> Furthermore, would it make more sense to have the data dump locally, > and then use a script to move the contents of the dump to a machine > on the network, perhaps even to a machine located on an alternate > network accessed via a second ethernet card?
This would be the simplest approach. That is what we are currently doing. Are you using InnoDB tables or MyISAM databases or both? If InnoDB, dump your data with the --single-transaction option. It should make the dump process run in a separate transaction, which will allow reads and write to continue to take place. If MyISAM, there are no real good options for getting a clean dump, other than to lock all the tables and block your users out during that time. You can use the --lock-tables option but it does not work as well as --single-transaction for InnoDB databases. If -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
