QUESTION:

Did Textpattern corrupt my database?
I have a corrupt database table, how do I fix it?



ANSWER:

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.

The MySQL manual has a section on checking and repairing tables. TextDrive customers will find phpMyAdmin table repair instructions in the knowledge base.

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.