|
Connect and load each database to the MySQL Server
|
10 of 10
|
Each of the DataBreeze databases that are included with the distribution (system, templates and demonstrations) will require a connection to the target SQL Server. After a successful connection has been established, each DataBreeze database ('system' excluded) contains a text SQL Script file that needs to be executed via the database Import/Export to load the SQL database into the target MySQL Server.
Each DataBreeze database will require a connection to two SQL accounts, one for the SQL Administrator and one for SQL End User data access. For simplicity this example will create one Administrative and one End User SQL account that will be used for all of the distribution databases.
Before connection is attempted to any of the distribution SQL databases, the database must be created and the two SQL Accounts permitted access.
In this demonstration, the SQL Administrator account will be called dbz_admin. The SQL End User account will be called dbz_admin_user. You may substitute your own names instead, but the accounts configured in the DataBreeze database connection must match permissions granted within the MySQL database.
The actual DataBreeze databases that are included with your distribution may vary. You should check the following Hosts:
- help - This Host contains the database 'help' which includes all system documentation and help.
- root - The root Host contains the system database that defines all Administration interfaces. The system database provides online help integrated into the Administrator tools. The actual data is stored in the 'help' database, so an SQL connection must be created for the system database to the SQL help (dbz_help) database. Please note that the system database has two SQL connections that must be individually configured. Since the connection is made to an already established database, no SQL Script needs to be run or loaded.
- demo - This Host contains all demonstration databases.
- template - The template Host contains each template database.
| MySQL Configuration
| |
Establish connection and load each included database
|
- From DataBreeze, login as the admin User.
- Use the Host Directory link to visit each included Host that contain databases (root, demo, help, template and possibly others)
- For each database in the selected Host directory:
- Click on the database to enter.
- Within the Start->SQL Admin menu, choose the SQL Connection Manager.
- For each connection in the Database (typically one except for the system DB that has two):
- Open the connection in E Edit mode. Note the SQL Database Name.
-
|
From the MySQL command line:
|
|---|
Create the new database and issue a permission statement for each SQL Account on the new database.
- sql_database_name The SQL Database Name as it appears in step 1 of the SQL Connection Manager
- dbz_admin/password The SQL Administrator name and password. Must match with the SQL Connection Manager.
- dbz_admin_user/password The SQL End User name and password. Must match with the SQL Connection Manager.
- localhost The DataBreeze Server Hostname, localhost in this single machine example
The following commands should be run, with your own substitutions (if desired) used for the colored words.
|
CREATE DATABASE sql_database_name;
GRANT ALL PRIVILEGES ON sql_database_name.* to dbz_admin@localhost IDENTIFIED BY 'password';
GRANT SELECT, INSERT, UPDATE, DELETE ON sql_database_name.* to dbz_admin_user@localhost IDENTIFIED BY 'password';
| |
- Continuing with the SQL Connection Manager, follow the step-by-step configuration process and confirm the connection.
NOTE: skip the next two steps for the system database.
- Within the Start->Data IO menu, choose SQL Restore/Import.
- Follow the step-by-step Import process using the load script to load the SQL portion of the database.
| |
