导入sql文件，mysql5.6无法启动-经典问答-看雪-安全社区|安全招聘|kanxue.com

导入sql文件，mysql5.6无法启动

发表于: 2013-10-9 23:12 10409

导入sql文件，mysql5.6无法启动

eremiter

2013-10-9 23:12

10409

OS：win2012R2 datacenter+Mysql5.6
在phpmyadmin4删除数据表，导入sql文件，发现导入有问题，干脆删除整个数据库，删除不了，就停止mysql，再启动，就发现如下图，拒绝访问，清空注册表，重装安装，也一样，还是无法启动，真是活见鬼了。
我的帐户是administrator,而且安装的mysql是在D盘，世界顶级公司的数据库难道就怎么脆弱
错误的日志发下

2013-10-09 16:50:10 2952 [Note] Plugin 'FEDERATED' is disabled.
2013-10-09 16:50:10 2952 [Warning] option 'innodb-autoextend-increment': unsigned value 67108864 adjusted to 1000
2013-10-09 16:50:10 ec0 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.
2013-10-09 16:50:10 2952 [Note] InnoDB: The InnoDB memory heap is disabled
2013-10-09 16:50:10 2952 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-10-09 16:50:10 2952 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-10-09 16:50:10 2952 [Note] InnoDB: Not using CPU crc32 instructions
2013-10-09 16:50:10 2952 [Note] InnoDB: Initializing buffer pool, size = 141.0M
2013-10-09 16:50:10 2952 [Note] InnoDB: Completed initialization of buffer pool
2013-10-09 16:50:11 2952 [Note] InnoDB: Highest supported file format is Barracuda.
2013-10-09 16:50:11 2952 [Note] InnoDB: 128 rollback segment(s) are active.
2013-10-09 16:50:11 2952 [Note] InnoDB: Waiting for purge to start
2013-10-09 16:50:11 2952 [Note] InnoDB: 5.6.14 started; log sequence number 1625977
2013-10-09 16:50:11 2952 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: cea61e03-30bf-11e3-941d-005056c00001.
2013-10-09 16:50:11 2952 [Note] Server hostname (bind-address): '*'; port: 3306
2013-10-09 16:50:11 2952 [Note] IPv6 is available.
2013-10-09 16:50:11 2952 [Note]   - '::' resolves to '::';
2013-10-09 16:50:11 2952 [Note] Server socket created on IP: '::'.
2013-10-09 16:50:12 2952 [Note] mysqld: ready for connections.
Version: '5.6.14'  socket: ''  port: 3306  MySQL Community Server (GPL)
2013-10-09 20:30:50 3120 [Note] Plugin 'FEDERATED' is disabled.
2013-10-09 20:30:50 3120 [Warning] option 'innodb-autoextend-increment': unsigned value 67108864 adjusted to 1000
2013-10-09 20:30:51 bdc 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.
2013-10-09 20:30:51 3120 [Note] InnoDB: The InnoDB memory heap is disabled
2013-10-09 20:30:51 3120 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-10-09 20:30:51 3120 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-10-09 20:30:51 3120 [Note] InnoDB: Not using CPU crc32 instructions
2013-10-09 20:30:51 3120 [Note] InnoDB: Initializing buffer pool, size = 141.0M
2013-10-09 20:30:51 3120 [Note] InnoDB: Completed initialization of buffer pool
2013-10-09 20:30:51 3120 [Note] InnoDB: Highest supported file format is Barracuda.
2013-10-09 20:30:51 3120 [Note] InnoDB: The log sequence numbers 1625977 and 1625977 in ibdata files do not match the log sequence number 1625987 in the ib_logfiles!
2013-10-09 20:30:51 3120 [Note] InnoDB: Database was not shutdown normally!
2013-10-09 20:30:51 3120 [Note] InnoDB: Starting crash recovery.
2013-10-09 20:30:51 3120 [Note] InnoDB: Reading tablespace information from the .ibd files...
2013-10-09 20:30:51 3120 [Note] InnoDB: Restoring possible half-written data pages 
2013-10-09 20:30:51 3120 [Note] InnoDB: from the doublewrite buffer...
2013-10-09 20:30:51 3120 [Note] InnoDB: 128 rollback segment(s) are active.
2013-10-09 20:30:51 3120 [Note] InnoDB: Waiting for purge to start
2013-10-09 20:30:51 3120 [Note] InnoDB: 5.6.14 started; log sequence number 1625987
2013-10-09 20:30:51 3120 [Note] Server hostname (bind-address): '*'; port: 3306
2013-10-09 20:30:51 3120 [Note] IPv6 is available.
2013-10-09 20:30:51 3120 [Note]   - '::' resolves to '::';
2013-10-09 20:30:51 3120 [Note] Server socket created on IP: '::'.
2013-10-09 20:30:52 3120 [Note] Event Scheduler: Loaded 0 events
2013-10-09 20:30:52 3120 [Note] D:/Program Files/MySQL/MySQL Server 5.6/bin\mysqld: ready for connections.
Version: '5.6.14'  socket: ''  port: 3306  MySQL Community Server (GPL)
2013-10-09 20:31:26 3120 [Note] D:/Program Files/MySQL/MySQL Server 5.6/bin\mysqld: Normal shutdown

