Re: state: reading from net
Very "erstaunlich"! I really didn't thought that! I think we all could live without(!) such answers. Who reads from the network? The client or the server? And if the client, why does it read from the net after the SQL-Statement is already completed? Is there anybody who has an answer with more information than that of Mr. Zawodny? Thank you Manfred Meier [EMAIL PROTECTED] "Jeremy D. Zawodny" schrieb: On Fri, Feb 02, 2001 at 08:12:23AM +0100, Manfred Meier wrote: Hello, does anybody know what "Reading from net" means in the "State" column of the output of mysqladmin processlist? I've always assumed that it means "I'm reading data from the network". 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Install My-SQL on an NT
At 08:37 02/02/2001 +0100, Lars-Olof Albertson wrote: Hi, Maybe you had an ancient distribution stuff. The best thing to make is the download of the last version at: http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.32-win.zip Remove the MySQL installation using the Control Panel Add/Remove Programs. Unpacked on temporary directory the zip file of the 3.23.32 stuff. Run the setup file, accepting the defaults options. On NT machine the best option to run the MySQL server is as service: c:\mysql\bin\mysqld-nt --install Now start the server: net start mysql Now, using the Win Explorer open the MySQL Manual at: c:\mysql\docs\Manual.html. Regards, Miguel Hello, I am new to the list and new to My-SQL. I want to test My-SQL on my NT, but have trubble to get it to work. I have downloaded the shareware release of MySQL for Win32 and installed it. According to the manual I should use "C:\mysql\bin\mysqld-nt" to start the server, but there is no file mysqld-nt in the bin folder. Where can I get the file mysqld-nt or should I do other things to get it to work. The rest I hope to find out with help of "Sams Teach youself MySQL in 21 Days" Thanks for your help Lars-Olof Albertson -- Lars-Olof Albertson FormOnLine AB Ragnar Lodbroks gr 17 S-224 75 Lund Sweden Telephone 046-39 93 32 Mobil 070-636 76 93 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solrzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ So Paulo, Brazil ___/ Development Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: state: reading from net
On Fri, Feb 02, 2001 at 09:11:39AM +0100, Manfred Meier wrote: Who reads from the network? The client or the server? They both do, really. The server reads the request and the client reads the response. In this case, though, you are looking at the status of various connections from the server's point of view, right? 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
Fw: MyODBC Error
Hi again, I solved the weird thing but the original myODBC error is still there. How do I know what values are suitable for my application. I'm using MediumBlob to store my data so at any one time, the max amount of data to insert would be 16M. So am I supposed to set max_allowed_packet to 16M, and if so, how much should I set the key_buffer_size to. The key read/key read request = approx 0.3969 and the key write/key write request = approx. 0.666. I don't really know what this means but the manual says it should be 0.01. Currently the variables are set as followed: [mysqld] set-variable = key_buffer_size=16M set-variable = max_allowed_packet=1M As I have mentioned earlier, I couldn't even get 1MB through. Any idea anyone? Thanks, Li Sze - Original Message - From: Li Sze [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 02, 2001 4:35 PM Subject: Re: MyODBC Error, SQLGetData Hi, Thanks Miguel, I'll look through the manual. Another weird thing came up while I was testing the following code. The cbData in the following line of code always turns up as 8164. Previously, the cbData will indicate the size of the data to be retrieved. -- -- --- g_rc = SQLGetData(hstmt, 11, SQL_C_BINARY, theVersions.byData, n, cbData); if (g_rc == SQL_ERROR) ProcessLogMessages(SQL_HANDLE_STMT, hstmt, "SQLGetData() Failed\n\n", TRUE); while (g_rc == SQL_SUCCESS_WITH_INFO || g_rc == SQL_SUCCESS) { if (cbData (SDWORD) n) { if (::WriteFile(hFile, theVersions.byData, n, dwWriteSize, NULL) == 0) { dwFileIOError = ::GetLastError(); TRACE("WriteFile error: %d\n", dwFileIOError); } } else { if (::WriteFile(hFile, theVersions.byData, cbData, dwWriteSize, NULL) == 0) { dwFileIOError = ::GetLastError(); TRACE("WriteFile error: %d\n", dwFileIOError); } } g_rc = SQLGetData(hstmt, 11, SQL_C_BINARY, theVersions.byData, n, cbData); if (g_rc == SQL_ERROR) ProcessLogMessages(SQL_HANDLE_STMT, hstmt, "SQLGetData() Failed\n\n", TRUE); } -- -- --- As I did not change anything, I'm really confused why it became constant. Even files that I've successfully tried retrieving yesterday doesn't work anymore. Li Sze - Original Message - From: Miguel Angel Solrzano [EMAIL PROTECTED] To: Li Sze [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, February 02, 2001 1:41 PM Subject: Re: MyODBC Error At 12:23 02/02/2001 +0800, Li Sze wrote: Hi, Try to use the variables below in your my.cnf file: [mysqld] set-variable = key_buffer_size=16M set-variable = max_allowed_packet=1M Set the values according with your necessities and read in the MySQL Manual the item Tuning server parameters. Regards, Miguel Hi, I'm using SQLPutData and SQLParamData to insert data into the database. It works fine with data files smaller than 1MB. However, I get the following error for the last call to SQLParamData when the data file is more than 1MB. I have no idea what the following error means. I would really appreciate it if someone could tell me what went wrong or if I need to include more information about this problem. Thanks in advance. The following is the trace log from myodbc. --- - myMFC fff63add:fff7fe09 ENTER SQLPutData HSTMT 0x00891258 PTR0x01710004 SDWORD 64974 myMFC fff63add:fff7fe09 EXIT SQLPutData with return code 0 (SQL_SUCCESS) HSTMT 0x00891258 PTR0x01710004 SDWORD 64974 myMFC fff63add:fff7fe09 ENTER SQLParamData HSTMT 0x00891258 PTR * 0x0066eb78 myMFC fff63add:fff7fe09 EXIT SQLParamData with return code -1 (SQL_ERROR) HSTMT 0x00891258 PTR * 0x0066eb78 DIAG [HY000] [TCX][MyODBC]MySQL server has gone away (2006) --- - Regards, Li Sze __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solrzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ So Paulo, Brazil ___/ Development Team - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED]
Re: Serious MySQL internal deadlock
On 01-Feb-2001 Sinisa Milivojevic wrote: HI! Most probably processes are waiting for the slave to get updated. To circumvent the problem, you should : - use our binary (if possible) - avoid LOCK TABLES, which truly is necessary only in some rare cases Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team Definitely not a replication problem. Just happened again (see attachment) with table locks removed (see my earlier mails). I then stopped the slave dbs and killed the associated threads on the master. What you can easily see is that the problem still persists. The database is locked for good. This is where the fun really starts. When you kill all the threads (the log daemons do recognize this and reconnect) *ALL* threads are in state system lock (see second attachment). This clearly means to me that the database lock handling is corrupted. Andreas Steinmetz D.O.M. Datenverarbeitung GmbH Id UserHostdb Command TimeState Info 226 logdaemon 10.1.1.6syslog Killed 64 System lock INSERT INTO pcp (time,host,c pu_user,cpu_nice,cpu_sys,cpu_idle,mem_used,mem_free,mem_shared,mem_cache 448 logdaemon 10.1.1.3syslog Query 64 System lock INSERT INTO pcp (time,host,cp u_user,cpu_nice,cpu_sys,cpu_idle,mem_used,mem_free,mem_shared,mem_cache 449 logdaemon 10.1.1.4syslog Query 64 System lock INSERT INTO pcp (time,host,cp u_user,cpu_nice,cpu_sys,cpu_idle,mem_used,mem_free,mem_shared,mem_cache 450 logdaemon 10.1.1.7syslog Query 64 System lock INSERT INTO pcp (time,host,cp u_user,cpu_nice,cpu_sys,cpu_idle,mem_used,mem_free,mem_shared,mem_cache 451 logdaemon 10.1.1.2syslog Query 53 System lock INSERT INTO ipchains (time,ho st,interface,proto,src_ip,src_port,dst_ip,dst_port,length,tos,id,frag_o 452 logdaemon localhost syslog Query 51 System lock INSERT INTO pcp (time,host,c pu_user,cpu_nice,cpu_sys,cpu_idle,mem_used,mem_free,mem_shared,mem_cache 453 dbmasterlocalhost NULLQuery 0 NULLshow processlist Id UserHostdb Command TimeState Info 223 logdaemon 10.1.1.7syslog Query 358 Opening table INSERT INTO pcp (time,host ,cpu_user,cpu_nice,cpu_sys,cpu_idle,mem_used,mem_free,mem_shared,mem_cache 224 logdaemon 10.1.1.4syslog Query 417 Opening table INSERT INTO pcp (time,host ,cpu_user,cpu_nice,cpu_sys,cpu_idle,mem_used,mem_free,mem_shared,mem_cache 225 logdaemon 10.1.1.3syslog Query 402 Opening table INSERT INTO pcp (time,host ,cpu_user,cpu_nice,cpu_sys,cpu_idle,mem_used,mem_free,mem_shared,mem_cache 226 logdaemon 10.1.1.6syslog Query 415 Opening table INSERT INTO pcp (time,host ,cpu_user,cpu_nice,cpu_sys,cpu_idle,mem_used,mem_free,mem_shared,mem_cache 227 logdaemon 10.1.1.2syslog Query 1279System lock INSERT INTO ipchains (time, host,interface,proto,src_ip,src_port,dst_ip,dst_port,length,tos,id,frag_o 228 logdaemon localhost syslog Query 635 System lock INSERT INTO ipchains (time, host,interface,proto,src_ip,src_port,dst_ip,dst_port,length,tos,id,frag_o 437 logreader 10.1.1.4syslog Query 421 Opening tables select src_ip,count(src_i p) as val,count(distinct dst_ip) as tot from ipchains where time='20010202 438 system localhost mysql Query 396 Opening tables SELECT User, Select_priv FRO M user where User = 'dbmaster' 444 dbmasterlocalhost NULLQuery 0 NULLshow processlist - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Idea: Automated server tuning?
Hi, Monty mentioned that they're looking at making virtually all of the run-time variables changeable WITHOUT a server restart. Once that happens, it's just a matter of programming and benchmarking to have a self-tuning system (to some degree). I hadn't really thought about the concept in terms of dynamic configuration changes without taking the server down. Sounds great! However, I think if the MySQL developers are thinking about adding some kind of self-tuning on top of dynamic configuration changing, then some heavy thought needs to go into any implementation. Having the server automatically adapt to usage patterns and change it's own config without any kind of control, notice or restarting of the daemon could get sticky. If not implemented right, you might have a situation where MySQL adapts its config wrongly to a prolonged freak period of heavy (or very light) usage which would have trailing repercussions as normal usage is resumed. But, as always, these are problems that can simply (or not so simply) be overcome by good design and programming. It's certainly useful. As soon as I heard about the tunable parameters without a restart, the first thing that jumped to mind was a database tuning application. I'm glad I'm not the only one who's thought of this... :) With dynamic configuration, I now envisage some kind of secondary tuning daemon that runs in parallel to MySQL that continuously tails log files to gather and store commonly used queries as well as regularly taking snapshots of status statistics. It would then periodically analyse the data it's recorded and dynamically make changes it thinks (or rather, to be on the safe side, knows) would make an improvement to common usage. After it has made changes, it would (for while, at least) go into 'sit-back-and-watch' mode, in order to compare performance after the event to what it was before. If it's worse, it dynamically restores the previous config - this might partially avoid the scenario I described earlier. Regards, Basil Hussain ([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
STD function
Hi I'm doing a simple query using the function STD but I'm getting zeros as answer. I know that zero is a perfectly good answer for standart deviation but in this case I should get some positive values :-) Is there something wrong with this function ? My sql string is the folowing and I'm using version 3.22.32. SELECT ROUND(ESTACOES.LAT_I,1) AS LAT, ROUND(ESTACOES.LON_I,1) AS LON, ROUND(AVG(ESTACOES.PROF_I),1) AS PRF, ROUND(AVG(ESTACOES_REC.RECRUTAS),1) AS REC, STD(ESTACOES_REC.RECRUTAS) AS STDEV FROM ESTACOES, ESTACOES_REC WHERE ESTACOES.CRUZEIRO=ESTACOES_REC.CRUZEIRO AND ESTACOES.ESTACAO=ESTACOES_REC.ESTACAO AND ESTACOES.CRUZEIRO!='2420982' GROUP BY LAT,LON Thanks EJ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Support request from Progetto 2000 ID support 4300
Progetto 2000 writes: Hi, I'm trying to install MySQL Client (rpm -i MySQL-client-3.23.29-1.i386.rpm). The MySQL is just installed because if I run the commands: mysql_install_db safe_mysqld The daemon runs. But if I insert a normal command like: "mysqladmin version" the answer is "command not found". I think that this result because the MySQL client is not installed. I downloaded MySQL client RPM I run the command "rpm -i MySQL-client-3.23.29-1.i386.rpm" but the answer is "Error: failed dipendencies: /usr/bin/perl5 is needed by MySQL-client-3.23.29-1 I look into /usr/bin/ and perl5 exist ! What can I do ? Can you help me ? Run: rpm --nodeps Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: myODBC question
John, To avoid the issues you mentioned, each table requires an AUTO_INCREMENT column and a TIMESTAMP(14) column. We have been coding with VC++ and using various third party ODBC clients, including MS Access, pretty much since the inception of MyODBC. When using the Jet Database Engine (MS Access) the ability to recognize uniqueness of a record/row is paramount. Adding the aforementioned columns assures uniqueness. Pat... [EMAIL PROTECTED] - Original Message - From: "John Jensen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 01, 2001 2:40 PM Subject: Re: myODBC question Speaking as one who tried working with such a connection, FORGET IT. While entering data, I might get all or half a record entered when the message arrives telling me the information cannot be posted, because another user was editing that record (which I could tell was simply NOT the case), and I had the option of either dropping my input, or put the whole record in the past buffer. Occasionally, I would get lucky and get a whole record entered and saved, but mostly, my datbase was getting filled with gaps. Get phpMyAdmin. It is far more reliable solution. On 1 Feb 2001, at 12:06, (Mr) Pekka Gaiser wrote: Hi there, A DB newbie question - can I use MS Access for remote mySQL databases using myODBC?? Thanks. John Jensen 520 Goshawk Court Bakersfield, CA 93309 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: HEAP or COMPRESSED ?
David Brown writes: I have a quick lookup table of about 500,000 records. The table consists of just 3 fields medium int fields, and indexed on just one of them - So the records are small, as is the index. The data won't have any inserts/updates throughout the day, and will be built once a day. It's not a problem if the data is lost (server falling over), as it can be rebuilt within 5 mins. I need to get the most screamingly fast performance from the lookup of this table (all selects will be "=" matches using the index) Do I use HEAP tables - benefitting from hashed indexes and always in memory. Or.. Do I use pack_isam and compress a plain ISAM/MyISAM table ? - benefitting from being memory mapped and using less memory (am I right?) There is oodles of spare memory currently (well, about 256MB spare) System specs: Dual P3 750, running BSDI 4.0 and 512Mb RAM Hi! Use HEAP tables and set a cron job to periodically dump a table (with CREATE from SELECT ) to MyISAM table. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Server down with ELT,FIELD Funktion and GROUP BY
Description: When I make a "SELECT count(*) AS Anzahl, ELT(FIELD(kundentyp, ... ), ... ) as Kundentyp,kategorie FROM table WHERE ... GROUP BY kundentyp,kategorie ORDER BY kategorie" the Server response with: mysql SELECT count(*) AS Anzahl, ELT(FIELD(kundentyp,'PP','PPA','PG','PGA','FK','FKA','FP','FPA','K','KA','V','VA',''), 'Privat (Private Nutzung)','Privat (Private Nutzung) Sitz im Ausland','Privat (geschaeftliche Nutzung)','Privat (geschaeftliche Nutzung) Sitz im Ausland','Firma (Kapitalgesellschaft)','Firma (Kapitalgesellschaft) Sitz im Ausland','Firma (Personengesellschaft)','Firma (Personengesellschaft) Sitz im Ausland','oeff. rechtl. Koerperschaft','oeff. rechtl. Koerperschaft Sitz im Ausland','Eingetragener Verein','Eingetragener Verein Sitz im Ausland','Typ unbekannt') AS kundentyp ,kategorie FROM vertragsdaten WHERE hdl_nr 200 AND kategorie IN ('Prepaid','Mobilfunk') AND st_klasse = 'Workflow' GROUP BY Kundentyp,kategorie ORDER BY kategorie; ERROR 2013: Lost connection to MySQL server during query mysql And then the Server restarts itself, but all connections where gone and the clients must reconnect. How-To-Repeat: Here is a dump from the table: --- cut here --- # MySQL dump 8.12 # # Host: localhostDatabase: copy_vertrag # # Server version3.23.32-log # # Table structure for table 'vertragsdaten' # CREATE TABLE vertragsdaten ( cont_nr int(11) NOT NULL auto_increment, ver_nr int(11) NOT NULL default '0', aufnr int(11) NOT NULL default '0', username varchar(50) NOT NULL default '', hdl_nr int(11) NOT NULL default '0', eintrag date NOT NULL default '-00-00', st_klasse varchar(40) NOT NULL default '', st_wert varchar(40) NOT NULL default '', st_zusatz varchar(40) NOT NULL default '', st_bemerkung varchar(255) NOT NULL default '', kunden_art varchar(40) NOT NULL default '', mcbs_knr int(11) default NULL, mcbs_aufnr int(11) NOT NULL default '0', schufa_status char(1) default '?', bemerkung text, wirknetz text, wf_igz int(11) NOT NULL default '0', tarifcode varchar(80) default NULL, recycle char(1) default NULL, sim varchar(30) default NULL, mcbs_tpl varchar(30) default NULL, emp_nr int(11) NOT NULL default '0', laufzeit int(11) default NULL, hdl_name varchar(30) default NULL, prov_hdl_nr int(11) NOT NULL default '0', auto_wirknetz varchar(50) default NULL, auto_billing varchar(50) default NULL, touch timestamp(14) NOT NULL, kategorie varchar(50) default NULL, kundentyp varchar(20) NOT NULL default '', sammel_rech_msisdn varchar(30) NOT NULL default '', p_nr varchar(9) NOT NULL default '', suffix char(3) NOT NULL default '', PRIMARY KEY (cont_nr), KEY idx_aufnr(aufnr), KEY idx_hdl_nr(hdl_nr), KEY idx_st_klasse(st_klasse), KEY ver_nr(ver_nr), KEY eintrag_idx(eintrag), KEY emp_nr_idx(emp_nr), KEY wf_igz(wf_igz), KEY touch(touch), KEY hdl_tag(eintrag,hdl_nr), KEY prov_hdl_nr(prov_hdl_nr), KEY mcbs_aufnr(mcbs_aufnr), KEY kundentyp(kundentyp), KEY p_nr(p_nr,suffix) ) TYPE=MyISAM; # # Dumping data for table 'vertragsdaten' # INSERT INTO vertragsdaten VALUES (3359356,405,3359356,'Mustermann Musterfrau',52500,'2000-05-20','workflow','Auftrag erledigt','Originalvertrag eingegangen und geprüft','','privat',1485525,2122316,'+','','N',1909160,'MobilComSuper92000D2',NULL,NULL,'MS9ND2',3,24,'MobilCom Shop Koeln',52500,NULL,'auto',20010202105916,'Mobilfunk','PP','','',''); INSERT INTO vertragsdaten VALUES (3359357,468,3359357,'Mustermann Musterfrau',7001,'2000-05-20','workflow','Auftrag erledigt','Originalvertrag eingegangen und geprüft','','privat',1503580,2139699,'+','','P',1909171,'MobilComSuper9D1T10SFreisprech(Akquise)',NULL,NULL,'MS9NS1',327,24,'MobilCom Intern',7003,NULL,'auto',20010202105916,'Mobilfunk','PP','','',''); INSERT INTO vertragsdaten VALUES (3359358,407,3359358,'Mustermann Musterfrau',7001,'2000-05-20','workflow','Auftrag erledigt','Originalvertrag eingegangen und geprüft','','privat',1501358,2137473,'N','','N',1909159,'MobilComSuper92000D2',NULL,NULL,'MS9ND2',325,24,'MobilCom Intern',7003,NULL,'auto',20010202105916,'Mobilfunk','PP','','',''); INSERT INTO vertragsdaten VALUES (3359359,468,3359359,'Mustermann Musterfrau',7001,'2000-05-20','workflow','Auftrag erledigt','Originalvertrag eingegangen und geprüft','','privat',1507831,2143894,'+','','P',1909162,'MobilComSuper9D1T10SFreisprech(Akquise)',NULL,NULL,'MS9NS1',327,24,'MobilCom Intern',7003,NULL,'auto',20010202105916,'Mobilfunk','PP','','',''); INSERT INTO vertragsdaten VALUES (3359360,0,0,'Mustermann Musterfrau',29674907,'2000-05-20','workflow','Auftrag erledigt','Originalvertrag eingegangen und geprüft','','privat',1900169997,2414578,'+',NULL,'N',1909148,'',NULL,NULL,'RV99066_2',20,NULL,'POS',29674907,NULL,NULL,20010202105916,'Mobilfunk','','','97317481','007'); INSERT INTO vertragsdaten VALUES (3359361,406,3359361,'Mustermann
How do I move database directories
Hi, I have installed mysql on SuSE Linux from an rpm. It works but I want to move the data directory to a larger disk on my machine. How do I do it?? If I create a symbolic link to the /var/lib/mysql directory, the mysql.sock (don't really understand what this file does) file vanishes and I can't restart the server. If I make a sumbolic link to the actual database sybdirectories, it doesn't see them properly. If I edit the /etc/rc.d/mysql file to change the data directory, the .sock file vanishes again and it won't start. What is the procedure? Howard Miller - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
jsp
First excuse me for my english, I should like of knowing if the mysql ago connection with the jsp, what if if he may do, drop of knowing where I could meet any tutorial, if exist. Thank you by attention. Sara. __ Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
datadir on coda filesystem
Description: The mysql initialisation fails on coda filesystems. Apparently CREATE TABLE creates just the *.frm files, but silently won't create the *.ISM and *ISD, resulting in a subsequent message "ERROR: 1033 Incorrect information in file: './mysql/db.frm'" How-To-Repeat: The problem has been reproduced with both mysql-3.22.32 and current 3.23.32 (the latter with disable-large-files) on SuSE linux 7.0, kernel 2.2.16, glibc2.1.3 starting a freshly installed mysqld with /coda/vol/mysql/libexec/mysqld --bootstrap --skip-grant-tables --basedir=/coda/vol/mysql --datadir=/coda/vol/mysql/var and issuing create table bla (bla int); leads to the strace output below. there is another strace for datadir=/tmp/mysql, which succeeds. I am not deep enough into the mysql sources to understand where exactly the statement fails. Any help, also on where coda might be the cause, is appreciated. Yours, Steffen - starting a freshly installed mysqld with strace /coda/vol/mysql/libexec/mysqld --bootstrap --skip-grant-tables --basedir=/coda/vol/mysql --datadir=/coda/vol/mysql/var create table bla (bla int); leads to : read(0, create table bla (bla int); "create table bla (bla int);\n", 1024) = 28 access("./mysql/bla.frm", F_OK) = -1 ENOENT (No such file or directory) open("./mysql/bla.frm", O_RDWR|O_CREAT|O_TRUNC, 0660) = 5 write(5, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 4096) = 4096 lseek(5, 64, SEEK_SET) = 64 write(5, "//\0", 3) = 3 write(5, "\0 \0\0", 4) = 4 lseek(5, 0, SEEK_END) = 4096 write(5, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 4096) = 4096 pwrite(5, "\376\1\7\7\3\0\0\20\1\0\\0\0\20\0\6\0\0\0\0\0\0\0\0"..., 64, 0) = 64 pwrite(5, "\0\0\6\0\2\0,\0", 8, 4096) = 8 lseek(5, 4112, SEEK_SET)= 4112 write(5, "\376\0\0\0\0\377", 6) = 6 lseek(5, 8192, SEEK_SET)= 8192 write(5, "h\1\0\20\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 288) = 288 write(5, "7\0\2\1\2\24) "..., 55) = 55 write(5, "\4\4\v\v\2\0\33\200\0\0\0", 11) = 11 write(5, ",", 1)= 1 write(5, "bla,\0", 5) = 5 close(5)= 0 open("./mysql/bla.frm", O_RDONLY) = 5 read(5, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 64) = 64 close(5)= 0 write(2, "ERROR: 1033 Incorrect informati"..., 62ERROR: 1033 Incorrect information in file: './mysql/bla.frm') = 62 - With datadir set to an ext2 fs it looks like this: strace /coda/vol/mysql/libexec/mysqld --bootstrap --skip-grant-tables --basedir=/coda/vol/mysql --datadir=/tmp/mysql read(0, create table bla (bla int); "create table bla (bla int);\n", 1024) = 28 access("./mysql/bla.frm", F_OK) = -1 ENOENT (No such file or directory) open("./mysql/bla.frm", O_RDWR|O_CREAT|O_TRUNC, 0660) = 5 write(5, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 4096) = 4096 lseek(5, 64, SEEK_SET) = 64 write(5, "//\0", 3) = 3 write(5, "\0 \0\0", 4) = 4 lseek(5, 0, SEEK_END) = 4096 write(5, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 4096) = 4096 pwrite(5, "\376\1\7\7\3\0\0\20\1\0\\0\0\20\0\6\0\0\0\0\0\0\0\0"..., 64, 0) = 64 pwrite(5, "\0\0\6\0\2\0,\0", 8, 4096) = 8 lseek(5, 4112, SEEK_SET)= 4112 write(5, "\376\0\0\0\0\377", 6) = 6 lseek(5, 8192, SEEK_SET)= 8192 write(5, "h\1\0\20\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 288) = 288 write(5, "7\0\2\1\2\24) "..., 55) = 55 write(5, "\4\4\v\v\2\0\33\200\0\0\0", 11) = 11 write(5, ",", 1)= 1 write(5, "bla,\0", 5) = 5 close(5)= 0 open("./mysql/bla.frm", O_RDONLY) = 5 read(5, "\376\1\7\7\3\0\0\20\1\0\\0\0\20\0\6\0\0\0\0\0\0\0\0"..., 64) = 64 lseek(5, 64, SEEK_SET) = 64 read(5, "//\0\0 \0\0", 7) = 7 lseek(5, 4096, SEEK_SET)= 4096 read(5, "\0\0\6\0\2\0,\0", 8) = 8 pread(5, "\376\0\0\0\0\377", 6, 4112) = 6 lseek(5, 8192, SEEK_SET)= 8192 read(5, "h\1\0\20\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 288) = 288 read(5, "7\0\2\1\2\24) "..., 72) = 72 close(5)= 0 lstat("./mysql/bla", 0xbfffc9c4)= -1 ENOENT (No such file or directory) open("./mysql/bla.ISM", O_RDWR|O_CREAT|O_TRUNC, 0660) = 5 open("./mysql/bla.ISD", O_RDWR|O_CREAT|O_TRUNC, 0660)
mysql on a locked media on windoze?
I'm evaluation mysql for a product which need both a local database and a remote database access. The product will be shipped on CD, running a windoze machine which could or not have TCP/IP installed. - will mysqld run from a locked media (both the binary and the database)? - is it possible to merge both client and server into a huge binary, or may the server can run run as a "side-application"? TIA Greg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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/DBD on Darwin/mosx
I'm currently evaluation mysql, on a MacOS X machine. It compiles OK, but the test requires DBD, which I wasn't able to compile: - while running "perl Makefile.PL" I get: Note (probably harmless): No library found for -lm Note (probably harmless): No library found for -lz Note (probably harmless): No library found for -lgz Unrecognized argument in LIBS ignored: 'libgcc.a' -when trying to install I get: dyld: /usr/local/bin/perl multiple definitions of symbol _strtol /System/Library/Frameworks/System.framework/Versions/B/System(strtol.o) definition of _strtol ../blib/arch/auto/DBD/mysql/mysql.bundle definition of _strtol I wasn't able to find any reference to "_strol" in the sources, what's going on??? TIA Greg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Platform Suse 7.0, AMD 450 KIII+, 128MB Ram Linux on 10 Gig system harddrive with 45 Gig additional drive mounted as /dbshare. MySQL needs to keep its database files in dbshare but I have not been able to make it work. From what I have read in this maillist it would appear that some combination of the use of safe_mysqld -datadir= -ledir= -socket= and the creation of symbolic links will allow me to do this but so I have not found the combination. RPM -Uhf --force MySQL-3.23.32-1.i386 RPM creates /var/lib/mysql with a test folder and a mysql folder and mysql.sock. If I move the mysql folder to the /dbshare and create a symbolic link to it in /ver/lib/mysql then the error Can't find file /mysql/host.frm occurs with safe_mysqld. I am doing something wrong. Help would be 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: mySQL IS winning
"RH" == Rolf Hopkins [EMAIL PROTECTED] writes: RH That also depends on your definition of *PRODUCTION* status. If you are RH going to make a profit using MySQL then you need to purchase a license. Not any more; MySQL is GPL in the current version. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 3.23.32 memory optimization ....
Do you mean that mysql_store_result() should store everything to a local file and and mysql_fetch... should read from this file? This should not be that hard to do. Yes, you can use the actual SQL_CURSOR_FORWARD_ONLY that is unused at this moment, to call mysql_store_result_on_file(). This new funcion open a temporary file and perform the same operation of mysql_store_result() but it uses the temporary file instead of the memory. It sets a flag to tell to the native mysql function (I don't remember its name now) called in SQLFetchRow() to read from the temporary file instead of memory. This is easy to do, (for you of course) but it could be a trick waiting the cursors that, If I don't mind, are planned in mySQL 4. One can activate or deactivate this capability using ODBC or SET SQL_PARAMETER=0|1 Do you think that you can insert this feature in a 3.23.33 releases without modify yours planned jobs and, if yes, please let me know when you can do it. Regards marcello P.S. Do you remember my friend Danilo Montesi (University of Milan), he has sent to you an abstract to the Triggers implementation one or two month ago ? I would like to know your opinion on his job, and if you consider this approach convenient. -- Marcello Giovagnoli R D Logical System S.r.l. 23, Via R. Scotellaro I-60035 Jesi (AN) -ITALY Tel/Fax: +39 731 200374/200378 mailto:[EMAIL PROTECTED] http://www.logicalsystem.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
Comments in a table
Hi, Is it possible to put comments against a table and column that are persistent; so that when you run 'explain' or 'describe', these comments will display. Rob
Re: How do I move database directories
I use ./safe_mysqld --datadir=/.../... to put the data onto another disk. Manfred Howard Miller schrieb: Hi, I have installed mysql on SuSE Linux from an rpm. It works but I want to move the data directory to a larger disk on my machine. How do I do it?? If I create a symbolic link to the /var/lib/mysql directory, the mysql.sock (don't really understand what this file does) file vanishes and I can't restart the server. If I make a sumbolic link to the actual database sybdirectories, it doesn't see them properly. If I edit the /etc/rc.d/mysql file to change the data directory, the .sock file vanishes again and it won't start. What is the procedure? Howard Miller - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Multi Replication
Hi, I have two production machines with mysql running, and I'd like to set up a third on which does backups with replication. As far as I know, one mysqld can not replicate from two different master. But I need DB1 from HOST1 and DB2 from HOST2 to be replicated, so I've used mysqld_multi to start two mysqld on one machine. Now the problem is, that replication would not start, because of the missing entries for the grou [mysqld] in my.cnf (if you are using mysqld_multi, you have no [mysqld] group but one or more called [mysqld1], [mysqld2] and so on). A solution to this problem is to copy the section with the replication information from the [mysqld1] group to the [mysqld] group, start server 1, copy the replication information from the [mysqld2] group to the [mysqld] group, start server 2 and so on. Is this an known problem, and is there better solution? cheers, Martin -- ..Martin Mrvka, Research Development ..SMS Internet-Dienstleistung GmbH ...Sporgasse 25/2, A-8010 Graz ..Tel./Fax.: +43 316 81 33 80 DW 31, Fax DW 50 .http://www.sms.at - [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: Max value
It works without the group by clause also. As in: select max(debt) from users; Roger Ramirez wrote: http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Gro up_by_functions max(x) works with the group by clause. -Original Message- From: Roman Arefiev [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 10:25 AM To: [EMAIL PROTECTED] Subject: Max value Hello, I'm a newbie in MySql, it would be great if you can help me .. the problem is : I have a Mysql table like: create table users (user varchar(20), debt int(10)); How can I select user with the greatest value of debt ? I have this function (max) in MS Access database and it works perfectly. I've read all docs about MySql, but I couldn't find the same function in MySql. If it is difficult to you, can you supply me with the exact SQL-query (for this example). Thanx a lot, sorry for my English, Roman Arefiev, Sochi. Russia. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 -- Angela Curtis Innovative Business Consultants http://www.ibc2001.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: turn $2000.00 into $1600.00 in 14 days
where i live this is illegal. i hope these jerks don't have my email address. can you do anything about this TEnon? At 11:14 PM -0500 2/1/01, [EMAIL PROTECTED] wrote: New Concept in Gifting! Join A Team Of 6 And 7 Figure Earners The sole purpose of this Activity is to enable us to bless more people and to change lives by helping others receive gifts, which will enable the receiver to share their blessings with others! * Gift $2000 to prosper over $16,000 * No dues or membership fees * Introduce only two into this private activity * No purchases, no quotas, no selling! * No meetings, conference calls, no pressure! * Participation is by invitation only and of your own free will. * 6 7 figure income earners as leadership Interested? The program is moving fast call 1-310-706-2050 ext. 4594 for more details. Please leave your: Name Email address Phone number (with area code) Time zone and best time to call 1 310 706 2050 ext. 4594 24 hours a day To be removed send an email to: [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
Stale mysql queries
Hi folks, I got a strange problem, we're running a webhosting company and during peekhours, mysql really hits the cpu peek. I do believe there is one or more clients that are running high loads of querys without actually closing them, or perhaps even running querys that dosn't timeout. Is there any way to make a default timeout on querys from the server config file? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Comments in a table
Hi, Is it possible to put comments against a table and column that are persistent; so that when you run 'explain' or 'describe', these comments will display. Tables in MySQL (version 3.23 at least - not sure about 3.22) do actually have a comment 'field' built in. You specify your initial comment when you create the table, like so: CREATE TABLE foo (bar INT, blah DATETIME, ... ) COMMENT = "Another table."; You should also be able to change it at any time like this: ALTER TABLE foo COMMENT = "I changed the comment."; However, you can't get the table's comment using normal DESCRIBE statements. It is only available through the SHOW syntax, like so: SHOW TABLE STATUS FROM database LIKE "foo"; The column name in the output (if you're querying from Perl or PHP, etc.) is, unsurprisingly, 'Comment'. There's also lots of other extremely useful information to be gleaned from SHOW TABLE STATUS, such as the type of table and date/time of creation of last update, etc. Unfortunately, you can't tag columns with comments, though. Regards, Basil Hussain ([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
Can`t connect to local MySQL server...
Hi List, Whem I will go start the MySQL in Linux, receive a error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock`(111) What I do? Thanks Edgard Arthur Michel [EMAIL PROTECTED] Brazil
incremental backups?
Are incremental backups possible in MySQL? I haven't seen any reference to "incremental" in the mysqldump or anywhere else for that matter. TIA. -- Hardy Merrill Mission Critical Linux, Inc. http://www.missioncriticallinux.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
Importing/Exporting mysql databases
Hello, I am trying to export several databases from one mysql server on one linux box and import them all to another mysql server on another linux box. I just completely forgot what the syntax is. Would someone be able to help me? Thanks! Sincerely, Tom Cruickshank -- E-Mail: Tom Cruickshank [EMAIL PROTECTED] Date: 02-Feb-01 Time: 14:55:59 This message was sent by XFMail -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: incremental backups?
At 2:54 PM -0500 2/2/01, Hardy Merrill wrote: Are incremental backups possible in MySQL? I haven't seen any reference to "incremental" in the mysqldump or anywhere else for that matter. You can take a full dump, and then treat the contents of the update logs from that point on as incremental backups. (Restore using the dump, then feed the update log(s) into mysql to "replay" the queries performed from the point of the dump on.) -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: system requirements?
- Original Message - From: "Ren Tegel" [EMAIL PROTECTED] To: "Jeff Harris" [EMAIL PROTECTED] Sent: Friday, February 02, 2001 9:09 PM Subject: Re: system requirements? Jeff, yes the win32 version of mysql runs perfectly under nt. Some notes about mysql, php and nt: -php won't run as a module within windows (apache or IIS), but acts as a cgi scripts. Problems on this are: some reduced performance, no non-buffered output, and problems sending headers. This also involves http authentication issues, since NT ms-iis tends to use it's own user database. This can be quite hard to circumvent. -installation/configuration of php may be some harder. You might want to run apache for NT anyhow instead of ms-iis. So, linux or another unix platform is optimal for the combination of php and mysql, but stuff perfectly runs under NT. Compliments for the authors :) - Original Message - From: "Jeff Harris" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 02, 2001 9:02 PM Subject: system requirements? can mysql be run on windows 2000 or nt 4.0 is there any issues mixing ms sql and mysql? or running php files on iis4 or 5? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Importing/Exporting mysql databases
mysqldump -hhost -uuser -ppw --opt --all-databases all-dbs.sql mysql -hnewhost -uuser -ppw all-dbs.sql or as one command: mysqldump -hhost -uuser -ppw --opt --all-databases | mysql -hnewhost -uuser -ppw you can leave out the -hhost(newhost) if you ftp the file from one machine to the other. Check the very excellent manual: http://www.mysql.com/documentation/mysql/bychapter/manual_Tools.html#m ysqldump - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] - Original Message - From: "Tom Cruickshank" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 02, 2001 2:59 PM Subject: Importing/Exporting mysql databases Hello, I am trying to export several databases from one mysql server on one linux box and import them all to another mysql server on another linux box. I just completely forgot what the syntax is. Would someone be able to help me? Thanks! Sincerely, Tom Cruickshank -- E-Mail: Tom Cruickshank [EMAIL PROTECTED] Date: 02-Feb-01 Time: 14:55:59 This message was sent by XFMail -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
MyODBC and SQL_BIT type
Hello everyone. I'm hoping the developer of MyODBC hangs out on this list, but here goes. I browsed through the sources a bit, and I noticed several places where you are mapping SQL_BIT type to TinyINT. It appears this is only a one way mapping (software-odbc-mysql) and not the other way. What I would like is 1 of 2 things, either 1) A possible update to MyODBC where an option can be checked (similiar to large results etc..) that allows TinyINT columns to be "converted" to SQL_BIT when sent to the software or 2) Pointers on where in the sources the "translation" is done when coming from mysql. Reason I need these is I'm under the gun to "fully" integrate Visual FoxPro with MySQL (one data source, that whole thing) and the current Visual FoxPro tables use a LOT of bool fields. So if I can do a little translation on the fly, I can fake this, and make everyone happy :) Thanks in advance, Eric Fitzgerald Server Administrator AMN Television Marketing - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 do I Move Directories
Platform Suse 7.0, AMD 450 KIII+, 128MB Ram Linux on 10 Gig system harddrive with 45 Gig additional drive mounted as /dbshare. I have created a symbolic link in /var/lib of mysql- /dbshare. then RPM -Uhv --force MySQL*-3.23.32-1.i386.rpm to install the files from MySQL-3.23.32-1.i386.rpm MySQL-client-3.23.32-1.i386.rpm MySQL-shared-3.23.32-1.i386.rpm The folders mysql and test are placed in /dbshare and mysql.sock is also created in /dbshare along with the following error message. 010202 13:31:48 mysqld started 010202 13:31:48 /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010202 13:31:48 mysqld ended What am I missing to make this 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
Selecting rows with same data in all fields except one
Hello, I have a table which consists of 5 columns. There are a large number of rows that have the same values for the first 4 columns and the last column is the only thing that differs. I would like to grab all the rows that have these identical columns so I can store it into one rows with all the different values in the last column of just one row. What would the syntax be to grab all the rows that have identical data in the first 4 columns? I know this is pretty trivial but everthing I try seems to be wrong. Thanks for your help. Greg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Efficient Select
Hi I was wondering if anyone could help me find the most efficient.. or at least A efficient way to preform the following task: I have a table that has some data, one of which is a UserName column. I have another table that has multiple rows for that UserName. So table one looks like: id int UserName varchar StopTimedatetime and table two looks like id int UserName varchar Group varchar So far I have SELECT table1.id FROM table1, table2 WHEREtable1.StopTime = 0 AND table1.UserName = table2.username AND table2.Group != 'Dedicated' You can see that I am trying to get the id's from the first table where the stoptime is 0 and they do NOT have an entry in table2 that says dedicated. There are multiple entries is table2 for each username... Any suggestions? Thanks Drew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: problems migrating from mysql 3.22.22 to 3.23.32
'when' is a reserved word in 3.23 -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: Noah Romer [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 14:38 In the process of moving a database to a new server, I decided to upgrade to the 3.23 series MySQL, as it had been declared "stable" and has some new features I want to investigate. However, I've had to drop back to 3.22.22, as I started getting an "invalid SQL syntax" error on certain insert commands. Specifically, when I try to do an insert into a change logging table in our bug tracking database, I get "ERROR 1064: You have an error in your SQL syntax". An example would be the following, which I tried from the command line mysql client when our bug tracking software started complaining about not being able to log changes: mysql insert into bugs_activity (bug_id,who,when,field,oldvalue,newvalue) values (334,18,20010131145149,'bug_status','NEW','RESOLVED'); ERROR 1064: You have an error in your SQL syntax near 'when,field,oldvalue,newvalue) values (334,18,20010131145149,'bug_status','NEW','' at line 1 I can't find anything in the above SQL command that would constitute invalid syntax, and MySQL 3.22.22 doesn't have any problems with it, so I was wondering if anyone on this list might have an idea as to what's going on. The systems involved here are dual processor Linux machines. I've tried this using the MySQL-3.23.32-1 rpms (installed on the new system, which is running RedHat 6.2 on dual PIII 933's) and using the source code (mysql-3.23.32.tar.gz), compiled and running on the old system (a dual PPro system running a heavily modified RedHat 5.1). The result are the same in either case. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Efficient Select
So that looks like it does a select for all in table2 who DO have dedicated and just excludes those matches... thats an interesting way of doing it.. but that would still return a row for the other groups that the username belongs to in table2 right? so for instance if there is 2 entries in table 2 : id UserName Group 1 test Dedicated 2 test Limit1 Then it would match the second one, therefore the id that matched that username in table1 would be selected, or am i looking at it incorrectly.. Basically, I dont want any rows selected from table one if the username has an entry in table2 with a group of Dedicated.. I just ran that query on our database too and it appears to be stuck :\ On 02 Feb 2001 16:26:41 -0500, Johnson, Gregert wrote: SELECT t1.id FROM table 1 t1 LEFT JOIN table2 t2 ON t1.UserName = t2.UserName AND t2.Group = 'Dedicated' AND t1.StopTime = 0 WHERE t2.id IS NULL; --Greg Johnson -Original Message- From: Drew [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 4:00 PM To: [EMAIL PROTECTED] Subject:Efficient Select Hi I was wondering if anyone could help me find the most efficient.. or at least A efficient way to preform the following task: I have a table that has some data, one of which is a UserName column. I have another table that has multiple rows for that UserName. So table one looks like: id int UserName varchar StopTimedatetime and table two looks like id int UserName varchar Group varchar So far I have SELECT table1.id FROM table1, table2 WHEREtable1.StopTime = 0 AND table1.UserName = table2.username AND table2.Group != 'Dedicated' You can see that I am trying to get the id's from the first table where the stoptime is 0 and they do NOT have an entry in table2 that says dedicated. There are multiple entries is table2 for each username... Any suggestions? Thanks Drew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: garbage turn $2000.00 into $1600.00 in 14 days
But, I understand that some of these junkers/spammers are just trawling for addresses that they only later learn are real when the recipient replies to the remove link. From that point, they're latched unless they change their e-mail addres. I think it's reprehensible to be spamming people. The spammers should explicitly state something like: "The address throught which you received my solicitation/message is indexed for automatic DND (do not disturb) so that if you don't reply to us at all, we only keep your address to cause our server to not use it again in subsequent mailings. This way, you are secure and comfortable knowing we don't know if your address is valid or not, and it's to our disadvantage to count and mail to you, who might be repeatedly annoyed with us or to an address that is counted against our mail quota because yours might in fact be a bad address." A mouthful, but would go a longer way to restore the responsibility--as long as the message above is heeded and not used for trickery, treachery, deceit and deluge... Regards, rmdirms Aaron Williams wrote: At 10:25 PM +0200 2/2/01, Siim Einfeldt aka Itpunk wrote: I get an awful lot of spam to my private email as well, I could filter them, but does anyone know what is the best way to actually get to know where and from who the email has come from (as the from addresses lie 99% of the cases)? I personally use spamcop (www.spamcop.net). Just copy and paste the message with full headers into the form on the page, submit, and it parse out the headers to find out where it came from. It will ask you if you wish to send a notice to the contacts of those domains, which you can do by just clicking a button. I work for an ISP, and SpamCop is quite effective. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Aaron Williams [EMAIL PROTECTED] Dev. Engineering StarNet Incorporated WholeSale Dial-Upwww.megapop.net =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: problems migrating from mysql 3.22.22 to 3.23.32
On Fri, Feb 02, 2001 at 03:38:09PM -0500, Noah Romer wrote: mysql insert into bugs_activity (bug_id,who,when,field,oldvalue,newvalue) values (334,18,20010131145149,'bug_status','NEW','RESOLVED'); ERROR 1064: You have an error in your SQL syntax near 'when,field,oldvalue,newvalue) values (334,18,20010131145149,'bug_status','NEW','' at line 1 The MySQL manual, Reference Reserved Words. 'WHEN' is listed as a reserved word. Change your field's name. G'luck, Peter -- Nostalgia ain't what it used to be. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Minor bug in replication
Description: my error-log show me "Can't connect ... on '206709' (22)(107) retry in 3306 sec And really, it is connecting 3306 seconds later. Obviously, this is the port-number and the delay should be 60 seconds How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.22.21 (Source distribution) Environment: System: Linux citybeat 2.2.16 #4 Mon Oct 9 14:43:48 MEST 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/i486-suse-linux/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' Configure command: ./configure Perl: This is perl, version 5.005_03 built for i686-linux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
GROUPing question
I have a GROUPing question on the following query: SELECT HOUR(closedtime) AS hour, COUNT(assignedto) AS count FROM db WHERE (closedtime ='2001-01-01' AND closedtime = '2001-01-31 23:59:59') AND assignedto='person' GROUP BY hour; give something like this: +--++---+ | hour | prettyhour | count | +--++---+ |8 | 8AM|40 | |9 | 9AM| 161 | | 10 | 10AM | 265 | | 11 | 11AM | 177 | | 12 | 12PM | 213 | | 13 | 1PM|93 | | 14 | 2PM| 119 | | 15 | 3PM| 105 | | 16 | 4PM| 129 | | 17 | 5PM|77 | | 18 | 6PM|42 | | 19 | 7PM| 5 | | 20 | 8PM| 9 | | 21 | 9PM| 6 | | 22 | 10PM | 7 | | 23 | 11PM | 2 | +--++---+ 16 rows in set (4.71 sec) Is there a way to get the AVG count per day over this range instead of the above total (in one query)? I can't seem to find info on grouping by several things. Thanks! Graeme - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: [CGI] Gas Prices
Brazil: US$0,825/litre - That's really expensive!!! BR, Fábio Ottolini - Original Message - From: "Solomon Sokolovsky" [EMAIL PROTECTED] To: "Marko Sarunac" [EMAIL PROTECTED]; "Redvers Davies" [EMAIL PROTECTED] Cc: "mySQL Mailing List" [EMAIL PROTECTED] Sent: Thursday, February 01, 2001 10:19 PM Subject: RE: [CGI] Gas Prices Here in Australia 90 cents (AUSD)per litre thats about 58 cents USD. We consider this very expensive! -Original Message- From: Marko Sarunac [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 4:55 AM To: Redvers Davies Cc: mySQL Mailing List Subject: Re: [CGI] Gas Prices And i thought 72.9 Cents (Canadian) per litre was expensive :( Redvers Davies [EMAIL PROTECTED] on 02/01/2001 09:03:19 AM To: [EMAIL PROTECTED] cc: [EMAIL PROTECTED] (Ray Ray), [EMAIL PROTECTED] (mySQL Mailing List), [EMAIL PROTECTED] (Jeff Hunt), [EMAIL PROTECTED] (Ed Holmes), [EMAIL PROTECTED] (Chris Goehrig), [EMAIL PROTECTED] (CGI Mailing List), [EMAIL PROTECTED] (Bill Turay), [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] (bcc: Marko Sarunac/ISM-BC) Subject: Re: [CGI] Gas Prices By now you're probably thinking gasoline priced at about $1.49 is cheap. Me too! As it is now $1.58 for regular unleaded. Now that the oil Just an off topic observation. $1.58 is cheap. Here, (in the UK) our Gas price is $6 a gallon. (Yes, six US dollars a gallon). Its kinda annoying to hear people complaining about gas being $1.50 as "high" ;) Red - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: Antwort: mySQL is winning
I didn't receive this e-mail back after I sent it... - Original Message - From: "Fábio Ottolini" [EMAIL PROTECTED] To: "Paul DuBois" [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: "Fowler, J.T." [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, February 01, 2001 7:20 PM Subject: Re: Antwort: mySQL is winning One thing that I have learned on the corporate market is that huge companies prefer to pay huge amounts of money than to bet on a product that is new and almost for free. Quality in this case is secondary and what happens behind the scenes is what is taken into consideration. An IT Director doesn't feel comfortable to say to a huge enterprise that they are going to migrate to an open source database. Again, quality is not the problem. If something goes wrong people will always say: "If I have stayed with Oracle this would never happend!" That's bullshit. We all know that but have to face the facts and learn to live with them, learn to dodge'em. Of course Oracle is worried about MySQL. They have enough reasons for that. At the moment I'm trying to use MySQL inside a HUGE (really HUGE) company and the answers that I receive from the IT Department is something like: "We'll be not responsible if anything goes wrong." NOBODY wants to put their faces at the combat front but still I'm trying... Future will show the truth and people who believe in open source and MySQL have to be prepared for this kind of situations. I don't expect my company to forget about their agreement with other companies just because the open source comunity says MySQL is good. News like NASA using MySQL and some small movements here and there are going to put MySQL against the wall. If I can put MySQL to work inside this company and people start to hear about it they are going to consider it in the future for big things. If MySQL is good, and I truly believe that it is, we are going to hear the trumpets of victory very soon. So, if you are a MySQL addicted like I am, don't worry. It takes time to prove that something is good but once it's done it's just a matter of maintaining the name and the quality of the astonishing product that MySQL is today. Best regards, Fábio Ottolini - Original Message - From: "Paul DuBois" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: "Fowler, J.T." [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, February 01, 2001 3:32 PM Subject: Re: Antwort: mySQL is winning On Thu, Feb 01, 2001 at 04:21:15PM +0100, [EMAIL PROTECTED] wrote: On 01.02.2001 14:54:11 Fowler, J.T. wrote: Migration Kit for MySQL to Oracle on Linux Now Available. Moving just got easier with the new MySQL-to-Oracle Migration Workbench-the ideal migration software for developers who want to migrate open-source database on Linux to Oracle on Red Hat Linux 6.2. Hmm?? In how far is MySQL winning? Isn't that a sign that it's losing? I mean, if this were a Oracle-To-MySQL kit, I would understand you The announcement is an explicit indicator that Oracle has taken notice of the MySQL world, and felt a need to respond. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Efficient Select
SELECT t1.id FROM table1 t1, table2 t2a, table2 t2b WHERE t1.StopTime = 0 AND (t2a.Group != 'Dedicated' AND t2a.UserName != t2b.Username) AND t2a.UserName = t1.UserName Not sure if you need those () though. On 2 Feb 2001, Drew Wilder-Goodwin wrote: So that looks like it does a select for all in table2 who DO have dedicated and just excludes those matches... thats an interesting way of doing it.. but that would still return a row for the other groups that the username belongs to in table2 right? so for instance if there is 2 entries in table 2 : id UserName Group 1 test Dedicated 2 test Limit1 Then it would match the second one, therefore the id that matched that username in table1 would be selected, or am i looking at it incorrectly.. Basically, I dont want any rows selected from table one if the username has an entry in table2 with a group of Dedicated.. I just ran that query on our database too and it appears to be stuck :\ On 02 Feb 2001 16:26:41 -0500, Johnson, Gregert wrote: SELECT t1.id FROM table 1 t1 LEFT JOIN table2 t2 ON t1.UserName = t2.UserName AND t2.Group = 'Dedicated' AND t1.StopTime = 0 WHERE t2.id IS NULL; --Greg Johnson -Original Message- From: Drew [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 4:00 PM To: [EMAIL PROTECTED] Subject:Efficient Select Hi I was wondering if anyone could help me find the most efficient.. or at least A efficient way to preform the following task: I have a table that has some data, one of which is a UserName column. I have another table that has multiple rows for that UserName. So table one looks like: id int UserName varchar StopTimedatetime and table two looks like id int UserName varchar Group varchar So far I have SELECT table1.id FROM table1, table2 WHEREtable1.StopTime = 0 AND table1.UserName = table2.username AND table2.Group != 'Dedicated' You can see that I am trying to get the id's from the first table where the stoptime is 0 and they do NOT have an entry in table2 that says dedicated. There are multiple entries is table2 for each username... Any suggestions? Thanks Drew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problems migrating from mysql 3.22.22 to 3.23.32
Ok, being careful to try and avoid any naughty words that might trigger the bleeding spam filter. The Tilghman wrote: 'when' is a reserved word in 3.23 Well, that would explain that. Arrrgghh! I even spent a couple of hours going through the "upgrading from 3.22"/"major new features of 3.23"/"complete change list of 3.23" etc pages and never saw this mentioned. Either I'm blind/obtuse (always possible) or this was extremely under-a d v e r t i s ed. Now I get to comb through a few hundred lines of Perl code looking for any hard coded references to "when." Thanks, Noah -Original Message- From: Noah Romer [mailto:[EMAIL PROTECTED]] Sent: Friday, February 02, 2001 14:38 In the process of moving a database to a new server, I decided to upgrade to the 3.23 series MySQL, as it had been declared "stable" and has some new features I want to investigate. However, I've had to drop back to 3.22.22, as I started getting an "invalid SQL syntax" error on certain insert commands. Specifically, when I try to do an insert into a change logging table in our bug tracking database, I get "ERROR 1064: You have an error in your SQL syntax". An example would be the following, which I tried from the command line mysql client when our bug tracking software started complaining about not being able to log changes: mysql insert into bugs_activity (bug_id,who,when,field,oldvalue,newvalue) values (334,18,20010131145149,'bug_status','NEW','RESOLVED'); ERROR 1064: You have an error in your SQL syntax near 'when,field,oldvalue,newvalue) values (334,18,20010131145149,'bug_status','NEW','' at line 1 I can't find anything in the above SQL command that would constitute invalid syntax, and MySQL 3.22.22 doesn't have any problems with it, so I was wondering if anyone on this list might have an idea as to what's going on. The systems involved here are dual processor Linux machines. I've tried this using the MySQL-3.23.32-1 rpms (installed on the new system, which is running RedHat 6.2 on dual PIII 933's) and using the source code (mysql-3.23.32.tar.gz), compiled and running on the old system (a dual PPro system running a heavily modified RedHat 5.1). The result are the same in either case. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 errors, can anyone shed some light?
We are getting thse errors. Can anyone point me in the right direction? DBI-connect(database=whois;host=www5) failed: Host 'www5' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' at /usr/lib/perl5/site_perl/5.005/PEC.pm line 731 Thanks, CC - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
host.frm
What is host.frm and why can host.frm not be located where I want to be? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Out of disk space
I'm suddenly getting "Got error 28 from table handler" from a MySQL script that used to work fine. On searching the MySQL list archives, I determined that means I'm out of disk space. Something's weird here though: root@trapezoid [~]# df Filesystem 1k-blocks Used Available Use% Mounted on /dev/hda8 256667245754 0 100% / /dev/hda123302 2445 19654 11% /boot /dev/hda6 6672828 3809672 2524188 60% /home /dev/hda5 6672828954312 5379548 15% /usr /dev/hda7 256667 54830188585 23% /var If there are 256667 total, and 245754 used, shouldn't there be 10913 available? I tried doing a /sbin/reboot but it still says available 0. Also, is editing /etc/rc.d/init.d/mysql and adding "--tmpdir=/var/tmp" to the mysql command the correct way of setting the temporary directory that MySQL uses? (It seems to be working, but I just want to make sure) -Philip Mak ([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
Deleting table question...
Hello, via telnet with mysql server on linux, I try to delete a table, but it won't work. I'm browsing the documentation, I can't see what will work. I can do this via asp, but I'd love to know the command for something that should be as simple as mysql Delete (tablename) from (Database name); Anybody? Thanks PS. Sorry if this sounds basic, I thought it was, but nothing works.
mysql++ 1.7.8
I'm having a little trouble running a program I made with mysql++1.7.8, when I run the app it segment faults when the connect object is created. this is what I am running Red Hat Linux release 7.0 (Guinness) Kernel 2.2.16-22 on an i586 Mysql 3.23.32 mysql++1.7.8 gcc 2.96.2 here is how I compile the app g++ temp.cpp -I/usr/local/mysql/include/mysql -L/usr/local/mysql/lib/mysql -lsqlplus -Wl,--rpath=/usr/local/mysql/lib/mysql here is the code #include sqlplus.hh #include iostream.h int main() { cout " startup" endl; Connection con("temp","localhost","root","temp",3306,0,60,1,"",0); cout "done" endl; return 0; } here is the output startup Segmentation fault (core dumped) here is what causes it to crash Starting program: /home/projects/code/isv/join/a.out startup Program received signal SIGSEGV, Segmentation fault. chunk_free (ar_ptr=0x464c457f, p=0x4005f198) at malloc.c:3071 3071malloc.c: No such file or directory. now back traceing it #0 chunk_free (ar_ptr=0x464c457f, p=0x4005f198) at malloc.c:3071 #1 0x401415fc in __libc_free (mem=0x4005f1a0) at malloc.c:3043 #2 0x40200d25 in my_no_flags_free () from /usr/local/mysql/lib/mysql/libmysqlclient.so.10 #3 0x401fc929 in mysql_real_connect () from /usr/local/mysql/lib/mysql/libmysqlclient.so.10 #4 0x4002dfa4 in MysqlConnection::real_connect (this=0xb8b0, db=0x8048c02 "temp", host=0x8048bf8 "localhost", user=0x8048bf3 "root", passwd=0x8048bed "temp", port=3306, compress=0, connect_timeout=60, socket_name=0x8048bec "", client_flag=0) at connection.cc:49 #5 0x4002dc7e in MysqlConnection::MysqlConnection (this=0xb8b0, db=0x8048c02 "temp", host=0x8048bf8 "localhost", user=0x8048bf3 "root", passwd=0x8048bed "temp", port=3306, compress=0 '\000', connect_timeout=60, te=true, socket_name=0x8048bec "", client_flag=0) at connection.cc:29 #6 0x8048a9f in main () #7 0x400e5790 in __libc_start_main (main=0x8048a2c main, argc=1, ubp_av=0xbb24, init=0x8048860 _init, fini=0x8048bbc _fini, rtld_fini=0x4000d35c _dl_fini, stack_end=0xbb1c) at ../sysdeps/generic/libc-start.c:111 any help to remedy this problem would be great. David _ Get your FREE download of MSN Explorer at http://explorer.msn.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: Deleting table question...
why dont you try use database drop tablename Mensaje citado por: Joel Holtzman [EMAIL PROTECTED]: Hello, via telnet with mysql server on linux, I try to delete a table, but it won\'t work. I\'m browsing the documentation, I can\'t see what will work. I can do this via asp, but I\'d love to know the command for something that should be as simple as mysql Delete (tablename) from (Database name); Anybody? Thanks PS. Sorry if this sounds basic, I thought it was, but nothing works. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Out of disk space
Philip Mak wrote: I'm suddenly getting "Got error 28 from table handler" from a MySQL script that used to work fine. On searching the MySQL list archives, I determined that means I'm out of disk space. Something's weird here though: root@trapezoid [~]# df Filesystem 1k-blocks Used Available Use% Mounted on /dev/hda8 256667245754 0 100% / If there are 256667 total, and 245754 used, shouldn't there be 10913 available? I tried doing a /sbin/reboot but it still says available 0. Nope. That's the 5% reserved space you're treading on. Yes, that space is still there but you can only access it as root, no one else. Consequently every thing else is telling you the drive's full (which is correct). Besides, 10Mb isn't a whole lot anyways. Better free up some space on that drive. AMK4 -- W | | I haven't lost my mind; it's backed up on tape somewhere. | ~ Ashley M. Kirchner mailto:[EMAIL PROTECTED] . 303.442.6410 x130 SysAdmin / Websmith . 800.441.3873 x130 Photo Craft Laboratories, Inc. .eFax 248.671.0909 http://www.pcraft.com . 3550 Arapahoe Ave #6 .. . . . . Boulder, CO 80303, USA - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Deleting table question...
Thank you, I learned that I needed: Drop *table* tablename Thanks for your help, guys. I appreciate it Joel - Original Message - From: [EMAIL PROTECTED] To: Joel Holtzman [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, February 02, 2001 3:51 PM Subject: Re: Deleting table question... why dont you try use database drop tablename Mensaje citado por: Joel Holtzman [EMAIL PROTECTED]: Hello, via telnet with mysql server on linux, I try to delete a table, but it won\'t work. I\'m browsing the documentation, I can\'t see what will work. I can do this via asp, but I\'d love to know the command for something that should be as simple as mysql Delete (tablename) from (Database name); Anybody? Thanks PS. Sorry if this sounds basic, I thought it was, but nothing works. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Load Data errors
Hello, I have one question about the 'load data' function. Below is the what I have for 'actor.txt' for a text file I want to load to table 'actor' | ID | fFirst | Last --- | 2 | Sean| Smith --- | 5 | John | Jones The columns ID/FIRST/LAST already exist. I just want to overight the data with this file. But when I do, I get an error : duplicate entry for key 1 (I guess that's the primary key, which is ID) Basically, the question is if I can ever just either: A.) Create a table and with the create synatx, use load data infile. Otherwise, I am forced to create default values, and when I use load data infile after, I get duplicate errors OR B.) Is there a way to overright the data of the table? When I create a table, there are 0 records entered. That's why I use these text files. Yet, somehow, it won't be inserted. The documentation only shows the syntax, not the solution. Has anybody had experienced going around this issue? I've tried to no avail. Even the gui software people rave about give me errors. But this is my priority, I am sure it's something simple. Thanks for your time. I thought I'd ask to play it safe as I search for answers. Joel
Re: turn $2000.00 into $1600.00 in 14 days
On Fri, 2 Feb 2001, Siim Einfeldt aka Itpunk wrote: I get an awful lot of spam to my private email as well, I could filter them, but does anyone know what is the best way to actually get to know where and from who the email has come from (as the from addresses lie 99% of the cases)? yeah, I know this is offtopic, but still! Siim Einfeldt Try http://www.spamcop.com Regards Peter [EMAIL PROTECTED] -- For the ways of man are before the eyes of the LORD, and he ponders all his goings. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
BETWEEN problem?
Can anyone explain the following results to me? I am trying to find all values +/- 30% from a number... value is declared as: | value | int(10) unsigned Note that 1.3*63000 is 81900... The first two are apparently correct: mysql SELECT count(*) FROM bench WHERE year = 95 and - value = .7*63000 and value = 1.3*63000 ; +--+ | count(*) | +--+ | 115 | +--+ 1 row in set (0.10 sec) mysql SELECT count(*) FROM bench WHERE year = 95 and - value = .7*63000 and value = 81900 ; +--+ | count(*) | +--+ | 115 | +--+ 1 row in set (0.08 sec) These next two should give the same result, but... mysql SELECT count(*) FROM bench WHERE year = 95 and - value BETWEEN .7*63000 and 81900 ; +--+ | count(*) | +--+ | 47 | +--+ 1 row in set (0.08 sec) mysql SELECT count(*) FROM bench WHERE year = 95 and - value BETWEEN .7*63000 and 1.3*63000 ; +--+ | count(*) | +--+ |0 | +--+ 1 row in set (0.08 sec) Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
corrupt user table
anyone know how to repair a corrupt user table? I edited the user.ISD file and I can make changes via mysql but cannot do a select * from user; _ Get your FREE download of MSN Explorer at http://explorer.msn.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
How to uninstall MySQL?
Hi, I installed MySQL on Red Hat 6.2. Now I am having trouble with uninstalling it. If I do rpm -erase MySQL-version.rpm, the message saying "no rpm package is installed". If I do rpm -i MySQL-version.rpm, the message says that the rpm package is already installed. what should I do to uninstall it? Thanks! = Abby __ Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to uninstall MySQL?
Just take the .rpm off the end, and any additional platform information like i386, etc. It would just be, for example, rpm -e MySQL-3.23.32-1 Sean On Fri, 2 Feb 2001, Abby Jiang wrote: Hi, I installed MySQL on Red Hat 6.2. Now I am having trouble with uninstalling it. If I do rpm -erase MySQL-version.rpm, the message saying "no rpm package is installed". If I do rpm -i MySQL-version.rpm, the message says that the rpm package is already installed. what should I do to uninstall it? Thanks! = Abby __ Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
200 DOLLARS FOR YOU
Re: Efficient Select
Give this a try. I used table aliases out of habit. SELECT table1.id FROM table1 A LEFT JOIN table2 B ON A.UserName = B.username AND B.Group != 'Dedicated' WHERE B.username IS NULL AND A.StopTime = 0; - Scott Hi I was wondering if anyone could help me find the most efficient.. or at least A efficient way to preform the following task: I have a table that has some data, one of which is a UserName column. I have another table that has multiple rows for that UserName. So table one looks like: id int UserName varchar StopTimedatetime and table two looks like id int UserName varchar Group varchar So far I have SELECT table1.id FROM table1, table2 WHEREtable1.StopTime = 0 AND table1.UserName = table2.username AND table2.Group != 'Dedicated' You can see that I am trying to get the id's from the first table where the stoptime is 0 and they do NOT have an entry in table2 that says dedicated. There are multiple entries is table2 for each username... Any suggestions? Thanks Drew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- -- Scott A. Gerhardt P.Geo. Gerhardt Information Technologies [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: turn $2000.00 into $1600.00 in 14 days
Why does anyone need lessons in how to lose $400 in 14 days? I can do it easily. Terence - Original Message - From: "Colin Faber" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, February 03, 2001 1:46 PM Subject: Re: turn $2000.00 into $1600.00 in 14 days [EMAIL PROTECTED] wrote: where i live this is illegal. i hope these jerks don't have my email address. can you do anything about this TEnon? snip This is a problem everywhere. If you notice 90% of spam is useless even if you're interested in the crap product being "marketed" to you; because the reply and or contact email is bogus. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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