Parameterized and spatial data

2001-06-07 Thread Greg Liapis
Hi all, this is probably a silly question, but as I am a student who wants to use MySQL for a project, I would like to know if MySQL supports parameterized tables and if supports spatial data. Thanks.

Re: $dbh->tables, SHOW tables, etc.

2001-05-26 Thread Greg Cope
the .src.rpm. > Both show tables, show databases now work. > I come across this problem - and its complier / optimisations related. gcc 2.92.3 + pgcc patches works OK for me. 2.92.3 plus optimisations is can fail. YMMY - but ditch 2.96 until its safe ! Greg > Thanks for th

No Curses/termcap library found

2001-05-24 Thread Greg Robillard
Help, I get this configuration error when trying to configure mysql. Any solutions. Greg Robillard

unlocking read only table

2001-05-16 Thread Greg
One of the tables of my database suddently became read-only; when I try to add a line, I get: ERROR 1036: Table 'Requests' is read only I'm alone working on this table, and didn't lock it. Does anyone know how I can unlock th

Re: ODBC for MySql with SSL

2001-05-13 Thread Greg Cope
. I personally do not know about ODBC driver and when > this will be coded to use SSL. Anyway this can't be done before MySQL > itself is ready for this. > Will this code be used by the replication slave code ? Ie.

Database Error

2001-05-08 Thread Greg Cardoza
Good Day: Could someone help me and tell me which direction to go to see why I'm getting unknown database error caught by the SQLException catch. I checked to make sure that the Class.forName was being executed and it was. Just need a little helping hand. Thanks...

MyODBC General Question

2001-05-08 Thread Greg Cardoza
Good Day: I was just wondering, if I'm using mm.mysql.jdbc-1.2c to connect to a database w/JAVA do I also need MyODBC installed and configured also? Or is mm.mysql.jdbc-1.2c all I need? Thanks alot.. Greg __ Do You Yahoo!? Yahoo! Auc

Database Connection

2001-05-07 Thread Greg Cardoza
t to a database. Thanks a bunch... Greg __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ - Before posting, please

JDBC Connection

2001-05-05 Thread Greg Cardoza
... Greg

Re: Rolling back of a transaction

2001-05-03 Thread Greg Cope
can suggest > MySql or not for developing the engine using EJB with JTA to my > organization. > RTFM specifically DBD, Inobase, and Gemini. It amazes me that people withh start / think about product developement, without reading the (in this case excellent) manual. Greg > Thanks &a

__tz problem in sys/time.h

2001-04-12 Thread Greg Berry
else. SO, in the mysql-3.23.36 source directory, in include/global.h, if you define __USE_GNU before the lines to include sys/time.h, #define __USE_GNU the compilation runs smoothly, with no more problems. Thank you, Greg Submitter-Id: none Originator:Gregory Berry Organization: none

Re: Speed and Hardware

2001-04-05 Thread Greg Cope
server - in 90% of cases like this people claim thier sites are dynamic, yet very little is realtime, and alot can be cached locally. Can you cache any data locally, even if the cache is refreshed every minute or 5 minutes it may save alot of hits on the DB, yet your users may never know the differ

Help!! New Win32 mySQL User

2001-04-02 Thread Greg Miller
quot;, but the NT Command Processor just hangs when I issue this command. Now I have this thing so messed up, that I cannot log into the server at all except locally. What am I doing wrong??? Thanks! Greg Miller, IS/Development SantaPlus ---

RE: multiple instances and initial password

2001-03-30 Thread Greg Donald
> Two things that I am sure will be answered very quickly. > > 1) I have a development box that I have successfully installed and > configured 3 seperate instances. Each instances has its own port > number. > When playing around with mysqladmin I know I can specify the port > number as > an opti

New MySQL user - Problems connecting

2001-03-29 Thread Greg Miller
quot;, but the NT Command Processor just hangs when I issue this command. Now I have this thing so messed up, that I cannot log into the server at all except locally. What am I doing wrong??? Thanks! Greg Miller, IS/Development SantaPlus ---

MYSQL and Solaris.

2001-03-29 Thread Greg Wejrowski
on a sparc system runing Solairs 2.6. If so could you give details as what software you used to compile the native. Which version of complier and which version of mysql source code was used.. Thanks V/R Greg Wejrwoski - Befo

Can not install on Solaris 2.6

