Re: HOTBACKUP

2004-02-13 Thread Heikki Tuuri
Arnoldus, you should add log-bin to the [mysqld] section of my.cnf, so that mysqld writes the binlog. Please see the MySQL online manual about this option. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup

Re: HOTBACKUP

2004-02-12 Thread Ware Adams
No, InnoDB hot backup only backs up the table data, not the definitions. You need to back those up separately. This is all explained here: http://www.innodb.com/manual.php#Backing_up_myisam_and_innodb There's also a perl script that can help you with the backup. Even though it says MyISAM, you