开发者

mysql---database size

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:

  1. Collect all table names in the database before the export.
  2. Generate a checksum for all the tables and put the tablename and checksum value in DBCheckSum1.txt
  3. Load the exported data into another instance of mysql
  4. Collect all table names in the second database
  5. Generate a checksum for all the tables and put the tablename and checksum value in DBCheckSum2.txt
  6. Compare the Checksum Files
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