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.
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
Help,
I get this configuration error when trying to configure mysql.
Any solutions.
Greg Robillard
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
. 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.
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...
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
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
...
Greg
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
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
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
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
---
> 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
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
---
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
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
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
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
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,
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
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
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
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/
>
> ---
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
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 &
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
>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
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
ver runs Linux.
>
> Signed,
> Screwed
> _
> Get your FREE download of MSN Explorer at http://explorer.msn.com
^
No thanks.
Greg.
>
>
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:/
' -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
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
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
t session! :)
MysqlTool
Looks pretty good
http://dajoba.com/projects/mysqltool/
Greg
>
> TIA,
>
> Mickalo
>
> Mike(mickalo)Blezien
>
> Thunder Rain Internet Publishing
> Providing Internet Solution
lems !
Thanks again for your help.
Greg
>
> Regards,
>
> Sinisa
>
> __ _ _ ___ == MySQL AB
> /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
> /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
>/*/ /
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
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)
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-
; | 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
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
>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
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
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
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
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
> >
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]
>
> --
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:
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
>
>
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
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
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
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://
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
;-)
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|
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 :)
>
> -
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!
> |_
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 ?
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.
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
-
.
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
301 - 361 of 361 matches
Mail list logo