Changing domain in wordpress


So to at least make an effort at testing the wordpress upgrade to make sure no one’s blog theme/widgets ended up completely broken I made a beta site. Since wordpress stores the URL of its blogs in the database this was initially problematic. sed and mysqldump made it a quite easy transition though.

Dump your database:
mysqldump wordpress -p | mydatabase
sed ‘s/blogs\.dootdoot\.com/new\.domain\.here/g’ mydatabase > mynewdatabase

Then import back into mysql, change your wp-config.php domain and things should be cricket. This probably could be filed under “stupid simple” as far as location changing goes.  Although I should add that if you were trying to move to a type domain, wordpress ignores the www

Repairing Mysql Tables


Just going about day by day tasks, out network monitoring solution is acting very funky.

Sure enough, some of the .MYI files are missing.  This is a really simple fix that for some reason other people I know couldn’t find a way to fix.  To fix these issues, there is a simple command but first you might as well check to see if there are other errors.  So start by using the mysqlcheck utility.

mysqlcheck -A –auto-repair

This will tell you what tables are fubar’d

To repair them log into mysql and run the following command.

repair table <tablename> use_frm;

I’ve read the use_frm is often unnecessary, but to my experience its always required when mysqlcheck can’t fix them automagically.

Repetitive task is repetitive


We have a database that stores all the little details about how utilized our network is.  It has information at 5 minute averages, 1 hour averages, and 1 day averages.  The software that does this is supposed to keep only 3 months worth of 5 minute data, 6 months worth of hourly, and a year worth of daily.  You’d think that since the feature shipped with the initial product that by version 5 it would work.  


It doesn’t.

So here I sit going through table by table looking at the definition of the table, finding what the timestamp column is named and telling the table to delete everything more recent than a certain second.  This task is not hard, this task is boring though.  Someone email me some sudoku’s.