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.
PHP Warning: mysqli_connect(): (HY000/2002): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) in sugarcrm/include/database/MysqliManager.php on line We have faced such an error with SugarCRM today. The above error was reporting in error_log file every time the cron.php is executed via cron job. We have taken a closer look and couldn’t find any real reason why … Read more