I have MySQL 4.0.12 working on Debian Linux box. DB server uses MYISAM and InnoDB tables. MySQL docs shows what is the best way to backup InnoDB tables but I don't want to shutdown db server every backup time.
I suppose it is not a good idea to just copy database files and innodb log files to the safe place because of unwanted rollbacks danger.
What if I use mysqldump to backup databases data, and then I copy innodb log files to the safe place? I suppose I should flush tables first.
I'm interested in your opinions. I'm sure that there is anybody more experienced in this matter.
Regards, -- Jarek
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
