我在一个环境设置中,使用 MariaDB 10.0.12-MariaDB Homebrew
MariaDB 10.0.12-MariaDB Homebrew
我搞砸了安装,所以我确实从安装程序中完全删除了MySQL和MariaDB,然后重新开始。
完成MariaDB的安装后,我已innoDB通过数据库转储从生产服务器重新导入了数据库()。工作正常。在第二天重启后,我将无法再访问数据库:
innoDB
Table 'my.table' doesn't exist in engine
是什么原因造成的,解决方案是什么?我确实看到了数据库的结构,但是当我尝试访问它时,它给了我这个错误消息。
我确实尝试过mysql-upgrade --force删除rm ib_logfile1 ib_logfile0
mysql-upgrade --force
rm ib_logfile1 ib_logfile0
这里的数据丢失不是问题,问题在于,每次重新启动时,我都无法花费30分钟来重新安装每个数据库。
这是一些日志:
140730 9:24:13 [Note] Server socket created on IP: '127.0.0.1'. 140730 9:24:14 [Note] Event Scheduler: Loaded 0 events 140730 9:24:14 [Warning] InnoDB: Cannot open table mysql/gtid_slave_pos 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. 140730 9:24:14 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1932: Table 'mysql.gtid_slave_pos' doesn't exist in engine 140730 9:24:14 [Note] /usr/local/Cellar/mariadb/10.0.12/bin/mysqld: ready for connections. Version: '10.0.12-MariaDB' socket: '/tmp/mysql.sock' port: 3306 Homebrew 140730 16:26:28 [Warning] InnoDB: Cannot open table db/site 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.
某些内容已删除您的ibdata1文件,InnoDB保留了该字典。绝对不是MySQL。