Database data into files

Discussion in 'MySQL' started by shabbir, Apr 29, 2007.

  1. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,375
    Likes Received:
    388
    Trophy Points:
    83
    Say I have MySQL Database where I have one field containing large text data. Say something like Email body text or some long emails and now I want that data to compare at future instance and see what is updated from the last export.

    Now what I am looking for is export the data of a table into a file but the constraint is it each row should be exported to a file.

    What I am seeing best is have the MySQLDump to a single file and then split the data into needed files
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,375
    Likes Received:
    388
    Trophy Points:
    83
    Just to add I also have the phpMyAdmin installed and if anything such is there in it you can also let me know.
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice