but updating blogrolls takes soooooooooo lonnngggggg

So is this iteration three of “Cruel Angel Theses”?

Nice to see it finalised. Prepare to be referenced in ‘The Uniform Resource Locator As A Means of Expression’.

Oh you crazy icky mashers! I just had to spend like a whole TEN minutes searching all your names and running SQL queries to update all comment author URLs and URLs in posts! I highly recommend using find and replace in your database to make the changes, because (since your permalink structure is the same) it will save you a lot of time and pain. Hit me up if you need to know how.

BTW, did you leave Aria Anime behind, because that subdomain still redirects to the icky masher subdomain? Randall hasn’t updated his blogroll either yet…

BACK UP YOUR DATABASE FIRST! You may want to run this on a small test case first as well, to make sure you understand the concept. This is not the most direct method of updating, but I feel it is a little easier to understand, and since you will be cutting and pasting, you can’t really make a typo and screw everything up.

Since everyone’s database is named differently, here is the basic tutorial:

1) Go to your WP database, then go to the wp_posts table.
2) Click on the search tab and search for post_content LIKE %ikimashou.net% where the percentage marks indicate a wildcard.
3) Select one and change the instance of ikimashou.net to dasaku.net
4) When you do this once, you will notice that it will update that one entry with some code like UPDATE `YOURDATABASENAME`.`wp_posts` SET `post_content` =
WHERE `post_content` LIKE '%ikimashou.net%' WHERE BLAHBLAHBLAHBLAH;
5) Underneath that code will be the code from your search, that will look like SELECT *
FROM `wp_posts`
WHERE `post_content` LIKE '%ikimashou.net%'
LIMIT 0 , 30[...]
6) The idea is to replace the WHERE statement in the first piece of code with the WHERE statement in the second piece of code (WHERE `post_content` LIKE '%ikimashou.net%';)
7) Don’t forget the semicolon at the end (;)
8) Run it and the SQL query will update all the instances for you.

This process can be repeated on your wp_comments table, searching in comment_author_url for %ikimashou.net% and replacing all instances there with dasaku.net. Good luck!

Can’t wait for the Valentine’s thing, whatever that is. Will it be a loli covered in chocolates for me?

[...] more step-by-step walkthrough for those who have no knowledge of SQL. I posted this as a comment on Owen’s blog, but some other people may be interested, so here’s a basic overview of how to update URLs in [...]