Re: Sharing database files between EMBEDDED MYSQL and MySQL Server

2004-10-22 Thread Egor Egorov 
Valdir Henrique Dias Leite [EMAIL PROTECTED] wrote:

 I have an application that uses mysql embedded (performance 
 issues ...).
 
 The app itself works fine, but data adminsitration (issuing 
 DDL, DML statements ) is very complicated using C API... 
 
 So, I created an entry in my.cnf pointing to directory where 
 database used by embedded is, aiming to use mysql interface 
 to perform queries, updates, et cetera.
 
 The problem is: Every changes I make using mysql interface, 
 don=B4t reflect inside embedded scope (for example, inserts 
 made by mysql don=B4t exists in queries run by embedded 
 application).
 
 My questions are: Is it possible to have a situation like 
 mine ? There is an isolation between two aplications 
 (mysqld and mysqlembedded) ? May I mix scenarios as I 
 wonder ? What is wrong ?

Read manual on flush tables and lock tables: 
http://dev.mysql.com/doc/mysql/en/LOCK_TABLES.html
http://dev.mysql.com/doc/mysql/en/FLUSH.html





-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Sharing database files between EMBEDDED MYSQL and MySQL Server

2004-10-20 Thread Valdir Henrique Dias Leite 
Hello all,

I have an application that uses mysql embedded (performance
issues ...).

The app itself works fine, but data adminsitration (issuing
DDL, DML statements ) is very complicated using C API...

So, I created an entry in my.cnf pointing to directory where
database used by embedded is, aiming to use mysql interface
to perform queries, updates, et cetera.

The problem is: Every changes I make using mysql interface,
don´t reflect inside embedded scope (for example, inserts
made by mysql don´t exists in queries run by embedded
application).

My questions are: Is it possible to have a situation like
mine ? There is an isolation between two aplications
(mysqld and mysqlembedded) ? May I mix scenarios as I
wonder ? What is wrong ?

Thanks in advance,

Valdir Leite
São Paulo
Brazil

 
__
Acabe com aquelas janelinhas que pulam na sua tela.
AntiPop-up UOL - É grátis!
http://antipopup.uol.com.br/



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]