MySQL не тръгва (лог в темата)

GTI

Well-Known Member
Joined
Jan 1, 2011
Messages
1,364
Reaction score
422
това се случи днес,не съм барал нищо по настройките.

2015-11-27 17:53:24 1a58 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.
151127 17:53:24 [Note] InnoDB: Using mutexes to ref count buffer pool pages
151127 17:53:24 [Note] InnoDB: The InnoDB memory heap is disabled
151127 17:53:24 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
151127 17:53:24 [Note] InnoDB: Memory barrier is not used
151127 17:53:24 [Note] InnoDB: Compressed tables use zlib 1.2.3
151127 17:53:24 [Note] InnoDB: Not using CPU crc32 instructions
151127 17:53:24 [Note] InnoDB: Initializing buffer pool, size = 16.0M
151127 17:53:24 [Note] InnoDB: Completed initialization of buffer pool
151127 17:53:24 [Note] InnoDB: Highest supported file format is Barracuda.
151127 17:53:24 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1712243
151127 17:53:24 [Note] InnoDB: Database was not shutdown normally!
151127 17:53:24 [Note] InnoDB: Starting crash recovery.
151127 17:53:24 [Note] InnoDB: Reading tablespace information from the .ibd files...
151127 17:53:24 [Note] InnoDB: Restoring possible half-written data pages
151127 17:53:24 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1712253
151127 17:53:25 [Note] InnoDB: 128 rollback segment(s) are active.
151127 17:53:25 [Note] InnoDB: Waiting for purge to start
151127 17:53:25 [Note] InnoDB: Percona XtraDB (Percona – The Database Performance Experts) 5.6.22-72.0 started; log sequence number 1712253
151127 17:53:25 [Note] Plugin 'FEEDBACK' is disabled.
151127 17:53:25 [Note] Server socket created on IP: '::'.
 

dota-sdso

Well-Known Member
Joined
Apr 30, 2014
Messages
590
Reaction score
821
Google Says:

1.exit Xampp server
2.go to your C:\xampp\mysql\data directory
3.delete the ibdata1 file
4.restart xampp server
It should work
 

GTI

Well-Known Member
Joined
Jan 1, 2011
Messages
1,364
Reaction score
422
Не тръгна.
2015-11-29 21:43:48 19cc 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.
151129 21:43:48 [Note] InnoDB: Using mutexes to ref count buffer pool pages
151129 21:43:48 [Note] InnoDB: The InnoDB memory heap is disabled
151129 21:43:48 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
151129 21:43:48 [Note] InnoDB: Memory barrier is not used
151129 21:43:48 [Note] InnoDB: Compressed tables use zlib 1.2.3
151129 21:43:48 [Note] InnoDB: Not using CPU crc32 instructions
151129 21:43:48 [Note] InnoDB: Initializing buffer pool, size = 32.0M
151129 21:43:48 [Note] InnoDB: Completed initialization of buffer pool
151129 21:43:48 [Note] InnoDB: Restoring page 0 of tablespace 0
151129 21:43:48 [Warning] InnoDB: Doublewrite does not have page_no=0 of space: 0
151129 21:43:48 [ERROR] InnoDB: space header page consists of zero bytes in data file E:\Programs\xampp\mysql\data\ibdata1
151129 21:43:48 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
151129 21:43:48 [ERROR] Plugin 'InnoDB' init function returned error.
151129 21:43:48 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
151129 21:43:48 [Note] Plugin 'FEEDBACK' is disabled.
151129 21:43:48 [ERROR] Unknown/unsupported storage engine: InnoDB
151129 21:43:48 [ERROR] Aborting

151129 21:43:48 [Note] e:\programs\xampp\mysql\bin\mysqld.exe: Shutdown complete
 

dota-sdso

Well-Known Member
Joined
Apr 30, 2014
Messages
590
Reaction score
821
Ако наистина си с ксамп направо си го изтегли отново и си импортни само датата, ако не си го направил още. Няма смисъл да си губиш времето да търсиш какво гърми според мен, друг е въпроса ако искаш точно този ксамп да тръгне.
 

GTI

Well-Known Member
Joined
Jan 1, 2011
Messages
1,364
Reaction score
422
Това и направих,но забравих да пиша в темата :(