George, the binlog is exactly you must have switched on and you must keep the binlog files. The binlog contains the SQL statements you run into your database, and by re-running it against your database backup you can recover from your backup to the present state. You need the binlogs in disaster recovery: broken disk, fire, etc. In 'normal' crashes (seg fault, OS crash, power outage) normally the regular InnoDB log files are enough and it will automatically recover to a consistent state. Then you do not need to recover from a backup with the binlogs. Regards, Heikki http://www.innodb.com Copied message: ................ The InnoDB manual reads: "...To be able to recover your InnoDB database (...), you have to run your MySQL database with the general logging and log archiving of MySQL switched on. Here by the general logging we mean the logging mechanism of the MySQL server which is independent of InnoDB logs." I admit, I am a litte disturbed. To shed a little light: which are the logging mechanisms I have to enable and howcan I do this ? I have binary logging enabled in my.cnf [at least I hope so using the entry "binlog"] - is that all I have to do ?Thanks for your help. George --------------------------------------------------------------------- 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
