Martyn Wendon wrote:

> Hello,
>
> I'm having some trouble in re-locating my MySQL databases to a different
> directory.  My scenario is:
>
> Platform: Red Hat Linux 6.2
> MySQL: 3.23.43
>
> MySQL data currently stored in /var/lib/mysql
> The database name is "music" (so files are therefore in
> /var/lib/mysql/music)
>
> I wish to move the database "music" to /home/martyn/mysql.
>
> I create the above directory, then go into /var/lib/mysql and do "mv music
> /home/martyn/mysql" which moves the "music" database where I want it.  I
> then do "ln -s /home/martyn/mysql/music music" which creates a sym link to
> the new location.
>
> This all seems to work fine (i.e. as a sym link should) but when I run the
> mysql client and type "show databases;" the "music" database is no longer
> shown.  Is there anything additional to the above that I need to do to get
> this to work?
>
> Many thanks,
>
> Martyn

Hello,

No any problem with the installation ( rpm package ) of MySQL ?

Edward.




---------------------------------------------------------------------
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

Reply via email to