MySQL Forums
Forum List  »  Backup

Backup script
Posted by: Patrick Daly
Date: March 27, 2008 07:52AM

I a newbie to MySql and I was searching for a windows script to backup my database nightly. I have bin-log enabled.

Here's what I'd like to happen.
Every night at 12 I like a full backup and flush the bin-logs.
Every 1 hour during the day I'd like the bin-logs to be flushed(backed up) to another directory.
The script should manage deleting old backup files/logs older than 2days old.

I've found alot of scripts/commands to backup the database but none that manage bin-log backups and purging.

The database is quite small in size > 100MB. Any pointers please?

Options: ReplyQuote


Subject
Views
Written By
Posted
Backup script
4391
March 27, 2008 07:52AM


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.