Home » Databases
cPanelTips MYSQL Tutorials are the most easy to use and well explained MySQL tutorials around. You will find simple and practical step by step guides based in our sysadmin and developer experience. Let us teach you how to tweak your MYSQL Server Security and Performance.
MySQL Problem: Column count of mysql.proc is wrong. Expected 20, found 16. The table is probably corrupted. That was the error seen on the MYSQL shell when I was about to generate a MySQL dump . It simplydenied…Read More »
On the nixcp.com server the other day I found something weird when I was about to grant MySQL privileges to a new MySQL user. When I ran the SQL query, an error appeared on the screen: ERROR 1805 (HY000):…Read More »
Exploring the MySQL error log file on a cPanel server I found this odd message: Could not increase number of max_open_files to more than 12000. This was happening on a CentOS 7 + cPanel + CloudLInux server. What is…Read More »
Days ago one of our customers with a very large InnoDB database was having a strange error while trying to restart MySQL server. So our tech team started investigating and found it was caused due to the very big…Read More »
On this post we will explore the best way to generate a full MYSQL backup of all your databases inside a Linux server. This is useful for most Linux distributions such as CentOS/RHEL, Ubuntu/Debian, and of course it’s…Read More »