morning for 30 days. The Binlog retention time for the main library is 7 days.So it's easy to think of a way to recover from the early 2014-09-25 backup of the library, and then through the main library Binlog through the time period to filter out the early morning to 2014-09-25 21:53:56 all changes, after the data, confirmed by the business can be discarded. Or to find out this part of the data in some other way later. But the immediate task is to restore the database immediately.
Third, find
How to modify the File Creation Time and query in Solaris
Lab Demonstration:
1. Check time
[[Email protected]:/] # dateTue Jul 15 21:37:01 CDT 2014
-- If the time is incorrect, modify the format as follows:[[Email protected]:/] # date 0715221114 -- July 15, 2014Tue Jul 15 22:11:00 CDT 2014
2. Create an experiment environment
[[Email protected]:/] # mkdir Test
[[Email protected]:/] # cd Test
[[Email protected]:/test] # Touch test1[[Email protected]:/test] # Touch Test2[[Email protected]:/test] #
When the CentOS 7.0 installation is complete, the NIC is not powered on by default, and the name of the NIC is changed. In CentOS 5 and the previous system Nic named eth0 eth1 such name, and to the CentOS 6 era the name of the network card changed to EM1 em2 such name, the larger changes appear in the CentOS 7 era, the name of the network card changed directly into ens192 The appearance of eno12312 and so on. The following is specific to the CentOS 7.0 network adapter configuration operation.Sys
Job 4:One, wildcard practice:1, Show/etc directory, start with a letter, followed by a non-letter and any other arbitrary length of any character file or directory;[[email protected] fuboyuan]# ls-l/etc/[[:alpha:]]*[^[:alpha:]] 2. Display the/usr/share/man directory, all the files or directories that begin with man, followed by a number;[[email protected] fuboyuan]# Ls-ld/usr/share/man/man[0~9]3, copy/etc directory, so P,m,r start, and the. conf end of the file or directory to the/TMP/CONF.D dir
examples Example 1 : Lists the contents of the current directorycommand:lsls The file and directory under the current directory are listed without any arguments after the command[Email protected] ~]# lsanaconda-ks.cfg cplogs.sh Documents install.log Music public tmpautouserdel.sh Desktop Downloads install.log.syslog Pictures Templates videos[[email protected] ~]# Example 2 : Lists all files in the current directorycommand:ls-a[Email protected] ~]# ls-a. Bash_history cplogs.sh Downloads. Gnot
2016-01-30 Mount Failure Problem resolution[Email protected] ~]# MOUNT/DEV/SDC/DTAMount:you must specify the filesystem type[Email protected] ~]#[Email protected] ~]# mount-t ext4/dev/sdc1/dataMount:wrong fs type, bad option, bad Superblock ON/DEV/SDC1,Missing codepage or helper program, or other errorIn some cases useful info are found in Syslog-tryDMESG | Tail or so[[emailprotected] ~]# cat/proc/filesystemsnodev sysfsnodev rootfsnodev bdevnodev procnodev Cgroupnodev Cpusetnodev tmpfsnodev de
large business, semi-synchronous is also relatively weak situation, performance loss is large.Installation usebelow to see how to install the use of semi-synchronous, most of the MySQL itself is not preloaded with semi-synchronized components, need to install additional, but the general MySQL package will bring the so file, so as long as the manual loading can be used.First check if there's no outfit.Mysql> Show plugins;Find out if there are semisync letters, there is is installed, no is not in
log, location of all log stores2.3 ls CommandLs-l Listing Details[[emailprotected] ~]# ls-l anaconda-ks.cfg rw-------. 1 root root 1464 May 22:25 anaconda-ks.cfgls-i List i node information [[emailprotected] ~]# ls-i anaconda-ks.cfganaconda- Ks.cfgls-lh-h display file size in a clearer, readable manner [[emailprotected] ~]# ls-lh anaconda-ks.cfg rw-------. 1 root root 1.5K May 22:25 anaconda-ks.cfgls-la-a Show hidden files or directories [[emailprotected] ~]# ls-la total usage 32dr-
The newly installed Mac system 10.10, JDK is 1.8, because some tools to use JDK 6, the following is the setup processView versionJava-versionSee Java again: in/usr/bin/java Cd/usr/binls-all | grep javalrwxr-xr-x 1 root wheel 9 00:23 java-/system/library/frameworks/javavm.framework /versions/current/commands/javalrwxr-xr-x 1 root wheel 9 00:23 javac-/system/library/ Frameworks/javavm.framework
{} \;/bin/find: '/enterprise Db_backup/postgresql/network-scripts ': No such file or Directory[[email protected] ~]# echo $?1
Obviously, the above command returned the wrong result, but the customer reflected that the data in the folder 7 days before the script execution was deleted.
Problem Analysis:
To reproduce the failure. This issue is analyzed in a separate server that performs the find command by simulating data alone. Test steps such as the following:
the previous backup if you need to overwrite the file.-f:force mandatory Meaning, if the target file already exists, will not be asked and directly covered;-I: If the target file (destination) already exists, you will be asked to overwrite it!-U: If the target file already exists and source is newer, update (update)-T:--target-directory=directory move all source arguments into directory, which is the target directory for the specified MV, which is suitable for moving multiple source files to a
./sbin16k ./lost+found264k /home86m. /boot328g ./var4.0k. /dev0. /sys330g .Take a look at the occupancy in VAR (MySQL data is placed in Lib, www is the website with some related backup)Lltotal 72drwxr-xr-x root root 4096 Sep 02:50./drwxr-xr-x root root 4096 Sep 23 02:45. /DRWXRWXRWX 3 root root 4096 Sep 06:33 backups/drwxr-xr-x roo
applications) Cimne Products:Cervenka Consulting GiD 13.1.4d Win64 1CDCimne GiD Professional 13.0.4 Win32 1CDGid. professional.v11.1.8d.win32_64 2CD (geometric modeling and numerical simulation tools. and provide visual analysis of the results. Can be locatedNumerical simulation of solid and structural mechanics, fluid mechanics, electromagnetics, heat conduction and other disciplines)GID v8.0.9 Linux 1CDGID v8.0.9 Linux64 1CD Cyclepad v2.0 1CDOPOS v4.9 1CDRamseries Professional v11.0.5 1CD (th
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.