Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2003
    Posts
    4

    Unanswered: how to import databases from mysql to db2?

    Hello,

    Could anybody please give me some hints as to how can I import databases in mysql to DB2? I have no idea about mysql at all.

    I would like to take the database to some other physical location, so please tell me if there is a way to take it in file/csv/text format and install it back on DB2.

    Thanks for the help in advance.
    Vidya.

  2. #2
    Join Date
    Sep 2002
    Location
    Montreal, Canada
    Posts
    224
    Provided Answers: 1

    Re: how to import databases from mysql to db2?

    Originally posted by VidyaRam
    Hello,

    Could anybody please give me some hints as to how can I import databases in mysql to DB2? I have no idea about mysql at all.

    I would like to take the database to some other physical location, so please tell me if there is a way to take it in file/csv/text format and install it back on DB2.

    Thanks for the help in advance.
    Vidya.
    Check out the mysqldump utility.

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

    Then you'll have to import the script into db2.

    Hope this helps.

  3. #3
    Join Date
    Sep 2003
    Posts
    4
    Thank you bstjean for the quick reply. I will try it out.

    Vidya.

  4. #4
    Join Date
    Oct 2003
    Location
    Chennai,India
    Posts
    4

    Post script to Import Data from CSV file to DB2 Database

    Hi,



    Could anyone help me to write script or send script to import data from CSV file to DB2 database.

  5. #5
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: script to Import Data from CSV file to DB2 Database

    Refer the Command Reference Manual for detailed information :

    IMPORT FROM <filename> of <format> <insert/replace/etc> into <tablename>

    HTH

    Sathyaram

    Originally posted by sengu
    Hi,



    Could anyone help me to write script or send script to import data from CSV file to DB2 database.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  6. #6
    Join Date
    Oct 2003
    Location
    Chennai,India
    Posts
    4

    Smile Re: script to Import Data from CSV file to DB2 Database

    Thanks Sathyaram

Posting Permissions

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