Re: Conversion between FoxPro .DBF and MySql Database

[Laurentiu Stancalie]

Hello,

The surest way to convert the .dbf tables to mysql tables is to write your own program in FoxPro to convert each table into a text file like:

CREATE TABLE <tb_name> (<field_list>);

INSERT INTO <tb_name> (<field_list) VALUES (<field_values1>);
INSERT INTO <tb_name> (<field_list) VALUES (<field_values2>);
...
INSERT INTO <tb_name> (<field_list) VALUES (<field_valuesN>);

It is not very hard to do, just take care of the field types (string types must be surrounde by ""). Then you can execute the resulting file as batch job in mysql.

Success !
Laurentiu