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 […]
Posts in the Databases category:
Percona DB
Perconadb Quick Links: Adding Perconadb Repo Installing Percona db 5.5/5.1 Securing db configuration Creating .my.cnf
Holland backup
Holland backup is a way to backup your mysql databases automatically using cronjobs (rather than manually using mysqldump). The following is a guide to install holland backup. Quick Links: Installing Holland backup on CentOS Creating .my.cnf file for holland Holland backup location Missing default.conf Testing Holland backup (manually)
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 […]
mysql / Mariadb commands
This guide will go through some mysql commands, these will also be relevant to Mariadb Quick Links: Deleting a user Changing the host of a user Changing a users password Granting user privileges mysql dump mysql secure copy (scp) Securing mysql Remotely accessing your db Finding out the size of a db or table […]
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”> […]