Setting up a Database on Test Server
I am using XAMPP for local testing. I would like to fully create my web site and database on my local machine. Once the site and database are completed I would then like to upload them onto a remote host.
I wondered how to set this up correctly on the local host. Where should my local host database be stored. Setting up the connection in Dreamweaver should be straight forward I just want to confirm where I should store the database on my local machine and if it would make a difference where it is stored?
I would change the connection settings when the site went live with the online host provider.