mysqlbinlog
Mysql data recovery using mysqlbinlog
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[详细]
2023-03-16 09:47 分类:问答MySQL BinLog Statement Retrieval
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[详细]
2023-01-03 02:48 分类:问答running mysqlbinlog on other server
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[详细]
2022-12-18 19:11 分类:问答