分类 问题记录 下的文章

1、确保log_bin已开启

show variables like '%log_bin%';

2、查看bin_log文件目录

show variables like '%datadir%';

QQ截图20210716101452.png

3、进入bin_log文件目录,找到日志文件,文件名为mysql-bin.000xxx

cd /www/server/data/
ll

QQ截图20210716102437.png

4、复制mysql-bin文件,防止后续操作对其造成影响
5、使用mysqlbinlog(在mysql/bin目录中)工具,将日志导出sql

mysqlbinlog -d [database] mysql-bin.000006 > 006bin.sql

6、编辑导出的sql文件,将误删除语句剔除
7、执行sql文件

mysql -u root -p 123456 [database] < 006bin.sql 

搞定。

1、SignalR前端连接失败,出现以下错误

Failed to start the transport 'WebSockets': Error: There was an error with the transport.

问题:Nginx不支持WebSocket
解决方法:需要修改Nginx配置

location /hubroute {
  # Configuration for WebSockets
  proxy_set_header Upgrade $http_upgrade;
  proxy_set_header Connection $connection_upgrade;
  proxy_cache off;
  # WebSockets were implemented after http/1.0
  proxy_http_version 1.1;
}

文档:https://docs.microsoft.com/zh-cn/aspnet/core/signalr/scale?view=aspnetcore-5.0#linux-with-nginx

2、HttpClient https请求出现证书问题

The SSL connection could not be established, see inner exception. The remote certificate is invalid according to the validation procedure.

解决方法:将系统证书复制到OpenSSL目录中

cp /etc/pki/tls/cert.pem /usr/local/openssl/

今天重装完Android Studio,启动模拟器时出现了以下问题

Emulator: dsound: Could not initialize DirectSoundCapture 15:37 Emulator: dsound: Reason: No sound driver is available for use, or the given GUID is not a valid DirectSound device ID 15:37 Emulator: dsound: Attempt to initialize voice without DirectSoundCapture object 15:37 Emulator: dsound: Attempt to initialize voice without DirectSoundCapture object 15:37 Emulator: audio: Failed to create voice goldfish_audio_in‘ 15:37 Emulator: D:\buildSoft\android-studio\sdk\emulator\qemu\windows-x86_64\qemu-system-i386.exe: warning: opening audio input failed 15:37 Emulator: dsound: Attempt to initialize voice without DirectSoundCapture object 15:37 Emulator: dsound: Attempt to initialize voice without DirectSoundCapture object 15:37 Emulator: audio: Failed to create voice adc’

找了好久终于找到了解决方法:

https://jingyan.baidu.com/article/a65957f434890a24e67f9bfc.html

1、打开系统声音设置,打开声音控制面板

QQ截图20190322172307-768x435.png

2、将录制里的立体声混音打开

QQ图片20190322172353-238x300.png

3、重启模拟器,OK