Differences

This shows you the differences between two versions of the page.

--- moodle-dump [2022/04/14 09:28] – created 82.65.196.74
+++ moodle-dump [2023/09/28 12:26] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
 <code>
-mysqldump -uroot -paStr45?c moodle  --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 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
 </code>
@@ Line 12: / Line 12: @@
 flush privileges;
 </code>
+Depuis mysql8
+<code>
+grant alter,create,delete,drop,index,insert,select,update,trigger,alter routine,
+create routine, execute, create temporary tables on nextcloud.* to 'nextclouduser';
+</code>