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 mysq

Re: CHANGE MYSQL DATADIR TO ANOTHER HARDISK

2008-08-17 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 mysq

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