0 Members and 1 Guest are viewing this topic.
[root@pohon mysql]# sh /script/fix-all; sh /script/restart-all- For help, type '/script/fixdns --help'- No argument supplied. Defaulting to localhost (master) serversCould not open database connection.- For help, type '/script/fixphp --help'- No argument supplied. Defaulting to localhost (master) serversCould not open database connection.- For help, type '/script/fixweb --help'- No argument supplied. Defaulting to localhost (master) serversCould not open database connection.Initialize PureFtp service- Initialize process- Restart xinetd service for pureftpChange qmail.init--------------------------Set '/home/vpopmail/bin/vchkpw' for root:root ownershipSet '/home/vpopmail/bin/vchkpw' for 4751 permissions--------------------------Set '/var/qmail/control/locals' with 'localhost' only--------------------------Using qmail-toaster - fix '/home/vpopmail/etc/vpopmail.mysql'ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)--------------------------Could not connect: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)--------------------------- For help, type '/script/fixmail --help'- No argument supplied. Defaulting to localhost (master) serversCould not open database connection.--------------------------Could not open database connection.Stopping kloxo:Waiting for the process to die.....Stopped kloxoStarting kloxo: 11Could not open database connection.Started kloxoStopping named: [ OK ]Starting named: [ OK ]Stopping httpd: [ OK ]Starting httpd: [ OK ]Restarting qmail:* Stopping qmail-smtpd.* Sending qmail-send SIGTERM and restarting.* Restarting qmail-smtpd.Stopping xinetd: [ OK ]Starting xinetd: [ OK ]Stopping mysqld: [ OK ]MySQL Daemon failed to start.Starting mysqld: [FAILED][root@pohon mysql]#
[root@pohon mysql]# service mysqld restartStopping mysqld: [ OK ]MySQL Daemon failed to start.Starting mysqld: [FAILED]
[root@pohon script]# yum list installed mysql* mariadb* MariaDB*Loaded plugins: fastestmirror, priorities, protectbase, replaceLoading mirror speeds from cached hostfile * base: mirrors.hostemo.com * extras: mirrors.hostemo.com * kloxo-mr-epel: download.fedoraproject.org * kloxo-mr-ius: ius.cu.be * updates: mirror.pregi.netExcluding Packages from Kloxo-MR - centalt - i386FinishedExcluding Packages from Kloxo-MR - IUS Community Packages for EL 5 - i386FinishedReducing Kloxo-MR - IUS Community Packages for EL 5 (special) - i386 to included packages onlyFinished0 packages excluded due to repository protectionsError: No matching Packages to list
log-bin=mysql-bin binlog_format=mixedjadinya akan seperti ini : # log-bin=mysql-bin# binlog_format=mixed
ibdata1ib_logfile0ib_logfile1
[root@pohon mysql]# service mysqld startMySQL Daemon failed to start.Starting mysqld: [FAILED]
/var/log/mysqld.logsama yang di /var/lib/mysql/xxxxx.err (kalo ada)
[root@pohon log]# vi mysqld.log130709 06:57:29 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql130709 6:57:29 [Note] Plugin 'FEDERATED' is disabled.130709 6:57:30 InnoDB: Initializing buffer pool, size = 16.0M130709 6:57:30 InnoDB: Completed initialization of buffer poolInnoDB: The first specified data file ./ibdata1 did not exist:InnoDB: a new database to be created!130709 6:57:30 InnoDB: Setting file ./ibdata1 size to 10 MBInnoDB: Database physically writes the file full: wait...130709 6:57:30 InnoDB: Log file ./ib_logfile0 did not exist: new to be createdInnoDB: Setting log file ./ib_logfile0 size to 5 MBInnoDB: Database physically writes the file full: wait...130709 6:57:30 InnoDB: Log file ./ib_logfile1 did not exist: new to be createdInnoDB: Setting log file ./ib_logfile1 size to 5 MBInnoDB: Database physically writes the file full: wait...InnoDB: Doublewrite buffer not found: creating newInnoDB: Doublewrite buffer createdInnoDB: Creating foreign key constraint system tablesInnoDB: Foreign key constraint system tables created130709 6:57:30 InnoDB: Started; log sequence number 0 0130709 6:57:30 [Warning] 'user' entry 'root@pohon.web.id' ignored in --skip-name-resolve mode.@"mysqld.log" 766L, 44136C
[root@pohon log]# tail mysqld.logInnoDB: Restoring possible half-written data pages from the doublewriteInnoDB: buffer...InnoDB: Doing recovery: scanned up to log sequence number 0 44233130711 14:22:28 InnoDB: Starting an apply batch of log records to the database...InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99InnoDB: Apply batch completed130711 14:22:28 InnoDB: Started; log sequence number 0 44233130711 14:22:28 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)130711 14:22:28 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)130711 14:22:28 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
[root@pohon log]# cd /var/lib/mysql[root@pohon mysql]# dir *.errdir: *.err: No such file or directory
can't find file: './mysql/host.frm
mysql_upgrade
[root@pohon /]# mysql_upgradeLooking for 'mysql' as: mysqlLooking for 'mysqlcheck' as: mysqlcheckRunning 'mysqlcheck with default connection argumentsmysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connectFATAL ERROR: Upgrade failed
[root@pohon /]# cd /var/lib/mysql[root@pohon mysql]# dir mysql.sockdir: mysql.sock: No such file or directory
Page created in 0.041 seconds with 17 queries.