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

问题描述

我正在开发一个小型社交网络(只是为了打发我的空闲时间)，我从一个 Maria 数据库开始.但是我遇到了一些问题(长篇大论)，所以我将其更改为 MySQL 数据库.但在此之后，我无法将值插入到某些表中(例如，使用 Maria 我将值插入到消息"表中没有问题，现在当我拥有 MySQL 时，它不会将值插入到该表中).

我不太了解这两个数据库之间的差异.这可能是它不起作用的原因 - 从 Maria 更改为 MySQL?Maria是否有可能支持" MySQL不支持的东西?我没有收到任何错误，它只是没有向表中插入值.

解决方案

阅读此链接

选择目的地

ESF 数据库迁移工具包(http://www.easyfrom.net/):这个工具包非常重要减少迁移到/从以下任何数据库/文件系统迁移的工作量、成本和风险: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 并将任何 ODBC DSN 数据源传输给它们.

阅读:https://www.easyfrom.net/articles/mariadb_to_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.

Read this: https://www.easyfrom.net/articles/mariadb_to_mysql/

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