After the alter tbname drop column, how to recover deleted data column?-CodePudding

Home > database > After the alter tbname drop column, how to recover deleted data column?

After the alter tbname drop column, how to recover deleted data column?

Time：09-26

RT, operation today, the development to delete this column, and then deleted,,
How to put this column data recovered now?
Find the binary log, didn't find these data, how to do?

CodePudding user response:

Get the latest time of complete, and then execute the statement in the BINLOG recovery,

CodePudding user response:

For the latest backup recovery.

CodePudding user response:

No backup is restored, the last time to find your perfect + binlog recovery,

Page link：https//www.codepudding.com/database/34390.html

Prev:Create a mysql InnoDB Cluster times wrong

Next:Query project list, a user can approval of the project, how to write a script?

Tags：

MySQL

Links：
CodePudding