goosehunter Posted April 1, 2006 Share Posted April 1, 2006 I'm trying to automate transfering data from a non-SQL database to MySQL. The text file containing the data has the following format:TRUNCATE TABLE 'products';INSERT INTO 'products' VALUES (1,2,'Some Product',9.95);Using phpMyAdmin 2.6.0, the "Choose File" works nicely every time to import 7600 data records into MySQL 3.23.56.But file_get_contents() in a PHP script produces "SQL systax errors" with the same text file.Can someone suggest a PHP / SQL approach that will import cleanly? Link to comment https://forums.phpfreaks.com/topic/6318-automate-data-import/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.