Category Archives: SQL & Databases

Idiots Guide: Migrating WordPress to GoDaddy Managed Hosting

There are lots of guides out there for migrating WordPress websites but there are a few peculiarities about GoDaddy Hosting and I found many of the guides didn’t provide enough detail. Considera ...

Bob McKay 8001 views 2 likes Nov 12, 2016 Hosting, SQL & Databases, WordPress

Backing Up MySQL Databases on a Windows Server

I’ve been managing Microsoft Windows based Plesk servers for many years now and one thing that has always been a problem has been backing up MySQL databases, in particular, databases that use In ...

Bob McKay 5922 views 0 likes May 12, 2015 SQL & Databases

Quick Work Around for the “You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column” MySQL Error

Every now and then when I’m working on a MySQL database and trying to manually update records, my update query gets knocked back with the following error (or something similar depending on if I& ...

Bob McKay 10058 views 1 likes Aug 28, 2014 SQL & Databases

Solving PHPMyAdmin Import/Export Syntax Errors

As a Microsoft SQL Server fan, I’ve found the move to MySQL fairly painless in all but one area: database administration. I have the excellent MySQL WorkBench which makes things a little easier ...

Bob McKay 7881 views 1 likes Jul 28, 2014 PHP, SQL & Databases, Web & Programming

MySQL Fulltext Index Searching

So I recently want to create a search using Full Text Index searching but wasn’t sure how to go about it, I had to lookup multiple resources and still had hiccups along that way so figured IR ...

Bob McKay 3992 views 3 likes May 7, 2014 SQL & Databases, Web & Programming