And the winner is?
In the process of upgrading this blog to the latest version of WordPress, I got lazy. So lazy that I created a nice little list of commands that I could just copy and paste at the command line that would back up my files, delete some others, and copy across new files.
Well, not paying attention, I started this all from the WRONG DIRECTORY!!!
So I deleted this blog’s “wp-content” directory. Good thing I had a backup of my theme on my laptop.
I also have any images that I’ve previously embedded in posts on my laptop. The problem is, WordPress places these images in different directories by default. For example, any images I added to this post would be uploaded to wp-content/uploads/2007/06. I now have to find all posts with images, find out exactly which ones they’re using, and where they need to be uploaded. Yippee-ka-yay(you should know the rest of THAT saying…)
Anyway, here’s the SQL I’m running in phpMyAdmin to get all posts with the phrase “/uploads/” in them (indicating an image, at the very least):
select post_content from "wp_posts" where post_content like '%/uploads/%'
This is probably not the best way to do it, but it’s working.
So, why am I telling you all this?
After this most IRRITATING of things anybody could do to themselves, I needed SOMETHING to make myself feel better…
Well Scott from “Self Made Minds” has a competition running that I decided to try out for to take my mind off of my screw up. The prize is for an established, yet under-used (I believe) website, “fictionforum.net“.
I figure, being an avid reader, I might be able to do something with it…
Anyway, whether I win or not, (and Scott, please don’t take this as sucking up), you MUST subscribe to that blog. And, read EVERYTHING right from the very beginning. It is THE most informative blog at the moment for anybody trying to make it online. Using real examples from his (their?) site “Coolest Gadgets“, I’ve learned more from that blog in the last month than I’ve learned from 90% of the other blogs I’ve ever read…
