We've lately used a Drupal 6 install and also the directory storing the mysqld-bin.XXX files /var/run/mysqld has triggered the mysql server to crash. How big these files (log) are gone 1g in dimensions each and you will find a lot of them. I must know a means we are able to either enable log rotation or something like that much like insure this doesn't happen again.

Any insight is greatly appreciated.

Thanks ahead of time,

JN

Short answer, you actually can: http://dev.mysql.com/doc/refman/5.0/en/binary-log.html

http://dev.mysql.com/doc/refman/5.0/en/replication-options-binary-log.html

But you have to make certain you've got a good backup system in position so that you can take pictures of the DB, then recover together with your binlog.

Particularly, look into the max_binlog_size option

Set this to something similar to 128 or 256Mb you'll be able to then just add-on a cron job copying old binlogs served by each database dump, then remove old binlogs.