mysql won't start, tried several solutions none worked

Problems with the Windows version of XAMPP, questions, comments, and anything related.

mysql won't start, tried several solutions none worked

Postby horseatingweeds » 22. September 2009 01:41

Everything seemed to be running fine the a couple days ago. Now mysql won't start. Apache starts ok. I've tried a few things I found after searching, like running the xampp.stop.exe and xampp.start.exe. I've restarted windows. I ran xampp-portcheck.exe and it shows mysql on port 3306 and says it's free.

What should I do here? I haven't done anything to make a change since it was running fine.
horseatingweeds
 
Posts: 20
Joined: 10. September 2009 03:17

Re: mysql won't start, tried several solutions none worked

Postby Wiedmann » 22. September 2009 03:10

What should I do here?

Maybe reading the *.err file can help.
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: mysql won't start, tried several solutions none worked

Postby horseatingweeds » 22. September 2009 03:36

I don't see a mysql .err file. The apache error file didn't have anything about mysql in it. But after running mysql.bat Here it is.

Code: Select all
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)
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
090921 22:33:24  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
090921 22:33:24  InnoDB: Started; log sequence number 0 58311781
090921 22:33:24 [ERROR] Fatal error: Can't open and lock privilege tables: Can't
 find file: 'host' (errno: 2)

MySQL konnte nicht gestartet werden
MySQL could not be started
Press any key to continue . . .
horseatingweeds
 
Posts: 20
Joined: 10. September 2009 03:17

Re: mysql won't start, tried several solutions none worked

Postby Wiedmann » 22. September 2009 03:48

But after running mysql.bat Here it is.

Ah, ok, you are using an old XAMPP.

090921 22:33:24 [ERROR] Fatal error: Can't open and lock privilege tables: Can't
find file: 'host' (errno: 2)

Did you have same "host.*" files in "\xampp\mysql\data\mysql"?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: mysql won't start, tried several solutions none worked

Postby horseatingweeds » 22. September 2009 04:06

Wiedmann wrote:Ah, ok, you are using an old XAMPP.


It's xampp 1.7.1

Wiedmann wrote:Did you have same "host.*" files in "\xampp\mysql\data\mysql"?


I have one file in \xampp\mysql\data\mysql called host.frm. I tried opening it but my test editor can't read it.

Edit...

I found an error log in the data directory - in a file named after the computer:

Code: Select all
090921 20:14:31 [Note] Plugin 'InnoDB' disabled by command line option
090921 20:14:31 [ERROR] mysql\bin\mysqld.exe: unknown option '--skip-bdb'
090921 20:14:31 [ERROR] Aborting

090921 20:14:31 [Warning] Forcing shutdown of 2 plugins
090921 20:14:31 [Note] mysql\bin\mysqld.exe: Shutdown complete

090921 20:14:33 [Note] Plugin 'InnoDB' disabled by command line option
090921 20:14:33 [ERROR] mysql\bin\mysqld.exe: unknown option '--skip-bdb'
090921 20:14:33 [ERROR] Aborting

090921 20:14:33 [Warning] Forcing shutdown of 2 plugins
090921 20:14:33 [Note] mysql\bin\mysqld.exe: Shutdown complete

090921 20:14:53 [Note] Plugin 'InnoDB' disabled by command line option
090921 20:14:53 [ERROR] mysql\bin\mysqld.exe: unknown option '--skip-bdb'
090921 20:14:53 [ERROR] Aborting

090921 20:14:53 [Warning] Forcing shutdown of 2 plugins
090921 20:14:53 [Note] mysql\bin\mysqld.exe: Shutdown complete

090921 20:14:58 [Note] Plugin 'InnoDB' disabled by command line option
090921 20:14:58 [ERROR] mysql\bin\mysqld.exe: unknown option '--skip-bdb'
090921 20:14:58 [ERROR] Aborting

090921 20:14:58 [Warning] Forcing shutdown of 2 plugins
090921 20:14:58 [Note] mysql\bin\mysqld.exe: Shutdown complete

090921 20:15:01 [Note] Plugin 'InnoDB' disabled by command line option
090921 20:15:01 [ERROR] mysql\bin\mysqld.exe: unknown option '--skip-bdb'
090921 20:15:01 [ERROR] Aborting

090921 20:15:01 [Warning] Forcing shutdown of 2 plugins
090921 20:15:01 [Note] mysql\bin\mysqld.exe: Shutdown complete

090921 20:15:04 [Note] Plugin 'InnoDB' disabled by command line option
090921 20:15:04 [ERROR] mysql\bin\mysqld.exe: unknown option '--skip-bdb'
090921 20:15:04 [ERROR] Aborting

090921 20:15:04 [Warning] Forcing shutdown of 2 plugins
090921 20:15:04 [Note] mysql\bin\mysqld.exe: Shutdown complete

090921 20:25:14 [Note] Plugin 'InnoDB' disabled by command line option
090921 20:25:14 [ERROR] mysql\bin\mysqld.exe: unknown option '--skip-bdb'
090921 20:25:14 [ERROR] Aborting

090921 20:25:14 [Warning] Forcing shutdown of 2 plugins
090921 20:25:14 [Note] mysql\bin\mysqld.exe: Shutdown complete

090921 20:33:26 [Note] Plugin 'InnoDB' disabled by command line option
090921 20:33:26 [ERROR] mysql\bin\mysqld.exe: unknown option '--skip-bdb'
090921 20:33:26 [ERROR] Aborting

