MySQL :: MySQL 8.0 Reference Manual :: 20.3.1 Import Database Sample

5.7

MySQL 8.0 Reference Manual / ... / Import Database Sample

20.3.1 Import Database Sample

The world_x database sample contains one JSON collection and a set of three 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.

Requirements

To follow this quick-start guide you need a MySQL server with X Plugin installed, the default in 8.0, and MySQL Shell to use as the client. See Installing MySQL Shell. Start MySQL before you load the example world_x database for this guide.

Download and Import world_x Database

To prepare the world_x database sample, follow these steps:

Download world_x-db.zip.
Extract the installation archive to a temporary location such as /tmp/. Unpacking the archive results in a single file named world_x.sql.
Import the world_x.sql file to your database. 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.sql
Enter password: ****
```
- Set MySQL Shell to SQL mode while it is running and source the schema file while MySQL Shell is running by issuing:
```
\source /tmp/world_x-db/world_x.sql
Switching to SQL mode... Commands end with ;
\source /tmp/world_x-db/world_x.sql
```
Replace /tmp/ with the path to the world_x.sql file on your system. Enter your password when prompted. A non-root account can be used as long as the account has privileges to create new databases.

Related Information

MySQL Shell Sessions explains session types.
See Chapter 2, Installing and Upgrading MySQL for general installation assistance.

PREV HOME UP NEXT