MySQL Forums
Forum List  »  InnoDB

Re: Alter table killed, but change was done
Posted by: Charlie Schaubmair
Date: June 04, 2011 01:33AM

As you can see in my first post:
http://forums.mysql.com/read.php?22,422008,422008#msg-422008

The following statement was executed:
ALTER TABLE table1 modify myColumn varchar(200);

The other few statements I've described were only to show a much better way.

Ok, from the beginning:

1. This script was executed:
ALTER TABLE table1 modify myColumn varchar(200);

2. More then 3 hours later I killed it:
KILL xxxx;

3. There was a tmp-table for the being altered table and this table was immediately deleted.

4. again about 5 hours later there were some 28 errors

5. 1 day later I notced that the table was changed

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Alter table killed, but change was done
780
June 04, 2011 01:33AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.