Binary Backup of innodb
Hi,
We have developed an hot backup utility for innodb ( in shell script). The theme is to run 2 instance of mysql in master and slave mode. Backup is taken from the Slave DB. While taking backup the slave DB is asked to synchronise with the master DB. then the replication is stopped and a snapshot of the slave DB is taken. The code is something like this
$MYSQL_DIR/mysql -u$USER -p$PASSWD -S SOCK_FILE << END
flush tables with read lock ;
\!{ cd $DB2_DIR ; tar -czvf $BACKUP_DIR/data.tgz . ;} 2>&1 >> $LOGFILE
flush logs ;
unlock tables ;
END
But when we restore from the backup. The database fails to startup, giving assertion failure.
We are using mysql version 4.0.17 on linux kernal 2.4.
Can anybody give a clue or workaround of the problem.
Subject
Views
Written By
Posted
Binary Backup of innodb
5804
January 17, 2006 12:49AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.