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