Well I use mySQL on my Mac for all my other database work. This particular database is natively produced in FoxPro as that is what our Company uses. My website offers some of our clients this data (stored in FoxPro DBF's) using PHP which is running on an Apache Web Server on Mac OS X.

I am looking into the option of importing the DBF records in my mySQL Server on my Mac. The one issue that's coming to my mind is ... the DBF is updated daily. An "End-Of-Day" program run at night updates the FoxPro DBF. I can write a program in PHP to import the DBF Records --> mySQL ... however, I'm going to need to somehow Automate this procedure so that it runs automatically every nigh (or early morning) ... and also such that only NEWER records are imported from the DBF --> mySQL.

Sounds a bit rough ... but seems to be a plausible solution.

On Nov 24, 2009, at 12:46 PM, Olav wrote:

Rahul S. Johari wrote:

Quite right.

Unfortunately there doesn't seem to be any available ODBC Drivers for
FoxPro available for Mac OS X either!! I'm hitting a brick wall no
matter what direction I take.

Convert to SQLite and don't look back ;)

Unless your DBF files are still in use in another application of course.
If that use is not simultaneous you could at least trivially write an
import/export routine.

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Rahul Sitaram Johari
Founder, Internet Architects Group, Inc.

[Email] sleepwal...@rahulsjohari.com
[Web]   http://www.rahulsjohari.com

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to