From owner-freebsd-questions@FreeBSD.ORG Thu May 1 18:32: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 507D5106566B for ; Thu, 1 May 2008 18:32:50 +0000 (UTC) (envelope-from jjvaughan@gmail.com) Received: from fk-out-0910.google.com (fk-out-0910.google.com [209.85.128.191]) by mx1.freebsd.org (Postfix) with ESMTP id D10018FC1E for ; Thu, 1 May 2008 18:32:49 +0000 (UTC) (envelope-from jjvaughan@gmail.com) Received: by fk-out-0910.google.com with SMTP id k31so921347fkk.11 for ; Thu, 01 May 2008 11:32:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; bh=bceMo+9cdTaUjIsM7VcqHjIHLUOz4blmca5Sh+P1Zmk=; b=OH0xBjURFvJp4T20xB5eeTlvxB3HfjYTlo7RuK9i3PDm4MFYOkvTQSUVSd7i26VuvjkkvTMDDaxbhI5nyczjpnT+Km23cvaqn2H7xPCnBimDjVCxVPp1ij6vhuv9eWif4b8CAAw5mefdPaRgQsbYKFxhkmxIAZzZ2eA3oHbFLpI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=qrKP1roojHAHm5sGzQ5OnbksiLd8pKP1LDkXlntAyQeJag6caPIzsKxMTwx84cRxGmdYzd3tMmMx4QpeOug6p3UrrqZppQD1l3KxuTNButC2PKMaJNekPgVnnHV5NYunxxxWFy6OPk0OpeSiG+pX+9tebNz9epT88iBXuBd2R6Y= Received: by 10.82.145.7 with SMTP id s7mr258379bud.81.1209665042092; Thu, 01 May 2008 11:04:02 -0700 (PDT) Received: by 10.82.173.15 with HTTP; Thu, 1 May 2008 11:04:02 -0700 (PDT) Message-ID: Date: Thu, 1 May 2008 14:04:02 -0400 From: "John Vaughan" To: freebsd-questions@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 18:32: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