Importing from hosted wordpress to wordpress.com – error message clarification
-
I am trying to export my blog from my host to wordpress.com; mainly for backup purposes but also in case I can’t renew my hosting, and I’ve installed the WP-Export plugin and doing it via the WordPress-MT-Wordpress.com method but I get the following message. Can anyone help me out? Thanks in advance.
<div id=’error’>
<p class=’wpdberror’>WordPress database error: [MySQL client run out of memory]
SELECT wp_posts.post_date, wp_posts.post_content, wp_posts.post_title, wp_users.display_name, wp_posts.post_status, wp_comments.comment_author, wp_comments.comment_content, wp_comments.comment_author_email, wp_comments.comment_author_url, wp_comments.comment_date, wp_post2cat.category_id, wp_categories.cat_name FROM wp_comments RIGHT OUTER JOIN wp_posts ON ( wp_comments.comment_post_ID = wp_posts.ID ) LEFT OUTER JOIN wp_users ON ( wp_posts.post_author = wp_users.ID ) LEFT OUTER JOIN wp_post2cat ON ( wp_posts.ID = wp_post2cat.post_id ) LEFT OUTER JOIN wp_categories ON (wp_post2cat.category_id = wp_categories.cat_ID)
</div> -
MySQL client run out of memory
B*tch to your host. They have the memory setting set too low for MySQL on their server.
Um, also WP-Export won’t export your categories. Give me about 5 minutes and I’ll post the one that I use. (I can’t find it in the WP.org forums.)
-
For once, a screw up and it isn’t my fault! Phew.
Thanks drmike.. I’ve been struggling with this all day.
-
Here you go. Doess all of the categories although you will have to sort them into subcategories after the importing.
Drop that in your blog’s root directory and run it from your browser. Save the output and import that into your WP.com install via the MT importer.
If you get 404 errors on this end or out of memory errors, try dividing up the file a bit. I usually recommend 50-75 posts per file, a smaller number if your posts are large.
I will also post this one as well as I modified it a bit. You’ll note that this one also kicks out a “This post was originally posted here” type link with links back to the original blog. Feel free to use that one if you want. Do note that the website URL and name is hardcoded. You’ll have to change it before running it.
I didn’t write them but found them over at the WP.org forums.
edit: Second link fixed. Sorry about that.
-
-
Oops, change the file name from exportWP2MT.phps to exportWP2MT.php The ‘s’ stands for ‘source code’ Sorry about that. Make sure it’s also in the same directory as your config.php file. It is not a plug in.
-
No go. I just keep getting the same screen as before. Let me just make sure I’ve got this right:
I download the file as .php, upload it into the folder that has my wp-config.php file, change the appropriate CHMOD settings and then run the script.
Or have I missed a step somewhere?
-
I just get the same screen as what I had earlier. Here’s a link to the page: http://www.idlanzakaria.com/wordpress/exportWP2MT.php
Thanks again for helping me out with this.
-
I hate to say it but it’s either something up with your server or the file somehow didn’t get over there correctly. I just copied and pasted the file from here and it comes up fine. (Reminder, large file)
Is there some method you can copy and paste the file instead of uploading and downloading? I wonder if your handling it as php changed it to output somehow.
-
I’ve tried different ways of acquiring the .php file – copy and pasting, save-as, changing various CHMOD specs etc. but I keep getting the same problem. I am beginning to suspect it may be host related now. Am pretty much on the verge of giving up now. Ah well, maybe one day I will be rich enough to pay a research assistant to manually copy the individual entries.
-
idlan – if you can get a database export of your existing blog (it’s an .sql file) then I’ll try and help. I’ll create a blog, import your db and see what we can export from that.
If that could be useful, drop a feedback in and I’ll give you the email address to send it. -
Hi podz
Thanks for the offer. I’m taking every shot I can now. Yup, I’ve got a .sql backup of my blog – it’s about 10MB though.
-
-
Thanks to both drmike and podz; I think I’m well on my way to sorting things out now.
:)
- The topic ‘Importing from hosted wordpress to wordpress.com – error message clarification’ is closed to new replies.
WordPress.com Forums 