Comment on How to migrate Flat Text File into MySQL?parentComments−zeroxsysOP15yI 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.−rick88815yyou 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−zeroxsysOP15yYes, I am familiar with that, thank you @rick888.
Comments
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.
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
Yes, I am familiar with that, thank you @rick888.