I've taken my wife's WP blog offline and installed XAMPP to keep it local on her PC for reference in her writing.
I copy all the WP files to the XAMPP/htdocs folder, but there appears to be no clear instructions on where to place the existing database files to access her blog. The instructions at http://www.tamba2.org.uk/wordpress/xampp/ don't seem to have any instructions on how to use an existing database. It looks like it's only set up for telling me how to start a new file. I placed the database in the htdocs folder, edited the wp-config file with so that the define('DB_HOST') line now points to 'localhost' instead of the server location it was at, and I get a "cannot establish database connection" error.
I kept the DB_NAME, DB_USER, and DB_PASSWORD lines the same. Obviously the database will still need to use those.
I know XAMPP works, because I typed localhost/index.html and the "It works!" html file came up. So I'm obviously not putting the database in the right place or my wp-config file is not set up right.