Re: Mysql.log error - Please help

[Jocelyn Fournier]

Hi,

Or simply use perror 28 :)

[EMAIL PROTECTED]:~$ perror 28
Error code  28:  No space left on device

Regards,
  Jocelyn

- Original Message -
From: "Brian Reichert" <[EMAIL PROTECTED]>
To: "Minal Amle" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, April 04, 2003 9:06 AM
Subject: Re: Mysql.log error - Please help


> On Fri, Apr 04, 2003 at 12:22:18PM +0530, Minal Amle wrote:
> > Hello,
> >
> > I am facing a problem while inserting data in one of the tables of my
mysql database as:
> > Error writing file '/var/log/mysql.log' (Errcode :28)
>
> I suspect this 'Errcode' corresponds to 'errno' under UNIX systems.
> On mine, that would corresspond to:
>
>   #define ENOSPC  28  /* No space left on device */
>
> My box, a FreeBSD box, has this constant in /usr/include/sys/errno.h.
> your system may vary...
>
>   man errno
>
> Good luck...
>
> > Thanks in advance.
> >
> > Regards,
> > Minal Amle
> > Software Engineer
> > OAS Information Systems Pvt. Ltd.
> > #2, Symphony-C, Range Hills Road,
> > Pune 411020
> > Tel: +91 20 5520311
> > Fax: +91 20 5520312
> > Email: [EMAIL PROTECTED]
> > http://www.oas.co.in
>
> --
> Brian 'you Bastard' Reichert <[EMAIL PROTECTED]>
> 37 Crystal Ave. #303 Daytime number: (603) 434-6842
> Derry NH 03038-1713 USA BSD admin/developer at large
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
>
>
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: MySQL index fun

[Dan Rossi]

Create a compound index on either (time, source_ip) or (source_ip,
time).  Mysql cannot use two indexes on one table.

woah what are you saying here , that it cant have multiple indexes within a
table ?

and what is a compound index ?

say i have a table

products:
productID
product
storeID <-index
userID <-index

stores:
storeID
store

users:
userID
user

can i not have multiple indexes like that , as i usually use int keys to
join tables together



-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 3:22 PM
To: Steve Phillips
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL index fun


In the last episode (Apr 03), Steve Phillips said:
> I have a table for ip data that i need to index to suit the following
> query
>
> SELECT time,source_ip,bytes FROM data.tb_ipdata_0403 WHERE (time >
> 1049108400 AND time < 1051786799) AND (source_ip > 3389268097 AND
> source_ip < 3389268099)
>
> if i created an index on the time column and an index of the
> source_ip column would the query then use these indexes or would i
> need to change my query ?

Create a compound index on either (time, source_ip) or (source_ip,
time).  Mysql cannot use two indexes on one table.


--
Dan Nelson
[EMAIL PROTECTED]

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysql.log error - Please help

[Brian Reichert]

On Fri, Apr 04, 2003 at 12:22:18PM +0530, Minal Amle wrote:
> Hello,
> 
> I am facing a problem while inserting data in one of the tables of my mysql database 
> as:
> Error writing file '/var/log/mysql.log' (Errcode :28)

I suspect this 'Errcode' corresponds to 'errno' under UNIX systems.
On mine, that would corresspond to:

  #define ENOSPC  28  /* No space left on device */

My box, a FreeBSD box, has this constant in /usr/include/sys/errno.h.
your system may vary...

  man errno

Good luck...

> Thanks in advance.
> 
> Regards,
> Minal Amle
> Software Engineer
> OAS Information Systems Pvt. Ltd.
> #2, Symphony-C, Range Hills Road,
> Pune 411020
> Tel: +91 20 5520311
> Fax: +91 20 5520312
> Email: [EMAIL PROTECTED]
> http://www.oas.co.in

-- 
Brian 'you Bastard' Reichert<[EMAIL PROTECTED]>
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA BSD admin/developer at large

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Mysql.log error - Please help

[Minal Amle]

Hello,

I am facing a problem while inserting data in one of the tables of my mysql database 
as:
Error writing file '/var/log/mysql.log' (Errcode :28)
While records are getting inserted in other tables. I am not getting why this is 
happening so.
Can anybody please help me in this regard?

Thanks in advance.

Regards,
Minal Amle
Software Engineer
OAS Information Systems Pvt. Ltd.
#2, Symphony-C, Range Hills Road,
Pune 411020
Tel: +91 20 5520311
Fax: +91 20 5520312
Email: [EMAIL PROTECTED]
http://www.oas.co.in

Re: my_raid_seek assertion failed in mysqld log

[Jeremy Zawodny]

On Fri, Apr 04, 2003 at 01:22:39PM +0700, David Garamond wrote:
> i found this on my server log:
> 
> mysqld-max: raid.cc:160: my_off_t my_raid_seek(int, long long unsigned 
> int, int, int): Assertion `pos != (~(my_off_t) 0)' failed.
> 
> and then mysqld shuts down. i start it again but after a short while the 
> same error appears and mysqld stops again. what does this indicate? a 
> disk failure?

Oh, good.  It's not just the machines at Yahoo, then.

I haven't looked into it much yet, but we had a machine hit that a few
times.  That made me realize that I had been building our MySQL
servers with raid support.  We don't have any need for it, so I've
removed it.  But clearly something is funky with the raid code.

I've yet to figure out a way to reproduce the bug.  Well, I have't
tried very hard either...

Any chance you can?  If so, getting it fixed shouldn't be a problem.

Jeremy
-- 
Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/

MySQL 4.0.8: up 59 days, processed 2,015,166,365 queries (390/sec. avg)

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

my_raid_seek assertion failed in mysqld log

[David Garamond]

i found this on my server log:

mysqld-max: raid.cc:160: my_off_t my_raid_seek(int, long long unsigned 
int, int, int): Assertion `pos != (~(my_off_t) 0)' failed.

and then mysqld shuts down. i start it again but after a short while the 
same error appears and mysqld stops again. what does this indicate? a 
disk failure?

--
dave
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: InnoDB disk file grows, never shrinks

[Michael S]

I should add that my test continually inserted and deleted records from a set of 
tables. At no point did any table have more than 101 records, but the test ran 348 
times, so there were 348 * 100 rows INSERTed and DELETEd.

-ms


-- Original Message --
From: "Michael S" <[EMAIL PROTECTED]>
Reply-To: <[EMAIL PROTECTED]>
Date:  Thu,  3 Apr 2003 23:45:28 -0600

>My InnoDB file is set to 60MB, and is not set to autoexpand.
>
>When running stress tests against my server today, I got a message that the table was 
>full and the test stopped. Sure enough, the InnoDB file was about 62MB.
>
>My question:
>I assume that the InnoDB file is the transaction log. Is there a command that I 
>should be running to truncate the transaction log periodically so it doesn't fill up? 
>On MS SQL Server, I can run with TRUNCATE LOG ON CHECKPOINT if running in a test 
>scenario.
>
>TIA,
>-ms
>
>
>-- 
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

InnoDB disk file grows, never shrinks

[Michael S]

My InnoDB file is set to 60MB, and is not set to autoexpand.

When running stress tests against my server today, I got a message that the table was 
full and the test stopped. Sure enough, the InnoDB file was about 62MB.

My question:
I assume that the InnoDB file is the transaction log. Is there a command that I should 
be running to truncate the transaction log periodically so it doesn't fill up? On MS 
SQL Server, I can run with TRUNCATE LOG ON CHECKPOINT if running in a test scenario.

TIA,
-ms


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL index fun

[Dan Nelson]

In the last episode (Apr 03), Steve Phillips said:
> I have a table for ip data that i need to index to suit the following
> query
> 
> SELECT time,source_ip,bytes FROM data.tb_ipdata_0403 WHERE (time >
> 1049108400 AND time < 1051786799) AND (source_ip > 3389268097 AND
> source_ip < 3389268099)
> 
> if i created an index on the time column and an index of the
> source_ip column would the query then use these indexes or would i
> need to change my query ?

Create a compound index on either (time, source_ip) or (source_ip,
time).  Mysql cannot use two indexes on one table.
 

-- 
Dan Nelson
[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Blobbing data on MySQL

[delz]

Hi All,

Good day !!!

I'm trying to setup up a mysql server that will store scanned documents
(.doc, gif, jpeg, etc..) and will try to achieve this by blobbing data
into the mysql server. I find this to be very useful for archiving old piles
of paper and scanning them before they worn out. I also need to create a
database for it of course,  that will store the scanned documents into the
mysql server. This of course needs a lot of disk space on the hard drive of
the server specially if you have tons of documents to scan. Blobbing data
into the mysql server will obviously consume lots of disk space and if it
turns to be that way, I need another hard disk to store the blob data. Using
the rpms to install mysql the path where  the database are installed is at
/var/lib/mysql, if I install it via tarball I would install it at
/usr/local/mysql, my question is how do I make a path for my blob data into
another hard disk in case the primary hard disk gets full so that the data
will be saved on another hard drive. I would want to achieve this kind of
setup for me to have more options rather than setting up another server to
store the data. I would appreciate if someone could help me on this.

Regards,

Delz



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: [MySQL] RE: Question: Connecting MySQL with DreamWeaver MX on Windows 2000

[Ashley M. Kirchner]

[EMAIL PROTECTED] wrote:

I need to know how to set it up and how to connect.

   How to setup what?  There's is no setup that you have to do for DW. 
Just define your site as local and start coding.  As for connecting, 
that's specific to what you're using.  If you're using PHP, read its manual.

MySQL is already installed but there is no database, no tables.
 

   So?  Create them.  Again, read the manual.  MySQL has a very 
extensive manual available.

--
H| I haven't lost my mind; it's backed up on tape somewhere.
 +
 Ashley M. Kirchner    .   303.442.6410 x130
 IT Director / SysAdmin / WebSmith . 800.441.3873 x130
 Photo Craft Laboratories, Inc.. 3550 Arapahoe Ave. #6
 http://www.pcraft.com . .  ..   Boulder, CO 80303, U.S.A. 





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: external connection

[Daniel Kasak]

Lecul, Fred wrote:

Hmm...

Yeah, its not connecting!

Im getting:

ERROR 1130: Host '10.x.x.x' is not allowed to connect to this MySQL server

Any idea's??

Fred
 

Have a look at http://www.mysql.com/doc/en/Adding_users.html

Note the example about a page down that says:

mysql> GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED]
   -> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
This will set up a user 'monty' who can connect from 'localhost' with 
the password 'some_pass'.

You need to use the same syntax, but instead of 'localhost' use '10.%' 
or something like that.
The percentage sign (%) is a wildcard.

eg:

mysql> GRANT ALL PRIVILEGES ON *.* TO monty@'10.%'
   -> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
I think you need the quotes around the ip address part. I haven't used 
the grant commands for a while.

See how you go. If you still have problems, it really would help if you 
tell us what grant commands you've used so far.

--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: www.nusconsulting.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: JDBC can't connect, but command line can...

[Todd O'Bryan]

OK. I'm an idiot.

It suddenly hit me today that my code worked at home, but not at 
school. Then I remembered that we have a proxy server at school.
I disabled the SOCKS proxy, and, sure enough, everything works now.

There are disadvantages to just changing a Home/School setting, 
especially if you forget what all is involved in the switch.

Color me stupid,
Todd
On Wednesday, April 2, 2003, at 10:56  AM, Mark Matthews wrote:

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Todd O'Bryan wrote:
| I've managed to get mysql up and running again (I don't know how) but
| JDBC won't connect to it.
|
| Here's my little simple code:
| 
| import java.sql.*;
| import java.io.*;
|
| public class MySQLTester {
|
| public static void main(String[] args) throws Exception {
| Class.forName("com.mysql.jdbc.Driver");
| System.out.println("Loaded Driver...");
|
| DriverManager.setLogWriter(new PrintWriter(System.out));
|
|
| Connection con =
| DriverManager.getConnection("jdbc:mysql://localhost/test","tobryan1",
| "aoeuidhtns");
| System.out.println("Got connection...");
|
| Statement s = con.createStatement();
| s.executeUpdate("CREATE TABLE students (login char(8), last
| VARCHAR(20), first VARCHAR(20), " +
| "nickname VARCHAR(20), course CHAR(4), period
| INT)");
| }
| }
| 
| And here's what happens:
|
| [iBook:18]> java MySQLTester
| Loaded Driver...
| DriverManager.getConnection("jdbc:mysql://localhost/test")
| trying
| driver[className=com.mysql.jdbc.Driver,[EMAIL PROTECTED]
|
| and it hangs forever.
|
| -
| I can connect to mysql using the same user name and password, 
however
|
| [iBook:20]> mysql -u tobryan1 -p
| Enter password:
| Welcome to the MySQL monitor.  Commands end with ; or \g.
| Your MySQL connection id is 9 to server version: 4.0.12-standard
|
| Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
|
| mysql> use test;
| Database changed
| mysql> show tables;
| Empty set (0.00 sec)
|
| mysql>
| -
| I've searched for info on troubleshooting the JDBC connection and
| skimmed the O'Reilly book by George Reese, but to no avail.
|
| Should I just give up, or is there something I can do to figure out
| what's going wrong?
|
| Thanks,
| Todd

When you don't specify a hostname (and 'localhost' doesn't count, use
'127.0.0.1') to the mysql commandline client, it uses Unix domain
sockets to connect to the server.
JDBC has to use TCP/IP, because Java doesn't have support for Unix
domain sockets.
What happens if you do:

mysql -h 127.0.0.1 -u tobryan1 -p

What happens if you telnet to 'localhost 3306'...does the server 
answer,
or do you just sit forever?

If neither of these work, than neither will JDBC...do you have a
firewall setup on your machine that would block 127.0.0.1? Was mysqld
started with '--skip-networking' ???
	-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.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+iwg5tvXNTca6JD8RAuwwAKC86/iQI35O+DYV89O4bAdDnDf8zACgma1w
HdDjewEWMRj5/0gYmM9MARo=
=ay/F
-END PGP SIGNATURE-


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: external connection

[Lecul, Fred]

Hmm...

Yeah, its not connecting!

Im getting:

ERROR 1130: Host '10.x.x.x' is not allowed to connect to this MySQL server

Any idea's??

Fred

-Original Message-
From: Daniel Kasak [mailto:[EMAIL PROTECTED] 
Sent: Friday, 4 April 2003 1:42 PM
To: Lecul, Fred; [EMAIL PROTECTED]
Subject: Re: external connection


Lecul, Fred wrote:

>Tried that and it didn't work
>
>Is it possible that the port 3306 is blocked? And if it is, how can I 
>open this?
>
>Thanks
>
>Fred
>  
>
It's possible.
Maybe post the grant commands you used (minus the password of course) to 
set up the user account.
If possible try to connect with the mysql command-line client:

mysql -h HOSTNAME -u USERNAME -p

See if that gives any errors, and if so post them also. It's a bit hard 
to say where the problem is otherwise.

-- 
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: www.nusconsulting.com


**   IMPORTANT MESSAGE  **
This e-mail message is intended only for the addressee(s) and contains information 
which may be confidential. If you are not the intended recipient please advise the 
sender by return email, do not use or disclose the contents, and delete the message 
and any attachments from your system. Unless specifically indicated, this email does 
not constitute formal advice or commitment by the sender or the Commonwealth Bank of 
Australia (ABN 48 123 123 124) or its subsidiaries.
**


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: external connection

[Daniel Kasak]

Lecul, Fred wrote:

Tried that and it didn't work

Is it possible that the port 3306 is blocked? And if it is, how can I open
this?
Thanks

Fred
 

It's possible.
Maybe post the grant commands you used (minus the password of course) to 
set up the user account.
If possible try to connect with the mysql command-line client:

mysql -h HOSTNAME -u USERNAME -p

See if that gives any errors, and if so post them also. It's a bit hard 
to say where the problem is otherwise.

--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: www.nusconsulting.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: A question about using C API in mysql (linux platform)

[Martin]

Li:
you have to link in the mysql library mysqlclient.a in your makefile
Here is my makefile which you may use for reference
# This assumes the MySQL software is installed in /usr/local/mysql
inc  := /cygdrive/g/mysql/mysql-debug-4.0.12-pc-linux-i686/include
lib  := /cygdrive/g/mysql/mysql-debug-4.0.12-pc-linux-i686/lib

# If you have not installed the MySQL software yet, try this instead
#inc  :=
/cygdrive/g/mysql/mysql-debug-4.0.12-pc-linux-i686/include:$(HOME)/mysql-4.0
/include
#lib  := $(HOME)/mysql-4.0/libmysqld

CC   := gcc
CPPFLAGS := -I$(inc) -D_THREAD_SAFE -D_REENTRANT
CFLAGS   := -g -W -Wall
LDFLAGS  := -static
# You can change -lmysqld to -lmysqlclient to use the
# client/server library
#LDLIBS= -L$(lib) -lmysqld -lz -lm -lcrypt
LDLIBS= libmysqlclient.a -lz -lm -lcrypt

ifneq (,$(shell grep FreeBSD /COPYRIGHT 2>/dev/null))
# FreeBSD
LDFLAGS += -pthread
else
# Assume Linux
LDLIBS += -lpthread
endif

# This works for simple one-file test programs
sources := $(wildcard *.c)
objects := $(patsubst %c,%o,$(sources))
targets := $(basename $(sources))

all: $(targets)

clean:
 rm -f $(targets) $(objects) *.core

Keep us apprised,
Martin
- Original Message -
From: "Li Yang" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Thursday, April 03, 2003 7:32 PM
Subject: A question about using C API in mysql (linux platform)


Hi, I'm a newbie to MySQL
Now I am using C to connect mysql  in Linux
The heaser souce code like:
#include 
#include 
#include 
   and After I use "gcc test.c -L /usr/local/mysql/lib/ -shared " to compile
it , and when I run the a.out ,it always say that "Segmentation Fault "
   and If I use "gcc test.c -L /usr/local/mysql/lib/ -static " to compile it
,It says that "undefined reference to 'mysql_init' "
   How should I do ?
   Thanks!


Best Regards
Li Yang

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: external connection

[Lecul, Fred]

Tried that and it didn't work

Is it possible that the port 3306 is blocked? And if it is, how can I open
this?

Thanks

Fred

-Original Message-
From: Daniel Kasak [mailto:[EMAIL PROTECTED] 
Sent: Friday, 4 April 2003 12:09 PM
To: Lecul, Fred
Cc: '[EMAIL PROTECTED]'
Subject: Re: external connection


Lecul, Fred wrote:

>Hi
> 
>Im new to mysql and am trying to connect externally.
> 
>I have hashed out the skip-networking in the my.cnf, created a new user 
>and gave permissions but it seems it just doent want to accept the 
>connection. I am trying to connect using free-Mascon.
> 
>Any idea's on what I can do?
> 
>Frederic Lecul
>
>  
>
Have you reloaded the grant tables? You have to do that when you alter / 
add users / permissions etc.

mysqladmin reload -p

-- 
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: www.nusconsulting.com


**   IMPORTANT MESSAGE  **
This e-mail message is intended only for the addressee(s) and contains information 
which may be confidential. If you are not the intended recipient please advise the 
sender by return email, do not use or disclose the contents, and delete the message 
and any attachments from your system. Unless specifically indicated, this email does 
not constitute formal advice or commitment by the sender or the Commonwealth Bank of 
Australia (ABN 48 123 123 124) or its subsidiaries.
**


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL index fun

[Steve Phillips]

Hey People :-)

I have a table for ip data that i need to index to suit the following query

SELECT time,source_ip,bytes FROM data.tb_ipdata_0403 WHERE (time > 
1049108400 AND time < 1051786799) AND (source_ip > 3389268097 AND source_ip 
< 3389268099)

if i created an index on the time column and an index of the source_ip 
column would the query then use these indexes or would i need to change my 
query ?

(I was thinking of an index on source_ip and then dropping all entries for 
the customer ip range into a tmp table and doing the summing on that as the 
table should be a lot smaller)

--
Steve Phillips
Professional Slacker
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: [MySQL] RE: Question: Connecting MySQL with DreamWeaver MX on Windows 2000

[kira]

I need to know how to set it up and how to connect.

MySQL is already installed but there is no database, no tables.


- Original Message - 
From: Ashley M. Kirchner 
To: Marco Chaires 
Cc: [EMAIL PROTECTED] ; [EMAIL PROTECTED] 
Sent: Thursday, April 03, 2003 9:16 PM
Subject: Re: [MySQL] RE: Question: Connecting MySQL with DreamWeaver MX on Windows 2000


Quoting Marco Chaires <[EMAIL PROTECTED]>:

> i dont really recommend that combination but its possible... good luck..!

   Why not?  If you do it right, it works just fine.  I develop mainly on my 
laptop before uploading to the main server.  I have MySQL installed on the main 
server, and on my laptop.  When I'm working in DW, using PHP, all I have to do 
is connect to localhost to get to MySQL.  When I upload the page, it works fine 
because it's now querying the local MySQL server.

   You can go further, I also have a dedicated MySQL server that's different 
from the main webserver.  On both the webserver as well as my laptop, the $host 
point to that address.  Either way, you CAN develop MySQL specific scripts 
using PHP, in Dreamweaver.

-- 
R | I haven't lost my mind; it's backed up on tape somewhere.
  +
  Ashley M. Kirchner    .   303.442.6410 x130
  IT Director / SysAdmin / WebSmith . 800.441.3873 x130
  Photo Craft Laboratories, Inc.. 3550 Arapahoe Ave. #6
  http://www.pcraft.com . .  ..   Boulder, CO 80303, U.S.A. 

A question about using C API in mysql (linux platform)

[Li Yang]

Hi, I'm a newbie to MySQL
Now I am using C to connect mysql  in Linux 
The heaser souce code like:
#include 
#include 
#include
   and After I use "gcc test.c -L /usr/local/mysql/lib/ -shared " to compile it , and 
when I run the a.out ,it always say that "Segmentation Fault "
   and If I use "gcc test.c -L /usr/local/mysql/lib/ -static " to compile it ,It says 
that "undefined reference to 'mysql_init' "
   How should I do ?
   Thanks!


Best Regards
Li Yang

Re: external connection

[Daniel Kasak]

Lecul, Fred wrote:

Hi

Im new to mysql and am trying to connect externally.

I have hashed out the skip-networking in the my.cnf, created a new user and
gave permissions but it seems it just doent want to accept the connection. I
am trying to connect using free-Mascon. 

Any idea's on what I can do?

Frederic Lecul

 

Have you reloaded the grant tables? You have to do that when you alter / 
add users / permissions etc.

mysqladmin reload -p

--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: www.nusconsulting.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

external connection

[Lecul, Fred]

Hi
 
Im new to mysql and am trying to connect externally.
 
I have hashed out the skip-networking in the my.cnf, created a new user and
gave permissions but it seems it just doent want to accept the connection. I
am trying to connect using free-Mascon. 
 
Any idea's on what I can do?
 
Frederic Lecul




**   IMPORTANT MESSAGE  **
This e-mail message is intended only for the addressee(s) and contains information 
which may be confidential. If you are not the intended recipient please advise the 
sender by return email, do not use or disclose the contents, and delete the message 
and any attachments from your system. Unless specifically indicated, this email does 
not constitute formal advice or commitment by the sender or the Commonwealth Bank of 
Australia (ABN 48 123 123 124) or its subsidiaries.
**

Re: [MySQL] RE: Question: Connecting MySQL with DreamWeaver MX on Windows 2000

[Ashley M. Kirchner]

Quoting Marco Chaires <[EMAIL PROTECTED]>:

> i dont really recommend that combination but its possible... good luck..!

   Why not?  If you do it right, it works just fine.  I develop mainly on my 
laptop before uploading to the main server.  I have MySQL installed on the main 
server, and on my laptop.  When I'm working in DW, using PHP, all I have to do 
is connect to localhost to get to MySQL.  When I upload the page, it works fine 
because it's now querying the local MySQL server.

   You can go further, I also have a dedicated MySQL server that's different 
from the main webserver.  On both the webserver as well as my laptop, the $host 
point to that address.  Either way, you CAN develop MySQL specific scripts 
using PHP, in Dreamweaver.

-- 
R | I haven't lost my mind; it's backed up on tape somewhere.
  +
  Ashley M. Kirchner    .   303.442.6410 x130
  IT Director / SysAdmin / WebSmith . 800.441.3873 x130
  Photo Craft Laboratories, Inc.. 3550 Arapahoe Ave. #6
  http://www.pcraft.com . .  ..   Boulder, CO 80303, U.S.A. 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: table structure design

[Dan Rossi]

i cant seem to access the server times out :|

http://www.research.att.com/sw/tools/graphviz/download.html

-Original Message-
From: Nicholas [mailto:[EMAIL PROTECTED] Behalf Of
Nicholas Spagnoletti
Sent: Friday, April 04, 2003 1:28 AM
To: [EMAIL PROTECTED]
Subject: Re: table structure design


Hi

About Entity Relationship Diagrams: I use Graphviz to generate ERD's on
the fly, from the database. Graphviz is very cool:
http://www.research.att.com/sw/tools/graphviz/

Graphviz draws graphs from files written in its language (called 'dot')
Your PHP script (or language of choice) needs to get the tables and
fields from MySQL, take your naming conventions etc. into account, and
output a dot file that will look like something like this in its
simplest form:


digraph schema {
user [shape=record, label="ID|name|surname"];
user -> user_group;
user_group [shape=record; label="ID|groupname"];
}


Pipe that to dotty (part of the graphviz suite) and it will display a
graph with one block called user (and its fields) and one block called
user_group (and its fields) and a line joining them.
So all you need to do is write your own script to output all your tables
and their relationships and dotty will draw it nicely for you.


On Thu, 2003-04-03 at 16:12, Cal Evans wrote:
> Lots of them. None cheap.  What ever you do, steer clear of the one at
> www.thekompany.com. It's a piece of crap.  I bought a version and then
> foolishly bought an upgrade thinking it would be better.  it's not and the
> primary programmer for the project is very arrogant on the mailing list
> setup for support.
>
> ERWin is a great tool but it does not support MySQL directly. (You could
use
> ODBC to reverse engineer a database though) The same with ERStudio from
> Embarcadero (sp?)  Great tool, expensive though.
>
> =C=
>
> - Original Message -
> From: "Daniel Rossi" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, April 03, 2003 12:37 AM
> Subject: table structure design
>
>
> is there any table structure design program in a graphical layout for
> windows available ? i have tables and fields on paper but would like a way
> to be able to lay them out on a screen and show which table joins to what
> and what keys it uses let me know thanks
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: self foreign keys and InnoDB is it possible ?

[Daevid Vincent]

I don't have the answer to your question, but I find your question very
interesting.

One observation,and I could be wrong, is that "deleting 1 has to delete
1,2,4,5' doesn't seem to be legal as far as Foreign Key constraints go. 

As I read your table, 1/aa has no father (-1), 2/bb has father 1/aa, but
4/dd and 5/ee have father of 2/bb NOT 1/aa, 1/aa is a grandfather. While I
see your logic (if 2/bb doesn't exist, then 4/dd and 5/ee can't exist
either), but you are getting into recursion here I think, which I'm pretty
sure is beyond the scope of SQL. You might have to break this into a routine
in whatever language you're using, one that traverses your tree and deletes
the nodes. I'm sure there are some efficient algorithms out there for this
type of thing.

> -Original Message-
> From: alx [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, April 03, 2003 5:10 PM
> To: [EMAIL PROTECTED]
> Subject: self foreign keys and InnoDB is it possible ?
> 
> 
> hi all
> 
> I'm creating a table like this
> 
> CREATE TABLE test (
> id  integer not null primary key auto_increment,
> testchar(20),
> father  integer key default ='-1' not null,
> FOREIGN KEY (id) RERERENCES test(padre) ON DELETE CASCADE
> ) Type=InnoDB;
> 
> But I made some mistakes on it, because i want it to act differently
> from now
> 
> I want obtain something like this
> 
> table row example:
> id  test  father
> 1   'aa'  -1
> 2   'bb'  1
> 3   'cc'  -1
> 4   'dd'  2
> 5   'ee'  2
> 6   'ff'  3
> so relatives chains are
> 1-2-4
>\-5
> 
> 3-6
> 
> and then I want to delete all child from a id that is their father.
> 
> example 
> deleting 3 has to delete 3 and 6
> deleting 2 has to delete 2,4,5
> deleting 1 has to delete 1,2,4,5
> 
> I hope this could be enough to explain my SQL problem...
> 
> TIA
> ALx
> -- 
> alx <[EMAIL PROTECTED]>
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?> [EMAIL PROTECTED]
> 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to prevent a user from dropping/creating a database

[Chris Jaeger]

Jeremy Zawodny wrote:
On Wed, Apr 02, 2003 at 01:46:00PM -0800, Chris Jaeger wrote:

Hi all,

	I'm wondering if there is some way to setup privileges in the grant 
tables such that a user can create or drop any arbitrary table in 
databases that user is associated with, but be unable to create or drop 
the databases themselves. I was hoping the tables_priv table would come 
to my rescue, but the MySQL documentation claims that you can't specify 
wildcards in the table_name column.


Give them CREATE and DROP privileges on the databases you'd like them
to be able to mess with.
	Thanks Jeremy, but I'm still having trouble. Perhaps I am setting this 
up wrong, but this doesn't seem to work. Assume that I have a user foo 
who wishes to use a database bar. Here is what I execute:

CREATE DATABASE bar;
GRANT SELECT, INSERT, DELETE, DROP, CREATE, UPDATE, INDEX, ALTER
  ON bar.*
  TO [EMAIL PROTECTED] IDENTIFIED BY 'pass';
	After this has gone through, I can see that the user foo has no 
privileges in the user table, and only the granted privileges in the db 
table. However, when connecting as the user foo, I can still execute the 
commands:

DROP DATABASE bar;
CREATE DATABASE bar;
	and they work. The user foo can't create/drop any other databases, but 
he can do this to bar, which unfortunately is not acceptable for my 
application (we are using symbolic links to database directories, and 
this sequence allows the user to remove the symlink and recreate the 
database under /var/lib/mysql, which is the data directory on our server).

	Any advice is appreciated.

Regards,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

self foreign keys and InnoDB is it possible ?

[alx]

hi all

I'm creating a table like this

CREATE TABLE test (
id  integer not null primary key auto_increment,
testchar(20),
father  integer key default ='-1' not null,
FOREIGN KEY (id) RERERENCES test(padre) ON DELETE CASCADE
) Type=InnoDB;

But I made some mistakes on it, because i want it to act differently
from now

I want obtain something like this

table row example:
id  test  father
1   'aa'  -1
2   'bb'  1
3   'cc'  -1
4   'dd'  2
5   'ee'  2
6   'ff'  3
so relatives chains are
1-2-4
   \-5

3-6

and then I want to delete all child from a id that is their father.

example 
deleting 3 has to delete 3 and 6
deleting 2 has to delete 2,4,5
deleting 1 has to delete 1,2,4,5

I hope this could be enough to explain my SQL problem...

TIA
ALx
-- 
alx <[EMAIL PROTECTED]>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Question: Connecting MySQL with DreamWeaver MX on Windows 2000

[kira]

nah, i'll just test stuff off my website as usual

thanks though


- Original Message - 
From: Marco Chaires 
To: [EMAIL PROTECTED] ; [EMAIL PROTECTED] 
Sent: Thursday, April 03, 2003 8:59 PM
Subject: RE: Question: Connecting MySQL with DreamWeaver MX on Windows 2000


Yeap..

i dont really recommend that combination but its possible... good luck..!

Marco Chaires
Depto. de Sistemas
Miciudad.com 
[EMAIL PROTECTED] 




-Mensaje original-
De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Enviado el: Jueves, 03 de Abril de 2003 05:17 p.m.
Para: [EMAIL PROTECTED]
Asunto: Question: Connecting MySQL with DreamWeaver MX on Windows 2000


Question: can I install mySql on my computer and test php with dreamweaver
mx?

it's asking me to define a connection, which i've done in ultradev with
asp/IIS, but there aren't really instructions on getting this working for
me.  the dwmx help file sent me to mysql.com, where i grabbed the app and
installed it, but after that, there's not much to go on.

i've got win2k.  thanks for any help

~kira


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Question: Connecting MySQL with DreamWeaver MX on Windows 2000

[Marco Chaires]

Yeap..

i dont really recommend that combination but its possible... good luck..!

Marco Chaires
Depto. de Sistemas
Miciudad.com 
[EMAIL PROTECTED] 




-Mensaje original-
De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Enviado el: Jueves, 03 de Abril de 2003 05:17 p.m.
Para: [EMAIL PROTECTED]
Asunto: Question: Connecting MySQL with DreamWeaver MX on Windows 2000


Question: can I install mySql on my computer and test php with dreamweaver
mx?

it's asking me to define a connection, which i've done in ultradev with
asp/IIS, but there aren't really instructions on getting this working for
me.  the dwmx help file sent me to mysql.com, where i grabbed the app and
installed it, but after that, there's not much to go on.

i've got win2k.  thanks for any help

~kira


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Question: Connecting MySQL with DreamWeaver MX on Windows 2000

[kira]

Question: can I install mySql on my computer and test php with dreamweaver
mx?

it's asking me to define a connection, which i've done in ultradev with
asp/IIS, but there aren't really instructions on getting this working for
me.  the dwmx help file sent me to mysql.com, where i grabbed the app and installed 
it, but after that, there's not much to go on.

i've got win2k.  thanks for any help

~kira 

Re: How to prevent a user from dropping/creating a database

[Jeremy Zawodny]

On Wed, Apr 02, 2003 at 01:46:00PM -0800, Chris Jaeger wrote:
> Hi all,
> 
>   I'm wondering if there is some way to setup privileges in the grant 
> tables such that a user can create or drop any arbitrary table in 
> databases that user is associated with, but be unable to create or drop 
> the databases themselves. I was hoping the tables_priv table would come 
> to my rescue, but the MySQL documentation claims that you can't specify 
> wildcards in the table_name column.

Give them CREATE and DROP privileges on the databases you'd like them
to be able to mess with.

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

Jeremy
-- 
Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/

MySQL 4.0.8: up 59 days, processed 2,009,667,903 queries (390/sec. avg)

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Question:

[Michael Shulman]

Kira, please correct your subject line and ask your question again.

-ms


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] 
Sent: Thursday, April 03, 2003 3:52 PM
To: [EMAIL PROTECTED]
Subject: Question: 


Question: can I install mySql on my computer and test php with dreamweaver
mx?

it's asking me to define a connection, which i've done in ultradev with
asp/IIS, but there aren't really instructions on getting this working for
me.

i've got win2k.  thanks for any help

~kira


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Question:

[kira]

Question: can I install mySql on my computer and test php with dreamweaver mx?

it's asking me to define a connection, which i've done in ultradev with asp/IIS, but 
there aren't really instructions on getting this working for me.

i've got win2k.  thanks for any help

~kira

RE: Can we make some C, Java based "Mysql App Server"

[Dan Rossi]

sorry i'm gonna learn java soon but i only develop in php right this minute
thats my level :| , but the OO in java is similir to php so i an pick it up

-Original Message-
From: Martin Gainty [mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 12:15 AM
To: Daniel Rossi; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Can we make some C, Java based "Mysql App Server"


Daniel
How about 1 working Java or C or C++ example which uses MySQL
Personally every example I have used (both Linux and Windows) uses libraries
which
cannot resolve the simplest MySQL functions with no ability to recover.
Very frustrating.
Thank You,
Martin
- Original Message -
From: "Daniel Rossi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, April 02, 2003 11:54 PM
Subject: Re: Can we make some C, Java based "Mysql App Server"


hmm a middleware product would be good , extra processing=time ?

also stored procedures would be excellent ,

 also maybe a middleware product to load balance between slave and master
and delegate slaves if a master goes down is there such a thing ?

>>> Nitin Nanivadekar <[EMAIL PROTECTED]> 04/03/03 04:41pm >>>
Dear Friends,
We all know Mysql is a beautiful database engine but
there are some things missing. Even Mysql team
acknowkedges the need in their ToDo list.
i was thinking of designing a Java, C based
application server that acts as a gridge bewween the
applications & the database. This server can take care
of various aspects & especially as a Pre-Processor for
aome nice queries such as "Connect By", Stored
procedures, triggers etc.
Mysql team will require beyond ver 5.0 to give us all
this.
pls comment :)
-Nitin

__
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
http://tax.yahoo.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Request: please use meaningful subject lines

[Jeremy Zawodny]

On Wed, Apr 02, 2003 at 11:14:56AM -0800, Michael Shulman wrote:
> 
> Please try to use more informative subject lines in your
> queries. You'll be more likely to get good help quickly.

Agreed.

I simply delete messages with subject lines that don't say anything
specific.

I wish ISPs asked all their subscribers to read some basic
microcontent guidelines.

http://www.useit.com/alertbox/980906.html

It takes virtually no time.

Maybe the "welcome" message for new subscribers could point to it?

Jeremy
-- 
Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/

MySQL 4.0.8: up 59 days, processed 2,009,284,069 queries (391/sec. avg)

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Problem with sum()

[LeTortorec, Jean-Louis]

Thanks, I'll do that.




-Original Message-
From: gerald_clark [mailto:[EMAIL PROTECTED] 
Sent: Thursday, April 03, 2003 4:52 PM
To: LeTortorec, Jean-Louis
Cc: '[EMAIL PROTECTED]'
Subject: Re: Problem with sum()


Because neither 0.7 nor 0.1 have an exact binary floating point 
reprsentation.
Use Decimal type instead.

LeTortorec, Jean-Louis wrote:

>Hello every one,
>
>I have a simple table, with a "float" field called quantity. In this 
>table, there are 2 records: 1 with quantity=0.7, and 1 with 
>quantity=0.1.
>
>When I do a "select sum(quantity) from mytable", I got 0.798956919 
>instead of 0.8.
>
>Does any body know why?
>
>Thanks.
>
>Jean-Louis
>
>  
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Problem with sum()

[Jennifer Goodie]

Because you are using a float.  There has been much discussion of this on
the list, search the archives.  Floats aren't so good if you need your math
to be right.

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

> -Original Message-
> From: LeTortorec, Jean-Louis [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 03, 2003 1:40 PM
> To: '[EMAIL PROTECTED]'
> Subject: Problem with sum()
>
>
> Hello every one,
>
> I have a simple table, with a "float" field called quantity.
> In this table, there are 2 records: 1 with quantity=0.7, and 1 with
> quantity=0.1.
>
> When I do a "select sum(quantity) from mytable", I got 0.798956919
> instead of 0.8.
>
> Does any body know why?
>
> Thanks.
>
> Jean-Louis
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problem with sum()

[gerald_clark]

Because neither 0.7 nor 0.1 have an exact binary floating point 
reprsentation.
Use Decimal type instead.

LeTortorec, Jean-Louis wrote:

Hello every one,

I have a simple table, with a "float" field called quantity.
In this table, there are 2 records: 1 with quantity=0.7, and 1 with
quantity=0.1.
When I do a "select sum(quantity) from mytable", I got 0.798956919
instead of 0.8.
Does any body know why?

Thanks.

Jean-Louis

 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problem with sum()

[LeTortorec, Jean-Louis]

Hello every one,

I have a simple table, with a "float" field called quantity.
In this table, there are 2 records: 1 with quantity=0.7, and 1 with
quantity=0.1.

When I do a "select sum(quantity) from mytable", I got 0.798956919
instead of 0.8.

Does any body know why?

Thanks.

Jean-Louis

Re: Migrate mysql from SunOS 5.8 to Windows 2000

[Jannie Qu]

Thank you Martin to give me good suggestion.

As we know, windows 2000 is not as stable as unix. If other than operating 
system and hardware perspective, are there any other difference of mysql 
running on unix and mysql running on windows?

Thank you,
Jannie
From: "Martin" <[EMAIL PROTECTED]>
To: "Jannie Qu" <[EMAIL PROTECTED]>
CC: <[EMAIL PROTECTED]>
Subject: Re: Migrate mysql from SunOS 5.8 to Windows 2000
Date: Thu, 3 Apr 2003 14:15:29 -0700
Not if
0)strong processor (at least 2GHz)
1)you have enough RAM (1GB will do)
2)have enough SCSI or RAID Drives (with hopefully 1GB Free)
3)gets tricky with Process Management as Win2k process Management utilities
are sparse (no cron or kill utilities)
-Martin
- Original Message -
From: "Jannie Qu" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 03, 2003 1:24 PM
Subject: Migrate mysql from SunOS 5.8 to Windows 2000
> Hi, group,
>
> Greeting.
>
> We will migrate MySQL 3.47 from SunOS to Windows 2000. (I guess I have 
to
> use mysqldump).
>
> Well, I wonder any one of you who knows whether there is any forseeable
> problem of using production/busy mysql database on windows 2000 
operating
> platform?
>
> Thank you,
> Jannie
>
>
>
>
>
> _
> Add photos to your messages with MSN 8. Get 2 months FREE*.
> http://join.msn.com/?page=features/featuredemail
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


