Troubleshooting MySQL table errors

Troubleshooting table errors

Table not found or file not found errors

Normally mysql database is kept in '/var/lib/mysql' folder. In this folder there is generally one directory for each database. Inside this directory based on table format 'Innodb' or 'MyISM' there are multiple files. If the file extensions are '.frm', '.ism' and '.isd' for each table then '.frm' should be lower case and '.ISM' amd '.ISD' should be in upper case

Error from table handler at row n

If you get error like 'Error from table handler at row n' then you can try from command line

mysqlcheck -r <database_name>

where <database_name> is the name of the database inside which some table is giving error

Access denied/Can't write

• Make sure the temporary directory mentioned in '/etc/my.cnf' exists, is writable and has free space.
• All files, folders and sub-folders inside '/var/lib/mysql' shown be owned by mysql:mysql

Back to Mysql configuration