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 MoreCategory: Hostripples Featured
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 MoreHow to install MariaDB Server in cPanel/WHM servers?
How to install MariaDB Server in cPanel/WHM servers? And What are the advantages of using MariaDB Server ? Ans: * Install MariaDB Server in cPanel/WHM servers 1. Backup existing MySQL data # mysqldump –all-databases –routines –triggers > /home/db_dump/alldb.sql # service mysql stop # cp -r /var/lib/mysql/mysql /home/db_dump/ # service mysql start 2. Select MySQL version […]
See More
You must be logged in to post a comment.