2001-03-28 Thread Greg Wejrowski
ibcrypt_1.so.1: open failed: No such file or directory. How do I fix this.. V/R Greg Wejrowski (wedge) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (t

solaris 2.6 install problem

2001-03-27 Thread Greg Wejrowski
ile called libcrypt_i.so.1, but I can find a file called libcrypt_i.a in the /usr/lib directory.. I installed mysql in x86 linux box with little problem. Any help would be appreciated.. V/R Greg Wejrowski (wedge) - Before posti

Re: Innobase in MySQL

2001-03-18 Thread Greg Cope
Peter Zaitsev wrote: > > Hello Greg, > > Saturday, March 17, 2001, 3:31:53 AM, you wrote: > > GC> It would be very handy if Innobase (and the GEMINI when it comes along) > GC> where to support mysqldump in the standard way, as I assume it works as > GC> such an

Install Help... re: RPM

2001-03-17 Thread Greg C. Pauley, PDQ
I have recently installed MySQL-server-version-3.23.35.rpm on my cobalt raq4... The install documents state that the rpm will install into the /var/lib folder... I ran the install but can't seen to locate where the files were installed? Any help is appreciated. Thanks,

Re: Innobase in MySQL

2001-03-16 Thread Greg Cope
when it comes along) where to support mysqldump in the standard way, as I assume it works as such and I and many others would have to change thier backup scripts. Delayed index creation is very usefull (in saving time) in larger DB loads via a mysqldump - Hiekki is this difficult ? Thanks all for you

Re: MySQL 3.23.35 is released

2001-03-16 Thread Greg Cope
Michael Widenius wrote: > > Hi! > > > Greg> On the off chance any ideas when this (A Gemini THandler) 3.23.x release > Greg> may be and when we might see a public 4.x alpha. I know the answer will > Greg> probably be "When its ready" but a small clue

Re: MySQL 3.23.35 is released

2001-03-16 Thread Greg Cope
th the Gemini Table handler is moved to a .3x release as would seem the case ? On the off chance any ideas when this (A Gemini THandler) 3.23.x release may be and when we might see a public 4.x alpha. I know the answer w

Re: Mysql directory

2001-03-12 Thread Greg Cope
rsion to due to an unforseen problem then I just restart the old one. Greg > > __ > Do You Yahoo!? > Yahoo! Auctions - Buy the things you want at great prices. > http://auctions.yahoo.com/ > > ---

show tables bug - minor update

2001-03-12 Thread Greg Cope
lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release). Now all I need to do is find some Ok flags for egc ! regards Greg - Before posting, please check: http://www.mys

More show databases / tables bug news ...

2001-03-12 Thread Greg Cope
weird. Greg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail &

Re: Poddible SHOW DATABASE || TABLE bug in 3.23.33

2001-03-08 Thread Greg Cope
his being a possible glibc issue ? Greg > >Description: > SHOW DATABASE and SHOW TABLES and mysqlshow all return empty lists (i.e a nice list >of blanks - no of blank lines > equals number of databases / tables) > > >How-To-Repeat: > Do a mysqlshow or SHOW D

Poddible SHOW DATABASE || TABLE bug in 3.23.33

2001-03-08 Thread greg
>Description: SHOW DATABASE and SHOW TABLES and mysqlshow all return empty lists (i.e a nice list of blanks - no of blank lines equals number of databases / tables) >How-To-Repeat: Do a mysqlshow or SHOW DATABASES under mysql >Fix: >Submitter-Id: >Originator:Greg Cop

Improving MySQL installation in ApacheToolbox - RFC

2001-03-08 Thread Greg Cope
places. This is not supposed to be a mysql installer - if you don't want to complie from source then use the binaries or RPMS. What this is supposed to be is an improvement to the way apachetoolbox deals with mysql. Thats all. Co

Re: Dropped wrong DB. Can I recover?

2001-03-08 Thread Greg Cope
ver runs Linux. > > Signed, > Screwed > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com ^ No thanks. Greg. > >

Re: show databases|tables problem

2001-03-07 Thread Greg Cope
d Suse (both have been upgraded from errata). Thanks Paul. Greg > > -- > Paul DuBois, [EMAIL PROTECTED] > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http:/

Re: Bug with 'show databases|tables'

2001-03-07 Thread Greg Cope
' -O6 > -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' > Another common moment is on RH 6.2 I compiled it with egcs and libstdc++ was > not installed. If this helps my problems are on: Redhat 6.2 I've libstdc++-2.9.0-30 and it has th

Re: Bug with 'show databases|tables'

