CageFS and PHP Selector are two major components of Cloud Linux. The installation of PHP Selector PHP Selector is a CloudLinux component that sits on top of CageFS. It allows each user to select PHP version & module based on their needs. PHP Selector requires account to have CageFS enabled to work. 1) The installation of PHP Selector […]
See MoreCategory: Hostripples Featured
Change default timezone in MySQL
How to change default timezone in MySQL? The timezone on SiteGround’s servers is CST. This is a global setting which cannot be changed. 1) Modify the MySQL NOW() function. 2) Selecting the current date/time: SELECT NOW(); If you want to add 2 hours to the result, 3) Use the following syntax: SELECT DATE_ADD(NOW(), INTERVAL 2 […]
See MoreUpgrade 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 More
You must be logged in to post a comment.