RE: Please help me.
Hi You can make a backup of the original table and recreate the table and import. That will help you ASAP Muthukumar Selvarasu, Project Manager, Webmaster Ltd. -Original Message- From: Gary Smith [mailto:g...@primeexalia.com] Sent: Thursday, March 19, 2009 7:25 AM To: Valentin Ionescu; mysql@lists.mysql.com Cc: wi...@lists.mysql.com; mysql-h...@lists.mysql.com Subject: RE: Please help me. Velentin, http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html Note the section for the droping of foreign keys used the contraint name, not the key name. Try this and see if it solves the first problem (of removing the constraint). Then you should be able to drop the column after that. From: Valentin Ionescu [colibry...@yahoo.com] Sent: Wednesday, March 18, 2009 11:27 AM To: mysql@lists.mysql.com Cc: wi...@lists.mysql.com; mysql-h...@lists.mysql.com Subject: Please help me. Hi! My name is Valentin and I am writing to you for the following problem: I created a database containing the table: CREATE TABLE `documents_ex` ( `ID` int(10) unsigned NOT NULL AUTO_INCREMENT, `Journal_ex_ID` int(10) unsigned DEFAULT NULL, `Documents_ID` int(10) unsigned DEFAULT NULL, `Data` datetime DEFAULT NULL, `Nr` varchar(50) DEFAULT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `Journal_ex_ID` (`Journal_ex_ID`,`Documents_ID`,`Data`,`Nr`), KEY `Documents_ID` (`Documents_ID`), CONSTRAINT `documents_ex_ibfk_1` FOREIGN KEY (`Journal_ex_ID`) REFERENCES `journal_ex` (`ID`) ON DELETE CASCADE, CONSTRAINT `documents_ex_ibfk_2` FOREIGN KEY (`Documents_ID`) REFERENCES `documents` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1 After some time I decided to drop 'Journal_ex_ID' column and all its environment from this non empty table. All I tried to do like: alter table documents_ex drop column Journal_ex_ID or alter table documents_ex drop foreign key Journal_ex_ID or alter table documents_ex drop key Journal_ex_ID I receive the same error 150 and I don't know what to do. Please help me. Best regards. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=g...@primeexalia.com -- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe: http://lists.mysql.com/win32?unsub=muthukumar...@hotmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Please help me.
Hi! My name is Valentin and I am writing to you for the following problem: I created a database containing the table: CREATE TABLE `documents_ex` ( `ID` int(10) unsigned NOT NULL AUTO_INCREMENT, `Journal_ex_ID` int(10) unsigned DEFAULT NULL, `Documents_ID` int(10) unsigned DEFAULT NULL, `Data` datetime DEFAULT NULL, `Nr` varchar(50) DEFAULT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `Journal_ex_ID` (`Journal_ex_ID`,`Documents_ID`,`Data`,`Nr`), KEY `Documents_ID` (`Documents_ID`), CONSTRAINT `documents_ex_ibfk_1` FOREIGN KEY (`Journal_ex_ID`) REFERENCES `journal_ex` (`ID`) ON DELETE CASCADE, CONSTRAINT `documents_ex_ibfk_2` FOREIGN KEY (`Documents_ID`) REFERENCES `documents` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1 After some time I decided to drop 'Journal_ex_ID' column and all its environment from this non empty table. All I tried to do like: alter table documents_ex drop column Journal_ex_ID or alter table documents_ex drop foreign key Journal_ex_ID or alter table documents_ex drop key Journal_ex_ID I receive the same error 150 and I don't know what to do. Please help me. Best regards. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Please help me.
Velentin, http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html Note the section for the droping of foreign keys used the contraint name, not the key name. Try this and see if it solves the first problem (of removing the constraint). Then you should be able to drop the column after that. From: Valentin Ionescu [colibry...@yahoo.com] Sent: Wednesday, March 18, 2009 11:27 AM To: mysql@lists.mysql.com Cc: wi...@lists.mysql.com; mysql-h...@lists.mysql.com Subject: Please help me. Hi! My name is Valentin and I am writing to you for the following problem: I created a database containing the table: CREATE TABLE `documents_ex` ( `ID` int(10) unsigned NOT NULL AUTO_INCREMENT, `Journal_ex_ID` int(10) unsigned DEFAULT NULL, `Documents_ID` int(10) unsigned DEFAULT NULL, `Data` datetime DEFAULT NULL, `Nr` varchar(50) DEFAULT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `Journal_ex_ID` (`Journal_ex_ID`,`Documents_ID`,`Data`,`Nr`), KEY `Documents_ID` (`Documents_ID`), CONSTRAINT `documents_ex_ibfk_1` FOREIGN KEY (`Journal_ex_ID`) REFERENCES `journal_ex` (`ID`) ON DELETE CASCADE, CONSTRAINT `documents_ex_ibfk_2` FOREIGN KEY (`Documents_ID`) REFERENCES `documents` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1 After some time I decided to drop 'Journal_ex_ID' column and all its environment from this non empty table. All I tried to do like: alter table documents_ex drop column Journal_ex_ID or alter table documents_ex drop foreign key Journal_ex_ID or alter table documents_ex drop key Journal_ex_ID I receive the same error 150 and I don't know what to do. Please help me. Best regards. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=g...@primeexalia.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: can some please help me -- REPLICATION
Add additional option to my.cnf [mysqld] relay-log-purge=1 On Mon, Aug 11, 2008 at 2:21 AM, Brown, Charles [EMAIL PROTECTED] wrote: Here is what I'm getting mysql change master to master_host = 'naxbmisq01.bmi.com', master_user = 'repl', master_password = 'repl'; ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log mysql reset slave; Query OK, 0 rows affected (0.00 sec) mysql change master to master_host = 'naxbmisq01.bmi.com', master_user = 'repl', master_password = 'repl'; ERROR 29 (HY000): File './naxbmisq02-relay-bin.000157' not found (Errcode: 2) mysql -Original Message- From: David Giragosian [mailto:[EMAIL PROTECTED] Sent: Sunday, August 10, 2008 12:54 PM To: mysql@lists.mysql.com Subject: Re: can some please help me -- REPLICATION On 8/10/08, Jim Lyons [EMAIL PROTECTED] wrote: you should probably just resync your slave. If it hasn't run for over a month then there's not a lot of point in trying to start it up. Even if you did start the slave (which seems doubtful) you'd have over a month's worth of commands to make up. You can tell mysql to not keep relay logs that have already been used. What's the command or setting for this action? --David. This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
can some please help me -- REPLICATION
The background: We are doing replication. The file-system containing the SLAVE's relay-log got filled to capacity. Later on, I noticed replication has not been working for the last month or more. My Action: I deleted the 2 oldest relay-log then attempted to restart SLAVE. Now, the SLAVE will not start. Replication will not start. The SLAVE continues to request for those logs. My Question: What instructions/command can I issue to the SLAVE so it can ignore relay-logs not found? See below for msg I have been getting from the SLAVE -- for all attempts to restart. 080809 2:09:23 [ERROR] Failed to open the relay log 'FIRST' (relay_log_pos 4) 080809 2:09:23 [ERROR] Could not open log file 080809 2:13:58 [ERROR] Error reading master configuration 080809 2:29:49 [ERROR] Error reading master configuration 080809 7:31:40 [ERROR] Error reading master configuration 080809 7:57:32 [ERROR] Failed to open log (file './naxbmisq02-relay-bin.000157', errno 2) 080809 7:57:32 [ERROR] Failed to open the relay log 'FIRST' (relay_log_pos 4) 080809 7:57:32 [ERROR] Could not open log file 080809 8:01:27 [ERROR] Error reading master configuration 080809 8:11:42 [ERROR] Error reading master configuration This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: can some please help me -- REPLICATION
you should probably just resync your slave. If it hasn't run for over a month then there's not a lot of point in trying to start it up. Even if you did start the slave (which seems doubtful) you'd have over a month's worth of commands to make up. You can tell mysql to not keep relay logs that have already been used. Just copy over the masters' files, reset slave and master and start up the slave. On Sun, Aug 10, 2008 at 11:34 AM, Brown, Charles [EMAIL PROTECTED] wrote: The background: We are doing replication. The file-system containing the SLAVE's relay-log got filled to capacity. Later on, I noticed replication has not been working for the last month or more. My Action: I deleted the 2 oldest relay-log then attempted to restart SLAVE. Now, the SLAVE will not start. Replication will not start. The SLAVE continues to request for those logs. My Question: What instructions/command can I issue to the SLAVE so it can ignore relay-logs not found? See below for msg I have been getting from the SLAVE -- for all attempts to restart. 080809 2:09:23 [ERROR] Failed to open the relay log 'FIRST' (relay_log_pos 4) 080809 2:09:23 [ERROR] Could not open log file 080809 2:13:58 [ERROR] Error reading master configuration 080809 2:29:49 [ERROR] Error reading master configuration 080809 7:31:40 [ERROR] Error reading master configuration 080809 7:57:32 [ERROR] Failed to open log (file './naxbmisq02-relay-bin.000157', errno 2) 080809 7:57:32 [ERROR] Failed to open the relay log 'FIRST' (relay_log_pos 4) 080809 7:57:32 [ERROR] Could not open log file 080809 8:01:27 [ERROR] Error reading master configuration 080809 8:11:42 [ERROR] Error reading master configuration This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jim Lyons Web developer / Database administrator http://www.weblyons.com
Re: can some please help me -- REPLICATION
On 8/10/08, Jim Lyons [EMAIL PROTECTED] wrote: you should probably just resync your slave. If it hasn't run for over a month then there's not a lot of point in trying to start it up. Even if you did start the slave (which seems doubtful) you'd have over a month's worth of commands to make up. You can tell mysql to not keep relay logs that have already been used. What's the command or setting for this action? --David.
RE: can some please help me -- REPLICATION
Re: You can tell mysql to not keep relay logs that have already been used. What command does this -Original Message- From: David Giragosian [mailto:[EMAIL PROTECTED] Sent: Sunday, August 10, 2008 12:54 PM To: mysql@lists.mysql.com Subject: Re: can some please help me -- REPLICATION On 8/10/08, Jim Lyons [EMAIL PROTECTED] wrote: you should probably just resync your slave. If it hasn't run for over a month then there's not a lot of point in trying to start it up. Even if you did start the slave (which seems doubtful) you'd have over a month's worth of commands to make up. You can tell mysql to not keep relay logs that have already been used. What's the command or setting for this action? --David. This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: can some please help me -- REPLICATION
Here is what I'm getting mysql change master to master_host = 'naxbmisq01.bmi.com', master_user = 'repl', master_password = 'repl'; ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log mysql reset slave; Query OK, 0 rows affected (0.00 sec) mysql change master to master_host = 'naxbmisq01.bmi.com', master_user = 'repl', master_password = 'repl'; ERROR 29 (HY000): File './naxbmisq02-relay-bin.000157' not found (Errcode: 2) mysql -Original Message- From: David Giragosian [mailto:[EMAIL PROTECTED] Sent: Sunday, August 10, 2008 12:54 PM To: mysql@lists.mysql.com Subject: Re: can some please help me -- REPLICATION On 8/10/08, Jim Lyons [EMAIL PROTECTED] wrote: you should probably just resync your slave. If it hasn't run for over a month then there's not a lot of point in trying to start it up. Even if you did start the slave (which seems doubtful) you'd have over a month's worth of commands to make up. You can tell mysql to not keep relay logs that have already been used. What's the command or setting for this action? --David. This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
please help me.
my operating system is linux redhat 9.0. i am installing mysql 5.0.x binary distribution. Which edition is the most fit in the following editions? And would you like to tell me the difference among these editions? Thanks very much! [image: [ ]] mysql-standard-5.0.22-linux-i686-glibc23.tar.gz http://mysql.oss.eznetsols.org/Downloads/MySQL-5.0/mysql-standard-5.0.22-linux-i686-glibc23.tar.gz 27-May-2006 02:32 26M GZIP compressed docume [image: [TXT]] mysql-standard-5.0.22-linux-i686-glibc23.tar.gz.aschttp://mysql.oss.eznetsols.org/Downloads/MySQL-5.0/mysql-standard-5.0.22-linux-i686-glibc23.tar.gz.asc 27-May-2006 08:52 189 GZIP compressed docume [image: [ ]] mysql-standard-5.0.22-linux-i686-glibc23.tar.gz.md5http://mysql.oss.eznetsols.org/Downloads/MySQL-5.0/mysql-standard-5.0.22-linux-i686-glibc23.tar.gz.md5 27-May-2006 02:32 82 GZIP compressed docume [image: [ ]] mysql-standard-5.0.22-linux-i686-icc-glibc23.tar.gzhttp://mysql.oss.eznetsols.org/Downloads/MySQL-5.0/mysql-standard-5.0.22-linux-i686-icc-glibc23.tar.gz 27-May-2006 02:24 24M GZIP compressed docume [image: [TXT]] mysql-standard-5.0.22-linux-i686-icc-glibc23.tar.gz.aschttp://mysql.oss.eznetsols.org/Downloads/MySQL-5.0/mysql-standard-5.0.22-linux-i686-icc-glibc23.tar.gz.asc 27-May-2006 08:52 189 GZIP compressed docume [image: [ ]] mysql-standard-5.0.22-linux-i686-icc-glibc23.tar.gz.md5http://mysql.oss.eznetsols.org/Downloads/MySQL-5.0/mysql-standard-5.0.22-linux-i686-icc-glibc23.tar.gz.md5 27-May-2006 02:24 86 GZIP compressed docume [image: [ ]] mysql-standard-5.0.22-linux-i686.tar.gzhttp://mysql.oss.eznetsols.org/Downloads/MySQL-5.0/mysql-standard-5.0.22-linux-i686.tar.gz 27-May-2006 07:15 30M GZIP compressed docume [image: [TXT]] mysql-standard-5.0.22-linux-i686.tar.gz.aschttp://mysql.oss.eznetsols.org/Downloads/MySQL-5.0/mysql-standard-5.0.22-linux-i686.tar.gz.asc 27-May-2006 08:52 189 GZIP compressed docume [image: [ ]] mysql-standard-5.0.22-linux-i686.tar.gz.md5http://mysql.oss.eznetsols.org/Downloads/MySQL-5.0/mysql-standard-5.0.22-linux-i686.tar.gz.md5
Re: please help me.
On 6/2/06, yuan edit [EMAIL PROTECTED] wrote: my operating system is linux redhat 9.0. i am installing mysql 5.0.x binary distribution. Which edition is the most fit in the following editions? You notices most of those files are .asc and .md5 used to verify the integrity of the archive after you download it, right? So, reduced to 3 versions to choose. And would you like to tell me the difference among these editions? You can search the MySQL site, and I would advice you to download it from the site, not from this mirror that I never heard of. If you were at the site, there are docs explaining the difference between each version. mysql-standard-5.0.22-linux-i686-glibc23.tar.gz Compiled against glibc-2.3 mysql-standard-5.0.22-linux-i686-icc-glibc23.tar.gz Compiled with ICC?! Dunno, never heard of it and its not at the official MySQL site. mysql-standard-5.0.22-linux-i686.tar.gz Static linked, as far as I know. I strongly advice you to: 1) Never copy and paste a whole web page in a mail. 2) Strip down what is unrelevant of text 3) Clean html tags 4) Learn about md5 and asc. 5) Be thankful that someone read all this blob and answered 6) Download MySQL from www.mysql.com -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ --END GEEK CODE BLOCK-- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Please help me: Boolean fulltext searches, AND instead of OR
John thegimper wrote: This is what i need: Posted by gogman on Monday May 5 2003, @10:42am on the mysql website: MySQL defaults to an 'OR'. Example: 'dog cat' = 'dog OR cat'. Most fulltext search engines default to an 'AND'. These include: AltaVista, Fast Search, Google, Hotbot, Lycos, Northern Light and Yahoo. Excite is an exception that defaults to an 'OR'. It's not clear to me that this is entirely accurate (Google, for example, is a relevance search http://www.google.com/support/bin/answer.py?answer=427topic=352), but I don't think web search engine front ends are particularly relevant in any case. New Feature: set-variable = ft_boolean_default='AND' vs 'OR' ('OR' would be the default setting so as to not break older code) With a 'AND' default 'OR' would have to be explicit. Example: 'dog cat' = 'dog AND cat', 'dog OR cat' - requires 'OR' to be set. Performance tests are indicating a 5-7 times increase in search speed with AND vs OR statements. -- I have done some searches on google and found several people wanting to do the same... but no solutions. Is there still no solution for this? Every large searchengine works like this. Why do you *need* this? More to the point, why should mysql do this? Honestly, I think you are confusing the user interface, the application, and the back end. Your user interface is free to include a search box where the user can type 'dog cat' with the expectation that only documents containing both (AND) will be returned. Your application needs to parse the request and send the proper query to mysql (the back end). Mysql is just a useful tool. It stores your data and provides various forms of full-text searching: Relevance scoring - WHERE MATCH (doc, description) AGAINST ('dog cat') OR searches - WHERE MATCH (doc, description) AGAINST ('dog cat' IN BOOLEAN MODE) AND searches - WHERE MATCH (doc, description) AGAINST ('+dog +cat' IN BOOLEAN MODE) Given these choices, I'm not sure what difference it makes what the default is. You surely don't propose to pass unmodified user input to mysql, as that's not a good idea (see SQL injection http://www.google.com/search?q=SQL+injection). If you want AND searches, simply have your app add the + signs to the user input as it builds the query to send to mysql. If you are determined to change mysql's default behavior, then Sergei has already given a solution earlier in this thread: swap the '+' and ' ' in the ft_boolean_syntax variable. The only objection raised to this was the suggestion that if the user prepends a '+' to a word, it becomes optional (OR instead of AND), but that's a moot point, as your app will, of course, strip the '+' when parsing the user's input. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Please help me: Boolean fulltext searches, AND instead of OR
Is there still no solution for this? Every large searchengine works like this. Quoting: Hi that works fine only now if a user puts + in front of a word that word becomes optional = OR? What i would like is the search to work exactly like before only that it defaults to AND instead of OR. Almost every search engine i have tried, google etc. works like this. black horse cat dog only show results with all words present. This is what i did, set global ft_boolean_syntax = ' +-()~*:|' I really appreciate your help!! From: Sergei Golubchik [EMAIL PROTECTED] To: Jessica Svensson [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Please help me: Boolean fulltext searches, AND instead of OR Date: Wed, 23 Mar 2005 22:32:49 +0100 Hi! On Mar 23, Jessica Svensson wrote: Is there any way i can get results with AND instead of OR? Trying to search for black cat should only return records that contains both black and cat. I'm using the following code to get my result: SELECT * FROM `searchtbl` WHERE MATCH (text) AGAINST ('black cat' IN BOOLEAN MODE); sure there must be an easy way to change the default word separator to AND instead of OR? There is. See ft_boolean_syntax variable - it defines what characters is used for each operator. In particular it defines '+' for must be present and a space ' ' for optionally present words. You want to put the space first (for must be present words) Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ www.mysql.com _ Lättare att hitta drömresan med MSN Resor http://www.msn.se/resor/ - FREE E-MAIL IN 1 MINUTE! - [EMAIL PROTECTED] - http://www.pc.nu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Please help me: Boolean fulltext searches, AND instead of OR
This is what i need: Posted by gogman on Monday May 5 2003, @10:42am on the mysql website: MySQL defaults to an 'OR'. Example: 'dog cat' = 'dog OR cat'. Most fulltext search engines default to an 'AND'. These include: AltaVista, Fast Search, Google, Hotbot, Lycos, Northern Light and Yahoo. Excite is an exception that defaults to an 'OR'. New Feature: set-variable = ft_boolean_default='AND' vs 'OR' ('OR' would be the default setting so as to not break older code) With a 'AND' default 'OR' would have to be explicit. Example: 'dog cat' = 'dog AND cat', 'dog OR cat' - requires 'OR' to be set. Performance tests are indicating a 5-7 times increase in search speed with AND vs OR statements. -- I have done some searches on google and found several people wanting to do the same... but no solutions. Quoting John thegimper [EMAIL PROTECTED]: Is there still no solution for this? Every large searchengine works like this. Quoting: Hi that works fine only now if a user puts + in front of a word that word becomes optional = OR? What i would like is the search to work exactly like before only that it defaults to AND instead of OR. Almost every search engine i have tried, google etc. works like this. black horse cat dog only show results with all words present. This is what i did, set global ft_boolean_syntax = ' +-()~*:|' I really appreciate your help!! From: Sergei Golubchik [EMAIL PROTECTED] To: Jessica Svensson [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Please help me: Boolean fulltext searches, AND instead of OR Date: Wed, 23 Mar 2005 22:32:49 +0100 Hi! On Mar 23, Jessica Svensson wrote: Is there any way i can get results with AND instead of OR? Trying to search for black cat should only return records that contains both black and cat. I'm using the following code to get my result: SELECT * FROM `searchtbl` WHERE MATCH (text) AGAINST ('black cat' IN BOOLEAN MODE); sure there must be an easy way to change the default word separator to AND instead of OR? There is. See ft_boolean_syntax variable - it defines what characters is used for each operator. In particular it defines '+' for must be present and a space ' ' for optionally present words. You want to put the space first (for must be present words) Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ www.mysql.com _ Lättare att hitta drömresan med MSN Resor http://www.msn.se/resor/ - FREE E-MAIL IN 1 MINUTE! - [EMAIL PROTECTED] - http://www.pc.nu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] - FREE E-MAIL IN 1 MINUTE! - [EMAIL PROTECTED] - http://www.pc.nu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Please help me: Boolean fulltext searches, AND instead of OR
Is there any way i can get results with AND instead of OR? Trying to search for black cat should only return records that contains both black and cat. I'm using the following code to get my result: SELECT * FROM `searchtbl` WHERE MATCH (text) AGAINST ('black cat' IN BOOLEAN MODE); sure there must be an easy way to change the default word separator to AND instead of OR? I found this: set-variable = ft_boolean_default='AND' SET ft_boolean_default = 'AND' But it does not work, everything would be sooo much easier if this was possible. black cat is only an example and the real query comes from user input. So it can be anything like +cat -dog +big nose -horse white black -red so parsing the input is not what i want, i just want to change the default word separator to AND instead of OR. Now i´m running 4.1.10 and also tried with 4.0.24 Please help me, there must be a way to change this?!?! _ Hitta rätt på nätet med MSN Sök http://search.msn.se/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Please help me: Boolean fulltext searches, AND instead of OR
Is there any way i can get results with AND instead of OR? Trying to search for black cat should only return records that contains both black and cat. I'm using the following code to get my result: SELECT * FROM `searchtbl` WHERE MATCH (text) AGAINST ('black cat' IN BOOLEAN MODE); sure there must be an easy way to change the default word separator to AND instead of OR? I found this: set-variable = ft_boolean_default='AND' SET ft_boolean_default = 'AND' But it does not work, everything would be sooo much easier if this was possible. I know that i could put a + infront of every word but thats not what i want since the query comes from a searchbox and i dont want to write som code to manipulate the indata so ite shows correctly i just want to change the default word separator from OR to AND. Maybe it´s ft_boolean_syntax that should be changed? If so to what... please help me before i try to strangle myself :P _ Chatt: Träffa nya nätkompisar på Habbo Hotel http://habbohotel.msn.se/habbo/sv/channelizer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Please help me: Boolean fulltext searches, AND instead of OR
I couldn't find much on the variable you were trying to change. Although it may have changed and now be called ft_boolean_syntax. But that still won't help you since it doesn't appear to have an option to change the default separator. I think you will need to add the + to each word if you want the AND behavior. Why are you so averse to parsing? It would make it easier for the user to input search terms. If it's helpful, below is some php code I use for parsing search phrases entered by users. It adds + and * based on quotes or independent words. I wrote it a long time ago and it problem needs to be looked at to make it better, but it's worked for me for a while now. It will give you the AND behavior you are looking for. function prepFullTextSearch($searchVal) { //Split words into list $word_List = explode(' ',trim($searchVal)); //Step through word list to get search phrases $i = 0; $isPhrase= false; foreach($word_List as $word) { $searchItems[$i] = trim( ($isPhrase?$searchItems[$i].' '.$word:$word) ); //Check for start of Phrase if(substr($searchItems[$i],0,1) == '') { $isPhrase = true; } //If not building a phrase, append wildcard (*) to end of word if(!$isPhrase) { $searchItems[$i] .= '*'; $i++; } //Check for end of Phrase if(substr($searchItems[$i],-1) == '') { $isPhrase = false; $i++; } } $searchVal= '+'.implode(' +',$searchItems); return $searchVal; } On Mar 23, 2005, at 2:45 PM, Jessica Svensson wrote: Is there any way i can get results with AND instead of OR? Trying to search for black cat should only return records that contains both black and cat. I'm using the following code to get my result: SELECT * FROM `searchtbl` WHERE MATCH (text) AGAINST ('black cat' IN BOOLEAN MODE); sure there must be an easy way to change the default word separator to AND instead of OR? I found this: set-variable = ft_boolean_default='AND' SET ft_boolean_default = 'AND' But it does not work, everything would be sooo much easier if this was possible. black cat is only an example and the real query comes from user input. So it can be anything like +cat -dog +big nose -horse white black -red so parsing the input is not what i want, i just want to change the default word separator to AND instead of OR. Now i´m running 4.1.10 and also tried with 4.0.24 Please help me, there must be a way to change this?!?! _ Hitta rätt på nätet med MSN Sök http://search.msn.se/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Please help me: Boolean fulltext searches, AND instead of OR
Hi! On Mar 23, Jessica Svensson wrote: Is there any way i can get results with AND instead of OR? Trying to search for black cat should only return records that contains both black and cat. I'm using the following code to get my result: SELECT * FROM `searchtbl` WHERE MATCH (text) AGAINST ('black cat' IN BOOLEAN MODE); sure there must be an easy way to change the default word separator to AND instead of OR? There is. See ft_boolean_syntax variable - it defines what characters is used for each operator. In particular it defines '+' for must be present and a space ' ' for optionally present words. You want to put the space first (for must be present words) Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Please help me: Boolean fulltext searches, AND instead of OR
Hi that works fine only now if a user puts + in front of a word that word becomes optional = OR? What i would like is the search to work exactly like before only that it defaults to AND instead of OR. Almost every search engine i have tried, google etc. works like this. black horse cat dog only show results with all words present. This is what i did, set global ft_boolean_syntax = ' +-()~*:|' I really appreciate your help!! From: Sergei Golubchik [EMAIL PROTECTED] To: Jessica Svensson [EMAIL PROTECTED] CC: mysql@lists.mysql.com Subject: Re: Please help me: Boolean fulltext searches, AND instead of OR Date: Wed, 23 Mar 2005 22:32:49 +0100 Hi! On Mar 23, Jessica Svensson wrote: Is there any way i can get results with AND instead of OR? Trying to search for black cat should only return records that contains both black and cat. I'm using the following code to get my result: SELECT * FROM `searchtbl` WHERE MATCH (text) AGAINST ('black cat' IN BOOLEAN MODE); sure there must be an easy way to change the default word separator to AND instead of OR? There is. See ft_boolean_syntax variable - it defines what characters is used for each operator. In particular it defines '+' for must be present and a space ' ' for optionally present words. You want to put the space first (for must be present words) Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ www.mysql.com _ Lättare att hitta drömresan med MSN Resor http://www.msn.se/resor/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Please help me: Boolean fulltext searches, AND instead of OR
On Wed, 23 Mar 2005 22:22:34 +, Jessica Svensson [EMAIL PROTECTED] said: Hi that works fine only now if a user puts + in front of a word that word becomes optional = OR? What i would like is the search to work exactly like before only that it defaults to AND instead of OR. Almost every search engine i have tried, google etc. works like this. black horse cat dog only show results with all words present. I'm a little late in the discussion but... Are you using a scripting language with MYSQL? It'd be easy w/PHP This is what i did, set global ft_boolean_syntax = ' +-()~*:|' I really appreciate your help!! From: Sergei Golubchik [EMAIL PROTECTED] To: Jessica Svensson [EMAIL PROTECTED] CC: mysql@lists.mysql.com Subject: Re: Please help me: Boolean fulltext searches, AND instead of OR Date: Wed, 23 Mar 2005 22:32:49 +0100 Hi! On Mar 23, Jessica Svensson wrote: Is there any way i can get results with AND instead of OR? Trying to search for black cat should only return records that contains both black and cat. I'm using the following code to get my result: SELECT * FROM `searchtbl` WHERE MATCH (text) AGAINST ('black cat' IN BOOLEAN MODE); sure there must be an easy way to change the default word separator to AND instead of OR? There is. See ft_boolean_syntax variable - it defines what characters is used for each operator. In particular it defines '+' for must be present and a space ' ' for optionally present words. You want to put the space first (for must be present words) Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ www.mysql.com _ Lättare att hitta drömresan med MSN Resor http://www.msn.se/resor/ -- 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]
please help me!
Hi, I am trying to install MySQL without any joy. I would appreciate if you could help me please. Here I have listed the steps I took it to install. 1. I double click on INSTALL-BINARY in mysql.docs 2. Got the message as Windows cannot open this fiel: File: INSTALL-BINARY To open this file, Windows need to know what program created it. Because I do not know the program therefore I used an option as use the Web services to find the appropriate program and I am getting the following error message: Bad Request (Invalid URL) From _http://shell.windows.com/fileassoc/0409/xml/redir.asp?Ext_ (http://shell.windows.com/fileassoc/0409/xml/redir.asp?Ext) =A Your help to install MySql will be highly appreciateed Many Thanks Abdul syed
Replication is currupted ...Please help me...
Hi all. My company has three Mysql DB servers. one is master, the other are slaves. master's version is 3.23.54-log. two slaves's version is 4.0.17 and Os of all servers is linux 7.3 2 days ago, another slave's replication was currupted unexpactedly, but the other slave was ok. I don't know what this replaction was currepted. Anybody know what I do? Please let me know... this is err_message at that time. - 040609 13:09:14 Error in Log_event::read_log_event(): 'Event too big', data_len: 1852795251, event_type: 110 040609 13:09:14 Error reading relay log event: slave SQL thread aborted because of I/O error 040609 13:09:14 Slave: Could not parse relay log event entry. The possible reasons are: the master's binary log is corrupted (you can check this by running 'mysqlbinlog' on the binary log), the slave's relay log is corrupted (you can check this by running 'mysqlbinlog' on the relay log), a network problem, or a bug in the master's or slave's MySQL code. If you want to check the master's or slave's MySQL code. If you want to check the master's binary log or slave's relay log, you will be able to know their names by issuing 'SHOW SLAVE STATUS' on this slave. Error_code: 0 040609 13:32:16 Slave I/O thread exiting, read up to log 'www5-bin.001', position 84904657
RE: Replication is currupted ...Please help me...
May be a full off the filesystem where the relay logbin file is ? Marc. -Message d'origine- De?: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Envoye?: mercredi 9 juin 2004 09:46 A?: [EMAIL PROTECTED] Objet?: Replication is currupted ...Please help me... Hi all. My company has three Mysql DB servers. one is master, the other are slaves. master's version is 3.23.54-log. two slaves's version is 4.0.17 and Os of all servers is linux 7.3 2 days ago, another slave's replication was currupted unexpactedly, but the other slave was ok. I don't know what this replaction was currepted. Anybody know what I do? Please let me know... this is err_message at that time. - 040609 13:09:14 Error in Log_event::read_log_event(): 'Event too big', data_len: 1852795251, event_type: 110 040609 13:09:14 Error reading relay log event: slave SQL thread aborted because of I/O error 040609 13:09:14 Slave: Could not parse relay log event entry. The possible reasons are: the master's binary log is corrupted (you can check this by running 'mysqlbinlog' on the binary log), the slave's relay log is corrupted (you can check this by running 'mysqlbinlog' on the relay log), a network problem, or a bug in the master's or slave's MySQL code. If you want to check the master's or slave's MySQL code. If you want to check the master's binary log or slave's relay log, you will be able to know their names by issuing 'SHOW SLAVE STATUS' on this slave. Error_code: 0 040609 13:32:16 Slave I/O thread exiting, read up to log 'www5-bin.001', position 84904657 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Please help me optimize a MySQL server.
Hi, I'm running a MySQL server on a duel P III 1G, with 2 GB RAM. MySQL 4.0.18 compiled from source. We have 2 webservers running apache, And this is the backend database server. The server is really slow. a select on a table with 138,247 rows takes about 1.6 - 2+ seconds, I have about 50% CPU idle. using MyISAM table types. sure I can provide any statistics about the running server. Do you think that switching to innodb'd help ? Is it a problem with Debian woody ?? Any suggestions are welcomed. Many thanks! -- -- Katoob Main Developer Linux registered user #224950, ICQ #58475622 -- Don't send me any attachment in Micro$oft (.DOC, .PPT) format please Read http://www.fsf.org/philosophy/no-word-attachments.html Preferable attachments: .PDF, .HTML, .TXT Thanx for adding this text to Your signature -- -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT d-(++)@ s+(++):-+++ a-- C+++$ UL+++$ P+++$+ L+++()$+ E+++ W++?$ N o? K-? !w++ !O !M !V !PS@ !PE@ Y+ PGP=+++ t? 5? !X R? tv-- b+@ DI D+ G-- e+ h--++ !r y? --END GEEK CODE BLOCK-- signature.asc Description: Digital signature
Re: Please help me optimize a MySQL server.
Mohammed Sameer [EMAIL PROTECTED] wrote: I'm running a MySQL server on a duel P III 1G, with 2 GB RAM. MySQL 4.0.18 compiled from source. We have 2 webservers running apache, And this is the backend database server. The server is really slow. a select on a table with 138,247 rows takes about 1.6 - 2+ seconds, I have about 50% CPU idle. using MyISAM table types. sure I can provide any statistics about the running server. Do you think that switching to innodb'd help ? Is it a problem with Debian woody ?? Any suggestions are welcomed. Does MySQL use indexes? You can check it with EXPLAIN SELECT: http://dev.mysql.com/doc/mysql/en/EXPLAIN.html Some optimization tips you can find at: http://dev.mysql.com/doc/mysql/en/MySQL_Optimisation.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[uniball@gmx.net: Re: Please help me optimize a MySQL server.]
sorry Egor Egorov, Mutt sent the mail to your private inbox ;) resending to the mailing list. On Wed, May 19, 2004 at 02:02:29PM +0300, Egor Egorov wrote: Mohammed Sameer [EMAIL PROTECTED] wrote: I'm running a MySQL server on a duel P III 1G, with 2 GB RAM. MySQL 4.0.18 compiled from source. We have 2 webservers running apache, And this is the backend database server. The server is really slow. a select on a table with 138,247 rows takes about 1.6 - 2+ seconds, I have about 50% CPU idle. using MyISAM table types. sure I can provide any statistics about the running server. Do you think that switching to innodb'd help ? Is it a problem with Debian woody ?? Any suggestions are welcomed. Thanks for replying... Does MySQL use indexes? You can check it with EXPLAIN SELECT: http://dev.mysql.com/doc/mysql/en/EXPLAIN.html It's phpBB and phpnuke still fighting with them to trash phpnuke default tables. The website is really active, with about 67000 visits/day. We are using a RAID controller for the server. Some optimization tips you can find at: http://dev.mysql.com/doc/mysql/en/MySQL_Optimisation.html I tried all this, but no use. CPU idle is usually 0% a 1.5 gig log file was generated in about 12h or so. move to innodb from MyISAM ? Is it a Debian woody problem ? load balancing ? I tried to do what I can, but nothing improved the performance. -- -- Katoob Main Developer Linux registered user #224950, ICQ #58475622 -- Don't send me any attachment in Micro$oft (.DOC, .PPT) format please Read http://www.fsf.org/philosophy/no-word-attachments.html Preferable attachments: .PDF, .HTML, .TXT Thanx for adding this text to Your signature -- -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT d-(++)@ s+(++):-+++ a-- C+++$ UL+++$ P+++$+ L+++()$+ E+++ W++?$ N o? K-? !w++ !O !M !V !PS@ !PE@ Y+ PGP=+++ t? 5? !X R? tv-- b+@ DI D+ G-- e+ h--++ !r y? --END GEEK CODE BLOCK-- signature.asc Description: Digital signature
Re: Please help me optimize a MySQL server.
Something that small shouldn't really need optimizing. What is the size of your data (mb?, gb?) and what does your query look like? If you are doing a wild card search on a large text field without a full text index, then those times may be the best you're going to get. Many times it's about optimizing your query statement or you indexes rather than MySQL settings. For instance, I have a test machine (Mac G4 400Mhz, 512MB, MySQL 4.0.18) that does a three table join with each table having just over 100,000 rows. My initial query took about 12 seconds, but changing my query statement around a little I got it to just under 1 second. Which is pretty good considering the hardware it's on. What does you explain for the query look like? It's probably doing a full table scan, which means you're bottleneck is the disk. On May 19, 2004, at 3:26 AM, Mohammed Sameer wrote: Hi, I'm running a MySQL server on a duel P III 1G, with 2 GB RAM. MySQL 4.0.18 compiled from source. We have 2 webservers running apache, And this is the backend database server. The server is really slow. a select on a table with 138,247 rows takes about 1.6 - 2+ seconds, I have about 50% CPU idle. using MyISAM table types. sure I can provide any statistics about the running server. Do you think that switching to innodb'd help ? Is it a problem with Debian woody ?? Any suggestions are welcomed. Many thanks! -- -- Katoob Main Developer Linux registered user #224950, ICQ #58475622 -- Don't send me any attachment in Micro$oft (.DOC, .PPT) format please Read http://www.fsf.org/philosophy/no-word-attachments.html Preferable attachments: .PDF, .HTML, .TXT Thanx for adding this text to Your signature -- -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT d-(++)@ s+(++):-+++ a-- C+++$ UL+++$ P+++$+ L+++()$+ E+++ W++?$ N o? K-? !w++ !O !M !V !PS@ !PE@ Y+ PGP=+++ t? 5? !X R? tv-- b+@ DI D+ G-- e+ h--++ !r y? --END GEEK CODE BLOCK-- -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Please help me optimize a MySQL server.
On Wed, May 19, 2004 at 08:47:28AM -0400, Brent Baisley wrote: Something that small shouldn't really need optimizing. What is the size of your data (mb?, gb?) and what does your query look like? If you are doing a wild card search on a large text field without a full text index, then those times may be the best you're going to get. Many times it's about optimizing your query statement or you indexes rather than MySQL settings. mainly we are using 2 databases: 675M for phpbb and 77M for phpnuke. That's not much. Ok, It seems that the actual queries performed by phpbb are optimized. For instance, I have a test machine (Mac G4 400Mhz, 512MB, MySQL 4.0.18) that does a three table join with each table having just over 100,000 rows. My initial query took about 12 seconds, but changing my query statement around a little I got it to just under 1 second. Which is pretty good considering the hardware it's on. What does you explain for the query look like? It's probably doing a full table scan, which means you're bottleneck is the disk. but the server is running on a duel P III with 2 GB RAM and a RAID controller. Do you think there is much to be done, or shall I look for better hardware/or clustering ? On May 19, 2004, at 3:26 AM, Mohammed Sameer wrote: Hi, I'm running a MySQL server on a duel P III 1G, with 2 GB RAM. MySQL 4.0.18 compiled from source. We have 2 webservers running apache, And this is the backend database server. The server is really slow. a select on a table with 138,247 rows takes about 1.6 - 2+ seconds, I have about 50% CPU idle. using MyISAM table types. sure I can provide any statistics about the running server. Do you think that switching to innodb'd help ? Is it a problem with Debian woody ?? Any suggestions are welcomed. Many thanks! -- -- Katoob Main Developer Linux registered user #224950, ICQ #58475622 -- Don't send me any attachment in Micro$oft (.DOC, .PPT) format please Read http://www.fsf.org/philosophy/no-word-attachments.html Preferable attachments: .PDF, .HTML, .TXT Thanx for adding this text to Your signature -- -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT d-(++)@ s+(++):-+++ a-- C+++$ UL+++$ P+++$+ L+++()$+ E+++ W++?$ N o? K-? !w++ !O !M !V !PS@ !PE@ Y+ PGP=+++ t? 5? !X R? tv-- b+@ DI D+ G-- e+ h--++ !r y? --END GEEK CODE BLOCK-- -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- -- Katoob Main Developer Linux registered user #224950, ICQ #58475622 -- Don't send me any attachment in Micro$oft (.DOC, .PPT) format please Read http://www.fsf.org/philosophy/no-word-attachments.html Preferable attachments: .PDF, .HTML, .TXT Thanx for adding this text to Your signature -- -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT d-(++)@ s+(++):-+++ a-- C+++$ UL+++$ P+++$+ L+++()$+ E+++ W++?$ N o? K-? !w++ !O !M !V !PS@ !PE@ Y+ PGP=+++ t? 5? !X R? tv-- b+@ DI D+ G-- e+ h--++ !r y? --END GEEK CODE BLOCK-- signature.asc Description: Digital signature
Re: Please help me optimize a MySQL server.
I wouldn't upgrade until you know where the bottleneck is (CPU, disk, network, or RAM). Since you are using professional software, I wouldn't try to change the queries. Have you made changes to your my.cnf file? Since you have enough ram to hold all the data, ram is probably not your bottleneck. The question is whether you have your system configured to use it. I forget if phpbb and phpnuke use PEAR::DB to access the underlying database. If they do, there is a certain amount of overhead involved that you just can't get around without changing the database access code to use native calls. Are your database and web server on the same machine (a security no-no, but performance yes-yes)? If they are on separate machines, make sure you have a fast connection between them, at least 100MB and make sure it's full duplex. On May 19, 2004, at 10:34 AM, Mohammed Sameer wrote: On Wed, May 19, 2004 at 08:47:28AM -0400, Brent Baisley wrote: Something that small shouldn't really need optimizing. What is the size of your data (mb?, gb?) and what does your query look like? If you are doing a wild card search on a large text field without a full text index, then those times may be the best you're going to get. Many times it's about optimizing your query statement or you indexes rather than MySQL settings. mainly we are using 2 databases: 675M for phpbb and 77M for phpnuke. That's not much. Ok, It seems that the actual queries performed by phpbb are optimized. For instance, I have a test machine (Mac G4 400Mhz, 512MB, MySQL 4.0.18) that does a three table join with each table having just over 100,000 rows. My initial query took about 12 seconds, but changing my query statement around a little I got it to just under 1 second. Which is pretty good considering the hardware it's on. What does you explain for the query look like? It's probably doing a full table scan, which means you're bottleneck is the disk. but the server is running on a duel P III with 2 GB RAM and a RAID controller. Do you think there is much to be done, or shall I look for better hardware/or clustering ? On May 19, 2004, at 3:26 AM, Mohammed Sameer wrote: Hi, I'm running a MySQL server on a duel P III 1G, with 2 GB RAM. MySQL 4.0.18 compiled from source. We have 2 webservers running apache, And this is the backend database server. The server is really slow. a select on a table with 138,247 rows takes about 1.6 - 2+ seconds, I have about 50% CPU idle. using MyISAM table types. sure I can provide any statistics about the running server. Do you think that switching to innodb'd help ? Is it a problem with Debian woody ?? Any suggestions are welcomed. Many thanks! -- -- Katoob Main Developer Linux registered user #224950, ICQ #58475622 -- Don't send me any attachment in Micro$oft (.DOC, .PPT) format please Read http://www.fsf.org/philosophy/no-word-attachments.html Preferable attachments: .PDF, .HTML, .TXT Thanx for adding this text to Your signature -- -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT d-(++)@ s+(++):-+++ a-- C+++$ UL+++$ P+++$+ L+++()$+ E+++ W++?$ N o? K-? !w++ !O !M !V !PS@ !PE@ Y+ PGP=+++ t? 5? !X R? tv-- b+@ DI D+ G-- e+ h--++ !r y? --END GEEK CODE BLOCK-- -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- -- Katoob Main Developer Linux registered user #224950, ICQ #58475622 -- Don't send me any attachment in Micro$oft (.DOC, .PPT) format please Read http://www.fsf.org/philosophy/no-word-attachments.html Preferable attachments: .PDF, .HTML, .TXT Thanx for adding this text to Your signature -- -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT d-(++)@ s+(++):-+++ a-- C+++$ UL+++$ P+++$+ L+++()$+ E+++ W++?$ N o? K-? !w++ !O !M !V !PS@ !PE@ Y+ PGP=+++ t? 5? !X R? tv-- b+@ DI D+ G-- e+ h--++ !r y? --END GEEK CODE BLOCK-- -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Please help me optimize a MySQL server.
On Wed, May 19, 2004 at 11:36:38AM -0400, Brent Baisley wrote: I wouldn't upgrade until you know where the bottleneck is (CPU, disk, network, or RAM). Since you are using professional software, I wouldn't try to change the queries. Have you made changes to your my.cnf file? Since you have enough ram to hold all the data, ram is probably not your bottleneck. The question is whether you have your system configured to use it. Here is the uncommented parts in the /etc/my.cnf: [client] port= 3306 socket = /tmp/mysql.sock [mysqld] port= 3306 socket = /tmp/mysql.sock key_buffer = 384M skip-locking set-variable= max_connections=3500 max_allowed_packet = 1M table_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M myisam_sort_buffer_size = 64M thread_cache = 8 query_cache_size = 32M thread_concurrency = 2 server-id = 1 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash [isamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M I forget if phpbb and phpnuke use PEAR::DB to access the underlying database. If they do, there is a certain amount of overhead involved that you just can't get around without changing the database access code to use native calls. Are your database and web server on the same machine (a security no-no, but performance yes-yes)? If they are on separate machines, make sure you have a fast connection between them, at least 100MB and make sure it's full duplex. I think they don't use it, The database on a separate server, with a 1000MB LAN connection, Same for the 2 webservers. I verified this now. On May 19, 2004, at 10:34 AM, Mohammed Sameer wrote: On Wed, May 19, 2004 at 08:47:28AM -0400, Brent Baisley wrote: Something that small shouldn't really need optimizing. What is the size of your data (mb?, gb?) and what does your query look like? If you are doing a wild card search on a large text field without a full text index, then those times may be the best you're going to get. Many times it's about optimizing your query statement or you indexes rather than MySQL settings. mainly we are using 2 databases: 675M for phpbb and 77M for phpnuke. That's not much. Ok, It seems that the actual queries performed by phpbb are optimized. For instance, I have a test machine (Mac G4 400Mhz, 512MB, MySQL 4.0.18) that does a three table join with each table having just over 100,000 rows. My initial query took about 12 seconds, but changing my query statement around a little I got it to just under 1 second. Which is pretty good considering the hardware it's on. What does you explain for the query look like? It's probably doing a full table scan, which means you're bottleneck is the disk. but the server is running on a duel P III with 2 GB RAM and a RAID controller. Do you think there is much to be done, or shall I look for better hardware/or clustering ? On May 19, 2004, at 3:26 AM, Mohammed Sameer wrote: Hi, I'm running a MySQL server on a duel P III 1G, with 2 GB RAM. MySQL 4.0.18 compiled from source. We have 2 webservers running apache, And this is the backend database server. The server is really slow. a select on a table with 138,247 rows takes about 1.6 - 2+ seconds, I have about 50% CPU idle. using MyISAM table types. sure I can provide any statistics about the running server. Do you think that switching to innodb'd help ? Is it a problem with Debian woody ?? Any suggestions are welcomed. Many thanks! -- -- Katoob Main Developer Linux registered user #224950, ICQ #58475622 -- Don't send me any attachment in Micro$oft (.DOC, .PPT) format please Read http://www.fsf.org/philosophy/no-word-attachments.html Preferable attachments: .PDF, .HTML, .TXT Thanx for adding this text to Your signature -- -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT d-(++)@ s+(++):-+++ a-- C+++$ UL+++$ P+++$+ L+++()$+ E+++ W++?$ N o? K-? !w++ !O !M !V !PS@ !PE@ Y+ PGP=+++ t? 5? !X R? tv-- b+@ DI D+ G-- e+ h--++ !r y? --END GEEK CODE BLOCK-- -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- -- Katoob Main Developer Linux registered user #224950, ICQ #58475622 -- Don't send me any attachment in Micro$oft (.DOC, .PPT) format please Read http://www.fsf.org/philosophy/no-word-attachments.html Preferable attachments: .PDF, .HTML, .TXT Thanx for adding this text to Your signature -- -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT d-(++)@ s+(++):-+++ a-- C+++$ UL+++$ P+++$+ L+++()$+ E+++ W++?$ N o? K-? !w++ !O !M !V !PS@ !PE@ Y+ PGP=+++ t? 5? !X R? tv-- b+@ DI D+ G-- e+ h--++ !r y? --END GEEK
Re: Please help me optimize a MySQL server.
on 05/19/2004 08:36 AM, Brent Baisley at [EMAIL PROTECTED] wrote: I wouldn't upgrade until you know where the bottleneck is (CPU, disk, network, or RAM). Since you are using professional software, I wouldn't try to change the queries. Have you made changes to your my.cnf file? Since you have enough ram to hold all the data, ram is probably not your bottleneck. The question is whether you have your system configured to use it. I forget if phpbb and phpnuke use PEAR::DB to access the underlying database. If they do, there is a certain amount of overhead involved that you just can't get around without changing the database access code to use native calls. Are your database and web server on the same machine (a security no-no, but performance yes-yes)? If they are on separate machines, make sure you have a fast connection between them, at least 100MB and make sure it's full duplex. PhpBB is just php access to mysql, no PEAR::DB involved. I can say from eperience, the phpBB code is kinda bad in regards to how it talks to mysql, on some pages it is not at all uncommon for there to be 10 or more complex querries. I would be willing to bet there are many installed mods on phpBB, they offer stuff like, show all online users which though a nice feature, is heavy on the DB. There are hundreds of these mods, people just copy and paste and install them, before they know it the database is taking 30 selects on every single page load, just so you can say happy birthday to: someuser on every page. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Asking again... please help me!!!
You really need to look at your DW installation/user manual/tutorial: how to set up a site within DW and how to configure a db resource. The mySQL part as such seems to work ok, but I doubt there are any db connections defined yet (ODBC or JDBC). If this is new stuff to you take the ODBC route, it's easier especially if you are on Windows. Jan -Original Message- From: Lost Idols [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 18:15 To: [EMAIL PROTECTED] Subject: Asking again... please help me!!! I did ask this before, but haven't got any help yet. I'm trying this again... so please let me know if you know. Setting up MySQL and PHP on my Mac OS X 10.2 Just made it work... well, at least I now have a databse that I created and a table with two things inserted. I can also see them when I do a SELECT... So, since I know it's working, I started my DW MX to try to work from there, but I just get an error. I've been setting up the database with all the info and when I want to select from the list of databases I just get the following message: HTTP Error Code 404 File Not Found. Here are some possible reasons for the problem: 1) There is no testing server running on the server machine. What's wrong? Any clues here in this list? Staffan PS. I'm a newbie, so please write in newbie language ;-) _ Hitta rätt på nätet med MSN Sök http://search.msn.se/ -- 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]
Asking again... please help me!!!
I did ask this before, but haven't got any help yet. I'm trying this again... so please let me know if you know. Setting up MySQL and PHP on my Mac OS X 10.2 Just made it work... well, at least I now have a databse that I created and a table with two things inserted. I can also see them when I do a SELECT... So, since I know it's working, I started my DW MX to try to work from there, but I just get an error. I've been setting up the database with all the info and when I want to select from the list of databases I just get the following message: HTTP Error Code 404 File Not Found. Here are some possible reasons for the problem: 1) There is no testing server running on the server machine. What's wrong? Any clues here in this list? Staffan PS. I'm a newbie, so please write in newbie language ;-) _ Hitta rätt på nätet med MSN Sök http://search.msn.se/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Asking again... please help me!!!
HTTP 404 is an error code, when you try to reach a file, what is not exist. For example, if you have a webserver, http://mydomain.com and you have only an index.html nothing else, if you write http://mydomain.com/myfile.html then you will get this error, because myfile.html is not an existing file. It's also, if there is no WEBserver on that machine. So it's not MySql or PHP or Mac problem. Vaso -Original Message- From: Lost Idols [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 5:15 PM To: [EMAIL PROTECTED] Subject: Asking again... please help me!!! I did ask this before, but haven't got any help yet. I'm trying this again... so please let me know if you know. Setting up MySQL and PHP on my Mac OS X 10.2 Just made it work... well, at least I now have a databse that I created and a table with two things inserted. I can also see them when I do a SELECT... So, since I know it's working, I started my DW MX to try to work from there, but I just get an error. I've been setting up the database with all the info and when I want to select from the list of databases I just get the following message: HTTP Error Code 404 File Not Found. Here are some possible reasons for the problem: 1) There is no testing server running on the server machine. What's wrong? Any clues here in this list? Staffan PS. I'm a newbie, so please write in newbie language ;-) _ Hitta rätt på nätet med MSN Sök http://search.msn.se/ -- 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: Asking again... please help me!!!
MySQL doesn't return HTTP error codes. Your problem is not with mysql but with Dreamweaver's browser not being pointed at a running webserver. Did you set up Apache (or some other server) when you set up PHP and prove that both are functioning? Matt -Original Message- From: Lost Idols [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 11:15 AM To: [EMAIL PROTECTED] Subject: Asking again... please help me!!! I did ask this before, but haven't got any help yet. I'm trying this again... so please let me know if you know. Setting up MySQL and PHP on my Mac OS X 10.2 Just made it work... well, at least I now have a databse that I created and a table with two things inserted. I can also see them when I do a SELECT... So, since I know it's working, I started my DW MX to try to work from there, but I just get an error. I've been setting up the database with all the info and when I want to select from the list of databases I just get the following message: HTTP Error Code 404 File Not Found. Here are some possible reasons for the problem: 1) There is no testing server running on the server machine. What's wrong? Any clues here in this list? Staffan PS. I'm a newbie, so please write in newbie language ;-) _ Hitta rätt på nätet med MSN Sök http://search.msn.se/ -- 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: Someone PLEASE Help Me!!! This should be really easy for you folks!
At 05:16 PM 10/17/03 -0700, you wrote: I desperately need everyone's help. I normally build database driven websites on NT Servers with an MS Access database, using perl 5 to read/write the database. Now I need to build a website that can handle a database with almost a gigabyte worth of images to catalog (no it's not porn). Ideally I would like to use the same method BUT the only hosts i can find that will offer that much disk space only use Unix and MySQL. I, However, have never used MySQL. I have used sql statements in the perl script to read/write the MS Access database, but i have never used MySQL. I need someone to tell me would I have to buy some software to build a MySQL database? Is there a free download that i can use to build the database? Where would I find it to download/purchase it? Is there an easy example of what statements I could use from a perl script to add, delete and read a single entry or a whole range of entries from the database? Can someone please help me? I'm desperate! Alternatively, if someone knows of a host that offers that much space and MS Access capatibility for around $10 a month that would certainly work too. Thank you everyone for your help and time in this. Sincerely, Mike Tiny Bailey Author of What Have We Done? The Dragon Chronicles Mike, I'm learning MySQL also. Should be really easy with your background Try this. 30 days free: http://www.webyog.com/sqlyog You can change database structure or data values in the GUI, and read the resulting MySQL statements in the other window. John -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Someone PLEASE Help Me!!! This should be really easy for you folks!
I desperately need everyone's help. I normally build database driven websites on NT Servers with an MS Access database, using perl 5 to read/write the database. Now I need to build a website that can handle a database with almost a gigabyte worth of images to catalog (no it's not porn). Ideally I would like to use the same method BUT the only hosts i can find that will offer that much disk space only use Unix and MySQL. I, However, have never used MySQL. I have used sql statements in the perl script to read/write the MS Access database, but i have never used MySQL. I need someone to tell me would I have to buy some software to build a MySQL database? Is there a free download that i can use to build the database? Where would I find it to download/purchase it? Is there an easy example of what statements I could use from a perl script to add, delete and read a single entry or a whole range of entries from the database? Can someone please help me? I'm desperate! Alternatively, if someone knows of a host that offers that much space and MS Access capatibility for around $10 a month that would certainly work too. Thank you everyone for your help and time in this. Sincerely, Mike Tiny Bailey Author of What Have We Done? The Dragon Chronicles
Re: Someone PLEASE Help Me!!! This should be really easy for you folks!
On Fri, 2003-10-17 at 20:16, Mike Bailey wrote: I desperately need everyone's help. I normally build database driven websites on NT Servers with an MS Access database, using perl 5 to read/write the database. Now I need to build a website that can handle a database with almost a gigabyte worth of images to catalog (no it's not porn). Ideally I would like to use the same method BUT the only hosts i can find that will offer that much disk space only use Unix and MySQL. I, However, have never used MySQL. I have used sql statements in the perl script to read/write the MS Access database, but i have never used MySQL. I need someone to tell me would I have to buy some software to build a MySQL database? Is there a free download that i can use to build the database? Where would I find it to download/purchase it? MySQL is GPL'd software. It's free. You can purchase a license if you need a warranty, support or if you want to distribute the software as part of a non-GPL'd package. You can download either a Linux or Windows version from www.mysql.com. Is there an easy example of what statements I could use from a perl script to add, delete and read a single entry or a whole range of entries from the database? I assume you're using DBI in your Perl scripts. (I wasn't aware that Access had an SQL server engine. I thought you had to use SQLServer for that.) MySQL and Perl should work essentially the same as Access and Perl. Just use a MySQL driver instead of an Access driver. There will likely be slight variations in the dialects of SQL spoken by the two databases, of course, but it shouldn't be anything too difficult to sort out. There's also a mailing list for Perl and MySQL if you run into problems. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Please help me!
Hi! I am new here and wonder if anyone could help me with a problem in my community. The adress is http://trashankarna.net/community/default.php I can't figure this out. I get this message when I choose to read a message in my outbox/utkorg: Warning: 1 is not a valid MySQL-Link resource in C:\apache\htdocs\community\meddelanden\lasaut.php on line 69 I can read the message, anyway. My lasaut.php looks like this: ?php @session_start(); @$user = $iwcuser; @$pass = $iwcpass; if(!$user) { echo(script language=JavaScript); echo(self.location.replace('http://trashankarna.net/community/login/ouch.php')); echo(/script); } $open = mysql_connect(localhost, community, tarot); $info = mysql_db_query(iwcusers, SELECT * FROM users WHERE username = '$user', $open); $rad = mysql_fetch_array($info); if($user == $rad[username] $pass == $rad[password]) { ? ?php // top.inc ? ?php require ('c:\\apache\htdocs\community\_inc\top.inc'); ? ?php // Innehåll ? table cellpadding=0 cellspacing=0 style=border-width: 1pt; border-color: #00; border-style: solid align=left tr td class=menux width=20/td td class=menuxbrspan class=rubrikLäs e-postmeddelande/spanbrimg src=/community/_media/line.gif vspace=5 height=1 width=100%/td td class=menux width=10/td /tr tr td class=menux width=10/td td class=menux width=600 height=200 valign=topspan class=brodtext a href=/community/meddelanden/skriv.php class=bodylankSkriv ett e-postmeddelande/a | a href=/community/meddelanden/adressbok.php class=bodylankMin adressbok/a | a href=/community/meddelanden/mappar.php class=bodylankSkapa mapp/a | p ?php $open = mysql_connect(localhost, community, tarot); $db = mysql_db_query(iwepost, SELECT * FROM meddelanden WHERE id = '$id'); $rad = mysql_fetch_array ($db); print $rad[subject]; print | ; print $rad[datum]; print brbr; print pre class=body; print $rad[body]; print /pre; print Tillbaka till a href=/community/meddelanden/default.php class=bodylankinkorgen/a; mysql_close($open); ? p ?php // bottom.inc ? ?php require ('c:\\apache\htdocs\community\_inc\bottom.inc'); ? ?php mysql_close($open); ? ?php } ? My lasa.php looks like this: ?php @session_start(); @$user = $iwcuser; @$pass = $iwcpass; if(!$user) { echo(script language=JavaScript); echo(self.location.replace('http://trashankarna.net/community/login/ouch.php')); echo(/script); } $open = mysql_connect(localhost, community, tarot); $info = mysql_db_query(iwcusers, SELECT * FROM users WHERE username = '$user', $open); $rad = mysql_fetch_array($info); if($user == $rad[username] $pass == $rad[password]) { ? ?php // top.inc ? ?php require ('c:\\apache\htdocs\community\_inc\top.inc'); ? ?php // Innehåll ? table cellpadding=0 cellspacing=0 style=border-width: 1pt; border-color: #00; border-style: solid align=left tr td class=menux width=20/td td class=menuxbrspan class=rubrikLäs e-postmeddelande/spanbrimg src=/community/_media/line.gif vspace=5 height=1 width=100%/td td class=menux width=10/td /tr tr td class=menux width=10/td td class=menux width=600 height=200 valign=topspan class=brodtext a href=/community/meddelanden/skriv.php class=bodylankSkriv ett e-postmeddelande/a | a href=/community/meddelanden/adressbok.php class=bodylankMin adressbok/a | a href=/community/meddelanden/mappar.php class=bodylankSkapa mapp/a | p ?php $open = mysql_connect(localhost, community, tarot); $db = mysql_db_query(iwepost, SELECT * FROM meddelanden WHERE id = '$id'); $rad = mysql_fetch_array ($db); print $rad[subject]; print | ; print $rad[datum]; print brbr; print pre class=body; print $rad[body]; print /pre; print Tillbaka till a href=/community/meddelanden/default.php class=bodylankinkorgen/a; mysql_close($open); $open = mysql_connect(localhost, community, tarot); mysql_db_query(iwepost, UPDATE meddelanden SET last = 'j' WHERE id = '$id'); ? p ?php // bottom.inc ? ?php require ('c:\\apache\htdocs\community\_inc\bottom.inc'); ? ?php mysql_close($open); ? ?php } ? Someone has tried my community from another computer that isn't within the network, and every seem to work, but not E-post. When they did choose to read a message in the inbox they got this message: Warning: MySQL Connection Failed: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in C:\apache\htdocs\community\meddelanden\lasa.php on line 43 I have made changes from localhost to my domain http://trashankarna.net in the httpd.conf file, so this
RE: Please help me!
As this is really a PHP specific question, you may get a better response on the PHP general mailing list at http://www.php.net/mailing-lists.php Anyway, if my limited experience in PHP serves correctly, you may need to call echo(mysql_error()); near the potentially troublesome code. Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Varghonan [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 10:36 AM To: [EMAIL PROTECTED] Subject: Please help me! Hi! I am new here and wonder if anyone could help me with a problem in my community. The adress is http://trashankarna.net/community/default.php I can't figure this out. I get this message when I choose to read a message in my outbox/utkorg: Warning: 1 is not a valid MySQL-Link resource in C:\apache\htdocs\community\meddelanden\lasaut.php on line 69 I can read the message, anyway. My lasaut.php looks like this: ?php @session_start(); @$user = $iwcuser; @$pass = $iwcpass; if(!$user) { echo(script language=JavaScript); echo(self.location.replace('http://trashankarna.net/community/login/ouch.php')); echo(/script); } $open = mysql_connect(localhost, community, tarot); $info = mysql_db_query(iwcusers, SELECT * FROM users WHERE username = '$user', $open); $rad = mysql_fetch_array($info); if($user == $rad[username] $pass == $rad[password]) { ? ?php // top.inc ? ?php require ('c:\\apache\htdocs\community\_inc\top.inc'); ? ?php // Innehåll ? table cellpadding=0 cellspacing=0 style=border-width: 1pt; border-color: #00; border-style: solid align=left tr td class=menux width=20/td td class=menuxbrspan class=rubrikLäs e-postmeddelande/spanbrimg src=/community/_media/line.gif vspace=5 height=1 width=100%/td td class=menux width=10/td /tr tr td class=menux width=10/td td class=menux width=600 height=200 valign=topspan class=brodtext a href=/community/meddelanden/skriv.php class=bodylankSkriv ett e-postmeddelande/a | a href=/community/meddelanden/adressbok.php class=bodylankMin adressbok/a | a href=/community/meddelanden/mappar.php class=bodylankSkapa mapp/a | p ?php $open = mysql_connect(localhost, community, tarot); $db = mysql_db_query(iwepost, SELECT * FROM meddelanden WHERE id = '$id'); $rad = mysql_fetch_array ($db); print $rad[subject]; print | ; print $rad[datum]; print brbr; print pre class=body; print $rad[body]; print /pre; print Tillbaka till a href=/community/meddelanden/default.php class=bodylankinkorgen/a; mysql_close($open); ? p ?php // bottom.inc ? ?php require ('c:\\apache\htdocs\community\_inc\bottom.inc'); ? ?php mysql_close($open); ? ?php } ? My lasa.php looks like this: ?php @session_start(); @$user = $iwcuser; @$pass = $iwcpass; if(!$user) { echo(script language=JavaScript); echo(self.location.replace('http://trashankarna.net/community/login/ouch.php')); echo(/script); } $open = mysql_connect(localhost, community, tarot); $info = mysql_db_query(iwcusers, SELECT * FROM users WHERE username = '$user', $open); $rad = mysql_fetch_array($info); if($user == $rad[username] $pass == $rad[password]) { ? ?php // top.inc ? ?php require ('c:\\apache\htdocs\community\_inc\top.inc'); ? ?php // Innehåll ? table cellpadding=0 cellspacing=0 style=border-width: 1pt; border-color: #00; border-style: solid align=left tr td class=menux width=20/td td class=menuxbrspan class=rubrikLäs e-postmeddelande/spanbrimg src=/community/_media/line.gif vspace=5 height=1 width=100%/td td class=menux width=10/td /tr tr td class=menux width=10/td td class=menux width=600 height=200 valign=topspan class=brodtext a href=/community/meddelanden/skriv.php class=bodylankSkriv ett e-postmeddelande/a | a href=/community/meddelanden/adressbok.php class=bodylankMin adressbok/a | a href=/community/meddelanden/mappar.php class=bodylankSkapa mapp/a | p ?php $open = mysql_connect(localhost, community, tarot); $db = mysql_db_query(iwepost, SELECT * FROM meddelanden WHERE id = '$id'); $rad = mysql_fetch_array ($db); print $rad[subject]; print | ; print $rad[datum]; print brbr; print pre class=body; print $rad[body]; print /pre; print Tillbaka till a href=/community/meddelanden/default.php class=bodylankinkorgen/a; mysql_close($open); $open = mysql_connect(localhost, community, tarot); mysql_db_query(iwepost, UPDATE meddelanden SET last = 'j' WHERE id = '$id'); ? p ?php // bottom.inc ? ?php require ('c:\\apache\htdocs\community\_inc\bottom.inc'); ? ?php mysql_close($open
please help me
i have deleted mysql database, can i restore it with start defaults ? Thanks, Thailon, Slovakia -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re: please help me
On Friday 28 March 2003 13:59, Ing.Peter Misovic wrote: i have deleted mysql database, can i restore it with start defaults ? mysql_install_db is your solution. :) Thailon, Slovakia -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: please help me - problem with innodb foreign keys
Natale, please address these general questions to [EMAIL PROTECTED] InnoDB requires that the indexes are created explicitly. It would require a change to MySQL to automate the creation of them. Without indexes foreign key checks would be very slow because then every check would have to do a table scan. Regards, Heikki Innobase Oy sql query - Original Message - From: Natale Babbo [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 14, 2003 5:52 PM Subject: please help me - problem with innodb foreign keys # - PLEASE HELP -- # hi, i've a problem with innodb foreign keys creation as following: is it still true that mysql/innodb needs explicit index creation on foreign keys? why can't i use a standard syntax for foreign keys creations? i have a database schema (ddl) with over 50 tables and i was trying to create the database on mysql when i receive a lot of errors like this: ERROR 1005: Can't create table (errno 150) how can i create the database without creating explicitly an index on each foreign keys of my database? any suggestions are appreciated. Please help me. Many thanks. __ Yahoo! Cellulari: loghi, suonerie, picture message per il tuo telefonino http://it.yahoo.com/mail_it/foot/?http://it.mobile.yahoo.com/index2002.html - 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
Please, help me to realize a dream....with mysqlclient library...
Hi, I'm a newer in database programming with C APIs, so the problem arose with the gcc compiler shouldn't surprise you. Now, here the problem. I've installed the Mysql server/client appliaction for win2000. After that, I enjoy the header files (mysql.h) to write a little program in C. The compiling was ok but once I've tried to build the program the gcc compiler gave me the following indication (and also the VisulaC++ compiler): gcc -c main.c Mysql_BuildIF.c -s -mwindows -mno-cygwin -fnative-struct -IC:\ mysql\include\ -IC:\ProgramFiles\MicrosoftVisualStudio\VC98\include gcc -o MySQL_BuildIF.exe main.o Mysql_BuildIF.o -LC:\mysql\lib\debug\mysql client.lib -LC:\ProgramFiles\MicrosoftVisualStudio\VC98\LIB -s -mwindows -mno-c ygwin -fnative-struct -IC:\mysql\include\ -IC:\ProgramFiles\MicrosoftVisualStudi o\VC98\include Mysql_BuildIF.o(.text+0x59):Mysql_BuildIF.c: undefined reference to `mysql_optio ns@12' Mysql_BuildIF.o(.text+0xfe):Mysql_BuildIF.c: undefined reference to `mysql_init@ 4' Mysql_BuildIF.o(.text+0x158):Mysql_BuildIF.c: undefined reference to `mysql_quer y@8' make: *** [all] Error 1 As the compiler didn't recognize the correct library to link to. Also, hereinafter you'll find attached the makefile I used to buil my Mysql_BuildIF.exe file. As you can see the linked library are in the path C.\mysql\lib\debug as the application had installed the library during its installation. INSTDIR=C:\mysql LIBMYSQL=C:\mysql\lib\debug WINDIR=C:\ProgramFiles\MicrosoftVisualStudio\VC98 ### # Compiler CC=gcc # Parameters given to the compiler CFLAGS=-s -mwindows -mno-cygwin -fnative-struct -I$(INSTDIR)\include\ -I$(WINDIR)\include #-L$(INSTDIR)\lib\ # Change the name of your output file here # OUTPUT=MySQL_BuildIF.exe # Modify your source files here # SRCS=main.c Mysql_BuildIF.c # Change the object files, according to the source files, here # Cconvention=__cdecl OBJS=main.o Mysql_BuildIF.o -L$(LIBMYSQL)\mysqlclient.lib -L$(WINDIR)\LIB -lmysqlclient -lz # Standard targets all: $(CC) -c $(SRCS) $(CFLAGS) $(CC) -o $(OUTPUT) $(OBJS) $(CFLAGS) Ccode: $(CC) -c $(SRCS) $(CFLAGS) test: all ./$(OUTPUT) clean: del *.o Please, what happened?? Fabio Varriale System Engineer ERI/TVA Phone: +39-06-72583940 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Please Help me
Dear sir, when i installed mysql to my unix server. when i run make, i find this error sql_lex.cc:168: `get_hash_symbol' undeclared (first use this function) *** Error code 1 make: Fatal error: Command failed for target `sql_lex.o' Current working directory /usr/local/mysql-3.23.52/sql *** Error code 1 make: Fatal error: Command failed for target `all-recursive' Current working directory /usr/local/mysql-3.23.52/sql *** Error code 1 make: Fatal error: Command failed for target `all-recursive' Current working directory /usr/local/mysql-3.23.52 *** Error code 1 make: Fatal error: Command failed for target `all-recursive-am' Could you please tell me, what can i do? Best Regards, Amany Younis ENG. AMANY YOUNIS COMMUNICATION DEPARTMENT IDSC ( INFORMATION AND DECISION SUPPORT CENTER) Phone 002-02-7391366 002-02-7391342 Fax 002-02-7391388 - 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
Please help me with this fulltext query!
Hi! I have 2 tables Table 'candidate_index' holds information like firstName,lastName,phoneNumber etc. Example id | firstName | lastName | phoneNumber 1 | Peter | Engström | 3236363 2 | John| Smith | 3773737 ... Table 'candidate_skills' holds the skills a candidate have Example id | candidateID | skill | 1 | 1 | Office 2000 | 2 | 1 | PHP | 3 | 2 | C++ | 4 | 1 | Java | 4 | 2 | Java | ... I want to make a fulltext search in both the candidate information + the skills. Is this possible? How do I do it? If I for example search for '+peter +java' I want candidate 1 to come up as a hit. Do I need to group the skills with the candidate info? How do I do this? Is it a good idea to create an extra table called 'candidate_fulltext' with one big 'text' column and insert all the information and just make the fulltext search in this table? Table 'candidate_fulltext' holds the details about the candidates + the skills Example candidateID | bigtext_to_use_for_searching id| Peter Engström 3236363 Office 2000 PHP Java Or is there another solution? Best regards /Peter Ps I have 50 000 candidates and each candidate have about 10 skills Ds. 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
please help me
I couldn't ./configure and make mysql.The mistake is: the ./bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! You can start the MySQL daemon with: cd . ; ./bin/mysqld_safe You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; run-all-tests Please report any problems with the ./bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com Starting the mysqld server. You can test that it is up and running with the command: ./bin/mysqladmin version [root@guanqun mysql-4.0.1-alpha-pc-linux-gnu-i686]# chown: `mysql': invalid user Starting mysqld daemon with databases from /usr/local/src/zsj/mysql-4.0.1-alpha- pc-linux-gnu-i686/data 020624 12:23:27 mysqld ended [root@guanqun mysql-4.0.1-alpha-pc-linux-gnu-i686]# make make: *** No targets specified and no makefile found. Stop. __ === ÐÂÀËÃâ·Ñµç×ÓÓÊÏä (http://mail.sina.com.cn) ÐÂÀË·ÖÀàÐÅÏ¢£º¶þÊÖÊг¡×ßÒ»×ߣ¬¸Ã³öÊÖʱ¾Í³öÊÖ£¡ (http://classad.sina.com.cn/2shou/) - 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
please help me
I couldn't ./configure and make mysql.The mistake is: the ./bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! You can start the MySQL daemon with: cd . ; ./bin/mysqld_safe You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; run-all-tests Please report any problems with the ./bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com Starting the mysqld server. You can test that it is up and running with the command: ./bin/mysqladmin version [root@guanqun mysql-4.0.1-alpha-pc-linux-gnu-i686]# chown: `mysql': invalid user Starting mysqld daemon with databases from /usr/local/src/zsj/mysql-4.0.1-alpha- pc-linux-gnu-i686/data 020624 12:23:27 mysqld ended [root@guanqun mysql-4.0.1-alpha-pc-linux-gnu-i686]# make make: *** No targets specified and no makefile found. Stop. __ === ÐÂÀËÃâ·Ñµç×ÓÓÊÏä (http://mail.sina.com.cn) ÐÂÀË·ÖÀàÐÅÏ¢£º¶þÊÖÊг¡×ßÒ»×ߣ¬¸Ã³öÊÖʱ¾Í³öÊÖ£¡ (http://classad.sina.com.cn/2shou/) - 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: please help me understand users privileges
At 23:49 29/5/2002 -0400, Charles Brown wrote: Hi, I removed the user= and password= entries from the my.ini file, because I didn't like seeing a password exposed in plain text. This seemed to have no effect on MySQL at all. What are those entries for? Do I need them? What should they be? The MySQL account name and password? No you don't need them if you don't want that the tool queries the server for to see the variables, databases/tables and make reports, in another words them are used for to connect to the server, not for start/stop the server. However you need to consider that the my.ini file is locates at WinDir directory (WINNT\Windows) and for security you need to protect that directory with the Windows directives, in this case the my.ini file even in plain text should be protected. Regards, Miguel -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
please help me understand users privileges
I'm new to MySQL, and just installed the latest production release on Win 2K. I have a few questions on users and privileges, please help me understand. First, when MySQL starts as a service, what user and password does it use to access the database? I created a MySQL account, should I change the MySQL service properties to use that account? Or leave it using Local System account? I installed MySQL while logged in as Administrator. When logged in as Administrator, I can start winmysqladmin, and it comes up with a green light. When I log in as any other user, I get a red light, even when I have added that user to the mysql/user table with a GRANT ALL. How can I get it to come up with a green light for a normal user? I know the MySQL server is running because I can telnet to localhost 3306 and see the MySQL version number pop out. I removed the user= and password= entries from the my.ini file, because I didn't like seeing a password exposed in plain text. This seemed to have no effect on MySQL at all. What are those entries for? Do I need them? What should they be? The MySQL account name and password? Thank you. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.351 / Virus Database: 197 - Release Date: 4/19/2002 - 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: URGENT - ISAMCHK utility - Please help me
Hello. On Mon, May 20, 2002 at 07:17:55PM +0400, [EMAIL PROTECTED] wrote: Hello: I was trying isamchk on my tables. Found one table with deleted blocks. You know, there would be no reason to repair, except to reclaim the disk space of the deleted rows? Used this option to check: ./isamchk -e ~/usr/local/var/events/events.ISM ###output### Data records: 435 Deleted blocks: 375 - check file-size - check delete-chain - check index reference - check data record references index: 1 - check data record references index: 2 - check records and index references ### And to recover ./isamchk -r ~/usr/local/var/events/events.ISM ###output msg### - recovering ISAM-table '/usr/local/var/events/events.ISM' Data records: 435 - Fixing index 1 - Fixing index 2 ### After fixing the table, the table is showing empty. Strange. As there are reported 433 records to exist. Did you shutdown the server while you used isamchk as I recommended in my last mail? If not, take a backup from the table and start from scratch. The .ISD file has got data in that. How can I recover the contents in that table or should I use any other command to fix the tables. No. What you have done should have worked. Regards, Benjamin. [...] At 06:47 PM 5/16/02 +0200, you wrote: [...] Shut down the mysql daemon, run isamchk on all tables to find out which are corrupted and run isamchk -r on those. Then restart mysqld. Do not forget to make backup copies of the tables in question beforehand, in case anything unexpected happens. You can get more information about your version of isamchk with isamchk --help. -- [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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Please Help Me
I am using MySql with Visual Basic. I Got an ERROR when trying to add a new record in situation as under. I have a table Company and a field in that table EmpName char (20) and one record is there value is = Piyush I am trying to add a new record I can add if the value of field is less then or equal to the length of old record len(Piyush) = 6.(Max Length of value from old records) If i will try to add Ashok i can add it BUT If I TRY TO ADD SANDEEP the length is 7 I could not add it. getting an error. and if there is not any record means maximum value from old record is zero then i could not add a record means clearly i could not add FIRST RECORD ANYWAY FORM VISUAL BASIC. what is solution Please help ME. Thanks in Advance - Piyush - 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: Please Help Me
Whats your INSERT statement look like? And does it give any errors back? -Nick I am using MySql with Visual Basic. I Got an ERROR when trying to add a new record in situation as under. I have a table Company and a field in that table EmpName char (20) and one record is there value is = Piyush I am trying to add a new record I can add if the value of field is less then or equal to the length of old record len(Piyush) = 6.(Max Length of value from old records) If i will try to add Ashok i can add it BUT If I TRY TO ADD SANDEEP the length is 7 I could not add it. getting an error. and if there is not any record means maximum value from old record is zero then i could not add a record means clearly i could not add FIRST RECORD ANYWAY FORM VISUAL BASIC. what is solution Please help ME. Thanks in Advance - Piyush - 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 mysql- [EMAIL PROTECTED] To unsubscribe, e-mail mysql- unsubscribe- [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
Please help me
I have installed mysql -3.23.39-pc-linux-gnu-i686 on linux , and i want to use foreign key constraints . what configurations i have to made. please give step by step procedure so that i am able to install in my machine and able to work. waiting for your reply. Regards - 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
Please help me
Asit, Thursday, February 28, 2002, 2:55:01 PM, you wrote: AS I have installed mysql -3.23.39-pc-linux-gnu-i686 on linux , and i want AS to use foreign key constraints . AS what configurations i have to made. please give step by step procedure AS so that i am able to install in my machine and able to work. You should upgrade MySQL Server to 3.23.44 and up. You can read basic info about foreign key constraints if you look at: http://www.mysql.com/doc/A/N/ANSI_diff_Foreign_Keys.html AS waiting for your reply. AS Regards -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
please help me
I have installed mysql -3.23.39-pc-linux-gnu-i686 on linux , and i want to use foreign key constraints . what configurations i have to made. please give step by step procedure so that i am able to install in my machine and able to work. waiting for your reply. Regards - 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: please help me
Hi try http://www.devshed.com/Server_Side/PHP/SoothinglySeamless/page1.html for good tutorials on PHP and MySQL, although biased toward Unix, I suppose it should work in a similar way on IIS. Maybe wrong?! snip ? $dbuser = 'root'; $dbhost = 'localhost'; $dbpass = 'password'; $dbname = 'test2'; $dbtble = 'books'; $mysql_link = mysql_connect($dbhost,$dbuser,$dbpass); $column = mysql_list_fields($dbname,$dbtble,$mysql_link); for($i=0; $i mysql_num_fields($column); $i++ ) { print mysql_field_name($column,$i ).br; } ? -Original Message- From: anandakkumar araskumar [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 12:37 PM To: [EMAIL PROTECTED] Subject: please help me Hi all Iam new to php and iam learning that from scratch.I came across a problem in connecting mysql from php script.I run php in windows2000 under IIS configured to personal web server.I have installed mysql with server and client and both are running in the same machine(ofcourse, i can you use the ipaddress of localhost).I didn't set any username or password with mysql. This is my php script: $link=mysql_connect(localhost); if($link) die(Couldn't connect to mysql.mysql_error() ); print Successfully connected to server; when i execute this program iam getting the following message: Couldn't connect to mysql Anyone please help me as this is very urgent. thanks in advance Regards shahjahan __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 - 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
please help me
Hi all Iam new to php and iam learning that from scratch.I came across a problem in connecting mysql from php script.I run php in windows2000 under IIS configured to personal web server.I have installed mysql with server and client and both are running in the same machine(ofcourse, i can you use the ipaddress of localhost).I didn't set any username or password with mysql. This is my php script: $link=mysql_connect(localhost); if($link) die(Couldn't connect to mysql.mysql_error() ); print Successfully connected to server; when i execute this program iam getting the following message: Couldn't connect to mysql Anyone please help me as this is very urgent. thanks in advance Regards shahjahan __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 - 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: please help me
Although this is not a php list... mysql_connect() returns TRUE on success and FALSE on failuer, so testing $link like if($link) means it did connect. your script should read: $link=mysql_connect(localhost) // the !(bang as it is called) means NOT // so !TRUE == FALSE if(!$link) { printf(Could not connect to mysql server: %s,mysql_error()); } else { //connection is good } or, better yet: if(!$link=mysql_connect(localhost)) { printf(Could not connect:\n%s : %s\n,mysql_errno(),mysql_error()); } else { //connection is good } hope it helps. - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -Original Message- From: anandakkumar araskumar [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 6:37 AM To: [EMAIL PROTECTED] Subject: please help me Hi all Iam new to php and iam learning that from scratch.I came across a problem in connecting mysql from php script.I run php in windows2000 under IIS configured to personal web server.I have installed mysql with server and client and both are running in the same machine(ofcourse, i can you use the ipaddress of localhost).I didn't set any username or password with mysql. This is my php script: $link=mysql_connect(localhost); if($link) die(Couldn't connect to mysql.mysql_error() ); print Successfully connected to server; when i execute this program iam getting the following message: Couldn't connect to mysql Anyone please help me as this is very urgent. thanks in advance Regards shahjahan __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 - 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: please help me
On Thu, 29 Nov 2001, anandakkumar araskumar wrote: Hi all Iam new to php and iam learning that from scratch.I came across a problem in connecting mysql from php script.I run php in windows2000 under IIS configured to personal web server.I have installed mysql with server and client and both are running in the same machine(ofcourse, i can you use the ipaddress of localhost).I didn't set any username or password with mysql. This is my php script: $link=mysql_connect(localhost); if($link) die(Couldn't connect to mysql.mysql_error() ); Perhaps you meant if(!$link) ... Notice the not ! operand. If a link is established then the $link PHP variable will no longer hold the empty string. In PHP all varaibles are automatically initialized to hold an empty string which can also be used interchangeably with the boolean false value. The standard way of connecting is: $link = mysql_connect($db_host, $db_user, $db_pass) OR die(Could not connect to database server.); Here the stuff after OR is executed only if mysql_connect returns false which is the way the C || operator works. Regards, Neil - 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
Please help me restore my table
mysql,hello£¡ There are three table(a,b,c) in my database,Today, I want to delete some records from b; but I regreted very much my having send wrong command :delete from a where id3 I make a mistake, I deleted the records from a table which I shouldn't delete from! Can I restore the records? What can i do ? it is very important for me to restore them! Please help me out! thank you very much! sincerely lvchunli ÂÀ´ºÀû [EMAIL PROTECTED] 2001-11-04 15:23:44 ¡ñ ¡ñ£© ¡ñ ¡ñ £©£Ü¡ñ£¯£Ü¡ñ £¼©§£¾ £¨©§ £¨©§£© £¨£©©§©§ £¨ £¾ £¯£Ü£¯ £© £¨£Ü£¯ £© £¯ £Ü £¯£Ü ×óÈýȦ ÓÒÈýȦ ²±×ÓŤŤ ƨ¹ÉŤŤ Äã¾Í²»»áÀÏ-.~ - 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
please help me .........cannot find -lmysqlcliente
I use Linux RedHat 7.0 I installed and Configured MySQL-3.23.42 I am installing icradius-0.18.1 installing icradius I got the following: make: /usr/bin/ld: cannot find -lmysqlclient collect2: ld returned 1 exit status make: *** [radius] Error 1 Now, i added the line: /proc/6/fd/mysqlclient - - - (that is where I found lmysqlclient) to the file: /etc/ld.so.conf and I did run ldconfig but nothing, I thin tried to install icradius, after make I got the errors as up. My computer is HP Pavilion 9680C PIII 533 Hz, 128 MB RAM. I appreciate your help. kiv _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - 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
please help me .........cannot find -lmysqlcliente
I use Linux RedHat 7.0 I installed and Configured MySQL-3.23.42 I am installing icradius-0.18.1 installing icradius I got the following: make: /usr/bin/ld: cannot find -lmysqlclient collect2: ld returned 1 exit status make: *** [radius] Error 1 Now, i added the line: /proc/6/fd/mysqlclient - - - (that is where I found lmysqlclient) to the file: /etc/ld.so.conf and I did run ldconfig but nothing, I thin tried to install icradius, after make I got the errors as up. My computer is HP Pavilion 9680C PIII 533 Hz, 128 MB RAM. I appreciate your help. kiv _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - 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: please help me .........cannot find -lmysqlcliente
katty Iniguez [EMAIL PROTECTED] writes: I use Linux RedHat 7.0 I installed and Configured MySQL-3.23.42 I am installing icradius-0.18.1 installing icradius I got the following: make: /usr/bin/ld: cannot find -lmysqlclient collect2: ld returned 1 exit status make: *** [radius] Error 1 1) Make sure you have mysql-devel installed 2) Make sure you have -L/where/your/mysqlclientlibrary/is on your linker line Now, i added the line: /proc/6/fd/mysqlclient - - - (that is where I found lmysqlclient) That's something different - /proc/* aren't real files. -- Trond Eivind Glomsrød Red Hat, Inc. - 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: please help me .........cannot find -lmysqlcliente
From: katty Iniguez [EMAIL PROTECTED] make: /usr/bin/ld: cannot find -lmysqlclient collect2: ld returned 1 exit status make: *** [radius] Error 1 Now, i added the line: /proc/6/fd/mysqlclient - - - (that is where I found lmysqlclient) This location probably isn't what you want. You probably want something inside of your mysql instalation directory. --- Rodney Broom Programmer: Desert.Net - 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: Please help me , about mysql replicate!
On Fri, Aug 31, 2001 at 05:44:11PM +0800, Wang Aocheng wrote: Dear All, I have a question: How can build multi-master-host? I have 3 mysql hosts,I want to use mysql data replicate. thanks! And you want all 3 to be masters? If so, you need to configure them in a replication triangle where the master/slave relationship looks like this, where X --Y means Y is a slave of X A -- B -- C -- A Or, easier to visualize in my poor ASCII art: A / ^ / \ v \ B C That should do what you're looking for. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 3 days, processed 33,382,375 queries (110/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
Please help me , about mysql replicate!
Dear All, I have a question: How can build multi-master-host? I have 3 mysql hosts,I want to use mysql data replicate. thanks! wac - 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
alter table mytable order by my_column is too slowly, why? Please help me.
I execute this SQL with mysql 3.23.39 (all platform, Windows98, Windows2000 and Redhat Linux 7.1), but it's very very slowly. alter table mytable order by my_column; mytable has 3,000,000 rows, my_column is define as char(15). But when mytable has 1,000,000 rows, it's very fast, about 1.5 minute. === http://sms.163.comÍøÒ׶ÌÐÅ ·¢×ÔÄÚÐÄ http://love.163.com Ç£ÒÁÖ®ÊÖ¹²ÏíÈËÉú»¶Ó飡NEW£¡ http://alumni.163.com ±ÌÔÆÌ죬»ÆÒ¶µØ£¬Ð£Ô°Ç黳ÒÀÈçÎô - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: FULLTEXT/localisation error - please, please help me
Hi! On Jul 27, Peter Szekszardi wrote: Hi, I have recompiled mysql using the hungarian character set, reindexed all the tables,... I have strange problem now: Ok, could you create a test case for that ? 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
FULLTEXT/localisation error - please, please help me
Hi, I have recompiled mysql using the hungarian character set, reindexed all the tables,... I have strange problem now: If I do: select count(*) from sites where match(site_content) against('tõzsde'); it returns 0. If I do: select count(*) from sites where site_content like % tõzsde %; it returns 38. Of course tõzsde cannot be a stopword, as it is long enough, and this table contains some 1 records, and only a very few of them is relevant. The other interesting thing is, that it works for example with the string értéktõzsde, match-againt finds the relevant records. See the previous conditions below. Regards, Peter Peter Szekszardi wrote: Hi, I have configured MySQL with charset latin2 on a Linux box. I made a big table with a mediumtext filed and a search engine using MySQL match-against. On the Linux box everything looked fine. Now we replaced our server to FreeBSD. I compiled the same source with the same configuration settings. Now I have several problems with special iso-latin2 characters: - For example when I search for a string which contains a character which has the code of F5 (t+F5+zsde), it selects words which is the same but contains the character with code F4 (t+F4+zsde). The difference is that the character F4 is an element of the standard character set also. They look familiar and being afraid of codepage problems some sites use F4 instead of the official F5. A nice behaviour from MySQL that it also select the words with F6 (t+F6+zsde). F5 and F6 completely different letters, although they pronounced nearly the same and the look of letter itself is similar. Again, F6 is the member of the standard codepage. - Another example if I search for a word starts with F5 (F5+rmester), I get no results from MySQL. If I use F6 (F6+rmester) which is grammaticaly completely incorrect, I get the result. This is funny because the result contains F5 (F5+rmester)! (F5 is o with two long diacritics, F4 is o with one small v turned upsidedown on the top of it, F6 is o with two dots on it. F5 F6 are the official characters, but they are different.) I would really apreciate if someone could enlighten me... Where is the problem? Is there a problem wih MySQL? Or the problem is with the localisation function of FreeBSD? Both the previous Linux server and the current BSD has setlocale installed and has the iso-8859.2 locale. I am sorry, but my English might be to week to explain the situation correctly. 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
localisation error - please, please help me
Hi, I have configured MySQL with charset latin2 on a Linux box. I made a big table with a mediumtext filed and a search engine using MySQL match-against. On the Linux box everything looked fine. Now we replaced our server to FreeBSD. I compiled the same source with the same configuration settings. Now I have several problems with special iso-latin2 characters: - For example when I search for a string which contains a character which has the code of F5 (t+F5+zsde), it selects words which is the same but contains the character with code F4 (t+F4+zsde). The difference is that the character F4 is an element of the standard character set also. They look familiar and being afraid of codepage problems some sites use F4 instead of the official F5. A nice behaviour from MySQL that it also select the words with F6 (t+F6+zsde). F5 and F6 completely different letters, although they pronounced nearly the same and the look of letter itself is similar. Again, F6 is the member of the standard codepage. - Another example if I search for a word starts with F5 (F5+rmester), I get no results from MySQL. If I use F6 (F6+rmester) which is grammaticaly completely incorrect, I get the result. This is funny because the result contains F5 (F5+rmester)! (F5 is o with two long diacritics, F4 is o with one small v turned upsidedown on the top of it, F6 is o with two dots on it. F5 F6 are the official characters, but they are different.) I would really apreciate if someone could enlighten me... Where is the problem? Is there a problem wih MySQL? Or the problem is with the localisation function of FreeBSD? Both the previous Linux server and the current BSD has setlocale installed and has the iso-8859.2 locale. I am sorry, but my English might be to week to explain the situation correctly. 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
localisation error - please, please help me
Hi, I have configured MySQL with charset latin2 on a Linux box. I made a big table with a mediumtext filed and a search engine using MySQL match-against. On the Linux box everything looked fine. Now we replaced our server to FreeBSD. I compiled the same source with the same configuration settings. Now I have several problems with special iso-latin2 characters: - For example when I search for a string which contains a character which has the code of F5 (t+F5+zsde), it selects words which is the same but contains the character with code F4 (t+F4+zsde). The difference is that the character F4 is an element of the standard character set also. They look familiar and being afraid of codepage problems some sites use F4 instead of the official F5. A nice behaviour from MySQL that it also select the words with F6 (t+F6+zsde). F5 and F6 completely different letters, although they pronounced nearly the same and the look of letter itself is similar. Again, F6 is the member of the standard codepage. - Another example if I search for a word starts with F5 (F5+rmester), I get no results from MySQL. If I use F6 (F6+rmester) which is grammaticaly completely incorrect, I get the result. This is funny because the result contains F5 (F5+rmester)! (F5 is o with two long diacritics, F4 is o with one small v turned upsidedown on the top of it, F6 is o with two dots on it. F5 F6 are the official characters, but they are different.) I would really apreciate if someone could enlighten me... Where is the problem? Is there a problem wih MySQL? Or the problem is with the localisation function of FreeBSD? Both the previous Linux server and the current BSD has setlocale installed and has the iso-8859.2 locale. I am sorry, but my English might be to week to explain the situation correctly. 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
PLEASE help me!! MySQL Linux Problem
I am having A LOT of trouble compiling the code Simple1.cc which comes with the C++ API for Linux I have extracted the API to a directory in /root/ and MySQL is installed and works in /usr/local/mysql PLEASE someone please help me compile just this simple program. What am I missing? When I compile it I include the path to the header files to mysql and of the mysql API. I am running Suse Linux 7.1 professional with Kernel 2.4 This is what I get when I try and compile it: pc-xxx-31-190-xxx-du:~/mysql++-1.7.9/examples # g++ simple1.cc -I/root/mysql++-1.7.9/sqlplusint/ -I/usr/local/mysql/include /tmp/ccvKKWW7.o: In function `main': /tmp/ccvKKWW7.o(.text+0x30): undefined reference to `MysqlConnection::MysqlConnection(char const *, char const *, char const *, char const *, bool)' /tmp/ccvKKWW7.o(.text+0x55b): undefined reference to `operator(ostream , mysql_ColDataconst_string const )' /tmp/ccvKKWW7.o(.text+0x6a2): undefined reference to `MysqlConnection::~MysqlConnection(void)' /tmp/ccvKKWW7.o(.text+0x80d): undefined reference to `MysqlConnection::~MysqlConnection(void)' /tmp/ccvKKWW7.o(.rodata+0x1ac): undefined reference to `mysql_date type_info node' /tmp/ccvKKWW7.o(.rodata+0x1e4): undefined reference to `mysql_time type_info node' /tmp/ccvKKWW7.o: In function `MysqlDate type_info function': /tmp/ccvKKWW7.o(.gnu.linkonce.t.__tf9MysqlDate+0x18): undefined reference to `mysql_date type_info function' /tmp/ccvKKWW7.o: In function `MysqlTime type_info function': /tmp/ccvKKWW7.o(.gnu.linkonce.t.__tf9MysqlTime+0x18): undefined reference to `mysql_time type_info function' /tmp/ccvKKWW7.o: In function `MysqlRes::~MysqlRes(void)': /tmp/ccvKKWW7.o(.gnu.linkonce.t._._8MysqlRes+0x1b): undefined reference to `MysqlResUse::~MysqlResUse(void)' /tmp/ccvKKWW7.o: In function `MysqlQuery::preview(void)': /tmp/ccvKKWW7.o(.MysqlQuery::gnu.linkonce.t.preview(void)+0x1b): undefined reference to `SQLQuery::str(SQLQueryParms const ) const' /tmp/ccvKKWW7.o: In function `MysqlRes::num_rows(void) const': /tmp/ccvKKWW7.o(.MysqlRes::gnu.linkonce.t.num_rows(void) const+0x14): undefined reference to `mysql_num_rows' /tmp/ccvKKWW7.o: In function `MysqlQuery::store(SQLQueryParms , query_reset)': /tmp/ccvKKWW7.o(.MysqlQuery::gnu.linkonce.t.store(SQLQueryParms , query_reset) +0x40): undefined reference to `SQLQuery::str(SQLQueryParms const , query_reset)' /tmp/ccvKKWW7.o: In function `MysqlFieldNames::MysqlFieldNames(MysqlResUse const *)': /tmp/ccvKKWW7.o(.MysqlFieldNames::gnu.linkonce.t.(MysqlResUse const *)+0x4d): undefined reference to `MysqlFieldNames::init(MysqlResUse const *)' /tmp/ccvKKWW7.o: In function `MysqlResUse::num_fields(void) const': /tmp/ccvKKWW7.o(.MysqlResUse::gnu.linkonce.t.num_fields(void) const+0x12): undefined reference to `mysql_num_fields' /tmp/ccvKKWW7.o: In function `MysqlRes::fetch_row(void) const': /tmp/ccvKKWW7.o(.MysqlRes::gnu.linkonce.t.fetch_row(void) const+0xd8): undefined reference to `mysql_fetch_row' /tmp/ccvKKWW7.o(.MysqlRes::gnu.linkonce.t.fetch_row(void) const+0xec): undefined reference to `mysql_fetch_lengths' /tmp/ccvKKWW7.o: In function `MysqlRes::data_seek(unsigned int) const': /tmp/ccvKKWW7.o(.MysqlRes::gnu.linkonce.t.data_seek(unsigned int) const+0x1c): undefined reference to `mysql_data_seek' /tmp/ccvKKWW7.o: In function `MysqlConnection::store(basic_stringchar, string_char_traitschar, __default_alloc_templatetrue, 0 const )': /tmp/ccvKKWW7.o(.MysqlConnection::gnu.linkonce.t.store(basic_stringchar , string_char_traitschar, __default_alloc_templatetrue, 0 const )+0x1d): undefined reference to `MysqlConnection::store(basic_stringchar, string_char_traitschar, __default_alloc_templatetrue, 0 const , bool)' /tmp/ccvKKWW7.o: In function `FieldTypes::FieldTypes(MysqlResUse const *)': /tmp/ccvKKWW7.o(.FieldTypes::gnu.linkonce.t.(MysqlResUse const *)+0x4d): undefined reference to `FieldTypes::init(MysqlResUse const *)' collect2: ld returned 1 exit status Please please someone help. This is REALLY starting to get on my nerves now!! Thanks lots David Ayliffe ([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: PLEASE help me!! MySQL Linux Problem
Read the man page for gcc and note the command line switch to point the linker at specific libraries, then use those switches on the command line. This is a linker error, rather than a compiler error: Example: g++ myGreatProgram.cpp -L/usr/mysql/lib -lmysqlclient On Wednesday 18 July 2001 15:28, David Ayliffe wrote: I am having A LOT of trouble compiling the code Simple1.cc which comes with the C++ API for Linux I have extracted the API to a directory in /root/ and MySQL is installed and works in /usr/local/mysql PLEASE someone please help me compile just this simple program. What am I missing? When I compile it I include the path to the header files to mysql and of the mysql API. I am running Suse Linux 7.1 professional with Kernel 2.4 This is what I get when I try and compile it: pc-xxx-31-190-xxx-du:~/mysql++-1.7.9/examples # g++ simple1.cc -I/root/mysql++-1.7.9/sqlplusint/ -I/usr/local/mysql/include /tmp/ccvKKWW7.o: In function `main': /tmp/ccvKKWW7.o(.text+0x30): undefined reference to `MysqlConnection::MysqlConnection(char const *, char const *, char const *, char const *, bool)' /tmp/ccvKKWW7.o(.text+0x55b): undefined reference to `operator(ostream , mysql_ColDataconst_string const )' /tmp/ccvKKWW7.o(.text+0x6a2): undefined reference to `MysqlConnection::~MysqlConnection(void)' /tmp/ccvKKWW7.o(.text+0x80d): undefined reference to `MysqlConnection::~MysqlConnection(void)' /tmp/ccvKKWW7.o(.rodata+0x1ac): undefined reference to `mysql_date type_info node' /tmp/ccvKKWW7.o(.rodata+0x1e4): undefined reference to `mysql_time type_info node' /tmp/ccvKKWW7.o: In function `MysqlDate type_info function': /tmp/ccvKKWW7.o(.gnu.linkonce.t.__tf9MysqlDate+0x18): undefined reference to `mysql_date type_info function' /tmp/ccvKKWW7.o: In function `MysqlTime type_info function': /tmp/ccvKKWW7.o(.gnu.linkonce.t.__tf9MysqlTime+0x18): undefined reference to `mysql_time type_info function' /tmp/ccvKKWW7.o: In function `MysqlRes::~MysqlRes(void)': /tmp/ccvKKWW7.o(.gnu.linkonce.t._._8MysqlRes+0x1b): undefined reference to `MysqlResUse::~MysqlResUse(void)' /tmp/ccvKKWW7.o: In function `MysqlQuery::preview(void)': /tmp/ccvKKWW7.o(.MysqlQuery::gnu.linkonce.t.preview(void)+0x1b): undefined reference to `SQLQuery::str(SQLQueryParms const ) const' /tmp/ccvKKWW7.o: In function `MysqlRes::num_rows(void) const': /tmp/ccvKKWW7.o(.MysqlRes::gnu.linkonce.t.num_rows(void) const+0x14): undefined reference to `mysql_num_rows' /tmp/ccvKKWW7.o: In function `MysqlQuery::store(SQLQueryParms , query_reset)': /tmp/ccvKKWW7.o(.MysqlQuery::gnu.linkonce.t.store(SQLQueryParms , query_reset) +0x40): undefined reference to `SQLQuery::str(SQLQueryParms const , query_reset)' /tmp/ccvKKWW7.o: In function `MysqlFieldNames::MysqlFieldNames(MysqlResUse const *)': /tmp/ccvKKWW7.o(.MysqlFieldNames::gnu.linkonce.t.(MysqlResUse const *)+0x4d): undefined reference to `MysqlFieldNames::init(MysqlResUse const *)' /tmp/ccvKKWW7.o: In function `MysqlResUse::num_fields(void) const': /tmp/ccvKKWW7.o(.MysqlResUse::gnu.linkonce.t.num_fields(void) const+0x12): undefined reference to `mysql_num_fields' /tmp/ccvKKWW7.o: In function `MysqlRes::fetch_row(void) const': /tmp/ccvKKWW7.o(.MysqlRes::gnu.linkonce.t.fetch_row(void) const+0xd8): undefined reference to `mysql_fetch_row' /tmp/ccvKKWW7.o(.MysqlRes::gnu.linkonce.t.fetch_row(void) const+0xec): undefined reference to `mysql_fetch_lengths' /tmp/ccvKKWW7.o: In function `MysqlRes::data_seek(unsigned int) const': /tmp/ccvKKWW7.o(.MysqlRes::gnu.linkonce.t.data_seek(unsigned int) const+0x1c): undefined reference to `mysql_data_seek' /tmp/ccvKKWW7.o: In function `MysqlConnection::store(basic_stringchar, string_char_traitschar, __default_alloc_templatetrue, 0 const )': /tmp/ccvKKWW7.o(.MysqlConnection::gnu.linkonce.t.store(basic_stringchar , string_char_traitschar, __default_alloc_templatetrue, 0 const )+0x1d): undefined reference to `MysqlConnection::store(basic_stringchar, string_char_traitschar, __default_alloc_templatetrue, 0 const , bool)' /tmp/ccvKKWW7.o: In function `FieldTypes::FieldTypes(MysqlResUse const *)': /tmp/ccvKKWW7.o(.FieldTypes::gnu.linkonce.t.(MysqlResUse const *)+0x4d): undefined reference to `FieldTypes::init(MysqlResUse const *)' collect2: ld returned 1 exit status Please please someone help. This is REALLY starting to get on my nerves now!! Thanks lots David Ayliffe ([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
HELP! Please help me
My host has set the max_allowed_packet to only 16384, so I'm unable to do large queries, such as submitting large text files into the database. Is there a way to increase the max_allowed_packet? Keeping in mind I'm on a shared host. Thanks in advance! Jez _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Hello please help me out
try echo file.sql mysql -u username -p password databasename or on dos type file.sql mysql -u username -p password databasename That should execute the scripts on the db in question, or you can download a a tool like mysqlgui/mysqlfront and use it to load and run the queries. Sean -Original Message- From: Divakar [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 28, 2001 4:50 AM To: [EMAIL PROTECTED] Subject: Hello please help me out Hi list I am a beginner in the field of mysql I would like to know whether it is possible to run sql scripts(a .sql file) in mysql. if yes please some body tell me how do we do that,. regards Div - 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: Hello please help me out
[EMAIL PROTECTED] wrote: try echo file.sql mysql -u username -p password databasename You mean: ^ cat file.sql | mysql -u username -p password databasename ^ Or, better: mysql -u username -p password databasename file.sql -- Jack Challen Technical Consultant OCSL http://www.ocsl.co.uk/ - 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: Hello please help me out
whoops, yip, **blush** -Original Message- From: Jack Challen [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 28, 2001 10:23 AM To: [EMAIL PROTECTED] Cc: Sean O'Donnell Subject: Re: Hello please help me out [EMAIL PROTECTED] wrote: try echo file.sql mysql -u username -p password databasename You mean: ^ cat file.sql | mysql -u username -p password databasename ^ Or, better: mysql -u username -p password databasename file.sql -- Jack Challen Technical Consultant OCSL http://www.ocsl.co.uk/ - 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
Hello please help me out
Hi list I am a beginner in the field of mysql I would like to know whether it is possible to run sql scripts(a .sql file) in mysql. if yes please some body tell me how do we do that,. regards Div - 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: Hello please help me out
At 9:19 AM +0530 6/28/01, Divakar wrote: Hi list I am a beginner in the field of mysql I would like to know whether it is possible to run sql scripts(a .sql file) in mysql. if yes please some body tell me how do we do that,. The MySQL Reference Manual is your friend: http://www.mysql.com/doc/M/u/Multiple_sql_commands.html regards Div -- Paul DuBois, [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
Could sombody please HELP me
I have a major problem could somebody take a seeress look at this mysql running on cobalt raq4 I have looked through the archives and looked at the manual can not find anything to explain this nothing in the mysql log file I can not access the databases from the web browser I get empty databases Went in at telnet erased all the databases including mysql ran mysql_install_db logged back in with the web browser and the tables were there stopped mysql restarted mysql logged back in with the web browser databases were there but no tables I can see the tables if I telnet in and use mysql Command What is going on have done this about 6 times I really need to fix this Should I reinstall mysql? Should I shoot my server? -- Best regards, Richardmailto:[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
Please HELP ME!!!!!!!!!!!!!!!!!!!!!!!!!!!
k, I followed the instuctions on the MySQL page, downloaded mysql-3.23.36-pc-linux-gnu-i686.tar.gz for redhat linux and then followed the install directions: shell groupadd mysql shell useradd -g mysql mysql shell cd /usr/local shell gunzip /path/to/mysql-VERSION-OS.tar.gz | tar xvf - shell ln -s mysql-VERSION-OS mysql shell cd mysql shell scripts/mysql_install_db -- The install shell chown -R root /usr/local/mysql I got up to this part and it gave me an error, here's what I did, should I have just done it by rpm? Just in case how would I uninstall this if I change my mind to install by rpm instead, or is there anything to uninstall? What do I do? thx, Dave [root@sp mysql]# scripts/mysql_install_db -- The install Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: ./bin/mysqladmin -u root -p password 'new-password' ./bin/mysqladmin -u root -h sp -p password 'new-password' See the manual for more instructions. You can start the MySQL daemon with: cd . ; ./bin/safe_mysqld You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; run-all-tests Please report any problems with the ./bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com [root@sp mysql]# chown -R root /usr/local/mysql -- The problem chown: /usr/local/mysql: No such file or directory - 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: Please HELP ME!!!!!!!!!!!!!!!!!!!!!!!!!!!
[root@sp mysql]# chown -R root /usr/local/mysql -- The problem chown: /usr/local/mysql: No such file or directory Where is mysql installed this messages says it's not in /usr/local/mysql Search your system.. and chown the equivalent of the /usr/local/mysql Bye, B. - 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
PLEASE HELP ME TO START
Hi friends ... I have sent once my problem, but don't know why, I haven't recieved any answer or solution for it ... Actually, I have installed MySql 3.22.21 on my SERVER NT4, and installed the MyODBC, I have installed them on my D drive ( the WINNT is installed on D drive) , and when I type from the command prompt : mysqld --install, a masg pops up saying : Failed to install service That was the first command I made, so is it correct to do that or I shall type sth else ... Please I need help as soon as possible ... I need MySql to start working ... Note ... I wonder if MySql version I have downloaded from the MYSQL DOWNLOAD Site is the suitable one for me... How should I know ? If any one send me the exact link for the downloadable file , It will be great ... Many Thnx in Advance Hanan Khader _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PLEASE HELP ME TO START
At 10:41 4-4-01 +0200, hanan khader wrote: Hi friends ... I have sent once my problem, but don't know why, I haven't recieved any answer or solution for it ... Perhaps because you try to run MySQL on Windows.. I think most people on this list are familiar with MySQL on Linux. I found a link in the manual: http://www.analysisandsolutions.com/code/mybasic.htm This is supposed to be a beginners MySQL tutorial for setting up MySQL on Windooz. Many many links can be found if you use your favorit searchengine. Bye, B. - 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: Please help me finding a sql-statement
HI, If I understand your question, you need two queries: select count(*) as count, ip, value from log group by ip select count(*) as count, ip, value from log group by ip,value that leads to the right direction! thanks! It shows me a the ips with their values and how many times they are in the table. That brings me somehow nearer to the solution but I am still getting mad about not finding exactly what I need (you know that feeling? its like having jam in the head!) I want to get the number of rows which have the same ip and same/different value. The questions are: 1. How many rows have same values for field x and y? 2. How many ips have different values for field x (and same field y)? (more interesting) Lets have a test-table: id value timestamp 1 a 1 a 2 a 2 b 3 a 3 a 3 b The queries should return in this case: 1. 4 rows (have same id/value) 2. 2 (ids have different values for for field 'value') As I am seeking differences here, after this it will be interesting to see a list of this 2 ids and their values: id val 2 a 2 b 3 a 3 b So I could make it to: There are 2 different values for id "2" : a,b There are 2 different values for id "3" : a,b Maybe you got an idea? Many thanks for your attention! A small table for testing: CREATE TABLE test ( id tinyint(1) DEFAULT '0' NOT NULL, value char(1) NOT NULL ); # # Dumping data for table 'test' # INSERT INTO test VALUES ( '1', 'a'); INSERT INTO test VALUES ( '1', 'a'); INSERT INTO test VALUES ( '2', 'a'); INSERT INTO test VALUES ( '2', 'b'); INSERT INTO test VALUES ( '3', 'a'); INSERT INTO test VALUES ( '3', 'a'); INSERT INTO test VALUES ( '3', 'b'); - 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: Please help me finding a sql-statement
Hi, something, that gets quite near to what I want is: select a.id, a.value, b.value from test as a left join test as b on a.id=b.id group by a.id, a.value having a.valueb.value; It spits out the right data, but not the way I want... ++---+---+ | id | value | value | ++---+---+ | 2 | b | a | | 3 | b | a | | 3 | c | a | | 3 | d | a | ++---+---+ Just a little bit closer... Have a nice thread, 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
Re: Please help me finding a sql-statement
Hi, sometimes one has to have the feeling, that somebody wants to help to get it done better! :) I think I got it: select a.id, a.value from test as a left join test as b on a.id=b.id where a.value b.value group by a.id,a.value; Its good to check logtables! Of course I would appreciate suggestions of doing this better! Thanks for your help! Have a nice thread, 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
please, please help me
I'm using MySQL 3.23.29-1 on a Red Hat Linux 7.0 platform. I've all patched the mysql-related bug fixes from Red Hat. I'm using a pentiumiii 800mhz dual processor system. I'm using mysql++ c++ api. My program links well with the sqlplus library and the mysqlclient library, but when I run the linked executable, the program says "segmentation fault" - it says it can't open "mutex.c" ; as I have traced, this error occurs when the program creates a new "Connection" object - I have another computer with the same setting as the above but only one exception that this computer is single processor.(sorry I'm not a native English speaker, so I'm not good at English) On this computer, the same program runs well!!! Please, gurus, help!!! What's my problem? I'll really appreciate your kind help.. Many many thanks in advance. == ¿ì¸® ÀÎÅͳÝ, Daum Æò»ý ¾²´Â ¹«·á E-mail ÁÖ¼Ò ÇѸÞÀÏ³Ý Áö±¸ÃÌ ÇÑ±Û °Ë»ö¼ºñ½º Daum FIREBALL http://www.daum.net - 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
problem installing MyODBC. Please Help Me.
Hi friends, I am a beginner for mysql. finally i was able to set it up. now i have problems to set myodbc upthe error is like "An error occured while copying C:\WINDOWS\SYSTEM\MFC30.DLL the computer asks me to restart the computer and try install again. but it does not work, so i am looking for your suggestions. Thank you in advance, _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Please Help me ..Apache_1.3.17+php-3.0.16+mysql-3.23.32
I can't to compile this I'm getting the following error on my gmake (most snipped for brevity). gcc -DSOLARIS2=280 -DUSE_HSREGEX -DUSE_EXPAT -I./lib/expat-lite -DNO_DL_NEEDED -I/usr/local/include -I/usr/local/include/mysql `./apaci` -L/usr/local/lib -R/usr/local/lib \ -o httpd buildmark.o modules.o modules/php3/libphp3.a modules/standard/libstandard.a main/libmain.a ./os/unix/libos.a ap/libap.a regex/libregex.a lib/expat-lite/libexpat.a -R/usr/local/lib/mysql -L/usr/local/lib/mysql -Lmodules/php3 -L../modules/php3 -L../../modules/php3 -lmodphp3-lpam -lm -ldl -lsocket -lnsl -lresolv -lsocket -lnsl Undefined first referenced symbol in file mysql_get_client_info modules/php3/libphp3.a(mysql.o) mysql_drop_db modules/php3/libphp3.a(mysql.o) mysql_close modules/php3/libphp3.a(mysql.o) mysql_fetch_lengths modules/php3/libphp3.a(mysql.o) mysql_free_result modules/php3/libphp3.a(mysql.o) mysql_create_db modules/php3/libphp3.a(mysql.o) mysql_field_seekmodules/php3/libphp3.a(mysql.o) mysql_list_fields modules/php3/libphp3.a(mysql.o) mysql_fetch_row modules/php3/libphp3.a(mysql.o) mysql_real_querymodules/php3/libphp3.a(mysql.o) mysql_real_connect modules/php3/libphp3.a(mysql.o) mysql_stat modules/php3/libphp3.a(mysql.o) mysql_fetch_field modules/php3/libphp3.a(mysql.o) mysql_list_dbs modules/php3/libphp3.a(mysql.o) mysql_select_db modules/php3/libphp3.a(mysql.o) mysql_store_result modules/php3/libphp3.a(mysql.o) mysql_list_tables modules/php3/libphp3.a(mysql.o) mysql_data_seek modules/php3/libphp3.a(mysql.o) mysql_init modules/php3/libphp3.a(mysql.o) ld: fatal: Symbol referencing errors. No output written to httpd collect2: ld returned 1 exit status make[2]: *** [target_static] Error 1 make[2]: Leaving directory `/scratch/webdev/apache_1.3.12/src' make[1]: *** [build-std] Error 2 make[1]: Leaving directory `/scratch/webdev/apache_1.3.12' make: *** [build] Error 2 Thanks. Fabian Gonzalo [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: Would you please help me?
On Tue, 16 Jan 2001, ±i®p»Ê wrote: Hi, happy new year!! Yesterday morning, I operated MySQL (3.23.28) insert some data into a table , I found a error and could not find any one can help with: - Welcome to the MySQL monitor.Commands end with ; or \g. Your MySQL connection id is 117 to server version: 3.23.28-gamma Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql use gon; Database changed mysql insert into mymp3 (myclass)values('class_four'); ERROR 1062: Duplicate entry '127' for key 1 mysql - Could you please tell me what's wrong with and how to deal wiht it ? Thanks!! fongming from Taiwan ,2001/1/15 Looks like you're trying to insert a UNIQUE value in your database that already exists. do a "SELECT count(myclass) FROM mymp3 WHERE myclass = 'class_four'". If that returns 1, the value already exists. This is caused by the record variable set to PRIMARY KEY or UNIQUE, which prevents you from having two of the same values :) Atle - 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
please help me with charset
Good day all! Please help me with charset adding. I have some strange trouble. I use FreeBSD 4.2 STABLE and MySQL 3.23.28-gamma (compiled from FreeBSD ports) and PHP 4.04. As I understood Latin1 is a default charset. So, I wanted to add cp1251 or koi8_ru. Ok, I add --default-character-set=cp1251 to my mysql start-up script. The problem is: If I connect from console to mysql and type \s (to get status information) it shows: Language: cp1251 Everything seems OK, but if I try to connect via phpMyAdmin or Horde (webmail implementation) it returns - For phpMyAdmin Warning: MySQL Connection Failed: Can't initialize character set 14 (path: default) in /usr/local/www/htdocs/adm/lib.inc.php on line 255 Error For Horde Warning: Can't initialize character set 14 (path: default) in /usr/local/lib/phplib/db_mysql.inc on line 73 I don't know where is my mistake? I do have sql/share/charsets folder with Index and cp1251.conf. I checked Index - records are OK. Should I add something to /etc/my.cnf file? Looking forward to hear from you. Regards, Roman -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: [EMAIL PROTECTED] If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php