>Thanks Christian!
>
>Already downloaded. Just a question: as far I could get in the internet, the database itsef is composed by the .FRM (table definition), .MYD (table data) and .MYI (table indices) files. Is that right?
>
>Also could see that there are many .IBD (???) files.
>
>If I leave just the files with those file extensions above in C:\ MySQLTest, will I have the database running and can access it with the mysql-connector-odbc-5.2.2-ansi-winx64.msi ?
>
>Regards,
>
>Fernando

There is a difference to VFP in the way how MySQL handles the tables in the database. For one, there are different types of tables (Engine type), the one I use most is InnoDB and MyIsam. Depending on the engine type, you have different file extensions. I never tried to understand the file structure of the tables in MySQL, but in most cases if you copy, remove or rename a file in the data folder it would give you serious errors in the database, and then it can get complicated.

If you just startup the MySQLD engine, (mysqllib\bin\mysqld -u root --port=50999 --datadir=c:\mysqltest\data --console), then you can connect to the database with the port that is specified, and the ip address of the computer (mostly "localhost"):

lnHndl = SQLSTRINGCONNECT("DRIVER={MySQL ODBC 5.1 Driver};UID=root;PWD=;server=localhost;port=50999")

and run the queries:

=SQLEXEC(lnHndl,"Use FHHCS")
=SQLEXEC(lnHndl,"Show Tables")
BROWSE