Loading the Winestore Database : PHP

The steps to load the winestore database are as follows:

Download a copy of the winestore database.
Uncompress the winestore database package in any directory by running:
```
gzip -d winestore.database.tar.gz
```
Untar the tape archive file by running:
```
tar xvf winestore.database.tar
```
A list of files extracted is output.
Check that MySQL is running using:
```
/usr/local/bin/mysqladmin -uroot -ppassword version
```
where password is the root user password. If MySQL isn't running, log in as the Linux root user, and start the MySQL server using:
```
/usr/local/bin/safe_mysqld --user=mysql &
```
Run the MySQL command-line interpreter using the username and password created when MySQL was installed, and load the winestore data. The login name is username, and the password is password:
```
/usr/local/bin/mysql -uusername -ppassword < winestore.database
```

After the loading is complete-it may take a few seconds-the database can be tested by running a query. Type the following command on one line:

/usr/local/bin/mysql -uusername -ppassword -e 'USE winestore; SELECT * FROM region;'

This should produce the list of wine regions as output:

+-----------+---------------------+-------------+------+
| region_id | region_name         | description | map  |
+-----------+---------------------+-------------+------+
|         1 | Goulburn Valley     | NULL        | NULL |
|         2 | Rutherglen          | NULL        | NULL |
|         3 | Coonawarra          | NULL        | NULL |
|         4 | Upper Hunter Valley | NULL        | NULL |
|         5 | Lower Hunter Valley | NULL        | NULL |
|         6 | Barossa Valley      | NULL        | NULL |
|         7 | Riverland           | NULL        | NULL |
|         8 | Margaret River      | NULL        | NULL |
|         9 | Swan Valley         | NULL        | NULL |
+-----------+---------------------+-------------+------+

The winestore database has now been loaded and tested.