Is it possible to find a dump of a large database somewhere?

Question

Database

Actually, I want to visually see the benefits of indexes on large databases, and practice with a large amount of data. When you create a couple of tables in which a couple of records, this is certainly good, but it makes little sense.
Is there somewhere some kind of database dumps IN WHICH MANY RECORDS that you can download yourself and practice?

Answer 1

Faker

Answer 2

Why dump? Take and write a mini script to generate fake data.

Answer 3

There is a Wikipedia dump, it is quite weighty (for PC scale) https://dumps.wikimedia.org/ - here you can search somewhere

Answer 4

<?php
    $host = '127.0.0.1';
    $db   = 'test';
    $user = 'root';
    $pass = '';
    $charset = 'utf8';
    $dsn = "mysql:host=$host;dbname=$db;charset=$charset";
    $opt = [
        PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
        PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
        PDO::ATTR_EMULATE_PREPARES   => false,
    ];
    $pdo = new PDO($dsn, $user, $pass, $opt);
    for ($i = 0; $i < 1000000; $i++) {
      $pdo->query(sprintf('INSERT INTO table (id, value) VALUES (%d, "%s")', $i+1, uniqid());
    }

Answer 5

https://www.howtoforge.com/how-to-benchmark-your-s...
There are keys for preparing the database that allow you to fill the database with the required amount of data with one command