<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="mysql-shell-tutorial-python-download">
      </a>
      22.4.2 Download and Import world_x Database
     </h3>
    </div>
   </div>
  </div>
  <p>
   As part of this quick-start guide, an example schema is provided
      which is referred to as the
   <code class="literal">
    world_x
   </code>
   schema.
      Many of the examples demonstrate Document Store functionality
      using this schema. Start your MySQL server so that you can load
      the
   <code class="literal">
    world_x
   </code>
   schema, then follow these steps:
  </p>
  <div class="orderedlist">
   <ol class="orderedlist" type="1">
    <li class="listitem">
     <p>
      Download
      <a class="ulink" href="http://downloads.mysql.com/docs/world_x-db.zip" target="_blank">
       world_x-db.zip
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      Extract the installation archive to a temporary location such
          as
      <code class="filename">
       /tmp/
      </code>
      . Unpacking the archive results
          in a single file named
      <code class="filename">
       world_x.sql
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      Import the
      <code class="filename">
       world_x.sql
      </code>
      file to your
          server. You can either:
     </p>
     <div class="itemizedlist">
      <ul class="itemizedlist" style="list-style-type: disc; ">
       <li class="listitem">
        <p>
         Start MySQL Shell in SQL mode and import the file by
              issuing:
        </p>
        <div class="copytoclipboard-wrapper">
         <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa33625594"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-terminal">mysqlsh <span class="token property">-u</span> root <span class="token property">--sql</span> <span class="token property">--file</span> /tmp/world_x-db/world_x<span class="token punctuation">.</span>sql
Enter password<span class="token punctuation">:</span> ****</code></pre>
        </div>
       </li>
       <li class="listitem">
        <p>
         Set MySQL Shell to SQL mode while it is running and
              source the schema file by issuing:
        </p>
        <div class="copytoclipboard-wrapper">
         <pre class="programlisting language-mysqlsh"><div class="docs-select-all right" id="sa12562761"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-mysqlsh">\sql
Switching to SQL mode<span class="token operator">...</span> Commands end <span class="token keyword">with</span> <span class="token punctuation">;</span>
\source <span class="token operator">/</span>tmp<span class="token operator">/</span>world_x<span class="token operator">-</span>db<span class="token operator">/</span>world_x<span class="token punctuation">.</span>sql</code></pre>
        </div>
       </li>
      </ul>
     </div>
     <p>
      Replace
      <code class="filename">
       /tmp/
      </code>
      with the path to the
      <code class="filename">
       world_x.sql
      </code>
      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.
     </p>
    </li>
   </ol>
  </div>
  <div class="simplesect">
   <div class="titlepage">
    <div>
     <div class="simple">
      <h4 class="title">
       <a name="mysql-shell-tutorial-python-world-x">
       </a>
       The world_x Schema
      </h4>
     </div>
    </div>
   </div>
   <a class="indexterm" name="idm46045127324832">
   </a>
   <p>
    The
    <code class="literal">
     world_x
    </code>
    example schema contains the
        following JSON collection and relational tables:
   </p>
   <div class="itemizedlist">
    <ul class="itemizedlist" style="list-style-type: disc; ">
     <li class="listitem">
      <p>
       Collection
      </p>
      <div class="itemizedlist">
       <ul class="itemizedlist" style="list-style-type: circle; ">
        <li class="listitem">
         <p>
          <code class="literal">
           countryinfo
          </code>
          : Information about
                countries in the world.
         </p>
        </li>
       </ul>
      </div>
     </li>
     <li class="listitem">
      <p>
       Tables
      </p>
      <div class="itemizedlist">
       <ul class="itemizedlist" style="list-style-type: circle; ">
        <li class="listitem">
         <p>
          <code class="literal">
           country
          </code>
          : Minimal information about
                countries of the world.
         </p>
        </li>
        <li class="listitem">
         <p>
          <code class="literal">
           city
          </code>
          : Information about some of the
                cities in those countries.
         </p>
        </li>
        <li class="listitem">
         <p>
          <code class="literal">
           countrylanguage
          </code>
          : Languages spoken in
                each country.
         </p>
        </li>
       </ul>
      </div>
     </li>
    </ul>
   </div>
  </div>
  <div class="simplesect">
   <div class="titlepage">
    <div>
     <div class="simple">
      <h4 class="title">
       <a name="idm46045127313040">
       </a>
       Related Information
      </h4>
     </div>
    </div>
   </div>
   <div class="itemizedlist">
    <ul class="itemizedlist" style="list-style-type: disc; ">
     <li class="listitem">
      <p>
       <a class="ulink" href="/doc/mysql-shell/8.4/en/mysql-shell-sessions.html" target="_top">
        MySQL Shell Sessions
       </a>
       explains session
            types.
      </p>
     </li>
    </ul>
   </div>
  </div>
 </div>
 <br/>
</div>
