Although I wouldn't suggest doing this, it seems to work fine for me. I suggest in moving the directory, do not make ANY changes to the permissions - any. Just do this as root:
(Assuming you have redhat'ish directory structure) cd /var/lib/mysql mv dbname /home/user/database ln -s /home/user/database /var/lib/mysql/dbname This works fine in my environment. Just don't mess with the permissions or ownership, leave it as mysql/mysql. On Tuesday 27 November 2001 11:54 am, Mike(mickalo)Blezien wrote: > Hello All, > > Hoping someone can point where I may have gone wrong on setting our > client's databases within their own respective home directories. Here is > one of the setups dir tree and settings: > > The database 'tracers' is symbolically linked from the datadir to the > client's home directory. But for some reason, I keep getting the error > message that the tables are 'read only'...! > > what did I go wrong here?? How can I get MySQL to read/write to the > database in the client's home directory?? I thought I had all the owner/grp > settings correct. > > Thanks > > mysql sql database. > > # client home dir /home/tracerta/tracers > drwxrwxrwx 2 tracerta mysql 4096 Nov 25 22:57 ./ > drwx--x--x 13 tracerta tracerta 4096 Nov 27 12:45 ../ > -rw-rw-rw- 1 tracerta mysql 0 Nov 25 22:57 customers.MYD > -rw-rw-rw- 1 tracerta mysql 1024 Nov 25 22:57 customers.MYI > -rw-rw-rw- 1 tracerta mysql 9010 Nov 25 22:57 customers.frm > -rw-rw-rw- 1 tracerta mysql 0 Nov 25 22:57 log.MYD > -rw-rw-rw- 1 tracerta mysql 1024 Nov 25 22:57 log.MYI > -rw-rw-rw- 1 tracerta mysql 8610 Nov 25 22:57 log.frm > -rw-rw-rw- 1 tracerta mysql 0 Nov 25 22:57 membership.MYD > -rw-rw-rw- 1 tracerta mysql 1024 Nov 25 22:57 membership.MYI > -rw-rw-rw- 1 tracerta mysql 8644 Nov 25 22:57 membership.frm > -rw-rw-rw- 1 tracerta mysql 0 Nov 25 22:57 onlinetag.MYD > -rw-rw-rw- 1 tracerta mysql 1024 Nov 25 22:57 onlinetag.MYI > -rw-rw-rw- 1 tracerta mysql 8592 Nov 25 22:57 onlinetag.frm > -rw-rw-rw- 1 tracerta mysql 340 Nov 25 22:57 product_id.MYD > -rw-rw-rw- 1 tracerta mysql 3072 Nov 25 22:57 product_id.MYI > -rw-rw-rw- 1 tracerta mysql 8700 Nov 25 22:57 product_id.frm > -rw-rw-rw- 1 tracerta mysql 0 Nov 25 22:57 recovery.MYD > -rw-rw-rw- 1 tracerta mysql 1024 Nov 25 22:57 recovery.MYI > -rw-rw-rw- 1 tracerta mysql 8990 Nov 25 22:57 recovery.frm > -rw-rw-rw- 1 tracerta mysql 14904 Nov 25 22:57 retailtag.MYD > -rw-rw-rw- 1 tracerta mysql 19456 Nov 25 22:57 retailtag.MYI > -rw-rw-rw- 1 tracerta mysql 8616 Nov 25 22:57 retailtag.frm > -rw-rw-rw- 1 tracerta mysql 0 Nov 25 22:57 tags.MYD > -rw-rw-rw- 1 tracerta mysql 1024 Nov 25 22:57 tags.MYI > -rw-rw-rw- 1 tracerta mysql 8652 Nov 25 22:57 tags.frm > -rw-rw-rw- 1 tracerta mysql 0 Nov 25 22:57 temptag.MYD > -rw-rw-rw- 1 tracerta mysql 1024 Nov 25 22:57 temptag.MYI > -rw-rw-rw- 1 tracerta mysql 8602 Nov 25 22:57 temptag.frm > > # dir /var/lib/mysql/var > drwx------ 2 mysql mysql 1024 Jul 30 19:32 jytinter_db/ > -rw-r--r-- 1 mysql mysql 2276 Nov 14 09:56 my.cnf > drwx------ 2 mysql mysql 1024 Jul 31 08:09 mysql/ > -rw-rw-r-- 1 mysql mysql 65962 Nov 27 13:51 mysql.log > -rw-rw---- 1 mysql mysql 4 Nov 26 22:51 mysql.pid > -rw-rw-r-- 1 mysql root 6450 Nov 26 22:51 mysql_log.err > -rw-rw---- 1 mysql mysql 54739 Nov 26 22:51 mysql_update.log > drwx------ 2 mysql mysql 1024 Jul 30 19:31 referra1/ > lrwxrwxrwx 1 mysql mysql 22 Nov 25 23:00 tracers -> > /home/tracerta/tracers/ > Mike(mickalo)Blezien > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > Thunder Rain Internet Publishing > Providing Internet Solutions that work! > http://www.thunder-rain.com > Tel: 1(225)686-2002 > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > > > --------------------------------------------------------------------- > 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
