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
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:
https://dev.mysql.com/doc/refman/5.7/en/packet-too-large.html
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.