MySQL partition is full
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:
- Running MySQL 4 and MySQL 5 Concurrently From Howtoforge.com’s article: Running MySQL 4 And MySQL 5 Concurrently...
- hdd partition for cpanel server Simple Harddisk partition, assume only for vps and have or...
- MySQL 5 access via old MySQL-Front 2.5 Kusma!!!, Now I know how to make old mysql front...
- SQL Error: Table ‘mysql.proc’ doesn’t exist Today I upgraded my HeidiSQL into version 4, but when...
- Running MySQLd as standalone application on Windows My friend asked me how to get MySQL running as...