dots Created with Sketch.
Yogesh Chauhan's Blog

How to import MySQL small sample database into phpMySQL?

in SQL/MySQL on August 13, 2019

In this small blog post I am going to show you how to download the MySQL database for the upcoming articles on this blog. You can use this database for your small projects or just for learning purpose as well. 

This database has 3 tabes as follows. 

  • country: Information about countries of the world.
  • city: Information about some of the cities in those countries.
  • countrylanguage: Languages spoken in each country.

Click to Download the database file.

After downloading the database file, follow the instructions below to install it. 

  1. Extract the .gz file in any desired location and you'll see world.sql file.
  2. Log into your phpmyadmin account. The id is root and leave the password field empty.
  3. Go to your server's homepage and click on the "import" option from the menu bar.
  4. Choose the world.sql file to upload and click on the "Go" button leaving all the other options as they are. 
  5. That's it. In less than a minute you'll see the table and columns in the left column bar. Go ahead and play with the database. 

If you're using MySQL Shell, follow this link to know how to install the database.

Note: The sample data used in the world database is Copyright Statistics Finland,  http://www.stat.fi/worldinfigures.

amazon

Most Read

#1 How to check if radio button is checked or not using JavaScript? #2 Solution to “TypeError: ‘x’ is not iterable” in Angular 9 #3 How to add Read More Read Less Button using JavaScript? #4 How to uninstall Cocoapods from the Mac OS? #5 PHP Login System using PDO Part 1: Create User Registration Page #6 How to Use SQL MAX() Function with Dates?

Recently Posted

#Jul 22 Is there a CSS parent selector? #Jul 22 Difference between :where and :is in CSS #Jul 22 Does :is() pseudo selector hint at CSS preprocessing in the future? #Jul 22 Control Scrolling with CSS Scroll Snap #Jul 21 Control rendering using CSS content-visibility property #Jul 21 How to use @supports rule in CSS?
You might also like these
The 7 Security Objectives of Any Organization for IT and Network SecurityMiscellaneousWhat are Stored Procedures for SQL Server?SQL/MySQLHow to animate list items using CSS and JavaScript?CSSCSS Attribute SelectorsCSSSolution to the error “Visual Studio Code can’t be opened because Apple cannot check it for malicious software”MiscellaneousHow to apply style only to first child and/or only to children other than the first child?CSS