You should be able to:
1. Shut down the server.
2. Copy all the files from your data directory (including the grant tables,
etc.) to where you would like them.
3. Change the location in your /etc/my.cnf file (Assuming a linux server.
It should be similar for other architectures.)
4. Make sure a
Willie Northway wrote:
>Can anyone fill me in on how to manage this *without* using a huge pile
>of symlinks:
>
>
May I highly recommend the symlink method? Its actually very
informative to do:
$ ls -l /var/mysql
and see:
---x---
mbabcock -> /home/mbabcock/mysql
gcurtis -> /home/gcurtis/mysql
