Disk Space Usage in cPanel (Home >> Files >> Disk Space Usage) This page shows you where disk space usage is distributed within your account’s home directory. Information about your account’s disk usage, follow these steps: 1) Login to cPanel 2) under Files 3) click Disk Space Usage. Note: It can be useful when you […]
See MoreTag: Databases
Upgrade MySQL and MySQL Governor in cPanel
Upgrade MySQL and MySQL Governor in cPanel CloudLinux based server First make full mysql backup(including system tables) to safe location. 1) Take the backup of all the databases on the server. $ mkdir -p ~/mysqlbkp $ service mysql restart –skip-networking –skip-grant-tables $ mysql_upgrade $ mysqldump –all-databases –routines –triggers > ~/mysqlbkp/dbcopy.sql $ service mysql stop $ cp -r /var/lib/mysql/mysql ~/mysqlbkp/ $ service mysql start 2) update mysql/governor in the following way: # yum update governor-mysql –enablerepo=cloudlinux-updates-testing # /usr/share/lve/dbgovernor/db-select-mysql –mysql-version=mysql55 # /usr/share/lve/dbgovernor/db-select-mysql –install-now installation […]
See MoreDatabases showing 0MB in cPanel
Databases showing 0MB in cPanel From command line 1. Run the command. # /usr/local/cpanel/bin/setupdbmap 2. Edit cPanel configuration file. disk_usage_include_sqldbs=1 ( you need to set it to ‘1’ if ‘0’ ) in file /var/cpanel/cpanel.config 3. Run the following script. #/scripts/update_db_cache You can also enable this from the WHM control panel. WHM >> Server Configuration >> […]
See More