files under mysql's var directory

[ighal]

Hi everyone.


I have a lot of files named [hostname]-bin.00000x and they are making my filesystem to grow up very fast.

Does anyone know if those files are necessary to Plesk's functionallity or they are just backup files?

Please help me....

Regards!

 

[wagnerch]

It is binary logging, check your /etc/my.cnf for a line that says "log-bin". If you remove the line and restart mysql then binary logging should be turned off and then you can run "mysqladmin flush-logs" to get rid of them.

It is not necessary, but if it is enabled then you can do point in time recover with MySQL. You would have to write custom scripts to pull the binary logs and put them to tape or other backup medium.

See the following URL:

The Binary Log

 

[ighal]

Thanks!