MySQL dump import into MariaDB syntax error to use near '*/'
This is the result from mysqldump 10.13 and MySQL 8.0.28 Server.
/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` int(11) DEFAULT NULL COMMENT 'user name', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='User table';
/!50003 CREATE/ /!50017 DEFINER=
%/ /*!50003 TRIGGER
user_triggerAFTER INSERT ON
userFOR EACH ROW
INSERT INTO user_language(user_id, language_id) VALUES (1,1); */;;
If I try to import this piece with
mysql < dump.sqlinto a MariaDB 10.6.7, it results into
ERROR 1064 (42000) at line 9: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '*/' at line 1
I would appreciate any info on why this is happening and how to avoid it.
There are significant differences in the
information_schemadatabases between 8.0 and MariaDB. Avoid trying to move any data either direction. (Ditto for