i tried this one
PURGE { BINARY | MASTER } LOGS
{ TO '*log_name*' | BEFORE *datetime_expr* }
but for some reason it didn't purge any bin file.. so i tried our expired...
on the my.cnf waited for a while and it was deleted...
is there a requirement to use "purge" i have "5.0.51a-0.rhel4" running on my
test box.
On Mon, May 11, 2009 at 10:15 PM, <edb...@edberg-online.com> wrote:
> On Mon, May 11, 2009 6:41 pm, Rilawich Ango wrote:
> > Hi,
> > In the master database, there are plenty of mysql-bin.X. It
> > occupied almost all the disk space. As I know, the files should be
> removed
> > by issuing reset master. Below are my questions. -Do I need to stop
> > replication before issuing reset master? If yes, do I need to rebuild
> the
> > replication after reset master? If no, does the existing replication
> > broken after reset master? ango
> >
>
> See
>
> http://dev.mysql.com/doc/refman/5.0/en/purge-binary-logs.html
>
> (or the relevant URL for your language/version). And you can use the
> expire_logs_days system variable to have MySQL automatically purge old
> logs.
>
> - steve
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=jerom...@gmail.com
>
>
