>Hi
>
>I am have a website and I am building a database (mysql)
>
>Is it possible to connect via VFP to my remote database in my website ?
>
>I would like to import data from my remote database to my local dbf table, without have to deal with .txt files.
>
>Also make some modification in remote table data via VFP. (insert, delete record, etc.)

If you have a connectstring to your db, you can do pretty much anything that you have rights to. In the connect string the name of the server may be a bit longer than for a local one, or you can use the IP address instead of the name, and the operation will be a lot slower. And that's the whole difference - in any other respect you can do anything with that database that you can do with the one on your desktop or on the server in the next room. Again, assuming you have the rights.

To get the data, for each table issue a "select * from mytable" via a sqlexec() call, and you'll get the data in a local cursor. After that, it's up to you to do whatever you want with those data.

However, if you want to rebuild the database locally, do a full backup and pull that text file. It will contain a bunch of insert statements, that you only need to run and you'll have your data in a local MySql database, without any conversion into Fox cursors and back.