继win7环境下mysql5卸载后服务安装不上又出现mysql server无法启动的问题:D:\PHP\MySQL Server 5.6\bin>net start mysql
MySQL 服务正在启动 .
MySQL 服务无法启动。系统出错。发生系统错误 1067。进程意外终止。mysql错误日志:2013-07-29 10:58:03 a10 InnoDB: File name D:\PHP\MySQL Server 5.5\ibdata1
2013-07-29 10:58:03 a10 InnoDB: File operation call: 'create' returned OS error 103.
2013-07-29 10:58:03 a10 InnoDB: Cannot continue operation.
2013-07-29 11:20:48 1776 [Note] Plugin 'FEDERATED' is disabled.
2013-07-29 11:20:48 804 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-07-29 11:20:48 1776 [Note] InnoDB: The InnoDB memory heap is disabled
2013-07-29 11:20:48 1776 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-07-29 11:20:48 1776 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-07-29 11:20:48 1776 [Note] InnoDB: Not using CPU crc32 instructions
2013-07-29 11:20:48 1776 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2013-07-29 11:20:48 1776 [Note] InnoDB: Completed initialization of buffer pool
2013-07-29 11:20:48 804 InnoDB: Operating system error number 3 in a file operation.
InnoDB: The error means the system cannot find the path specified.
InnoDB: If you are installing InnoDB, remember that you must create
InnoDB: directories yourself, InnoDB does not create them.
2013-07-29 11:20:48 804 InnoDB: File name D:\PHP\MySQL Server 5.5\ibdata1
2013-07-29 11:20:48 804 InnoDB: File operation call: 'create' returned OS error 103.
2013-07-29 11:20:48 804 InnoDB: Cannot continue operation.
但是,我的MySQL安装目录中没有ibdata1目录或文件……针对以上错误报告,都有哪些原因造成?如何解决?MySQL服务器Windows
MySQL 服务正在启动 .
MySQL 服务无法启动。系统出错。发生系统错误 1067。进程意外终止。mysql错误日志:2013-07-29 10:58:03 a10 InnoDB: File name D:\PHP\MySQL Server 5.5\ibdata1
2013-07-29 10:58:03 a10 InnoDB: File operation call: 'create' returned OS error 103.
2013-07-29 10:58:03 a10 InnoDB: Cannot continue operation.
2013-07-29 11:20:48 1776 [Note] Plugin 'FEDERATED' is disabled.
2013-07-29 11:20:48 804 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-07-29 11:20:48 1776 [Note] InnoDB: The InnoDB memory heap is disabled
2013-07-29 11:20:48 1776 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-07-29 11:20:48 1776 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-07-29 11:20:48 1776 [Note] InnoDB: Not using CPU crc32 instructions
2013-07-29 11:20:48 1776 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2013-07-29 11:20:48 1776 [Note] InnoDB: Completed initialization of buffer pool
2013-07-29 11:20:48 804 InnoDB: Operating system error number 3 in a file operation.
InnoDB: The error means the system cannot find the path specified.
InnoDB: If you are installing InnoDB, remember that you must create
InnoDB: directories yourself, InnoDB does not create them.
2013-07-29 11:20:48 804 InnoDB: File name D:\PHP\MySQL Server 5.5\ibdata1
2013-07-29 11:20:48 804 InnoDB: File operation call: 'create' returned OS error 103.
2013-07-29 11:20:48 804 InnoDB: Cannot continue operation.
但是,我的MySQL安装目录中没有ibdata1目录或文件……针对以上错误报告,都有哪些原因造成?如何解决?MySQL服务器Windows
但是现在mysql server启动后,没有mysql表:D:\PHP\MySQL Server 5.6\bin>mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.12 MySQL Community Server (GPL)Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trade of Oracle Corporation and/or its
affiliates. Other names may be trades of their respective
owners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| test |
+--------------------+
2 rows in set (0.08 sec)如何加载数据表?