View Single Post
  #1 (permalink)  
Old February 26th, 2005, 02:13 PM
miguelm miguelm is offline
Registered User
 
Join Date: Feb 2005
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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

C:\MyWebSite

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!



Reply With Quote