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?