Step 2: Run SQL scripts

Run the SQL scripts in the table below.

Note: These scripts require administrator permissions on the server to run them.

CAUTION:

If you have a different port or different password, make sure that you change the password and port numbers in these examples to match the ones in your configuration.

Run these scripts from the MySQL Command Prompt window or from MySQL Workbench.

Action	SQL Script
Create Quartz	> source <your filepath>/create_quartz_mysql.sql
Create Hibernate repository	> source <your filepath>/create_repository_mysql.sql
Create Jackrabbit	> source <your filepath>/create_jcr_mysql.sql
Create Pentaho Operations mart	> source <your filepath>/pentaho_mart_mysql.sql

Note: You unpacked the Pentaho Operations mart SQL file while preparing your environment for the archive installation process. Depending on your environment, see Prepare your Windows environment for an archive install or Prepare your Linux environment for an archive install for details.