Re: Logging SQL queries

need to record all > queries performed. What is the best / recommended way to achieve this. > > Thanks > Neil > -- Mauricio Tellez

Trigger working with server 5.0.51 but not 5.0.22

mp_calculos_res' doesn't exist" Is there a big change in handling triggers from version 5.0.22 to 5.0.51? Or I missing something? Thanks in advance -- Mauricio Tellez

Log querys from stored procedure

call. By the way, how can I log the triggers queries? Do I need to set some kind of "query log verbose level"? thanks in advance. -- Mauricio Tellez

dynamic table name

7;John Doe'; END of course nested_sp is very silly, but the idea is the same. When I run this, I found that there is no table name like '20080426...' but I get a table 'my_table', how can I fix this? -- Mauricio Tellez

[OFFTOPIC] PHP and local-infile

mysql command line I get the same message, so I put the following in my.cnf: loose-local-infile at [client]section. This solve the mysql command line, but when running from PHP I still got the same. Any clue? -- Mauricio Tellez

Re: Automatic email to database member on X date?

gt; For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- Mauricio Tellez

Re: Odd behavior of 'load data'

sage- > From: joe [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 08, 2008 12:01 AM > To: 'Mauricio Tellez' > Subject: RE: Odd behavior of 'load data' > > You may need to use LOAD DATA LOCAL INFILE. > > > -Original Message- > From: Ma

Re: Odd behavior of 'load data'

cess the file specified by load data, and the user you use to connect to mysql has nothing to do in that, am I right? So, why this work properly with the root user but not with the filasPOS user? Thanx for the help 2008/1/7, Chris <[EMAIL PROTECTED]>: > > Mauricio Tellez wrote: > >

Odd behavior of 'load data'

_priv: Y Create_user_priv: N ssl_type: ssl_cipher: x509_issuer: x509_subject: max_questions: 0 max_updates: 0 max_connections: 0 any clue? thanks in advance. -- Mauricio Tellez

Re: Restoring a binary log ( mysqlbinlog )

Hi, please see comments below.. thank you Mauricio On Wed, 2006-04-05 at 09:02, Prasanna Raj wrote: > Hi All > > Correct me if iam wrong > > You might have run the create table syntax from hrdb database .So it gives > you the create table also when you do mysqlbinlog .

Restoring a binary log ( mysqlbinlog )

rite operations were created as a result from executing reports not data modification ) thanks Mauricio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Numbering rows

re could be less. That's it. Thank you very much for your valuable help Mauricio On Fri, 2005-05-13 at 06:22, Harald Fuchs wrote: > In article <[EMAIL PROTECTED]>, > Mauricio Pellegrini <[EMAIL PROTECTED]> writes: > &

Numbering rows

5 0 3 4 8 22 7 1 <-This is row number 1 5 8 22 0 2 <-This is row number 2 6 10 64 20 1 <-This is row number 1 - I hope it is clear enough All sugestions ar

Re: How to select the max value

several rows with the > same max date, the outer query will return all of them. > > Please note that I am running MySQL 4.0.x so I can't test this in MySQL but > it would work in DB2; DB2 and MySQL are very close in most respects. > > Rhino > > - Original Mess

How to select the max value

Id x_col date_col 3 1 2005-04-12 Is there a way to do that ? Thanks in advance Mauricio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to import data from Dbase3?

Hi there's a free utility name dbf2mysql I assume you are running dbase3 plus under windows/dos Look for it in google or ask me and I would send it to you. I´ve used it under windows with dbf tables from Clipper, dBase and Fox It doesn't require ODBC drivers at all. greetings Maurici

Upgrading from 4.1.4 gamma to 4.1.10a

e to leave intact my current databases (innodb tablespace, etc.) and replace only the binaries ? or Should I do full dump with mysqldump an then recreate the whole thing under the new version after installing it from scratch? thanks Mauricio -- MySQL General Mailing List For list arch

Re: Lock timeout problem

se Locked table (pr_prestaciones) was not updated by the query in *** (2) thanks Mauricio On Fri, 2005-03-11 at 18:42, Heikki Tuuri wrote: > Mauricio, > > - Original Message - > From: "Mauricio Pellegrini" <[EMAIL PROTECTED]> > Newsgroups: mailing.datab

Limit of a sql script

problem when mysql handles the content of this script due to its size. In other words is there a limit on the size of a script that mysql can hable from the command line ? I hope I've made myself clear Best regards Mauricio -- MySQL General Mailing List For list archives: http://l

Lock timeout problem

t may not be inside the binary log as we had to stop the server and start it again . Question #2. What does the " 225 lock struct(s) " mean Thanks Mauricio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Query_cache_size Question

questions for thoses results ? > There's a lot of lowmem_prunes, so I would indeed increase the memory > size to reduce the risk of lowmem_prunes. > What is your query_cache_limit ? > >Jocelyn > > Mauricio Pellegrini a écrit : &

