Re: replication binary log files location

2004-08-24 Thread Crouch, Luke H.
I found the solution to my own problem... the log-bin option is a specific filename. so when you set: log-bin=/logging mysql must have ownership of the / folder, as it is trying to create /logging.001 and /logging.index easily fixed by adding the file-name to the path... log-bin=/logging/h

Re: replication/binary log

2003-12-09 Thread Tobias Asplund
On Tue, 9 Dec 2003, Mayuran Yogarajah wrote: > Diana Soares wrote: > > >Use "PURGE {MASTER|BINARY} LOGS TO 'log_name'" instead of "RESET > >MASTER". > >>From the manual: > > > >" > >Deletes all the binary logs listed in the log index that are strictly > >prior to the specified log or date. The log

Re: replication/binary log

2003-12-09 Thread Mayuran Yogarajah
Diana Soares wrote: Use "PURGE {MASTER|BINARY} LOGS TO 'log_name'" instead of "RESET MASTER". From the manual: " Deletes all the binary logs listed in the log index that are strictly prior to the specified log or date. The logs also are removed from this list recorded in the log index file, so tha

Re: replication/binary log

2003-12-09 Thread Diana Soares
Use "PURGE {MASTER|BINARY} LOGS TO 'log_name'" instead of "RESET MASTER". >From the manual: " Deletes all the binary logs listed in the log index that are strictly prior to the specified log or date. The logs also are removed from this list recorded in the log index file, so that the given log now