I have just moved from MS Access to MySQL, I haven't really got going yet, and I am a little confused at how I interact with a db created in MySQL. In the past I have always kept my database in its associated website folder within wwwroot. However, I have been advised to keep it in C:\mysql\data. Does it need to be here, or can I locate it in wwwroot?

I use Dreamweaver and I am also a little confused as to how I can upload the db using the ftp/site manager if it isn't in the wwwroot site folder from where dreamweaver manges the site. I have looked at a test db I have created in the data directory - Access creates just one file which is the whole database, however I can't seem to locate one particular file, there seems to be many. If this is the case, what do I need to upload to ensure all of the database is uploaded and where do I upload to on the remote site?

Mat

--------------------------

Matthew Stuart
11 Yew Tree Close
Middleton Cheney
Banbury
Oxon
OX17 2SU

01295 713813
07803 207734

--------------------------


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to