you can export the foxpro table to a text file and import to your mysql table. like this:
mysql> SET AUTOCOMMIT=1; # Used for quick re-create of the table mysql> DELETE FROM pet; mysql> LOAD DATA LOCAL INFILE "pet.txt" INTO TABLE pet FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n'; if there are many indexes, it's better to disable indexes, then enable them ALTER TABLE .. DISABLE KEYS ALTER TABLE .. ENABLE KEYS ----- Original Message ----- From: "Carlos Vazquez" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 29, 2003 3:29 PM Subject: Like MySQL Dump, but with FoxPro Tables Hi all! I want to create an application that transfers data from FoxPro (*.dbf) tables to MySQL. Does MySQL have a DUMP like or LOAD LIKE function that transfers this data in one step? I just don't want to loop into thousands of records to insert them one by one into my MySQL database. It makes my program too slow and very unlikely to use... Thanks in advance Carlos Antonio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
