News for hackers. Stuff that matters.

A comment on How to migrate Flat Text File into MySQL?. Parent comment

Re:How to migrate Flat Text File into MySQL? by zeroxsys on Saturday July 23, 2011 @10:09AM (#2796941)
I don't have a shell access to my client's shared server, so I can't do it using perl/bash. Yes, I'll try this with PHP instead.
[ Parent | on HN ]
Re:How to migrate Flat Text File into MySQL? by rick888 on Saturday July 23, 2011 @12:46PM (#2797231)
you could upload the file to your server and do a mysql_import (I assume it's tab/comma delimited).

PHP can call system commands, so you could do system("Mysql import ...(file)...").

more info about the command here: http://dev.mysql.com/doc/refman/5.0/en/mysqlimport.html

[ Parent | on HN ]
Re:How to migrate Flat Text File into MySQL? by zeroxsys on Saturday July 23, 2011 @01:26PM (#2797324)
Yes, I am familiar with that, thank you @rick888.
[ Parent | on HN ]