export mariadb 10 dump to mysql 5.5
mariadb, mysql
Solution
Use `mysqldump --compatible=ansi --all-databases` to export in ansi mode.
Problem
Is there a way to use mysqldump or something similar to create an all-databases dump from a mariadb 10 server that will import into a mysql 5.5 server flawlessly? Currently I run into some problems with the dump because of mariadb-only features. Thank You