Re: mysql 3.23.36 problem

2001-03-30 Thread Tim Bunce
On Thu, Mar 29, 2001 at 07:57:41PM +0300, Michael Widenius wrote: mysql rename tables test1 to test3, test2 to test1, test3 to test2; Peter ERROR 1192: Can't execute the given command because you have active locked Peter tables or an active transaction I bet this happens when you have a

mysql 3.23.36 problem

2001-03-29 Thread Peter Zaitsev
Hello mysql, Resently I've found a problem when I was trying to upgrade from 3.23.32 to 3.23.36, well I had a same problem then tried to upgrade to 3.23.33 so decided to wait a bit, but now i think I should check more about this. The problem is the followings: Sometimes then I rename

RE: mysql 3.23.36 problem

2001-03-29 Thread Cal Evans
absolutely MUST move tables around like this, try 3 different statements. Cal http://www.calevans.com -Original Message- From: Peter Zaitsev [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 4:44 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: mysql 3.23.36 problem Hello