Setting Up the Database (MySQL)

Step 1: Download and install MySQL 5.0/5.1/5.5

NOTE: MySQL 5.5 is only supported with Cascade 7.2+.

If you have an existing MySQL instance that you wish to use, skip ahead to Step 2.

Download and install MySQL (5.0, 5.1, or 5.5). To verify that MySQL is running, type mysql -u root at a command line. You should see something like this:

Welcome to the MySQL monitor.  Commands end with ; or \g.  
Your MySQL connection id is 303 to server version: 5.0.27-community-nt

If the command is not recognized, either navigate to the MySQL bin directory and try again or add the MySQL bin directory to your $PATH).

Step 2: Edit your MySQL configuration file

IMPORTANT: Make sure that your database is configured to use the InnoDB storage engine.

On Windows, edit your my.ini file located in the MySQL program folder (e.g. C:\Program Files\MySQL\MySQL Server 5.0) and change or add the following variables under the [mysqld] section:

max_allowed_packet=16M    
key_buffer=16M

On Linux, Unix, or OS X, edit your my.cnf file (usually located in the /etc directory) and change or add the following variables under the [mysqld] section:

max_allowed_packet=16M    
key_buffer=16M

Note: these are minimum memory settings. If they are already set to something higher, you can keep the original values.

For additional information regarding these configuration files, please reference MySQL's documentation.

Step 3: Restart MySQL

MySQL must be restarted in order for any changes to take effect.

Step 4: Download the Cascade Server database

Download the Cascade Server database.

After downloading, unzip the database.

Step 5: Import the Cascade Server database

From a command line, open a MySQL prompt and execute the following commands (replacing 'cascade' with the database name of your choice):

CREATE DATABASE `cascade`;  
ALTER DATABASE `cascade` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;  
exit

Exit the MySQL prompt.

To import the database on Windows, execute the following at a command line:

mysql -u root -p --default-character-set=utf8 cascade < \path\to\file\cascade.sql

To import the database on Linux, Unix, or OS X, execute the following at a command line:

mysql -u root -p --default-character-set=utf8 cascade < /path/to/file/cascade.sql

where 'cascade' is the name of your new database and '/path/to/file/cascade.sql' is the full directory path to the Cascade Server database file.

Your MySQL database is now configured and ready to be used by Cascade Server.