Day Wing Cloud RDS database operation

1.RDS database is created, click RDS Instance Management to find the information below.

Official Document -1:HTTP://WWW.CTYUN.CN/HELP/QSLIST/567

Official Document -2:http://www.ctyun.cn/help/qslist/544

IP: Link address a column below the corresponding is Ip:post (IP: Port), get the colon to the left of the data is the IP address

HOST: Port number (get (ip:post) the data to the right of the colon is the port number)

User: Sky-wing Cloud default RDS database username root

Password: is the password created when you create an RDS instance

2.RDS database is not shown externally, only intranet IP can operate RDS DB instance. Open a sky-wing cloud Command window with MySQL database installed.

[[Email protected] ~]#mysql-h<IP> -P<HOST> -u<user> -P<password>//< red > is the corresponding value, the command does not include <> Warning:using a password on the command lineInterfacecan be insecure.Welcome to theMySQLMonitor. CommandsEndwith; or \g.YourMySQLConnection ID is 95366Server version: 5.6.30-Log MySQLCommunity Server (GPL) Copyright (c)2018, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or Itsaffiliates.Other names trademarks of their respectiveowners.Type' Help; ' or ' \h ' forHelp. Type ' \c ' to clear the CurrentInput statement.MySQL>

3.RDS database Export SQL File command, enter directly in the Linux command window

Mysqldump--databases < database name >--single-transaction--hex-blob--set-gtid-purged=
OFF--no-create-info--skip-triggers-u < database user name >-p-h < database RDS Intranet address >-P <rds Database port >-r < generated file path >

Day Wing Cloud RDS database operation