Page 1 of 1

Mysql Bin log usage

Posted: Wed Jun 16, 2004 1:56 pm
by magicrobotmonkey
Ok, i used mysqlbinlog to grab the log for a table and dump it to a file. Cool. Now I'm not sure what to do with said table. It looks like this:

Code: Select all

CREATE TABLE `report` (
  `RID` int(5) NOT NULL auto_increment,
  `Act_Year` timestamp(14) NOT NULL,
  `Sel_Year` varchar(4) default NULL,
  `Sel_Quarter` char(2) default NULL,
  `A3` mediumint(10) default NULL,
  `A2` mediumint(10) default NULL,
  `B2` mediumint(10) default NULL,
  `B3` mediumint(10) default NULL,
  `C3` mediumint(10) default NULL,
  `C2` mediumint(10) default NULL,
  `C1` mediumint(10) default NULL,
  `B1` mediumint(10) default NULL,
  `A1` mediumint(10) default NULL,
  `NAIC` varchar(7) NOT NULL default '',
  `is_old` char(1) default '0',
  `methodology` varchar(255) default NULL,
  `Pay_Date` date default NULL,
  `suffix` char(3) NOT NULL default '',
  `why_not` varchar(255) default NULL,
  `no_questions` varchar(7) default NULL,
  `na_questions` varchar(7) default NULL,
  `changes` varchar(255) default NULL,
  PRIMARY KEY  (`RID`)
) TYPE=MyISAM 8  ß Ðÿ2   •hÈ@20032 8 D D * * D 906110 §        8  ß Àÿ1   lhÈ@20031 ? D D ? ? D 906110 ®¦        &üß Àÿ0   lhÈ@20031 193990 ®¦          &üß Àÿ/   lhÈ@20031 668420 ®¦          A Ø Ðÿ.   •hÈ@20032 Ð ¸ Æ ´ Õ “ ·  ¿  ½  600540 §        A Ø Àÿ-   lhÈ@20031  )    Õ Ä  Ç  Ç  600540 ®¦        8 dØ Ðÿ,   •hÈ@20032 " Ø d       952370 §        8 dØ Àÿ+   lhÈ@20031 ¡ 9 -       952370 ®¦        &üß Àÿ*   lhÈ@20031 229500 ®¦          &üß Àÿ)   lhÈ@20031 206990 ®¦
So, uhhh..... yea I gues I have to do something else before using it. Or add another parameter when pulling it?

Posted: Thu Jun 17, 2004 12:11 am
by Weirdan
what exact command you used? It seems you've posted your binlog contents, not the output of mysqlbinlog utility...

Posted: Thu Jun 17, 2004 6:18 am
by magicrobotmonkey
uhh it was" mysqlbinlog - h localhost -u xxx -p xxx -t nhhp.report -r test.sql"

Posted: Thu Jun 17, 2004 9:22 am
by Weirdan
for reading binlog from remote server you have to specify -R option. Unless you do so all relevant options are ignored.