Open Stack

On Wed, Nov 6, 2013 at 12:46 PM, Razique Mahroua
<razique.mahroua at gmail.com> wrote:
> 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

I cannot.
The reason why I need to do it is because the current database is
already in a state which is driving nova-network crazy.

I have sent an email a few days ago about the problem we are having
with our installation. After some more checking, it seems that the
problem is caused by the *data* currently stored in the database; we
tried with an empty one and everything was working smoothly: instances
are started within one minute and deleted as needed, while going back
to the original database brings back the issue.

So, we guess it's something on the database, but we don't have either
the time nor the competence nor the need to further debug the issue,
since we are planning to move Havana soon and we have to keep the
cloud up&running ASAP.

Therefore we decided to clean up the database and remove more or less
everything, but as I said, we would like to keep the information
mentioned before.

.a.

>
>
> 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.
>
> -- br/>antonio.s.messina@@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



-- 
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