Published on : April 12, 2017 by Manu M.
Hello, This post is about truncating eximstats database. The scenario is considered when the database size increase to large size. This can occur due to high mail queue or spam issues. If your eximstats database has gotten pretty large, chances are you have a spam issue and may want to check your /var/log/exim_mainlog log to […]
Published on : April 4, 2016 by Afsal
When installing applications like Magento, WordPress, etc, there will be an option to specify a MySQL table prefix which is to be used with the application’s MySQL database. This prefix will be added to all the tables in the application’s database. Adding such a prefix increases the security of the application as it is a […]
Published on : August 9, 2015 by Maddy Mattocks
We came across the following error message on all sites, hosted on a server configured with cPanel, CloudLinux PHP Selector (CL Selector) and Percona as DBMS. Issue was happening on only one server and not on others though. Some sites showed the error message of inability to load “pdo_mysql” and further investigations revealed that other […]
Published on : June 2, 2015 by Arnold Pablo
cPanel has made everyone’s life easy. But a few sysadmins won’t get the kick of “IT” when they work on a cPanel server. cPanel is fun and is defining professionalism in their support, Paper lantern UI and in every other area, I can think of, as each day passes. The MySQL create user and create […]
Published on : September 29, 2014 by Mithun S.
Some times you might get any error on R1Soft MySQL restore like, “Error restoring MySQL database – MySQLD executable not found!” Here we are going to see an alternative to restore a database from R1Soft backup from command line when the restoration from GUI fails. How it works: When we start an R1Soft MySQL restore, […]