Check out http://wp-cli.org/. It’s fantastic and I’ve used the export capability multiple times. More information on wp-cli. WP-CLI is a set of command-line tools for managing WordPress installations. You can update plugins, set up multisite installs and much more, without using a web browser. You will most likely have to install wp-cli. You can find … Read more
Take a look at this WordPress plugin WP Static HTML output This plugin produces a static HTML version of your wordpress install, incredibly useful for anyone who would like the publishing power of wordpress but whose webhost doesn’t allow dynamic PHP driven sites – such as MobileMe. You can run your development site on a … Read more
It is that simple for WordPress too. I use the following to back up my WP sites: mysqldump -u <user> -p<pass> –quick –extended-insert <db-name> > backup.sql The mysqldump document gives the details on all the parameters. –extended-insert is quicker when updating a DB from a dump file and makes the dump file smaller. –quick makes … Read more
The solution that we have gone with in the end uses a single call to get_user_meta passing just the $user_id – this way all user data is returned in a single query, reducing a heavy load on the DB during large user data exports. We then run a series of checks against the returned data … Read more
Using multisite to develop then export to a single install is a bad idea. For one multisite behaves different than a single install and you want your dev to as close to the production as possible. It’s also a pain in the a** to manually export the right db tables then import them into a … Read more
Option 1 As the article linked by @MikeMadern suggests: in your web host control panel, go to PHPMyAdmin select the table wp_comments select Export, configure the format further down in the same screen, select the Save as file and Go Option 2 Or, as the same article suggests, just use a plugin: Export comments Pulls … Read more
https://github.com/scribu/wp-scb-framework/wiki This guy has built what you are looking for I believe. He’s a core-contributor and his code is top notch. And the project is open on github, so even better right?
This answer is essentially the same as Ünsal’s, but I’d like to elaborate a bit because despite being right his answer didn’t help me (I was just trying to remember what I’d done in the past, I should have read his more carefully and I would have figured it out, but I think for others … Read more
I had a very similar problem when I moved a WordPress Blog from a single WordPress installation to a Multisite installation with different domain names but same IP. I found out that the problem is the wp_http_validate_url function which drops the URL if the source IP is the same as the destination IP. You can … Read more
Anthologize A great option is the Anthologize plugin. It works with WordPress 3.0, allows you to format your book in WordPress itself, and then publish everything automatically to PDF, ePub, and other formats.