Hello mysql, Resently MYSQL have introduced transaction support, which at least in INNODB allows to make consistent backup/recovery. The bad thing about this is - MYSQLDUMP does not support anything about this, so I had to done the same things buy hands. The Idea is quite simple - to add transaction start in the begin of backup and in the begining of recovery. This would take a consistent backup of all of the tables, and as well will allow consistent recovery, at least if not using drop table. -- Best regards, Peter mailto:[EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php