Hi, There is an faq on using symbolic links to move databases at http://www.mysql.com/doc/S/y/Symbolic_links.html which covers the details. The gotcha that I fell into was that the mysql user (usually "mysql") needs to have rights to the directories that you move the data to. So if you put a database called "mydata" in a user directory "/home/user1" the mysql user needs to have rights to the "user1" directory as well as the "mydata" directory. Hope that makes sense.
Kind Regards, Martyn ----- Original Message ----- From: "Mike(mickalo)Blezien" <[EMAIL PROTECTED]> To: "Martyn Wendon" <[EMAIL PROTECTED]> Sent: Sunday, November 25, 2001 10:16 PM Subject: Re: Symbolic Links to Data > Hello Martyn, > > I was follow your thread on this issue of symbolic linking to the clients home > directory. I'm in the process of setting up the same type of system, so each > client's account database is within their /home/acct_name/ folder, so the disk > space used by their database is tacked onto their total allotted disc space > instead of in the /var or /usr filesystem. We're on a RH/Linux 6.2 O/S also. > > Could you be so kind and outline how you set yours up, this would help alot. > > I have 2 mysql server running. One for development work, and one for our > clients. the mysql for the clients is located in the /var/lib/mysql folder, > datadir /var/lib/mysql/var/ => database folders > > I believe your pretty much doing the same thing :) > > appreciate you time, > --------------------------------------------------------------------- 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
