How can I create Embedded database from this IDE?

senglory · Post by **senglory** » Sat 21 Aug 2010 08:04

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?

Alexz · Post by **Alexz** » Sat 21 Aug 2010 09:07

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.

senglory · Post by **senglory** » Sat 21 Aug 2010 15:11

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?

Viktor · Post by **Viktor** » Wed 25 Aug 2010 11:28

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?

senglory · Post by **senglory** » Sun 12 Sep 2010 19:21

I created the connection but got message:

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

What's wrong to my connection or MySQL?

Viktor · Post by **Viktor** » Tue 14 Sep 2010 13:12

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\

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.

senglory · Post by **senglory** » Tue 14 Sep 2010 15:08

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?

.jp · Post by **.jp** » Tue 14 Sep 2010 16:23

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.

Viktor · Post by **Viktor** » Wed 15 Sep 2010 08:51

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