Home » Tag Archives: mysql

Tag Archives: mysql

How to install Mytop 1.9.1 on Cpanel

MyTop is one of the best MySQL monitoring tools available, written by a MySQL guru, Jeremy Zawodny. Its vital for monitoring your MySQL health, especially in a shared hosting environment. Installation on a CentOS (for cPanel) server is quite straight forward with this guide. First off, we need a few perl modules, cPanel’s realperlinstaller comes in handy, if you aren’t on …

Read More »

Migrate from Mysql to MariaDB in cPanel/WHM

MariaDB is “An enhanced, drop-in replacement for MySQL”. Below you will find some steps on how to affectively stop cPanel/WHM from maintaining MySQL and begin utilizing MariaDB for any and all database activity on your server but please note that, cPanel/WHM no longer maintains MySQL on your system it is on the Systems Administrator to manage and maintain any updates …

Read More »

Backup and Restore MySQL Database Using mysqldump

mysqldump is an effective tool to backup MySQL database. It creates a *.sql file withDROP table, CREATE table and INSERT intosql-statements of the source database. To restore the database,  execute the *.sql file on destination database. Using mysqldump, you can backup a local database and restore it on a remote database at the same time, using a single command. In …

Read More »