منتدى استراحات زايد

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,

Code:
------- 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:

Code:
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/up...0b2.php?step=3
actually, this query mustn't not take much time. just adds a field

Code:
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.