On 6/27/06, Andreas Widerøe Andersen <[EMAIL PROTECTED]> wrote:
Hi,
I have a few FreeBSD servers running various web/database things and I'm
looking for a good a reliable backup script that I can run through a
cronjob. I'm currently running the latest version of mysql323, but will
upgrade to version 4.1 soon aswell as upgrade most of the servers to the
latest FreeBSD version.
Any good suggestions to a script that will back up my databases and make
things ready for an easy restore if I need to?
30 23 * * * date=`date -I` && /usr/bin/mysqldump --opt -B -C -h<host>
-<user> -p<password> <database> | bzip2 -c >
path/to/backup/$date-<database>.sql.bz2
I guess it will work on a FreeBSD, its my own cron job here...
--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
