Add database from a text file

[kirtan_thakkar]

I have a database in a text file. I want to add the database from it to my MySQL database. I am new to php so i want the code of it and please explain if you can because it will help to increase my php knowledge. And after adding 1 line into database i want to skip 2 lines.. Can any one help me..??

[keval_hack]

load data infile "filename.txt" into table tablename fields terminated by ","

You can run above query for that.

[umandajayo]

mysql_query("LOAD DATA LOCAL INFILE '/path/to/file' INTO TABLE mytable");

try this code....

cheers

[Ajuddy]

when you say run this querry, where do you run it? in mysql or you querry it on the connect.php file?

[muralibobby2015]

in the connect.php file