Re: Mysql 3.23-14 keeps dieing on me...

2001-02-13 Thread Michal Matula - BillBoard.cz
Dear Scott, we ran into simillar problem also, although without those fatal consequences with having to reboot etc. We have discovered that this message usually appears when you do not explicitely close your connection to MySQL from your scripts before they end up. So - before your script en

Here you have, ;o)

2001-02-13 Thread James Moore
Hi: Check This! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-m

LDAP

2001-02-13 Thread Alex Kontorovich
Hello. Does anybody worked with LDAP + MySQL ? Thanks in advance, Alex Kontorovich - DBA - Tel:(+972)9 - 9519133 Mobile: (+972)54 - 424862 E-mail: [EMAIL PROTECTED]

MySQL 3.23.33 released

2001-02-13 Thread Michael Widenius
Hi! This release mainly fixes some bugs in replication. If you are not using replication you probably don't have any reasons to upgrade. Changes in release 3.23.33 -- * Added `--character-sets-dir' to `myisampack'. * Removed warnings when running `REPAIR TABLE

Re: special characters messing me up

2001-02-13 Thread Irmund Thum
Rolf Hopkins schrieb: > > "^M"??? You sure it is that? Anyway, it is most likely to do with carriage > returns. Windows uses CR and LF to indicate a new line, while Linux and > Macs only use LF. Hopefully this will help. Don't know what you can do > about it though. > > - Original Messa

How to get Query Execution Time

2001-02-13 Thread Mathew Joseph
hi there, at the mysql prompt i can get the exact time taken to run each query. how can i display this time in an HTML page via PHP. is there a function which gives me this time bye Mathew - Before posting, please check:

Re: Shell Shocking

2001-02-13 Thread clay bond
On Tue, 13 Feb 2001, Donald Korth wrote: > The hosting company has given me a user name and passwd . When i log into my own >site thro' a telnet session i 'm able to view all the databases created in the server >that includes DBs not created by me . I also did a "USE DB" command to connect t

Re: Access 2000 and MySQL

2001-02-13 Thread Miguel Angel Solórzano
At 15:12 12/02/2001 -0500, WJ McEachran wrote: Hi! MySQL doesn't support Windows clustered servers because besides the transaction feature is necessary the development of the resource manager to have the fail over. Regards, Miguel >I've just been exposed to Access 2000 :-( >I'd be interested in a

Re: MS Access - This Recordset is not updateable

2001-02-13 Thread Miguel Angel Solórzano
At 10:34 12/02/2001 -0700, John Halladay wrote: Hi! Generally your problem happened when you did the linking of the MySQL table, Access didn't find a primary key column and you didn't select any. If the above is right, add a primary key column and link the table again. Regards, Miguel >I've scan

What Does This Mean?

2001-02-13 Thread Ben Ocean
Hi; I'm getting this error: >>> Unsatisfied dependencies for mod-php3-mysql-3.0.8-2: mod-php3 >= 3.0.8 <<< What does it mean and what should I do about it (if anything)? TIA, BenO - Before posting, please check: http://www.m

Re: [PHP] What Does This Mean?

2001-02-13 Thread Ankur Verma
I am not very sure of what exactly does this this mean but I guess that the particular module that you are installing requires a cversion of PHP that has to be greater than 3.0.8. This is just a guess. I aplogize if it's wrong. regards Ankur Verma HCL Technologies A1CD, Sec -16 Noida, UP India

WinNT max_connections

2001-02-13 Thread Ron Schmalz
Hello, I'm using MySQL Version 3.22.34 on WinNT (it's still shareware) in combination with MyODBC. And now I received the following message from another program using this database: "SQL-State: S1000 [TCX][MyODBC] Too many connections" Therefore I read the manual and found out, that I have to

Re: Win2000 cluster and MySQL

2001-02-13 Thread Miguel Angel Solórzano
At 12:42 12/02/2001 +0100, Thierry Coopman wrote: Hi! Hi! MySQL doesn't support Windows clustered servers because besides the transaction feature is necessary the development of the resource manager to have the fail over. Regards, Miguel >Hi, > >A collegue of me is asking if it is possible to u

Re: how to add to a set

2001-02-13 Thread Bob Hall
>OK, is there an easy way to ADD a value to a set type without having >to enumerate all that's there already? I've looked through >http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SET > >but it doesn't say anything about adding values to the current set. >It rather looks l

Re: nested sets vs. key path method

2001-02-13 Thread Bob Hall
>Hello, >at the time I try to figure out what's the best way >to get a kind of parent/child - hierarchy with unlimited >subchild. >My special attention is situated on really fast SELECT statements. > >Actually I'm using nested sets like: > >CREATE TABLE Personnel >(emp CHAR(10) PRIMARY KEY, >salar

Re: SELECT DISTINCT question

2001-02-13 Thread Bob Hall
>Say I have a bunch of records in a table with a bunch of fields. One of >those fields is cluster_id. It is not unique. However, I want to make a >unique set. I want one record for each cluster_id value. I don't care >which record that is. > >Right now, I do: >SELECT DISTINCT cluster_id FROM my_ta

Re: special characters messing me up

2001-02-13 Thread clay bond
On Tue, 13 Feb 2001, Irmund Thum wrote: > Rolf Hopkins schrieb: > > > > "^M"??? You sure it is that? Anyway, it is most likely to do with carriage > > returns. Windows uses CR and LF to indicate a new line, while Linux and > > Macs only use LF. Hopefully this will help. Don't know what yo

Dynamic Replication

2001-02-13 Thread Simon Green
Hi All I am going to have replication on mySQL database. I am just starting to write a script to see if the slave can connect to the master. If not then do one last check to see if the master is down by trying to connect to it. Then connect to slave set slave as master. When that is sorted do some

RE: nested sets vs. key path method

2001-02-13 Thread Jon Haworth
Bob, you may sound like a broken record, but at least it's stuck on a particularly delightful song that I think everyone should listen to. If everyone on this list had this book we'd see a 50% reduction in traffic overnight :-) Cheers Jon -Original Message- From: Bob Hall [mailto:[EMAI

Re: special characters messing me up

2001-02-13 Thread tlr7425
can you please stop sending attachments through the list? At 11:24 AM +0100 2/13/01, Irmund Thum wrote: >Rolf Hopkins schrieb: >> >> "^M"??? You sure it is that? Anyway, it is most likely to do with carriage >> returns. Windows uses CR and LF to indicate a new line, while Linux and >> Macs

Caching Bug with AUTO_INCREMENT columns

2001-02-13 Thread christoph . schemainda
From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Caching Bug with AUTO_INCREMENT columns Description: When i use a table with an AUTO_INCREMENT column and insert Data in the Table with a NULL Value for the AUTO_INCREMENT column, AUTO_INCREMENT sets an new value

Re: UDF - string problem

2001-02-13 Thread Sinisa Milivojevic
Thomas Kaester writes: > Hello Sinisa and everybody who can help me! > > I try to develop a UDF which returns a string! But I get only 256 characters of the >string! I tried to change my alloc function, so that I only use my_malloc and >my_free! But the result is the same! The necessary me

ASP and MySQL

2001-02-13 Thread Matt Davis
I have MySQL running on a cobalt Raq 3 with linux operating system. I have set up MyODBC and I can connect through MS Access I can also connect through MS Frontpage and created a simple web interface to retrieve some results from my db however when uploaded I recieve no results when I definatly sh

Re: Virus Alert - For Your Info.

2001-02-13 Thread Andy Woolley
Guys, I know it's off topic but this virus seems to be spreading quite violently, I've had to remove from one of our clients machines this morning. If you become infected with it, it's a simple remove procedure. 1. Remove the reference to OnTheFly in the registry, look for the text VBS and WORM

Re: Update: Status of MySQL 4.0/Innobase/transactions & row level locks

2001-02-13 Thread Heikki Tuuri
>> [...]. Currently, in MySQL >> you must call UNLOCK TABLES before issuing another LOCK TABLES, because >> there is no deadlock detection in MySQL itself. >I believe a LOCK TABLES does an automatic atomic UNLOCK TABLES of any >that were locked before if it's able to get the requested locks. >Ti

Re: How to get Query Execution Time

2001-02-13 Thread Basil Hussain
Hi, > at the mysql prompt i can get the exact time taken to run each query. > how can i display this time in an HTML page via PHP. is there a function > which gives me this time Unfortunately, no, there isn't a built-in function to do this. So, you'll have to resort to some DIY. But, it's quite

problem with configure Mysql-3.23.32 on INTEL/SOLARIS8

2001-02-13 Thread Remy . Mary
I try to install Mysql-3.23.32 on INTEL/SOLARIS8 the command ./configure --prefix=/usr/local/mysql returns following error : checking if gcc supports -c -o file.o... yes checking if gcc supports -c -o file.lo... yes checking if gcc supports -fno-rtti -fno-exceptions ... yes

Re: Shell Shocking

2001-02-13 Thread Mikel King
Problem is that most ISPs can't afford a competent DBA...;( clay bond wrote: > On Tue, 13 Feb 2001, Donald Korth wrote: > > > The hosting company has given me a user name and passwd . When i log into my own >site thro' a telnet session i 'm able to view all the databases created in the server

Re: Shell Shocking

2001-02-13 Thread Mikel King
Absolutely this is nothing short of bad adminingIbet you could scag in their passwd file and has root access in short order...;( And of course the ISP will blame mysql if anything happens to them though...lazy bad ISP cheers, mikel Donald Korth wrote: > Hello > > The hosting company

Re: Caching Bug with AUTO_INCREMENT columns

2001-02-13 Thread Peter Skipworth
While the output you've shown could well be considered eroneous, surely you shouldn't be relying on this sort of logic in a decent piece of code ? Or am I missing something ? If you're trying to work out which row was inserted most recently, shouldn't you be using your db handle lastinsert_id pa

Re: special characters messing me up

2001-02-13 Thread Pat Sherrill
When ftp'ing the file use the ASCII mode instead of the BINARY mode. All CR/LF conversions will take place automagically. Alternatively some linux distributions have a utility to strip CR's from ASCII files and there is always old reliable vi . I hope this helps... Pat... [EMAIL PROTECTED] ---

Re: special characters messing me up

2001-02-13 Thread G. Adam Stanislav
At 23:04 12-02-2001 -0800, John W Ford wrote: >I can't figure out why my windows machine leaves "^M" character at the end >of each line of code. This causes the file to be messed up when I put it on >the Linux server. That's a carriage return. DOS/Windows ends a line with a carriage return follow

Re: Shell Shocking

2001-02-13 Thread Rolf Hopkins
What you have just described means that database permissions have not been set up correctly and your ISP has left himself wide open for all kinds of attacks and I'm not just talking about attacks on the database itself but also attacks on the whole system. Ie access to unix root. DOS, etc Read t

Exporting data from MySQL to Oracle

2001-02-13 Thread Noor Dawod
Hello, I'm having a problem exporting MySQL BLOB's to Oracle, especially those records that has "Carriage Return" or "Line Feed" characters in them. Has anyone done this before, and how did they do it? I need an immediate help in this subject. I'd appreciate you help very much. Thanks Noor -

Re: special characters messing me up

2001-02-13 Thread Peter Skipworth
Or a handy one-liner... perl -pi -e "s/[\012\015]//" *.sql On Tue, 13 Feb 2001, Pat Sherrill wrote: > When ftp'ing the file use the ASCII mode instead of the BINARY mode. All > CR/LF conversions will take place automagically. Alternatively some linux > distributions have a utility to strip C

TEXT's are giving us headaches!

2001-02-13 Thread Noor Dawod
Hello, We operate a forums website and use Phorum web application (PHP/MySQL backend), more info: http://www.phorum.org After operating for two years now, we are facing a serious problem. Giving the fact that the forums are full of content, ONE (1) search operation on a single forum is draining

Cannot load connection class 'java.sql.SQLException ????

2001-02-13 Thread Daniel Ducat
Hello everyone Does anyone know why and when occurs the following error : Cannot load connection class 'java.sql.SQLException Thanks a lot ! Daniel Ducat - Before posting, please check: http://www.mysql.com/manual.php (th

mySQL/php query help

2001-02-13 Thread Stinsman, Scott
can anyone figure out why the following code works fine when both select variables = "ALL" and also when only 1 of the 2 ="ALL" but NOT when BOTH select variables equal something other than "ALL"? here is the code: What area of the city would you like to dine in? \n"; $select.="ALL\n"; w

Suggested feature

2001-02-13 Thread Alex Povolotsky
Hello! I think that one feature will be useful: limits (like UNIX limit feature) on per-thread basis. On public-access site (for instance, free hosting with mysql) poorly-written SQL can make quite a load; limiting usage can forcedly kill such requests. I could not subscribe to developers list

Here you have, ;o)

2001-02-13 Thread Mike Hammonds
Hi: Check This! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-ma

Here you have, ;o)

2001-02-13 Thread Mike Hammonds
Hi: Check This! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-ma

Re: Shell Shocking

2001-02-13 Thread Van
Rolf Hopkins wrote: > > What you have just described means that database permissions have not been > set up correctly and your ISP has left himself wide open for all kinds of > attacks and I'm not just talking about attacks on the database itself but > also attacks on the whole system. Ie access

RE: Exporting data from MySQL to Oracle

2001-02-13 Thread Cal Evans
Didn't Oracle just release a MySQL to Oracle migration kit? Check the Oracle website. Cal http://www.calevans.com -Original Message- From: Noor Dawod [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 13, 2001 8:41 AM To: MySQL List Subject: Exporting data from MySQL to Oracle Hello,

Fw: Duplicate entry error -THANKS!

2001-02-13 Thread Paul Wilkinson
THANK_YOU! I was modifying entries for a joiner table without checking to see tif they were already present! > Subject: RE: Duplicate entry error?? > > > > Hi, > > > > You have a unique key defined which includes Ekey and another field (the > key > > 2 mentioned in the error message), and the

RE: ASP and MySQL

2001-02-13 Thread Jacques Venter
Hi Matt, Think you will find: http://www.scibit.com/MySQL useful > -Original Message- > From: Matt Davis [mailto:[EMAIL PROTECTED]] > Sent: 13 February 2001 14:47 > To: [EMAIL PROTECTED] > Subject: ASP and MySQL > > > I have MySQL running on a cobalt Raq 3 with linux operating system. I

Re: mysqlimport - LOAD DATA LOCAL INFILE

2001-02-13 Thread Rus
I suppose that only way to reorganize unique field is to use another table. - Original Message - From: Irmund Thum <[EMAIL PROTECTED]> To: Rus <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, February 13, 2001 8:53 AM Subject: Re: mysqlimport - LOAD DATA LOCAL INFILE > Rus sc

Re: TEXT's are giving us headaches!

2001-02-13 Thread Jason Terry
A mistake I made for a long time with MATCH AGAINST is to not include it in the WHERE clause eg I did SELECT ID,MATCH Q,A AGAINST ("This") AS Score FROM faq instead of SELECT ID,MATCH Q,A AGAINST ("This") AS Score FROM faq WHERE MATCH Q,A AGAINST ("This") The latter will give much better perfo

RE: TEXT's are giving us headaches!

2001-02-13 Thread Noor Dawod
Hi Hmm, this seems to me like redundant code.. if you're holding info in Score, and not using it but only using the same operation that was used to create it, then it's a redundant code.. Are you sure the second form works faster than the first one? Noor -Original Message- From: Jason

RE: Exporting data from MySQL to Oracle

2001-02-13 Thread Noor Dawod
I couldn't find such product on Oracle's website. Noor -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 13, 2001 5:51 PM To: Noor Dawod; MySQL List Subject: RE: Exporting data from MySQL to Oracle Didn't Oracle just release a MySQL to Oracle migrati

Re: TEXT's are giving us headaches!

2001-02-13 Thread Jason Terry
>From what someone on this (can't remember who or I would give credit) list told me, >It ONLY uses the index if you have it in the WHE RE clause... and apparently the SQL optimizer catches that the MATCH AGAINST is the same in both places and only runs it once... - Original Message - Fr

RE: Here you have, ;o)

2001-02-13 Thread Jon Haworth
Oh no, not another one -Original Message- From: Mike Hammonds [mailto:[EMAIL PROTECTED]] Sent: 12 February 2001 18:30 To: [EMAIL PROTECTED] Subject: Here you have, ;o) Hi: Check This! - Before posting, please ch

/tmp/mysql.sock disappearing?

2001-02-13 Thread Brian Reichert
I couldn't fine this mentioned in the archives, so I hope someone has seen this before: I'm running into a situation wherein /tmp/mysql.sock keeps disspearing. There is still server process (sleeping), and there is still a pidfile. This can happen after ten or fifteen minutes of queries. I don

Re: special characters messing me up

2001-02-13 Thread John Jensen
"M" is the thirteenth letter of the alphabet. ASCII 13 (^M) is the carriage return. If you are using binary transfer on ftp, then you will get these and any other control characters imbedded in your file. Set your ftp to ASCII and try again. Perl is particulary sensitive to this. HTML doesn't

Bug in .32: inconsistent truncation of decimal places

2001-02-13 Thread Pete Harlan
Hi, The two selects in this script: drop table if exists foo; create table foo (id int not null); insert into foo (id) values (0), (1); drop table if exists joiner; create table joiner (joinerid int not null); insert into joiner (joinerid) values

Re: special characters messing me up

2001-02-13 Thread Thalis A. Kalfigopoulos
On Tue, 13 Feb 2001, Peter Skipworth wrote: > Or a handy one-liner... > > perl -pi -e "s/[\012\015]//" *.sql > > Or alternatively edit the file with vi and do: :s/ // This inteprets to the following keystrokes: ':' colon 's' s for substitute ' ' Ctrl-v-m to create the annoying ^M

Re: special characters messing me up

2001-02-13 Thread Peter Lewis
On Tue, 13 Feb 2001, Irmund Thum wrote: > Rolf Hopkins schrieb: > > > > "^M"??? The ^M is the carriage return/line feed usually found in ms/dos text files. On my Linux system (on downloaded files) I removed them by tr -d \r old file > new file. tr = text replace; -d delete; \r = ^M see 'info

Re: MySQL 3.23.33 released

2001-02-13 Thread Christian Hammers
Michael, it would be very nice if you would mark security related bugs so that admins who are not subscribed on Bugtraq see them, too. This is at least the second time where I got information about security bugs in MySQL *only* via 3rd party and not from the web page nor from the changelog. Disa

Re: special characters messing me up

2001-02-13 Thread Thalis A. Kalfigopoulos
> > Or a handy one-liner... > > > > perl -pi -e "s/[\012\015]//" *.sql > > > > > > Or alternatively edit the file with vi and do: > :s/// > > This inteprets to the following keystrokes: > ':' colon > 's' s for substitute > ''Ctrl-v-m to create the annoying ^M as one character > '//'

Re: Password routine

2001-02-13 Thread Fred van Engen
On Tue, Feb 13, 2001 at 11:45:55AM +0700, Andrea wrote: > Hi all > > I am interesting on password routine in mysql > > Could some body help about this routine ? > > I download the source code of MySql, but i am not yet found about this > routine > Are you looking for the following code from s

RE: special characters messing me up

2001-02-13 Thread mike thomas
Try this, The code below will remove the last character from each record in your file. On your Linux system enter this line on the command line and the results will appear in the NEW_FILE. Obviously you can name the input and output files anything you want. awk '{print substr($0, 1, length-1)}'

RE: special characters messing me up

2001-02-13 Thread mike thomas
John Here is another solution to removing those '^M' chars. This is a lot simpler than my last idea :- sed 's/^M//g' YOUR_FILE > YOUR_NEW_FILE Michael Thomas www.abcXyz.com > - > Before posting, please check: >http://www.

changing the direction of searches via Select

2001-02-13 Thread Warren
Hi! I'd like very much to be able to walk backwards through a list of my records. How might I indicate that mysql ought to position itself at the highest record number and then all selects will go backwards (say with LIMIT 1) ? Thanks for your time! Cheers! -Warren -

Strange Replication Problem in 3.23.33 (bug?)

2001-02-13 Thread Matt Hahnfeld
I set up two MySQL servers to run in a failover configuration. Because queries will only ever be submitted to one server at a time, I decided to use a makeshift two-way replication scheme under MySQL as descibed in the MySQL manual. First server (wallace) has this: --

Re: /tmp/mysql.sock disappearing?

2001-02-13 Thread Fred van Engen
On Tue, Feb 13, 2001 at 11:50:28AM -0500, Brian Reichert wrote: > I couldn't fine this mentioned in the archives, so I hope someone has seen > this before: > > I'm running into a situation wherein /tmp/mysql.sock keeps disspearing. > > There is still server process (sleeping), and there is still

Re: Reading from merge table while updating underlying table

2001-02-13 Thread Fred van Engen
To add to this, I'm running 3.23.32 (on Solaris). I really like the concept of merge tables, but without the ability to insert new records in underlying tables, it's far less useful for my needs. Thanks. Fred. On Tue, Feb 13, 2001 at 12:44:25AM +0100, Fred van Engen wrote: > Hi, > > Is it oka

Answering my own question --- sorry for noise on the list

2001-02-13 Thread Warren
Hi! I just posted the following silly (in retrospect) question >I'd like very much to be able to walk backwards >through a list of my >records. How might I indicate >that mysql ought to position itself at the >highest record number and then all selects >will go backwards (say with LIMIT 1) ? I

RE: special characters messing me up

2001-02-13 Thread The Tilghman
mv file file~ ; tr -d '\015' file ; rm file~ Or, in vim, :set fileformat=unix Or, use PFE32.EXE on Windows as your editor (allows saving as Unix text file). -Tilghman -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger > -Original Message- > From

Re: Here you have, ;o)

2001-02-13 Thread Carsten Gehling
From: "Jon Haworth" <[EMAIL PROTECTED]> Sent: Tuesday, February 13, 2001 5:40 PM > Oh no, not another one Mike and James - you fell for the good ol' trick. Bu hu for you - don't you just "love" it? :-) Now whoever made the little bastard this time...? Funny thing actually: My Outlook Expre

RE: special characters messing me up

2001-02-13 Thread John W Ford
Thanks everybody for helping me out... I got the scripts loaded and am talking to mySQL via DBI now. > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of > G. Adam Stanislav > Sent: Tuesday, February 13, 2001 6:36 AM > To: John W Ford; Mysql > Subject: R

RE: changing the direction of searches via Select

2001-02-13 Thread Cal Evans
How do you define backwards? By what sort order? Cal http://www.calevans.com -Original Message- From: Warren [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 13, 2001 1:28 PM To: [EMAIL PROTECTED] Subject: changing the direction of searches via Select Hi! I'd like very much to be

Re: Answering my own question --- sorry for noise on the list

2001-02-13 Thread Irmund Thum
Warren schrieb: > > Hi! I just posted the following silly (in retrospect) question > $next=MYSQL_QUERY("select ref from questions where ref < $ref[0] ORDER BY > ref DESC LIMIT 1"); no reason to apologize - sometimes the best postings :- -- http://it97.dyn.dhs.org/ IrmundThum +49 179 699

Re: /tmp/mysql.sock disappearing?

2001-02-13 Thread Brian Reichert
On Tue, Feb 13, 2001 at 08:35:44PM +0100, Fred van Engen wrote: > I've seen it after installing two versions of MySQL on one server. > I forgot to set another location for the second MySQL process > before starting it with /bin/safe_mysqld. The result was that the > socket was removed by the secon

help please?

2001-02-13 Thread Crystal D. Silver
Hi, My host gives me a MySQL database, and I've had no trouble getting purchased cgi scripts to integrate with it...however, now I want to deleted everything (all tables within the database) and start from scratch...I've wasted a lot of space and have double-installed some things, etc. I don't s

mysql-3.22.4a-beta and RedHat 7.0 (compile problems)

2001-02-13 Thread Fulko Hew
I know I'm using a really old version of mysql (3.22.4a-beta) but upgrading means changing my application, and I'd rather avoid that right now. I'm trying to get it to build on RedHat 7.0 I have updated gcc to 2.96-69 When compiling sql/sql_yacc.cc The compiler appears to hang in pass 1. Aft

RE: Here you have, ;o)

2001-02-13 Thread Maciek Uhlig
Isn't it possible the virus itself was actually removed by the mailserver antivirus software? Can anybody confirm this just for we could feel more safe? My Outlook 2000 shows the message and the attachment, but the attachment is a text file with mailing list footer information - just like somethin

Transaction issues

2001-02-13 Thread Marc Soda
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello all, I am new to the list and need assistance. I noticed this thread in the archives, but I didn't see an answer. So, I'll ask it again. I have tried several times to use BerkeleyDB with MySQL to provide transaction support. It has failed

logging to a FIFO?

2001-02-13 Thread Brian Reichert
I _used_ to be able to log to a FIFO as recently as mysql-3.22.32, but now with mysql-3.23.33, I can't: 010213 17:03:11 Could not use /var/mysql/db/localhost.fifo for logging (error 29) where in /usr/include/sys/errno.h: #define ESPIPE 29 /* Illegal seek */ I'm gue

mysql@lists.mysql.com

2001-02-13 Thread Joseph Christian
>Description: Corrupted tables cause REPLACE to complain about Duplicate entries. Or maybe REPLACE gets confused and causes table corruption. It doesn't happen all of the time which is the frustrating part of this. >How-To-Repeat: DBD::mysql::db do failed: Duplicate entry '3098

Re: Here you have, ;o)

2001-02-13 Thread John Jensen
Try Pegasus Mail. It is a very well designed email client, without some of Outlook's bugs. It very versital, and it is also free. If you want to get the most out of it, you can buy the manual. I had forgotton how much in love with it I once was, until Outlook refused to behave as the help file

Transaction support in MySQL?

2001-02-13 Thread Eric Kwong
I'm wondering if MySQL supports transaction? Since I have an application to use MySQL JDBC to perform several insert statements and then do a rollback, all data saved to the database without rolling back. -Eric - Before posting

AW: Exporting data from MySQL to Oracle

2001-02-13 Thread Denis Mettler
Hi there, please check the oracle migration bench at the oracle technet. http://technet.oracle.com kind regards denis mettler -Urspr?ngliche Nachricht- Von: Noor Dawod [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 13. Februar 2001 17:23 An: Cal Evans; MySQL List Betreff: RE: Exportin

Re: external access to mysql

2001-02-13 Thread Atle Veka
Search for the information on grant tables on mysql.com. .. Atle On Mon, 12 Feb 2001, Mike Yuen wrote: > I and 2 others are working on a web site an occasionally. Each of us are > in different locations and exchange info email. Some of them > need to query the database to compare results wi

Re: Here you have, ;o)

2001-02-13 Thread B. van Ouwerkerk
>I had forgotton how much in love with it I once was, until Outlook >refused to behave as the help files said it would, and the help files >describe capabilities that were simply not available. I have moved to >Outlook, because I needed to access several email accounts, and the >older versions of

Re: Transaction support in MySQL?

2001-02-13 Thread tc lewis
http://www.mysql.com/documentation/mysql/bychapter/manual_Compatibility.html#Missing_Transactions http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html#BDB -tcl. On Tue, 13 Feb 2001, Eric Kwong wrote: > I'm wondering if MySQL supports transaction? > Since I have an appli

Re: help please?

2001-02-13 Thread clay bond
On Tue, 13 Feb 2001, Crystal D. Silver wrote: > in the documentation about how to just plain DELETE everything in the > database (i don't want to delete the installed database itself, just go back > down to where there's nothing in it, so I can start over)...could somebody > tell me what to do?

WISHLIST

2001-02-13 Thread Chris Moore
I would like to see some 'bash-like' abilities for an alias command and a .mysql file or something similar to store commonly used queries (to be accessed by a single keyword). I find myself writing extremely long queries from time to time and I have to store them in a text file and worry about co

Calculation of memory usage by indexes

2001-02-13 Thread pdewaha
Hi, I've got a question about the use of indexes. I've a site running quite good. I've such features like polls and all that usual stuff. I take the poll tables as example. POLLS: idpoll bigint unsigned not null auto_increment primary key,

Help please: getting the total from the results of SUM

2001-02-13 Thread jerome auza
Hi, Is it possible to get the total from the results of SUM in the same SQL statement? I want to have this output: NameAmount Percent Name1 15 25 Name2 15 25 Name3 30 50 My database only have the first two columns and the Percent column is calculated

Re: help please?

2001-02-13 Thread William R. Mussatto
drop table... On Tue, 13 Feb 2001, Crystal D. Silver wrote: > Date: Tue, 13 Feb 2001 14:01:48 -0800 > From: Crystal D. Silver <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: help please? > > Hi, > > My host gives me a MySQL database, and I've had no trouble getting purchased > cgi scri

Solaris compilations

2001-02-13 Thread Alan W. Rateliff, II
Apparently I jumped the gun today when I posted my last message about compiling on Solaris. I had inadvertantly extracted and compiled an older version of MySQL. Tonight I compiled the latest version, 3.23.33, and it does indeed fix all the shortcomings of the previous compiles with Solaris. No

Re: help please?

2001-02-13 Thread Mysql Mailing List
DELETE FROM tableName; Jiang - Original Message - From: "Crystal D. Silver" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 13, 2001 3:01 PM Subject: help please? > Hi, > > My host gives me a MySQL database, and I've had no trouble getting purchased > cgi scripts to

Re: /tmp/mysql.sock disappearing?

2001-02-13 Thread Rolf Hopkins
Do you have a cron job that's cleaning up your socket file along with whatever other garbage it's cleaning up? - Original Message - From: "Brian Reichert" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 14, 2001 4:42 Subject: Re: /tmp/mysql.sock disappearing? > On

Re: help please?

2001-02-13 Thread Brady Orand
Won't a "Drop TABLE" work? Brady... Original Message Follows From: "Crystal D. Silver" <[EMAIL PROTECTED]> Reply-To: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Subject: help please? Date: Tue, 13 Feb 2001 14:01:48 -0800 Hi, My host gives me a MySQL database, and I've had no trouble

Re: mySQL/php query help

2001-02-13 Thread Rolf Hopkins
I can't see anything wrong with your code? What exactly is the problem? Aren't the values, from the select statement printing out on your web page or something? Are you sure you provided the right code? - Original Message - From: "Stinsman, Scott" <[EMAIL PROTECTED]> To: <[EMAIL PROTECT

Bugs

2001-02-13 Thread Jonathan Berall
Hi, Attached is a bug and a question. Regards, Jonathan user id: jberall4691 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ SELECT t.trans_id, t.trans_no, DATE_FORMAT(t.tra

Transaction Issues

2001-02-13 Thread Phil Daintree
The documentation puts me off going with BDB tables - since there is a big performance hit. There is a fair bit in the manual as to the preferred approach under MySQL ie atomic updates. At the moment for MyISAM tables - the fast ones I understand - it seems that all we have to play with is Lock

installing mysql 3.23.33 rpm on RH7

2001-02-13 Thread csyap
Hi, I'm trying to install the lastest version of mysql 3.23.33 rpm (downloaded from mysql.com) on RH7 using the command "rpm -Uvh MySQL*" but encountered "failed dependencies error" as shown below: error: failed dependencies: MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.33-1 mysql = 3.23.2

Re: installing mysql 3.23.33 rpm on RH7

2001-02-13 Thread Rolf Hopkins
"They're bccckkk!!!" Try installing, using the skip dependency check flag. - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 14, 2001 11:13 Subject: installing mysql 3.23.33 rpm on RH7 > Hi, > > I'm trying to install the lastest versio

Re: installing mysql 3.23.33 rpm on RH7

2001-02-13 Thread Thiru
I had the same problem just yesterday. -> MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.33-1 benchmark uses Perls DBI modules, so U have to install them before installing MySQL-bench. Unless U R going to perform benchmarking U need not install MySQL-bench modules. -> mysql = 3.23.22 is ne

Re: jsp

2001-02-13 Thread s chitra
Hi sara, Try with: Connection myConn = DriverManager.getConnection("jdbc:mysql://localhost/test_db1,"user","passwor d"); I can able to understand that you want to use mysql database using Jsp. regards, S.Chitra

  1   2   >