To enable MySQL users to perform manipulation of the
world_x sample database using MySQL, the data
set is available as a set of four tables:
country: Information about countries of the world.
city: Information about some of the cities in those countries.
countrylanguage: Languages spoken in each country.
countryinfo: Information about each country represented as a JSON document.
world_x.sql file containing the
world_x database is available for download at
https://dev.mysql.com/doc/index-other.html. The file is
provided as a compressed tar file or Zip
world_x database uses features specific
to X DevAPI, and thus requires MySQL 5.7 or higher. A
world database variant also exists that does
not use X DevAPI features and may be used with MySQL 5.5 and
higher. See Setting Up the world Database.
To install the
world_x sample database, follow
Download the installation archive to a temporary location such as
/tmp/and unpack it. Unpacking the archive results in a directory named
world_x-dbcontaining files named
world_x.sqlscript to create the database structure and insert the data using one of the following methods:
Use MySQL Shell:
shell> mysqlsh -u root --sql --recreate-schema world_x < C:\temp\world_x-db\world_x.sql
Use the standard MySQL command-line client:
Connect to MySQL:
shell> mysql -u root -p
From the mysql client, load the file:
mysql> SOURCE C:/temp/world_x-db/world_x.sql;
Enter your password when prompted. A non-
rootaccount can be used, provided that the account has privileges to create new databases.
Replace the path to the
world_x.sqlfile with the actual path on your system.Note
On Windows, use slashes rather than backslashes when executing the
To confirm that the sample
world_xdatabase is installed correctly, execute the following statements. You should see output similar to that shown here.
mysql> USE world_x; Database changed mysql> SHOW TABLES; +-------------------+ | Tables_in_world_x | +-------------------+ | city | | country | | countryinfo | | countrylanguage | +-------------------+ 4 rows in set (0.00 sec) mysql> SELECT COUNT(*) FROM city; +----------+ | COUNT(*) | +----------+ | 4079 | +----------+ 1 row in set (0.02 sec) mysql> SELECT COUNT(*) FROM country; +----------+ | COUNT(*) | +----------+ | 239 | +----------+ 1 row in set (0.00 sec)
You now have the
world_x sample database
Another popular sample database is the Sakila database. For additional details, see http://dev.mysql.com/doc/sakila/en/.