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
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.
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?