Solved

Cold Backup of Visual FoxPro 7

Posted on 2009-03-31
3
452 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 41

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

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…
A customer recently asked me about anti-malware and the different deployment options available for his business. Daily news about cyberattacks, zero-day vulnerabilities, and companies that suffered a security breach made him wonder if the endpoint a…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.

919 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now