mariadb迁移到mysql,从MariaDB迁移到MySQL-差异

I am working on a small social network (just to fill my free time) and I started with a Maria database. But I had some problems with it (long story) so I changed it to a MySQL database. But after this, I am not able to insert values into some tables (for example with Maria I inserted values to "messages" table with no problem and now when I have MySQL it won´t insert values to this table).

I don´t know very much about the differences between those two databases.

Can this be the reason why it is not working - change from Maria to MySQL?

Is it possible that Maria "supports" something that MySQL does not?

I don´t get any errors, it just does not insert values to the table.

解决方案

Read this link https://mariadb.com/kb/en/library/mariadb-vs-mysql-compatibility/ which discusses in detail the compatibility issues between various versions of MariaDB and MySQL:

And there was a toolkit called ESF Database Migration Toolkit

Choose a Data Source

Choose a Destination

ESF Database Migration Toolkit ( http://www.easyfrom.net/ ): This toolkit dramatically cuts the effort, cost, and risk of migrating to/from any of the following database/file systems: Oracle, MySQL, SQL Server, PostgreSQL, IBM DB2, IBM Informix, InterSystems Caché, Teradata, Visual Foxpro, SQLite, FireBird, InterBase, Microsoft Access, Microsoft Excel, Paradox, Lotus, dBase, CSV/Text and transfer any ODBC DSN data source to them.