cPanel KnowledgeBase and Troubleshooting, cPanel Server Fixes and Tutorials

We can backup our databases using different methods, Here is the shell script used for automatic backup MySQL databases using mysqldump in your cpanel server. The following instruction can be used to backup any database. The only requirement is that you are using a Linux server to host your files and mysql user privileges. Use this Database Automatic […]

InnoDB force Recovery, There are many reasons available to get database corrupted. Make sure that you maintain a good backup schedule by running a cpanel backup in case of serious corruption or data loss issue or refer with Mysql knowledgebase. InnoDB corruption can cause all of the databases running on that server to be inaccessible. […]

MySQL Performance Tuning Shell Script, This script takes information from “SHOW STATUS LIKE…” and “SHOW VARIABLES LIKE…” then attempts to produce sane recommendations for tuning server variables. It is compatible with all versions of MySQL 3.23 and above. In your huge traffic cPanel server you can use the following MySQL performance tuning script to optimize […]

We can use various methods to change database engine. In order to convert Database ENGINE from InnoDB to MyISAM use the following methods and shell scripts. First you should take all the databases backup. root@serv [~]#mysqldump DBname > DBBacupname.sql Method : 1 Once you secure the Database you may create a file called DBlist.txt and […]

Mysqlmymonlite Stats and Monitoring process free tool, Bash shell script tool used to gather stats for Apache, Nginx, litespeed web server and MySQL servers. Useful for troubleshooting & diagnostics and monitoring of server stats. mysqlmymonlite.sh is a MySQL optimization tool – a lite version of more extensive featured mysqlmymon.sh – a MySQL and system monitoring […]

Sql.safe mode Errors If you have any mysql connection errors and received error with cpanel user name authentication errors. If sql.safe_mode is enabled, mysql_connect() and mysql_pconnect() ignore any arguments passed to them. Instead, PHP attempts to connect using the following details: host: local host user: the user PHP runs as password: an empty string (“”) […]