utf8 support

MySql 4.1 should have utf8 charset support, I downloaded the alpha version but don't seem to have the utf8.xml file comes with it. Any one know how to get the needed charset support files? Thanks John

Re: Search?

Pieter, If you use LIKE '%abc%' then this will match 'abc' 'abcs' 'ABC' 'DABCE' 'DABC' and 'ABCD'. It will not match 'AB'. In your case it may work better if you validate the words before you run your SELECT statement or make your fields more specific. For example, instead of a field called descr

Re: how to show all locks on a table?

At 10:33 AM 8/21/2003 -0700, Bennett Haselton wrote: [already posted to mailing.database.mysql newsgroup but not to list; sorry for cross-post] I found a way to do this before, but I didn't write down how I did it, so I don't remember it now. And I've searched http://www.mysql.com/doc/ in vain

linked db

Hi, is it possible to link databases within mysql? I have a access database that I need to import into mysql this db consists of 4 other dbs linked together sharing a common switchboard. Can I link the tables in one db to tables in another db? thanks Bob

Re: Named pipe vs TCP/IP speed

- Original Message - From: "Jakob Dölling" > Hi: > > > This surprised me! I have been connecting with named pipes (and telling > > others to do the same) on Win2k since I discovered them, because my queries > > (and time to connect) are most definitely *faster*. The client/server > > commu

Re: MySQL running out of date

Fred van Engen wrote: > SELECT 2147483648*2147483648*4 returns 0. > SELECT 2147483648*2147483648*2 returns -9223372036854775808. > SELECT 2147483648*2147483648*2-1 returns 9223372036854775807. > > The same problem in most programming languages. What do other DBMS do > and what do the SQL stand

Re: MyODBC 3.51 + Windows Server 2000 = Memory Leak

We're running MyODBC 3.51 on Windows 2000 Ssrver with IIS5 and ColdFusion 5 applications and don't see any memory leaks. In a very hight traffic application, you'll want to keep connections open as long as possible anyway. There's also a MyODBC list that you might try. - Original Message --

MyODBC 3.51 + Windows Server 2000 = Memory Leak

We have a very high traffic mysql app running in ASP on Windows 2000. It connects to a Linux mysql server (4.0.12) via ADODB and MyODBC. It's leaking memory like crazy. We've implemented connection pooling and long timeouts on connections so as to minimize the number of connects & closes, but

Re: My SQL Search

I am searching for a specific company name that gets passed to this page. I tried adding the mysql statement: SELECT product_id, company_name, product_name, url, description FROM product, company WHERE product.product_id = company.company_id AND description LIKE '%FORM.query%' AND company_name L

innodb doc in mysql.com

In mysql.com site on section 7.5.4.1 it says and I qoute "If something goes wrong in an InnoDB database creation, you should delete all files created by InnoDB. This means all datafiles, all log files, the small archived log file, and in the case you already did create some InnoDB tables, delete a

Re: Mast-Master Replication

Hi, I wish I could use that more, but load data from master locks everything all at once, then you have to wait for the transfer, making it not a great idea to use on a busy live/big database. I can do a back up localy and then transfer the data with a lot less locked time. Still, the times I have

Re: [OT] Autoresponders (is Re: Spam from this list)

I've been getting autoresponders from [EMAIL PROTECTED] [EMAIL PROTECTED] ("The Oracle") [EMAIL PROTECTED] On Saturday, August 23, 2003, at 12:41 PM, Joe Baptista wrote: BTW, did anyone around here get mail from CServe containing important email addresses such as support? I got from them these

Fwd: differance between InnoDB and MyISAM tables ?

For example, does 'delayed' work with 'insert' and 'replace' like it does for ISAM and MyISAM tables? Creigh X-MindSpring-Loop: [EMAIL PROTECTED] Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm List-ID: List-Help: List-Unsubscribe: L

Re: [OT] Autoresponders (is Re: Spam from this list)

On Sat, 23 Aug 2003, Jakob [iso-8859-1] Dölling wrote: > BTW, did anyone around here get mail from CServe containing important email > addresses such as support? I got from them these mails twice to three times > or so. Just wondering... i've been getting email from something called the oracle.

Re: help installing DBI modules

On Sat, Aug 23, 2003 at 10:42:45AM -0400, March, Kristopher (Contractor) (DSCR) wrote: > I'm trying to install DBI perl modules on a SUN 8 box. > > I can't seem to find a make utilitity for building the components. Is it > called something else or will I have to go out and install it? Is /usr/u

UPDATE based on value in another table

How do I update a table to remove orphaned references to a second table? I've deleted rows in the second table, which has a unique auto_increment key. The first table now has references to keys that no longer exist. I need to update the first table, setting the value to NULL where the referenced

Re: Named pipe vs TCP/IP speed

Hi: > This surprised me! I have been connecting with named pipes (and telling > others to do the same) on Win2k since I discovered them, because my queries > (and time to connect) are most definitely *faster*. The client/server > communication is about 25-30% slower using TCP/IP. Example: a simpl

[OT] Autoresponders (is Re: Spam from this list)

Joe Baptista wrote: > Now you have good reason to complain - because thats not right. An > autoresponder should only send out email once per email address. Repeated > sends is the sign of some twit not knowing how to operate an > autoresponder. Yea - and very well set up autoresponders should m

Re: MySQL running out of date

On Sat, Aug 23, 2003 at 02:07:36PM +0200, Hans van Harten wrote: > Fred van Engen wrote: > > On Sat, Aug 23, 2003 at 10:54:32AM +0200, Hans van Harten wrote: > >> My checks might not match those of (the next version of) MySQL and > >> at that time the difference in thoughts will pass unnoticed ! >

help installing DBI modules

I'm trying to install DBI perl modules on a SUN 8 box. I can't seem to find a make utilitity for building the components. Is it called something else or will I have to go out and install it?

ERROR: 1130 Need help changing privileges

Hi all, I need help changing host privileges in mySQL server. I am trying to access mySQL server from a remote computer that doesn't have access rights. The online doc sucks; I can't get anything useful out of it. A step-by-step instruction on how to change it would be greatly appreciated.

Re: Spam from this list

On Sat, 23 Aug 2003, Thomas Andersson wrote: > Marc Storck wrote: > > > Strange, I never get those!! > > I've gotten 3 after 3 posts so far, bet I'll soon get my 4:th... > > Best Wishes > Thomas Now you have good reason to complain - because thats not right. An autoresponder should only send ou

Re: Spam from this list

you should not bother the list with this nonsense - your concept of spam is another persons concept of managing information. Just send them an email to block autoreponder messages to this lists participants. If they can;'t comply then complain to the list manager. And this by definition is not

ITS NOT SPAM - IT"S AN AUTORESPONDER - WAS Re: Re: Spam from this list (fwd)

This is not spam - it's an autoreponder - so lets not get to excited here. Joe Baptista - only at www.baptista.god "Who is this dog Franks in Qatar?" ... Muhammed Saeed al-Sahaf former Iraqi Information Minister -- Forwarded message -- Date: 23 Aug 2003 09:37:30 EDT From: Telem

Re: tellme Timestamp

On Fri, 22 Aug 2003 17:14:38 -0500 "Dan J. Rychlik" <[EMAIL PROTECTED]> wrote: > Hello All, > > I am trying to find out how I can change my timestamp(14) to timestamp(8). use DATE fields instead. or use DATE_FORMAT() with TIMESTAMP to get only date. --- WBR, Antony Dovgal aka tony2001 [EMA

Re: Spam from this list

Marc Storck wrote: > Strange, I never get those!! I've gotten 3 after 3 posts so far, bet I'll soon get my 4:th... Best Wishes Thomas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: My SQL Search

On Fri, 22 Aug 2003 23:28:18 + "Nathan Simms" <[EMAIL PROTECTED]> wrote: > Hi, I'm currently using the following mysql statement to perform a search. > Right now it is only returning the results which are found in the > description field. How do I modify this statement so that it is searching

Re: Spam from this list

Hi Thomas, I report this stuff always to [EMAIL PROTECTED] and 20 minutes later its gone ;-) Best regards Nils Valentin Tokyo/Japan 2003年 8月 23日 土曜日 22:25、Thomas Andersson さんは書きました: > Hmm > > This is not nice.. I posted on this list, and within seconds I got spam > from some phone company wh

Re: Spam from this list

one doesn't even need to be subscribed to a list to get all the mail addresses. since all mails are archived and accessible from the web, a simple mail spider is sufficient. for this reason, i never use my private mail address for public postings of this kind. and as soon as i have my own mail s

Re: Spam from this list

Strange, I never get those!! Marc - Original Message - From: "Thomas Andersson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, August 23, 2003 3:41 PM Subject: Re: Spam from this list > Joe Baptista wrote: > > > are you getting spam or an autoresponder. i rarely post to t

Re: Spam from this list

Joe Baptista wrote: > are you getting spam or an autoresponder. i rarely post to this list > so > lets see what happens. Both, when I get a 'requested' salespitch I call it spam, no matter if it was auto or not. Seems I get it for every mail I post here. Best Wishes Thomas -- MySQL General

Re: Spam from this list

are you getting spam or an autoresponder. i rarely post to this list so lets see what happens. Joe Baptista - only at www.baptista.god "Whenever we attack, they retreat. When we pound them with missiles and heavy artillery, they retreat even deeper. But when we stopped pounding, they pushed to

Spam from this list

Hmm This is not nice.. I posted on this list, and within seconds I got spam from some phone company which was a reply to my post to the list. Aparently a company is subscribed and use posts here to build a list of valid addresses to spam... The offending mailer was: [EMAIL PROTECTED] -- MySQL

Upgrading 3.23->4.0 under WinXP ?

Hi! I'm pretty green at this and I'm a bit clueless here, After reinstalling my system I upgraded from 3.23 to 4.0 of MySQL, then I moved my old dbs in there and most seems to work OK. Now PHPMyAdmin tells me my userbase is out of date and that I need to run mysql_fix_privilege_tables... HOW do I

Re: MySQL running out of date

Fred van Engen wrote: > On Sat, Aug 23, 2003 at 10:54:32AM +0200, Hans van Harten wrote: >> My checks might not match those of (the next version of) MySQL and >> at that time the difference in thoughts will pass unnoticed ! > I agree that MySQL should complain but I'm not sure it should fail. > The

Re: MySQL running out of date

On Sat, Aug 23, 2003 at 10:54:32AM +0200, Hans van Harten wrote: > Fred van Engen wrote: > > On Fri, Aug 22, 2003 at 01:16:48AM -0500, Hans van Harten wrote: > >> that comes with neither warnings nor errors reported ... > > Error reports would have been nice, but why does your application > > suppl

Re: Fw: Replication

Sam, On Fri, Aug 22, 2003 at 08:37:33PM -0400, sam [EMAIL PROTECTED] wrote: > So, you are saying that the fact that replication is > not working when we re-connect is not a bug. > > Replication is all about passing data from one node > (a master) to the next (the slave). I do not know what > it

Re: MySQL running out of date

Fred van Engen wrote: > On Fri, Aug 22, 2003 at 01:16:48AM -0500, Hans van Harten wrote: >> that comes with neither warnings nor errors reported ... > Error reports would have been nice, but why does your application > supply these incorrect dates anyway? Probably because some user typed > them. An

Re: MySQL running out of date

Rajesh Kumar wrote: > Hans van Harten unknowingly asked us: > >> create database data_test ; >> use data_test; >> create table test3 (a date); >> insert into test3 values ( >> from_unixtime(unix_timestamp('2002-102-31'),'%Y-%m-%d' )); >> insert into test3 values ( >> from_unixt

Re: MySQL running out of date

On Fri, Aug 22, 2003 at 01:16:48AM -0500, Hans van Harten wrote: > Rajesh Kumar wrote: > > Peter Brawley unknowingly asked us: > >>> Interestingly, use of date_add() and date_sub() on 'odd' dates such > >>> as "Feb 31" does produce sane results. > >>> Subtract one from "2000 Feb 31", and you'll get

can't start mysqld

Hello I have installed mysql on my Linux redhat 7.2 System. when I try to lauch the mysqld ,the message is [ok] but when i launch service mysql status, i got the folowwing :"mysql is dead but subsys is locked" and I can't connect to my database Can you help me please Think you

Re: innodb use outside of explicit transactions

On Sat, 23 Aug 2003, Heikki Tuuri wrote: > Marc, > > - Original Message - > From: "Marc Slemko" <[EMAIL PROTECTED]> > Newsgroups: mailing.database.mysql > Sent: Saturday, August 23, 2003 7:19 AM > Subject: innodb use outside of explicit transactions > > > > Suppose I have an innodb table i

Re: innodb and fragmentation

Jeff, - Original Message - From: "Jeff Mathis" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Saturday, August 23, 2003 12:20 AM Subject: Re: innodb and fragmentation > does shutting down the database server and restarting it have the same > effect? no. We were talking ab

Re: innodb use outside of explicit transactions

Marc, - Original Message - From: "Marc Slemko" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Saturday, August 23, 2003 7:19 AM Subject: innodb use outside of explicit transactions > Suppose I have an innodb table in 4.0.14 and do: > > LOCK TABLE maggie > INSERT INTO maggi