I'm trying to build a site on a local server before exporting it to a live domain. I learned to install XAMPP (PC), create a database, and get a WordPress site configured properly so it's showing in my local browser.
What I'm not clear on is if I need to reference the same 'wordpress' database if I'm doing more than one local build at a time? Or do I need to create a new database for each local site and give each DB a unique name (i.e. not 'wordpress')? Or does XAMPP only recognize a database named 'wordpress'?
I use Dreamhost so I'm guessing I would create a new database there once I'm ready to export all the files, then change the wp-config.php to redirect to the new database and then go live. But I want to be sure.