How to upload data to MySql databse (phpMyAdmin, Yahoo store host)
Posted on 2004-10-08
How do I upload data to my MySql database? Using phpMyAdmin, I see how to do a dump (getting data out) but not how to get data in.
I've tried using the feature "insert data from a textfile into a table", which allows me to browse to a local file, but the filename arrives blank into the SQL-query and I get the following statement, with an error:
LOAD DATA LOCAL INFILE '' INTO TABLE `Customer` FIELDS TERMINATED BY ';' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'
File '' not found (Errcode: 2)
I have MySQL installed locally. Can I maintain my databases from here?
My goal is to sync our local customer and product info with my on-line tables.