ContextQMD
Back to Influxdb

Undelete a table

content/influxdb3/cloud-dedicated/admin/tables/undelete.md

latest2.8 KB
Original Source

Use the Admin UI or 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.

{{< tabs-wrapper >}} {{% tabs %}} Admin UI influxctl {{% /tabs %}} {{% tab-content %}} {{< admin-ui-access >}}

In the table list for a database, find the deleted table you want to restore. Deleted tables are shown with a "Deleted" status indicator. You can sort on column headers or use the Search field to find a specific table.

  1. In the options menu (three vertical dots to the right of the table), click Restore Table. The Restore Table dialog displays.

  2. In the Restore Table dialog, review the table name and deletion date.

  3. Click the Restore Table button to restore the table. {{% /tab-content %}} {{% tab-content %}}

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

  5. 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. {{% /tab-content %}} {{< /tabs-wrapper >}}