Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 43.3Mb
PDF (A4) - 43.4Mb
Man Pages (TGZ) - 297.1Kb
Man Pages (Zip) - 402.3Kb
Info (Gzip) - 4.3Mb
Info (Zip) - 4.3Mb
Excerpts from this Manual

22.3.2 Download and Import world_x Database

As part of this quick-start guide, an example schema is provided which is referred to as theworld_x schema. Many of the examples demonstrate Document Store functionality using this schema. Start your MySQL server so that you can load theworld_x schema, then follow these steps:

  1. Downloadworld_x-db.zip.

  2. Extract the installation archive to a temporary location such as/tmp/. Unpacking the archive results in a single file namedworld_x.sql.

  3. Import theworld_x.sql file to your server. You can either:

    • Start MySQL Shell in SQL mode and import the file by issuing:

      mysqlsh -u root --sql --file /tmp/world_x-db/world_x.sqlEnter password: ****

    • Set MySQL Shell to SQL mode while it is running and source the schema file by issuing:

      \sqlSwitching to SQL mode... Commands end with ;\source /tmp/world_x-db/world_x.sql

    Replace/tmp/ with the path to theworld_x.sql file on your system. Enter your password if prompted. A non-root account can be used as long as the account has privileges to create new schemas.

The world_x Schema

Theworld_x example schema contains the following JSON collection and relational tables:

  • Collection

    • countryinfo: Information about countries in the world.

  • Tables

    • country: Minimal information about countries of the world.

    • city: Information about some of the cities in those countries.

    • countrylanguage: Languages spoken in each country.

Related Information