Binary
Is there some kind of pattern in fields containing binary data - so you can be sure that is really IS binary!? I.e. if I in my database have a BLOB-field and sometimes write a string, and sometimes a file?! Regards David - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
bug in bdb-table handler ???
hello mysql-team, i am sorry if i do not correctly report this bug, but i do not know how i should make it sure with a script, that you can verify or repeat this bug. however i have a dump of my mysql-database attached to this mail and hope it will be enough. i am using mysql source distribution 3.23.36 with bdb-tablehandler on a linux server. my problem is that the result sets i receive from my tables are not always correct. if i do the select statement: >SELECT MA_Key FROM Counsel_Skill WHERE MA_Key=1 AND CO_Key=1 GROUP BY MA_Key the result set should contain one record (1). sometimes (and i do not know when and why) i receive an empty result set. if this error occurs i do the select statement: >SELECT MA_Key FROM Counsel_Skill WHERE MA_Key=1 AND SK_Key=10 GROUP BY MA_Key and afterwards the first select statement again: >SELECT MA_Key FROM Counsel_Skill WHERE MA_Key=1 AND CO_Key=1 GROUP BY MA_Key and then it works! i do not understand this - can you help me with this problem - it is really important thanks a lot bye kerstin - 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
Direct communication with internet server
Hello to all, Is it possible to communicate with a database that is in a Internet server without using PHP? How can one make? In "Host" it is necessary to put the primary server DNS? Can it be carried out the communication with Delphi? What parameters is it necessary to use? Thank you. Best Regards, Jose Antonio Molina - 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
Driver odbc for mysql
I install the obdc driver for mysql and then anothers database what runing (way others odbc drivers, as infomix) in my computer don´t runing more. Please help
Re: Compilation problems.
At 12:13 PM -0400 5/28/01, Nicu Popovici wrote: >Hello guys, > > I managed to compile succesfully my C program but now when I run it I get >something like the following >--- > >TEST1 >Failed in SELECT , Error: You have an error in your SQL syntax near ')' at >line 1 > > >What I want to ask , I have to do "use my_data_base" first or not ? Very likely, but it's kind of difficult to tell. You don't show us the query that's failing, so it's basically impossible to tell you what's wrong with it... > >Regards, >Nicu -- 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
Re: Compilation problems.
At 10:22 AM -0400 5/28/01, Nicu Popovici wrote: >Hello, > >I took out the m_string.h file from include directive and I get the following >error Well, sure. You already know that you need that file; taking it out won't help anything. > > > gcc -g Bug_Report.c -O -o TEST1 -I/usr/include/mysql -L/usr/lib/mysql >-lmysqlclient -lnsl >/tmp/ccWyxVrf.o: In function `main': >/home/nicu/QA/Bug_Report.c:15: undefined reference to `strmov' >collect2: ld returned 1 exit status > > > >So it seems that I need the m_string.h file for the definition of strmov() >function. > >I did also include the my_global.h file along with m_string.h but I get a >bunch of errors . Can anyone send me some C Api example to see what include >file to use myself. What I suggested was that you include global.h, not my_global.h. Try that. >Regards, >Nicu > > > >Paul DuBois wrote: > >> At 8:46 PM -0400 5/26/01, Nicu Popovici wrote: >> >Hello Sinisa, >> > >> > I managed to get a connection to a database but now when I want to >> >try to make a query on that >> >database I have to use strmov() function defined in m_string.h but >> >at compilation time I get the >> >following errors. >> >JUST BECAUSE I INCLUDED m_string.h into my file >> >> Did you also include any other include files on which m_string.h might >> depend? For instance, line 93 uses the NEAR symbol, which is defined >> in global.h. If you didn't include global.h before m_string.h, you >> will of course have problems. >> >> > >> >gcc -g Bug_Report.c -o first.o -L/usr/lib/mysql >> >-I/usr/include/mysql/ -lmysqlclient >> >In file included from Bug_Report.c:3: >> >/usr/include/mysql/m_string.h:93: parse error before `_dig_vec' >> >/usr/include/mysql/m_string.h:93: warning: data definition has no >> >type or storage class >> >/usr/include/mysql/m_string.h:149: parse error before `pchar' >> >/usr/include/mysql/m_string.h:151: parse error before `pchar' >> >/usr/include/mysql/m_string.h:154: parse error before `s' >> >/usr/include/mysql/m_string.h:156: parse error before `my_string' >> >/usr/include/mysql/m_string.h:169: parse error before `_VARARGS' >> >/usr/include/mysql/m_string.h:170: parse error before `_VARARGS' >> >/usr/include/mysql/m_string.h:171: parse error before `_VARARGS' >> >/usr/include/mysql/m_string.h:172: parse error before `_VARARGS' >> >/usr/include/mysql/m_string.h:173: parse error before `_VARARGS' >> >/usr/include/mysql/m_string.h:174: parse error before `_VARARGS' >> >/usr/include/mysql/m_string.h:209: parse error before `value' >> >/usr/include/mysql/m_string.h:93: warning: array `_dig_vec' assumed >> >to have one element >> > >> > >> >Maybe you have some ideeas . >> > >> >Thank you >> >Nicu >> > >> >Sinisa Milivojevic wrote: >> > >> >> Nicu Popovici writes: >> >> > Hi Sinisa, >> >> > >> >> > I get another error now. It seems that I managed to pass by >> >>that error. Here it is what >> >> > I get now: >> >> > >> >> > -- >> >> > Failed to connect to database! Error Protocol mismatch. Server >> >>Version = 10 Client Version = >> >> > 9 ; >> >> > -- >> >> > >> >> > What shall I do ? >> >> > >> >> > Regards, >> >> > Nicu >> >> > >> >> >> >> Get a newer libmysqlclient version. >> >> >> >> Regards, >> >> >> >> Sinisa >> >> >> >> __ _ _ ___ == MySQL AB >> >> /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic >> >> /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] >> >> /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus >> >>/*/ /*/ /*/\*\_/*/ \*\_/*/ |*| >> >>/*/^^^\*\^^^ > > >> /*/ \*\Developers Team > > > -- 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
connect error
What does this mean and how do I fix it, I just finished installing from source tar. [root@Precious /]# mysql -u root -p Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Dave - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to convert my sql server data into mysql ??
i would like to convert my sql server data into mysql, how can i do ?? /---\ Confidential and/ or privileged information may be contained in this e-mail and any attachments transmitted with it ('Message'). If you are not the addressee indicated in this Message (or responsible for delivery of this Message to such person),you are hereby notified that any dissemination, distribution, printing or copying of this Message or any part thereof is prohibited. Please delete this Message if received in error and advise the sender by return e-mail. Opinions, conclusions and other information in this Message that do not relate to the official business of this company shall be understood as neither given nor endorsed by this company. This mail is certified Virus Free by *ProtectNow! (InternetNow Sdn Bhd) *Scanner Engine powered by Norman Virus Control \--/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help w/MySQL and Dreamweaver Ultradev
- Original Message - From: "Daniele Iachini" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, May 28, 2001 6:50 PM Subject: Help w/MySQL and Dreamweaver Ultradev > I'm not able to manage dates correctly in dreamweaver, expecially when a > form with dates is submitted to update a record. > The singular -mm-dd format of MySQL in fact is correctly put in > dd/mm/ (that's ok for my country and is my locale) but when i submit the > form, even without changes, it isn't recognised any more by MySQL that > zeroes the field or tries to read it a non inverted -mm-dd (obviously > corrupted). Anyone knows a solution or knows the syntax of DoDateTime() > function that seems to be a possible solution? > Is there a place in internet where I can find a complete reference of ASP > command and functions syntax??? I always cringe when I think about the ASP code that is produced by the Macromedia products. However, this problem can be easily solved with an ASP function that you can add to your pages (I would recommend putting it in an include file, but that's just me). As far as I know, none of the options within the FormatDateTime function will format the date to the -MM-DD format used by MySQL (and Oracle too, btw). Therefore, use the following function: <% Function MakeDate(strDate) 'Written by Dennis Salguero If IsDate(strDate) Then Dim m Dim d Dim y m = Month(strDate) d=Day(strDate) y=Year(strDate) MakeDate = y & "-"& m & "-" & d Else MakeDate = strDate End If End Function %> As you can see, this function is very straightforward. It simply breaks down the date you pass into different components and formats it to fit a -MM-DD format, which is understood by MySQL. Good Luck, Dennis ** Beridney Computer Services http://www.beridney.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
Help w/MySQL and Dreamweaver Ultradev
I'm not able to manage dates correctly in dreamweaver, expecially when a form with dates is submitted to update a record. The singular -mm-dd format of MySQL in fact is correctly put in dd/mm/ (that's ok for my country and is my locale) but when i submit the form, even without changes, it isn't recognised any more by MySQL that zeroes the field or tries to read it a non inverted -mm-dd (obviously corrupted). Anyone knows a solution or knows the syntax of DoDateTime() function that seems to be a possible solution? Is there a place in internet where I can find a complete reference of ASP command and functions syntax??? Thanks in advance. MySQL is great;) Daniele. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Help! How to use dBase with mySQL?
I just converted a 48meg 90,000 row dbf file using dbf2mysql off of the MySQL site. Worked very nice for me on Win2K. Cheers Mike -Original Message- From: Pat Suwalski [mailto:[EMAIL PROTECTED]] Sent: Monday, May 28, 2001 6:25 PM To: [EMAIL PROTECTED] Subject: Help! How to use dBase with mySQL? I'm doing a school project for which I'm to write a PHP script with MySQL that searches a dBase database. I've got my code planned out, but the problem right now seems to be that mySQL can't directly read dBase databases. It's a fairly large database (9 megs), and so I ask: do I need to convert it somehow or can I just read it directly? Thanks for any assistance you could spare. --Pat - 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: changing pasword
Martin, You should try the following. It's work for me. mysql> connect mysql; mysql> update user set password=PASSWORD('newpassword') where user='auser'; mysql>FLUSH PRIVILEGES; Regard, Emanduel Chan - Original Message - From: "Martin RODOT" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, May 28, 2001 3:41 PM Subject: changing pasword > Hi ! > > I'm using MySql 3.23.38-nt on a test machine. > > I'd like to create a new user and I tried : > > -- > mysql> connect mysql > Connection id:308 > Current database: mysql > > mysql> set password for auser = password("anewpassword"); > ERROR 1133: Can't find any matching row in the user table > --- > > But I have actually created the user and I can see : > > > mysql> select * from user where user = "auser"; > +---+-+--+-+ > | Host | User| Password | Select_priv | Insert_priv > +---+-+--+-+ > | localhost | auser | 5f1839b1118fb243 | Y | Y > +---+-+--+-+ > 1 row in set (0.00 sec) > mysql> > > > Of course I was connected as super-user with all privileges. > > Does anybody can explain me what is wrong ? > > Regards. > > Martin RODOT > M.R.IT - BLOIS - France > > Welcome in Blois > > - > 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
Error 1030: got error 28 from table handler
Hello, When trying to do a large select statement like the following this error is returned: select account.username,person.firstname,person.lastname, person.company_name, person.street,person.city,person.state, person.zip,person.franchise, person.card_number,person.expires,account.date,transaction.* from person,account left join transaction on account.username=transaction.username where (account.id=person.id) && ((account.day>='1') &&(account.day<='24') &&(account.type!='franchise') &&(person.pay_method='ccard')) order by person.franchise,account.username; I have tried the set SQL_BIG_TABLES flag set to 1, but that did not help and now I'm out of ideas. Any suggestions would be appreciated. Griff Hamlin, III Quik International. - 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
Problems shutting down on OpenBSD
Hello, I am running MySQL 3.23.37 on an OpenBSD 2.8 box. The db is working fine and starts fine but I cannot seem to shut it down... I do mysql.server stop and this is what I see in the logs: 010528 20:59:07 /usr/local/libexec/mysqld: Normal shutdown but the command exits because it is taking too long and mysql is still running... then when I make any attempt to access mysql, THEN it shuts down: 010528 21:00:41 /usr/local/libexec/mysqld: Shutdown Complete 010528 21:00:41 mysqld ended There are no other messages in the .err log... I apologize if this has been covered already but I couldn't find a decent answer in the archives or manual... oh, I also installed mysql from openbsd ports instead of from source... if that makes a difference.. thanks, shawn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Help! How to use dBase with mySQL?
No, MySQL will not read dBase files. I can think of 3 ways to do it off the top of my head. 1: Use Visual FoxPro. It will read dBase files and you can use the DBC to open a connection to a MySQL database through an ODBC connection. (Been there, done that) 2: Use a dialect of *Base to create an insert.sql file that has 1 insert for each record in your dBase table. Then just use : mysql < import.sql to get it into your database. (I'm over simplifying but not much) 3: Use PHP. It can (supposedly) read dbase files and MySQL files. Suck it out of one and push it into another. (Never done this but it sounds like it could work if everything is configured properly. If I were you, I'd use #2, it's the easiest. Cal http://www.calevans.com -Original Message- From: Pat Suwalski [mailto:[EMAIL PROTECTED]] Sent: Monday, May 28, 2001 7:25 PM To: [EMAIL PROTECTED] Subject: Help! How to use dBase with mySQL? I'm doing a school project for which I'm to write a PHP script with MySQL that searches a dBase database. I've got my code planned out, but the problem right now seems to be that mySQL can't directly read dBase databases. It's a fairly large database (9 megs), and so I ask: do I need to convert it somehow or can I just read it directly? Thanks for any assistance you could spare. --Pat - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help! How to use dBase with mySQL?
Pat Suwalski wrote: > > I'm doing a school project for which I'm to write a PHP script with MySQL > that searches a dBase database. > > I've got my code planned out, but the problem right now seems to be that > mySQL can't directly read dBase databases. > > It's a fairly large database (9 megs), and so I ask: do I need to convert it > somehow or can I just read it directly? > > Thanks for any assistance you could spare. > --Pat > Pat: It's been a long time since I've used dbase, but, I believe you can export csv. >From there import into MySQL. You'll have to create the table structure, first. Depending on the table structure, shouldn't take more than a couple hours. Regards, Van -- = Linux rocks!!! http://www.dedserius.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
Help! How to use dBase with mySQL?
I'm doing a school project for which I'm to write a PHP script with MySQL that searches a dBase database. I've got my code planned out, but the problem right now seems to be that mySQL can't directly read dBase databases. It's a fairly large database (9 megs), and so I ask: do I need to convert it somehow or can I just read it directly? Thanks for any assistance you could spare. --Pat - 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: "Match" does not find it, but "Like" finds it
>From http://www.mysql.com/doc/F/u/Fulltext_Search.html: mysql> SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('MySQL'); Empty set (0.00 sec) Search for the word MySQL produces no results in the above example. Word MySQL is present in more than half of rows, and as such, is effectively treated as a stopword (that is, with semantical value zero). It is, really, the desired behavior - a natural language query should not return every second row in 1GB table. So "Netscape" or "Windows" are in more than half of the rows. > Hi, > > Using MySQL 3.23.38, I have a table with a mediumtext field > "contenu" and a fulltext index on it. > The field contains full HTML documents. > > The following command usually works to find words: > > select titre from sites where match(contenu) against ('virus') > > The problem is, some words, like "Netscape" or "Windows", are never found > with MATCH. Other words of the same length are found. > > However, if I use a LIKE, they are found: > > select titre from sites where contenu like '%Netscape%' > > I did not see those words that don't work, in the stopword list > myisam/ft_static.c - 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
"Match" does not find it, but "Like" finds it
Hi, Using MySQL 3.23.38, I have a table with a mediumtext field "contenu" and a fulltext index on it. The field contains full HTML documents. The following command usually works to find words: select titre from sites where match(contenu) against ('virus') The problem is, some words, like "Netscape" or "Windows", are never found with MATCH. Other words of the same length are found. However, if I use a LIKE, they are found: select titre from sites where contenu like '%Netscape%' I did not see those words that don't work, in the stopword list myisam/ft_static.c -- Marc Delisle Service de l'informatique Collège de Sherbrooke, Québec - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Copying to temp table
Use fulltext indexes (http://www.mysql.com/doc/F/u/Fulltext_Search.html). Queries with LIKE '%...%' will always be slow because they can't use indexes, and you're doing SIX of them, of course it'll take a while. Only drawback of fulltext indexes is (AFAIK) you can't match against fields in separate tables in a single fulltext query. > Hi to all of you! > > The following query takes more than half an our to execute. I don't think > that is normal. Most time takes "copying to tmp table". > > SELECT DISTINCT > Formular.titel AS formularTitel, > Formular.id AS formularId, > Anbieter.id AS anbieterId, > Anbieter.anbieterName AS anbieterName > FROM > Formular, > Anbieter > WHERE > Formular.anbieter_id=Anbieter.id > AND > ( Formular.titel LIKE '%köln%' OR Formular.schluesselwoerter LIKE '%köln%' > OR Anbieter.anbieterName LIKE '%köln%' ) > AND > ( Formular.titel NOT LIKE '%gew%' AND Formular.schluesselwoerter NOT LIKE > '%gew%' AND Anbieter.anbieterName NOT LIKE '%gew%' ) > ) - 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
Copying to temp table
Hi to all of you! The following query takes more than half an our to execute. I don't think that is normal. Most time takes "copying to tmp table". SELECT DISTINCT Formular.titel AS formularTitel, Formular.id AS formularId, Anbieter.id AS anbieterId, Anbieter.anbieterName AS anbieterName FROM Formular, Anbieter WHERE Formular.anbieter_id=Anbieter.id AND ( ( Formular.titel LIKE '%köln%' OR Formular.schluesselwoerter LIKE '%köln%' OR Anbieter.anbieterName LIKE '%köln%' ) AND ( Formular.titel NOT LIKE '%gew%' AND Formular.schluesselwoerter NOT LIKE '%gew%' AND Anbieter.anbieterName NOT LIKE '%gew%' ) ) I hope someone can help me. Thanks a lot, Benne -- Benjamin Boksa [EMAIL PROTECTED] side by site GmbH & Co. KG Druckgestaltung & Webdesign Barbarastr. 3-9 (Block 6) D-50735 Koeln Telefon: +49 221 2790964 Telefax: +49 221 2790965 http://www.sidebysite.de/ - 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
Missing file in MyODBC NT/Win2K client?
I've (mostly) switched over from Win98 to Win2K on one of my home machines. I have a Linux box sitting in a closet as a mail/web server, with Apache logging its activity to a MySQL database. To browse the server logs, I threw together a few lines of SQL in Access and had it use MyODBC to talk to the server. Now that I'm running Win2K, I grabbed the appropriate MyODBC client yesterday and tried installing it. However, there appears to be a missing file, myodbc.rsp, which is needed by install.bat to install the client. I took a look in the Win9x client package and saw nothing that applied. What's needed to get MyODBC working under Win2K? Scott Alfter [EMAIL PROTECTED] PGP signature
Re: SQL Problem
>I have a problem adapting a multiple select to MySQL. >Can someone help me ? > >Here is my request (Oracle format) > >SELECT Tactic.teamCode FROM Tactic WHERE >Tactic.teamCode NOT IN (SELECT Game.teamCode1 FROM Game, Turn WHERE >Game.gameTurn = Turn.code) >AND Tactic.teamCode NOT IN (SELECT Game.teamCode2 FROM Game, Turn WHERE >Game.gameTurn = Turn.code); > >I could use the following one, if it's easier to translate to MySQL >SELECT Tactic.teamCode FROM Tactic WHERE >Tactic.teamCode NOT IN (SELECT Game.teamCode1 FROM Game, Turn WHERE >Game.gameTurn = 3) >AND Tactic.teamCode NOT IN (SELECT Game.teamCode2 FROM Game, Turn WHERE >Game.gameTurn = 3); > >Thanks > >Cedric Lefebvre SELECT Tactic.teamCode FROM (Tactic tc LEFT JOIN Game g ON (tc.teamCode = g.teamCode1) OR (tc.teamCode = g.teamCode2)) LEFT JOIN Turn tn ON g.gameTurn = tn.code WHERE (g.teamCode1 IS NULL) AND (g.teamCode2 IS NULL); Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak MySQL list magic words: sql query database - 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: possible to store raw data (like image data)?
Ryan wrote: > > Is it possible to store raw data (like image data) in mysql? If so, how can i >accomplish it? (Should i need to make user-defined type?) Otherewise, what other >databases support storing raw data? You can use blob type. -- _/_/ _/_/_/ - Rafał Jank [EMAIL PROTECTED] - _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 5215625 _/ _/ _/ ==* http://szukaj.wp.pl *==-- - 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
possible to store raw data (like image data)?
Is it possible to store raw data (like image data) in mysql? If so, how can i accomplish it? (Should i need to make user-defined type?) Otherewise, what other databases support storing raw data? - Do You Yahoo!? Yahoo! Auctions $2 Million Sweepstakes - Got something to sell?
RE: Determining Database size via SQL
If you are using only fixed-length (no VARCHARs, TEXTs or BLOBs) MyISAM tables you can calculate it by finding the storage required for each row (http://www.mysql.com/doc/S/t/Storage_requirements.html) and multiplying it by the number of rows. If you are using variable-length MyISAM tables, you should be able to calculate that column's storage requirement by selecting avg(length(column)) from the table for each variable length column. > I need a way to determine the size of a single database on mySQL > via an SQL > command. > > I am running an application on a service provider that gives me a limited > amount of database space for my application. I want to be able to > gauge the > percentage of that space that I am using. The only access I have > been given > to the mySQL database is through JDBC SQL. > > I do not have ANY access to the directories that mySQL is > installed in. In > fact it is on an entirely different machine than the server that runs my > application. And my application can only connect to that server > via the JDBC > drivers for mySQL. > > Anyone have any ideas? > > You can email me directly about this. > > Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Determining Database size via SQL
I need a way to determine the size of a single database on mySQL via an SQL command. I am running an application on a service provider that gives me a limited amount of database space for my application. I want to be able to gauge the percentage of that space that I am using. The only access I have been given to the mySQL database is through JDBC SQL. I do not have ANY access to the directories that mySQL is installed in. In fact it is on an entirely different machine than the server that runs my application. And my application can only connect to that server via the JDBC drivers for mySQL. Anyone have any ideas? You can email me directly about this. Thanks Scott (aka PetSkippy) _ 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
Writing MySQL's log back into log database
Hello, Normally, MySQL maintains a flat log file to write all queries passed to it. Is it possible (any module or whatever) to get it to put this log into a specific database, in order to be processed more efficiently? Thanks for the reply. Maxim Pavlov [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
Having problems with a query..
$newgoalquery = mysql_query("select players.PLAYERID, players.FIRSTNAME, players.LASTNAME, COUNT(goals.SCORER) as TG FROM players, goals where (goals.SCORER = players.PLAYERID) AND players.TEAMID = '$TEAMID' GROUP BY PLAYERID ORDER BY players.LASTNAME"); I'm trying to fetch out the number of goals for each player on the team .. which it does, but if a player has 0 goals, it doesn't return that row, which I need. How can I write this query so it returns that information as well? If I need to post any other info to get an answer, such as my table descriptions, please let me know. Thanks! Chad - 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
BDB tables and mysql.
Hello mysql, I'm testing BDB tables in mysql to find out i'll be able to use them in my application. I was testing how does big tables work with BDB and so created table which is about 10GB in size. I could easy make it with multiple inserts from test-insert, so the problem with insert seems to be fixed now. So I'm trying to do select count(*) from table now and... get error #12 saying BDB is out of locks, therefore my number of lock is 10 which is quite large. With bdb_locks=1.000.000 I was able do do this, but this resulted in ~230Mb of memory wasted for locks which I think is too much (230Bytes for lock is a huge amount) If I'm not mistaken the problem is bdb_locks corresponding to seting of several options of BDB, which is bad thing as only one of them is needed to be so huge,while others do not and are just wasting memory. -- Best regards, Peter mailto:[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: Cannot create table with file named INFILE
> Please check the manual before sending a question to this list.. says every > messages.. So: > > http://www.mysql.com/doc/R/e/Reserved_words.html I read it (please note the (*)): A common problem stems from trying to create a table with column names that use the names of datatypes or functions built into MySQL, such as TIMESTAMP or GROUP. You're allowed to do it(*) (for example, ABS is an allowed column name), but whitespace is not allowed between a function name and the `(' when using functions whose names are also column names. (*) It is rather confusing. Is is alloweed or it is forbidden? Maybe it is alloweed only for the functions but it is not so clear. In this case the manual is not enough, I suppose. > Workaround: give your table another name. > It's a joke? I'm porting my application from another database where that INFILE field was alloweed, so it is not so easy. My hope was that maybe there is in a kind of quoting or escape sequence that disables keyword matching. Regards Alessandro Staltari. - 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 and Word Documents ...
On Tue, 22 May 2001, Jeremy Zawodny wrote: > On Tue, May 22, 2001 at 10:37:20PM +0100, Nii Larnyoh wrote: > > I have just loaded a MICROSOFT WORD document to be stored in a mySQL > > blob column. I will like to know if the blob column that will be > > indexed by the FULLTEXT indexer? > > Given that it's not [just] text, what do you expect to happen? I'd > expect it to either not work at all, or to work in a semi-broken way. I agree. To make it work WORD documents can be piped through some filter and be stored as pure ascii in text tables. It might look like: wvWare -x /usr/local/share/wv/wvHtml.xml %s 2>/dev/null \ | w3m -dump -T text/html where %s means your *.doc file. You have linux, don't you? Thomas - 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: Is MySQL BeoWulf compatible?
No, MySQL is neither PVM nor MPI aware and thus not a Beowulf application. Had you asked this on the Beowulf mailing list they would have said too because *by definition* Beowulf is solely intended for computational clusters, not high availability or parallel database clusters. Regards, Gary "SuperID" Huntress === FreeSQL.org offering free database hosting to developers Visit http://www.freesql.org - Original Message - From: "Vinche" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, May 28, 2001 3:40 AM Subject: Is MySQL BeoWulf compatible? > Subj. > Can I set it up on a cluster? I have so heavy load on my > MySQL server that I need to increase the power of my server. > I consider different ways of doing it and want to know if > somebody installed it successfully on a cluster. > > Best regards, > Vinche mailto:[EMAIL PROTECTED] > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: copying to tmp table
Paste EXPLAIN SELECT ... (your SELECT); from the mysql client. > Hi! > > When I join 4 tables with about 3000 records in each mysql seems to work > forever on "copying to tmp table". > > I wonder what that could be. I have enough free space in the tmp-dir and > don't know what else could it be. > > The database-model is normalized and on another machine it takes > me about 1 > second to get a response. > > The strange thing about it is, that it worked before. - 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: Cannot create table with file named INFILE
Please check the manual before sending a question to this list.. says every messages.. So: http://www.mysql.com/doc/R/e/Reserved_words.html Workaround: give your table another name. Bye, B. At 14:23 28-5-01 +0200, Alessandro Staltari wrote: >Hello. I'm new to MySQL but I have a problem that appears serious, al >least for me. >I can't create a table with a field named INFILE. I think mysql consider >INFILE as a keyword. Is there work around for this? >Shouldn't INFILE be used only within a LOAD statement? I think it is a bug >in the query parser? > >Regards > >Alessandro Staltari - 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
Replication
Hi, Excuse my english pleasei'll try to explain what i have to do. I have two server running MySQL, at this time one is a master and the other a slave. What I have to do is to make both master and slave together so if the master gows down the system still work with the slavelike a cluster, could someone help me? Thanks, Rodrigo Gonzalez.
copying to tmp table
Hi! When I join 4 tables with about 3000 records in each mysql seems to work forever on "copying to tmp table". I wonder what that could be. I have enough free space in the tmp-dir and don't know what else could it be. The database-model is normalized and on another machine it takes me about 1 second to get a response. The strange thing about it is, that it worked before. So if anyone is able to help me please do so. Thank you, Benjamin Boksa -- Benjamin Boksa [EMAIL PROTECTED] side by site GmbH & Co. KG Druckgestaltung & Webdesign Barbarastr. 3-9 (Block 6) D-50735 Koeln Telefon: +49 221 2790964 Telefax: +49 221 2790965 http://www.sidebysite.de/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: question...
First, you need to REVOKE any existing priviledges for that user, then GRANT the privileges you wish that user to have. This is detailed in the MySQL Manual (http://www.mysql.com/doc/G/R/GRANT.html). G. Jensen - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, May 28, 2001 5:34 AM Subject: question... > > hi > > hope this is the correct list for questions...if not , sorry > > i have a mysql server under linux, works fine but, if a user has an mysql > account eg: "XYZ" and connects then he can take a look into the other DB, of > other users ..he cant change any things. how i can set the permission for > read the DB for own DB only? is running as user "mysql/ group dameon" > > the user connect via a GUI Client.../ PhpAdmin or so... > > thx cya > > > - > 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
Cannot create table with file named INFILE
Hello. I'm new to MySQL but I have a problem that appears serious, al least for me. I can't create a table with a field named INFILE. I think mysql consider INFILE as a keyword. Is there work around for this? Shouldn't INFILE be used only within a LOAD statement? I think it is a bug in the query parser? Regards Alessandro Staltari
RE: SQL Problem
In fact this does not return me what I want : If I have the tables Tactic teamCode 1 teamCode 2 teamCode 3 teamCode 4 Game teamCode1 1 teamCode2 3 GameTurn 1 teamCode4 1 teamCode2 3 GameTurn 1 Turn Code 1 My request would return me nothing while your request would return me different sets with at least Tactic.teamCode 2 / Game.TeamCode1 1 / Game.TeamCode2 3 / GameTurn 1 So your answer is not right at all. Does someone has a clue ? Cedric Lefebvre > Something like > > SELECT Tactic.teamCode > FROM Tactic t, Game g, Turn r > WHERE t.teamCode <> g.teamCode1 > AND t.teamCode <> g.teamCode2 > AND g.gameTurn = r.code; > > ...and even the table "Turn" may not be necessary, depending > on the values > in your tables and what you want to do with it. > > > - Original Message - > From: "Lefebvre, Cedric" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, May 28, 2001 14:41 > Subject: SQL Problem > > > > I have a problem adapting a multiple select to MySQL. > > Can someone help me ? > > > > Here is my request (Oracle format) > > > > SELECT Tactic.teamCode FROM Tactic WHERE > > Tactic.teamCode NOT IN (SELECT Game.teamCode1 FROM Game, Turn WHERE > > Game.gameTurn = Turn.code) > > AND Tactic.teamCode NOT IN (SELECT Game.teamCode2 FROM > Game, Turn WHERE > > Game.gameTurn = Turn.code); > > > > I could use the following one, if it's easier to translate to MySQL > > SELECT Tactic.teamCode FROM Tactic WHERE > > Tactic.teamCode NOT IN (SELECT Game.teamCode1 FROM Game, Turn WHERE > > Game.gameTurn = 3) > > AND Tactic.teamCode NOT IN (SELECT Game.teamCode2 FROM > Game, Turn WHERE > > Game.gameTurn = 3); > > > > Thanks > > > > Cedric Lefebvre > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with installation [MySQL GUI]
Buyondo Charles writes: > I'm running RedHat 7.0 with mysql-server-3.23.22-6. When I try installin the rpm I >get the > following message "MySQL-server is needed by mysqlgui-static-1.7.1-1" > > Hi! Please use our latest 1.7.5 static binary for Linux instead of RPM. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SQL Problem
On Mon, 28 May 2001, Lefebvre, Cedric wrote: > > I have a problem adapting a multiple select to MySQL. > Can someone help me ? > > Here is my request (Oracle format) > > SELECT Tactic.teamCode FROM Tactic WHERE > Tactic.teamCode NOT IN (SELECT Game.teamCode1 FROM Game, Turn WHERE > Game.gameTurn = Turn.code) > AND Tactic.teamCode NOT IN (SELECT Game.teamCode2 FROM Game, Turn WHERE > Game.gameTurn = Turn.code); > > I could use the following one, if it's easier to translate to MySQL > SELECT Tactic.teamCode FROM Tactic WHERE > Tactic.teamCode NOT IN (SELECT Game.teamCode1 FROM Game, Turn WHERE > Game.gameTurn = 3) > AND Tactic.teamCode NOT IN (SELECT Game.teamCode2 FROM Game, Turn WHERE > Game.gameTurn = 3); > bonjour, You can't use subselect. -- jean-michel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql++ Vector/ Row problem
Tiwonge Nathan Kawonga writes: > Hi all; > When I run the example in its original directory, I have no problems. > When I wrap the example in my source, the source compiles but fail to > link with a certain Library as shown in the output below. What I want is > to get out the query results and use them in normal C++ environment. > Your help will be greatly appreciated. I am using linux Redhad version > 6.2 > and mysql++ version 1.7.8 > > Thanx in advance > Tiwonge > > This is my compiler output > Hi! First of all, please use version 1.7.9 which is already out. > g++ -W -Wall -Wpointer-arith -pipe -D_POSIX_THREADS > -D_POSIX_THREAD_SAFE_FUNCTIONS -D_REENTRANT -DACE_HAS_AIO_CALLS -O3 -g > -Wno-uninitialized -fno-implicit-templates > -I/home/ACE/ACE_wrappers/TAO/orbsvcs -I/home/ACE/ACE_wrappers/TAO > -I/usr/include/mysql -I/home/tiwonge/broker/broker_idl > -I/home/tiwonge/retailer/implementation_TAO/Utils -I/usr/include/mysql > -I/usr/local/mysql++/sqlplusint/.libs -I/usr/local/mysql++/sqlplusint > -I/usr/lib/mysql/include -I/home/ACE/ACE_wrappers > -DACE_HAS_EXCEPTIONS -L/home/ACE/ACE_wrappers/TAO/orbsvcs/orbsvcs > -L/home/ACE/ACE_wrappers/TAO/tao -L/usr/lib/mysql/lib -L./../broker_idl > -L/home/tiwonge/retailer/implementation_TAO/Utils -L/usr/lib/mysql > -L/home/ACE/ACE_wrappers/ace -L./ -o supplierServer > .obj/supplierServer.o libsupplier.a -lTAO_CosTrading -lTAO_CosNaming > -lTAO_DynamicAny -lTAO_PortableServer -lTAO -lz -lmysqlclient > -lsupplier_idl -lsqlplus -lTINAUtils -lACE -ldl -lpthread -lrt > libsupplier.a(i_QueryDb_i.o): In function > `i_QueryDb_i::getMessage(short, char const *, supplier::logInInfo const > &, supplier::messageInfo_out)': > /usr/local/mysql++/sqlplusint/connection1.hh:120: undefined reference to > `void MysqlConnection::storein_sequence __default_alloc_template > >(vector __default_alloc_template > &, basic_string string_char_traits, __default_alloc_template > const &)' > collect2: ld returned 1 exit status > make: *** [supplierServer] Error 1 > What is your compiler version ?? Try compiling without -Wno-uninitialized -fno-implicit-templates. The above method is a part of MySQL++ library and yet we did not have reports of such problems. You should also check that your linker finds libsqlplus library and that it si located in some of the directories pointed out by -L statements. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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
question...
hi hope this is the correct list for questions...if not , sorry i have a mysql server under linux, works fine but, if a user has an mysql account eg: "XYZ" and connects then he can take a look into the other DB, of other users ..he cant change any things. how i can set the permission for read the DB for own DB only? is running as user "mysql/ group dameon" the user connect via a GUI Client.../ PhpAdmin or so... thx cya - 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-field
hello! When I attempt to create a fulltext-index with the following code ALTER TABLE press ADD FULLTEXT ruffsig (preamble) everything seems fine. And the SHOW CREATE TABLE results ( see below ) seems fine too! Yet when I run a SHOW INDEX FROM press, the "sub_part" value is 1, and the comment field does not include a "Fulltext" note... How come?!!? Server: mySQL 3.32-beta create table press(id int(16) unsigned default NULL auto_increment, date date not null default '-00-00', header varchar(130) not null default '', preamble text not null, txt text not null, pdf int(16) unsigned not null default '0', image int(16) unsigned not null default '0', primary key (id), key date(date), fulltext key ruffsig(preamble) ) type=MyISAM / David - 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: Maximum number of characters in a field
--- [EMAIL PROTECTED] wrote: > Hi, > I have a problem regarding Mysql database. how can I insert more than 256 characters in a > field > of a table? Is it a limitation of Mysql database. Actually I want to insert a large string > which consists of more than 256 characters in a > field. > Pl let me know ASAP. > Arindam Das Adhikari > > > __ > Do You Yahoo!? > Yahoo! Auctions - buy the things you want at great > prices > http://auctions.yahoo.com/ __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
UPDATE Bug fixed or not?
Hi, regarding http://ep33.tp4.ruhr-uni-bochum.de/mlists/MySQL/May.2000/index.html#2025 , I had the same problem with MySQL 3.23.30. The following statement "Update Tree set left=left+2 where (left>$right and right>=$right);" sometimes (not reproducable) locked up MySQL completely. The "left" value in at least one row was very high (e.g. 455434), but should be e.g 56. After updating MySQL to version 3.23.37 I couldn cause this error any more. Can anybody tell me if this Bug is fixed now finally? Best regards, Manuel - 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
mysql@lists.mysql.com
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator: >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release: mysql-3.23.33 (Official MySQL binary) >Environment: System: Linux unitek18.unitek.net 2.2.14-5.0 #1 Tue Mar 7 20:53:41 EST 2000 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='-O6 -mpentium ' CXX='gcc' CXXFLAGS='-O6 -mpentium -felide-constructors' LDFLAGS='-static' LIBC: lrwxrwxrwx1 root root 13 Oct 31 2000 /lib/libc.so.6 -> libc-2.1.3.so -rwxr-xr-x1 root root 4101324 Mar 1 2000 /lib/libc-2.1.3.so -rw-r--r--1 root root 20272704 Mar 1 2000 /usr/lib/libc.a -rw-r--r--1 root root 178 Mar 1 2000 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared Perl: This is perl, version 5.005_03 built for i386-linux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql++ Vector/ Row problem
Hi all; When I run the example in its original directory, I have no problems. When I wrap the example in my source, the source compiles but fail to link with a certain Library as shown in the output below. What I want is to get out the query results and use them in normal C++ environment. Your help will be greatly appreciated. I am using linux Redhad version 6.2 and mysql++ version 1.7.8 Thanx in advance Tiwonge This is my compiler output g++ -W -Wall -Wpointer-arith -pipe -D_POSIX_THREADS -D_POSIX_THREAD_SAFE_FUNCTIONS -D_REENTRANT -DACE_HAS_AIO_CALLS -O3 -g -Wno-uninitialized -fno-implicit-templates -I/home/ACE/ACE_wrappers/TAO/orbsvcs -I/home/ACE/ACE_wrappers/TAO -I/usr/include/mysql -I/home/tiwonge/broker/broker_idl -I/home/tiwonge/retailer/implementation_TAO/Utils -I/usr/include/mysql -I/usr/local/mysql++/sqlplusint/.libs -I/usr/local/mysql++/sqlplusint -I/usr/lib/mysql/include -I/home/ACE/ACE_wrappers -DACE_HAS_EXCEPTIONS -L/home/ACE/ACE_wrappers/TAO/orbsvcs/orbsvcs -L/home/ACE/ACE_wrappers/TAO/tao -L/usr/lib/mysql/lib -L./../broker_idl -L/home/tiwonge/retailer/implementation_TAO/Utils -L/usr/lib/mysql -L/home/ACE/ACE_wrappers/ace -L./ -o supplierServer .obj/supplierServer.o libsupplier.a -lTAO_CosTrading -lTAO_CosNaming -lTAO_DynamicAny -lTAO_PortableServer -lTAO -lz -lmysqlclient -lsupplier_idl -lsqlplus -lTINAUtils -lACE -ldl -lpthread -lrt libsupplier.a(i_QueryDb_i.o): In function `i_QueryDb_i::getMessage(short, char const *, supplier::logInInfo const &, supplier::messageInfo_out)': /usr/local/mysql++/sqlplusint/connection1.hh:120: undefined reference to `void MysqlConnection::storein_sequence > >(vector > &, basic_string, __default_alloc_template > const &)' collect2: ld returned 1 exit status make: *** [supplierServer] Error 1 This is my makefile MAKEFILE = Makefile BIN2 =supplierServer supplierClient updatedb getmessage LIBNAME = libsupplier LIB2 = $(LIBNAME).a #SHLIB2 = $(LIBNAME).$(SOEXT) ifndef TAO_ROOT TAO_ROOT = $(ACE_ROOT)/TAO endif FILES = i_InitialiseDb_i\ i_UpdateDb_i\ i_QueryDb_i BROKER_ROOT = $(HOME)/broker MYSQLCLIENT_ROOT =/usr/local/mysql++ MYSQL_ROOT = /usr/lib/mysql LDFLAGS += -L$(TAO_ROOT)/orbsvcs/orbsvcs -L$(TAO_ROOT)/tao -L$(MYSQL_ROOT)/lib -L./../broker_idl -L$(HOME)/retailer/implementation_TAO/Utils -L/usr/lib/mysql CPPFLAGS += -I$(TAO_ROOT)/orbsvcs -I$(TAO_ROOT) -I/usr/include/mysql -I$(BROKER_ROOT)/broker_idl -I$(HOME)/retailer/implementation_TAO/Utils -I/usr/include/mysql -I$(MYSQLCLIENT_ROOT)/sqlplusint/.libs -I$(MYSQLCLIENT_ROOT)/sqlplusint -I$(MYSQL_ROOT)/include LSRC= $(addsuffix .cpp,$(FILES)) PSRC= $(addsuffix .cpp,$(BIN2)) #ACE_SHLIBS += -lTAO_CosTrading -lTAO_CosNaming -lTAO_DynamicAny -lTAO_PortableServer -lTAO -lACE -lTINAUtils LDLIBS += -lTAO_CosTrading -lTAO_CosNaming -lTAO_DynamicAny -lTAO_PortableServer -lTAO -lz -lmysqlclient -lsupplier_idl -lsqlplus -lTINAUtils CXXLINK = $(LIBTOOL) --mode=link $(CXXLD) $(AM_CXXFLAGS) $(CXXFLAGS) $(LDFLAGS) -o $@ # # Include macros and targets #- ifeq ($(ACE_HAS_GNUG_PRE_2_8),1) # Since older g++ cannot handle nested classes properly, this test # will not build on g++ prior to 2.8.0. all clean realclean: @echo Trading tests is not built with older versions of g++ else # ! ACE_HAS_GNUG_PRE_2_8 include $(TAO_ROOT)/rules.tao.GNU If the TAO orbsvcs library wasn't built with sufficient components, don't try to build here. TAO_ORBSVCS := $(shell sh $(ACE_ROOT)/bin/ace_components --orbsvcs) #ifeq (Trader,$(findstring Trader,$(TAO_ORBSVCS))) BIN = $(BIN2) LIB = $(LIB2) SHLIB = $(SHLIB2) #endif # Trader include $(ACE_ROOT)/include/makeinclude/wrapper_macros.GNU include $(ACE_ROOT)/include/makeinclude/macros.GNU include $(TAO_ROOT)/rules.tao.GNU include $(ACE_ROOT)/include/makeinclude/rules.common.GNU include $(ACE_ROOT)/include/makeinclude/rules.nonested.GNU include $(ACE_ROOT)/include/makeinclude/rules.lib.GNU include $(ACE_ROOT)/include/makeinclude/rules.bin.GNU include $(ACE_ROOT)/include/makeinclude/rules.local.GNU #include $(TINA_ROOT)/make.tina.GNU .PRECIOUS: i_InitialiseDb_i.o supplierServer.o ifneq ($(BIN),) ifeq ($(SHLIB), $(findstring $(SHLIB), $(BUILD))) $(BIN): $(SHLIB) endif ifeq ($(LIB), $(findstring $(LIB), $(BUILD))) $(BIN): $(LIB) endif endif # BIN realclean: clean -$(RM) $(foreach file, $(IDL_FILES), $(foreach ext, $(IDL_EXT), $(file)$(ext))) endif # ! ACE_HAS_GNUG_PRE_2_8 This is my source #include "orbsvcs/orbsvcs/CosNamingC.h" #include "i_QueryDb_i.h" #include #include "stream.h" #include #include "stdlib.h" #include #include #include //#include "util.hh" sql_create_5(stock, 1, 5, string, item, longlong, num, double, weight, double, price, Date, sdate) void i_QueryDb_i::getMessage (
Mysql++ Vector/ Row problem
Hi all; When I run the example in its original directory, I have no problems. When I wrap the example in my source, the source compiles but fail to link with a certain Library as shown in the output below. What I want is to get out the query results and use them in normal C++ environment. Your help will be greatly appreciated. I am using linux Redhad version 6.2 and mysql++ version 1.7.8 Thanx in advance Tiwonge This is my compiler output g++ -W -Wall -Wpointer-arith -pipe -D_POSIX_THREADS -D_POSIX_THREAD_SAFE_FUNCTIONS -D_REENTRANT -DACE_HAS_AIO_CALLS -O3 -g -Wno-uninitialized -fno-implicit-templates -I/home/ACE/ACE_wrappers/TAO/orbsvcs -I/home/ACE/ACE_wrappers/TAO -I/usr/include/mysql -I/home/tiwonge/broker/broker_idl -I/home/tiwonge/retailer/implementation_TAO/Utils -I/usr/include/mysql -I/usr/local/mysql++/sqlplusint/.libs -I/usr/local/mysql++/sqlplusint -I/usr/lib/mysql/include -I/home/ACE/ACE_wrappers -DACE_HAS_EXCEPTIONS -L/home/ACE/ACE_wrappers/TAO/orbsvcs/orbsvcs -L/home/ACE/ACE_wrappers/TAO/tao -L/usr/lib/mysql/lib -L./../broker_idl -L/home/tiwonge/retailer/implementation_TAO/Utils -L/usr/lib/mysql -L/home/ACE/ACE_wrappers/ace -L./ -o supplierServer .obj/supplierServer.o libsupplier.a -lTAO_CosTrading -lTAO_CosNaming -lTAO_DynamicAny -lTAO_PortableServer -lTAO -lz -lmysqlclient -lsupplier_idl -lsqlplus -lTINAUtils -lACE -ldl -lpthread -lrt libsupplier.a(i_QueryDb_i.o): In function `i_QueryDb_i::getMessage(short, char const *, supplier::logInInfo const &, supplier::messageInfo_out)': /usr/local/mysql++/sqlplusint/connection1.hh:120: undefined reference to `void MysqlConnection::storein_sequence > >(vector > &, basic_string, __default_alloc_template > const &)' collect2: ld returned 1 exit status make: *** [supplierServer] Error 1 This is my makefile MAKEFILE = Makefile BIN2 =supplierServer supplierClient updatedb getmessage LIBNAME = libsupplier LIB2 = $(LIBNAME).a #SHLIB2 = $(LIBNAME).$(SOEXT) ifndef TAO_ROOT TAO_ROOT = $(ACE_ROOT)/TAO endif FILES = i_InitialiseDb_i\ i_UpdateDb_i\ i_QueryDb_i BROKER_ROOT = $(HOME)/broker MYSQLCLIENT_ROOT =/usr/local/mysql++ MYSQL_ROOT = /usr/lib/mysql LDFLAGS += -L$(TAO_ROOT)/orbsvcs/orbsvcs -L$(TAO_ROOT)/tao -L$(MYSQL_ROOT)/lib -L./../broker_idl -L$(HOME)/retailer/implementation_TAO/Utils -L/usr/lib/mysql CPPFLAGS += -I$(TAO_ROOT)/orbsvcs -I$(TAO_ROOT) -I/usr/include/mysql -I$(BROKER_ROOT)/broker_idl -I$(HOME)/retailer/implementation_TAO/Utils -I/usr/include/mysql -I$(MYSQLCLIENT_ROOT)/sqlplusint/.libs -I$(MYSQLCLIENT_ROOT)/sqlplusint -I$(MYSQL_ROOT)/include LSRC= $(addsuffix .cpp,$(FILES)) PSRC= $(addsuffix .cpp,$(BIN2)) #ACE_SHLIBS += -lTAO_CosTrading -lTAO_CosNaming -lTAO_DynamicAny -lTAO_PortableServer -lTAO -lACE -lTINAUtils LDLIBS += -lTAO_CosTrading -lTAO_CosNaming -lTAO_DynamicAny -lTAO_PortableServer -lTAO -lz -lmysqlclient -lsupplier_idl -lsqlplus -lTINAUtils CXXLINK = $(LIBTOOL) --mode=link $(CXXLD) $(AM_CXXFLAGS) $(CXXFLAGS) $(LDFLAGS) -o $@ # # Include macros and targets #- ifeq ($(ACE_HAS_GNUG_PRE_2_8),1) # Since older g++ cannot handle nested classes properly, this test # will not build on g++ prior to 2.8.0. all clean realclean: @echo Trading tests is not built with older versions of g++ else # ! ACE_HAS_GNUG_PRE_2_8 include $(TAO_ROOT)/rules.tao.GNU If the TAO orbsvcs library wasn't built with sufficient components, don't try to build here. TAO_ORBSVCS := $(shell sh $(ACE_ROOT)/bin/ace_components --orbsvcs) #ifeq (Trader,$(findstring Trader,$(TAO_ORBSVCS))) BIN = $(BIN2) LIB = $(LIB2) SHLIB = $(SHLIB2) #endif # Trader include $(ACE_ROOT)/include/makeinclude/wrapper_macros.GNU include $(ACE_ROOT)/include/makeinclude/macros.GNU include $(TAO_ROOT)/rules.tao.GNU include $(ACE_ROOT)/include/makeinclude/rules.common.GNU include $(ACE_ROOT)/include/makeinclude/rules.nonested.GNU include $(ACE_ROOT)/include/makeinclude/rules.lib.GNU include $(ACE_ROOT)/include/makeinclude/rules.bin.GNU include $(ACE_ROOT)/include/makeinclude/rules.local.GNU #include $(TINA_ROOT)/make.tina.GNU .PRECIOUS: i_InitialiseDb_i.o supplierServer.o ifneq ($(BIN),) ifeq ($(SHLIB), $(findstring $(SHLIB), $(BUILD))) $(BIN): $(SHLIB) endif ifeq ($(LIB), $(findstring $(LIB), $(BUILD))) $(BIN): $(LIB) endif endif # BIN realclean: clean -$(RM) $(foreach file, $(IDL_FILES), $(foreach ext, $(IDL_EXT), $(file)$(ext))) endif # ! ACE_HAS_GNUG_PRE_2_8 This is my source #include "orbsvcs/orbsvcs/CosNamingC.h" #include "i_QueryDb_i.h" #include #include "stream.h" #include #include "stdlib.h" #include #include #include //#include "util.hh" sql_create_5(stock, 1, 5, string, item, longlong, num, double, weight, double, price, Date, sdate) void i_QueryDb_i::getMessage (
Mysql++ Vector/ Row problem
Hi all; When I run the example in its original directory, I have no problems. When I wrap the example in my source, the source compiles but fail to link with a certain Library as shown in the output below. What I want is to get out the query results and use them in normal C++ environment. Your help will be greatly appreciated. I am using linux Redhad version 6.2 and mysql++ version 1.7.8 Thanx in advance Tiwonge This is my compiler output g++ -W -Wall -Wpointer-arith -pipe -D_POSIX_THREADS -D_POSIX_THREAD_SAFE_FUNCTIONS -D_REENTRANT -DACE_HAS_AIO_CALLS -O3 -g -Wno-uninitialized -fno-implicit-templates -I/home/ACE/ACE_wrappers/TAO/orbsvcs -I/home/ACE/ACE_wrappers/TAO -I/usr/include/mysql -I/home/tiwonge/broker/broker_idl -I/home/tiwonge/retailer/implementation_TAO/Utils -I/usr/include/mysql -I/usr/local/mysql++/sqlplusint/.libs -I/usr/local/mysql++/sqlplusint -I/usr/lib/mysql/include -I/home/ACE/ACE_wrappers -DACE_HAS_EXCEPTIONS -L/home/ACE/ACE_wrappers/TAO/orbsvcs/orbsvcs -L/home/ACE/ACE_wrappers/TAO/tao -L/usr/lib/mysql/lib -L./../broker_idl -L/home/tiwonge/retailer/implementation_TAO/Utils -L/usr/lib/mysql -L/home/ACE/ACE_wrappers/ace -L./ -o supplierServer .obj/supplierServer.o libsupplier.a -lTAO_CosTrading -lTAO_CosNaming -lTAO_DynamicAny -lTAO_PortableServer -lTAO -lz -lmysqlclient -lsupplier_idl -lsqlplus -lTINAUtils -lACE -ldl -lpthread -lrt libsupplier.a(i_QueryDb_i.o): In function `i_QueryDb_i::getMessage(short, char const *, supplier::logInInfo const &, supplier::messageInfo_out)': /usr/local/mysql++/sqlplusint/connection1.hh:120: undefined reference to `void MysqlConnection::storein_sequence > >(vector > &, basic_string, __default_alloc_template > const &)' collect2: ld returned 1 exit status make: *** [supplierServer] Error 1 This is my makefile MAKEFILE = Makefile BIN2 =supplierServer supplierClient updatedb getmessage LIBNAME = libsupplier LIB2 = $(LIBNAME).a #SHLIB2 = $(LIBNAME).$(SOEXT) ifndef TAO_ROOT TAO_ROOT = $(ACE_ROOT)/TAO endif FILES = i_InitialiseDb_i\ i_UpdateDb_i\ i_QueryDb_i BROKER_ROOT = $(HOME)/broker MYSQLCLIENT_ROOT =/usr/local/mysql++ MYSQL_ROOT = /usr/lib/mysql LDFLAGS += -L$(TAO_ROOT)/orbsvcs/orbsvcs -L$(TAO_ROOT)/tao -L$(MYSQL_ROOT)/lib -L./../broker_idl -L$(HOME)/retailer/implementation_TAO/Utils -L/usr/lib/mysql CPPFLAGS += -I$(TAO_ROOT)/orbsvcs -I$(TAO_ROOT) -I/usr/include/mysql -I$(BROKER_ROOT)/broker_idl -I$(HOME)/retailer/implementation_TAO/Utils -I/usr/include/mysql -I$(MYSQLCLIENT_ROOT)/sqlplusint/.libs -I$(MYSQLCLIENT_ROOT)/sqlplusint -I$(MYSQL_ROOT)/include LSRC= $(addsuffix .cpp,$(FILES)) PSRC= $(addsuffix .cpp,$(BIN2)) #ACE_SHLIBS += -lTAO_CosTrading -lTAO_CosNaming -lTAO_DynamicAny -lTAO_PortableServer -lTAO -lACE -lTINAUtils LDLIBS += -lTAO_CosTrading -lTAO_CosNaming -lTAO_DynamicAny -lTAO_PortableServer -lTAO -lz -lmysqlclient -lsupplier_idl -lsqlplus -lTINAUtils CXXLINK = $(LIBTOOL) --mode=link $(CXXLD) $(AM_CXXFLAGS) $(CXXFLAGS) $(LDFLAGS) -o $@ # # Include macros and targets #- ifeq ($(ACE_HAS_GNUG_PRE_2_8),1) # Since older g++ cannot handle nested classes properly, this test # will not build on g++ prior to 2.8.0. all clean realclean: @echo Trading tests is not built with older versions of g++ else # ! ACE_HAS_GNUG_PRE_2_8 include $(TAO_ROOT)/rules.tao.GNU If the TAO orbsvcs library wasn't built with sufficient components, don't try to build here. TAO_ORBSVCS := $(shell sh $(ACE_ROOT)/bin/ace_components --orbsvcs) #ifeq (Trader,$(findstring Trader,$(TAO_ORBSVCS))) BIN = $(BIN2) LIB = $(LIB2) SHLIB = $(SHLIB2) #endif # Trader include $(ACE_ROOT)/include/makeinclude/wrapper_macros.GNU include $(ACE_ROOT)/include/makeinclude/macros.GNU include $(TAO_ROOT)/rules.tao.GNU include $(ACE_ROOT)/include/makeinclude/rules.common.GNU include $(ACE_ROOT)/include/makeinclude/rules.nonested.GNU include $(ACE_ROOT)/include/makeinclude/rules.lib.GNU include $(ACE_ROOT)/include/makeinclude/rules.bin.GNU include $(ACE_ROOT)/include/makeinclude/rules.local.GNU #include $(TINA_ROOT)/make.tina.GNU .PRECIOUS: i_InitialiseDb_i.o supplierServer.o ifneq ($(BIN),) ifeq ($(SHLIB), $(findstring $(SHLIB), $(BUILD))) $(BIN): $(SHLIB) endif ifeq ($(LIB), $(findstring $(LIB), $(BUILD))) $(BIN): $(LIB) endif endif # BIN realclean: clean -$(RM) $(foreach file, $(IDL_FILES), $(foreach ext, $(IDL_EXT), $(file)$(ext))) endif # ! ACE_HAS_GNUG_PRE_2_8 This is my source #include "orbsvcs/orbsvcs/CosNamingC.h" #include "i_QueryDb_i.h" #include #include "stream.h" #include #include "stdlib.h" #include #include #include //#include "util.hh" sql_create_5(stock, 1, 5, string, item, longlong, num, double, weight, double, price, Date, sdate) void i_QueryDb_i::getMessage (
Growing CPU usage by Mysqld
Hello mysql, I've just upgraded my WEB-Server box (2xPIII-500Mhz, 1Gb mem) to FreeBSD 4.3-RELEASE & update mysql to 3.23.38. (mysql Ver 11.15 Distrib 3.23.38, for -freebsd4.3 (i386)) Usually mysqld was taken 8-20% of CPU usage (top results). But after some days i'am notice that mysql takes all resources, avialable on 1 cpu ;( After mysqladmin shutdown and start it again all goes normal some time.. (8-20% of load), but it grows with days ;( Is there any solution for this problem ? - 'top' -- last pid: 62113; load averages: 1.91, 1.96, 1.97 up 17+04:35:35 16:38:58 112 processes: 2 running, 110 sleeping CPU states: 21.6% user, 0.0% nice, 46.0% system, 0.0% interrupt, 32.3% idle Mem: 385M Active, 419M Inact, 150M Wired, 31M Cache, 98M Buf, 20M Free Swap: 2048M Total, 4304K Used, 2044M Free PID USERNAME PRI NICE SIZERES STATE C TIME WCPUCPU COMMAND 23130 mysql 62 0 425M 170M CPU1 0 107:08 79.15% 79.15% mysqld 62009 apache 18 0 15900K 10652K lockf 1 0:01 4.53% 3.03% httpd - Generally Mysql is used from PHP-4.0.5 as mod_php from apache. And there is no noticed worked mysql threads - 'mysqladmin processlist | grep -v Sleep' -- | Id | User| Host | db | Command| Time | State | |Info | | 3851 | DELAYED | localhost | webchat | Delayed_insert | 2| Waiting on cond | |messages | | 4446 | DELAYED | localhost | webchat | Delayed_insert | 201 | Waiting on cond | |pager| | 4605 | root| localhost | | Query | 0| | |show processlist | --- - 'mysqladmin status' -- Uptime: 9732 Threads: 58 Questions: 530902 Slow queries: 56 Opens: 3159 Flush tables: 1 Open tables: 249 Queries per second avg: 54.552 ó Õ×ÁÖÅÎÉÅÍ, áÌÅËÓÅÊ òÕÓÁÎÏ× îÁÕÞÎÏ-ÐÒÏÉÚ×ÏÄÓÔ×ÅÎÎÏÅ ÐÒÅÄÐÒÉÑÔÉÅ "àÎÉËÏÎ ðÌÀÓ", îÏ×ÏÓÉÂÉÒÓË ÷ÅÄÕÝÉÊ ÓÐÅÃÉÁÌÉÓÔ ÏÔÄÅÌÁ Internet ÔÅÈÎÏÌÏÇÉÊ Unix network administrator ôÅÌ: +7 3832 23-94-06 +7 3832 10-00-50 æÁËÓ:+7 3832 23-94-06 ICQ UIN: 8397628 - 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
Too much CPU Usage
Hi ! I'm a novice mysql administrator and acording to my Web Hosting Provider, my mysql daemon is loading the CPU too much. The web has currently two main php scripts regarding the MySQL daemon. The first one shows a banner using the PHPAdServer application ( no clicks are registered, only shows the banner at the moment) The second one is a poll system of my own, that "draw" a random poll from the database ( there are currently 9 polls) and if the user clicks the Vote button, the vote is registered at the database. These two scripts are in the main page of the web, that has received 40,000 hits since the scripts have been incorporated, 15 days ago more or less... the max_connections allowed by the mysql at the same time are 28. What do you think it's the problem, an incorrect mysql configuration, the hosting machine is a bit junkie or it's normal this CPU usage with these two mysql access ? Here do you have the system statistics regarding the mysqld task last pid: 69299; load averages: 9.82, 11.98, 12.69 up 6+20:14:16 19:44:01 602 processes: 13 running, 588 sleeping, 1 zombie CPU states: 70.8% user, 0.0% nice, 29.2% system, 0.0% interrupt, 0.0% idle Mem: 355M Active, 45M Inact, 85M Wired, 16M Cache, 61M Buf, 1544K Free Swap: 1024M Total, 56M Used, 968M Free, 5% Inuse PID USERNAME PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND 510 gameswor 2 0 13804K 2844K poll 58.7H 39.75% 39.75% mysqld
Re: Compilation problems.
Hello guys, I managed to compile succesfully my C program but now when I run it I get something like the following --- TEST1 Failed in SELECT , Error: You have an error in your SQL syntax near ')' at line 1 What I want to ask , I have to do "use my_data_base" first or not ? Regards, Nicu - 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: Symbolic Links under Windows (Can also work running MySQL as a console)
> The problem has been resolved. There is apparently an > undocumented option > (at least it's not documented in the HTML manual for 3.23.38) > required in > the my.cnf file - "use-symbolic-links". I was using all > default values, so > I wasn't even using a my.cnf or a my.ini file. > > Here's how I made it work on my NT system: > > 1. Upgrade to 3.23.38 (someone suggested I needed that, > although the HTML > documentation said that symbolic link support was compiled > into the binary > distribution much earlier; I doubt this is necessary) > 2. Copy c:\mysql\my-example.cnf to c:\my.cnf > 3. Edit c:\my.cnf and comment out all the options; just leave > [myslqd] section > 4. Add use-symbolic-links to the [mysqld] section > 5. Start mysql-max-nt service > 6. Create the mydb.sym file in the c:\mysql\data directory, > with the line > c:\inetpub\wwwroot\mydb\. Note the trailing backslash; I was > told this is > important. > > Database is ready to go. Hi all, Unfortunately I could not make this work on Windows 2000, but I found a way that should run on all Windows platforms thanks to the tip regarding the 'use-symbolic-links' option :-) 1) Start a DOS-prompt 2) Go to the '\bin' directory 3) Type the following command: 'mysqld-max --console --skip-innodb --use-symbolic-links' 4) Now you get a message that states 'mysqld-max: ready for connections'. IMPORTANT: In order to use your mysql database, you need to keep this DOS-prompt window (conmsole) 'alive'. However I am not sure how to shut down the MySQL database console properly, is it safe just to 'kill' the console window? Please beware that I do no know the functionality behind the innodb feature (--skip-innodb), thus use the command above with caution, you might want to take a backup of your data in the MySQL database before you try this out. -- Regards Grosen Friis, Programmer -- The Stibo Group Søren Nymarks Vej 3 DK-8270 Højbjerg Aarhus, Denmark Phone +45 89 39 11 11 Direct +45 89 39 13 21 Fax +45 89 39 11 12 E-mail: [EMAIL PROTECTED] http://www.stibo.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
MySQL plugin for new FileMaker Pro 5.5?
I was so excited to see that the latest FileMaker Pro finally supports SQL stuff built in, but was disheartened to see that I could only use it with Oracle and a couple other commercial servers. Is anyone out there working on a mysql plugin for 5.5? FileMaker would seemingly be an awesome way to easily create graphical clients for the faster/better mysql server... -Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with installation [MySQL GUI]
I'm running RedHat 7.0 with mysql-server-3.23.22-6. When I try installin the rpm I get the following message "MySQL-server is needed by mysqlgui-static-1.7.1-1" - 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: changing pasword
Did you 1. Use GRANT to create the user? If you didn't and inserted data incorrectly into the grant tables, you could find problems later on. 2. Flush privileges after creating the user? - Original Message - From: "Martin RODOT" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, May 28, 2001 15:41 Subject: changing pasword > Hi ! > > I'm using MySql 3.23.38-nt on a test machine. > > I'd like to create a new user and I tried : > > -- > mysql> connect mysql > Connection id:308 > Current database: mysql > > mysql> set password for auser = password("anewpassword"); > ERROR 1133: Can't find any matching row in the user table > --- > > But I have actually created the user and I can see : > > > mysql> select * from user where user = "auser"; > +---+-+--+-+ > | Host | User| Password | Select_priv | Insert_priv > +---+-+--+-+ > | localhost | auser | 5f1839b1118fb243 | Y | Y > +---+-+--+-+ > 1 row in set (0.00 sec) > mysql> > > > Of course I was connected as super-user with all privileges. > > Does anybody can explain me what is wrong ? > > Regards. > > Martin RODOT > M.R.IT - BLOIS - France > > Welcome in Blois > > - > 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
Jdbc connection
Hi, I have used mm.mysql driver for jdbc connection. I've did all the neccessary connection and the java application was able to load the driver, but there was this problem. The java program was actually from the mm.mysql documentation. Problem: SQLException:Server configuration denies access to data sources SQLState: 08001 VendorError: 0 Other than performing the steps for the driver setup, is there other things that i have to do, in order to set up the link? For the mySQL, i used the binary distribution and installed using the rpm.(both the server and client). I only used the command: shell> rpm -i MySQL-VERSION.i386.rpm MySQL-client-VERSION.i386.rpm I did not exec the mysql_install_db command. I could access the mySQL and perform create,select,... Thanks a million. Regards, Johan
Is MySQL BeoWulf compatible?
Subj. Can I set it up on a cluster? I have so heavy load on my MySQL server that I need to increase the power of my server. I consider different ways of doing it and want to know if somebody installed it successfully on a cluster. Best regards, Vinche mailto:[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
changing pasword
Hi ! I'm using MySql 3.23.38-nt on a test machine. I'd like to create a new user and I tried : -- mysql> connect mysql Connection id:308 Current database: mysql mysql> set password for auser = password("anewpassword"); ERROR 1133: Can't find any matching row in the user table --- But I have actually created the user and I can see : mysql> select * from user where user = "auser"; +---+-+--+-+ | Host | User| Password | Select_priv | Insert_priv +---+-+--+-+ | localhost | auser | 5f1839b1118fb243 | Y | Y +---+-+--+-+ 1 row in set (0.00 sec) mysql> Of course I was connected as super-user with all privileges. Does anybody can explain me what is wrong ? Regards. Martin RODOT M.R.IT - BLOIS - France Welcome in Blois - 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
What option of LOAD DATA should I use?
Hi all, How to use MySQL LOAD DATA command to load comma separated text data but one of the field can contains comma character as part of of the string context.? In other word, I want LOAD DATA insert string with comma characters inside it but without adding slash character ('\')to distinguish it as a field separator. I use this command, LOAD DATA LOCAL INFILE "DATA.TXT" REPLACE INTO TABLE tbl FIELDS TERMINATED BY "|" IGNORE 1 LINES but when I look at the table tbl, everything is fine except in the field that contain comma character, comma charater is written as '\,' rather than just ','. What option of LOAD DATA should I use? Jamal
Re: Compilation problems.
Hello, I took out the m_string.h file from include directive and I get the following error gcc -g Bug_Report.c -O -o TEST1 -I/usr/include/mysql -L/usr/lib/mysql -lmysqlclient -lnsl /tmp/ccWyxVrf.o: In function `main': /home/nicu/QA/Bug_Report.c:15: undefined reference to `strmov' collect2: ld returned 1 exit status So it seems that I need the m_string.h file for the definition of strmov() function. I did also include the my_global.h file along with m_string.h but I get a bunch of errors . Can anyone send me some C Api example to see what include file to use myself. Regards, Nicu Paul DuBois wrote: > At 8:46 PM -0400 5/26/01, Nicu Popovici wrote: > >Hello Sinisa, > > > > I managed to get a connection to a database but now when I want to > >try to make a query on that > >database I have to use strmov() function defined in m_string.h but > >at compilation time I get the > >following errors. > >JUST BECAUSE I INCLUDED m_string.h into my file > > Did you also include any other include files on which m_string.h might > depend? For instance, line 93 uses the NEAR symbol, which is defined > in global.h. If you didn't include global.h before m_string.h, you > will of course have problems. > > > > >gcc -g Bug_Report.c -o first.o -L/usr/lib/mysql > >-I/usr/include/mysql/ -lmysqlclient > >In file included from Bug_Report.c:3: > >/usr/include/mysql/m_string.h:93: parse error before `_dig_vec' > >/usr/include/mysql/m_string.h:93: warning: data definition has no > >type or storage class > >/usr/include/mysql/m_string.h:149: parse error before `pchar' > >/usr/include/mysql/m_string.h:151: parse error before `pchar' > >/usr/include/mysql/m_string.h:154: parse error before `s' > >/usr/include/mysql/m_string.h:156: parse error before `my_string' > >/usr/include/mysql/m_string.h:169: parse error before `_VARARGS' > >/usr/include/mysql/m_string.h:170: parse error before `_VARARGS' > >/usr/include/mysql/m_string.h:171: parse error before `_VARARGS' > >/usr/include/mysql/m_string.h:172: parse error before `_VARARGS' > >/usr/include/mysql/m_string.h:173: parse error before `_VARARGS' > >/usr/include/mysql/m_string.h:174: parse error before `_VARARGS' > >/usr/include/mysql/m_string.h:209: parse error before `value' > >/usr/include/mysql/m_string.h:93: warning: array `_dig_vec' assumed > >to have one element > > > > > >Maybe you have some ideeas . > > > >Thank you > >Nicu > > > >Sinisa Milivojevic wrote: > > > >> Nicu Popovici writes: > >> > Hi Sinisa, > >> > > >> > I get another error now. It seems that I managed to pass by > >>that error. Here it is what > >> > I get now: > >> > > >> > -- > >> > Failed to connect to database! Error Protocol mismatch. Server > >>Version = 10 Client Version = > >> > 9 ; > >> > -- > >> > > >> > What shall I do ? > >> > > >> > Regards, > >> > Nicu > >> > > >> > >> Get a newer libmysqlclient version. > >> > >> Regards, > >> > >> Sinisa > >> > >> __ _ _ ___ == MySQL AB > >> /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic > >> /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] > >> /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus > >>/*/ /*/ /*/\*\_/*/ \*\_/*/ |*| > >>/*/^^^\*\^^^ > >> /*/ \*\Developers Team > > > > > >- > >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 > > -- > 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