I’d say it’s risky since it’s possible that you end up with inconsistent 
states, especially with the security_groups and keypairs tables.
You should probably dump the whole database and restore it if needed

Razique
-- 
Razique

On 6 Nov 2013 at 03:46:02, Antonio Messina ([email protected]) wrote:

Hi all,  

We need to backup and then recover some information from the nova  
database, specifically:  

* flavors  
* quotas  
* keypairs  
* security groups  

I would like to know which tables I am supposed to back up and  
recover, I guess the following:  

* quotas  
* security_groups
* security_group_rules
* instance_types  

are enough? Can I just dump them with mysqldump and recover them with  
mysql < backupfile?  

.a.  

--  
[email protected]
[email protected] +41 (0)44 635 42 22  
GC3: Grid Computing Competence Center http://www.gc3.uzh.ch/
University of Zurich  
Winterthurerstrasse 190  
CH-8057 Zurich Switzerland  

_______________________________________________
Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
Post to : [email protected]
Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
_______________________________________________
Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
Post to     : [email protected]
Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack

Reply via email to