Jump to content

Archived

This topic is now archived and is closed to further replies.

goosehunter

Automate Data Import

Recommended Posts

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?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.