Problem moving database datadir

["Mike(mickalo)Blezien" <mickalo@xxxxxxxxxxxxx>]

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 <mysql-thread92382@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php