From Ali RDS Export the database and import the self-built database steps __ Database

1. Choose a good installation version based on RDS
2 Uninstall the original database
Rpm-qa | grep MySQL
Run the command on the next line based on the results of the above query
Rpm-ev--nodeps XXXXX
Yum Remove Mysql-server mysql-devel rm–rf/usr/my.cnf
Rm-rf/root/.mysql_sercret
Rm-rf/etc/my.cnf
Rm-rf/var/lib/mysql 3 Download installation package
wget http://dev.mysql.com/Downloads/MySQL-5.6/MySQL-server-5.6.21-1.rhel5.x86_64.rpm
wget http://dev.mysql.com/Downloads/MySQL-5.6/MySQL-devel-5.6.21-1.rhel5.x86_64.rpm
wget http://dev.mysql.com/Downloads/MySQL-5.6/MySQL-client-5.6.21-1.rhel5.x86_64.rpm
4 Installation RPM-IVH mysql-server-5.6.21-1.rhel5.x86_64.rpm
RPM-IVH mysql-client-5.6.21-1.rhel5.x86_64.rpm
RPM-IVH mysql-devel-5.6.21-1.rhel5.x86_64.rpm
5, modify the configuration file, initialize MySQL
5.1, modify the configuration file path to the ETC directory, command:
Cp/usr/share/mysql/my-default.cnf/etc/my.cnf
5.2, initialization of MySQL, command:
/usr/bin/mysql_install_db 6, to see if the MySQL service has been started, if not started, then start MySQL:
Ps-ef|grep MySQL
Netstat-anpt|grep 3306
Service MySQL Start
7 because MySQL installed the initial default password is a random password, we may need to modify to our own set of password:
Query default password command:
More/root/.mysql_secret
After you see the initial password, use the MYSQL-UROOT-PJ3R5QTNXRKSXNQTJ command to login to MySQL: (J3R5QTNXRKSXNQTJ is the original password I found)
Set password = password (' 123456 ');
8 Modify the MySQL service boot automatically start (do not need to skip)
Chkconfig MySQL on;
Chkconfig MySQL--list;
Set remote root access permission GRANT all privileges on *.* to ' root ' @ ' 192.168.7.% ' identified by ' xxxx ' with GRANT OPTION;
Grant all privileges in *.* to ' root ' @ ' 10.0.40.% ' identified by ' xxxx ' with GRANT OPTION;
Grant all privileges in *.* to ' root ' @ ' 10.0.41.% ' identified by ' xxxx ' with GRANT OPTION; Flush privileges; 9 in the website https://www.percona.com/downloads/XtraBackup/LATEST/download the corresponding version percona-xtrabackup-2.2.10-1.el6.x86_64.rpm 10 To install and the corresponding dependency pack
Yum-y Install Perl perl-devel Libaio libaio-devel Perl-time-hires
wget ftp://rpmfind.net/linux/dag/redhat/el6/en/x86_64/dag/RPMS/libev-4.15-1.el6.rf.x86_64.rpm
RPM-IVH libev-4.15-1.el6.rf.x86_64.rpm
Rpm-hiv percona-xtrabackup-24-2.4.9-1.el6.x86_64.rpm 11 According to Aliyun https://help.aliyun.com/knowledge_detail/41817.html Prompt for recovery.