Help Center/ GaussDB(for MySQL)/ Troubleshooting/ SQL Issues/ Error Message Reported When alter table xxx discard/import tablespace Is Executed
Updated on 2023-10-19 GMT+08:00

Error Message Reported When alter table xxx discard/import tablespace Is Executed

Scenario

When alter table xxx discard or import tablespace is executed in GaussDB(for MySQL), the following error message was displayed: "ERROR 3658 (HY000): Feature IMPORT/DISCARD TABLESPACE is unsupported ()".

Possible Causes

MySQL Community Edition uses alter table xxx discard or import tablespace to physically replace table data based on local .ibd tablespace files for data migration, data backups, and data restoration.

GaussDB(for MySQL) decouples storage from compute. Data is stored using shared storage and there is no local .ibd file.

Solution

Import and export data, use DRS for data synchronization, or back up data and restore data.