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 >