How do I restore the data of a truncated table?
相关问题
- sqlyog export query result as csv
- NOT DISTINCT query in mySQL
- MySQL: conduct a basic search
- Why sometimes there is one of more gap(s) in the v
- mySQL alter table on update, current timestamp
http://dev.mysql.com/doc/refman/5.0/en/truncate-table.html
You can restore a table from a backup, if it was
The only way is backups or if you have binary logs that contain all the data.otherwise you cannot restore data :(