next up previous contents
Next: 問題解決 Up: 其他小修改 Previous: 目錄檔案瀏覧   Contents

ibdata1 過大

  1. moodle 2.3 版中的目錄檔案瀏覧,使用者無法更動其排序方式,預設順序為 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.
    


2018-08-14