Facing Sql state error on data migration cmd "SQLSTATE[42000]: Syntax error or access violation: 1115 Unknown character set: 'utf8mb4'"

[adethnicinfotech-stack]

Steps to reproduce : On running Below command in Magento 2.4.8

• Run ./bin/magento migrate:data -r -a app/code/Magento/Migration/etc/opensource-to-opensource/1.9.2.4/config.xml
• Getting Below Error :

SQLSTATE[42000]: Syntax error or access violation: 1115 Unknown character set: 'utf8mb4', query was: CREATE TABLE IF NOT EXISTS m2_cl_catalog_compare_item (
catalog_compare_item_id int NOT NULL COMMENT 'Catalog_compare_item_id' ,
operation text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT 'Operation',
processed bool NOT NULL default 0 COMMENT 'Processed' ,
PRIMARY KEY (catalog_compare_item_id)
) COMMENT='m2_cl_catalog_compare_item' ENGINE=INNODB charset=utf8mb4 COLLATE=utf8mb4_general_ci

Solution I tried.

• Added the content below on map.xml file under document rule section of source as well as destination.
  <ignore> <document>m2_cl_catalog_compare_item</document> </ignore> <ignore> <document>catalog_compare_item</document> </ignore>
• Manually created table in db directly using same create query.

Still getting same error.
Can you please help me with this migration.

[m2-assistant]

Hi @adethnicinfotech-stack. Thank you for your report.
To speed up processing of this issue, make sure that you provided sufficient information.
Add a comment to assign the issue: @magento I am working on this

---

Join Magento Community Engineering Slack and ask your questions in #github channel.