MySql recovers a deleted table

Unfortunately I am clearing one of the tables in my database and I am trying to restore it using a command mysqlbinlog

in the mysql cli since I just found out about it. How can I restore it? my bottom command couldn't execute

Command:

mysqlbinlog binary_log_file > query_log.sql

      

Terminal:

MariaDB [(none)]> mysqlbinlog binary_log_file > query_log.sql
    -> 
    -> Ctrl-C -- exit!

      

how can i execute this command in sql cli?

+3


source to share





All Articles