Data Migration

Last updated: 2020-07-20 17:38:49

    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.

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

    Was this page helpful?

    Was this page helpful?

    • Not at all
    • Not very helpful
    • Somewhat helpful
    • Very helpful
    • Extremely helpful
    Send Feedback