The Specify Setup Wizard requires the default engine for MySQL to be set to InnoDB to build the Specify database, other default engine settings will require that a Specify database be built manually with MySQL command line interface.

Note: that this method is only recommended for sites where mySQL is already in use and where InnoDB is not the default MySQL data engine. If you are creating a Specify database in a fresh installation of MySQL, which has InnoDB has the default, do not use this method, use the Specify Wizard instead to create a new Specify database installation.

To create the Specify database within MySQL you will need to contact us to get the MySQL script. Once you have received the script from us, use the following command lines, which are distinguished with red text:

In Linux, your command line prompt may be a "$' or other shell character, for Windows installations of MySQL the command line prompt will be "Drive:\path>" such as "C:\windows\system32>". The MySQL \bin directory should be in your Path variable. (Use the command "Set" to see if it is. If it is not present you will need to change your current working directory to C:\program files\MySQL\MySQL Server 5.5[or whichever version you have installed]\bin). The drive letter may not be "C:" if you installed MySQL elsewhere.

    $ mysql -u root -p

    Enter password: (enter the password for the root user in your MySQL installation.)

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is ####

Server version: 5.#.## MySQL Community Server (GPL)

(more text)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

    mysql> create database specify;

Query OK, 1 row affected (0.00 sec)

    mysql> exit

Bye

    $ mysql -u root -p specify <[insert path to this saved file:] specify_build.sql

    Enter password: (enter the password for the root user in your MySQL installation.)

    $ mysql -u root -p specify

    Enter password: (enter the password for the root user in your MySQL installation.)

    mysql> show databases;

(will display a simple table that shows a database "specify")

    mysql> exit

Bye

----------------

Then start the Specify Wizard application that is part of the Specify download. In the Wizard form, enter the "IT User" username and password and the database name (e.g. "specify"). Click the "Test IT Login" button to confirm that you have the IT user name, password and database name correct. Do not click on the "Create Specify Database" button, the database is already created, but once the test login is successful, click on "Next" and proceed through the Wizard to configure the database.