This section describes the different kinds of backups that MySQL Enterprise Backup can
create and the techniques for producing them, with examples showing
the relevant syntax for the mysqlbackup command.
It also includes a full syntax reference for the
mysqlbackup command.
Try using the "--extended-insert" option with mysqldump. This will create an INSERT statement that groups the VALUES together, which will increase the speed of re-inserting the data into the database by a vast amount.
Here is an example of a line from a file created by the command, "mysqldump --user=me -p --extended-insert my_db > c:\db.sql"
i.e. INSERT INTO some_table VALUES (610,8197325,'2006-10-11 05:51:37'),(1220,2001647,'2007-08-07 15:01:28'),(6713,8470458,'2000-05-06 01:34:23');
© 2013, Oracle Corporation and/or its affiliates
User Comments
For backing up InnoDB tables, I'd suggest having a look at mysqldump along with the --single-transaction option.
Try using the "--extended-insert" option with mysqldump. This will create an INSERT statement that groups the VALUES together, which will increase the speed of re-inserting the data into the database by a vast amount.
Here is an example of a line from a file created by the command, "mysqldump --user=me -p --extended-insert my_db > c:\db.sql"
i.e. INSERT INTO some_table VALUES (610,8197325,'2006-10-11 05:51:37'),(1220,2001647,'2007-08-07 15:01:28'),(6713,8470458,'2000-05-06 01:34:23');
Add your own comment.