この記事は、2015年「MySQLマニュアルを読む」アドベントカレンダーの23日目です.
こんにちは！つらいです！
マニュアルをふわふわと眺めるだけのフェーズを過ぎて、やはり、ひとつひとつ実際に試してみたいフェーズに入ってきました。毎日数十分程度の時間じゃぁできません。。
ということで本日はライトな話題で。
MySQLのリファレンスマニュアルには、最終章（26章）に、「MySQL Workbench」という章があります。
ただひとつの節からなるシンプルな章だなぁと思って、中身を読んだことがなかったのですが、ちゃんと見てみたら、MySQL本体マニュアルとは別に、Workbench 専用のマニュアルがあると、書かれていました。しかも、このページ内にある唯一のリンクで、すぐに気づきそうなものなのに。。。
ちなみに、本マニュアルによると MySQL Workbenchは、MySQL 5.1以上に対応。5.0でも動くけどいくつかの機能がサポートされない、4.x シリーズはサポートされない、とのことです。
さて、その MySQL Workbench のマニュアルは、こちら。
http://dev.mysql.com/doc/workbench/en/
バージョン番号が含まれないのですね。ここで現在公開されているのは、MySQL Workbench 6 (6.0～6.3) のマニュアルとなります。
MySQL Workbench の全もくじを以下に掲載します。
みんなだいすき「Extending」の説明もありますよ！
MySQL Workbench Table of Contents
1 General Information
1.1 What Is New in MySQL Workbench 6
1.1.1 New in MySQL Workbench 6.3
1.1.2 New in MySQL Workbench 6.2
1.1.3 New in MySQL Workbench 6.1
1.1.4 New in MySQL Workbench 6.0
1.2 MySQL Workbench Editions
2 Installation
2.1 System Requirements
2.2 Command-line options
2.3 MySQL Workbench on Windows
2.3.1 Installing
2.3.2 Launching
2.3.3 Uninstalling
2.4 MySQL Workbench on Linux
2.4.1 Installing
2.4.2 Launching
2.4.3 Uninstalling
2.5 MySQL Workbench on OS X
2.5.1 Installing
2.5.2 Launching
2.5.3 Uninstalling
3 Configuration
3.1 User Accessibility Options
3.2 Workbench Preferences
3.2.1 General Editors Preferences
3.2.2 SQL Editor Preferences
3.2.3 Administration Preferences
3.2.4 Modeling Preferences
3.2.5 Fonts and Colors Preferences
3.2.6 Other Preferences
3.3 MySQL Workbench Settings and Log Files
3.4 Tutorial: Add a Custom Link to the Home Page
3.5 Common Preferences and Configurations
4 The Home Screen
5 MySQL Connections
5.1 Creating A New MySQL Connection (Simple)
5.2 Creating A New MySQL Connection (Tutorial)
5.3 Manage Server Connections
5.3.1 Standard TCP/IP Connection Method
5.3.2 Local Socket/Pipe Connection Method
5.3.3 Standard TCP/IP over SSH Connection Method
5.3.4 SSL Wizard (Certificates)
5.3.5 System Profile
5.3.6 Configure Server Management Wizard
5.3.7 The Password Storage Vault
5.4 MySQL Fabric Integration
5.5 Client Connections
6 Administrative Tasks
6.1 Server Management
6.1.1 MySQL Connection Navigator
6.1.2 Server Logs
6.1.3 Service Control
6.1.4 Configuration (options file)
6.2 Users and Privileges
6.3 Server Status
6.4 Status and System Variables
6.5 Data Export and Import
6.5.1 Table Data Export and Import Wizard
6.5.2 SQL Data Export and Import Wizard
6.5.3 Result Data Export and Import
6.6 MySQL Audit Inspector Interface
6.7 MySQL Enterprise Backup Interface
6.7.1 General Requirements
6.7.2 Online Backup
6.7.3 Backup Recovery
6.8 MySQL Enterprise Firewall Interface
6.9 The wbcopytables Tool
7 Performance Tools
7.1 Performance Dashboard
7.2 Performance Schema Reports
7.3 Visual Explain Plan
7.4 Query Statistics
7.5 Tutorial: Using Visual Explain to improve query performance
8 Database Development
8.1 Visual SQL Editor
8.1.1 SQL Query Window
8.1.2 SQL Query Window Toolbar
8.1.3 Query and Edit Menus
8.1.4 Results Window
8.1.5 SQL Snippets tab
8.1.6 Context Sensitive Help
8.1.7 Output History Panel
8.1.8 Table Data Search Panel
8.1.9 Export / Import a Table
8.1.10 Tutorial: Adding Data
8.1.11 The MySQL Table Editor
8.1.12 Code Generation Overview
8.2 Object Management
8.2.1 Object Browser and Editor Navigator
8.2.2 Session and Object Information Panel
8.2.3 Schema and Table Inspector
9 Database Design / Modeling
9.1 Modeling Interface
9.1.1 Model Editor
9.1.2 EER Diagram Editor
9.1.3 Creating Tables
9.1.4 Creating Foreign Key Relationships
9.1.5 Creating Views
9.1.6 Creating Routines and Routine Groups
9.1.7 Creating Layers
9.1.8 Creating Notes
9.1.9 Creating Text Objects
9.1.10 Creating Images
9.2 Additional Modeling Tools
9.2.1 Printing Diagrams
9.2.2 DBDoc Model Reporting
9.2.3 Schema Validation Plugins
9.3 Modeling Tutorials
9.3.1 Creating a Model
9.3.2 Basic Modeling
9.3.3 Importing a Data Definition SQL Script
9.3.4 Using the Default Schema
9.3.5 Documenting the sakila Database
9.4 Forward and Reverse Engineering
9.4.1 Forward Engineering
9.4.2 Reverse Engineering
9.5 Schema Synchronization and Comparison
9.5.1 Database Synchronization
9.5.2 Compare and Report Differences in Catalogs
9.6 Table Templates
9.7 Customizing DBDoc Model Reporting Templates
9.7.1 Supported Template Markers
9.7.2 Creating a Custom Template
10 Database Migration Wizard
10.1 General installation requirements
10.1.1 ODBC Libraries
10.1.2 ODBC Drivers
10.2 Migration Overview
10.2.1 A visual guide to performing a database migration
10.2.2 Migrating from supported databases
10.2.3 Migrating from unsupported (generic) databases
10.3 Conceptual DBMS equivalents
10.4 Microsoft Access Migration
10.5 Microsoft SQL Server migration
10.5.1 Preparations
10.5.2 Drivers
10.5.3 Connection Setup
10.5.4 Microsoft SQL Server Type Mapping
10.6 PostgreSQL migration
10.6.1 Preparations
10.6.2 Drivers
10.6.3 Connection Setup
10.6.4 PostgreSQL Type Mapping
10.7 MySQL migration
10.8 Using the MySQL Workbench Migration Wizard
10.8.1 Connecting to the databases
10.8.2 Schemata Retrieval and Selection
10.8.3 Reverse Engineering
10.8.4 Object Selection
10.8.5 Migration
10.8.6 Manual Editing
10.8.7 Target Creation Options
10.8.8 Schema Creation
10.8.9 Create Target Results
10.8.10 Data Transfer and Migration Setup
10.8.11 Bulk Data Transfer
10.8.12 Migration Report
10.9 MySQL Workbench Migration Wizard FAQ
A MySQL Workbench Frequently Asked Questions
B Keyboard Shortcuts
C Extending Workbench
C.1 GRT and Workbench Data Organization
C.2 Modules
C.3 Plugins / Tools
C.4 Adding a GUI to a Plugin Using MForms
C.5 The Workbench Scripting Shell
C.5.1 Exploring the Workbench Scripting Shell
C.5.2 The Shell Window
C.5.3 The Files, Globals, Classes, Modules, and Notifications Tabs
C.6 Tutorial: Writing Plugins
D How To Report Bugs or Problems
E MySQL Enterprise Features
F MySQL Utilities
G Third Party Licenses
G.1 .NET Flat TabControl License
G.2 ANTLR ECMA Grammar License
G.3 ANTLR License
G.4 Bitstream Vera License
G.5 Boost Library License
G.6 Cairo License
G.7 CTemplate (Google Template System) License
G.8 cURL (libcurl) License
G.9 DockPanel Suite License
G.10 Dojo Toolkit v1.7.0b1 License
G.11 FreeTDS License
G.12 GDAL/OGR License
G.13 GLib License (for MySQL Workbench)
G.14 Glitz License
G.15 GNU Lesser General Public License Version 2.1, February 1999
G.16 HtmlRenderer (System.Drawing.Html)
G.17 iODBC License
G.18 Libiconv License
G.19 Libintl License
G.20 libpng License
G.21 Libxml2 License
G.22 Libzip License
G.23 Lua (liblua) License
G.24 Paramiko License
G.25 PCRE License
G.26 Pixman License
G.27 PROJ.4 License
G.28 PyCrypto 2.6 License
G.29 PyODBC License
G.30 PySQLite License
G.31 Python License
G.32 Python-ecdsa License
G.33 Scintilla License
G.34 ScintillaNET License
G.35 SQLCipher License
G.36 TinyXML License
G.37 TreeViewAdv for .NET License
G.38 VSQLite++ License
G.39 zlib License少し見通しが悪いので、レベル２までのもくじも載せておきます。
MySQL Workbench Table of Contents
1 General Information
1.1 What Is New in MySQL Workbench 6
1.2 MySQL Workbench Editions
2 Installation
2.1 System Requirements
2.2 Command-line options
2.3 MySQL Workbench on Windows
2.4 MySQL Workbench on Linux
2.5 MySQL Workbench on OS X
3 Configuration
3.1 User Accessibility Options
3.2 Workbench Preferences
3.3 MySQL Workbench Settings and Log Files
3.4 Tutorial: Add a Custom Link to the Home Page
3.5 Common Preferences and Configurations
4 The Home Screen
5 MySQL Connections
5.1 Creating A New MySQL Connection (Simple)
5.2 Creating A New MySQL Connection (Tutorial)
5.3 Manage Server Connections
5.4 MySQL Fabric Integration
5.5 Client Connections
6 Administrative Tasks
6.1 Server Management
6.2 Users and Privileges
6.3 Server Status
6.4 Status and System Variables
6.5 Data Export and Import
6.6 MySQL Audit Inspector Interface
6.7 MySQL Enterprise Backup Interface
6.8 MySQL Enterprise Firewall Interface
6.9 The wbcopytables Tool
7 Performance Tools
7.1 Performance Dashboard
7.2 Performance Schema Reports
7.3 Visual Explain Plan
7.4 Query Statistics
7.5 Tutorial: Using Visual Explain to improve query performance
8 Database Development
8.1 Visual SQL Editor
8.2 Object Management
9 Database Design / Modeling
9.1 Modeling Interface
9.2 Additional Modeling Tools
9.3 Modeling Tutorials
9.4 Forward and Reverse Engineering
9.5 Schema Synchronization and Comparison
9.6 Table Templates
9.7 Customizing DBDoc Model Reporting Templates
10 Database Migration Wizard
10.1 General installation requirements
10.2 Migration Overview
10.3 Conceptual DBMS equivalents
10.4 Microsoft Access Migration
10.5 Microsoft SQL Server migration
10.6 PostgreSQL migration
10.7 MySQL migration
10.8 Using the MySQL Workbench Migration Wizard
10.9 MySQL Workbench Migration Wizard FAQ
A MySQL Workbench Frequently Asked Questions
B Keyboard Shortcuts
C Extending Workbench
D How To Report Bugs or Problems
E MySQL Enterprise Features
F MySQL Utilities
G Third Party Licenses
