'/var/db/mysql/mysql-bin.index' not found

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

'/var/db/mysql/mysql-bin.index' not found

samsam007
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
_______________________________________________
[hidden email] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-database
To unsubscribe, send any mail to "[hidden email]"
Reply | Threaded
Open this post in threaded view
|

Re: '/var/db/mysql/mysql-bin.index' not found

Tom Evans-3
On Sun, 2009-05-17 at 23:13 +1000, Sam Wun wrote:

> 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

mysql runs as user mysql, and you have some files it cannot access -
probably the most important is the folder isn't owned by mysql, and it
also wouldn't be able to open the 'mysql' database, which stores user
info.

Cheers

Tom

_______________________________________________
[hidden email] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-database
To unsubscribe, send any mail to "[hidden email]"