GoDaddy and WordPress on Windows IIS [updated]
I just moved this blog from DreamHost to GoDaddy. At the same time, I switched from Linux hosting to Windows hosting. When I first copied my files over, everything appeared to work. Until I made a change in the Permalink settings. Then I got 404 errors for every page, including the Word Press admin area....
Reset the Root Password on MySQL
From time to time, you may run across a MySQL database where you don’t have the root password, but you require it to perform some task or another. In my case, I inherited a MySQL installation but no root password was available. The root password in the records did not work. Here’s a quick lesson...
Find Duplicate Records – SQL Query
Here’s a real simple query to detect duplicate records (based on a single field). This query works in both MySQL and Microsoft SQL. SELECT FieldName, COUNT( FieldName ) AS Occurrences FROM TableName GROUP BY FieldName HAVING ( COUNT( FieldName ) > 1 )
