Windows-MySQL/基本機能/MySQL起動関連/サンプル/同一のマシンで起動 - プログラミングの勉強をしよう@Wiki

Top > Windows-MySQL > 基本機能 > MySQL起動関連 > サンプル > 同一のマシンで起動

同一のマシンで起動

環境設定

１つめのデータディレクトリ

IP　：192.168.111.10
Port：3309
Path：C:/ProgramData/MySQL/data1
 

２つめのデータディレクトリ

IP　：192.168.111.10
Port：3310
Path：C:/ProgramData/MySQL/data2
 

１つ目のデータ設定

データディレクトリをコピー

c:\>xcopy "C:\Program Files\MySQL\MySQL5.1\data" "c:\ProgramData\MySQL\data1" /E /I
C:\Program Files\MySQL\MySQL5.1\data\ibdata1
C:\Program Files\MySQL\MySQL5.1\data\ib_logfile0
C:\Program Files\MySQL\MySQL5.1\data\ib_logfile1
C:\Program Files\MySQL\MySQL5.1\data\mysql-bin.000001
C:\Program Files\MySQL\MySQL5.1\data\mysql-bin.000002
C:\Program Files\MySQL\MySQL5.1\data\mysql-bin.index
C:\Program Files\MySQL\MySQL5.1\data\m_shige1979-PC.err
C:\Program Files\MySQL\MySQL5.1\data\mysql\columns_priv.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\columns_priv.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\columns_priv.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\db.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\db.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\db.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\event.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\event.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\event.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\func.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\func.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\func.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\general_log.CSM
C:\Program Files\MySQL\MySQL5.1\data\mysql\general_log.CSV
C:\Program Files\MySQL\MySQL5.1\data\mysql\general_log.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\help_category.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\help_category.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\help_category.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\help_keyword.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\help_keyword.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\help_keyword.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\help_relation.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\help_relation.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\help_relation.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\help_topic.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\help_topic.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\help_topic.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\host.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\host.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\host.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\ndb_binlog_index.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\ndb_binlog_index.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\ndb_binlog_index.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\plugin.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\plugin.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\plugin.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\proc.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\proc.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\proc.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\procs_priv.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\procs_priv.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\procs_priv.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\servers.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\servers.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\servers.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\slow_log.CSM
C:\Program Files\MySQL\MySQL5.1\data\mysql\slow_log.CSV
C:\Program Files\MySQL\MySQL5.1\data\mysql\slow_log.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\tables_priv.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\tables_priv.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\tables_priv.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\time_zone.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\time_zone.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\time_zone.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\time_zone_leap_second.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\time_zone_leap_second.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\time_zone_leap_second.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\time_zone_name.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\time_zone_name.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\time_zone_name.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\time_zone_transition.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\time_zone_transition.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\time_zone_transition.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\time_zone_transition_type.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\time_zone_transition_type.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\time_zone_transition_type.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\user.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\user.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\user.MYI
76 個のファイルをコピーしました
 
c:\>copy "C:\Program Files\MySQL\MySQL5.1\my-huge.ini" "C:\ProgramData\MySQL\data1\my.ini"
        1 個のファイルをコピーしました。
 
c:\>
 
 

my.iniを設定

# The following options will be passed to all MySQL clients
[client]
#password	= your_password
port		= 3309
socket		= /tmp/mysql.sock
 
# Here follows entries for some specific programs
 
# The MySQL server
[mysqld]
basedir="C:\Program Files\MySQL\MySQL5.1/"
datadir="C:\ProgramData\MySQL\data1/"
default-character-set=cp932
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=100
 
port		= 3309
 
 

起動

c:\>"C:\Program Files\MySQL\MySQL5.1\bin\mysqld" --defaults-file="C:\ProgramData\MySQL\data1\my.ini" --console
100701 18:23:59 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' inste
100701 18:23:59 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
100701 18:23:59 [Note] Plugin 'FEDERATED' is disabled.
100701 18:23:59  InnoDB: Started; log sequence number 0 44233
100701 18:24:06 [Note] Event Scheduler: Loaded 0 events
100701 18:24:06 [Note] C:\Program Files\MySQL\MySQL5.1\bin\mysqld: ready for connections.
Version: '5.1.48-community-log'  socket: ''  port: 3309  MySQL Community Server (GPL)
100701 18:29:19 [Note] C:\Program Files\MySQL\MySQL5.1\bin\mysqld: Normal shutdown
 
