> load data from master never worked for innodb. And the suggested mysqldump command does not work for MyISAM.
Either way, the suggestion is a non-starter. I could "flush tables with read lock" and then do a mysqldump but again that would take hours and all the databases would be read-only during the whole operation, and even the read-only performance would be poor. I'd really prefer not to do that. I'll say again that the MySQL documentation specifically says that ZFS snapshots are a good way to make backups of MySQL databases. Is the documentation incorrect? Or perhaps does that also only work for MyISAM tables? If so, that ought to be called out more clearly in the documentation. -- Tim Gustafson t...@soe.ucsc.edu 831-459-5354 Baskin Engineering, Room 313A -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql