TencentDB for MySQL supports importing SQL files via the console, allowing you to execute SQL statements in the selected database. You can also use this feature to create databases/tables and change table structures to initialize or modify the instance.
Note:Only two-node and three-node TencentDB for MySQL instances support importing SQL files.
Note:
- To avoid database unavailability caused by corruption of system tables, do not import data from system tables such as the
mysql.user
table.- Only incremental import is supported. Clear any obsolete data in the database before importing.
- You can import an unencrypted .zip file. The unzipped files must be .sql files with a total size of no more than 5 GB.
- A single file should not exceed 10 GB (if it is zipped, the file should not exceed 5 GB after being unzipped), and the file name can contain only letters, digits, and underscores.
- Uploaded files are valid for 14 days and will be automatically deleted after expiration.
Note:
- The import cannot be rolled back. Confirm the import information before proceeding.
- If you forgot the password, reset it as instructed in Resetting Password.
Was this page helpful?