unable to start mysql services

Gflames · 08-13-2013, 05:04 PM

I lost power while accessing mysql services,after rebooting I can not restart the service.The error in the mysqld.log file; FATAL error;cant open and lock privilege tables:incorrect file format 'host'.
thanks for the help in advance

Ser Olmy · 08-13-2013, 05:54 PM

This is not really a "newbie" question, and the thread would probably be more at home in the "Linux - Server" forum.

If you type the exact error message into Google, you'll find that the fix involves backing up your database files, clearing out the entire database directory and running mysql_install_db to regenerate the missing/corrupt system database. You can then copy your database files back.

You'll have to add back all user privileges manually, but they're gone now anyway.

Kustom42 · 08-13-2013, 05:57 PM

Did you try a quick google search?

There are a few ways to fix this. You can do the mysql_install_db to reinstall the hosts or you can start mysqld with skip grant and try a repair on the table, which will more than likely delete all the users in it and you will just need to add them back in.

http://forums.mysql.com/read.php?34,164324
http://wiki.unixh4cks.com/index.php/...mat_%27host%27