Troubleshooting MySQL table errors

From Notes_Wiki
Revision as of 04:09, 7 November 2012 by Saurabh (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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