List:General Discussion« Previous MessageNext Message »
From:Eric Frazier Date:August 17 2002 1:33am
Subject:mysqlbinlog - doesn't work on some log files
View as plain text  
Hi,

I deleted a db I didn't mean to.  I am using mysql 4.0.1 Alpha and some 
innodb and some myisam tables.
I have the log files I need to restore my data since I have been running 
since the last backup with binlog enabled in my.cnf.

The problem is that mysqlbinlog shows some log files, but other log files 
choke.

In VI I can see this at the top of one of one log file:

  þbin¢>.=.....K..
00000010  00 01 00 00  00 00 00 02  00 34 2e 30  2e 31 2d 61  .........4.0.1-a
00000020  6c 70 68 61  2d 6c 6f 67  00 00 00 00  00 00 00 00  lpha-log........
00000030  00 00 00 00  00 00 00 00  00 00 00 00  00 00 00 00  ................
00000040  00 00 00 00  00 00 00 00  00 00 00 a2  3e 06 3d 77  ...........¢>.=w
00000050  40 06 3d 02  01 00 00 00  f2 00 00 00  02 00 00 00  @.=.....ò.......
00000060  00 00 c1 1b  00 00 00 00  00 00 0a 00  00 73 65 6e  ..Á..........sen
00000070  73 69 74 69  6c 6c 65 00  55 50 44 41  54 45 20 75  sitille.UPDATE u
00000080  61 5f 70 72  69 6d 61 72  79 5f 68 69  74 73 20 53  a_primary_hits S
00000090  45 54 20 31  31 64 61 79  20 3d 20 28  31 31 64 61  ET 11day = (11da
000000a0  79 20 2b 20  31 29 2c 20  31 31 75 5f  64 61 79 20  y + 1), 11u_day
000000b0  3d 20 28 31  31 75 5f 64  61 79 20 2b  20 31 29 2c  = (11u_day + 1),
000000c0  20 4d 6f 6e  74 68 5f 54  6f 74 61 6c  20 3d 20 28   Month_Total = (
000000d0  4d 6f 6e 74  68 5f 54 6f  74 61 6c 20  2b 20 31 29  Month_Total + 1)
000000e0  2c 20 4d 6f  6e 74 68 5f  55 6e 69 71  75 65 20 3d  , Month_Unique =
000000f0  20 28 4d 6f  6e 74 68 5f  55 6e 69 71  75 65 20 2b   (Month_Unique +

but mysqlbinlog only shows this for this 4.8M file:

root@www194:/home/back# mysqlbinlog www194-bin.001
# at 4
#020611 11:17:06 server id  1   Start: binlog v 1, server v  created 691231 
16:00:00
# at 73
#030419 19:03:44 server 
id  104888125   Query   thread_id=15859712      exec_time=131072
use ;
LOAD DATA INFILE ''  REPLACE INTO TABLE nsitille  OPTIONALLY  ENCLOSED BY 
'\0' ESCAPED BY '\0' LINES STARTING BY '\0';



I had been running this machine as a Master to a remote slave. And some of 
the logs are large because I ran LOAD DATA FROM MASTER a few times from the 
slave machine.  So I have the data I need but I can't access it. I have a 
total of 8 log files, only two work with mysqlbinlog. The rest return very 
shortly like above.

This is really freaking me out, if this doesn't work, then I will have to 
start not trusting the log at all, which would suck. I have been able to 
restore data before, in the same way, from this same database and config.


Thanks,


Eric






Thread
mysqlbinlog - doesn't work on some log filesEric Frazier17 Aug
Re: mysqlbinlog - doesn't work on some log filesHeikki Tuuri17 Aug
Re: mysqlbinlog - doesn't work on some log filesEric Frazier19 Aug
  • JOIN in an update query?Chris Boget19 Aug
    • Re: JOIN in an update query?Victoria Reznichenko19 Aug