I accidentally dropped a schema without backing it up. And now I want to use mysqlbinlog utility to perform recovery. (It seems that 开发者_如何转开发mysqlbinlog is a good tool). And it needs those b
I have seven 1G MySQL binlog files that I have to use to retrieve some \"lost\" information.I only need to get certain INSERT statements from the log (ex. where the statement starts with \"INSERT INTO
When I \"playback\" the statments from binary, the Load data statment fails for obvious reason. LOAD DATA LOCAL INFILE \'/tmp/SQL_MB-80-2\' REPLACE INTO TABLE some_table