[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: running backup



On Wednesday, 31.05.2006 at 13:56 +0800, Jon  Miller wrote:

> #!/bin/sh
> # script to automate the backup of the Ruby server to the W2K3 server
> #
> DAY=`date +'%a-%d-%m-%y'`
> BACKUPDIR=/backup
> RUBYLIVE=/var/lib/mysql/
> 
> cd $RUBYLIVE
> tar -czvf /backup/rubylive${DAY}.tgz ./rubylive

(Not related to what you asked, but might be important)

Are you backing up MySQL databases here via there location in the
filesystem?  If so, this is 'unsafe', since any changes made to the
databases during your 'tar' will not be handled properly: this *could*
result in a partially- or completely-useless backup.

You should really backup MySQL databases using mysqldump instead.

If that's not what you're doing, apologies...

Dave.
-- 
Please don't CC me on list messages!
...
Dave Ewart - davee@sungate.co.uk - jabber: davee@jabber.org
All email from me is now digitally signed, key from http://www.sungate.co.uk/
Fingerprint: AEC5 9360 0A35 7F66 66E9 82E4 9E10 6769 CD28 DA92

Attachment: signature.asc
Description: Digital signature


Reply to: