I've got a backup that is scheduled by MySQL Administrator, which appears to be happening without a problem. However, I just tried to restore that backup on my machine, and the data doesn't appear to be restoring properly. The original database was on our web server, where the backup occurs each night automatically. I've downloaded the backup to my machine, and tried to restore it using MySQL Administrator, and it goes through the motions, but the data has not been changed in my database here. What could I be doing wrong here?
Thanks, Jesse