090921 20:33:26 [Warning] Forcing shutdown of 2 plugins
090921 20:33:26 [Note] mysql\bin\mysqld.exe: Shutdown complete

090921 20:33:30 [Note] Plugin 'InnoDB' disabled by command line option
090921 20:33:30 [ERROR] mysql\bin\mysqld.exe: unknown option '--skip-bdb'
090921 20:33:30 [ERROR] Aborting

090921 20:33:30 [Warning] Forcing shutdown of 2 plugins
090921 20:33:30 [Note] mysql\bin\mysqld.exe: Shutdown complete

090921 20:58:18 [Note] Plugin 'InnoDB' disabled by command line option
090921 20:58:18 [ERROR] mysql\bin\mysqld.exe: unknown option '--skip-bdb'
090921 20:58:18 [ERROR] Aborting

090921 20:58:18 [Warning] Forcing shutdown of 2 plugins
090921 20:58:18 [Note] mysql\bin\mysqld.exe: Shutdown complete

090921 20:58:48 [Note] Plugin 'InnoDB' disabled by command line option
090921 20:58:48 [ERROR] mysql\bin\mysqld.exe: unknown option '--skip-bdb'
090921 20:58:48 [ERROR] Aborting

090921 20:58:48 [Warning] Forcing shutdown of 2 plugins
090921 20:58:48 [Note] mysql\bin\mysqld.exe: Shutdown complete

090921 21:13:43 [Note] Plugin 'InnoDB' disabled by command line option
090921 21:13:43 [ERROR] mysql\bin\mysqld.exe: unknown option '--skip-bdb'
090921 21:13:43 [ERROR] Aborting

090921 21:13:43 [Warning] Forcing shutdown of 2 plugins
090921 21:13:43 [Note] mysql\bin\mysqld.exe: Shutdown complete

090921 21:14:45 [Note] Plugin 'InnoDB' disabled by command line option
090921 21:14:45 [ERROR] mysql\bin\mysqld.exe: unknown option '--skip-bdb'
090921 21:14:45 [ERROR] Aborting

090921 21:14:45 [Warning] Forcing shutdown of 2 plugins
090921 21:14:45 [Note] mysql\bin\mysqld.exe: Shutdown complete

090921 21:15:00 [Note] Plugin 'InnoDB' disabled by command line option
090921 21:15:00 [ERROR] mysql\bin\mysqld.exe: unknown option '--skip-bdb'
090921 21:15:00 [ERROR] Aborting

090921 21:15:00 [Warning] Forcing shutdown of 2 plugins
090921 21:15:00 [Note] mysql\bin\mysqld.exe: Shutdown complete

090921 21:15:04 [Note] Plugin 'InnoDB' disabled by command line option
090921 21:15:04 [ERROR] mysql\bin\mysqld.exe: unknown option '--skip-bdb'
090921 21:15:04 [ERROR] Aborting

090921 21:15:04 [Warning] Forcing shutdown of 2 plugins
090921 21:15:04 [Note] mysql\bin\mysqld.exe: Shutdown complete

090921 21:17:51 [Note] Plugin 'InnoDB' disabled by command line option
090921 21:17:51 [ERROR] mysql\bin\mysqld.exe: unknown option '--skip-bdb'
090921 21:17:51 [ERROR] Aborting

090921 21:17:51 [Warning] Forcing shutdown of 2 plugins
090921 21:17:51 [Note] mysql\bin\mysqld.exe: Shutdown complete

090921 21:20:36 [Note] Plugin 'InnoDB' disabled by command line option
090921 21:20:36 [ERROR] mysql\bin\mysqld.exe: unknown option '--skip-bdb'
090921 21:20:36 [ERROR] Aborting

090921 21:20:36 [Warning] Forcing shutdown of 2 plugins
090921 21:20:36 [Note] mysql\bin\mysqld.exe: Shutdown complete

090921 21:20:40 [Note] Plugin 'InnoDB' disabled by command line option
090921 21:20:40 [ERROR] mysql\bin\mysqld.exe: unknown option '--skip-bdb'
090921 21:20:40 [ERROR] Aborting

090921 21:20:40 [Warning] Forcing shutdown of 2 plugins
090921 21:20:40 [Note] mysql\bin\mysqld.exe: Shutdown complete

090921 21:20:41 [Note] Plugin 'InnoDB' disabled by command line option
090921 21:20:41 [ERROR] mysql\bin\mysqld.exe: unknown option '--skip-bdb'
090921 21:20:41 [ERROR] Aborting

090921 21:20:41 [Warning] Forcing shutdown of 2 plugins
090921 21:20:41 [Note] mysql\bin\mysqld.exe: Shutdown complete



And here is one named mysql_error.log (should have looked closer in data directory I guess.

Code: Select all
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
090921 20:04:43  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
090921 20:04:43  InnoDB: Started; log sequence number 0 58311781
090921 20:04:43 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
090921 22:04:59  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
090921 22:04:59  InnoDB: Started; log sequence number 0 58311781
090921 22:04:59 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
090921 22:05:18  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
090921 22:05:18  InnoDB: Started; log sequence number 0 58311781
090921 22:05:18 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)


So does this mean InnoDB is disabled and I need to enable it?
horseatingweeds
 
Posts: 20
Joined: 10. September 2009 03:17


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 50 guests