MySQL Forums - Embedded

MySQL Embedded server on Windows hang in mysql_init with INFINITE WaitForSingleObject (no replies)

Ismael Briones Vilar — Mon, 08 Apr 2013 21:16:46 +0000

Hi.

I'm trying build a program with MinGW (4.7), using libmysqld, but it enter in a loop in mysql_init and never get out of this function. I debuged it and this is the call stack:

myslq_init
mysql_server_init
init_embedded_server
init_server_components
plugin_init
plugin_initialize
int (** plugin_type_initialize)(st_plugin_int *)
innobase_start_or_create_for_mysql
recv_recovery_from_checkpoint_start_func
recv_synchronize_groups
rw_lock_s_lock_spin
sync_array_wait_event
os_event_wait_low
WaitForSingleObject - with a wait time of INFINITE

What is the problem?

This is the program:

#include
#include
#include
#include

MYSQL *mysql;
MYSQL_RES *results;
MYSQL_ROW record;

static char *server_options[] = {"mysql_test",
"--defaults-file=c:\\mysql_embedded\\my.ini",
NULL };
int num_elements = (sizeof(server_options) / sizeof(char *)) - 1;
static char *server_groups[] = {"embedded", "server", NULL };

int main(void)
{
mysql_library_init(num_elements, server_options, (char **)server_groups);

mysql = mysql_init(mysql);

mysql_library_end();

return 0;
}

This is my.ini:

[embedded]
basedir=C:/mysql_embedded
datadir=C:/mysql_embedded/data
language=C:/mysql_embedded/share/english

[server]
basedir=C:/mysql_embedded
datadir=C:/mysql_embedded/data
language=C:/mysql_embedded/share/english

I compile with:

g++ -o test test.cpp -Id:\MySQLServer5.6.10\include -Ld:\MySQLServer5.6.10\lib -l libmysqld -D__LCC__

I have tried with different version of libmysqld: MySQL 5.1.68, 5.5.30, 5.6.10 but all hangs in myslq_init.

I'm running it in VMware.

What's the problem?

how do I get the files? (no replies)

Darrel Christenson — Wed, 27 Mar 2013 15:46:20 +0000

I need the embedded server files for 5.5.17.

I neglected to install them originally.

I've re-run the installer multiple times and turned the embedded server on and
it says installing but no files/folder appears. I even tried a repair pass and
still nothing.

How can I get the embedded server files/docs?

Darrel Christenson

Can I some how use the MySQL Embedded (libmysqld.dll) using VB.NET ? (no replies)

Mark Dicken — Wed, 17 Oct 2012 04:25:17 +0000

Hi All (first post)

Can I somehow use the MySQL Embedded (libmysqld.dll) using VB.NET ?

All I want is an alternative to SQLite but using the MySQL Embedded Version

If there is a simple sample then please point me in the right direction

If this will not happen till some next release then I better tick along with SQLite and re-check MySQL in another year or so . . .

Many Thanks in Advance for any answers

Regards
MD

Mysql jdbc/mxj connector multiple instances error (no replies)

A Enfors — Mon, 10 Sep 2012 15:23:57 +0000

Hi
I am using MySQL with the jdbc and mxj connectors to embed the mysql database into my Java application. If I launch an instance of my Java program everything works fine, if I however try to start a second instance of the program I get the following error (both instances are running on the same windows machine) :

InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.

Does anyone know Why this is this?
Is there innoDB/MySQL configurations to be done to allow for concurrent access? Can an embedded mysql database not handle concurrent access?
Thanks

table_row is not constant in innodb partitioned table (no replies)

rajnish kumar — Tue, 26 Jun 2012 12:31:22 +0000

Hi Team,

As mentioned in mysql 5.5 documents

