I've read several of the related topics posted here, but I have not been able to avoid this innodb error.
The steps I've taken to replicate data from a Slackware server - 5.5.27-log (S) to a FreeBSD slave - 5.5.21-log (F) were these:
flush tables with read lock;
- (S) in another terminal
show master status;
- (S) stop mysqld via command line in third terminal;
- (F) while both servers are stopped,
rsyncmysql datadir from (S), excluding master.info, mysql-bin and relay-* files; Also tried
rsyncof all files;
- (F) start mysqld (skip-slave)
121018 12:03:29 InnoDB: Error: page 7 log sequence number 456388912904 InnoDB: is in the future! Current system log sequence number 453905468629. InnoDB: Your database may be corrupt or you may have copied the InnoDB InnoDB: tablespace but not the InnoDB log files. See InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html InnoDB: for more information.
This kind of error happens for a lot of tables.
I know I can use
dump, but the database is large, ca. 70GB and the systems are slow (old), so would like to get this replication to work with data transfer.
What should I try to solve this issue?