MySQL help importing csv

Discussion in 'MySQL' started by basscleff, May 28, 2008.

0
  1. #1
    wonder if someone can assist:

    I have a tag cloud script, and am trying to add bulk links to the database without manually doing it through the php web interface 1 by 1.

    I exported my sql database to excel using mysql admin, and then added some data (hyperlinks and text descriptions) I then attempted to re-import the data as csv, but was not able to.

    is there someone that can offer some pointers, or the right process to export, edit, and then import?

    thx
     
    basscleff, May 28, 2008 IP
  2. sukosari

    sukosari Active Member

    Messages:
    63
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    93
    #2
    you can use tool, such as navicat or EMS
     
    sukosari, May 29, 2008 IP
  3. kmap

    kmap Well-Known Member

    Messages:
    2,215
    Likes Received:
    29
    Best Answers:
    2
    Trophy Points:
    135
    #3
    Well i can import the data cheaply

    from csv

    $10 per db

    50% advance

    Regards

    Alex
     
    kmap, May 29, 2008 IP
  4. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #4
    You can choose any of the MySQL GUI tool to export and import your data. You can use Excel to edit data or even any text editor.
     
    mwasif, May 29, 2008 IP
  5. allaboutgeo

    allaboutgeo Peon

    Messages:
    85
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #5
    I can do it for you at a very nominal cost.
     
    allaboutgeo, May 29, 2008 IP