RE: Fulltext search of words < 3 chars in 3.23

[JamesD]

thanks Mike,
I think i'll go climb another learning curve :-)
...

Jim

-Original Message-
From: Mike Hillyer [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 28, 2002 9:49 PM
To: JamesD; Frank Peavy; [EMAIL PROTECTED]
Subject: RE: Fulltext search of words < 3 chars in 3.23


He wants to execute a FULLTEXT search as opposed to a simple LIKE statement,
so I think REGEXP is out of the question.

Mike Hillyer


-Original Message-
From: JamesD [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 28, 2002 10:48 PM
To: Frank Peavy; [EMAIL PROTECTED]
Subject: RE: Fulltext search of words < 3 chars in 3.23


You need to use the REGEXP capability instead of "Like" in a where clause

select 'field(s)' from 'table' where 'field' REGEXP '^[a-z]{1,3}$';

Jim

-Original Message-
From: Frank Peavy [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 28, 2002 6:55 PM
To: [EMAIL PROTECTED]
Subject: Fulltext search of words < 3 chars in 3.23


Does anyone have a method of performing fulltext searches on words less
than 3 characters on MySql 3.23? I am dealing with a web hosting company so
a re-compile is out of the question.

Anyone have any good suggestions? I need to perform searches on acronyms
like "php".
Thanks.


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Fulltext search of words < 3 chars in 3.23

[Mike Hillyer]

He wants to execute a FULLTEXT search as opposed to a simple LIKE statement,
so I think REGEXP is out of the question.

Mike Hillyer


-Original Message-
From: JamesD [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 28, 2002 10:48 PM
To: Frank Peavy; [EMAIL PROTECTED]
Subject: RE: Fulltext search of words < 3 chars in 3.23


You need to use the REGEXP capability instead of "Like" in a where clause

select 'field(s)' from 'table' where 'field' REGEXP '^[a-z]{1,3}$';

Jim

-Original Message-
From: Frank Peavy [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 28, 2002 6:55 PM
To: [EMAIL PROTECTED]
Subject: Fulltext search of words < 3 chars in 3.23


Does anyone have a method of performing fulltext searches on words less
than 3 characters on MySql 3.23? I am dealing with a web hosting company so
a re-compile is out of the question.

Anyone have any good suggestions? I need to perform searches on acronyms
like "php".
Thanks.


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Fulltext search of words < 3 chars in 3.23

[JamesD]

in sql use perl regular expression:

select 'field(s)' from 'table' where 'field' REGEXP '^[a-z]{1,2}$';

Jim

-Original Message-
From: JamesD [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 28, 2002 9:48 PM
To: Frank Peavy; [EMAIL PROTECTED]
Subject: RE: Fulltext search of words < 3 chars in 3.23


You need to use the REGEXP capability instead of "Like" in a where clause

select 'field(s)' from 'table' where 'field' REGEXP '^[a-z]{1,3}$';

Jim

-Original Message-
From: Frank Peavy [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 28, 2002 6:55 PM
To: [EMAIL PROTECTED]
Subject: Fulltext search of words < 3 chars in 3.23


Does anyone have a method of performing fulltext searches on words less
than 3 characters on MySql 3.23? I am dealing with a web hosting company so
a re-compile is out of the question.

Anyone have any good suggestions? I need to perform searches on acronyms
like "php".
Thanks.


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Fulltext search of words < 3 chars in 3.23

[JamesD]

You need to use the REGEXP capability instead of "Like" in a where clause

select 'field(s)' from 'table' where 'field' REGEXP '^[a-z]{1,3}$';

Jim

-Original Message-
From: Frank Peavy [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 28, 2002 6:55 PM
To: [EMAIL PROTECTED]
Subject: Fulltext search of words < 3 chars in 3.23


Does anyone have a method of performing fulltext searches on words less
than 3 characters on MySql 3.23? I am dealing with a web hosting company so
a re-compile is out of the question.

Anyone have any good suggestions? I need to perform searches on acronyms
like "php".
Thanks.


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Fulltext search of words < 3 chars in 3.23

[Mike Hillyer]

I would think that using the fulltext search IN BOOLEAN MODE would return
results of any length, even 3 characters or less, check the bottom of
http://www.mysql.com/doc/en/Fulltext_Search.html for examples on using
boolean mode.

Mike Hillyer


-Original Message-
From: Frank Peavy [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 28, 2002 7:55 PM
To: [EMAIL PROTECTED]
Subject: Fulltext search of words < 3 chars in 3.23


Does anyone have a method of performing fulltext searches on words less
than 3 characters on MySql 3.23? I am dealing with a web hosting company so
a re-compile is out of the question.

Anyone have any good suggestions? I need to perform searches on acronyms
like "php".
Thanks.


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Moving a database accross a platform

[Andreas]

Benjamin Pflugmann wrote:


Look up mysqldump and mysql in the manual. You want to do something
like this:

targethost$ mysqladmin create new_database
targethost$ mysqldump -h oldhost some_database | mysql new_database


at least if he hasn't used innodb with foreign keys

AFAIK mysqldump is not clever enough to dump the tables in the right
order so that referential integrity doesn't stop the reimport of the data

or maybe I'm to stupid to make it do it the right way




-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL 4.0.7 is released

[Andreas]

Hsiao Ketung Contr 61 CS/SCBN wrote:


Does each version of MySql has binary AND src version for installation ?


yes



I found binary version only.


look again
it's on the bottom of the page



Does the majority of MySql user us the binary version ?


dunno ... but it works, so why bother ?



Who would have the need to use src version of installation.
I imagine that src version give user more options for customizing MySql.


sure ... but do you feel anythig lacking ?



-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: JDBC driver / JBoss

[miguel solórzano]

At 11:57 29/12/2002 +1100, Greg Matthews wrote:
Hi,


If anyone has managed to get named pipes working under Windows XP with
JBoss, would they be nice enough to forward the URL used?


Only one note here: MySQL by default disables the named pipes.
If you want the named pipes you must use at command prompt or
in your configuration file the user variable:

--enable-named-pipe


--
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Miguel Angel Solórzano <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   São Paulo - Brazil
   <___/   www.mysql.com 


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Fulltext search of words < 3 chars in 3.23

[Frank Peavy]

Does anyone have a method of performing fulltext searches on words less 
than 3 characters on MySql 3.23? I am dealing with a web hosting company so 
a re-compile is out of the question.

Anyone have any good suggestions? I need to perform searches on acronyms 
like "php".
Thanks.


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

PR: Linux binaries built for glibc 2.0 don't work on RedHat betas with lastest glibc

[Bernardo Innocenti]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

>Description:
Most Linux binaries available from mysql.com are compiled to work with glibc 
versions as old as 2.0,
but the latest glibc 2.3.2 shipped by RedHat has apparently dropped support 
for 2.0 symbols.
This is what you get from mysqlcc:

 ./mysqlcc: relocation error: ./mysqlcc: symbol errno, version GLIBC_2.0 not 
defined in
   file libc.so.6 with link time reference

>How-To-Repeat:
Install RH 8.1.92 (Phoebe) or RawHide and run mysqlcc or try using libmysql.so 
shipped
with MySQL 4.0.7 RPM binaries.
>Fix:
Recompile on a system with glibc 2.1 or higher.

>Originator:Bernardo Innocenti <[EMAIL PROTECTED]>
>MySQL support: none
>Synopsis:  MySQL binaries built for glibc 2.0 don't work with latest glibc 2.3.2
>Severity:  serious
>Priority:  medium
>Category:  mysql
>Class: sw-bug
>Release:   mysql-3.23.54 (Source distribution)

>Environment:
System: Linux beetle.trilan 2.4.20-2.2custom #3 Thu Dec 26 19:04:19 CET 2002 i686 
athlon i386 GNU/Linux
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2.1/specs
Configured with: ../configure --prefix=/usr --mandir=/usr/share/man 
--infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking 
--with-system-zlib --enable-__cxa_atexit --host=i386-redhat-linux
Thread model: posix
gcc version 3.2.1 20021207 (Red Hat Linux 8.0 3.2.1-2)
Compilation info: CC='i386-redhat-linux-gcc'  CFLAGS='-O2 -march=i386 -mcpu=i686 -g 
-D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE'  CXX='i386-redhat-linux-g++' 
 CXXFLAGS='-O2 -march=i386 -mcpu=i686 -g -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 
-D_LARGEFILE_SOURCE -fno-rtti -fno-exceptions'  LDFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   13 Dec 28 08:52 /lib/libc.so.6 -> libc-2.3.1.so
- -rwxr-xr-x1 root root  1226072 Dec 19 12:41 /lib/libc-2.3.1.so
- -rw-r--r--1 root root  2231738 Dec 19 11:44 /usr/lib/libc.a
- -rw-r--r--1 root root  204 Dec 19 11:35 /usr/lib/libc.so
Configure command: ./configure '--host=i386-redhat-linux' '--build=i386-redhat-linux' 
'--target=i386-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr' 
'--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' 
'--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib' 
'--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/usr/com' 
'--mandir=/usr/share/man' '--infodir=/usr/share/info' '--without-readline' 
'--without-debug' '--enable-shared' '--with-extra-charsets=complex' '--with-bench' 
'--localstatedir=/var/lib/mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' 
'--with-mysqld-user=mysql' '--with-extra-charsets=all' '--with-innodb' 
'--enable-local-infile' '--enable-large-files=yes' '--enable-largefile=yes' 
'--with-berkeley-db-includes=/usr/include' '--with-berkeley-db-libs=/usr/lib' 
'--with-thread-safe-client' 'CFLAGS=-O2 -march=i386 -mcpu=i686 -g -D_GNU_SOURCE 
-D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' 'CXXFLAGS=-O2 -march=i386 -mcpu=i686 -g 
-D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-rtti -fno-exceptions' 
'build_alias=i386-redhat-linux' 'host_alias=i386-redhat-linux' 
'target_alias=i386-redhat-linux-gnu'

- -- 
  // Bernardo Innocenti - Develer S.r.l., R&D dept.
\X/  http://www.develer.com/
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE+DlpBltU4TfxqZsoRAnCrAJ4kcmiOFDTUW3Bt18Z4pXyj0fINxQCeMZwA
rvWHfVuUEWdWbF4ZqwWMv5Q=
=Nhdd
-END PGP SIGNATURE-


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: JDBC driver / JBoss

[Mark Matthews]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Greg Matthews wrote:

Mark,

Version was 3.51.05.


Hmmm, that looks like an ODBC driver version. MySQL Connector/J has two 
branches right now 2.0.x and 3.0.x, seeing as how you're using named 
pipes, you must be using 3.0.x something.

& works ok. It now seems that it might be related to me trying to use
the NamedPipeSocketFactory. When I use leave these properties out of the
datasource url everything works ok.

socketFactory=com.mysql.jdbc.NamedPipeSocketFactory
namedPipePath=/mysql/pipe


[snip]


Other variations of namedPipePath, like c:/mysql/pipe also fail, and yes,
there is a directory called c:\mysql


If you haven't changed the named-pipe path (and I doubt you have), leave 
it off. The driver will use the default. You also need to have started 
your MySQL server with --enable-named-pipe and you need to be running 
the mysqld-nt.exe or mysqld-max-nt.exe binary for your server.

See

http://www.mysql.com/doc/en/Windows_prepare_environment.html

and

http://www.mysql.com/doc/en/Windows_running.html

Any help much appreciated,

Greg.

PS. Using the standard IP-based connection (i.e. not named-pipes) seems to
kick MS Sql Servers arse in terms of speed.


That's nice to hear :) Considering that in my testing named pipes are 
even faster (at least on XP), you should look forward to great 
performance once you get everything running.

Please let me know if you need any further assistance.

Thanks, and Happy New Year!

	-Mark


- -- 
MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/

For technical support contracts, visit https://order.mysql.com/?ref=mmma

__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /  Mark Matthews <[EMAIL PROTECTED]>
  / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
 /_/  /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
<___/ www.mysql.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.1.90 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+DlRGtvXNTca6JD8RAoInAJ9WSz/9+ib44fXhIsd+WjEBZ5UfLQCfcjoo
7Vdwx5WGgZElpVV3Gz0CksA=
=Vdq/
-END PGP SIGNATURE-


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: JDBC driver / JBoss

[Greg Matthews]

Mark,

Version was 3.51.05.

& works ok. It now seems that it might be related to me trying to use
the NamedPipeSocketFactory. When I use leave these properties out of the
datasource url everything works ok.

socketFactory=com.mysql.jdbc.NamedPipeSocketFactory
namedPipePath=/mysql/pipe

If anyone has managed to get named pipes working under Windows XP with
JBoss, would they be nice enough to forward the URL used?

jdbc:mysql://localhost/activelist?socketFactory=com.
mysql.jdbc.NamedPipeSocketFactory&namedPipePath=/mysql/pipe

Other variations of namedPipePath, like c:/mysql/pipe also fail, and yes,
there is a directory called c:\mysql

Any help much appreciated,

Greg.

PS. Using the standard IP-based connection (i.e. not named-pipes) seems to
kick MS Sql Servers arse in terms of speed.


- Original Message -
From: "Mark Matthews" <[EMAIL PROTECTED]>
To: "Greg Matthews" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, December 29, 2002 11:27 AM
Subject: Re: JDBC driver / JBoss


> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Greg Matthews wrote:
> > All,
> >
> > The documention on the JDBC driver (v0.87) shows that ampersands are
used to
> > delimit driver parameters.
>
> I'm curious as to where you get a version # of '0.87'. As far as I know
> neither MM.MySQL or Connector/J has had a version # of 0.87.
>
> >
> > JBoss (www.jboss.org) stores datasource definitions in XML files, and so
> > using & seems a bit problematic.
>
> No, not really. The entity for '&' in XML is &
>
> >
> > Is there any way that the supported delimiters can be extended to use a
> > semi-colon or something that's not going to break XML?
>
> XML has an '&' character, it's & :)
>
> -Mark
>
> sql,query
> - --
> MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/
>
> For technical support contracts, visit https://order.mysql.com/?ref=mmma
>
>  __  ___ ___   __
> /  |/  /_ __/ __/ __ \/ /  Mark Matthews <[EMAIL PROTECTED]>
>/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
>   /_/  /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
>  <___/ www.mysql.com
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v1.1.90 (MingW32)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iD8DBQE+DkF+tvXNTca6JD8RAjY1AJ9TNkBvLTG7SKefDDAUw7xtvTsnrwCgwg1u
> woOKNI5bQ6P50tKEz9adMQ8=
> =d0G6
> -END PGP SIGNATURE-
>


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: JDBC driver / JBoss

[Mark Matthews]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Greg Matthews wrote:

All,

The documention on the JDBC driver (v0.87) shows that ampersands are used to
delimit driver parameters.


I'm curious as to where you get a version # of '0.87'. As far as I know 
neither MM.MySQL or Connector/J has had a version # of 0.87.


JBoss (www.jboss.org) stores datasource definitions in XML files, and so
using & seems a bit problematic.


No, not really. The entity for '&' in XML is &



Is there any way that the supported delimiters can be extended to use a
semi-colon or something that's not going to break XML?


XML has an '&' character, it's & :)

	-Mark

sql,query
- -- 
MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/

For technical support contracts, visit https://order.mysql.com/?ref=mmma

__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /  Mark Matthews <[EMAIL PROTECTED]>
  / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
 /_/  /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
<___/ www.mysql.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.1.90 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+DkF+tvXNTca6JD8RAjY1AJ9TNkBvLTG7SKefDDAUw7xtvTsnrwCgwg1u
woOKNI5bQ6P50tKEz9adMQ8=
=d0G6
-END PGP SIGNATURE-


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

JDBC driver / JBoss

[Greg Matthews]

All,

The documention on the JDBC driver (v0.87) shows that ampersands are used to
delimit driver parameters.

JBoss (www.jboss.org) stores datasource definitions in XML files, and so
using & seems a bit problematic.

Is there any way that the supported delimiters can be extended to use a
semi-colon or something that's not going to break XML?

e.g.


In JBoss, this is a problem because of the &

jdbc:mysql://dev/activelist?prop1=val1&prop2=val2

Can it be extended to allow this also...

jdbc:mysql://dev/activelist;prop1=val1;prop2=val2


Thanks,
Greg

sql,query


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: ADO Error '800a01fb'

[jumpmaster]

Michael,

My guess (and this is *only a guess*) -- for some reason one of the objects
is not being created; maybe the recordset object.  I am not sure where you
are getting that error number from (presumably in you browser) as you do not
state it.  i suggest that you check your webserver logs if you have access
to them.  They might have an extended error message which will pinpoint your
problem.

Also, you can try to 'trap' the error.  I found this tid-bit on the M$
site...


On error resume next
..
..
..
Your problem code goes here
..
..
..
if err.number <> 0 then
Response.Write err.description & "" & err.source & ""
err.clear
end if


Here is the link where I found it:
http://support.microsoft.com/default.aspx?scid=kb;en-us;299981#7


One last note...the reason I think it is your recordset object is because of
your query...You use single quotes in the wrong place.  Your strSQL variable
should be defined as follows:

strSQL = "SELECT * FROM IMAGES WHERE ID = '" & ID & "'"

Or - if ID is numeric then:

strSQL = "SELECT * FROM IMAGES WHERE ID = " & ID

HTH,
Kurt

-Original Message-
From: Michael She [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 28, 2002 6:57 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: ADO Error '800a01fb'


Hi all,

I'm getting this error with MyODBC v2.50 and v3.51.  I'm running MySQL
v4.06:

Microsoft VBScript runtime error '800a01fb'

An exception occurred: 'open'

/mshe/gallery/picture.asp, line 45


The code for that area is:

strConn = "DSN=binaryio;"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.open strConn

set rs = server.createobject("adodb.recordset")
strSQL = "SELECT * FROM IMAGES WHERE `ID` = " & ID
rs.open strSQL, objConn, 3,1,1

Nothing out of the ordinary... anyone know why I'm getting this error?
Thanks!
--
Michael She  : [EMAIL PROTECTED]
Mobile   : (519) 589-7309
WWW Homepage : http://www.binaryio.com/



-
Before posting, please check:
   http://www.mysql.com/products/myodbc/manual_toc.html (the manual)
   http://lists.mysql.com/(the list archive)

To unsubscribe, e-mail <[EMAIL PROTECTED]>
To unsubscribe from Yahoo! Groups version, e-mail
[EMAIL PROTECTED]


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: SELECT query

[Adolfo Bello]

> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]] 
> Sent: Saturday, December 28, 2002 6:44 PM
> To: Gloria L. McMillan; [EMAIL PROTECTED]
> Subject: Re: SELECT query
> 
> 
> At 14:38 -0700 12/28/02, Gloria L. McMillan wrote:
> >RE: MySQL SELECT and COUNT or SUM
> >
> >>
> >  > Hi, all!
> >>
> >>  I think this SELECT command does almost what I need.
> >>
> >>  SELECT CW03survey.Q6, CW03survey.Q7, CW03survey.Q8
> >>
> >>  FROM CW03survey
> >>
> >>  WHERE CW03survey.Q3 = '1'
> >>
> >>  =
> >>
> >>  But how can I get it to also run a count of the total of each 
> >> column?  Q6, Q7...?

Try:

SELECT CW03survey.Q6, CW03survey.Q7, CW03survey.Q8
FROM CW03survey WHERE CW03survey.Q3 = '1'
UNION 
SELECT SUM(CW03survey.Q6), SUM(CW03survey.Q7), SUM(CW03survey.Q8)
FROM CW03survey WHERE CW03survey.Q3 = '1'



-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: SELECT query

[Paul DuBois]

At 14:38 -0700 12/28/02, Gloria L. McMillan wrote:

RE: MySQL SELECT and COUNT or SUM




 > Hi, all!


 I think this SELECT command does almost what I need.

 SELECT CW03survey.Q6, CW03survey.Q7, CW03survey.Q8

 FROM CW03survey

 WHERE CW03survey.Q3 = '1'

 =

 But how can I get it to also run a count of the total of each column?
 Q6, Q7...?

 Thanks,


 > Gloria McMillan


If you mean that you want a list of items and also a count of the number
of items in the list, you cannot do it with a single query.  Lists of
items and summaries of lists of items are two different things.

-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: SELECT query

[Gloria L. McMillan]

RE: MySQL SELECT and COUNT or SUM

[EMAIL PROTECTED] wrote:

> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> sql,query,queries,smallint
>
> If you just reply to this message, and include the entire text of it in the
> reply, your reply will go through. However, you should
> first review the text of the message to make sure it has something to do
> with MySQL. Just typing the word MySQL once will be sufficient, for example.
>
> You have written the following:
>
> Hi, all!
>
> I think this SELECT command does almost what I need.
>
> SELECT CW03survey.Q6, CW03survey.Q7, CW03survey.Q8
>
> FROM CW03survey
>
> WHERE CW03survey.Q3 = '1'
>
> =
>
> But how can I get it to also run a count of the total of each column?
> Q6, Q7...?
>
> Thanks,
>
> Gloria McMillan


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: certification exam

[Stefan Hinz, iConnect \(Berlin\)]

John,

> Has anyone been successful in signing up for the certification exam?

Yes. I took the exam (still beta at that time) November 26, in Berlin,
Germany.

> I've entered dates going up to Jume 30,2003 to schedule an exam and
all
> I get back is exam not available.

The V.U.E. registration website sucks, and I reported this to the people
in charge of the certification at MySQL AB. When I tried to register, I
got similar responses like you. The responses said things like "not yet
available", "not available between 0:00 and 24:00 h", "not available
before December 30th" etc. Whatever I filled in looking for a test
centre in Berlin yielded no positive result. I find this _very_
unprofessional.

So, finally I decided to try it the good old way - by telephone. A mere
10 minutes later I had a date for the exam the following week.

What the V.U.E. person on the phone told me is nearly unbelievable. She
said that some test centers do not want their exams to be listed on the
web site, or they do not want their possible exam times to be published.
Maybe it's true that they do not want to earn money, but I cannot
believe that at all.

Sad but true: All I can suggest is, go to
http://www.vue.com/contact/mysql/, find out the telephone number and
give them a call. At least it's toll free :)

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  Geschäftsführer / CEO iConnect GmbH 
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

- Original Message -
From: "John Coder" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, December 28, 2002 12:44 AM
Subject: certification exam


> sql, query, mysql,"I'm a lumberjack and I'm ok" for he spam police.
>
>
>
> Has anyone been successful in signing up for the certification exam?
> I've entered dates going up to Jume 30,2003 to schedule an exam and
all
> I get back is exam not available.
>
> John
>
>
>
> -
> 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
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: altering data structure

[Stefan Hinz, iConnect \(Berlin\)]

David,

> I don't have a good example, but suppose I have a few tables with some
> fields each and I realize that I should make a new table with data
from
> some columns of some tables.  What to do?

Do you want to CREATE TABLE tbl_new SELECT (col1, col2, ...) FROM
tbl_old? Or do I miss something which would make it a more complicated
task?

If you don't want all rows from the source table you can use WHERE
and/or LIMIT.

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  Geschäftsführer / CEO iConnect GmbH 
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

- Original Message -
From: "David T-G" <[EMAIL PROTECTED]>
To: "mysql users" <[EMAIL PROTECTED]>
Sent: Saturday, December 28, 2002 2:37 AM
Subject: altering data structure


> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hi, all --
>
> What's the best way to change your database schema around if you have
> data in it?  How do you know when to simply ALTER TABLE and when to
dump
> the whole thing (perhaps doing specific SELECTs to spit out the data
> you'd like to have in the end to be processed by some script that will
> make the new table structure)?
>
> I don't have a good example, but suppose I have a few tables with some
> fields each and I realize that I should make a new table with data
from
> some columns of some tables.  What to do?
>
>
> TIA & HAND & Happy Holidays
>
> mysql query,
> :-D
> - --
> David T-G  * There is too much animal courage in
> (play) [EMAIL PROTECTED] * society and not sufficient moral
courage.
> (work) [EMAIL PROTECTED]  -- Mary Baker Eddy, "Science and
Health"
> http://www.justpickone.org/davidtg/Shpx gur Pbzzhavpngvbaf Qrprapl
Npg!
>
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v1.0.7 (FreeBSD)
>
> iD8DBQE+DQB2Gb7uCXufRwARAoiYAJ9ImPYzudn5iVy6a2VaxF9hZpT0QQCgm5A8
> V9U37FV1f/Xk6VVRbPa8A9I=
> =XKu3
> -END PGP SIGNATURE-
>
> -
> 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
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: style question: "drop database" in an install script

[Stefan Hinz, iConnect \(Berlin\)]

David,

> Or is there perhaps a "RENAME DATABASE" command (I saw RENAME TABLE)

in MySQL 4.1, you will find "ALTER DATABASE":
http://www.mysql.com/documentation/mysql/bychapter/manual_News.html#News
-4.1.0

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  Geschäftsführer / CEO iConnect GmbH 
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

- Original Message -
From: "David T-G" <[EMAIL PROTECTED]>
To: "mysql users" <[EMAIL PROTECTED]>
Sent: Saturday, December 28, 2002 2:15 AM
Subject: style question: "drop database" in an install script


> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hi, all --
>
> I'm working up the schema for my application and, as you can imagine,
> starting over and reloading numerous times :-)  In fact, I intend for
the
> script to be an install script, run on a new installation of the
software
> to set things up.
>
> The script starts out
>
>   drop database if exist dbname ;
>   create database dbname ; use dbname ;
>   create table tablename
>   (
> ...
>   ) ;
>   ...
>
> to set things up and then continues
>
>   insert into tablename (field,field,field)
> ( data , data , data ) ,
> ...
> ( data , data , data ) ;
>   ...
>
> to set up the predefined things (credit card types and so on).
>
> To reload the database and try something new, all I have to do is
>
>   mysql -udroot -p < script.sql
>
> and what was there goes away and is rebuilt fresh.  That's mighty
> convenient as I'm building up a table's design and trying it out.
>
> Soo...  When you experienced folks write software that's meant to
be
> installed from a script or such, do you lead off with a 'drop
database'
> command, or is that just too dangerous to put in a script and you make
> your users clean up any old installation by hand?  This will have to
be
> run by a root user, so we can figure that this user might have read
the
> docs and know that he's going to start [over] from scratch, but then,
> again, users are users :-)
>
> Meanwhile, is there if/then/else functionailty in SQL so that I can
say
>
>   if exist dbname exit "some error" ;
>   create database dbname ;
>   ...
>
> and not try to create and populate a database on top of an existing
one?
> Or is there perhaps a "RENAME DATABASE" command (I saw RENAME TABLE)
so
> that I could rename the old one to get it out of the way but not toss
it?
>
>
> TIA & HAND
>
> mysql query,
> :-D
> - --
> David T-G  * There is too much animal courage in
> (play) [EMAIL PROTECTED] * society and not sufficient moral
courage.
> (work) [EMAIL PROTECTED]  -- Mary Baker Eddy, "Science and
Health"
> http://www.justpickone.org/davidtg/Shpx gur Pbzzhavpngvbaf Qrprapl
Npg!
>
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v1.0.7 (FreeBSD)
>
> iD8DBQE+DPsqGb7uCXufRwARAsp8AKC7BuVdyO7Dl5fkbvEM51o+i/BAEgCeI5iI
> dI7HQb5oywLHuZIjLxXYZwY=
> =QTHL
> -END PGP SIGNATURE-
>
> -
> 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
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Mac OS X 10.2 ?

[Richard Nagle]

just install 3.23.53 for ( Mac OS X 10.2 ) from: 
www.entropy.ch/software/macosx/mysql
all went well,
saw prompt mysql>
type command: show database, saw test, and mysql database
did a \q (quit)
exit okay,

AND THEN !

try to get back into mysql, no luck
can see mysqld is still running.

how does one get back in ?

Anyone,
Thanks in Advance

Richard


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Fulltext search: Is there a way to disable the stop words?

[John Porter Simons]

Does anyone know of a runtime way to disable the stopword list?  I'm 
doing 'boolean mode' fulltext searches, but not getting any results if 
the term is in the compiled-in stopword list.  It seems like boolean 
mode shouldn't even use the stopwords -- they're more for determining 
relevence.

I tried prepending '+' to all my terms, but that didn't override the 
stopwords.  It was easy enough to change the source code to disable stop 
words, but I've been completely unsuccessful at getting my custom-built 
binaries to work at all. I need to use the pre-built binaries. 

Any system variables I could set, or any parameters I could add to MATCH 
... AGAINST query syntax, or any plans to disable stopwords for boolean fulltext 
searches in future builds?

Thanks for any advice you can give,

John Simons




-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Desperate - failed: Lost connection to MySQL server during query

[John P]

> If you are running close to the same setup with no problems then I feel a
> little better about it not being a issue of pure traffic.

Yes, we operate in a very similar way to you. (BTW, we have had very good
results with a PHP based cache facility that simply stores the db driven
pages over a selectable time period; good if your pages don't change that
much! Capacity increased 4000% or so; would imagine something similar exists
for perl)

> I don't think the link between the machines is a issue, both machines are
> dedicated and at the same location, I've tried using both the external and
> internal (10.0.x.x) IP to connect to the DB with the same results and in
all
> cases both machines have had entries in their hosts file for one another.
>
> As for simultaneous connections, that is something that I still need to go
> through the logs and come up with a real number for those time frames.. I
> don't know anyway to see a real number of actual users using Apache via
the
> command line (is there such a thing?).

I've always done ps -ef | grep httpd | wc -l a few times which shows the
processes, you can get a good idea of whether the site is busy or not. I
don't know how to actually find the exact number of users, I suppose netstat
?

> One thing I wonder that I forgot to ask - does using IP address as the
host
> for a user in mySql matter? Meaning before DNS switched over I wanted to
get
> everything up and running so I created all the mysql user accounts based
on
> the IP address of the web server (and not name).
> I would think if this were a issue at all I would be getting "denied"
> messages and it wouldn't work 100% of the time, but I thought I would
throw
> it out there.

I'd do everything by IP, especially for the "internal" stuff.

It might be worth trying a dedicated cable+two separate network cards in
each server to handle MySQL traffic. Just a thought, but could packets be
getting lost between the two servers (network overloaded or out of ports on
eth0 or ..?)

Post your exact network setup (machines, switches/hubs etc) and that might
give some more clues?

Good luck
John


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: installing RPM RedHat 8.0

[Samuel Pizzuto]

>
>I am getting the following message when submitting the following:
>
>
>how-to-repeat:
>
>[root@localhost sam]# rpm -ivh /mnt/cdrom/MySQL-4.0.6-.0.i386.rpm
>
>error:/mnt/cdrom/MySQl-4.0.6-.0.i386.rpm: MD5 digest : BAD 
>expected(ba03cefd50c27d9d993ce693457c072d) != 
>(ad8cba3b72f6ae195b93f9b1db8a481c) 
>error:/mnt/cdrom/MySQl-4.0.6-.0.i386.rpm cannot be installed
>
>I have tried several .rpm from different North America sites
>sam
>
>
>-
>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 <[EMAIL PROTECTED]>
>
>

http://netwinsite.com/dbabble/

-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mid vs substring

[Paul DuBois]

At 9:44 +0200 12/28/02, Octavian Rasnita wrote:

Which is the difference between mid and substring functions in MySQL?


None.  MID() is actually a synonym for SUBSTRING() in MySQL.


sql, query


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mid vs substring

[Octavian Rasnita]

Which is the difference between mid and substring functions in MySQL?

Thank you.

Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMAIL PROTECTED]



-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Desperate - failed: Lost connection to MySQL server during query

[Chris Faust]

Yes, I do connect to the DB server over IP - in short this is what I do
within MAIN of all my scripts (and $db is what is used anyplace a DB
connection is needed)

##
# Database Setup
# -
#
my $dbpassfile = '/websites/web_files/dbadmin.pass';
my ($db_username,$db_password,$db_location,$db_name,$db);
open (DBPASSFILE, "$dbpassfile") or die "Couldn't open $dbpassfile: $!\n";
while () {
 ($db_username,$db_password,$db_location,$db_name) = split;
 }
my $database = "DBI:mysql:database=$db_name:host=$db_location";
$db = DBI->connect($database,$db_username,$db_password) or die "Cannot
Connect: " . $db->errstr();
close DBPASSFILE;

I use a text file to store the username,password,table name and IP to add
just a little more security.
I have check to make sure that open files on the linux machine wasn't a
issue (and it wasn't) when opening up that file each time.

As far as the connection_timeout, I don't have anything in my.cnf but if I
do a mysqladmin variables it shows me its set to 5.

I think I'm going back to the drawing board :)

Thanks
-Chris


>>
>> This DOES seem to indicate you are connecting using TCP/IP. Are
>> you? If so,
>> a whole new sleuth of options appears.
>>
>> > I'm leaning towards either Redhat 8, or Apache 2 or the combination of
>> > the two of them - I just can't figure out what else to try or what to
>> > look for.
>>
>> Try connecting over the domain socket; or / and add something
>> like this to
>> the [mysql] section of my.cnf,
>>
>> set-variable = connect_timeout=4
>>
>> Just to see whether it is a timing problem.
>>
>> - Mark
>>



-
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 
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Upgrade from 3.23.x to 4.0.x??

[Davy Obdam]

Hi people,

I have a few questions about whether or not i should upgrade to MySQL 
4.0.7-Gamma on my Windows XP system. I am now running MySQL 3.23.54a on 
my Laptop. Its used for developing/testing, and the applications needs 
to be transported to the final server after completion. Most of the time 
however the server is a 3.23.x and not 4.0.x. Is 4.0.x backwards 
compatible? Can i tranfer my databases without problems from my current 
MySQL 3.23.54 database to MySQL 4.0.x.? And is MySQL 4.0.7-gamma 
coonsiderd stable?

Also i would like to know how-to upgrade, can i just instal over my 
excisting MySQL installation?

Any thoughts are apreciated, thanks for your time,

Best regards,

Davy Obdam
mailto:[EMAIL PROTECTED]



-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Mysql Query request

[Paul DuBois]

At 2:40 -0800 12/28/02, Arun Kumar wrote:

But if I have varchar fields won't the size of the
record vary based on the actual contents in the
varchar fields.

Arun


Of course.  My answer remains the same.  Perhaps I should
add that what all this means is that you must perform
the calculations on a per-record basis, and that these
calculations, though not especially difficult, are likely
to become fairly ugly as the number of columns in your table
increase.

Don't forget that a VARCHAR containing a 10-byte
string takes a different amount of storage than, say,
a MEDIUMTEXT, TEXT, or LONGTEXT containing a 10-byte
string.

If what you really want to do (though this is *not*
what you said) is to order by the length of a given
string column, just do:

SELECT  , LENGTH(col_name) FROM tbl_name ... ORDER BY LENGTH(col_name);

Add the appropriate constant to the LENGTH() expression to factor
in the extra number of bytes required internally to store the column
length.  (E.g., 1 for VARCHAR, 4 for LONGTEXT.)



--- Paul DuBois <[EMAIL PROTECTED]> wrote:

 At 18:38 -0800 12/27/02, Arun Kumar wrote:
 >Dear All,
 >  I have a table 'X', I want to display the record
 >  in this table 'X' which has occupied the maximum
 >  number of bytes, i.e i want a query/queries to
 >display the record with maximum size. I would also
 >like to print the
 >  record size as well.
 >
 >  Any help in this front would be great.
 >  Arun

 You'll have to calculate record size yourself based
 on knowledge
 about the types of the columns in the table and the
 storage occupied

 > by those types.



-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Desperate - failed: Lost connection to MySQL server during query

[Mark]

- Original Message -
From: "Chris Faust" <[EMAIL PROTECTED]>
To: "Mark" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, December 28, 2002 1:18 PM
Subject: RE: Desperate - failed: Lost connection to MySQL server during
query



> I really don't think its any of the scripts either, everything was
> running fine at another location (none of these errors ever came up)
> and the scripts do run fine via the command line.

Hmm, if stuff runs consistently well on the command line, then that seems to
be ruling out a hardware error (unless you connect our DBI over TCP/IP, in
which case you could have a faulty Ethernet card; but I assumed you are
using a local UNIX domain socket, like /tmp/mysql.sock).

> One other test I did was put part of the site that was getting as many
> lost connection errors as anything else, on another machine (the
> administration side of it) and once there it ran perfectly using the
> same mySql server (and its even IIS).

This DOES seem to indicate you are connecting using TCP/IP. Are you? If so,
a whole new sleuth of options appears.

> I'm leaning towards either Redhat 8, or Apache 2 or the combination of
> the two of them - I just can't figure out what else to try or what to
> look for.

Try connecting over the domain socket; or / and add something like this to
the [mysql] section of my.cnf,

set-variable = connect_timeout=4

Just to see whether it is a timing problem.

- Mark


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Desperate - failed: Lost connection to MySQL server during query

[Chris Faust]

If you are running close to the same setup with no problems then I feel a
little better about it not being a issue of pure traffic.

As for the scripts, its a heavy reliance on the database for information -
pretty much the whole site is like a classifieds ads system. Other then the
advance searches (which are not used all that much) 90% of everything is
just a single select to the DB at which point the results are normally
parsed out in a single loop and displayed to the user (I also use
HTML::Template to deal with serving results).

If it means anything, when things are running at a normal load I can sit and
watch people hitting the scripts (just using top or ps -eaf) and see that
they use up a little CPU and then they are gone (meaning everything did its
thing and it was over), I almost never see a perl process that is running
one of the webscipts last any more then a second or sometimes two..

I don't think the link between the machines is a issue, both machines are
dedicated and at the same location, I've tried using both the external and
internal (10.0.x.x) IP to connect to the DB with the same results and in all
cases both machines have had entries in their hosts file for one another.

As for simultaneous connections, that is something that I still need to go
through the logs and come up with a real number for those time frames.. I
don't know anyway to see a real number of actual users using Apache via the
command line (is there such a thing?).

One thing I wonder that I forgot to ask - does using IP address as the host
for a user in mySql matter? Meaning before DNS switched over I wanted to get
everything up and running so I created all the mysql user accounts based on
the IP address of the web server (and not name).
I would think if this were a issue at all I would be getting "denied"
messages and it wouldn't work 100% of the time, but I thought I would throw
it out there.

Thanks
-Chris


>>
>> Chris, we are running a similar www/db box setup to you, with similar
>> traffic and data transfer figures. I use Apache 1.3/PHP though.
>> I never see
>> the uptime over 1, let alone 6.
>>
>> Do all your scripts have quite extensive reliance on the DB and
>> calculations
>> etc? I would have thought that the WWW box has very little to do!
>>
>> I know each situation is different, but have you tested the link
>> between the
>> two computers (is it dedicated or over the same net as the WWW?) to check
>> that there isn't a problem there? What sort of simultaneous connection
>> figures does this problem start at? I wonder about a hardware / network
>> problem too..
>>
>>
>> Cheers,
>> John



-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: Re: Mysql Query request

[Egor Egorov]

On Saturday 28 December 2002 12:40, Arun Kumar wrote:

> But if I have varchar fields won't the size of the
> record vary based on the actual contents in the
> varchar fields.

Use LENGTH() function:
http://www.mysql.com/doc/en/String_functions.html

and plus one byte.



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: Re: Bug using truncation in 4.0.4-beta

[Victoria Reznichenko]

On Sunday 22 December 2002 20:16, Salam Baker Shanawa wrote:
> Hello Victoria,
>
> Is there any plan to make operators work with phrase searches.
> something like: against ('"comput* scie*"') in boolean mode

Yes, it's still in TODO :)

> I have tested 4.0.6-gamma and I can see that the bug is fixed:
> Empty set is returned when truncation operator is used :-)
>
>
>
> Victoria Reznichenko wrote:
> > sbs,
> > Tuesday, October 29, 2002, 7:31:03 AM, you wrote:
> >
> > samdldlds> Description:
> > samdldlds> Special case: using SELECT with truncation doesn't
> > return some records samdldlds> when the searched query appears at
> > the end of the line. Note that the last record will samdldlds> be
> > matched and returned because there is a space character at the end.
> > samdldlds> I am using ft_min_word_len = 1;
> >
> > Currently phrase search doesn't work with operators. If they work for
> > somebody, it's a bug, too :-)



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com





-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: fulltext search in boolean mode problems

[Egor Egorov]

On Saturday 28 December 2002 11:40, Anton Zabannikh wrote:

> I have some problems with fulltext search in boolean mode using mysql
> 4.0.6.
> I try to use this query:
> mysql>  SELECT * FROM molotok_lots WHERE MATCH (lot_name,lot_desc)
> mysql> AGAINST ('+some +text' IN BOOLEAN MODE);
> I got error :
> ERROR 1064: You have an error in your SQL syntax near 'BOOLEAN MODE)' at
> line 1
>
> Type of table is MyISAM.
>
> How to fix this problem ?

Hm..
It works fine for me:

mysql> select * from articles where match(body) against('+link +world' IN 
BOOLEAN MODE);
++--+
| id | body |
++--+
|  1 | link it to the world |
++--+
1 row in set (0.00 sec)

Note: that's supported since 4.0.1 and not in 3.23.x branch. 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Sorting order in latin1 broken

[Georg Richter]

On Saturday 28 December 2002 15:20, [EMAIL PROTECTED] wrote:

> When querying text strings from a latin1 database,
> a text string starting with german "Ü" is ordered
> between "W" and "Y", but should be treated as "U" or "Ue".
>

For the correct sorting you need another charset (latin1_de or german1).

Regards

Georg

filter:mysql,query

-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Sorting order in latin1 broken

[hadmut]

>Description: Sorting order in latin1 broken
>How-To-Repeat: Enter some strings into database and do select...order by


>Submitter-Id:  
>Originator:Hadmut Danisch
>MySQL support: none
>Synopsis:  Sorting order in latin1 broken
>Severity:  non-critical
>Priority:  medium 
>Category:  mysql
>Class: sw-bug 
>Release:   mysql-3.23.54 (Source distribution)

>Environment:   Linux, debian
System: Linux sodom 2.4.20-universal-686 #1 Mit Dez 4 19:09:11 CET 2002 i686 unknown 
unknown GNU/Linux
Architecture: i686


When querying text strings from a latin1 database,
a text string starting with german "Ü" is ordered
between "W" and "Y", but should be treated as "U" or "Ue".


Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs
gcc version 2.95.4 20011002 (Debian prerelease)
Compilation info: CC='gcc'  CFLAGS=''  CXX='g++'  CXXFLAGS=''  LDFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   13 2002-12-07 19:41 /lib/libc.so.6 -> 
libc-2.3.1.so
-rwxr-xr-x1 root root  1109068 2002-11-19 19:13 /lib/libc-2.3.1.so
-rw-r--r--1 root root  2344038 2002-11-19 19:14 /usr/lib/libc.a
-rw-r--r--1 root root  178 2002-11-19 19:14 /usr/lib/libc.so
-rw-r--r--1 root root   726564 2002-06-16 07:53 
/usr/lib/libc-client.so.2001
-rw-r--r--1 root root   742884 2002-11-01 21:42 
/usr/lib/libc-client.so.2002
Configure command: ./configure '--prefix=/usr' '--exec-prefix=/usr' 
'--libexecdir=/usr/sbin' '--datadir=/usr/share' '--sysconfdir=/etc/mysql' 
'--localstatedir=/var/lib/mysql' '--includedir=/usr/include' 
'--infodir=/usr/share/info' '--mandir=/usr/share/man' '--enable-shared' 
'--with-libwrap' '--enable-assembler' '--with-berkeley-db' '--with-innodb' 
'--enable-static' '--enable-local-infile' '--with-raid' '--enable-thread-safe-client' 
'--without-readline' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' 
'--with-mysqld-user=mysql' '--without-bench' '--without-docs' 
'--with-client-ldflags=-lstdc++' '--with-extra-charsets=all'



regards
Hadmut

-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

ensuring an instructor, client, or room isn't double-booked

[David T-G]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi, all --

I have tables for clients, instructors, places (rooms), and classtypes,
and finally a schedule where these come together.  I'd like to make sure
that a client isn't being double-scheduled (two classes at once), or an
instructor isn't being double-booked (two private students in the same
time slot) -- basically the same person (client or instructor) at the
same time, though it also applies for rooms.

Given a table like

  create table schedule
  (
# ID number
id smallint not null default 0 auto_increment primary key ,
client smallint ,   # references client.id
class smallint ,# references classtypes.id
place smallint ,# references places.id
instr smallint ,# references personnel.id
time datetime   # when
  ) ;

I could, for every insert, check

  select * from schedule where client = '1' and time = '...' ;

to make sure the client isn't being booked twice, or

  select * from schedule where instr = '1' and time = '...' ;

to make sure the instructor isn't double-booked, but that seems like it
would get awfully slow as the table grows...  Is this the sort of thing
where a temporary table is advised, or should I define a reverse table
that shows each instructor and his/her bookings, or what?


TIA & HAND & Happy Holidays

:-D
- -- 
David T-G  * There is too much animal courage in 
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED]  -- Mary Baker Eddy, "Science and Health"
http://www.justpickone.org/davidtg/Shpx gur Pbzzhavpngvbaf Qrprapl Npg!

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (FreeBSD)

iD8DBQE+DaQNGb7uCXufRwARAg6qAJ4vjNsp5EfoQLJRKJdw0MhMx56fygCbBX7H
MVGjrhB5RczZ5f6UAFf6bmk=
=VSZ0
-END PGP SIGNATURE-

-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Desperate - failed: Lost connection to MySQL server during query

[Chris Faust]

Wow, I don't know if that's a good bet as doesn't a donut cost around a
dollar these days :).

Seriously, It very well could be something hardware related but everything
is brand-new and I'm not seeing any issues logged anyplace with anything on
the machine (except this specific problem at high load times and there is
the error being reported).

Something else that may be an issue is its just traffic and how Redhat 8 or
Apache 2 deals with it, the site isn't over the top but the high daily
average is 10,000 unique users, 250,000 page views and about 6 gig of
bandwidth a day..
Pipe is no issue at all and I would think that the P4 could handle that
amount of traffic - I only see CPU go off the chart when all the disconnects
start happening so its hard to tell if one is the result of the other..

Hardware is my last resort, but its moving up the list fast!!

Thanks
-Chris


>> -Original Message-
>> From: Doug Thompson [mailto:[EMAIL PROTECTED]]
>> Sent: Saturday, December 28, 2002 7:33 AM
>> To: Chris Faust; Mark; [EMAIL PROTECTED]
>> Subject: RE: Desperate - failed: Lost connection to MySQL server during
>> query
>>
>>
>> Chris:
>>
>> I bet a dollar to a donut that you have a hardware problem.  The
>> essential proof is in the first quoted paragraph below.  Believe
>> your data, save your hair.
>>
>> Regards,
>> Doug
>>
>> Filter That!  SQL MySQL Query
>>
>> On Sat, 28 Dec 2002 07:18:07 -0500, Chris Faust wrote:
>>
>> >One other test I did was put part of the site that was getting
>> as many lost
>> >connection errors as anything else, on another machine (the
>> administration
>> >side of it) and once there it ran perfectly using the same
>> mySql server (and
>> >its even IIS).
>> >
>> >I'm leaning towards either Redhat 8, or Apache 2 or the
>> combination of the
>> >two of them - I just can't figure out what else to try or what
>> to look for.
>> >I hate the thought all the work involved in bring up a new machine and
>> >bringing everything over when I at least have a error message
>> to work with
>> >:).
>>
>>
>>
>>



-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Desperate - failed: Lost connection to MySQL server during query

[Doug Thompson]

Chris:

I bet a dollar to a donut that you have a hardware problem.  The
essential proof is in the first quoted paragraph below.  Believe 
your data, save your hair.

Regards,
Doug

Filter That!  SQL MySQL Query

On Sat, 28 Dec 2002 07:18:07 -0500, Chris Faust wrote:

>One other test I did was put part of the site that was getting as many lost
>connection errors as anything else, on another machine (the administration
>side of it) and once there it ran perfectly using the same mySql server (and
>its even IIS).
>
>I'm leaning towards either Redhat 8, or Apache 2 or the combination of the
>two of them - I just can't figure out what else to try or what to look for.
>I hate the thought all the work involved in bring up a new machine and
>bringing everything over when I at least have a error message to work with
>:).





