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..
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...
create the table first in mysql then use the LOAD DATA INFILE to bring your text file into the mysql database table.
I would do that first because you then have all the data into mysql to work with.
You then can figure out what tables you need to move your database towards normalization. you can then do a select out of this first table on only the fields you need for each of the other tables.
(i.e. you might want to create one for contact info of each supplier, you would then only select the fields from the master table that you would need in the contact table. you could assign an autoincrement field or something to identify the suppliers or whatever).
finally, when you are happy with all your other tables you can delete the initial table from your database.