Impex huge data base

[alone]

I would like some advice from those experts.

Here is my situation
===================
Current CMS : xoops1
Data base size : over 2G
Users account : 50,000
Posts : 5,000,000
Topics : 350,000
PM : 1,000,000
average user online : 600register, 600guess
===================

I am going to move all data to vb3.0.7, users and forums are done.
when importing threads and posts ( 500 each time), it timeout frequently, I chnage php execution time to 120s and timeout still occur, I am using a p4 2.4G, 1G ram pc as data base and httpd ran at another pc.

plz give me some adivce.

[Jerry]

Righty, first thing to do is run impex stand alone, i.e. in the web root and not in the admincp, and set up the ImpExConfig.php.

Secondly, if you can turn off the PHP time out and set the memory limit as high as you dare as 350,000 topics is going to take up a lot of memory when importing the posts (it loads a reference array importthreadid -> threadid). With 1G of ram I'd give PHP 512 Meg.

Take a back up after each module.

After importing the posts its going to take quite a while to update the parent id's also, so give it time and don't hit back or refresh.

[alone]

in the web root and not in the admincp <--- I don't understand

[Jerry]

in the web root and not in the admincp <--- I don't understand

out side of the folder you are running vBulletin in, i.e. if you have :

/home/jerry/www/forum/
/home/jerry/www/forum/impex

at the moment which is the usual way, move it out like this :


/home/jerry/www/forum/
/home/jerry/www/impex

So its not inside vBulletin, no time outs and slightly less memory used.

[cokechiu]

out side of the folder you are running vBulletin in, i.e. if you have :

/home/jerry/www/forum/
/home/jerry/www/forum/impex

at the moment which is the usual way, move it out like this :


/home/jerry/www/forum/
/home/jerry/www/impex

So its not inside vBulletin, no time outs and slightly less memory used.

Thank you very much, I will try it. arhh, I am working for alone.