2017-08-02 -- Exporting through the WordPress panel is not reliable and is broken for large blogs.
- I use PhpMyAdmin and dump the entire table as an SQL file.
2015-12-10 -- My concerns are no longer valid.
- It's easy enough to FTP-download the images, and re-upload them to a new place.
- Exporting and importing the "WordPress eXtended RSS" (WXR) file is trivial.
- A simple XML file is small enough that there should be no file size concerns.
While there are export and import features in /wp-admin/export.php, I did some thinking and research to learn that there some issues with the functionality.
- Importing a large database is non-trivial
- There is no file/image backup-and-restore
Changing URLs requires setting changes or database editing
1. Importing a large database is non-trivial ∞
- Some browsers have issues transferring large files.
Most databases have low limits for the size of database which they can import. It's usually around 2MB.
The first shouldn't be a big deal for me.
The second is really annoying, but there's nothing to be done. I would need to upload the XML file to the server and then do a manual import through SSH or whatever other tool, which is annoying but not particularly challenging.
2. There is no file/image backup-and-restore ∞
The official support topic says "any uploads and images will need to be manually transferred to the new blog". How vague of them. I still don't really know what this means. I'll have to manually keep a directory with a local copy of everything I've uploaded. I don't know if there's a simple way for me to automate the backup of an existing blog.
This is the kind of stuff I would have liked to learn before getting into all of this in the first place.
sFTP doesn't seem to work. The connection just gets reset. I also have some overzealous security settings on my system, so I'm not surprized.
FTP doesn't seem to work. The connection fails and reconnects all time out. They do not allow FTP.
I've contacted WordPress support to see what they say about an easier direct-download link on the Media Library page.
They say:
There isn't a way to backup the images. If you were setup a self-hosted blog though, when you import the export file you would have the option to download and import the attachments (images) though.
I guess what I could do is have a local copy of WordPress running, and then use it to pull the images. I could use a simple local LAMP setup for that. If/when I do that, I'll write a followup post.
3. URL changes require database editing ∞
I bumped into some references that a simple export/import will not work, at least in all circumstances. It seems that some people who change URLs need to do some editing to correct the blog's self-referencing links.
I've already been fairly careful to make sure that my manually-created self-pointing URLs are not absolute but are only relative. But that still won't work if I move the blog to a directory. I guess if I face that, I'd be working with some search-and-replace magic to correct my export file.
Resources ∞
I haven't really investigated this further, but I'll update this post when I have more information.
