Batch Operating Instance

Last updated: 2021-07-12 09:54:20

    Overview

    TencentDB for MySQL supports importing SQL files in the console. This feature allows you to execute SQL statements in the selected database. You can also use this feature to create databases/tables and change table structure so as to initialize or modify the instance.

    Note:

    Only two-node and three-node TencentDB for MySQL instances support importing SQL files.

    Directions

    1. Log in to the TencentDB for MySQL console. In the instance list, click an instance ID or Manage in the Operation column to enter the instance management page.
    2. Select Database Management > Database List and click Import Data.
    3. On the pop-up page, click Add File to import the file. After the upload is completed, click Next.
      Note:

      • To avoid database unavailability caused by corruption of system tables, please do not import data from system tables such as the mysql.user table.
      • Only incremental import is supported. If there is obsolete data in the database, clear the data before the importing operation.
      • A single SQL file to be imported cannot exceed 2 GB. The filename can only contain letters, digits, and underscores.
      • Uploaded files are valid for 14 days and will be automatically deleted after expiration.
    4. On the database selection page, select the target database and click Next.
    5. On the confirmation page, after confirming that the imported data is correct, enter the account and password and click Import.
      Note:

      • The import cannot be rolled back. Please confirm the import information.
      • If you forgot the password, please reset it as instructed in Resetting Password.