MyISAM and InnoDB in same database
Hello,
I'm trying to get the correct mysqldump arguments set to do our backups. I have 5 databases total. 1 of these has both InnoDB tables and MyISAM tables. I'd like to be able to get a snapshot of the entire server at once. I was going to use --lock-all-tables but that option turns off --single-transaction.
Is there no way to do what I want? How can I get a snapshot of a database containing both InnoDB tables and MyISAM tables?
Thanks,
Matthew
Subject
Views
Written By
Posted
MyISAM and InnoDB in same database
5219
April 11, 2005 09:43PM
2945
April 18, 2005 08:21AM
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.