Table recycle bin

How it works

When you run DROP TABLE on a database with the recycle bin enabled, PolarDB-X 1.0 moves the table to the recycle bin rather than deleting it immediately. The table is no longer visible in the database but remains recoverable for up to 2 hours. After 2 hours, the table is permanently deleted.

Tables in the recycle bin continue to occupy storage space until they are restored or deleted. To free up storage before the 2-hour window expires, delete the tables manually from the recycle bin.

Only DROP TABLE triggers the recycle bin. Tables cleared with TRUNCATE TABLE are not moved to the recycle bin and cannot be recovered through this feature.

Limitations

Enable the recycle bin

1. Log on to the PolarDB-X console and select the region where your instance is deployed.

2. On the Instances page, click the instance name.

3. In the left-side navigation pane, click Table Recycle Bin.

4. Select the database for which you want to enable the recycle bin, then click Enable.

5. In the confirmation dialog, click OK.

Restore a table

1. On the Table Recycle Bin page, find the database and locate the table you want to restore.

2. Click Restore.

A table can be restored only within 2 hours of being dropped. After 2 hours, the table is permanently deleted and cannot be recovered.

Delete tables from the recycle bin

1. On the Table Recycle Bin page, find the database and locate the table.

2. To delete a single table, click Delete. To remove all tables in the recycle bin at once, click Clear Recycle Bin.

Disable the recycle bin

1. On the Table Recycle Bin page, find the database.

2. Click Disable.