开发者

running mysqlbinlog on other server

开发者 https://www.devze.com 2022-12-18 19:11 出处:网络
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

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
开发者_StackOverflow

How do I make sure that the data is consistent even if I run the extract of the binary files onto a different server?


While extracting the binary statements, I need local-load parameter

mysqlbinlog /var/log/mysql/mysql-bin.* --start-datetime="2010-02-03 15:55:38" --local-load='tmp/' > tocentral.txt
0

精彩评论

暂无评论...
验证码 换一张
取 消