对比两个数据库的记录数

   A机器和B机器上都跑有数据库服务，B机器上的数据库是从A机器上导过来的，现在线上程序连接A机器数据库时正常，连接B机器异常，初步怀疑是数据库导入时记录不完整造成的。数据库中一共有100个多表，不可能一一肉眼比对其值.于是想出了一个办法，通过脚本来比对其值

1)初步的整理

A机器：

1. mysqlshow -uroot -p db_name --count >> a.txt 

B机器：

1. mysqlshow -uroot -p db_name --count >>b.txt 

整理a.txt中内容部分如下：

1. aaa                                  31          16 
2. gift_card_base_info                  10         851 
3. gift_card_use_info                    6         252 
4. ms_log                                6        5827 
5. ms_users                              7         548 
6. ms_users_friends                      8         918 
7. sph_counter                           2           1 
8. who_account_log                      10      692650 
9. who_active                            7          94 
10. who_active_vote                      11          40 
11. who_ad                               13           1 
12. who_ad_custom                         7           0 
13. who_ad_position                       6           0 
14. who_admin_action                      3         113 
15. who_admin_log                         5      423922 
16. who_admin_message                     9           0 
17. who_admin_user                       13         176 
18. who_adsense                           3           0 
19. who_affiliate_log                     8        6154 
20. who_agency                            3           0 
21. who_area_region                       3        1780 
22. who_article                          13        1839 
23. who_article_cat                       8          33 
24. who_attr_composit                     3         450 
25. who_attribute                        10          12 
26. who_auction_log                       5           0 
27. who_auto_manage                       4           0 
28. who_back_goods                        8           0 
29. who_back_order                       31           4 
30. who_bak                              31          52 
31. who_bak1                             31          21 
32. who_bak2                             31          38 
33. who_bak3                             31          51 
34. who_bak4                             31          82 
35. who_bak5                             31          39 
36. who_bonus_type                       11           0 
37. who_booking_goods                    15      292713 
38. …………………………………………………………………………………………………………………………………………………………………………………………………………

b.txt

1. aaa                                  31          16 
2. gift_card_base_info                  10         851 
3. gift_card_use_info                    6         265 
4. ms_log                                6        5827 
5. ms_users                              7         548 
6. ms_users_friends                      8         918 
7. sph_counter                           2           1 
8. who_account_log                      10      698600 
9. who_active                            7          94 
10. who_active_vote                      11          40 
11. who_ad                               13           1 
12. who_ad_custom                         7           0 
13. who_ad_position                       6           0 
14. who_admin_action                      3         113 
15. who_admin_log                         5      430266 
16. who_admin_message                     9           0 
17. who_admin_user                       13         177 
18. who_adsense                           3           0 
19. who_affiliate_log                     8        6154 
20. who_agency                            3           0 
21. who_area_region                       3        1780 
22. who_article                          13        1845 
23. who_article_cat                       8          33 
24. who_attr_composit                     3         450 
25. who_attribute                        10          12 
26. who_auction_log                       5           0 
27. who_auto_manage                       4           0 
28. who_back_goods                        8           0 
29. who_back_order                       31           4 
30. who_bak                              31          52 
31. who_bak1                             31          21 
32. who_bak2                             31          38 
33. who_bak3                             31          51 
34. who_bak4                             31          82 
35. who_bak5                             31          39 
36. who_bonus_type                       11           0 
37. who_booking_goods                    15      292674 
38. …………………………………………………………………………………………………………………………………………………………………………………………………………

2)还是利用perl脚本来对比两个文件的值吧，方便

code:

1. #!/usr/bin/perl -w 
2.  
3. use strict; 
4.  
5. my (%hashA,%hashB) = (); 
6.  
7. open my $file,'<','record_194.txt' or die "$!\n"; 
8.  
9. while (<$file>) { 
10.        chomp; 
11.        my @arrayA = split /\s+/; 
12.        $hashA{$arrayA[0]} = $arrayA[2]; 
13. } 
14.  
15. close $file; 
16.  
17. open $file,'<','record_2.txt' or die "$!\n"; 
18.  
19. while (<$file>) { 
20.        chomp; 
21.        my @arrayB = split /\s+/; 
22.        $hashB{$arrayB[0]} = $arrayB[2]; 
23. } 
24.  
25. close $file; 
26.  
27. foreach my $table (sort keys %hashA) { 
28.  
29.         if (exists $hashB{$table}) { 
30.  
31.            if ($hashA{$table} != $hashB{$table}) { 
32.                 print $table,"\n"; 
33.            } 
34.  
35.         } 
36.  
37. } 

运行即可

本文转自dongfang_09859 51CTO博客，原文链接：http://blog.51cto.com/hellosa/504677，如需转载请自行联系原作者