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 …
