Next: 成績排序 Up: 其他小修改 Previous: 目錄檔案瀏覧 Contents DYWANG_HOME
sortorder, itemid, filepath, filename，增加以修改時間遞減 timemodified DESC 優先排列。
[root@moodle mysql]# mysqldump -uroot -p --quick --force --routines --add-drop-database --all-databases --add-drop-table > /mnt/mobackup/mysqldump20180612.sql
Enter password:
mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = '#mysql50#lost+found”: Cannot load from mysql.proc. The table is probably corrupted (1548)
mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'moodle23”: Cannot load from mysql.proc. The table is probably corrupted (1548)
mysqldump: Got error: 1102: Incorrect database name '#mysql50#moodle23.20130903' when selecting the database
-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'mysql”: Cannot load from mysql.proc. The table is probably corrupted (1548)
mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'openmeetings”: Cannot load from mysql.proc. The table is probably corrupted (1548)
mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'test”: Cannot load from mysql.proc. The table is probably corrupted (1548)
[root@moodle mysql]# mysql -uroot -pxxxxxx
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 14
Server version: 5.5.38 MySQL Community Server (GPL) by Remi
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> repair table mysql.proc
-> ;
+------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+------------+--------+----------+----------+
| mysql.proc | repair | status | OK |
+------------+--------+----------+----------+
1 row in set (0.05 sec)
mysql> exit
Bye
[root@moodle mysql]# mysql_upgrade -uroot -pxxxxxx
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments
Failed to ALTER DATABASE `#mysql50#lost+found` UPGRADE DATA DIRECTORY NAME
Error: Can't create database 'lost+found'; database exists
Failed to ALTER DATABASE `#mysql50#moodle23.20130903` UPGRADE DATA DIRECTORY NAME
Error: Incorrect database name '#mysql50#moodle23.20130903'
Running 'mysqlcheck with default connection arguments
mysqlcheck: Error: Couldn't get table list for database #mysql50#lost+found: Can't read dir of './lost+found/' (errno: 13)
moodle23.mdl_assign OK
moodle23.mdl_assign_grades OK
moodle23.mdl_assign_plugin_config OK
moodle23.mdl_assign_submission OK
moodle23.mdl_assignfeedback_comments OK
moodle23.mdl_assignfeedback_file OK
moodle23.mdl_assignsubmission_file OK
moodle23.mdl_assignsubmission_onlinetext OK
moodle23.mdl_attendance_log OK
moodle23.mdl_attendance_sessions OK
moodle23.mdl_attendance_statuses OK
moodle23.mdl_attforblock OK
moodle23.mdl_backup_controllers OK
moodle23.mdl_backup_courses OK
moodle23.mdl_backup_files_template OK
moodle23.mdl_backup_ids_template OK
moodle23.mdl_backup_logs OK
moodle23.mdl_block OK
moodle23.mdl_block_community OK
moodle23.mdl_block_configurable_reports OK
moodle23.mdl_block_formal_langs OK
moodle23.mdl_block_formal_langs_node_dscr OK
moodle23.mdl_block_gchat_messages OK
moodle23.mdl_block_gchat_sessions OK
moodle23.mdl_block_gchat_user_sessions OK
moodle23.mdl_block_gchat_users OK
moodle23.mdl_block_instances OK
moodle23.mdl_block_mrbs_area OK
moodle23.mdl_block_mrbs_entry OK
moodle23.mdl_block_mrbs_repeat OK
moodle23.mdl_block_mrbs_room OK
moodle23.mdl_block_objectives OK
moodle23.mdl_block_objectives_objectives OK
moodle23.mdl_block_objectives_timetable OK
moodle23.mdl_block_positions OK
moodle23.mdl_block_rss_client OK
moodle23.mdl_blog_association OK
moodle23.mdl_blog_external OK
moodle23.mdl_book OK
moodle23.mdl_book_chapters OK
moodle23.mdl_cache_filters OK
moodle23.mdl_cache_flags OK
moodle23.mdl_cache_text OK
moodle23.mdl_capabilities OK
moodle23.mdl_chat OK
moodle23.mdl_chat_messages OK
moodle23.mdl_chat_messages_current OK
moodle23.mdl_chat_users OK
moodle23.mdl_choice OK
moodle23.mdl_choice_answers OK
moodle23.mdl_choice_options OK
moodle23.mdl_choicegroup OK
moodle23.mdl_choicegroup_options OK
moodle23.mdl_cohort OK
moodle23.mdl_cohort_members OK
moodle23.mdl_comments OK
moodle23.mdl_config OK
moodle23.mdl_config_log OK
moodle23.mdl_config_plugins OK
moodle23.mdl_context OK
moodle23.mdl_context_temp OK
moodle23.mdl_course OK
moodle23.mdl_course_categories OK
moodle23.mdl_course_completion_aggr_methd OK
moodle23.mdl_course_completion_crit_compl OK
moodle23.mdl_course_completion_criteria OK
moodle23.mdl_course_completion_notify OK
moodle23.mdl_course_completions OK
moodle23.mdl_course_modules OK
moodle23.mdl_course_modules_availability OK
moodle23.mdl_course_modules_completion OK
moodle23.mdl_course_published OK
moodle23.mdl_course_request OK
moodle23.mdl_course_sections OK
moodle23.mdl_course_sections_availability OK
moodle23.mdl_data OK
moodle23.mdl_data_content OK
moodle23.mdl_data_fields OK
moodle23.mdl_data_records OK
moodle23.mdl_enrol OK
moodle23.mdl_enrol_authorize OK
moodle23.mdl_enrol_authorize_refunds OK
moodle23.mdl_enrol_flatfile OK
moodle23.mdl_enrol_paypal OK
moodle23.mdl_event OK
moodle23.mdl_events_handlers OK
moodle23.mdl_events_queue OK
moodle23.mdl_events_queue_handlers OK
moodle23.mdl_external_functions OK
moodle23.mdl_external_services OK
moodle23.mdl_external_services_functions OK
moodle23.mdl_external_services_users OK
moodle23.mdl_external_tokens OK
moodle23.mdl_feedback OK
moodle23.mdl_feedback_completed OK
moodle23.mdl_feedback_completedtmp OK
moodle23.mdl_feedback_item OK
moodle23.mdl_feedback_sitecourse_map OK
moodle23.mdl_feedback_template OK
moodle23.mdl_feedback_tracking OK
moodle23.mdl_feedback_value OK
moodle23.mdl_feedback_valuetmp OK
moodle23.mdl_files OK
moodle23.mdl_files_reference OK
moodle23.mdl_filter_active OK
moodle23.mdl_filter_config OK
moodle23.mdl_folder OK
moodle23.mdl_forum OK
moodle23.mdl_forum_discussions OK
moodle23.mdl_forum_posts OK
moodle23.mdl_forum_queue OK
moodle23.mdl_forum_read OK
moodle23.mdl_forum_subscriptions OK
moodle23.mdl_forum_track_prefs OK
moodle23.mdl_glossary OK
moodle23.mdl_glossary_alias OK
moodle23.mdl_glossary_categories OK
moodle23.mdl_glossary_entries OK
moodle23.mdl_glossary_entries_categories OK
moodle23.mdl_glossary_formats OK
moodle23.mdl_grade_categories OK
moodle23.mdl_grade_categories_history OK
moodle23.mdl_grade_grades OK
moodle23.mdl_grade_grades_history OK
moodle23.mdl_grade_import_newitem OK
moodle23.mdl_grade_import_values OK
moodle23.mdl_grade_items OK
moodle23.mdl_grade_items_history OK
moodle23.mdl_grade_letters OK
moodle23.mdl_grade_outcomes OK
moodle23.mdl_grade_outcomes_courses OK
moodle23.mdl_grade_outcomes_history OK
moodle23.mdl_grade_settings OK
moodle23.mdl_grading_areas OK
moodle23.mdl_grading_definitions OK
moodle23.mdl_grading_instances OK
moodle23.mdl_gradingform_guide_comments OK
moodle23.mdl_gradingform_guide_criteria OK
moodle23.mdl_gradingform_guide_fillings OK
moodle23.mdl_gradingform_rubric_criteria OK
moodle23.mdl_gradingform_rubric_fillings OK
moodle23.mdl_gradingform_rubric_levels OK
moodle23.mdl_groupings OK
moodle23.mdl_groupings_groups OK
moodle23.mdl_groups OK
moodle23.mdl_groups_members OK
moodle23.mdl_hotpot OK
moodle23.mdl_hotpot_attempts OK
moodle23.mdl_hotpot_cache OK
moodle23.mdl_hotpot_details OK
moodle23.mdl_hotpot_questions OK
moodle23.mdl_hotpot_responses OK
moodle23.mdl_hotpot_strings OK
moodle23.mdl_imscp OK
moodle23.mdl_label OK
moodle23.mdl_lesson OK
moodle23.mdl_lesson_answers OK
moodle23.mdl_lesson_attempts OK
moodle23.mdl_lesson_branch OK
moodle23.mdl_lesson_grades OK
moodle23.mdl_lesson_high_scores OK
moodle23.mdl_lesson_pages OK
moodle23.mdl_lesson_timer OK
moodle23.mdl_license OK
moodle23.mdl_log OK
moodle23.mdl_log_display OK
moodle23.mdl_log_queries OK
moodle23.mdl_lti OK
moodle23.mdl_lti_submission OK
moodle23.mdl_lti_types OK
moodle23.mdl_lti_types_config OK
moodle23.mdl_message OK
moodle23.mdl_message_contacts OK
moodle23.mdl_message_processors OK
moodle23.mdl_message_providers OK
moodle23.mdl_message_read OK
moodle23.mdl_message_working OK
moodle23.mdl_mnet_application OK
moodle23.mdl_mnet_host OK
moodle23.mdl_mnet_host2service OK
moodle23.mdl_mnet_log OK
moodle23.mdl_mnet_remote_rpc OK
moodle23.mdl_mnet_remote_service2rpc OK
moodle23.mdl_mnet_rpc OK
moodle23.mdl_mnet_service OK
moodle23.mdl_mnet_service2rpc OK
moodle23.mdl_mnet_session OK
moodle23.mdl_mnet_sso_access_control OK
moodle23.mdl_mnetservice_enrol_courses OK
moodle23.mdl_mnetservice_enrol_enrolments OK
moodle23.mdl_modules OK
moodle23.mdl_my_pages OK
moodle23.mdl_openmeetings OK
moodle23.mdl_page OK
moodle23.mdl_portfolio_instance OK
moodle23.mdl_portfolio_instance_config OK
moodle23.mdl_portfolio_instance_user OK
moodle23.mdl_portfolio_log OK
moodle23.mdl_portfolio_mahara_queue OK
moodle23.mdl_portfolio_tempdata OK
moodle23.mdl_post OK
moodle23.mdl_profiling OK
moodle23.mdl_qtype_algebra_options OK
moodle23.mdl_qtype_algebra_variables OK
moodle23.mdl_qtype_essay_options OK
moodle23.mdl_qtype_preg OK
moodle23.mdl_question OK
moodle23.mdl_question_answers OK
moodle23.mdl_question_attempt_step_data OK
moodle23.mdl_question_attempt_steps OK
moodle23.mdl_question_attempts OK
moodle23.mdl_question_calculated OK
moodle23.mdl_question_calculated_options OK
moodle23.mdl_question_categories OK
moodle23.mdl_question_dataset_definitions OK
moodle23.mdl_question_dataset_items OK
moodle23.mdl_question_datasets OK
moodle23.mdl_question_formulas OK
moodle23.mdl_question_formulas_answers OK
moodle23.mdl_question_hints OK
moodle23.mdl_question_match OK
moodle23.mdl_question_match_sub OK
moodle23.mdl_question_multianswer OK
moodle23.mdl_question_multichoice OK
moodle23.mdl_question_multinumerical OK
moodle23.mdl_question_numerical OK
moodle23.mdl_question_numerical_options OK
moodle23.mdl_question_numerical_units OK
moodle23.mdl_question_randomsamatch OK
moodle23.mdl_question_script OK
moodle23.mdl_question_sessions OK
moodle23.mdl_question_shortanswer OK
moodle23.mdl_question_states OK
moodle23.mdl_question_truefalse OK
moodle23.mdl_question_usages OK
moodle23.mdl_quiz OK
moodle23.mdl_quiz_attempts OK
moodle23.mdl_quiz_feedback OK
moodle23.mdl_quiz_grades OK
moodle23.mdl_quiz_overrides OK
moodle23.mdl_quiz_overview_regrades OK
moodle23.mdl_quiz_question_instances OK
moodle23.mdl_quiz_question_response_stats OK
moodle23.mdl_quiz_question_statistics OK
moodle23.mdl_quiz_reports OK
moodle23.mdl_quiz_statistics OK
moodle23.mdl_rating OK
moodle23.mdl_registration_hubs OK
moodle23.mdl_report_customsql_queries OK
moodle23.mdl_repository OK
moodle23.mdl_repository_instance_config OK
moodle23.mdl_repository_instances OK
moodle23.mdl_resource OK
moodle23.mdl_resource_old OK
moodle23.mdl_role OK
moodle23.mdl_role_allow_assign OK
moodle23.mdl_role_allow_override OK
moodle23.mdl_role_allow_switch OK
moodle23.mdl_role_assignments OK
moodle23.mdl_role_capabilities OK
moodle23.mdl_role_context_levels OK
moodle23.mdl_role_names OK
moodle23.mdl_role_sortorder OK
moodle23.mdl_scale OK
moodle23.mdl_scale_history OK
moodle23.mdl_scorm OK
moodle23.mdl_scorm_aicc_session OK
moodle23.mdl_scorm_scoes OK
moodle23.mdl_scorm_scoes_data OK
moodle23.mdl_scorm_scoes_track OK
moodle23.mdl_scorm_seq_mapinfo OK
moodle23.mdl_scorm_seq_objective OK
moodle23.mdl_scorm_seq_rolluprule OK
moodle23.mdl_scorm_seq_rolluprulecond OK
moodle23.mdl_scorm_seq_rulecond OK
moodle23.mdl_scorm_seq_ruleconds OK
moodle23.mdl_sessions OK
moodle23.mdl_stats_daily OK
moodle23.mdl_stats_monthly OK
moodle23.mdl_stats_user_daily OK
moodle23.mdl_stats_user_monthly OK
moodle23.mdl_stats_user_weekly OK
moodle23.mdl_stats_weekly OK
moodle23.mdl_survey OK
moodle23.mdl_survey_analysis OK
moodle23.mdl_survey_answers OK
moodle23.mdl_survey_questions OK
moodle23.mdl_tag OK
moodle23.mdl_tag_correlation OK
moodle23.mdl_tag_instance OK
moodle23.mdl_timezone OK
moodle23.mdl_tool_customlang OK
moodle23.mdl_tool_customlang_components OK
moodle23.mdl_tutorship OK
moodle23.mdl_tutorship_configs OK
moodle23.mdl_tutorship_periods OK
moodle23.mdl_tutorship_reserves OK
moodle23.mdl_tutorship_timeslots OK
moodle23.mdl_tutorship_timetables OK
moodle23.mdl_upgrade_log OK
moodle23.mdl_url OK
moodle23.mdl_user OK
moodle23.mdl_user_enrolments OK
mysqlcheck: Got error: 1102: Incorrect database name '#mysql50#moodle23.20130903' when selecting the database
moodle23.mdl_user_info_category OK
moodle23.mdl_user_info_data OK
moodle23.mdl_user_info_field OK
moodle23.mdl_user_lastaccess OK
moodle23.mdl_user_preferences OK
moodle23.mdl_user_private_key OK
moodle23.mdl_webdav_locks OK
moodle23.mdl_wiki OK
moodle23.mdl_wiki_links OK
moodle23.mdl_wiki_locks OK
moodle23.mdl_wiki_pages OK
moodle23.mdl_wiki_subwikis OK
moodle23.mdl_wiki_synonyms OK
moodle23.mdl_wiki_versions OK
moodle23.mdl_wiziq OK
moodle23.mdl_wiziq_content OK
moodle23.mdl_workshop OK
moodle23.mdl_workshop_aggregations OK
moodle23.mdl_workshop_assessments OK
moodle23.mdl_workshop_assessments_old OK
moodle23.mdl_workshop_comments_old OK
moodle23.mdl_workshop_elements_old OK
moodle23.mdl_workshop_grades OK
moodle23.mdl_workshop_grades_old OK
moodle23.mdl_workshop_old OK
moodle23.mdl_workshop_rubrics_old OK
moodle23.mdl_workshop_stockcomments_old OK
moodle23.mdl_workshop_submissions OK
moodle23.mdl_workshop_submissions_old OK
moodle23.mdl_workshopallocation_scheduled OK
moodle23.mdl_workshopeval_best_settings OK
moodle23.mdl_workshopform_accumulative OK
moodle23.mdl_workshopform_comments OK
moodle23.mdl_workshopform_numerrors OK
moodle23.mdl_workshopform_numerrors_map OK
moodle23.mdl_workshopform_rubric OK
moodle23.mdl_workshopform_rubric_config OK
moodle23.mdl_workshopform_rubric_levels OK
FATAL ERROR: Upgrade failed
[root@moodle mysql]# mv moodle23.20130903 /var/www/moodledata23/
[root@moodle mysql]# rmdir lost+found/
[root@moodle mysql]# mysql_upgrade -uroot -pns2J*zFG
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments
Running 'mysqlcheck with default connection arguments
moodle23.mdl_assign OK
moodle23.mdl_assign_grades OK
moodle23.mdl_assign_plugin_config OK
moodle23.mdl_assign_submission OK
moodle23.mdl_assignfeedback_comments OK
moodle23.mdl_assignfeedback_file OK
moodle23.mdl_assignsubmission_file OK
moodle23.mdl_assignsubmission_onlinetext OK
moodle23.mdl_attendance_log OK
moodle23.mdl_attendance_sessions OK
moodle23.mdl_attendance_statuses OK
moodle23.mdl_attforblock OK
moodle23.mdl_backup_controllers OK
moodle23.mdl_backup_courses OK
moodle23.mdl_backup_files_template OK
moodle23.mdl_backup_ids_template OK
moodle23.mdl_backup_logs OK
moodle23.mdl_block OK
moodle23.mdl_block_community OK
moodle23.mdl_block_configurable_reports OK
moodle23.mdl_block_formal_langs OK
moodle23.mdl_block_formal_langs_node_dscr OK
moodle23.mdl_block_gchat_messages OK
moodle23.mdl_block_gchat_sessions OK
moodle23.mdl_block_gchat_user_sessions OK
moodle23.mdl_block_gchat_users OK
moodle23.mdl_block_instances OK
moodle23.mdl_block_mrbs_area OK
moodle23.mdl_block_mrbs_entry OK
moodle23.mdl_block_mrbs_repeat OK
moodle23.mdl_block_mrbs_room OK
moodle23.mdl_block_objectives OK
moodle23.mdl_block_objectives_objectives OK
moodle23.mdl_block_objectives_timetable OK
moodle23.mdl_block_positions OK
moodle23.mdl_block_rss_client OK
moodle23.mdl_blog_association OK
moodle23.mdl_blog_external OK
moodle23.mdl_book OK
moodle23.mdl_book_chapters OK
moodle23.mdl_cache_filters OK
moodle23.mdl_cache_flags OK
moodle23.mdl_cache_text OK
moodle23.mdl_capabilities OK
moodle23.mdl_chat OK
moodle23.mdl_chat_messages OK
moodle23.mdl_chat_messages_current OK
moodle23.mdl_chat_users OK
moodle23.mdl_choice OK
moodle23.mdl_choice_answers OK
moodle23.mdl_choice_options OK
moodle23.mdl_choicegroup OK
moodle23.mdl_choicegroup_options OK
moodle23.mdl_cohort OK
moodle23.mdl_cohort_members OK
moodle23.mdl_comments OK
moodle23.mdl_config OK
moodle23.mdl_config_log OK
moodle23.mdl_config_plugins OK
moodle23.mdl_context OK
moodle23.mdl_context_temp OK
moodle23.mdl_course OK
moodle23.mdl_course_categories OK
moodle23.mdl_course_completion_aggr_methd OK
moodle23.mdl_course_completion_crit_compl OK
moodle23.mdl_course_completion_criteria OK
moodle23.mdl_course_completion_notify OK
moodle23.mdl_course_completions OK
moodle23.mdl_course_modules OK
moodle23.mdl_course_modules_availability OK
moodle23.mdl_course_modules_completion OK
moodle23.mdl_course_published OK
moodle23.mdl_course_request OK
moodle23.mdl_course_sections OK
moodle23.mdl_course_sections_availability OK
moodle23.mdl_data OK
moodle23.mdl_data_content OK
moodle23.mdl_data_fields OK
moodle23.mdl_data_records OK
moodle23.mdl_enrol OK
moodle23.mdl_enrol_authorize OK
moodle23.mdl_enrol_authorize_refunds OK
moodle23.mdl_enrol_flatfile OK
moodle23.mdl_enrol_paypal OK
moodle23.mdl_event OK
moodle23.mdl_events_handlers OK
moodle23.mdl_events_queue OK
moodle23.mdl_events_queue_handlers OK
moodle23.mdl_external_functions OK
moodle23.mdl_external_services OK
moodle23.mdl_external_services_functions OK
moodle23.mdl_external_services_users OK
moodle23.mdl_external_tokens OK
moodle23.mdl_feedback OK
moodle23.mdl_feedback_completed OK
moodle23.mdl_feedback_completedtmp OK
moodle23.mdl_feedback_item OK
moodle23.mdl_feedback_sitecourse_map OK
moodle23.mdl_feedback_template OK
moodle23.mdl_feedback_tracking OK
moodle23.mdl_feedback_value OK
moodle23.mdl_feedback_valuetmp OK
moodle23.mdl_files OK
moodle23.mdl_files_reference OK
moodle23.mdl_filter_active OK
moodle23.mdl_filter_config OK
moodle23.mdl_folder OK
moodle23.mdl_forum OK
moodle23.mdl_forum_discussions OK
moodle23.mdl_forum_posts OK
moodle23.mdl_forum_queue OK
moodle23.mdl_forum_read OK
moodle23.mdl_forum_subscriptions OK
moodle23.mdl_forum_track_prefs OK
moodle23.mdl_glossary OK
moodle23.mdl_glossary_alias OK
moodle23.mdl_glossary_categories OK
moodle23.mdl_glossary_entries OK
moodle23.mdl_glossary_entries_categories OK
moodle23.mdl_glossary_formats OK
moodle23.mdl_grade_categories OK
moodle23.mdl_grade_categories_history OK
moodle23.mdl_grade_grades OK
moodle23.mdl_grade_grades_history OK
moodle23.mdl_grade_import_newitem OK
moodle23.mdl_grade_import_values OK
moodle23.mdl_grade_items OK
moodle23.mdl_grade_items_history OK
moodle23.mdl_grade_letters OK
moodle23.mdl_grade_outcomes OK
moodle23.mdl_grade_outcomes_courses OK
moodle23.mdl_grade_outcomes_history OK
moodle23.mdl_grade_settings OK
moodle23.mdl_grading_areas OK
moodle23.mdl_grading_definitions OK
moodle23.mdl_grading_instances OK
moodle23.mdl_gradingform_guide_comments OK
moodle23.mdl_gradingform_guide_criteria OK
moodle23.mdl_gradingform_guide_fillings OK
moodle23.mdl_gradingform_rubric_criteria OK
moodle23.mdl_gradingform_rubric_fillings OK
moodle23.mdl_gradingform_rubric_levels OK
moodle23.mdl_groupings OK
moodle23.mdl_groupings_groups OK
moodle23.mdl_groups OK
moodle23.mdl_groups_members OK
moodle23.mdl_hotpot OK
moodle23.mdl_hotpot_attempts OK
moodle23.mdl_hotpot_cache OK
moodle23.mdl_hotpot_details OK
moodle23.mdl_hotpot_questions OK
moodle23.mdl_hotpot_responses OK
moodle23.mdl_hotpot_strings OK
moodle23.mdl_imscp OK
moodle23.mdl_label OK
moodle23.mdl_lesson OK
moodle23.mdl_lesson_answers OK
moodle23.mdl_lesson_attempts OK
moodle23.mdl_lesson_branch OK
moodle23.mdl_lesson_grades OK
moodle23.mdl_lesson_high_scores OK
moodle23.mdl_lesson_pages OK
moodle23.mdl_lesson_timer OK
moodle23.mdl_license OK
moodle23.mdl_log OK
moodle23.mdl_log_display OK
moodle23.mdl_log_queries OK
moodle23.mdl_lti OK
moodle23.mdl_lti_submission OK
moodle23.mdl_lti_types OK
moodle23.mdl_lti_types_config OK
moodle23.mdl_message OK
moodle23.mdl_message_contacts OK
moodle23.mdl_message_processors OK
moodle23.mdl_message_providers OK
moodle23.mdl_message_read OK
moodle23.mdl_message_working OK
moodle23.mdl_mnet_application OK
moodle23.mdl_mnet_host OK
moodle23.mdl_mnet_host2service OK
moodle23.mdl_mnet_log OK
moodle23.mdl_mnet_remote_rpc OK
moodle23.mdl_mnet_remote_service2rpc OK
moodle23.mdl_mnet_rpc OK
moodle23.mdl_mnet_service OK
moodle23.mdl_mnet_service2rpc OK
moodle23.mdl_mnet_session OK
moodle23.mdl_mnet_sso_access_control OK
moodle23.mdl_mnetservice_enrol_courses OK
moodle23.mdl_mnetservice_enrol_enrolments OK
moodle23.mdl_modules OK
moodle23.mdl_my_pages OK
moodle23.mdl_openmeetings OK
moodle23.mdl_page OK
moodle23.mdl_portfolio_instance OK
moodle23.mdl_portfolio_instance_config OK
moodle23.mdl_portfolio_instance_user OK
moodle23.mdl_portfolio_log OK
moodle23.mdl_portfolio_mahara_queue OK
moodle23.mdl_portfolio_tempdata OK
moodle23.mdl_post OK
moodle23.mdl_profiling OK
moodle23.mdl_qtype_algebra_options OK
moodle23.mdl_qtype_algebra_variables OK
moodle23.mdl_qtype_essay_options OK
moodle23.mdl_qtype_preg OK
moodle23.mdl_question OK
moodle23.mdl_question_answers OK
moodle23.mdl_question_attempt_step_data OK
moodle23.mdl_question_attempt_steps OK
moodle23.mdl_question_attempts OK
moodle23.mdl_question_calculated OK
moodle23.mdl_question_calculated_options OK
moodle23.mdl_question_categories OK
moodle23.mdl_question_dataset_definitions OK
moodle23.mdl_question_dataset_items OK
moodle23.mdl_question_datasets OK
moodle23.mdl_question_formulas OK
moodle23.mdl_question_formulas_answers OK
moodle23.mdl_question_hints OK
moodle23.mdl_question_match OK
moodle23.mdl_question_match_sub OK
moodle23.mdl_question_multianswer OK
moodle23.mdl_question_multichoice OK
moodle23.mdl_question_multinumerical OK
moodle23.mdl_question_numerical OK
moodle23.mdl_question_numerical_options OK
moodle23.mdl_question_numerical_units OK
moodle23.mdl_question_randomsamatch OK
moodle23.mdl_question_script OK
moodle23.mdl_question_sessions OK
moodle23.mdl_question_shortanswer OK
moodle23.mdl_question_states OK
moodle23.mdl_question_truefalse OK
moodle23.mdl_question_usages OK
moodle23.mdl_quiz OK
moodle23.mdl_quiz_attempts OK
moodle23.mdl_quiz_feedback OK
moodle23.mdl_quiz_grades OK
moodle23.mdl_quiz_overrides OK
moodle23.mdl_quiz_overview_regrades OK
moodle23.mdl_quiz_question_instances OK
moodle23.mdl_quiz_question_response_stats OK
moodle23.mdl_quiz_question_statistics OK
moodle23.mdl_quiz_reports OK
moodle23.mdl_quiz_statistics OK
moodle23.mdl_rating OK
moodle23.mdl_registration_hubs OK
moodle23.mdl_report_customsql_queries OK
moodle23.mdl_repository OK
moodle23.mdl_repository_instance_config OK
moodle23.mdl_repository_instances OK
moodle23.mdl_resource OK
moodle23.mdl_resource_old OK
moodle23.mdl_role OK
moodle23.mdl_role_allow_assign OK
moodle23.mdl_role_allow_override OK
moodle23.mdl_role_allow_switch OK
moodle23.mdl_role_assignments OK
moodle23.mdl_role_capabilities OK
moodle23.mdl_role_context_levels OK
moodle23.mdl_role_names OK
moodle23.mdl_role_sortorder OK
moodle23.mdl_scale OK
moodle23.mdl_scale_history OK
moodle23.mdl_scorm OK
moodle23.mdl_scorm_aicc_session OK
moodle23.mdl_scorm_scoes OK
moodle23.mdl_scorm_scoes_data OK
moodle23.mdl_scorm_scoes_track OK
moodle23.mdl_scorm_seq_mapinfo OK
moodle23.mdl_scorm_seq_objective OK
moodle23.mdl_scorm_seq_rolluprule OK
moodle23.mdl_scorm_seq_rolluprulecond OK
moodle23.mdl_scorm_seq_rulecond OK
moodle23.mdl_scorm_seq_ruleconds OK
moodle23.mdl_sessions OK
moodle23.mdl_stats_daily OK
moodle23.mdl_stats_monthly OK
moodle23.mdl_stats_user_daily OK
moodle23.mdl_stats_user_monthly OK
moodle23.mdl_stats_user_weekly OK
moodle23.mdl_stats_weekly OK
moodle23.mdl_survey OK
moodle23.mdl_survey_analysis OK
moodle23.mdl_survey_answers OK
moodle23.mdl_survey_questions OK
moodle23.mdl_tag OK
moodle23.mdl_tag_correlation OK
moodle23.mdl_tag_instance OK
moodle23.mdl_timezone OK
moodle23.mdl_tool_customlang OK
moodle23.mdl_tool_customlang_components OK
moodle23.mdl_tutorship OK
moodle23.mdl_tutorship_configs OK
moodle23.mdl_tutorship_periods OK
moodle23.mdl_tutorship_reserves OK
moodle23.mdl_tutorship_timeslots OK
moodle23.mdl_tutorship_timetables OK
moodle23.mdl_upgrade_log OK
moodle23.mdl_url OK
moodle23.mdl_user OK
moodle23.mdl_user_enrolments OK
moodle23.mdl_user_info_category OK
moodle23.mdl_user_info_data OK
moodle23.mdl_user_info_field OK
moodle23.mdl_user_lastaccess OK
moodle23.mdl_user_preferences OK
moodle23.mdl_user_private_key OK
moodle23.mdl_webdav_locks OK
moodle23.mdl_wiki OK
moodle23.mdl_wiki_links OK
moodle23.mdl_wiki_locks OK
moodle23.mdl_wiki_pages OK
moodle23.mdl_wiki_subwikis OK
moodle23.mdl_wiki_synonyms OK
moodle23.mdl_wiki_versions OK
moodle23.mdl_wiziq OK
moodle23.mdl_wiziq_content OK
moodle23.mdl_workshop OK
moodle23.mdl_workshop_aggregations OK
moodle23.mdl_workshop_assessments OK
moodle23.mdl_workshop_assessments_old OK
moodle23.mdl_workshop_comments_old OK
moodle23.mdl_workshop_elements_old OK
moodle23.mdl_workshop_grades OK
moodle23.mdl_workshop_grades_old OK
moodle23.mdl_workshop_old OK
moodle23.mdl_workshop_rubrics_old OK
moodle23.mdl_workshop_stockcomments_old OK
moodle23.mdl_workshop_submissions OK
moodle23.mdl_workshop_submissions_old OK
moodle23.mdl_workshopallocation_scheduled OK
moodle23.mdl_workshopeval_best_settings OK
moodle23.mdl_workshopform_accumulative OK
moodle23.mdl_workshopform_comments OK
moodle23.mdl_workshopform_numerrors OK
moodle23.mdl_workshopform_numerrors_map OK
moodle23.mdl_workshopform_rubric OK
moodle23.mdl_workshopform_rubric_config OK
moodle23.mdl_workshopform_rubric_levels OK
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.general_log OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.servers OK
mysql.slow_log OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
Running 'mysql_fix_privilege_tables'...
OK
[root@moodle mysql]# mysqldump -uroot -pns2J*zFG --quick --force --routines --add-drop-database --all-databases --add-drop-table > /mnt/mobackup/mysqldump20180612.sql
-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.