1 / 12

MySQL GUI Administration Tools

MySQL GUI Administration Tools. Rob Donahue Manager, Distributed Systems Development May 7th, 2001. Overview. OCLC SiteSearch 4.1.2 includes MySQL as a replacement for mSQL.

hestia
Download Presentation

MySQL GUI Administration Tools

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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 • Doesn’t 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 Fredy’s 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?

More Related