am3n portfolio

MySQL databases are located on /var/lib/mysql, if you create a partition for /var and and big enough to hold your databases MySQL will stop working because not enough space to put the data. Below is the easy way to fix it:

Assume you have /home partition which is far more bigger than /var, we’ll move to /home/mysql

service mysql stop
cd /var/lib
mv mysql /home
ln -s /home/mysql .
chown -R mysql.mysql mysql
service mysql start


The lesson in here is: please do research how much your data will grow, or it will be pain in the ass

Related posts:

1. Fantastico Problem First, Joomla is not listed on Fantastico, tried to update...

Related posts brought to you by Yet Another Related Posts Plugin.

This entry was posted on Saturday, September 5th, 2009 at 4:07 pm and is filed under Freelance, Web and System Administrator. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.