Importing from wordpress hosted blog

  • Unknown's avatar
    sugarmama · Member ·

    I bought a domain & have been blogging with WP as my host. I don’t want to use the domain any longer. I’m trying to import from the wordpress hosted to the “dot wordpress dot com”, but it doesn’t seem to work from the simple “import” option under “manage”. Any suggestions?

  • Unknown's avatar
    sunburntkamel · Member ·

    install this plugin in your hosted wordpress installation:
    http://www.technosailor.com/wordpress-to-wordpress-import/

    now you can go to Manage > WP Export, and download your blog as a *.WXR

    you should be able to import that file on the import page of your wordpress dot com blog.

    some additional notes from my attempts:
    http://sunburntkamel.archgfx.net/2006/11/02/import-wordpress/

  • Unknown's avatar
    michaelsync · Member ·

    Yeah. it might work for importing to wpmu from wp.

    but importing to wp from wpmu doesn’t work very well.

    I wanted to use paid-hosting before I bought domain-upgrade from wordpress.
    So, I downloaded wp from wp.org and tried to import xml from wpmu to my local wp . but it ended up with getting errors in importing

    Here are some links that you may wanna check.

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

    http://wordpress.org/support/topic/85101?replies=4

    Today also, I have tried to import after installing fresh wp and activating xmp import plugin that sunburntkamel mentioned.

    but I’m getting the following error.. (I think, this is the same error that i got (http://wordpress.com/forums/topic.php?id=3583&replies=13))

    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-11-28 07:33:21’, ‘2006-11-28 07:33:21’, ‘http://localhost/wordpress/wp-content/uploads/2006/11/wordpress2006-11-28xml’, ‘wordpress2006-11-28xml’, ”, ‘attachment’, ‘open’, ‘open’, ”, ‘wordpress2006-11-28xml’, ”, ”, ‘2006-11-28 07:33:21’, ‘2006-11-28 07:33:21’, ‘0’, ‘0’, ‘import’, ‘http://localhost/wordpress/wp-content/uploads/2006/11/wordpress2006-11-28xml’)

    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:PersonalOpenSourcewordpress/wp-content/uploads/2006/11/wordpress2006-11-28xml’)

    btw, wordpress2006-11-28.xml is a xml file that i exported from wpmu (michaelsync.net)

    Let me know if you found the solution.

    For the time being, I’ll be waiting paid-upgrade hosting from WordPress. ( I still love my old url “michaelsync.wordpress.com”. I dont wanna leave it. )

    When can we expect to get paid-hosting upgrade from wordpress? not so expensive one. I’m not able to afford for VIP hosting. maybe cheaper one. around 5$ per month. :)

    Thanks.

  • Unknown's avatar
    hamarana · Member ·

    worked well for me tonight, thanks for that link to the plugin :)

  • Unknown's avatar
    verbalchameleon · Member ·

    this worked for me too (going from self-hosted to wordpress.com). thanks!

  • The topic ‘Importing from wordpress hosted blog’ is closed to new replies.