When I do a FLUSH LOGS my bin log does increment and a new one is created. My query log does not behave this way, however. Just the bin log. It creates files with the .00x extension where "x" is an incremental number.
Lou ----- Original Message ----- From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 14, 2004 8:09 AM Subject: Re: about flush logs > "Tang, Grace H" <[EMAIL PROTECTED]> wrote: > > In my box, mysql server version is 4.0.18. > > > > I tried "> flush logs". Nothing happened in the mysql data directory. All the log files > > were not replaced. > > > > Does "flush logs" rename the old log files and create new log files? > > FLUSH LOGS closes and reopens all logs. In doesn't rename anything. For update log if you didn't specify extention, FLUSH LOGS creates new log file. > > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Egor Egorov > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]