Re: how to determine user Privilege fields

2004-01-09 Thread Jeremy March
Can I create a php script like: No. Try this: $privSQL = SHOW GRANTS FOR 'paul'@'localhost';; $priv_result = mysql_query($privSQL) or die(Couldn't Select Priv); while($myrow = mysql_fetch_row($priv_result)) { echo $myrow[0]br; } I believe this only returns a single row with the grant

Re: mysqld without LinuxThreads

2004-01-09 Thread [EMAIL PROTECTED]
Thanks a lot for your kind and amusing explanation! I will have a look at MySQL thread layer AND of course wait for kernel 2.6.. Chris Nolan wrote: On Thu, 2004-01-08 at 21:10, [EMAIL PROTECTED] wrote: Andy Bakun wrote: On Wed, 2004-01-07 at 10:38, [EMAIL PROTECTED] wrote: Hi

Re: mysqld without LinuxThreads

2004-01-09 Thread Andy Bakun
On Thu, 2004-01-08 at 05:24, Chris Nolan wrote: 3. Wait for a while. Linux 2.6 includes (as does the RedHat 9.0 and ES/WS/AS 3.0 kernels) NPTL - the Native POSIX Threads for Linux implementation which is superior in many ways and does not use clone() at all. As you'll no longer want to use

Re: Convert query from v4 syntax to v3

2004-01-09 Thread Rory McKinley
On 7 Jan 2004 at 11:04, Odhiambo Washington wrote: Hello, I have a query that executes well when run on MySQL-4.x, but not 3.23.x: SELECT popbox.local_part, popbox.password_hash, popbox.domain_name, CONCAT(domain.path,'/',popbox.mbox_name) AS path FROM popbox JOIN domain USING

Unknown character set: 'latin1_swedish_ci'

2004-01-09 Thread conrad . stefan
040109 11:06:17 Unknown character set: 'latin1_swedish_ci' I get thousands of this Messages in the Errorlog, since I switched from 4.1.0 to 4.1.1 SHOW COLLATION LIKE 'latin1%' Collation | Charset |Id |Default |Compiled |Sortlen latin1_german1_ci | latin1 | 5 | |

Re: Knowing the real size of a column

2004-01-09 Thread Director General: NEFACOMP
I have tried it but it failed to give me that size. It only works when the content is a CHAR or VARCHAR. It just returns the number of characters, not the disk size. Thanks Emery - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 08,

Re: Knowing the real size of a column

2004-01-09 Thread Director General: NEFACOMP
Yes, I am using ADO. But, I wanted to know the size so that the application may decide to download the content. I wanted to download the content if its size is below 1MB. ADO will know the size after downloading it; is it right? I might be wrong!!! Thanks Emery - Original Message -

Re: MYSQL Aborting

2004-01-09 Thread Victoria Reznichenko
Chris L. White [EMAIL PROTECTED] wrote: Need some help on this one. We are using the MYSQL on Server 2003. This is what I keep getting: Microsoft Windows [Version 5.2.3790] (C) Copyright 1985-2003 Microsoft Corp. C:\MySQL\binmysqld --console InnoDB: The first specified data file

Re: mysqld without LinuxThreads

2004-01-09 Thread Chris Nolan
On Fri, 2004-01-09 at 20:58, Andy Bakun wrote: On Thu, 2004-01-08 at 05:24, Chris Nolan wrote: 3. Wait for a while. Linux 2.6 includes (as does the RedHat 9.0 and ES/WS/AS 3.0 kernels) NPTL - the Native POSIX Threads for Linux implementation which is superior in many ways and does not use

Re: Free software to design forms and report

2004-01-09 Thread Shawn
I am a new to MySQL. Would like to find out if there is any free software out in the market to design forms and report that links to MySQL. I am looking at a local database, forms and report. How about DBForms? http://jdbforms.sourceforge.net/ DbForms enables developers to build sophisticated

Re: Problems with fulltext search in boolean mode

2004-01-09 Thread Egor Egorov
Mark van Herpen [EMAIL PROTECTED] wrote: Sure, SELECT ID, companyName, streetName, houseNo, postalCode, city, firstName, lastName, debNo, houseNoExt , MATCH (companyName, streetName, city, postalCode, lastName, firstName) AGAINST ('Mark -Nijmegen' IN BOOLEAN MODE) AS score FROM

Re: Recommended Course

2004-01-09 Thread Aftab Jahan Subedar
Hey why not travel to Dhaka in my tour learn package. I teach 1. C/C++ on Unix/Win32/MFC 2. MySQL C API uses with MySQL 3. C+CGI+MySQL+MySQL C API 3. MySQL Administration Tour learn package available vice-versa tooo!!! If you can provide passage. Marc Dver wrote: This might be a bit of a

Re: apostrophe error

2004-01-09 Thread Aftab Jahan Subedar
Try using QUOTE function. Asif Iqbal wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi All I have been using mysql database to collect my syslog data. It was working fine. However recently I had few logs that had apotrophe and I failed to insert those lines into my database. It said syntax

Converting an Access Table to MySQL

2004-01-09 Thread zzapper
Hi Ya, How to this has always been somewhat fuzzy in my head. I looked around for tools unsuccessfully . So I thought I'd share my solution. I've just written a simple Perl script to do this, this uses DBI:mysql to write to mysql and DBI:ODBC to read from Access. I suppose it could be rewritten

Re: Mysql by itself? [err: 10061]

2004-01-09 Thread Victor Medina
I think the point is, that when you installed it, there was a dependency was it mysql? or was it apache? I am thinking it was apache, maybe the auth_mysql was compiled with it, so it needed the mysql to run porperly. Apche has a module that allows it to authenticate users against a db server

embedded MySQL on arm

2004-01-09 Thread Raphael Mack
hi, I'm working on a project with an arm-CPU in an embedded system, so there are a few hardware limits like slow CPU, little RAM and very little ROM (Flash). I hope to get a MMC-Interface running to use for data storage. I'm very free to chose a db and version and don't need much features. Now

ON UPDATE CASCADE

2004-01-09 Thread Morten Gulbrandsen
Hello, If I change the value of a reference a , for instance by means of updating or inserting values, I'd expect both updated values and inserted values to cascade, hence to change b, where FOREIGN KEY (b) REFERENCES A(a) ON UPDATE CASCADE In this example foreign key and reference

Re: select lock - How reliable?

2004-01-09 Thread Alfredo Cole
El Jue 08 Ene 2004 19:56, Paul DuBois escribió: At 19:16 -0600 1/8/04, Alfredo Cole wrote: Hi: (...) The code I use is: select lock Sorry. It's select get_lock... get code add one to code write code release lock and select release_lock... That looks like pseudo code

Re: Convert query from v4 syntax to v3

2004-01-09 Thread Odhiambo Washington
* Rory McKinley [EMAIL PROTECTED] [20040109 13:21]: wrote: On 7 Jan 2004 at 11:04, Odhiambo Washington wrote: Hello, I have a query that executes well when run on MySQL-4.x, but not 3.23.x: SELECT popbox.local_part, popbox.password_hash, popbox.domain_name, CONCAT(domain.path

import data from text files

2004-01-09 Thread Armin
hi list , I've got two problem with mysql , maybe it is not a real 'problem' but i need help hardly ! :) 1 in a table , we got many record ( 1400 ) , some of them are equal , i want to delete just one of them , in other word , i don't want two record equal . 2 i got a text file , which

Re: Mysql by itself?

2004-01-09 Thread Donald Henson
On Thu, 2004-01-08 at 21:23, EP wrote: OK, I need to ask a stupid question. I normally run MySQL on Apache. I have a second machine [a laptop] which I can't get Apache to run on [the ports are restricted/closed]. Is there a way to run MySQL without a server like Apache underneath it?

Re: Convert query from v4 syntax to v3

2004-01-09 Thread Rory McKinley
On 9 Jan 2004 at 16:48, Odhiambo Washington wrote: * Rory McKinley [EMAIL PROTECTED] [20040109 13:21]: wrote: On 7 Jan 2004 at 11:04, Odhiambo Washington wrote: Hello, I have a query that executes well when run on MySQL-4.x, but not 3.23.x: SELECT popbox.local_part

Re: Convert query from v4 syntax to v3

2004-01-09 Thread Roger Baklund
* Rory McKinley [...] * Odhiambo Washington I have a query that executes well when run on MySQL-4.x, but not 3.23.x: [...] I can't see what is throwing the syntax error..p'raps I am just being dense. Note that INNER JOIN syntax allows a join_condition only from MySQL 3.23.17 on. The same is

Re: apostrophe error

2004-01-09 Thread Matthew Stuart
Man I have been banging away at this for a week and I am only just getting to a point where I am finding a resolution. There seems to be a lot of info out there for this kind of thing, but very little on how to implement it. I use ASP and VBScript with Macromedia Dreamweaver so with asp I can

tuning key_buffer_size

2004-01-09 Thread Joshua Thomas
Hello all, My mySQL 4.1.0 server is currently set to use a key_buffer_size of 32M. My server has 1GB of RAM, and is now using only InnoDB tables. The manual says that 'Key_reads/Key_read_request ratio should normally be 0.01'; mine is ~ 0.12; the manual also says 'Key_write/Key_write_requests

Re: import data from text files

2004-01-09 Thread Roger Baklund
* Armin I've got two problem with mysql , maybe it is not a real 'problem' but i need help hardly ! :) 1 in a table , we got many record ( 1400 ) , some of them are equal , i want to delete just one of them , in other word , i don't want two record equal . Take a look at SELECT

Re: Convert query from v4 syntax to v3

2004-01-09 Thread Rory McKinley
On 9 Jan 2004 at 15:33, Roger Baklund wrote: * Rory McKinley [...] * Odhiambo Washington I have a query that executes well when run on MySQL-4.x, but not 3.23.x: [...] I can't see what is throwing the syntax error..p'raps I am just being dense. Note that INNER JOIN syntax allows a

Re: Converting an Access Table to MySQL

2004-01-09 Thread Nitin Mehta
you need not write any scripts, just use MySQL Front to Import/Export dat from M$ Access zzapper [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi Ya, How to this has always been somewhat fuzzy in my head. I looked around for tools unsuccessfully . So I thought I'd share my

Time Zone

2004-01-09 Thread Hassan Shaikh
Hi, How do I change datetime from one time zone to another? I've a column in one of my tables having the type DATETIME and I need to show date AND time to end-user based on his/her preference. TIA. Hassan

Re: import data from text files

2004-01-09 Thread Nestor Florez
Armin, 1)When you say that the records are duplicate, do you mean the record number(first field) or or do you mean the entire record is a duplicate? 2)Now to load a file made out of comma separated fields into a table that was created in the same field format, here are 2 ways: a)mysql USE

RE: Converting an Access Table to MySQL

2004-01-09 Thread John Berman
I have ported several table from access to MySQL with good results. Within Access right click on the table you are interested in and export, then select odbc data sources and off you go Regards John B -Original Message- From: Nitin Mehta [mailto:[EMAIL PROTECTED] Sent: 09 January

Re: Converting an Access Table to MySQL

2004-01-09 Thread zzapper
On Fri, 9 Jan 2004 20:40:44 +0530, Nitin Mehta [EMAIL PROTECTED] wrote: you need not write any scripts, just use MySQL Front to Import/Export dat from M$ Access Are you using MySqlfront2.5 (the original) or the new 3.x? BTW I already use/love 2.5. That's why I post to Usenet to be told

Re: Converting an Access Table to MySQL

2004-01-09 Thread Victor Medina
On Fri, 2004-01-09 at 11:44, zzapper wrote: On Fri, 9 Jan 2004 20:40:44 +0530, Nitin Mehta [EMAIL PROTECTED] wrote: you need not write any scripts, just use MySQL Front to Import/Export dat from M$ Access Are you using MySqlfront2.5 (the original) or the new 3.x? BTW I already

Re: Converting an Access Table to MySQL

2004-01-09 Thread zzapper
On Fri, 09 Jan 2004 11:48:42 -0400, Victor Medina [EMAIL PROTECTED] wrote: hey hey hey! wait a second there! is there a new mysqlfront? :o where can i download it? :) 3.0??? I already love and worship mysqlfront 2.5, i thought it was dead :( do you have a link? Victor, It's at the same URL

Re: apostrophe error

2004-01-09 Thread Michael Stassen
I don't use ASP and VBScript with Macromedia Dreamweaver, but I think the problem here is that you've misunderstood what is needed, rather than that Dreamweaver's escaping mechanism doesn't work. Let me try to explain. Mysql has no trouble with apostrophes in the data. The problem comes

Re: Converting an Access Table to MySQL

2004-01-09 Thread Victor Medina
thanxss! :) On Fri, 2004-01-09 at 12:04, zzapper wrote: On Fri, 09 Jan 2004 11:48:42 -0400, Victor Medina [EMAIL PROTECTED] wrote: hey hey hey! wait a second there! is there a new mysqlfront? :o where can i download it? :) 3.0??? I already love and worship mysqlfront 2.5,

Re: select lock - How reliable?

2004-01-09 Thread Michael Stassen
LAST_INSERT_ID() is connection specific, so it is safe from the concurrency issue. See http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html and http://www.mysql.com/doc/en/Getting_unique_ID.html for more. Michael Alfredo Cole wrote: El Jue 08 Ene 2004 19:56, Paul DuBois escribió: At 19:16

New INstall of MySQL

2004-01-09 Thread Chris L. White
Ok I have a question. This is the first time any of us here in our office have installed MySQL or for that fact worked with MySQL. So I got stuck with trying to figure it out. Ok here is the problem. I completely removed the previous MYSQL installation attempt. I started new to install

Re: Knowing the real size of a column

2004-01-09 Thread Dan Nelson
In the last episode (Jan 09), Director General: NEFACOMP said: I have tried it but it failed to give me that size. It only works when the content is a CHAR or VARCHAR. It just returns the number of characters, not the disk size. Isn't that the same thing? LENGTH() would really be better,

Problem with 'OR' statement

2004-01-09 Thread Hunter, Jess
Could someone have a look at this syntax and give me some guidance what I may be overlooking? SELECT * from $TableName WHERE machinename != 'FIND_ME' OR machinename != 'OPEN' I can make the statement work individually, but when I try to add the 'OR' statement it fails to 'remove' the designated

Re: Converting an Access Table to MySQL

2004-01-09 Thread David Rayner
Victor, It's at the same URL www.mysqlfront.de I'm not sure it's stable yet Subject:Re: Converting an Access Table to MySQL From: Victor Medina [EMAIL PROTECTED] To: zzapper [EMAIL PROTECTED] Copies to: [EMAIL PROTECTED] Date

Re: select lock - How reliable?

2004-01-09 Thread Hassan Schroeder
LAST_INSERT_ID() is connection specific, so it is safe from the concurrency issue. Note: safe may not apply if you're using connection pooling :-) -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com

Re: Problem with 'OR' statement

2004-01-09 Thread Stefan Kuhn
Am Friday 09 January 2004 17:22 schrieb Hunter, Jess: Could someone have a look at this syntax and give me some guidance what I may be overlooking? SELECT * from $TableName WHERE machinename != 'FIND_ME' OR machinename != 'OPEN' A query like where x=a or s=b will always return all values.

Re: Problem with 'OR' statement

2004-01-09 Thread Stefan Kuhn
Am Friday 09 January 2004 17:22 schrieb Hunter, Jess: Could someone have a look at this syntax and give me some guidance what I may be overlooking? SELECT * from $TableName WHERE machinename != 'FIND_ME' OR machinename != 'OPEN' Some other thing: Instead of saying where x!=a and x!=b you

Re: Problem with 'OR' statement

2004-01-09 Thread Stefan Kuhn
Am Friday 09 January 2004 17:57 schrieb Stefan Kuhn: Am Friday 09 January 2004 17:22 schrieb Hunter, Jess: Could someone have a look at this syntax and give me some guidance what I may be overlooking? SELECT * from $TableName WHERE machinename != 'FIND_ME' OR machinename != 'OPEN' A

Re: Problem with 'OR' statement

2004-01-09 Thread Matt Fuller
Jess, You should use an AND () instead of the OR. You result is everything, correct? When the query is doing the machinename != 'FIND_ME', the record(s) with machinename = 'OPEN' are being returned. Likewise, when the machinename != 'OPEN' is being performed, the records(s) with machinename =

Re: Problem with 'OR' statement

2004-01-09 Thread Michael Stassen
Your current statement, with the OR, says to select a record if its name is not FIND_ME or if its name is not OPEN. That will be all of them. I expect you want all of them except the ones named FIND_ME and OPEN. So, you want AND instead of OR, because logically, NOT (this OR that) = NOT

Re: Time Zone

2004-01-09 Thread Jochem van Dieten
Roger Baklund wrote: The date/time returned by the server is in the timezone of the server. If you need to convert it to a different timezone, you must do this within your application. It can be done directly in the SELECT statement. PHP example: $usertimezone = get_user_prefs('timezone'); $res =

Re: compiling mysql with ssl

2004-01-09 Thread Cion Chen
I have Redhat 9 with openssl-0.9.7a-20 tring to re-compiling mysql-4.0.17 again with the options: ./configure --with-openssl --with-openssl-includes=/usr/include/openssl --wi th-openssl-libs=/usr/lib --with-vio --prefix=/usr/local/compiled There is messages that is coming: checking if we

Re: New INstall of MySQL

2004-01-09 Thread Victor Medina
OK!, first of all, do you have a complete-working directory of mysql in whatever drive you installed mysql?, this is usually in c:\mysql. I asked this because the installer doesn't seems to work. Also there is no need for a my.cnf and a my.ini, you should only use one, one is enough, i rather use

Re: compiling mysql with ssl

2004-01-09 Thread Greg G
You'll want this: --with-openssl-libs=/usr/local/ssl/lib (not /usr/lib) -Greg G Cion Chen wrote: I have Redhat 9 with openssl-0.9.7a-20 tring to re-compiling mysql-4.0.17 again with the options: ./configure --with-openssl --with-openssl-includes=/usr/include/openssl --wi

Re: compiling mysql with ssl

2004-01-09 Thread Victor Medina
I had the same problem, just don't know what is wrong with the red hat ssl packages. I did this: 1.- download a fresh copy of openssl, configure with --prefix=/opt/OpenSSL, compile and install, everything will go to /optOpenSSL, so, the new version won't conflict with the red hat's 2.- compile

Re: Time Zone

2004-01-09 Thread Roger Baklund
* Jochem van Dieten [...] The $usertimezone contains an integer between -12 and +12, representing the offset in hours of the user timezone compared to the server timezone. A user in the same timezone as the server would have $usertimezone=0. Some locations have timezone offsets that are

Re: Subtracting date fields

2004-01-09 Thread Ryan Yagatich
On Sat, 2004-01-31 at 14:57, Kenneth Letendre wrote: Hello, I'm trying to get the difference (in days) between dates stored in two date fields. My query: SELECT id,(firstdate- postdate) AS diff FROM calendar This works fine if the two dates are in the same month, but not

Re: mysqld without LinuxThreads

2004-01-09 Thread Andy Bakun
On Fri, 2004-01-09 at 05:14, Chris Nolan wrote: On Fri, 2004-01-09 at 20:58, Andy Bakun wrote: On Thu, 2004-01-08 at 05:24, Chris Nolan wrote: 3. Wait for a while. Linux 2.6 includes (as does the RedHat 9.0 and ES/WS/AS 3.0 kernels) NPTL - the Native POSIX Threads for Linux

Re: select lock - How reliable?

2004-01-09 Thread Roger Baklund
* Hassan Schroeder LAST_INSERT_ID() is connection specific, so it is safe from the concurrency issue. Note: safe may not apply if you're using connection pooling :-) In what situation is this unsafe? In general, you would not call LAST_INSERT_ID() without first having done an INSERT in the

Re: select lock - How reliable?

2004-01-09 Thread Hassan Schroeder
Roger Baklund wrote: LAST_INSERT_ID() is connection specific, so it is safe from the concurrency issue. Note: safe may not apply if you're using connection pooling :-) In what situation is this unsafe? In general, you would not call LAST_INSERT_ID() without first having done an INSERT in the same

Problems loading a TEXT field

2004-01-09 Thread mark
Table's defined with ... content TEXT field, but when I issue the command insert into content values ( 'test', '', 'index.html', 1.000, 'index.html','','', load_file('/home/projects/URCMS/test/index.html'), 'import', now(), 'test', 'import', 0,''); either as script input, or from the sql

Re: Problems loading a TEXT field

2004-01-09 Thread Diana Soares
From the manual, check: * the file must be on the server * you must specify the full pathname to the file (ok, you did this) * you must have the FILE privilege * the file must be readable by all and be smaller than max_allowed_packet If the file doesn't exist or can't be read due to one of the

Re: Time Zone

2004-01-09 Thread Jochem van Dieten
Roger Baklund wrote: * Jochem van Dieten The proper way to program this would require MySQL to support the AT TIME ZONE construct, but I haven't found it on the MySQL roadmap yet. Woudn't the proper way be the way that leads to a result you can live with? Of course support in the server would

Re: select lock - How reliable?

2004-01-09 Thread Roger Baklund
* Hassan Schroeder In what situation is this unsafe? In general, you would not call LAST_INSERT_ID() without first having done an INSERT in the same session, and even with connection pooling you would usually use the same connection for all statements related to a session. What am I

Re: New INstall of MySQL

2004-01-09 Thread robert_rowe
Comment out this line: datadir = c:/SQLData in the my.ini file in your windows (winnt) folder and remove the my.cnf from your c:\. Start the server. The default location of the data folder is c:/mysql/data. You told it to look in c:/SQLData and it can't find it's security database. Also you

Re: select lock - How reliable?

2004-01-09 Thread Roger Baklund
... and of course the _point_ of connection pooling: one assumes that there is overhead involved connecting to the server, thus you would avoid a lot of connect/one-small-session/close and instead have fewer connect/many-small-sessions/close. It is relatively fast to connect to MySQL, making

Re: Time Zone

2004-01-09 Thread Roger Baklund
* Jochem van Dieten Woudn't the proper way be the way that leads to a result you can live with? Of course support in the server would have been better, but why can you not use a mechanism as described above? Using AT TIME ZONE is the way supported by SQL:1999, which makes it the proper

Re: select lock - How reliable?

2004-01-09 Thread Hassan Schroeder
Roger Baklund wrote: Maybe I don't understand connection pooling, then. Isn't its purpose to allow a client -- say, a webapp running in Tomcat -- to multiplex requests for *multiple* end users over a single connection? Almost... except for the 'single connection' part. It will maintain a pool of

RE: New INstall of MySQL

2004-01-09 Thread Chris L. White
OK I actually did as you described and it started up fine, well at least I think it did. I open the WinMySqlAdmin 1.4 window and it says not found: Driver Version:03.51 Driver: C:\windows\system32\myodbc3.dll API Level:2 Setup: C:windows\system32\myodbc3.dll SQL Level:1 It has no

mysql database, user table, two root accounts

2004-01-09 Thread Leo Donahue
I am less than 24 hours new to MySql. I have executed the following sql scripts: use mysql; delete from user where User=''; delete from db where User=''; flush privileges; select host, user, password from user; The last sql query yields the following: hostuserpassword

Re: select lock - How reliable?

2004-01-09 Thread Roger Baklund
* Hassan Schroeder [...] OK, but the user here is the servlet container (Tomcat), *not* the human end user. That should not make a difference, as seen from the server a client is a client. As would temporary tables, which is why I stopped using them for request-specific data :-) Right...

Re: select lock - How reliable?

2004-01-09 Thread Hassan Schroeder
Roger Baklund wrote: OK, but the user here is the servlet container (Tomcat), *not* the human end user. That should not make a difference, as seen from the server a client is a client. Huh? OK, Tomcat is the client of the MySQL server; user or client, same situation. As would temporary tables,

RE: mysql database, user table, two root accounts

2004-01-09 Thread Arjun Subramanian
That's not two root accounts. What that means is this: The first line defines privileges for root connecting from localhost The second line defines privileges for root connecting from any remote host. Hence the %. It implies [EMAIL PROTECTED] Hope this helps. Arjun Subramanian Georgia Tech

RE: mysql database, user table, two root accounts

2004-01-09 Thread Leo Donahue
Yes, this helps thank you. -Original Message- From: Arjun Subramanian [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 2:16 PM To: 'Leo Donahue'; [EMAIL PROTECTED] Subject: RE: mysql database, user table, two root accounts That's not two root accounts. What that means is this:

Re: compiling mysql with ssl

2004-01-09 Thread Cion Chen
Thanks for your reply, I do that but it's was unsuccesful. With theses options i get the following error when i do MAKE: ../readline/libreadline.a -lncurses ../libmysql/.libs/libmysqlclient.so -L/usr/lib -lz -lcrypt -lnsl -lm -lssl -lcrypto -Wl,--rpath -Wl,/usr/local/compiled/lib/mysql

Re: tuning key_buffer_size

2004-01-09 Thread walt
 Thomas wrote: Hello all, My mySQL 4.1.0 server is currently set to use a key_buffer_size of 32M. My server has 1GB of RAM, and is now using only InnoDB tables. The manual says that 'Key_reads/Key_read_request ratio should normally be 0.01'; mine is ~ 0.12; the manual also says

Re: select lock - How reliable?

2004-01-09 Thread Roger Baklund
* Hassan Schroeder [...] Not errors, just the same temp table being shared across end user requests. ok... If you did this: - create temp table - use temp table - drop temp table for each session, I would expect it to work. (atleast until a session crashes before it drops the temp table.)

Re: Time Zone

2004-01-09 Thread Jochem van Dieten
Roger Baklund wrote: * Jochem van Dieten Functionally, I believe it is much cleaner as it abstracts the problem away from the developer. Especially around DST changes this can be an important issue. I agree again. But it doesn't answer my question... I suppose you can live without timezones

Table lock statistics by TABLE not just server,db

2004-01-09 Thread trevor%tribenetwork.com
Mysqlians, I am trying to determine in some of my database tables should be converted from MyISAM to Innodb. I have read that a collusion on 10-20% is the threshold at which one should convert( current # around .3%). However the table_locks_waited and table_locks_immediate

Re: select lock - How reliable?

2004-01-09 Thread Hassan Schroeder
Roger Baklund wrote: ok... If you did this: - create temp table - use temp table - drop temp table for each session, I would expect it to work. (atleast until a session crashes before it drops the temp table.) This is straying from the original question :-) but my understanding of temp tables is

MySQL Service starts and then Stops

2004-01-09 Thread Chris L. White
OK this may be weird. I still have got no further than my last post, but when I start the service it starts it then it appears to stop it 10 seconds later I see this in the MySQLAdmin screen I am totally lost on this. Chris L. White Network Administrator Coe-Truman Technologies, Inc. Email:

Re: Problems loading a TEXT field

2004-01-09 Thread mark
On Friday 09 January 2004 01:44 pm, Diana Soares wrote: From the manual, check: * the file must be on the server * you must specify the full pathname to the file (ok, you did this) * you must have the FILE privilege Ahhh! Misunderstood that one. Got it, now. Thanks. Still don't understand

NOT NULL fields in INNODB Tables

2004-01-09 Thread Donal Murtagh
Greetings, My DB consists of INNODB tables, such as... CREATE TABLE user ( name VARCHAR(255) NOT NULL ) TYPE = INNODB; The NOT NULL qualifier doesn't have the effect I expected. Although I can't do this... INSERT user VALUES (null); I can do this: INSERT user VALUES (); I appreciate

Re: mysql database, user table, two root accounts

2004-01-09 Thread Michael Stassen
As [EMAIL PROTECTED] and [EMAIL PROTECTED] are separate entries in the user table, each with its own password and privileges, they are 2 separate root accounts from mysql's perspective. You could choose to think of them as the same account by keeping their settings the same, or you could

Re: select lock - How reliable?

2004-01-09 Thread William R. Mussatto
Hassan Schroeder said: Roger Baklund wrote: Maybe I don't understand connection pooling, then. Isn't its purpose to allow a client -- say, a webapp running in Tomcat -- to multiplex requests for *multiple* end users over a single connection? Almost... except for the 'single connection' part.

Re: select lock - How reliable?

2004-01-09 Thread Roger Baklund
* Hassan Schroeder Roger Baklund wrote: ok... If you did this: - create temp table - use temp table - drop temp table for each session, I would expect it to work. (atleast until a session crashes before it drops the temp table.) This is straying from the original question :-)

Re: Problems loading a TEXT field

2004-01-09 Thread Michael Stassen
mark wrote (1/9/2004): On Friday 09 January 2004 01:44 pm, Diana Soares wrote: From the manual, check: * the file must be on the server * you must specify the full pathname to the file (ok, you did this) * you must have the FILE privilege Ahhh! Misunderstood that one. Got it, now. Thanks.

Re: select lock - How reliable?

2004-01-09 Thread Hassan Schroeder
Roger Baklund wrote: Ouch. Very special, imo... this means the connection is re-negotiated for each statement? Sounds strange. Maybe the client connection is 'virtual' or 'by proxy', so that multiple users actually share the same connection at the same time? If you want to think of it that way,

Re: NOT NULL fields in INNODB Tables

2004-01-09 Thread Roger Baklund
* Donal Murtagh My DB consists of INNODB tables, such as... CREATE TABLE user ( name VARCHAR(255) NOT NULL ) TYPE = INNODB; The NOT NULL qualifier doesn't have the effect I expected. Although I can't do this... INSERT user VALUES (null); I can do this: INSERT user VALUES ();

Re: MySQL Service starts and then Stops

2004-01-09 Thread robert_rowe
Could you post the contents of you my.cnf (or my.ini) file? What OS are you trying to run the server on? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Table lock statistics by TABLE not just server,db

2004-01-09 Thread Jeremy Zawodny
On Fri, Jan 09, 2004 at 01:43:53PM -0800, trevor%tribenetwork.com wrote: Mysqlians, I am trying to determine in some of my database tables should be converted from MyISAM to Innodb. I have read that a collusion on 10-20% is the threshold at which one should convert( current #

Re: New INstall of MySQL

2004-01-09 Thread Amanullah
Hi, make sure the existing directories has been removed fully, then continue with new installation, after installation is over, pl. restart the system, if mysql daemon has not started, pl. go to ..\mysql\bin\ directory run winmysqladmin.exe. mysql service will be strated to work.. -Aman.

Certification Question

2004-01-09 Thread Arjun Subramanian
I took the MySQL core certification exam on the 2nd of January and Passed. I was just wondering when MySQL actually sends out the Certificate and other stuff they said they would send out? Does anyone here have any experience with this ? Thanks in advance. Arjun Subramanian Georgia Tech Station

Re: Certification Question

2004-01-09 Thread Amanullah
I'm also interested to take up the certification exam on Mysql, pl. guide me how to proceed to get certification on the same, I'm in India (chennai). -aman. Arjun Subramanian wrote: I took the MySQL core certification exam on the 2nd of January and Passed. I was just wondering when MySQL

Re: select lock - How reliable?

2004-01-09 Thread Roger Baklund
* Hassan Schroeder Roger Baklund wrote: Ouch. Very special, imo... this means the connection is re-negotiated for each statement? Sounds strange. Maybe the client connection is 'virtual' or 'by proxy', so that multiple users actually share the same connection at the same time? If you

Re: select lock - How reliable?

2004-01-09 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Roger Baklund wrote: [snip] A connection pooling implementation without this isolation, where multiple users can share the same database connection at the same time is either broken or intended for a special purpose (some non-multi-statement