Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2003
    Posts
    12

    Unanswered: How to do export and import

    Hi!
    How to do an export/import in mysql on WIN2000.

    Many Thanks,

  2. #2
    Join Date
    Dec 2003
    Location
    Sweden
    Posts
    4

    Re: How to do export and import

    Originally posted by D.Ramesh
    Hi!
    How to do an export/import in mysql on WIN2000.

    Many Thanks,
    I usually run LOAD DATA INFILE mto import and mysqldump [OPTIONS] database [tables] to export (see below).

    http://www.mysql.com/doc/en/mysqlimport.html
    http://www.mysql.com/doc/en/mysqldump.html
    /maria

  3. #3
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    You can check

    http://www.lasso-developpeur.net/us/...tab=db&lang=us

    For importing text file in a mysql table
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  4. #4
    Join Date
    Sep 2003
    Posts
    12
    Thanks!

  5. #5
    Join Date
    Sep 2003
    Posts
    12
    Hi!
    c:\mysql\bin>mysqldump --all-databases > alldbdump.sql

    Using the above command i have taken the dump of all the databases. Now i want to restore all the databases in the dump to a new machine.How to do it?I have to use the Load data Infile or is there any other way.Buy using the load data infile .txt files can be imported to table.

    Now i have one dump file(alldbdump.sql)?

    Many Thanks!

  6. #6
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    MySqldump whithout specifics options
    Will produce a simple sql file
    contenning db and table creation statement
    and insert statement to populate the table

    So to restaure your db on an other serveur you should use

    mysql -u [user] -p -h [hote] .... < file.sql
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  7. #7
    Join Date
    Sep 2003
    Posts
    12
    Thanks a lot...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •