Backup MySQL or MariaDB

[@rajib7278]

Thanks bro. You videos are very useful for me to get my moodle setups. Keep up the great work.

[@Wise-Cat]

Glad to hear it! I hope my future videos are also useful for you. Good luck!

[@Syllas95]

Very nice and well explained content... It's a pain that moodle didn't considered the upgrading process, nor a way to backup everithing as is....

[@Wise-Cat]

I imagine that at some point Moodle will need an automatic updater like WordPress. I have written scripts before that backup and update Moodles weekly. The script is simple enough and is triggered with a cronjob, but I still feel a bit anxious letting Moodle upgrade itself unattended. That said, I'm even more anxious about newly discovered security vulnerabilities going unpatched... I would be all for automatic updates!

[@Syllas95]

@@Wise-Catcompletely agree on what you said. Do you have a repository for those scripts? Maybe the community can work on it.

[@Wise-Cat]

@Syllas95 whenever I've done it, it was a bespoke upgrade in bash rather than a PHP script. So, it probably wouldn't work for everyone. The basic idea is the same as in this video: kzbin.info/www/bejne/b4eUqmp9btimp9E I also add a step where the SQL database is backed up right before the update. That might be a good topic for a video. And maybe if I wrote the script using vars I could post it to GitHub. Hmm, thanks for the idea 💡

[@IchBinGigio]

That was really useful. Thank you.👍

[@Wise-Cat]

Glad to hear that!

[@AlejandroPalestrini]

Excelente! Muchas gracias, desde Argentina un saludo grande!

[@Wise-Cat]

Argentina? Wow! Thanks for watching! Glad to have been of service.

[@sharifchowdhury9743]

How to install and configure Moodle archive system using moodle 4.1 and mysql 8 for previous semester

[@Wise-Cat]

I think there is a plugin for bulk backups (by Justin Hunt?) though it might not be in the plugins database. Also you could try using the upload courses feature to duplicate existing courses in bulk.

[@truthtriumphs5289]

for this command "mysqldump -u root -p open > open_backup.sql" open is database name, which password should I use?

[@Wise-Cat]

In that case, you specified the MySQL root user, so the password belonging to MySQL root. Note that this is different to the sudo password or server root password. Alternatively, you can use the username and password as defined in config.php. you don't actually need root permissions to take a dump, usually.

[@truthtriumphs5289]

@Wise-Cat Thanks!