----在一台服务器上创建两个mysql实例
安装环境:win7
1.使用mysql安装程序安装一个mysql实例 (这个很简单,省略掉)
2.停止mysql 服务
3.将datadir 和 basedir的 路径的文件夹 复制到另外一个文件夹中
旧:basedir="C:/Program Files/MySQL/MySQL Server 5.1/"
datadir="C:/ProgramData/MySQL/MySQL Server 5.1/Data/"
新: basedir="E:\MySQL\MySQL Server 5.1\"
datadir="E:\MySQL\MySQL Server 5.1\data\"
4.修改 basedir 中的my.ini 文件 贴出来的部分 两个端口号 datadir和basedir 路径
[client]
port=3306
[mysql]
default-character-set=latin1
# 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=3306
#Path to installation directory. All paths are usually resolved relative to this.
basedir="C:/Program Files/MySQL/MySQL Server 5.1/"
#Path to the database root
datadir="C:/ProgramData/MySQL/MySQL Server 5.1/Data/"
==修改之后=============
[client]
port=3307
[mysql]
default-character-set=latin1
# 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=3307
#Path to installation directory. All paths are usually resolved relative to this.
basedir="E:\MySQL\MySQL Server 5.1\"
#Path to the database root
datadir="E:\MySQL\MySQL Server 5.1\data\"
5. 生成mysql服务
在新的basedir 下找到 mysqld 程序
cmd 命令:
c:\>cd E:\MySQL\MySQL Server 5.1\bin>
在当前路径下执行以下命令:
mysqld install MySQLTest --defaults-file="E:\MySQL\MySQL Server 5.1\my.ini"
补充:
移除实例:
mysqld-nt --remove mysqlTest