Re: Query_cache_size Question

not_cached means the number of query results that didn't get into the cache because of a space limitation ? If so, perhaps adding few more Mb would improve that number , isn't it? On Wed, 2005-03-09 at 19:30, Dan Nelson wrote: > In the last episode (Mar 09), Mauricio Pellegrini said

Query_cache_size Question

be a more efective value? As I've said before the engine is InnoDB. Thanks Mauricio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: skip-name-resolve

accepted by mysqld So I repost my question Is there a sure way to check if skip-name-resolve is in efect ? Thanks Mauricio On Wed, 2005-03-09 at 14:20, Keith Ivey wrote: > Mauricio Pellegrini wrote: > > > Is there a way to check whether this option is active or not, while the > >

Re: skip-name-resolve

Is there a way to check whether this option is active or not, while the server is running? Thanks Mauricio On Tue, 2005-03-08 at 06:39, Gleb Paharenko wrote: > Hello. > > > Is the option well set and in the right place ? > > Yes. If your mysqld reads this file (use --def

skip-name-resolve

occur also on a server running SuSe Linux 8.2 ? Thanks Mauricio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Which file to backup

Yes , I'm using innodb. Is it necesary to do a mysqladmin flush-logs before making a copy of ib_logfile* or must the server go down to do a safe copy of the ib_logfiles ? thanks Mauricio On Fri, 2004-09-17 at 09:08, Egor Egorov wrote: > Mauricio Pellegrini <[EMAIL PROTEC

Sign

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

How to create random table names on the fly

Thank you Mauricio P.S.: I 've already tryed with temporary tables and they`re ok but sometimes I need to use them twice in the same query and that`s not possible. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.

Re: Naming columns dynamically

That's exactly what I'm trying to do (use the contents of a variable as an alias for the column) Thanks Mauricio On Tue, 2004-11-16 at 16:09, Rhino wrote: > Actually, Mauricio is trying to concatenate the string 'October_' (or > whatever) to the *alias* of the colu

Re: Naming columns dynamically

meone else reads this thread the question is: Is it possible to use variables as column names ? like this : Select field1 as @var from table1 Thanks again Mauricio On Tue, 2004-11-16 at 05:38, Gleb Paharenko wrote: > Hello, Mauricio. > I've found somethin

Naming columns dynamically

now the value of @var which is typed by the operator at the time the query is run. Is there a way to concatenate the contens of a variable and a column alias at run time ? thanks for your ideas Mauricio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To un

Complex update query

porary table to insert the new records into tableC ? Thank you And forgive me if I couldn't make myself clear Mauricio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to pick the oldest row

Thanks Jim,but that doesn't work for me because the order by performs after the records have been selected. At that time I already have the unwanted row. I will try to explain a little bit further SELECT * FROM `mj_tmp`This select is suposed to return all rows WHERE idk NOT IN but

Re: Conexiones no autorizadas

Very sorry!!! I've just mistaken the email address.. This message was intended to be sent to a Spanish SuSE List. I Apologize. Mauricio On Mon, 2004-09-27 at 15:55, Mauricio Pellegrini wrote: > Hola , > > Estoy empezando a notar intentos de ingreso con usuarios ilegales >

Conexiones no autorizadas

sus experiencias Desde ya muchas gracias Mauricio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SV: Mysql goes down when executing query

t a Client program could cause mysql to restart in that way. by the way as I've seen that the control center is no longer under development which program would you suggest to replace it.( assuming the same capabilities, of course ) Thank you very much Mauricio P.S. Im using SuSE v.8.2

Re: What's wrong with the use of Between and datetime columns ?

Sorry , You were right. I was mistaken the results Between works just fine. It was me. I'm Very sorry Thank you all On Thu, 2004-09-23 at 15:45, Mauricio Pellegrini wrote: > Thanks,but I've also tried the date() function > to compare only the date part of the colum

Re: What's wrong with the use of Between and datetime columns ?

Thanks,but I've also tried the date() function to compare only the date part of the column like this select * where date(date_col) between date(startdate) and date(enddate) and the result is the same. On Thu, 2004-09-23 at 11:04, gerald_clark wrote: > Mauricio Pellegrini wrote:

What's wrong with the use of Between and datetime columns ?

e datetime type. First I would like to know why is this happening, and second how to avoid it. Thanks Mauricio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Which file to backup

Sorry for my bad English!! From: Mauricio Pellegrini <[EMAIL PROTECTED]> To: MySql List <[EMAIL PROTECTED]> Subject: Wich file to backup Date: 16 Sep 2004 11:28:56 -0700 Hi , I'm trying to backup the 'binary log' and don't know which file is it. these are the f

Re: SV: Mysql goes down when executing query

rse__FP3THDPcUi + 68 0x8097e4f dispatch_command__F19enum_server_commandP3THDPcUi + 1643 0x80977d8 do_command__FP3THD + 188 0x8096f17 handle_one_connection + 615 0x82d146c pthread_start_thread + 220 0x82fa9fa thread_start + 4 Thanks Mauricio On Thu, 2004-09-16 at 00:52, Heikki Tuuri wr

Wich file to backup

e name of the file I should use into my script? Thanks Mauricio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SV: Mysql goes down when executing query

Thanks, but already have innodb_buffer_pool_size=160M and I've raised innodb_additional_mem_pool_size from 2M to 10M And the problem remains the same. Any sugestions? Thanks Mauricio On Tue, 2004-09-14 at 18:05, Nickolai Nielsen wrote: > Hi > > Try setting these variabl

Mysql goes down when executing query

Hi, Sorry to disturb but Mysql 4.1.4 gamma goes down when executing this query. I've tryed the same query without the coalesce function and the problem persists. select coalesce(viehc,0), coalesce(vieapellido,0), coalesce(vienombres,0), coalesce(viedoc,0), coalesce(numero,0),

Wrong query result

e type InnoDB. What is happenning? Mauricio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

License question

ql as database engine and the MySql package delivered with the application, is licensed under GPL. Could the developer claim License rights upon the use of such a combination ? Thanks Mauricio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Wrong query result

NDEZ NUÑES MONTAGNE MIÑO ANTIÑACO MORENO GONZALEZ In other words mysql seems to confuse N with Ñ The charset for the tables is latin1 and the type InnoDB. What is happenning? Mauricio -- MySQL General Mailing List For list archives: http://lists.

Mysql 4.1.4 gamma - Install error

126976 Despite that message, everything seems to be working just fine. Is that error something I should take care of? what is the cause ? Thanks Mauricio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Query hangs mysql 4.1

Hi, I don't mean to abuse, but could someone give me some help on how to upgrade from 4.1.1 Alpha to 4.1.4 gamma Any help gratly appreciated Mauricio On Thu, 2004-09-02 at 10:34, Heikki Tuuri wrote: > Mauricio, > > please send the FULL .err log to me. Do not cut anything of

Query hangs mysql 4.1

dP3THDPcUi + 1631 0x8114ec2 do_command__FP3THD + 162 0x8114637 handle_one_connection + 551 0x40146c60 _end + 934901296 0x402e9b77 _end + 936617287 Watching those entries in the error log I cant figure why is this happening. Can anybody give me a hint? Thank you Mauricio -- MySQL General Mailin

how to hide certain columns

#x27; @var1:[EMAIL PROTECTED] as 'C3' @var2:[EMAIL PROTECTED]@var1 from test; Select C1, C2 ,C3 from tmp_test Is there another way ? Thanks a million Mauricio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Using SUM in a special way

l the rest of the people who answered my question Gratefully Mauricio On Fri, 2004-08-13 at 11:55, Keith Ivey wrote: > Mauricio Pellegrini wrote: > > >and would like to obtain this result from a query > > > > Col1Col2Col3 > > 1 20 20 &

Using SUM in a special way

I mean... Thank you Mauricio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Moving InnoDB database from Linux to Windows

x27;. (errno: 1) -- Mauricio Bruns - ASV Consultoria [EMAIL PROTECTED] - www.asv.com.br Rua Felipe Schmidt, 31 - Sala 904 88350-075 - Brusque - SC - Brasil tel/fax: (47) 351-3901 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

ERROR 1137: Can't reopen table: 'mj_tmp_diag'

ERROR 1137: Can't reopen table: 'mj_tmp_diag' <--- This is T1 Is it that I can't use two temporary tables this way? What can I do to solve this problem? The error shows when I execute the whole query under MySql Control Center. Mysql version is 4.1 Thanks in advan

How to turn rows into columns

Thanks in advance, Mauricio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySqldump not giving the right output

ld it be the problem is happening because I'm running the command from within a script which dumps several tables in sequence? The script uses mysqldump to extract data into individual files and uses cat to concatenate all this files into one. any help would be appreciated Thanks MAuricio

Re: Slow querys When ADSL is down on W2K

> > > > The only thing strange about this is that in your previous > post you mentioned that the wk2 machine had an ip of > 192.168.10.5. Yes, that example was from another machine on the same net > > The above route print output seems to be for a machine > with an ip of 192.168.10.2. Yes.

Re: Slow querys When ADSL is down on W2K

On Tue, 2004-06-08 at 12:57, John Fawcett wrote: > From: "Mauricio Pellegrini" > > Hi, > > > > I've tryed that after reading this message, > > But couldn't get the route correctly established. > > > > I'm giving some more details

Re2: Slow querys When ADSL is down on W2K

192.168.10. 3 Performs right all the time All of them are on the same Network. How should I form the route command? Oh, the ADSL router is on 192.168.10.1, Which is set as the default Gateway Any help greatly appreciated. Mauricio On Thu, 2004-06-03 at 14:08, Brad Tilley wrote: > I&#

RE: Slow querys When ADSL is down on W2K

hen the adsl goes down? > > Not a network expert, so just a guess 8-) > > Peter > > > > -Original Message- > > From: Mauricio Pellegrini [mailto:[EMAIL PROTECTED] > > Sent: 04 June 2004 00:44 > > To: MySql List > > Subject: Slow querys When

Slow querys When ADSL is down on W2K

ion ) returns normal execution times on the W2k boxes. Soon as the ADSL service is restored execution times return to normal on w2k and remains unchanged on Linux. I can't figure why this happens.. any ideas are especially welcome Thanks Mauricio -- MySQL General Mailing List For li

