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 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
