I'd say that we need to know the content of the master's binary log
starting for the position listed above. Also don't forget to add options
to show row-based events to the mysqlbinlog command line.
]]
>>>> from the master db binlogs
[root@admin237 mysql]# mysqlbinlog -v --start-position=658931054 --stop-position=658931055 mysql-bin.001260
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4
#131120 15:00:20 server id 2373306 end_log_pos 106 Start: binlog v 4, server v 5.1.61-log created 131120 15:00:20
BINLOG '
BD+NUg+6NiQAZgAAAGoAAAAAAAQANS4xLjYxLWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAAUwAEGggAAAAICAgC
'/*!*/;
# at 658931054
#131120 18:08:01 server id 2373306 end_log_pos 658931432 Query thread_id=1010612 exec_time=8 error_code=0
use revolveclothing_com_-_db/*!*/;
SET TIMESTAMP=1384999681/*!*/;
SET @@session.pseudo_thread_id=1010612/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
SET @@session.sql_mode=0/*!*/;
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
/*!\C utf8 *//*!*/;
SET @@session.character_set_client=33,@@session.collation_connection=33,@@session.collation_server=8/*!*/;
SET @@session.time_zone='SYSTEM'/*!*/;
SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
replace into id_shipcost select mid(productcode, locate('-',productcode)+1,2) as GCat, round(sum(shippingcost)/count(*),2) as ShipCost from shipment where boxtime between date_sub(current_date, interval 180 day) and date_sub(current_date, interval 1 day) and shippingcost>0 group by GCat
/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
[[ Relay_Master_ Log_File: mysql-bin.001260
Exec_ Master_ Log_Pos: 658931054
I'd say that we need to know the content of the master's binary log
starting for the position listed above. Also don't forget to add options
to show row-based events to the mysqlbinlog command line.
]]
>>>> from the master db binlogs
[root@admin237 mysql]# mysqlbinlog -v --start- position= 658931054 --stop- position= 658931055 mysql-bin.001260 max_insert_ delayed_ threads= 0*/; _TYPE=@ @COMPLETION_ TYPE,COMPLETION _TYPE=0* /; 6NiQAZgAAAGoAAA AAAAQANS4xLjYxL WxvZwAAAAAAAAAA AAAAAAAAAAAAAAA AAAAAAAAA AAAAAAAAAEzgNAA gAEgAEBAQEEgAAU wAEGggAAAAICAgC _com_-_ db/*!*/ ; 1384999681/ *!*/; pseudo_ thread_ id=1010612/ *!*/; foreign_ key_checks= 1, @@session. sql_auto_ is_null= 1, @@session. unique_ checks= 1, @@session. autocommit= 1/*!*/; sql_mode= 0/*!*/; auto_increment_ increment= 1, @@session. auto_increment_ offset= 1/*!*/; character_ set_client= 33,@@session. collation_ connection= 33,@@session. collation_ server= 8/*!*/; time_zone= 'SYSTEM' /*!*/; lc_time_ names=0/ *!*/; collation_ database= DEFAULT/ *!*/; '-',productcode )+1,2) as GCat, round(sum( shippingcost) /count( *),2) as ShipCost from shipment where boxtime between date_sub( current_ date, interval 180 day) and date_sub( current_ date, interval 1 day) and shippingcost>0 group by GCat TYPE=@OLD_ COMPLETION_ TYPE*/;
/*!40019 SET @@session.
/*!50003 SET @OLD_COMPLETION
DELIMITER /*!*/;
# at 4
#131120 15:00:20 server id 2373306 end_log_pos 106 Start: binlog v 4, server v 5.1.61-log created 131120 15:00:20
BINLOG '
BD+NUg+
AAAAAAAAAAAAAAA
'/*!*/;
# at 658931054
#131120 18:08:01 server id 2373306 end_log_pos 658931432 Query thread_id=1010612 exec_time=8 error_code=0
use revolveclothing
SET TIMESTAMP=
SET @@session.
SET @@session.
SET @@session.
SET @@session.
/*!\C utf8 *//*!*/;
SET @@session.
SET @@session.
SET @@session.
SET @@session.
replace into id_shipcost select mid(productcode, locate(
/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_