[veyissen]

Hi

I want to upgrade 3.6.5 to 3.8.2. I have a very large db. over 2 GB. over 400.000 user. When start to upgrade, it continues from 3.6.5 to 3.7.0b2 step3 and then at this step, upgrade stops. proceed button not show up. and I start to wait and wait again.

Step 3) Misc Table Alterations.

just this one.

while waiting, I look at to mysql process list and see,

------- status                    
copy to tmp table  

  -----info---
  ALTER TABLE userADD profilevisits INT           UNSIGNED NOT NULL DEFAULT 0

--------------------------------------------------------

it takes hours.. and after waiting approximately 2 hours, mysql gives a database error:

Database error in vBulletin 3.6.8:
 
Invalid SQL:
 
ALTER TABLE user
ADD profilevisits INT UNSIGNED NOT NULL DEFAULT 0;
 
MySQL Error : Server shutdown in progress
Error Number : -1
Request Date : Monday, April 27th 2009 @ 01:00:56 PM
Error Date : Monday, April 27th 2009 @ 01:01:23 PM
Script : http://www.xxx.com/forum2/install/upgrade_370b2.php?step=3

actually, this query mustn't not take much time. just adds a field

ALTER TABLE user
 ADD profilevisits INT UNSIGNED NOT NULL DEFAULT 0;

then, dear forum owners and professionals, what sould I do now? How this upgrade continue? why every query needs "copy to tmp"?

Thanks alot.