Why is my database corrupt?
Did Textpattern corrupt my database?
I have a corrupt database table, how do I fix it?
It’s possible for Textpattern’s database to become corrupted. There are several possible causes:
- A server crash
- Server hardware failure
- A MySQL bug
It should not be possible for a user application like Textpattern to damage a MySQL table. (It might be possible for Textpattern to trigger a bug in MySQL, but the fault in that case lies with MySQL).
Occasional database corruption is a risk on shared hosting services, but should be rare. If you’re experiencing frequent corruption problems you should talk to your hosting company, and consider moving to a more reliable service.
In most cases a corrupt table can be repaired easily with little or no permanent damage. Many hosting companies and web hosting control panels provide a quick method of checking and repairing MySQL tables, so check their knowledge base and documentation.
There is also a Textpattern plugin which can allow you to repair tables in your Textpattern database.
In severe cases a corrupt table can cause data loss. You’ll need to restore a backup if this is the case.