开发技术学习

通过mysqlbinlog日志文件恢复mysql数据库.

操作前选备份mysqlbinlog日志文件；通过mysqlbinlog恢复数据库：--stop-datetime结束时间,可以指定bin文件/www/server/mysql/bin/mysqlbinlog --stop-datetime="2023-04-27 17:35:27" /www/server/data/mysql-bin.000001 > redata.sql不需要这一步：/www/server/mysql/bin/mysqlbinlog --base64-output=DECODE-ROWS -v -d kfju_com /www/server/data/mysql-bin.000001 > redata.sql/www/server/mysql/bin/mysqlbinlog --no-defaults --stop-datetime="2023-04-27 17:35:27" /www/server/data/mysql-bin.000001 -d kfju_com >...