How to call stored procedures using C API
Hi to all, I try to call a stored procedure using mysql_real_query and with the CLIENT_MULTI_STATEMENTS flag on mysql_real connect() function. When i try the statement call sp1(@myparam); the error can't return the results in actual context is occur. Please, if is some one which have experience whith the handling store procedures using MySQL C API, to give me a solution. I use mysql-5.0.2x on Fedora 5. Thank you, -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to call stored procedures using C API
Hi again folks, The problem is solved.Was entirely my fault because i didn't check the version of mysqlclient library. -Original Message- From: Gelu Gogancea Sent: Monday, 21 August, 2006 12:47 PM To: mysql@lists.mysql.com Subject: How to call stored procedures using C API Hi to all, I try to call a stored procedure using mysql_real_query and with the CLIENT_MULTI_STATEMENTS flag on mysql_real connect() function. When i try the statement call sp1(@myparam); the error can't return the results in actual context is occur. Please, if is some one which have experience whith the handling store procedures using MySQL C API, to give me a solution. I use mysql-5.0.2x on Fedora 5. Thank you, -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Split a Delimited String in SQL ( PROCEDURE split_string )
Hi, It's very important to have instaled the library client related to the MySQL server version.For example, you cannot use libmysql.dll version 3.X or 4.x to use stored procedure from version 5.X of MySQL RDBMS. Regards, _ G.NET SOFTWARE COMPANY SYSTEM INTEGRATOR - AUTOMATION SOFTWARE DEVELOPMENT http://www.gonetsoftware.com Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] -Original Message- From: Jørn Dahl-Stamnes [mailto:[EMAIL PROTECTED] Sent: Wednesday, 21 June, 2006 2:42 PM To: mysql@lists.mysql.com Subject: Re: Split a Delimited String in SQL ( PROCEDURE split_string ) On Wednesday 21 June 2006 13:37, listsql listsql wrote: Just for the happy comment: Argentina Will win the match tonight against Holland :) MARTIN ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Argentina Will win the match tonight against Holland' at line 1 -- Jørn Dahl-Stamnes homepage: http://www.dahl-stamnes.net/dahls/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to use Logic in View Statment?
Hi , IMHO the corect way is to check if IS NULL SELECT fieldOne, fieldTwo, IF(fieldThree IS NULL,fieldFour,fieldThree) as Company FROM table; Depening on the column definition(if is byte,multi-byte...etc.), LENGTH() function can have various behaviour and is not quite sure that you will get always the same result. Regards _ G.NET SOFTWARE COMPANY SYSTEM INTEGRATOR - AUTOMATION SOFTWARE DEVELOPER http://www.gonetsoftware.com Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, 28 November, 2005 10:09 PM To: Cory @ SkyVantage Cc: My SQL Subject: Re: How to use Logic in View Statment? Cory @ SkyVantage [EMAIL PROTECTED] wrote on 11/28/2005 02:38:50 PM: I have a similar question. How do you test if the field in question isn't NULL or '' (empty string)? Is the LENGTH a good test or is there a better way? [EMAIL PROTECTED] wrote: LENGTH does exist (as a function): http://dev.mysql.com/doc/refman/5.0/en/string-functions.html and here is how to use the IF() function: http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html I believe this is the equivalent statement you wanted: SELECT fieldOne, fieldTwo, IF(CHAR_LENGTH(fieldThree)0,fieldThree,fieldFour) as Company FROM table; There are MANY ways to work with or detect NULL values: ISNULL() COALESCE() IS NULL IS NOT NULL NOT .. IS NULL ='' = NULL IFNULL() NULLIF() http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html What exactly are you trying to accomplish with the test? There may be several ways of getting at what you want. Shawn Green Database Administrator Unimin Corporation - Spruce Pine The ISNULL function returns either a 0 or 1 depening on if the expression inside the parentheses is NULL or not -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Question about BLOB
I use mysql C API and for *escaping* the data i use the mysql_real_escape_string()the mysql native function. Thanks, _ G.NET SOFTWARE COMPANY SYSTEM INTEGRATOR - AUTOMATION SOFTWARE DEVELOPER http://www.gonetsoftware.com Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] -Original Message- From: Philippe Poelvoorde [mailto:[EMAIL PROTECTED] Sent: Wednesday, 03 August, 2005 9:58 AM To: 'mysql@lists.mysql.com ' Subject: Re: Question about BLOB Gelu Gogancea wrote: Hi, Is not the first time when i read this this page. So, the conclusion is that until MySQL version 5.0.3 the empty spaces are remove if i wish to store the binary data in a table. Is not any other solutions?Because for the moment i convert the binary data into ASCII(printing ASCII) string,i add slashes after each converted character and after all this i store in the BLOB field on the table.And i wish to avoid this procedure...wasting a lot of time. Thanks, the story for the trailing spaces only apply for varchar, so for blob it does not matter as long as you properly escape the data. (you don't need the ascii conversion, just the escaping) -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Question about BLOB
Hi, Is not the first time when i read this this page. So, the conclusion is that until MySQL version 5.0.3 the empty spaces are remove if i wish to store the binary data in a table. Is not any other solutions?Because for the moment i convert the binary data into ASCII(printing ASCII) string,i add slashes after each converted character and after all this i store in the BLOB field on the table.And i wish to avoid this procedure...wasting a lot of time. Thanks, _ G.NET SOFTWARE COMPANY SYSTEM INTEGRATOR - AUTOMATION SOFTWARE DEVELOPER http://www.gonetsoftware.com Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Monday, 01 August, 2005 8:41 PM To: Gelu Gogancea; MySQL mailing list Subject: RE: Question about BLOB [snip] I have a table with a MEDIUMBLOB field and i wish to store a picture(.BMP) which the size is 10622 bytes.But when i look into the table i see only 9582 bytes. Please, i wish to know for what reason on the table are few bytes than original. I use MySQL 5.0 - Fedora Core 3 [/snip] Have a look here, http://dev.mysql.com/doc/mysql/en/blob.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Question about BLOB
Hi, I have a table with a MEDIUMBLOB field and i wish to store a picture(.BMP) which the size is 10622 bytes.But when i look into the table i see only 9582 bytes. Please, i wish to know for what reason on the table are few bytes than original. I use MySQL 5.0 - Fedora Core 3 Thanks, _ G.NET SOFTWARE COMPANY SYSTEM INTEGRATOR - AUTOMATION SOFTWARE DEVELOPER http://www.gonetsoftware.com Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED] Sent: Monday, 01 August, 2005 7:08 PM To: Spill Support; MySQL mailing list Cc: [EMAIL PROTECTED] Subject: Re: mysql bug 9670 OPTIMIZE TABLE crashes Matthis, unfortunately, the bug fix was never made to 4.0. It is only in 4.1.12 and later. Regards, Heikki - Alkuperäinen viesti - Lähettäjä: Matthijs van der Klip [EMAIL PROTECTED] Vastaanottaja: MySQL mailing list mysql@lists.mysql.com Kopio: [EMAIL PROTECTED]; [EMAIL PROTECTED] Lähetetty: Monday, August 01, 2005 5:08 PM Aihe: mysql bug 9670 OPTIMIZE TABLE crashes Hi, I am experiencing assertion failures described in the following bugreport: http://bugs.mysql.com/bug.php?id=9670 The bug has been closed, but I'm running the most current 4.0.25 version of MySQL. The report mentions downgrading to 4.0.23 or upgrading to 4.1. Is this really neccessary or should this bug already be fixed in 4.0.25? Best regards, -- Matthijs van der Klip System Administrator Spill E-Projects The Netherlands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: connection time is slow
IMHO You have problems on the DNS server. _ G.NET SOFTWARE COMPANY SYSTEM INTEGRATOR - AUTOMATION SOFTWARE DEVELOPER Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] -Original Message- From: Heo, Jungsu [mailto:[EMAIL PROTECTED] Sent: Thursday, 29 July, 2004 3:17 PM To: [EMAIL PROTECTED] Subject: connection time is slow [Could not convert from 'ks_c_5601-1987'] Hello. I'm using MySQL 4.1.2 on Linux(Fedora Core 2) and Window 2003 Server. When connect from Linux to Windows, or from Window to Linux connection time is very slow. ( it takes about 6 seconds) But Linux to Linux or Windows to Windows Fast. Anybody has an Idea? Thank you for advanced answer! == (ÁÖ)À¯ºñÄõÅͽº Æйи® °³¹ßÆÀ Çã Á¤ ¼ö ÁÖÀÓ email : [EMAIL PROTECTED] tel : 02-798-6822 fax : 02-749-9632 Web : http://www.ufamily.co.kr ¼¿ï½Ã ¿ë»ê±¸ ³²¿µµ¿ 104 û¼Ûºôµù 3Ãþ == ¿ï ÂÄ, ¿ï ¾¥ We win! This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain private, confidential and/or privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, employee or agent responsible for delivering this message, please contact the sender by reply e-mail and destroy all copies of the original e-mail message. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Bug on MYSQL-5.0 in statement OPTIMIZE TABLE
Title: Bug on MYSQL-5.0 in statement OPTIMIZE TABLE Hi, TABLE CREATE DESCRIPTION : CREATE TABLE T1(IDAP INT(16),TVAL INT(2),CH_VAL_SEC INT(16),INDEX(IDAP),INDEX(TVAL),INDEX(CH_VAL_SEC)); RUNNING CONDITIONS: -use persistent connection. RUNNING SEQUENCE: 1-Open 1-st connection. 2-insert in table many values at once time with delayed option; insert delayed into T1 (IDAP,TVAL,CH_VAL_SEC) VALUES(1,-2,100),(2,-3,101),(3,-4,102); 3-I let 1-st connection open.Open 2-nd connection to execute the next 2 statement. 4-delete all data from table : delete from T1; 5-optimize the table : optimize table T1; MySQL daemon crash on this last statement if i use PERSISTENT CONNECTION, otherwise is OK. From the mysql daemon log: 040223 14:59:49 mysqld started 040223 14:59:50 InnoDB: Started; log sequence number 0 43634 040223 14:59:50 /mysql/mysql-5.0.bin/libexec/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 2) 040223 14:59:50 Found 4.1 style password for user '[EMAIL PROTECTED]'. Ignoring user. You should change password for this user. /mysql/mysql-5.0.bin/libexec/mysqld: ready for connections. Version: '5.0.0-alpha' socket: '/mysql/mydatabase/mysql.sock' port: 3306 mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=8388600 read_buffer_size=131072 max_used_connections=2 max_connections=100 threads_connected=3 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 225791 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x85b00a8 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0x41da4ee4, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x813c7c4 0x4004e618 0x40049dea 0x4202726c 0x40049dea 0x8185301 0x400492b6 0x420de407 New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/en/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x8584920 = O.H..B. thd-thread_id=4 The manual page at http://www.mysql.com/doc/en/Crashing.html contains information that should help you find out what is causing the crash. 040223 15:01:37 mysqld ended MY.CNF FILE : [mysqld] datadir=/mysql/mydatabase socket=/mysql/mydatabase/mysql.sock [mysql.server] user=mysql basedir=/mysql/mydatabase [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid OS ENVIRONMENT: RED HAT 8.0 HARDWARE : Pentium IV 1,7 Ghz,512 Mb RAM,2 x 40GB EIDE HDD Regards, Gelu _ G.NET SOFTWARE COMPANY SYSTEM INTEGRATOR - AUTOMATION SOFTWARE DEVELOPER Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: using 2 nic controllers
Hi, You can only bind to a specific network interface IP address which is mounted and Up from your server. ie: ./mysqld --bind-address=YOUR_IP_ADDRESS Regards, Gelu _ G.NET SOFTWARE COMPANY SYSTEM INTEGRATOR - AUTOMATION SOFTWARE DEVELOPER Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] -Original Message- From: theoharis tsenis [mailto:[EMAIL PROTECTED] Sent: Thursday, 29 January, 2004 2:37 PM To: mysql-discuss Subject: using 2 nic controllers Hi, on a linux installation i use for my purposes 2 ehternet cards. I have installed the mysql 4.0.15. From a remote client i make various queries but few of them expires (about 5% !!!). If i disable the second ethernet adapter the expires dissapears all works very well. Is there away to make mysql to listen on a specific ethernet card? Regards, Teo. Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail! http://login.mail.lycos.com/r/referral?aid=27005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: CALCULATING DATES
Hi, You can use TO_DAYS() and FROM_DAYS() functions for what you need. All details about Time and Date functions : http://www.mysql.com/doc/en/Date_and_time_functions.html Regards, Gelu _ G.NET SOFTWARE COMPANY SYSTEM INTEGRATOR - AUTOMATION SOFTWARE DEVELOPER Permanent e-mail address : [EMAIL PROTECTED] -Original Message- From: Paul Hayer [mailto:[EMAIL PROTECTED] Sent: Wednesday, 28 January, 2004 4:46 PM To: '[EMAIL PROTECTED]' Subject: CALCULATING DATES Hi, I want to be able to show the total of the subtraction of the returned date from the from date for each department for each month. This to be done on a range of a year, and then when the next month comes round for the calculation to take that month into account, so, shifting the range to calculate by a month forward. Thanks in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: CALCULATING DATES
I'm not very sure that i understand very well your problem but i suppose that if you don't have entries in your table(s) for weekends, is obvious that you can not show directly some results. To show what you wish i guess is better to use conditional IF() function. ie: SELECT IF(YOUR_FIELD_DEPARTMENT_FROM_TABLE=YOUR_INTERESTED_DEPARTMENT_ID,TO_DAYS(LAST_DAY)-TO_DAYS(FIRST_DAY),0) Regards, Gelu _ G.NET SOFTWARE COMPANY SYSTEM INTEGRATOR - AUTOMATION SOFTWARE DEVELOPER Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] -Original Message- From: Paul Hayer [mailto:[EMAIL PROTECTED] Sent: Wednesday, 28 January, 2004 6:14 PM To: '[EMAIL PROTECTED]' Subject: FW: CALCULATING DATES Thanks for the reply, I think SUM(DAYOFYEAR) has solved it. However is there a way of subtracting weekends and showing departments even if they have no entries( ie to show the dept and 0 as it's result)? Cheers. -Original Message- From: Gelu Gogancea [mailto:[EMAIL PROTECTED] Sent: 28 January 2004 15:08 To: Paul Hayer; [EMAIL PROTECTED] Subject: RE: CALCULATING DATES Hi, You can use TO_DAYS() and FROM_DAYS() functions for what you need. All details about Time and Date functions : http://www.mysql.com/doc/en/Date_and_time_functions.html Regards, Gelu _ G.NET SOFTWARE COMPANY SYSTEM INTEGRATOR - AUTOMATION SOFTWARE DEVELOPER Permanent e-mail address : [EMAIL PROTECTED] -Original Message- From: Paul Hayer [mailto:[EMAIL PROTECTED] Sent: Wednesday, 28 January, 2004 4:46 PM To: '[EMAIL PROTECTED]' Subject: CALCULATING DATES Hi, I want to be able to show the total of the subtraction of the returned date from the from date for each department for each month. This to be done on a range of a year, and then when the next month comes round for the calculation to take that month into account, so, shifting the range to calculate by a month forward. Thanks in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Test!!!Please ignore this message
Title: Test!!!Please ignore this message Hi fellows, ...just a test.Please ignore this message. _ G.NET SOFTWARE COMPANY SYSTEM INTEGRATOR - AUTOMATION SOFTWARE DEVELOPER Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can not make PULL from mysql.bkbits.net
Hi, I wish to make a pull for mysql-5.0 from http://mysql.bkbits.net but always is nothing to pull. I try with : bk pull http://mysql.bkbits.net/mysql-5.0 I wonder, what happens ? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED]
Re: C API
Hi, You can not use native MYSQL C API to handle Oracle DataBase.Work very well (mixed with MYSQL C API) the ORACLE C API which is named OCI(Oracle Call Interface). Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Priyanka Gupta [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 2:14 AM Subject: C API Is there a way to have a common C API for MySQL and Oracle. I am writing some software that I would like to work with both MYSQL or Oracle as the backend server? priyanka _ Enjoy MSN 8 patented spam control and more with MSN 8 Dial-up Internet Service. Try it FREE for one month! http://join.msn.com/?page=dept/dialup -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Leaking Memory from mysql_real_query()
usually, to release memory is used mysql_free_result(). You do that ? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: bluejack [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 8:26 PM Subject: Leaking Memory from mysql_real_query() This is probably my mistake somewhere, but perhaps someone could shed some light on the matter: I have an app, compiled with the mysql c apis, that is leaking memory. I know this by fine-tuned debugging using mallinfo. The memory that is being leaked is allocated by calls to mysql_real_query(), and I can't figure out what needs to happen to free it. I *do* free the memory allocated by mysql_store_result(), but that does not rollback the memory allocated in mysql_real_query(). I am using the current production version of 4.0.15-standard, so I can't imagine this is an actual memory leak in mysql. Any idea what I might be doing wrong? --bluejack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MINOR BUG IN CREATE TABLE ver. MYSQL-5.0
Hi, On the CREATE TABLE statement some mistake in syntax is not reported. STATEMENT: CUT- --- CREATE TABLE prodconfirm(IDPC INT(16) AUTO_INCREMENT NOT NULL PRIMARY KEY,mUser CHAR(16),PLANT VARCHAR(4),LINE VARCHAR(8),,MATERIAL VARCHAR(10),SERIAL VARCHAR(10),PRODDATE DATETIME,CONFIRM TINYINT(1),TRANSFER TINYINT(1), CONF_DATE DATE,TRANSF_DATE DATE,INDEX productconfirm(IDPC,mUser,PLANT,LINE,MATERIAL,SERIAL,PRODDATE,CONFIRM,TRANSF ER,CONF_DATE,TRANSF_DATE)); CUT- Between VARCHAR(8) and MATERIAL are double comma.This not generate an error in syntax. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: not allowed to connect to this mysql server
Hi, First you must add grants to the user which you want to connect to the MySQL server.In documentation (4.3.5 Adding New Users to MySQL) you will find how you can achieved this. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 2:41 PM Subject: not allowed to connect to this mysql server Hi I am using a .Net project to connect to a mysql server. I have a winXP (IIS installed) machine as a network client to our mysql server hold on a linux machine. I have mydobc installed. I made a connection in .Net. But when I try to connect to mysql I get an error message saying: 'My ip' is not allowed to connect to this mysql server What can I do? Sinan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Doing select @a does not work in replication.
Hi, ...the sysntax it's not quite normal.You should try : select @a:=max(id)+1 from t1; To test if the variable @a is loaded with what you expect, you can do: select @a; ...if the result is NULL something is working wrong. Anyhow, i wonder how it works on the master ? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Scott Wong [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 6:53 PM Subject: Doing select @a does not work in replication. I'm not sure if this is a feature or not so i'll just report it as a possible bug. I couldnt find anything in the documentation. How to repeat: create table t1(id int); insert into t1 set id=0; select @a:max(id)+1 from t1; insert into t1 [EMAIL PROTECTED]; Result on master: mysql select * from t1; +--+ | id | +--+ |0 | |1 | +--+ 2 rows in set (0.00 sec) result on slave: mysql select * from t1; +--+ | id | +--+ |0 | | NULL | +--+ Binlog shows insert into t1 set [EMAIL PROTECTED]; on both master and slave. Fix:? Thank you for your time, Scott Wong Meiko America, INC -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql_query to return immediately when connection lost
Hi, This is usually happened becuase you don't have configured a DNS server in your network. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Pedro Alvarez-Tabío [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 1:47 PM Subject: mysql_query to return immediately when connection lost Hello, My client uses mysql_query to access a remote server. When the connection is lost (cable disconnected), mysql_query doesn't return immediately and I need a fast error return. I have tried executing mysql_options(mysql, MYSQL_OPT_CONNECT_TIMEOUT, connectTimeout); (connectTimeout=1), always before connecting (mysql_real_connect). Also set mysql.reconnect to 0 before executing mysql_query. But no success. I need mysql_query to immediately return when a connection is lost in order the client to switch to the replicated server. Would you please tell me how can I do it? Thank you. Pedro -- |\ | \ | \ |___\ | | -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql_query to return immediately when connection lost
Hi, In this case i guess is better to execute mysql_ping() before mysql_query(). Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Pedro Alvarez-Tabío [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Gelu Gogancea [EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 4:34 PM Subject: Re: mysql_query to return immediately when connection lost Hi, In this case I do have a DNS server. Any other hint please? I strongly need mysql_query to return immediately if connection is lost with the server. Any configuration parameter or similar on MySQL? Need to reconfigure something in the OS? Thanks. Pedro Gelu Gogancea wrote: Hi, This is usually happened becuase you don't have configured a DNS server in your network. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Pedro Alvarez-Tabío [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 1:47 PM Subject: mysql_query to return immediately when connection lost Hello, My client uses mysql_query to access a remote server. When the connection is lost (cable disconnected), mysql_query doesn't return immediately and I need a fast error return. I have tried executing mysql_options(mysql, MYSQL_OPT_CONNECT_TIMEOUT, connectTimeout); (connectTimeout=1), always before connecting (mysql_real_connect). Also set mysql.reconnect to 0 before executing mysql_query. But no success. I need mysql_query to immediately return when a connection is lost in order the client to switch to the replicated server. Would you please tell me how can I do it? Thank you. Pedro -- |\ | \ | \ |___\ | | -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- |\ | \ | \ |___\ | | -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: AW: EMS MySQL Manager for Linux 1.15 released!
Hi, - Original Message - From: Daniel Kasak [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 12:35 AM Subject: Re: AW: EMS MySQL Manager for Linux 1.15 released! Rusch (ext) Reiner wrote: Hi, is anyone interested in commercial use/spam of this list? If not, I would prefer to throw them out of the list. Regards, Reiner If it offends you so then set up a filter to deal with it. MySQL-related software releases can't be considered spam. Focus your attention on real spam. There's plenty to go after without taking things out on people providing software for our favourite database. I agree with this point of viewsubscribe also. Best regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.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 - 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: Looking for a bona fide distributed database that is open source
Hi Bruce, - Original Message - From: Bruce Feist [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Sunday, March 16, 2003 7:03 AM Subject: Re: Looking for a bona fide distributed database that is open source Gelu Gogancea wrote: You make confusion between terms, CONCEPTS and TECHNOLOGIES.Is not yet invented the tools which should THINK instead of our BRAIN when must design a system...any kind of. You are mistaken if you think that I am confused about this. ...maybe...but from what you describe in your messages that is understandable. There are RDBMS's out there that support the features that I described. Yes, of course. An example is CA-OpenIngres. They are good for building distributed databases because they allow the implementer to work at a higher and more appropriate level, concentrating on the distribution appropriate instead of the mechanism for implementing distribution, and because they let the application developer ignore the fact that the database happens to be distributed. Ah...:)...so, now o lot of things began to be jointlyi agree. MySQL don't have implemented such a *powerful tool*(ad-literam copy words, from Ingres website). I made no claim that these other tools think or design; they simply You understand me wrong...it's was like example to be obvious the difference between, concepts and technologies(or tools, if i can said in this way) have extra functionality which implements distribution ...i guess that you wish to said : functionality which are permissive for implementing the distribution. Functionality, which must be able to manage two/more tables on the heterogeneous network environment.With this capabilites it's more easy to implement the distribution.Quite true. -- which is what the original poster was asking about. A human being still must figure out what the most effective distribution strategy is. Yes.It seems that we begin to talk about the same things.And now become the correct answer: MYSQL CAN BE USED IN THE DISTRIBUTED ENVIRONMENT SYSTEMS. MySQL is a fine RDBMS; it simply does not implement distribution in its engine. By claiming that it does, you do a disservice to other RDBMSs which *do*, and to people looking for such a solution. This is not was my intention.The result of this kind of discussions, always should go to some things which must be more clearly.Every project leader,manager...whatever...must be able to make out the correct decision, depend on his needs pertain to his knowledge,experince. Bruce Feist Regards, Gelu - 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: mySQL activity logging on a dual prozessor maschine
Hi Peter, - Original Message - From: Peter Stoehr [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Gelu Gogancea [EMAIL PROTECTED] Sent: Monday, March 17, 2003 3:56 PM Subject: RE: mySQL activity logging on a dual prozessor maschine Hi Gelu, thanks for your message. But I'm not confused about the timeformat, I'm confused of the order the logs are. 1st: 19:31:18 2nd: 19:31:20 3rd: 19:31:18 (!) 4th: 19:31:20 (!) Indeed...this is a little strange.If we suppose that your computer clock work fine,remain only idea about time processing.It's possible to be some shorter processes which can running on the same period of time with the longer processes.That means can be a process(shorter time running/easy process) which is started after another process is already started(longer time running/heavy) but is finished before the process which was already started.In this situation can make sense because this processes write on the log file (the starting time) after *they* are succesfully finished. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] ... I don't know, what the problem is. Rgds, Peter -Original Message- From: Gelu Gogancea [mailto:[EMAIL PROTECTED] Sent: Friday, March 14, 2003 10:34 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: mySQL activity logging on a dual prozessor maschine Hi, Maybe it's funny...but this is MySQL date/time format which is used in log files.On my MySQL servers date/time are formated in the same way. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Peter Stoehr [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 14, 2003 10:52 PM Subject: mySQL activity logging on a dual prozessor maschine Hi list, few days ago, I have installed a 2nd CPU in my ProLiant380. I recompiled a new kernel (2.4.17) for Debian 3.0. On the machine there is mySQL 3.23.52-2 installed (deb). Every thing works fine, just the logging of mySQL looks a little funny to me, especially the time: 030314 19:31:189745 Query SELECT de FROM b... 9745 Query SELECT gid FROM ... 030314 19:31:209745 Query SELECT gid FROM ... 030314 19:31:189745 Query SELECT gid FROM ... 9745 Query SELECT de FROM b... 030314 19:31:209745 Query SELECT de FROM b... 030314 19:31:189745 Query SELECT de FROM b... 030314 19:31:209745 Query SELECT de FROM b... 030314 19:31:189745 Query SELECT de FROM b... 030314 19:31:209745 Query SELECT de FROM b... 030314 19:31:189745 Query SELECT de FROM b... 030314 19:31:209745 Query SELECT de FROM b... 030314 19:31:189745 Query SELECT de FROM b... 030314 19:31:209745 Query SELECT de FROM b... 030314 19:31:189745 Query SELECT de FROM b... 9745 Query SELECT de FROM b... 9745 Query SELECT gid FROM ... 030314 19:31:209745 Query SELECT gid FROM ... The websites still grow up without errors and there is also nothing in the errorlogs. Did someone of you ever had this interesting thing? I could not find anything about that with Google or in the mailarchive here at mySQL. Thanks for your help, regards, Peter - 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 - 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: mySQL activity logging on a dual prozessor maschine
Hi again Peter, I talk about processes which running in milliseconds. I don't know what to say further.Anyhow, i guess(...in my opinion) this happened because of processing time(especially that you have to 2 CPU mounted in your system).I think is not other reason because MYSQL, purely read the time from the system and write to the log file.The question is : When ? Best regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Peter Stoehr [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Gelu Gogancea [EMAIL PROTECTED] Sent: Monday, March 17, 2003 6:28 PM Subject: RE: mySQL activity logging on a dual prozessor maschine Hi again, I don't think, that there are longer or shorter processes. Since I installed the 2nd CPU (933MHz for Compaq ProLaint380), I have these logenties. For example, I have a site, which supports more languages (at this time english and german only). On one site, I installed a JavaScript-Calender and the name of the months will be selected from the database in the correct language the customer wanted it. The mysql-logs look like this, when I called the calender and the name of month should be in german: 030317 16:09:54 22669 Init DB calenderDB 22669 Query SELECT de FROM general_lang WHERE def = 'jan' 030317 16:09:58 22669 Query SELECT de FROM general_lang WHERE def = 'feb' 030317 16:09:54 22669 Query SELECT de FROM general_lang WHERE def = 'mar' 030317 16:09:58 22669 Query SELECT de FROM general_lang WHERE def = 'apr' 22669 Query SELECT de FROM general_lang WHERE def = 'mai' 030317 16:09:54 22669 Query SELECT de FROM general_lang WHERE def = 'jun' 030317 16:09:58 22669 Query SELECT de FROM general_lang WHERE def = 'jul' 030317 16:09:54 22669 Query SELECT de FROM general_lang WHERE def = 'aug' 030317 16:09:58 22669 Query SELECT de FROM general_lang WHERE def = 'sep' 030317 16:09:54 22669 Query SELECT de FROM general_lang WHERE def = 'okt' 22669 Query SELECT de FROM general_lang WHERE def = 'nov' 030317 16:09:58 22669 Query SELECT de FROM general_lang WHERE def = 'dez' I don't think, that selecting the german word for february, april and july needs more cpu than march, june or october. There is also another thing; I in one database some ISO short forms, which stands for some languages. For example: de - german, en - english, it - italian and so on. So, if one customer wants to see details of one person which works for our office, he maybe doesn't know the meaning of de, en, it. So this shortforms will also translated to his prefered language. The mysql-logs looks like this: 030317 15:20:58 22560 Query SELECT def FROM lang_sprachkuerzel WHERE isoKuerzel = 'en' 030317 15:20:57 22560 Query SELECT en FROM general_lang WHERE def = 'englisch' 22560 Query SELECT def FROM lang_sprachkuerzel WHERE isoKuerzel = 'hr' 030317 15:21:00 22560 Query SELECT en FROM general_lang WHERE def = 'kroatisch' 030317 15:20:57 22560 Query SELECT def FROM lang_sprachkuerzel WHERE isoKuerzel = 'fr' 030317 15:21:00 22560 Query SELECT en FROM general_lang WHERE def = 'franzoesisch' 030317 15:20:57 22560 Query SELECT def FROM lang_sprachkuerzel WHERE isoKuerzel = 'it' 030317 15:21:00 22560 Query SELECT en FROM general_lang WHERE def = 'italienisch' 030317 15:20:57 22560 Query SELECT def FROM lang_sprachkuerzel WHERE isoKuerzel = 'ru' 030317 15:21:00 22560 Query SELECT en FROM general_lang WHERE def = 'russisch' A PHP script split the language-string which was for this example: en,hr,fr,it,ru. Then the script initialize a mysql query (look for the definition of _en_). mysql sends back: _englisch_. Then the script initialize a translation query (look for the english word for _englisch_). mysql send back _english_. Only after this steps, the php-script starts again with _hr_ and so on. So when mysql made the logentry _SELECT en FROM general_lang WHERE def = 'englisch'_, mysql got the the query result from _SELECT def FROM lang_sprachkuerzel WHERE isoKuerzel = 'en'_. But this query result was in the past and not in the future. That's the funny thing I'm thinking of. Before I upgraded my server with the 2nd cpu, the logs where _normal_. Rgds, Peter -Original Message- From: Gelu Gogancea [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 4:48 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: mySQL activity logging on a dual prozessor maschine Hi Peter, - Original Message - From: Peter Stoehr [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Gelu Gogancea [EMAIL PROTECTED] Sent
Re: Looking for a bona fide distributed database that is open source
Hi, You make confusion between terms, CONCEPTS and TECHNOLOGIES.Is not yet invented the tools which should THINK instead of our BRAIN when must design a system...any kind of.I hope you feel the difference.For example,a new concept of databases is : the neural database system.What you will do now?To wait until some *automation* will be implemented ? Anyhow this discussion risk to be already off topic for MySQL mailing list. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Bruce Feist [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Saturday, March 15, 2003 3:26 AM Subject: Re: Looking for a bona fide distributed database that is open source Gelu Gogancea wrote: It's quite right, some SQL DataBase engines(like Oracle,DB2,msSQL) have implemented facilities for this. Distributed database can be achieved,like example, using DISTRIBUTED OBJECTS(let's say CORBA).In my understanding that means that MySQL already can be used like distributed database. Can be used like is not the same as is. Similarly, by writing software in C, you can achieve SQL and use OS files like a relational database -- that doesn't mean that flat files *are* a relational database. Finally,What i wish to say is that distributed databases depend on us to be achieved and not by the RDBMS. Yes, it can be done manually... but there are many advantages to having Is not invented yet the tools/technologies which can design the distributed capabilities built into the RDBMS itself. I've used such systems (Computer Associates' OpenIngres product), and when distributed capabilities are needed it's far superior to use a product designed for it. Some examples of the improvements are: 1) Distributed optimizer automatically takes advantage of changes to distribution structure 2) Applications can be written which are independant of distribution structure 3) Complexity of applications is reduced, resulting in lower development costs and fewer bugs 4) Transaction management spanning databases on multiple computers Paul have right and i read very carefully him message:He said (very explicit and without any doubt)that MySQL can not manage multiple tables which are hosted on different servers with one single query.For me this is not a reason to not use MySQL for distributed database system. It's one factor, though. If we relax the definition of a distributed database system to be a client-server RDBMS which can be used to build an application which can combine information from queries to multiple databases on multiple computers, as it seems you wish to do, then yes, MySQL qualifies, and has its usual advantages of low cost, open source, and speed. Depending on the project's needs, these may or may not be enough to counterbalance built-in distribution capabilities of true distributed RDBMSs. If i remember well, on the MySQL website is a link to a german company which has develop a modules which treat multiple MySQL database(hosted on different machine of course) to a logical one. If so, then using it in conjunction with MySQL would indeed create a distributed database management system. Bruce Feist - 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: Looking for a bona fide distributed database that is open source
Hi, IMHO: The distributed database is a concept which is can not be assign to the SQL engine standards(AFAIK).Stored procedures,triggers are described in the SQL 92 or SQL 99 standards. It's quite right, some SQL DataBase engines(like Oracle,DB2,msSQL) have implemented facilities for this. Distributed database can be achieved,like example, using DISTRIBUTED OBJECTS(let's say CORBA).In my understanding that means that MySQL already can be used like distributed database. Finally,What i wish to say is that distributed databases depend on us to be achieved and not by the RDBMS. Paul have right and i read very carefully him message:He said (very explicit and without any doubt)that MySQL can not manage multiple tables which are hosted on different servers with one single query.For me this is not a reason to not use MySQL for distributed database system. If i remember well, on the MySQL website is a link to a german company which has develop a modules which treat multiple MySQL database(hosted on different machine of course) to a logical one. Best Regards, Gelu P.S.This is my opinion...if you consider that i'm wrong. __ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: gerald_clark [EMAIL PROTECTED] To: Bruce Feist [EMAIL PROTECTED] Cc: MySQL List [EMAIL PROTECTED] Sent: Friday, March 14, 2003 5:33 PM Subject: Re: Looking for a bona fide distributed database that is open source No, it is not distributed. Bruce Feist wrote: Gelu Gogancea wrote: To anyone that *didn't see the forest because of the trees*. You already find it. Is MySQL really distributed, or just client-server? I've seen no indication of distributed capabilities; I'm new to MySQL, so maybe I just haven't read enough. But a distributed DBMS should be able to execute a single query which transparently accesses multiple database installations on multiple computers, possibly on multiple platforms. For instance, SELECT * from a, b ON a.id = b.id; where table 'a' is in a database on a Windows/2000 computer and table 'b' is on a Linux machine. The DBMS should keep track of which table is in which database on which computer, and its optimizer should be capable of figuring out an efficient way of resolving such queries. Can MySQL do that? Bruce Feist - 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: Looking for a bona fide distributed database that is open source
Hi, - Original Message - From: Brian Johnson [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Friday, March 14, 2003 7:14 PM Subject: Re: Looking for a bona fide distributed database that is open source My experience may be limited but I don't know of any database that will allow a single query to access mutiple database servers Yes, it is.But when you must save some money, you are pushed to find solutions with what it is on the market and which is optimal like price/performance. Some friends of mine was hasty to use like database support for their application,Oracle9i...and was very disappointed. Regards, Gelu In fact, only a few seem to be able to even access mutiple databases on the same server Frankly, I am still looking for a db that provides n way replication (this may solve some of your wishes since a local copy could be maintain on your local server) Paul DuBois ([EMAIL PROTECTED]) wrote: At 9:55 -0500 3/14/03, Bruce Feist wrote: Gelu Gogancea wrote: To anyone that *didn't see the forest because of the trees*. You already find it. Is MySQL really distributed, or just client-server? I've seen no indication of distributed capabilities; I'm new to MySQL, so maybe I just haven't read enough. But a distributed DBMS should be able to execute a single query which transparently accesses multiple database installations on multiple computers, possibly on multiple platforms. For instance, SELECT * from a, b ON a.id = b.id; where table 'a' is in a database on a Windows/2000 computer and table 'b' is on a Linux machine. The DBMS should keep track of which table is in which database on which computer, and its optimizer should be capable of figuring out an efficient way of resolving such queries. Can MySQL do that? Bruce Feist No. A given connection is a connection to a specific server. You cannot access tables managed by different servers within a single query. - Original Message - From: james [EMAIL PROTECTED] Sent: Thursday, March 13, 2003 4:44 PM I am looking for a bona fide distributed database system, like Oracle or SQLServer, but open source running on Linux. - 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 -- Brian Johnson This is where my witty signature line would be if I bothered to edit this line :) - 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: Paul, do you address this in any of your books?
Hi, You can try to use IF(),CASE() function in the SQL statement. Eg. select USERID,IF(DAY='2003-01-02',COUNT(*),0) as 2003-01-02,IF(DAY='2003-01-03',COUNT(*),0) as 2003-01-03...how_many_days_you_wishfrom YOUR_TABLES where YOUR_CONDITIONS GROUP BY DAY; Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: DANIEL GADDIS [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 14, 2003 10:40 PM Subject: Paul, do you address this in any of your books? I'm running MySql 4.0.10-gamma-max-nt-log I have 1 table like the one below... ++-+--+ | DAY| USERID | LIS_QUANTITY | ++-+--+ | 2003-01-02 | H0850A1 | 539 | | 2003-01-02 | LBBSWJR |7 | | 2003-01-02 | O0600B3 | 21 | | 2003-01-03 | H0850A1 |6 | | 2003-01-03 | H2610A1 | 51 | | 2003-01-03 | O0600B3 | 19 | | 2003-01-04 | H0850A1 |8 | | 2003-01-04 | H2610A1 | 13 | | 2003-01-04 | LBBSWJR |3 | ++-+--+ I would like a sql query to produce output like the following... +-++++ | USERID | 2003-01-02 | 2003-01-03 | 2003-01-04 | +-++++ | H0850A1 |539 | 6 | 8 | | H2610A1 || 51 | 13 | | LBBSWJR | 7 || 3 | | O0600B3 | 21 | 19 || +-++++ Can I do this just by using sql and not adding php, perl, or any other language? If mysql can't handle this with sql only, would it be able to do it once subselects or other features are available in future releases? Anyone used postgresql? I wonder if it could handle it. Any thoughts? Thanks, Daniel - 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: Paul, do you address this in any of your books?
i correct my example : select USERID,IF(DAY='2003-01-02',SUM(LIS_QUANTITY),0) as 2003-01-02,IF(DAY='2003-01-03',SUM(LIS_QUANTITY),0) as 2003-01-03...how_many_days_you_wishfrom YOUR_TABLES where YOUR_CONDITIONS GROUP BY DAY; Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Gelu Gogancea [EMAIL PROTECTED] To: DANIEL GADDIS [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, March 14, 2003 11:05 PM Subject: Re: Paul, do you address this in any of your books? Hi, You can try to use IF(),CASE() function in the SQL statement. Eg. select USERID,IF(DAY='2003-01-02',COUNT(*),0) as 2003-01-02,IF(DAY='2003-01-03',COUNT(*),0) as 2003-01-03...how_many_days_you_wishfrom YOUR_TABLES where YOUR_CONDITIONS GROUP BY DAY; Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: DANIEL GADDIS [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 14, 2003 10:40 PM Subject: Paul, do you address this in any of your books? I'm running MySql 4.0.10-gamma-max-nt-log I have 1 table like the one below... ++-+--+ | DAY| USERID | LIS_QUANTITY | ++-+--+ | 2003-01-02 | H0850A1 | 539 | | 2003-01-02 | LBBSWJR |7 | | 2003-01-02 | O0600B3 | 21 | | 2003-01-03 | H0850A1 |6 | | 2003-01-03 | H2610A1 | 51 | | 2003-01-03 | O0600B3 | 19 | | 2003-01-04 | H0850A1 |8 | | 2003-01-04 | H2610A1 | 13 | | 2003-01-04 | LBBSWJR |3 | ++-+--+ I would like a sql query to produce output like the following... +-++++ | USERID | 2003-01-02 | 2003-01-03 | 2003-01-04 | +-++++ | H0850A1 |539 | 6 | 8 | | H2610A1 || 51 | 13 | | LBBSWJR | 7 || 3 | | O0600B3 | 21 | 19 || +-++++ Can I do this just by using sql and not adding php, perl, or any other language? If mysql can't handle this with sql only, would it be able to do it once subselects or other features are available in future releases? Anyone used postgresql? I wonder if it could handle it. Any thoughts? Thanks, Daniel - 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 - 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: mySQL activity logging on a dual prozessor maschine
Hi, Maybe it's funny...but this is MySQL date/time format which is used in log files.On my MySQL servers date/time are formated in the same way. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Peter Stoehr [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 14, 2003 10:52 PM Subject: mySQL activity logging on a dual prozessor maschine Hi list, few days ago, I have installed a 2nd CPU in my ProLiant380. I recompiled a new kernel (2.4.17) for Debian 3.0. On the machine there is mySQL 3.23.52-2 installed (deb). Every thing works fine, just the logging of mySQL looks a little funny to me, especially the time: 030314 19:31:189745 Query SELECT de FROM b... 9745 Query SELECT gid FROM ... 030314 19:31:209745 Query SELECT gid FROM ... 030314 19:31:189745 Query SELECT gid FROM ... 9745 Query SELECT de FROM b... 030314 19:31:209745 Query SELECT de FROM b... 030314 19:31:189745 Query SELECT de FROM b... 030314 19:31:209745 Query SELECT de FROM b... 030314 19:31:189745 Query SELECT de FROM b... 030314 19:31:209745 Query SELECT de FROM b... 030314 19:31:189745 Query SELECT de FROM b... 030314 19:31:209745 Query SELECT de FROM b... 030314 19:31:189745 Query SELECT de FROM b... 030314 19:31:209745 Query SELECT de FROM b... 030314 19:31:189745 Query SELECT de FROM b... 9745 Query SELECT de FROM b... 9745 Query SELECT gid FROM ... 030314 19:31:209745 Query SELECT gid FROM ... The websites still grow up without errors and there is also nothing in the errorlogs. Did someone of you ever had this interesting thing? I could not find anything about that with Google or in the mailarchive here at mySQL. Thanks for your help, regards, Peter - 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: forcing mysql client to use TCP socket?
Hi, I think you have at least two ways: 1.To put the corect path to the sock file, in my.cnf configuration file. 2.To find where MySQL daemon create this file and add the argument -S to the mysql client application. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Murad Nayal [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, March 14, 2003 10:42 PM Subject: forcing mysql client to use TCP socket? Hello, how can I force mysql interactive client (actually the client library as well) to use a TCP port on the local host if I do: mysql -h localhost -u user -p --port=2000 I get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' what might be a problem is: it seems, for reasons I don't entirely understand possibly related to the network configuration on this node, I need to use the name 'localhost' rather than the actual name of the node! thanks in advance for the help Murad - 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: Looking for a bona fide distributed database that is open source
To anyone that *didn't see the forest because of the trees*. You already find it. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: james [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 13, 2003 4:44 PM Subject: Looking for a bona fide distributed database that is open source To anyone that cares I am looking for a bona fide distributed database system, like Oracle or SQLServer, but open source running on Linux. I have found one, Backplane, but as I understand it it is used for BSD Unix. If anyone can help it would be much appreciated. tx Jimmy the hat - 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: HELP mysql_server_init embedded in a DLL?
Hi, - Original Message - From: Derick Smith [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, February 28, 2003 9:09 PM Subject: Re: HELP mysql_server_init embedded in a DLL? Attempts at creating an embedded mySQL DLL for VB: I can successfully use the mysql_init() function from libmysql.lib to create a DLL for VB. However, when I use this function (in a DLL or lib)linked against the libmysqld.lib or mysqlserver.lib it crashes the VB application but not the C application. I tried hard coding the arguments and servergroups for mysql_server_init (I also used memset to initialize the strings to 0), I get the same result. The lib I create will always work with a C program, but the DLL will not work with VB. You must take care with CALLING CONVENTIONS(__stdcall).This is be one reason for crash. Does anyone have any more suggestions on how to use the embedded library in a Visual C DLL to link with VB? You can not access directly the mysql api function from VB.Are ,at least,two big problems :the VB type STRING which is UNICODE ; passing the data structure (like MYSQL which contain node lists) from VB to C or reverse.In my opinion you should make functions which will be interface between MYSQL C API and VB.Also you should make your own function to convert char to unicode and reverse.It's better if you don't use MultiByteToWideChar()...you will get a lot of unpleasure surprises. Of course you can do some improvisation (like in mysql_init or to convert a STRING into ARRAY of BYTE) but is not a solution because VB imediatly will give you some error like OUT OF MEMORY. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] Thanks Eric p.s: Email received from another individual (Thanks!!): Put the libMySql.dll in the wint\system32 directory (or in the directory where your executable is!) In vb, I use this one the declares: Public Declare Function mysql_init Lib libmySQL (ByVal lMYSQL As Long) As Long Public Declare Function mysql_real_connect Lib libmySQL _ (ByVal lMYSQL As Long, _ ByVal sHostName As String, _ ByVal sUserName As String, _ ByVal sPassword As String, _ ByVal sDbName As String, _ ByVal lPortNum As Long, _ ByVal sSocketName As String, _ ByVal lFlags As Long) As Long Public Function OpenConnection(ByVal sHostName As String, _ ByVal sUserName As String, _ ByVal sPassword As String, _ ByVal sDbName As String, _ Optional ByVal lPortNum As Long = 3306, _ Optional ByVal lFlags As MYSQL_FLAG) As MYSQL_CONNECTION_STATE mlMYSQL = mysql_init(mlMYSQL) If mlMYSQL = 0 Then no connection handler Else 'connect to server If mysql_real_connect(mlMYSQL, msHostname, msUsername, msPassword, msDbName, mlPortNum, , mlFlags) = 0 Then ' oops Else 'connection established ... state is now open End If End If 'setup the return value End Function I myselve created an dll (in vb) which encapsulates all the stuff to connect to the database, use recordsets, (as close as possible to the ADO object model: so with connection, recordset - objects, bookmarks, fields, ...) Hope this helps. From: Gelu Gogancea [EMAIL PROTECTED] To: Derick Smith [EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED] Subject: Re: HELP mysql_server_init embedded in a DLL? Date: Fri, 28 Feb 2003 14:40:31 +0200 Hi, - Original Message - From: Derick Smith [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, February 27, 2003 10:33 PM Subject: Re: HELP mysql_server_init embedded in a DLL? I am posting this again, in hope that I will get a response. I tried doing the following (see VB code below. I got this code from another site): I get the same error message as if I was calling the DLL I created in C which calls mysql_server_init. Is it impossible to call this function from VB or embedded in another DLL from VB? Can I only use the embedded mysql library in C or C++? Thanks Eric Public Declare Function mysql_server_init Lib C:\mysql40\source\lib_release\libmysqld.dll _ (ByVal argc As Long, _ ByVal argv As Byte, _ ByVal groups As Byte) As Long Private Sub cmdmysq_server_init_Click() Dim argv(0) As Byte, groups(0) As Byte Dim i As Long argv(0) = Asc(0) groups(0) = Asc(0) i = mysql_server_init(0, argv, groups) End Sub In my opinion,this will never work because argv and groups are pointed to array which have a pointer char
Re: HELP mysql_server_init embedded in a DLL?
Hi, - Original Message - From: Derick Smith [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, February 27, 2003 10:33 PM Subject: Re: HELP mysql_server_init embedded in a DLL? I am posting this again, in hope that I will get a response. I tried doing the following (see VB code below. I got this code from another site): I get the same error message as if I was calling the DLL I created in C which calls mysql_server_init. Is it impossible to call this function from VB or embedded in another DLL from VB? Can I only use the embedded mysql library in C or C++? Thanks Eric Public Declare Function mysql_server_init Lib C:\mysql40\source\lib_release\libmysqld.dll _ (ByVal argc As Long, _ ByVal argv As Byte, _ ByVal groups As Byte) As Long Private Sub cmdmysq_server_init_Click() Dim argv(0) As Byte, groups(0) As Byte Dim i As Long argv(0) = Asc(0) groups(0) = Asc(0) i = mysql_server_init(0, argv, groups) End Sub In my opinion,this will never work because argv and groups are pointed to array which have a pointer char*(*); But anyhow...if you wish to try again this formula, must declare argv and groups ByRef because VB is responsable for the stack and the variable must be initialized before using like argument in function.Since argv and groups are byte is a non-sense to use ASC(). I'm very pessimistic that will be work. From: Derick Smith [EMAIL PROTECTED] To: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: mysql_server_init embedded in a DLL? Date: Wed, 26 Feb 2003 14:34:28 + Hi! I am trying to create a DLL that will hide embedded mySQL functions for use with VB. I am using mysqlserver.lib. I am able to compile and execute the following code. This has to be done in C because VB is too slow :-( If mysql_server_init function is run in the DLL from Visual Basic. I get the following error message: ..referenced memory at 0x00. The memory could not be read. Without the mysql_server_init function it will run correctly. It will also run correctly when this is compiled as a .lib file linked to a C program. Is it possible to embed mysql_server_init in a DLL? (So the DLL can be used in VB) Thanks in advance for any responses. Thanks Eric header1.h #define GPAPI __stdcall header2.h typedef unsigned long DBS; #define NULLDBS (DBS)0 api.c GPAPI DBS dbNewSet (char * basedir, char * datadir, char * dbname) { return NewSet(basedir,datadir,dbname); } newset.c extern DBS NewSet(char * basedir, char * datadir, char * dbname) { DBSET* pSet = CreateSet(); char *args[3]; char strArgs[3][1024]; I guess some problems can be elimanted if you initialize the variables which are declared or if you allocate some memory. Anyhow you can use '\0' - termination string to be sure that you don't have *other garbage* after your string.This *garbage* can influence the lenght of the string.Bad thing. int iRtn; int argc = 3; strcpy(strArgs[0],this_program); sprintf(strArgs[1],--basedir=%s,basedir); sprintf(strArgs[2],--datadir=%s,datadir); args[0]= strArgs[0]; args[1]= strArgs[1]; args[2]= strArgs[2]; /* If I comment out this line of code, the DLL will run correctly. If mysql_server_init function is run in the DLL. I get the following error message: ..referenced memory at 0x00. The ...this means that one of your variables is NULL.This error occur because you don't *catch* the right pointer.By using equal sign you pass the pointer to lvalue and not the value.At the address of pointer you can find the value. memory could not be read */ iRtn = mysql_server_init(3, args, server_groups); if (pSet ==0 ) return NULLDBS; memset(pSet, 0, sizeof(DBSET)); /* Zero the structure.*/ pSet-size = sizeof(DBSET);/* Assign structure size. */ pSet-magic = DBS_MAGIC; /* Assign magic number. */ return (DBS)(void*)pSet; } If you have a little patience (maybe a week or two...i try to find some available time for this) a new version of GMySQL(An interface between MYSQL C API function and VB or other development platform for Windows) will be released.This new version, will contain the implementation of the new replication functions and also will be able to work with libmysqld. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail - 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
Re: REPOST: MySQL 3.23.54 is a buggy, crashing piece of crap.
Hi Benjamin, I hope you have a nice day. - Original Message - From: Benjamin Pflugmann [EMAIL PROTECTED] To: Jason Maskell [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, February 17, 2003 1:14 PM Subject: Re: REPOST: MySQL 3.23.54 is a buggy, crashing piece of crap. On Mon 2003-02-17 at 03:38:07 -0600, [EMAIL PROTECTED] wrote: Reply when you have a job, dumbass. I have a system that makes more in a week than you make in a year crashing because of this buggy piece of shit. If a system supposedly making millions a year is unstable you are a fool that you haven't solved it already using your advanced support contract (http://www.mysql.com/support/), that you surely have. I don't give a rats ass what your worthless opinion on my post is. Now fuck off, dumbass. Yeah. That lack of respect is exactly why I refused to read your ...you can not ask respect from this man which already make the prove that have no BRAIN. original post about the problem to the end. As I said, that is a list of volunteers and your attitude surely doesn't help you to get answers. Bye, Regards, Benjamin. Gelu - Original Message - From: Benjamin Pflugmann [EMAIL PROTECTED] To: Jason Maskell [EMAIL PROTECTED] Sent: Monday, February 17, 2003 3:35 AM Subject: Re: REPOST: MySQL 3.23.54 is a buggy, crashing piece of crap. On Mon 2003-02-17 at 02:40:57 -0600, [EMAIL PROTECTED] wrote: Oh grow up. Exactly the kind of reply I expected from you. -- [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: question
Hi, Already work (very well) on Win98. You can download it from http://www.mysql.com/downloads/mysql-4.0.html Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Smita Marda [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 03, 2003 1:25 PM Subject: question technical question- The MySQL-4.0-mysql-4.0.6-gamma-win works on winNT will it work on win98? Plz reply me immediately.. __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.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 - 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: Replication Problems/Questions
Hi, - Original Message - From: Guddack Thorsten ICM MP SCM GO 21 [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 30, 2003 3:44 PM Subject: Replication Problems/Questions Hi List I'm using 2 WinNT-Servers, Sp6 with mysql 4.0.5. max-nt. I ve setup a replication between these two servers as discribed in the manual and some small problems comes up. Maybe someone can give me some help. 1.) On the Master I create a user repl with the rights 'replication slave'. On the slave I used a user with all possible rights. Starting the replication with 'reset slave', 'change master to.' and 'start slave', I get an error: Show slave status says Slave_IO_running no and some entry in mysql.err. This Problem I could solve using a user in 'change master to ' that has also admin rights. What could cause the problem? 2.) The more important Problem: If the replication is running, and I try to replicate a table where data was inserted on the master with 'LOAD DATA INFILE...' or 'LOAD DATA LOCAL INFILE' the server process on the slaves crushes The files on the master, for LOAD DATA.were still there. Any Ideas? IMHO: ...this can happening because on the slave you don't have(...i guess) the file for LOAD DATA.By REPLICATION the slave trying to copy every movement of the master and not the data itself.This means that slave trying to execute LOAD DATA INFILE YOUR_PATH_TO_FILE .and not copy the data from the master. At Last one question: - could anyone explain me the meaning of the fields from show slave status ( I'm looking for a way to decide if the slave has replicated all the data from the master ) Best regards Best Regards, Gelu [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: copying a row
Hi - Original Message - From: W. Enserink [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 30, 2003 4:34 PM Subject: copying a row Hi all, Im in need of some tps. I want to copy a row in a table to a new row in the same table except for the unique ID. Is there some mysql statement for this? It should work something like : set @a:=''; set @b:='' set @n:=''; set a variable for each item which you need to insert in to table. select @a:=ITEM1,@b:=ITEM2...@n:ITEMn from your_table where. insert into your_table values(@a,@b@n) Regards, Gelu regards Wilbert - Pas de Deux Van Mierisstraat 25 2526 NM Den Haag tel 070 4450855 fax 070 4450852 http://www.pdd.nl [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: how to get the Nth record of a result ?
Hi, select * from table where condition LIMIT HOW_MANY_RESULT_YOU_WISH; Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: alx [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 27, 2003 12:17 PM Subject: how to get the Nth record of a result ? HI all I'm trying to get the Nth record of a query which i don't know nothing but the table name. I mean something like select * from table where condition . give me the Nth result; I hope someone can help me. TIA Bye Alx - 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: SELECTing across a Network
Hi, For the moment you can't. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Isaac Anietye Inyang [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 27, 2003 4:23 PM Subject: SELECTing across a Network Hello Please can someone tell me how to run a SELECT between databases on a network. I want to SELECT some data from a mySQL server named PC1 to a table on a second mySQL server named PC2. Thanks in advance. Isaac Anietye Inyang Systems Engineer Cooperative Information Network Obafemi Awolowo University Ile-Ife - 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
Strange behaviuor in ver. 4.1(maybe dusty)
Hi, Something very strange was happened on my production server where i have mounted MySQL ver. 4.1 (latest pull on Jan 25, 12:00 GMT) Unfortunatelly i'm not able(a...i didn't start with --log) to reproduce the exact sequence of queries which was send to the server. MySQL was down on this query: SELECT * FROM stoc LIMIT 1; ...where table stoc is MyISAM and has aprox.150.000 of rows(stoc.MYD -14 MB,stoc.MY-23 MB). IMHO: I'm sure that is nothing wrong with this query because after mysql daemon was restarting, it was successfully executed. Anyhow,mysqld log said: == Alarm status: Active alarms: 1 Max used alarms: 3 Next alarm time: 28765 cNewCount: 45 Memory that was not free'ed (402786381 bytes): 1024 bytes at 0x008424df8, allocated at line 79 in 'hash_filo.h' 8152 bytes at 0x008882a88, allocated at line 2368 in 'sql_acl.cc' 8 bytes at 0x0088b1ac0, allocated at line 277 in 'array.c' 12 bytes at 0x008882a58, allocated at line 277 in 'array.c' 56 bytes at 0x0088b1b68, allocated at line 277 in 'array.c' 368 bytes at 0x0088b1930, allocated at line 277 in 'array.c' 968 bytes at 0x00889f1b0, allocated at line 94 in 'my_alloc.c' 24 bytes at 0x0088b1b30, allocated at line 277 in 'array.c' 2048 bytes at 0x0088b05d0, allocated at line 79 in 'hash_filo.h' 8 bytes at 0x0088af718, allocated at line 545 in 'sql_db.cc' 16384 bytes at 0x0088b67c8, allocated at line 154 in 'sql_string.h' 4112 bytes at 0x0088b5798, allocated at line 40 in 'my_alloc.c' 8208 bytes at 0x0088b3768, allocated at line 40 in 'my_alloc.c' 5 bytes at 0x0088b3740, allocated at line 201 in 'sql_parse.cc' 11 bytes at 0x00889c038, allocated at line 517 in 'sql_parse.cc' 16391 bytes at 0x0088ab5e8, allocated at line 90 in 'net_serv.cc' 84 bytes at 0x00889bbc8, allocated at line 129 in 'vio.c' 32768 bytes at 0x0088a35c8, allocated at line 178 in 'mf_iocache.c' 3 bytes at 0x00889bba0, allocated at line 66 in 'mf_cache.c' 6 bytes at 0x00889bb78, allocated at line 65 in 'mf_cache.c' 128 bytes at 0x00889bad8, allocated at line 147 in 'sql_class.cc' 3072 bytes at 0x0088a29a8, allocated at line 283 in 'sql_list.h' 256 bytes at 0x008887ce8, allocated at line 132 in 'sql_udf.cc' 496 bytes at 0x008878dd0, allocated at line 54 in 'queues.c' 800 bytes at 0x008878988, allocated at line 318 in 'sql_parse.cc' 8136 bytes at 0x0088769a0, allocated at line 94 in 'my_alloc.c' 8136 bytes at 0x0088749b8, allocated at line 94 in 'my_alloc.c' 248 bytes at 0x0088748a0, allocated at line 43 in 'ft_stopwords.c' 18599440 bytes at 0x059359020, allocated at line 119 in 'mf_keycache.c' 384053248 bytes at 0x042515020, allocated at line 117 in 'mf_keycache.c' 256 bytes at 0x008874780, allocated at line 814 in 'ha_innodb.cc' 24 bytes at 0x008422f20, allocated at line 700 in 'ha_innodb.cc' 1024 bytes at 0x008425218, allocated at line 209 in 'repl_failsafe.cc' 4224 bytes at 0x008423cb8, allocated at line 54 in 'sql_base.cc' 128 bytes at 0x008422710, allocated at line 49 in 'my_bitmap.c' 530 bytes at 0x008422c50, allocated at line 599 in 'charset.c' 672 bytes at 0x008422208, allocated at line 1402 in 'set_var.cc' 128 bytes at 0x00841e658, allocated at line 1621 in 'item_func.cc' 13411 bytes at 0x00841ed80, allocated at line 83 in 'derror.cc' 6 bytes at 0x00841e2d8, allocated at line 4947 in 'mysqld.cc' 6 bytes at 0x00841e2b0, allocated at line 51 in 'mf_tempdir.c' 4 bytes at 0x00841e288, allocated at line 32 in 'mf_tempdir.c' 456 bytes at 0x00841eb98, allocated at line 94 in 'my_alloc.c' 456 bytes at 0x00841e9b0, allocated at line 94 in 'my_alloc.c' 456 bytes at 0x00841e7c8, allocated at line 94 in 'my_alloc.c' Maximum memory usage: 409950738 bytes (400343k) 030126 23:47:13 /mysql-4.1/libexec/mysqld: Normal shutdown 030126 23:47:13 InnoDB: Starting shutdown... 030126 23:47:14 InnoDB: Shutdown completed 030126 23:48:59 mysqld started 030126 23:49:03 InnoDB: Started /mysql-4.1/libexec/mysqld: ready for connections = Maybe this help. Best regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [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:ALTER TABLE (MySQL 4.1)
Hi Sergei, I just finish to compile the latest source code (Jan 25) from http://mysql.bkbits.net/mysql-4.1 The problem persist. Georg has right i was trying to alter table when the primary key was already defined and i was trying: ALTER TABLE cmdlivrare MODIFY IDCMD INT(9) AUTO_INCREMENT; From mysqld.log: thd=0x865c0e0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xbe7fd7d8, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x8114188 0x40039951 0x8167b06 0x8167413 0x8180a14 0x81825d8 0x812138f 0x8124d7d 0x811f9a7 0x811f612 0x811ef8d 0x4003376e 0x402687da New value of fp=(nil) failed sanity check, terminating stack trace! ... Some pointers may be invalid and cause the dump to abort... thd-query at 0x865f408 = alter table cmdlivrare modify IDCMD INT(9) AUTO_INCREMENT ...and from resolve_stack_dump: 0x8114188 handle_segfault + 416 0x40039951 _end + 936095697 0x8167b06 _Z11pack_fieldsiR4ListI12create_fieldE + 170 0x8167413 _Z16rea_create_tableP3THDPcP24st_ha_create_informationR4ListI12create_fieldE jP6st_key + 883 0x8180a14 _Z18mysql_create_tableP3THDPKcS2_P24st_ha_create_informationR4ListI12create_ fieldERS5_I3KeyEbbj + 2500 0x81825d8 _Z17mysql_alter_tableP3THDPcS1_P24st_ha_create_informationP13st_table_listR4 ListI12create_fieldERS6_I3KeyERS6_I10Alter_dropERS6 + 2736 0x812138f _Z21mysql_execute_commandP3THD + 2803 0x8124d7d _Z11mysql_parseP3THDPcj + 221 0x811f9a7 _Z16dispatch_command19enum_server_commandP3THDPcj + 859 0x811f612 _Z10do_commandP3THD + 110 0x811ef8d handle_one_connection + 813 0x4003376e _end + 936070638 0x402687da _end + 938384986 Best regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Sergei Golubchik [EMAIL PROTECTED] To: Gelu Gogancea [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, January 25, 2003 3:48 AM Subject: Re: BUG:ALTER TABLE (MySQL 4.1) Hi! On Jan 24, Gelu Gogancea wrote: Hi, I guess is as a bug in ALTER TABLE with MySQL 4.1,compiled from BK TREE on 2003-01-22. Table schema : CREATE TABLE cmdlivrare(IDCMD INT(9) NOT NULL PRIMARY KEY DEFAULT 2000,mUser CHAR(16),Dep CHAR(4),IDCLI INT(16),FactExt CHAR(20),LivrFinish SMALLINT(1),DataIntro DATE,DataIese DATE,INDEX(Dep),INDEX(FactExt),INDEX(IDCLI),INDEX(mUser),INDEX(LivrFinish),I NDEX(DataIntro),INDEX(DataIese)); I wish to alter this table and modify the definition of IDCMD to IDCMD INT(9) AUTO_INCREMENT NOT NULL PRIMARY KEY DEFAULT 3 For this i do : alter table cmdlivrare modify IDCMD INT(9) AUTO_INCREMENT NOT NULL PRIMARY KEY DEFAULT 3; No crash for me on a recent bk tree (Jan 24, that is). Try a fresh pull. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - 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: BUG:ALTER TABLE (MySQL 4.1)
Hi Sinisa, I guess is no need because the problem it's solved now.I don't wish to happened like the last time...and now, i'm little more carrefully. You have right.The data on table was corrupt becuase of previous source code (bk pull on Jan 22).I make ten's of test whith this code based on this problem. Today (Jan 25) i make pull again (Sergei suggest me today) and now it work well after when i fixed the table. Best regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Sinisa Milivojevic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, January 25, 2003 6:20 PM Subject: Re: BUG:ALTER TABLE (MySQL 4.1) Gelu Gogancea writes: Hi Sergei, I just finish to compile the latest source code (Jan 25) from http://mysql.bkbits.net/mysql-4.1 The problem persist. Georg has right i was trying to alter table when the primary key was already defined and i was trying: ALTER TABLE cmdlivrare MODIFY IDCMD INT(9) AUTO_INCREMENT; From mysqld.log: Best regards, Gelu _ G.NET SOFTWARE COMPANY Hi! Was it an empty table ir it had rows. Was it corrupt prior to being ALTERed ?? Please send us a dump of the table or if it is big, upload it to the usual place. -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com Join MySQL Users Conference and Expo: http://www.mysql.com/events/uc2003/ - 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: Client History
Hi, If you start the mysql daemon with option --log then you will find the file with all querys which was executed, in the data directory. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] To: Darren Young [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, January 25, 2003 6:04 PM Subject: Re: Client History Darren, Where does the mysql client store the query history information? .mysql_history in your home directory, for example. Under Win it doesn't get stored, AFAIK. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Darren Young [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, January 25, 2003 12:23 AM Subject: Client History Where does the mysql client store the query history information? I'm referring to the information that it pulls up when you hit the up or down arrow keys. There was a rather complex query that I came up with a while ago and don't feel like 'up arrowing' all night... Thanks, Darren Young mysql, 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 - 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: Writing program to communicate with remote internet MySQL server?
Hi, If i undertsand well you wish to make an application which to synchronization data between your local MySQL with the MySQL which is on the Web Server. I think you must have distinct connection to be able to pass the data from one server to other. I think you can do this with VB(..using ADO-MyODBC) or Perl.I don't know about Python or Ruby if have facility to accesing MySQL using MyODBC or if have something like MySQL database driver. Another option for VB is to use GMySQL (MySQL API for VB).In samples you will find a code which is near with your requirment. You can download it from : http://www.a1vbcode.com/app.asp?ID=1764 I hope it help. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: M Wells [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 24, 2003 11:32 AM Subject: RE: Writing program to communicate with remote internet MySQL server? Hi Gelu, I agree with you, and it's an excellent suggestion. On the other hand, I am generally interested in whether or not it's within my abilities / available toolset to do this, and it would allow me to develop far more specific / personalised 'synchronisation' processes. Anyone have any thoughts on how this could be achieved? Regards and best wishes, Murray Wells -Original Message- From: Gelu Gogancea [mailto:[EMAIL PROTECTED]] Sent: Friday, 24 January 2003 7:24 AM To: Murray Wells; [EMAIL PROTECTED] Subject: Re: Writing program to communicate with remote internet MySQL server? Hi, IMHO: I think the better way is to use replication between your local MySQL server and MySQL from the Web Server. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Murray Wells [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 23, 2003 4:30 PM Subject: Writing program to communicate with remote internet MySQL server? Hello All, For some time I've been wondering if it's possible to write a program that can automatically check my local MySQL server, create a recordset containing any new or updated records found in my local table(s) since the last check, and upload those new / updated records to the MySQL server my web site uses at phpwebhosting.com. My background is VB / VBA, but I also have access to Perl, Python and Ruby. I'm wondering if anyone can tell me if it's possible, using one of these languages, to connect to a remote MySQL server over the internet and to manipulate tables on the remote server as though they were recordset objects, similarly to how you might achieve this on a local server using MyODBC? The end goal is to develop a program I can fire as a Windows XP scheduled task to synchronize the remote database with the local one. Any help appreciated! Regards and best wishes, M Wells - 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 - 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: Bind Variables.]
Hi, With MySQL you can use variables which are represented using @ character. You can not use this variable like in Oracle or DB2 because ,for the moment, MySQL didn't have necessary tools which can handle like bind, this variables. I guess you can make some improvisations to suit at your needs. For example : If you wish to store an entire row(...or selective items from one row) in the one variable and after this to insert in other table: @a:=''; /* initialise the variable a*/ select @a:=CONCAT(FIRST_ITEM,',',SECOND_ITEM,',',THIRD_ITEM...etc) from YOUR_TABLES where SOME_CONDITIONS. insert into other_table values(MID(@,POSITION_OF1-st_ITEM,LENGTH),MID(@,POSITION_2-nd,LENGTH)etc ) Also, this can be replaced very well,if you use INSERT...SELECT statement. Another example which can help you to avoid bind array variable and also to avoid FOREACH() function is: insert into YOUR_TABLES SET YOUR_1-st_FIELD=1-st_ITEM,YOUR_2-nd_FIELD=2-nd_ITEM...etc select IF(1-st_ITEM SOME_FILTERING_CONDITIONS,RETURN_IF_TRUE,RETURN_IF_FALSE)...etc from OTHER_TABLE where CONSTRAINT_CONDITION... I hope it help, Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Alvaro Avello [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 24, 2003 1:54 PM Subject: [Fwd: Bind Variables.] Hi everybody: I 'm actually having an problem trying to mygrate to mysql. it's true that mysql does not support bind variables ? . Actually the development in my company is over Centura team developer connected to Centura Sqlbase , and the code of the aplications is widely using bind variables . there is a workaround for this ? there is a posibility that in the future releases of mysql bind variables will be supported ?' thanks in advance. Alvaro. - 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
BUG:ALTER TABLE (MySQL 4.1)
Hi, I guess is as a bug in ALTER TABLE with MySQL 4.1,compiled from BK TREE on 2003-01-22. Table schema : CREATE TABLE cmdlivrare(IDCMD INT(9) NOT NULL PRIMARY KEY DEFAULT 2000,mUser CHAR(16),Dep CHAR(4),IDCLI INT(16),FactExt CHAR(20),LivrFinish SMALLINT(1),DataIntro DATE,DataIese DATE,INDEX(Dep),INDEX(FactExt),INDEX(IDCLI),INDEX(mUser),INDEX(LivrFinish),I NDEX(DataIntro),INDEX(DataIese)); I wish to alter this table and modify the definition of IDCMD to IDCMD INT(9) AUTO_INCREMENT NOT NULL PRIMARY KEY DEFAULT 3 For this i do : alter table cmdlivrare modify IDCMD INT(9) AUTO_INCREMENT NOT NULL PRIMARY KEY DEFAULT 3; MySQL daemon got signal 11. MySQL log said: = mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=402653184 read_buffer_size=2093056 sort_buffer_size=2097144 max_used_connections=0 max_connections=100 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 802415 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x865b0a0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xbe7fd6f8, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x8114078 0x40039951 0x816785a 0x8167167 0x81807ac 0x8182370 0x8121257 0x8124c45 0x811f8a7 0x811f4fe 0x811ee79 0x4003376e 0x402687da New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x865e3c8 = alter table cmdlivrare modify IDCMD INT(9) AUTO_INCREMENT NOT NULL PRIMARY KEY DEFAULT 3 thd-thread_id=1 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 1 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid. The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash. = resolve_stack_dump succesfully does : 0x8114078 handle_segfault + 416 0x40039951 _end + 936099857 0x816785a _Z11pack_fieldsiR4ListI12create_fieldE + 170 0x8167167 _Z16rea_create_tableP3THDPcP24st_ha_create_informationR4ListI12create_fieldE jP6st_key + 883 0x81807ac _Z18mysql_create_tableP3THDPKcS2_P24st_ha_create_informationR4ListI12create_ fieldERS5_I3KeyEbbj + 2500 0x8182370 _Z17mysql_alter_tableP3THDPcS1_P24st_ha_create_informationP13st_table_listR4 ListI12create_fieldERS6_I3KeyERS6_I10Alter_dropERS6 + 2736 0x8121257 _Z21mysql_execute_commandP3THD + 2803 0x8124c45 _Z11mysql_parseP3THDPcj + 221 0x811f8a7 _Z16dispatch_command19enum_server_commandP3THDPcj + 879 0x811f4fe _Z10do_commandP3THD + 110 0x811ee79 handle_one_connection + 813 0x4003376e _end + 936074798 0x402687da _end + 938389146 I has the bad inspiration to compile without debug option.I try to recompile now and i will try to study to see what happened. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [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:ALTER TABLE (MySQL 4.1)
...like usually i forget some details: Table type is MyISAM and was created with MySQL ver 3.23.47 But if i create the table with ver.4.1 the behaviour is the same. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Gelu Gogancea [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, January 24, 2003 8:49 PM Subject: BUG:ALTER TABLE (MySQL 4.1) Hi, I guess is as a bug in ALTER TABLE with MySQL 4.1,compiled from BK TREE on 2003-01-22. Table schema : CREATE TABLE cmdlivrare(IDCMD INT(9) NOT NULL PRIMARY KEY DEFAULT 2000,mUser CHAR(16),Dep CHAR(4),IDCLI INT(16),FactExt CHAR(20),LivrFinish SMALLINT(1),DataIntro DATE,DataIese DATE,INDEX(Dep),INDEX(FactExt),INDEX(IDCLI),INDEX(mUser),INDEX(LivrFinish),I NDEX(DataIntro),INDEX(DataIese)); I wish to alter this table and modify the definition of IDCMD to IDCMD INT(9) AUTO_INCREMENT NOT NULL PRIMARY KEY DEFAULT 3 For this i do : alter table cmdlivrare modify IDCMD INT(9) AUTO_INCREMENT NOT NULL PRIMARY KEY DEFAULT 3; MySQL daemon got signal 11. MySQL log said: = mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=402653184 read_buffer_size=2093056 sort_buffer_size=2097144 max_used_connections=0 max_connections=100 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 802415 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x865b0a0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xbe7fd6f8, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x8114078 0x40039951 0x816785a 0x8167167 0x81807ac 0x8182370 0x8121257 0x8124c45 0x811f8a7 0x811f4fe 0x811ee79 0x4003376e 0x402687da New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x865e3c8 = alter table cmdlivrare modify IDCMD INT(9) AUTO_INCREMENT NOT NULL PRIMARY KEY DEFAULT 3 thd-thread_id=1 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 1 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid. The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash. = resolve_stack_dump succesfully does : 0x8114078 handle_segfault + 416 0x40039951 _end + 936099857 0x816785a _Z11pack_fieldsiR4ListI12create_fieldE + 170 0x8167167 _Z16rea_create_tableP3THDPcP24st_ha_create_informationR4ListI12create_fieldE jP6st_key + 883 0x81807ac _Z18mysql_create_tableP3THDPKcS2_P24st_ha_create_informationR4ListI12create_ fieldERS5_I3KeyEbbj + 2500 0x8182370 _Z17mysql_alter_tableP3THDPcS1_P24st_ha_create_informationP13st_table_listR4 ListI12create_fieldERS6_I3KeyERS6_I10Alter_dropERS6 + 2736 0x8121257 _Z21mysql_execute_commandP3THD + 2803 0x8124c45 _Z11mysql_parseP3THDPcj + 221 0x811f8a7 _Z16dispatch_command19enum_server_commandP3THDPcj + 879 0x811f4fe _Z10do_commandP3THD + 110 0x811ee79 handle_one_connection + 813 0x4003376e _end + 936074798 0x402687da _end + 938389146 I has the bad inspiration to compile without debug option.I try to recompile now and i will try to study to see what happened. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [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
Re: gethostbyname_r() (un)bug in MySQL source build
Hi, IMHO: I think if you use autoheader it's possible to fix that according with your glibc/compiler version.Also (...from what i remember what i saw in the source code) is used macros for checking GLIBC2 style. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Michael Bacarella [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 23, 2003 4:23 PM Subject: gethostbyname_r() (un)bug in MySQL source build Hope everyone's having fun at LinuxWorld. I couldn't find any discussion of a solution for this (according to Google, mysql.com search), other than at least a dozen reports from people having trouble with it. The bug is that the proper error is not reported and at least I was sent on a wild goose chase. In attempting to build MySQL 3.23.54a on a fresh Red Hat 8.0: libmysql.c: In function `mysql_real_connect': libmysql.c:1325: warning: passing arg 5 of `gethostbyname_r' from incompatible pointer type libmysql.c:1325: too few arguments to function `gethostbyname_r' libmysql.c:1325: warning: assignment makes pointer from integer without a cast Very odd. What ends up being generated in include/my_net.h is: #define my_gethostbyname_r(A,B,C,D,E) gethostbyname_r((A),(B),(C),(D), When it should be generating: struct hostent *my_gethostbyname_r(const char *name,struct hostent *result, char *buffer,int buflen, int *h_errnop); It does not get generated because ./configure does not detect GLIBC2's gethostbyname_r() even though it is there, and it is the six argument version that ends up being called with five. The problem actually has nothing to do with gethostbyname_r(). The problem is that g++ is not installed. The configure test program for gethostbyname_r() type depends on a C++ compiler, and ./configure is not halting the process for lack of C++ compiler: configure:19299: checking style of gethostname_r routines configure:19347: g++ -c -O -DDBUG_OFFconftest.cc 5 ./configure: line 1: g++: command not found configure:19350: $? = 127 configure: failed program was: #line 19316 configure #include confdefs.h #undef inline #if !defined(SCO) !defined(__osf__) !defined(_REENTRANT) #define _REENTRANT #endif #include pthread.h #include sys/types.h #include sys/socket.h #include netinet/in.h #include arpa/inet.h #include netdb.h #ifdef F77_DUMMY_MAIN # ifdef __cplusplus extern C # endif int F77_DUMMY_MAIN() { return 1; } #endif int main () { int skr; skr = gethostbyname_r((const char *) 0, (struct hostent*) 0, (char*) 0, 0, (struct hostent **) 0, skr); ; return 0; } Solution? Tell the user there is no C++ compiler if there is no C++ compiler. -- Michael Bacarella 24/7 phone: 646 641-8662 Netgraft Corporation http://netgraft.com/ unique technologies to empower your business Finger email address for public key. Key fingerprint: C40C CB1E D2F6 7628 6308 F554 7A68 A5CF 0BD8 C055 - 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: Writing program to communicate with remote internet MySQL server?
Hi, IMHO: I think the better way is to use replication between your local MySQL server and MySQL from the Web Server. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Murray Wells [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 23, 2003 4:30 PM Subject: Writing program to communicate with remote internet MySQL server? Hello All, For some time I've been wondering if it's possible to write a program that can automatically check my local MySQL server, create a recordset containing any new or updated records found in my local table(s) since the last check, and upload those new / updated records to the MySQL server my web site uses at phpwebhosting.com. My background is VB / VBA, but I also have access to Perl, Python and Ruby. I'm wondering if anyone can tell me if it's possible, using one of these languages, to connect to a remote MySQL server over the internet and to manipulate tables on the remote server as though they were recordset objects, similarly to how you might achieve this on a local server using MyODBC? The end goal is to develop a program I can fire as a Windows XP scheduled task to synchronize the remote database with the local one. Any help appreciated! Regards and best wishes, M Wells - 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: Hi and why
Hi, Indeed...this happend in both main version of MySQL (ver. 3.x and 4.0.x) However ,if you use : select * from test_table where NAME='2'; you will have the correct result. Regards, Gelu ___ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Valdir Stiebe Junior [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 21, 2003 8:47 PM Subject: Re: Hi and why I don't know why it returns the first two rows, but (assuming you didn't really end your query with two question marks) what error are you expecting to occur? I didn't end my query with the two question marks. :) And if i put 0 instead of (2 or any different of zero) after the equal sign the sql return nothing. (better than returning garbage) I was expecting something like 'Column NAME isn't of type integer'. - 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: Connection ms access to mysql
Hi, I think is better to export your each table from Access to a .txt formatted file...fields separated by ',' and end_of_line by ';'.It's better to avoid Cr or CrLf. Copy the .txt files into MySQL server host in a directory where MySQL have reading rights. And after this you can import in your MySQL tables using (...this can be a way) LOAD DATA... E.g: LOAD DATA INFILE 'the_path_to_one_of_txt_files' INTO TABLE one_of_table_to_load FIELDS TERMINATED BY ',' LINES TERMINATED BY ';'; This it should be work. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: mc 02 [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, January 18, 2003 7:51 AM Subject: Re: Connection ms access to mysql Hi Bob hall, I do apologize for being unclear in my previous message. To answer your question: Does the MySQL server run on your FreeBSD system? Yes MySQL runs prefectly with my FreeBSD 4.6 system. How are you trying to export your Jet tables? I assume that's what you mean when you refer to files. If you actually want to put your mdb files on FreeBSD, then you should be asking the freebsd-questions list about Samba. Im still unsure how im exporting the tables. What i want to do is exporting all the tables in the mdb files to mysql database and i dont know how to go about it. Thanx p.s: I'm looking into Samba as u mentioned previously. Regards MC -- __ Sign-up for your own FREE Personalized E-mail at Mail.com http://www.mail.com/?sr=signup Meet Singles http://corp.mail.com/lavalife - 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: Whats the best way to manage 'generic two-way relationships'?
Hi, - Original Message - From: Hoffman, Geoffrey [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 17, 2003 7:01 PM Subject: Whats the best way to manage 'generic two-way relationships'? I couldn't think of a better term for what I want to do... I am building a CMS for news stories. Often news stories are related to each other, or need to be grouped by content. I need a simple way to manage storyId relationships - in both directions. Thinking about the business logic to implement this is a bit confusing, because if you say story f is related to story b, and b is already related to c,d,e, then do I need aditional records for f-c, f-d, f-e? It gets worse if story f is related to g,h,i, and k is related to l,m,n and then you relate f to k... then you'd have to insert additional 9 (or would it be 12) records for the cross-product of all combinations of all the relationships. Or would you? And I can't think of how you'd handle this at the DB level (I'd have to loop in PHP and have 9 inserts?) My first thought was: CREATE TABLE storyRelationship( relIdINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, storyId1 INT UNSIGNED NOT NULL INDEX, storyId2 INT UNSIGNED NOT NULL INDEX In my opinion, is not too well(i don't wish to said it's a big mistake).In this way you will not be able to have data flexibility.The cardinality of your related stories will be 2 for ever. I think you can solve your situation with 5 tables. 1 table for data attribute(category,etc).CATEGORY 2 table for stories - i think in this way because you have 2 entities of relations : TO_RELATION and FROM_RELATION 2 index tables : one table for every relation table which can contain interchangeable ID's of stories:IDX_TO_RELATION which that contain ID's from FROM_RELATION and IDX_FROM_RELATION which that contain ID's from TO_RELATION A little schema (please maximize): FROM_RELATION(FIELDS: IDFROM,IDCAT..) IDX_FROM_RELATION(FIELDS: IDFROM,IDRELATED) CATEGORY(FIELDS: IDCAT...) TO_RELATION(FIELDS: IDTO,IDCAT,.)--IDX_TO_RELATION(FIELDS: IDTO,IDRELATED) relation schema for to_relation can be : CATEGORY.IDCAT-TO_RELATION.IDCAT TO_RELATION-IDX_TO_RELATION.IDTO IDX_TO_RELATION.IDRELATED-FROM_RELATIONS.IDFROM ..and for from_relation can be: CATEGORY.IDCAT-FROM_RELATION.IDCAT FROM_RELATION.IDFROM-IDX_FROM_RELATION.IDFROM IDX_FROM_RELATION.IDRELATED-TO_RELATION.IDTO ...it's very untested what i drawing here but i think it's a good start. I hope it help Best regards, Gelu ); so, for a given target story ID I would need a query that has something like... ... WHERE storyId1 = targetId OR storyId2 = targetId Another way I thought of has its own problems - CREATE TABLE storyRelationship ( relId INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, storyIdList TEXT }; of which a record would look something like: relId 5 storyIdList '46,59,89,94,213' but then I would need to do a lot of string parsing to get related stories, and I have to believe that a query with a 'LIKE %id%' clause is going to be a lot slower than one with an OR looking on two indexed rows. Any suggestions? - 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: data directory in 4.0.9
My dear friend, I suppose that you already done: ./configure --prefix=PATH_OF_THE_MYSQL_APPLICATION After compilation you must do: make install and after this : cd /PATH_OF_THE_MYSQL_APPLICATION/bin and... ./mysql_install_db. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Defryn, Guy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 16, 2003 4:00 AM Subject: data directory in 4.0.9 Where does mysql places the databases in 4.0.9 when installing from source? The var directory does not seem to be there anymore - 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: g++ and mySQL]
Hi, If i understand well you wish to concatenate different strings. Are many options but the most handy solution is if you use sprintf. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Dileep M. Kumar [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 16, 2003 1:10 PM Subject: g++ and mySQL] Hello friends, I am trying to connect mySQL thru g++. I could connect the db and execute a query. But I want to get a value from key board and pass the same inside the query. ie, This is the query I am passing. mysql_query(connection,insert into table-name values ('1','aaa','bbb','ccc')); But I want to read the values for aaa, bbb, ccc and pass into the query. How can I do it. I am a just a beginner in C/C++ Regards -- .''`. Dileep M. Kumar [EMAIL PROTECTED] : :' :http://www.kumarayil.net `. `'` `- Debian GNU/Linux - Choice of the Freedom Lovers - 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: g++ and mySQL]
Hi Benjamin, - Original Message - From: Benjamin Pflugmann [EMAIL PROTECTED] To: Gelu Gogancea [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, January 16, 2003 4:23 PM Subject: Re: g++ and mySQL] Hi. On Thu 2003-01-16 at 13:54:14 +0200, [EMAIL PROTECTED] wrote: Hi, If i understand well you wish to concatenate different strings. Are many options but the most handy solution is if you use sprintf. Well, in C++ you would rather use stringstream, because it has better type and bounds checking. Something like (untested): An object type which is C-style(c_str()) and which is null terminated array of characters. In this case i wonder ...if is a better bounds checking or is a little wasted of memory ?...considering that we never know from the begining the size of the string.In fact, i think that is the main purpose of the string type.This is indeed a facility for the programmer. #include sstream [...] std::ostringstream query; query insert into table-name values (1, ' my_escape(aaa) ', ' my_escape(bbb) ', ' my_escape(ccc) ') mysql_query( connection, query.str().c_str() ); (where my_escape is some function calling mysql_real_escape_string()) Or alternatively, use the mysqlcpp, the C++-API (which I am not so fond of). ...on this point we can handshake. HTH, Benjamin. Best regards, Gelu [...] I am trying to connect mySQL thru g++. I could connect the db and execute a query. But I want to get a value from key board and pass the same inside the query. ie, This is the query I am passing. mysql_query(connection,insert into table-name values ('1','aaa','bbb','ccc')); But I want to read the values for aaa, bbb, ccc and pass into the query. How can I do it. I am a just a beginner in C/C++ -- [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: May be bug in MySQL 4
Hi, I think is not a bug.The result is normal becuase function TO_DAYS() return the daynumber and not the date.If you wish to find a date depend on the number of days you can try(like example): select FROM_DAYS(TO_DAYS(NOW())-3); Read the manual about this two functions Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Dobromir Velev [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 14, 2003 9:37 PM Subject: May be bug in MySQL 4 Hi, There might be a bug in mysql 4 (tested on 4.0.8-gamma and 4.0.9-gamma) when combining simple arithmetic operations and date conversion I have a table with the following structure date_col date -00-00 int_col tinyint(3) unsigned This is what happens when I try to run a query like the one below. mysql select to_days(Now())-to_days(data_col)-int_col from table_name where to_days(Now())-to_days(data_col)int_col; +---+ | to_days(Now())-to_days(date_col)-int_col | +---+ | 18446744073709551607 | | 18446744073709551609 | | 18446744073709551607 | | 18446744073709551609 | | 18446744073709551607 | | 18446744073709551615 | Tested on Linux Redhat 7.3 and on a Slackware 7.0.0 TIA Dobromir Velev - 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: Problem using the C-API for MySQL Program breakdown after about 1 Mio SQL-statements
Hi, Maybe it's a good ideea to increase the value of max_allowed_packet(from my.cnf configuration file) to 2M.By default is 1MB. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Daniel Wetzler [EMAIL PROTECTED] To: MySQL Mailing Liste [EMAIL PROTECTED] Sent: Wednesday, January 15, 2003 11:54 AM Subject: Problem using the C-API for MySQL Program breakdown after about 1 Mio SQL-statements Hallo, I apologize for my bad english. Im desperate about the followwing problem : I'm using the MySQL C-API for accesssing a database with about 1.2 Mio SQL-Statemants. Therefor I make a connect to the database and after that a loop starts a Subprogram about 1.2 Mio times in which a SQL-statement is sent to the database. My problem is that the program breaks down after about 1 Mio iterations with a Bus error and Segmentation fault. If I analyse the core dump with a debugger I get the following statements : The program breaks down at line : if (mysql_query(mysql2, abfrage)) { printf (Fehler bei der Abfrage ! Fehler : %s \n %s \n, mysql_error(mysql2), abfrage); exit(1); Program terminated with signal 10, Bus Error. #0 0xff35a90c in vio_is_blocking () from /usr/local/mysql/lib/mysql/libmysqlclient.so.10 (gdb) up #1 0xff35a4e0 in net_clear () from /usr/local/mysql/lib/mysql/libmysqlclient.so.10 (gdb) up #2 0xff356abc in simple_command () from /usr/local/mysql/lib/mysql/libmysqlclient.so.10 (gdb) up #3 0xff3594e8 in mysql_real_query () from /usr/local/mysql/lib/mysql/libmysqlclient.so.10 (gdb) up #4 0x11728 in read_coor (i=1065778) at nclu-datenbank.c:279 (gdb) up I checked the SQL statement which is sent at that time an it is ok and leads to suitable result. Does any one have an idea why my program breaks down ? Greetings, Daniel P.S : Here is my code for accessing the database : (some code. ) mysql2 = mysql_init(NULL); if (mysql2 == NULL){ printf (mysql_init() fehlgeschlagen (kein Speicher ?)\n); exit (1); } if (mysql_real_connect( mysql2, def_host_name, def_user_name, def_password, def_db_name, 0, NULL, 0) == NULL){ printf(Datenbankverbindung hat nicht geklappt.\n); } printf (Datenbankverbindung 1 ok\n); while(ergebnisarray[zaehler] != NULL) { /*printf (zahl = %i\n, ergebnisarray[zaehler]);*/ j=read_coor(ergebnisarray[zaehler]); /* This is my fuction which sends the SQL-statements accessed 1.2 Mio times */ zaehler++; } mysql_close(mysql2); (some code) In my function I access the database with the following lines : (some code).. for (seglaengenzaehler = 1; seglaengenzaehler = seglength; seglaengenzaehler ++) { sprintf (abfrage, select xkoor, ykoor, zkoor, id from %iloop inner join pdbmolekuel on m%i=molekuelnr inner join pdbatom on molekuelnr = molekuelzuordnung where loopnummer = %i, seglength, seglaengenzaehler, i); if (mysql_query(mysql2, abfrage)) { printf (Fehler bei der Abfrage ! Fehler : %s \n %s \n, mysql_error(mysql2), abfrage); exit(1); } else { ergebnis = mysql_use_result(mysql2); } } if (ergebnis == NULL) { printf (Fehler beim show tables !\n Fehler : %s , mysql_error(mysql2)); } else { /*printf (Alles in Ordnung !\n);*/ while((myzeile = mysql_fetch_row(ergebnis))) { if ( strcmp(myzeile[3],CA)==0 || strcmp(myzeile[3],N) == 0 || strcmp(myzeile[3],C) == 0 || strcmp(myzeile[3],O) == 0) { // Es werden nur die Atome CA, N, C und O beachtet coor[j] = atof(myzeile[0]); coor[j+1] = atof(myzeile[1]); coor[j+2] = atof(myzeile[2]); j += 3; } } mysql_free_result (ergebnis); } resno = j/12; } (some code) - 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: error report using mysql 3.23.49 max
Hi, A very evasive description. - Original Message - From: PC Systems [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, January 15, 2003 8:03 PM Subject: error report using mysql 3.23.49 max Dear Sirs. We are programers in Brasil and we are currently conducting tests with MySQL version 3.23.49 Max working with Dephi 6.0. For testing purposes we What you using to accessing MySQL? MySQL C API,MyODBC,ZEOS...@? developed a very simple program that inserts 500 records into a table. The What is table schema ? folowing teste has been conducted: With the test program two stations try to insert records simultaneously and we got several erros such as error 22 from table handler, we lost records and we also got table corruption in some situations.Reviewing tests we found tha the test aplication did not return In what situations ? the insert erros giving the impression that all records have been inserted which was not true. Very strange.It's for the first time when i heard about that.Is very easy to blame a system if we don't real known almost all about it. Running exactly the same test program replacing MySQL by INTERBASE (Delphi) we had no records loss. We are at your disposal to supply I understand you.And VB programers work with out any problem with MS SQL any details or aditional information tha you might need to clarify this reported problem. We waiting some more details. Thanks for attention You are welcome Cilly Best regards, Gelu - 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: connect by IP number
Hi, If you use NULL on the USER parameter that means you wish to login with the current user which is already logged under Linux.I suppose that you don't have any user set to connect at MySQL server. I think it's better to try with root instead of NULL. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: mahdi samia [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 14, 2003 9:26 AM Subject: connect by IP number Hello all, I have writed a program and compiled it by g++. I used from API function for connecting to MySQLServer : mysql_real_connect(db,192.168.2.245,NULL,NULL,vlrdb,3306,/tmp/mysql.soc k,CLIENT_ODBC) but when running it I receive following message: Host 192.168.2.249 is not allowed to connect to this MySQL server 192.168.2.249 is client IP number that tries to connect to MySQLserver. please hint me. M.Samee -- __ Sign-up for your own FREE Personalized E-mail at Mail.com http://www.mail.com/?sr=signup Meet Singles http://corp.mail.com/lavalife - 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: Populating one table with data from another
Hi, You can use INSERT...SELECT. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Michael Knauf/Niles [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 14, 2003 7:01 PM Subject: Populating one table with data from another Ok, this has got to be easy, but I'm not getting it right... I have a table, products containing a 944 rows. One of the fields is fgNumber, I have another table, categoryRelatedToProducts which also has an fgNumber field and currently has no data. I'd like to add all 944 fgNumbers to the categoryRelatedToProducts table. Can I do this with one sql statement? Michael - 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: MS SQL vs MySQL
Hi, In fact ...you can choice the RDBMS depend on what you wish to do. If you are able to design the database for using without store procedures,viewers,triggers...you can choose MySQL. It's stable enough and the better part is that have very good performance. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Octavian Rasnita [EMAIL PROTECTED] Cc: MySQL [EMAIL PROTECTED] Sent: Tuesday, January 14, 2003 8:43 PM Subject: Re: MS SQL vs MySQL On Tue, Jan 14, 2003 at 11:41:16AM +0200, Octavian Rasnita wrote: Hi all, I've asked on another list which database they recommend among MySQL and MS SQL, and ... possibly PostgreSQL. Most of that list members answered me that they recommend MS SQL because it has much more features. Please check the list archives. This topic comes up all the time. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 30 days, processed 1,007,062,642 queries (381/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 - 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: problem with last_id
Hi, IMHO: I think you should try : 1) SET @a:=0; LOCK TABLE your_table_name WRITE; INSERT what_client_must_to_insert SELECT @a:=MAX(ID) FROM tableetc UNLOCK TABLE; After unlock the table you can find the value of variable @a by doing: SELECT @a; 2) INSERT what_client_must_to_insert SELECT LAST_INSERT_ID(); Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Richard Brenner [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 13, 2003 1:50 PM Subject: problem with last_id I have a problem with a query: I use an application where users can post messages. The messages are stored in two tables that are related by the id of the new created message. I get the last id with the following query: select max(id) as maxid from tasker_app The forum has many users and sometimes it happens that there are multiple inserts before I can receive the last id. Is it possible to stop inserts until I have finished both inserts? Thank you, Richard Brenner - 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: help with query
Hi, SELECT LEFT(YOUR_COLUMN,2) FROM YOUR_TABLE.for position SELECT RIGHT(YOUR_COLUMN,2) FROM YOUR_TABLE for type Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Leonardo Javier Beln [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 13, 2003 10:09 PM Subject: help with query Hi all! I would like to build a query that I can use to search hierichally from an char(4) id composed as followed 2positions for the class of plant (for example) and 2 positions for the type of flower (for example) if someone give me the id that means red rose tree, and I know there is another clasifications of tree and another colors for the rose, does anyone knows how to retrieve them. 0100 - Rose tree 0101 - pink rose tree 0102 - red rose tree 0103 - rococo rose tree 0200 - generic tree Thanks in advance Leonardo J. Beln. query mysql sql blah! - 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: Re[4]: mysql 4.0.8- crash on TCP connection
Hi, It seems is happens to all which use InnoDB.Is announced that will be solved in 4.0.9. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Johannes Ullrich [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 10, 2003 4:28 AM Subject: Re: Re[4]: mysql 4.0.8- crash on TCP connection On Thu, 9 Jan 2003 22:56:04 +0200 Gelu Gogancea [EMAIL PROTECTED] wrote: All this is very interesting, BUT i have two binary builds (4.0.7 4.0.8), Ha,Hayou are gentle. (load avg 10-60 Query/sec), and 4.0.8 crash (in some hardware/software) after 2 seconds work :( Did you see any relationship with 'replication'? I just downloaded 4.0.8. All it did was act as a slave. It crashed after a large 'load table' from the master and now refuses to start. Looks like it crashes as it read the relay-log-info file or just after it does so. at least thats my latest theory after doing more backtrace resolving, stracing and experimenting. did submit one or two bug reports about this. -- [EMAIL PROTECTED] Collaborative Intrusion Detection join http://www.dshield.org - 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: [OT] Re: InnoDB vs. MySQL performance Issue
Hi Paul, MYSQL AB maybe have already done something to diffuse this situation but without to get involved this very-mega-ultra public MYSQL LIST. And i think also is a duty of every member of this list to make all to keep clean this list but without any implication of it. I feel frustration also, because on January 5 2003 two of my townsman(romanians) was killed without any fault by the palestinian terrorist. But we must be rational and must to make difference between our feelings and MYSQL company with all what it is. Maybe it's time to show that the pigs and monkey are able to forgive in comparison with him,witch is man and witch is not able to respect all the members of this list(by making propaganda). If we think that this LISTS belong to MYSQL AB then MYSQL AB is a victim of this disputation.And if MYSQL AB will be have a PUBLIC attitude this means MYSQL AB will be agree with this kind of disputation .Personally, i think THIS NOT A PURPOSE OF MYSQL AB. Anyhow,i think this list belong to all MYSQL users/software developers and in this situation MYSQL AB didn't have ANY FAULT. With all my consideration, Gelu Gogancea Software Developer - System Integrator __ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Paul Magid [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; 'Michael Widenius' [EMAIL PROTECTED] Sent: Thursday, January 09, 2003 7:46 AM Subject: RE: [OT] Re: InnoDB vs. MySQL performance Issue To MySQL AB: Your lists are being used to disseminate extremist muslim hate-speech. As such, this will reflect terribly negatively on your company if you let this go unchallenged much longer. This individual, if you can call him that, has repeatedly said inflammatory stuff about Israel in his signature. Clearly, no one in an official capacity at your company saw fit to address that. However, now he has equated the Jews and Christians living in [his] lands to pigs and monkeys. This kind of racism is reprehensible in the extreme. This scum is posting his screed from Egypt; I, on the other hand, live in a country which has a much richer tradition of freedom of speech, the United States. And, contrary to this morons assertions, you DO NOT have the right to say anything, at any time, anywhere. And, particularly not in a private forum such as this. There are no first amendment protections from non-governmental actors ie: in this case MySQLAB. Thus, if MySQLAB chooses to do nothing about it your company will be tacitly condoning his behavior. I recommend that at a bare minimum this guy should be removed from the list, for the sheer disruption that he has caused to the normally extremely helpful discourse which is usual in this list. Furthermore, I am a DBA in a Fortune 500 company, and I do have significant influence over the buying decisions of my company with respect to databases. You can be sure that any business I have will not go to you if you do nothing. Sincerely, Paul Magid, DBA -Original Message- From: Sameh Attia [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 08, 2003 1:54 AM To: [EMAIL PROTECTED] Subject: [OT] Re: InnoDB vs. MySQL performance Issue Sam Przyswa wrote: Septenber 11 2001, more than 3000 women, men, child, killed, Tel Aviv January 5 2003, 23 death and 100 injured by islamic terrorists, that's the islamic history (small part). Sam Apache-PHP-MySQL user. -- Albert Einstein, Karl Marx, Jesus Christ, and you Mohamed what have you done for the world ? First of all do not cc me directly. I do get a copy of ur shit by the list. If you think that Mohamed did not do something for the world which is not true. At least he did not leave us with some pigs and monkeys. Read your history if u forgot. If u were a muslim, I thank God that u were not, u would learn how to respect other prophets. We as muslims do repect Jesus, Moses, Ibrahim, and other prohpets and we are asked to believe in them because it is a fundamental believe in our religion. If u want to know more about out prophet Mohamed go and read http://www.islamonline.com/PAGE12.html Also you will find below detailed information about what the modern, democractec, and civilized gang of Zions does to muslims. Israeli Massacres http://www.ummah.net/unity/palestine/index.htm Sabra Shatila http://www.ummah.net/unity/sabra/main.html Deir Yassin http://www.deiryassin.org http://www.ariga.com/peacewatch/dy http://www.us-israel.org/jsource/History/deir_yassin.html Qana http://web.cyberia.net.lb/qana/ .and much more but the memory does not help. Sam go and get a life and may God forgive u. But u should believe that sooner or later there will be no more pigs and monkeys in our lands. -- Sameh Attia Senior
Re: mysql 4.0.8- crash on TCP connection
Hi, What OS you use ? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Andrew Sitnikov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, January 08, 2003 8:14 PM Subject: mysql 4.0.8- crash on TCP connection Hello mysql, I try use 4.0.8 (max standard)in our production box, and it was crash every TCP connection, For 4.0.7 (standard) i has over 20 days uptime. Best regards, Andrew Sitnikov e-mail : [EMAIL PROTECTED] GSM: (+372) 56491109 - 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: Re[4]: mysql 4.0.8- crash on TCP connection
Hi, Try to start mysql daemon with --skip-innodb and see if the problem persist.I suppose is something wrong with your my.cnf configuration. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Andrew Sitnikov [EMAIL PROTECTED] To: Gelu Gogancea [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, January 09, 2003 6:05 PM Subject: Re[4]: mysql 4.0.8- crash on TCP connection Hello Gelu, GG Hi Andrew, GG I can not reproduce your case.For me work good.The only difference is that i GG use source distribution and you use a binary distribution. GG Please take a look in mysql log and tell me what you see there. GG Regards, 030108 20:12:09 mysqld started 030108 20:12:10 InnoDB: Started /usr/local/mysql/bin/mysqld: ready for connections mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=402653184 read_buffer_size=2093056 sort_buffer_size=2097144 max_used_connections=1 max_connections=200 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 1211614 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x8704638 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xb397f608, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x806f3bb 0x8269928 0x807724c 0x8077665 0x82670dc 0x829c67a New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at (nil) is invalid pointer thd-thread_id=10 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 10 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid. The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash. Number of processes running now: 0 030108 20:12:25 mysqld restarted 030108 20:12:26 InnoDB: Started Hello Gelu, GG Hi, GG What OS you use ? System: Linux gap 2.4.20-grsec #1 SMP Fri Dec 6 23:17:05 EET 2002 i686 GG unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake GG /home/local/sitnikov/bin/gcc /home/local/sitnikov/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs gcc version 2.95.3 20010315 (SuSE) Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=pentiumpro' CXX='gcc' GG CXXFLAGS='-O2 -mcpu=pentiumpro -felide-constructors' LD FLAGS='' ASFLAGS='' LIBC: -rwxr-xr-x1 root root 1384072 Oct 1 19:10 /lib/libc.so.6 -rw-r--r--1 root root 25215016 Oct 1 18:56 /usr/lib/libc.a -rw-r--r--1 root root 178 Oct 1 18:56 /usr/lib/libc.so Best regards, Andrew Sitnikov 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: Re[2]: mysql 4.0.8- crash on TCP connection
Hi, This is a glibc problem.In this case you can start mysql daemon with option --skip-name-resolve and in this situation is no need to add the IP address of every client in hosts file.The disadvantage is that the client can not connect to the server using host alias. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Andrew Sitnikov [EMAIL PROTECTED] To: Christopher E. Brown [EMAIL PROTECTED] Cc: Gelu Gogancea [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, January 09, 2003 7:19 PM Subject: Re[2]: mysql 4.0.8- crash on TCP connection Hello Christopher, CEB This sounds like what I just submitted a bug report for. Connections CEB to 4.0.8 (compiled locally or binary distro) cause a server crash if CEB the IP of the client is not resolvable in DNS. Yes ! I really have crash only when client(user) not has DNS records ! But with 4.0.7 this client(user) working properly. CEB One can add an entry to the hosts file for certain IPs to stop this, CEB however this still leaves the fact that ANY IP that can connect to the CEB server can crash it if there is no reverse entry. CEB -- CEB I route, therefore you are. Best regards, Andrew Sitnikov e-mail : [EMAIL PROTECTED] GSM: (+372) 56491109 - 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: remote connect crash
Hi, Start mysql daemon with options --skip-name-resolve Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Dmitry V. Sokolov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 09, 2003 7:07 PM Subject: remote connect crash Good day, could you help me to solve this problem? MySQL server segmentation faults when remote mysql client tries to connect on source and binary distributions. Local client connect does not cause any problems whatsoever. - 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: Re[4]: mysql 4.0.8- crash on TCP connection
All this is very interesting, BUT i have two binary builds (4.0.7 4.0.8), Ha,Hayou are gentle. (load avg 10-60 Query/sec), and 4.0.8 crash (in some hardware/software) after 2 seconds work :( If i understand well it crashed even if no one is connected ? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Andrew Sitnikov [EMAIL PROTECTED] To: Gelu Gogancea [EMAIL PROTECTED] Cc: Christopher E. Brown [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, January 09, 2003 10:28 PM Subject: Re[4]: mysql 4.0.8- crash on TCP connection Hello Gelu, No, the glibc gethostby* will walk the tree defined in hosts.conf, normally files,dns. A non-find in /etc/hosts followed by a NXDOMAIN GG If you said soanyhow gethostby* is used by DNS and no reverse. GG The Name Server(named) use this both functions depending by the order line GG in /etc/host.conf.And after this read the /etc/hosts.Depend on the action GG this file is call host database file or static table for host names. All this is very interesting, BUT i have two binary builds (4.0.7 4.0.8), downloaded from mysql mirror, and 4.0.7 work for me about 1 month with out problems (load avg 10-60 Query/sec), and 4.0.8 crash (in some hardware/software) after 2 seconds work :( Best regards, Andrew Sitnikov e-mail : [EMAIL PROTECTED] GSM: (+372) 56491109 - 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: Re[2]: mysql 4.0.8- crash on TCP connection
Functions gethostby* ,from glibc, work directly with the /etc/hosts file.If this functions didn't find an entry for the client, will be crashed. I try to find in the Andrew e-mail if he has installed the glibc 2.2.x but i don't see nothing about it.What i see is, he use 2.95.x which is declared by MySQL like unstable.In this context can be a coincidence what is happened. Also i don't find difference in MYSQL daemon source code(hostname.cc) between 4.0.7 and 4.0.8. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Christopher E. Brown [EMAIL PROTECTED] To: Gelu Gogancea [EMAIL PROTECTED] Cc: Andrew Sitnikov [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, January 09, 2003 7:48 PM Subject: Re: Re[2]: mysql 4.0.8- crash on TCP connection On Thu, 9 Jan 2003, Gelu Gogancea wrote: Hi, This is a glibc problem.In this case you can start mysql daemon with option --skip-name-resolve and in this situation is no need to add the IP address of every client in hosts file.The disadvantage is that the client can not connect to the server using host alias. Regards, Gelu Could you clarify This is a glibc problem? A known standard glibc 2.2.5 against which every other piece of software functions correctly, even when receiving null returns on reverse lookups, but 4.0.8 (both precompiled binary and locally build) crashes on a null return. Specially when (according to other reports) 4.0.7 functions correctly. -- I route, therefore you are. - 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: Re[2]: mysql 4.0.8- crash on TCP connection
sql,query,queries,smallint No, the glibc gethostby* will walk the tree defined in hosts.conf, normally files,dns. A non-find in /etc/hosts followed by a NXDOMAIN If you said soanyhow gethostby* is used by DNS and no reverse. The Name Server(named) use this both functions depending by the order line in /etc/host.conf.And after this read the /etc/hosts.Depend on the action this file is call host database file or static table for host names. from DNS results in a negative return from the gethostby* call. If it find something return a hostent data struct else is a NULL POINTER. Conclusioni think we talk about two different thing Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Christopher E. Brown [EMAIL PROTECTED] To: Gelu Gogancea [EMAIL PROTECTED] Cc: Andrew Sitnikov [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, January 09, 2003 9:38 PM Subject: Re: Re[2]: mysql 4.0.8- crash on TCP connection - 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: InnoDB vs. MySQL performance Issue
Peace to all, This is not the right place for this kind of discussions. Please STOP. Also i have a suggestion for the administrator of this list: -to forbidden all e-mail which have in subject or body, logo /slogan/catchword which can be considered RINGLEADER. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Sam Przyswa [EMAIL PROTECTED] To: Sameh Attia [EMAIL PROTECTED]; MySQL List [EMAIL PROTECTED] Sent: Monday, January 06, 2003 3:28 PM Subject: Re: InnoDB vs. MySQL performance Issue Sameh Attia ([EMAIL PROTECTED]) écrivait: Sam Przyswa wrote: Sameh Attia ([EMAIL PROTECTED]) écrivait: She who is in my mind and mouth, I love her with all my heart and blood We'll restore OUR Palestine Did you know a democratic country named ISRAEL created in 1948 ? How do u define democratic? country? Israel? created? BTW did u no about a gang founded on 1948? Yes I know, his name is PLO, and in this case Palestine is not a country but a terrorist organisation. 1) Democratic mean that all people, men, women, muslem, jewish, catholics, have the same right instead of arabs countries. 2) Country is like house and have to be build, not destroyed as you have done in Liban, and that you want with ISRAEL. 3) Israel is the only one democratic country in middle east where catholics, muslems, jewish, can leave together instead of yours where jewish, catholics, are killed as in Islamic Republic of Soudan, Irak, Syria, etc. 4) Created means... something that you can't understand because you never have created anything, just destroy as your child transformed in humain bombs. Peace, Country, Democracy, Sharing, lot of things that you will understand when you will become MEN as all of humains peoples, see you in 1000 years ! PS. MySQL is not a toy for you, try MS-SQL instead, I'm sure that Bill Gate himself will be happy to reply your messages with this very nice signature. Sam. - 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: InnoDB vs. MySQL performance Issue
Hi, I'm sure that all the people from this list RESPECT in what you believe or in values which are considered by you to be inviolable/holy. I'M NOT JEWISH but i'm sure if you will see, like logo/slogan , something like ... I WILL LOVE YOU FOREVER WITH MY HEART AND MY BLOOD, BEN GURION. ... i'm almost sure that you will feel frustration...and THIS IS NOT RIGHT. For this reason please remove your logo from the bottom of your e-mail body and after this i'm sure all people which are subscribed to this list will try to find a solution for your problem(maybe and SAM). Personally, i beg you to repost your problem to the list because i didn't catch the e-mail where is described your problem. Best Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] Ive already done that. I asked about a solution to my problem. -- Sameh Attia Senior System Engineer T.E. Data -- __ __ _ _ _/ /_/ /_(_)___ _ / ___/ __ `/ __/ __/ / __ `/ (__ ) /_/ / /_/ /_/ / /_/ / //\__,_/\__/\__/_/\__,_/ - 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: Desperate - failed: Lost connection to MySQL server during query
Hi, You right.RH8 have a problem with glibc.All people from the list recommende to make a downgrade to version 2.x or download binary distribution from MySQL site which is compiled with the right version of glibc. Are and other ways to solve your problems but i think you need to a stable solution. Anyway if you start MySQL daemon with option --skip-name-resolve and the problem it's solved then you have only this 2 options. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Chris Faust [EMAIL PROTECTED] To: John P [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, January 02, 2003 6:54 AM Subject: RE: Desperate - failed: Lost connection to MySQL server during query Thanks for the help John, I really don't know all the specifics of the hardware setup as it is all out at our ISP, I know its a rack mounted P4 and its going into a Cisco switch but that's about it. We have made some progress though and as strange as it sounds its really looking like its something with RH 8, in short we downgraded perl 5.8 to 5.6.1 with no results, we then went from Apache 2 down to 1.3 with no results, then that night backup exec came through and the machine spiked to 100% - noticed it by luck of being on the machine at the same time, this pretty much took Apache, Perl and my code out of the question. Did up a new machine (same specs), put RH 7.3 on it, copied everything over and made it live.. Right before we switched over to the new machine we stopped throttling the server (it was the only way to stop those errors) and instantly those connection failures started happening like crazy. As soon as we made the switch, they all went away, load was cut in half and CPU idle went up around 30 to 40% and things were just screaming, 110% improvement in all areas. So you'd think everything was wonderful now, wouldn't you?.. Well check this out.. As soon as the new web server was brought up I started getting (and still get) tons of Aborted connection ... (Got an error reading communication packets) - and mySql has run without a flaw since day one, also the scripts and DBI and everything was exactly the same on the new web server from the old web server (mysql would have no knowledge of the switch). I can say I'm about 98% sure that everything mySql shows for this problem at: http://www.mysql.com/doc/en/Communication_errors.html Isn't a issue. As RH 8 is also running on the dedicated mySql machine, I'm starting to believe its the root of all my problems. Its been a wild week!! Thanks -Chris -Original Message- From: John P [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 28, 2002 1:45 PM To: Chris Faust; [EMAIL PROTECTED] Subject: Re: Desperate - failed: Lost connection to MySQL server during query If you are running close to the same setup with no problems then I feel a little better about it not being a issue of pure traffic. Yes, we operate in a very similar way to you. (BTW, we have had very good results with a PHP based cache facility that simply stores the db driven pages over a selectable time period; good if your pages don't change that much! Capacity increased 4000% or so; would imagine something similar exists for perl) I don't think the link between the machines is a issue, both machines are dedicated and at the same location, I've tried using both the external and internal (10.0.x.x) IP to connect to the DB with the same results and in all cases both machines have had entries in their hosts file for one another. As for simultaneous connections, that is something that I still need to go through the logs and come up with a real number for those time frames.. I don't know anyway to see a real number of actual users using Apache via the command line (is there such a thing?). I've always done ps -ef | grep httpd | wc -l a few times which shows the processes, you can get a good idea of whether the site is busy or not. I don't know how to actually find the exact number of users, I suppose netstat ? One thing I wonder that I forgot to ask - does using IP address as the host for a user in mySql matter? Meaning before DNS switched over I wanted to get everything up and running so I created all the mysql user accounts based on the IP address of the web server (and not name). I would think if this were a issue at all I would be getting denied messages and it wouldn't work 100% of the time, but I thought I would throw it out there. I'd do everything by IP, especially for the internal stuff. It might be worth trying a dedicated cable+two separate network cards in each server to handle MySQL traffic. Just a thought, but could packets be getting lost between the two
Re: mysql_use_result
Hi, Strange...you should be able to find the number of fields from resultset with mysql_num_fields.You use MYSQL_RES like parameter for mysql_fetch_fields ? How do you use mysql_fetch_fields? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Ritesh Nadhani [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 02, 2003 8:34 PM Subject: mysql_use_result Greetings... When I am using mysql_use_result API to retrieve results, I am always getting 0 value for the max_length member of MYSQL_FIELD structure which is returned by mysql_fetch_fields. But when I am using mysql_store_result, max_length has correct value. Is this normal ? Is there any way to know the max_length when using mysql_use_result. Thanks in advance Insane - 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: ADO Error '800a01fb'
Hi, This is an aoutomation error and is possible to be raised because you use CreateObject instead of using object directly. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Michael She [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, December 28, 2002 7:57 AM Subject: ADO Error '800a01fb' Hi all, I'm getting this error with MyODBC v2.50 and v3.51. I'm running MySQL v4.06: Microsoft VBScript runtime error '800a01fb' An exception occurred: 'open' /mshe/gallery/picture.asp, line 45 The code for that area is: strConn = DSN=binaryio; Set objConn = Server.CreateObject(ADODB.Connection) objConn.open strConn set rs = server.createobject(adodb.recordset) strSQL = SELECT * FROM IMAGES WHERE `ID` = ID rs.open strSQL, objConn, 3,1,1 Nothing out of the ordinary... anyone know why I'm getting this error? Thanks! -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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 - 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: ADO Error '800a01fb'
Hi, From what i know i think is possible if you declare(like METADATA) this object(using UUID). Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Freddie Sorensen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, December 29, 2002 1:35 PM Subject: AW: ADO Error '800a01fb' I don't think so since there is no other way to create an object in ASP VBScript Which line is line 45 ? objConn.open or rs.open ? Freddie -Ursprüngliche Nachricht- Von: Gelu Gogancea [mailto:[EMAIL PROTECTED]] Gesendet: Sonntag, 29. Dezember 2002 12:02 An: [EMAIL PROTECTED]; Michael She Cc: [EMAIL PROTECTED] Betreff: Re: ADO Error '800a01fb' Hi, This is an aoutomation error and is possible to be raised because you use CreateObject instead of using object directly. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Michael She [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, December 28, 2002 7:57 AM Subject: ADO Error '800a01fb' Hi all, I'm getting this error with MyODBC v2.50 and v3.51. I'm running MySQL v4.06: Microsoft VBScript runtime error '800a01fb' An exception occurred: 'open' /mshe/gallery/picture.asp, line 45 The code for that area is: strConn = DSN=binaryio; Set objConn = Server.CreateObject(ADODB.Connection) objConn.open strConn set rs = server.createobject(adodb.recordset) strSQL = SELECT * FROM IMAGES WHERE `ID` = ID rs.open strSQL, objConn, 3,1,1 Nothing out of the ordinary... anyone know why I'm getting this error? Thanks! -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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 - Before posting, please check: http://www.mysql.com/products/myodbc/manual_toc.html (the manual) http://lists.mysql.com/(the list archive) To unsubscribe, e-mail [EMAIL PROTECTED] To unsubscribe from Yahoo! Groups version, 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 - 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: birthday calculation problem
Hi, I think you can try to use TO_DAYS() function; eg: select TO_DAYS('2002-12-28')-TO_DAYS(NOW()); Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Patrascu Eugeniu [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, December 27, 2002 2:56 PM Subject: birthday calculation problem Hi, I have a problem calculating birthdays in sql. Here goes my setup: I have a database that contains the bithdays of a number of people, and I want to know when there birthday is to congratulate them. The thing is that I want to now that a day before their birthday. Therefore I need a way to do that, and I do not know how to do it, so I am asking on this list, maybe there is someone that can tell me how. Regards, Patrascu Eugeniu - 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: birthday calculation problem
Hi, I think you can try to use TO_DAYS() function; eg: select TO_DAYS('2002-12-28')-TO_DAYS(NOW()); Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Patrascu Eugeniu [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, December 27, 2002 2:56 PM Subject: birthday calculation problem Hi, I have a problem calculating birthdays in sql. Here goes my setup: I have a database that contains the bithdays of a number of people, and I want to know when there birthday is to congratulate them. The thing is that I want to now that a day before their birthday. Therefore I need a way to do that, and I do not know how to do it, so I am asking on this list, maybe there is someone that can tell me how. Regards, Patrascu Eugeniu - 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: SELECT and UPDATE at the same time?
Hi, You can use REPLACE...SELECT Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Jeff Snoxell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 7:56 PM Subject: SELECT and UPDATE at the same time? Hello again, I'm selecting a group of records from my database. I then loop through the selected records and do some work based on what I find. But what I also want to do as I interrogate each record is update some of its fields with new values... but won't that screw up the outer loop? I mean if I try to execute a query whilst looping around the result set of a former query will I not screw up my result set that I'm looping through? Also, is it possible to update specific fields of certain records within a SELECT query? ie can I do something like this: SELECT * FROM my_table WHERE Age 50 AND UPDATE Status = OLD Ta, Jeff - 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: More locking issues
Hi, If you have more than one user connected to the database which handled the same tables, you need to use LOCK/UNLOCK tables. MySQL daemon don't lock tables or records if you don't require this. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Jeff Snoxell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 12, 2002 6:57 PM Subject: More locking issues Hi, I'm new to MySQL. I see you all talking about locking databases etc... but isn't that the point of having a database server? So you don't have to worry about record locks? I'm designing the backend for a popular site where a user's visit will result in multiple read/write operations on a database. Is record locking something I definitely need to do? Thanks, Jeff - 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: More locking issues
Hi, Is not the same caseJeff didn't said anything about TRANSACTIONS. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Michael T. Babcock [EMAIL PROTECTED] To: Gelu Gogancea [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; Jeff Snoxell [EMAIL PROTECTED] Sent: Thursday, December 12, 2002 8:44 PM Subject: Re: More locking issues Gelu Gogancea wrote: If you have more than one user connected to the database which handled the same tables, you need to use LOCK/UNLOCK tables. MySQL daemon don't lock tables or records if you don't require this. Can I ask if this is in fact accurate? As I understand it, MySQL does a fairly good job of locking the tables, that's part of the performance problem of MyISAM vs. InnoDB table types with many updates running. And with InnoDB, you get a Repeatable Read isolation level by default which 'feels like' getting a read lock. What did you mean that it doesn't lock tables? SQL -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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: Error No: 2013. Lost Connection MySQL server during query
Hi, Old story.You have many options.Perhaps the most convenient solutions are to start MySQL daemon with --skip-name-resolve(documentation - 4.1 Configuring MySQL) or you can add the client IP address and alias in the /etc/host. Other options are: -download MySQL 3.23.53a binary distribution . -upgrade your glibc to .42 or downgrade to .39. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Cem Yagli [EMAIL PROTECTED] To: Mysql maillist [EMAIL PROTECTED] Sent: Friday, November 29, 2002 9:31 AM Subject: Error No: 2013. Lost Connection MySQL server during query Hi all, I am trying to connect to mysql server (3.23.52) on Linux Redhat 8 thru win2000 with using any Front End applications (SQLyog251, MySqlwinadmin, winmysqladmin, ...). On every try, I am getting the same error message: Error No: 2013 Lost Connection MySQL server during query. I am being crazy. On the server side each connection try is leaving a paragraph in the /var/log/mysqld.log just like: Number of processes running now:1 mysqld process hanging, pid 2 - killed 022323 15:02:24 mysqld restarted /user/libexec/mysqld: ready for connection I am dying to see any database or table with establishing this connection. Is there anybody will help me? Sincerely. Cem Yagli key words: 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 - 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: SQL Row Counting in MySQL
Hi, Select * from Blah where stuff=true limit 10; Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Tom Place [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 26, 2002 5:01 PM Subject: SQL Row Counting in MySQL Hi All, Is there a simple way in MySQL to only select the first x rows that meet a specified criteria. For example in Oracle the following would work: Select * from Blah where stuff=true and rownum = 10 (where rownum is not a specific column, just a count of how many rows have been returned) But MySQL doesn't like this. Anyone know the correct way to approach this?? Cheers Tom - 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: SQL Query
Hi, If the lenght of what wish to retrieve is fixed to 2 length,you can try something like this: select MID(YOUR_FIELD,3,IF(RIGHT(LPAD(YOUR_FIELD,4,','),1)=',',1,2)) from YOUR_TABLE; Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Paul van Brouwershaven [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 16, 2002 3:45 PM Subject: SQL Query Hi, I have a colum with this values : ,1,4,5,66,247,7, ,1,3,5,62,767,6, ,1,5,5,11 ,1,9,5,36,7677,9, ,1,40,55,66,444,3, I want to get whis values : (second field) 4 3 5 9 40 I have tried this : REPLACE(SUBSTRING_INDEX(value, ',', 3), ',','') But the following is returned : 14 13 15 19 140 I have alse tried the following query : select mid(path,locate(2,path,,)+1,(locate(locate(2,path,,)+1,path,,)-loc ate(2,path,,)-1)) from path_table Regards, Paul - 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: importing from text: date column problem
Hi, It's possible if you use DATE_FORMAT(). E.g. SELECT DATE_FORMAT('1997-11-15', '%d-%b-%Y') Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Bran Ioan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 16, 2002 1:55 AM Subject: importing from text: date column problem I want to import a text file into a table that has a date type column with mysqlimport. In the text file the date column is in the DD-MMM-YY format (ie 25-JUL-02); so when I import it, I get -00-00 in the table's date column. Is there a way to do this correctly ? My version is 3.23.52. Thank you. ### Disclaimer on Exchange This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange. For more information, connect to http://www.F-Secure.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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/doc/ (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Copying one table to another
Hi, You can use : INSERT INTO SELECT * FROM YOUR_TABLE Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 14, 2002 8:49 PM Subject: Copying one table to another Say I have 2 tables with the exact same formatting (fields, values, etc.) Is there an easy way to dump the contents of one table to the other in SQL rather than outputting the one to a .txt or .sql and inputing it into the other table? Thanks, Ed - 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: my host IP changed
Hi, It's possible that in mysql.user table to exist the old IP address of your machine.You should check the field Host using: use mysql; select Host,User from user where User='YOUR_USER_NAME'; If in the Host field you see the '%' character that means your problem is not from MySQL... else you should to update the new IP address in the mysql.user table using update or replace. Finally you must do: flush privileges; Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Chris Walcott [EMAIL PROTECTED] To: Mysql-L (E-mail) [EMAIL PROTECTED] Sent: Thursday, November 14, 2002 9:22 PM Subject: my host IP changed I just got mysql up and running (I'm a new user). I'm using it with ColdFusionMX. Just as I was about to bind a database to coldfusion, my IT department decided to move my server to a new IP address. Now I can't get a database to bind to coldFusion and I'm wondering if it's because the IP address changed. Is this something that is stored in the mysql database? If so, how so I change that? I'd rather not have to rerun mysql_install_db. - chris - 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: my host IP changed
Yes.You can put the new IP address instead of the name (no localhost).When you make update, you must be sure that YOU DON'T REPLACE and the record where the Host field is 'localhost'.You must replace only the record where in Host field is the name of computer/server which must connect to the MySQL. You can use : update user SET Host='YOUR_IP_ADDRESS' where User='YOUR_USER_NAME' and Host='THE_NAME_OF_HOST'; Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Chris Walcott [EMAIL PROTECTED] To: 'Gelu Gogancea' [EMAIL PROTECTED]; Chris Walcott [EMAIL PROTECTED]; Mysql-L (E-mail) [EMAIL PROTECTED] Sent: Thursday, November 14, 2002 9:52 PM Subject: RE: my host IP changed right now the host field has 2 entries: localhost and newpop (the name of the server). There are no IP numbers. Should I replace the host name entry with the new IP address? thanks! - chris -Original Message- From: Gelu Gogancea [mailto:ggelu;arctic.ro] Sent: Thursday, November 14, 2002 11:47 AM To: Chris Walcott; Mysql-L (E-mail) Subject: Re: my host IP changed Hi, It's possible that in mysql.user table to exist the old IP address of your machine.You should check the field Host using: use mysql; select Host,User from user where User='YOUR_USER_NAME'; If in the Host field you see the '%' character that means your problem is not from MySQL... else you should to update the new IP address in the mysql.user table using update or replace. Finally you must do: flush privileges; Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Chris Walcott [EMAIL PROTECTED] To: Mysql-L (E-mail) [EMAIL PROTECTED] Sent: Thursday, November 14, 2002 9:22 PM Subject: my host IP changed I just got mysql up and running (I'm a new user). I'm using it with ColdFusionMX. Just as I was about to bind a database to coldfusion, my IT department decided to move my server to a new IP address. Now I can't get a database to bind to coldFusion and I'm wondering if it's because the IP address changed. Is this something that is stored in the mysql database? If so, how so I change that? I'd rather not have to rerun mysql_install_db. - chris - 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: Decrypt MYSQL Password
Hi, You can make your own authentification system.A table which can have a binary char/varchar field for encrypted password(effect similar like password from mysql.user) and another char for ASCII password. If you not use grant statement for adding new user, you can use the MySQL authentification system and you can make relation between this table and mysql.user using encrypted password like foreign key. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Merlin, The Mage [EMAIL PROTECTED] To: Ben C. [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, November 13, 2002 7:53 PM Subject: Re: Decrypt MYSQL Password Well, my ideia was to have two diferent fields, the first one to the real password, and the second to the tmp passwd. When the user logs normally, the tmppasswd is set to null, and when the user request a new passwd, this field is set to the temporary password. This will sent an email to the user with a link that allow the user to type the temporary passwd and if correct, set the real one. mpneves On Wednesday 13 November 2002 05:26 pm, Ben C. wrote: I am a little new to MySQL and PHP. How do I make the password a temporary password. So when they login the first time they need to reset the password? Thanks for you help in advance. Ben From: Merlin, The Mage [EMAIL PROTECTED] Date: 2002/11/13 Wed AM 04:20:20 EST To: Ben C. [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Decrypt MYSQL Password -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Ben, From the MySQL man online @ http://www.mysql.com/doc/en/Miscellaneous_functions.html#IDX1330 : PASSWORD() encryption is non-reversible. To create a forgot your password page, the best method is to generate a net password and send that new password. To make it easier to your users to remember their passwords, the best way is to set that password as a temporary one, that only allows them to set the original password. (maybe using a diferent field, so they can keep the original password if someone else goes to your site and request the password, just because he was bored. MPNeves On Wednesday 13 November 2002 07:27 am, Ben C. wrote: I am using the MySQL password() function for the my passwords on the user names. How do I decrypt the password in PHP to send it in an e-mail. I am making a forgot your password page and want to have the user enter their e-mail and have the password sent to them. Please help! - -- Merlin, the Mage themage.camelot.co.pt -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE90hleKOMrqDFTeBARAoc7AKDozVXEVP8Tfv8Qjx9DE4ChPF8zsACaAh/C efo5W0z4+dO3UEvTnDz9qJk= =i4Oj -END PGP SIGNATURE- -- Merlin, the Mage themage.camelot.co.pt - 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: yo
Hi, Maybe on IRC(UNDERNET) is possible to have chance to find MySQL tutorials in spanish. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Roberto Ramos [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 12, 2002 9:15 PM Subject: yo Hola: Yo no sé como trabaja mysql, lo instalé pero necesito un manual o un tutorial en Castellano (español), que me indique como usarlo, como crear tablas,etc. muchas gracias. Pd. la versión que instalé es par windows. - 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: mysqld refuse to die
Hi, If you really wish to kill the mysql daemon in this way : You should try : ps -ef |grep mysql ...show all the mysqld processes and after this must enumarate all pid of processes in a single kill command. E.g. kill -9 1024 1056 ...(processes which are open). But it's more health if you can stop the server using : /etc/rc.d/mysqld stop Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Jack Chen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 7:57 AM Subject: Re: mysqld refuse to die I have just figured out: kill -9 xxx (process number) Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] On Sat, 9 Nov 2002, Jack Chen wrote: Hi All, Please help me with this problem: For some reason, I could not bring down my mysqld by running mysqld stop An error message indicate: fail What's going on? Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; 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 - 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 --- Xnet scaneaza automat toate mesajele impotriva virusilor folosind RAV AntiVirus. Xnet automatically scans all messages for viruses using RAV AntiVirus. Nota: RAV AntiVirus poate sa nu detecteze toti virusii noi sau toate variantele lor. Va rugam sa luati in considerare ca exista un risc de fiecare data cand deschideti fisiere atasate si ca MobiFon nu este responsabila pentru nici un prejudiciu cauzat de virusi. Disclaimer: RAV AntiVirus may not be able to detect all new viruses and variants. Please be aware that there is a risk involved whenever opening e-mail attachments to your computer and that MobiFon is not responsible for any damages caused by viruses. - 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: mysqld refuse to die
...because not all mysql processes are named mysql and is one (and you know about this) which is for safe running(mysqld_safe or safe_mysqld) which create new threads when another is killed. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Jocelyn Fournier [EMAIL PROTECTED] To: Gelu Gogancea [EMAIL PROTECTED]; Jack Chen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 2:12 PM Subject: Re: mysqld refuse to die Hi, Why not trying killall -9 mysqld ? Regards, Jocelyn - Original Message - From: Gelu Gogancea [EMAIL PROTECTED] To: Jack Chen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 12:08 PM Subject: Re: mysqld refuse to die Hi, If you really wish to kill the mysql daemon in this way : You should try : ps -ef |grep mysql ...show all the mysqld processes and after this must enumarate all pid of processes in a single kill command. E.g. kill -9 1024 1056 ...(processes which are open). But it's more health if you can stop the server using : /etc/rc.d/mysqld stop Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Jack Chen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 7:57 AM Subject: Re: mysqld refuse to die I have just figured out: kill -9 xxx (process number) Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] On Sat, 9 Nov 2002, Jack Chen wrote: Hi All, Please help me with this problem: For some reason, I could not bring down my mysqld by running mysqld stop An error message indicate: fail What's going on? Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; 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 - 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 --- Xnet scaneaza automat toate mesajele impotriva virusilor folosind RAV AntiVirus. Xnet automatically scans all messages for viruses using RAV AntiVirus. Nota: RAV AntiVirus poate sa nu detecteze toti virusii noi sau toate variantele lor. Va rugam sa luati in considerare ca exista un risc de fiecare data cand deschideti fisiere atasate si ca MobiFon nu este responsabila pentru nici un prejudiciu cauzat de virusi. Disclaimer: RAV AntiVirus may not be able to detect all new viruses and variants. Please be aware that there is a risk involved whenever opening e-mail attachments to your computer and that MobiFon is not responsible for any damages caused by viruses. - 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: mysqld refuse to die
Yes.All processes are named mysqld...less one mysqld_safe which is main guilty for keeping mysql daemon in life. P.S. Please tell me (if you wish)...what means AFAIK? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Jocelyn Fournier [EMAIL PROTECTED] To: Gelu Gogancea [EMAIL PROTECTED]; Jack Chen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 2:27 PM Subject: Re: mysqld refuse to die just kill mysqld_safe and then the mysqld process :) (but AFAIK all the mysql thread are names mysqld ??) - Original Message - From: Gelu Gogancea [EMAIL PROTECTED] To: Jocelyn Fournier [EMAIL PROTECTED]; Jack Chen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 12:20 PM Subject: Re: mysqld refuse to die ...because not all mysql processes are named mysql and is one (and you know about this) which is for safe running(mysqld_safe or safe_mysqld) which create new threads when another is killed. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Jocelyn Fournier [EMAIL PROTECTED] To: Gelu Gogancea [EMAIL PROTECTED]; Jack Chen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 2:12 PM Subject: Re: mysqld refuse to die Hi, Why not trying killall -9 mysqld ? Regards, Jocelyn - Original Message - From: Gelu Gogancea [EMAIL PROTECTED] To: Jack Chen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 12:08 PM Subject: Re: mysqld refuse to die Hi, If you really wish to kill the mysql daemon in this way : You should try : ps -ef |grep mysql ...show all the mysqld processes and after this must enumarate all pid of processes in a single kill command. E.g. kill -9 1024 1056 ...(processes which are open). But it's more health if you can stop the server using : /etc/rc.d/mysqld stop Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Jack Chen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 7:57 AM Subject: Re: mysqld refuse to die I have just figured out: kill -9 xxx (process number) Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] On Sat, 9 Nov 2002, Jack Chen wrote: Hi All, Please help me with this problem: For some reason, I could not bring down my mysqld by running mysqld stop An error message indicate: fail What's going on? Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; 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 - 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 --- Xnet scaneaza automat toate mesajele impotriva virusilor folosind RAV AntiVirus. Xnet automatically scans all messages for viruses using RAV AntiVirus. Nota: RAV AntiVirus poate sa nu detecteze toti virusii noi sau toate variantele lor. Va rugam sa luati in considerare ca exista un risc de fiecare data cand deschideti fisiere atasate si ca MobiFon nu este
Re: mysqld refuse to die
Hi, What error you get when try to stop mysql daemon ?..or tell us what is in mysqld.log? Maybe we can help you. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Jack Chen [EMAIL PROTECTED] To: Gelu Gogancea [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 5:45 PM Subject: Re: mysqld refuse to die Thanks you all for your nice suggestions. The thing is, for some reason, I could not stop the mysqld using 'mysqld stop'. Any insight about why this would fail? Another question, which might not be a *pure* mysql one, is: I ran a script to load my mysql database, but it has not finished the job for almost 10 hours and now it is in *wait 4* state. Anything I can do about this? Should I wait till it is done or there is no hope and I just need to stop it and ran again? Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] On Sat, 9 Nov 2002, Gelu Gogancea wrote: Hi, If you really wish to kill the mysql daemon in this way : You should try : ps -ef |grep mysql ...show all the mysqld processes and after this must enumarate all pid of processes in a single kill command. E.g. kill -9 1024 1056 ...(processes which are open). But it's more health if you can stop the server using : /etc/rc.d/mysqld stop Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Jack Chen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 7:57 AM Subject: Re: mysqld refuse to die I have just figured out: kill -9 xxx (process number) Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] On Sat, 9 Nov 2002, Jack Chen wrote: Hi All, Please help me with this problem: For some reason, I could not bring down my mysqld by running mysqld stop An error message indicate: fail What's going on? Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; 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 - 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 --- Xnet scaneaza automat toate mesajele impotriva virusilor folosind RAV AntiVirus. Xnet automatically scans all messages for viruses using RAV AntiVirus. Nota: RAV AntiVirus poate sa nu detecteze toti virusii noi sau toate variantele lor. Va rugam sa luati in considerare ca exista un risc de fiecare data cand deschideti fisiere atasate si ca MobiFon nu este responsabila pentru nici un prejudiciu cauzat de virusi. Disclaimer: RAV AntiVirus may not be able to detect all new viruses and variants. Please be aware that there is a risk involved whenever opening e-mail attachments to your computer and that MobiFon is not responsible for any damages caused by viruses. - 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
Re: accessing mysql from C
Hi, Take a look in mysql.h. #ifdef USE_OLD_FUNCTIONS MYSQL * STDCALL mysql_connect(MYSQL *mysql, const char *host, const char *user, const char *passwd); int STDCALL mysql_create_db(MYSQL *mysql, const char *DB); int STDCALL mysql_drop_db(MYSQL *mysql, const char *DB); #define mysql_reload(mysql) mysql_refresh((mysql),REFRESH_GRANT) #endif #define HAVE_MYSQL_REAL_CONNECT mysql_connect it's already history. Try to use mysql_real_connect() Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Rahul Amaram-RollNo.286 [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 08, 2002 6:34 PM Subject: accessing mysql from C whenever i try to execute a C file which uses the mysql_connect method i get the following error. undefined reference to mysql_connect Please note that I have tried the following options. gcc -lmysqlclient file.c gcc -L /usr/lib/mysql -lmysqlclient file.c gcc -L /usr/lib/mysql -I /usr/include/mysql -lmysqlclient file.c Also note that .so files are not present in /usr/lib/mysql. I'm not sure if these .so are necessary. This is urgent. If you have any idea about how to solve this problem, pleaaae let me know! My version is 4.0.4. Please let me know if any extra rpms other than server, client, shared and devel are necessary for using mysql from C. Rahul. - 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: Returning an Auto-Increment Field
Hi, select last_insert_id(); Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Tim Johnson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 08, 2002 7:04 PM Subject: Returning an Auto-Increment Field Hello All: If I am adding a row to a table that has an auto-increment field, is there a way to query MySQL for the value of that field, once the new row is added? TIA -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com http://www.johnsons-web.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 - 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