D&C GLug - Home Page

[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]

Re: [LUG] Databases again

 

Neil Winchurst wrote:

> Anyway, I have now looked at localhost.err in /var/lib/mysql and here is
> the last bit
> 
> 060621 16:23:46  mysqld started
> 060621 16:23:48  InnoDB: Started
> 060621 16:23:48 /usr/sbin/mysqld: Can't open file: 'host.MYI'. (errno:
> 142) 060621 16:23:48 Fatal error: Can't open privilege tables: File
> '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2) 060621
> 16:23:48 Aborting
> 
> 060621 16:23:48  InnoDB: Starting shutdown...
> 060621 16:23:51  InnoDB: Shutdown completed
> 060621 16:23:51 /usr/sbin/mysqld: Shutdown Complete
> 
> 060621 16:23:51  mysqld ended
> 
> So I obviously have problems.

Does host.MYI (or any other file) exist in /var/lib/mysql/mysql ?

Sounds like the tables may not have been initialised, in which
case you may need to run mysql_install_db.

james

-- 
The Mailing List for the Devon & Cornwall LUG
http://mailman.dclug.org.uk/listinfo/list
FAQ: http://www.dcglug.org.uk/linux_adm/list-faq.html