SHED

SHEDの博客

Home首页Archives

【Technical Tutorial】How to Delete Volumes in OpenStack via MySQL

11
AI Translation
This post is translated from Chinese into English through AI.View Original
AI-generated summary
The document outlines a method for deleting volumes in OpenStack using MySQL, although it warns that this approach is not recommended as it merely hides the volume. The steps include accessing the MySQL command line, selecting the 'cinder' database, checking the volume identifier in OpenStack, and executing an SQL statement to mark the volume as deleted.

Method to Delete Volumes in OpenStack via Mysql#

[font color="red"]This method is not recommended; it is equivalent to hiding[/font]#

1. Enter the Mysql command line#

mysql -uroot -p[database password]

Enter Mysql

2. Enter the cinder database#

use cinder

Enter cinder database

3. Enter OpenStack to view volume identifiers#

Enter OpenStack to view volume identifiers

4. Execute the SQL statement to set the volume as deleted#

update volumes set deleted=1 where id="b0660a2b-7150-4854-bf09-089ceeca4003";

Execute the SQL statement to set the volume as deleted

Loading...
Ownership of this post data is guaranteed by blockchain and smart contracts to the creator alone.