How to delete a row from the networks table?

Asked by arturo lorenzo on 2011-02-23

If you enter nova-manage network create 10.0.0.0/24 1 255 then an entry is made in the sql db. how can I delete it if there is not use for it anymore?
thanks

Question information

Language:
English Edit question
Status:
Solved
For:
OpenStack Compute (nova) Edit question
Assignee:
No assignee Edit question
Solved by:
arturo lorenzo
Solved:
Last query:
Last reply:
Revision history for this message
arturo lorenzo (arturo-lorenzo) said :
#1

Found a workaround. Just enter in
 mysql> delete from networks;
and that will delete all the entries in the networks table.

Revision history for this message
Vish Ishaya (vishvananda) said :
#2

you also need to delete fixed_ips or you will likely run into problems.

Vish
On Feb 23, 2011, at 8:44 PM, arturo lorenzo wrote:

> Question #146630 on OpenStack Compute (nova) changed:
> https://answers.launchpad.net/nova/+question/146630
>
> Status: Open => Solved
>
> arturo lorenzo confirmed that the question is solved:
> Found a workaround. Just enter in
> mysql> delete from networks;
> and that will delete all the entries in the networks table.
>
> --
> You received this question notification because you are a member of Nova
> Core, which is an answer contact for OpenStack Compute (nova).