InnoDB: Error: space header page consists of zero bytes in data file C:\Program Files\xampp\mysql\data\ibdata1

InnoDB: Error: space header page consists of zero bytes in data file C:\Program Files\xampp\mysql\data\ibdata1
140615 18:58:34 InnoDB: Could not open or create data files.
140615 18:58:34 InnoDB: If you tried to add new data files, and it failed here,
140615 18:58:34 InnoDB: you should now edit innodb_data_file_path in my.cnf back
140615 18:58:34 InnoDB: to what it was, and remove the new ibdata files InnoDB created
140615 18:58:34 InnoDB: in this failed attempt. InnoDB only wrote those files full of
140615 18:58:34 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
140615 18:58:34 InnoDB: remove old data files which contain your precious data!
140615 18:58:34 [ERROR] Plugin 'InnoDB' init function returned error.
140615 18:58:34 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140615 18:58:34 [ERROR] Unknown/unsupported storage engine: InnoDB
140615 18:58:34 [ERROR] Aborting



Solution:
This issue can be fixed by following any one of the methods

I. Adding setting innodb_flush_method=normal to my.ini
   Open \xampp\mysql\bin\my.ini
   Find this line  [mysqld] 

   At the end of the innodb_parameters add the following:
 

innodb_flush_method=normal
II. Remove innodb data files

   Goto \xampp\mysql\data
   Rename ib_logfile0, ib_logfile1, ibdata to another name, let mysql create new
   one.

III. Change default storage engine to MyIsam by disabling InnoDb

   Open \xampp\mysql\bin\my.ini
   Find this line  [mysqld] 
   After that line add the following:
 
   default-storage-engine=MyISAM
 

 Search this line:

  #skip-innodb
 

 Modify that line like this:

  skip-innodb
 

  Save this file and restart mysql.



Origen: http://webdevelopmentscripts.com/23-solved-innodb-error-space-header-page-consists-of-zero-bytes-xampp

Si el contenido le ha sido de utilidad, lo invitamos a hacer una donación en el siguiente botón. La cantidad que sea de su voluntad entregar En caso que no se visualice el contenido, hacer recargar (refresh) a la página que sea abierta.