When managing databases and systems, we often need to delete rm files. Since there is no Recycle bin in Linux, after rm deletes a file or directory, data cannot be found and recovered from the so-called recycle bin in Windows. In this case, after the data is deleted by mista
Then enter the database password, and then enter:
The code is as follows
Copy Code
Reset Master;
This will erase all the cache mysql-bin.
Second, limit the generation of Mysql-bin
Cached files are still useful and can be used to
Tags: amp cpp script alt show SDA body t permission to install1 Get root access switch root2 Install E2fsprogs, some Linux comes with, some do not own, need to install3 Debugfs/dev/sda3 (the file is in the same partition)4 Wait until debugs: Enter Lsdel (lists the deleted files) please wait5 depending on the deletion time, find the inode number of the file6 Dump Do not modify and write the file once it has been mistakenly deleted, because it is restor
Using grep to restore accidentally deleted text files as long-term computer users will certainly experience accidental file deletion. files deleted on MacOSX and Windows will be imported to the recycle bin by default. In Linux, if you do not use the alias (alias) to modify t
Many users in the use of 360 security guards to clean up the computer, often because of carelessness or 360 identify problems, the important documents are cleaned together. Users familiar with the 360 security guards know that 360 of the files will not go into the Recycle Bin, when users use 360 to clean up the files,
Recover data: Restore deleted files in LinuxRecover data: Restore deleted files in LinuxGuideHave you ever encountered such a thing? When you find out, you have deleted the key or usedThe "rm" command mistakenly deletes an object that should not be deleted.
In the first case, you can go to the garbage
Currently, most of the Linux file systems are in Ext3 format. Once a file is deleted, it may not be restored, even if it can be recovered. Therefore, executing the rm command becomes abnormal. Therefore, we can write two Shell scripts to safely delete and restore files. The principle is very simple. Create a hidden folder ". temp" under the current user's home directory, which is equivalent to the
/extundelete-0.2.4.tar.bz2
# Tar-jxvf extundelete-0.2.4.tar.bz2
# Cd extundelete-0.2.4
#./Configure -- prefix =/usr/local/extundelete# Make make install
3. verify whether the installation is successful
# Cd/usr/local/extundelete/bin#./Extundelete-v---------------------Extundelete version 0.2.4Libext2fs version 1.41.12Processor is little endian.---------------------4. restore data
Example: if we accidentall
Restore accidentally deleted files in CentOS
In CentOS, if a file is accidentally deleted, perform the following steps to restore the file.
1. Disable all services
When a file is accidentally deleted, in order to restore data as much as possible, you must first disable all ongoing services and do not write data. Other
Tags: family spro href Local re-mount find profile using LinOverviewIn the operation of Linux system operations, often encountered due to careless operations, operation errors and other causes of file data loss, especially for customers in the enterprise some novice. Of course, this refers to the total deletion, that is, can not be recovered through the "Recycle Bin" situation, such as the use of "RM-RF" to
the current running status of port 22.
# Lsof-I: 22
Command PID user FD type device size node name
Sshd 1409 root 3u ipv6-5678 tcp *: SSH (Listen)
View the TXT file opened by the root user process:
# Lsof-a-u root-D txt
Command PID user FD type device size node name
Init 1 root TXT Reg 38432 1763452/sbin/init
Mingetty 1632 root TXT Reg 14366 1763337/sbin/mingetty
Mingetty 1633 root TXT Reg 14366 1763337/sbin/mingetty
Mingetty 1634 root TXT Reg 14366 1763337/sbin/mingetty
Mingetty
Restore accidentally deleted files under CentOS6.x
When you realize that a file is accidentally deleted, do not write the file frequently. Otherwise, your data recovery volume will be small. What we need to do is to immediately stop all the services on the server and directly killall the process name or kill-9 pid. Then, mount the partition where the file is accidentally deleted and remount it to ro, read-o
Restore the MySQL database tutorial log files
If the MySQL server has binary logs enabled, you can use the MySQL tutorial Binlog tool to recover data starting at a specified point in time (for example, from your last backup) until now or another specified point in time. "Mysqlbinlog: Utility for processing binary log files."To recover data from a binary log, you
1, we in the XP system clicks "starts"--> "runs" then opens the window to enter Regedit to open the registry
2, and then in the Open registry we locate to open: Hkey_local_machime/software/microsoft/windows/currentversion/explorer/desktop/nemespace In the left margin, click "New", select "PRIMARY Key", named "645ffo40-5081-101b-9f08-00aa002f954e", and then we click "Default" PRIMARY key value set to "Recycle
UnrmHttp://packetstormsecurity.com/UNIX/utilities/unrm-0.92.tar.gzA small tool actually uses the debugfs command in Linux, which simplifies the steps for manual use of debugfs,There is no interactive interface, and the recovered files are directly placed under a fixed directory.
According to this situation, the tools that are bulky and need to be installed are out of the Selection Range. I used unrmWithout damaging the data disk content, I put this t
If the MySQL server has binary logging enabled, you can use the Mysqlbinlog tool to recover data starting at a specified point in time (for example, from your last backup) until now or another specified point in time. "Mysqlbinlog: Utility for processing binary log files."
To recover data from a binary log, you need to know the path and file name of the current binary log file. You can generally find the path from the option file (that is, my.cnf or
If the MySQL server has binary logging enabled, you can use the Mysqlbinlog tool to recover data starting at a specified point in time (for example, from your last backup) until now or another specified point in time. "Mysqlbinlog: Utility for processing binary log files."
To recover data from a binary log, you need to know the path and file name of the current binary log file. You can generally find the path from the option file (that is, my.cnf or
Recover data: Restore deleted files in LinuxGuideHave you ever encountered such a thing? When you find out, you have deleted the key or usedThe "rm" command mistakenly deletes an object that should not be deleted.
In the first case, you can go to the garbage bin, search for the file, and restore it to the original loca
files, dozens of GB, use the following command to restore all
Cd/data/recovery
Nohup/data/recovery/ext3grep/bin/ext3grep/dev/sda8 -- restore-all
# Nohup and are recommended because it takes a long time to partition
Note that the restore-all parameter restores and backs
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.