Skip to Main Content

MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

mysqlbackup use --host backup on remote node:Mismatch found in innodb_page_size.

User_HPPAEMay 25 2016 — edited Jul 14 2016

node1(IP:10.1.173.151) Mysql Database Server install mysql database;

node2 (IP:10.1.173.152) Mysql Backup Server  install mysqlbackup;

On node2 backup node1'date ,command like this:

mysqlbackup --user=root --password=abc123 --backup-dir=/backup/bk1 --host=10.1.173.151 --port=3307 backup-and-apply-log

appear error like this:

mysqlbackup: ERROR: innodb_page_size obtained from innodb file header 0 is not matching with innodb_page_size 16384 which is read from backup configurations.

mysqlbackup: ERROR: Mismatch found in innodb_page_size.

mysqlbackup failed with errors!

Use  mysqlbackup --user=root --password=abc123 --backup-dir=/backup/bk`date +%M%S` --host=10.1.173.151 --port=3307 backup-and-apply-log

it comes The same errors;

mysqlbackup: ERROR: innodb_page_size obtained from innodb file header 0 is not matching with innodb_page_size 16384 which is read from backup configurations.

mysqlbackup: ERROR: Mismatch found in innodb_page_size.

mysqlbackup failed with errors!

what should i do? does mysqlbackup support remote server node backup?

Comments

Post Details

Added on May 25 2016
1 comment
801 views