<p style="margin: 0.0px 0.0px 0.0px 0.0px"><font face="Helvetica" size="4" style="font: 13.0px Helvetica">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.</font></p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px"><font face="Helvetica" size="4" style="font: 13.0px Helvetica">You should probably dump the whole database and restore it if needed</font></p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Helvetica; min-height: 16.0px"><br></p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px"><font face="Helvetica" size="4" style="font: 13.0px Helvetica">Razique</font></p>
 <div id="bloop_sign_"><span style="font-family:helvetica,arial;font-size:13px"></span>-- <br>Razique<br></div> <br /><p style="color:#A0A0A8;">On 6 Nov 2013 at 03:46:02, Antonio Messina (<a href="mailto://antonio.s.messina@gmail.com">antonio.s.messina@gmail.com</a>) wrote:</p> <blockquote type="cite" class="clean_bq"><span><div  ><div>Hi all,
<br/>
<br/>We need to backup and then recover some information from the nova
<br/>database, specifically:
<br/>
<br/>* flavors
<br/>* quotas
<br/>* keypairs
<br/>* security groups
<br/>
<br/>I would like to know which tables I am supposed to back up and
<br/>recover, I guess the following:
<br/>
<br/>* quotas
<br/>* security_groups
<br/>* security_group_rules
<br/>* instance_types
<br/>
<br/>are enough? Can I just dump them with mysqldump and recover them with
<br/>mysql < backupfile?
<br/>
<br/>.a.
<br/>
<br/>--   br/>antonio.s.messina@@gmail.com
<br/>antonio.messina@uzh.ch                     +41 (0)44 635 42 22
<br/>GC3: Grid Computing Competence Center      http://www.gc3.uzh.ch/
<br/>University of Zurich
<br/>Winterthurerstrasse 190
<br/>CH-8057 Zurich Switzerland
<br/>
<br/>_______________________________________________
<br/>Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
<br/>Post to     : openstack@lists.openstack.org
<br/>Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
<br/></div></div></span></blockquote>