go-mydumper icon indicating copy to clipboard operation
go-mydumper copied to clipboard

mysql lower_case_table_names = 0,where module is fail

Open hlh5 opened this issue 3 years ago • 2 comments

when mysql lower_case_table_names = 0,Uppercase table dump all,even if where module Configuration effectiveness

eg:

Use this to restrict exported data. These are optional

[where] MY_BASE = id >= 3

result will dump all data

hlh5 avatar Jan 21 '21 03:01 hlh5

First, Please give the full sql which go-dumper send to the MySQL, give a hint: enable the gerneal log and check the query executed

Second, run the sql in the MySQL and check the datas is filter or not

BohuTANG avatar Jan 21 '21 08:01 BohuTANG

@BohuTANG this issue should have been resolved via https://github.com/xelabs/go-mydumper/pull/34

parse ini file avoid table name case sensitive problem under Linux

ttys3 avatar Jan 22 '21 12:01 ttys3