Difference between revisions of "Troubleshooting MySQL table errors"

From Notes_Wiki
(Created page with "=Troubleshooting table errors= ==Table not found or file not found errors== Normally mysql database is kept in '<tt>/var/lib/mysql</tt>' folder. In this folder there is gene...")
 
m
Line 20: Line 20:
*Make sure the temporary directory mentioned in '<tt>/etc/my.cnf</tt>' exists, is writable and has free space.
*Make sure the temporary directory mentioned in '<tt>/etc/my.cnf</tt>' exists, is writable and has free space.
*All files, folders and sub-folders inside '/var/lib/mysql' shown be owned by mysql:mysql
*All files, folders and sub-folders inside '/var/lib/mysql' shown be owned by mysql:mysql
Back to [[Mysql configuration]]

Revision as of 23:08, 17 November 2012

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