The WordPress site is up and running on the web and just installed a local testing server (Apache/php/mysql) on my home computer. I'd like to suplicate the articles, categories, and pages from the web site database to the local testing server database.
When the site's (on the web) MySQL is exported, then imported into the MySQL on the testing server access to WP-ADMIN gets fouled up. When WP-ADMIN is accessed on the testing server it jumps to the web site's administrative area.
I've tried exporting/importing all of the tables except for the options table, but MySQL errors occur.
What is the trick to importing the articles posted on the web to the local testing server without fouling up access to the administrative area?