MySQL Forums
Forum List  »  MySQL Administrator

mssql database backup & restore
Posted by: Maryam Keshai
Date: August 09, 2010 09:20AM


we have on our mailserver a mysql database. if I back up database with the command:

mysqldump-u root - password = mypassword - single-transaction database-name> /path/$DUMPNAME

The command takes about 1 hour and the secured database is 8 GB.

But if I want Restoring this database on the server, it takes 7 hours!

the command:
mysql-u root-p - password = mypassword </path/$DUMPNAME

can someone tell me why the database is backed up to an hour but recovery of the database takes 7 hours???

Best Regards,


Options: ReplyQuote

Written By
mssql database backup & restore
August 09, 2010 09:20AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.