TABLE_ROWS: The number of table rows in the partition.
For partitioned InnoDB tables, the row count given in the TABLE_ROWS column is only an estimated value used in SQL optimization, and may not always be exact.
Beginning with MySQL Cluster NDB 7.0.22 and MySQL Cluster NDB 7.1.11, TABLE_ROWS shows correct information for NDB tables. Previously, for partitions of NDB tables, the TABLE_ROWS column value was always 0.
For NDB tables, you can also obtain this information using the ndb_desc utility.

, but i wannat know whether it is a bug or what , because i implement partition on innodb table aroung 96 lac record ,abd when I see count(*) on table table row number is ok but when I run query on information_schema.partitions and want to know which partition have how many rows ,it always varry .

i didnot understand what is going on ,How estimated value used in SQL optimization exceed total number of rows count in that table ?

can any one tell me in details why this things happend , i am using 5.5.20 MySQL Community Server (GPL) server .

i just wanna confirm wheter it is a bug or i can go ahead and implement partition on live environment.

thanks in Advance.

access denied (no replies)

Aaron Kerti — Wed, 13 Jun 2012 00:47:02 +0000

Hi, I'm using the c api and trying to access data off my mysql server(which is remote). When I try to connect it says access denied for user. How do I fix this? Is it something wrong with my server or code?

#include "stdafx.h"
#include

#include
#include

using namespace std;

int main()
{
MYSQL *conn;
MYSQL_RES *result;
MYSQL_ROW row;

std::cout << "start" << std::endl;

conn = mysql_init(NULL);

if(conn == NULL)
{
std::cout << "failed to initialize connection" << std::endl;
}

mysql_real_connect(conn, "216.51.232.61", "username", "password", "a1298_userAccounts", 0, "2082", 0);
cout << mysql_error(conn) << endl;

int query_result = mysql_query(conn, "SELECT * FROM UserAccounts");
std::cout << query_result << std::endl;

result = mysql_store_result(conn);

while ((row = mysql_fetch_row(result)))
{
std::cout << row[2] << std::endl;

if(row[2] == "shadyvillian")
{
if(row[3] == "a")
{
std::cout << "login successful" << std::endl;
}
}

}

mysql_free_result(result);
mysql_close(conn);

}

Is there a unique like? (1 reply)

Deepak K — Tue, 10 Jan 2012 01:32:46 +0000

I have to use LIKE in one of my columns. But the problem is that when i am using LIKE %abc% both abc, dabcd, abcde etc are selected together. But my requirement is a bit different.

What i need is:

If there are rows with entries abc,dsa abc, abcd etc when I select i have to get abc, and dsa abc rows.

Is this possible. Someone please comeup with a soulution.

Performance issues with embedded? (no replies)

Kevin Thorpe — Thu, 24 Nov 2011 17:03:50 +0000

Hi, I've just started playing with the embedded version to allow me to perform out-of-band long running queries against large continuously updating databases.

I have hit a performance issue though. The query I'm testing with takes 5 mins or so on the real mysql daemon (CentOS) but takes over an hour using the embedded version. Should I be expecting that sort of performance hit? It may be because I've only got the 32 bit version linked into a java library (myssql-je). Is it worth me spending the time to try and get it to compile 64 bit from source?

MySQL and Microchip PIC TCP/IP Stack (no replies)

Mauro Martins — Mon, 21 Nov 2011 17:01:31 +0000

Hello to all,

For a recent project (at least) I need to insert data into a MySQL database using a microcontroller with Ethernet connectivity.

Before starting with the microcontroller I'm trying to write an application using C# that connects to MySQL server using a TCP socket, but without using the "Connector" supplied by MySQL.

So far I'v only scratched the surface and was abel to establish connection and receive the welcome message from the server, I've been using this http://forge.mysql.com/wiki/MySQL_Internals_ClientServer_Protocol and the book "Understanding MySQL Internals".

My question, is there any C code I can port to my application? something where I could only change the way sockets are created and used (like a bottom layer) and use the upper layers?

The protocol doesn't seem very hard, but it will take very time until a working version is available.

