benwood

I just joined because my daughter’s wordpress-hosted blog croaked, and 1&1 could not, or would not recover it.

So… now that I know… I’ve been looking into how the import/export works, and I, too, was having trouble with the import. I’d get six of a hundred posts with an error message when it aborted.

I discovered what was tripping up my import, though, and it may help others. I’d used the image upload facility and named one image with a string that broke the import. This string is the one that appears as a tooltip (which worked as typed).

The error message:

WordPress database error: [Lost connection to MySQL server during query]
SELECT ID FROM blog_2_posts WHERE post_title = ‘Sandy on the ‘barisax’’ AND post_date = ‘2008-09-07 20:24:30’

The actual image title was
Sandy on the `barisax’

I changed this to
Sandy on the barisax

re-exported my block, re-imported into the new temporary blog and voila, it worked.

Those quotes in my label were the problem.

I still don’t have a solution to backing up my 1&1 blog, however, as the image files do not back up. They are on versions 2.2.1. 1&1 does not give me access to the actual files in the blog and so I can literally only back up the text and not the images. Better than nothing, kind of.