From owner-freebsd-questions Sun Jul 21 15: 7:11 2002 Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.FreeBSD.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id ADFB837B400 for ; Sun, 21 Jul 2002 15:07:08 -0700 (PDT) Received: from blueyonder.co.uk (pcow057o.blueyonder.co.uk [195.188.53.94]) by mx1.FreeBSD.org (Postfix) with ESMTP id A702443E65 for ; Sun, 21 Jul 2002 15:07:07 -0700 (PDT) (envelope-from andrew@cream.org) Received: from pcow057o.blueyonder.co.uk ([127.0.0.1]) by blueyonder.co.uk with Microsoft SMTPSVC(5.5.1877.757.75); Sun, 21 Jul 2002 23:06:42 +0100 Received: from cream.org (unverified [62.31.80.97]) by pcow057o.blueyonder.co.uk (Content Technologies SMTPRS 4.2.9) with ESMTP id ; Sun, 21 Jul 2002 23:06:42 +0100 Message-ID: <3D3B3119.4070204@cream.org> Date: Sun, 21 Jul 2002 23:09:29 +0100 From: Andrew Boothman User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.1a) Gecko/20020611 X-Accept-Language: en-us, en MIME-Version: 1.0 To: kmidtset@c2i.net Cc: freebsd-questions@FreeBSD.org Subject: Re: Transaction logs and MySQL References: <3D3AC2CF.12547.1CFEC2@localhost> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG Kjell - LA3SG wrote: >I have added --log-update=my-sql.log to the mysql startup script. >But I have not found any resulting logs. Where should they live? >Is it possible to set up logging to give separate logs for each DB? >Any help or doc pointers appreciated! > > Try reading MySQL's documentation on http://www.mysql.com Perhaps you can give mysql a path as well as a filename, ie --log-update=/var/log/my-sql.log ? To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message