Question : My installed versions of MariaDB and Percona Toolkit on MacBook: brew info percona-toolkit percona-toolkit: stable 3.0.10 (bottled), HEAD […]
Tag: mysqlbinlog
MySQL : Extract SQL statements from binlog
Question : I am trying the following command to extract SQL statements from binlog for using it in another database […]
what happens If I remove mysql-bin.index file?
Question : Because of the file storage full, we are removing mysql bin log files. Accidentally, we removed mysql-bin.index file. […]
MySQL Error wth Relay logs – Could not open relay logs file for logging
Question : We are receiving the following error. 2016-03-08 15:32:09 1184 [ERROR] MYSQL_BIN_LOG::move_crash_safe_index_file_to_index_file failed to move crash_safe_index_file to index file. […]
Can it be safe to disable binary logging in MySQL?
Question : Is the MySQL binlog similar to Oracle’s redo log or PostgreSQL’s Write-Ahead Log? If yes, how come it […]
Broken Slave MySQL : How To Fix MySQL Replication (BINLOG) error in the Slave?
Question : Before we start I can give some info about the versions, Ubuntu – 14.04, MySQL – 5.5 I […]
Why do the MySQL bin log files still exist after a purge or flush?
Question : I’ve used PURGE BINARY LOGS as well as FLUSH LOGS, but the mysql directory still contains these files: […]
what happens If I remove mysql-bin.index file?
Question : Because of the file storage full, we are removing mysql bin log files. Accidentally, we removed mysql-bin.index file. […]
How do I get the MySQL binary log coordinates from the binary files?
Question : I’m attempting to set up replication for a large (120 GB) MySQL database and I messed up. I […]
Show sql statements from mysql binlog (GTID)
Question : I have mysql binlogs for replication through GTID. I’m trying to show executed update/insert statements like this: mysqlbinlog […]