2013-10-09 20:31:26 3120 [Note] Giving 0 client threads a chance to die gracefully
2013-10-09 20:31:26 3120 [Note] Event Scheduler: Purging the queue. 0 events
2013-10-09 20:31:26 3120 [Note] Shutting down slave threads
2013-10-09 20:31:26 3120 [Note] Forcefully disconnecting 0 remaining clients
2013-10-09 20:31:26 3120 [Note] Binlog end
2013-10-09 20:31:26 3120 [Note] Shutting down plugin 'partition'
2013-10-09 20:31:26 3120 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2013-10-09 20:31:26 3120 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2013-10-09 20:31:26 3120 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2013-10-09 20:31:26 3120 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2013-10-09 20:31:26 3120 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2013-10-09 20:31:26 3120 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2013-10-09 20:31:26 3120 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2013-10-09 20:31:26 3120 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2013-10-09 20:31:26 3120 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2013-10-09 20:31:26 3120 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2013-10-09 20:31:26 3120 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2013-10-09 20:31:26 3120 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2013-10-09 20:31:26 3120 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2013-10-09 20:31:26 3120 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2013-10-09 20:31:26 3120 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2013-10-09 20:31:26 3120 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2013-10-09 20:31:26 3120 [Note] Shutting down plugin 'INNODB_METRICS'
2013-10-09 20:31:26 3120 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2013-10-09 20:31:26 3120 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2013-10-09 20:31:26 3120 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2013-10-09 20:31:26 3120 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2013-10-09 20:31:26 3120 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2013-10-09 20:31:26 3120 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2013-10-09 20:31:26 3120 [Note] Shutting down plugin 'INNODB_CMPMEM'
2013-10-09 20:31:26 3120 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2013-10-09 20:31:26 3120 [Note] Shutting down plugin 'INNODB_CMP'
2013-10-09 20:31:26 3120 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2013-10-09 20:31:26 3120 [Note] Shutting down plugin 'INNODB_LOCKS'
2013-10-09 20:31:26 3120 [Note] Shutting down plugin 'INNODB_TRX'
2013-10-09 20:31:26 3120 [Note] Shutting down plugin 'InnoDB'
2013-10-09 20:31:26 3120 [Note] InnoDB: FTS optimize thread exiting.
2013-10-09 20:31:26 3120 [Note] InnoDB: Starting shutdown...
2013-10-09 20:31:28 3120 [Note] InnoDB: Shutdown completed; log sequence number 1625997
2013-10-09 20:31:28 3120 [Note] Shutting down plugin 'BLACKHOLE'
2013-10-09 20:31:28 3120 [Note] Shutting down plugin 'ARCHIVE'
2013-10-09 20:31:28 3120 [Note] Shutting down plugin 'MRG_MYISAM'
2013-10-09 20:31:28 3120 [Note] Shutting down plugin 'MyISAM'
2013-10-09 20:31:28 3120 [Note] Shutting down plugin 'MEMORY'
2013-10-09 20:31:28 3120 [Note] Shutting down plugin 'CSV'
2013-10-09 20:31:28 3120 [Note] Shutting down plugin 'sha256_password'
2013-10-09 20:31:28 3120 [Note] Shutting down plugin 'mysql_old_password'
2013-10-09 20:31:28 3120 [Note] Shutting down plugin 'mysql_native_password'
2013-10-09 20:31:28 3120 [Note] Shutting down plugin 'binlog'
2013-10-09 20:31:28 3120 [Note] D:/Program Files/MySQL/MySQL Server 5.6/bin\mysqld: Shutdown complete

