MySql startet nicht

Irgendwelche Probleme mit XAMPP für Windows? Dann ist hier genau der richtige Ort um nachzufragen.

MySql startet nicht

Postby Janno » 11. October 2014 13:17

Habe XAMPP neu installieert.
Apacha startet.
MySLaber nicht.
Hier ist mysql_error log:

2014-10-11 13:46:21 6172 [Note] Plugin 'FEDERATED' is disabled.
2014-10-11 13:46:21 1b04 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.
2014-10-11 13:46:21 6172 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-10-11 13:46:21 6172 [Note] InnoDB: The InnoDB memory heap is disabled
2014-10-11 13:46:21 6172 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-10-11 13:46:21 6172 [Note] InnoDB: Memory barrier is not used
2014-10-11 13:46:21 6172 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-10-11 13:46:21 6172 [Note] InnoDB: Not using CPU crc32 instructions
2014-10-11 13:46:21 6172 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-10-11 13:46:21 6172 [Note] InnoDB: Completed initialization of buffer pool
2014-10-11 13:46:21 6172 [Note] InnoDB: Highest supported file format is Barracuda.
2014-10-11 13:46:21 6172 [Note] InnoDB: 128 rollback segment(s) are active.
2014-10-11 13:46:21 6172 [Note] InnoDB: Waiting for purge to start
2014-10-11 13:46:21 6172 [Note] InnoDB: 5.6.20 started; log sequence number 1665234
2014-10-11 13:46:21 6172 [Note] Server hostname (bind-address): '*'; port: 3306
2014-10-11 13:46:21 6172 [Note] IPv6 is available.
2014-10-11 13:46:21 6172 [Note] - '::' resolves to '::';
2014-10-11 13:46:21 6172 [Note] Server socket created on IP: '::'.
2014-10-11 13:46:21 6172 [Note] Event Scheduler: Loaded 0 events
2014-10-11 13:46:21 6172 [Note] mysql\bin\mysqld.exe: ready for connections.
Version: '5.6.20' socket: '' port: 3306 MySQL Community Server (GPL)
2014-10-11 13:48:22 6248 [Note] Plugin 'FEDERATED' is disabled.
2014-10-11 13:48:22 534 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.
2014-10-11 13:48:22 6248 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-10-11 13:48:22 6248 [Note] InnoDB: The InnoDB memory heap is disabled
2014-10-11 13:48:22 6248 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-10-11 13:48:22 6248 [Note] InnoDB: Memory barrier is not used
2014-10-11 13:48:22 6248 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-10-11 13:48:22 6248 [Note] InnoDB: Not using CPU crc32 instructions
2014-10-11 13:48:22 6248 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-10-11 13:48:22 6248 [Note] InnoDB: Completed initialization of buffer pool
2014-10-11 13:48:22 6248 [ERROR] InnoDB: C:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2014-10-11 13:48:22 6248 [ERROR] InnoDB: The system tablespace must be writable!
2014-10-11 13:48:22 6248 [ERROR] Plugin 'InnoDB' init function returned error.
2014-10-11 13:48:22 6248 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2014-10-11 13:48:22 6248 [ERROR] Unknown/unsupported storage engine: InnoDB
2014-10-11 13:48:22 6248 [ERROR] Aborting

2014-10-11 13:48:22 6248 [Note] Binlog end
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'partition'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'INNODB_METRICS'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'INNODB_CMP'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'INNODB_TRX'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'BLACKHOLE'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'ARCHIVE'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'MRG_MYISAM'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'MyISAM'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'MEMORY'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'CSV'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'sha256_password'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'mysql_old_password'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'mysql_native_password'
2014-10-11 13:48:22 6248 [Note] Shutting down plugin 'binlog'
2014-10-11 13:48:22 6248 [Note] mysql\bin\mysqld.exe: Shutdown complete

2014-10-11 13:48:41 4584 [Note] Plugin 'FEDERATED' is disabled.
2014-10-11 13:48:41 16cc 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.
2014-10-11 13:48:41 4584 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-10-11 13:48:41 4584 [Note] InnoDB: The InnoDB memory heap is disabled
2014-10-11 13:48:41 4584 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-10-11 13:48:41 4584 [Note] InnoDB: Memory barrier is not used
2014-10-11 13:48:41 4584 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-10-11 13:48:41 4584 [Note] InnoDB: Not using CPU crc32 instructions
2014-10-11 13:48:41 4584 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-10-11 13:48:41 4584 [Note] InnoDB: Completed initialization of buffer pool
2014-10-11 13:48:41 4584 [ERROR] InnoDB: C:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2014-10-11 13:48:41 4584 [ERROR] InnoDB: The system tablespace must be writable!
2014-10-11 13:48:41 4584 [ERROR] Plugin 'InnoDB' init function returned error.
2014-10-11 13:48:41 4584 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2014-10-11 13:48:41 4584 [ERROR] Unknown/unsupported storage engine: InnoDB
2014-10-11 13:48:41 4584 [ERROR] Aborting

2014-10-11 13:48:41 4584 [Note] Binlog end
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'partition'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'INNODB_METRICS'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'INNODB_CMP'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'INNODB_TRX'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'BLACKHOLE'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'ARCHIVE'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'MRG_MYISAM'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'MyISAM'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'MEMORY'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'CSV'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'sha256_password'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'mysql_old_password'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'mysql_native_password'
2014-10-11 13:48:41 4584 [Note] Shutting down plugin 'binlog'
2014-10-11 13:48:41 4584 [Note] mysql\bin\mysqld.exe: Shutdown complete

2014-10-11 13:52:58 6136 [Note] Plugin 'FEDERATED' is disabled.
2014-10-11 13:52:58 17ec 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.
2014-10-11 13:52:58 6136 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-10-11 13:52:58 6136 [Note] InnoDB: The InnoDB memory heap is disabled
2014-10-11 13:52:58 6136 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-10-11 13:52:58 6136 [Note] InnoDB: Memory barrier is not used
2014-10-11 13:52:58 6136 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-10-11 13:52:58 6136 [Note] InnoDB: Not using CPU crc32 instructions
2014-10-11 13:52:58 6136 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-10-11 13:52:58 6136 [Note] InnoDB: Completed initialization of buffer pool
2014-10-11 13:52:58 6136 [Note] InnoDB: Highest supported file format is Barracuda.
2014-10-11 13:52:58 6136 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 1665244 in the ib_logfiles!
2014-10-11 13:52:58 6136 [Note] InnoDB: Database was not shutdown normally!
2014-10-11 13:52:58 6136 [Note] InnoDB: Starting crash recovery.
2014-10-11 13:52:58 6136 [Note] InnoDB: Reading tablespace information from the .ibd files...
2014-10-11 13:52:58 6136 [Note] InnoDB: Restoring possible half-written data pages
2014-10-11 13:52:58 6136 [Note] InnoDB: from the doublewrite buffer...
2014-10-11 13:52:58 6136 [Note] InnoDB: 128 rollback segment(s) are active.
2014-10-11 13:52:58 6136 [Note] InnoDB: Waiting for purge to start
2014-10-11 13:52:58 6136 [Note] InnoDB: 5.6.20 started; log sequence number 1665244
2014-10-11 13:52:58 6136 [Note] Server hostname (bind-address): '*'; port: 3306
2014-10-11 13:52:58 6136 [Note] IPv6 is available.
2014-10-11 13:52:58 6136 [Note] - '::' resolves to '::';
2014-10-11 13:52:58 6136 [Note] Server socket created on IP: '::'.
2014-10-11 13:52:59 6136 [Note] Event Scheduler: Loaded 0 events
2014-10-11 13:52:59 6136 [Note] mysql\bin\mysqld.exe: ready for connections.
Version: '5.6.20' socket: '' port: 3306 MySQL Community Server (GPL)
2014-10-11 13:53:21 1560 [Note] Plugin 'FEDERATED' is disabled.
2014-10-11 13:53:21 1280 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.
2014-10-11 13:53:21 1560 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-10-11 13:53:21 1560 [Note] InnoDB: The InnoDB memory heap is disabled
2014-10-11 13:53:21 1560 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-10-11 13:53:21 1560 [Note] InnoDB: Memory barrier is not used
2014-10-11 13:53:21 1560 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-10-11 13:53:21 1560 [Note] InnoDB: Not using CPU crc32 instructions
2014-10-11 13:53:21 1560 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-10-11 13:53:21 1560 [Note] InnoDB: Completed initialization of buffer pool
2014-10-11 13:53:21 1560 [ERROR] InnoDB: C:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2014-10-11 13:53:21 1560 [ERROR] InnoDB: The system tablespace must be writable!
2014-10-11 13:53:21 1560 [ERROR] Plugin 'InnoDB' init function returned error.
2014-10-11 13:53:21 1560 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2014-10-11 13:53:21 1560 [ERROR] Unknown/unsupported storage engine: InnoDB
2014-10-11 13:53:21 1560 [ERROR] Aborting

