world_x database sample contains one JSON
collection and a set of three relational tables:
countryinfo: Information about countries in the world.
country: Minimal information about countries of the world.
city: Information about some of the cities in those countries.
countrylanguage: Languages spoken in each country.
You must install MySQL Shell with the X Protocol enabled. For instructions, see Section 19.3, “Setting Up MySQL as a Document Store”.
Start the server before you load the
database for this guide.
To prepare the
world_x database sample,
follow these steps:
Extract the installation archive to a temporary location such as
/tmp/. Unpacking the archive results in a single file named
Create the schema with the following command:
mysqlsh -u root --sql < /tmp/world_x-db/world_x.sqlEnter password:
****Records: 4079 Duplicates: 0 Warnings: 0 Records: 239 Duplicates: 0 Warnings: 0 Records: 239 Duplicates: 0 Warnings: 0 Records: 984 Duplicates: 0 Warnings: 0
Enter your password when prompted. A non-root account can be used as long as the account has privileges to create new databases.
/tmp/with the path to the
world_x.sqlfile on your system.