|
|
|
Hi, and welcome to this readme file for myAdmin.
myAdmin is a light-weight GUI client for mysql. It runs on top of TCX's libmysql.dll, and should therefore be capable of connecting to any mysql server.
This manual is also at http://members.xoom.com/qabi/myadmin/.
At least for the moment, the newest version can be found at http://members.xoom.com/qabi/myadmin/myAdmin1.0.1.0.zip.
|
Just unzip the archive to any directory you'd like it.
The required 'libmysql.dll' file is included. (Version 3.22.14-gamma - this can be replaced with a newer version, but it might not work).
|
This program is freeware. Go ahead and copy it, use it or do whatever you feel like.
I would, however, appreciate donations in any form and/or shape (even postcards and emails). These donations would be considered as supporting the myAdmin project.
My Address is:
Hillware I/S Dennis Thrys°e Solvangsvej 6, st, th DK-9000 Aalborg <qabi@mindless.com> http://members.xoom.com/qabi/
Although the program is freeware it is:
Copyright « 1999 by Hillware I/S, Dennis Thrysøe
|
The Treeview in the upper left part of the myAdmin window shows some objects in a hieracical view. Theese objects include hosts, databases, tables and fields.
The hosts can be created, edited and deleted either by using the menu-commands in the Hosts menu or by using the buttons in the toolbar. Editing a host and viewing it's properties is the same thing.
In the Properties view for a host there are also some information about the host's current status, and which clients are running on it at the moment. There is also a button for refreshing the server's grant information.
The information about the hosts is saved in the registry for use the next time myAdmin is used.
|
When a host that is not yet connected to is selected, it can be connected to with the Connect button, or the menu-item 'Connect'.
Connecting to a host will cause it to show all it's databases including tables and fields in the treeview. A connected host can be disconnected again.
More than one host can be connected to at the same time. Any queries/actions will be performed on the host which is selected.
|
To execute an SQL query, just type it into the edit box on in the upper right part of the window. Use the Query button, or the Query menu to execute the query. F12 and ALT-Q can also be used to execute the query.
The query edit-box can be saved to a file, or loaded from a file with the buttons in the tool-bar.
|
When a query returns a result set, it will be shown in the bottom part of the window, along with a summary (number of fields, number of rows or number of affected rows).
If desired, the result can be viewed in a maximized window by double-clicking the result table, or using the tool-bar button.
The result can be exported be clicking the appropriate tool-bar button or the menu-item. It can be exported either as a comma-seperated text file (optional header / selectable seperation char) or as SQL INSERT statements. The latter will produce a text file containing one INSERT statement for each row in the result. This can for instance be used to insert these rows into another database somewhere else.
|
It is possible to import or export SQL statements to/from myAdmin.
It is also possible to export a result from a query either as a comma-seperated text file or as SQL INSERT statements.
|
It shouldn't be a secret that I'm somewhat inspired by David B. Mansels
I also had some use for Blestan Tabakov's
Thanks to Baltic Solutions for making ColorEdit, the component that does the syntax highlighting.
Also, thanks to TCX DataKonsult AB (especially Monty) for helping me out. (And releasing mySQL!).
|
myAdmin 1.0.1.0
-------------------------
Another version. Some new features, and this time I remembered
updating the version string in the program :)
Bugfixes:
* Clicking in the treeview whitespace caused a GPF.
* Problems with reading from registry sometimes.
New features:
* Syntax highlighting in the SQL-edit box. Static colors. The
reserved words from the mySQL manual are all highlighted blue.
Comments are recognized (# and /* ... */) and most symbols
are red. (Let me know if you have more.
* Option to show number of milliseconds for performing and
retrieving query.
To do in coming versions:
* Add tabbed edit-boxes. Edit more than one query at the time.
myAdmin 1.0.0.4
-------------------------
Another version with some bugfixes and a few new features.
Bugfixes:
* Now constructs tree correctly when a database (which
is not the first in the list) doesn't allow listing its tables.
New features:
* Quicker (right-click menu) access to see all data in a table or
all data for a given field.
* Drop-down combo box that shows the cached queries.
* The window's position, state and size is now saved in the
Registry, and reloaded automatically.
To do in coming versions:
* Add tabbed edit-boxes. Edit more than one query at the time.
myAdmin 1.0.0.0
-------------------------
Finally! The Final version. This version haven't been tested
as much as I would have liked, as I don't have the equipment
and rescources to do that.
Instead I will release bugfixes as soon as I can get a chance
to fix any reported bugs.
New features:
* Entirely new model between libmysql.dll and the GUI.
This may have introduced some new bugs - we'll see.
* Now also connects to databases that disallows certain
operations (such as listing tables)
* Improved performance on connecting. The fields are listed much faster.
* Batch queries should now work. Just end your statements with a
semicolon ';'.
myAdmin 1.0.0.990124
-------------------------
Another prerelease.
New features:
* libmysql.dll is included in the zip. Courtesy of
TCX DataKonsult AB.
* Server statistics shown in the properties window.
* Option to refresh grants
* Export the results to a comma-seperated file or as
SQL INSERT statements
* Save/load the current statement to/from a file
* HTML manual included
* Change cursor during blocking tasks
myAdmin 1.0.0.990121
-------------------------
Another prerelease.
New features:
* Fields are added to the treeview for all tables
* Create and delete databases
Known issues:
* Change cursor while connecting (How?)
myAdmin 1.0.0.990120
-------------------------
Another prerelease.
New features:
* Ability to show the result in a bigger window on it's own.
Double click the result table, or user menu/button.
* See previous queries (and go back forward again) using buttons
* Create and drop databases
* Run cueries with databases/tables selected
* Drag & Drop a table to the query editing area. Or doubleclick
the table in the TreeView
Known issues:
* Retrieve field info to tree (mysql_list_fields returns a RES with 0 rows)
* Change cursor while connecting (How?)
myAdmin 1.0.0.990119
-------------------------
(only the zip has this version number, the program still has the older
version number 1.0.0.990118).
Second prerelease. More functions but
still quite unstable and errorprone.
Known problems:
* Run query while database, table or field selected in treeview
* Change cursor while connecting (How?)
* Retrieve field info to tree
(mysql_list_fields returns a RES with 0 rows)
* Somewhat slow update on query
myAdmin 1.0.0.990118
-------------------------
First prerelease. Purposely very unstable.
|
|