I'm on a Cpanel based account and have had success using their DB backup AND restore features. I've tried using automated scripts, and they seem to backup everything just fine, but then I'm left with a file I'm not able to restore (Iím VERY new at MySQL and donít even really know the basics.)
"MySQL database backup" sounded too good to be true, "Automated, daily/weekly/monthly, files kept for a specific amount of time, email notification with compressed files, etc. etc. etc."
I downloaded and configured the script (about 20 mins for a newbie like me) and ran it. It seemed to work beautifully.
I backed everything up in Cpanel, deleted the DB and restored the file using the command below.... it worked like a CHARM!
mysql -u username -pPassword database_name < path/db.sql
Excellent script! I'd like to see the programmer to add:
1) An automated GUI installation application.
2) An easy to use GUI restore application / script.