1

create table user (
uid int not null primary key,
name varchar(255) not null,
money int
)

select * from user

cd C:\Program Files\MySQL\MySQL Server 8.0\bin
mysqldump -uroot -h127.0.0.1 -pFuchen20050420 -P3306 db9 user>save_user.sql
mysql -uroot -pFuchen20050420  sb9 < save_user.sql

前

后

2

create table user2 (
uid int not null primary key,
name varchar(255) not null,
money int
)
insert into user2 values(1, "A", 2000)
insert into user2 values(2, "B", 3000)
select * from user2
delete from user2 where uid=1
delete from user2 where uid=2

mysql -uroot -pFuchen20050420
show variables like '%log_bin%';

show binlog events in 'LAPTOP-BSNKQAAO-bin.000074';
exit

mysqlbinlog  --no-defaults --start-position=4594  --stop-position=4884
 "C:\ProgramData\MySQL\MySQL Server 8.0\Data\LAPTOP-BSNKQAAO-bin.000074" | mysql -uroot -pFuchen20050420
 
mysqlbinlog  --no-defaults "C:\ProgramData\MySQL\MySQL Server 8.0\Data\LAPTOP-BSNKQAAO-bin.000074"

mysqlbinlog  --no-defaults  --start-datetime="20250517111421"  --stop-datetime="20250517111519" "C:\ProgramData\MySQL\MySQL Server 8.0\Data\LAPTOP-BSNKQAAO-bin.000074" | mysql -uroot -pFuchen20050420

前

后