1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Export MySQL to CSV

Discussion in 'MySQL' started by incommon, Jun 14, 2007.

  1. #1
    I'm running a windows machine (IIS6), with MySQL and MySQL Administrator installed.

    Unfortunately, phpmyadmin isn't installed.

    I need to export a MySQL database into .csv format. Does anyone know what the easiest way to do this is?
     
    incommon, Jun 14, 2007 IP
  2. gibex

    gibex Active Member

    Messages:
    1,060
    Likes Received:
    21
    Best Answers:
    0
    Trophy Points:
    95
    #2
    since csv is a text file you can use:

    SELECT * INTO OUTFILE 'YOUR_FILE.CSV'
    FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
    LINES TERMINATED BY '\n'
    FROM YOUR_TABLE;
     
    gibex, Jun 15, 2007 IP
  3. rthurul

    rthurul Peon

    Messages:
    45
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    OR you can install MySQL front and do it in a visual inteface very easily
     
    rthurul, Jun 16, 2007 IP
  4. incommon

    incommon Peon

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    I haven't used MySQL front before. Is it better than MySQL administrator?

    A quick google search says it has been discontinued:
    http://www.mysqlfront.de/

    Is it now heidiSQL?
    http://www.heidisql.com/
     
    incommon, Jun 16, 2007 IP
  5. rthurul

    rthurul Peon

    Messages:
    45
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Yes I think it was discontinued. I am using some older version and I preffer them over MySQL administrator.. This is obviously just my choice :)
     
    rthurul, Jun 18, 2007 IP