Cold Backup of Visual FoxPro 7

I am quite unfamiliar with FoxPro and I am just looking to create a simple nightly cold backup. I can do this with SQL Server and Oracle but shutting down the database, then copying the datafiles. I am not sure how to do this in FoxPro.

Every backup article I find online is related to a hot backup. While a hot backup would be ideal, it seems there are no clean cut solutions without a 3rd party utility. A cold backup would be fine as it's not a database that needs to be online constantly.

atsciAsked:
Who is Participating?
 
pcelbaCommented:
Cold backup of FoxPro database is very easy. FoxPro data are stored as files in standard file folders (extensions are .DBF, .CDX, .FPT, and many more). So if you know where these files are placed simply copy or zip them to your backup location. If you are not sure which folders contain application data simply copy all application folders including the programs. You have to ensure the data are not accessed during the backup otherwise the copy procedure could fail or backup incomplete data.

FoxPro has no native support for hot backup but it is possible to do it by program written in FoxPro language but the result is not 100% sure.
0
 
Olaf DoschkeSoftware DeveloperCommented:
Like pcelba says, it's as easy as it could be, you simply backup the files. you can even do that from inside your app, if you use the COPY FILE command, that also accepts wildcard characters like * and ?.

Copy File (lcDataDir+"*.*") TO (lcBackupDir+"*.*")

would be a start, when variables lcDataDir and lcBackupDir are set to the directories and as long as all database access is done (the database is 'cold'). This also works if files are open shared, but it will then of course not see anything in open transactions or in buffers.

Bye, Olaf.
0
 
BALMUKUND KESHAVCommented:
Create a Dos batch file mention the following dos command in batch file
copy <your data directory\*.*> your backup directory name

Call the batch file either using any app. or win' scheduler. Be sure during the period your fox app./dbf should not be used by any user other wise it will give error.

Regards,
Bm Keshav
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.