Mysql binary logs

2002-03-29 Thread Konstantin Yotov
Hello! :) I want to ask about binary log - what kind of info it writes and how I can use it. Is this info is connected with optimizing mysql work. Thanks. Kosyo __ Do You Yahoo!? Yahoo! Greetings - send holiday greetings for Easter, Passover

Mysql binary logs

2002-03-29 Thread Egor Egorov
Konstantin, Friday, March 29, 2002, 11:31:23 AM, you wrote: KY I want to ask about binary log - what kind of info it KY writes and how I can use it. Is this info is connected KY with optimizing mysql work. mysqld writes in a log file all SQL commands that update data and info about how long

Re: Mysql binary logs

2002-03-29 Thread Marc Prewitt
You might want to use the mysqlbinlog utility to look at the binlog. The binlog format has changed at least once in past versions and could change again. However, the output from mysqlbinlog just a straight text format of updates/inserts/deletes which happen to a database. -Marc Konstantin