This documentation is for WSO2 API Manager 2.1.0. View documentation for the latest release.

All docs This doc

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: corrected the DB script paths

...

  1. Connect to the database and run the relevant script.
    For example, run the following command to create the API-M tables in a MySQL database.

    Code Block
    languagepowershell
    mysql -u root -p -DWSO2AM_DB < '<API-M_HOME>/dbscripts/apimgt/mysql.sql';



    Multiexcerpt
    MultiExcerptNameMySQLver
    Note

    <API-M_HOME>/dbscripts/apimgt/mysql.sql is the script that should be used for MySQL 5.6 and prior versions. If you database is MySQL 5.7 or later version, use  <API-M_HOME>/dbscripts/apimgt/mysql5.7.sql script file.

  2. Restart the WSO2 API-M server.

...

  1. Connect to the database and run the relevant script. 
    For example, run the following command to create the MB tables in a MySQL database.

    Code Block
    languagepowershell
    mysql -u root -p -DWSO2MB_DB < '<API-M_HOME>/dbscripts/mb-store/mysql.sql';
    Multiexcerpt includeMultiExcerptNameMySQLverPageWithExcerptChanging the Default API-M Databases
    Note

    <API-M_HOME>/dbscripts/mb-store/mysql.sql is the script that should be used for MySQL 5.6 and prior versions. If you database is MySQL 5.7 or later version, use  <API-M_HOME>/dbscripts/mb-store/mysql5.7.sql script file.

  2. Restart the WSO2 API-M server.

...

  1. Connect to the database and run the relevant script. 
    For example, run the following command to create the MB tables in a MySQL database.

    Code Block
    languagepowershell
    mysql -u root -p -DWSO2_METRICS_DB < '<API-M_HOME>/dbscripts/metrics/mysql.sql';

    MultiExcerptNameMySQLverPageWithExcerptChanging the Default API-M Databases
    Note
    Multiexcerpt include

    <API-M_HOME>/dbscripts/metrics/mysql.sql is the script that should be used for MySQL 5.6 and prior versions. If you database is MySQL 5.7 or later version, use  <API-M_HOME>/dbscripts/metrics/mysql5.7.sql script file.

  2. Restart the WSO2 API-M server. 

...