I’m a Word Press Boy

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…6:19 AM Mar 29th from TweetDeck in reply to anandnataraj

For Drupal lovers or WordPress lovers let me confess I’m still a Drupalian by heart and WordPress is just a mask… I still challenge everyone that Drupal is the best CMS in the world than any other CMS… So, you can ask me why I converted from Drupal to WordPress… Here are my justifications

  •  
    • WordPress is quick in giving updates and more happening now-a-days
    • WordPress has all the tools for running a blog, which drupal must improve
    • WordPress admin interface is very simple to use
    • WordPress has more plugins and themes compared to drupal
    • Last but not least I get lot of enquries on wordpress customization… So using the system will help me understand client’s challenges and expectation…

I decided to convert to WordPress a month back, but I researched a lot on reading other blogs on lessons as I didn’t want to take a change… But itz all done within an hour and the process was very simple… This is what I did;

 

1.)    Installed WordPress in a folder /blog…

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);

3.)    In Drupal, I used url alies which was like /my_post_title_name and I wanted to have the same url alies.
To do this I updated the WordPress Permalink settings:
Custom Structure : %postname%    

4.)    120 posts and 98 comments were successfully imported from drupal to wordpress…

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 “/”…

7.)    Changed the site URL and blog URL in wp_options table to http://www.anandnataraj.com

 

It took 30 minutes to migrate from drupal to wordpress 2.7.1… So far, everything seems to be working just fine…

 

Yesterday I designed my own WordPress, brought a coffee mug and printed it there, also shot some snaps with it :)

 

Be Sociable, Share!
  • Twitter
  • Facebook
  • email
  • StumbleUpon
  • Delicious
  • Google Reader
  • LinkedIn
  • BlinkList
  • Digg

    Twitter

    @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見てきた…wwwwwwwwwwwwwwwwwww笑えたwwwでも、やっぱスタイルいいよね(´ψψ`)
    Wed, 08 Feb 2012 22:48:02 +0000

    ヤター!ジト目のAAできたよ~ 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

    Google Chrome Blog: Introducing Chrome for Android
    In 2008, we launched Google Chrome to help make the web better. We're excited that millions of people around the world use Chrome as their primary browser and we want to keep improving that experience. Today, we're ...
    Android and Security - Official Google Mobile Blog
    News, features and tips from the Google Mobile team.
    Gmail app for iOS available in the App Store ... - Official Gmail Blog
    Posted 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 Blog
    Official Gmail Blog. News, tips and tricks from Google's Gmail team and friends. Classic. Classic · Flipcard · Magazine · Mosaic · Sidebar · Snapshot · Timeslide. Loading. Send feedback.

    Facebook

    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

    5 Responses to “I’m a Word Press Boy”

    Leave a Reply

    Sponsors
    Featured Videos
    Tag Cloud
    Archiives
    Search Blog
    Famous Quotes

    "Talent is cheaper than table salt. What separates the talented individual from the successful one is a lot of hard work."

    Stephen King

    Categories
    Like Box