修改下面的ImagePath数值:
MYSQL-WIN下多实例及其启动
原创woxuewangluo 博主文章分类:MYSQL文档 ©著作权
©著作权归作者所有:来自51CTO博客作者woxuewangluo的原创作品,请联系作者获取转载授权,否则将追究法律责任
1、安装MySql5.5以root用户进入,查看存放数据及其配置文件的位置:
" C:\Program Files\MySQL\MySQLServer5.5-01\bin\mysqld" --defaults-file=" C:\Program Files\MySQL\MySQLServer5.5-01\my.ini" MySQL3307 ,退出注册表编辑器。
mysql> show variables like '%dir%';
+-----------------------------------------+-----------------------------------------------------------------------------------+
| Variable_name | Value |
+-----------------------------------------+-----------------------------------------------------------------------------------+
| basedir | C:/Program Files/MySQL/MySQL Server 5.5/ |
| binlog_direct_non_transactional_updates | OFF |
| character_sets_dir | C:\Program Files\MySQL\MySQL Server 5.5\share\charsets\ |
| datadir | C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.5\Data\ |
| innodb_data_home_dir | D:\ |
| innodb_log_group_home_dir | .\ |
| innodb_max_dirty_pages_pct | 75 |
| lc_messages_dir | C:\Program Files\MySQL\MySQL Server 5.5\share\ |
| plugin_dir | C:\Program Files\MySQL\MySQL Server 5.5\lib\plugin\ |
| slave_load_tmpdir | C:\WINDOWS\TEMP |
| tmpdir | C:\WINDOWS\TEMP |
+-----------------------------------------+-----------------------------------------------------------------------------------+
11 rows in set (0.00 sec)
以上红颜色的文件夹中的文件拷到自己建立的文件夹中,如:我是C:\Program Files\MySQL\MySQLServer5.5-01
2、拷贝完数据后编辑C:\Program Files\MySQL\MySQLServer5.5-01下的my.ini文件,端口设定为3308(自己没有用过的端口都可以),注意更改上一步拷过来的数据文件路径更改正确;
[client]
port=3308
[mysql]
default-character-set=latin1
#log-bin="C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.5\data\bin-log\mysql-bin.log"
# SERVER SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by the MySQL Server. Make sure that
# you have installed the server correctly (see above) so it reads this
# file.
#
[mysqld]
# The TCP/IP Port the MySQL Server will listen on
port=3308
basedir="C:/Program Files/MySQL/MySQLServer5.5-01/"
datadir="C:/Program Files/MySQL/MySQLServer5.5-01/data"
log-bin="C:/Program Files/MySQL/MySQLServer5.5-01/data/bin-log/mysql-bin.log"
innodb_data_home_dir="C:/Program Files/MySQL/MySQLServer5.5-01/data/"
以上参数必须修改和自己新建路径相同;
3、在cmd命令行模式下,进入:C:\Program Files\MySQL\MySQLServer5.5-01\bin目录执行以下命令:
mysqld install MySQL_3307(实例名称)
4、修改注册表信息:
在HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MySQL3307 打开,
修改下面的ImagePath数值:
修改下面的ImagePath数值:
5、然后就可以在服务管理里正常启动MySQL_3307服务。
6、错误分析:
看错误日志:PC-201202111331.err
131104 20:43:25 [Note] Plugin 'FEDERATED' is disabled.
131104 20:43:25 InnoDB: The InnoDB memory heap is disabled
131104 20:43:25 InnoDB: Mutexes and rw_locks use Windows interlocked functions
131104 20:43:25 InnoDB: Compressed tables use zlib 1.2.3
131104 20:43:25 InnoDB: Initializing buffer pool, size = 337.0M
131104 20:43:25 InnoDB: Completed initialization of buffer pool
131104 20:43:25 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:43:35 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:43:45 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:43:55 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:44:05 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:44:15 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:44:25 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:44:35 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:44:45 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:44:55 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:45:05 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:45:15 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:45:25 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:45:35 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:45:45 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:45:55 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:46:05 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:46:15 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:46:25 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:46:35 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:46:45 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:46:55 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:47:05 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:47:15 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:47:25 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:47:35 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:47:45 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:47:55 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:48:05 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:48:15 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:48:25 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:48:35 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:48:45 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:48:55 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:49:05 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:49:15 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:49:25 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:49:35 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:49:52 [Note] Plugin 'FEDERATED' is disabled.
131104 20:49:52 InnoDB: The InnoDB memory heap is disabled
131104 20:49:52 InnoDB: Mutexes and rw_locks use Windows interlocked functions
131104 20:49:52 InnoDB: Compressed tables use zlib 1.2.3
131104 20:49:52 InnoDB: Initializing buffer pool, size = 337.0M
131104 20:49:53 InnoDB: Completed initialization of buffer pool
131104 20:49:53 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:50:03 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:50:13 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:50:23 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:50:33 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:50:43 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:50:53 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:51:03 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:51:13 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:51:23 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:51:33 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:51:43 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:51:53 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:52:03 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:52:13 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:52:23 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:52:33 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:52:43 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:52:53 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:53:03 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:53:13 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:53:23 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:53:33 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:53:43 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:53:53 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:54:03 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:54:13 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:54:23 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:54:33 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:54:43 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:54:53 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
131104 20:55:03 InnoDB: highest supported file format is Barracuda.
131104 20:55:03 InnoDB: Waiting for the background threads to start
131104 20:55:04 InnoDB: 1.1.8 started; log sequence number 2469618
131104 20:55:04 [Note] Recovering after a crash using C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.5/data/bin-log/mysql-bin
131104 20:55:04 [Note] Starting crash recovery...
131104 20:55:04 [Note] Crash recovery finished.
131104 20:55:04 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3308
131104 20:55:04 [Note] - '0.0.0.0' resolves to '0.0.0.0';
131104 20:55:04 [Note] Server socket created on IP: '0.0.0.0'.
131104 20:55:04 [Note] Event Scheduler: Loaded 0 events
131104 20:55:04 [Note] C:\Program Files\MySQL\MySQLServer5.5-01\bin\mysqld.exe: ready for connections.
Version: '5.5.25-log' socket: '' port: 3308 MySQL Community Server (GPL)
C:\Program Files\MySQL\MySQLServer5.5-01\bin\mysqld.exe: File 'C:\Program Files\MySQL\MySQLServer5.5-01\data\bin-log\mysql-bin.index' not found (Errcode: 2)
131104 20:55:06 [ERROR] Aborting
131104 20:55:06 [Note] C:\Program Files\MySQL\MySQLServer5.5-01\bin\mysqld.exe: Shutdown complete
131104 20:57:08 [Note] Plugin 'FEDERATED' is disabled.
131104 20:57:08 InnoDB: The InnoDB memory heap is disabled
131104 20:57:08 InnoDB: Mutexes and rw_locks use Windows interlocked functions
131104 20:57:08 InnoDB: Compressed tables use zlib 1.2.3
131104 20:57:08 InnoDB: Initializing buffer pool, size = 337.0M
131104 20:57:09 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file C:\Program Files\MySQL\MySQLServer5.5-01\data\ibdata1 did not exist:
InnoDB: a new database to be created!
131104 20:57:09 InnoDB: Setting file C:\Program Files\MySQL\MySQLServer5.5-01\data\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
131104 20:57:09 InnoDB: Error: all log files must be created at the same time.
131104 20:57:09 InnoDB: All log files must be created also in database creation.
131104 20:57:09 InnoDB: If you want bigger or smaller log files, shut down the
131104 20:57:09 InnoDB: database and make sure there were no errors in shutdown.
131104 20:57:09 InnoDB: Then delete the existing log files. Edit the .cnf file
131104 20:57:09 InnoDB: and start the database again.
131104 20:57:09 [ERROR] Plugin 'InnoDB' init function returned error.
131104 20:57:09 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
131104 20:57:09 [ERROR] Unknown/unsupported storage engine: INNODB
131104 20:57:09 [ERROR] Aborting
131104 20:57:09 [Note] C:\Program Files\MySQL\MySQLServer5.5-01\bin\mysqld.exe: Shutdown complete
131104 20:59:31 [Note] Plugin 'FEDERATED' is disabled.
131104 20:59:31 InnoDB: The InnoDB memory heap is disabled
131104 20:59:31 InnoDB: Mutexes and rw_locks use Windows interlocked functions
131104 20:59:31 InnoDB: Compressed tables use zlib 1.2.3
131104 20:59:31 InnoDB: Initializing buffer pool, size = 337.0M
131104 20:59:31 InnoDB: Completed initialization of buffer pool
131104 20:59:32 InnoDB: highest supported file format is Barracuda.
131104 20:59:32 InnoDB: Waiting for the background threads to start
131104 20:59:33 InnoDB: 1.1.8 started; log sequence number 2469618
131104 20:59:33 [Note] Recovering after a crash using C:/Program Files/MySQL/MySQLServer5.5-01/data/bin-log/mysql-bin
131104 20:59:33 [Note] Starting crash recovery...
131104 20:59:33 [Note] Crash recovery finished.
131104 20:59:33 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3308
131104 20:59:33 [Note] - '0.0.0.0' resolves to '0.0.0.0';
131104 20:59:33 [Note] Server socket created on IP: '0.0.0.0'.
131104 20:59:33 [Note] Event Scheduler: Loaded 0 events
131104 20:59:33 [Note] C:\Program Files\MySQL\MySQLServer5.5-01\bin\mysqld.exe: ready for connections.
Version: '5.5.25-log' socket: '' port: 3308 MySQL Community Server (GPL)
131104 21:05:01 [ERROR] Invalid (old?) table or database name 'bin-log'
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
docker 启动 mysql:8.0.27 失败
docker 启动 mysql:8.0.27 失败
docker MySQL8.0.27 -
完全清理mysql-win
WontrolSet002\Services\Eventlog.
mysql mysql卸载 MySQL 重启 -
Mysql多实例启动
目录多实例的应用1、准备多个目录2、准备配置文件3、
mysql linux 运维 服务器 -
mysql多实例启动简要备忘
mysql多实例启动简要备忘
mysql 多实例 启动 简要备忘