Solved

Cold Backup of Visual FoxPro 7

Posted on 2009-03-31
3
456 Views
Last Modified: 2012-05-06
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.

0
Comment
Question by:atsci
3 Comments
 
LVL 42

Accepted Solution

by:
pcelba earned 125 total points
ID: 24033903
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
 
LVL 29

Assisted Solution

by:Olaf Doschke
Olaf Doschke earned 125 total points
ID: 24043522
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
 
LVL 6

Expert Comment

by:BALMUKUND KESHAV
ID: 24128216
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

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Server 2005 - Linked FoxPro 8 617
import foxpro DBF into Access or msSQL 7 3,726
Translate dll vb.net code to VFP 9 10 722
Overlay data type 17 100
Microsoft Visual FoxPro (short VFP) is a programming language with it’s own IDE and database, ranking somewhat between Access and VB.NET + SQL Server (Express). Product Description: http://msdn.microsoft.com/en-us/vfoxpro/default.aspx (http://msd…
Read about why it is more lucrative for an IT company to participate in government projects.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question