29 October 2012

MySQL errors: Error 'Unknown table engine 'InnoDB'' on query.

Again, while playing with Percona MySQL and their backup tool xtrabackup, I noticed the following error:
Error 'Unknown table engine 'InnoDB'' on query. Default database: 'database_name'. Query: 'sql_query'
The solution is very easy. I always have to check on master and slave the innodb_log_file_size option. It should be the same. Then restart the slave mysql and it should work.

No comments:

Post a Comment