Results 1 to 2 of 2

Thread: mySQL crashed overnight~!

  1. #1

    Thread Starter
    Hyperactive Member mastermind94's Avatar
    Join Date
    Jun 2000
    Location
    Montréal, Canada
    Posts
    441

    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

  2. #2
    Hyperactive Member
    Join Date
    Aug 2002
    Location
    Toronto, Ontario, Canada
    Posts
    275
    try re-installing mySql

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width