Embedded Server is an easy at installation server to be used by applications that do not require multi-user work with data. As an example, Embedded Server can be used for money access machines, automatic cash desks, different electronic facilities and so on. Please refer to MySQL Reference Manual for more details about Embedded Server’s features, usage, and licensing.
Here are known restrictions of current Embedded Server version. All of them are caused by the server itself, it is not a problem of dbForge Studio. For troubleshooting tips, refer to MySQL documentation.
Do either of these ways to configure the Embedded Server before using it:
To use my.ini file, you have to create it at the root Windows folder and fill its following sections:
[Server] - common settings for MySQL usual and Embedded servers.
[Embedded] - settings specific to Embedded server.
Tip: Find the details about the list of settings in MySQL Reference Manual.
Minimal my.ini example:
[embedded]
basedir=c:/servers/embedded/
datadir=c:/servers/embedded/data/
According to this configuration, contents of the share folder can be found in the c:\servers\embedded\share\ path, data is located in the c:\servers\embedded\data\ folder. Notice the use of forward slashes instead of backslashes.
1. Open the Database Connection Properties dialog box by any of these ways:
Right-click in the Database Explorer window and select New Connection on the menu
Note
The Database Explorer is not available in the dbForge Data Compare for MySQL, dbForge Schema Compare for MySQL.
2. Switch to the Embedded tab of the Database Connection Properties dialog box.
3. Check Use embedded server.
4. Clear the Use my.ini file check box and fill Base directory and Data directory fields if you want to set these directories manually and don’t want to use my.ini file.
5. Click OK to establish the database connection.