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
