Re: Kill DELETE Query

2010-12-17 Thread Willy Mularto
Thanks for the confirmation. sangprabv sangpr...@gmail.com http://www.petitiononline.com/froyo/ On Dec 17, 2010, at 1:31 PM, Ananda Kumar wrote: No...it will not. On Fri, Dec 17, 2010 at 11:26 AM, Willy Mularto sangpr...@gmail.com wrote: Thanks for the reply. I used non stored procedure

Re: Password Reset

2010-12-17 Thread Johan De Meersman
Change password statements should show up in the binary logs, too, in some form or other. On Thu, Dec 16, 2010 at 9:58 PM, Alejandro Bednarik alejand...@olx.comwrote: SQL injection? Check Apache or whatever log files. On Thu, Dec 16, 2010 at 4:17 PM, Gary gp...@paulgdesigns.com wrote: I

mysqldumpslow

2010-12-17 Thread partha sarathy
Is it possible to run mysqldumpslow on a remote host? -Partha -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Access to MySQL

2010-12-17 Thread Jesper Wisborg Krogh
On 17/12/2010, at 9:02 AM, Jerry Schwartz wrote: I have to move the back-end of an Access application to MySQL, and I’ve run into one issue that I haven’t been able to solve yet. The Access database stores dates as text in a “/mm/dd” format. The problem is that the default value is a

Re: Access to MySQL

2010-12-17 Thread Jo�o C�ndido de Souza Neto
What about this? date_format(now(), %Y/%m/%d) -- João Cândido de Souza Neto Jerry Schwartz je...@gii.co.jp escreveu na mensagem news:011201cb9d6c$eccc1e60$c6645b...@co.jp... I have to move the back-end of an Access application to MySQL, and I've run into one issue that I haven't been able to

RE: Access to MySQL

2010-12-17 Thread Jerry Schwartz
-Original Message- From: Jesper Wisborg Krogh [mailto:my...@wisborg.dk] Sent: Friday, December 17, 2010 6:07 AM To: Jerry Schwartz Cc: 'MySQL' Subject: Re: Access to MySQL On 17/12/2010, at 9:02 AM, Jerry Schwartz wrote: I have to move the back-end of an Access application to MySQL, and

RE: Access to MySQL

2010-12-17 Thread Jerry Schwartz
-Original Message- From: João Cândido de Souza Neto [mailto:j...@consultorweb.cnt.br] Sent: Friday, December 17, 2010 6:11 AM To: mysql@lists.mysql.com Subject: Re: Access to MySQL What about this? date_format(now(), %Y/%m/%d) [JS] I don't think you can use anything but a constant as a

Re: Access to MySQL

2010-12-17 Thread Shawn Green (MySQL)
Hi Jerry, On 12/17/2010 09:34, Jerry Schwartz wrote: -Original Message- From: Jo�o C�ndido de Souza Neto [mailto:j...@consultorweb.cnt.br] Sent: Friday, December 17, 2010 6:11 AM To: mysql@lists.mysql.com Subject: Re: Access to MySQL What about this? date_format(now(), %Y/%m/%d)

A better REPAIR TABLE for myisam tables (or for upgrading tables)

2010-12-17 Thread Hank
I've posted a similar post in the past -- but there I was mucking around with blank index files and frm files to fool myisamchk into repairing a table. But now I think I've come across a much better and more efficient way to do a REPAIR Table in order to upgrade my database tables from Mysql

RE: Access to MySQL

2010-12-17 Thread Jerry Schwartz
-Original Message- From: Shawn Green (MySQL) [mailto:shawn.l.gr...@oracle.com] Sent: Friday, December 17, 2010 10:35 AM To: Jerry Schwartz Cc: j...@consultorweb.cnt.br; mysql@lists.mysql.com Subject: Re: Access to MySQL Hi Jerry, On 12/17/2010 09:34, Jerry Schwartz wrote: -Original

max allowed packets on Mac

2010-12-17 Thread g...@noiseunit.com
Hi, I found this page on the wiki regarding max allowed packets. http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html However, on my Mac OSX when I try to run the following from terminal window I get Permission Denied shell mysqld --max_allowed_packet=16M And if I try to run as sudo

Re: A better REPAIR TABLE for myisam tables (or for upgrading tables)

2010-12-17 Thread Hank
Sorry... One small correction to my above post.. 'FLUSH TABLES' should be issued between steps 8 and 9. My 200+ million record table completed in 71 minutes. -Hank mysql; query;

Re: max allowed packets on Mac

2010-12-17 Thread Michael Dykman
I'm not nuts about deploying MySQL on macs, but I think you need to assume root. As your mac admin user, try $ sudo su - and give your admin password when asked. You should now be root and can expect permissions to behave as you would expect. - michael dykman On Fri, Dec 17, 2010 at 12:16 PM,