Load data to Mysql from a file

Hi,

I'm quite new to PHP, I have a file with all the data I need,if I open it using wordpad of windows, I can see the data there line by line(several columns per line).

Could you please tell me how to load it into an existing database in mysql, for example mydb?

Thank you very much.

Dallvic

 

You might want to take a look at phpmyadmin - perhaps you have this available on your server. It has a feature to import a data file into mysql.

If you have a file of sql statements, ie 'INSERT INTO xxx", then phpmyadmin will let you upload that file and run it into your database.

Hope this helps.

 

the data look like:

aaa [bbb] /ccc/
ddd [eee] /fff/

Thanks.

 

Yes, I have phpmyadmin on my server.
I just found out that I can use this command to load big amount of data:

LOAD DATA LOCAL INFILE “***.txt” INTO TABLE mydb;

Thanks.