Tagged Questions
0
votes
0answers
17 views
How to get details of changes in point in time recovery using mysqlbinlog
I have written a shell script for point in time recovery using binary logs( Point-in-Time Recovery Using Event Times). I'm using the start time as the previous full-backup start time and end time will ...
1
vote
1answer
178 views
MySQL Slave Relay Logging but not logging Binary Log
I have a master slave setup both mysql 5.5, the setup is fine except that the slave won't Binary log to the standard mysql-binlog only to the relay logs. I fear this may be due to my lack of ...
2
votes
2answers
428 views
Large files in wamp\bin\mysql\mysql5.5.24\data directory
I have discovered these files located in the wamp\bin\mysql\mysql5.5.24\data folder on my Windows 2008 server.
They are consuming about 22 GB on a 40 GB drive.
I am using a LMS called moodle, that ...
1
vote
2answers
349 views
Warnings: Why are statements with limit clause unsafe even if there isn't a limit?
I'm a bit irritated because of some warnings in mysql errorlog.
Example 1:
[Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT.
The statement ...
1
vote
1answer
354 views
mysql error log issue
I have mysql server running successfully.
The error log location is as..
mysql> show variables like '%log_erro%';
+---------------+------------------------+
| Variable_name | Value ...
2
votes
1answer
179 views
mysql emits BINLOG rows even though binlog_format=STATEMENT
We have MySQL 5.5 installed, we have the binlog_format=STATEMENT (the default)
According to the MySQL Documentation, the binary log should contain SQL statements only, but we still see BINLOG rows in ...
3
votes
1answer
679 views
What does the base64 BINLOG statements in mysqlbinlog output mean?
I have looked over the mysqlbinlog command as a candidate for rollback method from MySQL 5.5 to MySQL 5.0.
When I ran the command on one of the bin-log files in the MySQL 5.5 server, I've noticed ...
