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


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.


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!


I recently gave these instructions in this answer.

Short Version:

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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