Hello,
I'm successfully running MySql under Debian with the data files
in /var/lib/mysql. I would like to move the data base files to my home
directory and have mysql use them from there. How do I do it? Can I just
copy them to my home directory and start mysql with a parameter which point
to the new locaion? Can I do that with mysql starting at boot time?
I just looked at /etc/init.d/mysql and see that it appears to starts mysql
by calling /usr/bin/mysql_safe but there is no such file.
As an alternative to putting it in my home directory, I would be happy
putting the files in /usr/local. Can I do that without rebuilding mysql?
The reason I want to do this is that I want to install a new version of
Knoppix and that will format and clean out the / partition and I don't want
to loose the data I have in /var/lib/mysql. Could I just
save /var/lib/mysql and restore it after installing the new version of the
system?
Thanks in Advance,
--
Don Rozenberg
707-882-3601
ro***@mcn.org