从阿里rds导出数据库和导入自建数据库的步骤

1. 根据rds选择好安装的版本
2  卸载原有的数据库
rpm -qa | grep mysql
根据上面查询的结果运行下一行的命令
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  下载安装包
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  安装

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、 修改配置文件、初始化Mysql
　　5.1、修改配置文件路径到etc目录，命令：
 cp /usr/share/mysql/my-default.cnf /etc/my.cnf
　　5.２、初始化Mysql ，命令：
/usr/bin/mysql_install_db

6 、查看mysql服务是否已经启动，若没有启动，则启动mysql：
ps -ef|grep mysql
netstat -anpt|grep 3306
service mysql start
7 因为Mysql安装好后的初始默认密码是一个随机密码，我们可能需要修改成我们自己设置的密码：
　　查询默认密码命令：
more /root/.mysql_secret　　
看到初始密码后，使用mysql -uroot -pj3R5qTNxrKsxnQTj 命令登录Mysql：（j3R5qTNxrKsxnQTj即为笔者查到的初始密码）
set password = password('123456');
8  修改Mysql服务开机时自动启动（不需要则略过）
chkconfig mysql on;
chkconfig mysql --list;
设置远程root访问权限

GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.7.%' IDENTIFIED BY 'xxxx' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.0.40.%' IDENTIFIED BY 'xxxx' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.0.41.%' IDENTIFIED BY 'xxxx' WITH GRANT OPTION;

flush privileges;

9  在网站https://www.percona.com/downloads/XtraBackup/LATEST/ 下载相应的下版本percona-xtrabackup-2.2.10-1.el6.x86_64.rpm

10 进行安装和相应的依赖包
yum -y install perl perl-devel libaio libaio-devel perl-Time-HiRes perl-DBD-MySQL
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  根据阿里云 https://help.aliyun.com/knowledge_detail/41817.html 提示进行恢复。