mysqld - /var/log/mysql/mysql-bin.index not found
 

Hello,

I've tried to start MySQL server on my Kubuntu 6.06 but I was unsuccesful. Does anybody know how to install missing files???
--------------------------------------------------------------
robin@ubuntu:/var/log/mysql$ mysqld
mysqld: File '/var/log/mysql/mysql-bin.index' not found (Errcode: 13)
060905 21:21:41 [ERROR] Aborting

060905 21:21:41 [Note] mysqld: Shutdown complete

how did you installed mysql? what is it's version?
does "robin" user have root rights?
try to start mysql under the "root" user. i guess it may help.

chown those files to mysql
 

If you get this error File '/var/log/mysql/mysql-bin.index' not found (Errcode: 13) you might want to try and chown -R mysql:mysql /var/log/mysql

Cheers

Re
 

I have FreeBSD 6.1 and i think it doesn't matter if it is Kubuntu or FreeBSD 6.1.
Probably you will have the same problem as I have. It is mysql_install_db.
I edit mysql_install_db. Then i run it(mysql_install_db).
Then you have to correct rights in /var/db/mysql/.
Unfortunately i didn't save
my edited mysql_install_db but i think i edit it ->>
------------------------------
user="" //line 13 user="mysql"
pkgdatadir=/usr/local/share/mysql //line 94 to /var/db/mysql //but i didn't it sure
--------------------------------------------
maybe somebody it save and help you.
The main problem is that mysql-bin.index is searched in different "directory" and it will error in *.err(it is not exist here) than you have to edit mysql_install_db and correct this problem.

solution:' mysql-bin.index' not found (error code :13)
 

dear

i had face same problem in Linux-4 with Mysql 5.0.
solution=1:
put "mysql-bin.index" in "/usr/local/mysql/bin/" directory.

or /usr/local/mysql/bin/mysql-bin.index

after this start mysql: /etc/init.d/mysql start

it will be work.

----------------
solution =2:
if you dont have this file then create one new file named as:>
"mysql-bin.index" and paste below content into this file.

./mysql-bin.000001
./mysql-bin.000002
./mysql-bin.000003
./mysql-bin.000004
./mysql-bin.000005
./mysql-bin.000006
./mysql-bin.000008
./mysql-bin.000001
./mysql-bin.000002
./mysql-bin.000003
./mysql-bin.000004
./mysql-bin.000005
./mysql-bin.000006
./mysql-bin.000007
./mysql-bin.000008
./mysql-bin.000009
./mysql-bin.000016

after this :
put "mysql-bin.index" in "/usr/local/mysql/bin/" directory.

or /usr/local/mysql/bin/mysql-bin.index

after this start mysql: /etc/init.d/mysql start

it will be work.

Thanks alot, I had to sign in to tell you thanks...lol I was getting frustrated.