Herr Bischoff


MariaDB 10 vs. mysqli

Today, while checking out the awesome TokuDB MySQL storage engine, I wanted to write a simple PHP script to convert my tables from InnoDB to TokuDB. Using mysqli as a connector, I ran the script and got the following error:

mysqli::mysqli(): Headers and client library minor version mismatch.

Googling helped. It turns out you need to use the php5-mysqlnd package instead of php5-mysql. Just run:

apt-get remove php5-mysql
apt-get install php5-mysqlnd

In fact, on my Debian Wheezy machine, all I had to run was apt-get remove php5-mysql and php5-mysqlnd was installed automatically. phpMyAdmin got uninstalled alongside it. Oh well, I was switching over to using blazingly fast Adminer anyhow. So it’s all for the better I guess.