MariaDB Master-Slave Replication in CentOS/RHEL 8 with Multiple Databases
Master-Slave Replication Database replication is an inevitable feature for those who want to prevent data loss. The termRead More…
Category Archives: Mysql
25Jul/20
Different cPanel Backup Settings
Different cPanel Backup Settings in a cPanel server In the web hosting space, cPanel is the most common and user-friendly control panel. It provides a graphical interface to the customers so that they can handle andRead More…
26May/20
How to repair MySQL databases and tables on LINUX servers
In this blog, we would like to give you some useful insights on how to repair MySQL database and table. This is probably one of the most common, yet cumbersome aspects you may have to dealRead More…
Error : The adminbin “cpmysql” in the “Cpanel” namespace call to function “DBCACHE” ended prematurely: The subprocess reported the “” (255) error when it ended
This error was there in user’s cpanel section and no database, no db users etc were showing in the cpanel for the users. On checking the /varlib/mysql/server.domain.com.err (mysql error log) I can see the mysql userRead More…
Change the Max File Upload Size for PhpMyAdmin in Plesk
In some cases, we need to restore big databases using phpmyadmin. In that cases, we need to increase the upload limit in phpmyadmin to accomplish this. Change the values (to the required value) “upload_max_filesize” & “post_max_size” in theRead More…
[ERROR] /usr/sbin/mysqld: Can’t open file
I got this error while migrating huge amount of accounts from one cpanel server to another. [ERROR] /usr/sbin/mysqld: Can’t open file: ‘./dbname/tablename.frm’ (errno: 24) errno: 24 means there is too many open files. There isRead More…