MySQL Forums
Forum List  »  MySQL Administrator

Re: mssql database backup & restore
Posted by: Claude Veigas
Date: September 03, 2010 09:41AM

Hi Maryam,
When a database is dumped a set of mysql statements are dumped to a text file.

When you restore this file, each statement has to go through the following process :
1. syntax of sql is checked
2. referential integrity, foreign keys, etc have to verified
3. indexes have to be created and updated
4. each sql statement has to be committed.

Hence a restore is always slower than a backup.


Claude Veigas

Options: ReplyQuote

Written By
Re: mssql database backup & restore
September 03, 2010 09:41AM

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.