Validating the no of total number of rows in tables in Database XYZ Error:Migration Issue detected on Table in XYZ please verify the rows running command : SELECT table_name, table_rows FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA ='XYZ';

[basavarajaC]

after running the script, we get this issue but data is migrated, We found some number of rows data mismatch on migrated DB.

[mattiasclaesson]

The number of rows as displayed by information_schema.tabels used for validation is only a estimation.
It cannot be trusted.
https://stackoverflow.com/questions/61662317/why-does-my-mysql-databases-information-schema-not-accurately-represent-the-tab
Use the ordinary count method instead.