Re: CHANGE MYSQL DATADIR TO ANOTHER HARDISK

2008-08-18 Thread Ananda Kumar 
Shut down mysql, move all the datafiles to /data and create a symbolic link
from the current directory to /data. This should work.

regards
anandkl


On 8/18/08, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote:

 Hi all,

 On my debian system, i have two hardisk. I want to change the mysql datadir
 to another hardisk (/dev/cciss/c0d1p1 /data ). Please tell me how to do
 this.

 /dev/cciss/c0d0p1  34G  /
 /dev/cciss/c0d1p1  68G  /data

 --
 Krishna Chandra Prajapati

Re: CHANGE MYSQL DATADIR TO ANOTHER HARDISK

2008-08-18 Thread Paul Choi 
Better yet, either do a cp -a (if GNU cp) or mv, then modify your
my.cnf to reflect the new location. Your file permissions and ownership
will have been preserved if you used either of these commands, and it's
good to go.

On Mon, 2008-08-18 at 11:59 +0530, Ananda Kumar wrote:

 Shut down mysql, move all the datafiles to /data and create a symbolic link
 from the current directory to /data. This should work.
 
 regards
 anandkl
 
 
 On 8/18/08, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote:
 
  Hi all,
 
  On my debian system, i have two hardisk. I want to change the mysql datadir
  to another hardisk (/dev/cciss/c0d1p1 /data ). Please tell me how to do
  this.
 
  /dev/cciss/c0d0p1  34G  /
  /dev/cciss/c0d1p1  68G  /data
 
  --
  Krishna Chandra Prajapati
 

-- 
Paul Choi [EMAIL PROTECTED]

CHANGE MYSQL DATADIR TO ANOTHER HARDISK

2008-08-17 Thread Krishna Chandra Prajapati 
Hi all,

On my debian system, i have two hardisk. I want to change the mysql datadir
to another hardisk (/dev/cciss/c0d1p1 /data ). Please tell me how to do
this.

/dev/cciss/c0d0p1  34G  /
/dev/cciss/c0d1p1  68G  /data

-- 
Krishna Chandra Prajapati