From owner-freebsd-questions@FreeBSD.ORG Thu May 1 17:55:50 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 7E50C106566B for ; Thu, 1 May 2008 17:55:50 +0000 (UTC) (envelope-from vaughajj@jmu.edu) Received: from mpdir5.jmu.edu (mpdir5.jmu.edu [134.126.12.44]) by mx1.freebsd.org (Postfix) with ESMTP id 3AA728FC0C for ; Thu, 1 May 2008 17:55:50 +0000 (UTC) (envelope-from vaughajj@jmu.edu) Received: from jmu74b3530692a (ip18-89.pc.jmu.edu [134.126.18.89]) by mpdir5.jmu.edu (MOS 3.8.4-GA) with ESMTP id GER48602 (AUTH vaughajj); Thu, 1 May 2008 13:45:38 -0400 (EDT) Message-Id: <200805011745.GER48602@jmu.edu> From: "John" To: Date: Thu, 1 May 2008 13:45:32 -0400 MIME-Version: 1.0 X-Mailer: Microsoft Office Outlook, Build 11.0.5510 Thread-Index: AcirsybqKqfANwaRSveHjl1M++83iA== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198 X-Junkmail-Whitelist: YES (by domain whitelist at mpdir5.jmu.edu) Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: jjvaughan@gmail.com Subject: 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 17:55:50 -0000 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. 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. Thanks for the help! -John