Date: Sun, 17 May 2009 23:13:26 +1000 From: Sam Wun <swun2010@gmail.com> To: freebsd-database@freebsd.org Subject: '/var/db/mysql/mysql-bin.index' not found Message-ID: <736c47cb0905170613w7768c7a8l651e6d5be280554f@mail.gmail.com>
next in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?736c47cb0905170613w7768c7a8l651e6d5be280554f>