Stack Overflow
Stack Overflow

Questions tagged [binary-log]

40 questions
0
votes
0 answers

Recover database using only part of binary log MySql

I have made a backup, then I have executed several statements, including a delete. So I have recovered the backup but I only want to recover the binary log until before the delete operation, what command can I use for this?
Anita JP
  • 23
  • 4
0
votes
1 answer

how to recover the Database Data using binary logs?

One of our associate has deleted the database as well as the replica is there is a way to recover the database.
sandeepnegi1996
  • 29
  • 7
0
votes
2 answers

View Binary Logs of GCP Postgres SQL instance

How to view Binary Logs(Transaction Logs) of a GCP Postgres SQL Instance? Can it be viewed in GCP Console? I tried to use Stackdriver. But it only shows instance usage data. Thanks
Nipu
  • 653
  • 1
  • 8
  • 15
0
votes
1 answer

Logging of MySQL Queries and Forwarding to Syslog/Event log

I was to able to enable Error log, General Query log, Slow Query Log and Binary Log and was able to forward the logs to Syslog. I have few questions about logging. 1) The error log is automatically forwarded to Event log in Windows. How do I forward…
Thunder Kay
  • 143
  • 13
0
votes
1 answer

MySQL Binary Logging Preventing Write Transactions - Bitnami

I'm trying to configure MySQL on a Bitnami-prepared VM for replication (Not to be confused with MySQL With Replication from Bitnami), and I am having issues with its binary logging. When I add the line log-bin = mysql-bin or log_bin = mysql-bin in…
Anthony Casson
  • 43
  • 6
0
votes
1 answer

How To Remove Specific Query From MySQL Binary Log

So I have a binary log that's taking forever to restore to because of some poorly written code that updates a table every second or so for every user that's currently logged in. Of course the restore process is restoring every one of these lines and…
Brian Leishman
  • 8,155
  • 11
  • 57
  • 93
0
votes
0 answers

Unable to apply binarylogs to amazon RDS

I'm trying to migrate from an EC2 mysql(percona galera) to rds mysql but I'm running into some issues. The initial import works great but after that I'm hitting an issue when trying to apply the remaining binarylogs. Command to create binlog…
JakeJ
  • 13
  • 1
  • 8
0
votes
1 answer

Can not activate the log-bin

I have a database that uses the InnoDB engine on all his tables, running on a Windows Server 2008 r2 64bit in a VM farm. The policies of my organization promotes that every server has to have a replication that can run in the case of disaster in the…
juan_liga
  • 329
  • 2
  • 3
0
votes
2 answers

Binary Log MySQL

I have some binary log files from localhost but when i write mysqlbinlog mysql-bin.000001 > statament.sql or a text file it just returns gibberish i.e. /*!40019 SET @@session.max_insert_delayed_threads=0*/; /*!50003 SET…
pengwin
  • 85
  • 9
-1
votes
1 answer

Which tool for database vesioning to use? liquibase vs mysql binary logs

I'm trying to build a process of refactoring, testing and deployment of my databases. After some kind of research I found liquibase as a nice tool for managing my database versions. As well similar kind of jobs could be done with just mysql binary…
Nikage
  • 578
  • 2
  • 7
  • 18
1 2
3