Configuration Guides › Directory Configuration Guide › MySQL Server › Configure MySQL Data Stores › How to Store Session Information in MySQL › Create the Session Store Schema

Create the Session Store Schema

You create the session store schema so the MySQL database can store session information.

To create the session store schema

1. Navigate to path\MySQL.

   path

   Specifies the path to the schema files extracted from the tier 2 directory zip.

2. Open the following file in a text editor:

   sm_mysql_ss.sql

3. Locate the following lines:

   DROP FUNCTION IF EXISTS `databaseName`.`getdate` $$
   CREATE FUNCTION `databaseName`.`getdate` () RETURNS DATE
   

4. Replace each instance of 'databaseName' with the name of the database functioning as the session store.

   Example: If the name of the database is smsessionstore, the required update appears as follows:

   DROP FUNCTION IF EXISTS `smsessionstore`.`getdate` $$
   CREATE FUNCTION `smsessionstore`.`getdate` () RETURNS DATE
   

5. Copy the contents of the entire file.
6. Paste the file contents into a query and execute the query.

   The session store schema is created.