-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Desperate - failed: Lost connection to MySQL server during query

[Chris Faust]

Hello Mark,

Thanks for the reply..

I would need to wait until load gets up there to see the state of apache but
even now with almost no load on the machine I'm seeing at least a dozen
connections in the "TIME_WAIT" state. On the flip site of things I have not
been seeing any other connection related issues from apache (no connection
reset by peer messages or anything like that)

I really don't think its any of the scripts either, everything was running
fine at another location (none of these errors ever came up) and the scripts
do run fine via the command line.

To give you a little more on the scripts..

I create a connection to the DB as the first thing in all scripts. That
connection is used anyplace a call to the DB is needed, (in other words I
don't fork anything or create any children, establish a second connection
etc.) there is never anymore then 1 connection made to the DB for any 1
script that is compiled at run-time.

For timeout, Apache has:
Timeout 300
KeepAlive On
MaxKeepAliveRequests 0
KeepAliveTimeout 15

One other test I did was put part of the site that was getting as many lost
connection errors as anything else, on another machine (the administration
side of it) and once there it ran perfectly using the same mySql server (and
its even IIS).

I'm leaning towards either Redhat 8, or Apache 2 or the combination of the
two of them - I just can't figure out what else to try or what to look for.
I hate the thought all the work involved in bring up a new machine and
bringing everything over when I at least have a error message to work with
:).