Re: MySQL Warning Messages - Continued..

Yes, you were right! After reading your mail, counted the columns in my .txt file and discovered that there was a missing one. I've just added the column, issued a LOAD DATA... and the result was Zero warnings this time. Thanks a lot. Mauricio On Thu, 2004-06-03 at 09:59, Michael St

MySQL Warning Messages - Continued..

, its true that record count is = Cero at the time The number of columns for the table ( column count ) is always 54 of course. Any Ideas...? Thanks you Mauricio PS: Thanks Renato, Victor, Dan for your answers. -- MySQL General Mailing List For list archives: http://lists.mysql.co

How to retrieve MySQL Warning Messages

wrong with the table after executing the command. I would like to know the cause of the WARNINGS or what is the text corresponding to those warnings Is that possible? Thank you Mauricio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsub

ERROR 2013

changes into its data) Any hint would be greatly appreciated.. Thanks Mauricio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Backups with version 4.1

27;m starting to think in doing some kind of incremental backups in order to use less space for storage, is that possible ? Thank you Mauricio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RES: Compiling error 3.23.54a (src)

Hi, Aswering my own question, I had solved the problem above instaling gcc-c++, gcc-java, gcc-f77, and all other packages of gcc. Then I´ve installed MySQL without any problems. []´s Mauricio Bracale -Mensagem original- De: Mauricio Bracale [mailto:[EMAIL

RES: Compiling error 3.23.54a (src)

Hi, I just want to inform that I´m having the same problem in a Red Hat 8. I´ve installed this linux only with the basic packages, like gcc, cpp, glibc, ncurses (to recompile the kernel), binutils, make and glibc-kernel headers. And in one of the foruns I visited, somebody told to

RE: Mysql, ODBC and PHP

Hi It's not a MySQL issue, it's a web server configuration problem. Check you php.ini file and unquote in the section: ;Windows Extensions the line accordingly with the DB connexion you're using. MySQL is set by default. Also try the function odbc_fetch_into() -Mensaje original--

RE: getting the number of years between two dates

Well, actually I always use the Unix date format because is easier to use with PHP... and makes easier to do this kind of calculations... ;) -Mensaje original- De: John Meyer [mailto:johnmeyer_1978@;yahoo.com] Enviado el: jueves, 07 de noviembre de 2002 15:20 Para: Michael T. Babcock CC:

Re: spanish books about mysql?

Well, I bought "MySQL", Edición Especial from Paul DuBois. The editor is Prentice Hall. Maybe you can buy it at www.pearsoneducacion.com... jeje I found one about MySQL and Perl there. - Original Message - From: "Markus Jais" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, Aug

Re: Access to MySQL

SELECT * INTO mysql_table IN "" [ODBC;DSN=mysql_dsn;SERVER=localhost;UID=root;PWD=] FROM access_table You need myODBC and execute this in Access. Respect the double empty quotes. - Original Message - From: "Oladejo, Tokunboh" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, Augu

Re: MySql <- Access

Could you use this in Access, perhaps ? SELECT * INTO mysql_table IN "" [ODBC;DSN=mysql_sample_DSN;SERVER=localhost;UID=root;PWD=] FROM access_table You need myODBC 2.5 at least., and set up a DSN for your mysql database. It has worked fine for me with string, numeric and memo fields. It transp

BLOBs and DataBase... is it likely to corrupt it with them ?

I'm working with BLOBs in mySQL and Visual Basic... i read that storing images in the database has worst performance than the filesystem, but anyway I'm planning to store them in MediumBlobs. My specific problem is that I don't know if I'm risking too much the database, perhaps the chance it will

Re: Problem with BLOB Field

Try ActualSize instead. - Original Message - From: "deep kapasi" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, August 13, 2002 8:33 AM Subject: Problem with BLOB Field > Hi, > > I have already posted this query 4-5 days ago but no >