moodle-dump
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;
moodle-dump.1674895225.txt.gz · Last modified: 2023/09/28 12:26 (external edit) · Currently locked by: 216.73.217.114