How to delete mariadb-bin log


#1

hello mariadb-bin log use almost all my disk space, already disable the logging by commenting out log_bin in /var/lib/docker/volumes/global-db_db_conf/_data/conf.d/ee.cnf and set expired_logs_days to 1, but reamaining mariadb-bin.000XXX still there. Please help me to delete the remaining log.


#2

anyone? pls help


#3

Same issue here. Take down my website and my server!
I not discovery anything yet.

v4 documentation is terrible.

i’m glad to pay for a monthly subscription for a good support for Easy Engine!


#4

These are used as transaction and replication logs

PURGE BINARY LOGS TO 'mysql-bin.010

you can comment the log-bin* lines in the cnf. log-slave-updates should be commented too if enabled ti disable them both. But with a crash it can not repair the tables.


#5

i try purge command but it say PURGE: command not found , iam using easyengine v4. iam beginner so can you explain how to do from beginning, thanks


#6

you have to do to it from within Mysql

login from terminal mysql -uroot -p and there you do: PURGE BINARY LOGS TO 'mysql-bin.010

as a reference: https://dev.mysql.com/doc/refman/5.6/en/purge-binary-logs.html

Good Luck :wink:


#7

i try mysql -uroot -p it say mysql not installed, i think it’s because docker ting on easyengine v4


#8

Correct, you have to chroot into the container then execute the mysql commands.


#9

I don’t use EE v4 any longer so limited experience but if you did not manage what you wanted to do.
It might be an idea to use the admin tools and especially phpmyadmin to connect to mysql: