Skip to navigation Skip to content Change Is InevitableChange-Is-InevitableChange Is Inevitable
Menu
  • Home
  • MySQL
    • MySQL-Articles
    • MySQL-Scripts
    • MySQL Resources
  • Technical
    • QA-Testing
  • General
    • Review
    • Just for fun
    • Personal
  • Contact Me
    • Copyright
  1. Home
  2. Posts tagged “binary log”

Tag: binary log

MySQL MySQL-Articles

2 many dots can break your replication only once

Two or more dots in your relay log or binary log names can break replication; but worry not, it will only do it once. If you request to start again, it will work. That’s it, that’s the blog. Should you choose to spend some more time, go ahead. A new MySQL 5.7 GTID replication chain […]

August 19, 2021August 19, 2021
0
MySQL MySQL-Articles

Restore / Recover dropped MySQL database from binary logs

In this post I will share a recovery scenario of a MySQL database restore from the binary logs. Recently someone accidentally dropped an important MySQL database and the backup was not present! As we know the the binary log contains DMLs to table data and that’s where our hope lies. Luckily the binary log retention […]

February 23, 2015April 6, 2015
0

Sidebar

Search:

  • MySQL 8 – timestamp cannot be null and explicit_defaults_for_timestamp
  • Restore single MySQL table from Xtrabackup (video demo)
  • MySQL Interview – ChatGPT is not your DBA
  • Securing MySQL: Data Encryption with Percona Server and Vault
  • Can not connect to ProxySQL: reasons and fixtures
Top