-
Website
http://technosailor.com -
Original page
http://technosailor.com/2006/07/05/wordpress-to-wordpress-import/ -
Subscribe
All Comments -
Community
-
Top Commenters
-
AndyBeard
7 comments · 4 points
-
Rob
12 comments · 101 points
-
GeekMommy
4 comments · 15 points
-
chrisbachmann
5 comments · 1 points
-
chrispian
4 comments · 1 points
-
-
Popular Threads
Great work!
Textile and MArkdown are both plugins. Therefore they are filters of the_post(). If you look in the database at the raw entry, it will have all the textile/markdown markup. It's not formatted there. When the_content() is called and filtered on Markdown or Textile, the formatting comes through.
That being the case, if you import a WordPress blog that has been using Textile/Markdown, you'll be pulling in the raw content that is unformatted. To preserve the formatting, the new blog will have to have Textile or Markdown enabled as well.
And I couldn't help but notice The Wire: Season 1 peeking at me from below. Great, great show. First class all around in my opinion. McNulty man.
Even for just a few posts to test, this plugin in invaluble!
I've just tried to import my old wordpress blog into wordpress.com . Sadly it says
Sorry, there has been an error.
The uploaded file exceeds the upload_max_filesize directive in php.ini.
The file is about 2.1mb. Is there any way I can chop the file?
regards,
Steven
Worked without a hitch and all is great with the world again.
The plugin is giving me an error when I activate it in my wp1.5.1.3 version blog:
Warning: Wrong parameter count for substr() in /home/grace/public_html/wp/wp-content/plugins/wp-xmlmigrate.php on line 12Consequently, I am not given an option to export.
I am on the verge of closing my old blog (leaving a host) and your plugin promises to preserve just files I care to keep.
I would appreciate any help you could offer. I am using your plugin version 1.0.
Thank you for the right plugin at the right time!
Update: I decided to try to remove line 12 along with it's corresponding brackets . . . and It Worked! :)
I thought this would still be worth posting.
Now, I suppose I also wouldn't mind being able to easily export my links. Just in case. :mrgreen: (How come wp doesn't allow for subcategories for links, anyway?)
As for the rest of the import, unfortunately this is not a full fledge importer. This is a plugin that duplicates behavior in the next version of WP. I suppose I might be able to figure out how to do the links and cats, etc, but everything would get a little complex for an XML file. We'll see.
Great Plugin! But the import dont work at my blog. I import the xml file an after a while I get the message to download my admin.php! Whats wrong? Hope you can help me!
killercup
please help me! i have to migrate a blog with more than 500 osts an sql-import crashes because i got an error when i want to write a new post.
is it clever just upgrade to the newest beta?
if this is an server-problem, please tell me, else it might help to split large files on export!
i hope you can tell this some other developers and there will be an option to split the export e.g. in month.
if ( ( '2.0' == substr( get_bloginfo('version'), 0, 3 ) ) || ( '1.5' == substr( get_bloginfo('version'), 0, 3 ) ) )
Now to rebuild my site and move it back!
"Import WordPress
Warning: file(c:Inetpubwwwrootwordpress/i/2006/08/wpxml) [function.file]: failed to open stream: No such file or directory in c:\Inetpub\wwwroot\wordpress\wp-admin\import\wordpress.php on line 81
Warning: implode() [function.implode]: Bad arguments. in c:\Inetpub\wwwroot\wordpress\wp-admin\import\wordpress.php on line 82"
I'm guessing it's somehow related to the way the path looks in the first message. Export works great, so does import of RSS which I just tried so what could be the cure for the errors above?
Thanks again!
For it to run on IIS I had to add
enctype="multipart/form-data"to the form-tag in wp_authors_form().Not to be an ungrateful hag, cause it took me about three seconds to fix, but the resultant file had this at the end (html stripped):
Warning: Missing argument 1 for wp_die() in /(path removed)wp-includes/functions.php on line 2447
Warning: Cannot modify header information - headers already sent by (output started at /(path removed)/wp-content/plugins/wp-xmlmigrate.php:59) in /(path removed)/wp-includes/functions.php on line 2448
...followed by some HTML for a mostly blank page. Eep!
thank you for making everything easy.
Google Translation, pardon:
Estoy enterado de la edición pero no he calculado hacia fuera una solución todavía
When they get exported, they're pointing to the current post id of their parent, which means when they're imported (since the ids change) the sub pages all disappear. They're in the database, they're just no longer linked to their parents.
On Firefox / WindowsXP it shows a resulting html page with a summary of my site, not a WXR file, and nothing to download either.
What am I doing wrong? WP 2.02.
So I've added the post excerpt to the the export and import script. If you want I can send it to you.
Everytime I update a site it updates the main blog.
Thanks!!
i tried to import my 600 blog-posts on wordpress.com but it just creates a timeout and nothing happens.
i suggested this a while ago and i see this would be really nice: split the export file into one file for each month! so you can import one file after another and i think this might work!
even i was able to follow your instructions!
thanks, mark
No error message whatsoever.
when i use the exporter i get an xml file which is 9.8mb - then when i try to import it i receive a message which states
"Sorry, there has been an error.
File is empty. Please upload something more substantial."
this is on a mac in Safari and Firefox, wordpress 2.04
i want to export certain posts under a category from a 2.0.3 wordpress install :D
Upon attempted import of wordpress filem, I just get a message -
"The uploaded file could not be moved to ."
I'm guessing chmod? If that could be it, what exactly should be chmoded t owhat settings?
Here is a link that may help:
http://www.tamba2.org.uk/wordpress/restore/
I too have a Yahoo SQL output file but I can not seem to get things to work as per the instructions. I'm still trying to transfer my old Yahoo hosted WP posts to my new WP site.
Let me know how you make out.
Jld
It's a great plugin but I think I've found a flaw of sorts. I recently moved my blog to a new domain using the plugin and then redirected (301) all the old permalinks to the new ones. For about 20 posts out of 440 I've been getting 404 errors from the redirect. At first I thought the pages were missing but that's not the problem -- they are there but their slug has been changed and hence the permalink. Each affected post is one where WP would have mangled the slug originally to avoid a collision.
EXCELLENT WORK!
You guys rock!
====================
Import WordPress
Warning: file(C:Program FilesApache GroupApachehtdocsvirtualhostswww.bikinizero.comwp/wp-content/uploads/2006/09/bzxml): failed to open stream: No such file or directory in C:\Program Files\Apache Group\Apache\htdocs\virtualhosts\www.bikinizero.com\wp\wp-admin\import\wordpress.php on line 81
Warning: implode(): Bad arguments. in C:\Program Files\Apache Group\Apache\htdocs\virtualhosts\www.bikinizero.com\wp\wp-admin\import\wordpress.php on line 82
All done.
====================
We have a wordpress.com hosted blog, and now have installed WP on our domain. We want to import all 50+ of the old posts from wordpress.com blog.
Is that what this is supposed to do?
Upon attempted import of wordpress filem, I just get a message -
“The uploaded file could not be moved to .”
and that's all it says!
I told someone this 'might' work, and I'm REALLY diappointed that it didn't. With all these glowing reviews, I was starting to think I was insane.
In my experience the import/export worked really nicely. There's one potential pitfall though if you want your new blog to exactly mirror the old one (so that for example you can redirect from old to new). The import process may mangle post slugs and permalinks wherever the posts have the same title.
i ve got a multi-user blog and now one user wants to get an own blog on wordpress.com. Is there any possibilty to export only the articles from this user? or is there anther way for him to transfer his entries to wordpress.com without copy&paste everything?
Warning: implode(): Bad arguments. in D:\hshome\ummera\ummera.com\wordpress\wp-admin\import\wordpress.php on line 82
For two, look at your php.ini file and check out your setting with magic_cquotes_gpc. This is stripping your slashes. This is not my problem. This is a PHP config problem.
Thirdly, you're running on Windows. This could (I don't know) be throwing wackiness your way too.
First, you need to have an "uploads" folder, and it needs to have the right permissions. My setup did not have an uploads folder at all. The 2nd thing to check, was I had done some weird things with my permalinks and .htaccess file.
In the end I moved mine by hand, but I only had 10 entries.
i get this message:
"Howdy! This importer allows you to extract posts from wordpress RSS 2.0 file into your blog. This is useful if you want to import your posts from your local machine to the server on which you see this page. To get started you must fill in the "option" page"
but there is no option page... waht to do?
My original post 65, and 113, and 118 all have gone unrespoonded to by the developer, although Candic had a suggestion in #123, she never tried it.
In addition, your problem is with the Importer. I need you to re-read my entry. I don't support the importer. I didn't write it. I only bundled it. If there is a problem with it, it needs to be reported to the WordPress developers.
Please don't poison the readers with snide comments about my support when you yourself have not read my entry and understood it.
Rebeca: What's the issue? Instructions in the entry? Have you followed them? Are you getting an error somewhere?
This is presuming you're running on a Windows platform. That's what it seems.
I told you I was a newbie:)
WordPress database error: [Lock wait timeout exceeded; try restarting transaction]
I don't think this has anything to do with your plug in right, but if you could translate that for me?
Just to clarify, this is my (and a fewo thers) error, because I notice your post numbers have changed -
Upon attempted import of the apparently successfully exported wordpress.com file, I just get a message - “The uploaded file could not be moved to [blank] .” {blank} is not actually shown, it's just blank.
With my comment in #132, i'm wondering if maybe I really do have the wrong opinion of what this is supposed to do.
Take all my wordpress.com posts from their hosted blog and host it myself, right?
However I think I found a bug : I have child pages in my blog. They are well exported, but importing them silently fails : the importer lists the child pages as being imported, but they are not.
The opposite of Kathy, we're actually trying to move FROM the free WP site to our own webhosts and servers, and getting the error - “The uploaded file could not be moved to .”
Might that be it?
I went into the XML exported file and split off the posts that didn't import and ran it again just for those posts, but wanted you to know.
Thanks
Now, I want to to use it to import my wordpress.com to a new wordpress.com blog hosted under Joomla!.
I added the WordPress component to Joomla! from http://projects.j-prosolution.com/, which went without a hitch and seems to be a typical WordPress installation (Version 2.0, I think).
I uploaded your plug-in files (Version 1.0.2) to the appropriate places so I could import my WXR file, as per the instructions, and went to import it. I browsed my hard drive and found the appropriate file and clicked "Import". I waited while it did its thing, then it asked me about author names. Whether I change anything for the author name or not, it doesn't seem to matter as far as the results go, and then click "submit". I then get the message:
1.Importing post 'Blah blah blah'...
Fatal error: Call to undefined function: username_exists() in ..../wp-admin/import/wordpress.php on line 60
If you look in this file, this function is indeed not defined. Any ideas?
I think that the problem may be that the import program is not recognising that there is already an author and thinks it has to create one. I'll keep hacking...
Is there an easy/automatic way to chop up such a file? The whole reason I want to move from standalone to WordPress.com is so I don't have to deal with this sort of technical trouble.
If anyone has any ideas or hints, please give me a holla!
Thanks!
Warning: file(C:Program FilesApache Software FoundationApache2.2wwwwordpress/wp-content/uploads/2006/10/wordpress2006-10-27xml) [function.file]: failed to open stream: No such file or directory in C:\Program Files\Apache Software Foundation\Apache2.2\www\wordpress\wp-admin\import\wordpress.php on line 81
Warning: implode() [function.implode]: Bad arguments. in C:\Program Files\Apache Software Foundation\Apache2.2\www\wordpress\wp-admin\import\wordpress.php on line 82
be solved after all? I still haven't found the solution...
I set up a WP.org blog for a friend on my hosting account and now I want to move him to his own host. Amazingly enough, he is even less techno-literate than me, so I'm thinking about putting him on WP.com. His blog is on v 2.0.2. Can I use this plug-in to do this? Oh, and will it preserve the URL's? Thanks for any help you can offer.
ALL PAGES ARE EXPORTED
ALL PAGES ARE IMPORTED
However, somehow (and this is where I fail to come up with an explanation) when the post_parent field is not "0", the pages become invisible to the query"SELECT * FROM $wpdb->posts WHERE post_status = 'static'" in wordpress.
Going in via phpMyAdmin and manually changing the post_parent field to 0 fixes it. Changing the parent via Wordpress UI afterwards keeps it visible.
My only guess is that it may have something to do with data type definitions... No clue, honestly.
But I would cheer a fix by someone more competent than myself. God knows I have done as much as I can towards sorting this out.
Any suggestions? Thank you :-)
I suppose I have the same problem as charlie just above, though my error is in Finnish, translates maybe: 'Transported file could not be saved as .'
('Siirrettyä tiedostoa ei voitu tallentaa nimellä .')
My original problem was with the server, I think: I couldn't import from Blogspot, so I put up a wordpress.com blog and moved my stuff first there.
- Shouldn't your plugin create a WXR file (WordPress eXtended RSS)? To me it's creating a .xml file
Anyway, I was able to import the xml file as RSS, worked fine.
I wonder if linking into this post made it visible here?
http://wordpress.org/support/topic/59986?replie...
When I changed my folder permissions, I was able to upload the file.
I get this when I click button to export:
Safari can’t open the page “feed://www.cfcure.com/bluestravels/wp-admin/edit.php?page=wp-xmlmigrate.php”. The error was: “unknown error” (NSURLErrorDomain:-1) Please choose Report Bug to Apple from the Safari menu, note the error number, and describe what you did before you saw this message.
??? Thgis is the 1.02 version
Safari can’t open the page “feed://ironmind.cfcure.com/wp-admin/edit.php?page=wp-xmlmigrate.php”. The error was: “unknown error” (NSURLErrorDomain:-1) Please choose Report Bug to Apple from the Safari menu, note the error number, and describe what you did before you saw this message.
I get this in all my blogs. This plugin is failing to work.
I want to use this plugin to move *part* of my weblog to a WP.com-hosted weblog.
Right now, my blog is hosted on my own domain; I want to move certain categories to a WP.com blog and keep my original blog for other purposes. I installed the plug-in, but whenever I click the Download Export File button, my feed reader opens and tries to import the XML file as a news feed.
What can I do?
(BTW, I'm running WP 2.0.1.)
Make a backup of your blog and export it. Save it in safe keeping.
Then, delete the catageories and entries you do not want to import, and RE-EXPORT the scaled down verion of your blog.
Then, import back into your blog the first export file. It should not create duplicate posts, should it? Any one.
Then from your other blog, import the smaller, scaled down export of your WP blog, and inthat way you will import only what you wanted to import.
Does anyone disagree with this approach?
What gives??
First of all, thank you because this is what I wanted!
I have exported my WP 2.0.5 blog and imported in a test wordpress.com blog.
Everything OK, BUT
embedded video dissapear :(
Compare:
Original post:
http://enrique.brito.es/blog/archives/257
Backup copy:
http://enriquebrito.wordpress.com/2006/10/27/mi...
What about pages?
Have you planned an update to cover pages too?
By the way, I´ve used 1.0.2 version because I don´t find 2.0 import/export download link.
hehehehh
:sigh:
Could it be possible at IMPORT to select REPLACE or APPEND posts?
i like the option to export only some categorities, so:
what about an option to choose which months to export? with this you can e.g. backup old posts and comments with one file per month. and further it would be possible to backup a month at its end automated with a cron job!
i hope you'll have a look on my suggestion and give it a chance to get implemented! ;)
Thanks for this wonderful plug-in
Sorry, there has been an error.
Unable to create directory /users/home/rickschmoo/web/public/wp-content/uploads/2006/11. Is its parent directory writable by the server?
I've checked and everything seems to be writable. Any ideas?
Or is there any other way of doing this?
I searched the help site but found no info on importing a WP.com blog into a WP 2.04 blog. Though I did find your article and found it extremely useful
Can you help me out with this? I really do not want to loose my old blog and recreating each post manually in the new blog is quite painful.
thanks.
Not sure why you would import via RSS when this plugin gives you the chance to import a WordPress export file? If you read the entry, you'll realize that this plugin is exactly what you need to move from wp.com to a wp blog.
Cheers.
1. Exported WP.com as WXR
2. In my WP blog, went to Import and clicked Wordpress
3. Gave the path of the file generated in step 1
4. Everything got imported just like you said.
The only problem is that when I click the post titles, comments, or post category. I get errors similar to this:
"Not Found
The requested URL /blog/“/commentary/about-to-move/†was not found on this server."
You can check out www.manukhanna.com.
Can you suggest a solution.
thnx so much for ur help.
afer downloading above zip file, when i try to double click it in windows XP, it gives me error that it is invalid zip file.
after that i got the file from one my friend. but now the problem is, when i import, it created similar number of categories as the number of posts.
so what i do to solve this error ?
kindly help please
2. Which version of WP are u using?
3. I think u r choosing the wrong version of the plugin.
3. R u trying to import a WordPress 1.5.x blog? if so use the plugin version 1.0.2
I have free wordpress blog with 60 posts. It is in NON-ENG langague (i mean gujarati languge) category names are also in gujarati.
Now today i want it to transfered on my own domain so i exported XML file from free blog and i setup all the things including your tool on my domain and then started import.
Import worked very nice and i got all posts and comments. But there is a big problem in category.
If there are 50 posts it creates 50 categories. and without any name. for exmaple (1) like this.
all posts are not filed under proper category.
kinndly help me sir to solve this problem. I am very much confused since last so many hours. Is it bcos of NON-ENG categories ? do i have to attach all post manually by createing catgory on my domain ?
waiting for your reply.
thanks sir.
bye
Export worked fine and the import to a test wordpress.com blog was correct.
So, perhaps your characters, your language is too many different from English.
HAve you selected UTF-8 coding for your blog? WARNING: changing character coding may produce extrange caharacters.
(OPTIONS --> READ --> FEED AND PAGE CODING) I think this is the route in English. My blog is in spanish, remember.
I hope this helps.
my blog encoding is already utf-8 but still it is not working.
Super Idea!
pl. help.
but when i import it on my domain, it creates 63 categories bcos there are 63 posts. It gives the name to all categories as (1) like this.
NONE OF THE CATEGORIES FROM MY EARLIER BLOG ARE IMPORTED.
please help.
BTW will the old version still work?
but the regular expression looks like this...
'|(.*?)|is'
I changed it to this....
'||is'
Which works but probably not the best, I didn't feel like figuring out if or how I needed to escape '[', ']', and '!'
It works with that one simple change.
![CDATA[Category Name]]
my email is mailtomulder at gmail dot com
Basically, the exported output is FILENAME.XML, but it looks like the import function is looking for FILENAME.WXR. Simply changing the extension has no effect. Uploading the file with either extension results in nothing. No import, no error messages, nothing.
There's more detail in my post on the support forums, where there's another blogger having a similar issue:
http://wordpress.org/support/topic/95309
How do I use the output file to re-import?
Sandra: wordpress.php is bundled with the plugin.
I'm looking for someone who is excellent with WordPress and willing to provide their services to me - of course I will pay. I'm in the Cayman Islands and help seems a long way off - any takers?
Tim
Teasing.
Hehehe
I did an import from wordpress.com to a hosted wordpress blog this morning using the new importer and catgeories are preserved. Looks like that bug was squashed.
Both tarball and zip links have been updated.
WordPress 2.1 should be out in the early part of next year and it will have all of this functionality built in. Word of caution for anyone hoping to upgrade right away - make sure all your plugins are compatible before you move. During the WordPress 1.5 to 2.0 changeover, there was a running compatibility checklist of known plugins over at the codex. I imagine something similar will be done with this change over as well.
Feel free to continue to use this plugin on 2.0.x blogs until you're comfortable that switching to 2.1 won't break your blog.
Safari can’t open the page “localhost:8888/wordpress/wp-admin/edit.php?page=wp-xmlmigrate.php” because it cannot redirect to locations starting with “localhost:”.
A quick and dirty fix seems to be commenting out (by adding two forward slashes to the start of the line ie. //) the following line in wp-xmlmigrate.php:
header('Content-type: text/xml; charset=' . get_settings('blog_charset'), true);
in the function export_wp($cats)
Warning: implode(): Bad arguments. in /home/content/r/a/r/rarmbrust/html/old/wp-content/plugins/wp-xmlmigrate.php on line 71
WordPress database error:
When I export using the plugin, it generates a nearly blank file that contains the above error.
Please help...
I went into the XML file and cleaned up some case-sensitive mismatched tags, legacy HTML (mainly in comments with people entering their own) and other malformed code, but even after that it won't import. After uploading, I get a mostly blank page, and when I manually edit the URL in the browser address bar from "step1" to "step2" I get this:
See this page for screen shots explaining what I mean.
If you need the latest importer that may have changed since the current version of this plugin was released, I'd recommend going and grabbiing the 2.1 source from SVN and use wp-admin/import/wordpress.php.
I can't repeat enough. I don't maintain or support the importer. This plugin support goes with the EXPORTER which I wrote.
:-)
it says that the zip file is corrupted. any ideas?
More important though, is there any problem importing now, several months after the blog has gotten going?
We abandoned the old one, and never imported, but still have the export file.
Will the original posts and dates from the Wordpress.com hosted, all still be intact on my own hosted WP? I won't overwrite existing content, right? (I'm sorry, I'm not a techie)
WordPress database error: [Unknown column 'category_count' in 'field list']
SELECT cat_ID, cat_name, category_nicename, category_description, category_parent, category_count FROM wp_categories WHERE cat_ID > 0 ORDER BY cat_name
Warning: Invalid argument supplied for foreach() in /home/mydomain/public_html/folder/wp-content/plugins/wp-xmlmigrate.php on line 30
Is this a problem with my categories? I'd like to export all the categories. Is there some way I can just change the code to export all categories? I'm not up on any code that is web-related, sorry. Also, the old blog is 1.5.2!!! Is that still a problem?
For others like me who struggled for hours - it doesn't play nice with Safari (neither importing nor exporting). Use Firefox instead - I keep a copy hanging around on my hard drive for such occasions.
\"Postin\" -Southern Verb, to post. lol
http://trac.mu.wordpress.org/ticket/206
But then donnca reffered to your ticket as it was "somehow" fixed.
Did you try importing the xml file I uploaded in my ticket and no problem occured?
The uploaded file could not be moved to
what´s is worng, any permission?
it´s happens also with RSS importation.
could you help me ?
thanks
Much appreciated.
Kudos and more power!
I didn't want to upgrade my existing site since I was making a new one but with the old content.
Appreciate it.
I have tried to export my old site and get a different sized XML file everytime.
When I try to import the largest of these into my new WP2.1 installation it my browser spends some time uploading the file and then clears the import box from the screen leaving all other Admin Panel info there.
No posts, categories etc appear.
Doesn't restore my categories though :-( Got to edit 600 posts now...
Appreciate this still though.
All success
Dr.Mani
{
function export_cat_list()
{
global $wpdb;
$cats = $wpdb->get_results("SELECT cat_ID, cat_name, category_nicename, category_description, category_parent, category_count
FROM $wpdb->categories
WHERE cat_ID > 0
ORDER BY cat_name");
return $cats;
}
}
I scratched my head, bit the bullet, and simply edited out "category_count". Worked like an absolute charm.
I really appreciate your efforts with this plugin and utility!!
Anne
...after setting the uploads folder to 777. It could be mentioned in the original post, because the error message (from WP) is too mystic...
$ ls -l
-rw-r--r-- 1 kpelto users 6987 Feb 26 22:31 wp-xmlmigrate2.tar.gz
$ gzip -d wp-xmlmigrate2.tar.gz
$ ls -l
-rw-r--r-- 1 kpelto users 6964 Feb 26 22:31 wp-xmlmigrate2.tar
$ tar -xf wp-xmlmigrate2.tar
tar: Read 6964 bytes from wp-xmlmigrate2.tar
tar: This does not look like a tar archive
tar: Skipping to next header
tar: Error exit delayed from previous errors
GNU bash, version 2.05b.0(1)-release (i386-pc-linux-gnu)
gzip 1.3.5
(2002-09-30)
tar (GNU tar) 1.14
I use cpanel. Does anyone have a good idea of how this might be done? Would I have to make an export.php file for each individual author? What would the cron job code look like?
I think its a cool idea, just not sure how to do it.
I'm having the same problem as DIego, when I try to import I get the message:-
The uploaded file could not be moved to .
It looks like a permissions problem but where to start?
Just like to thank you for making this available to everyone. By the way, th plugin doesn't seem to work anymore upon upgrading to the latest version of WP. Just thought you should know. :)
Will
This plugin is awesome, just what I was looking for. Looks like you've made a lot of people very happy.
I was just wondering, does this plugin also have the option of exporting/importing custom fields and post excerpts? Also some plugins create their own tables in the database, does this have the option of exporting/importing those as well?
Thanks a lot for your time and patience.
Thx, great idea for a plugin btw.
I've installed and activated the plugin, but I really dont know where to look for the plugin's admin page. There's no WP Export option in the Manage menu.
Is it located somewhere else?
Sorry to ask this, but I cant find it...
Thanks
Error:
WordPress database error: [Unknown column ‘category_count’ in ‘field list’]
SELECT cat_ID, cat_name, category_nicename, category_description, category_parent, category_count FROM wp_categories WHERE cat_ID > 0 ORDER BY cat_name
Warning: Invalid argument supplied for foreach() in /home/mydomain/public_html/folder/wp-content/plugins/wp-xmlmigrate.php on line 30
I go through and use the export feature - end up saving the XML file to my desktop. (It is always the same size - 4.32MB.) Then, I go to the new blog and use the import feature. Everything goes smoothly - it asked me for the author and all that jazz, BUT it only uploads 95 posts of the total ~350. It doesn't seem like 4.32MB is that large a file, so I do not understand why it doesn't upload all of them. I can edit and view all the other posts. They are still in categories - so everything else seems to be working.
How do I move all of the posts? Is there a step-by-step troubleshooting you can point me to? Anything would help. :)
Although my export file was relatively small, I think the size was the problem. I ended up deleting all the already imported posts, and ran it again, which allowed me to import the missing posts.
Thanks again!
It's very useful for me.
Using this plugin copied everything, and I mean everything! Thank you!
Because the plugin inserts the , because of those extra symbols, the author or poster's name does not show up. Is there a way around this to fix it, instead of manually editing everything?
Any solutions? Don't keep them a secret!
Go to plugins and click the "edit" button next to the export plugin...
change the first line of code to something like this:
if ( ( '2.0' == substr( get_bloginfo('version'), 0, 3 ) ) || ( '1.5' == substr( get_bloginfo('version'), 0, 3 ) ) || 1==1 )
Note the || 1==1... that's the part I changed.
Hope this helps.
I´m using Wordpress 2.3.3
Any way to fix it ?
Thanks
The only thing that I\'m having trouble with is my blogroll. Have you ever seen a plugin that can export the WP 2.0.2 blogroll to OPML?
Evan
Needs to be
2. Rename wp-admin/import/wordpress.php to wordpress.old
3. Upload wordpress.php to wp-admin/import/
// if ( ( '2.0' == substr( get_bloginfo('version'), 0, 3 ) ) || ( '1.5' == substr( get_bloginfo('version'), 0, 3 ) ) )
// {
And this line at the second last line of the code:
// }
just before the PHP end tag
I used the method in #333 (actually tried it before I read that) but also I had to reformulate the xml stream. I just changed it to 'text' instead of 'text/xml' because (and maybe it's just safari -- others could be more forgiving) my browser didn't appreciate the format!
But then it worked.
Thanks! Cheers!
I had an old Japanese blog using Wordpress ME 1.5.1.3. I was lazy and never updated it. Finally a problem bubbled up because of some new database version at my host. I had to do a couple of tweaks suggested by commenters above to get it working.
First I added the 1=1 trick to the if statement. This allowed the export option to appear because it wasn't there at first.
Second I had to delete category_count as Anne suggests above.
After that, the export went fine, and I was able to import everything perfectly into the latest Wordpress 2.6 (Japanese version). PHEW! THANKS AGAIN!
WP 2.1 or better.
I want to import my content from WP 2.0.9 to the latest WP 2.6 which is complete new Website/DB. I created a XML file with this great plugin and copyed the wordpress.php to the folder mentioned above to WP 2.6.
The import works for the posts, comments and categories. BUT it does not show my static pages which are importent for my website. I saw that the content is inside the DB, but it has the value "post_type" = "post". But shouldn't the sites have the value "page"?
If anyone can help me - that would be great - it's really frustrating.
Additional does anybody explain me, how I can export my TAGS from Ultimate Tag Warrior to the new Wordpress installation?
That's the next step I have to do after the "pages" works ...
THANKS FOR HELP!
versions of WordPress have introduced post_type='page'. I don't know how
soon I can release an update. I recommend you checkout WP 2.1 via SVN and do
the import into 2.1, then upgrading to 2.6.
svn co http://svn.automattic.com/wordpress/branches/2.1 .
I recommend doing a dry run of the whole process on a development blog to
make sure it works properly. In the meantime, I'll try to update this in
time for WP 2.7.
Thank you!
I miss the category wise import/export in wordpress's build in importer/exporter. Is it possible to make this plugin work and allow category wise import/export in newer wordpress?
Thanks for this plugin.
Best Regards
JAX
After finally deciding to upgrade to 2.6.1 from 2.0.4 I thought I was screwed because of the new database structure, but your plugin made the job soo easy!
Thanks again and all the best.
Great plugin, absolutely saves the day.
Note however that for non-english characters to import correctly, the file that is imported (on Wordpress.com) needs to have UTF-8 character encoding. In my case, both old blogs were in Latin-1.
Changing a file from one encoding to another is a matter of the operating system and software you have installed on your computer. I used TextWrangler (Mac):
1. Open file
2. If characters are all scrambled, choose File > Reopen Using Encoding > The encoding your file has (in my case Latin-1)
3. At the bottom of the screen click the name of the encoding and select "Unicode UTF-8" instead.
4. Safe the file
In Linux, there is a command line tool called 'convmv' and you can do something like:
convmv -f latin1 -t utf8 FILENAME
Hope this helps for those that have foregin language blogs.