On Tue, 2009-11-24 at 12:59 -0500, Rahul S. Johari wrote: > 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] sleepwalker@xxxxxxxxxxxxxxxx > [Web] http://www.rahulsjohari.com > > > > > What about triggering an update of a MySQL database at the same time and in the same way on the same server as the FoxPro one? Then you can just copy the directory related to that particular MySQL database when the job has completed and you'll have a full backup. Thanks, Ash http://www.ashleysheridan.co.uk
