The latest version of MySQL 8.0 is available to install from the default AppStream repository. MySQL module is enabled by default on the CentOS 8 and RHEL 8 systems. We can install it using YUM command. # yum -y install @mysql # systemctl start mysqld # systemctl enable –now mysqld…
You can use the slow query log to help determine which database queries take a long time to run. However, the slow queries can affect database performance and overall server performance. Follow below steps to enable the mysql slow query log on your server :# Login to SSH shell with…
Follow below steps to truncate all current eximstats tables : # Login to SSH with root user # Enter into MySQL server # mysql # Use the database eximstat. mysql> use eximstats; Reading table information for completion of table and column names You can turn off this feature to get a…
How to Safely Change the Location of MySQL Data Directory on cPanel/WHM CloudLinux Servers
October 20, 2018
October 20, 2018
CloudLinux, cPanel WHM, Linux/CentOS, Migration, Mysql database
1 Comment
1. Make a full mysqldump file # mysqldump –opt -uroot -proot_password > /tmp/mysqldump 2. Uncheck monitor in WHM > Service Manager for Mysql and save the area 3. Stop MySQL service # /etc/init.d/mysql stop 4. Ensure that the following settings are present check file /etc/systemd/system/mariadb.service.d/homedir.conf [Service] ProtectHome=false ProtectSystem=off 5. Make…
Sometimes you want to upload or import large mysql database through phpMyAdmin but it fails with upload limit error. Follow below steps to increase upload or import limit for phpMyAdmin : # Login with root user on Centos Web Panel CWP server # Open below file : /usr/local/cwp/php71/php.ini Search for upload_max_filesize and post_max_size…
Use below steps to install or upgrade PostgreSQL on your cPanel server : 1) Run the /usr/local/cpanel/scripts/installpostgres command to install or upgrade PostgreSQL 2) Access WHM >> Home >> SQL Services >> Configure PostgreSQL 3) Click on Install Config if PostgreSQL does not exist on your server 4) Click Create…
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 #…
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…
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…