Before you create a MySQL workspace
Before you create the workspace, the source and destination databases should already exist.
When Tonic Structural generates data for MySQL, the destination database uses the same name as the source database. To prevent a conflict, the source and destination databases must be on different servers.
On each database, you must create a user that has the required permissions that Structural needs to function.
Creating the source database user
The following is an example of how to create a new user, called tonic
, and grant the necessary permissions.
For the source database, we recommend that you use a backup or fast follower database instead of connecting directly to your production environment.
The following additional grants are optional. They allow you to include triggers, routines, and events.
If you use any of these GRANT
options, then Structural copies the respective object types from the source to the destination database. Otherwise they are excluded.
Creating the destination database user
Last updated