Re: Problem moving database datadir

[Ken Kinder <ken@xxxxxxxxxxxxxxx>]

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