2.4 KiB
title | description | menu | weight | list_code_example | related | draft | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Undelete a table | Use the [`influxctl table undelete` command](/influxdb3/clustered/reference/cli/influxctl/table/undelete/) to restore a previously deleted table in your {{< product-name omit=" Cluster" >}} cluster. |
|
204 | ```bash { placeholders="DATABASE_NAME|TABLE_ID" } influxctl table undelete DATABASE_NAME TABLE_ID ``` |
|
true |
Use the influxctl table undelete
command
to restore a previously deleted table in your {{< product-name omit=" Cluster" >}} cluster.
[!Important] To undelete a table:
- A new table with the same name cannot already exist.
- You must have appropriate permissions to manage databases.
When you undelete a table, it is restored with the same partition template and other settings as when it was deleted.
[!Warning] Tables can only be undeleted for {{% show-in "cloud-dedicated" %}}approximately 14 days{{% /show-in %}}{{% show-in "clustered" %}}a configurable "hard-delete" grace period{{% /show-in %}} after they are deleted. After this grace period, all Parquet files associated with the deleted table are permanently removed and the table cannot be undeleted.
Undelete a table using the influxctl CLI
influxctl table undelete DATABASE_NAME TABLE_ID
Replace the following:
- {{% code-placeholder-key %}}
DATABASE_NAME
{{% /code-placeholder-key %}}: Name of the database associated with the deleted table - {{% code-placeholder-key %}}
TABLE_ID
{{% /code-placeholder-key %}}: ID of the deleted table to restore
[!Tip]
View deleted table IDs
To view the IDs of deleted tables, use the
influxctl table list
command with the--filter-status=deleted
flag--for example:influxctl table list --filter-status=deleted DATABASE_NAME
Replace {{% code-placeholder-key %}}
DATABASE_NAME
{{% /code-placeholder-key %}} with the name of the database associated with the table you want to undelete.