Auto database converter

Is there some tool/program out there that we can use to convert MariaDB to MySQL (and the other way around) instead of manually reviewing and editing the file to fix up syntax errors?

---

I have little hope for such a tool but it doesn't hurt to ask. Could save me so much time.

 

MySQL data. That's exactly what I did and it was throwing a bunch of syntax errors. I couldn't import the sql file into a new database. I had to use a text editor to manually update some things to fix the issues.

 

"ERROR ???? (??????): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use"

Import was always failing until the issues were fixed. Dump was made from command line.

 

Dump: mysqldump -u user -p -h localhost dbname > /path-to/database.sql
Import: mysql -u user -p dbname < /path-to/database.sql

There were a bunch.

One was something like (can't remember if the numbers are the same) :

ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''
Can't really remember how I fixed this one.

The top of the SQL file just had information about the database name, MariaDB version, etc.

Another was like (I just copy/pasted the number from the error above) :

ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use near ''Some-text-in-the-database'
^ This one I never solved.

Another had something like the below at the top and bottom of some table table (I think it was table data):

Code (Text):

/*!40101 SET character_set_client = utf8 */;

The bottom part had to change to "utf8" to be fixed. The top part already had it.

Another one that I encountered long long ago was related to InnoDB. I had to run an SQL query to mass find specific data to manually remove so that the database import could work.

 

It worked fine when importing into a database running on the same MariaDB version of the MariaDB database I exported. I think it was MySQL 5.5 (I know for certain it wasn't 5.6 because I ended up upgrading to that version). It was an xenForo database. The InnoDB one might have been Wordpress and/or xenForo.

I'm no longer trying to import the database btw. Just looking for a simple way (if it's possible) to convert in the future.