I recently changed themes with CSS Igniter and found that some of the content I had in that great previous (Eclecticon) theme was lost in my new theme (Business3ree). The data wasn’t lost, but the new theme didn’t use that data.
My goal
My goal was to UPDATE posts with the post_type eclecticon_project and replace them with ignition-portfolio following my previous post about updating WordPress to UTF-8 I was able to massage the query to fit my needs. 🙂
Process
The process is simple:
UPDATE `posts` SET `post_type` = REPLACE(`post_type` ,'eclecticon_project','ignition-portfolio');
