What is the procedure for adding hard drives and moving things around?
I have a server in my office running Suse 10.0 and we currently have 3 hard drives installed in the box.
We are only using 1 hard drive and it contains everything for the server including the /home directory.
What I would like to do is to be able to move the current /home directory to a hard drive of it's own and still have the server work correctly to put out the hosted accounts websites.
I would also like to have the MySQL databases stored on the 3rd hard drive instead of the primary hard drive that contains everything.
Is it possible to move these things around even though we now have websites on the server? If so, what would be the procedure to do so. I've been trying to find this information in all the Linux books that I have and can't seem to find a procedure for moving a home directory and or all the mysql databases to their own hard drives. I do know that when I initially setup this server, I did have the option to put /home on it's own hard drive but at the time chose not to.
The second part of this would be:
Can I leave the /home drive on the primary hard drive and have the server use one of the other hard drives that is installed on the server as a sort of overflow, so that when the first home directory fills up then it starts to write the data to the next hard drive? If so, how would I go about doing this.
Thanks if you can help me out. Keep in mind that I am a Newbie, so I pretty much need specific instructions to accomplish things that I've never done on the server before.