p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 (http://p2p.wrox.com/forumdisplay.php?f=123)
-   -   Moving the MySQL Database Root Directory (http://p2p.wrox.com/showthread.php?t=26137)

miguelm February 26th, 2005 02:13 PM

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!





All times are GMT -4. The time now is 06:01 AM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.