Does anyone know if there is a tool or a good way to recover a single table from the binlogs ?
I tried for n in dev-bin.*; do mysqlbinlog $n |grep table_name >> /tmp/file.sql; done but it just gives me the first line of the insert/update statement. I guess you could dump all the bin files out to a text file and then use a perl script to look for "insert into table_name" or "update table_name" and keep reading lines until you hit a ";". walt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]