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
