Dan,
What makes the program run every hour? How do you get it to start?
What happens if someone is changing data in a table when the program is
running?
Mike
James Bentley wrote:
Dan,
Interesting code. One observation. You delete the previous backup before the new one completes. What happens if current backup fails. You would have lost your previous backup.
Jim Bentley
American Celiac Society
[EMAIL PROTECTED]
tel: 1-504-737-3293
--- On Mon, 6/16/08, Dan Goldberg <[EMAIL PROTECTED]> wrote:
From: Dan Goldberg <[EMAIL PROTECTED]>
Subject: [RBASE-L] - RE: Hourly Backups
To: "RBASE-L Mailing List" <[email protected]>
Date: Monday, June 16, 2008, 2:58 PM
I run this file every hour on my server. I run it on the
server because it
only takes a couple of seconds to run vs. network traffic.
This places each table's data in its own file due to
the file sizes gets to
be rather large. I do not backup the structure hourly
because it does not
change. If I need to restore I pull the previous nights
backup and restore
the table's data that has changed for the day.
Connect dbname
SET VAR vtablename TEXT,vfilename TEXT
--delete previous backup
delete c:\backups\*.dat
--gets only the table data
DECLARE cursor1 CURSOR FOR SELECT sys_table_name FROM
sys_tables +
WHERE sys_table_type = 'table'
OPEN cursor1
FETCH cursor1 INTO vtablename INDICATOR vi1
WHILE SQLCODE <> 100 THEN
SET VAR vfilename = ('C:\BACKUPS\' +
.vtablename + '.dat')
OUTPUT &vfilename
UNLOAD DATA FOR &vtablename
OUTPUT SCREEN
FETCH cursor1 INTO vtablename INDICATOR vi1
ENDWHILE
DROP CURSOR cursor1
CLEAR VAR v%
exit
Dan Goldberg
________________________________
From: [email protected] [mailto:[EMAIL PROTECTED] On
Behalf Of Dan
Sent: Monday, June 16, 2008 12:18 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Hourly Backups
After loosing a day last week and having to revert to
yesterdays
data (only for a while thank God)
I was wondering if anyone has ideas on hourly backup
routines?
I ran an import which went awry, and R:base allowed itself
to grow past the
2 gig limit making the whole database unusable.
Is anyone using a backup procedure that would allow you to
be up to the
hour?
Thanks in advance.
Dan Champion
Service Department Manager
Vredevoogd Heating & Cooling
Grandville, MI. 49418
616-534-8271 x 14
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG.
Version: 8.0.100 / Virus Database: 270.3.0/1505 - Release Date: 6/16/2008 7:20 AM
