1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110
|
*************************************************************************
XmySQL (c) Rick Mehalick 1997,1998
Version 1.8
*************************************************************************
XmySQL is a front end to the MySQL database engine. It allows for
simple queries and table maintenance, as well as batch queries.
XmySQL has been compiled and tested on Linux 2.0.0
with MySQL 3.21.23b and Xforms version 0.88. The Makefile should need
very little modification, but I can't make any promises.
What you need to compile XmySQL:
Xforms at: http://bloch.phys.uwm.edu/xforms
MySQL at : http://www.tcx.se
Xpm : ftp://avahi.inria.fr/pub/xpm
License Notification:
You or your business may freely use XmySQL as it is covered under
the GNU GENERAL PUBLIC LICENSE.
NOTE: If you modify the source please let me know so that I can add
your modifications into the base code.
To use XmySQL:
- unzip the file: gzip -d xmysql-?.?.tar.gz
- untar the tar file: tar -xvf xmysql-?.?.tar
- copy Makefile: cp Makefile.Linux Makefile
NOTE set the INSTALLPATH in the Makefile
NOTE set the XMYSQL_XPMPATH in the Makefile
NOTE set the XMYSQL_HELPPATH in the Makefile
- compile XmySQL: make
- run XmySQL: xmysql
[-host host] [-user usr -password pw] [-port] [-socket] [-qlimit #]
NOTE: If you get a nasty message about all colors being used when you
start xmysql, try adding -shared, -stdcmap, or -private to the
command line of xmysql. These are options passed into Xforms
so that color support can be better. I have a report from one
user that -shared has worked for him.
ex: xmysql -shared
***** Starting with version 1.7, only source versions of XmySQL will
be available. I no longer have access to any platforms except
Linux. You can change the location of the help file and xpm file
(after the compile or if you are given a binary) by creating and
setting environment variables for XMYSQL_XPMPATH
and XMYSQL_HELPPATH.
For example: (assuming csh)
setenv XMYSQL_XPMPATH /usr/local/xmysql-1.8
setenv XMYSQL_HELPPATH /usr/local/xmysql-1.8
For example: (assuming bash)
export XMYSQL_XPMPATH=/usr/local/xmysql-1.8
export XMYSQL_HELPPATH=/usr/local/xmysql-1.8
Problem Areas:
Most users report problems with XmySQL connecting to the MySQL server.
If this happens to you, here are some tips to follow:
1) Can you connect with the command line mysql tool?
Double check permissions in the db, host, and user tables.
2) Try starting XmySQL with -host localhost
3) Supply a -port and -socket option to XmySQL to match any
given to the MySQL server, otherwise the default
3306 port number and /tmp/mysql.sock socket path will be used.
Bug Reporting:
Please send me details of your problem using the MySQL program
'mysqlbug' which can be found in the bin directory of the MySQL
installation. This information will tell me about your working
environment and connection options. I may also ask for a sample
database illustrating the problem you are seeing with XmySQL,
but don't send one before I ask; we don't want to increase net
traffic unless we have to.
Disclaimer:
This program is in ongoing development, thus it can have problems (bugs)
which I will correct as soon as I am aware of them and have time. I
assume no responsibility for loss of data or problems associated
with the supporting programs (Xforms, MySQL and other software)
that may occur.
I reserve the copyright to XmySQL. However, you are permitted to
distribute XmySQL, provided that you (a) distribute it with the
full sources, and (b) that you leave all documentation and
copyright notices intact.
Caution:
I have included the Xforms Xmysql.fd file in this release,
but don't use it without first copying it to a temporary
directory and using fdesign from there, otherwise a "save"
from fdesign will mess things up. The reason is that I
modified the fdesign generated files. I know, I know,
bad idea, but anyway, you've been warned.
FINAL NOTE:
Take a look at the CHANGES file for more information. I use it
like an update to the user guide.
Rick Mehalick
dblhack@wt.net
http://web.wt.net/~dblhack
12018 Villa Lea
Houston, TX 77071
|