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
5359
February 27, 2005 08:16AM
3301
August 28, 2005 11:46PM
3326
August 28, 2005 11:56PM
Re: create a backup script of my DB
3300
August 29, 2005 09:37AM
3077
October 06, 2005 08:27PM
3129
October 09, 2005 07:25PM
2922
December 30, 2005 06:39AM
3836
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.