Export local WP install to live – help needed

This question I’m asking has been asked a thousand different ways, and I refuse to believe I’m the only one with a basic need here so here goes:

I’m taking a simple local install and putting it live. I’ve exported before, but it didn’t seem to carry over any categories/settings/authors/etc. HOWEVER, that was almost a year ago, and it’s entirely possible I didn’t do things properly since I was just starting to learn WordPress.

So, what I need is to ask “If I login as admin, and click ‘export’, does it…”

  1. Does it export all posts and authors, including the post meta? (what authors wrote what posts)
  2. Does it export all settings? (permalinks, discussion, reading, etc)
  3. Does it export all media? (images, videos, etc)

It’s a simple list, but I’m being asked to take a very messy existing WP install and make it sexy in local then put it live with the new theme I built. I just want to know what to expect, so I can plan accordingly.

Thank you all!

Solutions Collecting From Web of "Export local WP install to live – help needed"

Your easiest option is to just take a copy of your local database and import it to the server using phpmyadmin or similar.

You can then add these 2 options to your wp-config.php file to update the site URL.

define('WP_HOME','http://example.com');
define('WP_SITEURL','http://example.com');

That was you will get everything in the database on to the live site and then all you need to do is make sure all the files are uploaded including your uploads folder.

Alex’s answer is the way to go here. That said, for the sake of posterity, here are the answers to your questions:

Does it export all posts and authors, including the post meta? (what
authors wrote what posts)

Yes

Does it export all settings? (permalinks, discussion, reading, etc)

No

Does it export all media? (images, videos, etc)

Yes. Then on import, you have to tell WordPress to download all attachments. However, your live server needs to be able to query your local server publicly, so if your local server is at http://localhost/ or something, that won’t work.

Cheers~

I recommend using my free WP Migrate DB plugin. It exports your database like phpMyAdmin, but does a find and replace on the URLs and file paths that need to be updated. It also handles any serialized data, so widgets don’t get corrupted.

There is a pro version of it as well, that allows you to push/pull your database from one WP install to another without leaving the WP dashboard.