I have a tab delimited .txt file that is storing the data for my database. I need to get this information into mySQL but although I have an idea what I need to do I am not sure the best way to go about it.
I need a script that will:
1: Drop the existing data from the table
2: Read each line of .txt and explode it
3: Insert all that information into mySQL
4: Append 'some' of the data to a newly created .txt that can be downloaded from the site
5: Delete the original .txt
Any body have any suggestions on the best way to do all this?
Cheers.
I need a script that will:
1: Drop the existing data from the table
2: Read each line of .txt and explode it
3: Insert all that information into mySQL
4: Append 'some' of the data to a newly created .txt that can be downloaded from the site
5: Delete the original .txt
Any body have any suggestions on the best way to do all this?
Cheers.