Solved

MySQL DB vs MARIA DB compatibility for PHP and Wordpress

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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Developers of all skill levels should learn to use current best practices when developing websites. However many developers, new and old, fall into the trap of using deprecated features because this is what so many tutorials and books tell them to u…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
The purpose of this video is to demonstrate how to manually back up a WordPress Database. This will be demonstrated using a Windows 8 PC. The Host used will be IPage.com Log into your Hosting account. IPage will be used for demonstration : Locat…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

821 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