I’m a Word Press Boy
April 1st, 2009 | 
Author: I’m a WordPress Bhoy boy looking for a WordPress girl 
yes for last 2 days I’m using WordPress… Not it is not a fools day prank… You can check this blog is on WordPress… I’ve been using Drupal CMS for my blog for last 4 years and I’ve great love for Drupal… There were lot criticism and cry from Drupal world… Even I got a shout from a buddy in twitter…
tronathan@anandnataraj Why on earth would you go from drupal TO wordpress? please enlighten me…
2.) Make sure both wordpress and drupal tables are in same database…
Please use below SQL queries to export the posts and comments from drupal to wordpress 2.7.1. I used phpmyadmin to write queries
This sql will export all posts from drupal to wordpress 2.7.1
# Use the Drupal database
use db261070012;
# Remove all current posts from WordPress
TRUNCATE TABLE wp_posts;
# Insert posts from Drupal into WordPress
INSERT INTO wp_posts (id, post_date, post_content, post_title, post_excerpt, post_name, post_modified, post_type, `post_status`)
SELECT DISTINCT
n.nid `id`,
FROM_UNIXTIME(n.created) `post_date`,
r.body `post_content`,
n.title `post_title`,
r.teaser `post_excerpt`,
IF(SUBSTR(a.dst, 11, 1) = ‘/’, SUBSTR(a.dst, 12), a.dst) `post_name`,
FROM_UNIXTIME(n.changed) `post_modified`,
‘post’ `post_type`,
IF(n.status = 1, ‘publish’, ‘private’) `post_status`
FROM cms_node n
INNER JOIN cms_node_revisions r
USING(vid)
LEFT OUTER JOIN cms_url_alias a
ON a.src = CONCAT(‘node/’, n.nid)
;
This sql will export all comments from drupal to wordpress 2.7.1
TRUNCATE TABLE wp_comments;INSERT INTO wp_comments (comment_post_ID, comment_date, comment_date_gmt, comment_content, comment_parent, comment_author, comment_author_email, comment_author_url, comment_author_ip, comment_approved)SELECTnid,FROM_UNIXTIME(timestamp),FROM_UNIXTIME(timestamp),comment,0,name,IF(mail=”, CONCAT(REPLACE(LOWER(name),’ ‘, ”), ‘@’, hostname, ‘.localhost’), mail),homepage,hostname,1FROM cms_comments;
This sql will update the number of counts in wordpress posts table
# update comments count on wp_posts tableUPDATE wp_posts SET comment_count = (SELECT COUNT(comment_post_id) FROM wp_comments WHERE wp_posts.id = wp_comments.comment_post_id);
5.) Finally pointed my site’s destination from /anandnataraj (location where drupal files reside) to /anandnataraj/blog (wordpress files)…
6.) Changed rewritebase in /anandnataraj/blog/.htaccess from “/blog” to “/”…
Changed the site URL and blog URL in wp_options table to http://www.anandnataraj.com
Yesterday I designed my own WordPress, brought a coffee mug and printed it there, also shot some snaps with it …
 | @oc_f1fan Yep, Let's see what @callmemochelle will blog about. Will it be riveting? We will soon find out. :) Wed, 08 Feb 2012 22:48:02 +0000 |
 | RT @Babytendence: #Themommyhook en @Babytendence, 100% funcionalidad para el #carrito de tu #bebe http://t.co/sIkpEgMb Wed, 08 Feb 2012 22:48:02 +0000 |
 | ＃ 通販 サーバーの不具合 http://t.co/oyjegN2a Wed, 08 Feb 2012 22:48:02 +0000 |
 | Keith Shetterly commented on James A. Ziegler's blog post 'True Car and ZAG - Cyber Bandits or Good for the Busi... http://t.co/OMcql7OC Wed, 08 Feb 2012 22:48:02 +0000 |
 | New blog posting, Left 4 Dead 2: Funny Moments of Getting Owned Part 2.5 - http://t.co/zBb0lTFU Wed, 08 Feb 2012 22:48:02 +0000 |
 | 昨日の浪川さんのBlog見てきた…ｗｗｗｗｗｗｗｗｗｗｗｗｗｗｗｗｗｗｗ笑えたｗｗｗでも、やっぱスタイルいいよね(´ψψ｀) Wed, 08 Feb 2012 22:48:02 +0000 |
 | ﾔﾀｰ！ジト目のＡＡできたよ～ http://t.co/x3FYoZRS (はてブ 1) ｜ 勝つる2chまとめブログ Wed, 08 Feb 2012 22:48:02 +0000 |
 | A Competitive Marketplace Keeps Prices Down – Good For You http://t.co/eEUnSZyR #greenwebhosting #green Wed, 08 Feb 2012 22:48:02 +0000 |
 | Evernote for iOS アップデート: スマートタイトル、編集機能改善、共有も楽に - Evernote日本語版ブログ http://t.co/FL5UXCNE Wed, 08 Feb 2012 22:48:02 +0000 |
 | Double happy. “@IndigoKidsBlog: RT @quillandquire: Best publicity stunt - Lemony Snicket and Seth on new series - http://t.co/qmOv6z6o” Wed, 08 Feb 2012 22:48:02 +0000 |
 | RT @EntMagazine: Want your employees to be more productive? Consider scaling back on meetings: http://t.co/zpxIislk by @ticewrites Wed, 08 Feb 2012 22:48:01 +0000 |
 | RT @theJeremyVine: Why the phrase "man up" is really, really unhelpful - latest blog on depression from @PaulBrook76:
