+

Search Tips | Advanced Search

For up-to-date product documentation, see the IBM MobileFirst Foundation Developer Center.


Create the MySQL database tables manually

Use the SQL scripts that are provided in the MobileFirst Server installation to create the MySQL database tables.


Before you begin

The MySQL database must fulfill the requirement as described in MySQL database and user requirements.

As described in Set up databases, all the four MobileFirst Server components need tables. They can be created in the same schema or in different schemas. However, some constraints apply depending on how the MobileFirst Server applications are deployed to the Java™ application server. They are the similar to the topic about the possible users for MySQL as described in Database users and privileges.

The scripts to create the tables are as follows:

The following example creates the tables for all the applications for the same user and database. It assumes that a database and a user has been created as in 'Requirements for the databases/MySQL'

The following procedure creates the tables for all the applications for the same user (mfpuser) and database (MFPDATA). It assumes that a database and a user are already created. For more information, see MySQL database and user requirements.


Procedure

  1. Run a MySQL command line client with the option: -u mfpuser.
  2. Enter the following commands:

      USE MFPDATA;
      SOURCE mfp_install_dir/MobileFirstServer/databases/create-mfp-admin-mysql.sql;
      SOURCE mfp_install_dir/MobileFirstServer/databases/create-configservice-mysql.sql;
      SOURCE mfp_install_dir/MobileFirstServer/databases/create-runtime-mysql.sql;
      SOURCE mfp_install_dir/PushService/databases/create-push-mysql.sql;

Parent topic: Create the database tables manually