Re: backing up database consisting of InnoDB and MyISAM tables

[Karen Owen]

I have been very happy with automysqlbackup.sh
It's an open source bash script that you modify for your environment. You can find it at: http://sourceforge.net/projects/automysqlbackup/

The script relies on mysqldump, which if you've got a combination of myISAM and InnoDB tables, will place a write lock on the Innodb tables serially as it backs up each table. It also takes care of cycling through daily, weekly and monthly backups and naming them appropriately. You may have to setup some env variables in .bashrc for it to run via a cron, but it's a sweet little script.

Of course, you can always buy a license to ibbackup, but the company who sells it, Innobase, is now owned by Oracle. Do you really want to give your money to Oracle?