Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/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';"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement