Solved

MySQL DB vs MARIA DB compatibility for PHP and Wordpress

Posted on 2016-10-13
2
109 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
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Build an array called $myWeek which will hold the array elements Today, Yesterday and then builds up the rest of the week by the name of the day going back 1 week.   (CODE) (CODE) Then you just need to pass your date to the function. If i…
This article discusses four methods for overlaying images in a container on a web page
This video teaches users how to migrate an existing Wordpress website to a new domain.
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…

864 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now