Clever Geek Handbook

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
mysql


source to share


No one has answered this question yet

Check out similar questions:

2568
Should I be using the datetime or timestamp datatype in MySQL?
1762
How to import SQL file using command line in MySQL?
1290
How do I get a list of user accounts using the command line in MySQL?
1105
How to reset AUTO_INCREMENT in MySQL?
1086
How to connect to MySQL database in Python?
809
Insert into MySQL table or update if exists
769
How to get the sizes of MySQL database tables?
367
How do I select the nth row in a SQL database table?
285
How to export and import .sql file from command line with parameters?
0
How to recover data from mysql table?


More articles:


All Articles
Loading...
X
Show
Funny
Dev
Pics