[Mark_SC.SE]

Im a newbie to MySQL. Im wondering how getting MySQL online works?

Basically, with "MS Access" you create your database, and your ASP page and then upload both to a server and away you go.

Im running IIS on Windows XP Pro. And have a connection to a MySQL database and am running SQL queries on it and everything is cool.

But when you create a MySQL database, where does it get saved to? What folder. Because I cant seem to find it.

I think its saved to this folder "C:\mysql\data\dbtest" with the extention of ".MYD"

But what would I need to upload to a server. Do I need to upload more than just the database and the ASP page? Because in the ASP code you dont specify "databasename.MYD"

Im connecting to my database through

objConn.ConnectionString = "DRIVER={MySQL}; database=dbTest; server=Mark; uid=root;

Sorry for the longwinded explanation, but im trying to set the scene as best as possible.

Any info on how it all works to get MySQL running online would be great

Many Thanks

Mark

[perleo]

MySQL doesnt work anything like Access.

Firstly, you dont need to anything with those files in the data folder. You dont call them in the script, you simpily call the table name

To get your db online, you need to export the database to an .sql file, and run this on your server.
Try the MySQL online documentation.