mysqlbinlog : Utility for Processing Binary Log and Relay Logs
0
votes
0answers
35 views
restore using mysqlbinlog failing
While doing restore from a MySQL binary log file, it is failing with the following error .
mysqlbinlog mysql-bin.000036 | mysql -u root -p asdb
ERROR 1032 (HY000) at line 48: Can't find record in ...
0
votes
2answers
74 views
Abnormally high MySQL writes and larger than normal Binary Log files. How can I determine what caused this?
We have a MySQL master database which replicates to a MySQL slave. We were experiencing issues where MySQL was showing a high number of writes (but not an increased number of queries being ran) for a ...
0
votes
1answer
108 views
Replication - Binary log parsing(Tableid generation, ON DELETE CASCADE handling, Changed columns for update event)
I am using MySQL 5.5 with InnoDB engine. I have set binlog format as row-based replication.
I have some doubts regarding replication:
1) How is the tableID generated? Is it stored somewhere?
2) ...
0
votes
1answer
108 views
Incremental MySQL restore using binlogs
I've tried to restore a MySQL database using incremental binlogs and mysqlbinlog tool but I received the following message:
ERROR 1666 (HY000) at line 30: Cannot execute statement: impossible to ...
0
votes
2answers
771 views
MySQL : Extract SQL statements from binlog
I am trying the following command to extract SQL statements from binlog for using it in another database (Amazon RDS)
mysqlbinlog /var/lib/mysql/binlog.000027 --start-position=54375264 ...
1
vote
2answers
143 views
Get missed transactions from slave
I'm trying to write a disaster recovery plan, I have one way replication with 1 master(A) and 3 slaves(B,C,D)
A
/|\
/ | \
B C D
Let's say my master crash, and I loose all data on ...
2
votes
1answer
1k views
Why do the MySQL bin log files still exist after a purge or flush?
I've used PURGE BINARY LOGS as well as FLUSH LOGS, but the mysql directory still contains these files:
mysql-bin.000025
mysql-bin.000024
mysql-bin.000023
mysql-bin.000022
mysql-bin.000021
...
1
vote
1answer
155 views
Mysqlbinlog statement reading
I am trying to perform a point in time on a specific database using a snapshot and mysql's transaction logs. I am using the following to pull statements from the time of the snapshot to the time of ...
2
votes
1answer
240 views
Is it possible to convert mysql binlog from statement format to row format?
The mysql server online is of version 4.1, which doesn't support row-based binary log. Nevertheless, I need the row-based binlog. Can I use the binlog generated by old mysql and import it into another ...
1
vote
2answers
284 views
MySQL bin log missing data?
I'm trying to make heads and tails of my binary logs and am coming up short. I have many entries similar to the following from mysqlbinlog but I'm missing log data that I know should be there.
# at ...
0
votes
0answers
104 views
MySQL binary log failed to generate a new one
In my Linux standalone machine, I have set up MySQL on it.
In my.cnf, I have the following cofiguration:
[mysqld]
log-bin=mysql-bin
binlog_format=mixed
expire_logs_days = 10
max_binlog_size = 100M
...