2014-10-11 13:53:21 1560 [Note] Binlog end
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'partition'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'INNODB_METRICS'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'INNODB_CMP'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'INNODB_TRX'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'BLACKHOLE'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'ARCHIVE'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'MRG_MYISAM'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'MyISAM'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'MEMORY'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'CSV'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'sha256_password'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'mysql_old_password'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'mysql_native_password'
2014-10-11 13:53:21 1560 [Note] Shutting down plugin 'binlog'
2014-10-11 13:53:21 1560 [Note] mysql\bin\mysqld.exe: Shutdown complete

2014-10-11 14:16:40 3560 [Note] Plugin 'FEDERATED' is disabled.
2014-10-11 14:16:40 c50 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.
2014-10-11 14:16:40 3560 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-10-11 14:16:40 3560 [Note] InnoDB: The InnoDB memory heap is disabled
2014-10-11 14:16:40 3560 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-10-11 14:16:40 3560 [Note] InnoDB: Memory barrier is not used
2014-10-11 14:16:40 3560 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-10-11 14:16:40 3560 [Note] InnoDB: Not using CPU crc32 instructions
2014-10-11 14:16:40 3560 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-10-11 14:16:40 3560 [Note] InnoDB: Completed initialization of buffer pool
2014-10-11 14:16:40 3560 [ERROR] InnoDB: C:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2014-10-11 14:16:40 3560 [ERROR] InnoDB: The system tablespace must be writable!
2014-10-11 14:16:40 3560 [ERROR] Plugin 'InnoDB' init function returned error.
2014-10-11 14:16:40 3560 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2014-10-11 14:16:40 3560 [ERROR] Unknown/unsupported storage engine: InnoDB
2014-10-11 14:16:40 3560 [ERROR] Aborting

2014-10-11 14:16:40 3560 [Note] Binlog end
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'partition'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'INNODB_METRICS'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'INNODB_CMP'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'INNODB_TRX'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'BLACKHOLE'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'ARCHIVE'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'MRG_MYISAM'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'MyISAM'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'MEMORY'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'CSV'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'sha256_password'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'mysql_old_password'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'mysql_native_password'
2014-10-11 14:16:40 3560 [Note] Shutting down plugin 'binlog'
2014-10-11 14:16:40 3560 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

Was ist das Problem?
Janno
 
Posts: 30
Joined: 28. March 2009 16:57
Operating System: Vista

Re: MySql startet nicht

Postby GMYC » 16. December 2014 09:34

Moin, ich bin neu hier und habe, welch Wunder ein Problem; nämlich exakt das hier Beschriebene.

Als weiterer Anhalt noch die Fehlermeldung bei Start von mysql aus xampp heraus:
quote

08:44:52 [mysql] Attempting to start MySQL app...
08:44:58 [mysql] Status change detected: running
08:44:59 [mysql] Status change detected: stopped
08:44:59 [mysql] Error: MySQL shutdown unexpectedly.
08:44:59 [mysql] This may be due to a blocked port, missing dependencies,
08:44:59 [mysql] improper privileges, a crash, or a shutdown by another method.
08:44:59 [mysql] Press the Logs button to view error logs and check
08:44:59 [mysql] the Windows Event Viewer for more clues
08:44:59 [mysql] If you need more help, copy and post this
08:44:59 [mysql] entire log window on the forums

unquote

Der log zeigt dann genau den in diesem Thread beschriebenen Text.

Kann jemand helfen???

Wäre schön, stehe nämlich auf dem Schlauch und weiß nicht weiter.

Danke
GMYC
 
Posts: 2
Joined: 16. December 2014 08:23
Operating System: Win8.1

