SQL dump cannot be imported into Shopware 6: The value specified for generated column … in table … is not allowed

When importing a Shopware 6 into another system, e.g when migrating the instance to another server it may happen that you get the following error:

The value specified for generated column … in table … is not allowed

This typically occurs when trying to import a MariaDB dump into a MySQL database as they differ slightly in syntax. The simple but not obvious solution is to export the dump with MySQL client instead of the MariaDB client. If the mysql client is not installed, simply use docker with a mysql-client image:

docker run --network host -it --rm joseluisq/mysql-client mysqldump --hex-blob -h 127.0.0.1 -u root -proot -P 31006 shopware

Now the import should go smoothly!