I've been using mysql for development. I don't use replication but I guess I had binary-logging enabled for some time on one of my previous computers and I have unknowingly accumulated hundreds of binary log files.
I'm using Linux now and I actually need to start using binary logging. When I try to enable binary log in my.cnf - mysql server doesn't start and this is what I find in error log:
1 110314 14:39:40 [Note] Plugin 'FEDERATED' is disabled.
2 110314 14:39:40 InnoDB: Started; log sequence number 0 36669358
3 ^G/usr/sbin/mysqld: File '.\mysql-bin.000179' not found (Errcode: 2)
4 110314 14:39:40 [ERROR] Failed to open log (file '.\mysql-bin.000179', errno 2)
5 110314 14:39:40 [ERROR] Could not open log file
6 110314 14:39:40 [ERROR] Can't init tc log
7 110314 14:39:40 [ERROR] Aborting
8
9 110314 14:39:40 InnoDB: Starting shutdown.
so - I assume - I just have to delete old binary logs - right? Can I just delete all mysql-bin. files? Would I have to clear mysql-bin.index file as well?
Thanks!