Avatar of Ben Hart
Ben Hart
Flag for United States of America asked on

Informix - dbexport/dbimport.. silly question

Say you have DB1.. if you successfull run dbexport on that database.  And let's say you lose the exported file(s).. is the data still contained within DB1 and in a current state that you could fire up the instance and access the data like nothing happened?
DatabasesDB2PostgreSQL

Avatar of undefined
Last Comment
Gary Patterson, CISSP

8/22/2022 - Mon
Jim P.

You should be able to. About 99.9% of the databases don't actually delete the data during the export process, they just make a copy of it in some sort text readable file.
Ben Hart

ASKER
I had hoped there'd be more than one reply.  Maybe someone whose done it before?
Gary Patterson, CISSP

dbexport is nondestructive.  It basically generates a bunch of SELECT statements, so you'll want to disable SELECT triggers before you run an export.

- Gary Patterson
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Ben Hart

ASKER
Thanks so much Gray.  Last thing.. once you dbimport into the new db on the new server.. does this new db need to already be as big as the old one or will it dynamically increase?
ASKER CERTIFIED SOLUTION
Gary Patterson, CISSP

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.