Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

export mariadb 10 dump to mysql 5.5

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

like image 937
Catscrash Avatar asked Dec 25 '22 01:12

Catscrash


1 Answers

Use mysqldump --compatible=ansi --all-databases to export in ansi mode.

like image 113
Julian Ladisch Avatar answered Jan 01 '23 14:01

Julian Ladisch