MySQL Forums
Forum List  »  Backup

Re: create a backup script of my DB
Posted by: Chis Florinel
Date: August 29, 2005 09:37AM

put the following code in a script and schedule it in cron to run daily:



#!/bin/sh
date=`date -I`
/usr/bin/mysqldump --user root --password=your_password dbName | gzip > /path/to/backup_folder/dbName$date.gz

Options: ReplyQuote


Subject
Views
Written By
Posted
5567
February 27, 2005 08:16AM
3403
August 28, 2005 11:46PM
3461
August 28, 2005 11:56PM
Re: create a backup script of my DB
3395
August 29, 2005 09:37AM
3188
October 06, 2005 08:27PM
3230
October 09, 2005 07:25PM
3010
December 30, 2005 06:39AM
3964
March 03, 2006 03:15AM


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.