I use a perl method for a full week's worth of backups, this could be
migrated to have a weekly, monthly, yearly snapshot as well.
#!/usr/bin/perl
my $szToday = `date +%a`;
chop ($szToday);
$dbDumpName = '/var/backup/dbDump.mysql';
$backupFile = '/var/backup/siteFiles';
$siteDir = '/home/dir/of/other/files';
system ("rm -f $dbDumpName\-$szToday.gz");
system ("/usr/local/bin/mysqldump -u fsbo fsbo >
$dbDumpName\-$szToday");
system ("gzip $dbDumpName\-$szToday");
system ("rm -f $backupFile\-$szToday.tgz");
system ("tar cfz $backupFile\-$szToday.tgz $siteDir");
-----Original Message-----
From: Gerald R. Jensen [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 15, 2002 9:49 PM
To: Chetan Lavti; [EMAIL PROTECTED]
Subject: Re: Script for Data base backup and recovery : Very essential
This has been covered here a number of times before ... a search of the
archive avoids the need to repeat the same info.
That being said ...
We use a cronjob (root) that calls a shell script at 3am daily.
The line in the cronjob is:
* 3 * * * /usr/local/bin/dbbakup.sh username password
The shell script:
#################################################################
#!/bin/sh
# $1 = Unix/MySQL Username
# $2 = Unix/MySQL Password
if [ ! -e /dbbakup ]
then
mkdir /dbbakup
fi
mysqldump -u$1 -p$2 -c --add-drop-table --add-locks --flush-logs
--databases
account>/dbbakup/account.sql
mysqldump -u$1 -p$2 -c --add-drop-table --add-locks --flush-logs
--databases
payroll>/dbbakup/payroll.sql
mysqldump -u$1 -p$2 -c --add-drop-table --add-locks --flush-logs
--databases
contact>/dbbakup/contact.sql
#################################################################
If you wanted to ftp the resulting scripts to another server, you could
add
code to the shell script to run ncftpput, etc.
Gerald Jensen
----- Original Message -----
From: "Chetan Lavti" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 12, 2002 11:16 PM
Subject: Script for Data base backup and recovery : Very essential
hi,
Can anybody tell me how can I write script for MySQL backup and
recovery.( i am newbie as per script is cencern)
I am using Innodb table type and using all the default parameters
specified in the my.cnf file (my-large.cnf)
Looking for kind response..
Thanks and regards,
Chetan Lavti
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
