Repair Tables

• To repair a table from the command line, first stop the mysqld server.

• The repair process involves several stages.
  • Change location to the database directory and check the permissions of the table files.
  • Make sure the table files are readable by the user that mysqld runs as.
  • Run myisamchk -e *.MYI
    • Use the -s (silent) option to suppress unnecessary information.
    • If the mysqld server is stopped, use the --update-state option to tell myisamchk to mark the table as "checked".
  • If myisamchk announces an error, repair those tables.
    • First, try myisamchk -r -q tbl_name
      • This attempts to repair the index file without touching the data file.
    • If the mysqld server is stopped, use the --update-state option to tell myisamchk to mark the table as "checked".
    • Make a backup of the data file before continuing.
    • Run myisamchk -r tbl_name
      • This removes incorrect rows and deleted rows from the data file and reconstructs the index file.
    • If the preceding step fails, run myisamchk --safe-recover tbl_name

How do I optimize tables?

---

---

© 2007 John Michael Pierobon

Notes