Tab delimited text --> MySQL

[Anon]

I've got tab-delimited database files coming from another database that I need to dump into my MySQL db. What is the best way to parse a tab delimited file with PHP?

Is PHP even the best tool for the job? I'd also consider doing a script in Python. Or maybe MySQL already has a utility for importing tab delimited files?

[Anon]

Luke
you can do it from the prompt by doing

mysql database < file.sql so that means a bash script or crontab can execute that. in the .sql file you can use. load data local infile "/home/you/foo.txt" into table foo;

That's one way.

gd

[Anon]

I guess load data local is some directive for using tab delimited text files?

What I wonder is how with a tab delimitd file you get around having a tab in a string, or a null field, etc... Seems like a rather limited format, but that's about I've got to work with

[kelkar_mandar]

i think you can try this

load data infile '/home/name/...' into table xyz fields terminated by ' ' lines terminated by '\n' ;

this is to be given from mysql prompt

if u have table say with fields name,address,no and if the files contains the data in other format then u can specify the field names in which they are in the file

load data infile '/home/name/...' into table xyz fields terminated by ' ' lines terminated by '\n' (address,name,no);

let me know if u wanted this same thing

i am also a newbie and would like to learn from mistakes

[e-mail]