websites for trades people

Geo Location for your local trades website

Submitted by gazza on Mon, 28/09/2020 - 14:13

As a trades person, you will be trying to target your local geographical area to gain more referrals through your website. There are many SEO implementations that you should have in your website to ensure that you are getting the right sort of traffic from the right location. One of these that will help you rank better is to  make sure you implement geo location tagging metadata on every page of your website. This isn't seen by visitors to your website but it is seen by search engines like Google and is used in location based searches.

Please use mysql_upgrade to fix this error - Plesk fix

Submitted by gazza on Thu, 24/09/2020 - 10:31

This error occurred in my environment when I tried to create a database dump. This happened after I updated the MariaDB from version 10.2.x to 10.3.x. After upgrading your MySQL you have to run  mysql_upgrade to fix any incompatibilities in System tables. 

Just run the below command at your Plesk command line after upgrading your MySQL, restart MySQL and it will fix the issue:

Upgrade MySQL databases:

MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin

Restart the MySQP service

systemctl restart mysql