Re-creating services and networks tables on nova db
For some weird reason the tables for the nova db on mysql server were lost. how can I recreate them or repopulate them? I have restarted the cloud compute and done a nova-manage db sync unsuccessfully. See below: mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | nova | +--------------------+ 3 rows in set (0.00 sec)
mysql> use nova Database changed mysql> show tables;
Empty set (0.00 sec)
This is the error I am getting: Operational Error 2003 "Can't connect to MySQL server on '13.141.230.64' (111)") None None"