View Single Post
  #1 (permalink)  
Old 07-02-04, 12:40 PM
Mark_SC.SE Mark_SC.SE is offline
New Member
 
Join Date: Jul 2004
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Beginner MySQL (it requires an answer of some length im assuming)

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
Reply With Quote