Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL master recovery from failure using binlog     - The method of Linux into the rescue mode (Linux)

- The most concise Systemd tutorial, just ten minutes (Linux)

- Oracle EBS R12 for Linux installation (Database)

- Java regular expression syntax (Programming)

- Linux crontab commands and detailed usage examples (Linux)

- Linux file permissions to modify the command: chmod (Linux)

- How to avoid two Chrome icon appears in ELementary OS Freya (Linux)

- Oracle 12c PDB Analysis (Database)

- Oracle 11g maintenance partitions (Seven) - Modifying Real Attributes of Partitions (Database)

- Zabbix system email alert Python script (Server)

- numpy and SciPy installation under Python for scientific computing package (Linux)

- Android official recommendation: DialogFragment create dialog (Programming)

- Snort build a secure Linux server (Linux)

- Windows 7 hard disk installation notes Debian (Linux)

- sqlplus connect to Oracle (Database)

- How to network to share files between Windows, MAC and Linux (Linux)

- To assign multiple IP addresses NIC on the CentOS 7 (Linux)

- To learn from scratch OpenWrt perfect tutorial (Linux)

- Linux user login ban (Linux)

- CentOS 6.6 install JDK7 (Linux)

 
         
  MySQL master recovery from failure using binlog
     
  Add Date : 2018-11-21      
         
         
         
 

MySQL master-slave failure when the first view from the database
mysql> show slave status G;

Remember bin-log of pos and binlog file (usually selected on a point nearest to recover pos) or check the time point mysql error diary,

The mysql-binlog converted to txt, you can view each database operation

mysqlbinlog   / path /mysql-bin.000xxx  > txt1.txt

use change master to master_host = 'xxxx', master_user = 'mysync', master_password = 'q123456',

master_log_file = 'mysql-bin.xxx', master_log_pos = xxx;

key in the main library and can not find the mysql synchronization pos and pos where bin-log file.

     
         
         
         
  More:      
 
- How to make Linux a non-root user uses less than 1024 ports (Linux)
- ADSL router to defend their own network security methods (Linux)
- To install Spotify in Ubuntu / Mint (Linux)
- Install Oracle JDK 8 and JVM class loading mechanism in Linux (Linux)
- Flask deploy applications using Nginx on Ubuntu (Server)
- Linux security settings Basics (Linux)
- JDK installation under CentOS (Linux)
- MySQL Installation Troubleshooting (Database)
- Ubuntu 14.04 running ASP.NET Configuration Mono + Jexus (Server)
- MySQL in order by inaccurate results in problems and solutions (Database)
- Linux firewall anti-hacker disguise malicious attacks (Linux)
- Android developers learning Adapter (data adapter) (Programming)
- Linux system Iptables Firewall User Manual (Linux)
- LVM Disk Manager Application (Linux)
- MongoDB 3.2 Cluster Setup (Database)
- Linux Apache server configure to protect system security (Linux)
- Simple RPM package production (Linux)
- Ubuntu cut screen method (Linux)
- Deepin Tutorial: Depth Description Installer expert mode (Linux)
- CentOS 6.5 installation and deployment SVN 1.8.10 (Linux)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.