xxxxx-bin.001 files in \xampp\mysql\data

[ozental_uk]

Hello. I was wondering if you can help me. I've been running Xampp for a few months now and I've noticed that my \xampp\mysql\data directory has many files in it like : xxxx-bin.001, xxxx-bin.002, xxxx-bin.003, etc. where xxxx is the name of a user or a server (I'm not sure which). I also have files called xxxx.err and xxxx-bin.index.

At the moment, I have around 700 MB of these files in total.

Can you tell me what these files are and whether I can delete them?

[Ceelight]

Have you checked what is "in" the files? Open them and maybe post the content (special the err. files are interesting).

I think you also want to avoid that this problem occures again.

[ozental_uk]

The xxxx.err files appear to be 'OK'. They just show when I repaired tables and started/ended mySQL sessions.

The xxxx-bin.001, etc. files are non-text files but seem to contain some text of SQL statements that have been run on various databases and such and some 'words' from the phpBB2 board that I also run on the site.

[Hanspeter Thöni]

the *.bin files are probably Binary Log files

see http://dev.mysql.com/doc/mysql/en/binary-log.html

All Changes on the DB are logged in the Binary Log. The These Files can be used for Crash Recovery or Server Replication
Tools 'mysqlbinlog' can convert these Files in SQL Files.

the *.err files are probably 'The Error Log'

see http://dev.mysql.com/doc/mysql/en/error-log.html

The logging can be configured in the my.cfg File.

(sorry for my bad englisch)

[ozental_uk]

That seems to make good sense. So I guess I can delete these if I need too, or at least, archieve them away in a ZIP or RAR file if needed.

[Wiedmann]

Can you tell me what these files are and whether I can delete them?

edit your "my.cnf" ("\xampp\mysql\bin"):

Code: Select all

[mysqld]
# log-bin

stop MySQL:

Code: Select all

cd \xampp\mysql\data
del *bin.*

start MySQL