Master-Slave Replication Database replication is an inevitable feature for those who want to prevent data loss. The term ‘Replication’ refers to making copy on precious data. Many companies spend up to millions of dollars to have it … Read more
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 and control their Linux hosting servers easily via browsers. cPanel also gives data safety through their whole account backup feature. … Read more
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 deal with on a regular basis. As you are aware the MySQL database is updated from time by time. MySQL … Read more
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 user table was corrupted and needed repair 141204 12:13:56 [ERROR] /usr/sbin/mysqld: Table ‘./mysql/user’ is marked as crashed and should be … Read more
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 the file “/usr/local/psa/admin/conf/php.ini” And restart the apache, here plesk service providing the apache for phpmyadmin, so restart psa. /etc/init.d/psa stop … Read more
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 is a mysql variable named “open_files_limit" which shows how many open files are allowed in mysql by default. We cannot update this valuse using “Set” command as this variable is a read only variable.