2001-03-07 Thread Greg Cope
The compiler >requirements are explained in the Manual. This is not a complier bug! > > Rather use the binary RPM's supplied by MySQL team. Or downgrade to Redhat 6.2 if >you want a stable system. I don't think 7.0 is ready for real production work. The same

Re: Bug with 'show databases|tables'

2001-03-07 Thread Greg Cope
10 Mar 6 00:23 /usr/lib/libc-client.a -> >c-client.a > Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static >--with-client-ldflags=-all-static --with-charset=koi8_ru --enable-assembler >--with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/m

Re: phpMyAdmin equivalent

2001-03-05 Thread Greg Cope
t session! :) MysqlTool Looks pretty good http://dajoba.com/projects/mysqltool/ Greg > > TIA, > > Mickalo > > Mike(mickalo)Blezien > > Thunder Rain Internet Publishing > Providing Internet Solution

Re: Problems with SHOW DATABASES / TABLES

2001-02-28 Thread Greg Cope
lems ! Thanks again for your help. Greg > > Regards, > > Sinisa > > __ _ _ ___ == MySQL AB > /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic > /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] >/*/ /

Re: Problems with SHOW DATABASES / TABLES

2001-02-27 Thread Greg Cope
23.33 reacts differently than 3.23.32 when it comes to SHOW ! > > - Usage of --safe-show-... options in 3.23.33 nope. > > - Usage of untested kernels Linux 2.2.17 Should be ok (Redhat errata upgrade for 6.2) Sinisa I do appreciate your help, but I still

Please help, I need JAVA code....

2001-02-18 Thread Greg Cardoza
hat's it for now and thanks to anyone who can help me. Please respond to this e-mail or send a new copy to [EMAIL PROTECTED] Thanks a bunch Greg - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: Possible SHOW DATABASE || TABLE bug in 3.23.33

2001-02-16 Thread Greg Cope
Sinisa Milivojevic wrote: > > Greg Cope writes: > > >Description: > > SHOW DATABASE and SHOW TABLES and mysqlshow all return empty lists (i.e > > a nice list of blanks - no of blank lines > > equals number of databases / tables) > > > > >How-

Re: show database does not work ;-(

2001-02-16 Thread Greg Cope
; | test | > +--+ > 2 rows in set (0.02 sec) > > I'm using Mandrake 7.2. > I installed using the RPM > MySQL-3.23.33-1.i386.rpm Thanks Not much help to me mind ... Thanks again ;-( Greg - Befo

Re: show database does not work ;-(

2001-02-16 Thread Greg Cope
Fred van Engen wrote: > > On Fri, Feb 16, 2001 at 02:18:11PM +, Greg Cope wrote: > > Dear All > > > > I've just installed mysql on a new host (3.23.33) and show databases > > does not work ;-(. > > > > Maybe it would help to read (or search) th

Possible SHOW DATABASE || TABLE bug in 3.23.33

2001-02-16 Thread Greg Cope
>Description: SHOW DATABASE and SHOW TABLES and mysqlshow all return empty lists (i.e a nice list of blanks - no of blank lines equals number of databases / tables) >How-To-Repeat: Do a mysqlshow or SHOW DATABASES under mysql in version 3.23.33 >Fix: >Submitter-Id: >Originato

Re: show database does not work ;-(

2001-02-16 Thread Greg Cope
ws in set (0.01 sec) Are you using 3.23.33 ? Greg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PR

show database does not work ;-(

2001-02-16 Thread Greg Cope
very wrong that must be obvious ? A rather dazed and confused, Greg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thre

Matching escaped characters

2001-02-08 Thread Greg Ederer
I have a data item (stored as a varchar) that looks like this: Mel\'nikova fieldname='Mel\'nikova' doesn't match it. Neither does fieldname='Mel\\\'nikova'. fieldname='Mel%nikova' does produce a match, and so does fieldname='Mel__nikova' (which leads me to believe that mysql treats \' as

Re: Should I switch to SCSI HD for mysql?

2001-02-08 Thread Greg Cope
Dave Hodgkinson wrote: > > "mike thomas" <[EMAIL PROTECTED]> writes: > > > Greg, > > > > Well, I'm doing like "%stuff%" selects on a single column table > > with 20 million records, so any speed gain would be greatWould > >

Re: Should I switch to SCSI HD for mysql?

2001-02-07 Thread Greg Cope
e atleast two IIRC from the manual - which has a section on Disk performance. If you are serious about performance go SCSI. Greg > > Thanks everyone! > > Michael Thomas > abcXyz.com > [EMAIL PROTECTED] > > --

Multiple defs of strtol.o (was RE: Mysql/DBD Error)

2001-02-06 Thread Greg
brary/Frameworks/System.framework/Versions/B/System(strtol.o) definition of _strtol /Local/Library/Perl/darwin/auto/DBD/mysql/mysql.bundle definition of _strtol PLEEEAAASE help me!!! Greg - Before posting, please check:

Re: MySQL NT Service Question

2001-02-04 Thread Greg Cope
few locking issues and is designed for a multiuser environment, something which access was not. As an aside 128 meg of RAM is not alot for a W2k server - RAM being cheap you may wish to upgrade it. Greg > Lee Jenkins > >

Selecting rows with same data in all fields except one

2001-02-02 Thread Greg Skouby
the different values in the last column of just one row. What would the syntax be to grab all the rows that have identical data in the first 4 columns? I know this is pretty trivial but everthing I try seems to be wrong. Thanks for your help. Greg

mysqladmin shutdown timeout

2001-02-02 Thread Greg
I can run mysqld by the book on MacOS X but trying to shut it down with "mysqladmin -u root -p shutdown" timeout after a long time, leave the daemon running... What can I do ? TIA Greg - Before posting, please chec

mysql/DBD on Darwin/mosx

2001-02-02 Thread Greg
System(strtol.o) definition of _strtol ../blib/arch/auto/DBD/mysql/mysql.bundle definition of _strtol I wasn't able to find any reference to "_strol" in the sources, what's going on??? TIA Greg - Before posting

mysql on a locked media on windoze?

2001-02-02 Thread Greg
le to merge both client and server into a huge binary, or may the server can run run as a "side-application"? TIA Greg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://

mysqlgui compile error

2001-02-01 Thread greg . kurzawa . b
Hello, I've run into some difficulty compiling mysqlgui-1.7.4 on RedHat 6.2. I am using gcc 2.95.2, which I have recently compiled installed to /opt/gcc. After running make, I receive the following error: g++ -o mysqlgui about.o db_tree.o Fl_NSlider.o getvars.o qsort.o queries.o bebac.o main.o d

Patch to add restart to mysql.server rc start script

2001-01-25 Thread Greg Cope
;-) Greg --- mysql.server.sh.bak Thu Jan 25 15:23:38 2001 +++ mysql.server.sh Thu Jan 25 15:29:50 2001 @@ -147,9 +147,14 @@ fi ;; + 'restart') +$0 stop +$0 start +;; + *) # usage -echo "usage: $0 start|stop" +echo "usage: $0 start|

Re: Inheritance

2001-01-23 Thread Greg Cope
outline what it can and cannot do. If you want to use MySQL in this area you will have to implement your own OO -> RDBMS translation etc ... It is not an OO DBMS. Hope that helps. Greg > > Any information would be useful. > > Thanks :) > > -

Re: 3.23.21 + DB 3.2.3h

2001-01-21 Thread Greg Cope
replace 'DB_VERSION_STRING.*g' 'DB_VERSION_STRING.*h' -- configure That should do the trick. Greg > > AMK4 > > -- > H | Hi, I'm currently out of my mind. Please leave a message. BP! > |_

Re: MySQL 3.23.31 configure fails with Berkeley DB 3.2.3h

2001-01-19 Thread Greg Cope
on $db_major.$db_minor.$db_patch" > -bdb_version_ok="$bdb_version_ok (must be at least version 3.2.3g)" > +bdb_version_ok="$bdb_version_ok (must be least version 3.2.3h)" >fi > ]) > Thanks for that. But does the conspiricy not continue ?

Re: MySQL 3.23.31 configure fails with Berkeley DB 3.2.3h

2001-01-19 Thread Greg Cope
Matt Wagner wrote: > > Greg Cope writes: > > Chris Johnson wrote: > > > > > > >Description: > > > I just downloaded MySQL 3.23.31 and the "patched version" of > > > Berkeley DB 3.2.3h from the www.mysql.com site.

Re: MySQL 3.23.31 configure fails with Berkeley DB 3.2.3h

2001-01-18 Thread Greg Cope
me I don't have the proper version of the DB. Here are the last > few lines from the configure output: This sounds similar to a problem that I reported a few hours ago to this list. Monty, MySQL dev team, any ideas ? Greg -

can't get mysql-3.23.31 to cofigure with berkeleydb support ?

2001-01-18 Thread Greg Cope
. What am I doing wrong ? Greg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> T

<    1   2   3   4