Salut,
j’aimerais effacer proprement les bin logs de mysql mais je suis face un petit probléme que je ne comprends pas.
/var/log/mysql# du -sh *
101M mysql-bin.000001
33M mysql-bin.000002
101M mysql-bin.000003
53M mysql-bin.000004
101M mysql-bin.000005
53M mysql-bin.000006
101M mysql-bin.000007
55M mysql-bin.000008
101M mysql-bin.000009
52M mysql-bin.000010
101M mysql-bin.000011
53M mysql-bin.000012
101M mysql-bin.000013
53M mysql-bin.000014
13M mysql-bin.000015
bon ils sont la
[code]mysql -uroot -pXXXXXXXXX
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1435030
Server version: 5.0.51a-3ubuntu5.8-log (Ubuntu)
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.
mysql> SHOW BINARY LOGS;
Empty set (0.00 sec)
mysql>
[/code]
ils sont plus la
alors du coup toute commande PURGE BINARY LOGS TO ‘mysql-bin.2’;
est forcément infructueuse…
Vous sauriez pourquoi ils se génèrent sur le disque dur mais que mysql ne les voit pas ?
Merci
