View Full Version : help! trouble loading .txt files into mySQL front

07-10-2002, 10:19 AM
spent all night entering data into my 1st DB via "mySQL front" and this morning had to reinstall everything, so i lost the whole DB but i did export it as a .txt & html table file last night.. but now i can't seem to get it back :mad:

here is what the exported .txt file looks like:

1,Niko Bellotto ,Slam mode,La colecion,21.50,slam_mode.mp3
2,Oliver Ho,Listening to the voice inside,Meta,40.50,oliver.mp3
3,Numero Deux,The dinning rooms,Conesa,32.50,numero.mp3
5,Gianni Ferrio,Spring themes,Garden,32.50,spring.mp3

..... more of the same..

(its for an online cd store (fake one)
i created a table with the same fields and tried to "import .txt file" but all i get is the id field filled up? the other fields stay blank?

i really don't have time to enter everything again.. :(

07-12-2002, 04:28 PM
You just need to manually parse the file. Using explode, it looks like it could be done very easily.

The text import might work as well if you remove the ID column, perhaps.

07-13-2002, 07:37 AM
:o hehe i'm such a newbie at this, all i had to do was change the "terminator" to "," instead of the default "/t"

07-13-2002, 01:37 PM
hehe cool! :)