/vertdump

Dumps HP Vertica database tables to zip file

Primary LanguageShellGNU General Public License v2.0GPL-2.0

vertdump

Dumps HP Vertica database tables to zip file

How to use (as root):

git clone https://github.com/gleisonsilva/vertdump.git
cd vertdump

Exporting data

./vertdump.sh -e DB_ADMIN_USER DB_ADMIN_PASSWORD SCHEMA_NAME /tmp/export/

Importing data

Tip : check in /tmp/export/ if there is a file used to import data previously . If any, should be deleted

./vertdump.sh -i DB_ADMIN_USER DB_ADMIN_PASSWORD SCHEMA_NAME ZIPPED_DUMP_FILE_TO_IMPORT USER_OWNER_OF_THE_IMPORTED_SCHEMA