Import database number of rows reduced

Import database number of rows reduced

by Alan Cherwinski -
Number of replies: 0

Moodle 2.83 LAMP.

I am changing from MyISAM to InnoDB by exporting the database and running a find and replace. 

When the database is imported back into an empty MYSQL DB the number of tables remains correct (250), but the number of Rows is less (126,159 vrs 131,482) and the over Size listed in MYPHP Admin is considerably larger ( 86.4 MiB vrs 48.7 MiB). I have done it twice with exactly the same results

Ran optimize on the original (not before exporting).   I suspect something in the import is not working correctly and the database is in complete based on the number of Rows. Is there a legitimate reason for the number of Rows to change?


Thanks for any advise or insight.



Average of ratings: -