ignores tables for the specified engine-M,--no-schemas no table structure-K,--no-locks does not add temporary share read lock, which may cause inconsistent data--less-locking InnoDB table, minimum time lock-L,--long-query-guard set the maximum query time, default is 60s-K,--kill-long-queries to kill the long query-D,--daemon open daemon mode-I,--snapshot-interval snapshot time, default is 60s-L,--logfile log file, default is standard output--TZ-UTC sets the time zone, which is used only when th
First, the introduction of rsync
Rsync is a data mirroring Backup tool under the Linux system that enables you to back up local system data over the network to any remote host, and Rsync has the following characteristics:
Can be mirrored to save the entire directory tree and file system
Data can be incrementally synchronized, file transfer efficiency is high, so synchronization time is very short.
You can keep attributes such as permissions, time,
recursively on directories (sets also-m)-l:compress using Legacy format (Linux kernel compression)-b#: Block size [4-7] (Default:7)-bd:block dependency (improve compression ratio)--no-frame-crc:disable Stream Checksum (default:enabled)--content-size:compressed frame includes original size (Default:not present)--[no-]sparse:sparse mode (default:enabled on file, disabled on stdout)Benchmark arguments:-b#: Benchmark file (s), using # compression level (DEFAULT:1)-e#: Test all compression levels fr
supports up to SQL 2008 and SQL 2012. The trial version provides a free trial period with no limit of 14 days.
Download and install the tool directly. Official Website:
After the installation is complete, open the main interface:
Click "New ":
Enter the database information and click "Open ":
Click "Evaluate Product ":
The table lists the operations performed previously. Right-click the row with incorrect operations and many
XP System Stop Service Recovery Tool Encyclopedia-antivirus software XP Special Edition list:
Recommend 1:100 degrees Guardian XP Escort Special Edition
Baidu Guardian first launched the "XP Escort program." With other security products "patching" way of continuous maintenance WinXP system, Baidu Guardian launched the "XP user solution" in the concept of commitment to "no harassment, not coe
Oracle DBA's Artifact: PRM recovery Tool, which runs from Oracle software and reads data directly from Oracle data filesPRM is all called Parnassusdata Recovery Manager, by the Tan software independent research and development, with independent software copyright. The PRM can be run independently of the Oracle software, extracting data from the table directly fro
| Mysql-uusername-p--force-read,-FWhen this parameter is used, the Mysqlbinlog tool prints out warning when it reads an unrecognized log event, ignores the event and resumes execution, Mysqlbinlog stops without this parameter.Mysqlbinlog vms00781-bin.000001-d testdb-f | Mysql-uusername-p--no-defaultsPrevents the Mysqlbinlog tool from reading parameters from any profile, except for. MYLOGIN.CNF (for safe pa
parameters that can be used #--database db_name Specifies only incremental recovery of data db_name the specified database #--start-position Specifies the Binlog point at which to start the recovery, which should exist in the specified first Binlog file. #--stop-position Specifies the Binlog site to revert to, which should exist in the last Binlog file specified. #--START-DATETIME Specifies the point in ti
their event locations 1: Record location in change MASTER to, can be used for recovery after direct start from the server 2: Record location in change MASTER to, but is commented by default --lock-all-tables,-x: Lock All tables --flush-logs,-F: Performing log scrolling --events,-E: Backup Event Scheduler --routines,-r: Backing up stored procedures and storage functions --triggers: Backup Trigger --all-databases,-A: Backing Up all libraries --database
SQL file does not necessarily back up the database creation statement, so when restoring, the database to be saved has already been created, otherwise it cannot be restored.Third, restore the database using the source commandUsing the source command, you need to log in to the database and invoke the command in the database operator interface to restore it, with the following syntaxSource path/file name. sqlThe above is the process of using mysqldump for the whole library backup and restoreUse M
back without the delete data. So execute two commands:F:\Program files\mysql_data\data\log>Mysqlbinlog liangck.000002--stop-pos=875 | Mysql-uroot-pF:\Program files\mysql_data\data\log>Mysqlbinlog liangck.000002--start-pos=1008 | Mysql-uroot-p mytestOK, now the second log file has data.The third log file is also the same, as long as you find the location of the drop table.F:\Program files\mysql_data\data\log>Mysqlbinlog liangck.000003--stop-pos=574 | Mysql-uroot–pNow let's look at the data and s
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.