Ask Your Question
0

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

asked 2012-05-03 15:47:52 -0500

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!

Sachin

edit retag flag offensive close merge delete

2 answers

Sort by ยป oldest newest most voted
0

answered 2012-05-03 22:35:55 -0500

conmotto gravatar image

Not sure, but I just posted a schema diagram and reverse-engineered MySQL .sql file that might help: http://www.prestonlee.com/2012/05/03/openstack-nova-essex-mysql-database-schema-diagram-and-sql/ (http://www.prestonlee.com/2012/05/03/...)

edit flag offensive delete link more
0

answered 2012-05-04 07:04:11 -0500

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 api.py 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.

Cheers!

Sachin

edit flag offensive delete link more

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

Stats

Asked: 2012-05-03 15:47:52 -0500

Seen: 101 times

Last updated: May 04 '12