...

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



mat
07-10-2002, 09: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:

id,artist,title,label,price,sound
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
4,Photek,Solaris,Omni,32.50,photek.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.. :(

Fitzbean
07-12-2002, 03: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.

mat
07-13-2002, 06: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"

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



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum