Here is the descriptions on how to upgrade the JCS for MySQL from a lower version to a higher version JCS for MySQL. Take the upgrade of JCS for MySQL 5.7 to MySQL 8.0 for example as below.
mysqldump -u User name -p Password -R -E --skip-tz-utc --opt --skip-add-drop-table --single-transaction --hex-blob --default-character-set=binary --master-data=2 -B Database name > /Path/Export file name.sql Parameter Description User Name: User Name of Cloud Database Password: Password of Cloud Database Database Name: Fill in database names to be outputted and separate several database names with spaces.
After exporting the data of JCS for MySQL 5.7, begin to create JCS for MySQL 8.0. For specific steps for creation, please refer to Create JCS for MySQL instance.
Create the database through the console. It shall ensure that the name of JCS for MySQL 5.7 to be exported has been created in JCS for MySQL 8.0 as well. For specific steps for creation, please refer to Create Database.
Create the database account through the console and grant the read-write permission of the database newly created in Step 5. For specific steps for creation, please refer to Create Account.
Import the data that is exported in Step 3 to the new JCS for MySQL 8.0 and execute the command
mysql -u User name -p Password -h Cloud database domain --default-character-set=binary < /Path/Export file name.sql Parameter Description User Name: User Name in Actions of Step 6. Password: Corresponding Password of the User in Actions of Step 6. Database Domain: Please view domain of JCS for MySQL 8.0 in the Details of instance.