For what it’s worth, you probably should setup a cron job to backup the database.
I do daily backup with this:
mysqldump --opt -uUSER -pPASSWORD -h mysql.YOURHOST.com YOUR-DB > /home/YOURSHELL-USER/backup/mysql/DB.dump.
should be all one line. the
date +%A thing causes the day of the week to be tacked onto the end of the file like this: DB.dump.Monday
Using the ‘snapshot’ feature, I could go back right now to the dump from Nov 27th.
oh yeah, fill in the caps with your info.
Might not help now, but could help someone else down the line.