Ich habe diese Version installiert: xampp-win32-5.5.30-3-vc11-installer
Wenn ich MySQL starte und danach den Admin von MySQL erhalte ich nach Neustart von MySQL unter Logs folgende Einträge:
2015-11-17 05:20:13 cb0 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2015-11-17 5:20:13 3248 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2015-11-17 5:20:13 3248 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-17 5:20:13 3248 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-11-17 5:20:13 3248 [Note] InnoDB: Memory barrier is not used
2015-11-17 5:20:13 3248 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-17 5:20:13 3248 [Note] InnoDB: Not using CPU crc32 instructions
2015-11-17 5:20:13 3248 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-11-17 5:20:13 3248 [Note] InnoDB: Completed initialization of buffer pool
2015-11-17 5:20:13 3248 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-17 5:20:13 3248 [Note] InnoDB: The log sequence numbers 1835037 and 1835037 in ibdata files do not match the log sequence number 1839379 in the ib_logfiles!
2015-11-17 5:20:13 3248 [Note] InnoDB: Database was not shutdown normally!
2015-11-17 5:20:13 3248 [Note] InnoDB: Starting crash recovery.
2015-11-17 5:20:13 3248 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-11-17 5:20:14 3248 [Note] InnoDB: Restoring possible half-written data pages
2015-11-17 5:20:14 3248 [Note] InnoDB: from the doublewrite buffer...
2015-11-17 5:20:14 3248 [Note] InnoDB: 128 rollback segment(s) are active.
2015-11-17 5:20:14 3248 [Note] InnoDB: Waiting for purge to start
2015-11-17 5:20:14 3248 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1839379
2015-11-17 5:20:15 200 [Note] InnoDB: Dumping buffer pool(s) not yet started
2015-11-17 5:20:15 3248 [Note] Plugin 'FEEDBACK' is disabled.
2015-11-17 5:20:15 3248 [Note] Recovering after a crash using tc.log
2015-11-17 5:20:15 3248 [Note] Starting crash recovery...
2015-11-17 5:20:15 3248 [Note] Crash recovery finished.
2015-11-17 5:20:15 3248 [Note] Server socket created on IP: '::'.
2015-11-17 5:20:15 3248 [ERROR] mysqld.exe: Table '.\mysql\db' is marked as crashed and should be repaired
2015-11-17 5:20:15 3248 [Warning] Checking table: '.\mysql\db'
2015-11-17 5:20:15 3248 [ERROR] mysql.db: 1 client is using or hasn't closed the table properly
2015-11-17 5:20:15 3248 [ERROR] mysqld.exe: Table '.\mysql\tables_priv' is marked as crashed and should be repaired
2015-11-17 5:20:15 3248 [Warning] Checking table: '.\mysql\tables_priv'
2015-11-17 5:20:15 3248 [ERROR] mysql.tables_priv: 1 client is using or hasn't closed the table properly
2015-11-17 5:20:15 3248 [ERROR] mysqld.exe: Table '.\mysql\columns_priv' is marked as crashed and should be repaired
2015-11-17 5:20:15 3248 [Warning] Checking table: '.\mysql\columns_priv'
2015-11-17 5:20:15 3248 [ERROR] mysql.columns_priv: 1 client is using or hasn't closed the table properly
2015-11-17 5:20:15 3248 [ERROR] mysqld.exe: Table '.\mysql\procs_priv' is marked as crashed and should be repaired
2015-11-17 5:20:15 3248 [Warning] Checking table: '.\mysql\procs_priv'
2015-11-17 5:20:15 3248 [ERROR] mysql.procs_priv: 1 client is using or hasn't closed the table properly
2015-11-17 5:20:15 3248 [Note] Event Scheduler: Loaded 0 events
2015-11-17 5:20:15 3248 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
Beende ich jetzt MySQL wieder, ohne den Admin gestartet zu haben und starte MySQL wieder neu, dann bekomme ich diese Meldungen:
2015-11-17 05:16:51 1984 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2015-11-17 5:16:51 6532 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2015-11-17 5:16:51 6532 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-17 5:16:51 6532 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-11-17 5:16:51 6532 [Note] InnoDB: Memory barrier is not used
2015-11-17 5:16:51 6532 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-17 5:16:51 6532 [Note] InnoDB: Not using CPU crc32 instructions
2015-11-17 5:16:51 6532 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-11-17 5:16:51 6532 [Note] InnoDB: Completed initialization of buffer pool
2015-11-17 5:16:51 6532 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-17 5:16:51 6532 [Note] InnoDB: The log sequence numbers 1835037 and 1835037 in ibdata files do not match the log sequence number 1839349 in the ib_logfiles!
2015-11-17 5:16:51 6532 [Note] InnoDB: Database was not shutdown normally!
2015-11-17 5:16:51 6532 [Note] InnoDB: Starting crash recovery.
2015-11-17 5:16:51 6532 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-11-17 5:16:51 6532 [Note] InnoDB: Restoring possible half-written data pages
2015-11-17 5:16:51 6532 [Note] InnoDB: from the doublewrite buffer...
2015-11-17 5:16:52 6532 [Note] InnoDB: 128 rollback segment(s) are active.
2015-11-17 5:16:52 6532 [Note] InnoDB: Waiting for purge to start
2015-11-17 5:16:52 6532 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1839349
2015-11-17 5:16:52 5776 [Note] InnoDB: Dumping buffer pool(s) not yet started
2015-11-17 5:16:52 6532 [Note] Plugin 'FEEDBACK' is disabled.
2015-11-17 5:16:52 6532 [Note] Recovering after a crash using tc.log
2015-11-17 5:16:52 6532 [Note] Starting crash recovery...
2015-11-17 5:16:52 6532 [Note] Crash recovery finished.
2015-11-17 5:16:52 6532 [Note] Server socket created on IP: '::'.
2015-11-17 5:16:52 6532 [Note] Event Scheduler: Loaded 0 events
2015-11-17 5:16:52 6532 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
das selbe Problem hatte ich bereits, als ich vorher diese Version installiert hatte: xampp-win32-5.6.14-0-VC11-installer
Für mich sieht das aus, das der Admin die DB nicht korrekt beendet und dabei dann die DB zerstört.
Ich habe keinerlei Änderungen bisher vorgenommen, nur installiert. Auf dem Rechner läuft Windows 7 Home 64 bit.
Ich möchte eigentlich den JTL-Shop4 lokal installieren.
Was kann ich nun tun?