从MariaDB迁移到MySQL-差异 [英] Migrating from MariaDB to MySQL - differences

问题描述

我在一个小型社交网络上工作(只是为了填补我的空闲时间)，所以我开始使用Maria数据库.但是我对此有一些问题(长话不说)，所以我将其更改为MySQL数据库.但是在此之后，我将无法在某些表中插入值(例如，对于Maria，我毫无问题地将值插入到"messages"表中，现在当我使用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).

我对这两个数据库之间的差异了解不多. 这可能是它无法正常工作的原因-从Maria更改为MySQL吗? Maria是否有可能支持" MySQL不支持的内容? 我没有任何错误，只是没有在表中插入值.

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.

推荐答案

阅读此链接 https://mariadb.com/kb/en/library/mariadb-vs-mysql-compatibility/详细讨论了MariaDB和MySQL的各个版本之间的兼容性问题:

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:

有一个名为ESF Database Migration Toolkit

选择数据源

选择目的地

ESF数据库迁移工具包( http://www.easyfrom.net/):该工具包非常实用减少了从以下任何数据库/文件系统迁移的工作量，成本和风险:Oracle，MySQL，SQL Server，PostgreSQL，IBM DB2，IBM Informix，InterSystemsCaché，Teradata，Visual Foxpro，SQLite，FireBird，InterBase ，Microsoft Access，Microsoft Excel，Paradox，Lotus，dBase，CSV/文本，并将任何ODBC DSN数据源传输给它们.

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.

阅读此内容: https://www.easyfrom.net/articles/mariadb_to_mysql/

这篇关于从MariaDB迁移到MySQL-差异的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！