Remove an OpenStack instance directly from the database
Sometimes you just want to get rid of an OpenStack instance, but the nova CLI doesn't really do the job. I found a very useful script here to achieve this task, but I found two issues there.
1- If you have 2 instances with the same name, it doesn't work at all
2- With the kilo release two DELETE statements are missing
So here it is, fixed :)
Usage : script.sh mysql_host mysql_username mysql_password your_vm_impossible_to_delete