To load data massively into your Jigsaw database, you must have the Jigsaw database created and the MySQL server running. You already know how to do this. If not, please refer to Chapter 1 for the installation of MySQL and Chapter 8 for the creation of the Jigsaw database.
Note
This tutorial will overwrite all your data in the js
database. If you don't want to overwrite the data in your js
database, you could simply create a new database with a different name and run the js.sql
script to create the tables in your new database.
After checking that everything is in order, follow these instructions:
From Packt's website download the
js_data.sql
script file.Launch the MySQL query browser.
From the File menu select Open Script....
Locate the downloaded file and open it.
At the beginning of the script file you will see this line:
USE js;
If you created a new database, replace the name
js
by the name of your new database.Click on the Execute button.
At the...