MySQL Forums
Forum List  »  Backup

Database's table_rows count increased after import
Posted by: Jason Oon
Date: July 18, 2019 08:38PM

I'm using mySQL 5.6.23 community server, I just notice some weird behavior what happen everytime I did export & import dump.

I notice, after I import the sql dump to a new DB, the table_rows count shows different count compare with the source DB. The value for each rows of the tables almost doubles it's source DB.

Is there a bug with information_schema table? I manually count a few tables by using select count(*) from table_name, it actually return the identical value for target & source DB.

Options: ReplyQuote

Written By
Database's table_rows count increased after import
July 18, 2019 08:38PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.