Need help? Check out our Support site, then


Import to Local WordPress

  1. Hello,

    I have downloaded wordpress (Version 2.0.4) and set up on my local machine as the backup of my live blog.
    But When I look a way to import my live blog (http://michaelsync.wordpress.com) into my local blog on my machine, I didn't see any option to import from wordpress exported file. and I noticed that the downloaded file is a lit bit different than wordpress.com.

    So, How can I import wordpress exported file into my local wordpress??

    Thanks in advance.

  2. The code for downloaded wordpress.org blogs and wordpress.com blogs is different. Here on wordpress.com we are working on a shared multiiuser MU platform. This has been discussed many, many times before on the forum. Have you used the forum search box?

  3. Search for export / import plugin at wp-plugins.net because the current wordpress version (2.0.4) doesnt support importing from WordPress except you're using RSS Feed to import all of your post or you can always use WordPress MU instead of standard wordpress :)

  4. disregard the above two comments.

    you'll need to download the import script from technosailor:

    http://www.technosailor.com/wordpress-to-wordpress-import/

    after installing wordpress.php into /wp-admin/import/, you'll have the option to import your *.WXR file.

    keep in mind, you don't need to have a working wordpress installation. the WXR file can just sit on your hard drive for safe keeping.

  5. Thanks. timethief, reaperxzr and sunburntkamel

  6. I got the following error..

    WordPress database error: [Field 'post_content_filtered' doesn't have a default value]
    INSERT INTO wp_posts (post_author, post_date, post_date_gmt, post_content, post_title, post_excerpt, post_status, comment_status, ping_status, post_password, post_name, to_ping, pinged, post_modified, post_modified_gmt, post_parent, menu_order, post_mime_type, guid) VALUES ('1', '2006-08-23 05:30:26', '2006-08-23 05:30:26', 'http://localhost/wordpress/wp-content/uploads/2006/08/wordpress2006-08-23xml', 'wordpress2006-08-23xml', '', 'attachment', 'open', 'open', '', 'wordpress2006-08-23xml', '', '', '2006-08-23 05:30:26', '2006-08-23 05:30:26', '0', '0', 'import', 'http://localhost/wordpress/wp-content/uploads/2006/08/wordpress2006-08-23xml')

    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3]
    SELECT category_id FROM wp_post2cat WHERE post_id =

    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 1)' at line 2]
    INSERT INTO wp_post2cat (post_id, category_id) VALUES (, 1)

    WordPress database error: [Out of range value adjusted for column 'post_id' at row 1]
    INSERT INTO wp_postmeta (post_id,meta_key,meta_value) VALUES ('','_wp_attached_file','D:\Personal\OpenSource\wordpress/wp-content/uploads/2006/08/wordpress2006-08-23xml')

    Is it because of different versions?

  7. Have you setup up your WordPress blog and installed the database yet?

  8. >>Have you setup up your WordPress blog and installed the database yet?
    Yeah.. I can do everything (ie: posting new thread) in my local blog except importing live blog into my local blog.

    http://wordpress.com/forums/topic.php?id=1597&replies=13

  9. Try this.

  10. Done this..

    I got new error..

    Warning: file(D:PersonalOpenSourcewordpress/wp-content/uploads/2006/08/wordpress2006-08-23xml) [function.file]: failed to open stream: No such file or directory in D:\Personal\OpenSource\wordpress\wp-admin\import\wordpress.php on line 81

    Warning: implode() [function.implode]: Bad arguments. in D:\Personal\OpenSource\wordpress\wp-admin\import\wordpress.php on line 82

    >>D:PersonalOpenSourcewordpress/wp-content/uploads/2006/08/wordpress2006-08-23xml
    ** I was wondering why there is no slash between "D:" and "Personal", and "OpenSource", and "wordpress".
    should be like "D://Personal/Opensouce/wordpress/...."

  11. Deleted.. (cuz I clicked the "post" btn twice.. )

  12. Have you posted this over at the wordpress.org support forums? They're much better equipped to help you with questions about local installations of wordpress than we are.

  13. Oki. Thanks..

Topic Closed

This topic has been closed to new replies.

About this Topic