Articles

 Convert Database ENGINE from InnoDB to MyISAM

 Database Automatic backup Shell script

 Errors create/write to file in /tmp (Errcode: 13)

Some services (like MySQL) aren’t starting on reboots. You get errors create/write to file in...

 How to Install Perl DBD::MySQL

This problem may occured when trying to install the perl-DBD-MySQL. It is found out the problem...

 How to change the MYSQL root password

 How to increase upload size for mysql database

We can increase the Upload Size for MySQL Database on cPanel with phpMyAdmin using WHM. The best...

 How to repair corrupted mysql database

Sometimes it happens that your database get corrupted due to many reason like it does not get...

 MySQL downgrade on cPanel server

You know downgrades are not recommended, it’s always best to stick with a newer version and work...

 Recover InnoDB table Corruption

 Replace MySQL with MariaDB in cPanel

MariaDB strives to be the logical choice for database professionals looking for a robust,...

 Replace MySQL with Percona in cPanel Server

 SQL safe mode in effect errors

Sql.safe mode Errors If you have any mysql connection errors and received error with cpanel user...

 Stats and Monitoring Process tool

Mysqlmymonlite Stats and Monitoring process free tool, Bash shell script tool used to gather...

 Test MySQL database connection with php script

You can use the following php script which is used to test mysql database connection on your...

 cPanel Log file locations

cPanel log file locations and Basic troubleshooting, most activity that happens on a server to...

 increase max_connections for a particular database

Max user connection for a database can be increased by following query mysql > GRANT ALL ON...

 increase max_connections for a particular database

Powered by WHMCompleteSolution