text: Database Migration: FoxPro to MySQL -
  Data types that do not match
  Set of characters that are different
  So, how can the problems above be addressed with several recommendations to migrate from FoxPro to MySQL? Simple! FoxPro tables also known as DBF files are exported as CSV (comma separated value) after which they are imported to MySQL. A common tool for conversion of DBF files is dbf2csv. For the next step of database migration MySQL provides 'LOAD DATA INFILE' statement that is capable of loading CSV file contents into previously created table:
  In a destination file, copy CSV files in a data folder. For security reasons, CSV file must be present in the data folder before data is loaded in MySQL.
  Post-processing processes are manual methods that are used because these two difficulties cannot be fixed by the said approach. Thus, script dbf2sql.php is important for the conversion of DBF files into SQL scripts. CSV file is an intermediate step that can be avoided by using this method. Also, the table can be built and filled with data in the process. But the drawbacks are: