Use the AWK tool in Cygwin to view mysql binlog logs

Source: Internet
Author: User
Tags mysql delete

Use the AWK tool in Cygwin to view mysql binlog logs

Linux tools are really powerful. However, as a person who does not have the right to use Linux machines or who does not use Linux for development, it is really inconvenient to use some commands, a unix-like simulation environment running on windows platform is a free software developed by cygnus solutions, which brings a lot of convenience to the use of some commands.

The first requirement is: binlog logs exported by others, 100 + Mb. It is very slow to open using a windows text editor, and it is almost too slow to be viewed, so I want to select the relevant lines and save them as another small file for easy viewing!

1. The installation of cygwinis detailed. The installation procedure is as follows: run the Installation File setup.exe again.

2. Preliminary debugging and use

The first command is the ls command. Check the current directory file and find that there are no files (check the cd/and ls commands. Is it similar to Linux );

The second command: view the current directory pwd and find/home/myhome; (in windows, you can easily add environment variables, and then quickly open cygwin: Run> minitty, then list the current directory: pwd. The directory is/cygdrive/c/Users/myhome)

The third command: knowing the directory structure, you only need to find the file you want to open, as shown below: more/cygdrive/c/Users/Desktop/binlog.20.33, then, the screen is fully blurred.

Fourth command: since Linux is used, awk must be used as a powerful text processing tool, as shown below: more/cygdrive/c/Users/Desktop/binlog.20.33 | awk-F' @ ''/tab_user [^ _]/{print NR," ==> ", $0} '> filtered-binlog.txt; in this case, the internal volume output to filtered-binlog.txt, it looks much easier. Use other useful commands. Note that the characters in the awk must use double quotation marks, which can be escaped, for example :\".

3. Click setup.exe to install the tool. (No apt-get, no yum, be sure not to conflict with windows)

In this way, you can use a variety of commands. Although apt-get, su, yum, and other commands cannot be used, other operations can be used ~

Install Python MySQLdb in Cygwin

MySQL Data Recovery-binlog

Clear binlog logs in MySQL

How to safely delete binlog logs under MySQL

MySQL -- binlog log data recovery

How does MySQL Delete binlog and restore Data?

Introduction and Analysis of Three MySQL binlog formats

MySQL uses binlog Incremental backup + restore instance

MySQL deletes binlog logs and restores data.

This article permanently updates the link address:

Related Article

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.