TestingDocs.com
Software Testing website
  • Automation
    • Selenium
    • JBehave Framework
  • Tutorials
    • MySQL Tutorials
    • Testlink
    • Maven
    • Git
  • IDEs
    • IntelliJ IDEA
    • Eclipse
  • Flowcharts
    • Flowgorithm
    • Raptor
  • About

MySQL

Setup MySQL world Database

Overview

This tutorial is a step-to-step guide to setup the MySQL world Database and the tables in the schema. The world sample sample database is an example database from MySQL team.

Download world Database

Download the MySQL script file that contains the SQL statements. To download the database navigate to the following URL:

https://dev.mysql.com/doc/index-other.html

In the Example Databases section, click on world database download links. The download is available in two formats.

On Windows Operating system click on the Zip download link.

OnĀ  Linux distributions click on the TGZ download link.

 

MySQL World Database Download

 

Extract Contents

Extract the contents of the world-db zip file. Copy the world.sql file to a suitable location.

Connect to the MySQL server using the mysql command-line client::

$> mysql -u root -p

Enter the root password. We can also use a non-root user account. The user account should have privileges to create new database. To know more about the MySQL command line client:

https://www.testingdocs.com/mysql-command-line-client/

Install Database

Execute the world.sql SQL script file to create the database structure and insert the data. In this example, the world.sql file is located at following location :

C:/TestingDocs/world.sql

Issue the following command at the MySQL command prompt.

mysql> SOURCE C:/TestingDocs/world.sql;

Press the Enter button to execute the command.

 

Install MySQL world Database

 

The database and the tables would be installed. To confirm we can use the following command to know the tables:

mysql> SHOW TABLES;

MySQL world tables

https://www.testingdocs.com/mysql-world-database-tables/

—

MySQL Tutorials

MySQL Tutorials on this website:

https://www.testingdocs.com/mysql-tutorials-for-beginners/

For more information on MySQL Database:

https://www.mysql.com/

Related Posts

MySQL Workbench Windows 11

MySQL /

New MySQL Connection in Workbench

MySQL Command-line Client

MySQL /

Command-Line MySQL Client

Start MySQL Client

MySQL /

Start MySQL Client on Windows 11

Windows 11 Services Run Prompt

MySQL /

Start MySQL Server on Windows 11

MySQL Community Downloads TDocs

MySQL /

Download & Install MySQL on Windows 11

‹ MySQL Community vs Enterprise Edition› MySQL world Database Tables

Recent Posts

  • Install RAPTOR Avalonia on CentOS
  • Download RAPTOR Avalonia Edition on Windows
  • npm doctor command
  • RAPTOR Editions
  • Flowgorithm Conditional Breakpoint Statement
  • Flowgorithm Read Numbers from File Example
  • Search Text File Flowchart Example
  • Flowgorithm Turtle Graphics Symbols
  • Draw Circle using Flowgorithm Turtle
  • Draw Parallel Lines using Flowgorithm Graphics

Back to Top

Links

  • Contact
  • Privacy Policy
  • Cookie Policy

www.TestingDocs.com

Go to mobile version