Difference between revisions of "Troubleshooting MySQL table errors"
From Notes_Wiki
m |
m |
||
| Line 1: | Line 1: | ||
<yambe:breadcrumb>Mysql configuration</yambe:breadcrumb> | |||
=Troubleshooting table errors= | =Troubleshooting table errors= | ||
| Line 22: | Line 23: | ||
<yambe:breadcrumb>Mysql configuration</yambe:breadcrumb> | |||
Revision as of 08:08, 2 December 2012
<yambe:breadcrumb>Mysql configuration</yambe:breadcrumb>
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
<yambe:breadcrumb>Mysql configuration</yambe:breadcrumb>
