pt-table-sync does not sync table when schema and table name are the same

makaronomakarono EntrantActive Member Participant
pt-table-sync does not sync table when schema and table name are the same

this is my command:

PTDEBUG=1 pt-table-sync --execute --lock 0 --chunk-size 1000 --verbose --nocheck-triggers --no-foreign-key-checks --no-check-child-tables --databases tokens --tables tokens h=192.168.2.2,u=xxx,p=xxx h=192.168.2.3;

this is debug output:

# SchemaIterator:7853 20796 Found 1 databases
# SchemaIterator:7860 20796 Next database: tokens
# SchemaIterator:7866 20796 SHOW /*!50002 FULL*/ TABLES FROM `tokens`
# SchemaIterator:7997 20796 Table summary_status_report is not in --tables list, ignoring
# SchemaIterator:8012 20796 Table tokens is only allowed in database HASH(0x55e119d76e78)
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.