A quick rescue to free space when mysql run out of space

This command can be used to start mysql service when it is stopped due to drive full

From command line issue the below command

tune2fs -m 0 /dev/sda5

This can save a little space enough to start mysql.

Now find out the reason to become the drive full. The below command can be used to list biggest 10 files:

du -a / | sort -n -r | head -n 10

If it is because any log file, delete it. If it is because of ibdata, the mysql file, follow the below steps to shrink it.
Also, check the possibility of reducing size by deleting old data from tables like STOCKDIARY, TAXLINES, etc.,

To shrink ibdata file, follow the below steps:
1. Connect a usb drive and mount it.
2. From command line issue below commands

mysqldump -u root -p SALECULATOR > /flash/fullbak.sql  (enter password)
mysql -u root -p (enter password)
DROP DATABASE SALECULATOR;
exit;
service mysql stop
rm /data/db/ibdata1
rm /data/db/ib_log*
service mysql start
mysql -u root -p (enter password)
CREATE DATABASE SALECULATOR;
USE SALECULATOR;
source /flash/fullbak.sql;
exit;
exit

0 Comments

Leave a Reply

Arrow-up