Mysql5.6
改成MySQL 10-MariaDB
之后恢复完数据库,就打不开了,
查看了下后台日志:
### 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[0m
数据库问题。
尝试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
,然后导入成功,网站打开正常。