By default MySQL keeps a log of all transactions, if you don’t limit this in “my.cnf” it will keep growing and keep creating “mysql-bin.XXXXX” files. To delete these files and potentially free up lots of disk space do the following:
If you are using DirectAdmin first find out the admin user account for MySQL:
cat /usr/local/directadmin/conf/mysql.conf
Then connect to MySQL:
mysql -u ADMINACCOUNT -p
Input the password and when you are connected purge the files by issueing the following command:
PURGE BINARY LOGS BEFORE '2016-03-31 23:59:59';
Disconnect from MySQL and check how many space is won by typing:
df -h
Nog geen commentaren