aliyun RDS for MySQL 备份文件恢复到自建数据库

2019独角兽企业重金招聘Python工程师标准>>>

https://help.aliyun.com/knowledge_detail/41817.html

//恢复aliyun RDS数据库
bash rds_backup_extract.sh -f /srv/db/hins2686859_data_20170702023426.tar.gz -C /srv/db/hins2686859_data_20170702023426innobackupex --defaults-file=/srv/db/hins2686859_data_20170702023426/backup-my.cnf --apply-log /srv/db/hins2686859_data_20170702023426chown -R mysql:mysql /srv/db/hins2686859_data_20170702023426mysqld_safe --defaults-file=/srv/db/hins2686859_data_20170701023427/backup-my.cnf --user=mysql --datadir=/srv/db/hins2686859_data_20170701023427 &mysqld_safe --defaults-file=/srv/db/hins2686859_data_20170702023426/backup-my.cnf --user=mysql --datadir=/srv/db/hins2686859_data_20170702023426 &mysqladmin -uroot -p shutdownupdate user set host='%' where user = 'root' and host='localhost';

 hins2686859_data_20170702023426/backup-my.cnf

# This MySQL options file was generated by innobackupex.# The MySQL server
[mysqld]
innodb_checksum_algorithm=innodb
#innodb_log_checksum_algorithm=innodb
innodb_data_file_path=ibdata1:200M:autoextend
innodb_log_files_in_group=2
innodb_log_file_size=1572864000
#innodb_fast_checksum=false
#innodb_page_size=16384
#innodb_log_block_size=512
innodb_undo_directory=.
innodb_undo_tablespaces=0#rds_encrypt_data=false
#innodb_encrypt_algorithm=aes_128_ecbgeneral_log=0

转载于:https://my.oschina.net/bobchow/blog/1301830

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！