开发者

mysql---database size

开发者 https://www.devze.com 2023-02-04 20:04 出处:网络
why the number of the database size bigger than thenumber of the database size which i download to the local environment.(i export the dabase by the p开发者_C百科hpmyadmin\'s export button)Interesting

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

精彩评论

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

关注公众号