Results 1 to 5 of 5

Thread: Backup up table

  1. #1
    Join Date
    Aug 2005
    Posts
    140

    Unanswered: Backup up table

    Hi
    I need to back up the table using sql code.
    I need something like mysqldump in MySql.
    Is something like this in informix?

    Thank you in advance

  2. #2
    Join Date
    May 2004
    Location
    New York
    Posts
    248
    dbschema -d database_name -t table_name -ss

    to get the schema

    unload to "table_name.unl"
    select * from table_name

    to unload the data

    if you want to unload the whole database you can use dbexport

  3. #3
    Join Date
    Aug 2005
    Posts
    140
    Thanks, but Can I do this with some Informix SQL command?
    I know about output and unload commands but they only write a data
    to file, they dont write a schema.

    Thanks

  4. #4
    Join Date
    May 2004
    Location
    New York
    Posts
    248
    The only way to do this is by querying systables and syscolumns, take a look how the values are stored. I did this long time ago and dont remember that value coresponds to what datatypes

  5. #5
    Join Date
    Sep 2002
    Posts
    102
    Attached is a unix shell script that extracts the table schema. You can extract the SQL to customize your unload script.
    Attached Files Attached Files

Posting Permissions

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