tencent cloud

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.

1. Log in to the TencentDB for MySQL console and click an instance ID to enter the management page.
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.

   
   For more information, see Importing SQL Files.

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?

You can purchase disaster recovery instances in the console.