SQL did'nt start on Windows 8 and 8.1

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

SQL did'nt start on Windows 8 and 8.1

Postby alyks » 15. November 2013 15:28

Hi everyone,

since i'm on Windows 8 then 8.1, i can't use Xampp, EasyPHP or Wamp... The same issue, SQL doesn't start anymore.... See the sql logs belong concerning Xampp :


Code: Select all
131115 15:04:27 [Note] c:\xampp2\mysql\bin\mysqld.exe: Shutdown complete

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

131115 15:04:31 [Note] c:\xampp2\mysql\bin\mysqld.exe: Shutdown complete

alyks
 
Posts: 3
Joined: 15. November 2013 15:14
Operating System: Windows 8

Re: SQL did'nt start on Windows 8 and 8.1

Postby alyks » 15. November 2013 19:26

This is the general log from Xampp :

Code: Select all
19:13:53  [main]    Initializing Control Panel
19:13:54  [main]    Windows Version: Windows 8  64-bit
19:13:54  [main]    XAMPP Version: 1.8.2
19:13:54  [main]    Control Panel Version: 3.2.1  [ Compiled: May 7th 2013 ]
19:13:54  [main]    You are not running with administrator rights! This will work for
19:13:54  [main]    most application stuff but whenever you do something with services
19:13:54  [main]    there will be a security dialogue or things will break! So think
19:13:54  [main]    about running this application with administrator rights!
19:13:54  [main]    XAMPP Installation Directory: "c:\xampp2\"
19:13:54  [main]    Checking for prerequisites
19:13:54  [main]    All prerequisites found
19:13:54  [main]    Initializing Modules
19:13:56  [main]    Enabling autostart for module "Apache"
19:13:56  [main]    Enabling autostart for module "MySQL"
19:13:56  [main]    Starting Check-Timer
19:13:56  [main]    Control Panel Ready
19:14:00  [Apache]    Autostart active: starting...
19:14:00  [Apache]    Attempting to start Apache app...
19:14:01  [mysql]    Autostart active: starting...
19:14:01  [mysql]    Attempting to start MySQL app...
19:14:38  [Apache]    Status change detected: running
19:14:41  [mysql]    Status change detected: running
19:14:44  [mysql]    Status change detected: stopped
19:14:44  [mysql]    Error: MySQL shutdown unexpectedly.
19:14:44  [mysql]    This may be due to a blocked port, missing dependencies,
19:14:44  [mysql]    improper privileges, a crash, or a shutdown by another method.
19:14:44  [mysql]    Press the Logs button to view error logs and check
19:14:44  [mysql]    the Windows Event Viewer for more clues
19:14:44  [mysql]    If you need more help, copy and post this
19:14:44  [mysql]    entire log window on the forums
19:15:18  [mysql]    Attempting to start MySQL app...
19:24:39  [mysql]    Attempting to start MySQL app...
19:24:39  [mysql]    Status change detected: running
19:24:41  [mysql]    Status change detected: stopped
19:24:41  [mysql]    Error: MySQL shutdown unexpectedly.
19:24:41  [mysql]    This may be due to a blocked port, missing dependencies,
19:24:41  [mysql]    improper privileges, a crash, or a shutdown by another method.
19:24:41  [mysql]    Press the Logs button to view error logs and check
19:24:41  [mysql]    the Windows Event Viewer for more clues
19:24:41  [mysql]    If you need more help, copy and post this
19:24:41  [mysql]    entire log window on the forums
19:26:34  [mysql]    Attempting to start MySQL app...
19:26:34  [mysql]    Status change detected: running
19:26:34  [mysql]    Status change detected: stopped
19:26:34  [mysql]    Error: MySQL shutdown unexpectedly.
19:26:34  [mysql]    This may be due to a blocked port, missing dependencies,
19:26:34  [mysql]    improper privileges, a crash, or a shutdown by another method.
19:26:34  [mysql]    Press the Logs button to view error logs and check
19:26:34  [mysql]    the Windows Event Viewer for more clues
19:26:34  [mysql]    If you need more help, copy and post this
19:26:34  [mysql]    entire log window on the forums
alyks
 
Posts: 3
Joined: 15. November 2013 15:14
Operating System: Windows 8

Re: SQL did'nt start on Windows 8 and 8.1

Postby Altrea » 15. November 2013 19:56

alyks wrote:InnoDB: Error: space header page consists of zero bytes in data file C:\xampp2\mysql\data\ibdata1
131115 15:04:31 InnoDB: Could not open or create data files.
131115 15:04:31 InnoDB: If you tried to add new data files, and it failed here,
131115 15:04:31 InnoDB: you should now edit innodb_data_file_path in my.cnf back
131115 15:04:31 InnoDB: to what it was, and remove the new ibdata files InnoDB created
131115 15:04:31 InnoDB: in this failed attempt. InnoDB only wrote those files full of
131115 15:04:31 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
131115 15:04:31 InnoDB: remove old data files which contain your precious data!


Everything important is written there.
Your ibdata1 file is corrupt or cannot be opend by the mysql process.
This could be an permission issue of windows 8. Never had this myself.
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: 8293
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: SQL did'nt start on Windows 8 and 8.1

Postby alyks » 15. November 2013 20:17

Ok thanks.
I've no idea how to fix permission on Windows 8. It seems not to be an option in this case...
alyks
 
Posts: 3
Joined: 15. November 2013 15:14
Operating System: Windows 8


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 66 guests