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]>
