Super Easy {Mac} DataBase Backups.. 
Author Message
 Super Easy {Mac} DataBase Backups..

Hi All,

I remeber a while back, that there was some discussion about backing
up filemaker databases.. while messing about yesterday, i used the
"finder" to duplicate a database i was working on.. then i noticed
that the database was open at the time.. very unlike the usual mac
behavior of not letting you copy or open a file if it is already in
use, the finder had absolutely no problem duplicating the database
while it was open..

so i made a little applescript to duplicate the database file..

Quick small and dirty.. but it works.. if you set the duplicate to
"replace" the existing copy, the existing copy will get moved to the
trash, so you will have the new copy in the "backup" folder, and any
previous copies will end up in the trash..

i don't know what this will do if someone is writing a record at the
exact time the duplicate occurs, but i can't imagine any "faster" way
to backup the database than a simple copy.. i only have fmp4 on one
mac, so i can't tell if it will work when the database is shared over
an appletalk network.. it does seem to work if the database is set to
be shared with the webcompanion..

the little applescript i came up with looks like so..

tell application "Finder"
activate
select file "Items" of folder "Sur-Tech"
duplicate selection to folder "Backup" of disk "Boot" with replacing
end tell

you could just replace the file names and locations for ones that will
work on your system..


Sur-Tech / Ami-Tech    (408) 496-6348 Xt 247     Santa Clara CA 95050
                          www.Sur-Tech.com



Sat, 20 Jan 2001 03:00:00 GMT
 Super Easy {Mac} DataBase Backups..

Quote:

> Hi All,

> I remeber a while back, that there was some discussion about backing
> up filemaker databases.. while messing about yesterday, i used the
> "finder" to duplicate a database i was working on.. then i noticed
> that the database was open at the time.. very unlike the usual mac
> behavior of not letting you copy or open a file if it is already in
> use, the finder had absolutely no problem duplicating the database
> while it was open..

Hi there,

The fact that the Finder did what you asked it to do is all the more
worrying because this will leave you with a possibly corrupted backup
copy. When you copy an open file and then open the copy, you will notice
the standard "Not closed properly" dialog. Although the repair cycle
usually works, it may not.

CvM
-----------------------------------------------------------------------
                      INDEX International Booksellers
    PO Box 1310, NL-2302 BH / Lammenschansweg 111, 2313 DL LEIDEN
                           THE NETHERLANDS


-----------------------------------------------------------------------


-----------------------------------------------------------------------



Sun, 21 Jan 2001 03:00:00 GMT
 Super Easy {Mac} DataBase Backups..
FileMaker Server has backup options and can be automated.

Consider using scripts to create a duplicate file rather than using the
finder. You can use one master file to cause other files to duplicate
themselves.



Tue, 23 Jan 2001 03:00:00 GMT
 Super Easy {Mac} DataBase Backups..
christian,

You truly should NOT backup an open FMPro file. It'll eventually turn up
damaged. Maybe not today, maybe not tomorrow, but soon - and for the rest
of your life.

The best backup solution probably involves FMPro Server. It allows you to
schedule file backups to be done anytime, day or night. It first
disconnects all users of the specified database, then creates a copy in a
specified backup folder. I've been using it for 1.5 years without a
hitch.

Of course, if you have multiple users accessing your files, FMPro Server
offers great speed and stability advantages, too.

Quote:

> Hi All,

> I remeber a while back, that there was some discussion about backing
> up filemaker databases.. while messing about yesterday, i used the
> "finder" to duplicate a database i was working on.. then i noticed
> that the database was open at the time.. very unlike the usual mac
> behavior of not letting you copy or open a file if it is already in
> use, the finder had absolutely no problem duplicating the database
> while it was open..

> so i made a little applescript to duplicate the database file..

<snip>
--
==========================================================
Michael Little

NOTE: Remove 'PAR3' from my address when replying
==========================================================
I'm a 20th century man, but I don't want to be here -- RD Davies


Thu, 25 Jan 2001 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Super easy ? for you gurus

2. Super Mac Training?

3. Easiest database program for easy calculations?

4. Database backup / database File Backup

5. Updating Ofa super shared database directly

6. 2 Easy SQL2000 Backup Questions

7. easy Backup/Restore question

8. How come SQL server does easy Hot backups?

9. Easiest Oracle Backup and Recovery Tool (Unix)

10. EBU and Backup Catalog - EASY QUESTION!!

11. Easiest Oracle Backup and Recovery Tool (Unix)

12. Easy way to backup...?


 
Powered by phpBB® Forum Software