mysql测试库

最新推荐文章于 2025-03-31 11:42:00 发布

songbintao

最新推荐文章于 2025-03-31 11:42:00 发布

阅读量562

点赞数

分类专栏： MySQL

本文链接：https://blog.youkuaiyun.com/songbintao/article/details/82627753

版权

MySQL 专栏收录该内容

8 篇文章

订阅专栏

本文介绍了一个测试数据库的导入过程及验证方法。通过指定的命令行操作，可以将包含多个表的测试数据库成功导入，并通过执行测试脚本来确保数据的完整性和正确性。整个过程涵盖了从下载测试文件到最终验证数据的一系列步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

测试文件下载地址：

https://github.com/datacharmer/test_db

安装：

unzip test_db-master.zip

cd test_db-master/

mysql -u root -p123456 <employees.sql

可以导入两个分区表：

mysql -u root -p123456 <employees_partitioned.sql

mysql < employees_partitioned.sql

检测导入的数据：

[root@node2 test_db-master]# mysql -u root -p123456 -t < test_employees_md5.sql
mysql: [Warning] Using a password on the command line interface can be insecure.
+----------------------+
| INFO                 |
+----------------------+
| TESTING INSTALLATION |
+----------------------+
+--------------+------------------+----------------------------------+
| table_name   | expected_records | expected_crc                     |
+--------------+------------------+----------------------------------+
| employees    |           300024 | 4ec56ab5ba37218d187cf6ab09ce1aa1 |
| departments  |                9 | d1af5e170d2d1591d776d5638d71fc5f |
| dept_manager |               24 | 8720e2f0853ac9096b689c14664f847e |
| dept_emp     |           331603 | ccf6fe516f990bdaa49713fc478701b7 |
| titles       |           443308 | bfa016c472df68e70a03facafa1bc0a8 |
| salaries     |          2844047 | fd220654e95aea1b169624ffe3fca934 |
+--------------+------------------+----------------------------------+
+--------------+------------------+----------------------------------+
| table_name   | found_records    | found_crc                        |
+--------------+------------------+----------------------------------+
| employees    |           300024 | 4ec56ab5ba37218d187cf6ab09ce1aa1 |
| departments  |                9 | d1af5e170d2d1591d776d5638d71fc5f |
| dept_manager |               24 | 8720e2f0853ac9096b689c14664f847e |
| dept_emp     |           331603 | ccf6fe516f990bdaa49713fc478701b7 |
| titles       |           443308 | bfa016c472df68e70a03facafa1bc0a8 |
| salaries     |          2844047 | fd220654e95aea1b169624ffe3fca934 |
+--------------+------------------+----------------------------------+
+--------------+---------------+-----------+
| table_name   | records_match | crc_match |
+--------------+---------------+-----------+
| employees    | OK            | ok        |
| departments  | OK            | ok        |
| dept_manager | OK            | ok        |
| dept_emp     | OK            | ok        |
| titles       | OK            | ok        |
| salaries     | OK            | ok        |
+--------------+---------------+-----------+
+------------------+
| computation_time |
+------------------+
| 00:00:17         |
+------------------+
+---------+--------+
| summary | result |
+---------+--------+
| CRC     | OK     |
| count   | OK     |
+---------+--------+