LinuxQuestions.org - mysql server does not start up

Hello,

Wanted to install mysql for media wiki. Was unable to get mysql running. I am posting the errors that I am getting.

Code:

prasanta@gbook:/var/lib$ sudo mysqld type

Password:



InnoDB: No valid checkpoint found.

InnoDB: If this error appears when you are creating an InnoDB database,

InnoDB: the problem may be that during an earlier attempt you managed

InnoDB: to create the InnoDB data files, but log file creation failed.

InnoDB: If that is the case, please refer to

InnoDB: http://dev.mysql.com/doc/mysql/en/Error_creating_InnoDB.html

051019 10:25:15 Can't init databases

051019 10:25:15 Aborting



051019 10:25:15 InnoDB: Warning: shutting down a not properly started

InnoDB: or created database!

051019 10:25:15 mysqld: Shutdown Complete

/var/lib/mysql/mysql/ is empty.

Output from mysql_install_db

Code:

Preparing db table

Preparing host table

Preparing user table

Preparing func table

Preparing tables_priv table

Preparing columns_priv table

Installing all prepared tables

ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 22)

ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 22)

ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 22)

ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 22)

ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 22)

ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 22)

ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 22)

ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 22)

....

....

Mysql restarts says the following.

Code:

prasanta@gbook:/var/lib$ sudo /etc/init.d/mysql start

Starting MySQL database server: mysqld...failed.

Please take a look at the syslog.

/usr/bin/mysqladmin: connect to server at 'localhost' failed

error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'

Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

The syslog also says the same thing.

I do not think permissions are the issue because I have even tried chmod 777 on the directory.

I have searched through the forum but was unable to get mysql running. Help.

Thanks

--
Prasanta