PDA

View Full Version : /var/ is 100% filled-- options?


AlexMack
Tue 19th Dec '06, 8:19pm
our /var/ partition is filled to capacity. there are some things we could clear out but that'd only be a temporary solution, as mysql is taking up the far majority of it. for whatever reason, /var/ was only allocated 1.7GB even though the hard drive is rather large [300GB]

how can we change where mysql stores data? is it advisable? or should we somehow change the partition size of /var/?

Zachery
Tue 19th Dec '06, 8:21pm
You can make a new folder and move the mysql folders and data files.

Stop mysql, copy the files over to your new directory. Add
datadir=/path/to/new/basedir

Under the [mysqld] portion of your my.cnf

Restart mysql.