Today I show you how to get rid of your All In One SEO Pack Plugin and integrate your meta Title, Description, & Keywords into Thesis Theme using a very simple code via PHP (I promise, not as daunting as it sounds). Simply copy the code below (two codes listed depending on your current All In One SEO Plugin code – and follow the steps given in the video above. If you have any questions, don’t hesitate to ask!
For All in One SEO versions below 1.6
insert wp_postmeta (post_id,meta_key,meta_value)
select post_id, concat(‘thesis_’,meta_key),meta_value
from wp_postmeta where meta_key in (‘title’,'description’,'keywords’);
For All in One SEO version 1.6 or higher
insert wp_postmeta (post_id,meta_key,meta_value)
select post_id, concat(‘thesis_’, substring(meta_key,10)), meta_value
from wp_postmeta where meta_key in (‘_aioseop_title’,'_aioseop_description’,'_aioseop_keywords’);
- Original Source: http://diythemes.com/answers/copy-all-in-one-seo-to-thesis/
- Hat-tip to Tim Jahn for helping me out with the PHPMyAdmin navigating.
Was this useful? Subscribe to the MattChevy RSS feed for the latest tips and tutorials!
{ 4 comments… read them below or add one }
using a very simple code via PHP
To be fair, this isn’t PHP code, but SQL code. Yes, you are using “PHPMyAdmin” to access your DB server, but there’s really no actual PHP involved
But man, what a cool tip.
Right – the context was “using PHPMyAdmin” – apologize for the confusion. And yes, it’s a nifty little trick for those who switch over to Thesis.
Also, outside of this tip, I wouldn’t recommend people to poke around in phpMyAdmin unless they have knowledge of what that is and what goes on in there. A few simple wrong clicks and your site database will vanish.
When it comes to messing with your database and/or phpMyAdmin, I highly recommend letting a trained professional do the poking, just to be safe.
Agreed – but the purpose of this video is to provide an explicit step by step guide for those who may not be as tech-savvy. By following the steps laid out in the video, you don’t run any risk of deleting your database.
…Just don’t go poking around or pushing any red buttons while you’re in there…