_
Help STOP SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Migrate mysql from SunOS 5.8 to Windows 2000

[Leif B. Kristensen]

On Thu, 03 Apr 2003 20:24:23 +, "Jannie Qu" <[EMAIL PROTECTED]>
wrote:

>We will migrate MySQL 3.47 from SunOS to Windows 2000.

That's the dumbest thing I've heard for a long time. It sounds like a
Pointy Haired Boss kind of decision.

regards,
-- 
Leif Biberg Kristensen 
http://solumslekt.org/
mail to leif at solumslekt dot org

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Migrate mysql from SunOS 5.8 to Windows 2000

[Martin]

Not if
0)strong processor (at least 2GHz)
1)you have enough RAM (1GB will do)
2)have enough SCSI or RAID Drives (with hopefully 1GB Free)
3)gets tricky with Process Management as Win2k process Management utilities
are sparse (no cron or kill utilities)
-Martin
- Original Message -
From: "Jannie Qu" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 03, 2003 1:24 PM
Subject: Migrate mysql from SunOS 5.8 to Windows 2000


> Hi, group,
>
> Greeting.
>
> We will migrate MySQL 3.47 from SunOS to Windows 2000. (I guess I have to
> use mysqldump).
>
> Well, I wonder any one of you who knows whether there is any forseeable
> problem of using production/busy mysql database on windows 2000 operating
> platform?
>
> Thank you,
> Jannie
>
>
>
>
>
> _
> Add photos to your messages with MSN 8. Get 2 months FREE*.
> http://join.msn.com/?page=features/featuredemail
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql equivalent for oracle.jdbc.pool

[Mark Matthews]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
abjett wrote:
| Does anyone know of a mysql equivalent for oracle.jdbc.pool?
|
| I am modifying code that uses OracleConnectionCacheImpl,
| OracleConnectionPoolDataSource, classes I from oracle.jdbc.pool.
|
| Thanks for any help
Use DBCP (http://jakarta.apache.org/commons/dbcp/) with Connector/J.

	-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.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQE+jJ8ctvXNTca6JD8RAjKtAKCkLBDHD46UR72XuCYsmRQHvovLzgCgvxsl
r6+bNgfEMeNFNP666n5+5Kg=
=A8Ku
-END PGP SIGNATURE-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Re: Help with 4.0.12 on WinXP

[ir000387]

Mark,

Your suggestion certainly sounds plausible. However, I have no control over the 
connections with Zeos Database Objects. Even though I open the actual database 
connection at the start of the program, it appears that each query forces a new 
connect/disconnect.  In fact, in perusing through the source code, the first operation 
on an OPEN is, if ACTIVE then DISCONNECT.

I will contact the Zeos developers and see if they have a workaround for this.

Thanks,
Dan Cumpian

---Original Message---
From: Mark Matthews <[EMAIL PROTECTED]>
Sent: 04/03/03 12:02 PM
To: Dan Cumpian <[EMAIL PROTECTED]>
Subject: Re: Help with 4.0.12 on WinXP

> 
> -BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Dan Cumpian wrote:
| Hello,
|
|
|
| I am having the following problem that I've been able to consistently
| replicate:
|
|
|
| I am using code written in Delphi with Zeos Database components and am
| having a problem with a query returning "server connection error". I am
| inserting a row into a table and then immediately selecting a row from a
| table . This error occurs whether I select out of the table I inserted
| the new row into or from any other table. After inserting 3700-3900
| rows, the select will be unable to connect. For at least 10-30 seconds,
| I cannot connect to MySQL, even with MySQL-Front (I get a "Can't connect
| to server" error).  There are no errors being logged. After the 10-30
| seconds passes, I can resume the program and it happens again after
| 3700-3900 rows.
|
|
|
| This does not happen on Windows 2000, only Windows XP (both Home and
| Pro). All connection are through Localhost.
|
|
|
| My configuration file is:
|
|
|
| [mysqld]
|
| set-variable=key_buffer_size=18M
|
| set-variable=myisam_sort_buffer_size=8M
|
| set-variable= max_allowed_packet=16M
|
|
|
| Table type is MyISAM.
|
|
|
| Machine is a P4-2.2Ghz with SCSI hard disks.
|
|
|
| Can anyone please suggest what I might be able to do to resolve this
| issue?

My guess is that you are making a new connection every time you do an
operation. Windows XP has a paltry amount of TCP/IP ports that can be
used for outbound connections (around 4000, which should sound
'coincidental' to you, given that your failures happen between 3700 and
3900)...These ports are shared for _all_ outbound TCP/IP from your box,
and can take up to 4 minutes to 'clear' so they can be re-used.

You should consider only opening the MySQL connection _once_ in your
program...Otherwise you need to use a registry hack to change the number
of 'ephemeral' ports that Windows XP will use (search the mailing list,
or the myodbc mailing list for a pointer to that article).

-Mark


- --
MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/";>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
~<___/ http://www.mysql.com";>www.mysql.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org";>http://enigmail.mozdev.org

iD8DBQE+jGkHtvXNTca6JD8RAu3kAJ41j4ulfljw8150u66inBwKHFTvtwCfYc4G
7ROQnT1NjSPAHMeJgQ1ptpE=
=v7fv
-END PGP SIGNATURE-

> 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Migrate mysql from SunOS 5.8 to Windows 2000

[Jannie Qu]

Hi, group,

Greeting.

We will migrate MySQL 3.47 from SunOS to Windows 2000. (I guess I have to 
use mysqldump).

Well, I wonder any one of you who knows whether there is any forseeable 
problem of using production/busy mysql database on windows 2000 operating 
platform?

Thank you,
Jannie




_
Add photos to your messages with MSN 8. Get 2 months FREE*.  
http://join.msn.com/?page=features/featuredemail

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql equivalent for oracle.jdbc.pool

[abjett]

Does anyone know of a mysql equivalent for oracle.jdbc.pool?

I am modifying code that uses OracleConnectionCacheImpl,
OracleConnectionPoolDataSource, classes I from oracle.jdbc.pool.

Thanks for any help

Bob



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Suggestions for choosing GUI Language that has a MySQL DB backend

[dpgirago]

The application will be run on windows2000. Or maybe Linux ... there is some
choice ;-)

>>Will this run on Windows or Linux?


Thank you, Martin, Mitko, John Griffin, David Christensen, Michael T. Babcock,
and sundisk
for your replies.

(Sorry for the delay...I work in several locations on Thursdays)

Delphi or Kylix... So it sounds like I'm headed for Linux-land.

David



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: date ranges

[Bruce Feist]

Bruce Feist wrote:

Instead, if the four dates are s1, e1, s2, and e2 (s=start, e=end), we
 

want:
 

s1 <= e2 /* first range can't start after second range ends */
AND
s2 <= e1 /* second range can't start after first range ends */   

Bruce Feist also wrote:

Your original suggestion works if the two ranges partially 
overlap, but not if one is wholly contained in the other.

Jones, Clifton R [CC] wrote:

Not true... a pencil and paper excercise shows it does, indeed, work.
 

What you quoted above wasn't Matt's original suggestion; it was my 
suggested alternative based on my above comments.  So, yes, I believe it 
works.  The original, and a counterexample I came up with for it, is in 
an earlier post.

Bruce Feist



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Thoughts on MySQL training?

[hcir]

i attended this class back in September, it was MORE than worth the 
cost!!

- hcir

mysql sql

On Wednesday, Apr 2, 2003, at 12:26 America/Anchorage, Rachel Rodriguez 
wrote:

I should have been more specific: we're looking at the
"Using and Managing MySQL" training.  Opinions
appreciated.
~RR
--- Rachel Rodriguez <[EMAIL PROTECTED]>
wrote:
I was wondering if anyone on the list has attended
any
of the training listed on the mysql.com site.  If
yes,
was it worth the costs in your opinion?  I'm trying
to
justify the costs to my management.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: date ranges

[Bruce Feist]

Matt Gostick wrote:

Sarah Heffron wrote:

I have a date range (start date and end date) supplied by the user 
and I also have information in a table that has start dates and 
end dates. I want to select everything in the table whose date range 
overlaps in any way with the date range given by the user. 
   

Matt Gostick's proposed solution:

Well...  if you were given a start date of 2003-01-01 and end date of
2003-01-31...
select *
from table_name
where start_date between "2003-01-01" and "2003-01-31"
  or end_date   between "2003-01-01" and "2003-01-31"
 

Bruce Feist's response:

Example: start_date = "2002-01-01" and end_date = 2003-02-01".

Instead, if the four dates are s1, e1, s2, and e2 (s=start, e=end), we want:
s1 <= e2 /* first range can't start after second range ends */
AND
s2 <= e1 /* second range can't start after first range ends */
   

Matt's response to Bruce's response:

Okay, so s1,e1 are supplied by the user and s2,e2 are in your tables
right?  

That's irrelevant to the form of the condition, but yes.

s1 <= e2 ... yeah that's what my original query does.
e1 >= s2 ... what?  yeah... it's an end date.. it's gonna be great than
a start date by nature.
But it's an end date from another range.  There's not necessarily any
relationship between the two.
Your original suggestion works if the two ranges partially overlap, but
not if one is wholly contained in the other.
Bruce Feist





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

new user needs help getting started

[Thomas Mouser]

I have two machines that I have installed red hat 8.0 on and with it
the mysql v 3.23.52. I have used admin and query tools to communicate
with both from a local machine using both localhost via unix socket and
via host name via tcp. When trying to communicate over the net from
a different machine using an account that is defined with a host of %
I get the same error on both everytime.
for example
mysqladmin: connect to server at 'prodwebsvr' failed
error: 'Lost connection to MySQL server during query'
the log shows the following in each example
Number of processes running now: 1
mysqld process hanging, pid 5625 - killed
030403 11:40:19  mysqld restarted
the same is true when I do a query
I'm sure there is a simple explanation but I have not found it.
I would appreciate any help.
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Conception - Tree - Recursivity -Address book - Query speed

[Leif B. Kristensen]

On Wed, 02 Apr 2003 16:53:44 +0200, Grégoire Dubois
<[EMAIL PROTECTED]> wrote:

>Creating the tree doesn't give me problem. Where I ask me some 
>questions, is the speed to get the whole tree from the database in a 
>recursive way.

I've made a PHP script doing genealogical descendancy charts that does
recursion on the application level. For an extreme example, look at
http://solumslekt.org/slekta/etterkommere.php?person=383> which
lists a very prolific family in which I've done extensive research.

I just ran it, and it lists 1100 spouses and descendants four levels
deep in a little over 5 seconds. The query is somewhat optimised, as I
check for the sex of the parent:

if ($sex == 'M')
$query = "select per_no, mother, sex from slekta 
where father = $p_no order by p_birth_date1";
elseif ($sex == 'F')
$query = "select per_no, father, sex from slekta 
where mother = $p_no order by p_birth_date1";

The table has per_no as primary key, and is indexed on (father, mother).

By the way, I wonder if there are other genealogy hackers here who'd
like to collaborate on an open-source project. 

regards,
-- 
Leif Biberg Kristensen 
http://solumslekt.org/
mail to leif at solumslekt dot org

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Conception - Tree - Recursivity -Address book - Query speed

[Kevin Fries]

I'm not sure Celko described all the queries in those articles (the url
I sent plus the followups in April and May that year.  You'll have to
hunt down those follow-ups.
But, for a much easier reference, look at Joe Celko's  _SQL For
Smarties_, where in one of the later chapters, he covers the nested set
hierarchy more completely.  I actually used that chapter when I did my
first implementation of that concept.  For me, I needed a hierarchy that
would stand up in any reasonable database.  It worked out very well,
even though I had to adapt the model to work across multiple tables.
The book is money well spent.

The following Usenet article is where I first was convince that this
would work for me.
http://groups.google.com/groups?q=celko+CONNECT+BY+from+Oracle+in+SQL-Se
rver%3F&hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=%230%23O0OiFBHA.1932%40tkmsftng
p04&rnum=4
That's a horrible URL.  If it doesn't work right, go to your favorite
usenet archive and look for :
celko "CONNECT BY from Oracle in SQL-Server?"

He posted a very nice article in July 2001 that explains a lot of the
concept, including 
How to get a complete subtree stom one node.  Reading the results is
slightly tricker, since a columnar result set can't obviously look like
a tree.

As for having to update a large portion of the tree to add or subtract
one node, yes.  That's necessary.  But for the cases I've dealt with,
this is business structure data, and it changes very rarely by
comparison to daily transactional information.  The payoff is that every
query against the tree is faster than it would have been under the
CONNECT-BY architecture particular to Oracle.  Oh, and in my case, and
in what Celko describes, the update to move the LFT/RGT values to make
room for a new node can be done in one update statement, even in mysql.
So it's tricky to write, but very simple to operate.

Kevin

-Original Message-
From: Grégoire Dubois [mailto:[EMAIL PROTECTED] 
Sent: Thursday, April 03, 2003 6:28 AM
To: Kevin Fries
Cc: [EMAIL PROTECTED]
Subject: Re: Conception - Tree - Recursivity -Address book - Query speed


Thank you very much for your answer.

I read the article.
I've understood that this nested tree model (with the "worm", I liked 
the image), permits to retrive very easiely the path of a node, and some

other things.
But : I've understood that if we want to modify the tree, all left and 
right numbers of all the nodes of the tree have to be changed. Why 
not... But biggest problem, I don't see how it permits me to get the 
whole tree in a recursive maner. I haven't seen a request that would 
give me something like that :
(root(node1, node2(node3, node4)))
corresponding to :
  root
   ||
 node1  node2
   ||
node3node4   

Kevin Fries wrote:

>My advice is to consider an alternate storage approach. Instead of 
>storing parent id's, store the trees using the Nested Set model.
> http://www.dbmsmag.com/9603d06.html
>
>About halfway down the article he presents a model where you never 
>store the parent id, but you do store two columns (LEFT and RIGHT) 
>which represent the boundaries of the child records, and their 
>respective LEFT and RIGHT information.
>
>That sounds complicated, and it is. But it is an ANSI-compliant 
>solution, and it can be used to get terrific results.
>
>His article is followed up in the april and may issues, as well, also 
>online.
>
>In addition, you can follow up his article by looking in Usenet groups 
>for the term "Nested Set Hierarchy" or "Nested Set Model".
>
>
>Good luck with it.
>Kevin
>
>-Original Message-
>From: Grégoire Dubois [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, April 02, 2003 6:54 AM
>To: [EMAIL PROTECTED]
>Subject: Conception - Tree - Recursivity -Address book - Query speed
>
>
>Hello all,
>
>I am putting multiple "address book" (trees) into a MySQL database.
>These "address book" are made of "directories" and "persons".
>
>It gives something like that for the tables :
>   
>Directory
>--
>ID
>Name
>ID_father (the reference to the father directory)
>
>
>Person
>-
>ID
>Name
>ID_father (the reference to the father directory)
>
>
>Creating the tree doesn't give me problem. Where I ask me some
>questions, is the speed to get the whole tree from the database in a 
>recursive way.
>The way the tree is defined in the database, I will be obliged to make 
>for each node a SELECT to know all its children, then do the same for 
>the children, etc... Each SELECT will give me a ResultSet. And from
each
>
>ResultSet I will know if the node has got childrens, and if yes, I'll
>have to make new requests to the database (one for each child), etc...
>
>As I will have a lot of clients that will ask for those trees, I am
>wondering if this technique wo

Saving the command buffer

[Myhre, Julie]

Hello,

I've been searching the manual and the web for information on saving the
last command I just typed in at the mysql> prompt.  If I create a
complex command in SQLPLUS that I'd like to use in the future, I can
then type "save greatcommand.sql", and the last command executed is
saved to the current directory.  I can execute it
using   "@greatcommand". 

Is there a way to do this in MySQL?  I know I can run batches at the
shell prompt, using redirects, and I can use the "source" command at the
mysql> prompt for a batch I created in the shell.  But I want to create
it while in MySQL (where I can see my output and decide I like the
command)can I do this with something other than using "spool" or
cutting and pasting?

Thanks in advance,
Julie Myhre


This e-mail message is for the sole use of the intended recipient(s) and may contain 
confidential and privileged information.  Any unauthorized review, use, disclosure or 
distribution is prohibited.  If you are not the intended recipient, please contact the 
sender by reply e-mail and destroy all copies of the original message.

Re: Suggestions for choosing GUI Language that has a MySQL DB bac kend

[James]

I second that


> :-)  My offering would be to suggest developing in Delphi or Kylix,
> depending on the platform.



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Suggestions for choosing GUI Language that has a MySQL DB bac kend

[Christensen, Dave]

:-)  My offering would be to suggest developing in Delphi or Kylix,
depending on the platform.

David Christensen
Brokers International, Ltd.
1200 E Main St
Panora, IA  50216
(641) 755-2775
[EMAIL PROTECTED]



-Original Message-
From: Martin Gainty [mailto:[EMAIL PROTECTED] 
Sent: Thursday, April 03, 2003 10:55 AM
To: [EMAIL PROTECTED]
Cc: MySQL List
Subject: Re: Suggestions for choosing GUI Language that has a MySQL DB
backend


If speed isnt a issue I would say develop with one of the interpreted
languages (Perl/Python) My experience trying to get anything compiled under
linux or windows because of missing headers or libraries will cause you and
your project to experience insufferable delay. Regards, Martin
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 03, 2003 9:24 AM
Subject: Suggestions for choosing GUI Language that has a MySQL DB backend


>
>
> Hi MySQL Listers,
>
> I'm wondering if someone might provide some guidance about what
programming
> language might best accomplish the following.
>
> I have been asked to write an interactive GUI program that allows for 
> the display of results from related queries. For example, launching 
> the application wil generate the first query, which
will
> return a list of names of individuals.
> Selecting a name triggers another query that returns demographic
information
> about that person and a list of their interests.
> Selecting an interest from the list triggers another query that 
> returns a
list
> of venues such as museums or restaurants where the person can explore 
> that interest. And selecting the venue triggers a query that returns 
> information such as driving directions or food menu.
>
> I have the MySQL database designed and tested, and the queries work as
intended.
> Also, the load on mysqld will be limited, so performance is not a 
> major
issue.
> Unfortunately, my employer does not want a web-based solution, so PHP 
> is
out.
> And all the activity has to occur in various sections of a single 
> screen.
>
> My apologies if I'm posting to the wrong list. But if someone has
accomplished
> something similar to the above using a MySQL backend, I would 
> appreciate
any
> advice or direction that might be provided.
>
> Thank you for reading this post.
>
> David
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Mysql and POP3? Need help

[Lessard, Arthur]

Hi...

Thanks to the great help on this list (including Juan), I was able to get postfix 
working with mysql.  Now, of course, I need to be able to read the mail being 
forwarded. :)  Due to restrictions beyond my control, it needs to be a pop3 server - I 
would prefer IMAP, but pop3 it is.  And the mail needs to be in mbox format, not 
Maildir, so that leaves out Courier-IMAP (which is a heavy package anyway when all I 
need is pop3).  Vpopmail shows some promise, but it seems very rigid in how it needs 
the mysql database defined, and the database is already built - is it possible to set 
up vpopmail to use a generic database and fields?  Or is there another pop3 package 
for Redhat that would be better suited?  All I need is a pop3 server, not a full suite 
of protocols.

Thanks again for all the help...:)
   
 Aj

RE: Suggestions for choosing GUI Language that has a MySQL DB backend

[John Griffin]

Hi David,

check out http://gtk.php.net/ It is a GUI toolkit with a PHP interface to allow you to 
build client applications. 

John Griffin

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 03, 2003 11:25 AM
To: [EMAIL PROTECTED]
Subject: Suggestions for choosing GUI Language that has a MySQL DB
backend




Hi MySQL Listers,

I'm wondering if someone might provide some guidance about what programming
language might best accomplish the following.

I have been asked to write an interactive GUI program that allows for the
display of results from related queries.
For example, launching the application wil generate the first query, which will
return a list of names of individuals.
Selecting a name triggers another query that returns demographic information
about that person and a list of their interests.
Selecting an interest from the list triggers another query that returns a list
of venues such as museums or restaurants where the person can explore that
interest.
And selecting the venue triggers a query that returns information such as
driving directions or food menu.

I have the MySQL database designed and tested, and the queries work as intended.
Also, the load on mysqld will be limited, so performance is not a major issue.
Unfortunately, my employer does not want a web-based solution, so PHP is out.
And all the activity has to occur in various sections of a single screen.

My apologies if I'm posting to the wrong list. But if someone has accomplished
something similar to the above using a MySQL backend, I would appreciate any
advice or direction that might be provided.

Thank you for reading this post.

David



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Suggestions for choosing GUI Language that has a MySQL DB backend

[Michael T. Babcock]

I have been asked to write an interactive GUI program that allows for
the display of results from related queries.
For example, launching the application wil generate the first query,
which will return a list of names of individuals.
 

May I suggest Python with PyGtk+ and using Glade to build the interface.

This code can be made quite small and efficient with Python in my 
experience.  If you have no Python experience; feel free to follow other 
suggestions, but consider trying it.

--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Help with 4.0.12 on WinXP

[Mark Matthews]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dan Cumpian wrote:
| Hello,
|
|
|
| I am having the following problem that I've been able to consistently
| replicate:
|
|
|
| I am using code written in Delphi with Zeos Database components and am
| having a problem with a query returning "server connection error". I am
| inserting a row into a table and then immediately selecting a row from a
| table . This error occurs whether I select out of the table I inserted
| the new row into or from any other table. After inserting 3700-3900
| rows, the select will be unable to connect. For at least 10-30 seconds,
| I cannot connect to MySQL, even with MySQL-Front (I get a "Can't connect
| to server" error).  There are no errors being logged. After the 10-30
| seconds passes, I can resume the program and it happens again after
| 3700-3900 rows.
|
|
|
| This does not happen on Windows 2000, only Windows XP (both Home and
| Pro). All connection are through Localhost.
|
|
|
| My configuration file is:
|
|
|
| [mysqld]
|
| set-variable=key_buffer_size=18M
|
| set-variable=myisam_sort_buffer_size=8M
|
| set-variable= max_allowed_packet=16M
|
|
|
| Table type is MyISAM.
|
|
|
| Machine is a P4-2.2Ghz with SCSI hard disks.
|
|
|
| Can anyone please suggest what I might be able to do to resolve this
| issue?
My guess is that you are making a new connection every time you do an
operation. Windows XP has a paltry amount of TCP/IP ports that can be
used for outbound connections (around 4000, which should sound
'coincidental' to you, given that your failures happen between 3700 and
3900)...These ports are shared for _all_ outbound TCP/IP from your box,
and can take up to 4 minutes to 'clear' so they can be re-used.
You should consider only opening the MySQL connection _once_ in your
program...Otherwise you need to use a registry hack to change the number
of 'ephemeral' ports that Windows XP will use (search the mailing list,
or the myodbc mailing list for a pointer to that article).
	-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.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQE+jGkHtvXNTca6JD8RAu3kAJ41j4ulfljw8150u66inBwKHFTvtwCfYc4G
7ROQnT1NjSPAHMeJgQ1ptpE=
=v7fv
-END PGP SIGNATURE-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

retry: Searching for values such as "10.2.4" via fulltext (more info)

[Adam Randall]

Since no one responded to this message at all, I'm sending it again.

I have a support system set up where people can search for various 
things using a fulltext index. The problem that I am having, though, 
is that I cannot seem to figure out how to get search results for 
values like "10.2.4" or "6.0.4". This is with MySQL 4.0.12, with the 
minimum word length of 3 (so we can search for PHP, IIS, etc).

Here are some examples of how the search is being performed:

select id,topic from articles where match(topic,summary,description) 
against ('10.2.4');
(no results)

select id,topic from articles where match(topic,summary,description) 
against ('"10.2.4"' in boolean mode);
(no results)

select id,topic from articles where topic like '%10.2.4%' or summary 
like '%10.2.4%' or description like '%10.2.4%';
(3 rows found)

I don't really want to do the last search because it's the slowest, 
and searching the most data un-indexed.

Anyway, if anyone has any advice, I would appreciate it.

Adam.

---
Adam Randall  http://www.xaren.net/
[EMAIL PROTECTED]   http://nt.xaren.net/
[EMAIL PROTECTED]AIM/iChat:  blitz574
"Macintosh users are a special case. They care passionately about the
Mac OS and would rewire their own bodies to run on Mac OS X if such a
thing were possible." -- Peter H. Lewis
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Storing queries

[H. Scott Brown]

Hi, List,

Just wondering...

Anybody have a good method to store queries?

I know MySQL doesn't support stored procedures at this time (will in 5.x, I 
guess).

Obviously, I can just stash it in a varchar field in a table somewhere, 
then select it and execute it in a separate query, but is there a better, 
more efficient way?

Any help greatly appreciated!

TIA,
--Scott Brown 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Suggestions for choosing GUI Language that has a MySQL DB backend

[Martin Gainty]

If speed isnt a issue I would say develop with one of the interpreted
languages (Perl/Python)
My experience trying to get anything compiled under linux or windows because
of missing
headers or libraries will cause you and your project to experience
insufferable delay.
Regards,
Martin
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 03, 2003 9:24 AM
Subject: Suggestions for choosing GUI Language that has a MySQL DB backend


>
>
> Hi MySQL Listers,
>
> I'm wondering if someone might provide some guidance about what
programming
> language might best accomplish the following.
>
> I have been asked to write an interactive GUI program that allows for the
> display of results from related queries.
> For example, launching the application wil generate the first query, which
will
> return a list of names of individuals.
> Selecting a name triggers another query that returns demographic
information
> about that person and a list of their interests.
> Selecting an interest from the list triggers another query that returns a
list
> of venues such as museums or restaurants where the person can explore that
> interest.
> And selecting the venue triggers a query that returns information such as
> driving directions or food menu.
>
> I have the MySQL database designed and tested, and the queries work as
intended.
> Also, the load on mysqld will be limited, so performance is not a major
issue.
> Unfortunately, my employer does not want a web-based solution, so PHP is
out.
> And all the activity has to occur in various sections of a single screen.
>
> My apologies if I'm posting to the wrong list. But if someone has
accomplished
> something similar to the above using a MySQL backend, I would appreciate
any
> advice or direction that might be provided.
>
> Thank you for reading this post.
>
> David
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL 4.0.12 / UPDATE using 2 tables / ERROR 1114: The table is full

[Gerrit Hannaert]

I've seen this on the mailing lists just a day ago ('*have a problem'*), 
and wow! I have a similar problem.
None of the suggestions in the online documentation helped. I tried both 
MyISAM and InnoDB table formats. This obviously only works on MySQL 
>=4.0 (I'm running the 4.0.12 RPM on Linux).

UPDATE a, b
SET a.date_out='2003-04-03 15:48:06',
a.is_dirty_date_out='Y'
WHERE a.file_id=b.file_id
AND date_out='2099-12-31'
AND file_mdate >= '2002-04-03 15:48:06'
AND a.storage_id='6';
ERROR 1114: The table 'a' is full

- a currently contains 1,419,724 rows
- b currently contains 825,770 rows
- the disk is in no way full, and both tables apart take up at most a 
few 100 MB. The machine has 1GB of RAM.

- the SHOW TABLE STATUS FROM db LIKE 'a' output:
| Name | Type   | Row_format | Rows| Avg_row_length
| Data_length | Max_data_length | Index_length | Data_free | Auto_increment
| Create_time | Update_time | Check_time | Create_options | 
Comment|

| a | InnoDB | Fixed  | 1411497 | 97
|   137003008 |NULL |153534464 | 0 |1419728
| NULL| NULL| NULL   | max_rows=1 | InnoDB 
free: 294912 kB |

(as a solution I'm going to denormalize a bit so I don't have to update 
using two tables, but this looks like a bug or a hole in the 
documentation/known issues)

If anyone has any pointers I'd be happy to hear them, please CC: me 
since I'm not on the mailing list (yet). The similarities between this 
TABLE STATUS and the previous poster are large, but there are probably 
important differences - namely table type, max_rows, Auto_increment, 
Row_format are all quite different.

Cheers,

--
=={Gerrit Hannaert}==
  IT Department, CropDesign N.V.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Suggestions for choosing GUI Language that has a MySQL DB backend

[Mitko Haralanov]

I would use C + GTK+ (if the os is linux). MySQL has a very nice C API
(which is well-documented, I think) and GTK+ is the most common and
preferred GUI development kit for Linux. If the platform is Windows, the
GUI will be something else but I would still use C for the MySQL stuff.

HTH,
-- Mitko

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Thursday, April 03, 2003 8:25 AM
To: [EMAIL PROTECTED]
Subject: Suggestions for choosing GUI Language that has a MySQL DB
backend



Hi MySQL Listers,

I'm wondering if someone might provide some guidance about what
programming
language might best accomplish the following.

I have been asked to write an interactive GUI program that allows for
the
display of results from related queries.
For example, launching the application wil generate the first query,
which will
return a list of names of individuals.
Selecting a name triggers another query that returns demographic
information
about that person and a list of their interests.
Selecting an interest from the list triggers another query that returns
a list
of venues such as museums or restaurants where the person can explore
that
interest.
And selecting the venue triggers a query that returns information such
as
driving directions or food menu.

I have the MySQL database designed and tested, and the queries work as
intended.
Also, the load on mysqld will be limited, so performance is not a major
issue.
Unfortunately, my employer does not want a web-based solution, so PHP is
out.
And all the activity has to occur in various sections of a single
screen.

My apologies if I'm posting to the wrong list. But if someone has
accomplished
something similar to the above using a MySQL backend, I would appreciate
any
advice or direction that might be provided.

Thank you for reading this post.

David



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 4.0.12 libmysqlclient.a

[Martin Gainty]

Allen-
nm shows that the library libmysqlient.a contains the required my_close
mysql_real_connect functions in Text section of libmysqlclient.a and yet I
cannot resolve to it..*hmm*
I have decided to attempt to compile libmysqlclient.c but am finding missing
the header ctype-simple.h
Cheers,
Martin
PostScript
So when will your company be publishing a book on the Rock n Roll bands from
Birmingham?
- Original Message -
From: "Allen Grace" <[EMAIL PROTECTED]>
To: "Martin Gainty" <[EMAIL PROTECTED]>; "MySQL List"
<[EMAIL PROTECTED]>
Sent: Thursday, April 03, 2003 9:29 AM
Subject: Re: 4.0.12 libmysqlclient.a


> On Thursday 03 April 2003 15:37, Martin Gainty wrote:
>
> > The unfortunate consequence of those who think RTFM will actually help
>
> Hmph.
>
> > The test_libmysqld example is embedded in the online manual located at:
> > \MySQL\mysql-standard-4.0.12-pc-linux-i686\manual.html
>
> A path to a file that's not on your machine :) would be
> http://www.mysql.com/doc/en/libmysqld_example.html
>
> This doesn't contain any calls to _mysql_close or _mysql_server_init...
> what's happened to your copy of the file?
>
> I've never played with cygwin, but I see it appears in the pathnames in
your
> output. Does it have the 'nm' utility? This tells you in readable form
what
> symbols are defined in any given library - which makes it useful for
> answering the kind of question you're asking.
>
> dbconnect() is defined in test_libmysqld.c also, so you shouldn't have any
> problems resolving it.
>
> rgds
>
> allen
> --
> *
>
> Allen Grace ([EMAIL PROTECTED])
> Analyst Programmer
> Peters Bookselling Services
> 120 Bromsgrove Street, Birmingham, B5 6RJ
>
> *
>
> This email and any files transmitted with it are
> confidential and intended solely for the use of the
> individual or entity to whom they are addressed.
>
> If you are not the intended above named addressee it
> may be unlawful for you to read, copy, distribute or
> otherwise use the information in this internet email.
>
> Any views or personal opinions expressed within this
> email may not be those of Peters Bookselling Services.
>
> *
>

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Thoughts on MySQL training?

[Rachel Rodriguez]

Many thanks to all for responding to my query
regarding MySQL training.  Your honest opinions were
greatly appreciated!

BTW, the general consensus was that it was quality
training and worth the price.

Thank you, Rachel

__
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
http://tax.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Suggestions for choosing GUI Language that has a MySQL DB backend

[dpgirago]

Hi MySQL Listers,

I'm wondering if someone might provide some guidance about what programming
language might best accomplish the following.

I have been asked to write an interactive GUI program that allows for the
display of results from related queries.
For example, launching the application wil generate the first query, which will
return a list of names of individuals.
Selecting a name triggers another query that returns demographic information
about that person and a list of their interests.
Selecting an interest from the list triggers another query that returns a list
of venues such as museums or restaurants where the person can explore that
interest.
And selecting the venue triggers a query that returns information such as
driving directions or food menu.

I have the MySQL database designed and tested, and the queries work as intended.
Also, the load on mysqld will be limited, so performance is not a major issue.
Unfortunately, my employer does not want a web-based solution, so PHP is out.
And all the activity has to occur in various sections of a single screen.

My apologies if I'm posting to the wrong list. But if someone has accomplished
something similar to the above using a MySQL backend, I would appreciate any
advice or direction that might be provided.

Thank you for reading this post.

David



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 4.0.12 libmysqlclient.a

[Allen Grace]

On Thursday 03 April 2003 15:37, Martin Gainty wrote:

> The unfortunate consequence of those who think RTFM will actually help

Hmph.

> The test_libmysqld example is embedded in the online manual located at:
> \MySQL\mysql-standard-4.0.12-pc-linux-i686\manual.html

A path to a file that's not on your machine :) would be 
http://www.mysql.com/doc/en/libmysqld_example.html

This doesn't contain any calls to _mysql_close or _mysql_server_init... 
what's happened to your copy of the file?

I've never played with cygwin, but I see it appears in the pathnames in your 
output. Does it have the 'nm' utility? This tells you in readable form what 
symbols are defined in any given library - which makes it useful for 
answering the kind of question you're asking. 

dbconnect() is defined in test_libmysqld.c also, so you shouldn't have any 
problems resolving it.

rgds

allen
-- 
*

Allen Grace ([EMAIL PROTECTED])
Analyst Programmer
Peters Bookselling Services
120 Bromsgrove Street, Birmingham, B5 6RJ

*

This email and any files transmitted with it are
confidential and intended solely for the use of the
individual or entity to whom they are addressed.

If you are not the intended above named addressee it
may be unlawful for you to read, copy, distribute or
otherwise use the information in this internet email.

Any views or personal opinions expressed within this
email may not be those of Peters Bookselling Services.

*

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How do I tell which mysql process has a lock?

[JRice]

Greetings.

How do I tell which mysql process has a lock on what tables?

I'm using mysql 3.23.54-Max with MyISAM tables on Linux 2.4.9-34 (RedHat
7.2).  We've got about 20 users and a myriad of automated scripts (Perl
DBI, Java JDBC) connecting to the database on a regular basis.

Thanks.



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

re: How can i change charset in mysql ?

[Egor Egorov]

On Wednesday 02 April 2003 20:30, Pratchaya Chatuphian wrote:
> I use MDK 9.0 and installed MySQL 4.0.12 Max ... sir
> How can i change  charset  sir ?
> i want to use tis-620 .. sir
> Any one can help me sir ... ?
>
> Just mean  change the my.conf ?   ( my-small.conf , my-medium.conf ,  )

You you should rename one of this file to my.cnf and put it to the /etc dir.
Add into [mysqld] section (not [client] section! )
default-character-set=tis620

[skip]

> that can not found tis620.conf ?
> How do i do next step sir
> ?

Because it's a multi-byte character set. It's implemented in the 
ctype-tis620.c file (you can see it in the /strings dir of source 
distribution)




-- 
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




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

re: loading data from a back up file

[Victoria Reznichenko]

On Thursday 03 April 2003 09:28, Justin French wrote:

> I have a 2.7meg dump of SQL created by phpMyAdmin [1], however when I try
> to import this data back into mysql through phpMyAdmin, it times out
> (understandably), so I guess I need to do this from the command line, but
> have no idea how to go about this AT ALL... can anyone point me in the
> right direction?

Something like:

mysql -uuser_name -puser_password database_name < script.sql


-- 
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





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

re: Schema definition fails when converted to InnoDB

[Victoria Reznichenko]

On Thursday 03 April 2003 12:40, Ian Hartas wrote:

> >Description:
>
> I have a database schema .sql file which is accepted when run with
> MyISAM tables. If I change the tables to be type = InnoDB, then it fails
> with the error message:
>
> mysql -u ts -p hbs  ERROR 1005 at line 54: Can't create table './hbs/#sql-34ef_f.frm' (errno:
> 150)

Your foreign key definition is not correctly formed:
http://www.mysql.com/doc/en/SEC463.html

> >How-To-Repeat:
>
> Save this text as schema_mysql.sql and run it as noted in the
> description line. database called 'hbs', user called 'ts'



-- 
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





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

re: re: How come I can't use an "AS" field in other operations?

[Egor Egorov]

On Wednesday 02 April 2003 22:36, Daevid Vincent wrote:

> so then the next obvious question to ask is... is this just not
> implemented yet, or is it not even on the radar as a 'feature'?

It'a behaviour. You can refer in the HAVING, ORDER BY and GROUP BY, but you 
can't in the select list and WHERE part.

> Out of curiosity, do other SQL implementations (RDBMS) allow this
> syntax?

Seems in Access it's allowed, but I'm not sure.

> On Wed, 2003-04-02 at 08:06, Egor Egorov wrote:
> > On Wednesday 02 April 2003 04:04, Daevid Vincent wrote:
> > > Is this a bug or just not implemented in 3.23.56-Max?
> > >
> > > mysql> SELECT alarm_notes, DATE_FORMAT(alarm_date,'%m/%d/%y %h:%i %p')
> > > AS alarm_date_format, IFNULL(CONCAT(contact_fname, ' ', alarm_date),
> > > alarm_date_format) AS contact_name, contact_email, contact_phone FROM
> > > alarm_table LEFT JOIN contact_table ON alarm_contact_table_id =
> > > contact_id WHERE alarm_rep_table_id = '1' ORDER BY alarm_date;
> > > ERROR 1054: Unknown column 'alarm_date_format' in 'field list'
> >
> > [skip]
> >
> > It's not a bug. You can't reference column aliases in the select list.




-- 
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




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

re: Can I enlarge user table's User field ?

[Egor Egorov]

On Thursday 03 April 2003 09:57, Heo Jungsu wrote:

> mysql> show columns from user like 'User' ;
> +---++--+-+-+---+
>
> | Field | Type   | Null | Key | Default | Extra |
>
> +---++--+-+-+---+
>
> | User  | varchar(16) binary |  | PRI | |   |
>
> +---++--+-+-+---+
> 1 row in set (0.00 sec)
>
> Can User field be VARCHAR(50) ?

Nope. You shouldn't do it.



-- 
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




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

re: RE: password not working from command line

[Egor Egorov]

On Wednesday 02 April 2003 17:19, Eldon Ziegler wrote:
> The contents of the user file are attached. The user name is testit and
> there is no password. This is server version 3.23.52, the version that came
> with the Red Hat 8 distribution.
>
> I entered mysql -utestit then USE mysql; and got
> ERROR 1044: Access denied for user: '@local host' to database 'mysql'
> Why no user name before the @?

Because you connect to the MySQL server as anonymous user. From the manual:

Note: if you allow anonymous users to connect to the MySQL server, you should 
also grant privileges to all local users as [EMAIL PROTECTED] because otherwise 
the anonymous user entry for the local host in the mysql.user table will be 
used when the user tries to log into the MySQL server from the local machine!

> Additionally, I tried to access mysql remotely with an app known to work on
> other installations of mysql and got, on the Linux machine running mysqld,
> /usr/bin/safe_mysql: line 273: 840 Segmentation fault
> ... output omitted
>
> Number of processes running now: 1
> mysqld process hanging, pid 843 - killed
> 030402 09:02:24  mysqld restarted
>
> Is this distribution any good?

Try to add

set-variable = thread_stack=256K

to the [mysqld] section of my.cnf.



-- 
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




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: date ranges

[Matt Gostick]

> >>I have a date range (start date and end date) supplied by the user 
> >>and I also have information in a table that has start dates and 
> >>end dates. I want to select everything in the table whose date range 
> >>overlaps in any way with the date range given by the user. 

> >Well...  if you were given a start date of 2003-01-01 and end date of
> >2003-01-31...
> >
> >select *
> >  from table_name
> > where start_date between "2003-01-01" and "2003-01-31"
> >or end_date   between "2003-01-01" and "2003-01-31"

> Example: start_date = "2002-01-01" and end_date = 2003-02-01".
> 
> Instead, if the four dates are s1, e1, s2, and e2 (s=start, e=end), we want:
> s1 <= e2 /* first range can't start after second range ends */
> AND
> s2 <= e1 /* second range can't start after first range ends */

Okay, so s1,e1 are supplied by the user and s2,e2 are in your tables
right?  Maybe it's just too early in the morning for me... but I don't
understand the problem anymore.

s1 <= e2 ... yeah that's what my original query does.
e1 >= s2 ... what?  yeah... it's an end date.. it's gonna be great than
a start date by nature.

Are you trying to say that you don't want overlap anymore?  You want the
s2,e2 to be contained by s1,e1?  I doubt that's what you want b/c you
wouldn't have written the list...  it's just a small and trivial
alteration to my original query...

select *
  from table_name
 where (start_date between "2003-01-01" and "2003-01-31"
or end_date between "2003-01-01" and "2003-01-31")
   and start_date > "2003-01-01"
   and end_date < "2003-01-31"

Sorry, I guess you're gonna have to be more specific.  I could probably
sit here for 30 minutes reading your email over and over to
understand... but I would rather you be more clear on what you want. 
But then again, I need another cup of coffee in me yet...

Matt.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: table structure design

[Nicholas Spagnoletti]

Hi

About Entity Relationship Diagrams: I use Graphviz to generate ERD's on
the fly, from the database. Graphviz is very cool:
http://www.research.att.com/sw/tools/graphviz/

Graphviz draws graphs from files written in its language (called 'dot')
Your PHP script (or language of choice) needs to get the tables and
fields from MySQL, take your naming conventions etc. into account, and
output a dot file that will look like something like this in its
simplest form:


digraph schema { 
user [shape=record, label="ID|name|surname"];
user -> user_group;
user_group [shape=record; label="ID|groupname"];
}


Pipe that to dotty (part of the graphviz suite) and it will display a 
graph with one block called user (and its fields) and one block called
user_group (and its fields) and a line joining them. 
So all you need to do is write your own script to output all your tables
and their relationships and dotty will draw it nicely for you.


On Thu, 2003-04-03 at 16:12, Cal Evans wrote:
> Lots of them. None cheap.  What ever you do, steer clear of the one at
> www.thekompany.com. It's a piece of crap.  I bought a version and then
> foolishly bought an upgrade thinking it would be better.  it's not and the
> primary programmer for the project is very arrogant on the mailing list
> setup for support.
> 
> ERWin is a great tool but it does not support MySQL directly. (You could use
> ODBC to reverse engineer a database though) The same with ERStudio from
> Embarcadero (sp?)  Great tool, expensive though.
> 
> =C=
> 
> - Original Message -
> From: "Daniel Rossi" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, April 03, 2003 12:37 AM
> Subject: table structure design
> 
> 
> is there any table structure design program in a graphical layout for
> windows available ? i have tables and fields on paper but would like a way
> to be able to lay them out on a screen and show which table joins to what
> and what keys it uses let me know thanks
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> 
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Schema definition fails when converted to InnoDB

[gerald_clark]

You can't add constraints referencing indices that don't exist.
Create your  indecies first.
Ian Hartas wrote:

Description:
   

   I have a database schema .sql file which is accepted when run with MyISAM
tables. If I change the tables to be type = InnoDB, then it fails with the error
message:
mysql -u ts -p hbs 
 

How-To-Repeat:
   

   Save this text as schema_mysql.sql and run it as noted in the description line.
   database called 'hbs', user called 'ts'
/*
** MySQL schema for the Holiay Booking System within FJS.
**
** by Ian Hartas, Kid01.
**
*/
drop table if exists ts_proj_team;
drop table if exists ts_resource_mgrs;
drop table if exists ts_entry;
drop table if exists ts_user_details;
drop table if exists ts_project_code_details;
drop table if exists ts_project_details;
drop table if exists ts_team;
drop table if exists ts_programme;
drop table if exists ts_location_entry;
drop table if exists ts_default_location;
create table ts_team
(
TEAM_IDinteger(8) not null primary key
,TEAM_NAME varchar(30) not null
,team_admin_email varchar(100)
) type = InnoDB;
create table ts_programme
(
PROGRAMME_ID   integer(8) not null primary key
,PROGRAMME_NAMEvarchar(30) not null
) type = InnoDB;
create table ts_user_details
(
USER_IDvarchar(8) not null primary key
,TEAM_ID   integer(8)
,STANDARD_HOURSfloat(30,2)
,USER_NAME varchar(40) not null
,PASSWORD  varchar(20) not null
,DEFAULT_LOCATION_ID   integer(8)
,ACTIVECHAR(1) -- check(ACTIVE in ('Y','N'))
,DESCRIPTION   varchar(255)
,EMAIL_ADDRESS varchar(100)
,HOURLY_RATE   decimal(9,2)
,ACCESS_LEVEL  integer(8) default 0
,charge_rate   varchar(20)
,start_datedatetime
,holiday_entitlement   decimal(9,2)
,holiday_taken decimal(9,2)
,holiday_carry_overdecimal(9,2)
,holiday_bought_sold   decimal(9,2)
,holiday_hours varchar(200)
) type = InnoDB;
alter table ts_user_details add constraint u_t foreign key (team_id)
   references ts_team(team_id);
create table ts_project_details
(
PROJECT_ID integer(8) not null primary key
,PROJECT_NAME  varchar(60) not null
,DESCRIPTION   varchar(255)
,ACTIVECHAR(1) -- check(ACTIVE in ('Y','N'))
) type = InnoDB;
create table ts_project_code_details
(
PROJECT_CODE_IDinteger(8) not null primary key
,PROJECT_IDinteger(8) not null
,PROJECT_CODE  varchar(10) not null
,PROJECT_CODE_NAME varchar(60) not null
,DESCRIPTION   varchar(255)
,UTIL_IND  CHAR(1)
,ACTIVECHAR(1) -- check(ACTIVE in ('Y','N'))
) type = InnoDB;
alter table ts_project_code_details add constraint pc_t foreign key (project_id)
   references ts_project_details(project_id);
create table ts_proj_team
(
 TEAM_ID   integer(8) not null
 ,PROJECT_ID   integer(8) not null
) type = InnoDB;
alter table ts_proj_team add constraint pt_p foreign key (project_id)
   references ts_project_details(project_id);
alter table ts_proj_team add constraint pt_t foreign key (team_id)
   references ts_team(team_id);
create table ts_resource_mgrs
(
 TEAM_ID   integer(8) not null
 ,USER_ID  varchar(8) not null
) type = InnoDB;
alter table ts_resource_mgrs add constraint rm_p foreign key(team_id)
   references ts_team(team_id);
alter table ts_resource_mgrs add constraint rm_u foreign key(user_id)
   references ts_user_details(user_id);
create table ts_entry
(
ID integer(38) not null primary key
,USER_ID   varchar(8) not null
,PROJECT_IDinteger(8)
,PROJECT_CODE_ID   integer(8)
,TEAM_ID   integer(8)
,HOURS FLOAT(30,2)
,EDATE datetime
,CDATE datetime
,MDATE datetime
,LOCKEDCHAR(1) -- check(LOCKED in ('Y','N','D'))
,UPDATE_HOURS  FLOAT(30,2)
,UPDATE_PROJECT_ID integer(8)
,UPDATE_PROJECT_CODE_ID integer(8)
,DESCRIPTION   varchar(255)
,nbhours   decimal(9,2)
,update_nbhoursdecimal(9,2)
) type = InnoDB;
alter table ts_entry add constraint e_p foreign key (project_id)
   references ts_project_details(project_id);
alter table ts_entry add constraint ec_p foreign key (project_code_id)
   references ts_project_code_details(project_code_id);
alter table ts_entry add constraint e_u foreign key (user_id)
   references ts_user_details(user_id);
/*
** Staff movement tracking
*/
create table ts_location_entry
(
   USER

Re: 4.0.12 libmysqlclient.a

[Martin Gainty]

Allen-
The unfortunate consequence of those who think RTFM will actually help
The test_libmysqld example is embedded in the online manual located at:
\MySQL\mysql-standard-4.0.12-pc-linux-i686\manual.html
Cheers,
Martin

PostScript:
I am still looking for library that will resolve
MySQL *one = db_connect("test");
(and will resolve all MySQL API methods)

- Original Message -
From: "Allen Grace" <[EMAIL PROTECTED]>
To: "Martin Gainty" <[EMAIL PROTECTED]>; "MySQL List"
<[EMAIL PROTECTED]>
Sent: Thursday, April 03, 2003 1:40 AM
Subject: Re: 4.0.12 libmysqlclient.a


> On Wednesday 02 April 2003 19:32, Martin Gainty wrote:
>
> > Attempting to run the makefile for test_libmysqld.c
>
> Where does this file test_libmysqld.c come from? I'm working with the
4.0.12
> distribution, there's nothing called that in the package I have.
>
> ...
>
> > /cygdrive/g/mysql/test_libmysqld/test_libmysqld.c:41: undefined
reference
> > to `_m
> > ysql_server_init'
> >
/cygdrive/g/DOCUME~1/mysql/LOCALS~1/Temp/ccocg8oR.o(.text+0xcf):/cygdrive/g
> >/ mysq
> > l/test_libmysqld/test_libmysqld.c:49: undefined reference to
`_mysql_close'
> >
> > why am I getting unresolved references when I link to 4.0.12
> > libmysqlclient.a???
>
> There's no symbol with those names in libmysqlclient.a as far as I can
tell:
>
> # cd /opt/mysql-4.0.12/lib/mysql
> # nm libmysqlclient.a | grep _mysql_close
> #
>
> No rows returned, so that's why the linker can't find it. (Same result for
> _mysql_server_init.)
>
> I did a find and grep across the whole source tree and find no references
to
> these functions, so I don't think they exist and whoever wrote
> test_libmysqld.c forgot to write them. Or they live in a library that's
local
> to your site.
>
> HTH
>
> allen
>
> --
> *
>
> Allen Grace ([EMAIL PROTECTED])
> Analyst Programmer
> Peters Bookselling Services
> 120 Bromsgrove Street, Birmingham, B5 6RJ
>
> *
>
> This email and any files transmitted with it are
> confidential and intended solely for the use of the
> individual or entity to whom they are addressed.
>
> If you are not the intended above named addressee it
> may be unlawful for you to read, copy, distribute or
> otherwise use the information in this internet email.
>
> Any views or personal opinions expressed within this
> email may not be those of Peters Bookselling Services.
>
> *
>

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Conception - Tree - Recursivity -Address book - Query speed

[Grégoire Dubois]

Thank you very much for your answer.

I read the article.
I've understood that this nested tree model (with the "worm", I liked 
the image), permits to retrive very easiely the path of a node, and some 
other things.
But : I've understood that if we want to modify the tree, all left and 
right numbers of all the nodes of the tree have to be changed. Why 
not... But biggest problem, I don't see how it permits me to get the 
whole tree in a recursive maner. I haven't seen a request that would 
give me something like that :
   (root(node1, node2(node3, node4)))
corresponding to :
 root
  ||
node1  node2
  ||
   node3node4   

Kevin Fries wrote:

My advice is to consider an alternate storage approach.
Instead of storing parent id's, store the trees using the Nested Set
model.
http://www.dbmsmag.com/9603d06.html
About halfway down the article he presents a model where you never store
the parent id, but you do store two columns (LEFT and RIGHT) which
represent the boundaries of the child records, and their respective LEFT
and RIGHT information.
That sounds complicated, and it is. But it is an ANSI-compliant
solution, and it can be used to get terrific results.
His article is followed up in the april and may issues, as well, also
online.
In addition, you can follow up his article by looking in Usenet groups
for the term "Nested Set Hierarchy" or "Nested Set Model".
Good luck with it.
Kevin
-Original Message-
From: Grégoire Dubois [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, April 02, 2003 6:54 AM
To: [EMAIL PROTECTED]
Subject: Conception - Tree - Recursivity -Address book - Query speed

Hello all,

I am putting multiple "address book" (trees) into a MySQL database. 
These "address book" are made of "directories" and "persons".

It gives something like that for the tables :
  
   Directory
   --
   ID
   Name
   ID_father (the reference to the father directory)

   Person
   -
   ID
   Name
   ID_father (the reference to the father directory)
Creating the tree doesn't give me problem. Where I ask me some 
questions, is the speed to get the whole tree from the database in a 
recursive way.
The way the tree is defined in the database, I will be obliged to make 
for each node a SELECT to know all its children, then do the same for 
the children, etc... Each SELECT will give me a ResultSet. And from each

ResultSet I will know if the node has got childrens, and if yes, I'll 
have to make new requests to the database (one for each child), etc...

As I will have a lot of clients that will ask for those trees, I am 
wondering if this technique won't take too much ressources and be too
slow.

I know that Oracle uses CONNECT BY PRIOR for this type of problem. But, 
as this functionnality isn't available yet in MySQL, I'm asking you for 
the best solution you would think of.

Thank you very much for your help.

PS : Any website talking about database conception would be very 
helpfull to me if you know some.



 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Please HELP!!! Re: Database Core Dumps

[TRANTER,STEWART (HP-Germany,ex1)]

Hi Mark and Steffan,

We solved this problem today and it was as Mark details below.  We have
installed the latest version available, and it now works fine  :-)  Phew!

Thanks very much to everyone for their help,

Best regards,

Stewart

-Original Message-
From: Mark Matthews [mailto:[EMAIL PROTECTED] 
Sent: 03 April 2003 15:00
To: TRANTER,STEWART (HP-Germany,ex1)
Cc: '[EMAIL PROTECTED]'
Subject: Re: Please HELP!!! Re: Database Core Dumps


-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

TRANTER,STEWART (HP-Germany,ex1) wrote:
| Hello Everyone,
|
| Yesterday I posted the message listed below.  I have some more
information.
| We have found the command that "pushes our database over the edge"!
It is:
|
| SHOW VARIABLES;
|
| All other db commands work (such as SHOW VARIABLES "%a";) except for:
|
| SHOW VARIABLES "%"
|
| Does anyone have any idea why this could be happening?  In addition we 
| are connecting to the database from a JSP Script using the driver:
|
| org.gjt.mm.mysql.Driver
|
| The JSP page doesn't actually explicitly call the SHOW VARIABLES; 
| command, but I guess (?) that this is called explicitly in the driver 
| connection somehow...  We confirmed that it was the SHOW VARIABLES; 
| command by
checking
| the log file (with --log and --log-update options).  We then tried 
| this at the MySQL command line and it caused the db to restart.
|
| Could this mean that one of the variables displayed by the SHOW 
| VARIABLES; command is causing some form of problem?
|
| Once again, many thanks in advance for taking the time to read this 
| mail, and I hope someone can help!
|
| The very best of regards,
|
| Stewart
|
..._/..
| Stewart Tranter[EMAIL PROTECTED] _/   
| Hewlett-Packard GmbH   Tel: (+49) 7031 14-1554   _/_/_/_/
| _/_/_/_/
| Software Engineering Services  Fax: (+49) 7031 14-4961  _/_/  _/_/
| Schickard Str.25   Mob: (+49) 1784 701 079 _/_/  _/_/
| 71034 Böblingen _/_/
| _/_/_/_/
| Germany_/
| https://ecardfile.com/id/stewarttranter
|  _/
|
...
|  Management and security solutions.  We make your e-solutions work.  
| On budget. On time. Every time.  External Web Site:  
| http://www.hp.com/hps/   Internal Web Site:  
| http://ses.cup.hp.com/ 
|
...
|
| MESSAGE FROM 2nd April 2003:
|
| Hello,
|
| I have a MySQL Database with two instances running.  They were both
working
| 100% normally, until yesterday.  When we connect to one instance we
get the
| following error:
|
| mysqld got signal 10;
| This could be because you hit a bug. It is also possible that this 
| binary or one of the libraries it was linked against is corrupt, 
| improperly
built,
| or misconfigured. This error can also be caused by malfunctioning
hardware.
| We will try our best to scrape up some info that will hopefully help 
| diagnose the problem, but since we have already crashed, something is 
| definitely wrong
| and this may fail
|
| key_buffer_size=16773120
| record_buffer=131072
| sort_buffer=524280
| max_used_connections=0
| max_connections=100
| threads_connected=1
| It is possible that mysqld could use up to
| key_buffer_size + (record_buffer + sort_buffer)*max_connections = 
| 80379 K bytes of memory Hope that's ok, if not, decrease some 
| variables in the equation
|
| 030402 11:32:22  mysqld restarted
|
| The other instance however works totally fine!  The server diskspace
is ok,
| we rebooted the server, everything looks ok!
|
| We are running "HP-UX B.11.11 U 9000/800 839927861 unlimited-user 
| license" with MySQL version:  Ver 3.23.54-max for hp-hpux11.11 on 
| hppa2.0w
|
| Can anyone offer any suggestions please?  We are all totally 
| stumped!!!
|
| Many thanks in advance and best regards,
|
| Stewart


There is a known issue on 64 bit platforms with MySQL versions < 3.23.56
causing a crash when 'SHOW VARIABLES' is executed.

You are right in thinking that the JDBC driver issues this query, because it
does. The JDBC driver uses the results of 'SHOW VARIABLES' to set many
internal parameters related to various capabilities that different versions
of MySQL and different configurations of MySQL have.

-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

Re: Can we make some C, Java based "Mysql App Server"

[Martin Gainty]

Daniel
How about 1 working Java or C or C++ example which uses MySQL
Personally every example I have used (both Linux and Windows) uses libraries
which
cannot resolve the simplest MySQL functions with no ability to recover.
Very frustrating.
Thank You,
Martin
- Original Message -
From: "Daniel Rossi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, April 02, 2003 11:54 PM
Subject: Re: Can we make some C, Java based "Mysql App Server"


hmm a middleware product would be good , extra processing=time ?

also stored procedures would be excellent ,

 also maybe a middleware product to load balance between slave and master
and delegate slaves if a master goes down is there such a thing ?

>>> Nitin Nanivadekar <[EMAIL PROTECTED]> 04/03/03 04:41pm >>>
Dear Friends,
We all know Mysql is a beautiful database engine but
there are some things missing. Even Mysql team
acknowkedges the need in their ToDo list.
i was thinking of designing a Java, C based
application server that acts as a gridge bewween the
applications & the database. This server can take care
of various aspects & especially as a Pre-Processor for
aome nice queries such as "Connect By", Stored
procedures, triggers etc.
Mysql team will require beyond ver 5.0 to give us all
this.
pls comment :)
-Nitin

__
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
http://tax.yahoo.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: table structure design

[Cal Evans]

Lots of them. None cheap.  What ever you do, steer clear of the one at
www.thekompany.com. It's a piece of crap.  I bought a version and then
foolishly bought an upgrade thinking it would be better.  it's not and the
primary programmer for the project is very arrogant on the mailing list
setup for support.

ERWin is a great tool but it does not support MySQL directly. (You could use
ODBC to reverse engineer a database though) The same with ERStudio from
Embarcadero (sp?)  Great tool, expensive though.

=C=

- Original Message -
From: "Daniel Rossi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 03, 2003 12:37 AM
Subject: table structure design


is there any table structure design program in a graphical layout for
windows available ? i have tables and fields on paper but would like a way
to be able to lay them out on a screen and show which table joins to what
and what keys it uses let me know thanks


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Can we make some C, Java based "Mysql App Server"

[GERST, MICHAEL (SBCSI)]

Woah... scope creep.. hehehe

Actually, I've done a little something along these lines with the MySQL C++
API (Unfortunately in VC++).  I've found it useful for throwing together
apps against the same db quickly.

This, however, would be even better...

If anyone decides to shoot forward on this, please let me know!  My time is
somewhat constrained right now (moving, trying to get a home fixed up, a
child on the way), but I would be more than willing to donate some time to
further this along.

Thanks,

-Mike Gerst
 SBC Services
 One SBC Center
 St. Louis, MO 63011 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Thursday, April 03, 2003 12:54 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Can we make some C, Java based "Mysql App Server"

hmm a middleware product would be good , extra processing=time ?

also stored procedures would be excellent ,

 also maybe a middleware product to load balance between slave and master
and delegate slaves if a master goes down is there such a thing ?

>>> Nitin Nanivadekar <[EMAIL PROTECTED]> 04/03/03 04:41pm >>>
Dear Friends,
We all know Mysql is a beautiful database engine but
there are some things missing. Even Mysql team
acknowkedges the need in their ToDo list.
i was thinking of designing a Java, C based
application server that acts as a gridge bewween the
applications & the database. This server can take care
of various aspects & especially as a Pre-Processor for
aome nice queries such as "Connect By", Stored
procedures, triggers etc.
Mysql team will require beyond ver 5.0 to give us all
this.
pls comment :)
-Nitin

__
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
http://tax.yahoo.com 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql 
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED] 



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: BUG: NT service account and defaults file

[miguel solorzano]

At 17:04 02/04/2003 +0100, Simon Tyler wrote:
Hi,
Looking at the code (3.23, 4.0 and 4.1) it looks as if it is getting 
confused in the main (in mysqld.cpp) and just calls Service.Init without 
loading the default file.

Doing the above without a service name works OK, doing it without 
over-riding the default-file is OK.
Yes probably this is the fix way. I will test also what is the
behavior when several services are running on the same machine.
Thanks for to point this.
--
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Miguel Angel Solórzano <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   São Paulo - Brazil
/_/  /_/\_, /___/\___\_\___/
   <___/   www.mysql.com 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Please HELP!!! Re: Database Core Dumps

[Mark Matthews]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
TRANTER,STEWART (HP-Germany,ex1) wrote:
| Hello Everyone,
|
| Yesterday I posted the message listed below.  I have some more
information.
| We have found the command that "pushes our database over the edge"!
It is:
|
| SHOW VARIABLES;
|
| All other db commands work (such as SHOW VARIABLES "%a";) except for:
|
| SHOW VARIABLES "%"
|
| Does anyone have any idea why this could be happening?  In addition we are
| connecting to the database from a JSP Script using the driver:
|
| org.gjt.mm.mysql.Driver
|
| The JSP page doesn't actually explicitly call the SHOW VARIABLES; command,
| but I guess (?) that this is called explicitly in the driver connection
| somehow...  We confirmed that it was the SHOW VARIABLES; command by
checking
| the log file (with --log and --log-update options).  We then tried this at
| the MySQL command line and it caused the db to restart.
|
| Could this mean that one of the variables displayed by the SHOW VARIABLES;
| command is causing some form of problem?
|
| Once again, many thanks in advance for taking the time to read this mail,
| and I hope someone can help!
|
| The very best of regards,
|
| Stewart
|
..._/..
| Stewart Tranter[EMAIL PROTECTED] _/   
| Hewlett-Packard GmbH   Tel: (+49) 7031 14-1554   _/_/_/_/
| _/_/_/_/
| Software Engineering Services  Fax: (+49) 7031 14-4961  _/_/  _/_/
| Schickard Str.25   Mob: (+49) 1784 701 079 _/_/  _/_/
| 71034 Böblingen _/_/
| _/_/_/_/
| Germany_/
| https://ecardfile.com/id/stewarttranter
|    _/
|
...
|  Management and security solutions.  We make your e-solutions work.
|  On budget. On time. Every time.
|  External Web Site:  http://www.hp.com/hps/ 
|  Internal Web Site:  http://ses.cup.hp.com/ 
|
...
|
| MESSAGE FROM 2nd April 2003:
|
| Hello,
|
| I have a MySQL Database with two instances running.  They were both
working
| 100% normally, until yesterday.  When we connect to one instance we
get the
| following error:
|
| mysqld got signal 10;
| This could be because you hit a bug. It is also possible that this binary
| or one of the libraries it was linked against is corrupt, improperly
built,
| or misconfigured. This error can also be caused by malfunctioning
hardware.
| We will try our best to scrape up some info that will hopefully help
| diagnose
| the problem, but since we have already crashed, something is definitely
| wrong
| and this may fail
|
| key_buffer_size=16773120
| record_buffer=131072
| sort_buffer=524280
| max_used_connections=0
| max_connections=100
| threads_connected=1
| It is possible that mysqld could use up to
| key_buffer_size + (record_buffer + sort_buffer)*max_connections = 80379 K
| bytes of memory
| Hope that's ok, if not, decrease some variables in the equation
|
| 030402 11:32:22  mysqld restarted
|
| The other instance however works totally fine!  The server diskspace
is ok,
| we rebooted the server, everything looks ok!
|
| We are running "HP-UX B.11.11 U 9000/800 839927861 unlimited-user license"
| with MySQL version:  Ver 3.23.54-max for hp-hpux11.11 on hppa2.0w
|
| Can anyone offer any suggestions please?  We are all totally stumped!!!
|
| Many thanks in advance and best regards,
|
| Stewart
There is a known issue on 64 bit platforms with MySQL versions < 3.23.56
causing a crash when 'SHOW VARIABLES' is executed.
You are right in thinking that the JDBC driver issues this query,
because it does. The JDBC driver uses the results of 'SHOW VARIABLES' to
set many internal parameters related to various capabilities that
different versions of MySQL and different configurations of MySQL have.
	-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.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQE+jDA+tvXNTca6JD8RAtiDAJ9EOsjZ8fE0T79BYC8qv+qJq7RubwCfcWp9
lo7USihZqgkfQQ7izJSTaxI=
=p7oA
-END PGP SIGNATURE-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Please HELP!!! Re: Database Core Dumps

[Stefan Hinz]

Stewart,

> Yesterday I posted the message listed below.  I have some more information.
> We have found the command that "pushes our database over the edge"!  It is:

> SHOW VARIABLES;

> All other db commands work (such as SHOW VARIABLES "%a";) except for:

> SHOW VARIABLES "%"

This should be "SHOW VARIABLES LIKE '%'". I tested all variants with
4.0.10, no problems. "SHOW VARIABLES '%'" gives me error 1064, as
should be.

> Does anyone have any idea why this could be happening?  In addition we are
> connecting to the database from a JSP Script using the driver:
> org.gjt.mm.mysql.Driver

So your problem seems to be related to the driver, or to your JSP app.

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  iConnect GmbH 
  Heesestr. 6, 12169 Berlin (Germany)
  Telefon: +49 30 7970948-0  Fax: +49 30 7970948-3

[filter fodder: sql, mysql, query]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

AW: Schema definition fails when converted to InnoDB

[Thorsten Schmidt]

> -Ursprüngliche Nachricht-
> Von: Ian Hartas [mailto:[EMAIL PROTECTED] 
> Gesendet: Donnerstag, 3. April 2003 11:40
> An: [EMAIL PROTECTED]
> Betreff: Schema definition fails when converted to InnoDB
> 
> 
> >Description:
> I have a database schema .sql file which is accepted 
> when run with MyISAM tables. If I change the tables to be 
> type = InnoDB, then it fails with the error
> message:
> 
> mysql -u ts -p hbs  ERROR 1005 at line 54: Can't create table 
> './hbs/#sql-34ef_f.frm' (errno: 150)

This sounds like you are trying to create foreign keys but don't have an index on 
these fields.
You may check this.

This would also explain why it works on MyISAM -> this format has no foreign key 
feature and ignores these settings, but not with InnoDB.

Bye

Thorsten

> >How-To-Repeat:
> Save this text as schema_mysql.sql and run it as 
> noted in the description line.
> database called 'hbs', user called 'ts'
> 
> /*
> ** MySQL schema for the Holiay Booking System within FJS.
> **
> ** by Ian Hartas, Kid01.
> **
> */
> 
> drop table if exists ts_proj_team;
> drop table if exists ts_resource_mgrs;
> drop table if exists ts_entry;
> drop table if exists ts_user_details;
> drop table if exists ts_project_code_details;
> drop table if exists ts_project_details;
> drop table if exists ts_team;
> drop table if exists ts_programme;
> drop table if exists ts_location_entry;
> drop table if exists ts_default_location;
> 
> create table ts_team
> (
>  TEAM_IDinteger(8) not null primary key
>  ,TEAM_NAME varchar(30) not null
>  ,team_admin_email varchar(100)
> ) type = InnoDB;
> 
> create table ts_programme
> (
>  PROGRAMME_ID   integer(8) not null primary key
>  ,PROGRAMME_NAMEvarchar(30) not null
> ) type = InnoDB;
> 
> create table ts_user_details
> (
>  USER_IDvarchar(8) not null 
> primary key
>  ,TEAM_ID   integer(8)
>  ,STANDARD_HOURSfloat(30,2)
>  ,USER_NAME varchar(40) not null
>  ,PASSWORD  varchar(20) not null
>  ,DEFAULT_LOCATION_ID   integer(8)
>  ,ACTIVECHAR(1) -- 
> check(ACTIVE in ('Y','N'))
>  ,DESCRIPTION   varchar(255)
>  ,EMAIL_ADDRESS varchar(100)
>  ,HOURLY_RATE   decimal(9,2)
>  ,ACCESS_LEVEL  integer(8) default 0
>  ,charge_rate   varchar(20)
>  ,start_datedatetime
>  ,holiday_entitlement   decimal(9,2)
>  ,holiday_taken decimal(9,2)
>  ,holiday_carry_overdecimal(9,2)
>  ,holiday_bought_sold   decimal(9,2)
>  ,holiday_hours varchar(200)
> ) type = InnoDB;
> 
> alter table ts_user_details add constraint u_t foreign key (team_id)
> references ts_team(team_id);
> 
> create table ts_project_details
> (
>  PROJECT_ID integer(8) not null 
> primary key
>  ,PROJECT_NAME  varchar(60) not null
>  ,DESCRIPTION   varchar(255)
>  ,ACTIVECHAR(1) -- 
> check(ACTIVE in ('Y','N'))
> ) type = InnoDB;
> 
> create table ts_project_code_details
> (
>  PROJECT_CODE_IDinteger(8) not null primary key
>  ,PROJECT_IDinteger(8) not null
>  ,PROJECT_CODE  varchar(10) not null
>  ,PROJECT_CODE_NAME varchar(60) not null
>  ,DESCRIPTION   varchar(255)
>  ,UTIL_IND  CHAR(1)
>  ,ACTIVECHAR(1) -- 
> check(ACTIVE in ('Y','N'))
> ) type = InnoDB;
> 
> alter table ts_project_code_details add constraint pc_t 
> foreign key (project_id)
> references ts_project_details(project_id);
> 
> create table ts_proj_team
> (
>   TEAM_ID   integer(8) not null
>   ,PROJECT_ID   integer(8) not null
> ) type = InnoDB;
> 
> alter table ts_proj_team add constraint pt_p foreign key (project_id)
> references ts_project_details(project_id);
> alter table ts_proj_team add constraint pt_t foreign key (team_id)
> references ts_team(team_id);
> 
> create table ts_resource_mgrs
> (
>   TEAM_ID   integer(8) not null
>   ,USER_ID  varchar(8) not null
> ) type = InnoDB;
> 
> alter table ts_resource_mgrs add constraint rm_p foreign key(team_id)
> references ts_team(team_id);
> alter table ts_resource_mgrs add constraint rm_u foreign key(user_id)
> references ts_user_details(user_id);
> 
> create table ts_entry
> (
>  ID integer(38) not null primary key
>  ,USER_ID   varchar(8) not null
>  ,PROJECT_IDinteger(8)
>  ,PROJECT_CODE_ID   integer(8)
>  ,TEAM_ID   integer(8)
>  ,HOURS FLOAT(30,2)
>  ,EDATE datetime
>  ,CDATE d

Schema definition fails when converted to InnoDB

[Ian Hartas]

>Description:
I have a database schema .sql file which is accepted when run with MyISAM
tables. If I change the tables to be type = InnoDB, then it fails with the error
message:

mysql -u ts -p hbs How-To-Repeat:
Save this text as schema_mysql.sql and run it as noted in the description line.
database called 'hbs', user called 'ts'

/*
** MySQL schema for the Holiay Booking System within FJS.
**
** by Ian Hartas, Kid01.
**
*/

drop table if exists ts_proj_team;
drop table if exists ts_resource_mgrs;
drop table if exists ts_entry;
drop table if exists ts_user_details;
drop table if exists ts_project_code_details;
drop table if exists ts_project_details;
drop table if exists ts_team;
drop table if exists ts_programme;
drop table if exists ts_location_entry;
drop table if exists ts_default_location;

create table ts_team
(
 TEAM_IDinteger(8) not null primary key
 ,TEAM_NAME varchar(30) not null
 ,team_admin_email varchar(100)
) type = InnoDB;

create table ts_programme
(
 PROGRAMME_ID   integer(8) not null primary key
 ,PROGRAMME_NAMEvarchar(30) not null
) type = InnoDB;

create table ts_user_details
(
 USER_IDvarchar(8) not null primary key
 ,TEAM_ID   integer(8)
 ,STANDARD_HOURSfloat(30,2)
 ,USER_NAME varchar(40) not null
 ,PASSWORD  varchar(20) not null
 ,DEFAULT_LOCATION_ID   integer(8)
 ,ACTIVECHAR(1) -- check(ACTIVE in ('Y','N'))
 ,DESCRIPTION   varchar(255)
 ,EMAIL_ADDRESS varchar(100)
 ,HOURLY_RATE   decimal(9,2)
 ,ACCESS_LEVEL  integer(8) default 0
 ,charge_rate   varchar(20)
 ,start_datedatetime
 ,holiday_entitlement   decimal(9,2)
 ,holiday_taken decimal(9,2)
 ,holiday_carry_overdecimal(9,2)
 ,holiday_bought_sold   decimal(9,2)
 ,holiday_hours varchar(200)
) type = InnoDB;

alter table ts_user_details add constraint u_t foreign key (team_id)
references ts_team(team_id);

create table ts_project_details
(
 PROJECT_ID integer(8) not null primary key
 ,PROJECT_NAME  varchar(60) not null
 ,DESCRIPTION   varchar(255)
 ,ACTIVECHAR(1) -- check(ACTIVE in ('Y','N'))
) type = InnoDB;

create table ts_project_code_details
(
 PROJECT_CODE_IDinteger(8) not null primary key
 ,PROJECT_IDinteger(8) not null
 ,PROJECT_CODE  varchar(10) not null
 ,PROJECT_CODE_NAME varchar(60) not null
 ,DESCRIPTION   varchar(255)
 ,UTIL_IND  CHAR(1)
 ,ACTIVECHAR(1) -- check(ACTIVE in ('Y','N'))
) type = InnoDB;

alter table ts_project_code_details add constraint pc_t foreign key (project_id)
references ts_project_details(project_id);

create table ts_proj_team
(
  TEAM_ID   integer(8) not null
  ,PROJECT_ID   integer(8) not null
) type = InnoDB;

alter table ts_proj_team add constraint pt_p foreign key (project_id)
references ts_project_details(project_id);
alter table ts_proj_team add constraint pt_t foreign key (team_id)
references ts_team(team_id);

create table ts_resource_mgrs
(
  TEAM_ID   integer(8) not null
  ,USER_ID  varchar(8) not null
) type = InnoDB;

alter table ts_resource_mgrs add constraint rm_p foreign key(team_id)
references ts_team(team_id);
alter table ts_resource_mgrs add constraint rm_u foreign key(user_id)
references ts_user_details(user_id);

create table ts_entry
(
 ID integer(38) not null primary key
 ,USER_ID   varchar(8) not null
 ,PROJECT_IDinteger(8)
 ,PROJECT_CODE_ID   integer(8)
 ,TEAM_ID   integer(8)
 ,HOURS FLOAT(30,2)
 ,EDATE datetime
 ,CDATE datetime
 ,MDATE datetime
 ,LOCKEDCHAR(1) -- check(LOCKED in ('Y','N','D'))
 ,UPDATE_HOURS  FLOAT(30,2)
 ,UPDATE_PROJECT_ID integer(8)
 ,UPDATE_PROJECT_CODE_ID integer(8)
 ,DESCRIPTION   varchar(255)
 ,nbhours   decimal(9,2)
 ,update_nbhoursdecimal(9,2)
) type = InnoDB;

alter table ts_entry add constraint e_p foreign key (project_id)
references ts_project_details(project_id);

alter table ts_entry add constraint ec_p foreign key (project_code_id)
references ts_project_code_details(project_code_id);

alter table ts_entry add constraint e_u foreign key (user_id)
references ts_user_details(user_id);


/*
** Staff movement tracking
*/

create table ts_location_entry
(
USER_ID varchar(8

Re: 4.0.12 libmysqlclient.a

[Allen Grace]

On Wednesday 02 April 2003 19:32, Martin Gainty wrote:

> Attempting to run the makefile for test_libmysqld.c

Where does this file test_libmysqld.c come from? I'm working with the 4.0.12 
distribution, there's nothing called that in the package I have.

...

> /cygdrive/g/mysql/test_libmysqld/test_libmysqld.c:41: undefined reference
> to `_m
> ysql_server_init'
> /cygdrive/g/DOCUME~1/mysql/LOCALS~1/Temp/ccocg8oR.o(.text+0xcf):/cygdrive/g
>/ mysq
> l/test_libmysqld/test_libmysqld.c:49: undefined reference to `_mysql_close'
>
> why am I getting unresolved references when I link to 4.0.12
> libmysqlclient.a???

There's no symbol with those names in libmysqlclient.a as far as I can tell:

# cd /opt/mysql-4.0.12/lib/mysql
# nm libmysqlclient.a | grep _mysql_close
#

No rows returned, so that's why the linker can't find it. (Same result for 
_mysql_server_init.)

I did a find and grep across the whole source tree and find no references to 
these functions, so I don't think they exist and whoever wrote 
test_libmysqld.c forgot to write them. Or they live in a library that's local 
to your site.

HTH

allen

-- 
*

Allen Grace ([EMAIL PROTECTED])
Analyst Programmer
Peters Bookselling Services
120 Bromsgrove Street, Birmingham, B5 6RJ

*

This email and any files transmitted with it are
confidential and intended solely for the use of the
individual or entity to whom they are addressed.

If you are not the intended above named addressee it
may be unlawful for you to read, copy, distribute or
otherwise use the information in this internet email.

Any views or personal opinions expressed within this
email may not be those of Peters Bookselling Services.

*

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Please HELP!!! Re: Database Core Dumps

[TRANTER,STEWART (HP-Germany,ex1)]

Hello Everyone,

Yesterday I posted the message listed below.  I have some more information.
We have found the command that "pushes our database over the edge"!  It is:

SHOW VARIABLES;

All other db commands work (such as SHOW VARIABLES "%a";) except for:

SHOW VARIABLES "%"

Does anyone have any idea why this could be happening?  In addition we are
connecting to the database from a JSP Script using the driver:

org.gjt.mm.mysql.Driver

The JSP page doesn't actually explicitly call the SHOW VARIABLES; command,
but I guess (?) that this is called explicitly in the driver connection
somehow...  We confirmed that it was the SHOW VARIABLES; command by checking
the log file (with --log and --log-update options).  We then tried this at
the MySQL command line and it caused the db to restart.

Could this mean that one of the variables displayed by the SHOW VARIABLES;
command is causing some form of problem?

Once again, many thanks in advance for taking the time to read this mail,
and I hope someone can help!

The very best of regards,

Stewart
..._/..
Stewart Tranter  [EMAIL PROTECTED] _/   
Hewlett-Packard GmbH Tel: (+49) 7031 14-1554   _/_/_/_/
_/_/_/_/
Software Engineering ServicesFax: (+49) 7031 14-4961  _/_/  _/_/
Schickard Str.25 Mob: (+49) 1784 701 079 _/_/  _/_/ 
71034 Böblingen   _/_/
_/_/_/_/   
Germany  _/
https://ecardfile.com/id/stewarttranter
   _/
...
 Management and security solutions.  We make your e-solutions work.
 On budget. On time. Every time.  
 External Web Site:  http://www.hp.com/hps/  
 Internal Web Site:  http://ses.cup.hp.com/  
...

MESSAGE FROM 2nd April 2003:

Hello,

I have a MySQL Database with two instances running.  They were both working
100% normally, until yesterday.  When we connect to one instance we get the
following error:

mysqld got signal 10;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose
the problem, but since we have already crashed, something is definitely
wrong
and this may fail

key_buffer_size=16773120
record_buffer=131072
sort_buffer=524280
max_used_connections=0
max_connections=100
threads_connected=1
It is possible that mysqld could use up to
key_buffer_size + (record_buffer + sort_buffer)*max_connections = 80379 K
bytes of memory
Hope that's ok, if not, decrease some variables in the equation

030402 11:32:22  mysqld restarted

The other instance however works totally fine!  The server diskspace is ok,
we rebooted the server, everything looks ok!

We are running "HP-UX B.11.11 U 9000/800 839927861 unlimited-user license"
with MySQL version:  Ver 3.23.54-max for hp-hpux11.11 on hppa2.0w

Can anyone offer any suggestions please?  We are all totally stumped!!!

Many thanks in advance and best regards,

Stewart

RE: Join Statement

[Chris Blake]

Thanks for tip, I`ve been doing a bit of reading up and have solved the
problem.

Your advice will be stored for future reference, thanks.



On Wed, 2003-04-02 at 21:31, Michael Shulman wrote:
> You can't use a JOIN on an insert, only on a SELECT. 
> 
> The (simplest) syntax for INSERT is
> 
> INSERT INTO  (col1, col2, col3) VALUES (val1, val2, val3)
> 
> You can also INSERT as a result of a SELECT, but that's not what you want.
> 
> Unfortunately, you will need to create multiple INSERT statements to keep
> the referential integrity solid.
> 
> If you use InnoDB, you can wrap your INSERT statements into a transaction so
> that they all are committed as a group. That way, you won't be left with
> dangling inserts without corresponding values in other tables if your insert
> fails.
> 
> -ms
>  
> 
> -Original Message-
> From: Chris Blake [mailto:[EMAIL PROTECTED] 
> Sent: Friday, March 28, 2003 1:37 AM
> To: [EMAIL PROTECTED]
> Subject: Join Statement
> 
> Greetings MySQL folk,
> 
> New to MySQL.here goes.
> 
> Have db with following tables :
> 
> Client :
> ClientID | ClientName | Address | Distance | ContactName | ContactNo
> 
> Jobs :
> JobID | ClientID | JobDate | JobDistance | JobWorkDone | JobTimeTaken |
> JobTypeID
> 
> JobTypes :
> JobTypeID | JobDesc
> 
> I need to create a JOIN statement in MySQL that will update the db but I
> can`t get it right :
> 
> Heres the (partial) code, it`s been through so many amendments I`ve
> actually got myself in a knot here.
> 
> //Create SQL to Update Job Info 
>   $sqlSaveJob = "INSERT INTO Jobs INNER JOIN ON  JobTypes" .
>   $sqlSaveJob = "SET ClientID = '$ClientID',".
>   $sqlSaveJob = "JobDate = $JobDate1,".
>   $sqlSaveJob = "JobTypesID = $JobTypesID,".
>   $sqlSaveJob = "Distance = $Distance,".
>   $sqlSaveJob = "WHERE ClientID = '$ClientID'"  ;
> 
> Any pointers.this is rather confusing. I may be a dufus cus I read
> the MySQL docs but it don`t make any sense.
> 
> -- 
> Chris Blake
> Office : (011) 782-0840
> Cell : 083 985 0379
> A chicken is the eggs way of producing more eggs.
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> 
-- 
Chris Blake
Office : (011) 782-0840
Cell : 083 985 0379
Linux vs. Windows is a no-WIN situation.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]