...
- Choose Administration> Database Configuration.
- Click the Create Database button.
In the Create Database dialog, indicate the desired database type and the connection settings for the new database.
Info icon false To create a new database of the same database type, indicate a new database location (e.g., schema, SID, service name, or path). To prevent overwriting, you cannot specify an existing database location. You do not need to remove the existing EM databases; just create the new database in a different location:- HyperSQL: Enter a new file path.
- MySQL: Enter a new schema.
- Oracle: Enter a new SID or service name.
To port a database to a different database type, select the target database type, then specify the desired location for the new database.
To create a new database account from this interface, enter the desired username and password, check Create a new user, then confirm the password. For new accounts on Oracle, you can also specify a data tablespace and temp tablespace—or you can leave those fields empty to use the defaults (<USER>_DATA> and <USER_TEMP>).
- At the bottom of the dialog, click Choose File, then select the location of the backup zip file.
- Click Create.
...
- Find the my.cnf/my.ini file for your installation of MySQL. For MySQL 5.7, see http://dev.mysql.com/doc/refman/5.7/en/option-files.html. For other versions, see the appropriate manual at http://dev.mysql.com/doc/index.html.
- Edit the file to use the parameter settings outlined below.
- Restart the MySQL Service
[mysqld]
...
- innodb = ON
...
- innodb_log_file_size = 5242880000 // This must be set to be 10x the largest content being loaded for the public marketplace.
...
- max_allowed_packet = 1G
...
- innodb_file_per_table = 1
...
- innodb_file_format = Barracuda
[mysql]
•
- max_allowed_packet = 1G
[client]
•
- max_allowed_packet = 1G