'/var/db/mysql/mysql-bin.index' not found
Sam Wun
swun2010 at gmail.com
Sun May 17 13:45:20 UTC 2009
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
More information about the freebsd-database
mailing list