How to load the sample database into the MariaDB server.

1. Download  the Sample Database 

(Source : https://www.mariadbtutorial.com/getting-started/mariadb-sample-database/ )

2. unzip the file to a directory e.g., c:\mariadb\nation.sql

2.  connect to the MariaDB server with the root user account, type the password and press the  Enter keyboard.

sudo mysql -u root -p
Enter password: ********

3.  Load the database by using the source command:

mysql>source c:\mariadb\nation.sql

4. select the nation database and display tables of the database:

mysql> use nation;
Database changed
mysql> show tables;