Re: MySQL Administrator crashes upon launch...

Wolfram Stebel wrote: Am 30.09.2005 16:29 Uhr schrieb Nuno Pereira unter [EMAIL PROTECTED]: in Users/user/Library/Logs/CrashReporter/java.crash.log one mile of traces Regards Wolfram ** Host Name: Erde Date/Time: 2005-09-30 15:13:52.351 +0200 OS Version: 10.4.2 (Build

Re: Performance problem

, bestimmte Benutzer mit sehr geringer Priorität auszustatten, dass deren Abfrage nicht über einen bestimmten %-Wert der Cpu-last geht und somit den laufenden Betrieb nicht stören? Vielen Dank für die Bearbeitung meiner Anfrage. Marco Baar -- Nuno Pereira -- MySQL General Mailing List For list

Re: timing problem

with it? How app2 sees what was the last data she read? -- Nuno Pereira -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Performance problem

Marco Baar wrote: of cause your right. hello dear Nuno Pereira, I use mysql since 2 years and collected about 50 MB user data. I ve got a performance problem during selecting the main table. The table has about 200.000 rows and I make a simple select. I only select over 4 attributes

Re: timing problem

Tony Leake wrote: On Thu, 2005-09-29 at 16:15 +0100, Nuno Pereira wrote: [EMAIL PROTECTED] wrote: This one is interesting in terms of concurrency... Is the app2 the one responsable for setting the flag? I supose that it is. If that happens it's important that app2 doesn't mess

Re: Newbie MySQL/PHP question re output formatting

don't understand arrays very well. Thanks VERY much for any help on this. bw --- Bill Whitacre [EMAIL PROTECTED] -- Nuno Pereira -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: AES_DECRYPT output

do that. Any idea how it's possible to do so? From: Nuno Pereira [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: Re: AES_DECRYPT output Date: Wed, 07 Sep 2005 12:19:01 +0100 I suppose that you have to change the status to Open, or people suppose that there aren't any changes. It would

Re: MySQL 4.0.26 has been released

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

Re: AES_DECRYPT output

? Should it always return a string format value? Or should it always return a system.byte[] format value? And I guess you also refer to the strange behavior that it's different when adding an ORDER BY or GROUP BY, right? Kind regards, Martin -- Nuno Pereira -- MySQL General Mailing List

Re: Upgrade from 4.0.12 to 4.0.25

Osvaldo Sommer wrote: Hi List I look up on the online manual for directions for this kind of upgrade but i found nothing. Is there something I have to do extra or the upgrade so smoth? Osvaldo Sommer See http://lists.mysql.com/mysql/186726 -- Nuno Pereira -- MySQL General Mailing List

Re: DIV-function?

specifically asked for a DIV function, not a division. :-) See above. With regards, Martijn Tonies -- Nuno Pereira -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: [Replication] Problem connecting to master

| +-+---+ | skip_networking | OFF | +-+---+ It can be a firewall problem... Are you sure that the slave didn't try to connect to the master, and got no response, or got a connection refused? Check the bin-log of the slave for errors in the bin-log. -- Nuno Pereira -- MySQL General Mailing

Re: create serial number by select

to modify the table, pick any reason. -- Nuno Pereira -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

SELECT ... JOIN with NULL values

| ++---+---+ Any sugestion? -- Nuno Pereira -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SELECT ... JOIN with NULL values

[EMAIL PROTECTED] wrote: Nuno Pereira [EMAIL PROTECTED] wrote on 08/26/2005 02:08:50 PM: Hi list, I have a query like this (the original is very big and names of columns/tables are in portuguese): SELECT * FROM tbl1 t JOIN tbl2 u ON (t.id_tbl2=u.id) For a schema like this: CREATE TABLE

Re: SELECT ... JOIN with NULL values

