why the number of the database size bigger than the number of the database size which i download to the local environment.(i export the dabase by the p开发者_C百科hpmyadmin's export button)
Interesting, phpmyadmin shrinks the database by 1/3 some said in a post dated back February 25, 2010 at 6:12am.
If you want to be sure the data is the same, do the following the next time you export:
- Collect all table names in the database before the export.
- Generate a checksum for all the tables and put the tablename and checksum value in DBCheckSum1.txt
- Load the exported data into another instance of mysql
- Collect all table names in the second database
- Generate a checksum for all the tables and put the tablename and checksum value in DBCheckSum2.txt
- Compare the Checksum Files
精彩评论