Moving A lot Attachments to File System
 

Hey guys
I am running a forums where people upload songs and music.. Each song is on average 5 MB and we have over 2000 attachments stored in the DB.

When I run the Attachment Storage Type in the admin cp.. I set the directory and the number of files per cycle (50).

The script runs for a while and then I get a timeout or a page not found page.. sometimes the page becomes blank...

We need to move these attachments ASAP as the host is threatening to suspend our account due to the huge databases size

Any help or suggestions would be appreciated

Your host needs to adjust the php settings and possibly mysql settings to allow you to move the files out of the db, the setting max_execution_time needs to be raised to allow the script to execute longer, if your host allows you the use of a php.ini file per directory on your account, you can set the limit there.

create a php.ini file and place this in it and upload it to every folder in your account that is dealing with the forums - max_execution_time 300

You can also try less than 50 at a time as well, lower 10 everytime unti lit stops timing out.