I use R:Compiler and compile it. I run it on the server using windows scheduler.
The built-in concurrency will take care of the changing data issue. It will wait for the write to complete before unloading it. Dan -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Sinclair Sent: Tuesday, June 17, 2008 1:14 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Hourly Backups 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 >
