Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    mat
    mat is offline
    Regular Coder
    Join Date
    Jul 2002
    Posts
    199
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unhappy help! trouble loading .txt files into mySQL front

    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

    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..

  • #2
    New Coder
    Join Date
    Jun 2002
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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.

  • #3
    mat
    mat is offline
    Regular Coder
    Join Date
    Jul 2002
    Posts
    199
    Thanks
    0
    Thanked 0 Times in 0 Posts
    hehe i'm such a newbie at this, all i had to do was change the "terminator" to "," instead of the default "/t"

  • #4
    New Coder
    Join Date
    Jun 2002
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts
    hehe cool!


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •