Converting mysql tables engines

Sometimes you may need to convert your mysql table engines. One of the most common reason to convert tables to InnoDB is for better reliability and scalability Quick Links: Viewing Table Engines Viewing Active Engines Alter Table Command Viewing Current Table Engines To view your current mysql engines use the following command: SELECT TABLE_NAME, ENGINE […]

Mariadb

Mariadb is very similar to mysql, its uses the same syntax and commands. The main difference between them both is when it comes to database replication, this is something that wont be covered on here for a while. Quick Links: Adding the Mariadb Repository Installing Mariadb Installing Mariadb PHP plugin   Mysql was previously fully […]

phpmyadmin

Quick Links: Installing phpMyAdmin in ubuntu (apache) Installing phpMyAdmin in Centos (apache)     Installing phpmyadmin with apache: Ubuntu: apt-get install -y phpmyadmin && echo Include /etc/phpmyadmin/apache.conf >> /etc/apache2/apache2.conf && service apache2 restart   CentOS: ¬†yum install phpmyadmin Then edit: /etc/httpd/conf/httpd.conf Example: vim /etc/httpd/conf/httpd.conf Add the following to the bottom of the file: <Directory “/usr/share/phpMyAdmin”> […]