Home / server / Questions / 183313
Accepted
Kirk Ouimet
Asked: 2010-09-22 11:57:23 +0800 CST

Recovering MySQL Databases from Total Failure

  • 772

MySQL was not starting. I backed up /var/lib/mysql/*. I uninstalled MySQL and reintalled it. It started again. I copied everything back to /var/lib/mysql. I restarted the service. I logged in and could see all of my tables. When I try to view their contents, I get:

Table 'tablename' doesn't exist

Is there something I need to do to make MySQL recognize the files I copied back into the /var/lib/mysql/ folder?

Any help is appreciated, I'm dying here.

mysql server-crashes

1 Answers

  1. Best Answer

    Check permissions, make sure ownership and permissions are correct on /var/lib/mysql. This is typically mysql. If this is not the issue, produce output of your .err log file.

    Try the following to correct permissions:

    chown -R mysql:mysql /var/lib/mysql
find /var/lib/mysql -type d -exec chmod 770 {} \;
find /var/lib/mysql -type f -exec chmod 660 {} \;

    The error log is located in the data directory, which appears to be /var/lib/mysql in your case. Verify in your cnf file.

    • 4