Stack Overflow
Stack Overflow

Questions tagged [mysqlbinlog]

mysqlbinlog is a MySQL Utility for Processing Binary Log Files

mysqlbinlog is a MySQL Utility for Processing Binary Log Files

The server's binary log consists of files containing “events” that describe modifications to database contents. The server writes these files in binary format. To display their contents in text format, use the mysqlbinlog utility

Docs: https://dev.mysql.com/doc/refman/5.7/en/mysqlbinlog.html

MariaDB Docs: https://mariadb.com/kb/en/library/using-mysqlbinlog/

134 questions
0
votes
1 answer

Restore mysql database using binary log file (log-bin) on Windows

Using binary log file to restore mysql database is very useful, especially in misoperation. Below is my method to do this on Windows. If this question helps you, please mark it as "Useful", thanks.
danny
  • 427
  • 1
  • 15
  • 25
0
votes
0 answers

MariaDB 10.2.10 writing double binlog entries in mixed format

I am using MariaDB 10.2.10 under Debian 9 in Master/Slave replication. I am experiencing problems with replication since the slave is refusing replication due to 1062 duplicate key errors. After a long time of investigation I found, that the binlog…
Pumuckl77
  • 1
  • 1
0
votes
1 answer

(MySQL) Does replication have a bin-log?

I make replication using aws-rds, and set bin-log and server-id property in parameter group(like my.cnf). and type below query SHOW VARIABLES LIKE 'log_bin'; but result is log_bin OFF Does replication have a bin-log?? How can I set bin-log to…
perfectacle
  • 59
  • 2
  • 9
0
votes
0 answers

What happens when mysql binlog reaches mysql-bin.999999

Lets say my mysql replication is enabled for long time, and the server has been quite busy, so new bin log files get created every few seconds. So in a few months, it is possible for latest bin log file to have name "mysql-bin.999999". Does the next…
Ouroboros
  • 1,432
  • 1
  • 19
  • 41
0
votes
0 answers

mysql replication breaks - binlog show event_type 68

I have a master/slave MySQL replication working for day on production level, but every day, the replication stops working. But every thing says it is ok: show slave status; show Slave_IO_Running and Slave_SQL_Running is yes. If I execute: stop…
costamatrix
  • 670
  • 8
  • 17
0
votes
1 answer

sync_binlog is different for master and slave

Is it fine if sync_binlog is different for master and slave. For my system I can see master has sync_binlog=1 and slave has sync_binlog=0
MrTambourineMan
  • 1,025
  • 1
  • 11
  • 19
0
votes
1 answer

MySQL - Binary Log File size growing more than the maximum limit

I have a MySQL 5.7 running on a Centos 6. I enabled Binary Logging and didn't provide any custom value for the maximum size of Binary Log in my configuration file. By default, the parameter max_binlog_size = 1073741824 which is equivalent to 1GB.…
Yashwanth Aluru
  • 1,125
  • 6
  • 21
  • 28
0
votes
1 answer

Recover database from many mysql bin log files

I have some MYSQL binary log files as well as the as the binary index file (https://dev.mysql.com/doc/refman/5.6/en/point-in-time-recovery.html). The files look like so: log-bin.000001, log-bin.000002, log-bin.000003. I also have a log-bin.index…
Yahya Uddin
  • 26,997
  • 35
  • 140
  • 231
0
votes
1 answer

MySQL Slave replication failure: How to identify SQL which is causing it to fail

I am running MySQL on AWS RDS.. Slave replication is getting stuck because of following error. It says that it is not able to find a record in table of slave server... Is there a way to know which record ? Or the SQL which is failing ! Read Replica…
Deepak Singhal
  • 10,568
  • 11
  • 59
  • 98
0
votes
1 answer

Can MariaDB's Maxscale(BinLog Server) be used as a collector of binlogs from different mysql clusters?

I have read that Maxscale(BinLog Server) of MariaDB can be used for relaying the bin logs from a MySQL Cluster to a single BinLog Server, however i wanted to know if its possible to collect all the bin logs from different MySQL Cluster and persist…
Sushil Ks
  • 403
  • 2
  • 10
  • 18
0
votes
1 answer

Coldfusion problem with mySQL binary logging?

I just tried adding binary logging to my mySQL "my.ini" file with the intention of being able to do incremental backups. However, I immediately provoked an error Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in …
Saul
  • 1,387
  • 5
  • 23
  • 45
0
votes
1 answer

How to make data Sync from AWS RDS to another AWS RDS with different schema

I have Mysql RDS1 and another Mysql RDS2 where the schema is different. I need the any changes on RDS1 to be synced immediately to Mysql RDS2. where the data changes due to create, insert, update and delete Both RDS1 and RDS2 is alive and integrated…
Max
  • 71
  • 9
0
votes
0 answers

How to make mysql semi-repl not timeout?

Since MySQL 5.5, we have semisync, but semisync will switch off when receive semi sync ACK timeout.So, is there any way to not timeout ? I find a variable for mariadb rpl_semi_sync_master_timeout.Also in mysql Range: 0 to 1844674407370955161 So, I…
wener
  • 7,191
  • 6
  • 54
  • 78
0
votes
2 answers

Get user info with trigger in MySQL

As the title said, I'd like to get some information of the user who is executing the SQL statement in MySQL. For example, if some SQL statement is executed by a user called 'work', how could I got the user name and host with trigger before it is…
Hualiang Li
  • 65
  • 2
  • 7
0
votes
1 answer

MySQL BinLog Statement Retrieval

I have seven 1G MySQL binlog files that I have to use to retrieve some "lost" information. I only need to get certain INSERT statements from the log (ex. where the statement starts with "INSERT INTO table SET field1="). If I just run a mysqlbinlog…
Jonathon
  • 262
  • 4
  • 15
1 2 3
…
8
9