There's master mysql running 5.6.30. Engine InnoDB.
innodb_file_per_table is used. Slave server is running 5.5.55
Doing next steps:
- (on master) innobackupex --no-timestamp /path/to/backup - (on master) innobackupex --apply-log - (on slave) /etc/init.d/mysql stop; clearing /var/lib/mysql - (on master) rsync -avpP /path/to/backup slave:/var/lib/mysql - (on slave) chown -R mysql:mysql /var/lib/mysql - (on slave) /etc/init.d/mysql start - doing other steps to enable Master-Slave replication...
Doing this steps on other servers, where no
innodb_file_per_table is used, works ok: database successfully copied and replication sets up and works.
But with "multiple .ibd" starting mysql on slave fails with error in corrupted tables. So something I'm doing wrong. But what? Wrong export-import? Slave has to be not older than master? Something else?
170430 21:51:05 InnoDB: 5.5.55 started; log sequence number 3110007332942
170430 21:51:05 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
170430 21:51:05 [Note] - '0.0.0.0' resolves to '0.0.0.0';
170430 21:51:05 [Note] Server socket created on IP: '0.0.0.0'.
170430 21:51:05 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist