Page 1 of 1
MySQL.sym error in Embedded mySQL
Posted: Sun 11 Jan 2009 21:08
by ausgen
Whenever I run the embedded mysql demo the following error message is returned under build 57.0.43 & 44 with both D2007 & D2009.
'Project Embedded.exe raised exception class Exception with message 'A call to an mysql_server_init failed
C:\Users\Public\Documents\Devart\MyDac for RAD Studio 2007\Demos\Win32\TechnologySpecific\Embedded\data\mysql.sym - The system cannot find the file specified'.
I am getting the same error in a prototype application that I am putting together. Any help would be appreciated.
Dennis
Posted: Tue 13 Jan 2009 10:14
by Dimon
Please specify the exact version of your Embedded server.
Also make sure that you have privileges to create files in the Embedded\data and Embedded\data\test directories.
Posted: Tue 13 Jan 2009 13:23
by ausgen
The MySQL version is 5.1.30 and files ib_logfile0, ib_logfile1 & ib_data1 plus folder TEST created successfully. The log created when the demo is executed is as below.
InnoDB: The first specified data file C:\Users\Public\Documents\Devart\MyDac for RAD Studio 2007\Demos\Win32\TechnologySpecific\Embedded\data\ibdata1 did not exist:
InnoDB: a new database to be created!
090114 0:17:19
InnoDB: Setting file C:\Users\Public\Documents\Devart\MyDac for RAD Studio 2007\Demos\Win32\TechnologySpecific\Embedded\data\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
090114 0:17:19
InnoDB: Log file C:\Users\Public\Documents\Devart\MyDac for RAD Studio 2007\Demos\Win32\TechnologySpecific\Embedded\data\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file C:\Users\Public\Documents\Devart\MyDac for RAD Studio 2007\Demos\Win32\TechnologySpecific\Embedded\data\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
090114 0:17:20
InnoDB: Log file C:\Users\Public\Documents\Devart\MyDac for RAD Studio 2007\Demos\Win32\TechnologySpecific\Embedded\data\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file C:\Users\Public\Documents\Devart\MyDac for RAD Studio 2007\Demos\Win32\TechnologySpecific\Embedded\data\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
Posted: Wed 14 Jan 2009 07:40
by Dimon
I could not reproduce the problem.
Please try to set the MySQLEmbDisableEventLog variable to True. This varible is declared in the MySqlApi unit.
If it doesn't solve the problem, please try to use another version of MySQL Embedded server (e.g. 4.1.18 ).
Got it working ...
Posted: Wed 14 Jan 2009 11:56
by ausgen
Works fine under libmysqld.dll 4.1.22, fails with 4.0.18 and 5.0.xx
Setting the MySQLEmbDisableEventLog variable
Posted: Wed 14 Jan 2009 19:48
by ausgen
Setting the MySQLEmbDisableEventLog variable to True does not resolve the issue with embedded server 5.1.x.
Posted: Fri 16 Jan 2009 13:17
by Dimon
I still can not reproduce the problem.
It is possible, it is a bug of MySQL Embedded server but not MyDAC.
Re: MySQL.sym error in Embedded mySQL
Posted: Fri 05 Jul 2013 01:46
by suathd
replace the
errmsg.sys file (which is under C:\Users\Public\Documents\Devart\MyDAC for XXXX\Demos\TechnologySpecific\Embedded\share\english) with your errmsg.sys file (which is in your
share folder)
good luck