2013-10-09 20:32:00 2280 [Note] Plugin 'FEDERATED' is disabled.
2013-10-09 20:32:00 2280 [Warning] option 'innodb-autoextend-increment': unsigned value 67108864 adjusted to 1000
2013-10-09 20:32:00 934 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.
2013-10-09 20:32:00 2280 [Note] InnoDB: The InnoDB memory heap is disabled
2013-10-09 20:32:00 2280 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-10-09 20:32:00 2280 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-10-09 20:32:00 2280 [Note] InnoDB: Not using CPU crc32 instructions
2013-10-09 20:32:00 2280 [Note] InnoDB: Initializing buffer pool, size = 141.0M
2013-10-09 20:32:00 2280 [Note] InnoDB: Completed initialization of buffer pool
2013-10-09 20:32:00 2280 [Note] InnoDB: Highest supported file format is Barracuda.
2013-10-09 20:32:00 2280 [Note] InnoDB: 128 rollback segment(s) are active.
2013-10-09 20:32:00 2280 [Note] InnoDB: Waiting for purge to start
2013-10-09 20:32:00 2280 [Note] InnoDB: 5.6.14 started; log sequence number 1625997
2013-10-09 20:32:00 2280 [Note] Server hostname (bind-address): '*'; port: 3306
2013-10-09 20:32:00 2280 [Note] IPv6 is available.
2013-10-09 20:32:00 2280 [Note]   - '::' resolves to '::';
2013-10-09 20:32:00 2280 [Note] Server socket created on IP: '::'.
2013-10-09 20:32:00 2280 [Note] Event Scheduler: Loaded 0 events
2013-10-09 20:32:00 2280 [Note] D:/Program Files/MySQL/MySQL Server 5.6/bin\mysqld: ready for connections.
Version: '5.6.14'  socket: ''  port: 3306  MySQL Community Server (GPL)
2013-10-09 20:35:42 2280 [Note] D:/Program Files/MySQL/MySQL Server 5.6/bin\mysqld: Normal shutdown

2013-10-09 20:35:42 2280 [Note] Giving 0 client threads a chance to die gracefully
2013-10-09 20:35:42 2280 [Note] Event Scheduler: Purging the queue. 0 events
2013-10-09 20:35:42 2280 [Note] Shutting down slave threads
2013-10-09 20:35:42 2280 [Note] Forcefully disconnecting 0 remaining clients
2013-10-09 20:35:42 2280 [Note] Binlog end
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'partition'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'INNODB_METRICS'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'INNODB_CMPMEM'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'INNODB_CMP'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'INNODB_LOCKS'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'INNODB_TRX'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'InnoDB'
2013-10-09 20:35:43 2280 [Note] InnoDB: FTS optimize thread exiting.
2013-10-09 20:35:43 2280 [Note] InnoDB: Starting shutdown...
2013-10-09 20:35:43 2280 [Note] InnoDB: Shutdown completed; log sequence number 1626007
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'BLACKHOLE'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'ARCHIVE'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'MRG_MYISAM'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'MyISAM'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'MEMORY'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'CSV'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'sha256_password'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'mysql_old_password'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'mysql_native_password'
2013-10-09 20:35:43 2280 [Note] Shutting down plugin 'binlog'
2013-10-09 20:35:43 2280 [Note] D:/Program Files/MySQL/MySQL Server 5.6/bin\mysqld: Shutdown complete

2013-10-09 20:35:46 4948 [Note] Plugin 'FEDERATED' is disabled.
2013-10-09 20:35:46 4948 [Warning] option 'innodb-autoextend-increment': unsigned value 67108864 adjusted to 1000
2013-10-09 20:35:46 1334 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.
2013-10-09 20:35:46 4948 [Note] InnoDB: The InnoDB memory heap is disabled
2013-10-09 20:35:46 4948 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-10-09 20:35:46 4948 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-10-09 20:35:46 4948 [Note] InnoDB: Not using CPU crc32 instructions
2013-10-09 20:35:46 4948 [Note] InnoDB: Initializing buffer pool, size = 141.0M
2013-10-09 20:35:46 4948 [Note] InnoDB: Completed initialization of buffer pool
2013-10-09 20:35:46 4948 [Note] InnoDB: Highest supported file format is Barracuda.
2013-10-09 20:35:46 4948 [Note] InnoDB: 128 rollback segment(s) are active.
2013-10-09 20:35:46 4948 [Note] InnoDB: Waiting for purge to start
2013-10-09 20:35:46 4948 [Note] InnoDB: 5.6.14 started; log sequence number 1626007
2013-10-09 20:35:46 4948 [Note] Server hostname (bind-address): '*'; port: 3306
2013-10-09 20:35:46 4948 [Note] IPv6 is available.
2013-10-09 20:35:46 4948 [Note]   - '::' resolves to '::';
2013-10-09 20:35:46 4948 [Note] Server socket created on IP: '::'.
2013-10-09 20:35:46 4948 [Note] Event Scheduler: Loaded 0 events
2013-10-09 20:35:46 4948 [Note] D:/Program Files/MySQL/MySQL Server 5.6/bin\mysqld: ready for connections.
Version: '5.6.14'  socket: ''  port: 3306  MySQL Community Server (GPL)
2013-10-09 20:44:27 4948 [Warning] InnoDB: Cannot open table testexa/t_user from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.

2013-10-09 22:48:51 4948 [ERROR] InnoDB: The file '.\testexa\tmp_update_common_cde.ibd' already exists though the corresponding table did not exist in the InnoDB data dictionary. Have you moved InnoDB .ibd files around without using the SQL commands DISCARD TABLESPACE and IMPORT TABLESPACE, or did mysqld crash in the middle of CREATE TABLE? You can resolve the problem by removing the file '.\testexa\tmp_update_common_cde.ibd' under the 'datadir' of MySQL.
2013-10-09 22:49:34 4948 [Note] D:/Program Files/MySQL/MySQL Server 5.6/bin\mysqld: Normal shutdown

2013-10-09 22:49:34 4948 [Note] Giving 0 client threads a chance to die gracefully
2013-10-09 22:49:34 4948 [Note] Event Scheduler: Purging the queue. 0 events
2013-10-09 22:49:34 4948 [Note] Shutting down slave threads
2013-10-09 22:49:34 4948 [Note] Forcefully disconnecting 0 remaining clients
2013-10-09 22:49:34 4948 [Note] Binlog end
2013-10-09 22:49:34 4948 [Note] Shutting down plugin 'partition'
2013-10-09 22:49:34 4948 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2013-10-09 22:49:34 4948 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2013-10-09 22:49:34 4948 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2013-10-09 22:49:34 4948 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2013-10-09 22:49:34 4948 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2013-10-09 22:49:34 4948 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2013-10-09 22:49:34 4948 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2013-10-09 22:49:34 4948 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2013-10-09 22:49:34 4948 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2013-10-09 22:49:34 4948 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2013-10-09 22:49:34 4948 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2013-10-09 22:49:34 4948 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2013-10-09 22:49:34 4948 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2013-10-09 22:49:34 4948 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2013-10-09 22:49:34 4948 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2013-10-09 22:49:34 4948 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2013-10-09 22:49:34 4948 [Note] Shutting down plugin 'INNODB_METRICS'
2013-10-09 22:49:34 4948 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2013-10-09 22:49:34 4948 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2013-10-09 22:49:34 4948 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2013-10-09 22:49:34 4948 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2013-10-09 22:49:34 4948 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2013-10-09 22:49:34 4948 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2013-10-09 22:49:34 4948 [Note] Shutting down plugin 'INNODB_CMPMEM'
2013-10-09 22:49:34 4948 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2013-10-09 22:49:34 4948 [Note] Shutting down plugin 'INNODB_CMP'
2013-10-09 22:49:34 4948 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2013-10-09 22:49:34 4948 [Note] Shutting down plugin 'INNODB_LOCKS'
2013-10-09 22:49:34 4948 [Note] Shutting down plugin 'INNODB_TRX'
2013-10-09 22:49:34 4948 [Note] Shutting down plugin 'InnoDB'
2013-10-09 22:49:34 4948 [Note] InnoDB: FTS optimize thread exiting.
2013-10-09 22:49:34 4948 [Note] InnoDB: Starting shutdown...
2013-10-09 22:49:35 4948 [Note] InnoDB: Shutdown completed; log sequence number 1627537
2013-10-09 22:49:35 4948 [Note] Shutting down plugin 'BLACKHOLE'
2013-10-09 22:49:35 4948 [Note] Shutting down plugin 'ARCHIVE'
2013-10-09 22:49:35 4948 [Note] Shutting down plugin 'MRG_MYISAM'
2013-10-09 22:49:35 4948 [Note] Shutting down plugin 'MyISAM'
2013-10-09 22:49:35 4948 [Note] Shutting down plugin 'MEMORY'
2013-10-09 22:49:35 4948 [Note] Shutting down plugin 'CSV'
2013-10-09 22:49:35 4948 [Note] Shutting down plugin 'sha256_password'
2013-10-09 22:49:35 4948 [Note] Shutting down plugin 'mysql_old_password'
2013-10-09 22:49:35 4948 [Note] Shutting down plugin 'mysql_native_password'
2013-10-09 22:49:35 4948 [Note] Shutting down plugin 'binlog'
2013-10-09 22:49:35 4948 [Note] D:/Program Files/MySQL/MySQL Server 5.6/bin\mysqld: Shutdown complete