Thanks
-Chris


>>
>>
>> > The problem is this, everytime the web server starts to work a little
>> > (load via a uptime showing about 6), 1 out of 5 scripts bomb out with
>> > the message of:
>> >
>> > "failed: Lost connection to MySQL server during query"
>> >
>> > As load gets higher then the rate of failure gets higher.
>>
>>
>> I lack the necessary info on your scripts, of course; but you might be
>> looking at it from the wrong angle. I would ere expect a
>> time-out issue with
>> the Apache server (that is, with its spawned children). Try a
>> "netstat -a";
>> are many http connection in a TIME_WAIT state? The "Timeout" value in
>> httpd.conf also leaps to mind. A CPU load of 6, though not itself
>> excessively high, may be an indication that the Apache server
>> gets hits with
>> many, many requests, forcing many to remain in a TIME_WAIT state for a
>> while -- long enough to cause a potential problem for the MySQL
>> connection,
>> at least.
>>
>> A solid test, I would say, is to try and run your Perl scripts
>> directly, and
>> not via a web-page. I have a nagging suspicion the errors will be gone.
>>
>> - Mark



-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Mysql Query request

[Arun Kumar]

But if I have varchar fields won't the size of the
record vary based on the actual contents in the
varchar fields.

Arun 

--- Paul DuBois <[EMAIL PROTECTED]> wrote:
> At 18:38 -0800 12/27/02, Arun Kumar wrote:
> >Dear All,
> >  I have a table 'X', I want to display the record
> >  in this table 'X' which has occupied the maximum
> >  number of bytes, i.e i want a query/queries to
> >display the record with maximum size. I would also
> >like to print the
> >  record size as well.
> >
> >  Any help in this front would be great.
> >  Arun
> 
> You'll have to calculate record size yourself based
> on knowledge
> about the types of the columns in the table and the
> storage occupied
> by those types.


__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

seagate crystal reports with mysql

[geeta varu]

can i create reports using 
seagate crystal reports with 
mySQL as backend.
regards,
gj

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: altering data structure

[David T-G]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Benjamin, et al --

...and then Benjamin Pflugmann said...
% 
% Hi.

Hi again!


% 
% On Fri 2002-12-27 at 20:37:58 -0500, [EMAIL PROTECTED] wrote:
% > Hi, all --
% > 
% > What's the best way to change your database schema around if you have
% > data in it?  How do you know when to simply ALTER TABLE and when to dump
% > the whole thing (perhaps doing specific SELECTs to spit out the data
% > you'd like to have in the end to be processed by some script that will
% > make the new table structure)?
% 
% Well, I guess it depends. I would start with making a backup. :-)

Of course :-)


% 
% Personally, I prefer to change the database with ALTER TABLE and
% UPDATEs, because I can get immediate feedback and I am comfortable

Hmmm...  OK.


% enough with writing such SQL queries from head. Do not forget to save
% the SQL commands in a file in case you have to start from scratch
% (backup).

Makes sense.  My inclination is to script it anyway, though for a real
one-time change maybe not.  Maybe we'd want to apply the changes to a
restored copy from before tonight's new backup, for instance...


% 
% I suppose if you are quite comfortable with e.g. Perl and/or the
% changes are going to be complex, writing a script is the better idea,

