XAMPP中的MySQL意外关闭

Question

XAMPP的控制面板显示错误为

错误: MySQL意外关闭。 14:09:43 mysql这可能是由于端口阻塞、缺少依赖关系、不正确的权限、崩溃或其他方法关闭造成的。

mysql_error.log中的文本是

3812 [Note] Plugin 'FEDERATED' is disabled.
 1604 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.
[Note] InnoDB: Using atomics to ref count buffer pool pages
[Note] InnoDB: The InnoDB memory heap is disabled
 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
 [Note] InnoDB: Memory barrier is not used
 [Note] InnoDB: Compressed tables use zlib 1.2.3
 [Note] InnoDB: Not using CPU crc32 instructions
 [Note] InnoDB: Initializing buffer pool, size = 16.0M
 [Note] InnoDB: Completed initialization of buffer pool
 [Note] InnoDB: Restoring page 0 of tablespace 0
 [Warning] InnoDB: Doublewrite does not have page_no=0 of space: 0
 [ERROR] InnoDB: space header page consists of zero bytes in data file C:\xampp\mysql\data\ibdata1
 [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!
       [ERROR] Plugin 'InnoDB' init function returned error.
 2015-04-15 14:09:43 3812 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
  [ERROR] Unknown/unsupported storage engine: InnoDB
   [ERROR] Aborting

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

Answer 1

如果你想在不丢失数据的情况下修复这个问题，你需要从备份中恢复你的数据库，只要仔细遵循下面的步骤，它就能工作了!！

1. 将文件夹xampp/mysql/data重命名为xampp/mysql/data_backup
2. 创建一个新文件夹xampp/mysql/data
3. 将驻留在xampp/mysql/backup中的内容复制到新的xampp/mysql/data文件夹中
4. 将xampp/mysql/data_backup中的所有数据库文件夹复制到xampp/mysql/data

注意:不要将mysql、performance_schema，和phpmyadmin文件夹从xampp/mysql/data_bk复制。

5.从ibdata1复制xampp/mysql/data_backup文件，并在xampp/mysql/data文件夹中替换它

5.终于！再次从XAMPP控制面板启动MySQL

Answer 2

为了避免这个问题，您可以遵循以下步骤：

1. 首先，您应该在"xampp控制面板“中停止"Apache”和"MySQL“。
2. 转到路径：C:\xampp\mysql\backup复制这里所有的东西
3. 进入路径：C:\xampp\mysql\data并将其粘贴到这里
4. 在这里，您将看到一个弹出:替换或跳过文件 单击Replace the files in the destination
5. 现在，您可以启动"Apache“和"MySQL”，而不需要任何麻烦。

希望它能正常工作。