Accidently dropped floating_ips and fixed_ips tables from nova db. How to recreate?

Asked by Sachin Agarwal on 2012-05-03

Dear all,

While trying to remove some stale information about IP addresses from the nova database, I accidently dropped the floating_ips and fixed_ips tables from the nova database. Is there a (sql or python script) command to recreate these empty tables (With the correct schema) so that I can do things like nova-manage network list?

I am running the Essex release under Ubuntu.

Thanks in advance!


Question information

English Edit question
OpenStack Compute (nova) Edit question
No assignee Edit question
Solved by:
Sachin Agarwal
Last query:
Last reply:
ConMotto (conmotto) said : #1

Not sure, but I just posted a schema diagram and reverse-engineered MySQL .sql file that might help:

Thanks @ ConMotto.

For now I decided to do a fresh install, because I wasnt sure about the status of the other tables when creating new tables. Although this reverse-engineered picture you have is very handy (printed it out just for reference!). Thanks!

I also figured out that since Openstack speaks to the SQL database through the sqlalchemy software the models described in the file exactly correspond to the tables being setup in SQL. Its probably important to follow these model descriptions because the sql tables have been changing through the version of Openstack.