Best regards, Mauro.

Debugging mysql_server_init() crash (no replies)

Brett Powell — Thu, 20 Oct 2011 00:27:24 +0000

The mysql_server_init() function seems to return 0 if success, 1 if error. Unfortunately, in my code when it returns 1, and I use Marshal.GetLastWin32Error() the error code is 0. I am assuming that it is not picking up on the error being generated by mysql_server_init(), but I am at a loss as to how to find out where the problem is now.

Here is the relevant code block...

[DllImportAttribute("libmysqld.dll", SetLastError = true)]
static extern int mysql_server_init(int argc, string[] argv, string[] groups);

static string[] server_options = new string[2];
static string[] server_groups = new string[3];

public static bool Start()
{
server_options[0] = "mysql_test"; // not used?
server_options[1] = "--defaults-file=./my.ini";

server_groups[0] = "client";
server_groups[1] = "server";
server_groups[2] = "\0";

if (mysql_server_init(2, server_options, server_groups) != 0)
{
int lastError = Marshal.GetLastWin32Error();
Console.WriteLine("MySQL Library Init Failed with error code: " + lastError);
return false;
}

Console.WriteLine("MySQL Library Started Successfully!");
return true;
}

mysqlconnector (no replies)

ranjeet jha — Mon, 01 Aug 2011 10:10:24 +0000

please any body give me code for connecting mysql in embedded c (arm7 keil compiler).

MySQL audit + approval system tool (no replies)

John Nash — Tue, 14 Jun 2011 10:06:11 +0000

Hi experts,
I'm looking for a specific DB admin tool.
I'm not looking for complicated BPM(business process management) software,
what I need is just some additional functionality embedded within admin tool.

What I need is the
1.Approvement system - whenever there is a request/need for new record, it needs approval from separate user before record gets updated
2.Audit - logging changes made by separate users

Commercial solution is also acceptable.

Thank you.

dump embedded database? (no replies)

Carlos Quiros — Mon, 04 Apr 2011 11:03:09 +0000

Hi,

I have an embedded database that I connect with using C++. Now, I want to move all the data from such database into a mysql server.

How can dump the embedded database into a SQL text file?

Thanks,
Carlos.

How to use Dephi connect MySQL Embedded? (no replies)

Masteritc SDN BHD — Sun, 07 Nov 2010 04:15:23 +0000

How to connect MySQL embedded using delphi?
Any component support it?

Thanks

mysql_library_init() fails in Embedded server v5.5.6 (1 reply)

cedric quilliot — Tue, 02 Nov 2010 21:43:56 +0000

Hello,

I have a program working fine with MySQL v5.1.51 embedded server.
Today I tried to link it against MySQL v5.5.6 rc .

The program fails during library init : mysql_library_init() returns 1, and the error file contains :

InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
101029 15:20:56 InnoDB: highest supported file format is Barracuda.

When the API is called, it lasts during 5 or 6 seconds, then fails (whereas in earlier releases it starts in less than a second).
The only arguments I pass to mysql_library_init() is the option "--defaults-file=mySql.ini", and my INI file contains only directives "basedir" and "datadir".

Any idea would be appreciated !

Thanks,

Cedric

Cascading auto-increment keys and C# DataSets (no replies)

Dave Williams — Thu, 28 Oct 2010 09:40:31 +0000

Hi

Does anybody know why the cascading foreign key relationships to auto-incrementing primary keys in a .net DataSet behaves differently with MySQL vs. MS SQL?

I'll flesh it out a bit. I created a parent table with an AI PK, and a child table with an AI PK and a foreign key field to the parent PK. Then I created a cascading relationship between the two, and a single typed DataSet with the same foreign key relationship. The DataSet's auto-increment is set to -1 (the default) to allow to SQL engine to supply the correct incremental values on update. The adapter is configured to 'Refresh the data table' after inserts. On MSSQL, I created 1 parent row and 2 child rows, added them and updated the database and the primary keys change to the next incremental values from the db, and the foreign key relationship holds.

