hello everyone, would someone like to help me troubleshoot this issue?
db_1 | 2019-07-09T13:39:30.795926Z 0 [Warning] InnoDB: Cannot open table mysql/plugin from the internal data dictionary of InnoDB though the .frm file for the table exists. Please refer to dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how to resolve the issue.
db_1 | mysqld: Table 'mysql.plugin' doesn't exist
db_1 | 2019-07-09T13:39:30.795968Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
db_1 | 2019-07-09T13:39:30.830946Z 0 [Warning] InnoDB: Cannot open table mysql/gtid_executed from the internal data dictionary of InnoDB t…
that's mysql 5.7 inside a docker container starting up after probably erroneously removing ib* files from its data directory
Thanks for the suggestion. Did that, came up with nothing useful. I was more hoping for a bit of interactive troubleshooting or quick suggestions. I'll just wipe the installation and restore from a backup.
@mustaccio The DISCARD TABLESPACE thing worked well for the lost non-system tables that I can easily restore in an empty fashion with CREATE TABLE and then recover the .ibd data. But for the mysql database I don't know how to create them, particularly since mysqld refuses to initialize with existing data. But what I did not was just destroying the entire Docker data volume, setting up MySQL from scratch, and restoring the user tables.
I should add that I'm aware my initial question was nowhere detailed enough to give you guys an indication of what I've tried.