Crashed table? No panic!

[cmadeira]

I recently had a table crash. All the data (400K of carefully picked up data like monument descriptions, timetables, addresses, phones and so on) vanished in the air.

Of course I should have made regular backups. Sometimes I do. Generally I make a routine to do it for me while I sleep. But I didn't this once.

I was advised to drop the crashed table and reload it again. However, I thought that could be a little too radical too start with.

So I went to mysql.com, Documentation, searched for crash.

One suggestion only: use REPAIR TABLE <tablename>

So I did. I wrote a small php script:

mysql_connect(your data)

$query="repair table monuments";
$res=mysql_query($query);
echo $res;

I ran the script and got an OK page.

At first I thought it was to quick, too easy, but then I went to see and yes, the table was there, in all its glory, there's probably a corrupt record somewhere, but I didn't find it yet.

Hope this helps someone...

[jason]

There's also a non-programming way to do this. (I hesitate to say "easier way" because there are more steps involved, but for a non-programmer, this would be easier.)

1. Log in to your CPanel
2. Click on phpMyAdmin
3. Select the database that contains the corrupt table
4. Click on the name of the table
5. Click on the "Operations" tab at the top of the page.
6. Click on "Repair table" under "Table maintenance."

--Jason

[Julian Muñoz]

Generally there is lost information after a table is repaired... When the thread table on my forum was corrupted, a thread on the forum disappeared... I noticed the missing thread because it was a very active thread on the moment, so I had to add the thread manually to the database to recover it.

The best advice to prevent this situation is to make regular backups of the database... You can even do it automatically on a daily basis. Search the forums and you will find answers