Hosting | Design | Technical Solutions
Plesk pre-migration check finishes with an error: Set variable innodb_strict_mode to OFF on target to avoid the migration errors Strict mode is enabled on the newer versions of MySQL/MariaDB by default. The my.cnf file needs to be edited. The following…
You have an entry in a MySQL database that you want to change. ie, you may want to re-reference an image folder or in my case, archive all the events on a sports site before the new season. To do…
I wanted to copy one column which held postcode data and insert all that data into another column, however I only wanted the first four characters, so effectively providing a column which relates to postcode districts. Create the new column…