Help Center> GaussDB(for MySQL)> Troubleshooting> SQL Issues> Error Message Reported When alter table xxx discard/import tablespace Is Executed

Updated on 2023-09-15 GMT+08:00

View PDF

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.

Parent topic: SQL Issues

Previous topic: ERROR 1396 Reported When a User Is Created

Next topic: Native Error 1461 Reported by a DB Instance

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.