jon_lawrance — 2013-04-30T14:00:08-04:00 — #1
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?
felgall — 2013-04-30T18:03:28-04:00 — #2
Worst case would be if you end up deciding to restore from a backup - in which case you'd lose whatever changes were made after the backup was taken. Of course you will have taken that into account when you made your backup plan.
Assuming that the repair runs successfully you will probably only lose data that were actually being updated at the time of the crash and so would probably not need to use a backup.
webcosmo — 2013-05-01T17:15:13-04:00 — #3
Hopefully you do have a backup, in case the database repair fails - that could be possible. Let them do it an hope for the best, worst case you just run the backup and lose only the latest post, asssuming that the site works now somehow...
jon_lawrance — 2013-05-08T08:54:07-04:00 — #4