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@xxxxxxxxxxxxx - jabber: davee@xxxxxxxxxx
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

Relevant Pages

  • running backup
    ... The script is as follows: ... # script to automate the backup of the Ruby server to the W2K3 server ...
    (Debian-User)
  • Re: NTBackup basic training
    ... >I want to back up the C and F drives on a W2K3 server on a daily basis to a file share on another server. ... I have a full backup and now I want to catch any changes. ... Use the backup Wizard to select and schedule the backup. ...
    (microsoft.public.win2000.cmdprompt.admin)
  • Re: OT backup mysql databases
    ... Subject: OT backup mysql databases ... >> I have a few small mysql databases on my system. ... >> every week with a cpio backup to tape. ...
    (Fedora)
  • Re: Undelete Software.
    ... I use a little program free delete. ... I have used it on my w2k3 server to do ... Although we can restore these from backup is there any ...
    (microsoft.public.windows.server.general)
  • Re: OT backup mysql databases
    ... > I have a few small mysql databases on my system. ... > every week with a cpio backup to tape. ... about in the mysql documentation including mysqldump and mysqlhotcopy. ...
    (Fedora)