Error:MySQL shutdown unexpectedly.

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Error:MySQL shutdown unexpectedly.

Postby Eren07 » 08. July 2014 14:31

Well guys, I'm using xampp for mysql. I'm installed it and started mysql. After I'm closed xampp and re-open it and when I'm tried to start mysql I see that:

16:30:26 [mysql] Error: MySQL shutdown unexpectedly.
16:30:26 [mysql] This may be due to a blocked port, missing dependencies,
16:30:26 [mysql] improper privileges, a crash, or a shutdown by another method.
16:30:26 [mysql] Press the Logs button to view error logs and check
16:30:26 [mysql] the Windows Event Viewer for more clues
16:30:26 [mysql] If you need more help, copy and post this
16:30:26 [mysql] entire log window on the forums

Help me please
Eren07
 
Posts: 8
Joined: 03. July 2014 22:34
Operating System: Windows XP

Re: Error:MySQL shutdown unexpectedly.

Postby Altrea » 08. July 2014 14:41

Eren07 wrote:16:30:26 [mysql] Press the Logs button to view error logs and check
16:30:26 [mysql] the Windows Event Viewer for more clues
16:30:26 [mysql] If you need more help, copy and post this
16:30:26 [mysql] entire log window on the forums


:!: :!: :!:
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: Error:MySQL shutdown unexpectedly.

Postby Eren07 » 08. July 2014 16:39

140708 18:40:56 [Note] Plugin 'FEDERATED' is disabled.
c:\xampp\mysql\bin\mysqld.exe: Table 'mysql.plugin' doesn't exist
140708 18:40:56 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140708 18:40:56 InnoDB: The InnoDB memory heap is disabled
140708 18:40:56 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140708 18:40:56 InnoDB: Compressed tables use zlib 1.2.3
140708 18:40:56 InnoDB: Initializing buffer pool, size = 16.0M
140708 18:40:56 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file C:\xampp\mysql\data\ibdata1
140708 18:40:56 InnoDB: Could not open or create data files.
140708 18:40:56 InnoDB: If you tried to add new data files, and it failed here,
140708 18:40:56 InnoDB: you should now edit innodb_data_file_path in my.cnf back
140708 18:40:56 InnoDB: to what it was, and remove the new ibdata files InnoDB created
140708 18:40:56 InnoDB: in this failed attempt. InnoDB only wrote those files full of
140708 18:40:56 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
140708 18:40:56 InnoDB: remove old data files which contain your precious data!
140708 18:40:56 [ERROR] Plugin 'InnoDB' init function returned error.
140708 18:40:56 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140708 18:40:56 [ERROR] Unknown/unsupported storage engine: InnoDB
140708 18:40:56 [ERROR] Aborting

140708 18:40:56 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

140708 18:41:03 [Note] Plugin 'FEDERATED' is disabled.
c:\xampp\mysql\bin\mysqld.exe: Table 'mysql.plugin' doesn't exist
140708 18:41:03 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140708 18:41:03 InnoDB: The InnoDB memory heap is disabled
140708 18:41:03 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140708 18:41:03 InnoDB: Compressed tables use zlib 1.2.3
140708 18:41:03 InnoDB: Initializing buffer pool, size = 16.0M
140708 18:41:03 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file C:\xampp\mysql\data\ibdata1
140708 18:41:03 InnoDB: Could not open or create data files.
140708 18:41:03 InnoDB: If you tried to add new data files, and it failed here,
140708 18:41:03 InnoDB: you should now edit innodb_data_file_path in my.cnf back
140708 18:41:03 InnoDB: to what it was, and remove the new ibdata files InnoDB created
140708 18:41:03 InnoDB: in this failed attempt. InnoDB only wrote those files full of
140708 18:41:03 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
140708 18:41:03 InnoDB: remove old data files which contain your precious data!
140708 18:41:03 [ERROR] Plugin 'InnoDB' init function returned error.
140708 18:41:03 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140708 18:41:03 [ERROR] Unknown/unsupported storage engine: InnoDB
140708 18:41:03 [ERROR] Aborting

140708 18:41:03 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

140708 18:41:08 [Note] Plugin 'FEDERATED' is disabled.
c:\xampp\mysql\bin\mysqld.exe: Table 'mysql.plugin' doesn't exist
140708 18:41:08 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140708 18:41:08 InnoDB: The InnoDB memory heap is disabled
140708 18:41:08 InnoDB: Mutexes and rw_locks use Windows interlocked functions
140708 18:41:08 InnoDB: Compressed tables use zlib 1.2.3
140708 18:41:08 InnoDB: Initializing buffer pool, size = 16.0M
140708 18:41:08 InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file C:\xampp\mysql\data\ibdata1
140708 18:41:08 InnoDB: Could not open or create data files.
140708 18:41:08 InnoDB: If you tried to add new data files, and it failed here,
140708 18:41:08 InnoDB: you should now edit innodb_data_file_path in my.cnf back
140708 18:41:08 InnoDB: to what it was, and remove the new ibdata files InnoDB created
140708 18:41:08 InnoDB: in this failed attempt. InnoDB only wrote those files full of
140708 18:41:08 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
140708 18:41:08 InnoDB: remove old data files which contain your precious data!
140708 18:41:08 [ERROR] Plugin 'InnoDB' init function returned error.
140708 18:41:08 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140708 18:41:08 [ERROR] Unknown/unsupported storage engine: InnoDB
140708 18:41:08 [ERROR] Aborting

140708 18:41:08 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete
Eren07
 
Posts: 8
Joined: 03. July 2014 22:34
Operating System: Windows XP

Re: Error:MySQL shutdown unexpectedly.

Postby Altrea » 08. July 2014 19:49

We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: Error:MySQL shutdown unexpectedly.

Postby Eren07 » 08. July 2014 19:51

What should I do there?
Eren07
 
Posts: 8
Joined: 03. July 2014 22:34
Operating System: Windows XP

Re: Error:MySQL shutdown unexpectedly.

Postby Altrea » 08. July 2014 19:52

read it carefully?!
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: Error:MySQL shutdown unexpectedly.

Postby Eren07 » 08. July 2014 19:55

I can't find my answer there, can you explain it here please?
Eren07
 
Posts: 8
Joined: 03. July 2014 22:34
Operating System: Windows XP

Re: Error:MySQL shutdown unexpectedly.

Postby Altrea » 08. July 2014 19:56

If you don't find the answer there, i am unable to explain it to you, sorry.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: Error:MySQL shutdown unexpectedly.

Postby Eren07 » 08. July 2014 20:03

:(
Eren07
 
Posts: 8
Joined: 03. July 2014 22:34
Operating System: Windows XP

Re: Error:MySQL shutdown unexpectedly.

Postby Altrea » 08. July 2014 20:05

I have written this Bug reports which took some of time.
All information are in it including two possible workaround explained step by step.
If that is not easy enough for you to follow, nobody can help you here.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 140 guests