Mysql Data File Deletion, operating system level recovery file, mysql level
Under what backup conditions is the Data File deleted and restored?
Restrictions
1. Do not use data blocks to be restored
2. The file system is not damaged.
Use tool ext3grep, http://code.google.com/p/ext3grep/
Install
./Configure
Make
Make install
Mount
Ls-id: directory of the file system where the data file is stored -- View inode
Directory of the file system where umount data files are stored
Ext3grep/dev/sdb1 -- ls -- inode 2
Ext3grep/dev/sdb1 -- ls -- inode 3
Ext3grep/dev/sdb1 -- ls -- inode 4
Ext3grep/dev/sdb1 -- restore-inode 2 -- run in an empty directory
Mv./RESTORED_FILES/inode.2 t3.MYI
Ext3grep/dev/sdb1 -- restore-inode 3
Mv./RESTORED_FILES/inode.3 t3.MYD
Ext3grep/dev/sdb1 -- restore-inode 4
Mv./RESTORED_FILES/inode.4 t3.frm
Cp t3 */home/mysql/db1
Chown mysql: mysql t3 *
The extundelete tool is similar to ext3grep to restore the ext4 type.
Extundelete/dev/sdb1 -- inode 2
Extundelete/dev/sdb1 -- restore-inode 2