01Technology
MySQL / MariaDB Backup & Archive Script
I am using MariaDB - the open source version of MySQL - and wanted an easy way to backup my databases on a regular schedule without having to do anything when I created or…
March 18, 2016
MySQL
Articles
5 stories
02Technology
Upgrade From MySQL to MariaDB on CentOS
Here is how you upgrade from MySQL 5.5+ to MariaDB 5.5, 5.6 or 10.0. After running MySQL 5.5 for a while and getting tired of not taking advantage of the features and performance…
April 22, 2014
03Technology
Convert From MyISAM to InnoDB Engine
If you ever have the need to convert a MySQL (or MariaDB) table from the MyISAM engine to the InnoDB engine, you can use the following script to get it done for an entire…
April 22, 2014
04Linux
phpMyAdmin + CentOS + Apache Worker MPM
After installing phpMyAdmin I kept getting the above error which reads: The mysqli extension is missing. Please check your PHP configuration. <a…
June 24, 2012
05Linux
Trac 0.12.3 + MySQL + Apache + Subversion on CentOS 5.5
The documentation for Trac is decent, but it isn't super clear what to do, especially if you aren't familiar with python. Some quick random info: For this example we are going to…
May 15, 2012