sathenzar Posted November 22, 2007 Share Posted November 22, 2007 Hey today I start my mysql service up (it was working the night before) and all the sudden I notice an error dumped out as this: C:\xampp>mysql_start Diese Eingabeforderung nicht waehrend des Running beenden Please dont close Window while MySQL is running MySQL is trying to start Please wait ... MySQL is starting with mysql\bin\my.cnf (console) 071122 12:18:16 [ERROR] Fatal error: Can't open and lock privilege tables: File '.\mysql\host.MYD' not found (Errcode: 2) MySQL konnte nicht gestartet werden MySQL could not be started Press any key to continue . . . What can I do? I don't have my databases back up so I hope they're ok or I'm going to have to programmically create 150 tables all over again :( Link to comment Share on other sites More sharing options...
0 FlibbyFlobby Posted November 22, 2007 Share Posted November 22, 2007 Hey today I start my mysql service up (it was working the night before) and all the sudden I notice an error dumped out as this:C:\xampp>mysql_start Diese Eingabeforderung nicht waehrend des Running beenden Please dont close Window while MySQL is running MySQL is trying to start Please wait ... MySQL is starting with mysql\bin\my.cnf (console) 071122 12:18:16 [ERROR] Fatal error: Can't open and lock privilege tables: File '.\mysql\host.MYD' not found (Errcode: 2) MySQL konnte nicht gestartet werden MySQL could not be started Press any key to continue . . . What can I do? I don't have my databases back up so I hope they're ok or I'm going to have to programmically create 150 tables all over again :( Firstly, don't panic. There's a folder in C:/xampp/mysql/data (or wherever you installed it) that has all the physical files that represent your databases. You can simply backup these up and paste them into the same location on a fresh Xampp install and be fine. Secondly, it looks like MySQL is mentioning my.cnf, which is a MySQL configuration file. Have you edited it? If you did and you have an error in it (syntax for example) it could cause MySQL not to start. Link to comment Share on other sites More sharing options...
0 LightIdea Posted November 22, 2007 Share Posted November 22, 2007 071122 12:18:16 [ERROR] Fatal error: Can't open and lock privilege tables: File'.\mysql\host.MYD' not found (Errcode: 2) It looks like you have deleted the mysql folder inside the data folder. Don't delete it. Link to comment Share on other sites More sharing options...
0 sathenzar Posted November 24, 2007 Author Share Posted November 24, 2007 no I found the problem bitdefender for some reason deleted it. I don't know why I had to reinstall but my databases are intact :) Link to comment Share on other sites More sharing options...
Question
sathenzar
Hey today I start my mysql service up (it was working the night before) and all the sudden I notice an error dumped out as this:
C:\xampp>mysql_start
Diese Eingabeforderung nicht waehrend des Running beenden
Please dont close Window while MySQL is running
MySQL is trying to start
Please wait ...
MySQL is starting with mysql\bin\my.cnf (console)
071122 12:18:16 [ERROR] Fatal error: Can't open and lock privilege tables: File
'.\mysql\host.MYD' not found (Errcode: 2)
MySQL konnte nicht gestartet werden
MySQL could not be started
Press any key to continue . . .
What can I do? I don't have my databases back up so I hope they're ok or I'm going to have to programmically create 150 tables all over again :(
Link to comment
Share on other sites
3 answers to this question
Recommended Posts