Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Reverted from v. 57
Excerpt
hiddentrue

NOTE TO WRITERS: Add the following to the beginning of your hosting page:

The following sections describe how to replace the default H2 databases with MySQL:

Table of Contents
maxLevel3
locationtop
styleborder:1
separatorpipe

...

  1. To create tables in the registry and user manager database (WSO2CARBON_DB), use the below script:

    Info

     You may have to enter the password for each command when prompted.

    Code Block
    languagepowershell
    mysql -u regadmin -p -Dregdb < '<PRODUCT_HOME>/dbscripts/mysql.sql';
    Note

    If you are using MySQL version 5.7 or later, rename mysql5.7.sql to mysql.sql and execute use the following commandscript instead:

    mysql -u regadmin -p -Dregdb < '<PRODUCT_HOME>/dbscripts/mysql.sql';
    We plan to merge the two scripts (
    mysql5.7.sql
    and mysql.sql) in a later version.
    ';
  2. Restart the server.

    Info

    You can create database tables automatically when starting the product for the first time by using the -Dsetup parameter as follows:

    • For Windows: <PRODUCT_HOME>/bin/wso2server.bat -Dsetup

    • For Linux: <PRODUCT_HOME>/bin/wso2server.sh -Dsetup

...