Re: Can someone help explain this
On Tue, Mar 13, 2001 at 08:03:09PM -0800, Bob Silva wrote: Heres the query Im trying to run: takes about 2 minutes...both userid and usernum columns have indexes...usernum is unique. Show keys follows. mysql explain SELECT usernum FROM client WHERE userid='Salty3' OR usernum = 4158774796; ++--+---+--+-+--+-++ | table | type | possible_keys | key | key_len | ref | rows| Extra | ++--+---+--+-+--+-++ | client | ALL | PRIMARY,useridIDX | NULL |NULL | NULL | 1586803 | where used | ++--+---+--+-+--+-++ 1 row in set (0.04 sec) Why is this doing a full table scan when I have provided 2 keys to search on? MySQL doesn't optimize WHERE clauses with OR's in them (at least not as good as it optimizes queries without them). See also: http://www.mysql.com/doc/S/e/Searching_on_two_keys.html ... Heres the time it took to run the query...we have about 1.6 million records in this table...it would make sense to me it would be able to use either key successively...but then again I didnt develop mysql so thats why Im here. Yes, it would need to use the indexes successively AND take care to use records only once if they exist in both indexes. Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Hi, a question about mysql and servlets
Hello everyboy, nice to post you. I hope this question not to be very frequent but i'm new in this list. I'd like to know if anybody knows how to connect a servlet with MySQL. It doesn't matter if it is by a ODBC:JDBC bridge o a 100% JDBC Driver. I can download the drivers. I want to know the steps and the string connection to use. If you are so so so so kind and the driver u use is not big , plese post it. Thank's from a new MySQL user. Francisco Glvez Martnez [EMAIL PROTECTED] [EMAIL PROTECTED] --- Chatea con Isabel Pisano. Actriz , periodista y escritora. El martes da 13 de Marzo a las 20:00 en http://www.eresmas.com/encuentros - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Very (excruciatingly) slow select
Hi List, I'm new to the list and I have a BrainTeaser for all of you. I have yet lots to learn about sql and mySQL so any suggestions are very welcome! Thanx in advance Hannes I have following select over a Database that I cannot setup myself, but have to take on as is: SELECT COMP.CompKey, COMP.NameLong, COMP.Internet, COMP.EMAIL, ACCOMP.Phar, ACCOMP.CompKey, ACCOMP.Role, AC.Phar, AC.IKSCat, AC.GenericCode, AC.InsCode, AC.GrdFrCode, AC.WWW, AC.NumOfPce, AC.SaleCode, ACMED.Phar, ACMED.ATCKey, ACMED.FormCode, ACNAM.Phar, ACNAM.LangCode, ACNAM.Name50, ACSC.Phar, ACSC.StoLNr, ACSC.StoKeyG, ACSC.Quantity, ACSC.QuantityUnit, ACSC.CodeWHK, SC.StoKeyG, SC.StoName, ACPRICEALG.Phar, ACPRICEALG.PriceType, ACPRICEALG.Price, CODES.CodeType, CODES.CodeValue, CODES.LangCode, CODES.CodeDesc AS GalenicForm, CLASS.CodeType, CLASS.CodeValue, CLASS.LangCode, CLASS.CodeDesc AS ATCClass FROM AC, ACMED, ACNAM, ACCOMP, COMP, ACSC, SC, ACPRICEALG, CODES, CODES AS CLASS WHERE COMP.NameLong LIKE 'Here Come the SearchTerms%' ANDACCOMP.CompKey=COMP.CompKey ANDACCOMP.Role='H' ANDAC.Phar=ACCOMP.Phar ANDAC.SaleCode!='H' ANDACMED.Phar=ACCOMP.Phar AND ACNAM.Phar=ACCOMP.Phar ANDACNAM.LangCode='D' ANDACSC.Phar=ACCOMP.Phar AND ACSC.CodeWHK='W' ANDSC.StoKeyG=ACSC.StoKeyG ANDACPRICEALG.Phar=ACMED.Phar AND ACPRICEALG.PriceType='PPUB' ANDCODES.CodeType=5 AND CODES.CodeValue=ACMED.FormCode ANDCODES.LangCode='D' ANDCLASS.CodeType=3 AND CLASS.CodeValue=ACMED.ATCKey ANDCLASS.LangCode='D' ORDER BY ACMED.ATCKey, ACPRICEALG.Price, ACMED.Phar, ACSC.StoLNr EXPLAIN says: +-Table--+-Type---+-Possible Keys---+-Key--+-Key-len---+-References---+-Rows---+-Extra---+ +++-+--+---+--++-+ | COMP | range | PRIMARY,| NameLong | | | 1 | | ||| NameLong| | | || | +++-+--+---+--++-+ | CLASS | ref| PRIMARY | PRIMARY | 4 | ??? | 159 | where used | +++-+--+---+--++-+ | SC | ALL| PRIMARY | | | | 6710 | | +++-+--+---+--++-+ | ACSC | ref| PRIMARY,Phar, | StoKeyG | 5 | SC.StoKeyG, | 14 | | ||| StoKeyG | | | W|| | +++-+--+---+--++-+ | ACCOMP | eq_ref | PRIMARY,CompKey | PRIMARY | 9 | ACSC.Phar, | 1 | where used | ||| | | | COMP.CompKey,|| | ||| | | | H|| | +++-+--+---+--++-+ | AC | eq_ref | PRIMARY | PRIMARY | 4 | ACCOMP.Phar | 1 | where used | +++-+--+---+--++-+ | ACNAM | eq_ref | PRIMARY | PRIMARY | 5 | ACCOMP.Phar, | 1 | where used | ||| | | | D|| | +++-+--+---+--++-+ | ACMED | eq_ref | PRIMARY,ATCKey | PRIMARY | 4 | ACCOMP.Phar | 1 | where used | +++-+--+---+--++-+ | CODES | range | PRIMARY | PRIMARY | | | 178 | | +++-+--+---+--++-+ | ACPRICEALG | eq_ref | PRIMARY | PRIMARY | 8 | ACMED.Phar, | 1 | where used | ||| | | | PPUB || | +++-+--+---+--++-+ That did not look too bad to me, but still the query takes so long to execute, the client-browser times out. So far I'm not even sure I'll get results, apart from the fact that I don't get a Syntax Error... Table Sizes: table Records AC
Re: apostrophe ....
tx Rolf! Yes, indeed. by default, on the newest releases of the php.ini file, magic_quotes_gpc is turned off. Of course one can switch it on/off running single scripts. The ini file in fact mentions in the introduction that is has changed. but.. why does php change default parameters, especially when releasing minor upgrades/patch levels. This stuff can take loads of time from the programmer, just by changing platform version from v4.01 to 4.04pl1 regards, rene - Original Message - From: "Rolf Hopkins" [EMAIL PROTECTED] To: "Ren Tegel" [EMAIL PROTECTED]; "Eric Fitzgerald" [EMAIL PROTECTED]; "Randy Johnson" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, March 14, 2001 1:27 AM Subject: Re: apostrophe Or you can fix your php by turning off the magic_quotes_gpc flag. You then won't need to change your code. Check out http://www.php.net/manual/en/configuration.php on how to do this. I have provided an example on how to do this with apache running on a linux machine. - Original Message - From: "Ren Tegel" [EMAIL PROTECTED] To: "Eric Fitzgerald" [EMAIL PROTECTED]; "Randy Johnson" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, March 14, 2001 2:56 Subject: Re: apostrophe this was true on php 4.01 but not on php 4.04pl1, i have to escape my strings again. or it's some switch or conf setting i never seen/heard/thought of... i now use $var=addslashes($var) on php4.0.4pl1 redhat 7 where i do not have to on a other system running php4.0.1 redhat 6.2 ! especially php seems to have loads of undocumented - and worse, changing, behaviour. regards, rene - Original Message - From: "Eric Fitzgerald" [EMAIL PROTECTED] To: "Randy Johnson" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, March 13, 2001 7:15 PM Subject: Re: apostrophe Two things here. First off, we had this problem spring up on us, and I think I may know why it's doing it to you. If your using PHP, the more recent version automatically escape out variables sent to the mysql driver. Thus randy's is converted to randy's. HOWEVER, if you still have old code where you ran things through addslashes, it turns out like to look like randy\\\'s. Which ends up being stored as randy\'s. To correct this, first fix your code, then run the following query: UPDATE table SET fieldname = REPLACE(fieldname,'\\',''); - Original Message - From: "Randy Johnson" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 13, 2001 9:54 AM Subject: apostrophe When a text with an apostrophe in it has a \' in it. How can I fix this? example randy's is stored in the DB as randy\'s thanks Randy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Communication Errors
Hi ! I've just upgraded to the new mysql server 3.23.32 and in the log I now see 'Aborted connection ... (Got an error reading communication packets)'. I have found information about this problem such as using the binary release instead of the source release. I have now done this and it still appears in the log, the last thing it suggested was to check the patch level of Solaris. I am running on a Sun Solaris 2.7 machine, does anybody know what the recommended patch level is to stop this problem happening ? Thanks. Regards, Marvin Wright. his message has been checked for all known viruses by MessageLabs. This message is intended for the stated recipients only and may be confidential. Opinions expressed in this email do not necessarily reflect the opinions of GlobePost Travel or Travelselect.com. If you are not the intended recipient of this message, please notify the sender immediately.
Erratic behaviour of binary varchar fields
Description. The bug is about selecting binary varchar fields and consists in erratic behaviour of these fields in combination with OR. When executing a SELECT statement with an ORed WHERE-clause such that the two basic clauses each select a differently cased variant of one (binary varchar) term, only the first is returned, although both are in the table. The funny thing is that this only holds when you have *two* clauses with one OR. With more ORs, the bug disappears. Concretely: screenshot mysql desc terms; +-+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +-+-+--+-+-+---+ | term| varchar(200) binary | | PRI | | | | corpus_id | decimal(15,0) | | PRI | 0 | | | frequency | decimal(15,0) | | | 0 | | | weight | float | YES | | NULL| | | n_documents | decimal(15,0) | | | 0 | | +-+-+--+-+-+---+ 5 rows in set (0.00 sec) mysql select * from terms where term = 'bank' OR term = 'Bank'; +--+---+---++-+ | term | corpus_id | frequency | weight | n_documents | +--+---+---++-+ | bank | 2 | 128 | NULL | 75 | +--+---+---++-+ 1 row in set (0.00 sec) mysql select * from terms where term = 'Bank' OR term = 'bank'; +--+---+---++-+ | term | corpus_id | frequency | weight | n_documents | +--+---+---++-+ | Bank | 2 | 176 | NULL | 99 | +--+---+---++-+ 1 row in set (0.01 sec) mysql select * from terms where term = 'bank' OR term = 'Bank' OR term = 'banks' or term = 'Banks'; +---+---+---++-+ | term | corpus_id | frequency | weight | n_documents | +---+---+---++-+ | Bank | 2 | 176 | NULL | 99 | | Banks | 2 |18 | NULL | 11 | | bank | 2 | 128 | NULL | 75 | | banks | 2 | 176 | NULL | 66 | +---+---+---++-+ 4 rows in set (0.00 sec) mysql \screenshot (The client on a WinNT machine (mysql Ver 9.37 Distrib 3.22.29, for Win95/Win98 (i586))). Submitter ID: Jan Voskuil Organization: SmartHaven, www.smarthaven.com MySql support: none Synopsis: Binary varchar fields behave erratically under ORed select-clauses with respect to casing. Release: mysql-3.23.32 (Source distribution) Environment: Linux Redhat 7 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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[2]: Innobase in MySQL
Hello Dan, Tuesday, March 13, 2001, 6:37:16 PM, you wrote: DN In the last episode (Mar 13), Peter Zaitsev said: Well guys mysqldump have one serious problem - the speed. The backup speed is quite upsetting and loads system much, but the worst thing is recovery speed. In my case the data is added in realtime - most queries are inserts which utilize system quite hard. So to recover data I have gathered for a month it will take about 1 week to feed mysql with mysqldump output, even with extended inserts. So at least this is not complete solution. DN Make sure you remove all your indexes during the load; that can really DN slow down inserts. Well I tried to do so but still it takes an amount of time to add the indexes... I think the good Idea would be to add to mysqldump an option to create the table without index, then insert all data indeed and then add keys required. This would be a good point in --opt mode or in other option :) -- Best regards, Petermailto:[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
connection lost on long-distance connection
I've ran into some problems when connecting to a mysql server over a long-distance connection (i.e.: the internet). The first time a client reconnects from a idle connection this reconnect fails, only the second time it succeeds. The main problem is that i've written a win32 app that connects to this server. Normally the client and server will be on a LAN but i test the program on a their database from my place. I use libmysql.dll for this. (no odbc!) Normally i relied on libmysql.dll to reconnect when a connection was lost, on a lan this never gave any problem but now it does, giving my app no result set on a particulair query after been idle for a while, and thus introducing bugs. I am able to reproduce this with the standard mysql client. Both the win32 and the linux client behave the same. Tech info: server running mysql 3.23.32 win32 binary distribution Client app is behind a firewall, MySQL server is directly connected to the internet. Telnet or other sessions normally remain alive through my firewall. ping trip-around time: about 200ms, however sometimes loads of packet loss (possible cause?) Just after a connection everything is fine: mysql show processlist; +-+---++--+-+--+---+ --+ | Id | User | Host | db | Command | Time | State | Info | +-+---++--+-+--+---+ --+ | 429 | admin | cx.upc-c.chello.nl | NULL | Query | 0| NULL | show processlist | +-+---++--+-+--+---+ --+ 1 row in set (0.21 sec) Then if a leave the client for a while (say: ten minutes) the connection is gone: mysql show processlist; ERROR 2013: Lost connection to MySQL server during query mysql show processlist; ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id:430 Current database: *** NONE *** +-+---++--+-+--+---+ --+ | Id | User | Host | db | Command | Time | State | Info | +-+---++--+-+--+---+ --+ | 429 | admin | cx.upc-c.chello.nl | NULL | Sleep | 2732 | | NULL | | 430 | admin | cx.upc-c.chello.nl | NULL | Query | 0| NULL | show processlist | +-+---++--+-+--+---+ --+ 2 rows in set (5.99 sec) So, the server still thinks i've got an active connection. this list keeps on growing. For as far as I can see, my win32 app behaves the same as the mysql client. It'll try to reconnect but it fails, only second time it succesfully reconnects. I ported my app from interbase to mysql. with interbase i did not have this connection problem, but it's so terribly slow on many queries/ larger result sets (interbase fetches a result field by field, generating numerous network packets...) I also have some PHP scripts that connect to this server, running in win32 cgi mode. They do behave normally, i guess because they have to connect every time (i.e.: no persistant connections for win32 w/o isapi) they are called. When not idle (i.e. active querying) everything behaves normal and i notice no errors at all, not even on heavy load. Any ideas / solution would be really appreciated thanx in advance, rene - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
setting simple mysqld options in /etc/my.cnf
Hi, I like to run mysqld with these 3 options: --log-slow-queries --delay-key-write-for-all-tables --skip-networking But, so far, I've been unable to get mysqld to read them out of /etc/my.cnf. Here's what's inside my /etc/my.cnf: [mysql.server] log-slow-queries delay-key-write-for-all-tables skip-networking Am I doing this wrong? I looked, but I didn't find any documentation of how to format simple options like this in /etc/my.cnf. ...or perhaps, I have them under the wrong header (is "mysql.server" correct?) ...or perhaps I just can't set these options in /etc/my.cnf. Currently, I set them by editing the mysql start script, adding them to the safe_mysqld line. Any help would be appreciated. -bill - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 simple mysqld options in /etc/my.cnf
you chowned mysql.cnf to owner/group mysql ? - Original Message - From: "Bill Marrs" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 14, 2001 1:16 PM Subject: setting simple mysqld options in /etc/my.cnf Hi, I like to run mysqld with these 3 options: --log-slow-queries --delay-key-write-for-all-tables --skip-networking But, so far, I've been unable to get mysqld to read them out of /etc/my.cnf. Here's what's inside my /etc/my.cnf: [mysql.server] log-slow-queries delay-key-write-for-all-tables skip-networking Am I doing this wrong? I looked, but I didn't find any documentation of how to format simple options like this in /etc/my.cnf. ...or perhaps, I have them under the wrong header (is "mysql.server" correct?) ...or perhaps I just can't set these options in /etc/my.cnf. Currently, I set them by editing the mysql start script, adding them to the safe_mysqld line. Any help would be appreciated. -bill - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 simple mysqld options in /etc/my.cnf
At 01:23 PM 3/14/2001 +0100, Ren Tegel wrote: you chowned mysql.cnf to owner/group mysql ? I hadn't, but mysql is reading some other options properly from my /etc/my.cnf file. Actually, I did some more searching and I found this command: /usr/libexec/mysqld --print-defaults It seems to show the options that will be used and it is picking up my options if I put them under [mysqld]. What was confusing me is that the ps output for safe_mysqld was not mentioning the options, but it wouldn't have to. I guess I just wanted some feedback that my options were being used and the above provides that. So, my solution is, these lines in /etc/my.cnf: [mysqld] skip-networking myisam-recover=BACKUP,FORCE log-slow-queries=/var/lib/mysql/home-slow.log delay-key-write-for-all-tables and use: /usr/libexec/mysqld --print-defaults to check if they being set properly... my output looks like: /usr/libexec/mysqld would have been started with the following arguments: --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --skip-networking --myisam-recover=BACKUP,FORCE --log-slow-queries=/var/lib/mysql/home-slow.log --delay-key-write-for-all-tables Thanks, -bill - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Importing ACCESS into MYSQL
Hi Does anybody know how to import MDB's into MYSql. Thanks Javier
use one database or many databases
Hello, I have to design a huge database for all the universities , is it better to consider a database for each university or one for all universities .. If I consider one database so I'll have one table for all students wich contain about 30 rows . thank you __ Get your free domain name and domain-based e-mail from Namezero.com New! Namezero Plus domains now available. Find out more at: http://www.namezero.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: Importing ACCESS into MYSQL
Dear Colleague, Easily, install myODBC on your Windows PC, then export table to the ODBC source. To do this, in the Access DB window, select the table you want to export, right-click on it, select save/export, choose the ODBC source. Table is created automatically in mysql, values are exported. Cheers, Pieter -Original Message- From: Javier Garcia [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 14, 2001 2:54 PM To: [EMAIL PROTECTED] Subject: Importing ACCESS into MYSQL Hi Does anybody know how to import MDB's into MYSql. Thanks Javier
Re: Membership management
Hi I'm newbie but see a PHP GuestBook in PHPBuilder.com Bye javier Dear All, Can someone recommend a PHP/MySQL script for managing membership forms using PHP and MySQL? I need something like a dbmanager which was available by Selena, but it was in perl with flat text database. Individual data is viewed only by the person having his own ID, He is not allowed to view any other members information. Nor can he modify his own data. Data modification is done only by system admin. If any of you come across such a script do mail me or the list. Thanks Love and regards Prasad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
use one database or many databases
Hello, I have to design a huge database for all the universities , is it better to consider a database for each university or one for all universities .. If I consider one database so I'll have one table for all students wich contain about 30 rows . thank you __ Get your free domain name and domain-based e-mail from Namezero.com New! Namezero Plus domains now available. Find out more at: http://www.namezero.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
AW: Importing ACCESS into MYSQL
Hi, you have to create an exportfile with ACCESS separated with colons for example. Then import this textfile in your mysql-database. It looks like this: LOAD DATA LOCAL INFILE "C:\\name_of_your_file.txt" INTO TABLE name_of_your_table FIELDS TERMINATED BY 'your_separator for example ,' ENCLOSED BY '"' (name of the table fields); Hope that helps! Patrick -Ursprngliche Nachricht- Von: Javier Garcia [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 14. Mrz 2001 14:54 An: [EMAIL PROTECTED] Betreff: Importing ACCESS into MYSQL Hi Does anybody know how to import MDB's into MYSql. Thanks Javier - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: BDB table corruption when inserting/retrieving a BLOB into a BDB table
We had similar problems with version 3.23.33. For us, the fix was to move the errant tables to MyISAM. We did not need transaction support for those tables. We have since moved the tables back to BDB with MySQL version 3.23.34a. The problem seems to have been resolved in this latest update. Cedric. -Original Message- From: Scott McCool [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 3:29 PM To: 'Stephen Faustino'; '[EMAIL PROTECTED]' Subject: RE: BDB table corruption when inserting/retrieving a BLOB into a BDB table I can also verify that the data seems to be stored properly (from mysql's command line tool). The problem seems most likely to occur with larger text strings Anyone else? -Scott -Original Message- From: Stephen Faustino [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 2:51 PM To: '[EMAIL PROTECTED]' Subject: RE: BDB table corruption when inserting/retrieving a BLOB into a BDB table We have also experienced the same exact behavior, also using the mm.mysql driver, on Linux. However, our problem is intermittent. There are times (though these times cannot be accurately predicted) where the data is retrieved correctly, which implies that the data is stored correclty. We have verified that the data is being stored correctly by using mysql to select the data into a dumpfile. We did not try to recreate the problem with a table handler other than BDB. Stephen L. Faustino Senior Software Engineer SecureLogix Corporation Direct/Vmail (210)402-9669x949 mailto:[EMAIL PROTECTED] This email is intended for the named recipient(s) only and may contain information that is privileged and/or confidential. Nothing in this email is intended to constitute a waiver of any privilege or the confidentiality of this message. If you have received this email in error, please notify me immediately by reply and delete this message. -Original Message- From: Scott McCool [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 1:01 PM To: '[EMAIL PROTECTED]' Subject: BDB table corruption when inserting/retrieving a BLOB into a BDB table I'm getting a very strange results all of the sudden when dealing with BLOBs in a mysql 3.23.32 on a Solaris 7 (SPARC) machine (inserts/deletes handled with the JDBC driver from http://mmmysql.sourceforge.net/) If I do the following: 1) Create a BDB table with a blob column: CREATE TABLE test4( id INTEGER not null PRIMARY KEY, ablob BLOB null ) TYPE=BDB; 2) Insert a particular blob into that column (I'm storing XSLT stylesheets in the real table, most of them work fine but one in particular is all of the sudden causing problems): ---code snip--- String fn="badblob.txt";// Filename of the blob I'm loading that causes problems FileInputStream style_fis=new FileInputStream(fn); byte[] style_bytes=new byte[style_fis.available()]; style_fis.read(style_bytes); String dQuery="delete from ttest4"; String iQuery="insert into ttest4(id,ablob) values(1,null);"; conn=cp.getConnection();// Gets a JDBC connection from a pool I keep elsewhere Statement stmt=conn.createStatement(); stmt.executeUpdate(dQuery); stmt.executeUpdate(iQuery); stmt.close(); String uQuery="update test4 set ablob=? where id=1"; pstmt=conn.prepareStatement(uQuery); pstmt.setBytes(1,style_bytes); pstmt.execute(); pstmt.close(); cp.releaseConnection(conn); ---end code snip--- (I've modified this some, but basically my code will insert an empty row then update it with the blob, this is to deal with some issues we've had with other RDBMs' implementations of JDBC). This seems to go just fine. 3) Retrieve that blob with the following code: --code snip-- conn=cp.getConnection(); Statement stmt=conn.createStatement(); String query="select ablob from ttest4 where id=1"; ResultSet rs=stmt.executeQuery(query); while(rs.next()) { Blob b=rs.getBlob(1); byte[] blobBytes=b.getBytes(0,(int)b.length()); System.out.println(new String(b)); } --end code snip-- At this point my output ends up very garbled. The output usually starts off with some very strange ASCII characters (seemingly binary data) with things like filesystem names thrown in the mix... Then at some point parts of my actual data (from the "badblob.txt" file in step 2) appears... Then the end of it is usually overwritten with more strange ASCII characters. In attempting to fix this problem, I dropped and recreated the entire database a few times, restarted the server daemon, etc. I finally ended up changing the table to TYPE=MyISAM and the problem went away. Unfortunately, I need transaction support for this project. I've been using this code, data, server version, bdb table, etc for a few weeks now with no problems, but suddenly when regenerating the schema last night this started to occur and is now happening regularly. I'd like to blame this on the particular blob I'm
Compile failing
Hi, Can anyone shed any light on this? I'm trying to build mySQL V3.23.34a on Tru64 V4.0G using gcc2.95.2 and GNU Make version 3.79.1. The makefiles were created using ./configure --prefix=/nipweb/mysql. No other configure paramaters were used. The compile keeps failing with the following error(s): gmake[2]: Leaving directory `/tmp_mnt/home/perrinm/mysql-3.23.34a/libmysql' Making all in client gmake[2]: Entering directory `/tmp_mnt/home/perrinm/mysql-3.23.34a/client' c++ -DUNDEF_THREADS_HACK -I./../include -I../include -I./.. -I..-I..-O3 -DDBUG_OFF -fno-implicit-templates -c mysql.cc In file included from ../include/global.h:186, from mysql.cc:28: /usr/include/alloca.h:68: warning: declaration of `void * alloca(int)' /usr/include/alloca.h:68: warning: conflicts with built-in declaration `void * alloca(long unsigned int)' c++ -DUNDEF_THREADS_HACK -I./../include -I../include -I./.. -I..-I..-O3 -DDBUG_OFF -fno-implicit-templates -c readline.cc In file included from ../include/global.h:186, from readline.cc:20: /usr/include/alloca.h:68: warning: declaration of `void * alloca(int)' /usr/include/alloca.h:68: warning: conflicts with built-in declaration `void * alloca(long unsigned int)' c++ -DUNDEF_THREADS_HACK -I./../include -I../include -I./.. -I..-I..-O3 -DDBUG_OFF -fno-implicit-templates -c sql_string.cc In file included from ../include/global.h:186, from sql_string.cc:24: /usr/include/alloca.h:68: warning: declaration of `void * alloca(int)' /usr/include/alloca.h:68: warning: conflicts with built-in declaration `void * alloca(long unsigned int)' sql_string.cc: In method `bool String::set(double, unsigned int = 2)': sql_string.cc:181: implicit declaration of function `int snprintf(...)' gmake[2]: *** [sql_string.o] Error 1 gmake[2]: Leaving directory `/tmp_mnt/home/perrinm/mysql-3.23.34a/client' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/tmp_mnt/home/perrinm/mysql-3.23.34a' gmake: *** [all-recursive-am] Error 2 I haven't got a clue what's happening, maybe someone else does. Thanks, Martyn Perring -- -- Martyn Perring System Administrator, NIP Environment Support Team MLB4/5, Desk 265 BT Advanced Communications Technology Centre, Adastral Park, Martlesham Heath, Ipswich,Tel: (01473-)608334 Suffolk, IP5 3REBTNet: *00 160 8334 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: use one database or many databases
If all the data will be used by the same application then I would suggest that you stick with a single database. Cal http://www.calevans.com -Original Message- From: abdelhamid bettache [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 14, 2001 8:11 AM To: [EMAIL PROTECTED] Subject: use one database or many databases Hello, I have to design a huge database for all the universities , is it better to consider a database for each university or one for all universities .. If I consider one database so I'll have one table for all students wich contain about 30 rows . thank you __ Get your free domain name and domain-based e-mail from Namezero.com New! Namezero Plus domains now available. Find out more at: http://www.namezero.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
Trouble automating backup
Hi, I'm trying to write a Perl script that will automate the backing up of the tables in my database. I'm building an array of the tables in the database, using show tables, and then I step through the array with a foreach loop. I've setup the SQL statement (to do the backup) as follows: $sth_backup = $dbh-prepare("BACKUP table ? TO ?"); And I'm calling it like this: $sth_backup-execute($table_name, $backup_location) || warn "Cant backup table $table_name: $DBI::errstr"; I've tried various values for $backup_location, but I can't seem to get it to work. When I use 'c:/' I get this: DBD::mysql::st execute failed: You have an error in your SQL syntax near ''iteration_failure' TO 'c:/'' at line 1 at backup_tables.pm line 24 When I use 'c:\' I get this: Bareword found where operator expected at backup_tables.pm line 18, near "$sth_tables-execute () || die "Can't" (Might be a runaway multi-line '' string starting on line 11)(Missing operator before t?) String found where operator expected at backup_tables.pm line 25, near "|| warn "" (Might be a runaway multi-line "" string starting on line 18) (Missing semicolon on previous line?) Anyone have any thoughts on what I need to do to get this to work? Thanks in advance, C. Duncan Hudson Dynax Solutions, Inc. Tel 216.292.8203 FAX 216.292.8273 EMail [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: error 127
Run isamchk on your tables. mohamed Abd El-Samei Mohamed wrote: Dear all i need help i have mysql-3.22.26a over unix solairs 7 when i try to apply query from the console to retrieve some information i got that error ERROR 1030: Got error 127 from table handler please help .. Thanks Sorry for bad english! -- Name : Mohamed Abd El-Samei Mohamed Company : Soficom Communications S.A.E Titel : System Administrator Tel : 202 7371952 fax : 202 7547415 e-mail : [EMAIL PROTECTED] Address : 30 baget Ali Zamalik.- P.C 11211 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Antwort: Re: Configure problems
On 13.03.2001 23:37:20 Kevin Price-Ward wrote: You can NOT use gcc-2.96. Why not? Compiling works fine, without a problem - anything else that I'm missing? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 2 Problems, Shutdown and BDB (data loss)
Enabled the binary log seems to have helped fix the data loss somewhat...I definetly don't loss it all, but I still get those restarts when I shutdown and sometimes, but now less often, I find the last few rows gone. /etc/my.cnf [mysqld] user=sql datadir=/usr/local/mysql/data socket=/tmp/mysql.sock port=3306 myisam-recover=BACKUP,FORCE log-slow-queries=/usr/local/mysql/data/slow.log log=/usr/local/mysql/data/mysqld.log log-bin=/usr/local/mysql/data/binary.log [mysql.server] user=sql basedir=/usr/local/mysql On Tue, 13 Mar 2001, goEbusiness.com Mail Lists wrote: OS: Solaris 7, Sparc MySQL Version: 3.23.29a Problem: Sometimes when I do a mysqladmin shutdown on the command line mysql restarts itself instead of shutting down. From the CLI: elvis~ mysqladmin -uadmin -pdevsqladmin shutdown Terminated 010313 18:17:40 mysqld restarted hangs until I press control C From the .err log: 010313 18:17:40 mysqld restarted /usr/local/mysql-3.23.29a/libexec/mysqld: ready for connections From the query log: 010313 18:17:40 3 Connectadmin@localhost on 3 Query SHOW VARIABLES LIKE 'pid_file' 3 Shutdown /usr/local/mysql-3.23.29a/libexec/mysqld, Version: 3.23.29a-gamma-log, started with: Tcp port: 3306 Unix socket: /tmp/mysql.sock Time Id CommandArgument Sometimes it shutdowns properly. Any ideas? 2nd Problem, using BDB when I insert data, for example mysql CREATE TABLE testBDB ( - name varchar(30) not null - ) TYPE=BDB ; Query OK, 0 rows affected (0.10 sec) mysql INSERT INTO testBDB (name) VALUES ('test no begin/commit') ; Query OK, 1 row affected (0.01 sec) mysql SELECT * FROM testBDB ; +--+ | name | +--+ | test no begin/commit | +--+ 1 row in set (0.00 sec) mysql BEGIN WORK ; Query OK, 0 rows affected (0.00 sec) mysql INSERT INTO testBDB (name) VALUES ('test with begin and commit') ; Query OK, 1 row affected (0.00 sec) mysql COMMIT ; Query OK, 0 rows affected (0.00 sec) mysql SELECT * FROM testBDB ; ++ | name | ++ | test no begin/commit | | test with begin and commit | ++ 2 rows in set (0.00 sec) then I do a restart and I get the behavior in problem #1 mysql SELECT * FROM testBDB ; Empty set (0.00 sec) all the data is gone! Any ideas on what is happening? I can't find anything in the logs about this, and the log.X are all binary data so I cannot decopher that. I'd upgrade to 34a but I am getting hte configure error that other people here are getting about no value for Char. Startup options for MySQL: /usr/local/mysql/bin/safe_mysqld --user=sql --log=/disk1/mysql-data-3.23.29/mysqld.log Bill - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: help-urgent
You have provided absolutely no useful information for anyone who may wish to help you. ramamurthy rajeshkumar wrote: hi, We are using mysql as back end in our server.We are getting an problem with Mysql .the problem is mysqld is going down wiht out any error messages.in the log file it has writted as mysql deamon ended no other messages is thr.but we are getting problmem recently previously it was working nice.as the load increases i am getting this problem(one more thin i have all me tables in single database 10 tables wiht recorde in 20,000 will this create problem) I have set max connections as 150. looking for your help in this regards.it will be helpful for me if you reply me ASAP with regardds Rajesh _ http://cinesouth.com - The best for entertainment in South India - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Trouble automating backup
Duncan Hudson wrote: $sth_backup = $dbh-prepare("BACKUP table ? TO ?"); You cannot embed table names or column names with the placeholder. If you do, that will not be mapped to BACKUP table foo but to BACKUP table 'foo' which will most probably fail. Use prepare("BACKUP table $table TO $othertable") instead. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How many rows does a table can hold?
I want to ask you : 1- How many rows does a mysql table can hold? 2- I have to design a database for all universities of my country , Is it better to consider one database for each university or one database for all universities . Note that a query on a table "student" would be more quick if I use for every university its own student table . thank you sorry for my english __ Get your free domain name and domain-based e-mail from Namezero.com New! Namezero Plus domains now available. Find out more at: http://www.namezero.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
synopsis of the problem (one line)
Description: How-To-Repeat: Fix: Submitter-Id: [EMAIL PROTECTED] Originator:root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.22-beta (Source distribution) Environment: System: Linux gemini.objectorb.com 2.2.16-22 #1 Tue Aug 22 16:49:06 EDT 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.0) Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686' CXX='c++' CXXFLAGS='-O2 -march=i386 -mcpu=i686' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 14 Mar 14 18:27 /lib/libc.so.6 - libc-2.1.92.so -rwxr-xr-x1 root root 4776568 Aug 31 2000 /lib/libc-2.1.92.so -rw-r--r--1 root root 22607104 Aug 31 2000 /usr/lib/libc.a -rw-r--r--1 root root 178 Aug 31 2000 /usr/lib/libc.so lrwxrwxrwx1 root root 10 Mar 14 19:15 /usr/lib/libc-client.a - c-client.a Configure command: ./configure i386-redhat-linux --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --includedir=/usr/include --libdir=/usr/lib --libexecdir=/usr/libexec --localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/share/man --infodir=/usr/share/info --without-debug --without-readline --enable-shared --with-extra-charsets=complex --without-bench --localstatedir=/var/lib/mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --enable-assembler --with-mysqld-user=mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How many rows does a table can hold?
I want to ask you : 1- How many rows does a mysql table can hold? 2- I have to design a database for all universities of my country , Is it better to consider one database for each university or one database for all universities . Note that a query on a table "student" would be more quick if I use for every university its own student table . thank you sorry for my english __ Get your free domain name and domain-based e-mail from Namezero.com New! Namezero Plus domains now available. Find out more at: http://www.namezero.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
[#Deleted] records in Access
Is anybody aware of a problem when connecting Microsoft Access to MySQL 3.23 where records with AutoIncrement fields claim to be deleted after entry? Here's what I have: MySQL 3.23.32 MyODBC 2.50.36 Microsoft Access 2000 Some of my tables have an AutoIncrement Integer field as the primary key and some have a Char() field as the primary key. The tables with Char() for the primary keys work fine. If I enter a record with AutoIncrement numbers as the primary key, Access claims the record is deleted as soon as it is updated. I do not enter a value for the AutoIncrement field (that would defeat the whole purpose of having and autoincrement field). The record does actually get saved correctly, and refreshing the data shows the newly created record. Also, if I do enter a value for the autoincrement field, it will not have this problem. Is there anything I can do to get this problem fixed? One more thing, in the past, I have used a similar setup with MySQL 3.22.29 for Windows. Everything worked fine with that version, but since it was shareware, I tried to upgrade to the 3.23.xx version under the GPL license. That is when I first ran into this problem, and I see that it still has not been fixed, or has not been reported. Please let me know what I can do to help solve this problem. Christopher Lewis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Transactions
Ryan, How exactly does the BEGIN/COMMIT/ROLLBACK transaction process work? The examples I have seen are like: BEGIN; statement 1; statement 2; statement n; COMMIT; Does this imply that if any of the statements fail then a ROLLBACK will be called, otherwise it will COMMIT? you have to code the rollback logic in your application. Since you send SQL statements to MySQL one at a time, the MySQL server cannot know what statements are still coming. In your example, MySQL/Innobase would do the following: if any single SQL statement fails, then depending on the error, Innobase will roll back part of the statement, the whole statement, or everything you have done since the last BEGIN (= the whole transaction). Then, if you continue sending statements to MySQL, they will be processed like nothing would have happened to the previous statement. Currently, in MySQL/Innobase a duplicate key error in an insert of a row only rolls back that single row insert. A deadlock with other transactions rolls back the whole transaction. ANSI SQL standard specifies that an error in an SQL statement should result in a rollback of that whole statement. We have to consider in future if MySQL should by default follow the ANSI spec. Regards, Heikki Tuuri Innobase Oy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Upgrading RPM 3.23.33 to 3.23.34
Sorry for the basic-ness of my questions, but... What's the best way to upgrade an RPM installation of MySQL? Can I just run rpm -U 3.23.34-1.i386 and it will take care of the upgrade or is there another way? Also, should I bring down the server before attempting an upgrade? Is it likely I'll have to rebuild PHP or Apache after the upgrade? I'd appreciate any advice from the MySQL sages... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FULLTEXT indexes
i have a table with a FULLTEXT index that correctly matches certain words: mysql select title from movie where title like 'little%'; ++ | title | ++ | Little Fugitive| | Little Kidnappers, The | | Little Mermaid, The| | Little Thief, The | ++ 4 rows in set (0.00 sec) mysql select title from movie where match(movie.title, movie.subtitle) against('little'); Empty set (0.00 sec) but fails to match others: mysql select title from movie where title like '%fugitive%'; +-+ | title | +-+ | Little Fugitive | +-+ 1 row in set (0.00 sec) mysql select title from movie where match(movie.title, movie.subtitle) against('fugitive'); +-+ | title | +-+ | Little Fugitive | +-+ 1 row in set (0.00 sec) does anyone know what this would happen? john - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
In some circumstances it can be beneficial to split into two a table that is scanned very often
"In some circumstances it can be beneficial to split into two a table that is scanned very often" I found these sentence in the mysql manual , section 12.3:Get your Data as small as possible Does every body know what are these circumstances? __ Get your free domain name and domain-based e-mail from Namezero.com New! Namezero Plus domains now available. Find out more at: http://www.namezero.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: Upgrading RPM 3.23.33 to 3.23.34
rpm -Uhv ... Yes bring it down or it will not upgrade properly. You may need to upgrade Apache etc too. Need to check with your OS vendor on this. Charles Hagen On Thu, 15 Mar 2001 [EMAIL PROTECTED] wrote: Sorry for the basic-ness of my questions, but... What's the best way to upgrade an RPM installation of MySQL? Can I just run rpm -U 3.23.34-1.i386 and it will take care of the upgrade or is there another way? Also, should I bring down the server before attempting an upgrade? Is it likely I'll have to rebuild PHP or Apache after the upgrade? I'd appreciate any advice from the MySQL sages... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Charles L. Hagen Engineer Hagen IT 920-261-8499 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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[2]: Innobase in MySQL
hi! "Peter" == Peter Zaitsev [EMAIL PROTECTED] writes: Peter Hello Dan, Peter Tuesday, March 13, 2001, 6:37:16 PM, you wrote: DN In the last episode (Mar 13), Peter Zaitsev said: Well guys mysqldump have one serious problem - the speed. The backup speed is quite upsetting and loads system much, but the worst thing is recovery speed. In my case the data is added in realtime - most queries are inserts which utilize system quite hard. So to recover data I have gathered for a month it will take about 1 week to feed mysql with mysqldump output, even with extended inserts. So at least this is not complete solution. DN Make sure you remove all your indexes during the load; that can really DN slow down inserts. Peter Well I tried to do so but still it takes an amount of time to add the Peter indexes... Peter I think the good Idea would be to add to mysqldump an option to create Peter the table without index, then insert all data indeed and then add keys Peter required. This would be a good point in --opt mode or in other option Peter :) This already happens when using LOAD DATA INFILE and MyISAM tables, but the Innobase table handler can't yet do this. 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
Symbolic links to tables
In section 12.2.2.1 of the manual it states that MySQL will allow one to move a table and symbolically link it. Then MySQL uses realpath() to find the absolute path. I have done this and all is fine until someone does a DELETE FROM or a ALTER TABLE . When these are done the symbolic links are removed and the tables is recreated in the original database directory. I believe this is because MySQL does a rm on the link. This behavior seems contrary to the use of realpath. Anyone have any idea how to move tables and use links without the above problems ? Thanks. David C. Patton Senior System Administrator Knowledge Management Objects, L.L.C. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Failover and Replication
Hi, We are implementing a linux cluster, and rather than get gouged by oracle (in performance and licensing) would much rather use MySQL. I searched through the archives and found several references to failover and replication but still have some questions. If I understand correctly, replication creates a working copy of mysql on another server, but it looks like the algorithm to automatically change slave to master if the master dies will not be added until mysql 4.x (from 11.4 in the manual). Is this still the case? Im not sure when that was written, perhaps there is news on this front? I also did not find a expected release date Does anyone have any stories/suggestions/experiences in regards to rolling our own monitoring script? Thanks! Bryan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
CVS anonymous access for 4.0 ??
What am I missing? cvs login had succeded. [martin@bart work]$ cvs -d :pserver:[EMAIL PROTECTED]:/cvsroot/mysql co mysql-4.0 cvs server: Updating mysql-4.0 cvs [server aborted]: cannot stat /home/cvs/locks-master: No such file or directory cvs [server aborted]: cannot stat /home/cvs/locks-master: No such file or directory [martin@bart work]$ Thanx for any help ;Martin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Working with UltraDev
Hello guys Does anyone ever work with Macromedia Dreamweaver Ultradev 4.0 and MySQL? I've just started a project and would like to work with MySQL on a RH6.2 box. The goal is to have UltraDev easily working on a Windows PC but managing the data bases store on the RH box. I guess I must start by downloading MyODBC, as I'm newbie to this topic, don't know where to get it and if it is its real name. Any comments will be welcome. *Wilmar Prez * IT Department * Libraries System *University of Antioquia *tels: +(57)4 2105145 *+(57)3 4612166 * Medelln - Colombia - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
HOWTO: Get column types enum values using perl
Hi, I posted before but the help did not yield any success, sorry but thanks. Any one else help? In message [EMAIL PROTECTED], Mark Worsdall [EMAIL PROTECTED] writes Hi, I am trying to read the field types (as well as 1 row of data and the field names), but I cannot seem to manage it. Any ideas on how? M. $sth = $dbh-prepare("SELECT * FROM $sqlTable WHERE id = $id"); $sth-execute; my $hash_ref= $sth-fetchrow_hashref; my @staffFields = keys(%{$hash_ref}); my @staffValues = values(%{$hash_ref}); my @types = $sth-type; #if ($sth-type-[0] = Mysql::FIELD_TYPE_STRING) { # print "Name is a STRING!!br"; #} $count=-1; foreach (@staffFields) { $count++; print $_ . " -- " . $staffValues[$count] . "br"; } -- He came from Econet - Oh no, I've run out of underpants :( Home:- [EMAIL PROTECTED] http://www.wizdom.org.uk Shadow:- [EMAIL PROTECTED] http://www.shadow.org.uk Work:- [EMAIL PROTECTED] http://www.hinwick.demon.co.uk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: help-urgent
Hello ramamurthy, rr hi, rr We are using mysql as back end in our server.We are getting an problem with Mysql .the problem is mysqld is going down wiht out any error messages.in the log file it has writted as mysql deamon rr ended no other messages is thr.but we are getting problmem recently previously it was working nice.as the load increases i am getting this problem(one more thin i have all me tables in single rr database 10 tables wiht recorde in 20,000 will this create problem) rr I have set max connections as 150. rr looking for your help in this regards.it will be helpful for me if you reply me ASAP Are you running MySQL over Linux, Windoze??? If it's Linux, you sould check system logs, free disk space, etc. (/var for example) If it's Windoze, God save you!!! ;-) As Gerald proposed, give more tech info about system. Good luck, -- Roberto - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Installation Problem
Hi: I am upgrading MySql from 3.22 to 3.23 on Sun solaris box. After download, unzip (GNU), and untar (GNUtar), I tried to configure and run it. It failed. Below is the message from error log. 010314 11:14:16 mysqld started ld.so.1: /home/lu/MySql/mysql-3.23.34-sun-solaris2.7-sparc/bin/mysqld: fatal: li bcrypt_i.so.1: open failed: No such file or directory 010314 11:14:16 mysqld ended What the problem is? What is bcypt_i.so.1 file? Thanks in advance! PS. My Sun computer is: Ultra 2, sparc, 5.6, C/C++ 5.0 -- Chris Lu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
INFO
can I manage mysql server 3.23 on red hat linux 6.1 using a win32 client on win nt ? thank you in advance. regards. Andrea GIGLIOTTI GB Net S.n.c. Via Bagni Caldi, 11 55021 Bagni di Lucca (LU) Tel. 0583-805533 Fax 0583-807912 http://www.g-bnet.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: In some circumstances it can be beneficial to split into two a table that is scanned very often
In the last episode (Mar 14), abdelhamid bettache said: "In some circumstances it can be beneficial to split into two a table that is scanned very often" I found these sentence in the mysql manual , section 12.3:Get your Data as small as possible Does every body know what are these circumstances? Say you have a table of dated records (web log, or some other transaction log), and you run lots of "last 24 hours" reports, you can speed up those queries by creating Current and Old tables. You insert into Current, and every night, shift the previous day's records into Old. If you create a MERGE table joining the two, you can still do queries over both tables as though they were one, when you need to. -- Dan Nelson [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: use one database or many databases
I have a similiar situation where I've got a huge database that maintains data for quite a few clients. Queries have gotten extremely sluggish. What I'm working on right now is to have a control database with a single table that contains a unique identifier for each client and a database name. When they log in it figures out the name of the database to use by looking in this table. Each instance of the program only accesses this one database (after finding it in the control) Since all of the programs that make up the suite call the same routine to establish a connection, it is a fairly painless update that I hope will provide substantial performance increases. The only drawback to this is if you need to run a lot of reports across clients. A few administrative reports wouldn't be so bad, but I wouldn't want to like construct a web page on the fly based on a query accessing 50 different data sources. Since this isn't the case here, it shouldn't be a problem. I'm by no means a guru, but this just seems like a logical way to handle the problem. If there is some major logic flaw here, please let me know now! ;) --James [EMAIL PROTECTED] --- From your message of Wed, 14 Mar 2001 08:26:21 -0600: If all the data will be used by the same application then I would suggest that you stick with a single database. Cal http://www.calevans.com -Original Message- From: abdelhamid bettache [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 14, 2001 8:11 AM To: [EMAIL PROTECTED] Subject: use one database or many databases Hello, I have to design a huge database for all the universities , is it better to consider a database for each university or one for all universities .. If I consider one database so I'll have one table for all students wich contain about 30 rows . thank you __ Get your free domain name and domain-based e-mail from Namezero.com New! Namezero Plus domains now available. Find out more at: http://www.namezero.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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 reply expected!
Dear Ruby, Thank you very much for your earlier response! We have downloaded the mm.mysql.jdbc driver as you have specified and placed it in the lib directory of Tomcat server! We tried placing the same in jdk and mysql lib directories too! Still we are not able to connect it! We are not clear as to where or in which lib directory we have to place these jar files! We are getting the following exception when we run our jsp file! The driver registration code we have used is as follows: Class.forName("org.gjt.mm.mysql.Driver"); Connection conn = DriverManager.getConnection("jdbc:mysql://www.homeomiracles.com:8080/homoeo" ); Error: 500 Location: /examples/jsp/num/Submit.jsp Internal Servlet Error: javax.servlet.ServletException: Unable to load class org.gjt.mm.mysql.Driver at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp l.java:459) at jsp.num._0002fjsp_0002fnum_0002fSubmit_0002ejspSubmit_jsp_16._jspService(_00 02fjsp_0002fnum_0002fSubmit_0002ejspSubmit_jsp_16.java:388) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja va:177) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:318) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:391) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404) at org.apache.tomcat.core.Handler.service(Handler.java:286) at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372) at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:79 7) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743) at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpC onnectionHandler.java:210) at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416) at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498) at java.lang.Thread.run(Thread.java:484)
RE: Full tables...
Hi, The output from mysqladmin variables would be useful. Quentin -Original Message- From: Dave Camarillo [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 March 2001 7:42 a.m. To: [EMAIL PROTECTED] Subject: Full tables... Hello all, I've run into a minor problem with my schema/mysql. I have a table with 64 columns (varying data-types) and about 7 indexes (some multi-column indexes) containing roughly 19 million records. Were running Solaris 2.8 on Sparc with mysql 3.23.33 with raid-tables and large files compiled in with gcc 2.95.2. In my development, I have roughly 30 MyISAM tables that are identical in columns/indexes to this particular table, the only difference is the number of records in this table (this table has the most records) My problem, is that when I go to do an update statement to the table, I get an error message back from the Perl DBI saying that "The table BLABLABLA is full". I have this table set up with raid-0, across 8 slices, each slice with a max size of 2 gigs. (in theory the max size of the table would be 16 gigs). After looking at the actual table slices in the mysql data directory, the sum of the slices only takes up about 4.5 gigs while, the index file is about 1.5 gigs and only in 1 file. There is plenty of memory on the machine, currently mysql has malloc'ed about 4 gigs. In my code, I've tried putting in "SET SQL_BIG_TABLES=1;", however I still get the same error. What kinds of things cause "Table Full" errors? I've looked through the mysql documentation, however I haven't been able to find a fix that works. Any suggestions, ideas etc? Thanks Dave [EMAIL PROTECTED] Some other info about how mysql is setup: Tmp_table_size=1gig Record buffer = 512M Table cache = 1gig Key_buffer = 1gig (I've been playing around with these settings so I know they are not optimal) Another question, off this subject. The most memory I've seen mysql use is 4 gigs. Is it possible for it to use more? Do I need to compile it with a different memory model? If so, what kind of model and where can I find out more about it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Full tables...w/ show variables
Wow...thanks for the quick response... The mysql variables are: +-+---+ | Variable_name | Value | +-+---+ | ansi_mode | OFF | | back_log| 50| | basedir | /usr/local/mysql/ | | binlog_cache_size | 32768 | | character_set | latin1| | character_sets | latin1 cp1251 | | concurrent_insert | ON| | connect_timeout | 5 | | datadir | /usr/local/mysql/var/ | | delay_key_write | ON| | delayed_insert_limit| 4000 | | delayed_insert_timeout | 300 | | delayed_queue_size | 4000 | | flush | OFF | | flush_time | 0 | | have_bdb| NO| | have_gemini | NO| | have_innobase | NO| | have_isam | YES | | have_raid | YES | | have_ssl| NO| | init_file | | | interactive_timeout | 28800 | | join_buffer_size| 131072| | key_buffer_size | 0 | | language| /usr/local/mysql/share/mysql/english/ | | large_files_support | ON| | locked_in_memory| OFF | | log | OFF | | log_update | OFF | | log_bin | OFF | | log_slave_updates | OFF | | long_query_time | 10| | low_priority_updates| OFF | | lower_case_table_names | 0 | | max_allowed_packet | 16776192 | | max_binlog_cache_size | 4294967295| | max_binlog_size | 1073741824| | max_connections | 200 | | max_connect_errors | 10| | max_delayed_threads | 150 | | max_heap_table_size | 16777216 | | max_join_size | 4294967295| | max_sort_length | 1024 | | max_tmp_tables | 32| | max_write_lock_count| 4294967295| | myisam_recover_options | OFF | | myisam_sort_buffer_size | 8388608 | | net_buffer_length | 16384 | | net_read_timeout| 30| | net_retry_count | 10| | net_write_timeout | 60| | open_files_limit| 0 | | pid_file| /usr/local/mysql/var/XXX.pid | | port| 3306 | | protocol_version| 10| | record_buffer | 536866816 | | query_buffer_size | 0 | | safe_show_database | OFF | | server_id | 0 | | skip_locking| OFF | | skip_networking | OFF | | skip_show_database | OFF | | slow_launch_time| 2 | | socket | /tmp/mysql.sock | | sort_buffer | 134217720 | | table_cache | 1024 | | table_type | MYISAM| | thread_cache_size | 0 | | thread_concurrency | 10
Mysql.sock Question
I hate to ask this question but I have tried everything. I am installed mysql on a new server and everything seems to be OK except it never created mysql.sock? Here is how I installed it: cd mysql-3.23.29a-gamma/ groupadd mysql useradd -g mysql mysql ./configure --with-named-curses-libs=/usr/lib/libncurses.so --without-bench make make install cd support-files/ cp mysql.server /etc/rc.d/init.d/ chkconfig --level 345 mysql.server on cd ../ /usr/local/bin/mysql_install_db /usr/local/bin/mysqladmin -u root password 'WHATEVER' Any ideas why the mysql.sock isn't there. Mysqld is running... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: use one database or many databases
Or, you could use one database, and lookup the clients table names, and use a merge table for reports. James Blackwell wrote: I have a similiar situation where I've got a huge database that maintains data for quite a few clients. Queries have gotten extremely sluggish. What I'm working on right now is to have a control database with a single table that contains a unique identifier for each client and a database name. When they log in it figures out the name of the database to use by looking in this table. Each instance of the program only accesses this one database (after finding it in the control) Since all of the programs that make up the suite call the same routine to establish a connection, it is a fairly painless update that I hope will provide substantial performance increases. The only drawback to this is if you need to run a lot of reports across clients. A few administrative reports wouldn't be so bad, but I wouldn't want to like construct a web page on the fly based on a query accessing 50 different data sources. Since this isn't the case here, it shouldn't be a problem. I'm by no means a guru, but this just seems like a logical way to handle the problem. If there is some major logic flaw here, please let me know now! ;) --James [EMAIL PROTECTED] --- From your message of Wed, 14 Mar 2001 08:26:21 -0600: If all the data will be used by the same application then I would suggest that you stick with a single database. Cal http://www.calevans.com -Original Message- From: abdelhamid bettache [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 14, 2001 8:11 AM To: [EMAIL PROTECTED] Subject: use one database or many databases Hello, I have to design a huge database for all the universities , is it better to consider a database for each university or one for all universities .. If I consider one database so I'll have one table for all students wich contain about 30 rows . thank you __ Get your free domain name and domain-based e-mail from Namezero.com New! Namezero Plus domains now available. Find out more at: http://www.namezero.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: In some circumstances it can be beneficial to split into two a table that is scanned very often
In the last episode (Mar 14), abdelhamid bettache said: "In some circumstances it can be beneficial to split into two a table that is scanned very often" I found these sentence in the mysql manual , section 12.3:Get your Data as small as possible Does every body know what are these circumstances? One case that comes to mind is when you have a table that you both need to write to often and read from often. If the columns you are reading from and writing two are different, then you can break them out into different tables. This is in-line with a general rule of thumb that a table should be mostly read from or mostly written to, not both equally (as databases have trouble doing both efficiently). Here's an example of a case I had a while back. I had an "Accounts" table which contained username, password, and last-access columns. The username/password fields were read from often, and the last-access column was written to often. So, I broke out the last-access column into its own table. This reduced the load on the Accounts table and thus speeded up access. With "mysqladmin processes" I had been seeing clients waiting for access to the Accounts table while the Last updates were happening. Meanwhile, I actually stopped using UPDATE to change the last-access column in the new Lasts table, instead I now use INSERT DELAYED. I did this because it's my understanding that UPDATEs are slower than INSERTs, plus using DELAYED has its performance benefits as well. This did complicate reading the last-access info, I have to do an "SELECT last-access FROM Lasts ORDER BY last-access DESC LIMIT 1" to get the most recent info. Plus I have a nightly script that cleans-up(deletes) non-latest Lasts rows. But, all this did solve my db performance problem. -bill - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Full tables...w/ show variables
Hello again. A few thoughts - nothing certain, and all derived from the fine manual, which you have already read, I'm afraid: Are you issuing the SQL_BIG_TABLES=1 in the same connected session as the query? Is there enough space in '/var/tmp'? However, if that was filling up, mysqld would wait for it to empty, rather than report an error. Are you able try setting the --big-tables option for the server, or increase the 'tmp_table_size' variable? If these lead nowhere, I'll have to leave it to the MySQL guys to figure out. Regards Quentin -Original Message- From: Dave Camarillo [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 March 2001 8:43 a.m. To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject: RE: Full tables...w/ show variables Wow...thanks for the quick response... The mysql variables are: +-+---+ | Variable_name | Value | +-+---+ | ansi_mode | OFF | | back_log| 50| | basedir | /usr/local/mysql/ | | binlog_cache_size | 32768 | | character_set | latin1| | character_sets | latin1 cp1251 | | concurrent_insert | ON| | connect_timeout | 5 | | datadir | /usr/local/mysql/var/ | | delay_key_write | ON| | delayed_insert_limit| 4000 | | delayed_insert_timeout | 300 | | delayed_queue_size | 4000 | | flush | OFF | | flush_time | 0 | | have_bdb| NO| | have_gemini | NO| | have_innobase | NO| | have_isam | YES | | have_raid | YES | | have_ssl| NO| | init_file | | | interactive_timeout | 28800 | | join_buffer_size| 131072| | key_buffer_size | 0 | | language| /usr/local/mysql/share/mysql/english/ | | large_files_support | ON| | locked_in_memory| OFF | | log | OFF | | log_update | OFF | | log_bin | OFF | | log_slave_updates | OFF | | long_query_time | 10| | low_priority_updates| OFF | | lower_case_table_names | 0 | | max_allowed_packet | 16776192 | | max_binlog_cache_size | 4294967295| | max_binlog_size | 1073741824| | max_connections | 200 | | max_connect_errors | 10| | max_delayed_threads | 150 | | max_heap_table_size | 16777216 | | max_join_size | 4294967295| | max_sort_length | 1024 | | max_tmp_tables | 32| | max_write_lock_count| 4294967295| | myisam_recover_options | OFF | | myisam_sort_buffer_size | 8388608 | | net_buffer_length | 16384 | | net_read_timeout| 30| | net_retry_count | 10| | net_write_timeout | 60| | open_files_limit| 0 | | pid_file| /usr/local/mysql/var/XXX.pid | | port| 3306 | | protocol_version| 10| | record_buffer | 536866816 | | query_buffer_size | 0 | | safe_show_database
Re: HOWTO: Get column types enum values using perl
In message [EMAIL PROTECTED], [EMAIL PROTECTED] writes $sth-{TYPE} returns a reference to an array of types. $types = $sth-{TYPE} if ($$type[0] = Mysql::FIELD_TYPE_STRING) (I don't know about the Mysql::FIELD_TYPE_STRING, but $$type[0] is the type of the first field.) When I do this:- my $types = $sth-{TYPE}; # if ($$types[0] = Mysql::FIELD_TYPE_STRING) { print "Type is a SRINGBR"; } It no longer executes the rest of the code as in the next part that gets the data doesn't get run. So I am lost once more.:( M. -- He came from Econet - Oh no, I've run out of underpants :( Home:- [EMAIL PROTECTED] http://www.wizdom.org.uk Shadow:- [EMAIL PROTECTED] http://www.shadow.org.uk Work:- [EMAIL PROTECTED] http://www.hinwick.demon.co.uk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqldump Error
I'm trying to use mysqldump to dump a database (obviously). Here's the commandline I'm using: [root@fugu work]# mysqldump --tab=. wonderdesk mysqldump: Got error: 1: Can't create/write to file '/root/work/Calls.txt' (Errcode: 13) The interesting thing, is that is IS creating Calls.sql, but it then crashes on Calls.txt. I've got plenty of drive space, file permissions aren't a problem, and it's creating some files, but not all of them. Anyone got any Ideas? I've searched around a bit, and haven't been able to find what an errcode 13 is, so I'm out of ideas. Thanks guys! Joel
win to linux
Hello, I am using MySQL on windows platform. How can I port mt datas from MySQL server on windows to MySQl server on Linux? Thanks for all.
Webmin
Has anyone found a GUI for MySQL on a Linux box? I found Webmin, but it seems limited. Is there an HTML GUI for MySQL? -- Charles L. Hagen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 simple mysqld options in /etc/my.cnf
I've found that past versions of MySQL ship with a version of safe_mysqld that reads the config file itself and only passes on a few of the parameters. We had to rewrite our own version to allow mysqld to actually parse the stuff on its own. Note that the my.cnf file that ships often seems to put the error log entry in the [mysqld] section which causes mysqld to stop with an error because it doesn't understand it if you run mysqld directly. I am assuming you are using Linux/Unix here. If it is Windows, I can't help :-) If you are using Linux/Unix, look through safe_mysqld and make sure that it will correctly pass these parameters through to mysqld. We had to make changes to get the logs to work the way we wanted them and eventually wrote our own version. Our version is not publically available, sorry. Best, Kyle On Wednesday 14 March 2001 04:16, Bill Marrs wrote: Hi, I like to run mysqld with these 3 options: --log-slow-queries --delay-key-write-for-all-tables --skip-networking But, so far, I've been unable to get mysqld to read them out of /etc/my.cnf. Here's what's inside my /etc/my.cnf: [mysql.server] log-slow-queries delay-key-write-for-all-tables skip-networking Am I doing this wrong? I looked, but I didn't find any documentation of how to format simple options like this in /etc/my.cnf. ...or perhaps, I have them under the wrong header (is "mysql.server" correct?) or perhaps I just can't set these options in /etc/my.cnf. Currently, I set them by editing the mysql start script, adding them to the safe_mysqld line. Any help would be appreciated. -bill - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- * "HEAR THE DIFFERENCE" with a live MicroTelco Gateway demo at: Voice on the Net (VON), March 20-23, Phoenix AZ. For more information visit: http://www.microtelco.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: HOWTO: Get column types enum values using perl
"MW" == Mark Worsdall [EMAIL PROTECTED] writes: MW When I do this:- MW my $types = $sth-{TYPE}; MW # MW if ($$types[0] = Mysql::FIELD_TYPE_STRING) { MW print "Type is a SRINGBR"; MW } Perhaps you mean if ($$types[0] == Mysql::FIELD_TYPE_STRING) you are doing an assignment, not a comparison. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: win to linux
rozakdemir wrote: Hello, I am using MySQL on windows platform. How can I port mt datas from MySQL server on windows to MySQl server on Linux? Thanks for all. You should search the sarchives and manual, this is a very FAQ... tables extension is like .MY* you can just copy them, if not you need mysqldump.. for details see mail archives. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqldump Error
ah but I do.. Allow me to prove it.. drwxr-xr-x 4 root wheel 512 Mar 14 12:50 work [root@fugu work]# touch this_works [root@fugu work]# ls -la -rw-r--r-- 1 root wheel0 Mar 14 13:42 this_works And, as I stated before, the Calls.sql file IS being created in this same directory. Is it possible this sort of permission denied is related to some part of the database?? I should mention that I can run a "normal" mysqldump till I'm blue in the face, it's just when I try and create these tab deliminated files that is chokes. Thanks! Joel - Original Message - From: "Gerald L. Clark" [EMAIL PROTECTED] To: "Joel Caturia" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, March 14, 2001 1:43 PM Subject: Re: mysqldump Error Joel Caturia wrote: I'm trying to use mysqldump to dump a database (obviously). Here's the commandline I'm using: [root@fugu work]# mysqldump --tab=. wonderdesk mysqldump: Got error: 1: Can't create/write to file '/root/work/Calls.txt' (Errcode: 13) The interesting thing, is that is IS creating Calls.sql, but it then crashes on Calls.txt. I've got plenty of drive space, file permissions aren't a problem, and it's creating some files, but not all of them. Anyone got any Ideas? I've searched around a bit, and haven't been able to find what an errcode 13 is, so I'm out of ideas. Thanks guys! Joel perror 13 Permission denied You don't have write permission in /root/work. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Webmin
Has anyone found a GUI for MySQL on a Linux box? I found Webmin, but it seems limited. Is there an HTML GUI for MySQL? You could try "MysqlTool". It's a Perl program. Haven't really used it yet, but it looks good. Adam -- Adam Stein @ Xerox Corporation Email: [EMAIL PROTECTED] Disclaimer: All views expressed here have been proved to be my own. [http://www.csh.rit.edu/~adam/] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Webmin
Has anyone found a GUI for MySQL on a Linux box? I found Webmin, but it seems limited. Is there an HTML GUI for MySQL? Check out MysqlTool at ... http://dajoba.com/projects/mysqltool/ ... it's a web-based interface implemented in Perl. If you prefer one written in PHP, have a look at phpMyAdmin at ... http://phpwizard.net/projects/phpMyAdmin/ - Ray - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqldump Error
Hi, Error 13 is permissions. Your server has to have permission to write to the directory, and over-write any existing file of the same name. Regards Quentin -Original Message- From: Joel Caturia [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 March 2001 10:07 a.m. To: [EMAIL PROTECTED] Subject: mysqldump Error I'm trying to use mysqldump to dump a database (obviously). Here's the commandline I'm using: [root@fugu work]# mysqldump --tab=. wonderdesk mysqldump: Got error: 1: Can't create/write to file '/root/work/Calls.txt' (Errcode: 13) The interesting thing, is that is IS creating Calls.sql, but it then crashes on Calls.txt. I've got plenty of drive space, file permissions aren't a problem, and it's creating some files, but not all of them. Anyone got any Ideas? I've searched around a bit, and haven't been able to find what an errcode 13 is, so I'm out of ideas. Thanks guys! Joel The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: win to linux
use ftp to copy your database/table files :) - Original Message - From: "rozakdemir" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 14, 2001 10:05 PM Subject: win to linux Hello, I am using MySQL on windows platform. How can I port mt datas from MySQL server on windows to MySQl server on Linux? Thanks for 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: mysqldump Error
Hi, But is your mysql server run by root, or, as advised, by 'mysql'? Quentin -Original Message- From: Joel Caturia [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 March 2001 10:56 a.m. To: Gerald L. Clark Cc: [EMAIL PROTECTED] Subject: Re: mysqldump Error ah but I do.. Allow me to prove it.. drwxr-xr-x 4 root wheel 512 Mar 14 12:50 work [root@fugu work]# touch this_works [root@fugu work]# ls -la -rw-r--r-- 1 root wheel0 Mar 14 13:42 this_works And, as I stated before, the Calls.sql file IS being created in this same directory. Is it possible this sort of permission denied is related to some part of the database?? I should mention that I can run a "normal" mysqldump till I'm blue in the face, it's just when I try and create these tab deliminated files that is chokes. Thanks! Joel - Original Message - From: "Gerald L. Clark" [EMAIL PROTECTED] To: "Joel Caturia" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, March 14, 2001 1:43 PM Subject: Re: mysqldump Error Joel Caturia wrote: I'm trying to use mysqldump to dump a database (obviously). Here's the commandline I'm using: [root@fugu work]# mysqldump --tab=. wonderdesk mysqldump: Got error: 1: Can't create/write to file '/root/work/Calls.txt' (Errcode: 13) The interesting thing, is that is IS creating Calls.sql, but it then crashes on Calls.txt. I've got plenty of drive space, file permissions aren't a problem, and it's creating some files, but not all of them. Anyone got any Ideas? I've searched around a bit, and haven't been able to find what an errcode 13 is, so I'm out of ideas. Thanks guys! Joel perror 13 Permission denied You don't have write permission in /root/work. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: use one database or many databases
I've run into a situation where i need to split an enormous database (only say a million rows but oh so long possibly many K) Using JDBC and prepared statements this could be facilitated if we could have the driver implement a setSQL(int x, "--text--") function which could replace a '?' placeholder for the table name in the SQL statement. I can imagine other uses for this too. Unfortunately not a feature in JDBC2.0 or 3.0. Dave. James Blackwell wrote: Yes, but I'm really lazy and changing one connect string is easier than going through 200,000 lines of code and changing table names. ;) That's a good spin on it. Thanks. --James --- From your message of Wed, 14 Mar 2001 14:09:30 -0600: Or, you could use one database, and lookup the clients table names, and use a merge table for reports. James Blackwell wrote: I have a similiar situation where I've got a huge database that maintains data for quite a few clients. Queries have gotten extremely sluggish. What I'm working on right now is to have a control database with a single table that contains a unique identifier for each client and a database name. When they log in it figures out the name of the database to use by looking in this table. Each instance of the program only accesses this one database (after finding it in the control) Since all of the programs that make up the suite call the same routine to establish a connection, it is a fairly painless update that I hope will provide substantial performance increases. The only drawback to this is if you need to run a lot of reports across clients. A few administrative reports wouldn't be so bad, but I wouldn't want to like construct a web page on the fly based on a query accessing 50 different data sources. Since this isn't the case here, it shouldn't be a problem. I'm by no means a guru, but this just seems like a logical way to handle the problem. If there is some major logic flaw here, please let me know now! ;) --James [EMAIL PROTECTED] --- From your message of Wed, 14 Mar 2001 08:26:21 -0600: If all the data will be used by the same application then I would suggest that you stick with a single database. Cal http://www.calevans.com -Original Message- From: abdelhamid bettache [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 14, 2001 8:11 AM To: [EMAIL PROTECTED] Subject: use one database or many databases Hello, I have to design a huge database for all the universities , is it better to consider a database for each university or one for all universities .. If I consider one database so I'll have one table for all students wich contain about 30 rows . thank you __ Get your free domain name and domain-based e-mail from Namezero.com New! Namezero Plus domains now available. Find out more at: http://www.namezero.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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
C with embedded mysql
Hi, I am a newbie... so please excuse me if the question is a bit wacky ;-) I was trying to write a database system using C with embedded mysql.. could you please help me by providing me with any links to anysites where I can get help in the form of 1. Sample code. 2. Tutorial on how to do the embedded mysql 3. How to compile and test out the code I have a Linux box with the latest version of mysql on it. Thanks for your help Ryan __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqldump Error
ahhh.. ok, I understand.. So the moral of the story is the mysql process itself touches the local filesystem. It's NOT the UID of the person running the command that matters, it's who the daemon is running as. Hence the reason the help page says "this only works when running on the same machine the daemon is on." But, I imagine the first part of the export IS running as root, because it works. Thank you for clearing this up, that didn't make a whole lot of sense to me, not it makes perfect sense. The export works now, case closed.. Thanks again! Joel - Original Message - From: "Quentin Bennett" [EMAIL PROTECTED] To: "'Joel Caturia'" [EMAIL PROTECTED]; "Gerald L. Clark" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, March 14, 2001 2:19 PM Subject: RE: mysqldump Error Hi, But is your mysql server run by root, or, as advised, by 'mysql'? Quentin -Original Message- From: Joel Caturia [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 March 2001 10:56 a.m. To: Gerald L. Clark Cc: [EMAIL PROTECTED] Subject: Re: mysqldump Error ah but I do.. Allow me to prove it.. drwxr-xr-x 4 root wheel 512 Mar 14 12:50 work [root@fugu work]# touch this_works [root@fugu work]# ls -la -rw-r--r-- 1 root wheel0 Mar 14 13:42 this_works And, as I stated before, the Calls.sql file IS being created in this same directory. Is it possible this sort of permission denied is related to some part of the database?? I should mention that I can run a "normal" mysqldump till I'm blue in the face, it's just when I try and create these tab deliminated files that is chokes. Thanks! Joel - Original Message - From: "Gerald L. Clark" [EMAIL PROTECTED] To: "Joel Caturia" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, March 14, 2001 1:43 PM Subject: Re: mysqldump Error Joel Caturia wrote: I'm trying to use mysqldump to dump a database (obviously). Here's the commandline I'm using: [root@fugu work]# mysqldump --tab=. wonderdesk mysqldump: Got error: 1: Can't create/write to file '/root/work/Calls.txt' (Errcode: 13) The interesting thing, is that is IS creating Calls.sql, but it then crashes on Calls.txt. I've got plenty of drive space, file permissions aren't a problem, and it's creating some files, but not all of them. Anyone got any Ideas? I've searched around a bit, and haven't been able to find what an errcode 13 is, so I'm out of ideas. Thanks guys! Joel perror 13 Permission denied You don't have write permission in /root/work. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 connection failed in browser
Hey everyone, I just went through a new setup of Information Resource Manager scripts under PHP 4.0.1p12-9 that work with MySql 3.23.22-6 under Apache 1.3.125-25, all of this stuff except the Resource Manager come standard with RedHat 7.0. After creating the database for the set of php scripts, I should be able to go right into my web browser and get to the scripts and see all the default screens. I can get to the login screen, but when entering a username and password I get the following: Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in ./irm.inc on line 83 Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in ./irm.inc on line 84 Warning: MySQL: A link to the server could not be established in ./irm.inc on line 84 It just looks like there may be a problem with the php scripts and the link to the mysql database, I've been through all of the config files I could find and have been searching the internet for some type of answer. I'm new to the mysql and php world, so it's all a struggle right now. Anyone have any ideas? (I'm sure it's a pretty simple fix) Thanks, Tim Czerlinsky Customer Support [EMAIL PROTECTED] ___ TechWorks 4030 West Braker Lane, Suite 350 Austin, Texas 78759-5319 USA 800-688-7466 ___ http://www.techworks.com http://www.techworks.com/ 512-794-8558 FAX Customer Support is available Mon.- Fri. 9:00 AM to 5:30 PM CST 800-933-6113
Re: How many rows does a table can hold?
On Wed, Mar 14, 2001 at 07:19:24AM -0800, abdelhamid bettache wrote: I want to ask you : 1- How many rows does a mysql table can hold? Millions. Probably billions. I've heard of someone putting 2 billion rows in a table before (if memory serves). 2- I have to design a database for all universities of my country , Is it better to consider one database for each university or one database for all universities . Note that a query on a table "student" would be more quick if I use for every university its own student table . If the data structures are identical, there should be little need to split them out into their own tables. Speed shouldn't be an issue if it is indexed properly. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: win to linux
I don't think that works across platformsits better to use the mysqldump command. Brian -Original Message- From: René Tegel [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 14, 2001 5:09 PM To: rozakdemir; [EMAIL PROTECTED] Subject: Re: win to linux use ftp to copy your database/table files :) - Original Message - From: "rozakdemir" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 14, 2001 10:05 PM Subject: win to linux Hello, I am using MySQL on windows platform. How can I port mt datas from MySQL server on windows to MySQl server on Linux? Thanks for 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
connection lost on long-distance connection
I've ran into some problems when connecting to a mysql server over a long-distance connection (i.e.: the internet). The first time a client reconnects from a idle connection this reconnect fails, only the second time it succeeds. The main problem is that i've written a win32 app that connects to this server. Normally the client and server will be on a LAN but i test the program on a their database from my place. I use libmysql.dll for this. (no odbc!) Normally i relied on libmysql.dll to reconnect when a connection was lost, on a lan this never gave any problem but now it does, giving my app no result set on a particulair query after been idle for a while, and thus introducing bugs. I am able to reproduce this with the standard mysql client. Both the win32 and the linux client behave the same. Tech info: server running mysql 3.23.32 win32 binary distribution Client app is behind a firewall, MySQL server is directly connected to the internet. Telnet or other sessions normally remain alive through my firewall. ping trip-around time: about 200ms, however sometimes loads of packet loss (possible cause?) Just after a connection everything is fine: mysql show processlist; +-+---++--+-+--+---+ --+ | Id | User | Host | db | Command | Time | State |Info | +-+---++--+-+--+---+ --+ | 429 | admin | cx.upc-c.chello.nl | NULL | Query | 0| NULL |show processlist | +-+---++--+-+--+---+ --+ 1 row in set (0.21 sec) Then if a leave the client for a while (say: ten minutes) the connection is gone: mysql show processlist; ERROR 2013: Lost connection to MySQL server during query mysql show processlist; ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id:430 Current database: *** NONE *** +-+---++--+-+--+---+ --+ | Id | User | Host | db | Command | Time | State |Info | +-+---++--+-+--+---+ --+ | 429 | admin | cx.upc-c.chello.nl | NULL | Sleep | 2732 | |NULL | | 430 | admin | cx.upc-c.chello.nl | NULL | Query | 0| NULL |show processlist | +-+---++--+-+--+---+ --+ 2 rows in set (5.99 sec) So, the server still thinks i've got an active connection. this list keeps on growing. For as far as I can see, my win32 app behaves the same as the mysql client. It'll try to reconnect but it fails, only second time it succesfully reconnects. I ported my app from interbase to mysql. with interbase i did not have this connection problem, but it's so terribly slow on many queries/ larger result sets (interbase fetches a result field by field, generating numerous network packets...) I also have some PHP scripts that connect to this server, running in win32 cgi mode. They do behave normally, i guess because they have to connect every time (i.e.: no persistant connections for win32 w/o isapi) they are called. When not idle (i.e. active querying) everything behaves normal and i notice no errors at all, not even on heavy load. Any ideas / solution would be really appreciated thanx in advance, rene - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: apostrophe ....
- Original Message - From: "Ren Tegel" [EMAIL PROTECTED] To: "Rolf Hopkins" [EMAIL PROTECTED]; "Eric Fitzgerald" [EMAIL PROTECTED]; "Randy Johnson" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, March 14, 2001 18:48 Subject: Re: apostrophe tx Rolf! Yes, indeed. by default, on the newest releases of the php.ini file, magic_quotes_gpc is turned off. uh...umm... I think you mean "on" not "off" O | O \/ Of course one can switch it on/off running single scripts. The ini file in fact mentions in the introduction that is has changed. but.. why does php change default parameters, especially when releasing minor upgrades/patch levels. This stuff can take loads of time from the programmer, just by changing platform version from v4.01 to 4.04pl1 Don't know why. Maybe the php list is getting too many questions on how to insert "special" character into "M y S Q L" :))) so they decided to change it for those who are too lazy to read the manual and find out about addslashes. But whatever there reason, it sure makes it harder for the rest of us. regards, rene - Original Message - From: "Rolf Hopkins" [EMAIL PROTECTED] To: "Ren Tegel" [EMAIL PROTECTED]; "Eric Fitzgerald" [EMAIL PROTECTED]; "Randy Johnson" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, March 14, 2001 1:27 AM Subject: Re: apostrophe Or you can fix your php by turning off the magic_quotes_gpc flag. You then won't need to change your code. Check out http://www.php.net/manual/en/configuration.php on how to do this. I have provided an example on how to do this with apache running on a linux machine. - Original Message - From: "Ren Tegel" [EMAIL PROTECTED] To: "Eric Fitzgerald" [EMAIL PROTECTED]; "Randy Johnson" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, March 14, 2001 2:56 Subject: Re: apostrophe this was true on php 4.01 but not on php 4.04pl1, i have to escape my strings again. or it's some switch or conf setting i never seen/heard/thought of... i now use $var=addslashes($var) on php4.0.4pl1 redhat 7 where i do not have to on a other system running php4.0.1 redhat 6.2 ! especially php seems to have loads of undocumented - and worse, changing, behaviour. regards, rene - Original Message - From: "Eric Fitzgerald" [EMAIL PROTECTED] To: "Randy Johnson" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, March 13, 2001 7:15 PM Subject: Re: apostrophe Two things here. First off, we had this problem spring up on us, and I think I may know why it's doing it to you. If your using PHP, the more recent version automatically escape out variables sent to the mysql driver. Thus randy's is converted to randy's. HOWEVER, if you still have old code where you ran things through addslashes, it turns out like to look like randy\\\'s. Which ends up being stored as randy\'s. To correct this, first fix your code, then run the following query: UPDATE table SET fieldname = REPLACE(fieldname,'\\',''); - Original Message - From: "Randy Johnson" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 13, 2001 9:54 AM Subject: apostrophe When a text with an apostrophe in it has a \' in it. How can I fix this? example randy's is stored in the DB as randy\'s thanks Randy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/
Re: Mysql.sock Question
- Original Message - From: "Marcus Ouimet" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 15, 2001 4:05 Subject: Mysql.sock Question I hate to ask this question but I have tried everything. I am installed mysql on a new server and everything seems to be OK except it never created mysql.sock? Here is how I installed it: cd mysql-3.23.29a-gamma/ groupadd mysql useradd -g mysql mysql ./configure --with-named-curses-libs=/usr/lib/libncurses.so --without-bench make make install cd support-files/ cp mysql.server /etc/rc.d/init.d/ chkconfig --level 345 mysql.server on cd ../ /usr/local/bin/mysql_install_db /usr/local/bin/mysqladmin -u root password 'WHATEVER' Any ideas why the mysql.sock isn't there. Mysqld is running... Are you sure it is running? do a ps -ef | grep mysql to find out. If not, start the server. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: apostrophe ....
Rolf, i asked my college "did you use the original ini" ? "yes, i did." he said, " i only changed some layout". for myself i changed some parameters on this .ini file like max execution time and max upload time, nothing more. excuse me for not verifying further but as far as i see this php.ini dramatacally changes with any version. sorry mysql list, it has in fact nothing to do with mysql.. but it took me several hours on several days within the last year... - Original Message - From: "Rolf Hopkins" [EMAIL PROTECTED] To: "Ren Tegel" [EMAIL PROTECTED]; "Eric Fitzgerald" [EMAIL PROTECTED]; "Randy Johnson" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, March 15, 2001 12:40 AM Subject: Re: apostrophe - Original Message - From: "Ren Tegel" [EMAIL PROTECTED] To: "Rolf Hopkins" [EMAIL PROTECTED]; "Eric Fitzgerald" [EMAIL PROTECTED]; "Randy Johnson" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, March 14, 2001 18:48 Subject: Re: apostrophe tx Rolf! Yes, indeed. by default, on the newest releases of the php.ini file, magic_quotes_gpc is turned off. uh...umm... I think you mean "on" not "off" O | O \/ Of course one can switch it on/off running single scripts. The ini file in fact mentions in the introduction that is has changed. but.. why does php change default parameters, especially when releasing minor upgrades/patch levels. This stuff can take loads of time from the programmer, just by changing platform version from v4.01 to 4.04pl1 Don't know why. Maybe the php list is getting too many questions on how to insert "special" character into "M y S Q L" :))) so they decided to change it for those who are too lazy to read the manual and find out about addslashes. But whatever there reason, it sure makes it harder for the rest of us. regards, rene - Original Message - From: "Rolf Hopkins" [EMAIL PROTECTED] To: "Ren Tegel" [EMAIL PROTECTED]; "Eric Fitzgerald" [EMAIL PROTECTED]; "Randy Johnson" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, March 14, 2001 1:27 AM Subject: Re: apostrophe Or you can fix your php by turning off the magic_quotes_gpc flag. You then won't need to change your code. Check out http://www.php.net/manual/en/configuration.php on how to do this. I have provided an example on how to do this with apache running on a linux machine. - Original Message - From: "Ren Tegel" [EMAIL PROTECTED] To: "Eric Fitzgerald" [EMAIL PROTECTED]; "Randy Johnson" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, March 14, 2001 2:56 Subject: Re: apostrophe this was true on php 4.01 but not on php 4.04pl1, i have to escape my strings again. or it's some switch or conf setting i never seen/heard/thought of... i now use $var=addslashes($var) on php4.0.4pl1 redhat 7 where i do not have to on a other system running php4.0.1 redhat 6.2 ! especially php seems to have loads of undocumented - and worse, changing, behaviour. regards, rene - Original Message - From: "Eric Fitzgerald" [EMAIL PROTECTED] To: "Randy Johnson" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, March 13, 2001 7:15 PM Subject: Re: apostrophe Two things here. First off, we had this problem spring up on us, and I think I may know why it's doing it to you. If your using PHP, the more recent version automatically escape out variables sent to the mysql driver. Thus randy's is converted to randy's. HOWEVER, if you still have old code where you ran things through addslashes, it turns out like to look like randy\\\'s. Which ends up being stored as randy\'s. To correct this, first fix your code, then run the following query: UPDATE table SET fieldname = REPLACE(fieldname,'\\',''); - Original Message - From: "Randy Johnson" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 13, 2001 9:54 AM Subject: apostrophe When a text with an apostrophe in it has a \' in it. How can I fix this? example randy's is stored in the DB as randy\'s thanks Randy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check:
Re: MySql connection failed in browser
Since you say you're new to this stuff, let's start with the very basics. RH7.0, I thought, was done poorly with many bugs. You can download their latest RPM patches from their ftp server which will fix up a lot of these bugs. With MySQL, my advice is to download the latest and greatest RPM directly from their website, not RH's. If you're not going to bother upgrading PHP then don't bother using persistent connections. The next step, once installed/upgraded, check that the server is working ok. Use ps -ef | grep mysql to find out. - Original Message - From: "Tim Czerlinsky" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 15, 2001 6:39 Subject: MySql connection failed in browser Hey everyone, I just went through a new setup of Information Resource Manager scripts under PHP 4.0.1p12-9 that work with MySql 3.23.22-6 under Apache 1.3.125-25, all of this stuff except the Resource Manager come standard with RedHat 7.0. After creating the database for the set of php scripts, I should be able to go right into my web browser and get to the scripts and see all the default screens. I can get to the login screen, but when entering a username and password I get the following: Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in ./irm.inc on line 83 Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in ./irm.inc on line 84 Warning: MySQL: A link to the server could not be established in ./irm.inc on line 84 It just looks like there may be a problem with the php scripts and the link to the mysql database, I've been through all of the config files I could find and have been searching the internet for some type of answer. I'm new to the mysql and php world, so it's all a struggle right now. Anyone have any ideas? (I'm sure it's a pretty simple fix) Thanks, Tim Czerlinsky Customer Support [EMAIL PROTECTED] ___ TechWorks 4030 West Braker Lane, Suite 350 Austin, Texas 78759-5319 USA 800-688-7466 ___ http://www.techworks.com http://www.techworks.com/ 512-794-8558 FAX Customer Support is available Mon.- Fri. 9:00 AM to 5:30 PM CST 800-933-6113 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: am I alone? (scale)
We've had fairly bad luck with Linux 2.2.X and SMP for any kind of high-end system. The DAC 960 SCSI controllers proved to be fairly problematic in this environment. Sometimes updating the drivers helps. We have a couple of systems that run much better when we do not use one of the CPUs. Just to offer another data point, we've had great luck with SMP Linux 2.2.x and the DAC 960 controller (a Mylex AcceleRAID 352). Debian Potato Linux 2.2.17 SMP, up 134 days. MySQL 3.23.32 up 39 days, Queries/second avg: 753. It's a dual 933 PIII w/2gb ram. No table corruption. We don't even use precompiled binaries ;) Obviously one person's good experience doesn't mean there's not a problem somewhere, but we sure haven't had any trouble, and it's not for lack of hammering on it. -- Pete Harlan [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: connection lost on long-distance connection
Hi, Here is the way I would fix that problem (assuming you're a programmer) write a simple function check_connection(MYSQL **conn) for example. that will issue a query "SELECT NOW()" to mysql, if that query fails that means connection to mySQL has gone away and the function has to reconnects to mySQL, if not then life is good and the function exits without having to do anything else. Now after writing that function, call it right before executing any query in your program. Regards, SC -- Nothing Like the Sun - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
hunting down duplicate entries
We recently moved our hardware inventory database off of access (yay!) over to mysql. During it's days as an access database it aquired a numbered of duplicate entries. In every case (or at least the ones I'm working on) the serial numbers will be the same but likely all other info will be slightly different. One of the records will be basically correct and current, the other faulty. I want to be able to find every case in the database where more than one record shares the same serial number (which is not at present a key feild, but will be once the dupes are removed) so we can look at the records and determine which ones are valid and which ones need to go. Is there a way to this? thanks in advance - Josh "Listen: We are here on Earth to fart around. Don't let anybody tell you any different!" - Kurt Vonnegut Josh Burroughs [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: hunting down duplicate entries
Select serialNo, count(serialNo) serNoCount from table group by serialNo order by 2 desc This will give you a list of all the unique serial numbers in your table. The ones with serNoCount1 are your duplicates. Without the capability to do subselects (yes, we all know...it's coming in the mythical v4!) you'll have to process that list in something like Java or PHP. HTH, Cal http://www.calevans.com -Original Message- From: Josh Burroughs [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 14, 2001 6:48 PM To: [EMAIL PROTECTED] Subject: hunting down duplicate entries We recently moved our hardware inventory database off of access (yay!) over to mysql. During it's days as an access database it aquired a numbered of duplicate entries. In every case (or at least the ones I'm working on) the serial numbers will be the same but likely all other info will be slightly different. One of the records will be basically correct and current, the other faulty. I want to be able to find every case in the database where more than one record shares the same serial number (which is not at present a key feild, but will be once the dupes are removed) so we can look at the records and determine which ones are valid and which ones need to go. Is there a way to this? thanks in advance - Josh "Listen: We are here on Earth to fart around. Don't let anybody tell you any different!" - Kurt Vonnegut Josh Burroughs [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: hunting down duplicate entries
On Wed, Mar 14, 2001 at 03:48:28PM -0900, Josh Burroughs wrote: We recently moved our hardware inventory database off of access (yay!) over to mysql. During it's days as an access database it aquired a numbered of duplicate entries. In every case (or at least the ones I'm working on) the serial numbers will be the same but likely all other info will be slightly different. One of the records will be basically correct and current, the other faulty. I want to be able to find every case in the database where more than one record shares the same serial number (which is not at present a key feild, but will be once the dupes are removed) so we can look at the records and determine which ones are valid and which ones need to go. Is there a way to this? Try select id, count(*) as mycnt from usedtobeaccesstable group by id having mycnt1 order by mycnt; -- The Moon is Waning Gibbous (69% of Full) nieuw.nl - 2dehands.nl - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: connection lost on long-distance connection
well, i use mysql_query as ported from libmysql.dll function mysql_query(_mysql:pmysql;const query: pchar):integer;stdcall;external 'libmysql.dll'; this function is supposed to return non-zero on failure and zero on succeed ( includes select/update/delete/insert/show etc.etc). This function behaves entirely normal. Until being idle for a while. The function then fails after first attempt to connect. But why? i haven't got any sql error. So i tested with the console client. Both win32 and linux clients behave the same. Unfortunately i can only test on a win32 server at "long" distance, but in fact i'd espect a linux server to behave the same (since i didn't notice any real difference before) Normally you'd expect them in the status "ERROR 2006: MySQL server has gone away No connection. Trying to reconnect..." However, i got: "ERROR 2013: Lost connection to MySQL server during query" Both client and server think the connection is active, but for one reason or another they fail. in the server's processlist you'll see the anomalial client for a while. The client just reconnects using a new socket resource. So, i can test if the function succeeds, i could test if had a reconnection error, but: why should i test if the function is supposed to reconnect by itself... and then fails ??? imho the result should be false because: - the server is really unavailable or: - the query is invalid. however it's not only libmysql.dll that suffers from this problem, it's also the (original) client... regards, rene - Original Message - From: "Boulat Khakimov" [EMAIL PROTECTED] To: "Ren Tegel" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, March 15, 2001 1:11 AM Subject: Re: connection lost on long-distance connection Hi, Here is the way I would fix that problem (assuming you're a programmer) write a simple function check_connection(MYSQL **conn) for example. that will issue a query "SELECT NOW()" to mysql, if that query fails that means connection to mySQL has gone away and the function has to reconnects to mySQL, if not then life is good and the function exits without having to do anything else. Now after writing that function, call it right before executing any query in your program. Regards, SC -- Nothing Like the Sun - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 connection failed in browser
I've been running Redhat 7.0 for 5 months now on my production server, haven't had any trouble with it. I had trouble with the rpms for 3.23.34 that were on mysql.com's download page. The server was getting intermittent signal 11's with blown stacks. I assume a shared library mismatch. My guess is that it was due to some incompatibility with RH 7.0 as I hear the rpms on mysql.com are built against RH 6.2. I reverted back to 3.23.32 from redhat.com's updates ftp area for 7.0 and it worked fine. To be honest, I don't really know what was causing the signal 11's. They were intermittent and thus hard to track down. Is anyone out there running the 3.23.34 rpms from mysql.com on RH 7.0 successfully (under load)? ...without getting signal 11's? If so, then I'm wrong and it was something else. -bill At 08:06 AM 3/15/2001 +0800, Rolf Hopkins wrote: Since you say you're new to this stuff, let's start with the very basics. RH7.0, I thought, was done poorly with many bugs. You can download their latest RPM patches from their ftp server which will fix up a lot of these bugs. With MySQL, my advice is to download the latest and greatest RPM directly from their website, not RH's. If you're not going to bother upgrading PHP then don't bother using persistent connections. The next step, once installed/upgraded, check that the server is working ok. Use ps -ef | grep mysql to find out. - Original Message - From: "Tim Czerlinsky" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 15, 2001 6:39 Subject: MySql connection failed in browser Hey everyone, I just went through a new setup of Information Resource Manager scripts under PHP 4.0.1p12-9 that work with MySql 3.23.22-6 under Apache 1.3.125-25, all of this stuff except the Resource Manager come standard with RedHat 7.0. After creating the database for the set of php scripts, I should be able to go right into my web browser and get to the scripts and see all the default screens. I can get to the login screen, but when entering a username and password I get the following: Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in ./irm.inc on line 83 Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in ./irm.inc on line 84 Warning: MySQL: A link to the server could not be established in ./irm.inc on line 84 It just looks like there may be a problem with the php scripts and the link to the mysql database, I've been through all of the config files I could find and have been searching the internet for some type of answer. I'm new to the mysql and php world, so it's all a struggle right now. Anyone have any ideas? (I'm sure it's a pretty simple fix) Thanks, Tim Czerlinsky Customer Support [EMAIL PROTECTED] ___ TechWorks 4030 West Braker Lane, Suite 350 Austin, Texas 78759-5319 USA 800-688-7466 ___ http://www.techworks.com http://www.techworks.com/ 512-794-8558 FAX Customer Support is available Mon.- Fri. 9:00 AM to 5:30 PM CST 800-933-6113 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Example DAO (not ADO)
Please example DAO!! ADO When you are coding with the ADO API and MyODBC you need to put attention in some default properties that aren't supported by the MySQL server. For example, using the CursorLocation Property as adUseServer will return for the RecordCount Property a result of -1. To have the right value, you need to set this property to adUseClient, like is showing in the VB code below: Dim myconn As New ADODB.Connection Dim myrs As New Recordset Dim mySQL As String Dim myrows As Long myconn.Open "DSN=MyODBCsample" mySQL = "SELECT * from user" myrs.Source = mySQL Set myrs.ActiveConnection = myconn myrs.CursorLocation = adUseClient myrs.Open myrows = myrs.RecordCount myrs.Close myconn.Close
Data tool
I want to load data to mysql. Does mysql has any tools like sqlload in oracle? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Very (excruciatingly) slow select
Hi Hannes Several approaches to achieve your work. One is upgrade your resource i.e. CPU, memory... I do not take this. Another is check all columns used inside WHERE clause whether they are indexed. If not, pls create indexes for them. it will definitely smooth better. Programmatically, I suggest you try to divide your query into several small queries. According to your query below, you are likely to join about 10 tables. As data grows, join those tables will produce undetermined large set of data. Tony -Original Message- From: Hannes Wyss [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 14, 2001 6:29 PM To: [EMAIL PROTECTED] Subject:Very (excruciatingly) slow select Hi List, I'm new to the list and I have a BrainTeaser for all of you. I have yet lots to learn about sql and mySQL so any suggestions are very welcome! Thanx in advance Hannes I have following select over a Database that I cannot setup myself, but have to take on as is: SELECT COMP.CompKey, COMP.NameLong, COMP.Internet, COMP.EMAIL, ACCOMP.Phar, ACCOMP.CompKey, ACCOMP.Role, AC.Phar, AC.IKSCat, AC.GenericCode, AC.InsCode, AC.GrdFrCode, AC.WWW, AC.NumOfPce, AC.SaleCode, ACMED.Phar, ACMED.ATCKey, ACMED.FormCode, ACNAM.Phar, ACNAM.LangCode, ACNAM.Name50, ACSC.Phar, ACSC.StoLNr, ACSC.StoKeyG, ACSC.Quantity, ACSC.QuantityUnit, ACSC.CodeWHK, SC.StoKeyG, SC.StoName, ACPRICEALG.Phar, ACPRICEALG.PriceType, ACPRICEALG.Price, CODES.CodeType, CODES.CodeValue, CODES.LangCode, CODES.CodeDesc AS GalenicForm, CLASS.CodeType, CLASS.CodeValue, CLASS.LangCode, CLASS.CodeDesc AS ATCClass FROM AC, ACMED, ACNAM, ACCOMP, COMP, ACSC, SC, ACPRICEALG, CODES, CODES AS CLASS WHERE COMP.NameLong LIKE 'Here Come the SearchTerms%' ANDACCOMP.CompKey=COMP.CompKey ANDACCOMP.Role='H' ANDAC.Phar=ACCOMP.Phar ANDAC.SaleCode!='H' ANDACMED.Phar=ACCOMP.Phar ANDACNAM.Phar=ACCOMP.Phar ANDACNAM.LangCode='D' ANDACSC.Phar=ACCOMP.Phar ANDACSC.CodeWHK='W' ANDSC.StoKeyG=ACSC.StoKeyG ANDACPRICEALG.Phar=ACMED.Phar ANDACPRICEALG.PriceType='PPUB' ANDCODES.CodeType=5 ANDCODES.CodeValue=ACMED.FormCode ANDCODES.LangCode='D' ANDCLASS.CodeType=3 ANDCLASS.CodeValue=ACMED.ATCKey ANDCLASS.LangCode='D' ORDER BY ACMED.ATCKey, ACPRICEALG.Price, ACMED.Phar, ACSC.StoLNr EXPLAIN says: +-Table--+-Type---+-Possible Keys---+-Key--+-Key-len---+-References---+-Rows---+-Extra--- + +++-+--+---+ --++-+ | COMP | range | PRIMARY,| NameLong | | | 1 | | ||| NameLong| | | || | +++-+--+---+ --++-+ | CLASS | ref| PRIMARY | PRIMARY | 4 | ??? |159 | where used | +++-+--+---+ --++-+ | SC | ALL| PRIMARY | | | | 6710 | | +++-+--+---+ --++-+ | ACSC | ref| PRIMARY,Phar, | StoKeyG | 5 | SC.StoKeyG, | 14 | | ||| StoKeyG | | | W || | +++-+--+---+ --++-+ | ACCOMP | eq_ref | PRIMARY,CompKey | PRIMARY | 9 | ACSC.Phar, | 1 | where used | ||| | | | COMP.CompKey,|| | ||| | | | H || | +++-+--+---+ --++-+ | AC | eq_ref | PRIMARY | PRIMARY | 4 | ACCOMP.Phar | 1 | where used | +++-+--+---+ --++-+ | ACNAM | eq_ref | PRIMARY | PRIMARY | 5 | ACCOMP.Phar, | 1 | where used | ||| | | | D || | +++-+--+---+ --++-+ | ACMED | eq_ref | PRIMARY,ATCKey | PRIMARY | 4 | ACCOMP.Phar | 1 | where used | +++-+--+---+ --++-+ | CODES | range | PRIMARY | PRIMARY | | |178 | | +++-+--+---+ --++-+ |
RE: Very (excruciatingly) slow select
One more suggestion is, using LIKE to search (whatever your column is indexed or not) is definitely slow than using "=". I try it in 0.38 M records before. -Original Message- From: Tony Shiu [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 15, 2001 11:21 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject:RE: Very (excruciatingly) slow select Hi Hannes Several approaches to achieve your work. One is upgrade your resource i.e. CPU, memory... I do not take this. Another is check all columns used inside WHERE clause whether they are indexed. If not, pls create indexes for them. it will definitely smooth better. Programmatically, I suggest you try to divide your query into several small queries. According to your query below, you are likely to join about 10 tables. As data grows, join those tables will produce undetermined large set of data. Tony -Original Message- From: Hannes Wyss [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 14, 2001 6:29 PM To: [EMAIL PROTECTED] Subject:Very (excruciatingly) slow select Hi List, I'm new to the list and I have a BrainTeaser for all of you. I have yet lots to learn about sql and mySQL so any suggestions are very welcome! Thanx in advance Hannes I have following select over a Database that I cannot setup myself, but have to take on as is: SELECT COMP.CompKey, COMP.NameLong, COMP.Internet, COMP.EMAIL, ACCOMP.Phar, ACCOMP.CompKey, ACCOMP.Role, AC.Phar, AC.IKSCat, AC.GenericCode, AC.InsCode, AC.GrdFrCode, AC.WWW, AC.NumOfPce, AC.SaleCode, ACMED.Phar, ACMED.ATCKey, ACMED.FormCode, ACNAM.Phar, ACNAM.LangCode, ACNAM.Name50, ACSC.Phar, ACSC.StoLNr, ACSC.StoKeyG, ACSC.Quantity, ACSC.QuantityUnit, ACSC.CodeWHK, SC.StoKeyG, SC.StoName, ACPRICEALG.Phar, ACPRICEALG.PriceType, ACPRICEALG.Price, CODES.CodeType, CODES.CodeValue, CODES.LangCode, CODES.CodeDesc AS GalenicForm, CLASS.CodeType, CLASS.CodeValue, CLASS.LangCode, CLASS.CodeDesc AS ATCClass FROM AC, ACMED, ACNAM, ACCOMP, COMP, ACSC, SC, ACPRICEALG, CODES, CODES AS CLASS WHERE COMP.NameLong LIKE 'Here Come the SearchTerms%' ANDACCOMP.CompKey=COMP.CompKey ANDACCOMP.Role='H' ANDAC.Phar=ACCOMP.Phar ANDAC.SaleCode!='H' ANDACMED.Phar=ACCOMP.Phar ANDACNAM.Phar=ACCOMP.Phar ANDACNAM.LangCode='D' ANDACSC.Phar=ACCOMP.Phar ANDACSC.CodeWHK='W' ANDSC.StoKeyG=ACSC.StoKeyG ANDACPRICEALG.Phar=ACMED.Phar ANDACPRICEALG.PriceType='PPUB' ANDCODES.CodeType=5 ANDCODES.CodeValue=ACMED.FormCode ANDCODES.LangCode='D' ANDCLASS.CodeType=3 ANDCLASS.CodeValue=ACMED.ATCKey ANDCLASS.LangCode='D' ORDER BY ACMED.ATCKey, ACPRICEALG.Price, ACMED.Phar, ACSC.StoLNr EXPLAIN says: +-Table--+-Type---+-Possible Keys---+-Key--+-Key-len---+-References---+-Rows---+-Extra--- + +++-+--+---+ --++-+ | COMP | range | PRIMARY,| NameLong | | | 1 | | ||| NameLong| | | || | +++-+--+---+ --++-+ | CLASS | ref| PRIMARY | PRIMARY | 4 | ??? |159 | where used | +++-+--+---+ --++-+ | SC | ALL| PRIMARY | | | | 6710 | | +++-+--+---+ --++-+ | ACSC | ref| PRIMARY,Phar, | StoKeyG | 5 | SC.StoKeyG, | 14 | | ||| StoKeyG | | | W || | +++-+--+---+ --++-+ | ACCOMP | eq_ref | PRIMARY,CompKey | PRIMARY | 9 | ACSC.Phar, | 1 | where used | ||| | | | COMP.CompKey,|| | ||| | | | H || | +++-+--+---+ --++-+ | AC | eq_ref | PRIMARY | PRIMARY | 4 | ACCOMP.Phar | 1 | where used | +++-+--+---+ --++-+ | ACNAM | eq_ref | PRIMARY | PRIMARY | 5 | ACCOMP.Phar, | 1 | where used | ||| | | | D || | +++-+--+---+ --++-+ | ACMED | eq_ref | PRIMARY,ATCKey | PRIMARY
connecting Microsoft Access to MySQL
The "trick" is that while an autoincrement field is a nice thing to have as a primary key, is to put a timestamp field in each MySQL table (in addition to the primary key). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Failover and Replication
On Wed, Mar 14, 2001 at 09:10:42AM -0800, Bryan Coon wrote: We are implementing a linux cluster, and rather than get gouged by oracle (in performance and licensing) would much rather use MySQL. A common solution to a common problem, I suspect. If I understand correctly, replication creates a working copy of mysql on another server, but it looks like the algorithm to automatically change slave to master if the master dies will not be added until mysql 4.x (from 11.4 in the manual). Right. Is this still the case? Yes. Does anyone have any stories/suggestions/experiences in regards to rolling our own monitoring script? What about having a dual-master setup? It's a bit tricky to get right, but it certainly can work. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 takes too much memory
On Wed, Mar 14, 2001 at 03:44:34PM +0700, Mohamad Ilhami wrote: Hi, after a few days, mysql take too much memory and sometimes causing swap memory exhausts. I'm sure that only one client accessing mysql server, but I see too many threads. So I shutdown MySQL periodically. I use mysql-large.cnf configuration file. If the client was killed by KILL signal, or terminated unexpectly, does mySQL thread exit automatically? Any one have suggestion? Well, try decreasing some of the values in your my.cnf file so that they more closely match the amount of memory you're willing to let MySQL use. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
limiting, sql question
Hello, I have one SQL question: I do: SELECT geo_continents.name, geo_countries.name from geo_continents, geo_countries WHERE geo_continents.id=geo_countries.continent; what gives me: +---++ | name | name | +---++ | Asia | Afghanistan| | Asia | Armenia| | Asia | Azerbaijan | | Asia | Bahrain| | Asia | Bangladesh | . tra la la | Europe| Switzerland| | Europe| Ukraine| | Europe| United Kingdom | | Europe| Vatican City State | . tra la la | North America | Antigua And Barbuda| | North America | Bahamas| | North America | Barbados | +---++ How do I construct a query which would output me continent name only once, having all the rest empty. something like this: +---++ | name | name | +---++ | Asia | Afghanistan| || Armenia| || Azerbaijan | || Bahrain| || Bangladesh | . tra la la | Europe| Switzerland| | | Ukraine| | | United Kingdom | | | Vatican City State | . tra la la | North America | Antigua And Barbuda| || Bahamas| || Barbados | +---++ Any way to do it with mySQL 3.22.xx? what about 3.23.xx ? Can one field be LIMITed and another not? I would like it to minimize the amount of data sent. (in the soft. this query will repeat itself quite a bit of times) P.S: sorry if the question is too stupid, but my 'SQL skills' are far not perfect. Thanks in advance, Maxim Maletsky - [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Webmaster, J-Door.com / J@pan Inc. LINC Media, Inc. TEL: 03-3499-2175 x 1271 FAX: 03-3499-3109 http://www.j-door.com http://www.j-door.com/ http://www.japaninc.net http://www.japaninc.net/ http://www.lincmedia.co.jp http://www.lincmedia.co.jp/
MySQL make install problem.
I configured and compiled mysql-3.23.34a without even a warning: ./configure --prefix=/usr/local/mysql-3.23.34a make but when I do a make install I get errors listed below. I included the mysqlbug output if needed below that. I dont know what the install is trying to do here (newbie :). I have made sure that mysql wasnt already installed (rpm -qa|grep mysql ). Anyone have any clues? TIA! Eric Making install in sql-bench make[1]: Entering directory `/usr/local/mysql-3.23.34a/sql-bench' make[2]: Entering directory `/usr/local/mysql-3.23.34a/sql-bench' make[2]: Nothing to be done for `install-exec-am'. /bin/sh ../mkinstalldirs /usr/local/mysql-3.23.34a/sql-bench /usr/bin/install -c test-ATIS /usr/local/mysql-3.23.34a/sql-bench/test-ATIS /usr/bin/install: `test-ATIS' and `/usr/local/mysql-3.23.34a/sql-bench/test-ATIS' are the same file /usr/bin/install -c test-connect /usr/local/mysql-3.23.34a/sql-bench/test-connect /usr/bin/install: `test-connect' and `/usr/local/mysql-3.23.34a/sql-bench/test-connect' are the same file /usr/bin/install -c test-create /usr/local/mysql-3.23.34a/sql-bench/test-create /usr/bin/install: `test-create' and `/usr/local/mysql-3.23.34a/sql-bench/test-create' are the same file /usr/bin/install -c test-insert /usr/local/mysql-3.23.34a/sql-bench/test-insert /usr/bin/install: `test-insert' and `/usr/local/mysql-3.23.34a/sql-bench/test-insert' are the same file /usr/bin/install -c test-big-tables /usr/local/mysql-3.23.34a/sql-bench/test-big-tables /usr/bin/install: `test-big-tables' and `/usr/local/mysql-3.23.34a/sql-bench/test-big-tables' are the same file /usr/bin/install -c test-select /usr/local/mysql-3.23.34a/sql-bench/test-select /usr/bin/install: `test-select' and `/usr/local/mysql-3.23.34a/sql-bench/test-select' are the same file /usr/bin/install -c test-wisconsin /usr/local/mysql-3.23.34a/sql-bench/test-wisconsin /usr/bin/install: `test-wisconsin' and `/usr/local/mysql-3.23.34a/sql-bench/test-wisconsin' are the same file /usr/bin/install -c test-alter-table /usr/local/mysql-3.23.34a/sql-bench/test-alter-table /usr/bin/install: `test-alter-table' and `/usr/local/mysql-3.23.34a/sql-bench/test-alter-table' are the same file /usr/bin/install -c bench-init.pl /usr/local/mysql-3.23.34a/sql-bench/bench-init.pl /usr/bin/install: `bench-init.pl' and `/usr/local/mysql-3.23.34a/sql-bench/bench-init.pl' are the same file /usr/bin/install -c compare-results /usr/local/mysql-3.23.34a/sql-bench/compare-results /usr/bin/install: `compare-results' and `/usr/local/mysql-3.23.34a/sql-bench/compare-results' are the same file /usr/bin/install -c run-all-tests /usr/local/mysql-3.23.34a/sql-bench/run-all-tests /usr/bin/install: `run-all-tests' and `/usr/local/mysql-3.23.34a/sql-bench/run-all-tests' are the same file /usr/bin/install -c server-cfg /usr/local/mysql-3.23.34a/sql-bench/server-cfg /usr/bin/install: `server-cfg' and `/usr/local/mysql-3.23.34a/sql-bench/server-cfg' are the same file /usr/bin/install -c crash-me /usr/local/mysql-3.23.34a/sql-bench/crash-me /usr/bin/install: `crash-me' and `/usr/local/mysql-3.23.34a/sql-bench/crash-me' are the same file /usr/bin/install -c copy-db /usr/local/mysql-3.23.34a/sql-bench/copy-db /usr/bin/install: `copy-db' and `/usr/local/mysql-3.23.34a/sql-bench/copy-db' are the same file make[2]: *** [install-benchSCRIPTS] Error 1 make[2]: Leaving directory `/usr/local/mysql-3.23.34a/sql-bench' make[1]: *** [install-am] Error 2 make[1]: Leaving directory `/usr/local/mysql-3.23.34a/sql-bench' make: *** [install-recursive] Error 1 SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). SEND-PR: From: root To: [EMAIL PROTECTED] Subject: [50 character or so descriptive subject here (for reference)] Description: precise description of the problem (multiple lines) How-To-Repeat: code/input/activities to reproduce the problem (multiple lines) Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: submitter ID Originator:root Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-@VERSION@@MYSQL_SERVER_SUFFIX@ (@COMPILATION_COMMENT@) Environment: machine, os, target, libraries (multiple lines) System: Linux cancerman.home.com 2.2.17-21mdk #1 Thu Oct 5 13:16:08 CEST 2000 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i586-mandrake-linux/2.95.3/specs gcc version 2.95.3 19991030 (prerelease) Compilation info:
koi8_ru question
Hello list! The question should be simple. Does koi8_ru stands for koi8 RUssian or is it koi8 Russian/Ukrainian. The reason I am asking is that I remember the days when RU was used for letter. But it does not seem to support Ukrainian characters. I could use koi8_ukr but I do not know if it will sort Russian characters correctly. So far I changed koi8_ru.conf to support Ukrainian, Russian and Belorussian (all, but short U for Belorussian, because I do not know where it is in a sorting order) characters. But I afraid my provider will not patch MySQL just for me. Regards, Serhiy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 make install problem.
Yes, The prefix path I used below is the path to the source distribution. Should it not be? Eric Mohamad Ilhami wrote: On Wed, 14 Mar 2001, Eric Morgan wrote: I configured and compiled mysql-3.23.34a without even a warning: ./configure --prefix=/usr/local/mysql-3.23.34a Is Mysql binary installation directory (indicated by prefix) same with MySQL source code ? make but when I do a make install I get errors listed below. I included the mysqlbug output if needed below that. I dont know what the install is trying to do here (newbie :). I have made sure that mysql wasnt already installed (rpm -qa|grep mysql ). Anyone have any clues? TIA! Eric Making install in sql-bench make[1]: Entering directory `/usr/local/mysql-3.23.34a/sql-bench' make[2]: Entering directory `/usr/local/mysql-3.23.34a/sql-bench' make[2]: Nothing to be done for `install-exec-am'. /bin/sh ../mkinstalldirs /usr/local/mysql-3.23.34a/sql-bench /usr/bin/install -c test-ATIS /usr/local/mysql-3.23.34a/sql-bench/test-ATIS /usr/bin/install: `test-ATIS' and `/usr/local/mysql-3.23.34a/sql-bench/test-ATIS' are the same file /usr/bin/install -c test-connect /usr/local/mysql-3.23.34a/sql-bench/test-connect /usr/bin/install: `test-connect' and `/usr/local/mysql-3.23.34a/sql-bench/test-connect' are the same file /usr/bin/install -c test-create /usr/local/mysql-3.23.34a/sql-bench/test-create /usr/bin/install: `test-create' and `/usr/local/mysql-3.23.34a/sql-bench/test-create' are the same file /usr/bin/install -c test-insert /usr/local/mysql-3.23.34a/sql-bench/test-insert /usr/bin/install: `test-insert' and `/usr/local/mysql-3.23.34a/sql-bench/test-insert' are the same file /usr/bin/install -c test-big-tables /usr/local/mysql-3.23.34a/sql-bench/test-big-tables /usr/bin/install: `test-big-tables' and `/usr/local/mysql-3.23.34a/sql-bench/test-big-tables' are the same file /usr/bin/install -c test-select /usr/local/mysql-3.23.34a/sql-bench/test-select /usr/bin/install: `test-select' and `/usr/local/mysql-3.23.34a/sql-bench/test-select' are the same file /usr/bin/install -c test-wisconsin /usr/local/mysql-3.23.34a/sql-bench/test-wisconsin /usr/bin/install: `test-wisconsin' and `/usr/local/mysql-3.23.34a/sql-bench/test-wisconsin' are the same file /usr/bin/install -c test-alter-table /usr/local/mysql-3.23.34a/sql-bench/test-alter-table /usr/bin/install: `test-alter-table' and `/usr/local/mysql-3.23.34a/sql-bench/test-alter-table' are the same file /usr/bin/install -c bench-init.pl /usr/local/mysql-3.23.34a/sql-bench/bench-init.pl /usr/bin/install: `bench-init.pl' and `/usr/local/mysql-3.23.34a/sql-bench/bench-init.pl' are the same file /usr/bin/install -c compare-results /usr/local/mysql-3.23.34a/sql-bench/compare-results /usr/bin/install: `compare-results' and `/usr/local/mysql-3.23.34a/sql-bench/compare-results' are the same file /usr/bin/install -c run-all-tests /usr/local/mysql-3.23.34a/sql-bench/run-all-tests /usr/bin/install: `run-all-tests' and `/usr/local/mysql-3.23.34a/sql-bench/run-all-tests' are the same file /usr/bin/install -c server-cfg /usr/local/mysql-3.23.34a/sql-bench/server-cfg /usr/bin/install: `server-cfg' and `/usr/local/mysql-3.23.34a/sql-bench/server-cfg' are the same file /usr/bin/install -c crash-me /usr/local/mysql-3.23.34a/sql-bench/crash-me /usr/bin/install: `crash-me' and `/usr/local/mysql-3.23.34a/sql-bench/crash-me' are the same file /usr/bin/install -c copy-db /usr/local/mysql-3.23.34a/sql-bench/copy-db /usr/bin/install: `copy-db' and `/usr/local/mysql-3.23.34a/sql-bench/copy-db' are the same file make[2]: *** [install-benchSCRIPTS] Error 1 make[2]: Leaving directory `/usr/local/mysql-3.23.34a/sql-bench' make[1]: *** [install-am] Error 2 make[1]: Leaving directory `/usr/local/mysql-3.23.34a/sql-bench' make: *** [install-recursive] Error 1 SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). SEND-PR: From: root To: [EMAIL PROTECTED] Subject: [50 character or so descriptive subject here (for reference)] Description: precise description of the problem (multiple lines) How-To-Repeat: code/input/activities to reproduce the problem (multiple lines) Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id:submitter ID Originator: root Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis:synopsis of the problem (one line) Severity:[ non-critical | serious | critical ] (one line) Priority:[ low | medium | high ] (one line) Category:mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: