MySQL 5.0 or 5.1 to 5.5 Upgrade Traumas on CentOS

Ignoring all the panic-mongers on the rest of the internet upgrading MySQL from 5.0 or 5.1 to 5.5 shouldn’t be that difficult. My task was to upgrade from 5.0 to 5.5 on CentOS (Remi Repos). It was to fix a bug with MySQL 5.0 ignoring the wait_timeout parameter in my.cnf.

Five to five on a Friday, I dive into the swamp, which turns out to be full of alligators.

Alligator 1: Version depenencies
Alligator 2: /usr/libexec/mysqld: unknown option ‘–skip-locking’
Alligator 3:  [ERROR] Error message file ‘/usr/share/mysql/english/errmsg.sys’ had only 481 error messages,
but it should contain at least 641 error messages.
Or some other variation of numbers.

Continue reading “MySQL 5.0 or 5.1 to 5.5 Upgrade Traumas on CentOS”

Upgrading from SQL 2000 to 2005 Error -1

Ever had your Upgrade Advisor return an error while upgrading an instance of SQL Server 2000 to SQL Server 2005?

UpgradeAdvisor returned  -1 .

I have, in two different circumstances,

  • While choosing an instance from the installed instances and choosing one of them to upgrade.
  • While running upgrade advisor exclusively.

Continue reading “Upgrading from SQL 2000 to 2005 Error -1”

How to move WordPress directory or server – properly

I ran into an annoying, but easily avoided problem the other day. When moving a clients WordPress site from the development/staging area to it’s live domain, I did the usual update “WordPress address” and “Blog address” in the WordPress settings.
Thats all you need to do, right? No.
Continue reading “How to move WordPress directory or server – properly”

WP-O-Matic Bug Fixes Round Up

I’ve run into quite a few issues in the latest 1.0RC3-7 release of WP-O-Matic. Here’s a round up of the bug fixes and addons you need to actually this potentially useful product useful!
Also, it includes a well known MySQL bug fix.

Continue reading “WP-O-Matic Bug Fixes Round Up”

PHP Export as CSV

A client recently requested an option to extract search results from their PHP application as CSV. It had me confused for a while, I was writing wrappers, writing out files, changing directory permissions, until I had a lightbulb moment.
There is no reason why you can’t have the browser do all the work for you. Continue reading “PHP Export as CSV”