April 30th, 2013, 12:30 PM
Crashed mysql tables - data loss?
I have several tables that have crashed in my mysql database that is for a vbulletin forum. Apparently, there was a power outage at the hosts. The hosts say they can just run a repair on the tables.
The forum has over a million posts so its a pretty big file.
What is the risk of data loss?
April 30th, 2013, 09:50 PM
Normally you'll lose a couple rows when running a repair, but since the risk of data loss is 100% if you don't repair it's pretty worthwhile.
If it's an option, you might want to grab a backup of the data files before attempting the repair.