Cloning of informix database

Posted in 2008

Topics: Migration, Import/Export & Data Conversion

JAYANTH JAYACHANDRAN — Fri, 02 May 2008 10:36:43 — source: IIUG Forums & Mailing Lists

Hi, I am trying to copy an informix database using dbexport and i could do it on a test server but not on a production server. Also in the test server i am unable to use dbimport which is not working and getting error message as " unable to create sql scripts. Could anyone please give me the syntax of using the dbexport/dbimport command so that i could proceed with this. Thanks for the help

↪ replying to JAYANTH JAYACHANDRAN

S.J. Scheepers — Fri, 02 May 2008 10:46:45 — source: IIUG Forums & Mailing Lists

Permissions? RTM 2008/5/2 JAYANTH JAYACHANDRAN <jayanthsec@gmail.com>: > Hi, > > I am trying to copy an informix database using dbexport and i could do it > on a > test server but not on a production server. Also in the test server i am > unable to use dbimport which is not working and getting error message as " > unable to create sql scripts. > > Could anyone please give me the syntax of using the dbexport/dbimport > command > so that i could proceed with this. > > Thanks for the help > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > See you at the IIUG Informix 2008 Conference > The Power Conference for Informix Professionals > April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas > http://www.iiug.org/conf > Registration Now Open!! > -- Skip +264-81-124-2345

↪ replying to S.J. Scheepers

Everett Mills — Fri, 02 May 2008 14:40:48 — source: IIUG Forums & Mailing Lists

If you're using UNIX or Linux, try "umask 000" before the dbexport. --EEM > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of S.J. > Scheepers > Sent: Friday, May 02, 2008 5:47 AM > To: ids@iiug.org > Subject: Re: Cloning of informix database [11956] > > Permissions? > > RTM > > 2008/5/2 JAYANTH JAYACHANDRAN <jayanthsec@gmail.com>: > > > Hi, > > > > I am trying to copy an informix database using dbexport and i could do > it > > on a > > test server but not on a production server. Also in the test server i am > > unable to use dbimport which is not working and getting error message as > " > > unable to create sql scripts. > > > > Could anyone please give me the syntax of using the dbexport/dbimport > > command > > so that i could proceed with this. > > > > Thanks for the help > > > > > > > > > ************************************************************************ ** > ***** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > See you at the IIUG Informix 2008 Conference > > The Power Conference for Informix Professionals > > April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas > > http://www.iiug.org/conf > > Registration Now Open!! > > > > -- > Skip > +264-81-124-2345 > > > ************************************************************************ ** > ***** > Forum Note: Use "Reply" to post a response in the discussion forum. > > See you at the IIUG Informix 2008 Conference > The Power Conference for Informix Professionals > April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas > http://www.iiug.org/conf > Registration Now Open!!

Glossary

dbexport / dbimport