You should be able to: 1. Shut down the server. 2. Copy all the files from your data directory (including the grant tables, etc.) to where you would like them. 3. Change the location in your /etc/my.cnf file (Assuming a linux server. It should be similar for other architectures.) 4. Make sure all your file permissions are ok -- that your mysql user can see them. 5. Restart the server.
It worked for me. You can see other options for your my.cnf file by looking at the instructions for installing MySql. I hope this helps... In Christ, Peter, hierodeacon ---- Dormition Skete A Monastery of the Russian Orthodox Autonomous Church http://www.BuenaVistaCO.com/GOC http://www.ROACAmerica.org ---- ----- Original Message ----- From: "Willie Northway" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 05, 2002 11:24 AM Subject: relocating databases > > > I'm thinking of moving databases from their standard location to > another disk. I'd like to set up a separate database for each user, so > that their storage space is reflected in their home directory quota. > > Can anyone fill me in on how to manage this *without* using a huge pile > of symlinks: > > http://www.mysql.com/doc/en/Symbolic_links.html > > thanks - Willie > > -- > Willie Northway > University of Michigan Webmaster Team > http://willienorthway.com/ > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
