Export MySQL to CSV

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

0
  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