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

Problems with the Windows version of XAMPP, questions, comments, and anything related.

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

Postby ozental_uk » 22. March 2005 13:36

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?
ozental_uk
 
Posts: 21
Joined: 30. July 2004 22:17

Postby Ceelight » 22. March 2005 13:44

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.
There's no place like 127.0.0.1
User avatar
Ceelight
 
Posts: 295
Joined: 31. January 2004 19:57
Location: Pfälzer im niedersächsischen Exil ;-)

Postby ozental_uk » 22. March 2005 13:52

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.
ozental_uk
 
Posts: 21
Joined: 30. July 2004 22:17

Postby Hanspeter Thöni » 22. March 2005 14:53

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)
Gruss Hanspeter
User avatar
Hanspeter Thöni
 
Posts: 233
Joined: 17. August 2004 10:29
Location: Schweiz

Postby ozental_uk » 22. March 2005 15:29

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.
ozental_uk
 
Posts: 21
Joined: 30. July 2004 22:17

Postby Wiedmann » 22. March 2005 16:15

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
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany


Return to XAMPP for Windows

Who is online

Users browsing this forum: kdalgorenk and 58 guests