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 »
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 »
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 »
Linux Tips, Hacks, Tricks, and Tutorials for Beginners | ServerNoobs A Beginners Guide to Server Management