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

サイト内検索

PGM
・Java
・Android
・Perl
・Python
・PHP
・Ruby
・VS2008 VB
・VS2008 C++
・VS2008 C#
・VS2010 VB
・VS2010 C++
・VS2010 C#
・CSS
・JavaScript
・CoffeeScript
・Dart
・JSX
・Haxe
・GCC
・Google Go
・Node.js

コマンド
・Windows
・Linux

Webサーバ
・Apache
・nginx

メールサーバ
・Postfix

CMS
・MovableType
・Drupal
・WordPress

ソースコード管理
・GitHub
・Bitbucket

バージョン管理
・Subversion
・Git

プロジェクト管理
・Trac
・Redmine
・dotProject

CI
・Jenkins

RDMSデータベース
・MySQL
・PostgreSQL
・DB2
・Oracle
・SQL Server

NoSQLデータベース
・MongoDB

Webサービス系（Windows）
・Windows Azure

Webサービス系（VPS系）
・Amazon Web Service
・さくらVPS

Webサービス系（Paas）
・Heroku
・appfog

仮想OS
・VMWare Server
・VMWare Player
・Oracle VM VirtualBox
・Vagrant

負荷テストツール
・apache-jmeter

メーリングリスト
・Mailman

Windows
・WebServer
・Apache
・Tomcat
・Node.js
・バージョン管理
・Subversion
・Git
・PGM
・VS2008 VB
・VS2010 VB
・MinGW C
・BCC55
・PHP
・Java
・Perl
・Ruby
・Python
・CoffeeScript
・Dart
・JSX
・Haxe
・DB
・MySQL
・PostgreSQL
・DB2
・Oracle
・SqlServer
・仮想化
・デスクトップ仮想化
・サーバ仮想化

Linux
・Shell
・コマンドスクリプト
・Linux設定
・Webサーバ
・Apache
・Tomcat
・バージョン管理
・Subversion
・サイト作成
・WordPress
・Movable Type
・XOOPS
・PGM
・C(GCC)
・PHP
・Java
・Perl
・Ruby
・Python
・Go
・DB
・MySQL
・PostgreSQL
・DB2
・Oracle
・バグ管理(BTS)
・Bugzilla
・Mantis
・BugTracker.NET

メニュー

Top > Windows-MySQL > 基本機能 > MySQL起動関連 > サンプル > 異なるマシンで起動

異なるマシンで起動

環境設定

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

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

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

IP　：192.168.111.11
Port：3308
Path：C:/ProgramData/MySQL/data2

１つ目のデータ設定

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

# The following options will be passed to all MySQL clients
[client]
#password	= your_password
port		= 3308
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		= 3308

my.iniを設定

C:\>xcopy "C:\Program Files\MySQL\MySQL5.1\data" "c:\ProgramData\MySQL\data1" /E /I
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
69 個のファイルをコピーしました
 
C:\>copy "C:\Program Files\MySQL\MySQL5.1\my-huge.ini" "C:\ProgramData\MySQL\data1\my.ini"
        1 個のファイルをコピーしました。
 
C:\>

起動

C:\>"C:\Program Files\MySQL\MySQL5.1\bin\mysqld" --defaults-file="C:\ProgramData\MySQL\data1\my.ini" --console
100702  0:02:40 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '-
-character-set-server' instead.
100702  0:02:40 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-ext
ernal-locking' instead.
100702  0:02:40 [Note] Plugin 'FEDERATED' is disabled.
100702  0:02:41  InnoDB: Started; log sequence number 0 46827
100702  0:02:41 [Note] Event Scheduler: Loaded 0 events
100702  0:02:41 [Note] C:\Program Files\MySQL\MySQL5.1\bin\mysqld: ready for connections.
Version: '5.1.48-community-log'  socket: ''  port: 3308  MySQL Community Server (GPL)
100702  0:02:46 [Note] C:\Program Files\MySQL\MySQL5.1\bin\mysqld: Normal shutdown
 
100702  0:02:46 [Note] Event Scheduler: Purging the queue. 0 events
100702  0:02:48  InnoDB: Starting shutdown...
100702  0:02:51  InnoDB: Shutdown completed; log sequence number 0 46827
100702  0:02:51 [Note] C:\Program Files\MySQL\MySQL5.1\bin\mysqld: Shutdown complete
 
 
C:\>

接続確認～切断

C:\>mysql -u root --port=3308
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.08 sec)
 
mysql> create database testdb1;
Query OK, 1 row affected (0.02 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', 'aaa', 'bbb');
Query OK, 1 row affected (0.05 sec)
 
mysql> insert into testtable1(data1, data2, data3) values('222', 'ccc', 'ddd');
Query OK, 1 row affected (0.00 sec)
 
mysql> insert into testtable1(data1, data2, data3) values('333', 'eee', 'fff');
Query OK, 1 row affected (0.01 sec)
 
mysql> select * from testtable1;
+-------+-------+-------+
| data1 | data2 | data3 |
+-------+-------+-------+
| 111   | aaa   | bbb   |
| 222   | ccc   | ddd   |
| 333   | eee   | fff   |
+-------+-------+-------+
3 rows in set (0.02 sec)
 
mysql> quit
Bye
 
C:\>"C:\Program Files\MySQL\MySQL5.1\bin\mysqladmin" -u root --port=3308 shutdown
 
C:\>

２つ目のデータ設定

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

C:\>xcopy "C:\Program Files\MySQL\MySQL5.1\data" "c:\ProgramData\MySQL\data2" /E /I
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
69 個のファイルをコピーしました
 
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		= 3308
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		= 3308

起動

C:\>"C:\Program Files\MySQL\MySQL5.1\bin\mysqld" --defaults-file="C:\ProgramData\MySQL\data2\my.ini" --console
100702  0:13:28 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead.
100702  0:13:28 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
100702  0:13:29 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
100702  0:13:29  InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
100702  0:13:30  InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
100702  0:13:30  InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
100702  0:13:31  InnoDB: Started; log sequence number 0 0
100702  0:13:31 [Note] Event Scheduler: Loaded 0 events
100702  0:13:31 [Note] C:\Program Files\MySQL\MySQL5.1\bin\mysqld: ready for connections.
Version: '5.1.48-community-log'  socket: ''  port: 3308  MySQL Community Server (GPL)
100702  0:17:53 [Note] C:\Program Files\MySQL\MySQL5.1\bin\mysqld: Normal shutdown
 
100702  0:17:53 [Note] Event Scheduler: Purging the queue. 0 events
100702  0:17:53  InnoDB: Starting shutdown...
100702  0:17:56  InnoDB: Shutdown completed; log sequence number 0 46827
100702  0:17:56 [Note] C:\Program Files\MySQL\MySQL5.1\bin\mysqld: Shutdown complete
 
 
C:\>

接続確認～切断

C:\>mysql -u root --port=3308
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.02 sec)
 
mysql> create database testdb1;
Query OK, 1 row affected (0.02 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.02 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', 'yyy', 'bbb');
Query OK, 1 row affected (0.02 sec)
 
mysql> insert into testtable1(data1, data2, data3) values('333', 'zzz', 'ccc');
Query OK, 1 row affected (0.01 sec)
 
mysql> select * from testtable1;
+-------+-------+-------+
| data1 | data2 | data3 |
+-------+-------+-------+
| 111   | xxx   | aaa   |
| 222   | yyy   | bbb   |
| 333   | zzz   | ccc   |
+-------+-------+-------+
3 rows in set (0.00 sec)
 
mysql> quit
Bye
 
C:\>"C:\Program Files\MySQL\MySQL5.1\bin\mysqladmin" -u root --port=3308 shutdown
 
C:\>

「異なるマシンで起動」をウィキ内検索

最終更新：2010年07月02日 00:23

プログラミングの勉強をしよう@Wiki

Windows-MySQL > 基本機能 > MySQL起動関連 > サンプル > 異なるマシンで起動

更新履歴

異なるマシンで起動

環境設定

１つ目のデータ設定

２つ目のデータ設定