The binlog tag has no wiki summary.
0
votes
1answer
51 views
Strange characters in mysqlbinlog output
Has anyone experienced this? Data replicates fine but when output in mysqlbinlog there are hidden characters that break the input?
mysqlbinlog Ver 3.3 for Linux at x86_64
mysql 5.5.28 server
...
0
votes
2answers
126 views
Replication master binlog rotation when network is unavailable
I recently experienced an issue where the binlog file in master rotated because network connectivity between the slave and master was unavailable.
After solving the network issue, the slave was not ...
1
vote
1answer
463 views
Binlog has bad magic number
I keep getting this error whenever I start MySQL.
121028 1:38:55 [Note] Plugin 'FEDERATED' is disabled.
121028 1:38:55 InnoDB: The InnoDB memory heap is disabled
121028 1:38:55 InnoDB: Mutexes and ...
1
vote
1answer
129 views
Master updates Slave but not Master itself
I have a setup master/slave in which applications are pointed only to master. Yesterday Master had got crashed due to "multi bit error on dimm detected" in Front indication panel in orange color.
...
3
votes
1answer
120 views
Switch MySQL lag slave to new master and keep lagging (5.1)
We have the following scenario:
Set of slaves replicate from the master, separate standby master (a.k.a slave with binlogs) replicates from the same master; lag slave, powered by pt-slave-delay, ...
1
vote
0answers
120 views
How to restore deleted rows from a binary log?
Background
I am trying to recover a few thousand rows that were accidentally deleted from a MySQL database. Luckily replication is enabled, so in the binary logs I have a record of each INSERT, ...
2
votes
2answers
89 views
How to see what was executed in the database via binlogs for specific date?
I am trying figure out how to "query" binlogs to see what was exectued in the database for a specific date. For example, if I execute mysqlbinlog binlog then the thing just runs forever and it is had ...
1
vote
2answers
1k views
Error reading MySQL 5.5 binary log using mysqlbinlog
I'm having some trouble with a replication setup I'm using. It has been working fine for months, and then over the weekend, the slave stopped reading updates from the masters binlog with an error Got ...
0
votes
2answers
311 views
How can you monitor if MySQL binlog files get corrupted?
I was wondering if there was any nice way to continuously monitor mysql master binlog files and detect if get corrupted.
1
vote
1answer
321 views
How soon after updating expire_logs_days param and restarting sql will old binlogs get deleted?
MySQL 5.1.x | InnoDB | Windows
My mysql data directory is starting to fill up with bin logs.
I currently have the following settings configured in my windows mysql server:
[mysqld]
log-bin
...
1
vote
1answer
144 views
MySQL binary logs - skip a table
Is there a way to skip a specific table in the binary logs?
I've got binary logs configured as my incremental backup strategy between nightly backups. But we have one huge reference table that we're ...
