Subject Re: [firebird-support] Equivalent of GbakSchd for Linux (Scripts)
Author Daniel K. P. Rezende
Hello everyone...
Salim, if you allow I would like to make a little observation.
I don´t know if Tom saw but in crontab line you made reference to "DBACKUP.SH" and the file you posted is calling... "SBACKUP.SH".
By the way... its a very interesting scripts... Nice mention to fstab =)
Monday I will post mines...

PS: Yes, I am so boring...

Daniel K. P. Rezende
SMed - Sistemas Médicos LTDA.


----- Original Message -----
From: Salim Naufal
To: firebird-support@yahoogroups.com
Sent: Saturday, May 08, 2004 6:51 AM
Subject: RE: [firebird-support] Equivalent of GbakSchd for Linux (Scripts)


Hi Tom,

This is the crontab for the backups: it will execute /backups/dbackup.sh
from Monday to Thursday and /backups/wbackup.sh on Fridays

dbServer1:/backups # crontab -l
# DO NOT EDIT THIS FILE - edit the master and reinstall.
# (/tmp/crontab.5730 installed on Mon May 3 17:45:52 2004)
# (Cron version -- $Id: crontab.c,v 2.13 1994/01/17 03:20:37 vixie Exp $)
50 16 * * 1-4 /backups/dbackup.sh
50 16 * * 5 /backups/wbackup.sh


Listing of the sbackup.sh:
------------------------------------------------------------------------
/opt/firebird/bin/gbak -b -T -user sysdba -password masterkey
/database/stock.fdb /backups/stock.fbk
gzip -9 /backups/stock.fbk

currDateCommand="date +%B%d%Y"
currDate=`$currDateCommand`
echo $currDate

mount /StocksBackups

mv /backups/stock.fbk.gz /StocksBackups/$currDate-Stock.fbk.gz
------------------------------------------------------------------------

listing of the wbackup.sh:
------------------------------------------------------------------------

/opt/firebird/bin/gbak -b -T -user sysdba -password masterkey
/database/stock.fdb /backups/stock.fbk
gzip -9 /backups/stock.fbk

currDateCommand="date +%B%d%Y"
currDate=`$currDateCommand`
echo $currDate

mount /StocksBackups

mv /backups/stock.fbk.gz /StocksBackups/$currDate-WeeklyStock.fbk.gz
------------------------------------------------------------------------

To mount the /StocksBackups directory which is on a MS Windows system, edit
the fstab and register the line below:

//192.168.0.123/Backupdir /StocksBackups smbfs
username=administrator,password=adminpwd 0 0

The 192.168.0.123 is the IP of the Windows PC, the Backupdir is the share
name on windows, /StocksBackups is the directory where the share is mounted
on linux, and the rest is user name and password to access the share.

I hope that this is what you are looking for

Salim




Yahoo! Groups Sponsor
ADVERTISEMENT





------------------------------------------------------------------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]