mysql won't start, tried several solutions none worked

[horseatingweeds]

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.

[Wiedmann]

What should I do here?

Maybe reading the *.err file can help.

[horseatingweeds]

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 . . .


[Wiedmann]

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"?

[horseatingweeds]

Ah, ok, you are using an old XAMPP.

It's xampp 1.7.1

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?