Tuesday, 16 August 2011 16:09
- Change database name my_joomla_db to your joomla database and my_wordpress_db to your Wordpress database
- Change http://demo.joellipman.com/wordpress/ to the full URL of your WordPress site.
- If post_type is to be post then append with ?p= otherwise use ?page_id=.
------ MIGRATING JOOMLA v1.5.# CONTENT TO WORDPRESS v3.2.# ------
-----------------------------------------------------------------
INSERT INTO my_wordpress_db.wp_posts
SELECT
id 'ID',
1 'post_author',
created 'post_date',
created 'post_date_gmt',
CONCAT(introtext, ' ', `fulltext`) 'post_content',
title 'post_title',
'' post_excerpt,
CASE state WHEN '1' THEN 'publish' ELSE 'draft' END 'post_status',
'open' comment_status,
'open' ping_status,
'' post_password,
alias 'post_name',
'' to_ping,
'' pinged,
modified 'post_modified',
modified 'post_modified_gmt',
'' post_content_filtered,
'0' post_parent,
CONCAT('http://demo.joellipman.com/wordpress/', '?p=', id) AS guid,
'0' menu_order,
'post' AS 'post_type',
'' post_mime_type,
0 comment_count
FROM
my_joomla_db.jos_content
ORDER BY
id
