So I've been playing with Dreamweaver and Coldfusion lately, and I'm starting to mess with PHP a bit. I have yet to publish a dynamic site, so I don't really understand - where does the MySQL database go for a PHP site?
With Coldfusion I was just using an MS Access database, and it could live in the same root folder as the rest of the site. I assume to publish that site, I'd just publish the whole root folder like usual, and since it contained the database I'd be good to go.
MySQL, on the other hand, puts the database in the MySQL localhost folder on my machine - separate from the rest of the site. I can still create a connection to it in Dreamweaver, but what happens when I publish this site? The database isn't in the local root website folder.
I can always just upload it separately... but does it go anywhere special on the web server, or just in the root folder? Or can I somehow create a MySQL database that's inside my PHP website local folder from the beginning, so it just gets published with the rest of the site?
I hope that makes sense... thanks.