Bin files mysql

[snaaps]

Can anyone tell me what ere the files in the /var/lib/mysql/hostname-bin.000xx means?

It used a lot off diskspace (total 73GB)
How do the get there, and how disabled it.

 

[Marshall]

Take a look at: http://dev.mysql.com/doc/refman/5.0/en/binary-log.html

Specifically near the middle

A client that has the SUPER privilege can disable binary logging of its own statements by using a SET SQL_LOG_BIN=0 statement. See Section 13.5.3, “SET Syntax”.

which I assume will disable it?

 

[nobaloney]

.bin files give you a way to recreate databases. Unless you learn how to use them and offer (hopefully as a paid service) the ability to restore MySQL databases up to the last entry, you probably don't need them, and even if you do, you only need to keep them since your last restart of MySQL.

Jeff

 

[alipour66m]

I have remobed rm -rf binlog.000* and now can not connect to database?
is there any solution?

 

[Zhenyapan]

I have remobed rm -rf binlog.000* and now can not connect to database?
is there any solution?

you need to restore all databases from backups