Help me !! Upgrade problem !!

[algolee]

Help !! I have a big problem!!

My VBB 2.2.9 attachment database is up to 6.x GB ( more than 150,000 pics about plants)
When I try to upgrade VBB from 2.2.9 to 3.x

Step 13) Update Attachments #1 Updating Attachments...
The processs run one day long and still running now .....

Last time I run it make my MAXTOR 80 GB HD crashed.... so I buy new SATA 80GB HD and try again.

Can someone help me and tell me how to do is the best way ??

My Hardware is :
CPU : AMD 64 3200+
OS :Fedora core 3 64 bit
RAM : 1 GB RAM
A-HA 29160 U2W + IBM 18GB HD (10000 rpm) for OS
MAXTOR 80 GB SATA HD for MySQL Database
Motherboard : Gigabyte K8NS-Ultra 939 :dead:

[Brad]

Let it run, it could take a few days to get done with all the attachments.

[algolee]

Dear Brad.loo
My another question is :
Put all pics into attachment database or save them as files is the best way for performance ??
For backup strategy , it seems put all attachments into database is the best way ?

[noppid]

While databases can store images and it is common. A little research will show you how inefficient it really is. If you have that much weight in images, the file system would be a good idea.

[Brad]

The file system is the best way to store attachments imo, the database means a hit in preformance.

Backing up the attachments when stored in the file system is as easy as backing up any directory on your web-server.

The upgrade path from vB 2 to vB 3 requires attachments in the database, because this is how they where always stored in vB 2. There is a hack to store vB2 attachments in the file system, but even with that when the time came to upgrade to vB3 you would have to move them back to the database.

You have a large attachment table, one of the largest I have seen. I heard reports of people having to keep the browser window open for 2 - 3 days for 3 gig's of attachments. So my advice is to leave the browser window open and hope it dose not eat the new harddrive

Maybe you should contact offical support about this one, they deal with many large boards daily with these kinds of issues. I rarley work directly with large forums

[algolee]

Thanks for answer me . I had already modified some source code that offical support give it to me .
It's just spend two hours for Step 13 . ^^ y