C:\Program Files\MariaDB 10.11\bin>mysqlbinlog --default-character-set=utf8 mysql-abc.000003 --stop-datetime="2023-05-31 12:36:00 mysqlbinlog: unknown variable 'character-set-server=utf8'
时间: 2023-08-08 09:09:40 浏览: 55
看起来问题仍然存在。你可以尝试在命令行中使用"-f"参数来强制指定输出格式为"ROW",像这样:
```
C:\Program Files\MariaDB 10.11\bin>mysqlbinlog --default-character-set=utf8 -f ROW mysql-abc.000003 --stop-datetime="2023-05-31 12:36:00"
```
这样应该就可以避免该错误提示了。如果问题仍然存在,请检查一下my.cnf文件中是否有其他不支持的参数。
相关问题
C:\Program Files\MariaDB 10.11\bin>mysqlbinlog mysql-abc.000003 --stop-datetime="2023-05-31 12:36:00" mysqlbinlog: unknown variable 'character-set-server=utf8'
这个错误提示是因为mysqlbinlog不支持在命令行中设置字符集编码,而你在my.cnf配置文件中设置了"character-set-server=utf8",所以mysqlbinlog无法识别该参数。你可以尝试在命令行中使用"--default-character-set=utf8"来指定字符集编码,像这样:
```
C:\Program Files\MariaDB 10.11\bin>mysqlbinlog --default-character-set=utf8 mysql-abc.000003 --stop-datetime="2023-05-31 12:36:00"
```
这样应该就可以避免该错误提示了。
Neither MariaDB nor MySQL is configured as the default SGDB. See Right-Click -> Help -> MariaDB - MySQL
As an AI language model, I do not have access to your system configuration. However, the message you received suggests that neither MariaDB nor MySQL is set as the default SGDB (database management system). To check which SGDB is set as the default, you can follow the steps mentioned in the message: right-click on the program, select Help, and then select the MariaDB or MySQL option to view the configuration settings. From there, you can change the default SGDB if needed.
相关推荐
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)