MySQL Forums
Forum List  »  MySQL Administrator

Re: Backup and No Extended inserts
Posted by: Barry Galbraith
Date: July 16, 2009 04:36PM

A,

To your question 1.
I know MS SQL Server doesn't do extended INSERTs. This means if you take a backup of MySQL with EXTENDED INSERTS, and try to load it in MS SQL Server, it won't load.
EXTENDED INSERTS is a MySQL thing.

To Question 2.
The backup file is smaller because the INSERT command is given once with about 2000 rows of data in my database.
Without EXTENDED INSERTS, then INSERT command is given for every row of data. This makes a smaller backup file.

When restoring a backup into a MySQL database, I find one taken with EXTENDED INSERTS is about 10 times faster to restore than one taken with single inserts.

I don't know the technicality of why it's more efficient, I just know that it is, for me.

Good Luck.

Barry.

Options: ReplyQuote


Subject
Written By
Posted
A B
July 14, 2009 07:44PM
Re: Backup and No Extended inserts
July 16, 2009 04:36PM
A B
July 16, 2009 10:14PM


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.