2009/05/29
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 www.blog.com type domain, wordpress ignores the www
No Comments » |
linux, mysql | Tagged: linux, mysql, wordpress |
Permalink
Posted by seth
2009/03/24
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.
No Comments » |
mysql, work |
Permalink
Posted by seth
2009/01/22
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.
No Comments » |
life, mysql, work | Tagged: life, mysql, tech, work |
Permalink
Posted by seth