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