Dedicated Server How to Limit MySQL Usage for Users

Dedicated Server How to Limit MySQL Usage for Users MySQL permits limits on dedicated server for individual database user accounts for the following: Limit Description MAX_QUERIES_PER_HOUR an integer representing the ...

Continue Reading

Dedicated Server How to Reinstall MySQL

Dedicated Server How to Reinstall MySQL Before doing anything We recommend you make full DA backups on your dedicated server for easy restore, and CustomBuild mysql backups, just in case. ...

Continue Reading

Dedicated Server How to transfer a database from one user to another

Dedicated Server How to transfer a database from one user to another This guide will outline the method to transfer a database from one User account to another on your ...

Continue Reading

Dedicated Server How to Optimize MySQL

Dedicated Server How to Optimize MySQL IMPORTANT Always make full backups of all of your databases before making any changes to your dedicated server my.cnf. Avoid changes to your InnoDB ...

Continue Reading

Dedicated Server How to track MySQL Load

Dedicated Server How to track MySQL Load If you notice that the MySQL processes on dedicated server are using a lot of CPU load, there is a way to see ...

Continue Reading

Dedicated Server Repair MySQL Tables

Dedicated Server Repair MySQL Tables If your dedicated server MySQL has crashed or MySQL tables have been corrupted somehow, there are few methods you can use to try and restore ...

Continue Reading

Dedicated Server Converting from MySQL 5.5 to MariaDB 5.5

Dedicated Server Converting from MySQL 5.5 to MariaDB 5.5   If you’re running MySQL 5.5 and wish to convert to MariaDB 5.5 (which then allows a higher MariaDB later on), ...

Continue Reading

Dedicated Server Connect to MySQL database from a remote connection

Dedicated Server Connect to MySQL database from a remote connection.   If you have a MySQL database with your hosting account and need to connect to it from your home ...

Continue Reading

Upgrade MariaDB on Dedicated Server with CustomBuild 2.0

Dedicated Server Upgrade MariaDB with CustomBuild 2.0 To upgrade mariadb using the CustomBuild script, adjust the following commands to the desired database type and version: cd /usr/local/directadmin/custombuild ./build set mysql_backup ...

Continue Reading

Upgrade MySQL on Dedicated Server with CustomBuild 2.0

Dedicated Server Upgrade MySQL with CustomBuild 2.0 To upgrade mysql using the CustomBuild script, adjust the following commands to the desired database type and version: cd /usr/local/directadmin/custombuild ./build set mysql_backup ...

Continue Reading