HI can i restore my backup with New database Name
i mean i took backup of tdadb database , i want to restore it with new name ...
Then u mean , that New database shuld b created in advance before restoring ???? and Then i need to restore using vbr.py
Restore Vertica With new database Name
Moderator: NorbertKrupa
-
- Newbie
- Posts: 19
- Joined: Thu Aug 08, 2013 8:01 am
Re: Restore Vertica With new database Name
>> created in advance before restoring
Yes, of cause! Can do you it in other way? Restore before a backup? Restore of what - an abstract database?
(and also restore doesn't mean create, something must exists)
Yes, of cause! Can do you it in other way? Restore before a backup? Restore of what - an abstract database?
(and also restore doesn't mean create, something must exists)
-
- Newbie
- Posts: 19
- Joined: Thu Aug 08, 2013 8:01 am
Re: Restore Vertica With new database Name
See i took the backup of tdadb , so in .info and .txt file , tdadb name is mentioned
and its catalog directories are
v_tdadb_node0001_catalog and v_tdadb_node0001_data
... i have another database called test, inside this data base my catalog and Data directory are
v_test_node0003_catalog and v_test_node0003_data
In my back up every where tdadb and its catalog names are mentioned , Shuld i replace one by one manually and then restore , then i i can do that by taking tar noe ????
and its catalog directories are
v_tdadb_node0001_catalog and v_tdadb_node0001_data
... i have another database called test, inside this data base my catalog and Data directory are
v_test_node0003_catalog and v_test_node0003_data
In my back up every where tdadb and its catalog names are mentioned , Shuld i replace one by one manually and then restore , then i i can do that by taking tar noe ????
Re: Restore Vertica With new database Name
Hi!
>> See i took the backup of tdadb , so in .info and .txt file , tdadb name is mentioned
Oops. You are right it's little more complicated - you also need to change node names in .ini and .info and rename some directories.
>> can i restore my backup with New database Name
Do you know, my answer now - I don't know, and I'm apologize that I gave you a wrong answer before! May be some other member will help you.
>> See i took the backup of tdadb , so in .info and .txt file , tdadb name is mentioned
Oops. You are right it's little more complicated - you also need to change node names in .ini and .info and rename some directories.
>> can i restore my backup with New database Name
Do you know, my answer now - I don't know, and I'm apologize that I gave you a wrong answer before! May be some other member will help you.
-
- Newbie
- Posts: 19
- Joined: Thu Aug 08, 2013 8:01 am
Re: Restore Vertica With new database Name
Can anyone pls help me to get sort of this problem
Re: Restore Vertica With new database Name
Hi!
[DELETED]
[DELETED]
Last edited by id10t on Sat May 09, 2015 3:33 pm, edited 1 time in total.
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Restore Vertica With new database Name
sKwa, great post! Thanks for sharing!
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.