Re: question about recovery with binlog

2006-01-27 Thread Gleb Paharenko
Hello. At least it replaces the contents of my test file. If you're able to provide the test case where replace utility doesn't work please provide it to the list with the contents of the file. wangxu wrote: > I execute follow statement. > - > shell>replac

Re: question about recovery with binlog

2006-01-25 Thread wangxu
I execute follow statement. - shell>replace @@session.sql_mode=0 @@session.sql_mode=1 -- 1.01 - But string "@@session.sql_mode=0" doesn't replace to "@@session.sql_mode=1". - Original Message - From: "Gl

Re: question about recovery with binlog

2006-01-23 Thread Gleb Paharenko
Hello. There a lot of different ways to perform this operation. See: http://dev.mysql.com/doc/refman/5.0/en/replace-utility.html man sed man awk wangxu wrote: > How to replace it? > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://l

Re: question about recovery with binlog

2006-01-22 Thread wangxu
How to replace it? The output is a binary file. - Original Message - From: "Gleb Paharenko" <[EMAIL PROTECTED]> To: Sent: Friday, January 20, 2006 10:11 PM Subject: Re: question about recovery with binlog > Hello. > > Just a possible workaround - yo

Re: question about recovery with binlog

2006-01-20 Thread Gleb Paharenko
c_time=0 error_code=0 > SET TIMESTAMP=1137661847; > INSERT INTO `ht_detail` VALUES > ('79NK0001/0003','79NK0001',1),('79NK0001/0003','79NK0002',1),('79NK0001/0003','79NK0003',1); > # at 2260 > #060119 17:10:47 server id 1

Re: question about recovery with binlog

2006-01-19 Thread wangxu
1137661847; /*!4 ALTER TABLE `ht_detail` ENABLE KEYS */; # End of log file ROLLBACK /* added by mysqlbinlog */; /*!50003 SET [EMAIL PROTECTED]/; ---------- ----- Original Message - From: "Gleb Paharenko" <[EMAIL PROTECTED]> To: Sent: Thursday, January 19, 2006 6:55 PM Re: question a

Re: question about recovery with binlog

2006-01-19 Thread Gleb Paharenko
Hello. Are you sure that the bug is thrown by mysqlbinlog? May be you're getting this while importing the output produced by mysqlbinlog? Have a look here: http://bugs.mysql.com/bug.php?id=13897 Check that you're using the same versions of mysql client and mysqlbinlog. wangxu wrote: > Mysql