Mysql5.6改成MySQL 10-MariaDB之后恢复完数据库,就打不开了,
HTTP Status 500 – Internal Server Error...
查看了下后台日志:

### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: Table 'xxx_com.config' doesn't exist
### The error may exist in class path resource [mapper/ConfigMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: select * from config where id = 1
### Cause: java.sql.SQLSyntaxErrorException: Table 'xxx_com.config' doesn't exist
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Table 'xxx_com.config' doesn't exist

数据库问题。
尝试PHPmyadmin手动导入数据库,出现错误

Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.

打开数据库文件查找ROW_FORMAT=COMPACT替换为ROW_FORMAT=DYNAMIC,然后导入成功,网站打开正常。

Last modification:April 25th, 2021 at 11:23 am
如果觉得我的文章对你有用,请随意赞赏