Accessing MySQL on VB.NET using MySQL Connector/Net, Part 3: Install Sample Database

This entry is part 3 of 8 in the series Accessing MySQL on VB.NET

You can download example databases for MySQL at http://dev.mysql.com/doc (Scroll down to Example Databases section). By the time I’m writing the article, there are 4 sample databases available on the page. I choose the world database since it compatible with all MySQL version.

Step-by-step to install sample database

  1. Download the sample database “world database”. Extract it, you’ll get the world.sql file to the Database PC. This file will be imported to MySQL in few steps later.
    Download Sample Database
  2. On the database PC, open command-line mode. Type below command to connect to the MySQL Server using MySQL’s root account.
    mysql -u root -p

    The parameter -p makes MySQL ask you to enter the password. Then, type the root’s password. In this example, it is “password”.
    Note: You can type this command on any path because I have added MySQL path to system environment while I was configuring MySQL Server on the previous part.
    Connect to MySQL Server

  3. Now I have connected to the MySQL Server. Next, I’m going to create an empty database name “world”.
    CREATE DATABASE world;

    Then, change the default database to the created database.

    USE world;

    Create A Blank Database

  4. Next, load the contents of “world.sql” file into the world database. The “world.sql” file was created on the first step.
    SOURCE c:world.sql

    You have to alter the path to where the world.sql file is located.
    Load World Content to MySQL Database

  5. You’ll see lot of output that MySQL performs query from the world.sql file.
    Query Output
  6. After MySQL finishes processing the world.sql file, try to test if the query is executed successfully. Type the command below to list all tables on the current database.
    SHOW TABLES;

    You’ll see that there are 3 tables.
    Show Tables

  7. You also can see the columns on the table by type the below command.
    DESCRIBE Country;

    View Columns of Table

  8. If you see the columns and tables as previous steps, it means that you have install sample database successfully.

Reference

Series Navigation<< Accessing MySQL on VB.NET using MySQL Connector/Net, Part 2: Setup MySQL ServerAccessing MySQL on VB.NET using MySQL Connector/Net, Part 4: Create & Grant MySQL User Account >>

One Response

  1. Vik September 10, 2010

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.