Web Hosting Talk







View Full Version : Foxpro to MySql


Vinayak_Sharma
08-22-2002, 04:00 PM
Hey I am a newbie with php, my problem is to transfer my foxpro data residing on my comp to MySql database residing on one of the host servers, and this is to be done regularly, as data is feeded every day on the foxpro package.

So can any one explain me how to do it, with some php residing on the web server, as my host won't allow remote connection to the MySql server (like using Myfrontend).

Thanks

anantatman
08-22-2002, 04:44 PM
create an XML webservice with php which takes a SQL statement, or CSV text on your host. .. You can also do this with a regular PHP script, look through phpmyadmin code to see how.

then on your end, you can have a windows service that exports data and uses HTTP to connect to the XML ws, or the php script.

Vinayak_Sharma
08-23-2002, 05:34 AM
I can't use XML, as I don't know it.

So is there an easy way out.

Lats
08-23-2002, 05:54 AM
Shouldn't be too hard :cool:

A quick search on google brought up this (http://ae.inc.ru/).


Lats...

anantatman
08-23-2002, 06:10 AM
google. the way you get **** done fast.