Restore from a backup file

[adrian.oprea]

How can i restore a database just form a full backup ?
imagine you lose the hosts and you have the bkp file on tape !! is this possible ?

[jpcavanaugh]

You should be able to do this -- see http://my.vertica.com/docs/6.0.1/HTML/i ... #16026.htm.

In general, you will need to restore the nodes, install vertica and create an empty database with the same name as the old one. Additionally, all the hostnames and ipaddress must be the same.

[adrian.oprea]

Ok, i have already tried all the backup options that come with vbr.py script . They work great !
But i was looking for a possible dump option and then import into a separate db , without any specific nodes config, just the object/schema alone !:).
Well as looking at Vertica's arch we might say that this type of backup/restore it has no reason to be done , but for the sake of stressing Vertica i wanna know is is possible .
BTW - this can be done with EXPORT-IMPORT over a public network !!
thx

[JimKnicely]

Adrian,

In your last post you wrote:

But i was looking for a possible dump option and then import into a separate db , without any specific nodes config, just the object/schema alone !:).

Are you looking to dump the objects in a schema? If so, have you looked at the EXPORT_OBJECTS function? You can use it dump the objects in a schema as SQL create statements...

From page 487 of the SQL Reference Manual:

EXPORT_OBJECTS
Generates a SQL script that you can use to recreate catalog objects on a different cluster.

This thread also refers to the EXPORT_OBJECTS function: viewtopic.php?f=48&t=356&hilit=export_objects

[adrian.oprea]

Sure this can be done !!
THX

[adrian.oprea]

You should be able to do this -- see http://my.vertica.com/docs/6.0.1/HTML/i ... #16026.htm.

In general, you will need to restore the nodes, install vertica and create an empty database with the same name as the old one. Additionally, all the hostnames and ipaddress must be the same.

So there is no EXPDP/IMPDP (oracle) like in Vertica ?

Imagine this :
How can i backup a schema MONKEY in Cluster X and restore it in Cluster Y ?
In schema MONKEY i have tables,views,functions,etc...
How is this possible without the EXPORT/IMPORT commands and not over the network , just plain tape !
THX