Data Migration

Last updated: 2021-07-06 17:05:17

    How do I import a local SQL file into a TencentDB for MySQL instance?


    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.

      A single SQL file to be imported cannot exceed 2 GB. The filename can only contain letters, digits, and underscores.

      For more information, please 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 Restore tab for download.
    • To export real-time data, you can purchase a read-only replica, 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?

    We recommend that you connect the database to be migrated using the data migration feature for data sync.