ContextQMD
Back to Influxdb

Undelete a table

content/influxdb3/clustered/admin/tables/undelete.md

latest2.1 KB
Original Source

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 7 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

  1. If you haven't already, download and install the influxctl CLI.

  2. Use the influxctl table undelete command to restore a deleted table. Provide the following:

    • The name of the database associated with the deleted table
    • The ID of the deleted table to restore
bash
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:

<!--pytest.mark.skip-->
bash
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.