100701 18:30:59 [Note] Event Scheduler: Purging the queue. 0 events
100701 18:30:59  InnoDB: Starting shutdown...
100701 18:31:04  InnoDB: Shutdown completed; log sequence number 0 46837
100701 18:31:04 [Note] C:\Program Files\MySQL\MySQL5.1\bin\mysqld: Shutdown complete
 
 
c:\>
 

接続確認～切断

C:\>"C:\Program Files\MySQL\MySQL5.1\bin\mysql" -u root --port=3309
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.48-community-log MySQL Community Server (GPL)
 
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license
 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| test               |
+--------------------+
3 rows in set (0.09 sec)
 
mysql> create database testdb1;
Query OK, 1 row affected (0.08 sec)
 
mysql> use testdb1;
Database changed
mysql> create table testtable1( data1 varchar(10), data2 varchar(10), data3 varchar(10),
    ->     primary key(data1));
Query OK, 0 rows affected (0.16 sec)
 
mysql> insert into testtable1(data1, data2, data3) values('111', 'aaa', 'bbb');
Query OK, 1 row affected (0.10 sec)
 
mysql> insert into testtable1(data1, data2, data3) values('222', 'ccc', 'ddd');
Query OK, 1 row affected (0.06 sec)
 
mysql> insert into testtable1(data1, data2, data3) values('333', 'eee', 'fff');
Query OK, 1 row affected (0.06 sec)
 
mysql> select * from testtable1;
+-------+-------+-------+
| data1 | data2 | data3 |
+-------+-------+-------+
| 111   | aaa   | bbb   |
| 222   | ccc   | ddd   |
| 333   | eee   | fff   |
+-------+-------+-------+
3 rows in set (0.00 sec)
 
mysql> quit
Bye
 
C:\>"C:\Program Files\MySQL\MySQL5.1\bin\mysqladmin" -u root --port=3309 shutdown
 
C:\>
 

２つ目のデータ設定

データディレクトリをコピー

c:\>xcopy "C:\Program Files\MySQL\MySQL5.1\data" "c:\ProgramData\MySQL\data2" /E /I
C:\Program Files\MySQL\MySQL5.1\data\ibdata1
C:\Program Files\MySQL\MySQL5.1\data\ib_logfile0
C:\Program Files\MySQL\MySQL5.1\data\ib_logfile1
C:\Program Files\MySQL\MySQL5.1\data\mysql-bin.000001
C:\Program Files\MySQL\MySQL5.1\data\mysql-bin.000002
C:\Program Files\MySQL\MySQL5.1\data\mysql-bin.index
C:\Program Files\MySQL\MySQL5.1\data\m_shige1979-PC.err
C:\Program Files\MySQL\MySQL5.1\data\mysql\columns_priv.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\columns_priv.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\columns_priv.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\db.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\db.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\db.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\event.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\event.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\event.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\func.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\func.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\func.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\general_log.CSM
C:\Program Files\MySQL\MySQL5.1\data\mysql\general_log.CSV
C:\Program Files\MySQL\MySQL5.1\data\mysql\general_log.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\help_category.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\help_category.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\help_category.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\help_keyword.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\help_keyword.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\help_keyword.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\help_relation.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\help_relation.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\help_relation.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\help_topic.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\help_topic.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\help_topic.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\host.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\host.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\host.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\ndb_binlog_index.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\ndb_binlog_index.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\ndb_binlog_index.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\plugin.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\plugin.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\plugin.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\proc.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\proc.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\proc.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\procs_priv.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\procs_priv.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\procs_priv.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\servers.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\servers.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\servers.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\slow_log.CSM
C:\Program Files\MySQL\MySQL5.1\data\mysql\slow_log.CSV
C:\Program Files\MySQL\MySQL5.1\data\mysql\slow_log.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\tables_priv.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\tables_priv.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\tables_priv.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\time_zone.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\time_zone.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\time_zone.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\time_zone_leap_second.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\time_zone_leap_second.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\time_zone_leap_second.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\time_zone_name.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\time_zone_name.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\time_zone_name.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\time_zone_transition.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\time_zone_transition.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\time_zone_transition.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\time_zone_transition_type.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\time_zone_transition_type.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\time_zone_transition_type.MYI
C:\Program Files\MySQL\MySQL5.1\data\mysql\user.frm
C:\Program Files\MySQL\MySQL5.1\data\mysql\user.MYD
C:\Program Files\MySQL\MySQL5.1\data\mysql\user.MYI
76 個のファイルをコピーしました
 
