Re: Discontinued AUTO_INCREMENT problem....

2010-12-21 Thread partha sarathy
Hi, There is one variable called innodb_autoinc_lock_mode. If the value is 0, this issue wont come. You might set it to 1 or 2. -Partha www.mafiree.com - Original Message From: Wagner Bianchi To: 杨涛涛 Cc: Xavier Correyeur ; mysql@lists.mysql.com Sent: Tue, 21 December, 2010 3:28:00

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: MySQL restore failing

2010-12-03 Thread partha sarathy
In mysql 5.1, mysql.proc table contains 20 columns. Can you check your new DB again? -Partha - Original Message From: Machiel Richards To: mysql mailing list Sent: Fri, 3 December, 2010 1:38:24 PM Subject: MySQL restore failing Hi All I am hoping that someone could assist

Re: MySQL sock file is missing: server doesn't start

2010-10-11 Thread partha sarathy
Hi, This can be useful... http://mafiree.com/blg/?p=124 -Partha www.mafiree.com - Original Message From: spacemarc To: MySQL Sent: Mon, 11 October, 2010 12:37:24 AM Subject: MySQL sock file is missing: server doesn't start hi MySQL server doesn't start because #2002 the /var/run/my

Re: Export into txt file (comma delimited)

2010-01-08 Thread partha sarathy
HI, Just add this at the end of your command "fields termininated by ','" like below, select * from ae_a222 where ano=2009 and dia_juliano between '1' and '365' into outfile "C:\\Documents and Settings\\rbastos\\Meus documentos\\teste.txt" fields termininated by ',' ; - Partha www.mafiree.com