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 (antonio.s.messina at gmail.com) 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. -- antonio.s.messina at gmail.com antonio.messina at uzh.ch +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 : openstack at lists.openstack.org Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.openstack.org/pipermail/openstack/attachments/20131106/d86be8ca/attachment.html>