how to rollback deleted data in mysql

MySQL database rollback method after misoperation, mysql database Basically, Every programmer dealing with databases (or perhaps your colleagues) will have a problem. How can I roll back MySQL quickly after a misoperation? For example, if you delete

Basically, every programmer working with the database (and probably your colleagues) will have a problem, how to quickly rollback after MySQL misoperation? For example, delete a table, forget to limit the condition, the whole table is gone. If this

In MYSQL, only INNODB and BDB Data Tables support transaction processing! Other types are not supported! * **: The default MYSQL database engine is MyISAM, which does not support transactions! If you want MYSQL to support transactions, You can

Start transaction, commit and rollback syntaxStart Transaction | Begin [Work]commit [Work] [and [No] chain] [[No] release]rollback [work] [and [No] chain] [[No] release]set autocommit = { 0 | The 1}start transaction or BEGIN statement can begin a

Start transaction, commit, and rollback syntaxStart transaction | begin [work] commit [work] [and [no] chain] [[no] release] rollback [work] [and [no] chain] [[no] release] set autocommit = {0 | 1} start transaction or begin statement can start a

You can actually see the inserted record in the current transaction. At last it was only deleted. However, Auto_increment should not delete and change the value. 1, why auto_increament did not roll back? Because the current value of the InnoDB's

A simple test: starttransaction; insertintotb1values (3, repeat (#39; a #39;, 65000), #39; x #39;, 1); -- commit; rollback; these are the size of files after tb1.ibd is inserted, before rollback, and after Rollback: someone asked in the QQ group :...

Why does MySQL rollback cause an increase in the ibd file ?, Mysqlibd A simple test: start transaction;insert into tb1 values(3, repeat('a', 65000),'x',1);--commit;rollback; These are the sizes of files after tb1.ibd is inserted, before rollback,

Why does MySQL rollback cause an increase in ibd files?A simple test: start transaction; insert into tb1 values (3, repeat ('A', 65000), 'x', 1); -- commit; rollback; these are the size of the files after rollback before tb1.ibd is inserted and

In order to ensure data security, the data needs to be backed up regularly. There are a number of ways to backup, and the effect is different. Once there is an error in the data in the database, you need to use the backed-up data for restore