Online Documentation for SQL Manager for MySQL

Specifying destination database


Use this step of the wizard to set the destination database for copying objects to. If the database is already registered (i.e. RadioButton Registered database was selected at the previous step), then you just need to select a host and a database that resides on this host. Otherwise you should set all the connection properties using the corresponding boxes and options: Host name, Port, User name, Password, Database name.

 

Copy Database Wizard - Specifying destination database

 

 

Specify the host where the destination database resides: type in the host name in the Host name field or select one in the drop-down list.

Enter MySQL port to connect through in the Port field and provide authorization settings: User name and Password.

 

Optionally you can use Named pipe to connect to database. Define Named pipe in the respective field. Named pipe value is stored in the MySQL server configuration file.

 

Database

Type in the name of the database to copy objects into.

 

If necessary, check the CheckBox Create profile for destination database option to register database in SQL Manager for MySQL.

 

The Load connection info menu allows you to select the alias of a previously registered database and use it's registration info for the newly created/configured database.

 

 

Click the Next button to proceed to the Selecting components to copy step of the wizard.