mySQL crashed overnight~!
hello all,
i'm running mySQL on my Windows 2K Server and mySQL crashed over night. Here's a copy of the DATA\MySql.Err (Today). I've been working on it since this morning and i need to fix that b4 the boss comes in (u guys must know how it is).
thanks Alot...
~me
Code:
030206 8:12:47 C:/mysql/bin/mysqld.exe: Table 'mysql.host' doesn't exist
Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not want to use transactional InnoDB tables, add a line
skip-innodb
to the [mysqld] section of init parameters in your my.cnf
or my.ini. If you want to use InnoDB tables, add to the [mysqld]
section, for example,
innodb_data_file_path = ibdata1:10M:autoextend
But to get good performance you should adjust for your hardware
the InnoDB startup options listed in section 2 at
http://www.innodb.com/ibman.html
// i added the nine innodb_data_file_path..... to the file then this line appears:
030206 8:12:58 MySql: Table 'mysql.host' doesn't exist
