Calculating your site size when migrating to MoodleCloud

Modified on Fri, 22 Dec 2023 at 03:39 PM

If you are planning to migrate your Moodle LMS site to MoodleCloud, you will need to calculate the size of your site to ensure that you purchase a plan with sufficient storage.

There is no easy way to calculate the size of your existing Moodle site. 

  • If you have technical skills here is the SQL query we use to calculate disk quota:
SELECT SUM(f.filesize) FROM ( SELECT DISTINCT contenthash, filesize FROM mdl_files WHERE filearea <> 'draft' AND referencefileid IS NULL AND component <> 'tool_recyclebin' AND (component <> 'backup' OR mimetype <> 'application/vnd.moodle.backup') AND component <> 'assignfeedback_editpdf' AND component <> 'core_h5p' AND component <> 'contentbank' UNION SELECT contenthash, filesize from mdl_files WHERE (component = 'core_h5p' AND filearea = 'content'> GROUP BY filesize, contenthash ) AS f");

This should return the number of bytes used by your site. Divide it by 1073741824 to get the value in gigabytes.

  • If you are not technically minded:

To calculate the total size of your site, perform a Backup of each of your site’s courses and add together the size of all the Backup files

To Backup your course:

  1. In your Moodle LMS site, visit each individual course;
  2. Click More > Course Reuse > Backup, go through the step and perform the course backup;
  3. Once finished, go to More > Course Reuse > Restore;
  4. Select the backup and download it to your computer;
  5. Go to your new MoodleCloud Site;
  6. Select Site Administration > Courses
  7. Click Restore course to upload that file;

In addition, you could upload them to a time-limited MoodleCloud Free Trial site to test and see the total file size (the time-limited Free Trial is limited to 250MB and 50 users).

  • Keep in mind that our plans are standard, so user and storage quotas are fixed.
    • If you need more storage, you'd have to upgrade to a larger plan;
    • Our largest plan goes up to 1,000 users and 5 GB of storage;
    • If you need more users or storage, please consider the services of a Moodle Certified Partner;
    • Find all our plans, quotas and prices in the MoodleCloud website;

*Find more about Course backup and Restore, and how to optimise your MoodleCloud site storage.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article