Step 1: Download and install MySQL
If you have an existing MySQL instance that you wish to use, skip ahead to Step 2.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.5.46 MySQL Community Server (GPL)
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.5) and change or add the following variables under the
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
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 CMS database
Download the Cascade CMS database.
After downloading, unzip the database.
Step 5: Import the Cascade CMS 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 CMS database file.
Your MySQL database is now configured and ready to be used by Cascade CMS.