Tagged: MySQL

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...

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 enhancements,...

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...

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 href=”Documentation.html#faqmysql” target=”documentation”><img src=”themes/dot.gif” title=”Documentation” alt=”Documentation” /></a> I had run “yum install php-mysqli” with success,...

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 be hosting...