Now with MySQL, I selected the Refresh data table option, but after update the new PK values aren't retrieved, and stay at -1. The parent row is committed to the db, but the child row can't because it doesn't know what the new parent PK is. Strangely enough, when I go back to the dataset wizard the refresh option is unchecked.

Is this expected behavior and does anybody know a workaround? Tried with v5.2.7 and 6.3.5, VS2008 on Win7.

Thanks, Dave

my.cnf for mysqld (no replies)

jotremar from — Thu, 28 Oct 2010 07:19:58 +0000

I use MXJ for a embedded server in Java app. When I start a new MysqlResource for server, how to pass path for my.cnf?

crash with libmysqld (no replies)

Jean-Michel Leon — Thu, 21 Oct 2010 21:55:19 +0000

Hello,

I'm trying to run the following program with libmysqld (5.0.91), and it is crashing on the mysql_library_end(); call with

Program terminated with signal 11, Segmentation fault.
#0 0x000000000058fbcd in innobase_release_stat_resources (trx=0xcdcdcdcdcdcdcdcd) at third_party/mysql50/sql/ha_innodb.cc:394
394 if (trx->has_search_latch) {
(gdb) bt
#0 0x000000000058fbcd in innobase_release_stat_resources (trx=0xcdcdcdcdcdcdcdcd) at third_party/mysql50/sql/ha_innodb.cc:394
#1 0x0000000000584ebc in innobase_release_temporary_latches (thd=0x7f5e7f850418) at third_party/mysql50/sql/ha_innodb.cc:425
#2 0x0000000000587244 in ha_innobase::close (this=0x7f5e84159b60) at third_party/mysql50/sql/ha_innodb.cc:2335
#3 0x0000000000713b33 in closefrm (table=0x7f5e8415da18) at third_party/mysql50/sql/table.cc:996
#4 0x000000000060f446 in intern_close_table (table=0x7f5e8415da18) at third_party/mysql50/sql/sql_base.cc:261
#5 0x000000000060f465 in free_cache_entry (table=0x7f5e8415da18) at third_party/mysql50/sql/sql_base.cc:280
#6 0x0000000000744357 in hash_delete (hash=0xe11020, record=0x7f5e8415da18 "\340\341\025\204^\177")
at third_party/mysql50/mysys/hash.c:539
#7 0x000000000060f58e in close_cached_tables (thd=0x0, if_wait_for_refresh=false, tables=0x0) at third_party/mysql50/sql/sql_base.cc:334
#8 0x000000000060f009 in table_cache_free () at third_party/mysql50/sql/sql_base.cc:117
#9 0x0000000000573fa9 in clean_up (print_message=false) at third_party/mysql50/libmysqld/../sql/mysqld.cc:1185
#10 0x000000000057986a in end_embedded_server () at third_party/mysql50/libmysqld/lib_sql.cc:561
#11 0x000000000056ab96 in mysql_server_end () at third_party/mysql50/libmysqld/libmysql.c:202
#12 0x000000000056aa3f in main (argc=6, argv=0x7fffc184a9b8) at storage/speckle/server/mysql/mysql_vanilla.cc:41

static MYSQL* Connect(const char* database) {
MYSQL* db = mysql_init(NULL);
assert(db != NULL);
mysql_options(db, MYSQL_OPT_USE_EMBEDDED_CONNECTION, NULL);
assert(db == mysql_real_connect(db, NULL, "mysql_test", NULL, database,
0, NULL, 0));
mysql_autocommit(db, true);
return db;
}

int main(int argc, char* argv[]) {
assert(0 == mysql_library_init(argc, argv, 0));
assert(1 == mysql_thread_safe());
assert(0 == mysql_thread_init());

{
// Create the database.
MYSQL* db = Connect(NULL);
assert(0 == mysql_query(db, "create database if not exists d"));
mysql_close(db);
}

// Open a connection to the new database.
MYSQL* db = Connect("d");

// Create the table.
assert(0 == mysql_query(
db, "create table if not exists t (i integer) engine=innodb"));
assert(0 == mysql_query(db, "insert into t values (1);"));
mysql_close(db);
mysql_thread_end();
mysql_library_end();
}

Any idea what's going on?

Thanks,

jm.

password authentication in embedded MySQL (1 reply)

Agus Setiono — Wed, 20 Oct 2010 10:33:54 +0000

Is password authentication feature in embedded MySQL (libmysqld.dll) disabled by default? That means, if I want to enable the feature then I have to build the DLL from the source, right?

Connecting MySQL to Virtools (no replies)

Fabio m — Mon, 27 Sep 2010 20:25:26 +0000

Hi there

I´m trying to do an app using Virtools to show data from a MySQL table but i´ve searched the Virtools forums and Google but there´s no information about this so i´m trying to find out if anyone understands using these two programs.

Virtools uses building blocks to build applications for the web, gaming or virtual reality but i don´t know what building block script i should make.

Thanks very much for your help.
Fabio

iMy 2.0 for iPhone with SSH support (no replies)

David Koretzky — Tue, 27 Jul 2010 20:03:58 +0000

Spanware is pleased to announce iMy 2.0, the full MySQL client for the iPhone.

iMy was the first MySQL client for the iPhone back in 2008, and now it is the first to add SSH tunneling for secure connections.

iMy lets you not only download query results directly from your iOS device, but upload large queries from your desktop to avoid typing.

iMy also has a new drag-tap query building interface that incorporates nearly every MySQL keyword.

iMy also lets you manage and terminate runaway processes simply and easily.

iMy is $5.99 USD and is available from the iTunes store here:
http://itunes.apple.com/us/app/imy/id290798289?mt=8

More information on iMy can be found here:
http://www.spanware.com/iphonedb/iMy/iMy.html

Embedded server in MySQL 5.5.4-m3 select failing on information_schema.tables? (no replies)

Rob Clevenger — Tue, 13 Jul 2010 23:16:54 +0000

I'm trying this embedded program to do a select against INFORMATION_SCHEMA.TABLES. It fails on next_field and next_mysql_field never being initialized and pointing to garbage.

It looks like this change may have added the code that's not working right: http://lists.mysql.com/commits/85677

I'm not sure what to initialize those fields to for the binary protocol, the text protocol sublcass looks right. Any help would be appreciated.

Thanks!

Rob

Here's a sample app demonstrating the problem on ubunty lucid.
#include
#include
#include
#include

static char *server_args[] = {
"this_program", /* this string is not used */
"--datadir=.",
"--key_buffer_size=32M"
};

#define CHECK(x) { if (!(x)) { std::cerr << #x << std::endl; exit(1); }}
#define CHECK_STMT(stmt, x) { if (!(x)) { std::cerr << #x << " " << \
mysql_stmt_error(stmt) << std::endl; exit(1); } else { std::cout << "after " \
<< #x << std::endl; } }

int main(void) {
printf("Hello World\n\n");
if (mysql_library_init(sizeof(server_args) / sizeof(char *),
server_args, NULL)) {
std::cerr << "Could not initialize MySQL library!";
return 1;
}

MYSQL* mysql = mysql_init(NULL);
if (!mysql_real_connect(mysql, NULL, NULL, NULL, NULL, 0, NULL, 0)) {
std::cerr << "mysql_real_connect";
return 1;
}

MYSQL_STMT* stmt = mysql_stmt_init(mysql);
CHECK(stmt != NULL);
std::string sql = "select * from information_schema.tables";
CHECK_STMT(stmt, mysql_stmt_prepare(stmt, sql.c_str(), sql.size()) == 0);
CHECK_STMT(stmt, mysql_stmt_execute(stmt)==0);

std::cout << "after mysql_stmt_execute" << std::endl;

mysql_close(mysql);
mysql_library_end();
return 0;
}

MySQL Embedded GUI? (no replies)

Ioannis Anifantakis — Tue, 06 Jul 2010 08:48:47 +0000

Is it possible through MySQL Administrator or Workbench5.2 (or some other tool) to open/query/alter an embedded database?

And if yes how!?

MySQL Embedded install Upgrades (no replies)

Ioannis Anifantakis — Tue, 06 Jul 2010 08:40:07 +0000

MySQL Embedded is ofcourse included in a single file called "libmysqld.dll".
However two folders must exist.
"data" and "shared"

When some user first runs the application, 3 files are automatically created inside the "data" subfolder.

ib_logfile0
ib_logfile1
ibdata1

Now the question is the following:

If I simply overwrite the "libmysqld.dll" file of the new embedded server version, do I have replaced the mysql embedded server version or need I do something more?

I have embedded version 5.1.41 and I change it to 5.1.48 by simply replacing THIS AND ONLY THIS FILE? If I replace the other 3 ofcourse the schema gets corrupted. If I don't replace the other 3 files everything runs smoothly and version is updated. But is it updated? or is it just me?

'Access violation reading' when changing db (no replies)

Crabby nolastname — Thu, 24 Jun 2010 23:37:59 +0000

Hi,

I have an "access violation reading" error when i try to change database.
The default code works fine, I can change tables, fields but when i change db it spits out
"..0xC0000005: Access violation reading location 0x0000000c."

. I tried copying database "mysql" to "myssql" just to check things out.., but still couldn't select from it (myssql) ..




#include "stdafx.h"





#include 


#include 


#include 


#include 


#include 


#include 





	MYSQL *mysql;


	MYSQL_RES *results;


	MYSQL_ROW record;





	static char *server_options[] = { "mysql-test", "--datadir=D:/softdev/testprojects/002_themysqlserv/data",


	"--language=C:/Server/MySQL/share/english",  NULL };


	


	int num_elements = sizeof(server_options)/ sizeof(char *) - 1;


		


	static char *server_groups[] = { "libmysqld_server", NULL };





int main(int argc, char* argv[])


 {	 int retval;


     retval = mysql_library_init(num_elements, server_options, (char **) server_groups);


     mysql = mysql_init(NULL);


     mysql_options(mysql, MYSQL_OPT_USE_EMBEDDED_CONNECTION, NULL);


     mysql_real_connect(mysql, NULL, "root", NULL, "mysql", 0, NULL, 0);


//   mysql_real_connect(mysql, NULL, "root", NULL, "myssql", 0, NULL, 0);


     mysql_query(mysql, "SELECT name FROM help_topic");


     results = mysql_store_result(mysql);


	


/*error*/    while((record = mysql_fetch_row(results))) {


                  printf("%s – %s \n", record[0], record[1]);


               }





     mysql_free_result(results);


     mysql_close(mysql);


     system("PAUSE");


     return 0;


}

I followed this guide http://lstigile.wordpress.com/2009/05/19/using-libmysqld-with-microsoft-visual-c-2008-express/

Im using VS2010..

I'm probably missing something.. Point me in the right direction :)

Thanks!

Setting lower_case_table_names in C++ embedded MySQL (no replies)

Dan Stuart — Wed, 16 Jun 2010 20:02:11 +0000

Hi everyone,

I am currently writing a C++ application with the embedded API that reads and executes SQL statements out of a .sql file after some processing. I'm working on Linux, but the SQL scripts are written by an appliciation originally developed for Windows, and as a result the table names in the file are case-inconsistent. I know that the usual solution is to set lower_case_table_names=1, but I don't know how to go about this with the embedded server.

I'm having the embedded server read options out of the /etc/my.cnf config file, where I've got "lower_case_table_names=1" under both the [mysqld] and [mysql] groups, but this isn't working, and I can't pass the server command-line arguments either since it's being started inside an executable. Is there some option in one of the initialization functions that takes command-line-like arguments?

Passing "SET lower_case_table_names=1" also doesn't work.

I know that the real solution to this is to lowercase the entire script, but unfortunately it includes some filenames that also need to be in the correct case. How do I do this?

Thanks!

'System.Byte' to type 'System.Char[]'. (no replies)

Michael Peterson — Fri, 04 Jun 2010 14:24:23 +0000

I am experiencing some issues moving data from SQL 2008 to MySQL 5.0.77 using SSIS 2008. The error I receive is

"Error: 0xC020844B at Data Flow Task, ADO NET Destination [1566]: An exception has occurred during data insertion, the message returned from the provider is: Unable to cast object of type 'System.Byte' to type 'System.Char[]'."

I do not have any 'BYTE' data types in my source, nor BIT types that are stored in together in a byte. I do not know why it is trying to convert from BYTE to CHAR. I am using an ADO.NET destinition using the 5.1 ODBC driver. My Source has some MSSQL data types like REAL and MONEY. I've used DECIMAL(19,4) and DOUBLE in MySQL destination.

Has anyone come across this error before and have any suggestions as to where I should look for a solution?

mysql command with embedded server? (no replies)

Kevin Regan — Mon, 24 May 2010 18:52:36 +0000

I've been playing around a bit with the embedded server. I've created a small C/C++ application that starts up and does simply database access.

However, what I would really like is a mysql command that is a self-contained database. Has anyone done something like this? For example, I'd like to be able to do the following:

$ mysql [options] < my_tables.sql

and have it work as a standalone command, without the MySQL database running.

MYSQL Access Violation Writing Error (no replies)

shahzaib khan — Mon, 24 May 2010 11:23:42 +0000

I am in very difficult situation while connecting with MYSQL dabatase , Trying to find some solution but can't get around . hopefully some has some idea to tell me what is going on and how to correct it.

I am using VC++ IDE , My Main program creats Two Threads . each thread performs a function and write the result in the database,

I have written class which interacts with MYSQL database , so i create two objects of mydatabase class and give it to each thread to access the database...

The Problem is after some time ( 3 - 5 minutes) its end up with an Error saying
---- Access Violation Writing Error. -----
and there is no futher message which can help me to find out what the problem is ...
I started to investigate and find out the problem could possibly be in the MYSQL *conn ...

currently class is like this

class myslq{
private :
MYSQL *conn

public :
void initMyDatabase();
void insertRecord (char *)
}

so in the function is initialize the conn and make connection .and keep the connection open until the program terminates ( Main Program is in infinite loop so not suppose to be ending )

what i did is changed the MYSQL *conn from being Global to Local so now i initiates the MYSQL conn structure inside the insertRecord function and close it before leaving the function. ... now doing this does stop the error message of "Access Violation Error" but starting to have different issue that most of the connection going on TIME_WAIT state and some of them shown ESTABLISHED . and after two days of running the program continuously MYSQL server said TOO MANY CONNECTIONS. and i simply can't access the database until i kill some connections.
Does any one has any idea what could possible be wrong in this situation. reply will deeply be appreciated.

How to move data files from embedded to standalone server (no replies)

aaaaaa aaaaaa — Tue, 13 Apr 2010 11:52:59 +0000

Hello.
I'm using an application that I think is using embedded Mysql (it uses the libmysql.dll file) and I would like to copy/move the data files to a mysql standalone server. This would allow me add and run some important queries that doesn't exist at the moment.

The data files are stored in a folder called Data inside the application folder.
THe data files are:

\data\ACTICS.CDX
\data\actics.dat
\data\actics.fpt
\data\ddv1.cdx
\data\ddv1.dat

Is there any to attach these files or a copy of these files to my standalone mysql server?

Thanks for your help and attention.
Jorge C.