PhpMyAdmin Database

[newsiness]

I export the database from old server then import to new server. The sizes for 3 tables from new server are all different from the old server. Any idea? Really appreciate your help. Thanks.

 

[Eric]

'Overhead'

 

[newsiness]

'Overhead'

thanks for the quick reply...may i know what is overhead? Why can't i import this to my new server as well? Thanks again.

 

[Peter]

I am not 100% sure but is it possible that they are optimized when importing?

Another thing that may cause this is that you may have been on a 32 bit system but moved to a 64 bit system or even from a Linux server to a Microsoft server (or vice versa). Data types nay need x amount of bytes on 1 type of system but a different amount on another which could account for such a difference.

 

[Eric]

I am not 100% sure but is it possible that they are optimized when importing?

Another thing that may cause this is that you may have been on a 32 bit system but moved to a 64 bit system or even from a Linux server to a Microsoft server (or vice versa). Data types nay need x amount of bytes on 1 type of system but a different amount on another which could account for such a difference.

:bingo: