MySQL GUI Administration Tools

1
MySQL GUI Administration Tools

• Rob Donahue
• Manager, Distributed Systems Development
• May 7th, 2001

2
Overview

• OCLC SiteSearch 4.1.2 includes MySQL as a
  replacement for mSQL.
• MySQL was originally developed to handle very
  large databases much faster than existing
  solutions and has been successfully used in
  highly demanding production environments for
  several years.
• MySQL is a client/server system that consists of
  a multi-threaded SQL server that supports
  different backends, several different client
  programs and libraries, administrative tools, and
  several programming interfaces.
• MySQL is open source software under the GNU
  public license (GPL).

3
Many Tools

• There are literally dozens of tools available
• Tools are available on a variety of platforms,
  both graphical and command line
• Each tool is different in look and feel but
  overall features are common
• Execute SQL queries
• Browse Tables
• Edit structure
• Import / Export
• Remote administration of databases

4
GUI Administration

• Several graphical administrative tools are
  available
• Web-based tools
• Wintel tools
• Unix tools
• Java Tools

5
Benefits of GUI Tools

• Easy addition and deletion of authos.
• Import of authorizations in many formats, such as
  a comma-delimited file from your OPAC.
• Some tools provide reports that may be useful.
• Many tools allow remote administration.

6
Web-based tools

• phpMyAdmin
• Open-Source, Freely available
• Allows complete web-administration of multiple
  databases
• Allows for direct entry of SQL queries.
• Allows batch imports into tables from delimited
  files.
• Easy to use
• Requires php 3.0

7
Wintel Tools

• MySQL Admin
• Doesnt require installation of any drivers.
• Support in multiple languages (English, Croatian,
  Italian, French... ).
• User interface has MS Access look and feel.
• Auxiliary connection to other databases/hosts.
• Visual query builder.
• Auto logging and e-mailing of unhandled
  exceptions.

8
Unix Tools

• MySQLGUI
• Open Source Freely available
• Graphical SQL client for MySQL
• Available for many platforms including Windows
• Remote administration capabilities

9
Java Based Tools

• Fredys Java Admin
• Open-Source Freely available
• Requires JDK 1.2.2 or 1.3
• Requires JDBC driver
• Allows for remote administration
• Has batch import / export ability

10
Summary

• Many free tools available on many platforms.
  Some even have source-code available.
• Graphical interface makes database administration
  easy.
• Can manipulate many databases from different
  servers from a central interface.
• MySQL ships with SiteSearch 4.1.2 May 11, 2001.

11
Where to Get Clients

• A listing of links to clients is available at
• www.mysql.com/downloads/contrib.html

12
Questions?