I don't know how complex things have to be before they're complex enough
for a script, but it sounds like it's possible.  OK; so maybe one needs a
script.  But, meanwhile, you can do this just within the database?  Wow.


% because it is more forgiving if you make errors. OTOH, you have a
% bigger overhead, depending on how well you know your scripting
% language.

Fairly well -- and I could always stand to learn more :-)


% 
% > I don't have a good example, but suppose I have a few tables with some
% > fields each and I realize that I should make a new table with data from
% > some columns of some tables.  What to do?
% 
% If you choose to go the SQL route, have a look at TEMPORARY TABLES,
% CREATE TABLE ... SELECT and INSERT ... SELECT. Don't forget that you

You mean a CREATE TABLE command that has SELECT as part of it, and an
INSERT command that has SELECT as part of it?  Actually I wanted to know
how to do the latter but didn't think it could be done!  Briefly:

  create table ccards
  (
# ID number
id smallint not null default 0 auto_increment primary key ,
  ...
hash tinyblob   # hash of the card: have we seen this one before?
  ) ;
  create table clientcards
  (
# ID number
id smallint not null default 0 auto_increment primary key ,
client smallint ,   # references client.id
card smallint , # references ccards.id (but must be disconnected)
type smallint , # references ccardtypes.id  ### need this here?
hash tinyblob   # references ccards.hash (but must be disconnected)
  ) ;
  ...
  insert into ccards (type,name,number,expdate) values
