Victoria Reznichenko wrote:
ColdFusion Lists <[EMAIL PROTECTED]> wrote:
we're using MySQL 4.0.12 with InnoDB... please do you have any scripts, comments,
suggestions, ideas, tutorials... about how to backup from that DB? It's possible to?
You can use mysqldump utility that comes with MySQL distribution:
http://dev.mysql.com/doc/mysql/en/mysqldump.html
There is also non-free InnoDB Hot Backup program:
http://www.innodb.com/order.php
Some info about backing up InnoDB database find at:
http://dev.mysql.com/doc/mysql/en/Backing_up.html
Also, as has been suggested on this list before, you can create a
replication slave of your database servr, and do the backups on that
slave. This requires extra disk space, and probably an extra box, but
it means you can try different backup schemes without putting much extra
starin on your main database server. Quite useful in high-load
production environments.
http://dev.mysql.com/doc/mysql/en/Replication.html
We are using this with a script that just stops the slave DB and makes a
copy of the data directory. It makes a rollback very fast.
Additionally, this second DB machine can be a hot backup for your main
DB machine, should something go wrong.
MySQL requires master servers to have log-bin enabled. You will have to
figure out how to get rid of the bin-logs from the master machine, or
else they will keep growing indefinately.
Jim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
