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.
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.
