Re: Corruptions like crazy

[John Bowles]

I just thought I should mention, I was reading about doing incremental backups of mysql and I set up the my.cnf file with the following two lines added.

log-bin=/tmp/mysql-bin #jwb: I inserted this line
binlog-do-db=MyDatabaseName #jwb: I inserted this line

and I run this command daily.

mysqldump -u root -pMyRootPassword --flush-logs --delete-master-logs --master-data=2 MyDatebaseName > /tmp/MJN_backup.sql

It seems to work. However when I first read about it the documentation said to start mysql in safe mode. I had problems with this (can't remember what) so I just started it as normal and everything seemed fine. I am wondering if running the mysql daemond as normal with the above two additions to the my.cnf file could create this problem.