WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Hi i am currently replacing my blog run on wordpress with another neat theme. I tried the preview template feature and everything is fine, just that i don't trust everything so easily when it comes to web-applications. So i want to use the same database currently used[meaning not to use same database for both sites, but make a copy of the database/something with the data/posts] with the post/article and then perfect the theme with the data then replace the old with new. I would like detailed steps for just the database part others i can handle :) thanks for any and every help

share|improve this question
up vote 1 down vote accepted

Just use the built-in exporter/importer. Export from the existing site, and import into the new site. You won't ever even need to touch the database.

share|improve this answer

Here's a tutorial on how to export / import your WordPress database and run the queries you'll need so the new site works: http://web-kreation.com/tutorials/migrating-a-wordpress-site-ftp-phpmyadmin-and-sql-queries/

If you just want a local environment so you can play around with themes, this is a good tutorial for setting that up on your Mac: http://loneplacebo.com/how-to-install-mamp-on-mac-for-local-wordpress-theme-development/

And here's how you could do that on a PC: http://return-true.com/2010/09/setting-up-xampp-wordpress-for-local-testing/

Best of luck!

share|improve this answer

I recently gave these instructions in this answer.

Short Version:

Use find/replace on the domain and path in the sql dump file.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.