Devart Forums

How can I create Embedded database from this IDE?
I tried to copy LIBMYSQLD.DLL to c:\windows, IDE starts but crashed with something like "memory read-write error" when it comes to open embedded-based connection. What I'm doing wrong and what's the right way to do this stuff?

Did you read the topic "Working with Embedded Server" in the product documentation?
If you fail to connect after reading it, let us know, please.

This is exactly what happens in my case. IDE crashes right at the moment of connecting to embedded database. Perhaps I'm doing something wrong? Could you tell me the exact instructions, step-by-step, how to prepare embedded server and how to open it in dbForge?

Try to copy LIBMYSQLD.DLL into the installation folder of dbForge Studio - D:\Program Files\Devart\dbForge Studio for MySQL\

Then on the Embedded tab of the Database Connection Properties, in the Base folder field, specify the path to the embedded server folder (for example, it can be named embedded), in the data folder - the path to the Data folder (it should be located in the embedded folder).
Press Test Connection.

Have you created the connection?

I created the connection but got message:

Can't connect to MySQL server on localhost (10061)

What's wrong to my connection or MySQL?

Use libmysqld.dll (MySQL 5.1.30 version). Place it to a directory, where dbForge Studio is installed.
Restart dbForge Studio for MySQL.
For example:
1. Create folder c:\BaseDir\
2. Create folder c:\BaseDir\Data\
3. Copy "share" folder from the MySQL server installation to the C:\BaseDir\

1. c:\BaseDir\c:\BaseDir\Data\c:\BaseDir\share\

4. Create New Connection.
Switch to the Embedded tab of the Database Connection Properties dialog box.
Check Use embedded server.
Uncheck Use my.ini file.
Fill "Base folder"=c:\BaseDir\ and "Data folder"= c:\BaseDir\Data\ fields.
Press OK to establish the database connection.

I have MySQL 5.1.50 version (don't know where to get 5.1.30), did all what you wrote and still getting "attempt to read or write protected memory" on 3 different machines (WinXP Pro SP3 ). dbForge v 4.50.303

How can I eliminate this issue?

In our test environment we used libmysqld.dll from MySQL 5.1.30, and everything worked OK. However, it seems that changes were made to this library, which is used for connecting to the embedded server, in version 5.1.40 and higher. Now we are investigating the reason of the error.

I have MySQL 5.1.50 version , did all what you wrote and still getting "attempt to read or write protected memory" on 3 different machines (WinXP Pro SP3 ). dbForge v 4.50.303

Yes, this is a bug. It will be fixed in one of the next builds.
Workaround: To work with MySQL Embedded server use libmysqld.dll version 5.1.30.

don't know where to get 5.1.30

Link: Http://downloads.mysql.com/archives.php ... 1&v=5.1.30