SQL File Import and Export
How do I import a local SQL file into a TencentDB for MySQL instance?
Note:
Only two-node and three-node TencentDB for MySQL instances support importing SQL files.
2. Select Database Management > Database List > Import Data. Select the file to be imported and the target database and click OK to import the data.
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 data import is supported. If there is obsolete data in the database, clear the data first before the import operation.
A single file does not exceed 10 GB. The file name only allows letters, digits, and underscores.
How do I export data from a database?
To export backup data, click an Instance ID in the console to enter the management page and select the Backup and Restoration tab for download. To export real-time data, you can purchase a read-only instance, connect to it, and then use mysqldump to get real-time data. Migration with DTS
What is the fastest way to migrate a 7 GB database to a TencentDB for MySQL instance?
We recommend you connect the database to be migrated by using DTS for data sync. Intra-Region Instance Data Sync
How do I sync real-time data in two instances with an intra-city active-active solution?