Can i delete mysql bin

Viewed 35k times. Improve this question. If you do receive the Error You are not using binary logging message, what does that mean? Is it then safe to manually delete the files? Add a comment.

Active Oldest Votes. Those are mysql bin logs. The server can get seriously irritated if you delete them with rm. Improve this answer. Sanjay Bharwani Sanjay Bharwani 1 1 silver badge 3 3 bronze badges. This is the most durable solution. Also the easiest way to purge if you don't quite remember your MySQL passwords :- — kasimir.

Best solution ever! If you want to purge all files, just set to 0 days, and then back to a good value based on your application.

Thanks, pal! Warner Warner Do I need to comment the server-id to disable it? Comparisons Using Subqueries. Restrictions on Subqueries. Transactional and Locking Statements. Statements That Cause an Implicit Commit. Restrictions on XA Transactions. Replication Statements. Functions which Configure the Source List. Function which Configures Group Replication Primary. Functions which Configure the Group Replication Mode. Compound Statement Syntax. Variables in Stored Programs.

Local Variable Scope and Resolution. Flow Control Statements. Restrictions on Server-Side Cursors. Restrictions on Condition Handling. Database Administration Statements. Account Management Statements. Please do not just delete them in the OS. You need to let mysqld do that for you. Here is how mysqld manages it: The file mysql-bin. Improve this answer. Please note that my post is over 8 years old. I try not amend my very old answers which are 10 years old and address older versions of MySQL.

The majority of MySQL installation out there still use 5. So my older answers help such users. As answer's author does not wish to update the answer to mention the new MySQL features, I advise to read this answer too. See: dev. EduardoSantana Thank you.

My answer was posted 8 years ago when MySQL 8. If you wish to add a new answer for the sake of MySQL 8. Derek Downey Derek Downey Xiaofeng Xiaofeng 2 2 silver badges 5 5 bronze badges.

Yes, it is safe. For mysql 8, here's how you can do it. And then, restart the service: sudo service mysql restart It will erase the log for you and will keep deleting them. Eduardo Santana Eduardo Santana 2 2 bronze badges.

Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password.