DokuWiki

This is an old revision of the document!

---

mysqldump -uroot -paStr45?c moodle   --max_allowed_packet=2048M  --ignore-table=moodle.mdl_logstore_standard_log --ignore-table=moodle.mdl_notifications --ignore-table=moodle.mdl_question_attempts --ignore-table=moodle.mdl_question_attempt_step_data --ignore-table=moodle.mdl_question_attempt_steps> /home/backup-13042022.sql

mysqldump -uroot -paStr45?c --no-data moodle  mdl_logstore_standard_log mdl_notifications mdl_question_attempts mdl_question_attempt_steps  mdl_question_attempt_step_data >> /home/backup-13042022-log.sql

CREATE DATABASE moodle DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
grant all privileges on moodle.* to 'moodleuser'@'localhost' identified by 'Aeiytr48!';
flush privileges;