Re: Discontinued AUTO_INCREMENT problem....

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 wagnerbianch...@gmail.com To: 杨涛涛 david.y...@actionsky.com Cc: Xavier Correyeur

mysqldumpslow

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

In mysql 5.1, mysql.proc table contains 20 columns. Can you check your new DB again? -Partha - Original Message From: Machiel Richards machi...@rdc.co.za To: mysql mailing list mysql@lists.mysql.com Sent: Fri, 3 December, 2010 1:38:24 PM Subject: MySQL restore failing Hi All

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

Hi, This can be useful... http://mafiree.com/blg/?p=124 -Partha www.mafiree.com - Original Message From: spacemarc spacem...@gmail.com To: MySQL mysql@lists.mysql.com Sent: Mon, 11 October, 2010 12:37:24 AM Subject: MySQL sock file is missing: server doesn't start hi MySQL server

Re: Export into txt file (comma delimited)

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