mysqlbinlog

warning: Creating default object from empty value in /var/www/galaober.org.ua/html/modules/taxonomy/taxonomy.pages.inc on line 34.

Восстановление данных с использованием mysqlbinlog

$ mysqlbinlog --base64-output=decode-rows -v mysql-bin.000262 > mysql-bin.000262.sql
$ mysqlbinlog --start-datetime="2012-07-27 21:00:00" --stop-datetime="2012-07-27 23:00:00" mysql-bin.000023 --base64-output=decode-rows --verbose > recover_decoded.txt

http://blog.secaserver.com/2012/07/mysql-recover-data-mysqlbinlog/

( categories: )
Syndicate content