[注意]传递专业知识、拓宽行业人脉——看雪讲师团队等你加入！

上传的附件：

mysql_services.jpg （74.06kb，1次下载）

收藏・0

免费・0

支持

最新回复 (5)
夏目雪币： 36 活跃值： (10) 能力值： ( LV2，RANK：10 ) 在线值：发帖 1 回帖 9 粉丝 0 关注私信	夏目 2 楼查看下日志信息的话，看看关键的地方，提示，警告什么可以忽略，主要看错误信息，就是error，你crtl+f找到 2013-10-09 22:48:51 4948 [ERROR] InnoDB: The file '.\testexa\tmp_update_common_cde.ibd' already exists though the corresponding table did not exist in the InnoDB data dictionary. 大致意思就是说这个文件'.\testexa\tmp_update_common_cde.ibd'示已经存在的，但是关联表在数据字典中没有，这里有一个冲突。然后下面它给出出现这种现象的猜测： Have you moved InnoDB .ibd files around without using the SQL commands DISCARD TABLESPACE and IMPORT TABLESPACE, or did mysqld crash in the middle of CREATE TABLE? You can resolve the problem by removing the file '.\testexa\tmp_update_common_cde.ibd' under the 'datadir' of MySQL. 你是不是没有用sql命令删除 InnoDB 文件（以 .ibd后缀的），sql命令是：DISCARD TABLESPACE and IMPORT TABLESPACE。最后给出解决这个问题的方法：（重点来了）用 mysql的'datadir'命令来删除'.\testexa\tmp_update_common_cde.ibd' 文件. 如果不清楚datadir，可以看看这个链接:http://blog.csdn.net/dengqiaodey/article/details/7878886 好了，解说完毕，第一次回答，吼吼~希望能够帮到你哈~ 2013-10-10 12:01 0
eremiter 雪币： 2 活跃值： (72) 能力值： ( LV2，RANK：10 ) 在线值：发帖 29 回帖 64 粉丝 0 关注私信	eremiter 3 楼肯定不是这错误，我已经把那个数据库删除了，也把err日志清空，还是启动不了Mysql，现在启动不了，日志也没内容 2013-10-10 15:54 0
南乡子雪币： 199 活跃值： (10) 能力值： ( LV2，RANK：10 ) 在线值：发帖 3 回帖 15 粉丝 0 关注私信	南乡子 4 楼最好的办法，安装Mysql5.5 短小精悍，又没问题，占用内存又小，才100M,mysql5.6已经完全变了，绝对很娇嫩 2013-10-10 17:31 0
夏目雪币： 36 活跃值： (10) 能力值： ( LV2，RANK：10 ) 在线值：发帖 1 回帖 9 粉丝 0 关注私信	夏目 5 楼你当时的日志信息就是这么显示的，既然现在没错误了，那你重新安装好了。有错误的话就把报错贴出来...要把问题描述清楚... 2013-10-10 17:34 0
eremiter 雪币： 2 活跃值： (72) 能力值： ( LV2，RANK：10 ) 在线值：发帖 29 回帖 64 粉丝 0 关注私信	eremiter 6 楼 [QUOTE=南乡子;1229566]最好的办法，安装Mysql5.5 短小精悍，又没问题，占用内存又小，才100M,mysql5.6已经完全变了，绝对很娇嫩[/QUOTE] 还是这个好，5.6是王公贵族，平民百姓用不起，太折腾人了，我去网上搜索一堆方法，没一个可以解决，下载5.5花几分钟就解决了谢谢楼上的夏大哥热心帮忙，但无法解决，不折腾了 2013-10-10 18:19 0
	游客登录 \| 注册方可回帖回帖表情雪币赚取及消费高级回复

eremiter

发帖

回帖

RANK

关注

私信

他的文章

关于我们

联系我们

企业服务

看雪公众号

最新回复 (5)
夏目雪币： 36 活跃值： (10) 能力值： ( LV2，RANK：10 ) 在线值：发帖 1 回帖 9 粉丝 0 关注私信	夏目 2 楼查看下日志信息的话，看看关键的地方，提示，警告什么可以忽略，主要看错误信息，就是error，你crtl+f找到 2013-10-09 22:48:51 4948 [ERROR] InnoDB: The file '.\testexa\tmp_update_common_cde.ibd' already exists though the corresponding table did not exist in the InnoDB data dictionary. 大致意思就是说这个文件'.\testexa\tmp_update_common_cde.ibd'示已经存在的，但是关联表在数据字典中没有，这里有一个冲突。然后下面它给出出现这种现象的猜测： Have you moved InnoDB .ibd files around without using the SQL commands DISCARD TABLESPACE and IMPORT TABLESPACE, or did mysqld crash in the middle of CREATE TABLE? You can resolve the problem by removing the file '.\testexa\tmp_update_common_cde.ibd' under the 'datadir' of MySQL. 你是不是没有用sql命令删除 InnoDB 文件（以 .ibd后缀的），sql命令是：DISCARD TABLESPACE and IMPORT TABLESPACE。最后给出解决这个问题的方法：（重点来了）用 mysql的'datadir'命令来删除'.\testexa\tmp_update_common_cde.ibd' 文件. 如果不清楚datadir，可以看看这个链接:http://blog.csdn.net/dengqiaodey/article/details/7878886 好了，解说完毕，第一次回答，吼吼~希望能够帮到你哈~ 2013-10-10 12:01 0
eremiter 雪币： 2 活跃值： (72) 能力值： ( LV2，RANK：10 ) 在线值：发帖 29 回帖 64 粉丝 0 关注私信	eremiter 3 楼肯定不是这错误，我已经把那个数据库删除了，也把err日志清空，还是启动不了Mysql，现在启动不了，日志也没内容 2013-10-10 15:54 0
南乡子雪币： 199 活跃值： (10) 能力值： ( LV2，RANK：10 ) 在线值：发帖 3 回帖 15 粉丝 0 关注私信	南乡子 4 楼最好的办法，安装Mysql5.5 短小精悍，又没问题，占用内存又小，才100M,mysql5.6已经完全变了，绝对很娇嫩 2013-10-10 17:31 0
夏目雪币： 36 活跃值： (10) 能力值： ( LV2，RANK：10 ) 在线值：发帖 1 回帖 9 粉丝 0 关注私信	夏目 5 楼你当时的日志信息就是这么显示的，既然现在没错误了，那你重新安装好了。有错误的话就把报错贴出来...要把问题描述清楚... 2013-10-10 17:34 0
eremiter 雪币： 2 活跃值： (72) 能力值： ( LV2，RANK：10 ) 在线值：发帖 29 回帖 64 粉丝 0 关注私信	eremiter 6 楼 [QUOTE=南乡子;1229566]最好的办法，安装Mysql5.5 短小精悍，又没问题，占用内存又小，才100M,mysql5.6已经完全变了，绝对很娇嫩[/QUOTE] 还是这个好，5.6是王公贵族，平民百姓用不起，太折腾人了，我去网上搜索一堆方法，没一个可以解决，下载5.5花几分钟就解决了谢谢楼上的夏大哥热心帮忙，但无法解决，不折腾了 2013-10-10 18:19 0
	游客登录 \| 注册方可回帖回帖表情雪币赚取及消费高级回复