Sorry for replying to mysqlf, but it really solved the problem: there were another JOIN that had to be transformed to a LEFT JOIN. Thanks. Nuno Pereira wrote: [EMAIL PROTECTED] wrote: Nuno Pereira [EMAIL PROTECTED] wrote on 08/26/2005 02:08:50 PM: Hi list, I have a query like

Re: 'ODBC'@'localhost' instead of 'root'@'invalid_hostname.com' ?!??

when I asked it to connect to an invalid hostname as user root ?!?! sincerly, martin -- Nuno Pereira -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 'ODBC'@'localhost' instead of 'root'@'invalid_hostname.com' ?!??

Sorry for replying to my own post, but here is the manual page of PHP about mysql functions: http://www.php.net/mysql and specificly to mysql_connect: http://www.php.net/manual/en/function.mysql-connect.php Nuno Pereira wrote: Martin Olsson wrote: Hi, I'm using PHP/MySQL to development

Re: cache queries

| +-+--+ Thank you !!! -- Nuno Pereira -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Best practices for deleting and restoring records - moving vs flagging

, not_published_and_not_deleted and not_published_and_deleted. I would say that the second is very bad. -- Nuno Pereira -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: help with slow query

what is the best. -- Nuno Pereira -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to use Like Clause in Perl? Works fine in MySQL control center!

. Anybody have any suggestions? Thanks, Siegfried -- Nuno Pereira -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Undefined variable: authed

? If that is the case, it seems to me that you were using a 4.0 PHP version. Try to initialize the variables like this: $help_out=$_REQUEST['help_out']; $authed=$_REQUEST['authed']; Thanks for you help Trevor -- Nuno Pereira -- MySQL General Mailing List For list archives: http

Re: query - select from one, update another

to also DECREMENT the comment count each time a comment is deleted (if you do it), but that doesn't occur very often. This is implicit in your comment, but is not a bad idea to explicit it. -- Nuno Pereira -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: query - select from one, update another

to also DECREMENT the comment count each time a comment is deleted (if you do it), but that doesn't occur very often. This is implicit in your comment, but is not a bad idea to explicit it. -- Nuno Pereira -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: query - select from one, update another

Sebastian wrote: Nuno Pereira wrote: [EMAIL PROTECTED] wrote: Sebastian [EMAIL PROTECTED] wrote on 08/08/2005 10:53:55 AM: Gleb Paharenko wrote: Hello. What about this: UPDATE news SET comments = ( SELECT COUNT(id) FROM comments WHERE newsid = news.id GROUP BY newsid

Re: MySQL 4.0.23a mysqld defunct

start MySQL with mysqld_safe, not with mysqld. -- Nuno Pereira -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL 4.0.23a mysqld defunct

Arek H wrote: Nuno Pereira wrote: Post here the result of a ps ajxf, but it seems to me that you didn't started properly mysql. You should start MySQL with mysqld_safe, not with mysqld. Here it is PPID PID PGID SID TTY TPGID STAT UID TIME COMMAND 0 1 0 0

Re: Can not connect to Mysql server with Number 2003

, there should be an explanation about how the server crashed Any idea, please help! Thank you..Nguyen -- Nuno Pereira -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

SELECT DISTINCT

FROM table; and the query based in a recent post doesn't work select distinct on (params), params, id from table order by params, id I checked the syntax and the later isn't correct. Any ideas? -- Nuno Pereira Estagiário Carclasse - Comércio Automóveis, S.A. Lugar Sr. dos Perdões - Ribeirão

Re: SELECT DISTINCT

[EMAIL PROTECTED] wrote: Depending on what version server you are running, the GROUP_CONCAT() function may be an option for you: SELECT params, GROUP_CONCAT(ID) FROM table GROUP BY params; I'm using 4.1.10a-standard-log Server version, and this is just what I wanted. Thanks. -- Nuno

Re: SELECT DISTINCT

want, the reply from Shawn Green is just what I want. -- Nuno Pereira -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

UPDATE WITH row

int_contxtd_details WHERE id=35) WHERE id!=35; Can anyone help? -- Nuno Pereira -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: UPDATE WITH row

