Backing up Innodb
When backing up innodb, there seem to be limits to the single-transaction option noted in the doc, and warnings about using it concurrently with various SQL statements. Of course, it may not be possible to stop these statements while the dump is occurring on a live machine without stopping the server. And, the doc clearly notes it won't help with MyISAM tables anyway in the case of a database using both storage types.
So.... Would this work, or... not
Thread 1: flush tables with read lock
Thread 2: mysqldump --singletransaction ...
Thread 1: unlock tables
Wouldn't this enable the ability to get a backup of BOTH Innodb and MyISAM tables, without the limitations noted in the doc, and, still support correct backup of the MyISAM tables in the same db? Which is what I am needing to do.
Wouldn't this work in all cases?
Subject
Views
Written By
Posted
Backing up Innodb
3568
March 10, 2009 01:23AM
2100
May 20, 2009 08:27AM
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.