1、确保log_bin已开启

show variables like '%log_bin%';

2、查看bin_log文件目录

show variables like '%datadir%';

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

cd /www/server/data/
ll

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 Error while waiting for device: The emulator process for AVD was killed

网上找了好多解决方案，最后发现是磁盘空间不足...
移动avd到其他盘，搞定。

调试时出现以下问题：

Error connecting to the service protocol: failed to connect to
http://127.0.0.1:56341/vQjFLT5wAX0=/

出现此问题是因为开启了代理，解决方法：

环境中配置本地地址不通过代理

export NO_PROXY=localhost,127.0.0.1

今天重装完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、打开系统声音设置，打开声音控制面板

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

3、重启模拟器，OK