› MySQL 5.5 Community Server
› MySQL 5.6 Community Server
› Percona Configuration Wizard
› XtraBackup 搭建主从复制
Great Sites on MySQL
› Percona
› MySQL Performance Blog
› Severalnines
推荐管理工具
› Sequel Pro
› phpMyAdmin
推荐书目
› MySQL Cookbook
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
这是一个创建于 1592 天前的主题，其中的信息可能已经有所发展或是发生改变。
系统是 debian 10，跟着这个文档下载安装了 mysql 8.0.21, 不过在执行 dpkg -i mysql-{common,community-client,client,community-server,server}_*.deb 的时候有依赖错误，所以我手动拆开成了几条命令先后执行，然后安装也成功了
dpkg -i mysql-common...deb
dpkg -i mysql-community-client...deg
dpkg -i mysql-client...deb
dpkg -i mysql-community-server...deb
dpkg -i mysql-server...deb
但是启动的时候报错
[MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21) starting as process 2029
[System] [MY-011012] [Server] Starting upgrade of data directory.
[System] [MY-013576] [InnoDB] InnoDB initialization has started.
[ERROR] [MY-012224] [InnoDB] Tablespace flags are invalid in datafile: ./ibdata1, Space ID:0, Flags: 21. Please refer to http://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
[ERROR] [MY-012237] [InnoDB] Corrupted page [page id: space=0, page number=0] of datafile './ibdata1' could not be found in the doublewrite buffer.
[ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Data structure corruption.
[ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
[ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
[ERROR] [MY-010119] [Server] Aborting
[System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21) MySQL Community Server - GPL
我跟着错误日志中的链接去设置了 innodb_force_recovery = 1, 再重启 systemctl restart mysql.service , 又报错了
[System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21) starting as process 1169
[System] [MY-011012] [Server] Starting upgrade of data directory.
[System] [MY-013576] [InnoDB] InnoDB initialization has started.
[ERROR] [MY-012936] [InnoDB] Database upgrade cannot be accomplished with innodb_force_recovery > 0
[ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
[ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
[ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
[ERROR] [MY-010119] [Server] Aborting
[System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21) MySQL Community Server - GPL
我是 mysql 菜鸡，技穷了，请各位大佬指点一手，现在是刚安装，没有数据，所以怎么搞都可以🙏
 |
1
skiy 2020-07-14 11:34:32 +08:00
如果是我，我先用集成包尝试一下。如果能正常安装，那我再去看它的安装脚本是怎么写的。
|
 |
2
justin2018 2020-07-14 11:51:00 +08:00
https://lnmp.org/ 这个可以试一试 😅
|
 |
3
noobma OP |
 |
4
wtks1 2020-07-14 12:59:24 +08:00 via Android
其实如果只是尝试一下，完全可以用 docker 来装的，用别人做好的镜像，基本不会出问题
|
 |
5
ZehaiZhang 2020-07-14 13:05:40 +08:00
一直都是 docker run 出来的🐶
|
 |
6
fhsan 2020-07-14 13:05:44 +08:00
1 如果是我，apt-get
2 如果是我，make make install 3 偶尔会 dpkg，毕竟当初就是这样 debian 安装 sougou deb 的 |
 |
7
newtype0092 2020-07-14 13:58:03 +08:00
你这就是有个旧表数据和新版 MySQL 不兼容啊，如果没有数据就是以前的遗留数据，去 data 文件夹下删空就行。
|
 |
8
zhangysh1995 2020-07-14 14:35:47 +08:00
配置文件写错了吧 => Tablespace flags are invalid in datafile: ./ibdata1, Space ID:0, Flags: 21. Please refer to http://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
|
 |
9
openbsd 2020-07-14 15:04:37 +08:00
不是 glibc 一把梭吗 ？
|
 |
10
madpecker009 2020-07-14 15:09:40 +08:00
@justin2018 mac 可以用这个吗？
|
|
11
noobma OP @newtype0092 大佬你这一说，感觉是的，以前有个 mariadb，可能是 maria 的数据
|
Select Language