MySQL Forums
Forum List  »  Backup

Re: Problem with Automatic Backup
Posted by: Jeff Diluzio
Date: January 20, 2005 02:32PM

I now create backups but I do not use mysql-administrator. I have created a simple backup script file that the cron calles daily.

Thanks,
Jeff Diluzio
____________________________________________
This is the script I use:

#!/bin/bash

date=$(date +%F)
time=$(date +%T)

## dump mysql database ##
mysqldump -l --add-drop-table --user=username --password=secret dbname > /data/Mysql_Backup${date}-${time}.sql

Options: ReplyQuote


Subject
Views
Written By
Posted
5295
January 11, 2005 08:31AM
3310
January 11, 2005 03:25PM
3285
January 14, 2005 10:01AM
3206
January 14, 2005 02:41PM
Re: Problem with Automatic Backup
4463
January 20, 2005 02:32PM
3290
M K
May 04, 2005 08:03AM
3738
February 28, 2005 03:12PM


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.