how to restore...?

Aspen · #1 08-10-2006, 07:15 AM

hello
I Explored my MySQL database (4.0.24-standard) from iPowerweb hosting site.
I want to restore it to my MySQL (mysql-4.1.13a-win32.zip) on my home server. When I loged on with MySQL Administrator, went to Restore, Opened .sql file, hit Start Restore, it gets stuck at 9598 number of bytes each time.
Thanks for any help!! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

sierra · #2 08-10-2006, 07:28 AM

try to restore your SQL file via MySQL Auto Backup.

MySQL Auto Backup

Professional MySQL Backup Automation Software on Windows -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

pumice · #3 08-10-2006, 07:46 AM

i think there should be an option to dump the db, you should make a xml dump or zipped one from PHPmyadmin

otherwise, you can use navicat, its one of the best tools. it has 30 day trial, so you can easily do your job -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

pumice · #4 08-10-2006, 07:51 AM

Quote:

Originally Posted by sierra

try to restore your SQL file via MySQL Auto Backup.

MySQL Auto Backup

Professional MySQL Backup Automation Software on Windows

this is also an option, i would still prefer navitcat for being simple and easy to use -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --