xml database import error (9 posts)

  1. becs
    Posted 9 years ago #

    HI all,

    Many thanks to the guys at install4free. Amazing service.

    However I am having a problem importing my old comments and posts. The file I am using is an xml file which wordpress.com emailed to me.

    The following is the error, then I get loads of code content. I can paste the whole content if required.

    There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

    ERROR: Unknown Punctuation String @ 345
    STR: </
    SQL: <!-- generator="wordpress/MU" created="2006-10-16 10:10"-->
    <rss version="2.0"

  2. Chris_K
    Posted 9 years ago #

    Ah, the wordpress.com export format is a bit different. Grab this plugin (read the directions for install!) and see if it won't do a better job with that export file: http://www.technosailor.com/wordpress-to-wordpress-import/

  3. becs
    Posted 9 years ago #


    Just trying to follow the instructions, I cannot find the wp-content and wp-admin folders.
    I know its staring me in the face somewhere..

  4. Chris_K
    Posted 9 years ago #

    They'd be on your web host, underneath the WordPress install directory (typically wordpress or blog maybe?)

  5. Samuel B

    Posted 9 years ago #

    Look in your /public_html/ folder.
    WP is installed at root level.

  6. becs
    Posted 9 years ago #

    Okay I have done all that successfully.
    I go into import/import wordpress and browse to the xml file.

    I get the error

    Unable to create directory /home/rebe3091/public_html/wp-content/uploads/2006/10. Is its parent directory writable by the server?

  7. Samuel B

    Posted 9 years ago #

    The 1st time you do this, you need to CHMOD the wp-content folder to 777. After performing your action, CHMOD back to 755.
    You can do this in your file manager or via FTP.

  8. becs
    Posted 9 years ago #

    Funny you should say that Samboll, I have just done that as per advice on another post on the forum and I think it has worked...

    please hold... lalalalalalal *ding*

    It worked. Excellent, thankyou for all your help. Now this is sorted, hopefully I don't need to change it again.
    Now to sort out image uploads :)

    Thanks everyone, and thankyou especially to Sam B whose install of my WP was amazingly quick.

  9. Samuel B

    Posted 9 years ago #

    Wow! You're a go getter. I just had a look at your site. Very good! I'm glad you're all fixed up.

Topic Closed

This topic has been closed to new replies.

About this Topic