I need to revert dB to a specific day but I have no backup on that day i trying to use binary file but i got no result
mysqlbinlog --start-position=14 --stop-datetime=“2021-03-23 10:05:00” /var/lib/mysql/mysql-bin.000260 > /tmp/mysql_restore.sql
I got no data return
/!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1/;
/!40019 SET @@session.max_insert_delayed_threads=0/;
/!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0/;
DELIMITER /!/;
DELIMITER ;End of log file
ROLLBACK /* added by mysqlbinlog /;
/!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
/!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0/;