This isn't awfully useful to you, but it's dead easy to do this on a Unix
system. All you do is copy the data over wherever you like (to a big, fat,
drive), and then link the new directory from the /usr/local/mysql/data/
directory ("ln -s").
OTOH, I guess you can't link a file/directory in Windows/DOS.
"David Brieck" <[EMAIL PROTECTED]> on 05/29/2001 09:13:17 AM
To: "Chris Mallett" <[EMAIL PROTECTED]>, "myODBC List \(E-mail\)"
<[EMAIL PROTECTED]>
cc: (bcc: Charles Kirby/Usdcsdny)
Subject: Re: mySQL databases over two drives
I'm not sure where you heard that MySQL only like to run on the C drive. I've
got my test bed at home running on my E drive and the production server where I
work runs on the D drive. Works great here!
----- Original Message -----
From: Chris Mallett
To: myODBC List (E-mail)
Sent: Tuesday, May 29, 2001 5:51 AM
Subject: mySQL databases over two drives
hi everyone
We have mySQL installed on the c drive of our server. However, we need to
move a mySQL database to another drive for more space. Will we need to also
re-install mySQL on the new drive? I have heard that mySQL is only truly
happy running on the C drive - is this true?
Is it possible to keep mySQL on the c drive but move the database files to
another drive? This way mySQL would still run on the c drive but retrieve
the database info from another drive.
Any help would be greatly appreciated.
cheers
chris
---------------------------------------------------------------------
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
