shutdown the mysqld, move the data direectory, and set up a symbolic link.
Rahadul Kabir wrote: >Hi, >I have MySQL3.23.47 running on a Cobalt RaQ4 System. The mysql >installed datadir turned out to be /var/lib/mysql. /var directory has >it's own partition (/dev/hda3) and total space available is 194MB. As My > >databases are growing and I'm out of space now on the /var directory. > >I am thinking I need to change the datadir variable to somewhere on the >/home directory, where I have > 25GB free. How can I achieve this? Or >is this the right approach? Please provide some solution as details as >possible, as I'm new into this stuff. >Thanks so much. > >Rahad > > >--------------------------------------------------------------------- >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 > > --------------------------------------------------------------------- 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