We do support Round the Clock 24 x 7 x 365 (+91) 883 012 3924
header-image

L3 Web Hosting Blog

cPanel, Plesk, Wordpress Hosting SSD disk

Check out L3WebHosting blog for tips and in-depth articles on web hosting services !!

How to upgrade mysql with CloudLinux on cPanel server

Using the mysql upgrade option in WHM will not work on CloudLinux installed server

Before proceed further we need to take backup of mysql databases in .sql format.

If you want to backup single database, execute below command to dump database contents to text file.

mysqldump sampledb > sampledb.sql

# For all databases on server, execute below command.

mysqldump –all-databases > all_databases.sql

# For upgrading to MySQL 5.5, you should to do:

/usr/share/lve/dbgovernor/db-select-mysql –mysql-version=mysql55
/usr/share/lve/dbgovernor/db-select-mysql –install-now

That’s it

root@L3webhosting.com [~]# mysql -V
mysql Ver 14.14 Distrib 5.5.34, for Linux (x86_64) using readline 5.1
root@L3webhosting.com [~]#

Now you need to recompile apache/php after mysql upgrade.

You can contact us at esupport@L3webhosting.com if you require any further assistance.

How to install “mongodb” on cPanel server

Here are steps to install “mongodb” on cPanel server :

# Install the MongoDB repo:

cd /etc/yum.repos.d

# Create mongodb.repo file:

vi mongodb.repo

# Paste below lines into mongodb.repo file :

[mongodb] name=MongoDB Repo
baseurl=http://downloads-distro.mongodb.org/repo/redhat/os/x86_64/
gpgcheck=0
enabled=1

# Install MongoDB using Yum

yum install mongo-10gen mongo-10gen-server

# Configure MongoDB to automatically start after reboot:

chkconfig mongod on

# Start MongoDB:

service mongod start

# Use the powerful PECL command to install your MongoDB PHP extension:

pecl install mongo

# Restart Apache to apply changes:

service httpd restart

#Verify installation with this command:

php -i | grep mongo -i

You can contact us at esupport@L3webhosting.com if you require any further assistance.

Error: “DATABASE CONNECTION ERROR-ROUNDCUBE”.

Issue :
Getting below error for roundcube

DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server- administrator.

There are few things to be checked while working with this problem.

# The database is repaired if the entire table exists. To repair a db follow this command

mysqlcheck -r roundcube

# The roundcube can be rebuild with the command line if the database or tables is missing. The command used to rebuild roundcube is:

FOR BACKING UP THE DATABASE USE THE FOLLOWING

mysqldump roundcube > roundcube.sql

FOR DROPPING THE DATABASE:
The command below has to run in MySQL prompt

DROP DATABASE roundcube;

FOR REBUILDING PURPOSE

/usr/local/cpanel/bin/update-roundcube –force

TO RESTORE:

mysql roundcube < roundcube.sql

You can contact us at esupport@L3webhosting.com if you require any further assistance.