Hi,
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