c:\>copy "C:\Program Files\MySQL\MySQL5.1\my-huge.ini" "C:\ProgramData\MySQL\data2\my.ini"
        1 個のファイルをコピーしました。
 
c:\>
 

my.iniを設定

# The following options will be passed to all MySQL clients
[client]
#password	= your_password
port		= 3310
socket		= /tmp/mysql.sock
 
# Here follows entries for some specific programs
 
# The MySQL server
[mysqld]
basedir="C:\Program Files\MySQL\MySQL5.1/"
datadir="C:\ProgramData\MySQL\data2/"
default-character-set=cp932
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=100
 
port		= 3310
 
 

起動

c:\>"C:\Program Files\MySQL\MySQL5.1\bin\mysqladmin" -u root --port=3310 shutdown
C:\Program Files\MySQL\MySQL5.1\bin\mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to MySQL server on 'localhost' (10061)'
Check that mysqld is running on localhost and that the port is 3310.
You can check this by doing 'telnet localhost 3310'
 
c:\>"C:\Program Files\MySQL\MySQL5.1\bin\mysqld" --defaults-file="C:\ProgramData\MySQL\data2\my.ini" --console
100701 19:19:50 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead
100701 19:19:50 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
100701 19:19:50 [Note] Plugin 'FEDERATED' is disabled.
100701 19:19:50  InnoDB: Started; log sequence number 0 44233
100701 19:19:51 [Note] Event Scheduler: Loaded 0 events
100701 19:19:51 [Note] C:\Program Files\MySQL\MySQL5.1\bin\mysqld: ready for connections.
Version: '5.1.48-community-log'  socket: ''  port: 3310  MySQL Community Server (GPL)
100701 19:23:42 [Note] C:\Program Files\MySQL\MySQL5.1\bin\mysqld: Normal shutdown
 
100701 19:23:42 [Note] Event Scheduler: Purging the queue. 0 events
100701 19:23:42  InnoDB: Starting shutdown...
100701 19:23:46  InnoDB: Shutdown completed; log sequence number 0 46837
100701 19:23:46 [Note] C:\Program Files\MySQL\MySQL5.1\bin\mysqld: Shutdown complete
 
 
c:\>
 

接続確認～切断

c:\>"C:\Program Files\MySQL\MySQL5.1\bin\mysql" -u root --port=3310
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.48-community-log MySQL Community Server (GPL)
 
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license
 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| test               |
+--------------------+
3 rows in set (0.00 sec)
 
mysql> create database testdb1;
Query OK, 1 row affected (0.01 sec)
 
mysql> use testdb1;
Database changed
mysql> create table testtable1( data1 varchar(10), data2 varchar(10), data3 varchar(10),
    ->     primary key(data1));
Query OK, 0 rows affected (0.06 sec)
 
mysql> insert into testtable1(data1, data2, data3) values('111', 'xxx', 'aaa');
Query OK, 1 row affected (0.03 sec)
 
mysql> insert into testtable1(data1, data2, data3) values('222', 'zzz', 'bbb');
Query OK, 1 row affected (0.07 sec)
 
mysql> insert into testtable1(data1, data2, data3) values('333', 'yyy', 'ccc');
Query OK, 1 row affected (0.03 sec)
 
mysql> select * from testtable1;
+-------+-------+-------+
| data1 | data2 | data3 |
+-------+-------+-------+
| 111   | xxx   | aaa   |
| 222   | zzz   | bbb   |
| 333   | yyy   | ccc   |
+-------+-------+-------+
3 rows in set (0.00 sec)
 
mysql> quit
Bye
 
c:\>"C:\Program Files\MySQL\MySQL5.1\bin\mysqladmin" -u root --port=3310 shutdown
 
c:\>
 

---