MySQL Forums
Forum List  »  Backup

Re: Backup program for MySQL
Posted by: Adam McGreggor
Date: January 24, 2005 08:01PM

I tend to use mysqldump in a batch file redirecting to a file

mysqldump --opt > "path\to\backups\%date% - databasename.sql"

That can then be scheduled (either with AT, or the Task Scheduler on Win) and include the path\to\backups in your Backup Routine (if it's not already)

The %date% prefixes the filename with the date run ;)

HTH,
A

Options: ReplyQuote


Subject
Views
Written By
Posted
4534
January 03, 2005 10:39AM
3222
January 05, 2005 02:54AM
3384
January 07, 2005 04:25AM
2781
August 24, 2005 02:10PM
2999
September 07, 2005 09:24PM
3095
January 11, 2005 06:11PM
Re: Backup program for MySQL
2931
January 24, 2005 08:01PM


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.