Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

MySQL DB vs MARIA DB compatibility for PHP and Wordpress

Posted on 2016-10-13
2
Medium Priority
?
999 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
1 Comment
 
LVL 84

Accepted Solution

by:
Dave Baldwin earned 2000 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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
Originally, this post was published on Monitis Blog, you can check it here . In business circles, we sometimes hear that today is the “age of the customer.” And so it is. Thanks to the enormous advances over the past few years in consumer techno…
The purpose of this video is to demonstrate how to set up an RSS Feed on a WordPress Website. This will be demonstrated using a Windows 8 PC. Feedburner will be used for this demonstration. Go to your WordPress login page. This will look like the…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
Suggested Courses

879 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