( '1' , 'david thorburn-gundlach' , '1234 5678 9abc def0' , '2003-06-00') ;
  update ccards set hash = md5(number) where id = last_insert_id() ;
  insert into clientcards values
( '' , '1' , '1' , '1' , 
  select ccards.hash where ccards.id = last_insert_id() ) ;

Everything up to the clientcards insert works just fine.  How can I
insert into clientcards the info including the hash from ccards?  [I'm
just doing this for the testing phase, since not only will the ccards
table be locked away in a real database but I'll be inserting the values
one at a time from my front end where I'll calculate the md5 sum myself,
but it works as an example.]


% can test with the SELECT and only add CREATE TABLE / INSERT part at
% the end. And LIMIT is your friend.

OK :-)


% 
% HTH,
% 
%   Benjamin.
% 
% -- 
% [EMAIL PROTECTED]


Thanks & HAND & Happy Holidays

:-D
- -- 
David T-G  * There is too much animal courage in 
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED]  -- Mary Baker Eddy, "Science and Health"
http://www.justpickone.org/davidtg/Shpx gur Pbzzhavpngvbaf Qrprapl Npg!

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (FreeBSD)

iD8DBQE+DXd5Gb7uCXufRwARAmtVAJ4i8dpmQz8yd/okzgTLdwXLn1HyiwCggIts
AOGgeFdZYnxRWLmgF6FDmVE=
=JheJ
-END PGP SIGNATURE-