[EMAIL PROTECTED] wrote: Nuno Pereira [EMAIL PROTECTED] wrote on 08/05/2005 02:41:45 PM: Following the SELECT DISTINCT topic, I have another question. I tryed to UPDATE all the tables, replacing one column in every tables with the contents of one specific row. I tried this, but the syntax

Re: mysql command line execution

Bruce Dembecki wrote: On Aug 1, 2005, at 4:58 AM, Nuno Pereira wrote: Jason Pyeron wrote: sorry, reply to error here On Fri, 29 Jul 2005, Nuno Pereira wrote: Michael Stassen wrote: You can, but why are you reinventing the wheel? Option files have already been provided

Re: mysql command line execution

user:pass is root:foobar So my command would be: mysql -u root -pfoobar NOT mysql -u root -p foobar Dan On Aug 1, 2005, at 9:09 AM, Nuno Pereira wrote: Hello Edwin, Ehrwin, $ mysql --version mysql Ver 14.7 Distrib 4.1.10a, for pc-linux-gnu (i686) I tried it several times, and the password

Re: mysql command line execution

Jason Pyeron wrote: sorry, reply to error here On Fri, 29 Jul 2005, Nuno Pereira wrote: Michael Stassen wrote: You can, but why are you reinventing the wheel? Option files have already been provided for this purpose. In what way is storing the batch user password in 'password_file

Re: mysql command line execution

, 2005 7:03 AM To: Ehrwin Mina Cc: Nuno Pereira; mysql@lists.mysql.com Subject: Re: mysql command line execution Ehrwin Mina wrote: That isn't true. If you make a ps, you will see something like mysql -p x . As I said before, you can use something like: mysql -uUser

Re: mysql command line execution

in an option file (usually .my.cnf) instead. The client, mysql, will read the password from the option file, without making it available to ps. Michael -- Nuno Pereira -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: mysql command line execution

Michael Stassen wrote: Nuno Pereira wrote: Michael Stassen wrote: Ehrwin Mina wrote: Jeff, You can make a shell script or a php script or a perl script by that way you can hide the commands you need to execute. eg. Make a shell script (myshell.sh) #!/bin/sh myuser=dbuser mypasswd

Re: concat function problems

, others could help. -- Nuno Pereira email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Databases in a different location than the default

192.168.0.5 3306 (With a space instead of a semicolon) It should prompt you with some imperceptible data, where you can see the version of MySQL Server in the middle. Close it with Ctrl+D Any suggestions are welcome TIM -- Nuno Pereira email: [EMAIL PROTECTED] -- MySQL General Mailing

Re: concat function problems

Try this query and output the result SHOW VARIABLES LIKE '%time%'; if you don't find a solution. -- Nuno Pereira email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Saving a whole txt file in a database

file . Many thanks -- Nuno Pereira email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: random rows selection

the list -- Airconditioners and computers have one thing in common: Once you open windows everything fails. Nuno Pereira -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQLDump - Command line password

to set GRANT priviliges of that user only to SELECT, and then he can only read the DB (what could be bad), and not alter it, but the you would need another user to alter the DB. -- Airconditioners and computers have one thing in common: Once you open windows everything fails. Nuno Pereira email

Re: Fw: table export problem

. Is this enought? -- Nuno Pereira -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How to know if a migration might have problems

and computers have one thing in common: Once you open windows everything fails. Nuno Pereira -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

[Fwd: Re: DROP FUNCTION doesn't work]

should try placing the remote FileSystem in the local disk of the MySQL server, in order to avoid this kind of problems. (Forgot to send to the list.) Nuno Pereira -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Can't connect from remote computer

-- Nuno Pereira Estagiário Carclasse - Comércio Automóveis, S.A. Lugar Sr. dos Perdões - Ribeirão (Famalicão) Telf.: 252 330 550 - Tlm: 965 215 076 email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL