Portál AbcLinuxu, 24. dubna 2024 06:49
$ mysql -u root -p
Tak mi sice tabulky zobrazí:
mysql> use databaze;
mysql> show tables;
Ale při pokusu o načtení
SELECT * FROM table_name;
vrátí chybu:
ERROR 1146 (42S02): Table 'moodle.mdl_user' doesn't exist
Chybu vrací i pokus o zálohu:
mysqldump -u root -p moodle > /kam/to/chci/moodle.sql
mysqldump: Got error: 1146: Table 'moodle.mdl_assign' doesn't exist when using LOCK TABLES
Ještě jsem zjistil, že disk byl po onom restartu zcela zaplněn, ale ani po uvolnění místa a restartu mysql se problém nevyřešil...
Prosím.. poraďte co se s tím dá dělat - ty weby musím co v nejkratším čase zprovoznit.
Na webu jsem našel nějaká řešení typu vymazat adresář s databází a soubory ib_logfile, ale nechci udělat nějakou hloupost. Nejsem přes databáze odborník, tak vás moc prosím o shovívavost...
Všem moc děkuji!
20.2.2017 12:16
kozzi | skóre: 55
| blog: vse_o_vsem
| Pacman (Bratrušov)
Tak to cele obnov ze zaloh. To vypada ze se ti poskodily data.
nebojte, to spravite
Děkuji vám za odpovědi.
V právech by to být nemělo, odpovídá nastavení:server:/var/lib/mysql # ls -lh total 176M -rw-rw---- 1 mysql mysql 56 Jan 22 2015 auto.cnf drwx------ 2 mysql mysql 4.0K Nov 22 12:23 drupal_afnet drwx------ 2 mysql mysql 12K Feb 14 17:43 drupal_kef drwx------ 2 mysql mysql 4.0K Jun 24 2016 exstres -rw-rw---- 1 mysql mysql 48M Feb 20 15:14 ib_logfile0 -rw-rw---- 1 mysql mysql 48M Feb 20 14:56 ib_logfile1 -rw-rw---- 1 mysql mysql 12M Feb 20 15:14 ibdata1 drwx------ 2 mysql mysql 4.0K Dec 13 2013 luxcal drwx------ 2 mysql mysql 36K Feb 9 12:52 moodle drwx------ 2 mysql mysql 4.0K Mar 3 2016 mrbs drwxrwx--- 2 mysql mysql 4.0K Jun 20 2016 mysql -rw-r--r-- 1 mysql mysql 3 Jun 20 2016 mysql_upgrade_info drwx------ 2 mysql mysql 4.0K May 20 2013 openmeetings drwx------ 2 mysql mysql 4.0K Jun 20 2016 performance_schema drwx------ 2 mysql mysql 4.0K Jan 12 2014 pokusy drwx------ 2 mysql mysql 4.0K Nov 14 2013 postfix -rw-r----- 1 mysql mysql 68M Jun 20 2016 server.err -rw-rw---- 1 mysql mysql 6 Feb 20 15:14 server.pid drwx------ 2 mysql mysql 4.0K Nov 6 2013 squirrelmail drwx------ 2 root root 4.0K Feb 20 15:11 test
Jestli máte na mysli /var/lib/mysql/mysql tak její tabulky vidí i PhpMyAdmin, takže jsou nejspíš v pořádku.
Nevidí hlavně ty "Drupalovské" a Moodle, což je nejhorší.Ty odkazy jsem si prošel a některé tipy i vyzkoušel bez valného úspěchu.
Ve výše uvedeném odkaze je ještě postup, který bych rád vyzkoušel, ale nerozumím přesně bodu 2:
1. should copy the mysql data folder (/var/lib/mysql -- linux OR C:\ProgramData\MySQL\MySQL Server 5.1\data -- windows)
2. in the new server stop the mysql and paste all the folders pertaining to different databases , except the main "mysql" database.
3. make sure to copy and paste "ibdata1" file from the backed up folder into the new server "mysql data folder".
4. make sure to give permission to "mysql" user for that file (windows user need not worry).
5. restart mysql you should be able to see all the backed up databases correctly configured , and you should be able to access the table data without getting that error (1146).
server:/media/Data/ftp/Upload # ls -lh total 424M -rw-rw---- 1 mysql mysql 61 Jan 28 2013 db.opt -rw-rw---- 1 mysql mysql 9.9K Aug 30 2015 mdl_assign.frm -rw-rw---- 1 mysql mysql 400K Feb 14 19:21 mdl_assign.ibd -rw-rw---- 1 mysql mysql 8.7K Aug 30 2015 mdl_assign_grades.frm -rw-rw---- 1 mysql mysql 432K Oct 19 19:00 mdl_assign_grades.ibd -rw-rw---- 1 mysql mysql 8.7K Jan 31 14:51 mdl_assign_overrides.frm -rw-rw---- 1 mysql mysql 144K Jan 31 14:52 mdl_assign_overrides.ibd -rw-rw---- 1 mysql mysql 8.6K Aug 30 2015 mdl_assign_plugin_config.frm -rw-rw---- 1 mysql mysql 544K Feb 14 19:14 mdl_assign_plugin_config.ibd -rw-rw---- 1 mysql mysql 8.7K Aug 30 2015 mdl_assign_submission.frm -rw-rw---- 1 mysql mysql 784K Feb 17 08:15 mdl_assign_submission.ibd -rw-rw---- 1 mysql mysql 8.7K Aug 30 2015 mdl_assign_user_flags.frm -rw-rw---- 1 mysql mysql 288K Feb 13 08:00 mdl_assign_user_flags.ibd -rw-rw---- 1 mysql mysql 8.5K Aug 30 2015 mdl_assign_user_mapping.frm -rw-rw---- 1 mysql mysql 512K Feb 13 08:00 mdl_assign_user_mapping.ibd -rw-rw---- 1 mysql mysql 8.6K Aug 30 2015 mdl_assignfeedback_comments.frm -rw-rw---- 1 mysql mysql 368K Sep 3 18:30 mdl_assignfeedback_comments.ibd -rw-rw---- 1 mysql mysql 8.7K Aug 30 2015 mdl_assignfeedback_editpdf_annot.frm -rw-rw---- 1 mysql mysql 128K Aug 30 2015 mdl_assignfeedback_editpdf_annot.ibd -rw-rw---- 1 mysql mysql 8.7K Aug 30 2015 mdl_assignfeedback_editpdf_cmnt.frm -rw-rw---- 1 mysql mysql 128K Aug 30 2015 mdl_assignfeedback_editpdf_cmnt.ibd -rw-rw---- 1 mysql mysql 8.5K Jul 11 2016 mdl_assignfeedback_editpdf_queue.frm -rw-rw---- 1 mysql mysql 96K Oct 19 19:00 mdl_assignfeedback_editpdf_queue.ibd -rw-rw---- 1 mysql mysql 8.5K Aug 30 2015 mdl_assignfeedback_editpdf_quick.frm -rw-rw---- 1 mysql mysql 112K Aug 30 2015 mdl_assignfeedback_editpdf_quick.ibd -rw-rw---- 1 mysql mysql 8.5K Aug 30 2015 mdl_assignfeedback_file.frm -rw-rw---- 1 mysql mysql 128K Aug 31 17:13 mdl_assignfeedback_file.ibd -rw-rw---- 1 mysql mysql 9.1K Jul 11 2016 mdl_assignment.frm -rw-rw---- 1 mysql mysql 112K Jul 11 2016 mdl_assignment.ibd -rw-rw---- 1 mysql mysql 8.9K Jul 11 2016 mdl_assignment_submissions.frm -rw-rw---- 1 mysql mysql 160K Jul 11 2016 mdl_assignment_submissions.ibd -rw-rw---- 1 mysql mysql 8.6K Jul 11 2016 mdl_assignment_upgrade.frm -rw-rw---- 1 mysql mysql 128K Jul 11 2016 mdl_assignment_upgrade.ibd -rw-rw---- 1 mysql mysql 8.5K Aug 30 2015 mdl_assignsubmission_file.frm -rw-rw---- 1 mysql mysql 320K Feb 13 08:00 mdl_assignsubmission_file.ibd -rw-rw---- 1 mysql mysql 8.6K Aug 30 2015 mdl_assignsubmission_onlinetext.frm -rw-rw---- 1 mysql mysql 128K Aug 30 2015 mdl_assignsubmission_onlinetext.ibd -rw-rw---- 1 mysql mysql 9.0K Aug 30 2015 mdl_backup_controllers.frm -rw-rw---- 1 mysql mysql 9.0M Feb 17 01:00 mdl_backup_controllers.ibd -rw-rw---- 1 mysql mysql 8.6K Aug 30 2015 mdl_backup_courses.frm -rw-rw---- 1 mysql mysql 112K Feb 17 09:00 mdl_backup_courses.ibd -rw-rw---- 1 mysql mysql 8.6K Aug 30 2015 mdl_backup_logs.frm -rw-rw---- 1 mysql mysql 36M Feb 17 01:00 mdl_backup_logs.ibd -rw-rw---- 1 mysql mysql 14K Aug 30 2015 mdl_badge.frm -rw-rw---- 1 mysql mysql 160K Aug 30 2015 mdl_badge.ibd -rw-rw---- 1 mysql mysql 8.6K Aug 30 2015 mdl_badge_backpack.frm -rw-rw---- 1 mysql mysql 112K Aug 30 2015 mdl_badge_backpack.ibd -rw-rw---- 1 mysql mysql 8.6K Aug 30 2015 mdl_badge_criteria.frm -rw-rw---- 1 mysql mysql 144K Aug 30 2015 mdl_badge_criteria.ibd -rw-rw---- 1 mysql mysql 8.5K Aug 30 2015 mdl_badge_criteria_met.frm -rw-rw---- 1 mysql mysql 144K Aug 30 2015 mdl_badge_criteria_met.ibd -rw-rw---- 1 mysql mysql 8.5K Aug 30 2015 mdl_badge_criteria_param.frm -rw-rw---- 1 mysql mysql 112K Aug 30 2015 mdl_badge_criteria_param.ibd -rw-rw---- 1 mysql mysql 8.5K Aug 30 2015 mdl_badge_external.frm -rw-rw---- 1 mysql mysql 112K Aug 30 2015 mdl_badge_external.ibd -rw-rw---- 1 mysql mysql 8.7K Aug 30 2015 mdl_badge_issued.frm -rw-rw---- 1 mysql mysql 144K Aug 30 2015 mdl_badge_issued.ibd -rw-rw---- 1 mysql mysql 8.6K Aug 30 2015 mdl_badge_manual_award.frm -rw-rw---- 1 mysql mysql 160K Aug 30 2015 mdl_badge_manual_award.ibd -rw-rw---- 1 mysql mysql 8.5K Aug 30 2015 mdl_block.frm -rw-rw---- 1 mysql mysql 112K Feb 17 09:00 mdl_block.ibd -rw-rw---- 1 mysql mysql 8.6K Aug 30 2015 mdl_block_community.frm -rw-rw---- 1 mysql mysql 96K Aug 30 2015 mdl_block_community.ibd -rw-rw---- 1 mysql mysql 8.6K Feb 9 12:52 mdl_block_helpdesk_hd_user.frm -rw-rw---- 1 mysql mysql 128K Feb 9 12:55 mdl_block_helpdesk_hd_user.ibd -rw-rw---- 1 mysql mysql 8.6K Feb 9 12:52 mdl_block_helpdesk_status.frm -rw-rw---- 1 mysql mysql 96K Feb 9 12:54 mdl_block_helpdesk_status.ibd -rw-rw---- 1 mysql mysql 8.5K Feb 9 12:52 mdl_block_helpdesk_status_path.frm -rw-rw---- 1 mysql mysql 96K Feb 9 12:54 mdl_block_helpdesk_status_path.ibd -rw-rw---- 1 mysql mysql 8.8K Feb 9 12:52 mdl_block_helpdesk_ticket.frm -rw-rw---- 1 mysql mysql 144K Feb 9 12:52 mdl_block_helpdesk_ticket.ibd -rw-rw---- 1 mysql mysql 8.5K Feb 9 12:52 mdl_block_helpdesk_ticket_assign.frm -rw-rw---- 1 mysql mysql 128K Feb 9 12:52 mdl_block_helpdesk_ticket_assign.ibd -rw-rw---- 1 mysql mysql 8.5K Feb 9 12:52 mdl_block_helpdesk_ticket_tag.frm -rw-rw---- 1 mysql mysql 112K Feb 9 12:52 mdl_block_helpdesk_ticket_tag.ibd -rw-rw---- 1 mysql mysql 8.8K Feb 9 12:52 mdl_block_helpdesk_ticket_update.frm -rw-rw---- 1 mysql mysql 112K Feb 9 12:52 mdl_block_helpdesk_ticket_update.ibd -rw-rw---- 1 mysql mysql 8.6K Feb 9 12:52 mdl_block_helpdesk_watcher.frm -rw-rw---- 1 mysql mysql 144K Feb 9 12:52 mdl_block_helpdesk_watcher.ibd -rw-rw---- 1 mysql mysql 8.8K Jan 31 14:51 mdl_block_instances.frm -rw-rw---- 1 mysql mysql 128K Feb 14 16:24 mdl_block_instances.ibd -rw-rw---- 1 mysql mysql 8.7K Aug 30 2015 mdl_block_positions.frm -rw-rw---- 1 mysql mysql 144K Aug 24 16:22 mdl_block_positions.ibd -rw-rw---- 1 mysql mysql 8.6K Aug 30 2015 mdl_block_recent_activity.frm -rw-rw---- 1 mysql mysql 112K Feb 17 09:00 mdl_block_recent_activity.ibd -rw-rw---- 1 mysql mysql 8.7K Jan 15 2016 mdl_block_rss_client.frm -rw-rw---- 1 mysql mysql 96K Feb 9 16:00 mdl_block_rss_client.ibd -rw-rw---- 1 mysql mysql 8.5K Aug 30 2015 mdl_blog_association.frm -rw-rw---- 1 mysql mysql 128K Aug 30 2015 mdl_blog_association.ibd -rw-rw---- 1 mysql mysql 8.7K Aug 30 2015 mdl_blog_external.frm -rw-rw---- 1 mysql mysql 112K Aug 30 2015 mdl_blog_external.ibd -rw-rw---- 1 mysql mysql 8.8K Aug 30 2015 mdl_book.frm -rw-rw---- 1 mysql mysql 96K Aug 30 2015 mdl_book.ibd -rw-rw---- 1 mysql mysql 8.8K Aug 30 2015 mdl_book_chapters.frm -rw-rw---- 1 mysql mysql 96K Aug 30 2015 mdl_book_chapters.ibd -rw-rw---- 1 mysql mysql 8.6K Aug 30 2015 mdl_cache_filters.frm -rw-rw---- 1 mysql mysql 112K Aug 30 2015 mdl_cache_filters.ibd -rw-rw---- 1 mysql mysql 8.6K Aug 30 2015 mdl_cache_flags.frm -rw-rw---- 1 mysql mysql 320K Feb 17 09:34 mdl_cache_flags.ibd -rw-rw---- 1 mysql mysql 8.6K Aug 30 2015 mdl_capabilities.frm -rw-rw---- 1 mysql mysql 208K Feb 9 12:52 mdl_capabilities.ibd -rw-rw---- 1 mysql mysql 8.7K Aug 30 2015 mdl_chat.frm -rw-rw---- 1 mysql mysql 112K Dec 3 2015 mdl_chat.ibd -rw-rw---- 1 mysql mysql 8.6K Aug 30 2015 mdl_chat_messages.frm -rw-rw---- 1 mysql mysql 160K Dec 3 2015 mdl_chat_messages.ibd -rw-rw---- 1 mysql mysql 8.6K Aug 30 2015 mdl_chat_messages_current.frm -rw-rw---- 1 mysql mysql 160K Dec 3 2015 mdl_chat_messages_current.ibd -rw-rw---- 1 mysql mysql 8.8K Aug 30 2015 mdl_chat_users.frm -rw-rw---- 1 mysql mysql 160K Dec 3 2015 mdl_chat_users.ibd -rw-rw---- 1 mysql mysql 9.1K Aug 30 2015 mdl_choice.frm -rw-rw---- 1 mysql mysql 112K Apr 12 2016 mdl_choice.ibd -rw-rw---- 1 mysql mysql 8.6K Aug 30 2015 mdl_choice_answers.frm -rw-rw---- 1 mysql mysql 144K Aug 30 2015 mdl_choice_answers.ibd -rw-rw---- 1 mysql mysql 8.6K Aug 30 2015 mdl_choice_options.frm -rw-rw---- 1 mysql mysql 112K Apr 12 2016 mdl_choice_options.ibd -rw-rw---- 1 mysql mysql 9.1K Jan 31 15:41 mdl_choicegroup.frm -rw-rw---- 1 mysql mysql 112K Jan 31 17:00 mdl_choicegroup.ibd -rw-rw---- 1 mysql mysql 8.6K Jan 31 15:41 mdl_choicegroup_options.frm -rw-rw---- 1 mysql mysql 112K Jan 31 17:00 mdl_choicegroup_options.ibd -rw-rw---- 1 mysql mysql 8.8K Aug 30 2015 mdl_cohort.frm -rw-rw---- 1 mysql mysql 112K Sep 19 2015 mdl_cohort.ibd -rw-rw---- 1 mysql mysql 8.5K Aug 30 2015 mdl_cohort_members.frm -rw-rw---- 1 mysql mysql 144K Feb 9 15:03 mdl_cohort_members.ibd -rw-rw---- 1 mysql mysql 8.7K Aug 30 2015 mdl_comments.frm -rw-rw---- 1 mysql mysql 128K Feb 13 08:00 mdl_comments.ibd -rw-rw---- 1 mysql mysql 9.1K Jul 11 2016 mdl_competency.frm -rw-rw---- 1 mysql mysql 128K Jul 11 2016 mdl_competency.ibd -rw-rw---- 1 mysql mysql 8.7K Jul 11 2016 mdl_competency_coursecomp.frm -rw-rw---- 1 mysql mysql 160K Jul 11 2016 mdl_competency_coursecomp.ibd -rw-rw---- 1 mysql mysql 8.6K Jul 11 2016 mdl_competency_coursecompsetting.frm -rw-rw---- 1 mysql mysql 112K Jul 11 2016 mdl_competency_coursecompsetting.ibd -rw-rw---- 1 mysql mysql 8.9K Jul 11 2016 mdl_competency_evidence.frm -rw-rw---- 1 mysql mysql 112K Jul 11 2016 mdl_competency_evidence.ibd -rw-rw---- 1 mysql mysql 8.9K Jul 11 2016 mdl_competency_framework.frm -rw-rw---- 1 mysql mysql 112K Jul 11 2016 mdl_competency_framework.ibd -rw-rw---- 1 mysql mysql 8.7K Jul 11 2016 mdl_competency_modulecomp.frm -rw-rw---- 1 mysql mysql 160K Jul 11 2016 mdl_competency_modulecomp.ibd -rw-rw---- 1 mysql mysql 8.9K Jul 11 2016 mdl_competency_plan.frm -rw-rw---- 1 mysql mysql 144K Jul 11 2016 mdl_competency_plan.ibd -rw-rw---- 1 mysql mysql 8.7K Jul 11 2016 mdl_competency_plancomp.frm -rw-rw---- 1 mysql mysql 112K Jul 11 2016 mdl_competency_plancomp.ibd -rw-rw---- 1 mysql mysql 8.6K Jul 11 2016 mdl_competency_relatedcomp.frm -rw-rw---- 1 mysql mysql 96K Jul 11 2016 mdl_competency_relatedcomp.ibd -rw-rw---- 1 mysql mysql 8.8K Jul 11 2016 mdl_competency_template.frm -rw-rw---- 1 mysql mysql 96K Jul 11 2016 mdl_competency_template.ibd -rw-rw---- 1 mysql mysql 8.6K Jul 11 2016 mdl_competency_templatecohort.frm -rw-rw---- 1 mysql mysql 128K Jul 11 2016 mdl_competency_templatecohort.ibd -rw-rw---- 1 mysql mysql 8.7K Jul 11 2016 mdl_competency_templatecomp.frm -rw-rw---- 1 mysql mysql 128K Jul 11 2016 mdl_competency_templatecomp.ibd -rw-rw---- 1 mysql mysql 8.8K Jul 11 2016 mdl_competency_usercomp.frm -rw-rw---- 1 mysql mysql 112K Jul 11 2016 mdl_competency_usercomp.ibd -rw-rw---- 1 mysql mysql 8.7K Jul 11 2016 mdl_competency_usercompcourse.frm -rw-rw---- 1 mysql mysql 112K Jul 11 2016 mdl_competency_usercompcourse.ibd -rw-rw---- 1 mysql mysql 8.8K Jul 11 2016 mdl_competency_usercompplan.frm -rw-rw---- 1 mysql mysql 112K Jul 11 2016 mdl_competency_usercompplan.ibd -rw-rw---- 1 mysql mysql 8.7K Jul 11 2016 mdl_competency_userevidence.frm -rw-rw---- 1 mysql mysql 112K Jul 11 2016 mdl_competency_userevidence.ibd -rw-rw---- 1 mysql mysql 8.6K Jul 11 2016 mdl_competency_userevidencecomp.frm -rw-rw---- 1 mysql mysql 128K Jul 11 2016 mdl_competency_userevidencecomp.ibd -rw-rw---- 1 mysql mysql 8.5K Aug 30 2015 mdl_config.frm -rw-rw---- 1 mysql mysql 192K Feb 17 09:00 mdl_config.ibd -rw-rw---- 1 mysql mysql 8.6K Aug 30 2015 mdl_config_log.frm -rw-rw---- 1 mysql mysql 9.0M Feb 16 11:54 mdl_config_log.ibd -rw-rw---- 1 mysql mysql 8.5K Aug 30 2015 mdl_config_plugins.frm -rw-rw---- 1 mysql mysql 400K Feb 17 09:00 mdl_config_plugins.ibd -rw-rw---- 1 mysql mysql 8.6K Aug 30 2015 mdl_context.frm -rw-rw---- 1 mysql mysql 336K Feb 16 23:18 mdl_context.ibd -rw-rw---- 1 mysql mysql 8.5K Aug 30 2015 mdl_context_temp.frm -rw-rw---- 1 mysql mysql 96K Aug 30 2015 mdl_context_temp.ibd -rw-rw---- 1 mysql mysql 14K Jan 31 14:51 mdl_course.frm -rw-rw---- 1 mysql mysql 160K Feb 16 17:08 mdl_course.ibd -rw-rw---- 1 mysql mysql 8.9K Aug 30 2015 mdl_course_categories.frm -rw-rw---- 1 mysql mysql 112K Feb 14 16:24 mdl_course_categories.ibd -rw-rw---- 1 mysql mysql 8.5K Aug 30 2015 mdl_course_completion_aggr_methd.frm -rw-rw---- 1 mysql mysql 144K Jan 29 12:27 mdl_course_completion_aggr_methd.ibd -rw-rw---- 1 mysql mysql 8.6K Aug 30 2015 mdl_course_completion_crit_compl.frm -rw-rw---- 1 mysql mysql 176K Aug 31 17:13 mdl_course_completion_crit_compl.ibd -rw-rw---- 1 mysql mysql 8.8K Aug 30 2015 mdl_course_completion_criteria.frm -rw-rw---- 1 mysql mysql 112K Jan 29 12:27 mdl_course_completion_criteria.ibd -rw-rw---- 1 mysql mysql 8.6K Aug 30 2015 mdl_course_completions.frm -rw-rw---- 1 mysql mysql 160K Feb 16 20:00 mdl_course_completions.ibd -rw-rw---- 1 mysql mysql 8.6K Aug 30 2015 mdl_course_format_options.frm -rw-rw---- 1 mysql mysql 128K Feb 14 19:11 mdl_course_format_options.ibd -rw-rw---- 1 mysql mysql 9.2K Jan 31 14:51 mdl_course_modules.frm -rw-rw---- 1 mysql mysql 240K Feb 16 11:00 mdl_course_modules.ibd -rw-rw---- 1 mysql mysql 8.6K Aug 30 2015 mdl_course_modules_completion.frm -rw-rw---- 1 mysql mysql 160K Feb 17 08:15 mdl_course_modules_completion.ibd -rw-rw---- 1 mysql mysql 8.7K Aug 30 2015 mdl_course_published.frm -rw-rw---- 1 mysql mysql 96K Aug 30 2015 mdl_course_published.ibd -rw-rw---- 1 mysql mysql 8.7K Aug 30 2015 mdl_course_request.frm -rw-rw---- 1 mysql mysql 112K Aug 30 2015 mdl_course_request.ibd -rw-rw---- 1 mysql mysql 8.7K Aug 30 2015 mdl_course_sections.frm -rw-rw---- 1 mysql mysql 192K Feb 16 11:00 mdl_course_sections.ibd -rw-rw---- 1 mysql mysql 10K Jan 31 14:51 mdl_data.frm -rw-rw---- 1 mysql mysql 64K Jan 31 14:52 mdl_data.ibd -rw-rw---- 1 mysql mysql 8.7K Aug 30 2015 mdl_data_content.frm -rw-rw---- 1 mysql mysql 128K Aug 30 2015 mdl_data_content.ibd -rw-rw---- 1 mysql mysql 8.9K Aug 30 2015 mdl_data_fields.frm -rw-rw---- 1 mysql mysql 64K Aug 30 2015 mdl_data_fields.ibd -rw-rw---- 1 mysql mysql 8.6K Aug 30 2015 mdl_data_records.frm -rw-rw---- 1 mysql mysql 112K Aug 30 2015 mdl_data_records.ibd -rw-rw---- 1 mysql mysql 8.7K Aug 30 2015 mdl_editor_atto_autosave.frm -rw-rw---- 1 mysql mysql 240K Feb 16 10:59 mdl_editor_atto_autosave.ibd -rw-rw---- 1 mysql mysql 14K Aug 30 2015 mdl_enrol.frm -rw-rw---- 1 mysql mysql 128K Feb 16 10:35 mdl_enrol.ibd -rw-rw---- 1 mysql mysql 8.7K Aug 30 2015 mdl_enrol_flatfile.frm -rw-rw---- 1 mysql mysql 144K Aug 30 2015 mdl_enrol_flatfile.ibd -rw-rw---- 1 mysql mysql 18K Jan 31 14:51 mdl_enrol_lti_lti2_consumer.frm -rw-rw---- 1 mysql mysql 64K Jan 31 14:52 mdl_enrol_lti_lti2_consumer.ibd -rw-rw---- 1 mysql mysql 8.6K Jan 31 14:51 mdl_enrol_lti_lti2_context.frm -rw-rw---- 1 mysql mysql 112K Jan 31 14:52 mdl_enrol_lti_lti2_context.ibd -rw-rw---- 1 mysql mysql 8.5K Jan 31 14:51 mdl_enrol_lti_lti2_nonce.frm -rw-rw---- 1 mysql mysql 112K Jan 31 14:52 mdl_enrol_lti_lti2_nonce.ibd -rw-rw---- 1 mysql mysql 8.8K Jan 31 14:51 mdl_enrol_lti_lti2_resource_link.frm -rw-rw---- 1 mysql mysql 144K Jan 31 14:52 mdl_enrol_lti_lti2_resource_link.ibd -rw-rw---- 1 mysql mysql 8.6K Jan 31 14:51 mdl_enrol_lti_lti2_share_key.frm -rw-rw---- 1 mysql mysql 128K Jan 31 14:52 mdl_enrol_lti_lti2_share_key.ibd -rw-rw---- 1 mysql mysql 8.6K Jan 31 14:51 mdl_enrol_lti_lti2_tool_proxy.frm -rw-rw---- 1 mysql mysql 128K Jan 31 14:52 mdl_enrol_lti_lti2_tool_proxy.ibd -rw-rw---- 1 mysql mysql 13K Jan 31 14:51 mdl_enrol_lti_lti2_user_result.frm -rw-rw---- 1 mysql mysql 112K Jan 31 14:52 mdl_enrol_lti_lti2_user_result.ibd -rw-rw---- 1 mysql mysql 8.5K Jan 31 14:51 mdl_enrol_lti_tool_consumer_map.frm -rw-rw---- 1 mysql mysql 128K Jan 31 14:52 mdl_enrol_lti_tool_consumer_map.ibd -rw-rw---- 1 mysql mysql 9.1K Jul 11 2016 mdl_enrol_lti_tools.frm -rw-rw---- 1 mysql mysql 128K Jul 11 2016 mdl_enrol_lti_tools.ibd -rw-rw---- 1 mysql mysql 8.9K Jul 11 2016 mdl_enrol_lti_users.frm -rw-rw---- 1 mysql mysql 128K Jul 11 2016 mdl_enrol_lti_users.ibd -rw-rw---- 1 mysql mysql 18K Aug 30 2015 mdl_enrol_paypal.frm -rw-rw---- 1 mysql mysql 96K Aug 30 2015 mdl_enrol_paypal.ibd -rw-rw---- 1 mysql mysql 9.0K Aug 30 2015 mdl_event.frm -rw-rw---- 1 mysql mysql 432K Feb 16 10:59 mdl_event.ibd -rw-rw---- 1 mysql mysql 8.7K Aug 30 2015 mdl_event_subscriptions.frm -rw-rw---- 1 mysql mysql 96K Aug 30 2015 mdl_event_subscriptions.ibd -rw-rw---- 1 mysql mysql 8.7K Aug 30 2015 mdl_events_handlers.frm -rw-rw---- 1 mysql mysql 112K Aug 30 2015 mdl_events_handlers.ibd -rw-rw---- 1 mysql mysql 8.6K Aug 30 2015 mdl_events_queue.frm -rw-rw---- 1 mysql mysql 112K Aug 30 2015 mdl_events_queue.ibd -rw-rw---- 1 mysql mysql 8.6K Aug 30 2015 mdl_events_queue_handlers.frm -rw-rw---- 1 mysql mysql 128K Aug 30 2015 mdl_events_queue_handlers.ibd -rw-rw---- 1 mysql mysql 13K Jul 11 2016 mdl_external_functions.frm -rw-rw---- 1 mysql mysql 192K Jan 31 14:52 mdl_external_functions.ibd -rw-rw---- 1 mysql mysql 8.8K Aug 30 2015 mdl_external_services.frm -rw-rw---- 1 mysql mysql 112K Aug 30 2015 mdl_external_services.ibd -rw-rw---- 1 mysql mysql 8.5K Aug 30 2015 mdl_external_services_functions.frm -rw-rw---- 1 mysql mysql 112K Jan 31 14:52 mdl_external_services_functions.ibd -rw-rw---- 1 mysql mysql 8.6K Aug 30 2015 mdl_external_services_users.frm -rw-rw---- 1 mysql mysql 128K Aug 30 2015 mdl_external_services_users.ibd -rw-rw---- 1 mysql mysql 8.9K Jan 31 14:51 mdl_external_tokens.frm -rw-rw---- 1 mysql mysql 160K Jan 31 14:52 mdl_external_tokens.ibd -rw-rw---- 1 mysql mysql 9.1K Aug 30 2015 mdl_feedback.frm -rw-rw---- 1 mysql mysql 112K Aug 30 2015 mdl_feedback.ibd -rw-rw---- 1 mysql mysql 8.7K Jul 11 2016 mdl_feedback_completed.frm -rw-rw---- 1 mysql mysql 128K Jul 11 2016 mdl_feedback_completed.ibd -rw-rw---- 1 mysql mysql 8.7K Jul 11 2016 mdl_feedback_completedtmp.frm -rw-rw---- 1 mysql mysql 128K Jul 11 2016 mdl_feedback_completedtmp.ibd -rw-rw---- 1 mysql mysql 13K Aug 30 2015 mdl_feedback_item.frm -rw-rw---- 1 mysql mysql 128K Aug 30 2015 mdl_feedback_item.ibd -rw-rw---- 1 mysql mysql 8.5K Aug 30 2015 mdl_feedback_sitecourse_map.frm -rw-rw---- 1 mysql mysql 128K Aug 30 2015 mdl_feedback_sitecourse_map.ibd -rw-rw---- 1 mysql mysql 8.5K Aug 30 2015 mdl_feedback_template.frm -rw-rw---- 1 mysql mysql 112K Aug 30 2015 mdl_feedback_template.ibd -rw-rw---- 1 mysql mysql 8.6K Jul 11 2016 mdl_feedback_value.frm -rw-rw---- 1 mysql mysql 144K Jul 11 2016 mdl_feedback_value.ibd -rw-rw---- 1 mysql mysql 8.6K Jul 11 2016 mdl_feedback_valuetmp.frm -rw-rw---- 1 mysql mysql 144K Jul 11 2016 mdl_feedback_valuetmp.ibd -rw-rw---- 1 mysql mysql 14K Aug 30 2015 mdl_files.frm -rw-rw---- 1 mysql mysql 14M Feb 17 00:07 mdl_files.ibd -rw-rw---- 1 mysql mysql 8.6K Aug 30 2015 mdl_files_reference.frm -rw-rw---- 1 mysql mysql 128K Aug 30 2015 mdl_files_reference.ibd -rw-rw---- 1 mysql mysql 8.5K Aug 30 2015 mdl_filter_active.frm -rw-rw---- 1 mysql mysql 128K Sep 19 2015 mdl_filter_active.ibd -rw-rw---- 1 mysql mysql 8.5K Aug 30 2015 mdl_filter_config.frm -rw-rw---- 1 mysql mysql 128K Aug 30 2015 mdl_filter_config.ibd -rw-rw---- 1 mysql mysql 8.8K Jul 11 2016 mdl_folder.frm -rw-rw---- 1 mysql mysql 112K Feb 16 09:30 mdl_folder.ibd -rw-rw---- 1 mysql mysql 9.5K Jan 31 14:51 mdl_forum.frm -rw-rw---- 1 mysql mysql 112K Jan 31 14:52 mdl_forum.ibd -rw-rw---- 1 mysql mysql 8.5K Aug 30 2015 mdl_forum_digests.frm -rw-rw---- 1 mysql mysql 144K Aug 30 2015 mdl_forum_digests.ibd -rw-rw---- 1 mysql mysql 8.6K Aug 30 2015 mdl_forum_discussion_subs.frm -rw-rw---- 1 mysql mysql 160K Aug 30 2015 mdl_forum_discussion_subs.ibd -rw-rw---- 1 mysql mysql 8.8K Jul 11 2016 mdl_forum_discussions.frm -rw-rw---- 1 mysql mysql 144K Jul 28 2016 mdl_forum_discussions.ibd -rw-rw---- 1 mysql mysql 8.9K Aug 30 2015 mdl_forum_posts.frm -rw-rw---- 1 mysql mysql 176K Jul 28 2016 mdl_forum_posts.ibd -rw-rw---- 1 mysql mysql 8.6K Aug 30 2015 mdl_forum_queue.frm -rw-rw---- 1 mysql mysql 144K Aug 30 2015 mdl_forum_queue.ibd -rw-rw---- 1 mysql mysql 8.6K Aug 30 2015 mdl_forum_read.frm -rw-rw---- 1 mysql mysql 144K Dec 22 2015 mdl_forum_read.ibd -rw-rw---- 1 mysql mysql 8.5K Aug 30 2015 mdl_forum_subscriptions.frm -rw-rw---- 1 mysql mysql 128K Jul 28 2016 mdl_forum_subscriptions.ibd -rw-rw---- 1 mysql mysql 8.5K Aug 30 2015 mdl_forum_track_prefs.frm -rw-rw---- 1 mysql mysql 112K Aug 30 2015 mdl_forum_track_prefs.ibd -rw-rw---- 1 mysql mysql 9.6K Aug 30 2015 mdl_glossary.frm -rw-rw---- 1 mysql mysql 112K Aug 30 2015 mdl_glossary.ibd -rw-rw---- 1 mysql mysql 8.5K Aug 30 2015 mdl_glossary_alias.frm -rw-rw---- 1 mysql mysql 112K Aug 30 2015 mdl_glossary_alias.ibd -rw-rw---- 1 mysql mysql 8.5K Aug 30 2015 mdl_glossary_categories.frm -rw-rw---- 1 mysql mysql 112K Aug 30 2015 mdl_glossary_categories.ibd -rw-rw---- 1 mysql mysql 9.1K Aug 30 2015 mdl_glossary_entries.frm -rw-rw---- 1 mysql mysql 144K Aug 30 2015 mdl_glossary_entries.ibd -rw-rw---- 1 mysql mysql 8.5K Aug 30 2015 mdl_glossary_entries_categories.frm -rw-rw---- 1 mysql mysql 128K Aug 30 2015 mdl_glossary_entries_categories.ibd -rw-rw---- 1 mysql mysql 8.8K Jan 15 2016 mdl_glossary_formats.frm -rw-rw---- 1 mysql mysql 96K Jan 15 2016 mdl_glossary_formats.ibd -rw-rw---- 1 mysql mysql 8.9K Aug 30 2015 mdl_grade_categories.frm -rw-rw---- 1 mysql mysql 128K Feb 14 19:33 mdl_grade_categories.ibd -rw-rw---- 1 mysql mysql 14K Aug 30 2015 mdl_grade_categories_history.frm -rw-rw---- 1 mysql mysql 256K Feb 14 19:33 mdl_grade_categories_history.ibd -rw-rw---- 1 mysql mysql 9.4K Aug 30 2015 mdl_grade_grades.frm -rw-rw---- 1 mysql mysql 11M Feb 16 10:57 mdl_grade_grades.ibd -rw-rw---- 1 mysql mysql 14K Jul 11 2016 mdl_grade_grades_history.frm -rw-rw---- 1 mysql mysql 27M Feb 16 10:57 mdl_grade_grades_history.ibd -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_grade_import_newitem.frm -rw-rw---- 1 mysql mysql 8.7K Jan 15 2016 mdl_grade_import_values.frm -rw-rw---- 1 mysql mysql 144K Jan 15 2016 mdl_grade_import_values.ibd -rw-rw---- 1 mysql mysql 14K Jan 24 2015 mdl_grade_items.frm -rw-rw---- 1 mysql mysql 304K Feb 16 10:35 mdl_grade_items.ibd -rw-rw---- 1 mysql mysql 14K Jan 24 2015 mdl_grade_items_history.frm -rw-rw---- 1 mysql mysql 120M Feb 15 11:05 mdl_grade_items_history.ibd -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_grade_letters.frm -rw-rw---- 1 mysql mysql 8.8K Sep 13 2013 mdl_grade_outcomes.frm -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_grade_outcomes_courses.frm -rw-rw---- 1 mysql mysql 8.8K Sep 13 2013 mdl_grade_outcomes_history.frm -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_grade_settings.frm -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_grading_areas.frm -rw-rw---- 1 mysql mysql 8.9K Sep 13 2013 mdl_grading_definitions.frm -rw-rw---- 1 mysql mysql 8.7K Sep 13 2013 mdl_grading_instances.frm -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_gradingform_guide_comments.frm -rw-rw---- 1 mysql mysql 8.8K Sep 13 2013 mdl_gradingform_guide_criteria.frm -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_gradingform_guide_fillings.frm -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_gradingform_rubric_criteria.frm -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_gradingform_rubric_fillings.frm -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_gradingform_rubric_levels.frm -rw-rw---- 1 mysql mysql 8.7K Sep 13 2013 mdl_groupings.frm -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_groupings_groups.frm -rw-rw---- 1 mysql mysql 8.8K Sep 13 2013 mdl_groups.frm -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_groups_members.frm -rw-rw---- 1 mysql mysql 8.7K Sep 13 2013 mdl_imscp.frm -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_label.frm -rw-rw---- 1 mysql mysql 11K Jan 15 2016 mdl_lesson.frm -rw-rw---- 1 mysql mysql 112K Jan 15 2016 mdl_lesson.ibd -rw-rw---- 1 mysql mysql 8.9K Sep 13 2013 mdl_lesson_answers.frm -rw-rw---- 1 mysql mysql 8.7K Sep 13 2013 mdl_lesson_attempts.frm -rw-rw---- 1 mysql mysql 8.6K May 28 2015 mdl_lesson_branch.frm -rw-rw---- 1 mysql mysql 144K May 28 2015 mdl_lesson_branch.ibd -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_lesson_grades.frm -rw-rw---- 1 mysql mysql 8.8K May 28 2015 mdl_lesson_overrides.frm -rw-rw---- 1 mysql mysql 144K May 28 2015 mdl_lesson_overrides.ibd -rw-rw---- 1 mysql mysql 8.9K Sep 13 2013 mdl_lesson_pages.frm -rw-rw---- 1 mysql mysql 8.6K May 28 2015 mdl_lesson_timer.frm -rw-rw---- 1 mysql mysql 128K May 28 2015 mdl_lesson_timer.ibd -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_license.frm -rw-rw---- 1 mysql mysql 8.5K Jan 24 2015 mdl_lock_db.frm -rw-rw---- 1 mysql mysql 144K Jan 24 2015 mdl_lock_db.ibd -rw-rw---- 1 mysql mysql 8.7K Sep 13 2013 mdl_log.frm -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_log_display.frm -rw-rw---- 1 mysql mysql 8.7K Sep 13 2013 mdl_log_queries.frm -rw-rw---- 1 mysql mysql 9.2K Jul 11 2016 mdl_logstore_standard_log.frm -rw-rw---- 1 mysql mysql 124M Feb 17 09:37 mdl_logstore_standard_log.ibd -rw-rw---- 1 mysql mysql 9.7K Jan 24 2015 mdl_lti.frm -rw-rw---- 1 mysql mysql 112K Jan 24 2015 mdl_lti.ibd -rw-rw---- 1 mysql mysql 8.7K Sep 13 2013 mdl_lti_submission.frm -rw-rw---- 1 mysql mysql 8.9K Jan 24 2015 mdl_lti_tool_proxies.frm -rw-rw---- 1 mysql mysql 112K Jan 24 2015 mdl_lti_tool_proxies.ibd -rw-rw---- 1 mysql mysql 8.7K Jan 24 2015 mdl_lti_tool_settings.frm -rw-rw---- 1 mysql mysql 144K Jan 24 2015 mdl_lti_tool_settings.ibd -rw-rw---- 1 mysql mysql 9.0K Jul 11 2016 mdl_lti_types.frm -rw-rw---- 1 mysql mysql 128K Jul 11 2016 mdl_lti_types.ibd -rw-rw---- 1 mysql mysql 8.5K Jan 31 14:51 mdl_lti_types_config.frm -rw-rw---- 1 mysql mysql 112K Jan 31 14:52 mdl_lti_types_config.ibd -rw-rw---- 1 mysql mysql 9.1K Jan 31 14:51 mdl_message.frm -rw-rw---- 1 mysql mysql 10M Feb 17 00:07 mdl_message.ibd -rw-rw---- 1 mysql mysql 8.5K Jan 24 2015 mdl_message_airnotifier_devices.frm -rw-rw---- 1 mysql mysql 112K Feb 13 2015 mdl_message_airnotifier_devices.ibd -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_message_contacts.frm -rw-rw---- 1 mysql mysql 8.5K Jan 31 14:51 mdl_message_popup.frm -rw-rw---- 1 mysql mysql 112K Feb 3 23:11 mdl_message_popup.ibd -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_message_processors.frm -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_message_providers.frm -rw-rw---- 1 mysql mysql 9.1K Jan 31 14:51 mdl_message_read.frm -rw-rw---- 1 mysql mysql 10M Feb 17 01:00 mdl_message_read.ibd -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_message_working.frm -rw-rw---- 1 mysql mysql 8.6K Jan 24 2015 mdl_messageinbound_datakeys.frm -rw-rw---- 1 mysql mysql 128K Jan 24 2015 mdl_messageinbound_datakeys.ibd -rw-rw---- 1 mysql mysql 8.6K Jan 24 2015 mdl_messageinbound_handlers.frm -rw-rw---- 1 mysql mysql 112K May 28 2015 mdl_messageinbound_handlers.ibd -rw-rw---- 1 mysql mysql 8.6K Jan 24 2015 mdl_messageinbound_messagelist.frm -rw-rw---- 1 mysql mysql 112K Jan 24 2015 mdl_messageinbound_messagelist.ibd -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_mnet_application.frm -rw-rw---- 1 mysql mysql 9.0K May 28 2015 mdl_mnet_host.frm -rw-rw---- 1 mysql mysql 112K May 28 2015 mdl_mnet_host.ibd -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_mnet_host2service.frm -rw-rw---- 1 mysql mysql 8.8K Sep 13 2013 mdl_mnet_log.frm -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_mnet_remote_rpc.frm -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_mnet_remote_service2rpc.frm -rw-rw---- 1 mysql mysql 8.8K Sep 13 2013 mdl_mnet_rpc.frm -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_mnet_service.frm -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_mnet_service2rpc.frm -rw-rw---- 1 mysql mysql 8.7K Sep 13 2013 mdl_mnet_session.frm -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_mnet_sso_access_control.frm -rw-rw---- 1 mysql mysql 8.9K Sep 13 2013 mdl_mnetservice_enrol_courses.frm -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_mnetservice_enrol_enrolments.frm -rw-rw---- 1 mysql mysql 8.6K Jan 24 2015 mdl_modules.frm -rw-rw---- 1 mysql mysql 112K Feb 17 09:00 mdl_modules.ibd -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_my_pages.frm -rw-rw---- 1 mysql mysql 9.1K Jan 31 15:44 mdl_organizer.frm -rw-rw---- 1 mysql mysql 96K Jan 31 15:44 mdl_organizer.ibd -rw-rw---- 1 mysql mysql 9.0K Jan 31 15:44 mdl_organizer_slot_appointments.frm -rw-rw---- 1 mysql mysql 160K Jan 31 15:44 mdl_organizer_slot_appointments.ibd -rw-rw---- 1 mysql mysql 8.6K Jan 31 15:44 mdl_organizer_slot_queues.frm -rw-rw---- 1 mysql mysql 160K Jan 31 15:44 mdl_organizer_slot_queues.ibd -rw-rw---- 1 mysql mysql 9.1K Jan 31 15:44 mdl_organizer_slots.frm -rw-rw---- 1 mysql mysql 144K Jan 31 15:44 mdl_organizer_slots.ibd -rw-rw---- 1 mysql mysql 8.9K Sep 13 2013 mdl_page.frm -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_portfolio_instance.frm -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_portfolio_instance_config.frm -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_portfolio_instance_user.frm -rw-rw---- 1 mysql mysql 13K Sep 13 2013 mdl_portfolio_log.frm -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_portfolio_mahara_queue.frm -rw-rw---- 1 mysql mysql 8.6K Jan 24 2015 mdl_portfolio_tempdata.frm -rw-rw---- 1 mysql mysql 128K Jan 24 2015 mdl_portfolio_tempdata.ibd -rw-rw---- 1 mysql mysql 9.1K Sep 13 2013 mdl_post.frm -rw-rw---- 1 mysql mysql 8.8K Sep 13 2013 mdl_profiling.frm -rw-rw---- 1 mysql mysql 8.9K Jan 15 2016 mdl_qtype_ddimageortext.frm -rw-rw---- 1 mysql mysql 112K Jan 15 2016 mdl_qtype_ddimageortext.ibd -rw-rw---- 1 mysql mysql 8.6K Jan 15 2016 mdl_qtype_ddimageortext_drags.frm -rw-rw---- 1 mysql mysql 112K Jan 15 2016 mdl_qtype_ddimageortext_drags.ibd -rw-rw---- 1 mysql mysql 8.6K Jan 15 2016 mdl_qtype_ddimageortext_drops.frm -rw-rw---- 1 mysql mysql 112K Jan 15 2016 mdl_qtype_ddimageortext_drops.ibd -rw-rw---- 1 mysql mysql 9.0K Jan 15 2016 mdl_qtype_ddmarker.frm -rw-rw---- 1 mysql mysql 112K Jan 15 2016 mdl_qtype_ddmarker.ibd -rw-rw---- 1 mysql mysql 8.6K Jan 15 2016 mdl_qtype_ddmarker_drags.frm -rw-rw---- 1 mysql mysql 112K Jan 15 2016 mdl_qtype_ddmarker_drags.ibd -rw-rw---- 1 mysql mysql 8.6K Jan 15 2016 mdl_qtype_ddmarker_drops.frm -rw-rw---- 1 mysql mysql 112K Jan 15 2016 mdl_qtype_ddmarker_drops.ibd -rw-rw---- 1 mysql mysql 8.9K Jan 24 2015 mdl_qtype_essay_options.frm -rw-rw---- 1 mysql mysql 144K Feb 16 11:12 mdl_qtype_essay_options.ibd -rw-rw---- 1 mysql mysql 8.9K Sep 13 2013 mdl_qtype_match_options.frm -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_qtype_match_subquestions.frm -rw-rw---- 1 mysql mysql 9.0K Jan 24 2015 mdl_qtype_multichoice_options.frm -rw-rw---- 1 mysql mysql 288K Jan 29 12:26 mdl_qtype_multichoice_options.ibd -rw-rw---- 1 mysql mysql 8.9K May 8 2015 mdl_qtype_multichoiceset_options.frm -rw-rw---- 1 mysql mysql 112K Jan 29 12:26 mdl_qtype_multichoiceset_options.ibd -rw-rw---- 1 mysql mysql 8.9K Jan 24 2015 mdl_qtype_randomsamatch_options.frm -rw-rw---- 1 mysql mysql 112K Feb 14 12:18 mdl_qtype_randomsamatch_options.ibd -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_qtype_shortanswer_options.frm -rw-rw---- 1 mysql mysql 14K Jan 15 2016 mdl_question.frm -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_question_answers.frm -rw-rw---- 1 mysql mysql 8.5K Jan 31 14:51 mdl_question_attempt_step_data.frm -rw-rw---- 1 mysql mysql 8.7K Sep 13 2013 mdl_question_attempt_steps.frm -rw-rw---- 1 mysql mysql 8.9K Jan 24 2015 mdl_question_attempts.frm -rw-rw---- 1 mysql mysql 17M Feb 16 11:05 mdl_question_attempts.ibd -rw-rw---- 1 mysql mysql 8.7K Sep 13 2013 mdl_question_calculated.frm -rw-rw---- 1 mysql mysql 9.0K Sep 13 2013 mdl_question_calculated_options.frm -rw-rw---- 1 mysql mysql 8.6K Jan 31 14:51 mdl_question_categories.frm -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_question_dataset_definitions.frm -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_question_dataset_items.frm -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_question_datasets.frm -rw-rw---- 1 mysql mysql 8.9K May 31 2015 mdl_question_ddwtos.frm -rw-rw---- 1 mysql mysql 112K Sep 19 2015 mdl_question_ddwtos.ibd -rw-rw---- 1 mysql mysql 8.9K May 31 2015 mdl_question_gapselect.frm -rw-rw---- 1 mysql mysql 112K May 31 2015 mdl_question_gapselect.ibd -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_question_hints.frm -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_question_multianswer.frm -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_question_numerical.frm -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_question_numerical_options.frm -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_question_numerical_units.frm -rw-rw---- 1 mysql mysql 8.7K Jan 24 2015 mdl_question_response_analysis.frm -rw-rw---- 1 mysql mysql 144K Apr 12 2016 mdl_question_response_analysis.ibd -rw-rw---- 1 mysql mysql 8.5K Jan 24 2015 mdl_question_response_count.frm -rw-rw---- 1 mysql mysql 112K Apr 12 2016 mdl_question_response_count.ibd -rw-rw---- 1 mysql mysql 9.1K Jan 24 2015 mdl_question_statistics.frm -rw-rw---- 1 mysql mysql 96K Apr 12 2016 mdl_question_statistics.ibd -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_question_truefalse.frm -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_question_usages.frm -rw-rw---- 1 mysql mysql 11K Jan 31 14:51 mdl_quiz.frm -rw-rw---- 1 mysql mysql 112K Feb 16 11:02 mdl_quiz.ibd -rw-rw---- 1 mysql mysql 9.0K Jan 31 14:51 mdl_quiz_attempts.frm -rw-rw---- 1 mysql mysql 672K Feb 16 11:05 mdl_quiz_attempts.ibd -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_quiz_feedback.frm -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_quiz_grades.frm -rw-rw---- 1 mysql mysql 8.7K Sep 13 2013 mdl_quiz_overrides.frm -rw-rw---- 1 mysql mysql 8.7K Sep 13 2013 mdl_quiz_overview_regrades.frm -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_quiz_reports.frm -rw-rw---- 1 mysql mysql 13K May 28 2015 mdl_quiz_sections.frm -rw-rw---- 1 mysql mysql 128K Jan 19 19:34 mdl_quiz_sections.ibd -rw-rw---- 1 mysql mysql 8.6K May 28 2015 mdl_quiz_slots.frm -rw-rw---- 1 mysql mysql 176K Feb 16 11:02 mdl_quiz_slots.ibd -rw-rw---- 1 mysql mysql 9.2K Jan 24 2015 mdl_quiz_statistics.frm -rw-rw---- 1 mysql mysql 96K Jan 31 14:52 mdl_quiz_statistics.ibd -rw-rw---- 1 mysql mysql 8.7K Sep 13 2013 mdl_rating.frm -rw-rw---- 1 mysql mysql 8.6K May 28 2015 mdl_registration_hubs.frm -rw-rw---- 1 mysql mysql 96K Feb 12 15:00 mdl_registration_hubs.ibd -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_repository.frm -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_repository_instance_config.frm -rw-rw---- 1 mysql mysql 8.7K Sep 13 2013 mdl_repository_instances.frm -rw-rw---- 1 mysql mysql 8.9K Sep 13 2013 mdl_resource.frm -rw-rw---- 1 mysql mysql 8.9K Sep 13 2013 mdl_resource_old.frm -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_role.frm -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_role_allow_assign.frm -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_role_allow_override.frm -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_role_allow_switch.frm -rw-rw---- 1 mysql mysql 8.7K Sep 13 2013 mdl_role_assignments.frm -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_role_capabilities.frm -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_role_context_levels.frm -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_role_names.frm -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_role_sortorder.frm -rw-rw---- 1 mysql mysql 8.7K Sep 13 2013 mdl_scale.frm -rw-rw---- 1 mysql mysql 8.8K Sep 13 2013 mdl_scale_history.frm -rw-rw---- 1 mysql mysql 11K Jan 31 14:51 mdl_scorm.frm -rw-rw---- 1 mysql mysql 112K Jan 31 14:52 mdl_scorm.ibd -rw-rw---- 1 mysql mysql 13K Sep 13 2013 mdl_scorm_aicc_session.frm -rw-rw---- 1 mysql mysql 13K Jan 24 2015 mdl_scorm_scoes.frm -rw-rw---- 1 mysql mysql 112K Jan 24 2015 mdl_scorm_scoes.ibd -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_scorm_scoes_data.frm -rw-rw---- 1 mysql mysql 8.7K Sep 13 2013 mdl_scorm_scoes_track.frm -rw-rw---- 1 mysql mysql 8.8K Sep 13 2013 mdl_scorm_seq_mapinfo.frm -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_scorm_seq_objective.frm -rw-rw---- 1 mysql mysql 8.7K Sep 13 2013 mdl_scorm_seq_rolluprule.frm -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_scorm_seq_rolluprulecond.frm -rw-rw---- 1 mysql mysql 8.7K Sep 13 2013 mdl_scorm_seq_rulecond.frm -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_scorm_seq_ruleconds.frm -rw-rw---- 1 mysql mysql 8.7K Sep 13 2013 mdl_sessions.frm -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_stats_daily.frm -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_stats_monthly.frm -rw-rw---- 1 mysql mysql 8.7K Sep 13 2013 mdl_stats_user_daily.frm -rw-rw---- 1 mysql mysql 8.7K Sep 13 2013 mdl_stats_user_monthly.frm -rw-rw---- 1 mysql mysql 8.7K Sep 13 2013 mdl_stats_user_weekly.frm -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_stats_weekly.frm -rw-rw---- 1 mysql mysql 8.8K Jan 31 14:51 mdl_survey.frm -rw-rw---- 1 mysql mysql 112K Jan 31 14:52 mdl_survey.ibd -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_survey_analysis.frm -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_survey_answers.frm -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_survey_questions.frm -rw-rw---- 1 mysql mysql 8.8K Jul 11 2016 mdl_tag.frm -rw-rw---- 1 mysql mysql 160K Jul 11 2016 mdl_tag.ibd -rw-rw---- 1 mysql mysql 8.7K Jul 11 2016 mdl_tag_area.frm -rw-rw---- 1 mysql mysql 128K Jul 11 2016 mdl_tag_area.ibd -rw-rw---- 1 mysql mysql 8.6K Jul 11 2016 mdl_tag_coll.frm -rw-rw---- 1 mysql mysql 96K Jul 11 2016 mdl_tag_coll.ibd -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_tag_correlation.frm -rw-rw---- 1 mysql mysql 8.7K Jul 11 2016 mdl_tag_instance.frm -rw-rw---- 1 mysql mysql 160K Jan 29 12:24 mdl_tag_instance.ibd -rw-rw---- 1 mysql mysql 8.6K Jan 24 2015 mdl_task_adhoc.frm -rw-rw---- 1 mysql mysql 112K Feb 16 11:00 mdl_task_adhoc.ibd -rw-rw---- 1 mysql mysql 8.9K Jan 24 2015 mdl_task_scheduled.frm -rw-rw---- 1 mysql mysql 112K Feb 17 09:00 mdl_task_scheduled.ibd -rw-rw---- 1 mysql mysql 8.6K Jul 11 2016 mdl_tool_cohortroles.frm -rw-rw---- 1 mysql mysql 112K Jul 11 2016 mdl_tool_cohortroles.ibd -rw-rw---- 1 mysql mysql 8.8K Sep 13 2013 mdl_tool_customlang.frm -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_tool_customlang_components.frm -rw-rw---- 1 mysql mysql 8.7K Jan 24 2015 mdl_tool_monitor_events.frm -rw-rw---- 1 mysql mysql 96K Jan 24 2015 mdl_tool_monitor_events.ibd -rw-rw---- 1 mysql mysql 8.5K Jan 24 2015 mdl_tool_monitor_history.frm -rw-rw---- 1 mysql mysql 128K Jan 24 2015 mdl_tool_monitor_history.ibd -rw-rw---- 1 mysql mysql 8.9K Jan 24 2015 mdl_tool_monitor_rules.frm -rw-rw---- 1 mysql mysql 128K Jan 24 2015 mdl_tool_monitor_rules.ibd -rw-rw---- 1 mysql mysql 8.7K Jul 11 2016 mdl_tool_monitor_subscriptions.frm -rw-rw---- 1 mysql mysql 128K Jul 11 2016 mdl_tool_monitor_subscriptions.ibd -rw-rw---- 1 mysql mysql 8.6K Jul 11 2016 mdl_tool_recyclebin_category.frm -rw-rw---- 1 mysql mysql 128K Sep 10 19:00 mdl_tool_recyclebin_category.ibd -rw-rw---- 1 mysql mysql 8.6K Jul 11 2016 mdl_tool_recyclebin_course.frm -rw-rw---- 1 mysql mysql 128K Feb 16 11:00 mdl_tool_recyclebin_course.ibd -rw-rw---- 1 mysql mysql 8.7K Jan 31 14:52 mdl_tool_usertours_steps.frm -rw-rw---- 1 mysql mysql 128K Jan 31 14:52 mdl_tool_usertours_steps.ibd -rw-rw---- 1 mysql mysql 8.6K Jan 31 14:52 mdl_tool_usertours_tours.frm -rw-rw---- 1 mysql mysql 96K Jan 31 14:52 mdl_tool_usertours_tours.ibd -rw-rw---- 1 mysql mysql 8.7K Sep 13 2013 mdl_upgrade_log.frm -rw-rw---- 1 mysql mysql 8.8K Sep 13 2013 mdl_url.frm -rw-rw---- 1 mysql mysql 27K Jan 24 2015 mdl_user.frm -rw-rw---- 1 mysql mysql 392K Feb 17 09:34 mdl_user.ibd -rw-rw---- 1 mysql mysql 8.8K May 28 2015 mdl_user_devices.frm -rw-rw---- 1 mysql mysql 144K Jun 19 2015 mdl_user_devices.ibd -rw-rw---- 1 mysql mysql 8.7K Sep 13 2013 mdl_user_enrolments.frm -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_user_info_category.frm -rw-rw---- 1 mysql mysql 8.5K Jan 24 2015 mdl_user_info_data.frm -rw-rw---- 1 mysql mysql 9.2K Sep 13 2013 mdl_user_info_field.frm -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_user_lastaccess.frm -rw-rw---- 1 mysql mysql 8.5K May 28 2015 mdl_user_password_history.frm -rw-rw---- 1 mysql mysql 112K May 28 2015 mdl_user_password_history.ibd -rw-rw---- 1 mysql mysql 8.6K Jan 24 2015 mdl_user_password_resets.frm -rw-rw---- 1 mysql mysql 112K Mar 31 2016 mdl_user_password_resets.ibd -rw-rw---- 1 mysql mysql 13K Sep 13 2013 mdl_user_preferences.frm -rw-rw---- 1 mysql mysql 8.7K Sep 13 2013 mdl_user_private_key.frm -rw-rw---- 1 mysql mysql 8.9K Sep 13 2013 mdl_wiki.frm -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_wiki_links.frm -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_wiki_locks.frm -rw-rw---- 1 mysql mysql 8.8K Sep 13 2013 mdl_wiki_pages.frm -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_wiki_subwikis.frm -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_wiki_synonyms.frm -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_wiki_versions.frm -rw-rw---- 1 mysql mysql 11K Jul 11 2016 mdl_workshop.frm -rw-rw---- 1 mysql mysql 112K Jul 11 2016 mdl_workshop.ibd -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_workshop_aggregations.frm -rw-rw---- 1 mysql mysql 9.1K Sep 13 2013 mdl_workshop_assessments.frm -rw-rw---- 1 mysql mysql 9.1K Sep 13 2013 mdl_workshop_assessments_old.frm -rw-rw---- 1 mysql mysql 8.7K Sep 13 2013 mdl_workshop_comments_old.frm -rw-rw---- 1 mysql mysql 8.8K Sep 13 2013 mdl_workshop_elements_old.frm -rw-rw---- 1 mysql mysql 8.7K Sep 13 2013 mdl_workshop_grades.frm -rw-rw---- 1 mysql mysql 8.7K Sep 13 2013 mdl_workshop_grades_old.frm -rw-rw---- 1 mysql mysql 9.8K Sep 13 2013 mdl_workshop_old.frm -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_workshop_rubrics_old.frm -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_workshop_stockcomments_old.frm -rw-rw---- 1 mysql mysql 9.1K Sep 13 2013 mdl_workshop_submissions.frm -rw-rw---- 1 mysql mysql 8.9K Sep 13 2013 mdl_workshop_submissions_old.frm -rw-rw---- 1 mysql mysql 13K Sep 13 2013 mdl_workshopallocation_scheduled.frm -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_workshopeval_best_settings.frm -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_workshopform_accumulative.frm -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_workshopform_comments.frm -rw-rw---- 1 mysql mysql 8.7K Sep 13 2013 mdl_workshopform_numerrors.frm -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_workshopform_numerrors_map.frm -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_workshopform_rubric.frm -rw-rw---- 1 mysql mysql 8.5K Sep 13 2013 mdl_workshopform_rubric_config.frm -rw-rw---- 1 mysql mysql 8.6K Sep 13 2013 mdl_workshopform_rubric_levels.frm
2017-02-21 12:25:59 2750 [Warning] InnoDB: Cannot open table mysql/slave_master_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting .html for how you can resolve the problem. 2017-02-21 12:25:59 2750 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened. 2017-02-21 12:25:59 2750 [Warning] InnoDB: Cannot open table mysql/slave_worker_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting .html for how you can resolve the problem. 2017-02-21 12:25:59 2750 [Warning] InnoDB: Cannot open table mysql/slave_relay_log_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshoot ing.html for how you can resolve the problem. 2017-02-21 12:25:59 2750 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened.
mysqlcheck -u root -p mysql | less . . mysql.innodb_index_stats Error : Table 'mysql.innodb_index_stats' doesn't exist status : Operation failed mysql.innodb_table_stats Error : Table 'mysql.innodb_table_stats' doesn't exist status : Operation failed mysql.slave_master_info Error : Table 'mysql.slave_master_info' doesn't exist status : Operation failed mysql.slave_relay_log_info Error : Table 'mysql.slave_relay_log_info' doesn't exist status : Operation failed mysql.slave_worker_info Error : Table 'mysql.slave_worker_info' doesn't exist status : Operation failed .Pro úplnost... Ty první dvě tabulky v seznamu (innodb_index_stats.ibd a innodb_table_stats.ibd), mají čas posledního zápisu právě v čase havárie serveru... Zkoušel jsem reinstal balíčku "mysql-community-server" stejné verze jako je instalovaná, ale i to bylo bez úspěchu. Takže mi asi zbývá postup: 1. Odinstalace - odebrat balíček "mysql-community-server"
SET FOREIGN_KEY_CHECKS=0;
a na konci to zase zapnout
SET FOREIGN_KEY_CHECKS=1;
A pak si nezapomeň hned nastavit pravidelný dump, nejlépe na jiný stroj.
Když tu db luxcal nejdříve dropneš, musí se obnova podařit.I v případě, když je poškozený Inn_DB engine? Ještě jsem včera našel nadějný postup v č.j., kterým bych to zkusil obnovit po nové instalaci mysql serveru. Pořád to nechci vzdát s ohledem na to, že se do těch webových adresářů v čase havárie nic nezapisovalo! Jen do té systémové ./mysql, jak jsem už uváděl. Ten návod je tady:
mysql> SHOW GLOBAL VARIABLES LIKE 'innodb_log_file_size';
V mém případě je 50331648.
Tiskni
Sdílej:
ISSN 1214-1267, (c) 1999-2007 Stickfish s.r.o.