From owner-freebsd-questions@FreeBSD.ORG Thu May 1 18:23:58 2008 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 3F1631065672 for ; Thu, 1 May 2008 18:23:58 +0000 (UTC) (envelope-from fbsd.questions@rachie.is-a-geek.net) Received: from snoogles.rachie.is-a-geek.net (rachie.is-a-geek.net [66.230.99.27]) by mx1.freebsd.org (Postfix) with ESMTP id 0D57D8FC0C for ; Thu, 1 May 2008 18:23:57 +0000 (UTC) (envelope-from fbsd.questions@rachie.is-a-geek.net) Received: from localhost (localhost [127.0.0.1]) by snoogles.rachie.is-a-geek.net (Postfix) with ESMTP id E19F51CC91; Thu, 1 May 2008 10:23:56 -0800 (AKDT) From: Mel To: freebsd-questions@freebsd.org Date: Thu, 1 May 2008 20:23:21 +0200 User-Agent: KMail/1.9.7 References: <200805011745.GER48602@jmu.edu> In-Reply-To: <200805011745.GER48602@jmu.edu> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200805012023.22509.fbsd.questions@rachie.is-a-geek.net> Cc: John , jjvaughan@gmail.com Subject: Re: Recovering mysql data - mysqlbinlog X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 01 May 2008 18:23:58 -0000 On Thursday 01 May 2008 19:45:32 John wrote: > Can someone direct me to where the MySQL transaction logs are stored? I am > running FreeBSD 6.1 with MySql 5.0.41 which I installed from ports, no > extra config. From what I've read online, unless you disable them (which I > couldn't find in the makefile) the logs should be being created. Doing a > find / --name "bin." Didn't turn up anything. By default they end up in /var/db/mysql and are named $hostname-bin.### Also, the information you read online is incorrect. By default, binary logging (which are the transaction logs) is disabled. I don't recall whether this is a FreeBSD port specific modification. You can turn it on by putting a my.cnf in /var/db/mysql. Templates named my-$size.cnf are in /usr/local/share/mysql and are well-commented. > I'll also note that it is not in var/db/mysql with the rest of the mysql > data files and the ib_logfiles which would have been useful, but the data I > am trying to recover is from a MyISAM. I take it you tried myisamchk? -- Mel Problem with today's modular software: they start with the modules and never get to the software part.