WordPress is built to import and export content. As such, there is no built-in way to import or export settings. Some theme and plugin authors, however, have built tools into their systems that import/export XML files that their systems can use store options. A great example is WordPress SEO by Yoast. Not only can you … Read more
If you can install and manage plugins on this site, install wp-dbmanager – you can use this to export your full database. If it will be living on the same URL, you can use the same plugin to import the DB for the new install.
Caveat This is extremely bad for SEO. Having duplicate content can ultimately cause your site(s) to be removed from search results. Solution This is actually pretty simple to have one database and disk content. Point both of the docroots to the same directory. Make sure each server name in your Apache config for each domain … Read more
I normally use mysqldump and sed: on old server: mysqldump -u user -p OldWpdatabase > wpdb.sql sed -i ‘s/oldurl/newurl/g’ wpdb.sql on new server: mysql -u user -p NewWpdatabase < wpdb.sql sed is used to search and replace all the hard coded occurrences of the website if needed.
A lot of people (including myself) have experienced random issues like you describe with this latest version of the WordPress Importer plugin. I recommend using WP Migrate DB. This plugin will not only migrate your content, but allow you to optionally find/replace any serialized URLs (in the event you’re migrating to a different domain as … Read more
I think that importing attachments separately (which is not possible with native export) is precisely cause for your issue. Importer plugin has following code: if ( $post_parent ) { // if we already know the parent, map it to the new local ID if ( isset( $this->processed_posts[$post_parent] ) ) { $post_parent = $this->processed_posts[$post_parent]; // otherwise … Read more
Have you checked out Create A Network on the codex? Essentially: Add define( ‘WP_ALLOW_MULTISITE’, true ); to your wp-config.php Access Tools > Network Setup from the admin menu & follow the instructions.
I’ve just had this or a very similar problem (I didn’t use the WP export tool, but instead did a manual migration from one environment to another). As far as I can tell, the problem occurs because of how WP stores the thumbnail data in the the wp_postmeta table (with the key ‘_wp_attachment_metadata’). This data … Read more
Worst case scenario, just make a new environment, with that theme (can even be on the live), then just re-upload the CSS and anything else you’ve edited (successfully that is).
The problem occurs in MySQL 5.6.20 or later, if the innodb_log_file_size in the my.ini is set too low. I changed mine to 16M and the problem went away. Thanks to @Otto for the solution. http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-20.html