export flatfile to Mysql db

[preethib]

I need help to export data from a flatfile to Mysql DB.

My Flatfile has about 5000 records, and one record can have any number of lines in the text file.

record1
field1: <value>
field2:<value>
field3:<value>
<value of field4> <value of field5> <value of field6>
field7:<value>
record2
field1: <value>
field2:<value>
field3:<value>
<value of field4> <value of field5> <value of field6>
record3
field1:<value>
field2:<value>
<value of field3> <value of field4> <value of field5> <value of field6>
..

Any suggestions how I can begin with, any URL links/help resources, will be great.

Thanks a lot.

 

[MikeLacey]

Have a look at:

http://www.mysql.com/doc/en/mysqlimport.html

Mike

Want to get great answers to your Tek-Tips questions? Have a look at faq219-2884

It's like this; even samurai have teddy bears, and even teddy bears get drunk.

 

[preethib]

Mike,

My file has data fields that needs to be inserted in different tables.
For eg.
If I see &quot;record&quot;, than assuming field1 exist, I need to inset the value of field1 to TableA and than assuming field1 exist, I need to inset the value of field2 to TableB etc...

In this case I guess I can use
&quot; [ESCAPED BY '\\' ]&quot;

to identify fields in my textfile.


-Preethi

Thanks for the information.