linux - Can't start MySQL after ESXi reboot -


my mysql server stopped working after esxi server restart... not start automatically, , can't start unix shell.

~# service mysql restart restart: unknown instance:  ~# sudo service mysql start start: job failed start  ~# sudo -u mysql mysqld ~#  ~# netstat -tap | grep mysql ~# ~# service mysql restart restart: unknown instance: 

files @ /var/log/ : mysql.err , mysql.log empty. file here /var/log/mysql/error.log has info:

version: '5.1.62-0ubuntu0.11.10.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (ubuntu) 130410  9:50:54 [error] /usr/sbin/mysqld: table './radius/radcheck' marked crashed , should repaired 130410  9:50:54 [warning] checking table:   './radius/radcheck' 130410  9:50:54 [error] /usr/sbin/mysqld: table './radius/radpostauth' marked crashed , should repaired 130410  9:50:54 [warning] checking table:   './radius/radpostauth' 130410  9:50:54 [error] /usr/sbin/mysqld: table './radius/resv' marked crashed , should repaired 130410  9:50:54 [warning] checking table:   './radius/resv' 130819 22:31:21 [note] plugin 'federated' disabled. 130819 22:31:21  innodb: initializing buffer pool, size = 8.0m 130819 22:31:21  innodb: completed initialization of buffer pool innodb: log sequence number in ibdata files not match innodb: log sequence number in ib_logfiles! 130819 22:31:21  innodb: database not shut down normally! innodb: starting crash recovery. innodb: reading tablespace information .ibd files... innodb: restoring possible half-written data pages doublewrite innodb: buffer...     

could tell me, wrong here?

ugh... that's ugly.

here's fix. when uninstalling, copy list of packages removed, use list reinstall them afterwards.

http://www.blog.webcare.pk/2012/05/ubuntu-mysql-cannot-start-after-upgrade.html


Comments

  1. Step 1. Backup /var/lib/mysql to /var/lib/mysql.bak
    Step 2. Uninstall Mysql
    Step 3. Reinstall Mysql
    Step 4: Stop + remove: /var/lib/mysql
    Step 5: Restore backup: /var/lib/mysql.bak to /var/lib/mysql
    Stop 6: Start Mysql
    Done.

    ReplyDelete

Post a Comment

Popular posts from this blog

Detect support for Shoutcast ICY MP3 without navigator.userAgent in Firefox? -

web - SVG not rendering properly in Firefox -

java - JavaFX 2 slider labelFormatter not being used -