On Fri, Jan 25, 2002 at 03:30:11AM -0500, Ken wrote: > I'm trying to enable binary logging on my MySQL server (3.23.28-gamma-log), per the >recommendations in the manual about properly backing up the database. > > In my /etc/my.cnf I have: > [mysqld] > log-bin=updates > > I had also tried just: > [mysqld] > log-bin > > But no update log file is being created in my data dir. Looking at the .err log >reveals: > 020125 03:16:38 mysqld started > 020125 3:16:38 Server id is not set - binary logging disabled > > What does this refer to, and how can I fix it?
Drop this into your my.cnf file: server-id = 1 And consider upgrading. 3.23.28 has some bugs that are fixed in the stable releases. It will be painless upgrade. :-) Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 22 days, processed 515,230,929 queries (266/sec. avg) --------------------------------------------------------------------- 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
