From owner-freebsd-database@FreeBSD.ORG Sun May 17 13:45:20 2009 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 8E4B8106566C for ; Sun, 17 May 2009 13:45:20 +0000 (UTC) (envelope-from swun2010@gmail.com) Received: from wf-out-1314.google.com (wf-out-1314.google.com [209.85.200.168]) by mx1.freebsd.org (Postfix) with ESMTP id 65AD88FC0C for ; Sun, 17 May 2009 13:45:20 +0000 (UTC) (envelope-from swun2010@gmail.com) Received: by wf-out-1314.google.com with SMTP id 24so1428374wfg.7 for ; Sun, 17 May 2009 06:45:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:date:message-id:subject :from:to:content-type:content-transfer-encoding; bh=zov4gIJ6kz5i+eAb9kPvgjn7BhtVNqks80Dxph2d9mM=; b=uf1WVpijOHzV+a3WajddH98ip/CI9CitTwEaJBy8MNSIt1vME4+6VdOLiBzBbpCYMU b7mA9sMYvPd9SZh5KYu6/6TH3O3Wv5+P3nlBnLEaI3sXbkhth6+8h5jsOWiJX1sqVyU2 918S5USM6Fjer8Fyn8uuZY0UIHlpahA8Q0CUI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type :content-transfer-encoding; b=fv+wFMbl9pWLKIiyLsHDC/fXT2dUeVahsI8QPLMTDroppVrdvkJqrnNHF2cvlO1gsh WeLhlYl3uAITKr82sUJ1ANthd3vS4EZGkE0niCjHu+TUyya/j9oNC2jA+7MiUD4TKXW6 4/62yMI9CoOBGVbSG/PEM7R1x3YjsF7AL+0G8= MIME-Version: 1.0 Received: by 10.143.37.20 with SMTP id p20mr1696582wfj.207.1242566006391; Sun, 17 May 2009 06:13:26 -0700 (PDT) Date: Sun, 17 May 2009 23:13:26 +1000 Message-ID: <736c47cb0905170613w7768c7a8l651e6d5be280554f@mail.gmail.com> From: Sam Wun To: freebsd-database@freebsd.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Subject: '/var/db/mysql/mysql-bin.index' not found X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 17 May 2009 13:45:20 -0000 Hi, I am running mysql 5.1 server in freebsd 7.2. I got the an error when I tried to start the following command: # /usr/local/bin/mysqld_safe --skip-grant-tables Error is: 090517 23:05:19 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql /usr/local/libexec/mysqld: File '/var/db/mysql/mysql-bin.index' not found (Errcode: 13) 090517 23:05:19 [ERROR] Aborting 090517 23:05:19 [Note] /usr/local/libexec/mysqld: Shutdown complete Here are all files in the directory: wp1:mysql # pwd /var/db/mysql wp1:mysql # ls -l total 22002 drwx------ 4 root mysql 512 May 17 23:05 ./ drwxr-xr-x 9 root wheel 512 May 12 13:57 ../ -rw-rw---- 1 mysql mysql 5242880 May 17 22:29 ib_logfile0 -rw-rw---- 1 mysql mysql 5242880 May 17 22:12 ib_logfile1 -rw-rw---- 1 mysql mysql 10485760 May 17 22:29 ibdata1 drwx------ 2 root mysql 2048 May 12 13:57 mysql/ -rw-rw---- 1 mysql mysql 125 May 17 22:16 mysql-bin.000001 -rw-rw---- 1 mysql mysql 125 May 17 22:17 mysql-bin.000002 -rw-rw---- 1 mysql mysql 951 May 17 22:19 mysql-bin.000003 -rw-rw---- 1 mysql mysql 708461 May 17 22:19 mysql-bin.000004 -rw-rw---- 1 mysql mysql 406 May 17 22:29 mysql-bin.000005 -rw-rw---- 1 root mysql 951 May 17 22:27 mysql-bin.000006 -rw-rw---- 1 root mysql 708461 May 17 22:27 mysql-bin.000007 -rw-rw---- 1 mysql mysql 133 May 17 22:27 mysql-bin.index drwx------ 2 root mysql 512 May 12 13:57 test/ -rw-rw---- 1 mysql mysql 6841 May 17 23:05 wp1.ip6.com.au.err -rw-rw---- 1 mysql mysql 5681 May 17 22:17 wp1.ip6.com.au.err-old wp1:mysql # The mysql-bin.index is in the path , why mysqld_safe can't pick it up? Your help is very much appreciated. Thanks