Forum Stats

  • 3,853,829 Users
  • 2,264,280 Discussions
  • 7,905,459 Comments

Discussions

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

User_HPPAE
User_HPPAE Member Posts: 1 Blue Ribbon
edited Jul 14, 2016 9:10AM in MySQL Community Space

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?

Answers