MySQL Forums
Forum List  »  Backup

binary log file questions
Posted by: rps
Date: July 20, 2005 03:20PM

I am using MySQL 4.1.12 on linux.

Can the binary log file get corrupted? If it were to get copied off to another server while it's being written to, the copied version could be corrupt, yes?

So I should flush the logs, then copy over the closed binary file. Is there an easy way to tell which bin file is the one to copy? I'd like to automate this in a script.

What do you think of having the log file on another machine? I could map a drive using Samba or NFS, and then have the binary log file be written to there. Could it corrupt, say if the server lost power in the middle of writing to it?

What I would like to accomplish is to have a backup every night of all my databases, and then incremental backups every 5 minutes or so. I've been doing a lot of searching but have not come across a solution yet. I will be using MyISAM and Innodb tables so this futher complicates things (like being able to use mysqldump for the nightly backup).

Thanks for any help.
-Ryan

Options: ReplyQuote


Subject
Views
Written By
Posted
binary log file questions
3104
rps
July 20, 2005 03:20PM


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.