-
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 
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Desperate - failed: Lost connection to MySQL server during query

[Mark]

- Original Message -
From: "Chris Faust" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, December 27, 2002 10:22 PM
Subject: Desperate - failed: Lost connection to MySQL server during query


> The problem is this, everytime the web server starts to work a little
> (load via a uptime showing about 6), 1 out of 5 scripts bomb out with
> the message of:
>
> "failed: Lost connection to MySQL server during query"
>
> As load gets higher then the rate of failure gets higher.


I lack the necessary info on your scripts, of course; but you might be
looking at it from the wrong angle. I would ere expect a time-out issue with
the Apache server (that is, with its spawned children). Try a "netstat -a";
are many http connection in a TIME_WAIT state? The "Timeout" value in
httpd.conf also leaps to mind. A CPU load of 6, though not itself
excessively high, may be an indication that the Apache server gets hits with
many, many requests, forcing many to remain in a TIME_WAIT state for a
while -- long enough to cause a potential problem for the MySQL connection,
at least.

A solid test, I would say, is to try and run your Perl scripts directly, and
not via a web-page. I have a nagging suspicion the errors will be gone.

- Mark


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: style question: "drop database" in an install script

[David T-G]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Benjamin, et al --

[I couldn't find your public key...  Is it on a keyserver?]

...and then Benjamin Pflugmann said...
% 
% Hello.

Hi!


% 
% On Fri 2002-12-27 at 20:15:22 -0500, [EMAIL PROTECTED] wrote:
% [...]
...
% > Soo...  When you experienced folks write software that's meant to be
% > installed from a script or such, do you lead off with a 'drop database'
% > command, or is that just too dangerous to put in a script
% 
% I would think so.

I'm going to figure you think "too dangerous" rather than think "lead
off" based on your comments below :-)


% 
% > and you make your users clean up any old installation by hand?
% 
% I would at least require them to do something special (use a --force
% flag or call a seperate cleanup script, or whatever).

I was thinking about a cleanup script; it sounds like that's the way to
go.


% 
% > This will have to be run by a root user, so we can figure that this
% > user might have read the docs and know that he's going to start
% > [over] from scratch, but then, again, users are users :-)
% 
% Even if most people would read the docs (that's not my experience, not
% even for those having root privileges ;), the problem is that the

Yeah, yeah :-)  One *hopes* that with power would come responsibility,
but in this loose age...


% damage could be relativly big. And the greater the possible damage the
% more conservative your scripts should be.

OK.  Sounds like sage advice.


% 
% > Meanwhile, is there if/then/else functionailty in SQL so that I can say
% > 
% >   if exist dbname exit "some error" ;
% >   create database dbname ;
% >   ...
% > 
% > and not try to create and populate a database on top of an existing one?
% 
% Since there is a flag --force to the mysql command line client, which
% will force continuation in case of sql error, it sounds as if the
% default behaviour of the tool already is to bail out on error. If not,
% it's a bug (either documentation of behaviour).

Oh :-)  Well, so I tried it; I commented out the drop and reran my
script, and it quit at

  ERROR 1007 at line 3: Can't create database 'dbname'. Database exists

so it looks like it doesn't continue.  Good; I won't be trying to make
stuff on top of stuff.


% 
% > Or is there perhaps a "RENAME DATABASE" command (I saw RENAME TABLE) so
% > that I could rename the old one to get it out of the way but not toss it?
% 
% If you do not restrict yourself to a SQL script, but a shell script
% which calls mysql to execute some SQL, you could react very flexible
% on the concerns you mentioned.

Yeah.  There will be an installation script (probably shell, because of
its portability, but perhaps perl for power) so I can just take the extra
steps of detecting the database and getting rid of it as a subtask.


% 
% HTH,

It does; thanks!


% 
%   Benjamin.
% 
% -- 
% [EMAIL PROTECTED]


HAND & Happy Holidays

:-D
- -- 
David T-G  * There is too much animal courage in 
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED]  -- Mary Baker Eddy, "Science and Health"
http://www.justpickone.org/davidtg/Shpx gur Pbzzhavpngvbaf Qrprapl Npg!

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (FreeBSD)

iD8DBQE+DXJ9Gb7uCXufRwARAvBPAKDIg9bz9cHpSPDt06kGZ99pgxH+EwCggMNr
TRignFqywNlCFDLVrkRMO0Q=
=HCwW
-END PGP SIGNATURE-

-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

fulltext search in boolean mode problems

[Anton Zabannikh]

Hello!

I have some problems with fulltext search in boolean mode using mysql
4.0.6.
I try to use this query:
mysql>  SELECT * FROM molotok_lots WHERE MATCH (lot_name,lot_desc)
mysql> AGAINST ('+some +text' IN BOOLEAN MODE);
I got error :
ERROR 1064: You have an error in your SQL syntax near 'BOOLEAN MODE)' at line 1

Type of table is MyISAM.

How to fix this problem ?
Thanks.
_
Anton Zabannikh


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: unable to create File DSN

[Robert Citek]

Hello all,

Seems like I'm not alone:
  http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:52006
On the bright side, I found an answer that pointed me somewhat in the right
direction:
  http://www.geocrawler.com/archives/3/13/1998/11/0/56625

I have discovered that I can create a trimmed-down version using notepad:

[ODBC]
DSN=foobar

If I call this file foo.dsn and put it in "C:\Program Files\Common
Files\odbc\Data Sources", foo.dsn shows up in the ODBC Data Source
Administrator application (aka ODBC manager).  However, in order to
actually use it, I have to create the System DSN that is specified in the
File DSN, for this example, foobar.  Using the ODBC manager, if I change
the File DSN, the System DSN also changes, and vice versa.  Yet, when I
quit and examine the file foo.dsn, nothing has changed.  It still just has
the single line DSN=foobar.

What is the advantage of creating a File DSN if I have to create a System
DSN?  Why not use the System DSN instead of a File DSN?  Setting up a
System DSN so that I can create a File DSN leaves me with the feeling that
something is broken.  Is it Windows' ODBC manager?  Is it MyODBC?  Should I
be trying MyODBC 3.51?

Any pointers greatly appreciated.

Regards,
- Robert

sql

-

At 11:38 PM 12/27/2002 -0600, Robert Citek wrote:
>Why can I not create a File DSN using MyODBC 2.50.39 on Windows 2000?


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php