Undelete a table
Use the influxctl table undelete command
to restore a previously deleted table in your InfluxDBed cluster.
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.
Tables can only be undeleted for
a configurable “hard-delete” grace period
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
If you haven’t already, download and install the
influxctlCLI.Use the
influxctl table undeletecommand 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
influxctl table undelete DATABASE_NAME TABLE_IDReplace the following:
DATABASE_NAME: Name of the database associated with the deleted tableTABLE_ID: ID of the deleted table to restore
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_NAMEReplace DATABASE_NAME
with the name of the database associated with the table you want to undelete.
Was this page helpful?
Thank you for your feedback!
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB Clustered and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.