How to check your Moodle Site database Size and creating a dump

If you have access to the server, you can check the database size using:

du -sh /var/lib/mysql/your_moodle_db_name

⚠️ Note: This method works only if you have direct file system access.

Create a Database Dump (Export the Database)

Run the following command in the terminal:

mysqldump -u root -p  moodle_db_name > /home/youruser/moodle_db_name.sql

• Replace root with your MySQL username if it’s different.
• Enter your MySQL password when prompted.
• The database dump (moodle_db_name.sql) will be saved in /home/youruser/.