Jump to content


Photo

Automate Data Import


  • Please log in to reply
No replies to this topic

#1 goosehunter

goosehunter
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 01 April 2006 - 05:22 AM

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?




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users