hi there..

i have a cgi database..
the cgi reads the datareh.txt file...
the txt file is fielded with | |
the database txt file fields is made of city-phone-fax-address-company name-keywords-sector etc..
like this;

Istanbul|Sampiyon Sarkuteri|Buyukdere C N70/A Mecidiyekoy|0212 2753164||istanbulgidasanayiureticilerivesaticilari |gidasanayiureticilerivesaticilari dnt|konserveciler yemekler gidacilar gidalar pastaneciler pastaneler kuruyemisciler cikolatalar copsisler donerler izgaralar yagcilar mantarlar dondurmacilar uncular sekerciler pekmezciler baharatcilar tavukcular ureticileri saticilari|canned food tinned nourishment bakery dried fruit chocolate ice cream flour sugar spices|conserve conservele mincari alimente cofetarie fructe uscate alune chocolate doner gratar ciuperci ulei ingetata faina dulciuri dulce dulceata pui gaina mirodenie produse producatori| | |

when someone search for something the cgi reads the txt file and copy the line to search results...

ok my question is how to convert this txt file to mysql database...
this database is terrible bec. when I want to change something or add another company i add or change the datareh.txt file in my local drive and upload it to server everytime..and it is 36 mb..!!!!

i think i have two possibility..first to change the database to mysql....second find a way to add the 36 mb datareh.txt file online..(it is nearly impossible to add it with online txt editor scripts bec of its size i think)

i hope you understand my problem...any help will be usefull..thanks for spending time...