Over the last few months it’s appeared rather quiet here at ClassiPress HQ. In actuality, we’ve been quite busy behind the scenes working on a new update (v3.0.3) and a brand new company web site. We plan on launching the new site early next month (which we’ll announce in a separate post and email to all customers) and then the 3.0.3 update will be released soon thereafter. It’s a bug fix and feature enhancement release so nothing major.
Anyhow, the reason for this post was to provide a handy bit of mySQL code when migrating your ClassiPress site to another domain.
While going through the demo site migration process, we had to change a bunch of legacy meta_values which have the image urls hardcoded in them so the thumbnail and ad images weren’t showing up. Instead of manually having to go through hundreds of records, it made more sense to write a custom sql query to handle the same change in a matter of seconds.
Continue reading →