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 MoreTag: database
Migrate and restore account from cpanel server
Migrate and restore account from cPanel server to another cpanel server Login to source server : /scripts/whoowns domain.com It shows the username for that domain name. You can create full backup of account which contain all data, database and emails by using following command. #/scripts/pkgacct username Change the permission #chmod 755 /home/cpmove-username.tar.gz Then Move the […]
See MoreMySQL server has gone away for query
MySQL server has gone away for query Error : “WordPress database error MySQL server has gone away for query…..” Solution : You need to add the following line in line number 334 in wp-includes/wp-db.php file $this->query(“set session wait_timeout=600”); Done
See More
You must be logged in to post a comment.