Mysql Bin log usage
Posted: Wed Jun 16, 2004 1:56 pm
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:
So, uhhh..... yea I gues I have to do something else before using it. Or add another parameter when pulling it?
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 ®¦