Re: Backup and No Extended inserts
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.
Subject
Written By
Posted
Re: Backup and No Extended inserts
July 16, 2009 04:36PM
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.