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.