restore

[dotKer]

I have a database named "DB07".
The DB09 has 9 tables.
This morning I wanted truncate a table named "table06".
I accidently did truncate a table named "table07" instead of "table 06" using phpMyAdmin.
There were thousands of records in "table07".
Now there is no record in "table07".
Can I resore the all records which were in "table07" with your help?

On the way of trying to restore the records in "table07"
I found the following

There is no "table07" in mysql > backup > mysql > backup.
There is table07.frm and table07.ibd in mysql > data > DB07
The last modified time of table07.frm is before accidental truncate time.
The last modified time of table07.idb is after accidental truncate time.

[Nobbie]

You need a backup of your data. If you dont have a backup, the truncated data is gone.

The backup folder does not provide backups, its for internal use only. You need your own backup. Table.frm only keeps the table definition (which columns and which type), not the table data. Table.frm remains untouched from a truncate, which deletes the data.