Re: MySql startet nicht

Postby Nobbie » 16. December 2014 11:50

Auf welche Weise hast Du Xampp installiert und auf welche Weise hast Du die Xampp Control gestartet? Grundsätzlich soll man bei Problemen mit Zugriffsrechten IMMER erst einmal versuchen, denn Xampp Control Dialog mit Administrator zu starten (rechts klicken -> als Administrator ausführen). Dort dann Apache und MySQL starten. Meistens löst das schon das Problem.

Als weitere Ursache kommt eine bereits installierte und laufende MySQL Version in Betracht. Schau Dir den Taskmanager an und suche nach "mysqld".
Nobbie
 
Posts: 13182
Joined: 09. March 2008 13:04

Re: MySql startet nicht

Postby GMYC » 16. December 2014 12:58

@Nobbie: Ich danke Dir! Das hat das Prob. gelöst. spitze
GMYC
 
Posts: 2
Joined: 16. December 2014 08:23
Operating System: Win8.1

Re: MySql startet nicht

Postby cladi » 31. December 2014 19:08

Hallo,
ich hab ein ähnliches Problem mit der gleichen Meldung im Xampp
nach dem Update des Xampp und dem Update von Wordpress.
Das Update vom Xampp habe ich online (ohne Absicherung :-/ gemacht, hat aber funktioniert.
Ich arbeite immer noch offline, die Wordpress-Seite ist noch nicht fertig.
MSQL bricht icht immer nach kurzer zeit auf Port 3306 ab. Apache lauscht auf Port 80. Bricht auch manchmal ab.
Dann meldet der Browser Datenbank not connected.
Und im Wordpressadmin kann ich im Dashboard zwar die Bearbeiten Funktion für die Beiträge und Seiten öffnen,
aber dann werden sie im Editor nicht angezeigt.
Ist die Datenbank MSQL vielleicht nicht verbunden?
Muss ich das DB backup der vorhandenen Seite neu in MSQL importieren?
Was habe ich falsch gemacht? :oops:

Cladi
cladi
 
Posts: 4
Joined: 31. December 2014 18:24
Operating System: Win 8.1

Re: MySql startet nicht

Postby cladi » 31. December 2014 19:10

P.s. ich habe Win 8.1 und mit Adminrechten xampp über localhost gestartet.
Cladi
cladi
 
Posts: 4
Joined: 31. December 2014 18:24
Operating System: Win 8.1

Re: MySql startet nicht

Postby Nobbie » 01. January 2015 12:57

cladi wrote:Das Update vom Xampp habe ich online (ohne Absicherung :-/ gemacht, hat aber funktioniert


Wahrscheinlich hast Du damit Deine Datenbank vernichtet. Wie hast Du ein Update gemacht, es gibt ja keine Update Prozedur und auch keine Update Version?
Nobbie
 
Posts: 13182
Joined: 09. March 2008 13:04

Re: MySql startet nicht

Postby cladi » 13. January 2015 22:18

Hallo Nobie,
Ich habe aus dem Backend von Wordpress das Update gestartet.
Zwischendurvh hatte ich Fehlermeldungen Line 495 und 1103 in wp-config.php, die sind jetzt plötzlich nicht mehr da.
Allderdings bricht der xampp bei jedem Versuch aus dem Backend eine Seite in den Editor zu laden ab. Dann kommt die Fehlermeldung "lost contact to database server at localhost.
und evtl ist Socket des lokalen Msql Servers nicht richtig konfiguriert, ich habe da nichts geändert.
Wenn ich die Wordpress Seite im Browser aufrufe werden alle Seiten gezeigt, nur nach anmeldung im Dashboard und dem Vesuch die Seiten zur Bearbeitung zu laden, bricht der msql immer ab mit obiger meldung.
Die Datenbank muss aber vorhanden sein, sonst würde die Webseite doch nicht im Browser aufgerufen. Es fehlt wohl die Verbindung zwoschen Dashboard und Datenbank??
Ich bin ratlos!
Gruss
Cladi
cladi
 
Posts: 4
Joined: 31. December 2014 18:24
Operating System: Win 8.1


Return to XAMPP für Windows

Who is online

Users browsing this forum: No registered users and 23 guests