Need help? Check out our Support site, then


WordPress.com Forums » Support

Import to Local WordPress

  1. michaelsync
    Member

    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. timethief
    Member

    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. reaperxzr
    Member

    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. sunburntkamel
    Member

    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. michaelsync
    Member

    Thanks. timethief, reaperxzr and sunburntkamel

  6. michaelsync
    Member

    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. drmike
    Member

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

  8. michaelsync
    Member

    >>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. drmike
    Member

    Try this.

  10. michaelsync
    Member

    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. michaelsync
    Member

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

  12. wank
    Member

    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. michaelsync
    Member

    Oki. Thanks..

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags