MySQL 生成百万测试数据

叁歲伎倆 2024-04-18 09:05 94阅读 0赞

**利用MySQL官方提供的测试库：[test\_db（链接）][test_db]来作为测试数据：**

**1、我这里是docker容器中安装的MySQL5.7，需要进入MySQL容器当中，并将容器外的/usr/local/employees\_db下的测试库文件夹中所有文件拷贝到MySQL容器的/opt目录下；**

[root@localhost usr]# docker ps -a
    CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS                     PORTS                               NAMES
    05236bb062ee        mysql:5.7           "docker-entrypoint.s…"   5 minutes ago       Exited (1) 5 minutes ago                                       great_gould
    aaebad189b9e        redis               "docker-entrypoint.s…"   4 months ago        Up 15 minutes                                                  redis-7005
    85c7ea6a780a        redis               "docker-entrypoint.s…"   4 months ago        Up 15 minutes                                                  redis-7004
    c3739b28b97f        redis               "docker-entrypoint.s…"   4 months ago        Up 15 minutes                                                  redis-7003
    c8175f6b9e53        redis               "docker-entrypoint.s…"   4 months ago        Up 15 minutes                                                  redis-7002
    d48017b48f0a        redis               "docker-entrypoint.s…"   4 months ago        Up 15 minutes                                                  redis-7001
    1de8d0866fff        redis               "docker-entrypoint.s…"   4 months ago        Up 15 minutes                                                  redis-7000
    0b9283e34495        mysql:5.7           "docker-entrypoint.s…"   5 months ago        Up 3 minutes               0.0.0.0:3306->3306/tcp, 33060/tcp   mysql5.7
    [root@localhost usr]# docker exec -it 0b9283e34495 /bin/bash
    root@0b9283e34495:/# ls
    bin  boot  dev  docker-entrypoint-initdb.d  entrypoint.sh  etc  home  lib  lib64  media  mnt  opt  proc  root  run  sbin  srv  sys  tmp  usr  var
    root@0b9283e34495:/# cd /opt
    root@0b9283e34495:/opt# ls
    root@0b9283e34495:/opt# exit;
    exit
    [root@localhost usr]# docker cp /usr/local/employees_db/ 0b9283e34495:/opt
    [root@localhost usr]# docker exec -it 0b9283e34495 /bin/bash
    root@0b9283e34495:/# cd /opt
    root@0b9283e34495:/opt# ls
    employees_db

**2、 利用mysql -uroot -p123456 < employees.sql 命令导入。**

**     账号密码自行根据自己需要更改。**

root@0b9283e34495:/opt# cd employees_db/
    root@0b9283e34495:/opt/employees_db# ls
    Changelog      employees_partitioned.sql   load_departments.dump   load_employees.dump  objects.sql
    README         employees_partitioned2.sql  load_dept_emp.dump      load_salaries.dump   test_employees_md5.sql
    employees.sql  employees_partitioned3.sql  load_dept_manager.dump  load_titles.dump     test_employees_sha.sql
    root@0b9283e34495:/opt/employees_db# mysql -uroot -p123456 < employees.sql
    --------
    --------
    --------（等待....）

**至此导入成功。 **

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3NDk1Nzg2_size_16_color_FFFFFF_t_70][]

[test_db]: https://github.com/datacharmer/test_db
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3NDk1Nzg2_size_16_color_FFFFFF_t_70]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/17/6553a4698c61431d99c60cf30bc06b39.png