Destination server is not compatible with the data in the table error.

Created by Nigel J, Modified on Sun, 12 Apr, 2020 at 2:23 PM by Nigel J

During the migration to a different server, you might encounter an error similar to this:

"Destination server is not compatible with the data in www_options table"

"Destination server is not compatible with the data in table. The size of BLOB/TEXT data inserted in one transaction is greater than 10% of redo log size. Increase the redo log size using innodb_log_file_size."

This error is related to InnoDBRedoLogSize in the database of the destination site.

Please follow the following guide to increase the log size & number and retry the migration:

https://dev.mysql.com/doc/refman/5.7/en/innodb-redo-log.html

https://support.plesk.com/hc/en-us/articles/115001738733-How-to-change-the-innodb-log-file-size-value-in-MySQL-MariaDB

You may contact the support of the web host for help with fixing this issue.