Good call!
I didnt notice this because I'm only backing up 60M of data, which took
about 90 seconds. A significantly larger database would have been killed
with this.
By separating the commands, everything completes within 30 seconds - and
that's even with an additional PGP command!
Thanks!
--
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
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Philip Tait wrote:
> I have done some searching, and have not been able to find a
> complete working example for properly backing up a MySQL database
> with BackupPC.
>
> If someone would be willing to share their working DumpPreUserCmd
> and DumpPostU
Check this thread:
http://www.backupcentral.com/phpBB2/two-way-mirrors-of-external-mailing-lists-3/backuppc-21/mysqldump-92269/
Ryan Manikowski | System Administrator
:703.677.8499:
[email protected]
2ergo – Digital leaders in a mobile world
Mobile Excellence Award - Best Innovator
M
On Mon, Jul 6, 2009 at 13:44, Philip Tait wrote:
> I have done some searching, and have not been able to find a complete
> working example for properly backing up a MySQL database with BackupPC.
>
> If someone would be willing to share their working DumpPreUserCmd and
> DumpPostUserCmd setup for
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
