#1
  1. No Profile Picture
    nnrao18
    Guest
    Devshed Newbie (0 - 499 posts)
    how to export the data from mysql database to a text file and how to import the data from text file to mysql database.
    If any one have the solution for this problem please send it as early as possible.

    with regards
    Narayana Rao
  2. #2
  3. No Profile Picture
    RyanP
    Guest
    Devshed Newbie (0 - 499 posts)
    use the mysqldump binary
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    16
    Rep Power
    0
    <BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by nnrao18:
    how to export the data from mysql database to a text file and how to import the data from text file to mysql database.
    [/quote]

    As guy before said, see the mysqldump. Works great, but if your version of mysql supports, use the --opt flag.

    You can also get table definitions like this:

    mysqldump [-u user] [-pPASSWORD] -d database >databases-d.dump

    I'm doing a compare of oracle and mysql (for features I use a lot in mysql I need to find in oracle):
    http://www.rede.com/rdbms/mysql2oracle.html

    Peter

  6. #4
  7. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2000
    Posts
    20
    Rep Power
    0
    You may also find the commands:
    LOAD DATA INFILE
    and
    SELECT ... INTO OUTFILE

    of some use.

IMN logo majestic logo threadwatch logo seochat tools logo