Table Corruption and Recovery
The file format that MySQL uses to store data has
been extensively tested, but there are always circumstances that may cause
database tables to become corrupted such as:
- Your website was out of database space
- The
mysqld
process being killed in the middle of a write.
- Unexpected shutdown of the computer (for
example, if the computer is turned off).
- A hardware error.
- A software bug in the MySQL or MyISAM code etc
...
In case of table corruption you need to create a
support request with the following details:
- Database Name
- Table Names of the tables that are corrupted
- Your domain name
The support team will run an ISAM check on the
tables and try to recover the same. Data can be recovered in most circumstances.
In future versions of the ManageSite interface
you will be able to run ISAM checks yourself using the Database Manager.