http://t.co/zIReHV4d Wed, 08 Feb 2012 22:48:01 +0000 |
 | TO COM FOGO NO CU, VO CRIAR UM BLOG Wed, 08 Feb 2012 22:48:01 +0000 |
 | @SameeraAbd هذا مقال كتبته من زمان عن هالموضوع .. http://t.co/HS1uO8LB Wed, 08 Feb 2012 22:48:01 +0000 |
 | RT @msftsecurity: Read our new blog post: "The @WhiteHouse Reports on the National Strategy for Global Supply Chain #Security" http://t.co/4nfWPU34 Wed, 08 Feb 2012 22:48:00 +0000 |
Blogs
Android and Security - Official Google Mobile BlogNews, features and tips from the Google Mobile team.
Gmail app for iOS available in the App Store ... - Official Gmail BlogPosted by Matthew Izatt, Product Manager Two weeks ago, we introduced our Gmail app for iOS. Unfortunately it contained a bug which broke notifications and displayed an error message, so we removed it from the App ...
Introducing the Gmail app for iPhone, iPad and ... - Official Gmail BlogOfficial Gmail Blog. News, tips and tricks from Google's Gmail team and friends. Classic. Classic · Flipcard · Magazine · Mosaic · Sidebar · Snapshot · Timeslide. Loading. Send feedback.
| Kevin Kr Ramsey espn.go.com blog 's link No more making fun of the NL Central, not after the St. Louis Cardinals shocked the baseball world with their wild-card run and postseason dramatics. |
| Dan Casey www.ctconstitution.com blog 's link Detailed information about the players will be coming shortly. To learn more about a player or the team, or to schedule an interview with a player, please contact Andrew Bosco, our public relations director, at Andrew (at) ctconstitution (dot) com or by calling (860) 515-8584 . |
| Carson Joyner carsonjoyner22.blogspot.com blog 's link |
| Jen Chantrill jen-livingbliss.blogspot.com blog 's link |
| Jesus Olivan jesusolivan.blogspot.com blog 's link En este blog se comentan algunas actividades artísticas que han llamado mi atención. Para un perfil completo ver www.jesusolivan.com. (contacto: jesusolivan.mail@gmail.com) |
| Don McConnell salemfilmfest.com blog 's link Do you remember the power and spirit that Reggae music brought to us back in the 1970′s? That torch still burns brightly for a group of elder Rasta hills-men from Nonsuch, Portland, Jamaica. They survive by living close to nature, working the land organically and harvesting wild fruits and bush medi... |
| Raelene Gibbons www.positivelypositive.com blog 's link |
| Maj Mackintosh Shirley Temple |
| Patrick Hazard www.chrisasksthehaz.com blog 's link |
| Jason Baird www.tomwoods.com blog 's link I am trying to understand the thinking behind the great many Americans who have decided to vote for a mainstream politician in 2012. Now before you read the |
| Bayli Silberstein |
| Brett Allen |
| Corey Fey www.cbsnews.com blog 's link YouTube video by Jimmy Diebold entitled "Midnight Lights" with music by Patrick Reza Read more by William Goodman on CBS News' The Feed Blog. |
| Vismaties Blogspotteliacom vismaties.blogspot.com blog 's link |
| Vasile Antipa vasile-antipa.blogspot.com blog 's link |
Powered by WordPress SEO Tools
Posted in 
hey.. good to see you shifting to WP
btw where did you get the mug printed??
hey thank you dude… infact you are instrumental for this change
… got those mugs printed in forum mall, bangalore…
That’s nice to hear! BTW when do we meet to talk from where we left?? We’ve lost quite a lot of time at even starting!
Drupal Theme Developer, is a best Drupal Theme web developing firm in India. We build affordable web for best price. We develop Drupal projects for any web and web pages. We do, Drupal Outsourcing project, PHP & Mysql outsource web development.
Your Article is very good. I learned somen outsourcing knowleges or skills from your articles.I can communicate with your in the web development outsourcing. Tks again. http://www.micrweb.net