Moving the MySQL Database Root Directory
I was able to install MySQL 4, Apache 2 and PHP 5 (in that order), with little difficulty, and everything seems to be working.
The MySQL databases are located at the default folder at
C:\Program Files\MySQL\MySQL Server 4.1\data
However, the local files of my website (to be uploaded using Dreamweaver) are located at
Shouldn't the database I create be located in the MyWebSite folder, along with the site's other pages, so that the inevitable uploading is quick and easy?
Could I use MySQL Administrator to edit the root data path of MySQL databases? If I do, should I manually move the databases from the old location to the new? Should I exit MySQL first? I'm worried about the MySQL database in particular, which holds user information.
Or should I just continue working with what I have? When ready to upload the database, I would then copy it first to the appropriate directory in my local site.
Thanks in advance!