Lock wait timeout exceeded; try restarting transaction error while import or transfer

Trying to import or transfer dev strapi to production server, getting the same error
Removing assets fixes the issue but how can I do actual import with all the data including assets
Tried to increase innodb_lock_wait_timeout in mysql server, no result
Tried to increase acquireConnectionTimeout strapi db config, no result
strapi v: 4.22.1
db: mysql 8

This topic has been created from a Discord post (1227216974271090760) to give it more visibility.
It will be on Read-Only mode here.
Join the conversation on Discord