I have uploaded the course to restore but have been stuck on 'Course restore in Progress' for a couple of days. Is there something else I should be doing? Any help would be appreciated!
Before trying again, you might check your apache error logs for something like 'server has gone away' ... that's the DB server and means that max_allowed_packets need to be increased. If apache error logs say something about 'memory allocated exceed' ... blah, blah, blah ... that's a PHP setting for amount of memory a script can consume.
Been my experience, that restores of courses ... especially if they are large *or* heavy processing ... (lot's of quizzes) typically require those tweaks.
'spirit of sharing', Ken
I am having the same issue, restore hangs at 25% on any course above 78M: I have made all the adjustments to the php.ini and my.cnf files. Still no changes. Use to work fine before I moved to a new server.
Where can I find this - max_allowed_packets - I checked my php.ini and it does not have this statement. I have a course that is 1.2 MB and it won't restore for me, I think it is too big. Your help would be appreciated. ALso can I change max file upload by simple changing the number?
Sorry ... it's max__allowed_packet if I shared incorrect info before ... corrected now.
It's not PHP but MySQL ... my.cnf - config file of your DB server?
Read about it here for a better understanding:
Comment: a 1.4M course ... how did you determine that? A backup file? An .mbz backup is a compressed file and it's size may not be an indication as to how heavy processing a restore will be. Bunch of Quizzes? Stored in the DB sql file or backup as text can be compressed a bunch. So it looks small ... but it's not really small processing wise.
In progress BTW, could indicate failure to restore and it also could indicate server just doesn't have the umph to do it. :\
'spirit of sharing', Ken
As far as file upload, you can change it to whatever size you want, essentially, but anything much bigger than 512MB can take a bit long. If you are going to change file upload size then use the same size for post_max_size as well - keeps them balanced. Also, while there, you might want to reset memory_limit to 256MB, I've always done it and yet to run into an issue with it. The other issue that might affect is max_execution_time. Never had an issue with this but the default is 240, you might want to set that to 300 - that's 5 minutes which should be long enough to execute any script.