Setting up a Database on Test Server

Hello:

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.

Thanks,
Glen

Do you need help setting up MYSQL(database) locally? Or are you wondering how you change database settings once you go live?

I want to create everything on a local machine until finalized then upload and go live. I just wondered if it may be necessary to have my DB in a sub folder in my root folder for the site or if it even matters.

Once the site is complete I would upload the DB to the host server and change the Dreamweaver settings to connect to it live.

Is this possible?

Thanks,
Glen

Yes, Once you are ready to switch to a live server, you can do a MySQL dump of your local database, and once you are live, you can import the dump to your live server and switch your connection settings to point to your live server.