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.
[Snippet] Manually reset a WordPress password
WordPress stores user passwords in MD5 checksums, so using your SQL admin tool of choice you can easily reset it.
- UPDATE `wp_users` SET `user_pass` = MD5('NEW PASSWORD') WHERE `wp_users`.`user_login` = "THE USER" LIMIT 1
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.
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.
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.
WP-O-Matic Cron Hangs
Does your WP-O-Matic hang sometimes when processing feeds? It's probably trying to a ping back to the original post. Chances are you don't even want it pinging back, depending on the purpose of your blog.
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.
MySQL Tuning Server Parameters
These are some of the handy MySQL 5.0 tweaks I do to get the most out a MySQL database;
I adjust the following to suit my server, I try to give MySQL as much resource as possible.
