Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2003
    Posts
    32

    Unanswered: Clone Informix 7.31 database

    HI
    iam new to informix. Currently Informix database 7.3 is Up & running on Linux os and I would like to move the entire database to some other Linux system( Suse Linux 7.1). can you please guide me how to clone the database from one platform to another (linux to Suse linux).

  2. #2
    Join Date
    May 2004
    Location
    New York
    Posts
    248
    take a look at the dbexport and dbimport commands

    you can do dbexport and tar the whole unload, ftp it over to another machine, untar it and to a dbimport


    Cheers

  3. #3
    Join Date
    Jul 2003
    Posts
    32
    Hi
    do you have any steps or notes for cloning database .
    Any help would be appreciated

    Rgds

  4. #4
    Join Date
    Aug 2003
    Location
    India
    Posts
    262
    Hi,

    Server 1

    dbexport <dbname> -ss

    Zip/Tar the file and copy it to other server & untar it.

    Server 2

    dbimport <dbname> -d <dbspace> -l <buffered>

    where d is the dbspace name
    and l is the buffered log mode

Posting Permissions

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