| Subject | RE: [firebird-support] Firebird automatic nightly backup |
|---|---|
| Author | Werner Cloete |
| Post date | 2004-06-18T10:34:22Z |
Hi everyone... :o)
How would you run nightly backups on a Windows machine..?
One option I considered is creating a batch file and setting Windows
up, through a schedule, to run the batch file every night...
Will that work...or is there a better alternative..?
-----Original Message-----
From: Jaume Sabater [mailto:jsabater@...]
Sent: 18 June 2004 11:36
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Firebird automatic nightly backup
Raigo wrote:
Just in case your servers run Linux, try with a job in the cron calling
a script similar to this:
#!/bin/bash
GBAK=/usr/bin/gbak
# Database
SRC_DB=/var/lib/firebird/data/database.fdb
BAK_DB=/var/lib/firebird/backup/database.fdb.gbak
${GBAK} -B -T -PAS masterkey -USER SYSDBA ${SRC_DB} ${BAK_DB}
if [ -e ${BAK_DB} ]
then
bzip2 -f ${BAK_DB}
fi
This script is for GNU/Debian Linux Firebird packages. Customize it to
your needs.
Only, and I mean _only_, firebird user should have access to this file.
Or root if you prefer (depending on where to set the cron job). Anyway,
be careful about security, as it contains the SYSDBA password.
--
Jaume Sabater
http://linuxsilo.net
"Ubi sapientas ibi libertas"
Yahoo! Groups Links
This e-mail message is confidential and intended solely for the person to whom or the entity to which it is addressed. All the contents and any attachments remain the property of VR Services (Pty) Ltd unless so stated by contract.
If you are not the intended recipient, you are prohibited from reading, copying, using or disclosing this message to others.
If you received this message in error, please notify the sender immediately by replying to this e-mail or by telephoning +27 21 430 9300 and thereafter delete the message. VR Services (Pty) Ltd does not accept liability for any personal views expressed in this message.
How would you run nightly backups on a Windows machine..?
One option I considered is creating a batch file and setting Windows
up, through a schedule, to run the batch file every night...
Will that work...or is there a better alternative..?
-----Original Message-----
From: Jaume Sabater [mailto:jsabater@...]
Sent: 18 June 2004 11:36
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Firebird automatic nightly backup
Raigo wrote:
> How to create Firebird 1 automatic nightly backups ?should
>
> The system should do a backup every night and there should be some way
> to know when certain backup was made (for example .gbk file name
> have date in it somehow like 18_06_2004.gbk).I see you are sending your emails from Mozilla on a Windows machine.
Just in case your servers run Linux, try with a job in the cron calling
a script similar to this:
#!/bin/bash
GBAK=/usr/bin/gbak
# Database
SRC_DB=/var/lib/firebird/data/database.fdb
BAK_DB=/var/lib/firebird/backup/database.fdb.gbak
${GBAK} -B -T -PAS masterkey -USER SYSDBA ${SRC_DB} ${BAK_DB}
if [ -e ${BAK_DB} ]
then
bzip2 -f ${BAK_DB}
fi
This script is for GNU/Debian Linux Firebird packages. Customize it to
your needs.
Only, and I mean _only_, firebird user should have access to this file.
Or root if you prefer (depending on where to set the cron job). Anyway,
be careful about security, as it contains the SYSDBA password.
--
Jaume Sabater
http://linuxsilo.net
"Ubi sapientas ibi libertas"
Yahoo! Groups Links
This e-mail message is confidential and intended solely for the person to whom or the entity to which it is addressed. All the contents and any attachments remain the property of VR Services (Pty) Ltd unless so stated by contract.
If you are not the intended recipient, you are prohibited from reading, copying, using or disclosing this message to others.
If you received this message in error, please notify the sender immediately by replying to this e-mail or by telephoning +27 21 430 9300 and thereafter delete the message. VR Services (Pty) Ltd does not accept liability for any personal views expressed in this message.