Re: install problems AGAIN
- Original Message - From: [EMAIL PROTECTED] To: George Pitcher [EMAIL PROTECTED] Sent: Saturday, August 25, 2001 1:41 PM Subject: Re: install problems AGAIN Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Hi all, yet again. I thought iut was going too well! I was at the 'make' stage and after about 90 minutes (the instructions did say it would take a while) I got an error message: 'c++: Internal compiler error: program cc1plus got fatal signal 15' It then leaves the various [3] make's. Does anyone have any experience of this and know of a solution? George in Edinburgh _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.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
Help about joins
Hi, I have a Oracle SQL string that contains '(+)' but when running it in mySQL I get an error message saying that it's a syntax error. The definition in a Oracle helpfile is: (+),Indicates that the preceding column SELECT ename, dname is the outer join column FROM emp, dept in a join.WHERE dept.deptno = emp.deptno (+) How can I do this in mySQL? Here is my SQL statement: --- SELECT f.fungroupno, f.infotypeid, f.qualifierid, f.vssno, f.vsscompany, f.vssgroupno, i.fromid, i.toid, i.linktype, s.sectionid section, LTRIM(CONCAT( t1.text, CONCAT( ' ', CONCAT( t2.text, CONCAT( '', CONCAT( t3.text, CONCAT( ' ', s.subheadtext))) infoelementtitle, NULL opcode, NULL optitle FROM wi_sifilter f, wi_siinfoelement i, wi_textlist t1, wi_textlist t2, wi_textlist t3, wi_pisection s , wi_fevss vs WHERE f.infotypeid = 'PARTS' AND f.fungroupno LIKE '49%' AND f.qualifierid = 'PARTS-CATLG' AND f.infoelementid = i.fromid AND s.sectionid = i.toid AND t1.language(+) = 'eng' AND t1.country(+) = 'US' AND t1.textid(+) = s.heading1 AND t2.language(+) = 'eng' AND t2.country(+) = 'US' AND t2.textid(+) = s.heading2 AND t3.language(+) = 'eng' AND t3.country(+) = 'US' AND t3.textid(+) = s.heading3 AND i.linktype = 'partinforef' AND vs.vssno = f.vssno AND (vs.model = 'F10' OR vs.model IS NULL) ORDER BY 6 ASC, 5 ASC, 4 ASC --- Best regards Joacim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Binlogs numbers
Hi, I've noticed, that bin logs names are followed by three digits: 001,002 and so on. What will happen when I reach 999? Will it start to overwrite my first logs? magic words: MySQL, table, sql -- _/_/ _/_/_/ - 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
Search and compare
Hi, Oracle has a fuction that compares value and then returns another value. DECODE( expr, search, result [, search, result] ... [, default] ) E.g. DECODE (deptno, 10, 'ACCOUNTING', 20, 'RESEARCH', 30, 'SALES', 40, 'OPERATION', 'NONE') If 'deptno' is equal to 10 the string 'ACCOUNTING' is returned, 20 = 'RESEARCH'etc. If no match 'NONE' will be returned. Is there some similar function in mySQL? Best regards Joacim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 about joins
Jarkeborn Joacim wrote: Hi, I have a Oracle SQL string that contains '(+)' but when running it in mySQL I get an error message saying that it's a syntax error. The definition in a Oracle helpfile is: (+),Indicates that the preceding column SELECT ename, dname is the outer join column FROM emp, dept in a join.WHERE dept.deptno = emp.deptno (+) How can I do this in mySQL? Here is my SQL statement: --- SELECT f.fungroupno, f.infotypeid, f.qualifierid, f.vssno, f.vsscompany, f.vssgroupno, i.fromid, i.toid, i.linktype, s.sectionid section, LTRIM(CONCAT( t1.text, CONCAT( ' ', CONCAT( t2.text, CONCAT( '', CONCAT( t3.text, CONCAT( ' ', s.subheadtext))) infoelementtitle, NULL opcode, NULL optitle FROM wi_sifilter f, wi_siinfoelement i, wi_textlist t1, wi_textlist t2, wi_textlist t3, wi_pisection s , wi_fevss vs WHERE f.infotypeid = 'PARTS' AND f.fungroupno LIKE '49%' AND f.qualifierid = 'PARTS-CATLG' AND f.infoelementid = i.fromid AND s.sectionid = i.toid AND t1.language(+) = 'eng' AND t1.country(+) = 'US' AND t1.textid(+) = s.heading1 AND t2.language(+) = 'eng' AND t2.country(+) = 'US' AND t2.textid(+) = s.heading2 AND t3.language(+) = 'eng' AND t3.country(+) = 'US' AND t3.textid(+) = s.heading3 AND i.linktype = 'partinforef' AND vs.vssno = f.vssno AND (vs.model = 'F10' OR vs.model IS NULL) ORDER BY 6 ASC, 5 ASC, 4 ASC --- Best regards Joacim Joacim: I don't think the (+) is standard ANSI SQL and is probably not necessary for your Oracle query. The (+) is unnecessary. Lose it and the query will likely work in both Oracle and MySQL. I'm curious why you're not explicitely specifying your OUTER JOIN before the WHERE clause which would make it a more efficient query. CONCAT() is definitely not supported in MSSQL as of 7.0, and will cause you problems there, but that's another issue. I'm assuming you're shooting for a cross-sql capable application. A thought to consider. Best 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
Re: MySQL datetime and microseconds
Hi! Sasha == Sasha Pachev [EMAIL PROTECTED] writes: Sasha On Wednesday 22 August 2001 15:37, you wrote: Can mysql support mucroseconds in the datetime field? mydate datetime(14,4) for instance? I havn't had success so far ;-) Sasha No, it cannot, at this time. We might consider adding it in 4.0. For the time Sasha being, you will have to resort to a hack with manually inserting the Sasha microsecond value in a speparate column and adjusting the computations. This is on the TODO for 4.0. We haven't however yet decided the syntax for this. (We want to have optimal microseconds both for datetime and timestamp columns) Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: shadow tables?
Hi! werner == werner ISO-8859-1 writes: werner Is it an option to drop the table and recreate and repopulate it? werner I would give it a try and think that your problem will be gone. werner You can easily do that with mysqldump. Ask again if you need more werner help. werner Alex Pukinskis schrieb am Mittwoch, 22. August 2001, 22:48:26: I've made some progress figuring out my case issue. It seems that somehow I'm ending up with shadow tables. I discovered this after I ran an ALTER command. My db has 4 tables: mysql show tables\g +-+ | Tables_in_hbperfrev | +-+ | employee| | perfassessment | | perfreview | | workgroup | +-+ 4 rows in set (0.01 sec) When I look at the perfassessment table, I see the two rows that I added via alter, q10 and q11: cut mysql describe PerfAssessment\g ++-+--+-+-++ | Field | Type| Null | Key | Default | Extra | ++-+--+-+-++ | ID | int(11) | | PRI | NULL| auto_increment | cut So clearly I have duplicate tables, and this explains all the case sensitivity problems I was having earlier. But why doesn't the second one show up when I do show tables? And how do I get rid of the second one? I have never seen this problem before. The only explanations I have for the above are: - Somehow MySQL doesn't think you have the rights to look at the PerfAssessment table with show tables. What result do you get if you login as the MySQL root user ? - You have just created a temporary table name PerfAssessment. In this case the problem should disappear when you reconnect to MySQL. What files do you have in the database directory ? Any help is much appreciated, as I've been banging my head against the wall for days. Again, this is 3.23.39, compiled from source, running on OS X Server (details below). Another question: I'm trying to remove some unused databases, but this command: ./mysqladmin -u root -p drop ac (where 'ac' is the database name) doesn't seem to actually remove them from the mysql database. Is there another command that completely removes databases? Yes, the above command should remove all database files in the 'ac' database, for which the MySQL server has delete privilege. Could you check verify there isn't some privilege problem with the files in the ac database ? Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Help about joins
-Original Message- From: Van [mailto:[EMAIL PROTECTED]] Sent: den 27 augusti 2001 11:01 To: Jarkeborn Joacim Cc: [EMAIL PROTECTED] Subject: Re: Help about joins Jarkeborn Joacim wrote: Hi, I have a Oracle SQL string that contains '(+)' but when running it in mySQL I get an error message saying that it's a syntax error. The definition in a Oracle helpfile is: (+),Indicates that the preceding column SELECT ename, dname is the outer join column FROM emp, dept in a join.WHERE dept.deptno = emp.deptno (+) How can I do this in mySQL? Here is my SQL statement: -- - SELECT f.fungroupno, f.infotypeid, f.qualifierid, f.vssno, f.vsscompany, f.vssgroupno, i.fromid, i.toid, i.linktype, s.sectionid section, LTRIM(CONCAT( t1.text, CONCAT( ' ', CONCAT( t2.text, CONCAT( '', CONCAT( t3.text, CONCAT( ' ', s.subheadtext))) infoelementtitle, NULL opcode, NULL optitle FROM wi_sifilter f, wi_siinfoelement i, wi_textlist t1, wi_textlist t2, wi_textlist t3, wi_pisection s , wi_fevss vs WHERE f.infotypeid = 'PARTS' AND f.fungroupno LIKE '49%' AND f.qualifierid = 'PARTS-CATLG' AND f.infoelementid = i.fromid AND s.sectionid = i.toid AND t1.language(+) = 'eng' AND t1.country(+) = 'US' AND t1.textid(+) = s.heading1 AND t2.language(+) = 'eng' AND t2.country(+) = 'US' AND t2.textid(+) = s.heading2 AND t3.language(+) = 'eng' AND t3.country(+) = 'US' AND t3.textid(+) = s.heading3 AND i.linktype = 'partinforef' AND vs.vssno = f.vssno AND (vs.model = 'F10' OR vs.model IS NULL) ORDER BY 6 ASC, 5 ASC, 4 ASC -- - Best regards Joacim Joacim: I don't think the (+) is standard ANSI SQL and is probably not necessary for your Oracle query. The (+) is unnecessary. Lose it and the query will likely work in both Oracle and MySQL. Unfortunately, we have a lots of SQL statements that are non standard ANSI SQL and more Oracle specific. I can't remove (+) since it doesn't work either in Oracle or mySQL. It seems that I have to rewrite lots of SQLs ;-( I'm curious why you're not explicitely specifying your OUTER JOIN before the WHERE clause which would make it a more efficient query. I'm not that good at SQL but I will take the issue to the SQL developer. CONCAT() is definitely not supported in MSSQL as of 7.0, and will cause you problems there, but that's another issue. I'm assuming you're shooting for a cross-sql capable application. A thought to consider. Yes, if the SQL statements where ANSI SQL it wouldn't be any problem to use mySQL instead of Oracle. We have lots of code that are developed for Oracle and it seems that they haven't developed database independant SQL's. It's very stupid done. Regards Joacim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: No Lock
On 26 Aug 2001 13:55:40 -0700, Jeremy Zawodny wrote: On Sun, Aug 26, 2001 at 11:52:15PM +0200, Boaz Yahav wrote: Does mysql have something like NO LOCK? SELECT * FROM mytable WHERE myfield='xyz' NO LOCK By default, no. But if you use InnoDB tables in MySQL, you'll get non-locking SELECTS, which is probably what you're looking for. See the docs at http://www.mysql.com/doc/ for more info. Yes, this is true. Additionally I would like to say that I asked similar question from Monty when I yet wasn't empoyed by MySQL and he told that usually same behaviour can be got if INSERT DELAYED is used. SELECTS do not lock on tables like adview/adclick stuff where no high accuracy needed. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ 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
[Solved] RE: Search and compare
Yes, I have got the tip from 'Carl Troein', thanks anyway CASE value WHEN [compare-value] THEN result [WHEN [compare-value] THEN result ...] [ELSE result] END Best regards Joacim -Original Message- From: Harald Fuchs [mailto:[EMAIL PROTECTED]] Sent: den 27 augusti 2001 11:43 To: [EMAIL PROTECTED] Subject: Re: Search and compare In article [EMAIL PROTECTED], Jarkeborn Joacim [EMAIL PROTECTED] writes: Hi, Oracle has a fuction that compares value and then returns another value. DECODE( expr, search, result [, search, result] ... [, default] ) E.g. DECODE (deptno, 10, 'ACCOUNTING', 20, 'RESEARCH', 30, 'SALES', 40, 'OPERATION', 'NONE') If 'deptno' is equal to 10 the string 'ACCOUNTING' is returned, 20 = 'RESEARCH'etc. If no match 'NONE' will be returned. Is there some similar function in mySQL? Yes. You can use CASE or IF() for that. - Before posting, please check: http://www.mysql.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-joacim.jarkeborn=consultant.volvo.com@lists .mysql.com 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
carrying database
Hi my name is Nejat from Turkey and i am very new in databases .I have got a database in linux which is mysql and i want to carry this database to a windows system how can this be done.Any help needed.Thankyou! _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.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
Re: carrying database
This is all nicely detailed in the MySQL Manual. Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) Suggest you use mysqldump, including the option to create the database and table schema. On the Linux machine: mysqldump -u{username} -p -c --databases {databasename}{databasename}.sql Copy the file(s) across the network to the Windoze box On the Windoze box: mysql -u{username} -p{databasename}.sql - Original Message - From: noe [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 27, 2001 5:20 AM Subject: carrying database Hi my name is Nejat from Turkey and i am very new in databases .I have got a database in linux which is mysql and i want to carry this database to a windows system how can this be done.Any help needed.Thankyou! _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Setting user passwords per database
It would see you could us ethe GRANT command: GRANT ALL PRIVILEGES ON database1.* TO user@% IDENTIFIED BY 'password1'; GRANT ALL PRIVILEGES ON database2.* TO user@% IDENTIFIED BY 'password2'; GRANT ALL PRIVILEGES ON database3.* TO user@% IDENTIFIED BY 'password3'; - Original Message - From: Mark Johnson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, August 26, 2001 10:40 PM Subject: Setting user passwords per database Is it possible to set a differenent password per database for the same user? It doen't appear to be possible - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Compiling MySQL Database on LinuxPPC
Hi all, Frustrated by failing compile: This is the message I get: c++: Internal compiler eror: program cc1plus got fatal signal 15 make[3]: ***[field.o] Error 1 make[3]: Leaving directory '/usr/src/mysql-3.23.37/sql' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory '/usr/src/mysql-3.23.37/sql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory '/usr/src/mysql-3.23.37' make: *** [all-recursive] Error 2 Any suggestions Regards George Pitcher Technical Manager HERON Project Napier University Edinburgh EH10 5DT [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] http://www.heron.ac.uk programmer - A device for transmuting caffeine into code. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.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
TEXT field and AppendChunk
hello all, I'm now developing with MySQL and VC. And I have a question with the field which type is TEXT. I cann't insert the value with AppendChunk. Here is part of my code. HRESULT hr; _RecordsetPtr pRS; _bstr_t G_CONNECTSTRING = LPersist Security Info=True;User ID=root;Data Source=NetVision;\ LMode=ReadWrite; hr = pRS.CreateInstance(__uuidof(Recordset)); hr = pRS-Open(Ltb_Channel, G_CONNECTSTRING, adOpenDynamic, adLockOptimistic, adCmdTable); VARIANT varTemp; VARIANT varBLOB; BYTE *pByte; try { SAFEARRAY FAR* psa; SAFEARRAYBOUND rgsabound[1]; rgsabound[0].lLbound = 0; rgsabound[0].cElements = m_strCScript.GetLength() * sizeof(TCHAR) + sizeof(TCHAR); // create a single dimensional byte array psa = SafeArrayCreate(VT_I1, 1, rgsabound); // set the data of the array with data in the edit box if(SafeArrayAccessData(psa,(void **)pByte) == NOERROR) memcpy((LPVOID)pByte,(LPVOID)m_strCScript.GetBuffer(m_strCScript.GetLength()),m_strCScript.GetLength()+1); SafeArrayUnaccessData(psa); varBLOB.vt = VT_ARRAY | VT_UI1; varBLOB.parray = psa; pRS-Fields-Item[0L]-AppendChunk(varBLOB); // Field[0] is TEXT pRS-Update(); } catch(_com_error e) { // When AppendChunk is called, it reports the error: // Any failure in adding a new column cancel the update pRS-CancelUpdate(); _bstr_t bstrSource(e.Source()); // Microsoft OLE DB Prvider for ODBC Drivers _bstr_t bstrDescription(e.Description()); // Invalid string or buffer length CString str; str.Format(\tCode = %08lx, e.Error()); str += Msg: ;str += e.ErrorMessage(); str += Source: ; str += bstrSource; str += Description: ; str += bstrDescription; AfxMessageBox(str); } - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
the most used DB in Webhosting
Dear members, I know you are MySQLer but be honest, what is the the most used Database in ISP of webhosting, and the reasons. And fornyou, after MySQL what is the DB the you prefer in webhosting. thanks to all - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: the most used DB in Webhosting
This is probably heresy here, but we use Filemaker for our web-database solution. The main reason why we use that in preference to more 'robust' SQL-based DBs is that we have a team using Filemaker clients updating information constantly and Filemaker is the most efficient db we have found to do that. We are currently evaluating MySQL to see if there are any advantages in moving. Regards George Pitcher Technical Manager HERON Project Napier University Edinburgh EH10 5DT [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] http://www.heron.ac.uk programmer - A device for transmuting caffeine into code. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 27, 2001 12:50 PM Subject: the most used DB in Webhosting Dear members, I know you are MySQLer but be honest, what is the the most used Database in ISP of webhosting, and the reasons. And fornyou, after MySQL what is the DB the you prefer in webhosting. thanks to all - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.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
carrying database
Hi my name is Nejat from Turkey and i am very new in databases .I have got a database in linux which is mysql and i want to carry this database to a windows system how can this be done.Any help needed.Thankyou! _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.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
Re: carrying database
On 27 Aug 2001 13:27:17 +0300, noe wrote: Hi my name is Nejat from Turkey and i am very new in databases .I have got a database in linux which is mysql and i want to carry this database to a windows system how can this be done.Any help needed.Thankyou! Search in manual for mysqldump -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Setting user passwords per database
I tried that, all it did was change my password for mysql completelyhowever, i could have done something wrong... - Original Message - From: Gerald R. Jensen [EMAIL PROTECTED] To: Mark Johnson [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, August 27, 2001 5:35 AM Subject: Re: Setting user passwords per database It would see you could us ethe GRANT command: GRANT ALL PRIVILEGES ON database1.* TO user@% IDENTIFIED BY 'password1'; GRANT ALL PRIVILEGES ON database2.* TO user@% IDENTIFIED BY 'password2'; GRANT ALL PRIVILEGES ON database3.* TO user@% IDENTIFIED BY 'password3'; - Original Message - From: Mark Johnson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, August 26, 2001 10:40 PM Subject: Setting user passwords per database Is it possible to set a differenent password per database for the same user? It doen't appear to be possible - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Date Formats into the DB
Hi I want to know if it's possible to put a format to a Date Field into the DB. For example: I have a data only JUN/2001 for a table, but the field FechaINI format is -00-00, so I want to put just -00 but I cannot. thanks Betto McRose G, - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Is MySQL network dependent?
I've installed MySQL on a Sun Ultra1 with Solaris 8 and it works fine. But as soon as I unplug the network cable none of the MySQL binaries seem to work any more. If I start MySQL is prints nothing and the process seems to hang. If I reconnect the cable and try starting MySQL again, everything runs smoothly. Any suggestions? Arvid Claassen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Binlogs numbers
Rafal Jank writes: Hi, I've noticed, that bin logs names are followed by three digits: 001,002 and so on. What will happen when I reach 999? Will it start to overwrite my first logs? magic words: MySQL, table, sql -- _/_/ _/_/_/ - 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 *==-- No, it will become .1000. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
repairing MyISAM table kills mysqld with SIG11
Description: 010827 16:24:44 Warning: Retrying repair of: './Mloti/blast_data' with keycache mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail key_buffer_size=268431360 record_buffer=4190208 sort_buffer=67108856 max_used_connections=6 max_connections=100 threads_connected=5 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 3030635 K bytes of memory Hope that's ok, if not, decrease some variables in the equation Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Stack range sanity check OK, backtrace follows: 0x807b0b8 0x812a6fa 0x8150f4f 0x81141dc 0x8108a84 0x80c4268 0x80c3f6e 0x80cacd0 0x80cd9e6 0x8082421 0x8085476 0x8080b4d 0x808006e Stack trace seems successful - bottom reached Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the sta ck trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x859ead0 = repair TABLE blast_data thd-thread_id=268 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 268 did to cause the crash. In some cases of really bad corruption, the above values may be invalid Please use the information above to create a repeatable test case for the crash, and send it to [EMAIL PROTECTED] Number of processes running now: 0 010827 16:24:44 mysqld restarted How-To-Repeat: /usr/local/mysql-3.23.39/bin/mysqlcheck -r --compress Mloti Mloti.Upd OK Mloti.blastOK Mloti.blast_crossupdateOK Mloti.blast_crossupdate_data OK /usr/local/mysql-3.23.39/bin/mysqlcheck: Got error: 2013: Lost connection to MySQL server during query when executing 'REPAIR TABLE' mysql check TABLE blast_data; +--+---+--+---+ | Table| Op| Msg_type | Msg_text | | +--+---+--+---+ | Mloti.blast_data | check | warning | Table is marked as crashed and last repair |failed | | Mloti.blast_data | check | warning | Size of datafile is: 178083072 Should |be: 178083068 | | Mloti.blast_data | check | error| Can't read indexpage from filepos: -1 | | | Mloti.blast_data | check | error| Corrupt | | +--+---+--+---+ 4 rows in set (0.01 sec) mysql optimize TABLE blast_data; +--+--+--+-+ | Table| Op | Msg_type | Msg_text || +--+--+--+-+ | Mloti.blast_data | optimize | error| Can't open file: 'blast_data.MYD'. (errno: |144) | +--+--+--+-+ 1 row in set (0.00 sec) mysql repair TABLE blast_data; ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id:268 Current database: Mloti Resolved stack trace generated with the mysqlcheck utility (stack trace generated by `REPAIR TABLE blast_data' seems exactly same). kulan$ nm -n /usr/local/mysql-3.23.39/libexec/mysqld symbol.table kulan$ /usr/local/mysql-3.23.39/bin/resolve_stack_dump -s symbol.table -n stack 0x807b0b8 handle_connections_sockets__FPv + 948 0x812a6fa uncompress + 122 0x8150f4f ptmalloc_init_all + 7 0x81141dc ptr_compare_2 + 0 0x8108a84 sort_write_record + 856 0x80c4268 rnd_pos__12ha_myisammrgPcT1 + 44 0x80c3f6e create__12ha_myisammrgPCcP8st_tableP24st_ha_create_information + 70 0x80cacd0 mysql_alter_table__FP3THDPcT1P24st_ha_create_informationP13st_table_listRt4List1Z12create_fieldRt4List1Z3KeyRt4List1Z10Alter_dr + 7464 0x80cd9e6 read_field__9READ_INFO + 358 0x8082421 mysql_execute_command__Fv + 9845 0x8085476 yyparse__Fv + 4870 0x8080b4d mysql_execute_command__Fv + 3489 0x808006e mysql_execute_command__Fv + 706 kulan$ mysql-3.23.39 has been compiled on thjis machine running currently 2.2.19 kernel (linux
Slow AND query
I've got a large table with, amongst other things, two indexed varchar fields. Individual queries, SELECT count(*) FROM orders WHERE email != 'control'; is fast (0.01 sec), and SELECT count(*) FROM orders WHERE distdate LIKE '07/%/2001'; is fast (0.02 sec). But, SELECT count(*) FROM orders WHERE distdate LIKE '07/%/2001' AND email = 'control'; is very slow. I can't think of any way to speed up the query. Is there some way I can index it so it will work faster? Thanks. Age --- Adriano Age Manocchia [EMAIL PROTECTED] SalsaSharkNetAIM/Yahoo/MSN: SalsaSharkNet http://SalsaShark.Net/ageICQ: 5962736 --- The capacity to blunder slightly is the real marvel of DNA. Without this special attribute, we would still be anaerobic bacteria, and there would be no music. -Lewis 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: repairing MyISAM table kills mysqld with SIG11
Hi! Try to repair the same table with 3.23.41. If it fails, please let us know, so that we can give you upload instructions. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Date Formats into the DB
On Mon, 27 Aug 2001, Betto McRose G, wrote: I want to know if it's possible to put a format to a Date Field into the DB. For example: I have a data only JUN/2001 for a table, but the field FechaINI format is -00-00, so I want to put just -00 but I cannot. Let MySQL store its format. When you retrieve a date field you may get exactly what you want using the DATE_FORMAT(date,format) function. 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
MySQL on Tru64 UNIX/OSF1
All, Has anyone installed / used MySQL on TRU64 UNIX? I just had to hack up the code to install it and I was curious if anyone else had this problem Or perhaps I am missing a switch on the configure line. In particular the choice of gethostbyname function does not seem to have the proper definition. Wayne Wayne O. CorelliWayne.Corelli [EMAIL PROTECTED] Compaq http://www.testdrive.compaq.com/ MRO1-3/F1 508-467-4138 (OFFICE) 200 Forest Street 508-467-1468 (fax) Marlborough, MA 01752 Email my Pager - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 on Tru64 UNIX/OSF1
Corelli, Wayne writes: All, Has anyone installed / used MySQL on TRU64 UNIX? I just had to hack up the code to install it and I was curious if anyone else had this problem Or perhaps I am missing a switch on the configure line. In particular the choice of gethostbyname function does not seem to have the proper definition. Wayne Wayne O. CorelliWayne.Corelli [EMAIL PROTECTED] Compaq http://www.testdrive.compaq.com/ MRO1-3/F1 508-467-4138 (OFFICE) 200 Forest Street 508-467-1468 (fax) Marlborough, MA 01752 Email my Pager We have installed MySQL on Tru64 Unix many times. With both gcc and Compaq compilers and found out that later one brings 5 - 8 % speed improvement. We also have a version of MySQL++, our C++ API for Compaq compiler. I think you can find some downloadable binaries for Tru64 on MySQL download pages. If you intend to put MySQL to some serious use, and if you can tell me about it, please do so in a direct mail to me. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL error 145
Does anyone know how I can go about troubleshooting what is wrong here? This is mysql on a Linux system I have no idea how to begin troubleshooting why the ACCOUNTING.MYD file can't be opened, I need some hints. Thanks, Chris Fatal Error A serious problem was encountered: Execute failed for 'select ACCTSESSIONID, TIME_STAMP, ACCTSESSIONTIME, ACCTINPUTOCTETS, ACCTOUTPUTOCTETS , FRAMEDIPADDRESS from ACCOUNTING where USERNAME = 'jhfgd' and ACCTSTATUSTYPE='Stop' order by TIME_STAMP': Can't open file: 'ACCOUNTING.MYD'. (errno: 145) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: repairing MyISAM table kills mysqld with SIG11
On Mon, 27 Aug 2001, Sinisa Milivojevic wrote: Hi! Try to repair the same table with 3.23.41. If it fails, please let us know, so that we can give you upload instructions. kulan$ ls -la /home/mysql/Mbovis/cogs_data* -rw-rw1 pedant users54195408 Jul 4 03:52 /home/mysql/Mbovis/cogs_data.MYD -rw-rw1 pedant users 72704 Aug 27 18:44 /home/mysql/Mbovis/cogs_data.MYI -rw-rw1 pedant users8714 Jul 4 03:52 /home/mysql/Mbovis/cogs_data.frm 3.23.41 also fails: mysql use Mbovis; Database changed mysql check table cogs_data; +--+---+--+-+ | Table| Op| Msg_type | Msg_text | | +--+---+--+-+ | Mbovis.cogs_data | check | warning | Table is marked as crashed and last repair |failed | | Mbovis.cogs_data | check | warning | Size of indexfile is: 72704 Should be: |25600 | | Mbovis.cogs_data | check | warning | Size of datafile is: 54195408 Should be: |54195388 | | Mbovis.cogs_data | check | error| Found 3277 keys of 257 | | | Mbovis.cogs_data | check | error| Corrupt | | +--+---+--+-+ 5 rows in set (0.05 sec) mysql repair table cogs_data; ERROR 2013: Lost connection to MySQL server during query mysql quit 0x8079ab8 handle_segfault__Fi + 380 0x8128eba pthread_sighandler + 150 0x814f0b6 chunk_free + 222 0x8151203 free + 155 0x8111cdc my_no_flags_free + 16 0x8106684 mi_repair + 2220 0x80c28e8 repair__9ha_myisamP3THDR17st_mi_check_paramb + 624 0x80c25ee repair__9ha_myisamP3THDP15st_ha_check_opt + 286 0x80c9430 mysql_admin_table__FP3THDP13st_table_listP15st_ha_check_optPCc13thr_lock_typebT5UiPM7handlerFP7handlerP3THDP15st_ha_check_opt_i + 1432 0x80cc173 mysql_repair_table__FP3THDP13st_table_listP15st_ha_check_opt + 67 0x8080fb1 mysql_execute_command__Fv + 4117 0x8083fa2 mysql_parse__FP3THDPcUi + 210 0x807f6bd do_command__FP3THD + 1269 0x807ebbb handle_one_connection__FPv + 551 Binaries produced on the problematic machine (Redhat 6.2), 2.2.19: CFLAGS=-O3 -mpentiumpro -felide-constructors -fno-exceptions -fno-rtti CXX=gcc CXXFLAGS=-O3 -mpentiumpro -feli de-constructors -fno-exceptions -fno-rtti ./configure --prefix=/usr/local/mysql --enable-assembler --with-mysqld -ldflags=-all-static -with-libwrap -with-named-z-lib --with-charset=latin1 --enable-thread-safe-client --with-nam ed-curses-libs=/usr/local/lib/libncurses.a --with-pthread If I should try also your binary distribution, please let me know. -- Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs [EMAIL PROTECTED] Faculty of Science, The Charles University - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Why DATE functions return a String in SELECT
Description: I use the MM JDBC driver version 2.0.4 to access my MySQL database from my Java app. If I do SELECT NOW(), it returns a String object and not a Date object. I tried to call different functions (e.g. SELECT DATE_ADD(NOW(), INTERVAL 0 SECOND)) in order to have a Date in my ResultSet, byt all I get is a String. Also, a query like SELECT *, NOW() FROM some_table also returns a String for the NOW() column and not a Date. How-To-Repeat: Here is a sample Java application to demonstrate this... import java.sql.*; public class Test { public static void main(String[] pasArgs) { try { Connection oConnect; Statement oStmt; ResultSet oRes; Class.forName(org.gjt.mm.mysql.Driver); oConnect = DriverManager.getConnection (jdbc:mysql://host:3306/db, user, password); oStmt = oConnect.createStatement(); oRes = oStmt.executeQuery(SELECT NOW()); oRes.next(); // This prints java.lang.String and not java.util.Date or java.sql.Date System.out.println(oRes.getObject(1).getClass().toString()); oRes.close(); oStmt.close(); oConnect.close(); } catch(Exception ex) { ex.printStackTrace(); } } } Fix: Submitter-Id: submitter ID Originator:Super-User Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.40 (Official MySQL binary) Environment: System: SunOS centaure 5.8 Generic_108528-06 sun4u sparc SUNW,Sun-Blade-100 Architecture: sun4 Some paths: /usr/bin/perl /usr/ccs/bin/make /opt/local/bin/gcc /usr/ucb/cc GCC: Reading specs from /opt/SISPgcc/lib/gcc-lib/sparc-sun-solaris2.6/2.8.1/specs gcc version 2.8.1 Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: -rw-r--r-- 1 root bin 1754016 Nov 23 2000 /lib/libc.a lrwxrwxrwx 1 root root 11 Jun 20 23:17 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1129948 Nov 23 2000 /lib/libc.so.1 -rw-r--r-- 1 root bin 1754016 Nov 23 2000 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Jun 20 23:17 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1129948 Nov 23 2000 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-assembler --disable-shared Perl: This is perl, version 5.005_03 built for sun4-solaris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Needed Please
Hi, use "mysqladmin variables" command to see current settings. I guess your mysqld does not read the config file you have edited. ;-) It happened to me me also few days ago. Remember mysqld looks for /etc/my.cnf and $DATADIR/var/my.cnf if I remember well. Maybe put the path to config file just on the command line into safe_mysqld script. Martin Hi I need to set the max_allowed_packet to 16M. below is my 01mysql-server.sh file. I use DBI and I know that I have to start this before the DBI program and I did but if I use ./mysqld --help it shows that my max_allowed_packet is still 1M. Any help would be really great since I've been working on this all day :( - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: repairing MyISAM table kills mysqld with SIG11
=?iso-8859-2?Q?Martin_MOKREJ=A9?= writes: On Mon, 27 Aug 2001, Sinisa Milivojevic wrote: If I should try also your binary distribution, please let me know. -- Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs [EMAIL PROTECTED] Faculty of Science, The Charles University Hi! Please try out our binary distro. I guess that you would not like either that we spend our time on fixing something that should not be fixed. If that repair crashes our latest binary, make a tar.gz out of your table and upload it to: ftp://support.mysql.com/pub/mysql/secret And send me a direct mail with a name of your tarball. Thanks in advance. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL error 145
Error: 45 145 = Table was marked as crashed and should be repaired On Mon, 27 Aug 2001 08:50:45 -0600, Chris M [EMAIL PROTECTED] wrote: Does anyone know how I can go about troubleshooting what is wrong here? This is mysql on a Linux system I have no idea how to begin troubleshooting why the ACCOUNTING.MYD file can't be opened, I need some hints. Thanks, Chris Fatal Error A serious problem was encountered: Execute failed for 'select ACCTSESSIONID, TIME_STAMP, ACCTSESSIONTIME, ACCTINPUTOCTETS, ACCTOUTPUTOCTETS , FRAMEDIPADDRESS from ACCOUNTING where USERNAME = 'jhfgd' and ACCTSTATUSTYPE='Stop' order by TIME_STAMP': Can't open file: 'ACCOUNTING.MYD'. (errno: 145) Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-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
Error 1045
Hi all. I am relatively new to mysql and brand new on this list :) Please help me with this: I have to backup a database and the simplest way to accomplish this is SELECT * FROM mytable INTO OUTFILE '/nobody_directory/mytabledump.txt'; The problem is that when I do this, the server response is: Error 1045: Access denied for user:'[EMAIL PROTECTED]' (Using password: YES). The grant for the user maxx is: Grant usage on *.* to maxx@'%' IDENTIFIED BY scrambledpassword Grant all privileges on main.* to maxx@'%'. The server is 3.23.39, protocol version 10, connection UNIX Socket running on RH Linux 7.0. The regular SELECT, UPDATE etc. are running correctly, only the dump does not. Can you help me with this, or where I should dig into documentation? Thanks a lot! Alex Sofronie [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: MySQL error 145
Chris M wrote: Does anyone know how I can go about troubleshooting what is wrong here? This is mysql on a Linux system I have no idea how to begin troubleshooting why the ACCOUNTING.MYD file can't be opened, I need some hints. That means that the table has crashed. Repair it with command repair table accounting; -- _/_/ _/_/_/ - 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
Inner selects
Hi all, I was wondering if it is possible to perform an inner select in MySQL. I have a database called EMP and when i enter the following query, I keep getting error 1064: select ename,deptno from emp where deptno in (select deptno from emp where ename = 'SCOTT') The error message reads as follows: ERROR 1064: You have an error in your SQL syntax near 'select deptno from emp where ename='scott')' at line 1 Does MySQL support inner select this way or is there another way to achieve the same? Thanks for your help. Best Regards, Michael Beaucourt -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
THANKS for having fixed DISTINCT ... HAVING bug...
... you are really very kind and helpful! Now I can avoid managing temp tables. Thanks very much, Nico Sabbi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Inner selects
Michael Beaucourt wrote: Hi all, I was wondering if it is possible to perform an inner select in MySQL. I have a database called EMP and when i enter the following query, I keep getting error 1064: select ename,deptno from emp where deptno in (select deptno from emp where ename = 'SCOTT') The error message reads as follows: ERROR 1064: You have an error in your SQL syntax near 'select deptno from emp where ename='scott')' at line 1 You can achieve it by writing this query in the following way: select a.ename,a.deptno from emp a,emp b where a.deptno=b.deptno and b.ename='SCOTT'; MySQL doesn't support subselects; -- _/_/ _/_/_/ - 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
Re: Inner selects
no mysql right now (3.23) does not support inner selects. however, it looks like you could join the 2 tables to get the result you want I'm assuming there are 2 tables inside the emp database ? or is emp the table ? anyway here is an idea: select d1.ename, d1.deptno FROM emp.table1 d1, emp.table2 d2 WHERE d1.deptno = d2.deptno AND d2.ename = 'SCOTT' -- Andrew - Original Message - From: Michael Beaucourt [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 27, 2001 11:27 AM Subject: Inner selects Hi all, I was wondering if it is possible to perform an inner select in MySQL. I have a database called EMP and when i enter the following query, I keep getting error 1064: select ename,deptno from emp where deptno in (select deptno from emp where ename = 'SCOTT') The error message reads as follows: ERROR 1064: You have an error in your SQL syntax near 'select deptno from emp where ename='scott')' at line 1 Does MySQL support inner select this way or is there another way to achieve the same? Thanks for your help. Best Regards, Michael Beaucourt -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
selecting what is not in something
I have two tables and that have a couple of identical columns. I would like to find out what of a certain column is in one table and not in another. I've tried the following, but I get errors: select col1 from tab1 where col1 not in (select col1 from tab2); select tab1.col1 from tab1,tab2 where tab1.col1 not in tab2; Please tell me how I can do this type of query. Jeff Shipman E-Mail: [EMAIL PROTECTED] Systems Programmer Phone: (505) 835-5748 NMIMT Computer Center http://www.nmt.edu/~jeff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: repairing MyISAM table kills mysqld with SIG11
cut Can you upload a copy of blast_data to ftp://support.mysql.com/pub/mysql/secret after verify first that what you plan to upload will crash a separate MySQL server on REPAIR? -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: repairing MyISAM table kills mysqld with SIG11 (fwd)
Hi, sorry I did not send the last e-mail to the whole list, so here it is. -- Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs [EMAIL PROTECTED] Faculty of Science, The Charles University -- Forwarded message -- Date: Mon, 27 Aug 2001 17:39:07 +0200 (MET DST) From: Martin MOKREJ [EMAIL PROTECTED] To: Sinisa Milivojevic [EMAIL PROTECTED] Subject: Re: repairing MyISAM table kills mysqld with SIG11 On Mon, 27 Aug 2001, Sinisa Milivojevic wrote: Please try out our binary distro. I guess that you would not like either that we spend our time on fixing something that should not be fixed. OK, so this is from mysql-3.23.41-pc-linux-gnu-i686/bin/mysqld.sym.gz et al.: mysql check table cogs_data; +--+---+--+-+ | Table| Op| Msg_type | Msg_text | | +--+---+--+-+ | Mbovis.cogs_data | check | warning | Table is marked as crashed and last repair |failed | | Mbovis.cogs_data | check | warning | Size of indexfile is: 72704 Should be: |25600 | | Mbovis.cogs_data | check | warning | Size of datafile is: 54195408 Should be: |54195388 | | Mbovis.cogs_data | check | error| Found 3277 keys of 257 | | | Mbovis.cogs_data | check | error| Corrupt | | +--+---+--+-+ 5 rows in set (0.55 sec) mysql repair table cogs_data; ERROR 2013: Lost connection to MySQL server during query mysql quit 0x807b1b8 handle_segfault__Fi + 380 0x812af8a pthread_sighandler + 154 0x81517df free + 39 0x8114a6c my_no_flags_free + 16 0x8109304 mi_repair + 2236 0x80c4768 repair__9ha_myisamP3THDR17st_mi_check_paramb + 624 0x80c446e repair__9ha_myisamP3THDP15st_ha_check_opt + 286 0x80cb320 mysql_admin_table__FP3THDP13st_table_listP15st_ha_check_optPCc13thr_lock_typebT5UiPM7handlerFP7handlerP3THDP15st_ha_check_opt_i + 1432 0x80ce076 mysql_repair_table__FP3THDP13st_table_listP15st_ha_check_opt + 70 0x8082641 mysql_execute_command__Fv + 4133 0x80856a6 mysql_parse__FP3THDPcUi + 210 0x8080d2d do_command__FP3THD + 1261 0x808022c handle_one_connection__FPv + 548 If that repair crashes our latest binary, make a tar.gz out of your table and upload it to: ftp://support.mysql.com/pub/mysql/secret kulan$ ftp support.mysql.com Connected to support.mysql.com. 220 www.mysql.com FTP server ready. Name (support.mysql.com:pedant): ftp 331 Guest login ok, send your complete e-mail address as password. Password: 530 Can't set guest privileges. Login failed. ftp user anonymous 331 Guest login ok, send your complete e-mail address as password. Password: 530 Can't set guest privileges. Login failed. ftp And send me a direct mail with a name of your tarball. http://pednew.gsf.de/cogs_data.tgz Please let me know that I can remove the file. ;) Thanks! -- Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs [EMAIL PROTECTED] Faculty of Science, The Charles University - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Compiling MySQL Database on LinuxPPC
Is there any specific reason you are compiling MySQL? I use MySQL on LinuxPPC, and never have compiled it due to the great rpm's available here: http://www.linuxppc.org/ (right side of the page) Hi all, Frustrated by failing compile: This is the message I get: c++: Internal compiler eror: program cc1plus got fatal signal 15 make[3]: ***[field.o] Error 1 make[3]: Leaving directory '/usr/src/mysql-3.23.37/sql' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory '/usr/src/mysql-3.23.37/sql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory '/usr/src/mysql-3.23.37' make: *** [all-recursive] Error 2 Any suggestions Regards George Pitcher Technical Manager HERON Project Napier University Edinburgh EH10 5DT [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] http://www.heron.ac.uk programmer - A device for transmuting caffeine into code. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: selecting what is not in something
Jeff, If the result table from the inner select is not huge, I usually issue the inner query by itself first, then build (in my scripting language of choice) a comma-delimited text field containing the results that I don't want in my final table. I then expand that text field into the 'NOT IN' clause, quoted as appropriate. It works reasonably well, but I haven't benchmarked the speed issues with large results from the inner query. Hope that helps. If MySQL asks me, my TOP priority is INNER SELECTs. But that's probably just me... Jay Fesco -Original Message- From: Jeff Shipman - SysProg [mailto:[EMAIL PROTECTED]] Sent: Monday, August 27, 2001 11:38 AM To: [EMAIL PROTECTED] Subject: selecting what is not in something I have two tables and that have a couple of identical columns. I would like to find out what of a certain column is in one table and not in another. I've tried the following, but I get errors: select col1 from tab1 where col1 not in (select col1 from tab2); select tab1.col1 from tab1,tab2 where tab1.col1 not in tab2; Please tell me how I can do this type of query. Jeff Shipman E-Mail: [EMAIL PROTECTED] Systems Programmer Phone: (505) 835-5748 NMIMT Computer Center http://www.nmt.edu/~jeff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Inner selects
Michael Beaucourt wrote: Hi all, I was wondering if it is possible to perform an inner select in MySQL. I have a database called EMP and when i enter the following query, I keep getting error 1064: select ename,deptno from emp where deptno in (select deptno from emp where ename = 'SCOTT') The error message reads as follows: ERROR 1064: You have an error in your SQL syntax near 'select deptno from emp where ename='scott')' at line 1 You can achieve it by writing this query in the following way: select a.ename,a.deptno from emp a,emp b where a.deptno=b.deptno and b.ename='SCOTT'; MySQL doesn't support subselects; -- _/_/ _/_/_/ - 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 *==-- Hi, Thanks for the answer. I already knew this was another solution for the query, but I was actually just wondering if MySQL supported inner select. Now I have some other questions also (I'm having a test for school tomorrow and school is using Oracle and I am using MySQL ;): - In oracle you have outer joins, where you have to use a (+) to find rows with null values and stuff like that. Any suggestions on how to do this in MySQL? - The function UNION to connect 2 select queries also doesn't seem to work in MySQL. Any workarounds? - In Oracle there is a very powerful DECODE(expr1,searchstring1,replacestring1,[searchstring2,replacestring2],[default]) but apparently decode means something else in MySQL. Is there a comparable function in MySQL? Thanks. Michael -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: the most used DB in Webhosting
I used to be a Lasso/FileMaker programmer. The day I decided to switch to the all-unix MySQL/PHP/Perl platform was very telling. I was attempting to parse log files with Lasso's file tags. Everything was working quite well, but once the log file was bigger than about 500k, it would hang the system for 60 seconds or more, while Lasso churned through the file. I decided to rewrite the script in Perl. What took lasso (which FileMaker Instant Publishing is built on) 1 or 2 minutes was instantaneous. The same goes for FileMaker, a search that returns more than 100 records, or inserting more than 20 records into a single table can take eons. With PHP/MySQL, I can do a dozen queries with complicated joins, in one script, and MySQL just spits the data out in record time. (even on an old, crusty PowerMac 7600/132)... I love FileMaker and will always use it on my desktop, but I have sworn off if it on the web, it's not meant for web-apps. I won't even go into scalability or backups. There are many interesting ways you could bridge the gap using FileMaker plug-ins, or JDBC, or ODBC, to move data into and out of a MySQL server, if you use Macs, you could even use MacSQL Monitor and AppleScript. Regards, David Dahl This is probably heresy here, but we use Filemaker for our web-database solution. The main reason why we use that in preference to more 'robust' SQL-based DBs is that we have a team using Filemaker clients updating information constantly and Filemaker is the most efficient db we have found to do that. We are currently evaluating MySQL to see if there are any advantages in moving. Regards George Pitcher Technical Manager HERON Project Napier University Edinburgh EH10 5DT [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] http://www.heron.ac.uk programmer - A device for transmuting caffeine into code. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 27, 2001 12:50 PM Subject: the most used DB in Webhosting Dear members, I know you are MySQLer but be honest, what is the the most used Database in ISP of webhosting, and the reasons. And fornyou, after MySQL what is the DB the you prefer in webhosting. thanks to all - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: selecting what is not in something
At 9:38 AM -0600 8/27/01, Jeff Shipman - SysProg wrote: I have two tables and that have a couple of identical columns. I would like to find out what of a certain column is in one table and not in another. I've tried the following, but I get errors: select col1 from tab1 where col1 not in (select col1 from tab2); select tab1.col1 from tab1,tab2 where tab1.col1 not in tab2; Please tell me how I can do this type of query. Use a LEFT JOIN. SELECT tab1.col1 FROM tab1 LEFT JOIN tab2 ON tab1.col1 = tab2.col1 WHERE tab2.col1 IS NULL tab2.col1 must be declared as NOT NULL for this to work. Jeff Shipman E-Mail: [EMAIL PROTECTED] Systems Programmer Phone: (505) 835-5748 NMIMT Computer Center http://www.nmt.edu/~jeff -- 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
Overwriting records with matching fields with dbf2mysql
What would be the best way to do this because I am working on a mysql replacement to an old foxpro database and I can import the table once but I am worried that if I try to import it again it will make duplicate records. Another issue is that I have added an extra field to the table which is not in the original table but I would like to keep it preserved some how. Any help would be great. Armando - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
GUI Error
Dear Sir, Ihave encountered an error with the windows version of the MySQL GUI. This error happens only when I try to pull data from the this table in the GUI. I can pull information from other sources. The GUI program will initiate a memory error message and quit. Is this a bug? This is the table: CREATE TABLE DVC (ID INTEGER(6) AUTO_INCREMENT PRIMARY KEY, SalesPerson VARCHAR(30), StartDate DATE, EndDate DATE, AccountNumber INTEGER(6), Company VARCHAR(60), BillAddress VARCHAR(30), City VARCHAR(20), State CHAR(2), Zip CHAR(5), Phone CHAR(12), AnnualVolume INTEGER(6), RateYear YEAR(4), Display DECIMAL(4,2), DisplaySunday DECIMAL(4,2), TVTimes DECIMAL(4,2), ClassLine DECIMAL(4,2), ClassLineSunday DECIMAL(4,2), ClassDisplay DECIMAL(4,2), ClassDisplaySunday DECIMAL(4,2), Zoned DECIMAL(4,2)), PrePrint DECIMAL(4,2)); --Jason =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Jason A. Vest Systems/ISP Manager-The Daily News Longview , Washington Ph. 360.575.6202 Fax 360.575.6204 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
iASP Engine...
Hello, My ISP suppports iASP. I've moved my site from running on Windows 2000 Server to a linux zeus web server. Everything runs fine from querying the mySQL database and returning records. But after about 5-10 queries of the database returning 20 records at a time the iASP engine slow right down, and this results in time out problems. Has anyone seen this problem, or know a fix for it ??? Thanks 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
Choosing between databases.
Hello, I am very new to mySQL and researching on the various databases options. Since I needed transactions enabled, so after a lot of research, I narrowed down to innodb and Bdb. But realized that Innodb is in alpha but BDB is very stable. Although I like the features that innodb has to offer, but for stability purposes I am leaning to BDB! Please let me know if there is anything that I missed in my research, or links that I should look into before I make up my mind. Thanks, really appreciate your help. Sheena. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Inner selects
Hi, - In oracle you have outer joins, where you have to use a (+) to find rows with null values and stuff like that. Any suggestions on how to do this in MySQL? You must use the Left Join type syntax in the FROM clause of your query. - The function UNION to connect 2 select queries also doesn't seem to work in MySQL. Any workarounds? I believe, not yet supported in MySQL. - In Oracle there is a very powerful DECODE(expr1,searchstring1,replacestring1,[searchstring2,replacestring2],[ default]) but apparently decode means something else in MySQL. Is there a comparable function in MySQL? Yes: It's the same as the MSSQL70 function. CASE expr1 WHEN searchstring1 THEN replacestring1 [WHEN searchstring2 THEN replacestring2] [ELSE default] END Good luck, Bruce - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Choosing between databases.
FWIW, I am using INNODB tables in production without a problem. Cal * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com * - Original Message - From: Sheena Sidhu [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 27, 2001 12:24 Subject: Choosing between databases. Hello, I am very new to mySQL and researching on the various databases options. Since I needed transactions enabled, so after a lot of research, I narrowed down to innodb and Bdb. But realized that Innodb is in alpha but BDB is very stable. Although I like the features that innodb has to offer, but for stability purposes I am leaning to BDB! Please let me know if there is anything that I missed in my research, or links that I should look into before I make up my mind. Thanks, really appreciate your help. Sheena. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Inner selects
On Mon, Aug 27, 2001 at 07:28:24PM +0200, Bruce Stewart wrote: - The function UNION to connect 2 select queries also doesn't seem to work in MySQL. Any workarounds? I believe, not yet supported in MySQL. It's was in the 4.0 tree last I looked, so it won't be long. :-) 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 10 days, processed 123,720,614 queries (137/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
Poblem with ODBC / W98 / ADO
Hi, 1. Please excuse my English mistakes I am a Swiss with Swiss German as mother language. My problem is related to using MySQL under Windows98 I have installed MySQL 3.23.41 MyODBC 2.50.38-win95 and Microsoft ADO 2.0 is used. I often get an error -2147217887 when a string in a VARCHAR- or a TEXT-field should get replaced by a longer string (of course still within the VARCHAR-length specification which means the replacement can not be done. A work around is to always enlarge with spaces to a maximum length but it s not really what we are looking for and its a problem regarding data which has been imported from an Access database and therefore dos not have the spaces. The error occurs when the content of the recordset field should get replaced (before the update command) I have always had the error when TEXT fields are concerned in the case of VARCHAR-fields it happens in some cases and others behave perfectly. I do not see any bug from my side which could be the reason. Can someone help me with information about this? Many thanks Alain Bebie [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
Selecting * from multiple tables
I'm running into a snag... here's an example of the query I'm making from within Perl: SELECT * FROM table1,table2 I know it's not a nice way to do it, but I'm making an SQL webpage frontend which I'd like to support it just in case. I'm using fetchrow-hashref to pull it out and display it. The problem I'm running into is when table1 and table2 have similar column names. One of them would be overwritten in the hash reference to be replaced by the second one it encounters. So my question is this. Is there any way to force MySQL to ouput the table name with the column name instead of just the column name, ie. table1.column2. Thanks in advance, Dave Mittner - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: repairing MyISAM table kills mysqld with SIG11 (fwd)
On Mon, 27 Aug 2001, Martin MOKREJ wrote: ftp://support.mysql.com/pub/mysql/secret Hmm, I can already login as ftp, but can only chdir to /pub/mysql, there's no secret directory. ;( http://pednew.gsf.de/cogs_data.tgz Hmm, try out http://kulan.gsf.de/cogs_data.tgz , but I'm sure the previous worked for me. ;-) Do you have it? -- Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs [EMAIL PROTECTED] Faculty of Science, The Charles University - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: THANKS for having fixed DISTINCT ... HAVING bug...
nsabbi writes: ... you are really very kind and helpful! Now I can avoid managing temp tables. Thanks very much, Nico Sabbi You are welcome. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Selecting * from multiple tables
At 10:43 AM -0700 8/27/01, Dave Mittner wrote: I'm running into a snag... here's an example of the query I'm making from within Perl: SELECT * FROM table1,table2 I know it's not a nice way to do it, but I'm making an SQL webpage frontend which I'd like to support it just in case. I'm using fetchrow-hashref to pull it out and display it. The problem I'm running into is when table1 and table2 have similar column names. One of them would be overwritten in the hash reference to be replaced by the second one it encounters. So my question is this. Is there any way to force MySQL to ouput the table name with the column name instead of just the column name, ie. table1.column2. No. Name the columns explicitly and give them aliases. Thanks in advance, Dave Mittner -- 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: Selecting * from multiple tables
On Monday 27 August 2001 19:43, Dave Mittner wrote: I'm running into a snag... here's an example of the query I'm making from within Perl: SELECT * FROM table1,table2 I know it's not a nice way to do it, but I'm making an SQL webpage frontend which I'd like to support it just in case. I'm using fetchrow-hashref to pull it out and display it. The problem I'm running into is when table1 and table2 have similar column names. One of them would be overwritten in the hash reference to be replaced by the second one it encounters. So my question is this. Is there any way to force MySQL to ouput the table name with the column name instead of just the column name, ie. table1.column2. Not that I know of. What you could do is create aliases using AS, e.g. SELECT *, table2.column2 AS table2_column2 FROM table1,table2 but then you would need to know which columns to alias. Or how about using fetchrow_arrayref()? That would remove the duplicate hash key problem, although you would have to extrapolate the column names yourself. Hope your system has lots of memory to cope with that select statement on tables of any significant size ;-) HTH Ian Barwick -- Ian Barwick - Developer - [EMAIL PROTECTED] akademie.de asp GmbH - http://www.akademie.de To query tables in a MySQL database is more fun than eating spam - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: repairing MyISAM table kills mysqld with SIG11 (fwd)
mysql repair table cogs_data; ERROR 2013: Lost connection to MySQL server during query mysql quit 0x807b1b8 handle_segfault__Fi + 380 0x812af8a pthread_sighandler + 154 0x81517df free + 39 0x8114a6c my_no_flags_free + 16 0x8109304 mi_repair + 2236 0x80c4768 repair__9ha_myisamP3THDR17st_mi_check_paramb + 624 0x80c446e repair__9ha_myisamP3THDP15st_ha_check_opt + 286 0x80cb320 mysql_admin_table__FP3THDP13st_table_listP15st_ha_check_optPCc13t= hr_lock_typebT5UiPM7handlerFP7handlerP3THDP15st_ha_check_opt_i + 1432 0x80ce076 mysql_repair_table__FP3THDP13st_table_listP15st_ha_check_opt + 70 0x8082641 mysql_execute_command__Fv + 4133 0x80856a6 mysql_parse__FP3THDPcUi + 210 0x8080d2d do_command__FP3THD + 1261 0x808022c handle_one_connection__FPv + 548 =20 If that repair crashes our latest binary, make a tar.gz out of your table and upload it to: =20 ftp://support.mysql.com/pub/mysql/secret kulan$ ftp support.mysql.com Connected to support.mysql.com. 220 www.mysql.com FTP server ready. Name (support.mysql.com:pedant): ftp 331 Guest login ok, send your complete e-mail address as password. Password: 530 Can't set guest privileges. Login failed. ftp user anonymous 331 Guest login ok, send your complete e-mail address as password. Password:=20 530 Can't set guest privileges. Login failed. ftp Sorry about that - we have now fixed the problems with our anonymous FTP upload, and it should be working. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Choosing between Databases.
Hello, I am looking into choosing between Innodb and BDB. One thing about BDB which I am quoting from the official site : Berkeley DB does not support SQL queries. All access to data is through the Berkeley DB API. Developers must learn a new set of interfaces in order to work with Berkeley DB. Although the interfaces are fairly simple, they are non-standard. has me worried. When I looked into Innodb, I see not similar reference so can I assume that it supports SQL. Can someone please let me know if I am wrong here? Thanks in advance, Sheena. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: GUI Error
Jason A. Vest writes: Dear Sir, Ihave encountered an error with the windows version of the MySQL GUI. This error happens only when I try to pull data from the this table in the GUI. I can pull information from other sources. The GUI program will initiate a memory error message and quit. Is this a bug? --Jason =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Jason A. Vest Systems/ISP Manager-The Daily News Longview , Washington Ph. 360.575.6202 Fax 360.575.6204 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thanks. I will check it out. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error Install MySQL Binary on AIX
Description: I downloaded the lated AIX binary from mysql.com, and unpacked it to /usr/local/mysql. I then cd'd to /usr/local/mysql and ran scripts/mysql_install_db per the INSTALL-BINARY file. This is the error I recieve: exec(): 0509-036 Cannot load program ./bin/my_print_defaults because of the following errors: 0509-130 Symbol resolution failed for my_print_defaults because: 0509-136 Symbol strcat (number 60) is not exported from dependent module /usr/local/lib/libz.a(shr.o). 0509-136 Symbol memmove (number 61) is not exported from dependent module /usr/local/lib/libz.a(shr.o). 0509-136 Symbol bcopy (number 62) is not exported from dependent module /usr/local/lib/libz.a(shr.o). 0509-192 Examine .loader sections symbols with the 'dump -Tv' command. I also recieve similar errors to that referencing ./bin/mysqld instead of ./bin/my_print_defaults. How-To-Repeat: scripts/mysql_install_db Fix: Submitter-Id: submitter ID Originator:Andrew Griffin ([EMAIL PROTECTED]) Organization: Emerson Process Management MySQL support: none Synopsis: Severity: non-critical Priority: medium Category: mysql Class: support Release: mysql-3.23.41 (Official MySQL binary) Environment: System: AIX aixtest1 3 4 000165744C00 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/local/lib/gcc-lib/powerpc-ibm-aix4.3.2.0/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='-O3 -mcpu=powerpc -Wa,-many ' CXX='c++' CXXFLAGS='-O3 -mcpu=powerpc -Wa,-many -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx 1 bin bin 19 Jun 19 16:12 /lib/libc.a - /usr/ccs/lib/libc.a lrwxrwxrwx 1 bin bin 19 Jun 19 16:12 /usr/lib/libc.a - /usr/ccs/lib/libc.a Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --disable-shared Perl: This is perl, version 5.005_03 built for aix - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: repairing MyISAM table kills mysqld with SIG11 (fwd)
Sorry about that - we have now fixed the problems with our anonymous FTP upload, and it should be working. lokk in pub/mysql/secret/ for: 15593452(size) cogs_data.tgz But same file should be accessible already via the 2 web links I've sent to you via personal e-mail. Thanks. -- Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs [EMAIL PROTECTED] Faculty of Science, The Charles University - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Solaris 2.8 configure problem...
I have a fairly new Solaris 2.8 (Ultra Sparc) machine on which I'm trying to build the MySQL client libraries. According to the INSTALL-SOURCE file, I need to use a command-line like this: CC=gcc CFLAGS=-O3 CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti ./configure --without-server --with-low-memory --enable-assembler config.err When I do that and look at config.err, I see the error message: configure: error: can not run test program while cross compiling Here's the whole thing (since the list won't take attachments). It's not too long. ---snip--- loading cache ./config.cache checking host system type... sparc-sun-solaris2.8 checking target system type... sparc-sun-solaris2.8 checking build system type... sparc-sun-solaris2.8 checking for a BSD compatible install... (cached) /usr/local/bin/install -c checking whether build environment is sane... yes checking whether make sets ${MAKE}... (cached) yes checking for working aclocal... found checking for working autoconf... found checking for working automake... found checking for working autoheader... found checking for working makeinfo... missing checking whether to enable maintainer-specific portions of Makefiles... no checking whether build environment is sane... yes checking whether make sets ${MAKE}... (cached) yes checking for gawk... (cached) nawk checking for gcc... (cached) gcc checking whether the C compiler (gcc -O3 ) works... yes checking whether the C compiler (gcc -O3 ) is a cross-compiler... no checking whether we are using GNU C... (cached) yes checking whether gcc accepts -g... (cached) yes checking for c++... (cached) c++ checking whether the C++ compiler (c++ -O3 -felide-constructors -fno-exceptions -fno-rtti ) works... yes checking whether the C++ compiler (c++ -O3 -felide-constructors -fno-exceptions -fno-rtti ) is a cross-compiler... yes checking whether we are using GNU C++... (cached) yes checking whether c++ accepts -g... (cached) yes checking how to run the C preprocessor... (cached) gcc -E checking for ranlib... (cached) ranlib checking for ld used by GCC... (cached) /usr/ccs/bin/ld checking if the linker (/usr/ccs/bin/ld) is GNU ld... (cached) no checking for BSD-compatible nm... (cached) /usr/ccs/bin/nm -p checking whether ln -s works... (cached) yes loading cache ./config.cache within ltconfig checking for object suffix... o checking for executable suffix... (cached) no checking for gcc option to produce PIC... -fPIC checking if gcc PIC flag -fPIC works... yes checking if gcc supports -c -o file.o... yes checking if gcc supports -c -o file.lo... yes checking if gcc supports -fno-rtti -fno-exceptions ... yes checking if gcc static flag -static works... -static checking if the linker (/usr/ccs/bin/ld) is GNU ld... no checking whether the linker (/usr/ccs/bin/ld) supports shared libraries... yes checking command to parse /usr/ccs/bin/nm -p output... ok checking how to hardcode library paths into programs... immediate checking for /usr/ccs/bin/ld option to reload object files... -r checking dynamic linker characteristics... solaris2.8 ld.so checking if libtool supports shared libraries... yes checking whether to build shared libraries... yes checking whether to build static libraries... yes checking for objdir... .libs creating libtool loading cache ./config.cache checking for a BSD compatible install... /usr/local/bin/install -c checking for bison... bison -y checking for pdftex... no checking return type of sprintf... configure: error: can not run test program while cross compiling ---snip--- According to the INSTALL-SOURCE file, that error means you have something wrong with your compiler installation! But I've already used this exact same compiler to bulild a *ton* of other packages on the machine. What can I do to fix/debug this problem? Thanks, 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 10 days, processed 124,283,460 queries (137/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
Re: Error Install MySQL Binary on AIX
[EMAIL PROTECTED] writes: Description: I downloaded the lated AIX binary from mysql.com, and unpacked it to /usr/local/mysql. I then cd'd to /usr/local/mysql and ran scripts/mysql_install_db per the INSTALL-BINARY file. This is the error I recieve: exec(): 0509-036 Cannot load program ./bin/my_print_defaults because of the following errors: 0509-130 Symbol resolution failed for my_print_defaults because: 0509-136 Symbol strcat (number 60) is not exported from dependent module /usr/local/lib/libz.a(shr.o). 0509-136 Symbol memmove (number 61) is not exported from dependent module /usr/local/lib/libz.a(shr.o). 0509-136 Symbol bcopy (number 62) is not exported from dependent module /usr/local/lib/libz.a(shr.o). 0509-192 Examine .loader sections symbols with the 'dump -Tv' command. I also recieve similar errors to that referencing ./bin/mysqld instead of ./bin/my_print_defaults. How-To-Repeat: scripts/mysql_install_db Fix: Submitter-Id:submitter ID Originator: Andrew Griffin ([EMAIL PROTECTED]) Organization: Emerson Process Management MySQL support: none Synopsis: Severity:non-critical Priority:medium Category:mysql Class: support Release: mysql-3.23.41 (Official MySQL binary) Environment: System: AIX aixtest1 3 4 000165744C00 Hi! We plan to fix this in our next release. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Solaris 2.8 configure problem...
Jeremy Zawodny writes: I have a fairly new Solaris 2.8 (Ultra Sparc) machine on which I'm trying to build the MySQL client libraries. According to the INSTALL-SOURCE file, I need to use a command-line like this: CC=gcc CFLAGS=-O3 CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti ./configure --without-server --with-low-memory --enable-assembler config.err When I do that and look at config.err, I see the error message: configure: error: can not run test program while cross compiling Here's the whole thing (since the list won't take attachments). It's not too long. According to the INSTALL-SOURCE file, that error means you have something wrong with your compiler installation! But I've already used this exact same compiler to bulild a *ton* of other packages on the machine. What can I do to fix/debug this problem? Thanks, 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 10 days, processed 124,283,460 queries (137/sec. avg) Jeremy, In our manual, chapter on Solaris, there are instructions on which lines to delete from configure script in the case like above. Just do that ! -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: repairing MyISAM table kills mysqld with SIG11 (fwd)
On Monday 27 August 2001 12:30, Martin MOKREJ? wrote: Sorry about that - we have now fixed the problems with our anonymous FTP upload, and it should be working. lokk in pub/mysql/secret/ for: 15593452(size) cogs_data.tgz But same file should be accessible already via the 2 web links I've sent to you via personal e-mail. Thanks. Thanks. Monty or Sergei - can you take a look at it - repair table cogs_data; dumps core with the following backtrace: 0x807b1b8 handle_segfault__Fi + 380 0x812af8a pthread_sighandler + 154 0x81517df free + 39 0x8114a6c my_no_flags_free + 16 0x8109304 mi_repair + 2236 0x80c4768 repair__9ha_myisamP3THDR17st_mi_check_paramb + 624 0x80c446e repair__9ha_myisamP3THDP15st_ha_check_opt + 286 0x80cb320 mysql_admin_table__FP3THDP13st_table_listP15st_ha_check_optPCc13thr_lock_typebT5UiPM7handlerFP7handlerP3THDP15st_ha_check_opt_i + 1432 0x80ce076 mysql_repair_table__FP3THDP13st_table_listP15st_ha_check_opt + 70 0x8082641 mysql_execute_command__Fv + 4133 0x80856a6 mysql_parse__FP3THDPcUi + 210 0x8080d2d do_command__FP3THD + 1261 0x808022c handle_one_connection__FPv + 548 -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SQLDriverConnect
If the connection string for SQLDriverConnect is DSN=foo, and DSN foo is defined within the odbc.ini file, then connection succeeds. However, if the connection string for SQLDriverConnect is DRIVER={MySQL};SERVER=foo_host;USER=foo;PWD=bar;DATABASE=foo_db, then error condition is returns with Specified driver could not be loaded, SQLSTATE IM003 What is wrong with my DRIVER value? Thanks Jeff Tanner Seattle, WA - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Urgent
Hi, I have mysql version 3.32.40 installed on my system. Please let me know what I need to take care of (besides the db backup) if I need to upgrade to mysql-max? I need this on an urgent basis, so please help! Thanks, Sheena. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 and GPL license: questions and discussion
I would like to discuss the MYSQL licensing policy. Please do not take anything personally. I do think that MySQL is one of best database management systems out there. Pertaining to the FAQ on the mysql.com site: --- begin snip Q:Does MySQL AB develop non-open source products? A:No. All the software we develop is open source / free software. The core MySQL[tm] server is under GPL. --- end snip -- I would like to know some more details here. In particular: 1. What was the name of the first GPL file release of MySQL? 2. Which portions are not distributed by mysql.com as part of MySQL? 3. Which portions of the Windows MySQL release are not released under the GPL if any? For instance is the windows installer program (is there one?) released under the GPL? 4. Are the Linux versions shipped with Red Hat 7 and 7.1 entirely distributed under the GPL? 5. Do PHP web applications that use PHP and MySQL require a MySQL license? Such applications are not derivative works as they are merely interfaces. Thus they do not require a license. Correct? References: 1. http://www.mysql.com/news/article-36.html (announces GLP release of source code) 2. http://www.mysql.com/news/article-75.html (some FAQs including the above) A:Forks are perfectly legal derivatives of GPL'd code as long as the GPL terms are followed. But please note that forking does not give the forker any rights to use the trademarks of others. The most ambiguous aspect of the GPL is that it does not seem to clearly specify what and what not comprises a derivative work. Does a web application which uses MySQL comprise a derivative work. I don't think so. Do such web applications have to be placed under the GPL. I don't see anything in the GPL that states this. Thanks for the clarification, 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
Re: Solaris 2.8 configure problem...
On Mon, Aug 27, 2001 at 09:43:23PM +0300, Sinisa Milivojevic wrote: Jeremy, In our manual, chapter on Solaris, there are instructions on which lines to delete from configure script in the case like above. Right. I've looked at: http://www.mysql.com/doc/S/o/Solaris.html http://www.mysql.com/doc/S/o/Solaris_2.7.html But none of them seem related to the problem I'm having. I'm using gcc 2.95.3, not Sun's compiler, so I can rule out a lot of those problems. And I'm not even to the point of trying to actually *build* MySQL, so I can rule out most of the stuff on the 2nd page. I'm stuck at ./configure. The only thing that seems to apply is this part: If you get the following error from configure: checking for restartable system calls... configure: error can not run test programs while cross compiling This means that you have something wrong with your compiler installation! In this case you should upgrade your compiler to a newer version. You may also be able to solve this problem by inserting the following row into the `config.cache' file: ac_cv_sys_restartable_syscalls=${ac_cv_sys_restartable_syscalls='no'} If you are using Solaris on a SPARC, the recommended compiler is gcc 2.95.2. You can find this at http://gcc.gnu.org/. Note that egcs 1.1.1 and gcc 2.8.1 don't work reliably on SPARC! But that's not the error I'm seeing. I'm not getting that far. I've looked at config.cache and found this already set: ac_cv_prog_cc_cross=${ac_cv_prog_cc_cross='no'} So I'm not sure why it thinks I'm cross-compiling. I'll tinker some more, but if anyone knows which setting is messed up, I'd appreciate knowing. Thanks, 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 10 days, processed 124,728,901 queries (137/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
RE: SQLDriverConnect
)-Original Message- )From: Jeff Tanner [mailto:[EMAIL PROTECTED]] )Sent: Monday, August 27, 2001 12:08 PM )To: '[EMAIL PROTECTED]' )Subject: SQLDriverConnect ) ) )If the connection string for SQLDriverConnect is DSN=foo, and DSN foo is )defined within the odbc.ini file, then connection succeeds. ) )However, if the connection string for SQLDriverConnect is )DRIVER={MySQL};SERVER=foo_host;USER=foo;PWD=bar;DATABASE=foo_db, )then error condition is returns with Specified driver could not be loaded, )SQLSTATE IM003 ) )What is wrong with my DRIVER value? ) This is nothing to do with the driver. The error is thrown by the ODBC Driver Manager. First check, whether the DRIVER={MySQL} or DRIVER={MySQL Driver} that is listed in the drivers tab of the ODBC DSN Administrator. I think, in the other way i.e. specifying DRIVER={MySQL Driver} should work fine. Let me know whether this solves your problem or not. Regards Venu -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Venu mailto:[EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Woodside, California USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Solaris 2.8 configure problem...
In article [EMAIL PROTECTED], [EMAIL PROTECTED] (Sinisa Milivojevic) writes: What can I do to fix/debug this problem? I'd this problem too (and I didn't note lines to be removed in the documentation). It turns out that there is in the configure script an assumption that the inability to produce a working executable implies that cross compilation is occurring. This is the case even if the executable fails because a library isn't where it is expected, or some such. For me, the problem disappeared when I gave configure precise instructions for some libraries, such as: -with-libwrap=/opt/tcp_wrappers/lib/libwrap.a -lnsl -lsocket This was on 3.23.40. - Andrew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Need Help Setting Up MySQL on Win98
Hello - I'm very new at this, so please pardon the very beginner questions... I'm attemtping to install MySQL to my local machine running Win98. The install seems to go alright, but when I try mysqld--standalone it gives me an error. Then I tried mysqld -standalone, which seemed to work. Then I entered, mysqladmin create testDB and I got the error message Can't connect to MySQL Server on 'localhost'. I tried telnetting to telnet localhost 3306 and got an error that it couldn't connect. Can anyone offer help? Thanks - Shawn [EMAIL PROTECTED] __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.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
Re: Is MySQL network dependent?
On Mon, Aug 27, 2001 at 02:40:51PM +0200, [EMAIL PROTECTED] wrote: I've installed MySQL on a Sun Ultra1 with Solaris 8 and it works fine. But as soon as I unplug the network cable none of the MySQL binaries seem to work any more. If I start MySQL is prints nothing and the process seems to hang. If I reconnect the cable and try starting MySQL again, everything runs smoothly. What if you '--skip-networking' when starting it? -- 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 10 days, processed 125,261,853 queries (137/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
Re: Need Help Setting Up MySQL on Win98
At 12:54 PM 8/27/01 -0700, you wrote: Hello - I'm very new at this, so please pardon the very beginner questions... I'm attemtping to install MySQL to my local machine running Win98. The install seems to go alright, but when I try mysqld--standalone it gives me an error. Then I tried mysqld -standalone, which seemed to work. Then I entered, mysqladmin create testDB and I got the error message Can't connect to MySQL Server on 'localhost'. I tried telnetting to telnet localhost 3306 and got an error that it couldn't connect. Can anyone offer help? Yeah, try double clicking on the winmysqladmin.exe icon. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Choosing between Databases.
At 11:10 AM -0700 8/27/01, Sheena Sidhu wrote: Hello, I am looking into choosing between Innodb and BDB. One thing about BDB which I am quoting from the official site : Berkeley DB does not support SQL queries. All access to data is through the Berkeley DB API. Developers must learn a new set of interfaces in order to work with Berkeley DB. Although the interfaces are fairly simple, they are non-standard. has me worried. When I looked into Innodb, I see not similar reference so can I assume that it supports SQL. Can someone please let me know if I am wrong here? Thanks in advance, Sheena. The MySQL server maps SQL statements onto the internals of the BDB or InnoDB table handlers. The BDB statement is probably more with reference to accessing it directly rather than through a SQL engine. -- 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: Choosing between Databases.
Hi Paul, Thanks for responding. I am not sure if I understand you fully here. SO you mean to say that BDB DOES support SQL, meaning that I send statements like 'Select * from user' to a BDB table from my C++ code? If that is possible, then great. If not, then kindly let me know if Innodb has the same issue? Regards, Sheena. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Monday, August 27, 2001 1:19 PM To: Sheena Sidhu; [EMAIL PROTECTED] Subject: Re: Choosing between Databases. At 11:10 AM -0700 8/27/01, Sheena Sidhu wrote: Hello, I am looking into choosing between Innodb and BDB. One thing about BDB which I am quoting from the official site : Berkeley DB does not support SQL queries. All access to data is through the Berkeley DB API. Developers must learn a new set of interfaces in order to work with Berkeley DB. Although the interfaces are fairly simple, they are non-standard. has me worried. When I looked into Innodb, I see not similar reference so can I assume that it supports SQL. Can someone please let me know if I am wrong here? Thanks in advance, Sheena. The MySQL server maps SQL statements onto the internals of the BDB or InnoDB table handlers. The BDB statement is probably more with reference to accessing it directly rather than through a SQL engine. -- 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: Choosing between Databases.
At 1:23 PM -0700 8/27/01, Sheena Sidhu wrote: Hi Paul, Thanks for responding. I am not sure if I understand you fully here. SO you mean to say that BDB DOES support SQL, meaning that I send statements like 'Select * from user' to a BDB table from my C++ code? If that is possible, then great. If not, then kindly let me know if Innodb has the same issue? You're not interacting directly with the BDB or InnoDB table handlers. You're interacting with the MySQL server. You send the server SQL statements, it performs the appropriate translation from SQL onto the operations supported by the table handlers. It doesn't matter whether the table handlers understand SQL as long as the MySQL server does -- which it does. You can easily convince yourself of this by writing a C++ program that talks to the MySQL server to manipulate a BDB table. Regards, Sheena. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Monday, August 27, 2001 1:19 PM To: Sheena Sidhu; [EMAIL PROTECTED] Subject: Re: Choosing between Databases. At 11:10 AM -0700 8/27/01, Sheena Sidhu wrote: Hello, I am looking into choosing between Innodb and BDB. One thing about BDB which I am quoting from the official site : Berkeley DB does not support SQL queries. All access to data is through the Berkeley DB API. Developers must learn a new set of interfaces in order to work with Berkeley DB. Although the interfaces are fairly simple, they are non-standard. has me worried. When I looked into Innodb, I see not similar reference so can I assume that it supports SQL. Can someone please let me know if I am wrong here? Thanks in advance, Sheena. The MySQL server maps SQL statements onto the internals of the BDB or InnoDB table handlers. The BDB statement is probably more with reference to accessing it directly rather than through a SQL engine. -- Paul DuBois, [EMAIL PROTECTED] -- 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: Choosing between Databases.
Hi Paul, Will not contest your claim at all since you must have tried it to make that claim. So if I agree with you, then don't you think that the statement which is posted earlier :Berkeley DB does not support SQL queries. All access to data is through the Berkeley DB API. is misleading esp. to a novice like me or is it that I misunderstood? -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Monday, August 27, 2001 1:38 PM To: Sheena Sidhu; Mysql (E-mail) Subject: RE: Choosing between Databases. At 1:23 PM -0700 8/27/01, Sheena Sidhu wrote: Hi Paul, Thanks for responding. I am not sure if I understand you fully here. SO you mean to say that BDB DOES support SQL, meaning that I send statements like 'Select * from user' to a BDB table from my C++ code? If that is possible, then great. If not, then kindly let me know if Innodb has the same issue? You're not interacting directly with the BDB or InnoDB table handlers. You're interacting with the MySQL server. You send the server SQL statements, it performs the appropriate translation from SQL onto the operations supported by the table handlers. It doesn't matter whether the table handlers understand SQL as long as the MySQL server does -- which it does. You can easily convince yourself of this by writing a C++ program that talks to the MySQL server to manipulate a BDB table. Regards, Sheena. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Monday, August 27, 2001 1:19 PM To: Sheena Sidhu; [EMAIL PROTECTED] Subject: Re: Choosing between Databases. At 11:10 AM -0700 8/27/01, Sheena Sidhu wrote: Hello, I am looking into choosing between Innodb and BDB. One thing about BDB which I am quoting from the official site : Berkeley DB does not support SQL queries. All access to data is through the Berkeley DB API. Developers must learn a new set of interfaces in order to work with Berkeley DB. Although the interfaces are fairly simple, they are non-standard. has me worried. When I looked into Innodb, I see not similar reference so can I assume that it supports SQL. Can someone please let me know if I am wrong here? Thanks in advance, Sheena. The MySQL server maps SQL statements onto the internals of the BDB or InnoDB table handlers. The BDB statement is probably more with reference to accessing it directly rather than through a SQL engine. -- Paul DuBois, [EMAIL PROTECTED] -- 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Choosing between Databases.
Hi Paul, Will not contest your claim at all since you must have tried it to make that claim. So if I agree with you, then don't you think that the statement which is posted earlier :Berkeley DB does not support SQL queries. All access to data is through the Berkeley DB API. is misleading esp. to a novice like me or is it that I misunderstood? BDB used directly without some kind of interface does not support SQL. The MySQL server is an interface to BDB. When you use BDB tables in MySQL, you're not interacting with BDB directly. You're making the mistake of interpreting a statement on the Berkeley DB Web site as though it was posted on the MySQL Web site. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Monday, August 27, 2001 1:38 PM To: Sheena Sidhu; Mysql (E-mail) Subject: RE: Choosing between Databases. At 1:23 PM -0700 8/27/01, Sheena Sidhu wrote: Hi Paul, Thanks for responding. I am not sure if I understand you fully here. SO you mean to say that BDB DOES support SQL, meaning that I send statements like 'Select * from user' to a BDB table from my C++ code? If that is possible, then great. If not, then kindly let me know if Innodb has the same issue? You're not interacting directly with the BDB or InnoDB table handlers. You're interacting with the MySQL server. You send the server SQL statements, it performs the appropriate translation from SQL onto the operations supported by the table handlers. It doesn't matter whether the table handlers understand SQL as long as the MySQL server does -- which it does. You can easily convince yourself of this by writing a C++ program that talks to the MySQL server to manipulate a BDB table. Regards, Sheena. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Monday, August 27, 2001 1:19 PM To: Sheena Sidhu; [EMAIL PROTECTED] Subject: Re: Choosing between Databases. At 11:10 AM -0700 8/27/01, Sheena Sidhu wrote: Hello, I am looking into choosing between Innodb and BDB. One thing about BDB which I am quoting from the official site : Berkeley DB does not support SQL queries. All access to data is through the Berkeley DB API. Developers must learn a new set of interfaces in order to work with Berkeley DB. Although the interfaces are fairly simple, they are non-standard. has me worried. When I looked into Innodb, I see not similar reference so can I assume that it supports SQL. Can someone please let me know if I am wrong here? Thanks in advance, Sheena. The MySQL server maps SQL statements onto the internals of the BDB or InnoDB table handlers. The BDB statement is probably more with reference to accessing it directly rather than through a SQL engine. -- Paul DuBois, [EMAIL PROTECTED] -- Paul DuBois, [EMAIL PROTECTED] -- 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
image data type
Hi there, I treat image data type as text, does anyone know how to insert an image into the table? Thanks Qingmin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
msg board with efficient threaded view design?
I was wondering if anyone could point me to a message board (perl or php) that has a very efficient database design to handle threaded views. I know that this is a difficult task under mysql and have seen the threads on recursive queries, but I'd like to find some real life examples rather than start completely from scratch. I'm currently using wwwthreads, but under under really high user loads it can get bogged down because of the number of queries it's making to get all the replies in the proper threaded order. I know UBB and vBulletin don't do threaded views. Has anyone seen one that handles threading reasonably efficiently? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Needed Please
On 26-Aug-2001 [EMAIL PROTECTED] wrote: Hi I need to set the max_allowed_packet to 16M. below is my 01mysql-server.sh file. I use DBI and I know that I have to start this before the DBI program and I did but if I use ./mysqld --help it shows that my max_allowed_packet is still 1M. Any help would be really great since I've been working on this all day :( case $1 in start) if [ -x /usr/local/bin/safe_mysqld ]; then /usr/local/bin/safe_mysqld --user=mysql --set-variable=max_allowed_packet=16M /dev/null echo -n ' mysqld' try it in your /etc/my.cnf: [mysqld] socket=/tmp/mysql.sock set-variable = max_allowed_packet=16M Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. (53kr33t w0rdz: sql table 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
Re: image data type
At 09:15 AM 8/28/01 +1200, you wrote: Hi there, I treat image data type as text, does anyone know how to insert an image into the table? the image data type is actually a BLOB, not text. Usually, it's more efficent to have the field be text, and just store the path to the image (C:\my\path\to\image.gif (Win32) or /home/user/path/to/image.gif (Unix)). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 and GPL license: questions and discussion
On 27 Aug 2001, Trond Eivind Glomsrød wrote: Neil Zanella [EMAIL PROTECTED] writes: 4. Are the Linux versions shipped with Red Hat 7 and 7.1 entirely distributed under the GPL? Yes. This appears to be true after noticing the following file under Red Hat 7.1: /usr/share/doc/mysql-3.23.36/COPYING I wonder whether the windows version of mysql is also distributed under the GNU GPL in full or whether it is only distributed under the GPL in part. Thanks, 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
MySQL+InnoDB
hi i'm trying to setup mysql w/ InnoDB i followed all steps from http://www.mysql.com/doc/I/n/InnoDB_start.html and i'm end up with this in my log every time i run mysql and in addition it ends here is log file from first time i run mysql 010827 17:07:07 mysqld started InnoDB: The first specified data file /usr/local/mysql/var/innodb/data/ibdata/ibdata1 did not exist: InnoDB: a new database to be created! InnoDB: Setting file /usr/local/mysql/var/innodb/data/ibdata/ibdata1 size to 2097152000 InnoDB: Database physically writes the file full: wait... InnoDB: Data file /usr/local/mysql/var/innodb/data/ibdata/ibdata2 did not exist: new to be created InnoDB: Setting file /usr/local/mysql/var/innodb/data/ibdata/ibdata2 size to 2097152000 InnoDB: Database physically writes the file full: wait... InnoDB: Error: all log files must be created at the same time. InnoDB: If you want bigger or smaller log files, InnoDB: shut down the database and make sure there InnoDB: were no errors in shutdown. InnoDB: Then delete the existing log files. Edit the .cnf file InnoDB: and start the database again. 010827 17:11:13 Can't init databases 010827 17:11:13 mysqld ended any ideas? thank you in advance - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Need Help Setting Up MySQL on Win98
Try putting a space between mysqld and --standalone (mysqld --standalone) - Original Message - From: S K Bryan [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Monday, August 27, 2001 2:54 PM Subject: Need Help Setting Up MySQL on Win98 Hello - I'm very new at this, so please pardon the very beginner questions... I'm attemtping to install MySQL to my local machine running Win98. The install seems to go alright, but when I try mysqld--standalone it gives me an error. Then I tried mysqld -standalone, which seemed to work. Then I entered, mysqladmin create testDB and I got the error message Can't connect to MySQL Server on 'localhost'. I tried telnetting to telnet localhost 3306 and got an error that it couldn't connect. Can anyone offer help? Thanks - Shawn [EMAIL PROTECTED] __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Select in groups of 5
Hello everyone, Is there any way to make selections in groups of 5. I want to get 5 record sets at a time until we get to a point that there's 4 or less records. Thank you everyone, Tyler database,sql,query,table - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Select in groups of 5
Select * from yourTable limit 0,5 gets you the first 5. After that: Select * from yourTable limit 5,5 gets you the next five...etc. Cal http://www.calevans.com -Original Message- From: Tyler Longrne [mailto:[EMAIL PROTECTED]] Sent: Monday, August 27, 2001 6:33 PM To: MySQL List Subject: Select in groups of 5 Hello everyone, Is there any way to make selections in groups of 5. I want to get 5 record sets at a time until we get to a point that there's 4 or less records. Thank you everyone, Tyler database,sql,query,table - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL+InnoDB
Yes. delete all ib_ files and all data files specified in my.cnf... and then run mysql again. ryan - Original Message - From: alexus [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 27, 2001 5:16 PM Subject: MySQL+InnoDB hi i'm trying to setup mysql w/ InnoDB i followed all steps from http://www.mysql.com/doc/I/n/InnoDB_start.html and i'm end up with this in my log every time i run mysql and in addition it ends here is log file from first time i run mysql 010827 17:07:07 mysqld started InnoDB: The first specified data file /usr/local/mysql/var/innodb/data/ibdata/ibdata1 did not exist: InnoDB: a new database to be created! InnoDB: Setting file /usr/local/mysql/var/innodb/data/ibdata/ibdata1 size to 2097152000 InnoDB: Database physically writes the file full: wait... InnoDB: Data file /usr/local/mysql/var/innodb/data/ibdata/ibdata2 did not exist: new to be created InnoDB: Setting file /usr/local/mysql/var/innodb/data/ibdata/ibdata2 size to 2097152000 InnoDB: Database physically writes the file full: wait... InnoDB: Error: all log files must be created at the same time. InnoDB: If you want bigger or smaller log files, InnoDB: shut down the database and make sure there InnoDB: were no errors in shutdown. InnoDB: Then delete the existing log files. Edit the .cnf file InnoDB: and start the database again. 010827 17:11:13 Can't init databases 010827 17:11:13 mysqld ended any ideas? thank you in advance - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Question on Table types and EJB persistance
Hi all, I know this might be slightly off topics. I was trying to make JBoss/MM-MySQL_JDBC/MySQL to work together. However, I found the following problem. With MyISAM type, the container-managed persists ok; but, with INNODB type, JBoss doesn't able to persist the data back to the Innodb table. I wonder if anybody have experience similar scenario and would kindly share some thoughts on this. Best regards, Michael - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
sorting this egroup
Maybe I overlooking the obvious here, but hey it won't be the first time. How does everyone sort this group in their email client? I have yet to find a way to manage these emails because of the lack of a consistent item in each email. i.e MySql in the subject line etc Suggestions? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL+InnoDB
i deleted everything and re-run again and it started fine now.. weird.. - Original Message - From: ryc [EMAIL PROTECTED] To: alexus [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, August 27, 2001 7:56 PM Subject: Re: MySQL+InnoDB Yes. delete all ib_ files and all data files specified in my.cnf... and then run mysql again. ryan - Original Message - From: alexus [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 27, 2001 5:16 PM Subject: MySQL+InnoDB hi i'm trying to setup mysql w/ InnoDB i followed all steps from http://www.mysql.com/doc/I/n/InnoDB_start.html and i'm end up with this in my log every time i run mysql and in addition it ends here is log file from first time i run mysql 010827 17:07:07 mysqld started InnoDB: The first specified data file /usr/local/mysql/var/innodb/data/ibdata/ibdata1 did not exist: InnoDB: a new database to be created! InnoDB: Setting file /usr/local/mysql/var/innodb/data/ibdata/ibdata1 size to 2097152000 InnoDB: Database physically writes the file full: wait... InnoDB: Data file /usr/local/mysql/var/innodb/data/ibdata/ibdata2 did not exist: new to be created InnoDB: Setting file /usr/local/mysql/var/innodb/data/ibdata/ibdata2 size to 2097152000 InnoDB: Database physically writes the file full: wait... InnoDB: Error: all log files must be created at the same time. InnoDB: If you want bigger or smaller log files, InnoDB: shut down the database and make sure there InnoDB: were no errors in shutdown. InnoDB: Then delete the existing log files. Edit the .cnf file InnoDB: and start the database again. 010827 17:11:13 Can't init databases 010827 17:11:13 mysqld ended any ideas? thank you in advance - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: sorting this egroup
I just use the [EMAIL PROTECTED] in the To field of the email. Works like a charm. --Daniel Von Fange -Original Message- From: Glyndower [mailto:[EMAIL PROTECTED]] Sent: Monday, August 27, 2001 8:56 PM To: George Pitcher; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: sorting this egroup Maybe I overlooking the obvious here, but hey it won't be the first time. How does everyone sort this group in their email client? I have yet to find a way to manage these emails because of the lack of a consistent item in each email. i.e MySql in the subject line etc Suggestions? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: sorting this egroup
Every mail on this list has the following header: List-ID: mysql.mysql.com I use maildrop with the following filter: if ( /^List-ID\: \mysql\.mysql\.com\/) { to Maildir/.mysql } hope this helps, dpk - Original Message - From: Glyndower [EMAIL PROTECTED] To: George Pitcher [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, August 27, 2001 5:55 PM Subject: sorting this egroup Maybe I overlooking the obvious here, but hey it won't be the first time. How does everyone sort this group in their email client? I have yet to find a way to manage these emails because of the lack of a consistent item in each email. i.e MySql in the subject line etc Suggestions? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php