Created
April 20, 2015 15:27
-
-
Save jamiehannaford/60430b6ca7154c79f8d0 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/bash | |
echo "Enter your MySQL user" | |
read MYSQL_USER | |
echo "Enter your MySQL user password" | |
read MYSQL_PASSWD | |
echo "Enter your Nova VM ID" | |
read VM_ID | |
MYSQL_HOST=localhost | |
mysql -u$MYSQL_USER -p$MYSQL_PASSWD -h$MYSQL_HOST -e "USE nova; delete from instance_faults where instance_faults.instance_uuid = '$VM_ID';" | |
mysql -u$MYSQL_USER -p$MYSQL_PASSWD -h$MYSQL_HOST -e "USE nova; delete from instance_extra where instance_extra.instance_uuid = '$VM_ID';" | |
mysql -u$MYSQL_USER -p$MYSQL_PASSWD -h$MYSQL_HOST -e "USE nova; delete from instance_metadata where instance_metadata.instance_uuid = '$VM_ID';" | |
mysql -u$MYSQL_USER -p$MYSQL_PASSWD -h$MYSQL_HOST -e "USE nova; delete from instance_id_mappings where instance_id_mappings.uuid = '$VM_ID';" | |
mysql -u$MYSQL_USER -p$MYSQL_PASSWD -h$MYSQL_HOST -e "USE nova; delete from instance_info_caches where instance_info_caches.instance_uuid = '$VM_ID';" | |
mysql -u$MYSQL_USER -p$MYSQL_PASSWD -h$MYSQL_HOST -e "USE nova; delete from instance_system_metadata where instance_system_metadata.instance_uuid = '$VM_ID';" | |
mysql -u$MYSQL_USER -p$MYSQL_PASSWD -h$MYSQL_HOST -e "USE nova; delete from security_group_instance_association where security_group_instance_association.instance_uuid = '$VM_ID';" | |
mysql -u$MYSQL_USER -p$MYSQL_PASSWD -h$MYSQL_HOST -e "USE nova; delete from block_device_mapping where block_device_mapping.instance_uuid = '$VM_ID';" | |
mysql -u$MYSQL_USER -p$MYSQL_PASSWD -h$MYSQL_HOST -e "USE nova; delete from fixed_ips where fixed_ips.instance_uuid = '$VM_ID';" | |
mysql -u$MYSQL_USER -p$MYSQL_PASSWD -h$MYSQL_HOST -e "USE nova; delete from instance_actions_events where instance_actions_events.action_id in (select id from instance_actions where instance_actions.instance_uuid = '$VM_ID');" | |
mysql -u$MYSQL_USER -p$MYSQL_PASSWD -h$MYSQL_HOST -e "USE nova; delete from instance_actions where instance_actions.instance_uuid = '$VM_ID';" | |
mysql -u$MYSQL_USER -p$MYSQL_PASSWD -h$MYSQL_HOST -e "USE nova; delete from virtual_interfaces where virtual_interfaces.instance_uuid = '$VM_ID';" | |
mysql -u$MYSQL_USER -p$MYSQL_PASSWD -h$MYSQL_HOST -e "USE nova; delete from instances where instances.uuid = '$VM_ID';" |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment