Re: Newbie: Replication Question

Very good, gmail does not handle mailing lists properly.. Sorry for sending this off-list to you, Alec. On Fri, 9 Jul 2004 17:09:45 -0300, João Paulo Vasconcellos [EMAIL PROTECTED] wrote: On Fri, 9 Jul 2004 10:44:42 +0100, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: L. Yeung [EMAIL

Server tuning

in the manual (if so, my apologies, but I could not find). TIA, -- João Paulo Vasconcellos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL and Filesystems

Hello everybody, someone can tell me the best FS to run MyISAM along with InnoDB tables ? SQL - For you-know-who -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 21 3852-9008 Ramal 31 [EMAIL PROTECTED

Re: email address authentification .....

unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 21 3852-9008 Ramal 31 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php

Re: Obvious mistake in query?

this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 21 3852-9008 Ramal 31 [EMAIL PROTECTED

Re: Mysql SELECT IF()

/unsubscribe.php -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 21 3852-9008 Ramal 31 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: ROOT Access Denied !!

-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 21 3852-9008 Ramal 31 [EMAIL PROTECTED] - Before posting, please check

Re: faster update

-errstr; while (A){ print $_\n; $sth-execute($_) || die Error2 executing update statement on track:\n . $sth-errstr; } close A; -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 21 3852-9008 Ramal 31 [EMAIL PROTECTED

Re: INSERT IF NOT EXISTS?

whish-list : ) Yes: INSERT IGNORE INTO ... You can read more at http://www.mysql.com/doc/I/N/INSERT.html -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 21 3852-9008 Ramal 31 [EMAIL PROTECTED] - Before posting

The silence...

Wow, what happened today ? Never saw that list so quiet. SQL. -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 21 3852-9008 Ramal 31 [EMAIL PROTECTED] - Before posting, please check: http

Re: Stupid - I just can't get it (NOT IN or NOT EXISTS)

with an error 1064: SQL syntax near '(SELECT msoccerroster.SID FROM msoccerroster)' please help J -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 21 3852-9008 Ramal 31 [EMAIL PROTECTED] - Before posting, please check

(Maybe) Silly question

, but I am not sure if the DATE part will be the same after the change. Anybody here did this before ? [ Hello filter, I can speak SQL :) ] -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 21 3852-9008 Ramal 31 [EMAIL PROTECTED

Re: (Maybe) Silly question

Message- From: João Paulo Vasconcellos [mailto:[EMAIL PROTECTED]] Sent: Friday, May 03, 2002 1:43 PM To: [EMAIL PROTECTED] Subject: (Maybe) Silly question Hello everybody, i was thinking about my database, and I found that the guy who planned it before me created a field to hold

What is `Aborted Clients` ?

Hello Everybody, can anyone explain me what is an Aborted Client ? I begin to wonder about this because this number was about 20 or 30 last week, and now suddenly it got above 200 ! I have no idea of what it means, so any help would be appreciated. Filter : sql -- João Paulo

Re: What is `Aborted Clients` ?

Thanks everybody. Filter : sql -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 21 3852-9008 Ramal 31 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual

SELECT from blob column

with many other files, including files in world-readable directories, and I always get the same result. Am I missing something ? -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 21 3852-9008 Ramal 31 [EMAIL PROTECTED

Re: SELECT from blob column

Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 21 3852-9008 Ramal 31 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Re: SELECT from blob column

$ And then use LOAD_FILE(), the data doesn't show up. But if you do: $ cat test.file Some text. ^D $ Then the text shows up. Better saying, if you create a file without a trailing newline, the text does not show up, but if you put a trailing newline, it appears. sql -- João Paulo Vasconcellos

Re: My.S.Q.L

Very fun ! - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, April 06, 2002 2:35 PM Subject: My.S.Q.L Ok... it's Saturday and I've been meaning to share this with a wider audience for years Antti, you'll probably remember this from when I sent

InnoDB is better than MyISAM ?

in MySQL, and I would like to know if InnoDB is better than MyISAM for this. Best regards, -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com

InnoDB and replication

Hello there, anybody here has some background using InnoDB and MySQL replication feature ? If so, would you mind sharing those information with me ? -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 3852-9008 Ramal 31 [EMAIL PROTECTED

Re: Newbie: access denied for user

: 'root@localhost' (Using password: NO) # ./mysql -u root test ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 3852-9008 Ramal 31 [EMAIL PROTECTED

MySQL Dumps

. -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 3852-9008 Ramal 31 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Index problems

index definition. You need to recreate it before you can do a repair --- My question is: how can I repair / recreate hte index definition ? I scan the manual, and it says nothing about it. Thanks in advance, -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 3852

Index problems

index definition. You need to recreate it before you can do a repair --- My question is: how can I repair / recreate hte index definition ? I scan the manual, and it says nothing about it. Thanks in advance, -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 3852