Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6
This is the forum to discuss the Wrox book Beginning PHP, Apache, MySQLWeb Development by Michael K. Glass, Yann Le Scouarnec, Elizabeth Naramore, Gary Mailer, Jeremy Stolz, Jason Gerner; ISBN: 9780764557446
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old February 26th, 2005, 02:13 PM
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!





Similar Threads
Thread Thread Starter Forum Replies Last Post
Moving server root outside virtual machine centaury Internet Information Services 3 October 7th, 2008 12:10 AM
Can you change root directory of sqlServer 2005 hamilton SQL Server 2005 5 April 4th, 2007 05:46 AM
Root Directory Chudz BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 1 July 11th, 2004 03:13 PM
Get IIS root directory from VB.NET weichunglow Pro VB.NET 2002/2003 0 June 16th, 2004 09:39 AM
PHP uploaded to root directory arnec BOOK: Beginning PHP4/PHP 5 ISBN: 978-0-7645-4364-7; v5 ISBN: 978-0-7645-5783-5 1 August 15th, 2003 03:24 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.