471,075 Members | 1,273 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,075 software developers and data experts.

Help moving data base from /var to home directory.

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
Jul 20 '05 #1
0 1342

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by matt | last post: by
reply views Thread by abcd | last post: by
8 posts views Thread by Johan Svedberg | last post: by
22 posts views Thread by Tony Houghton | last post: by
6 posts views Thread by Hemant Shah | last post: by
2 posts views Thread by BlackKite | last post: by
3 posts views Thread by Simon Brooke | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.