• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 772
  • Last Modified:

Informix export/import

We have a very old informix database version. Everything is command line.
How to add a user to the admin group?
When we export a database whose tables data are stored in a tablespace say xyz and when we import the same export file to another database should the tablespace be present.
0
basirana
Asked:
basirana
1 Solution
 
schwertnerCommented:
Possibly these are the commands:

dbexport name_of_database -o output_dir
dbimport name_of_database -i input_dir

http://www.dbforums.com/informix/1614574-informix-export-import.html

Normaly the tablespace should exist.

More info here:

http://www.novell.com/documentation/extendas37/docs/helpcore/books/instInformix.html
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now