# want to refresh EC2 server MySQL DB with AWS RDS DB, facing issues

**URL:** <https://forums.percona.com/t/want-to-refresh-ec2-server-mysql-db-with-aws-rds-db-facing-issues/6432>\
**Category:** Percona XtraBackup\
**Created:** [June 27, 2018, 5:00am UTC](https://forums.percona.com/t/want-to-refresh-ec2-server-mysql-db-with-aws-rds-db-facing-issues/6432 "2018-06-27T05:00:56Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![sivakrishna](https://avatars.discourse-cdn.com/v4/letter/s/c89c15/32.png) [@sivakrishna](https://forums.percona.com/u/sivakrishna)\
**Post date:** [June 27, 2018, 5:00am UTC](https://forums.percona.com/t/want-to-refresh-ec2-server-mysql-db-with-aws-rds-db-facing-issues/6432/1 "2018-06-27T05:00:56Z")

</div>

please provide steps with my.cnf file I’ve tried by giving some configuration but it not worked, to refresh my preprod db with prod rds db instance. kindly provide some process for that

my.cnf file

[client]  
user=xxx

password=ssxx

[host=xxxxxx.xx.rds.amazonaws.com](http://host=xxxxxx.xx.rds.amazonaws.com)

port=3306

databases=db1

[mysqld]

socket=/var/lib/mysql/mysql.sock

symbolic-links=0

collation-server = utf8\_unicode\_ci

init-connect=‘SET NAMES utf8’

character-set-server = utf8

#server\_id = 2

log\_bin = mysql-bin

expire\_logs\_days = 6

binlog\_format = ROW

max\_binlog\_size = 1024M

innodb\_strict\_mode = 0

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

max\_allowed\_packet = 1024M

show\_compatibility\_56 = ON

innodb\_data\_home\_dir = /rdsdbdata/db/innodb

innodb\_data\_file\_path = ibdata1:12M:autoextend

innodb\_log\_group\_home\_dir = /rdsdbdata/log/innodb

innodb\_log\_files\_in\_group = 2

innodb\_log\_file\_size = 0

innodb\_buffer\_pool\_size = 12G

innodb\_log\_buffer\_size = 256M

innodb\_log\_file\_size = 1G

innodb\_write\_io\_threads = 16

innodb\_flush\_log\_at\_trx\_commit = 0

innodb\_force\_recovery = 1

#Below lines to enable crash safe replication for more info visit [url][https://www.percona.com/blog/2013/09/13/enabling-crash-safe-slaves-with-mysql-5-6/[/url]](https://www.percona.com/blog/2013/09/13/enabling-crash-safe-slaves-with-mysql-5-6/%5B/url%5D)

relay\_log\_info\_repository = TABLE

master\_info\_repository = TABLE

relay\_log\_recovery = ON

skip-character-set-client-handshake

max\_execution\_time = 3000000

====EOF

Getting the below error:

xtrabackup: using the following InnoDB configuration:

xtrabackup: innodb\_data\_home\_dir = /rdsdbdata/db/innodb

xtrabackup: innodb\_data\_file\_path = ibdata1:12M:autoextend

xtrabackup: innodb\_log\_group\_home\_dir = /rdsdbdata/log/innodb

xtrabackup: innodb\_log\_files\_in\_group = 2

xtrabackup: innodb\_log\_file\_size = 1073741824

InnoDB: Number of pools: 1

InnoDB: Error: log file /rdsdbdata/log/innodb/ib\_logfile0 is of different size 0 bytes

InnoDB: than specified in the .cnf file 1073741824 bytes!