Okay, I am moving a lot of tables from one host to another. (Using phpMyAdmin and the export feature... export to .gz, then import new server... standard settings.)
I noticed an odd issue that is confusing me. The data all looks fine, but this makes me wonder...
Some tables have come through fine with matching size (data, index, row). But some differ in size... as far as I call tell row size and index are where the mismatch is occurring.
The weird thing is... sometimes the table is bigger on the new server and sometimes bigger on the old one. O_o
I realize that small differences like these are a poor way to judge if the data came through correctly, but it does have me wondering what is causing the issue. I have verified and everything else looks the same... number of rows, column types/settings, collation, index types.
Could this simply be a mis-match in MySQL versions or something else. The kicker is... some tables match exactly.