Solved

MySQL DB vs MARIA DB compatibility for PHP and Wordpress

Posted on 2016-10-13
2
469 Views
Last Modified: 2016-11-03
My question ... Maria DB = MySQL DB?  (In terms of compatibility, aside from the whole Oracle/OpenSource/Original Authors story)
Details ...I just moved a Wordpress site and several PHP Scripts (unrelated to WP) from a web server (Linux/Apache) to a new web server (Linux/Apache).  I just found out that the new server is running Maria DB 5.5.47, whereas the old server was running MySQL DB 5.5.25.
I hit a couple of snags to get the WP site and a couple of the PHP Scripts running, so before I start posting error log results & specifics, I was wondering, in general, if anyone has had experience with Maria DB, if it should be a drop-in replacement for MySQL ... or if there is an incompatibility list of any SQL Statements that may need to be changed, etc.
0
Comment
Question by:bleggee
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 83

Accepted Solution

by:
Dave Baldwin earned 500 total points
ID: 41842979
There is no incompatibility between MariaDB and MySQL in the community editions that you will find on web site hosting.  There are premium versions of both that have additional features.  It is more likely that you are seeing differences in the PHP version?

I maintain a couple of ecommerce sites.  We moved two from hosting with MySQL to hosting that uses MariaDB and never even noticed.  When I download the tables from the site for backups, I upload them into a MySQL server without problems.

According to this page https://en.wikipedia.org/wiki/MariaDB ,  Maria DB 5.5.47 is an older version.  But then so is my MySQL version here.  The web hosting I use has version 10.
3

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating and Managing Databases with phpMyAdmin in cPanel.
Since pre-biblical times, humans have sought ways to keep secrets, and share the secrets selectively.  This article explores the ways PHP can be used to hide and encrypt information.
The purpose of this video is to demonstrate how to update a WordPress Site’s version. WordPress releases new versions of its software frequently and it is important to update frequently in order to keep your site secure, and to get new WordPress…
The purpose of this video is to demonstrate how to Import and export files in WordPress. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Click on Too…

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question