BackupPC-users

Re: [BackupPC-users] MySQL dump backup example scripts request

2009-07-07 02:52:53
Subject: Re: [BackupPC-users] MySQL dump backup example scripts request
From: Boltris Alexandr <ua2fgb AT gmail DOT com>
To: backuppc-users AT lists.sourceforge DOT net
Date: Tue, 07 Jul 2009 09:46:30 +0300
Admiral Beotch пишет:
> I use a cron job that backups my databases on a daily/weekly basis and 
> then depend on backuppc to grab those static files - the backup of mysql 
> is not dependant on the DumpPreUserCmd in backuppc. The command I have 
> cron'd is:
> 
> mysqldump --opt --all-databases -u root | gzip -9 > 
> /backups/mySQL-AllDB.sql.gz
> 
> 
> 
I think, that is bad idea to run mysqldump and pipe its to gzip. because 
mysql stay locked while gzip working


------------------------------------------------------------------------------
Enter the BlackBerry Developer Challenge  
This is your chance to win up to $100,000 in prizes! For a limited time, 
vendors submitting new applications to BlackBerry App World(TM) will have 
the opportunity to enter the BlackBerry Developer Challenge. See full prize 
details at: http://p.sf.net/sfu/blackberry
_______________________________________________
BackupPC-users mailing list
BackupPC-users AT lists.sourceforge DOT net
List:    https://lists.sourceforge.net/lists/listinfo/backuppc-users
Wiki:    http://backuppc.wiki.sourceforge.net
Project: http://backuppc.sourceforge.net/