MySQL

How to clear eximstatus database entries

Tags: cPaneleximeximstatsMySQL

Published on : April 12, 2017 by

How to clear eximstatus database entries

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 […]

Continue Reading...


PHP script to Change MySQL Table Prefix

Tags: MySQLphpTable

Published on : April 4, 2016 by

PHP script to Change MySQL Table Prefix

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 […]

Continue Reading...


CloudLinux : PHP Selector – missing the MySQL extension

Tags: CageFSCloudLinuxMySQLPHP selector

Published on : August 9, 2015 by

CloudLinux : PHP Selector – missing the MySQL extension

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 […]

Continue Reading...


How to create MySQL user and database from command line of a cPanel server

Tags: cPanelhackMySQL

Published on : June 2, 2015 by

How to create MySQL user and database from command line of a cPanel server

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 […]

Continue Reading...


R1Soft MySQL Database restore :MySQLD executable not found!

Tags: databasesMySQLD executable not foundR1soft restore

Published on : September 29, 2014 by

R1Soft MySQL Database restore :MySQLD executable not found!

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, […]

Continue Reading...


Let's Connect

Get new updates

Categories

$0.000 items