UNROP VOLUME
描述
UNDROP VOLUME 恢复之前使用 DROP VOLUME 删除的文件卷及其关联的目录。如果文件卷未被删除，则抛出异常。
如果文件卷已缓存，则命令将取消缓存文件卷及其所有依赖项。
语法
UNDROP VOLUME ( volume_identifier | WITH ID volume_id )Parameter
volume_identifier
指定被删除的文件卷名，可以选择使用数据库名进行限定。
语法:
[ database_name. ] volume_namevolume_id
指定被删除的文件卷的 ID，文件卷的 ID 可以通过
SHOW VOLUMES等语句查询。
示例
-- 假设存在一个名为 `employeevolume` 的被删除的文件卷。
SHOW VOLUMES DROPPED;
+--------+-------------+---------+-------+----+--------------------+--------------------+--------+---------+-----------+
|database| tableName|tableType|tableId|size| createdAt| deletedAt|isShared|isDeleted|description|
+--------+-------------+---------+-------+----+--------------------+--------------------+--------+---------+-----------+
| default|employeevolume| volume| 1| 20|2024-10-10 19:27:...|2024-10-10 19:28:...| false| true| |
+--------+-------------+---------+-------+----+--------------------+--------------------+--------+---------+-----------+
-- 恢复此文件卷
UNDROP VOLUME employeevolume;
-- 确认被恢复
SHOW VOLUMES DROPPED;
+--------+---------+---------+-------+----+---------+---------+--------+---------+-----------+
|database|tableName|tableType|tableId|size|createdAt|deletedAt|isShared|isDeleted|description|
+--------+---------+---------+-------+----+---------+---------+--------+---------+-----------+
+--------+---------+---------+-------+----+---------+---------+--------+---------+-----------+
-- 删除文件卷
DROP VOLUME employeevolume;
SHOW VOLUMES DROPPED;
+--------+-------------+---------+-------+----+--------------------+--------------------+--------+---------+-----------+
|database| tableName|tableType|tableId|size| createdAt| deletedAt|isShared|isDeleted|description|
+--------+-------------+---------+-------+----+--------------------+--------------------+--------+---------+-----------+
| default|employeevolume| volume| 1| 20|2024-10-10 19:27:...|2024-10-10 19:28:...| false| true| |
+--------+-------------+---------+-------+----+--------------------+--------------------+--------+---------+-----------+
-- 使用 ID 恢复文件卷
UNDROP VOLUME WITH ID 1;
-- 确认被恢复
SHOW VOLUMES DROPPED;
+--------+---------+---------+-------+----+---------+---------+--------+---------+-----------+
|database|tableName|tableType|tableId|size|createdAt|deletedAt|isShared|isDeleted|description|
+--------+---------+---------+-------+----+---------+---------+--------+---------+-----------+
+--------+---------+---------+-------+----+---------+---------+--------+---------+-----------+