How do I import a local SQL file into a TencentDB for MySQL instance?
High-availability edition and finance edition of TencentDB for MySQL instances support importing SQL files.
- Log in to the TencentDB for MySQL Console and click an instance name to enter the management page.
- Select Database Management > Database List > Data Import. Select the file to be imported and the target database and click OK to import the data.
A single SQL file to be imported should be no more than 2 GB in size. The filename can only contain letters, digits, and underscores.
For more information, please see Importing SQL File.
How do I export data from a database?
- To export backup data, click an instance name in the console to enter the management page and select the Backup and Restore 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.
What is the fastest way to migrate a 7 GB database to a TencentDB for MySQL instance?
You are recommended to directly connect your source database by using the data migration feature for data sync.
How do I achieve sync of real-time data in two instances in a local dual-backup architecture?
For this purpose, you can purchase disaster recovery instances in the console.