Amittai, ----- Original Message ----- From: ""Amittai Aviram"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Sunday, December 08, 2002 9:46 PM Subject: Reading logs
> In both the MySQL manual and Paul DuBois superb _MySQL_, I find information > about turning logging on, rotating log files, and maintaining log files -- > but I still do not understand how I am supposed to _read_ a log file. I am > running MySQL 4.0.5-max-debug under Windows XP. If I issue the bare command > mysqlbinlog, I get a torrent of help info telling me what commands I'm > allows to issue, including the formula mysqlbinlog [options] log-files. OK, > I guess that means that I'm supposed to specify the log file or log files. > So I look in the data directory and find, not one, but four different files > that seem appropriately named: > > ib_arch_log_000000000 > ib_logfile0 > ib_logfile1 > ibdata1 > > If I try any of these without a path, I get "file not found." If I specify > the full path, I get, in every case, "ERROR: File is not a binary log file." > <sigh /> What am I supposed to do? you should use mysqlbinlog to one of the files whose name is something like yourhostname-bin.005 in the datadir of MySQL. I assume you have added the line log-bin to the [mysqld] section of your my.cnf or my.ini, so that mysqld knows to produce these binlog files. The files you listed above are InnoDB files, not binlog files. > Thanks. > > Amittai Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com sql query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php