Soheil Shaghaghi wrote: > Hello everyone, > I have my MySQL database n the var partition of a FreeBSD server. > The problem is that the partition is almost full, and now I can't start the > SQL server! > > I am thinking of moving the MySQL data directory to another partition, but I > don't know how I should do this. > Can anyone please tell me how, and also do I have to change any settings > after moving the data directory? > > Thanks so much. > > --------------------------------------------------------------------- > 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
Soheil, If you have a partition that you can dedicate to mysql, just rename the current mysql directory, mount the dedicated partion as /var/lib/mysql/ and copy the files from the mysql directory you renamed . Of course, be sure to stop mysql and check permissions of the new location. walt --------------------------------------------------------------------- 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
