Embedded MySQL Manager
Hi all, I am wondering if anyone can recommend an application that will allow me to manage an Embedded MySQL database similar to the operation of Navicat or EMS SQL Manager on a normal MySQL server instance? Thanks in advance Martin -- -- [EMAIL PROTECTED] -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Embedded MySQL
Hi All, Can some kind soul tell me from where I can download the Embedded Library version of MySQL? -- TIA, Asif -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Embedded MySQL
On Friday 23 June 2006 06:18 am, Asif Lodhi wrote: Hi All, Can some kind soul tell me from where I can download the Embedded Library version of MySQL? I don't see a binary version avaliable, but I know the following configure option exists: --with-embedded-server Build the embedded server (libmysqld). -- I'm assuming this is what you want -- TIA, Asif -- Chris White PHP Programmer/DB Jaguar Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Embedded MySQL
Hi, I haven't tried this one, but I think this might help http://mysql-je.sourceforge.net Asif Lodhi [EMAIL PROTECTED] wrote: Hi All, Can some kind soul tell me from where I can download the Embedded Library version of MySQL? -- TIA, Asif -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Re: Embedded MySQL
I am sorry, this in case if your programming in java. Melvin Zamora [EMAIL PROTECTED] wrote: Hi, I haven't tried this one, but I think this might help http://mysql-je.sourceforge.net Asif Lodhi wrote: Hi All, Can some kind soul tell me from where I can download the Embedded Library version of MySQL? -- TIA, Asif -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com - Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail Beta.
Re: Embedded MySQL
Hi Chris and Melvin, Thanks a lot for the quick responses. I have found it. Actually, it comes bundled with the main distribution. The documentation is in the main reference manual and the header can be found in the include directory. -- Thanks again. Asif I don't see a binary version avaliable, but I know the following configure option exists: --with-embedded-server Build the embedded server (libmysqld). -- I'm assuming this is what you want .. I haven't tried this one, but I think this might help http://mysql-je.sourceforge.net Can some kind soul tell me from where I can download the Embedded Library version of MySQL? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Embedded MySQL for Symbian ?
Hi, I am new to this group...Just wanted to findout whether Embedded MySQL library is available for Symbian ( Series 60 platform).Any effort going on in this direction..? Any idea about the rough memory footprint.. With Regards Ajit.S __ Discover Yahoo! Use Yahoo! to plan a weekend, have fun online and more. Check it out! http://discover.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Embedded MySQL for Symbian ?
that looks like a good idea, and im hoping it will be much faster. but, how can it ran on a symbian platform? On 6/15/05, AJIT SADASIVAN [EMAIL PROTECTED] wrote: Hi, I am new to this group...Just wanted to findout whether Embedded MySQL library is available for Symbian ( Series 60 platform).Any effort going on in this direction..? Any idea about the rough memory footprint.. With Regards Ajit.S __ Discover Yahoo! Use Yahoo! to plan a weekend, have fun online and more. Check it out! http://discover.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Louie Miranda http://www.axishift.com -- under development
Re: Embedded MySQL for Symbian ?
I mean, much faster to other db that are currently on the symbian platform. On 6/15/05, Louie Miranda [EMAIL PROTECTED] wrote: that looks like a good idea, and im hoping it will be much faster. but, how can it ran on a symbian platform? On 6/15/05, AJIT SADASIVAN [EMAIL PROTECTED] wrote: Hi, I am new to this group...Just wanted to findout whether Embedded MySQL library is available for Symbian ( Series 60 platform).Any effort going on in this direction..? Any idea about the rough memory footprint.. With Regards Ajit.S __ Discover Yahoo! Use Yahoo! to plan a weekend, have fun online and more. Check it out! http://discover.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Louie Miranda http://www.axishift.com -- under development -- Louie Miranda http://www.axishift.com -- under development
Embedded mysql for simple user programs
I cannot see in mysql online manual Embedded example (http://dev.mysql.com/doc/mysql/en/libmysqld_example.html) any pathname telling where de database will be saved in disk. So I suppose it must be some existing database especified on some configuration file. Could be embebbed mysql be a replacement to sqlite for programs that just want to create some database in some specified file with no configuration if possible? I was thinking of embebbed mysql as a way for user unprivileged desktop programs creating databases at user's home. The apps I was thinking of were personal databases, addressbooks and so. For being embebbed and created on a personal file or dir they would be easy to create, update and remove. Besides, for using mysql backend it would be powerful (lot of features as foreing indexes and constraints and complex sql commands) and I suppose easy to export data for latter use in other mysql databases and so if neccesary. So I could thank any opinion on this to help me know if embedded mysql could fit my needs or I would better use a simpler solution as sqlite. The things I would try to avoid: - An unprivileged desktop user needing to edit system config. - Needing to edit config files. Better to set up everything inside the application. - Being able to create, edit and remove database from application. No need for extra config. thanks, txemi. -- __ hola, soy una firma horrible -- \ ^__^ \ (oo)\___ (__)\ )\/\ ||w | || || email: [EMAIL PROTECTED] web: http://txemi.webhop.org web2: http://txemi2.webhop.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Embedded mysql for simple user programs
At 09:14 AM 11/4/2004, you wrote: I cannot see in mysql online manual Embedded example (http://dev.mysql.com/doc/mysql/en/libmysqld_example.html) any pathname telling where de database will be saved in disk. So I suppose it must be some existing database especified on some configuration file. Could be embebbed mysql be a replacement to sqlite for programs that just want to create some database in some specified file with no configuration if possible? I was thinking of embebbed mysql as a way for user unprivileged desktop programs creating databases at user's home. The apps I was thinking of were personal databases, addressbooks and so. For being embebbed and created on a personal file or dir they would be easy to create, update and remove. Besides, for using mysql backend it would be powerful (lot of features as foreing indexes and constraints and complex sql commands) and I suppose easy to export data for latter use in other mysql databases and so if neccesary. So I could thank any opinion on this to help me know if embedded mysql could fit my needs or I would better use a simpler solution as sqlite. The things I would try to avoid: - An unprivileged desktop user needing to edit system config. - Needing to edit config files. Better to set up everything inside the application. - Being able to create, edit and remove database from application. No need for extra config. thanks, txemi. To use the libmysqld.dll you need to create a section in the my.ini or my.cnf file that looks like: [MyEmbeddedProgram.exe] basedir=U:\MySQL datadir=U:\MySQL_Data tmpdir=f:\mysql_tmp where MyEmbeddedProgram.exe is the name of your program. But this could be expensive. If you distribute your application to others, whether for profit or for free, you will need a license for each copy (about $500). If all you're doing is creating address books or other tables with a few hundred rows in it, then MySQL is overkill. There are plenty of other databases out there that have a zero footprint and no install is necessary. I can suggest some for Windows that work great. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Embedded mysql for simple user programs
Hi. You may tell MySQL where the data files are stored in the argc, when you are calling mysql_server_init. Also you may put other server variables into this array. I think, MySQL can do most tasks, which you are looking for. See: http://dev.mysql.com/doc/mysql/en/Server_system_variables.html txemi [EMAIL PROTECTED] wrote: I cannot see in mysql online manual Embedded example (http://dev.mysql.com/doc/mysql/en/libmysqld_example.html) any pathname telling where de database will be saved in disk. So I suppose it must be some existing database especified on some configuration file. Could be embebbed mysql be a replacement to sqlite for programs that just want to create some database in some specified file with no configuration if possible? I was thinking of embebbed mysql as a way for user unprivileged desktop programs creating databases at user's home. The apps I was thinking of were personal databases, addressbooks and so. For being embebbed and created on a personal file or dir they would be easy to create, update and remove. Besides, for using mysql backend it would be powerful (lot of features as foreing indexes and constraints and complex sql commands) and I suppose easy to export data for latter use in other mysql databases and so if neccesary. So I could thank any opinion on this to help me know if embedded mysql could fit my needs or I would better use a simpler solution as sqlite. The things I would try to avoid: - An unprivileged desktop user needing to edit system config. - Needing to edit config files. Better to set up everything inside the application. - Being able to create, edit and remove database from application. No need for extra config. thanks, txemi. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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]
Re: Embedded mysql for simple user programs
Aha, what solution would you recommend? I would like some open and free product working in linux and win, easy to interact with other products and some relation among tables capabilitie (foreign index, constraint...). I focused on sqlite because It seem to match this requirements and it is already available on most linux distros. I did not know you had to pay for mysql, I thought they made money from services. El jue, 04-11-2004 a las 09:43 -0600, mos escribió: At 09:14 AM 11/4/2004, you wrote: I cannot see in mysql online manual Embedded example (http://dev.mysql.com/doc/mysql/en/libmysqld_example.html) any pathname telling where de database will be saved in disk. So I suppose it must be some existing database especified on some configuration file. Could be embebbed mysql be a replacement to sqlite for programs that just want to create some database in some specified file with no configuration if possible? I was thinking of embebbed mysql as a way for user unprivileged desktop programs creating databases at user's home. The apps I was thinking of were personal databases, addressbooks and so. For being embebbed and created on a personal file or dir they would be easy to create, update and remove. Besides, for using mysql backend it would be powerful (lot of features as foreing indexes and constraints and complex sql commands) and I suppose easy to export data for latter use in other mysql databases and so if neccesary. So I could thank any opinion on this to help me know if embedded mysql could fit my needs or I would better use a simpler solution as sqlite. The things I would try to avoid: - An unprivileged desktop user needing to edit system config. - Needing to edit config files. Better to set up everything inside the application. - Being able to create, edit and remove database from application. No need for extra config. thanks, txemi. To use the libmysqld.dll you need to create a section in the my.ini or my.cnf file that looks like: [MyEmbeddedProgram.exe] basedir=U:\MySQL datadir=U:\MySQL_Data tmpdir=f:\mysql_tmp where MyEmbeddedProgram.exe is the name of your program. But this could be expensive. If you distribute your application to others, whether for profit or for free, you will need a license for each copy (about $500). If all you're doing is creating address books or other tables with a few hundred rows in it, then MySQL is overkill. There are plenty of other databases out there that have a zero footprint and no install is necessary. I can suggest some for Windows that work great. Mike -- __ hola, soy una firma horrible -- \ ^__^ \ (oo)\___ (__)\ )\/\ ||w | || || email: [EMAIL PROTECTED] web: http://txemi.webhop.org web2: http://txemi2.webhop.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Embedded mysql for simple user programs
Thanks, I did have a look at it and it seems that I could use embedded mysql with no conffiles at all. :-) I like it becouse I would prefer application configuring mysql based on its own config or status and not having spread conffiles for each used library. Besides, various applications using this library and editing some mysql conffile at user home (/home/user/.my.cnf) could finish in a mess. El jue, 04-11-2004 a las 17:51 +0200, Gleb Paharenko escribió: Hi. You may tell MySQL where the data files are stored in the argc, when you are calling mysql_server_init. Also you may put other server variables into this array. I think, MySQL can do most tasks, which you are looking for. See: http://dev.mysql.com/doc/mysql/en/Server_system_variables.html txemi [EMAIL PROTECTED] wrote: I cannot see in mysql online manual Embedded example (http://dev.mysql.com/doc/mysql/en/libmysqld_example.html) any pathname telling where de database will be saved in disk. So I suppose it must be some existing database especified on some configuration file. Could be embebbed mysql be a replacement to sqlite for programs that just want to create some database in some specified file with no configuration if possible? I was thinking of embebbed mysql as a way for user unprivileged desktop programs creating databases at user's home. The apps I was thinking of were personal databases, addressbooks and so. For being embebbed and created on a personal file or dir they would be easy to create, update and remove. Besides, for using mysql backend it would be powerful (lot of features as foreing indexes and constraints and complex sql commands) and I suppose easy to export data for latter use in other mysql databases and so if neccesary. So I could thank any opinion on this to help me know if embedded mysql could fit my needs or I would better use a simpler solution as sqlite. The things I would try to avoid: - An unprivileged desktop user needing to edit system config. - Needing to edit config files. Better to set up everything inside the application. - Being able to create, edit and remove database from application. No need for extra config. thanks, txemi. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- __ hola, soy una firma horrible -- \ ^__^ \ (oo)\___ (__)\ )\/\ ||w | || || email: [EMAIL PROTECTED] web: http://txemi.webhop.org web2: http://txemi2.webhop.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Sharing database files between EMBEDDED MYSQL and MySQL Server
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
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]
Can a database be shared between different processes linked with the Embedded MySQL library?
Hello All, Is it possible to share a database between two processes when using libmysql, the embedded version of MySQL? My application will have one writer process and many reader processes and I would like to share a single embedded database between all the processes. Is that possible using libmysql?
Linking Embedded MySQL on Mac OS X
I am having the same problem that someone else posted about back in December and I didn't see any responses for: http://lists.mysql.com/mysql/156346 Specifically, I am trying to link with libmysqld.a on Mac OS X and am getting 16 undefined link errors such as fixsfdi, floatdisf, udivdi3, moddi3, etc. I have inferred from various google searches that most of these are linked in with a library called libkern on other *nix systems. However, the libkern.h on Mac doesn't list these particular methods and I don't know which library I should include. Regardless of whether you use CodeWarrior, XCode, gcc, or whatever, can anyone point me in the right direction? Thanks, Eric --- Eric Sword Group Logic, Inc. [EMAIL PROTECTED] 800.476.8781 (800.GROUP81) http://www.grouplogic.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Cant compile embedded mysql server in Windows
Hello, I want to use embedded MySQL server library. I downloaded the latest MySQL 4.1.1 source and unzipped. I opened up mysql.dsw and set libmysqld as active project. Using Build-Rebuild All.. I started compiling it. After all the related projects were compiled I am getting the following error while linking: Linking... libmysqld.def : error LNK2001: unresolved external symbol max_allowed_packet libmysqld.def : error LNK2001: unresolved external symbol myodbc_remove_escape libmysqld.def : error LNK2001: unresolved external symbol mysql_affected_rows libmysqld.def : error LNK2001: unresolved external symbol mysql_autocommit libmysqld.def : error LNK2001: unresolved external symbol mysql_change_user libmysqld.def : error LNK2001: unresolved external symbol mysql_character_set_name libmysqld.def : error LNK2001: unresolved external symbol mysql_close libmysqld.def : error LNK2001: unresolved external symbol mysql_commit libmysqld.def : error LNK2001: unresolved external symbol mysql_data_seek libmysqld.def : error LNK2001: unresolved external symbol mysql_debug libmysqld.def : error LNK2001: unresolved external symbol mysql_dump_debug_info libmysqld.def : error LNK2001: unresolved external symbol mysql_eof libmysqld.def : error LNK2001: unresolved external symbol mysql_errno libmysqld.def : error LNK2001: unresolved external symbol mysql_error libmysqld.def : error LNK2001: unresolved external symbol mysql_escape_string libmysqld.def : error LNK2001: unresolved external symbol mysql_fetch_field libmysqld.def : error LNK2001: unresolved external symbol mysql_fetch_field_direct libmysqld.def : error LNK2001: unresolved external symbol mysql_fetch_fields libmysqld.def : error LNK2001: unresolved external symbol mysql_fetch_lengths libmysqld.def : error LNK2001: unresolved external symbol mysql_fetch_row libmysqld.def : error LNK2001: unresolved external symbol mysql_field_count libmysqld.def : error LNK2001: unresolved external symbol mysql_field_seek libmysqld.def : error LNK2001: unresolved external symbol mysql_field_tell libmysqld.def : error LNK2001: unresolved external symbol mysql_free_result libmysqld.def : error LNK2001: unresolved external symbol mysql_get_client_info libmysqld.def : error LNK2001: unresolved external symbol mysql_get_host_info libmysqld.def : error LNK2001: unresolved external symbol mysql_get_proto_info libmysqld.def : error LNK2001: unresolved external symbol mysql_get_server_info libmysqld.def : error LNK2001: unresolved external symbol mysql_get_server_version libmysqld.def : error LNK2001: unresolved external symbol mysql_info libmysqld.def : error LNK2001: unresolved external symbol mysql_init libmysqld.def : error LNK2001: unresolved external symbol mysql_insert_id libmysqld.def : error LNK2001: unresolved external symbol mysql_kill libmysqld.def : error LNK2001: unresolved external symbol mysql_list_dbs libmysqld.def : error LNK2001: unresolved external symbol mysql_list_fields libmysqld.def : error LNK2001: unresolved external symbol mysql_list_processes libmysqld.def : error LNK2001: unresolved external symbol mysql_list_tables libmysqld.def : error LNK2001: unresolved external symbol mysql_more_results libmysqld.def : error LNK2001: unresolved external symbol mysql_next_result libmysqld.def : error LNK2001: unresolved external symbol mysql_num_fields libmysqld.def : error LNK2001: unresolved external symbol mysql_num_rows libmysqld.def : error LNK2001: unresolved external symbol mysql_odbc_escape_string libmysqld.def : error LNK2001: unresolved external symbol mysql_options libmysqld.def : error LNK2001: unresolved external symbol mysql_ping libmysqld.def : error LNK2001: unresolved external symbol mysql_query libmysqld.def : error LNK2001: unresolved external symbol mysql_read_query_result libmysqld.def : error LNK2001: unresolved external symbol mysql_real_escape_string libmysqld.def : error LNK2001: unresolved external symbol mysql_real_query libmysqld.def : error LNK2001: unresolved external symbol mysql_refresh libmysqld.def : error LNK2001: unresolved external symbol mysql_rollback libmysqld.def : error LNK2001: unresolved external symbol mysql_row_seek libmysqld.def : error LNK2001: unresolved external symbol mysql_row_tell libmysqld.def : error LNK2001: unresolved external symbol mysql_select_db libmysqld.def : error LNK2001: unresolved external symbol mysql_send_query libmysqld.def : error LNK2001: unresolved external symbol mysql_server_end libmysqld.def : error LNK2001: unresolved external symbol mysql_server_init libmysqld.def : error LNK2001: unresolved external symbol mysql_shutdown libmysqld.def : error LNK2001: unresolved external symbol mysql_sqlstate libmysqld.def : error LNK2001: unresolved external symbol mysql_ssl_set libmysqld.def : error LNK2001: unresolved external symbol mysql_stat libmysqld.def : error LNK2001: unresolved external symbol mysql_store_result libmysqld.def : error LNK2001: unresolved external symbol mysql_thread_id libmysqld.def
Re: Cant compile embedded mysql server in Windows
Karam Chand wrote: Hello, I want to use embedded MySQL server library. I downloaded the latest MySQL 4.1.1 source and unzipped. I opened up mysql.dsw and set libmysqld as active project. Using Build-Rebuild All.. I started compiling it. After all the related projects were compiled I am getting the following error while linking: Linking... ---8 You can download the .zip (precompiled) file from mysql.com and save a lot of time. Best Regards! -- |...| | _ _|Victor Medina M | |\ \ \| | _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_|_| /_/ \_\|Tel: +58-241-8507325 - ext. 325 | ||Cel: +58-412-8859934 | ||geek by nature - linux by choice | |...| -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cant compile embedded mysql server in Windows
Hello, I want a debuggable compiled library. Is Deug version of embedded server available. Karam --- Victor Medina [EMAIL PROTECTED] wrote: Karam Chand wrote: Hello, I want to use embedded MySQL server library. I downloaded the latest MySQL 4.1.1 source and unzipped. I opened up mysql.dsw and set libmysqld as active project. Using Build-Rebuild All.. I started compiling it. After all the related projects were compiled I am getting the following error while linking: Linking... ---8 You can download the .zip (precompiled) file from mysql.com and save a lot of time. Best Regards! -- |...| | _ _|Victor Medina M | |\ \ \| | _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_|_| /_/ \_\|Tel: +58-241-8507325 - ext. 325 | ||Cel: +58-412-8859934 | ||geek by nature - linux by choice | |...| -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Embedded mySQL
Hello, For embedded mySQL server there is a restriction that You cannot set this up as a master or a slave (no replication). To support replication using embedded mySQL is there any steps that I can follow (e.g., by modifying portion of the source code etc.)? Pls. advise Regds, Rajarshi Chaudhuri
embedded MySQL on arm
hi, I'm working on a project with an arm-CPU in an embedded system, so there are a few hardware limits like slow CPU, little RAM and very little ROM (Flash). I hope to get a MMC-Interface running to use for data storage. I'm very free to chose a db and version and don't need much features. Now ist the question whether mysql is the right choice and which version I should try. Any link or hint about mysql on arm (Crosscompiling), performance ... would be helpful. Thanks, Rapha -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Embedded MySQL example with g++?
Is there any example of makefile for g++ that links libmysqld? So far I can link libmysqld only with gcc-based programs, but g++ gives lots of unresolved symbols (like __pure_virtual etc.). thanks, Mirza Hadzic -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Prepared statements in embedded MySQL
I was wonder if anyone here could comment on when prepared statements might be available in the embedded server, I would find it very helpful. Will they be in the 4.1 release? Are there plans to add support in some future release? Thanks, Richard Tibbetts -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Embedded MySql with Borland BCC32
Hi experts, I need to create a static library for an embedded application with a 4-Byte alignment with BCC32 version 5.0. I prefer using the command line version. Using the files from the current distribution .\mysql\libmysqld results in early compile errors already in config-win.h, line 93, obviously with a mis-interpretation of __int64. Is there any experience about this, possibly a makefile available for that purpose or is another Borland-Compiler option or version more suitable? Kind regards in advance. Dieter W. Kuske I.C.S. Industrielle Automatisierungssysteme GmbH IT SOLUTIONS FOR INDUSTRIAL PRODUCTION ENVIRONMENTS SIGNATURE We are located at: N 52°19'22.3 E010°40'20.8 You may reach us by Phone: +49-5308-961000 Fax : +49-5308-961001 Mobile.: +49-171-81 81 007 UMS :+49-1212-66-81 81 007 Office hours from 09:00 AM through 11:00 PM UTC mailto:[EMAIL PROTECTED] For confidential messages use PGP. Get my PGP-Pub-Key from our homepage http://www.ics-consult.de ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. ** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[ANN] Blue World Lasso Professional 7 to include embedded MySQL
MySQL Colleagues: If you're interested in a new commercial-grade Web application server product which includes a commercial license of MySQL 4 embedded, please read on. We're excited to provide a version of Lasso with MySQL 4 built-in. This yields superior performance and provides tighter security and easier installation and maintenance. Thanks in advance for your interest. Enjoy! Bill - FOR IMMEDIATE RELEASE September 9, 2003 BLUE WORLD ANNOUNCES LASSO PROFESSIONAL 7 Support for embedded MySQL, Unicode, SOAP, image manipulation, data caching, and more to position Lasso Professional 7 as a leading Web application server. Bellevue, WA--September 9, 2003--Blue World Communications, Inc.--pioneers of the Web Data Engine(tm)--today announced Lasso Professional 7, a significant upgrade to its award-winning Web application server product for building and serving data-driven Web sites. Lasso Professional 7 introduces support for various industry standards while maintaining the ease-of-use and robust security that have won Lasso the support of thousands of Web developers worldwide. Lasso Professional 7 provides Web application developers a tool specifically designed to meet their most demanding needs without compromising ease-of-use, offering unprecedented productivity and flexibility, said Bill Doerrfeld, CEO of Blue World. Compliance with the latest industry standards positions Lasso Professional 7 at the forefront within the rapidly evolving Web application server tool arena. Lasso Professional 7 New Features Lasso Professional 7 (LP7) provides all of the features expected in an advanced Web application server, including the following new features: Embedded MySQL 4 Database Server - Includes a full commercial license of the MySQL database server embedded into the Lasso Server application. The embedded Lasso MySQL database server provides numerous advantages to the Lasso MySQL database provided in LP6 including greater performance, support for transactions, tighter security, and easier installation and maintenance. Internationalization and Localization - LP7 is now Unicode compliant, supporting hundreds of languages and character sets. Numbers, dates, and currencies can now be represented in localized formats. Dramatically Enhanced Performance - New byte-code compiler, algorithms and architecture provide vastly improved performance. LP7 outperforms virtually all other middleware products, in many cases by wide margins. SOAP/WSDL/XML Support - Facilitates communication with Web services via XML-based standards for data exchange. Supports SOAP calls so Lasso can be a Web services host. New XML implementation provides dramatic performance increase for both large and small documents while operating within a smaller memory footprint. Image Manipulation - Get information about images, resize images on the fly, create thumbnails, create watermarked images, or convert images from one format to another automatically. Apache 2 Web Server Support - Supports Apache 2 on Mac OS X (in addition to Apache 1.x) and Red Hat Linux. Caching for Enhanced Performance - Performance when communicating with slower databases can be dramatically enhanced through easy-to-use caching tags. Allows data served from databases such as FileMaker Pro to be served at speeds rivaling data served from MySQL databases. Enhanced and Simplified PDF Tags - Existing PDFs are now editable. PDF tags have been streamlined and take advantage of new features provided in an updated iText library. Now its easy to add dynamic content to existing PDF-based templates. Enhanced Database Communication - Programmatically control data source connections and transaction support via enhanced inline functionality. Ensures appropriate submission of data via Commit and Rollback routines. Manipulate database results as an array of returned records. Enhanced File Manipulation - Simplifies file manipulation with files now treated as objects. Provides enhanced performance for repeated access to the same file. Enhanced Network Communications - Simplifies network communications with network elements now treated as objects. Provides TCP and UDP support, listeners, and persistent connections. SSL support allows secure communications. Multi-Server Support - Facilitates load balancing and clustering by allowing multiple LP7 servers to share session data. LassoApp Maintenance - Lists open LassoApps within Lasso Administration for easier maintenance. Lasso Administration Enhancements - Streamlined interface focuses on administration tasks (e.g. Setup, Utility, Support) and provides new sections for controlling LassoApps and caching control settings. Remote Installation Support - Facilitates remote installation via the command line on Mac OS X. Lasso Security Enhancements - Can now check authorization against specific usernames and groups or against a custom username
About Embedded MySQL server
I've installed the last stable MySQL version (4.0.14-standard) form the binary distribution. I'm interested on implementing the embedded server within my clients programs but the distribution do not have included the libmysqld.a library. There is a possible solution to this without having to get the source and compile it. Thanks Vladimir -- BSc. Vladimir Espinosa Angarica Researcher National Bioinformatics Center Ministry of Science Technology and the Environment Industria y San José, Habana Vieja Capitolio Nacional CUBA Fax: (53-7) 8609614 Tel: (53-7) 8604397 E-mail: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
About Embedded MySQL server
I've installed the last stable MySQL version (4.0.14-standard) under Linux, (Suse-8.0) kernel 2.4.28-64GB SMP, form the binary distribution that i downloaded from www.mysql.com. I'm interested on implementing the embedded server within my clients programs but the distribution do not have included the libmysqld.a library. There is a possible solution to this without having to get the source and compile it. Thanks Vladimir -- BSc. Vladimir Espinosa Angarica Researcher National Bioinformatics Center Ministry of Science Technology and the Environment Industria y San José, Habana Vieja Capitolio Nacional CUBA Fax: (53-7) 8609614 Tel: (53-7) 8604397 E-mail: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Embedded MySQL?
Hi. On Thu 2003-03-20 at 08:25:08 +0200, [EMAIL PROTECTED] wrote: Hi, I have a question I hope you can help me with. I try to develop a database in Borlands Delphi or with C++ and Visual Studio 6 (Windows 2000). Probably I choose Delphi. Now I want to use MySQL as a platform for my program. According to http://www.mysql.com/doc/en/libmysqld_overview.html I can run a standalone server in my program. Now I wonder how this works in practise? Ideally I want to call an API in a dll-file to create and maintain the database. http://www.mysql.com/doc/en/libmysqld.html should answer most of your concern. Basically it boils down to an additional call to mysql_server_init() and mysql_server_end() and compiling with libmysqld instead of libmysqlclient. The rest is the same with the client library. HTH, Benjamin. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Embedded MySQL?
Hi, I have a question I hope you can help me with. I try to develop a database in Borlands Delphi or with C++ and Visual Studio 6 (Windows 2000). Probably I choose Delphi. Now I want to use MySQL as a platform for my program. According to http://www.mysql.com/doc/en/libmysqld_overview.html I can run a standalone server in my program. Now I wonder how this works in practise? Ideally I want to call an API in a dll-file to create and maintain the database. /Roland --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.462 / Virus Database: 261 - Release Date: 2003-03-13 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
embedded mysql
Hi, we are developing an application in java that needs to have an embedded database so that we needn't install the database on the client machine. Is it possible to achieve this using mysql. I read that mysql 4.0 supports embedded database, but I find that embedded MySQL server library is only for C developers. please help thanks rai _ Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year. http://login.mail.lycos.com/brandPage.shtml?pageId=plusref=lmtplus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: embedded mysql
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 mahesh rai wrote: Hi, we are developing an application in java that needs to have an embedded database so that we needn't install the database on the client machine. Is it possible to achieve this using mysql. I read that mysql 4.0 supports embedded database, but I find that embedded MySQL server library is only for C developers. please help thanks rai It is not currently planned to support 'libmysqld' from Java via the JDBC driver, as it is not technically feasible at this point in time due to threading and data conversion issues. This doesn't mean that you can't 'embed' MySQL through Java, though. There are plenty of users who do this by controlling the regular 'mysqld' through Runtime.exec() calls. 'mysqld' has enough command-line options that make it fully configurable, and controllable using plain command-line calls through Runtime.exec(). Connector/J 3.1.x will ship with utility classes to help with this (they are already included in the nightly snapshots from http://mmmysql.sourceforge.net/snapshots/dev/) -Mark - -- MySQL 2003 Users Conference - http://www.mysql.com/events/uc2003/ For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.1.90 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+Yr8ktvXNTca6JD8RAhD9AJ9YTFw19RTXwZa2xnvku4RvpQj5hgCdHT/W /fZrYX1vcn8z/ONCkaU6qv0= =URTk -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Embedded MySQL server
Hi Can some one guide me on how to use the embedded MySQL server. I have gone through brief description in the MySQL manual but did not get much from it When we use Embedded server in an application ,do we need complete MySQL installation ??? any pointer will be appraciated thanks asif __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Embedded MySQL
Hi, Since libmysqld don't use sockets or TCP/IP, what's the mechanism it uses when client and server communicate with each other? Thanks for reply in advance. Regards. -- ___ Get your free email from http://mymail.mailasia.com Powered by Outblaze - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Embedded MySQL Server
Hi, Since libmysqld does not use sockets or TCP/IP, what's the mechanism it uses when the client and server communicate with each other? I mean how embedded MySQL Server works as a server. Thanks for reply in advance. Regards. -- ___ Get your free email from http://mymail.mailasia.com Powered by Outblaze - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Bug report: Embedded MySQL version 4.05a
Hi Paul! Thank you for the quick response. Indeed, we expect it to work otherwise. In our application, users are authenticated by the operating system, but we were hoping to use the built-in authorization of MySql instead of developing our own. Our strategy is to automatically add users to MySql as they are given to us by the OS and assign permissions to tables using these users. Does that seem reasonable? Thank you! Henry. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 9:09 PM To: Matt Solnit; Heikki Tuuri; [EMAIL PROTECTED] Cc: Henry Bequet Subject: Re: Bug report: Embedded MySQL version 4.05a At 15:39 -0800 12/10/02, Matt Solnit wrote: === Bug report -- MySQL v4.05a, binary distribution === -- Machine specs: -- Compaq Presario desktop Windows XP Professional SP1 .NET Framework SP2 Problem description: The security features of MySQL do not seem to work with Embedded MySQL. Instead, every user is given full permissions. Would you expect otherwise? If you have the embedded server linked into an application, it's expected that the application will have full control over the server and can do anything with any of its databases. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Bug report: Embedded MySQL version 4.05a
=== Bug report -- MySQL v4.05a, binary distribution === -- Machine specs: -- Compaq Presario desktop Windows XP Professional SP1 .NET Framework SP2 Problem description: The security features of MySQL do not seem to work with Embedded MySQL. Instead, every user is given full permissions. - Setup script: - USE mysql DELETE FROM user WHERE user=''; DELETE FROM user WHERE user='root' AND host!='localhost'; USE test CREATE TABLE mytable (a int); GRANT SELECT ON mytable TO joe@localhost; GRANT USAGE ON mytable TO jay@localhost; FLUSH PRIVILEGES; -- Observed behavior: -- Running the mysql.exe client, anonymous users cannot connect to the database, user 'joe' has read-only access to the table test.mytable, and user 'jay' as no privileges. Running the mysql-server.exe host, all users have full privileges. Additionally, the GRANT statement in mysql-server.exe returns error 1047 (Unknown command). --- Possible cause: --- The function acl_init() which loads the ACL's for each user on startup, includes a parameter, dont_read_acl_tables, that can be set to true to skip this step. The purpose of this parameter according to the comments is to support the --skip-grant command-line option. However, the mysql_server_init() function hard-codes this parameter value to 1, so the ACL's never get loaded and every access succeeds. --- My contact information: --- Matt Solnit [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Bug report: Embedded MySQL version 4.05a
At 15:39 -0800 12/10/02, Matt Solnit wrote: === Bug report -- MySQL v4.05a, binary distribution === -- Machine specs: -- Compaq Presario desktop Windows XP Professional SP1 .NET Framework SP2 Problem description: The security features of MySQL do not seem to work with Embedded MySQL. Instead, every user is given full permissions. Would you expect otherwise? If you have the embedded server linked into an application, it's expected that the application will have full control over the server and can do anything with any of its databases. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Bug report: Embedded MySQL v4.04b
=== Bug report -- MySQL v4.04b, source distribution === Machine specs (build machine and test machine are same machine): Compaq Presario desktop Windows XP Professional SP1 .NET Framework SP2 -- Build description: -- libmysqld.dll was built using Microsoft Visual C++ 6.0 SP5 and Microsoft Visual C++ Processor Pack SP5 (used for ASM files). We build our own version because we need to make a change so that the DLL will work with C# clients (see below for more info). Problem description: A C# client was built using Microsoft Visual Studio.NET. The client calls mysql_server_init(), passing in the command-line argument --datadir=path, then attempts to open a connection using mysql_init() and mysql_real_connect(). A database that is known to exist is passed in to the mysql_real_connect() function. The function call fails and mysql_error() returns Unknown database 'name'. Behavior is identical using debug and release builds of libmysqld.dll. The problem does not occur using a C++ client. --- Possible cause: --- Stepping into MySQL, I find that the variable mysql_data_home is set to the correct value when mysql_server_init() returns. However, when mysql_init() is entered, the value has become corrupted. C# code: /**/ /* you will need to customize the datadir and database name */ /**/ using System; using System.Security; using System.Runtime.InteropServices; namespace ConsoleApplication1 { class Test { [STAThread] static void Main(string[] args) { TestDirectToDLL(); } private static void TestDirectToDLL() { string[] args = new string[] {thisappname, --datadir=c:/iter/source/ADCData}; MySqlAPI.ServerInit(args.Length, args, null); IntPtr cnn = MySqlAPI.Init(IntPtr.Zero); IntPtr result = MySqlAPI.Connect(cnn, null, null, null, iteration, 0, null, 0); if (result == IntPtr.Zero) throw new Exception(MySqlAPI.Error(cnn)); MySqlAPI.Close(cnn); MySqlAPI.ServerEnd(); } } class MySqlAPI { [SuppressUnmanagedCodeSecurity] [DllImport(libmysqld.dll, CharSet=System.Runtime.InteropServices.CharSet.Ansi, EntryPoint=mysql_server_init, ExactSpelling=true)] public static extern int ServerInit(int icArgs, string [] strArgs, string [] strGroups); [DllImport(libmysqld.dll, EntryPoint=mysql_server_end, ExactSpelling=true)] public static extern void ServerEnd(); [SuppressUnmanagedCodeSecurity] [DllImport(libmysqld.dll, EntryPoint=mysql_init, ExactSpelling=true)] public static extern IntPtr Init(IntPtr ihConnection); [SuppressUnmanagedCodeSecurity] [DllImport(libmysqld.dll, CharSet=System.Runtime.InteropServices.CharSet.Ansi, EntryPoint=mysql_real_connect, ExactSpelling=true)] public static extern IntPtr Connect(IntPtr ihConnection, [In] string strHost, [In] string strUser, [In] string strPassword, [In] string strDatabaseName, uint iPort, [In] string strSocketName, uint iFlags ); [SuppressUnmanagedCodeSecurity] [DllImport(libmysqld.dll, EntryPoint=mysql_close, ExactSpelling=true)] public static extern void Close(IntPtr ihConnection); [DllImport(libmysqld.dll, EntryPoint=mysql_errno, ExactSpelling=true)] public static extern uint ErrNo(IntPtr ihConnection); [DllImport(libmysqld.dll, CharSet=System.Runtime.InteropServices.CharSet.Ansi, EntryPoint=mysql_error, ExactSpelling=true)] public static extern string Error(IntPtr ihConnection); } } - C++ code: - /**/ /* plug this into the file test_dll.cpp that ships with MySQL */ /**/ /**/ /* you will need to customize the datadir and database name */ /**/ int main(int argc, char* argv[]) { MYSQL *one; const char *simulatedArgs[] = {thisappname, --datadir=c:/iter/source/ADCData}; const int simulatedArgCount = 2; mysql_server_init(simulatedArgCount, (char**)simulatedArgs, NULL); one = db_connect(iteration); db_do_query(one, show tables); mysql_close(one); mysql_server_end(); return 0; } --- MySQL binaries: --- Upon request, I can supply our debug and release builds of libmysqld.dll. --- Source code change description: --- There is
Re: Bug report: Embedded MySQL v4.04b
Matt, thank you for the bug report. I do not have C# in my computer. Did I understand correctly the bug does not appear if you use the Embedded Server Library inside C++? My first note is that you should define USE_TLS in all MySQL modules, like Monty instructed a week ago. But I guess that cannot cause the corruption of mysql_data_home. I looked at the source code, and it looks like mysql_data_home should be a pointer to a 512-character buffer called mysql_real_data_home, if you define a datadir, and that is not the default dir (that is, .\) of the running program. Could it be that mysql_data_home starts to point into some random location? I am forwarding this bug report to MySQL developers who know the mysqld option processing best. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com sql query - Original Message - From: Matt Solnit [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: Henry Bequet [EMAIL PROTECTED] Sent: Wednesday, November 27, 2002 7:12 PM Subject: Bug report: Embedded MySQL v4.04b === Bug report -- MySQL v4.04b, source distribution === Machine specs (build machine and test machine are same machine): Compaq Presario desktop Windows XP Professional SP1 .NET Framework SP2 -- Build description: -- libmysqld.dll was built using Microsoft Visual C++ 6.0 SP5 and Microsoft Visual C++ Processor Pack SP5 (used for ASM files). We build our own version because we need to make a change so that the DLL will work with C# clients (see below for more info). Problem description: A C# client was built using Microsoft Visual Studio.NET. The client calls mysql_server_init(), passing in the command-line argument --datadir=path, then attempts to open a connection using mysql_init() and mysql_real_connect(). A database that is known to exist is passed in to the mysql_real_connect() function. The function call fails and mysql_error() returns Unknown database 'name'. Behavior is identical using debug and release builds of libmysqld.dll. The problem does not occur using a C++ client. --- Possible cause: --- Stepping into MySQL, I find that the variable mysql_data_home is set to the correct value when mysql_server_init() returns. However, when mysql_init() is entered, the value has become corrupted. C# code: /**/ /* you will need to customize the datadir and database name */ /**/ using System; using System.Security; using System.Runtime.InteropServices; namespace ConsoleApplication1 { class Test { [STAThread] static void Main(string[] args) { TestDirectToDLL(); } private static void TestDirectToDLL() { string[] args = new string[] {thisappname, --datadir=c:/iter/source/ADCData}; MySqlAPI.ServerInit(args.Length, args, null); IntPtr cnn = MySqlAPI.Init(IntPtr.Zero); IntPtr result = MySqlAPI.Connect(cnn, null, null, null, iteration, 0, null, 0); if (result == IntPtr.Zero) throw new Exception(MySqlAPI.Error(cnn)); MySqlAPI.Close(cnn); MySqlAPI.ServerEnd(); } } class MySqlAPI { [SuppressUnmanagedCodeSecurity] [DllImport(libmysqld.dll, CharSet=System.Runtime.InteropServices.CharSet.Ansi, EntryPoint=mysql_server_init, ExactSpelling=true)] public static extern int ServerInit(int icArgs, string [] strArgs, string [] strGroups); [DllImport(libmysqld.dll, EntryPoint=mysql_server_end, ExactSpelling=true)] public static extern void ServerEnd(); [SuppressUnmanagedCodeSecurity] [DllImport(libmysqld.dll, EntryPoint=mysql_init, ExactSpelling=true)] public static extern IntPtr Init(IntPtr ihConnection); [SuppressUnmanagedCodeSecurity] [DllImport(libmysqld.dll, CharSet=System.Runtime.InteropServices.CharSet.Ansi, EntryPoint=mysql_real_connect, ExactSpelling=true)] public static extern IntPtr Connect(IntPtr ihConnection, [In] string strHost, [In] string strUser, [In] string strPassword, [In] string strDatabaseName, uint iPort, [In] string strSocketName, uint iFlags ); [SuppressUnmanagedCodeSecurity] [DllImport(libmysqld.dll, EntryPoint=mysql_close, ExactSpelling=true)] public static extern void Close(IntPtr ihConnection); [DllImport(libmysqld.dll, EntryPoint=mysql_errno, ExactSpelling=true)] public static extern uint ErrNo(IntPtr ihConnection); [DllImport(libmysqld.dll
RE: Bug report: Embedded MySQL v4.04b
I am looking into USE_TLS. But yes, I see that mysql_real_data_home is not corrupted, only mysql_data_home is. Thanks for your response. -- Matt -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 27, 2002 11:40 AM To: Matt Solnit; [EMAIL PROTECTED] Cc: Henry Bequet Subject: Re: Bug report: Embedded MySQL v4.04b Matt, thank you for the bug report. I do not have C# in my computer. Did I understand correctly the bug does not appear if you use the Embedded Server Library inside C++? My first note is that you should define USE_TLS in all MySQL modules, like Monty instructed a week ago. But I guess that cannot cause the corruption of mysql_data_home. I looked at the source code, and it looks like mysql_data_home should be a pointer to a 512-character buffer called mysql_real_data_home, if you define a datadir, and that is not the default dir (that is, .\) of the running program. Could it be that mysql_data_home starts to point into some random location? I am forwarding this bug report to MySQL developers who know the mysqld option processing best. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com sql query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
bug report: Embedded MySQL v4.04b
=== Bug report -- MySQL v4.04b, source distribution === Machine specs (build machine and test machine are same machine): Dell Inspiron 8200 laptop Windows XP Professional SP1 .NET Framework SP2 -- Build description: -- libmysqld.dll was built using Microsoft Visual C++ 6.0 SP5 and Microsoft Visual C++ Processor Pack SP5 (used for ASM files). We build our own version because we need to make a change so that the DLL will work with C# clients (see below for more info). Problem description: A C# client was built using Microsoft Visual Studio.NET. The client calls mysql_server_init(), mysql_server_end(), and mysql_server_init() again. On second call to mysql_server_init(), the exception System.NullReferenceException is thrown. From an equivalent C++ program, an access violation occurs at the same point. Behavior is identical using debug and release builds of libmysqld.dll. C# code: using System; using System.Runtime.InteropServices; using System.Security; namespace Reproduce_Embedded_MySQL_crash { class Class1 { [STAThread] static void Main(string[] args) { MySqlAPI.ServerInit(0, null, null); MySqlAPI.ServerEnd(); MySqlAPI.ServerInit(0, null, null); MySqlAPI.ServerEnd(); } } class MySqlAPI { [SuppressUnmanagedCodeSecurity] [DllImport(libmysqld.dll, CharSet=System.Runtime.InteropServices.CharSet.Ansi, EntryPoint=mysql_server_init, ExactSpelling=true)] public static extern int ServerInit(int icArgs, string [] strArgs, string [] strGroups); [DllImport(libmysqld.dll, EntryPoint=mysql_server_end, ExactSpelling=true)] public static extern void ServerEnd(); } } - C++ code: - // /* modified from test_dll.cpp that ships with MySQL */ // #include stdafx.h #include winsock.h #include mysql.h #include stdarg.h #include stdio.h #include stdlib.h const char *server_groups[] = { test_libmysqld_SERVER, embedded, server, NULL }; int main(int argc, char* argv[]) { mysql_server_init(argc, argv, (char **)server_groups); mysql_server_end(); mysql_server_init(argc, argv, (char **)server_groups); mysql_server_end(); return 0; } --- MySQL binaries: --- Upon request, I can supply our debug and release builds of libmysqld.dll. --- Source code change description: --- There is only one change we make to the MySQL 4.04b source distribution. We define USE_TLS for the mysys project. The reason is that it's required for clients that use LoadLibrary(), which includes all C# clients. More information can be found in the VC++ documentation article Rules and Limitations for TLS. --- My contact information: --- Matt Solnit [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: bug report: Embedded MySQL v4.04b
Matt, since you are using InnoDB, you cannot call server_end() and server_init() again during the lifetime of the process. InnoDB does not clean up its internal data structures in server_end(). Is there some special reason you would need to shut down the server and open it again? Regards, Heikki Innobase Oy sql query ... === Bug report -- MySQL v4.04b, source distribution === Machine specs (build machine and test machine are same machine): Dell Inspiron 8200 laptop Windows XP Professional SP1 .NET Framework SP2 -- Build description: -- libmysqld.dll was built using Microsoft Visual C++ 6.0 SP5 and Microsoft Visual C++ Processor Pack SP5 (used for ASM files). We build our own version because we need to make a change so that the DLL will work with C# clients (see below for more info). Problem description: A C# client was built using Microsoft Visual Studio.NET. The client calls mysql server init(), mysql server end(), and mysql server init() again. On second call to mysql server init(), the exception System.NullReferenceException is thrown. From an equivalent C++ program, an access violation occurs at the same point. Behavior is identical using debug and release builds of libmysqld.dll. C# code: using System; using System.Runtime.InteropServices; using System.Security; namespace Reproduce Embedded MySQL crash { class Class1 { [STAThread] static void Main(string[] args) { MySqlAPI.ServerInit(0, null, null); MySqlAPI.ServerEnd(); MySqlAPI.ServerInit(0, null, null); MySqlAPI.ServerEnd(); } } class MySqlAPI { [SuppressUnmanagedCodeSecurity] [DllImport(libmysqld.dll, CharSet=System.Runtime.InteropServices.CharSet.Ansi, EntryPoint=mysql server init, ExactSpelling=true)] public static extern int ServerInit(int icArgs, string [] strArgs, string [] strGroups); [DllImport(libmysqld.dll, EntryPoint=mysql server end, ExactSpelling=true)] public static extern void ServerEnd(); } } - C++ code: - // /* modified from test dll.cpp that ships with MySQL */ // #include stdafx.h #include winsock.h #include mysql.h #include stdarg.h #include stdio.h #include stdlib.h const char *server groups[] = { test libmysqld SERVER, embedded, server, NULL }; int main(int argc, char* argv[]) { mysql server init(argc, argv, (char **)server groups); mysql server end(); mysql server init(argc, argv, (char **)server groups); mysql server end(); return 0; } --- MySQL binaries: --- Upon request, I can supply our debug and release builds of libmysqld.dll. --- Source code change description: --- There is only one change we make to the MySQL 4.04b source distribution. We define USE TLS for the mysys project. The reason is that it's required for clients that use LoadLibrary(), which includes all C# clients. More information can be found in the VC++ documentation article Rules and Limitations for TLS. --- My contact information: --- Matt Solnit [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Using the embedded mysql server - how do I create a database on the fly?
Hello. I'm just getting started with the embedded mysql server and I'm not trying to do anything fancy. I just want to initialize the server and call mysql_create_db and have the database get created and then start using it. I've modified the basic embedded server example as follows: mysql_server_init(sizeof(server_args) / sizeof(char *), server_args, server_groups); if(mysql_create_db(one, my_database)) { fprintf(stderr, Failed to create new database. Error: %s\n, mysql_error(one)); } one = db_connect(my_database); two = db_connect(NULL); db_do_query(one, SHOW TABLE STATUS); db_do_query(two, SHOW DATABASES); mysql_close(two); mysql_close(one); I get a test_mysqld.c:53: warning: implicit declaration of function `mysql_create_db' when compiling and then I get a Seg Fault when it is ran. What am I doing wrong? - Steve __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
two embedded mysql library apps accessing the same database
I was wondering, what happens if two programs use the embedded mysql library and try to access the same database? Or, what happens if you run the mysql database server on the machine and use the embedded mysql library to access a database? how does the mysql lib require the application writer to handle multiple independent access? -thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Embedded MySQL
On Fri, Sep 27, 2002 at 01:37:24PM +0930, David Lloyd wrote: What's the advantages of using Embedded MySQL instead of, say, Berkely's DB? Well, the SQL interface is probably the biggest advantage. There is no query language for Berkely DB, so ad-hoc queries are time-consuming to code. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 51 days, processed 1,092,381,257 queries (243/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Embedded MySQL
What's the advantages of using Embedded MySQL instead of, say, Berkely's DB? [mysql, query] DSL -- Qualcuno no mi basta. Vivere cercando il grande amore. Vivere come se mai dovessimo morire. (Anastasio, Valli e Travato) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to compile embedded MySQL on Windows
Hi I am trying to figure out how to compile embedded MySQL on Windows. I read that one should configure using the --with-embedded-server flag, but I should also use some script called mysql_config. But I couldn't find that script, I have downloaded the source for version 4.0, so I should have all the necessary things. Please, if someone you lead me in the right directions I would really appriciate it. What I am trying to accomplish is to build the libmysql to also enable the SOCKET PORT facility in an embedded server. Thus I want to run my application with MySQL embedded and then also allow for connections to the database from the outside. If you've done something similar please let me know. Regards Tobias Tobias Eriksson ComOpt AB Michael Löfmans gata 6 254 38 Helsingborg, Sweden Direct: +46 42 389918 Phone: +46 42 389900 e-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to compile embedded MySQL on Windows
Tobias Eriksson wrote: Hi I am trying to figure out how to compile embedded MySQL on Windows. I read that one should configure using the --with-embedded-server flag, but I should also use some script called mysql_config. But I couldn't find that script, I have downloaded the source for version 4.0, so I should have all the necessary things. Please, if someone you lead me in the right directions I would really appriciate it. What I am trying to accomplish is to build the libmysql to also enable the SOCKET PORT facility in an embedded server. Thus I want to run my application with MySQL embedded and then also allow for connections to the database from the outside. If you've done something similar please let me know. Regards Tobias The embedded server does not work with networking enabled. You can only access it via libmysql which talks to it directly. See http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#libmysqld -Mark -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Embedded MySQL server crashing
Sorry for the ambiguity. My application is a gui application written in Borland C++ Builder 6. It features one form with 4 buttons consisting of Create, Connect, Disconnect, Destroy. Only the relevant buttons are availible at certain times. (For instance, you cannot destroy a server when one is not created, therefore you have to click create in order to hit destroy). The purpose of the Create button is to call mysql_server_init, which creates the mysqld embedded server. After which you hit connect to connect to the created server, and then you can disconnect and destroy the server with their respective buttons. I can click the following button and have it crash: o Create button o Destroy button o Create button again o Destroy button --(Crashes here) I hope this clears things up. The destroy button simply calls the mysql_server_end(), and nothing else, just to kill the server. The speed issues I had before (with it waiting 30 seconds to kill the server) were resolved with adding the skip-innodb option to my configuration file. This also fixed the previous crash after creating the server the second time, but now has moved the crash one step ahead, the destruction of the server. Ted -- Ted Morse CIHOLAS Enterprises [EMAIL PROTECTED] On Tue, 18 Jun 2002, miguel solorzano wrote: At 08:35 17/6/2002 -0500, Theodore Morse wrote: Hi, I tried the skip-innodb in my configuration file, it helps to a point, now I can create the server twice, but can only destroy it once, the procedure goes like this: Please clarify: o Create server o Destroy server Your application is closed ? or you did the below server instance immediately the above destroy action without to know if the server clean up was finished ? o Create server o CRASH!! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Embedded MySQL server crashing
Hello to all! I am currently working on a GUI Application in Borland C++ Builder, and must use an embedded MySQL server in it. I am having difficulties, however, because whenever I create an instance, and destroy it, then try to make another instance of an embedded server, the second time it tries to create the server, the application crashes. Furthermore, it takes a lot longer than expected to shut down the mySQL embedded server than it does to create it. Are there any bugs, or other gotchas when using the embedded version? Ted -- Ted Morse CIHOLAS Enterprises [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
UDF and embedded MySQL
I know the documentation says UDF and embedded MySQL server is not allowed, but then it says, some of these limitations can be changed by editing mysql_embed.h. I see in there that it has HAVE_DLOPEN undefined. I assume it is not as simple as uncommenting that line to whether or not UDF will work with MySQL embedded. Anyway, my question is 1) is it really that simple, 2) if not, what steps might I need to take to undo this limitation if it's even possible? For my application, I use two of my own functions which I currently compile as a shared library. I would love to embed MySQL so my end users do not have to install/admin a MySQL database. Thanks for any tips! Joey +--+ + + + Joey Mukherjee The price of freedom is eternal + + [EMAIL PROTECTED] vigilance, or $12.50 as seen on + + E-Bay... + + + +--+ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Embedded MySQL terminate abnormally.
I installed Embedded MySQL( compiled --with-embedded-server) And I compiled source code from Manual. (I did not modify the source) compiled nicly, but I run the Embedded MySQL, Segmentation fault occured [wertyu@inos prog]$ ls Makefile mysqld* mysqld.c mysqld.c~ [wertyu@inos prog]$ ./mysqld Segmentation fault [wertyu@inos prog]$ here is output from GDB Program received signal SIGSEGV, Segmentation fault. 0x8051984 in vio_read () (gdb) bt #0 0x8051984 in vio_read () #1 0x807357d in net_clear () #2 0x804857f in simple_command () #3 0x80494f0 in mysql_close () #4 0x80481e8 in main (argc=1, argv=0xb594) at mysqld.c:54 #5 0x8230a51 in __libc_start_main (main=0x80481a0 main, argc=1, argv=0xb594, init=0x80480b4 _init, fini=0x82782d0 _fini, rtld_fini=0, stack_end=0xb58c) at ../sysdeps/generic/libc-start.c:78 (gdb) gcc version = 2.91.66 OS version = Redhat 6.0 Thank you for advanced answer! Homepage = http://www.nnr.or.kr/inos/ ICQ # = 123534385 Member of DSN(database.sarang.net), NNR(nnr.or.kr) --MIME Multi-part separator-- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Embedded MySQL terminate abnormally.
At 23:46 30/12/2001 +0900, Heo, Jungsu Mr. wrote: Hi! Below the patch made by Monty: (/my/mysql) bk diffs sql/net_serv.cc = sql/net_serv.cc 1.32 vs edited = 170c170 #ifndef EXTRA_DEBUG --- #if !defined(EXTRA_DEBUG) !defined(EMBEDDED_LIBRARY) (/my/mysql) bk diffs -c sql/net_serv.cc = sql/net_serv.cc 1.32 vs edited = *** /tmp/net_serv.cc-1.32-4839 Sat Dec 22 15:13:31 2001 --- edited/sql/net_serv.cc Sun Dec 30 12:43:17 2001 *** *** 167,173 void net_clear(NET *net) { ! #ifndef EXTRA_DEBUG int count; /* One may get 'unused' warn */ bool is_blocking=vio_is_blocking(net-vio); if (is_blocking) --- 167,173 void net_clear(NET *net) { ! #if !defined(EXTRA_DEBUG) !defined(EMBEDDED_LIBRARY) int count; /* One may get 'unused' warn */ bool is_blocking=vio_is_blocking(net-vio); if (is_blocking) Regards, Miguel I installed Embedded MySQL( compiled --with-embedded-server) And I compiled source code from Manual. (I did not modify the source) compiled nicly, but I run the Embedded MySQL, Segmentation fault occured [wertyu@inos prog]$ ls Makefile mysqld* mysqld.c mysqld.c~ [wertyu@inos prog]$ ./mysqld Segmentation fault [wertyu@inos prog]$ here is output from GDB Program received signal SIGSEGV, Segmentation fault. 0x8051984 in vio_read () (gdb) bt #0 0x8051984 in vio_read () #1 0x807357d in net_clear () #2 0x804857f in simple_command () #3 0x80494f0 in mysql_close () #4 0x80481e8 in main (argc=1, argv=0xb594) at mysqld.c:54 #5 0x8230a51 in __libc_start_main (main=0x80481a0 main, argc=1, argv=0xb594, init=0x80480b4 _init, fini=0x82782d0 _fini, rtld_fini=0, stack_end=0xb58c) at ../sysdeps/generic/libc-start.c:78 (gdb) gcc version = 2.91.66 OS version = Redhat 6.0 Thank you for advanced answer! Homepage = http://www.nnr.or.kr/inos/ ICQ # = 123534385 Member of DSN(database.sarang.net), NNR(nnr.or.kr) --MIME Multi-part separator-- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Embedded MySQL server the outside world
Hi folks, does embedded server tcp-listen to the outside world i.e. it could be used by another app or perhaps been accessed by the same app using ODBC? OR is MySQL C API the only way to control it? Thanks, Marek - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Embedded MySQL server the outside world
Marek Kustka writes: Hi folks, does embedded server tcp-listen to the outside world i.e. it could be used by another app or perhaps been accessed by the same app using ODBC? Nope. OR is MySQL C API the only way to control it? Yes, so far. But other API's could be built on top of it ... Thanks, Marek -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
C with embedded mysql
Hi, I am a newbie... so please excuse me if the question is a bit wacky ;-) I was trying to write a database system using C with embedded mysql.. could you please help me by providing me with any links to anysites where I can get help in the form of 1. Sample code. 2. Tutorial on how to do the embedded mysql 3. How to compile and test out the code I have a Linux box with the latest version of mysql on it. Thanks for your help Ryan __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Embedded MySQL: Opinion Please
Hi! I've been monitoring this list for a while now (re: lurking), I've seen only passing comments about embedding MySQL, so I thought I would come out and directly ask the MySQL community for your opinions, or better yet, actual facts - based on experience. I am evaluating MySQL / Linux for use in a line of deeply embedded, multi-node, real-time SCADA products. Where: deeply embedded = headless platform, no user interaction (not even via telnet), no administration interaction, required to operate for years without restart. multi-node = 1 to N processor boards, sharing a common bus (VME, CPCI), not SMP. And, * Database size: between 10K - 250K records - where once the records have been created, they are only updated, typically between several 100 to several 1,000 UPDATES / second. * No moving parts (no fan, no hard disk, no CD, no floppy, no noth'n). * Memory size is not an issue (can add more as required); CPU power is not an issue (re: Moore's Law) (The actual requirements are not as extreme as depicted here, but I want to push the envelope.) I am convinced that MySQL / Linux will work in such as environment. But, the real question(s) is: Can they (MySQL / Linux) work in such an environment, continuously, without error or failure, or requiring operator intervention, for years on end? For this environment, is the MySQL / Linux combo a good idea? Or, should I stick with Linux, but seek out an alternate DBMS? Or, should I drop Linux and go with Windows CE, or some other RTOS? Or, should I stop being a software developing and become a sheepherder? David Vance Senior Software Developer GE Harris Energy Control Systems Canada, Inc. 2728 Hopewell Place NE Calgary, Alberta,Canada T1Y 7J7 +1 (403) 214-4543 +1 (403) 287-7946 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Embedded MySQL: Opinion Please
http://www.qnx.com/ Tey actually have a headline right now about BerkleyDB being ported. While I take nothing away from the Mysql/Linux combo as a stable OS. I would stay that a specifically designed RTOS for embeded devices might be better in this situation. Gregg - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 15, 2001 1:00 PM Subject: Embedded MySQL: Opinion Please Hi! I've been monitoring this list for a while now (re: lurking), I've seen only passing comments about embedding MySQL, so I thought I would come out and directly ask the MySQL community for your opinions, or better yet, actual facts - based on experience. I am evaluating MySQL / Linux for use in a line of deeply embedded, multi-node, real-time SCADA products. Where: deeply embedded = headless platform, no user interaction (not even via telnet), no administration interaction, required to operate for years without restart. multi-node = 1 to N processor boards, sharing a common bus (VME, CPCI), not SMP. And, * Database size: between 10K - 250K records - where once the records have been created, they are only updated, typically between several 100 to several 1,000 UPDATES / second. * No moving parts (no fan, no hard disk, no CD, no floppy, no noth'n). * Memory size is not an issue (can add more as required); CPU power is not an issue (re: Moore's Law) (The actual requirements are not as extreme as depicted here, but I want to push the envelope.) I am convinced that MySQL / Linux will work in such as environment. But, the real question(s) is: Can they (MySQL / Linux) work in such an environment, continuously, without error or failure, or requiring operator intervention, for years on end? For this environment, is the MySQL / Linux combo a good idea? Or, should I stick with Linux, but seek out an alternate DBMS? Or, should I drop Linux and go with Windows CE, or some other RTOS? Or, should I stop being a software developing and become a sheepherder? David Vance Senior Software Developer GE Harris Energy Control Systems Canada, Inc. 2728 Hopewell Place NE Calgary, Alberta,Canada T1Y 7J7 +1 (403) 214-4543 +1 (403) 287-7946 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Embedded MySQL: Opinion Please
Hi. On Thu, Feb 15, 2001 at 02:00:04PM -0500, [EMAIL PROTECTED] wrote: [...] Can they (MySQL / Linux) work in such an environment, continuously, without error or failure, or requiring operator intervention, for years on end? Well, I see no principle problem here. The servers I administer run about 200-400 days without interruption (then the counters get interrupted by hardware/software upgrades ;-) Exceptions are massive internet accesses (so called slashdot effect), but with enough memory and some reasonable limits set, one gets even this stuff stable (not responsive, but stable). What you have to have a look at is anything which is incremental, mainly log files and such stuff. Either disable or rotate those. What I would do is make a test install, then leave it alone for some time and then compare all file sizes and assure that the growing files will be no problem or handle them with cronjobs. For case of emergency (i.e. if some program crashes anyhow), there are several solutions for watchers available, which can restart them (although, as I said, I did not need that stuff until now on x86 boxes). For this environment, is the MySQL / Linux combo a good idea? The question is whether the support for your hardware is stable. If so, I would dare to say that I get the software part stable, too. Or, should I stick with Linux, but seek out an alternate DBMS? MySQL is rock solid if you avoid newly added features and have tested your queries once to be supported. I won't say anything about other DBMSes, because I use none intensively enough to justify a opinion on it. Or, should I drop Linux and go with Windows CE, or some other RTOS? Well, I am biased there, but I would really avoid Windows. ;-) Other RTOS are probably a good idea, as someone else already said. Or, should I stop being a software developing and become a sheepherder? No comment. ;-) Bye, Benjamin. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Embedded MySQL: Opinion Please
Benjamin Pflugmann wrote: Or, should I drop Linux and go with Windows CE, or some other RTOS? Well, I am biased there, but I would really avoid Windows. ;-) Other RTOS are probably a good idea, as someone else already said. Or, should I stop being a software developing and become a sheepherder? A RTOS? I would go for QNX, better yet: Neutrino (this is a really weird RTOS) No comment. ;-) Bye, Benjamin. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php