Re: question about recovery with binlog

2006-01-27 Thread Gleb Paharenko
uot;Gleb Paharenko" <[EMAIL PROTECTED]> > To: > Sent: Monday, January 23, 2006 7:56 PM > Subject:Re: question about recovery with binlog > > > >>Hello. >> >>There a lot of different ways to perform this operation. See: >> htt

Re: question about recovery with binlog

2006-01-25 Thread wangxu
Original Message - From: "Gleb Paharenko" <[EMAIL PROTECTED]> To: Sent: Monday, January 23, 2006 7:56 PM Subject:Re: question about recovery with binlog > Hello. > > There a lot of different ways to perform this operation. See: > http://dev.mysql.com/doc/re

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
end_log_pos 2287 Xid = 432 > COMMIT; > # at 2287 > #060119 17:10:47 server id 1 end_log_pos 2399 Query thread_id=25 > exec_time=0 error_code=0 > SET TIMESTAMP=1137661847; > /*!4 ALTER TABLE `ht_detail` ENABLE KEYS */; > # End of log file > ROLLBACK /* ad

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

question about recovery with binlog

2006-01-19 Thread wangxu
Mysqlbinlog throw out a error "ERROR 1231 (42000) at line 10: Variable 'sql_mode' can't be set to the value of '501481487'" when i recovery a binlog. What can i do?