put row
Hi, I've a situation where I want to put an ascii file as a set of rows in a table (one per line), whereas it may appear that some do already exist. In either case, I'm looking for 1 command that just puts the set of rows in the table. Is that possible in MySQL? In normal behavior, this would mean a combination of insert or update, but is there something like a put or load? Thx, Ivo. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: sql
* Pushkar Pradhan I'm trying to enforce one column of my table to contain strictly 6 chars. string. However I've some columns of type VARCHAR (e.g name, etc.) so mysql silently changes the column to VARCHAR. Right. Is there any way I can force the column to contain only 6 chars. Yes, you can define it as VARCHAR(6)...? -- Roger sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: sql
* Pushkar Pradhan I'm trying to enforce one column of my table to contain strictly 6 chars. string. However I've some columns of type VARCHAR (e.g name, etc.) so mysql silently changes the column to VARCHAR. It is ok for MySQL. You can find some info here : http://www.mysql.com/doc/en/Silent_column_changes.html ... a.. If any column in a table has a variable length, the entire row is variable-length as a result. Therefore, if a table contains any variable-length columns (VARCHAR, TEXT, or BLOB), all CHAR columns longer than three characters are changed to VARCHAR columns. This doesn't affect how you use the columns in any way; in MySQL, VARCHAR is just a different way to store characters. MySQL performs this conversion because it saves space and makes table operations faster. See section 7 MySQL Table Types. ... Is there any way I can force the column to contain only 6 chars. No. But do you actually need it?! Mikhail. - Original Message - From: Roger Baklund [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Pushkar Pradhan [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 9:46 AM Subject: Re: sql * Pushkar Pradhan I'm trying to enforce one column of my table to contain strictly 6 chars. string. However I've some columns of type VARCHAR (e.g name, etc.) so mysql silently changes the column to VARCHAR. Right. Is there any way I can force the column to contain only 6 chars. Yes, you can define it as VARCHAR(6)...? -- Roger sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: HAVING Max(x) IS NULL always TRUE.
Oleh, SELECT t1.id, Max(t2.data) FROM test1 t1 left join test2 t2 ON t1.id = t2.parent_id GROUP BY t1.id HAVING Max(t2.data) IS NULL; As temporary solution try to use next query: SELECT t1.id, Max(t2.data) as MaxData FROM test1 t1 left join test2 t2 ON t1.id = t2.parent_id GROUP BY t1.id HAVING MaxData IS NULL; Mikhail. - Original Message - From: Oleh Khoma [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 14, 2002 10:09 PM Subject: HAVING Max(x) IS NULL always TRUE. Description: HAVING Max(x) IS NULL always TRUE. This has changed since 3.23.39, when if the x column had all Nulls, Max(x) IS NULL was TRUE and FALSE otherwise. How-To-Repeat: CREATE TABLE test1 ( ID int unsigned auto_increment not null primary key, data varchar(50) ); INSERT INTO test1 (data) VALUES ('1'), ('2'), ('3'), ('4'); CREATE TABLES test2 ( ID int unsigned auto_increment not null primary key, parent_id int unsigned not null references test1, data enum('Y', 'N') null ); INSERT INTO test2 (parent_id, data) values (1, 'Y'), (1, 'N'), (1, Null), (2, 'Y'), (2, Null), (3, 'N'), (3, Null), (4, Null); SELECT t1.id, Max(t2.data) FROM test1 t1 left join test2 t2 ON t1.id = t2.parent_id GROUP BY t1.id HAVING Max(t2.data) IS NULL; Above query is returning only (4, Null) on 3.23.38-max and 3.23.39 but it returns (1, Y), (2, Y), (3, N), (4, Null) on 3.23.51 Fix: Workaround: HAVING Max(IfNull(t2.data, '')) = '' Submitter-Id: submitter ID Originator: Oleh Khoma Organization: FineStudio MySQL support: none Synopsis: HAVING Max(x) IS NULL always TRUE Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.51 (Source distribution) Environment: RedHat Linux 7.0 System: Linux linux1303.dn.net 2.2.16-RAID #6 SMP Fri Jul 7 13:29:16 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.1 2.96-98) Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=pentiumpro' CXX='gcc' CXXFLAGS='-O2 -mcpu=pentiumpro -felide-constructors' LDFLAGS='-static' LIBC: lrwxrwxrwx1 root root 13 Mar 20 17:07 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 5723311 Dec 8 2001 /lib/libc-2.2.4.so -rw-r--r--1 root root 27314296 Dec 8 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Dec 8 2001 /usr/lib/libc.so Configure command: ./configure --enable-assembler --with-other-libc=/usr/local/mysql 'CFLAGS=-O2 -mcpu=pentiumpro' CXXFLAGS=-O2 -mcpu=pentiumpro -felide-constructors' CXX=gcc LDFLAGS=-static - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
temporaere Dateien.
Hallo, Ich wuerde gern wissen, warum und wann MySQL temporaere Dateien erzeugt. Ausserdem wie vermeide ich, dass meine Festplatte bei der Ausfuehrung meiner Applikation, nicht voll wird, wenn so viele temporaere Dateien reingelegt werden. Vielen Danke. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: CDSISIS
hi i have the same problem with converting CDS ISIS to any other dbms but i know that CDS ISIS can export data in ISO format , the question here , can MySQL import ISO file , and how ? Thanks regards USAMA* _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 4.0.2, 4.0.3 replication circle broken.
Hello mysql, In case of repliacation circle (A-B-A) query 'flush log' on any of this servers create endless loop, with creating new binary log file on each iteration. (about 30 new files every second in my case) -- Best regards, Artem mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Instalation problems
To whom it may concern, I had a bad starts!!! I was trying to start working with MySQL with Windows 98 so I downloaded the file myodbc-21.50.39-win95.zip to install the drivers for ODBC, after unzip this file (obviously) I executed the file SETUP.EXE receiving the following message: Insufficient Memory or Disk Space, which is difficult to belive because I have a Pentium 4 with 256 Mb of RAM and a Hard Disk with 30 Gb of free space. What I am doing bad? I would appreciate a lot your help. Kind regards, Daniel Roldán _ Send and receive Hotmail on your mobile device: http://mobile.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: temporaere Dateien.
Hi, Please write in English to this mailing list, or go to a German one. Vielen Danke, :-) Bye Daniel At 11:04 2002.08.15. +0200, you wrote: Hallo, Ich wuerde gern wissen, warum und wann MySQL temporaere Dateien erzeugt. Ausserdem wie vermeide ich, dass meine Festplatte bei der Ausfuehrung meiner Applikation, nicht voll wird, wenn so viele temporaere Dateien reingelegt werden. Vielen Danke. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
MySQL and io read
Hello, I have a mysql database latest version from the freebsd ports running on a 350 Mhz with 385 MB memory and 1 ata 33 disk freebsd 4.6 stable server. I have a database with 5.5 million record in say 1 table. We use this read-only. It seems that when i do a select and the result is minimal it uses the index(fast about 3 sec), but when the result is much more it is not using the index. this results in a lot of disk io and taking to much time. My experience with msql7 is that it keeps thing in memory with results in performance improvement. Can this be done with mysql? When i use top i don't see mysql using much of my memory. I haven't changed any settings yet in my.cnf. [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL and io read
Reinier, It seems that when i do a select and the result is minimal it uses the index(fast about 3 sec), but when the result is much more it is not using the index. this results in a lot of disk io and taking to much time. It is correct, because (http://www.mysql.com/doc/en/MySQL_indexes.html at the end) ... Note that in some cases MySQL will not use an index, even if one would be available. Some of the cases where this happens are: If the use of the index would require MySQL to access more than 30% of the rows in the table. (In this case a table scan is probably much faster, as this will require us to do much fewer seeks.) Note that if such a query uses LIMIT to only retrieve part of the rows, MySQL will use an index anyway, as it can much more quickly find the few rows to return in the result. ... Try to check query plan (use EXPLAIN command). My experience with msql7 is that it keeps thing in memory with results in performance improvement. Can this be done with mysql? IMHO MySQL is doing that in correct way too. Best regards, Mikhail. - Original Message - From: Reinier van Heusden [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 12:13 PM Subject: MySQL and io read Hello, I have a mysql database latest version from the freebsd ports running on a 350 Mhz with 385 MB memory and 1 ata 33 disk freebsd 4.6 stable server. I have a database with 5.5 million record in say 1 table. We use this read-only. It seems that when i do a select and the result is minimal it uses the index(fast about 3 sec), but when the result is much more it is not using the index. this results in a lot of disk io and taking to much time. My experience with msql7 is that it keeps thing in memory with results in performance improvement. Can this be done with mysql? When i use top i don't see mysql using much of my memory. I haven't changed any settings yet in my.cnf. [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
mySQLGUI problem
everytime i submit a query, it closes the connection to my (remote) database - why? Jan Jan Davies animonkeyweb design, animation interactive media 07 808 120 310 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: put row
Ivo, Thursday, August 15, 2002, 9:55:25 AM, you wrote: IBin I've a situation where I want to put an ascii file as a set of rows in a IBin table (one per line), whereas it may appear that some do already exist. IBin In either case, I'm looking for 1 command that just puts the set of rows in IBin the table. Is that possible in MySQL? IBin In normal behavior, this would mean a combination of insert or update, but IBin is there something like a put or load? Take a look at LOAD DATA INFILE: http://www.mysql.com/doc/en/LOAD_DATA.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: RE: null
Mary, Wednesday, August 14, 2002, 7:23:47 PM, you wrote: MS here is is ... MS 'check to see if agent/dist code are already in temp table MS sSql = SELECT * _ MS FROM TempSap _ MS WHERE ProducerID=' FixSQLString( MS rs3!WritingAgentID) ' _ MS AND TaxID=' FixSQLString( rs3!taxid) MS ' _ MS AND DistributionCode=' MS FixSQLString(sDistributionCode) ' MS Call SendToDwDb(sSql, rs5) Mary, it would be nice if you post not only your INSERT statement, but the output of SHOW CREATE TABLE and the output of the query result, too. Provide also exact SELECT statement, i.e. with actual values for producerid, taxid and so on. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: transferring the data from Oracle to MySQL
Chugh, Tuesday, August 13, 2002, 2:40:54 PM, you wrote: CS We are in the process of transferring our databse from Oracle to MYSQL. CS Oracle has some triggers to insert into the table on some events. How can we CS handle this dynamic insertion of triggers in MYSQL. CS Also what is the alternative for check constraint of Oracle in MYSQL Unfortunatly MySQL doesn't support triggers yet. CHECK constraint also doesn't do anything. You should do it on the client level. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: a couple problems
Devore, Thursday, August 15, 2002, 12:05:13 AM, you wrote: D I'm having trouble with a vbulletin database running mysql as the back end. D It's running on linux server. Basically we had some weird problems and was D hoping someone else has seen this. First the boards went down because D somehow all the permissions on the table files in D /usr/local/mysql/var/database name were set to be owned by root. So the D mysql daemon didn't have privledges to read or write to them. You should just change owner of the data dir. D Today I just D fixed a crashed table to get the database back up. Tables could be corrupted for many reasons. Look at: http://www.mysql.com/doc/en/Corrupted_MyISAM_tables.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Data Directory
Daren, Wednesday, August 14, 2002, 11:49:22 PM, you wrote: DC My Linux installation only has about 1gb in the /var DC partition, so I need to relocate my databases to the DC /home partition. I'm pretty sure the following DC commands will shutdown mysql, move the data directory, DC create a symbolic link, and then restart mysql. My DC question is, is this complete, or do I need to DC chown/chgrp/chmod the new symbolic link directory? DC mysqladmin -u root -p shudown DC mv /var/lib/mysql /home DC ln -s /home/mysql /var/lib/mysql DC /etc/rc.d/init.d/mysqld start If you want to have another data dir than /var/lib/mysql you can just specify new data dir with --datadir=# option of mysqld or edit my.cnf file. Don't forget to check permissions on the new data dir. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 3 Questions
Will, Wednesday, August 14, 2002, 2:07:04 AM, you wrote: WK These questions may sound kinda basic, but here goes... WK 1.) What if I want to print (on paper) the contents of my MySQL database, WK then how do I do it? You may put data in the text file and print the contents of those file. Use mysqldump or SELECT INTO OUTFILE to put data into the file. http://www.mysql.com/doc/en/mysqldump.html http://www.mysql.com/doc/en/SELECT.html WK 2.) This question is more out of curiosity. Suppose I buy a database that WK has been prepopulated. Then how do I get that info into my existing WK database? Depending on format your database has. Take a look at LOAD DATA INFILE or if you have result file generated by mysqldump, just restore data. http://www.mysql.com/doc/en/LOAD_DATA.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: View current connections
Tab, Wednesday, August 14, 2002, 11:06:36 PM, you wrote: TA Is there a tool out there for Windows that will let me monitor how many TA connections to my MySQL database are currently open at any given moment? Use SHOW PROCESSLIST command: http://www.mysql.com/doc/en/SHOW_PROCESSLIST.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL and io read
Reinier, Thursday, August 15, 2002, 1:13:32 PM, you wrote: RvH I have a mysql database latest version from the freebsd ports running on a RvH 350 Mhz with 385 MB memory and 1 ata 33 disk freebsd 4.6 stable server. RvH I have a database with 5.5 million record in say 1 table. We use this RvH read-only. RvH It seems that when i do a select and the result is minimal it uses the RvH index(fast about 3 sec), but when the result is much more it is not using RvH the index. this results in a lot of disk io and taking to much time. RvH My experience with msql7 is that it keeps thing in memory with results in RvH performance improvement. Can this be done with mysql? When i use top i don't RvH see mysql using much of my memory. RvH I haven't changed any settings yet in my.cnf. What about using query cache? If you don't modify the data and run a lot of identical queries, it would be useful for you. Query cache is supported since 4.0.1 : http://www.mysql.com/doc/en/Query_Cache.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Security question
Mike, Thursday, August 15, 2002, 12:45:06 AM, you wrote: MH Hi there, MH I posted this a few days ago and recieved no responses, so I thought I would MH post it again: Mike, I answered you yesterday. MH Hi All; MH I am working on a front end to my database, but I am running into a bit of MH trouble. I have a user who has the proper privileges and grant option create MH other users, but I need to know this: can that user delete users he has MH created (or at least disable them), and can users change their own MH passwords? This is all being done for a VB front end, so I need to be able MH to do these things using SQL statements. Any help would be appreciated. To create other users you must have UPDATE privilege on database 'mysql' and GRANT_priv. To delete users you must have DELETE_priv and SELECT_priv (to use DELETE with WHERE clause) on the database 'mysql'. But in this case user can delete any user from database 'mysql' not only users that you created. User can change his password just using mysqladmin mysqladmin -uuser_name -pold_password password 'new_password' or SET statement: http://www.mysql.com/doc/en/Passwords.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: You seem to have found a bug in the SQL parser. Please submit a bug report with the
John, Wednesday, August 14, 2002, 12:26:29 PM, you wrote: JMH data chunk below. Description: JMH Bug in SQL parser. JMH --BEGIN CUT-- JMH eNotjs0KgkAYRfc9xV20itBxzMqhHyImCoxIA9eJX41hOY1m9YI+Vz+4u+dwFre7SQXKe66PpiRj JMH 5VliaaX7NRzL8cAZ4zYb2XwIZyxcJjwfOV19yJdGd5IY2LNOrN5IsxRPwpkqKDI0B4cLd9AWAZ2q JMH oiYj0LRmIX5FC9E+EIhkI5cH9LAKd1s8vmcQr2Uo/3N6KdTtAz8HMRA= JMH ---END CUT--- Fix: What is the format of the data above? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: temporaere Dateien.
On Thu, 15 Aug 2002 [EMAIL PROTECTED] wrote: Hallo, Ich wuerde gern wissen, warum und wann MySQL temporaere Dateien erzeugt. Ausserdem wie vermeide ich, dass meine Festplatte bei der Ausfuehrung meiner Applikation, nicht voll wird, wenn so viele temporaere Dateien reingelegt werden. Vielen Dank. Samia, there is something in the manual about temporary files. Look for Where MySQL Stores Temporary Files to be found under Problems and Common Errors / Administration Issues. quote MySQL creates all temporary files as hidden files. This ensures that the temporary files will be removed if `mysqld' is terminated. The disadvantage of using hidden files is that you will not see a big temporary file that fills up the filesystem in which the temporary file directory is located. unquote I think temporary files should be removed as soon as they are no longer needed and not be kept until mysqld is closed down (which may happen very unfrequently). You may always have a cron job deleting old temporary files automatically. Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fwd: RE: Newbie With a Question
Well, that's strike one for me! I sent my first post to the list and accidently ONLY sent it to one member of the list (who was kind enough to respond anyway!) My problem is that I am unable to change data in an existing table. I use the UPDATE function and it continues to tell me that I am using an Unknown Column. When I do a DESCRIBE on the table, I clearly see the column. Since I can see the column in the describe (named 'Field'), I must be doing something else wrong. Any help would be appreciated. (Thanks to Oscar, but his link seems to be for actually changing the format of a table, which is not my goal...yet=) --- Oscar Rylin [EMAIL PROTECTED] wrote: From: Oscar Rylin [EMAIL PROTECTED] To: 'Jones Tyler' [EMAIL PROTECTED] Subject: RE: Newbie With a Question Date: Wed, 14 Aug 2002 22:36:05 +0200 http://www.mysql.com/doc/A/L/ALTER_TABLE.html -Original Message- From: Jones Tyler [mailto:[EMAIL PROTECTED]] Sent: den 14 augusti 2002 22:33 To: Oscar Rylin Subject: Newbie With a Question Greetings, To begin with, if this is an inappropriate question for this list, let me appologize now. In that case, if you could direct me to an appropriate venu for my question, I would appreciate it. The question? I downloaded a free program on the internet to have some fun. After the download, I noticed a problem that I subsequently did a search on and found the answer. The problem is that I am having problems implementing the fix. The fix is to change the entry in a row of a table for a particular horizontal entry (or field, if you will). After I select the dB, I then typed SHOW TABLES and identified the table in question (HUNT_CONFIG). Looking at the Table, I then find the The first column is FIELD and the table entry I am interested in has a FIELD value of regtype. I want to change the entry in the third column for regtype, which is titled VAR. The current value is enum('0','1','2') and I need this value to be enum('0','1','2','3') So, I typed the following: UPDATE HUNT_CONFIG SET VAR='enum('0','1','2','3') WHERE FIELD='regtype'; But, it keeps giving me an error, acting as if there is not such Column by the name of 'FIELD'. I have double checked this many times and am certain that the name fo the column is FIELD. If you have any suggestions, they would be appreciated. __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.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: Speed problems.. Still
On Thu, 15 Aug 2002, Benjamin Pflugmann wrote: Let me try to explain. snip Last, an introduction into LEFT JOINs: snip Benjamin, this was a very good explanation. I would love to see an edited version of your post included in the Tutorial section of the very fine manual. Regards, Thomas Spahni -- sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Setting root password in mysql for windows
Art, Thursday, August 15, 2002, 7:12:40 AM, you wrote: AF Having a hard time coming to grips with the password setup for mysql in AF windows. I follow the instructions below from the documentation. AF C:\ C:\mysql\bin\mysql mysql AF mysql DELETE FROM user WHERE Host='localhost' AND User=''; AF mysql QUIT AF C:\ C:\mysql\bin\mysqladmin reload AF C:\ C:\mysql\bin\mysqladmin -u root password your_password AF All goes well until the last line and In type mysqladmin -u root password AF my_password. AF I get AF mysqladmin: connect to server at 'localhost' failed AF error: 'Access denied for user: 'root@localhost' (Using password: NO)' AF What is the cause of this and how can I fix it? Does user 'root' have a password? If so, you should use mysqladmin -u root -p password newpassword and enter old password in the password prompt or mysqladmin -u root -poldpassword password newpassword -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Zombie slave process on my master
Our server seems to think it is a slave. It has a slave thread rnning, whose only action is to complain once a minute about not being able to connect to master . This just started one day, when we took the server down and brought it right back up. I'd like to get rid of the slave thread, but I don't know where to start. Any ideas appreciated. Info. that could be of use follows We're running on Red Hat 7.2, using 3.23.49-max-log. (We're replicating from a 4.0.1 on Win 2000) Here's the slave status. (In fact, the server is on port 3307; there is another MySQL running on port 3306. There's no user named test) mysql show slave status; +-+-+-+---+--+-+ ---+-+-++--- -+--+ | Master_Host | Master_User | Master_Port | Connect_retry | Log_File | Pos | Slave_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last_error | Skip_counter | +-+-+-+---+--+-+ ---+-+-++--- -+--+ | | test| 3306| 60| | 4 | Yes | | | 0 | | 0| +-+-+-+---+--+-+ ---+-+-++--- -+--+ 1 row in set (0.00 sec) Here's the processlist. Id=1 is the zombie. Id=3 is the legitimate connection over the net from a slave. mysql show processlist; ++-++--+-+---+-- ---+--+ | Id | User| Host | db | Command | Time | State | Info | ++-++--+-+---+-- ---+--+ | 1 | system user | none | NULL | Connect | 50846 | connecting to master| NULL | | 3 | repl| id144.megapipe.net | NULL | Binlog Dump | 50771 | Slave connection: waiting for binlog update | NULL | | 93 | root| localhost | RCAP_SVR | Query | 0 | NULL| show processlist | ++-++--+-+---+-- ---+--+ 3 rows in set (0.00 sec) Here's a fragment of the error log when this appears to have started: 020726 02:02:39 mysqld started 020726 6:02:40 InnoDB: Started /usr/local/mysql/libexec/mysqld: ready for connections 020805 11:28:15 /usr/local/mysql/libexec/mysqld: Normal shutdown 020805 11:28:15 InnoDB: Starting shutdown... 020805 11:28:26 InnoDB: Shutdown completed 020805 11:28:26 /usr/local/mysql/libexec/mysqld: Shutdown Complete 020805 07:28:26 mysqld ended 020805 07:28:45 mysqld started 020805 11:28:45 InnoDB: Started /usr/local/mysql/libexec/mysqld: ready for connections 020805 11:28:45 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020805 11:29:45 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020805 11:30:45 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020805 11:31:45 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020805 11:32:45 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020805 11:33:45 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020805 11:34:45 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020805 11:35:45 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020805 11:36:45 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020805 11:37:45 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020805 11:38:45 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020805 11:39:45 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020805 11:40:45 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020805 11:41:45 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020805 11:42:45 Slave thread: error connecting to master: Unknown MySQL Server Host '' (4) (107), retry in 60 sec 020805 11:43:45
temporary files,
Hi, It's my first time for using MySQL. I would know, why does it generate such giant temporary files. And what should i do to save my disk from getting filled by these files. Regards Semia - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
temporary files
Hi, It's my first time for using MySQL. I would know, why does it generate such giant temporary files. And what should i do to save my disk from getting filled by these files. Regards Semia - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: RE: null
ok , but I have now just programmed around the error to meet my deadline... -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 6:08 AM To: [EMAIL PROTECTED] Subject: Re: RE: null Mary, Wednesday, August 14, 2002, 7:23:47 PM, you wrote: MS here is is ... MS 'check to see if agent/dist code are already in temp table MS sSql = SELECT * _ MS FROM TempSap _ MS WHERE ProducerID=' FixSQLString( MS rs3!WritingAgentID) ' _ MS AND TaxID=' FixSQLString( rs3!taxid) MS ' _ MS AND DistributionCode=' MS FixSQLString(sDistributionCode) ' MS Call SendToDwDb(sSql, rs5) Mary, it would be nice if you post not only your INSERT statement, but the output of SHOW CREATE TABLE and the output of the query result, too. Provide also exact SELECT statement, i.e. with actual values for producerid, taxid and so on. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Newbie With a Question
* Jones Tyler My problem is that I am unable to change data in an existing table. I use the UPDATE function and it continues to tell me that I am using an Unknown Column. That's right, you are... :) When I do a DESCRIBE on the table, I clearly see the column. Since I can see the column in the describe (named 'Field'), I must be doing something else wrong. This is where you are wrong. When you do a DESCRIBE on a table, you get a table as a result, and this result table has a column named 'Field'. This column is not part of the described table... (try DESCRIBE on any other table, you will allways see the same 'Field' column.) The columns of the DESCRIBE'ed table are those _listed_ in the 'Field' column, and the type of the columns are listed in the 'Type' column. See? Any help would be appreciated. (Thanks to Oscar, but his link seems to be for actually changing the format of a table, which is not my goal...yet=) Actually, in this case you have to change the table definition, and ALTER TABLE is the correct statement. The fix is to change the entry in a row of a table for a particular horizontal entry (or field, if you will). ...the entry in a row... Which row would that be? After I select the dB, I then typed SHOW TABLES and identified the table in question (HUNT_CONFIG). Looking at the Table, I then find the The first column is FIELD and the table entry I am interested in has a FIELD value of regtype. Ok... you did DESCRIBE HUNT_CONFIG, right? The name of the field is 'regtype'. I want to change the entry in the third column for regtype, which is titled VAR. The current value is VAR...? enum('0','1','2') and I need this value to be enum('0','1','2','3') Right. ENUM is a data type, to change the data type is not the same as changing the content of the column. UPDATE is for changing the content of the column. So, I typed the following: UPDATE HUNT_CONFIG SET VAR='enum('0','1','2','3') WHERE FIELD='regtype'; Yes, this is wrong. Try something like: ALTER TABLE HUNT_CONFIG MODIFY regtype enum('0','1','2','3'); -- Roger sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problems connecting
I have the mysqlgui installed on my machine which has Win NT. The db is on another machine, which I connect to using Telnet, and then the mysql command to connect to the db. That works fine. I want to however connect with the gui to the db on the other machine which I connect to using Telnet with an ip address (as I have mentioned). How do I get the gui to connect to the db on the other machine. What do I use as the Host Name, Port number? Please, could you help. Elna Monti Intelligent Metering Systems Tel: 456-8216 Cell: 082-433-0303 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Slow Log
I am having problems with mysql loggin slow queries. I have set up mysql.sh like this log_dir=/home/admin/slow_slog.log $bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file --log-slow-queri es=$log_dir That is all I have changed and re started mysql. but no slow_slog.log file has been created. What have I done wrong? And as you can see from the output from status I have 41 slow querys and not a long uptime Uptime: 8963 Threads: 22 Questions: 258529 Slow queries: 41 Opens: 572 Flush tables: 1 Open tables: 562 Queries per second avg: 28.844 Any clues 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
Re: MySQL 4.0.2, 4.0.3 replication circle broken.
Artem, Thursday, August 15, 2002, 12:06:07 PM, you wrote: AVR In case of repliacation circle (A-B-A) query 'flush log' on any of AVR this servers create endless loop, with creating new binary log file AVR on each iteration. (about 30 new files every second in my case) Thanks for bug report! I tested it yesterday and also have got thousands of log files :( -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: temporary files,
samia, Thursday, August 15, 2002, 3:45:27 PM, you wrote: s It's my first time for using MySQL. s I would know, why does it generate such giant temporary files. And what should i do to save my disk from getting s filled by these files. MySQL uses temporary tables in some queries. So, if you involved into such a query some large tables, temporary files might be big. MySQL store temporary files in the dir that are defined by TMPDIR variable. You can just limit size of this dir, but it's not a good idea. You can also find some info here: http://www.mysql.com/doc/en/Temporary_files.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 root password in mysql for windows
Still could not get it to work so I uninstealled and reinstalled. Will use the anonymous login etc util I figure out this security system. Is there a document that explains the password system in laymans terms? Art -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 4:08 AM To: [EMAIL PROTECTED] Subject: Re: Setting root password in mysql for windows Art, Thursday, August 15, 2002, 7:12:40 AM, you wrote: AF Having a hard time coming to grips with the password setup for mysql in AF windows. I follow the instructions below from the documentation. AF C:\ C:\mysql\bin\mysql mysql AF mysql DELETE FROM user WHERE Host='localhost' AND User=''; AF mysql QUIT AF C:\ C:\mysql\bin\mysqladmin reload AF C:\ C:\mysql\bin\mysqladmin -u root password your_password AF All goes well until the last line and In type mysqladmin -u root password AF my_password. AF I get AF mysqladmin: connect to server at 'localhost' failed AF error: 'Access denied for user: 'root@localhost' (Using password: NO)' AF What is the cause of this and how can I fix it? Does user 'root' have a password? If so, you should use mysqladmin -u root -p password newpassword and enter old password in the password prompt or mysqladmin -u root -poldpassword password newpassword -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 connecting
Elna, Thursday, August 15, 2002, 4:16:59 PM, you wrote: EM I have the mysqlgui installed on my machine which has Win NT. The db is on EM another machine, which I connect to using Telnet, and then the mysql command EM to connect to the db. That works fine. I want to however connect with the EM gui to the db on the other machine which I connect to using Telnet with an EM ip address (as I have mentioned). How do I get the gui to connect to the db EM on the other machine. What do I use as the Host Name, Port number? Host name - name of the host where MySQL server is located (or you can specify IP address) Port - port number that MySQL server are listening for TCP/IP connections. You can show the number of port just running command from mysql client program: SHOW VARIABLES LIKE port; -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Zombie slave process on my master
Bill, Thursday, August 15, 2002, 3:43:03 PM, you wrote: BE Our server seems to think it is a slave. It has a slave thread rnning, BE whose only action is to complain once a minute about not being able to BE connect to master . This just started one day, when we took the server BE down and brought it right back up. BE I'd like to get rid of the slave thread, but I don't know where to start. BE Any ideas appreciated. Check MySQL data dir. Do you have master.info file here? Seems, master.info contains wrong replication info. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FW: temporary files
-Original Message- From: DRISSI,SAMIA (Non-A-hsgGermany,ex1) Sent: Thursday, August 15, 2002 4:06 PM To: [EMAIL PROTECTED] Subject: Hi, Bei running one application on MySQL, the server generates a giant temporary file. At the same time i call the application again, and keep all old parameters values except one. The MySQL server generates once again such a big file. How could i get profit from the old one, so it just keeps track of the parameter, whose value was changed. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
temporary files
HI, MySQL keep the temporary files until it's closed down. Is there somme possibility to remove them as soon as they are no longer needed?? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: CDSISIS
Hi people, I ´ve converted from an ISIS database to Mysql. The opposite also is possible. As you know an ISIS tech database could not be relational. Perhaps you want to make some normalization first. I have done this using ISIS_DLL from VB, firs created an Access Database, exported to text and used a LOAD DATA... If you want to know how to handle ISIS Databases, the best tools and some documentation you can go to http://www.bireme.br You will find a section dedicated to ISIS Technology and ways to access to this data using Java,PHP, VB, Delphi, etc. Using some of this tools (that most are free) you can make a personalized development to make the conversion succesfully. Regards Emiliano. - Original Message - From: Usama Salama [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 6:04 AM Subject: Re: CDSISIS hi i have the same problem with converting CDS ISIS to any other dbms but i know that CDS ISIS can export data in ISO format , the question here , can MySQL import ISO file , and how ? Thanks regards USAMA* _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem starting mysqld on Solaris 2.8 (source distribution)
The mysql user needs write permission on the directory /usr/local/mysql-3.23.51/var Mark Gillett wrote: Having done some further work (I re-built using 3.23.51) I have managed to have the server startup and run, however I am still experiencing the : 020814 15:25:48 /usr/local/mysql-3.23.51/libexec/mysqld: Can't create/write to file '/usr/local/mysql-3.23.51/var/host.domain.pid' (Errcode: 13) Which is v. confusing. the daemon is running and works fine ... just no PID file (so the automated shutdown script won't work etc). Getting there (slowly) Regards, Mark -Original Message- From: Mark Gillett [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 5:26 PM To: [EMAIL PROTECTED] Subject: Re: problem starting mysqld on Solaris 2.8 (source distribution) Hi All (Gerald), Not sure why that should make a difference as the daemon is trying (it claims) to write to /usr/local/mysql/var. Have updated the privs : from ls -al /usr/local/mysql/var total 32 drw-rw-rw- 4 mysqlmysql512 Aug 14 11:27 . drwxr-xr-x 12 mysqlmysql512 Aug 14 10:12 .. -rw-rw-rw- 1 mysqlmysql 4908 Aug 14 11:01 midguard-bin.001 -rw-rw-rw- 1 mysqlmysql 19 Aug 14 11:01 midguard-bin.index -rw-rw-rw- 1 mysqlother 5369 Aug 14 15:25 midguard.sthelier.err drw-rw-rw- 2 mysqlmysql512 Aug 14 11:01 mysql drw-rw-rw- 2 mysqlmysql512 Aug 14 11:01 test and still have the same problem : 020814 15:25:48 mysqld started 020814 15:25:48 /usr/local/mysql-3.23.49/libexec/mysqld: Can't create/write to file '/usr/local/mysql-3.23.49/var/host.domain.pid' (Errcode: 13) 020814 15:25:48 /usr/local/mysql-3.23.49/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020814 15:25:48 /usr/local/mysql-3.23.49/libexec/mysqld: Error on delete of '/usr/local/mysql-3.23.49/var/host.domain.pid' (Errcode: 13) 020814 15:25:48 mysqld ended Good thought though ! Any other ideas ? Regards, Mark From: Gerald Clark Date: Wed, 14 Aug 2002 08:53:17 -0500 --- Look again. /usr/local/mysql is owned by root. Mark Gillett wrote: Hi all, Have built mysql (mysql-3.23.49.tar.gz) --prefix=/usr/local/mysql --with-named-z-libs=no --with-low-memory --enabl e -assembler on a new Solaris machine that we have (v 2.8, patched to June 8_Reccomended patch level). The configure, make and install seemed to go ok and were done as root. I have run the ./scripts/mysql_install_db script and then (here comes the problem) tried to startup the server. cd /usr/local/mysql ./bin/safe_mysqld --user=mysql but the bad news is that it doesn't appear to work: # Starting mysqld daemon with databases from /usr/local/mysql/var 020814 12:00:18 mysqld ended when I look in the .err file (usr/local/mysql/var/hostname.domain.err), I see : (tail hostname.domain.err) ---snip 020814 11:28:44 mysqld started 020814 11:28:44 /usr/local/mysql/libexec/mysqld: Can't create/write to file '/usr/local/mysql/var/hostname.domain.pid' (Errcode: 13) 020814 11:28:44 /usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host .frm' (errno: 13) 020814 11:28:44 /usr/local/mysql/libexec/mysqld: Error on delete of '/usr/local/mysql/var/hostname.domain.pid' (Errcode: 13) 020814 11:28:44 mysqld ended snip So I checked the ownership on the /usr/local/mysql/var directory etc: chgrp -R mysql /usr/local/mysql/var chown -R mysql /usr/local/mysql/var and ls -al shows that this lot seems ok : ---snip total 28 drw-rw-rw- 4 mysqlmysql512 Aug 14 11:27 . drwxr-xr-x 12 root mysql512 Aug 14 10:12 .. -rw-rw-rw- 1 mysqlmysql 4908 Aug 14 11:01 hostname-bin.001 -rw-rw-rw- 1 mysqlmysql 19 Aug 14 11:01 hostname-bin.index -rw-rw-rw- 1 mysqlother 3124 Aug 14 11:28 hostname.domain.err drw-rw-rw- 2 mysqlmysql512 Aug 14 11:01 mysql drw-rw-rw- 2 mysqlmysql512 Aug 14 11:01 test ---snip What am I missing ? Any ideas on the cause of this problem ? Thanks for your assistance (would be grateful for direct as well as list response as I am slower in wading through the lists than I would like!), Regards, Mark --- Mark Gillett IXIF Limited - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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:
RE: View current connections
Thanks for the reply Egor.. This helps, but what I'm really hoping to find is a GUI that updates itself on the fly, kind of like the Win2k Task Manager processes tab. Anybody got anything like this? -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 7:08 AM To: [EMAIL PROTECTED] Subject: Re: View current connections Tab, Wednesday, August 14, 2002, 11:06:36 PM, you wrote: TA Is there a tool out there for Windows that will let me monitor how TA many connections to my MySQL database are currently open at any TA given moment? Use SHOW PROCESSLIST command: http://www.mysql.com/doc/en/SHOW_PROCESSLIST.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
myisampack/myisamchk question
I got an error while executing myisamchk -rq on compressed table. Here's the output: [root@db prod_rel5_1_0]# myisampack buyer Compressing buyer.MYD: (3687550 records) - Calculating statistics - Compressing file 62.69% Remember to run myisamchk -rq on compressed tables [root@db prod_rel5_1_0]# myisamchk -rq buyer - check key delete-chain - check record delete-chain - recovering (with sort) MyISAM-table 'buyer.MYI' Data records: 3687550 - Fixing index 1 myisamchk: error: Found too many records; Can`t continue MyISAM-table 'buyer' is not fixed because of errors Try fixing it by using the --safe-recover (-o) or the --force (-f) option [root@db prod_rel5_1_0]# myisamchk -roq buyer - check key delete-chain - check record delete-chain - recovering (with keycache) MyISAM-table 'buyer.MYI' Data records: 3668074 Data records: 3687550 So, using myisamchk -roq solved the problem. My question is, what is the purpose of the error that I get and is it safe? Mihail Manolov Government Liquidation, LLC 202 467 6868 x.227 [EMAIL PROTECTED] www.govliquidation.com sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: View current connections
...I'm really hoping to find is a GUI that updates itself on the fly, kind of like the Win2k Task Manager processes tab. Anybody got anything like this? I am really happy with this one http://www.anse.de/mysqlfront/ It can do that and a lot of other nice features. Best regards, Mikhail. - Original Message - From: Tab Alleman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 5:01 PM Subject: RE: View current connections Thanks for the reply Egor.. This helps, but what I'm really hoping to find is a GUI that updates itself on the fly, kind of like the Win2k Task Manager processes tab. Anybody got anything like this? -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 7:08 AM To: [EMAIL PROTECTED] Subject: Re: View current connections Tab, Wednesday, August 14, 2002, 11:06:36 PM, you wrote: TA Is there a tool out there for Windows that will let me monitor how TA many connections to my MySQL database are currently open at any TA given moment? Use SHOW PROCESSLIST command: http://www.mysql.com/doc/en/SHOW_PROCESSLIST.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
I cannot get mysql to run.
-- Forwarded Message -- Subject: I cannot get mysql to run. Date: Thu, 15 Aug 2002 11:02:08 +0100 From: Barry Schofield [EMAIL PROTECTED] To: [EMAIL PROTECTED] 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: [I have tried rpm's and 4.0 version and your 3.23.51-pc-linux-gnu-i686.tar.gz and I cannot get anything to run. I am even following the instructions in appendix A of isbn 0-672-31784-2 SAMS php and mysql web development. ] Description: [root@localhost mysql]# ./bin/mysqladmin version ./bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! [root@localhost mysql]# I have checked this and the socks in this directory says 0 bytes. How-To-Repeat: ./bin/mysqladmin version Fix: unable to get round the problem Submitter-Id: submitter ID Originator:root on Redhat 7.3 [EMAIL PROTECTED] Organization: Barry Schofield Lion Communications MySQL support: [ email support ] Synopsis: synopsis of the problem (one line) Severity: [ critical ] Priority: [ high ] Category: mysql Class: [ support ] Release: mysql-3.23.51 (Source distribution) Environment: machine, os, target, libraries (multiple lines) System: Linux localhost.localdomain 2.4.18-3 #1 Thu Apr 18 07:37:53 EDT 2002 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.3 2.96-110) Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=pentiumpro' CXX='gcc' CXXFLAGS='-O2 -mcpu=pentiumpro -felide-constructors' LDFLAGS='-static' LIBC: lrwxrwxrwx1 root root 13 Aug 5 18:03 /lib/libc.so.6 - libc-2.2.5.so -rwxr-xr-x1 root root 1260480 Apr 15 14:44 /lib/libc-2.2.5.so -rw-r--r--1 root root 2310808 Apr 15 15:02 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 15 14:55 /usr/lib/libc.so Configure command: ./configure --enable-assembler --with-other-libc=/usr/local/mysql 'CFLAGS=-O2 -mcpu=pentiumpro' 'CXXFLAGS=-O2 -mcpu=pentiumpro -felide-constructors' CXX=gcc LDFLAGS=-static Overall: I have tried rpm's and 4.0 version and your 3.23.51-pc-linux-gnu-i686.tar.gz and I cannot get anything to run. I am even following the instructions in appendix A of isbn 0-672-31784-2 SAMS php and mysql web development. [root@localhost mysql]# ./bin/mysqladmin version ./bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! [root@localhost mysql]# I have checked this and the socks in this directory says 0 bytes. report from : localhost localdomain.err 020815 10:29:46 mysqld started 020815 10:29:46 /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysql/data/localhost.localdomain.pid' (Errcode: 13) 020815 10:29:46 /usr/local/mysql/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020815 10:29:46 /usr/local/mysql/bin/mysqld: Error on delete of '/usr/local/mysql/data/localhost.localdomain.pid' (Errcode: 13) 020815 10:29:46 mysqld ended mysql-3.23.51-pc-linux-gnu-i686/configure [root@localhost local]# cd mysql [root@localhost mysql]# ./configure --prefix=/usr/local/mysql NOTE: This is a MySQL binary distribution. It's ready to run, you don't need to configure it! To help you a bit, I am now going to create the needed MySQL databases and start the MySQL server for you. If you run into any trouble, please consult the MySQL manual, that you can find in the Docs directory. Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables 020815 10:29:46 ./bin/mysqld: Shutdown Complete To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: ./bin/mysqladmin -u root -p password 'new-password' ./bin/mysqladmin -u root -h localhost.localdomain -p password 'new-password' See the manual for more instructions. You can start the MySQL daemon with: cd . ; ./bin/safe_mysqld You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; run-all-tests Please report any problems with the ./bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com Starting the mysqld server. You can
Fwd: Cannot run any I configure
-- Forwarded Message -- Subject: Cannot run any I configure Date: Thu, 15 Aug 2002 11:08:26 +0100 From: Barry Schofield [EMAIL PROTECTED] To: [EMAIL PROTECTED] From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [I have tried rpm's and 4.0 version and your 3.23.51-pc-linux-gnu-i686.tar.gz and I cannot get anything to run. I am even following the instructions in appendix A of isbn 0-672-31784-2 SAMS php and mysql web development. ] Description: [root@localhost mysql]# ./bin/mysqladmin version ./bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! [root@localhost mysql]# I have checked this and the socks in this directory says 0 bytes. How-To-Repeat: ./bin/mysqladmin version Fix: unable to get round the problem Submitter-Id: submitter ID Originator:root on Redhat 7.3 [EMAIL PROTECTED] Organization: Barry Schofield Lion Communications MySQL support: [ email support ] Synopsis: synopsis of the problem (one line) Severity: [ critical ] Priority: [ high ] Category: mysql Class: [ support ] Release: mysql-3.23.51 (Source distribution) Environment: machine, os, target, libraries (multiple lines) System: Linux localhost.localdomain 2.4.18-3 #1 Thu Apr 18 07:37:53 EDT 2002 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.3 2.96-110) Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=pentiumpro' CXX='gcc' CXXFLAGS='-O2 -mcpu=pentiumpro -felide-constructors' LDFLAGS='-static' LIBC: lrwxrwxrwx1 root root 13 Aug 5 18:03 /lib/libc.so.6 - libc-2.2.5.so -rwxr-xr-x1 root root 1260480 Apr 15 14:44 /lib/libc-2.2.5.so -rw-r--r--1 root root 2310808 Apr 15 15:02 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 15 14:55 /usr/lib/libc.so Configure command: ./configure --enable-assembler --with-other-libc=/usr/local/mysql 'CFLAGS=-O2 -mcpu=pentiumpro' 'CXXFLAGS=-O2 -mcpu=pentiumpro -felide-constructors' CXX=gcc LDFLAGS=-static Overall: I have tried rpm's and 4.0 version and your 3.23.51-pc-linux-gnu-i686.tar.gz and I cannot get anything to run. I am even following the instructions in appendix A of isbn 0-672-31784-2 SAMS php and mysql web development. [root@localhost mysql]# ./bin/mysqladmin version ./bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! [root@localhost mysql]# I have checked this and the socks in this directory says 0 bytes. report from : localhost localdomain.err 020815 10:29:46 mysqld started 020815 10:29:46 /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysql/data/localhost.localdomain.pid' (Errcode: 13) 020815 10:29:46 /usr/local/mysql/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020815 10:29:46 /usr/local/mysql/bin/mysqld: Error on delete of '/usr/local/mysql/data/localhost.localdomain.pid' (Errcode: 13) 020815 10:29:46 mysqld ended mysql-3.23.51-pc-linux-gnu-i686/configure [root@localhost local]# cd mysql [root@localhost mysql]# ./configure --prefix=/usr/local/mysql NOTE: This is a MySQL binary distribution. It's ready to run, you don't need to configure it! To help you a bit, I am now going to create the needed MySQL databases and start the MySQL server for you. If you run into any trouble, please consult the MySQL manual, that you can find in the Docs directory. Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables 020815 10:29:46 ./bin/mysqld: Shutdown Complete To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: ./bin/mysqladmin -u root -p password 'new-password' ./bin/mysqladmin -u root -h localhost.localdomain -p password 'new-password' See the manual for more instructions. You can start the MySQL daemon with: cd . ; ./bin/safe_mysqld You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; run-all-tests Please report any problems with the ./bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com Starting the mysqld server. You can test that it is up and running with the command: ./bin/mysqladmin version [root@localhost mysql]# Starting mysqld daemon with
RE: View current connections
Is the MySQL serving a web site? If yes, wrap show processlist in perl or php and have it generate an auto refreshing page. On Thu, 15 Aug 2002, Tab Alleman wrote: Date: Thu, 15 Aug 2002 11:01:44 -0400 From: Tab Alleman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: View current connections Thanks for the reply Egor.. This helps, but what I'm really hoping to find is a GUI that updates itself on the fly, kind of like the Win2k Task Manager processes tab. Anybody got anything like this? -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 7:08 AM To: [EMAIL PROTECTED] Subject: Re: View current connections Tab, Wednesday, August 14, 2002, 11:06:36 PM, you wrote: TA Is there a tool out there for Windows that will let me monitor how TA many connections to my MySQL database are currently open at any TA given moment? Use SHOW PROCESSLIST command: http://www.mysql.com/doc/en/SHOW_PROCESSLIST.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Slow Log
Did you check your error logs? Does mysql have write permissions to /home/admin ? John Wards wrote: I am having problems with mysql loggin slow queries. I have set up mysql.sh like this log_dir=/home/admin/slow_slog.log $bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file --log-slow-queri es=$log_dir That is all I have changed and re started mysql. but no slow_slog.log file has been created. What have I done wrong? And as you can see from the output from status I have 41 slow querys and not a long uptime Uptime: 8963 Threads: 22 Questions: 258529 Slow queries: 41 Opens: 572 Flush tables: 1 Open tables: 562 Queries per second avg: 28.844 Any clues 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
warnings in 4.x
Does anyone know if version 4.x has/will have warnings if data being inserted is too large for a column? sql,query -- Walter Anthony System Administrator National Electronic Attachment Atlanta, Georgia 1-800-782-5150 ext. 1608 If it's not broketweak 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
Mysql Table Case
Hello, Is there a compile option or startup option to make mysql ignore table name case? So that the tables security and Security would be seen as the same table? -James James Kelty Director of Operations Everbase Systems, LLC 624 A Street Ashland, OR 97520 [EMAIL PROTECTED] 541.488.0801 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Primary key info in C API
Typically when using the C API, when you do a Select, MySQL hands back a virtual table where the fields (columns) are marked with various kinds of info - their name and source table, as you might expect, but also stuff like whether this field is the primary key for its table. So for example if I say this: select * from products join units where products.productid = units.productid I get back a table with all the fields from both products and units, and products.productid is marked as primary, and so is units.unitid (which is correct). Now for the problem. When I use the order by keyword, as follows: select * from products join units where products.productid = units.productid order by productnumber the primary key information doesn't arrive. Should it, or am I expecting too much? -- Michael __ ||| Michael Collins ||| ||| Kuwago Inc||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Mysql Table Case
Answer is No. Case-sensitivity of table names depends on operating system you are running mysql on.MySQL stores table definitions in TABLENAME.* files. So it will always be case-sensitive on *nix and case-insensitive on windows. Nilesh -Original Message- From: James Kelty [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 12:59 PM To: [EMAIL PROTECTED] Subject: Mysql Table Case Hello, Is there a compile option or startup option to make mysql ignore table name case? So that the tables security and Security would be seen as the same table? -James James Kelty Director of Operations Everbase Systems, LLC 624 A Street Ashland, OR 97520 [EMAIL PROTECTED] 541.488.0801 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Table Case
At 9:59 -0700 8/15/02, James Kelty wrote: Hello, Is there a compile option or startup option to make mysql ignore table name case? So that the tables security and Security would be seen as the same table? --set-variable=lower_case_table_names=1 But you should rename your tables to lowercase first before enabling this. -James James Kelty Director of Operations Everbase Systems, LLC 624 A Street Ashland, OR 97520 [EMAIL PROTECTED] 541.488.0801 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Table Case
Well, I guess that ISN'T really the case. http://www.mysql.com/doc/en/Name_case_sensitivity.html Sorry that I asked the question at all, but thanks for the replies. -James -Original Message- From: Nilesh Shah [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 10:20 AM To: James Kelty; [EMAIL PROTECTED] Subject: RE: Mysql Table Case Answer is No. Case-sensitivity of table names depends on operating system you are running mysql on.MySQL stores table definitions in TABLENAME.* files. So it will always be case-sensitive on *nix and case-insensitive on windows. Nilesh -Original Message- From: James Kelty [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 12:59 PM To: [EMAIL PROTECTED] Subject: Mysql Table Case Hello, Is there a compile option or startup option to make mysql ignore table name case? So that the tables security and Security would be seen as the same table? -James James Kelty Director of Operations Everbase Systems, LLC 624 A Street Ashland, OR 97520 [EMAIL PROTECTED] 541.488.0801 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: RES: Aggregate + left outer join (Solution)
Hi Eduardo, I found the solution the left outer join + aggregate problem I had earlier faced. the query should be SELECT p.nm_project, sum( dl.hours) FROM PROJECT p LEFT OUTER JOIN DAYLOG dl ON (p.id_project = dl.id_project AND MONTH(dl.DATE) = 8 AND (YEAR(dl.DATE) = 2002 ) GROUP BY p.id_project; Thanks for your help. -Manu - Forwarded by manu manickalal/PRTGROUP on 15-08-02 01:03 PM - |+ || mmanickalal@en| || herent.com| ||| || 09-08-02 04:49| || PM| ||| |+ ---| | | | To: [EMAIL PROTECTED] | | cc: (bcc: manu manickalal/PRTGROUP) | | Subject: Re: RES: Aggregate + left outer join | ---| Eduardo, Thanks for the reply, but I still get only one record for prj1. While prj2 does not show up with 0 hours. CREATE TABLE PROJECT ( ID_PROJECT int(11) NOT NULL auto_increment, NM_PROJECT varchar(255) NOT NULL default '' PRIMARY KEY (ID_PROJECT) ) TYPE=MyISAM; INSERT INTO PROJECT VALUES (100,'prj1'); INSERT INTO PROJECT VALUES (101,'prj2'); CREATE TABLE DAYLOG ( ID_PROJECT int(11) NOT NULL default '0', DATE datetime NOT NULL default '-00-00 00:00:00', HOURS float NOT NULL default '0', PRIMARY KEY (ID_PROJECT,DATE) ) TYPE=MyISAM; INSERT INTO DAYLOG VALUES (100,'2002-08-17 00:00:00',8); INSERT INTO DAYLOG VALUES (100,'2002-08-18 00:00:00',8); Thanks, -Manu |+--- || Eduardo Stopa| || eduardos@comolat| || ti.com.br | || | || 09-08-02 04:25 PM| || | |+--- ---| | | | To: manu manickalal/PRTGROUP| | cc: | | Subject: RES: Aggregate + left outer join | ---| Hi, Try the following query : SELECT p.id_project, p.nm_project, sum( dl.hours) FROM PROJECT p LEFT OUTER JOIN DAYLOG dl ON (p.id_project = dl.id_project) WHERE (MONTH(dl.DATE) = 8 AND (YEAR(dl.DATE) = 2002) or (dl.DATE is NULL) GROUP BY p.id_project Best Regards Eduardo - Mensagem original - De: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Enviada em: sexta-feira, 9 de agosto de 2002 17:13 Para: [EMAIL PROTECTED] Assunto:Aggregate + left outer join Hi, I am relatively new to MySQL.. I am having trouble getting an aggregate function and an outer join to work together. I have two tables PROJECT (id_project, nm_project) 100, prj1 101, prj2 DAYLOG (id_project, date, hours) 100, 2002-08-17, 8 100, 2002-08-18, 8 DAYLOG table contains number of hours booked against a project for a date. I needed to list the total hours booked against each project for any given month. My query SELECT p.id_project, p.nm_project, sum( dl.hours) FROM PROJECT p LEFT OUTER JOIN DAYLOG dl ON (p.id_project = dl.id_project) WHERE MONTH(dl.DATE) = 8 AND YEAR(dl.DATE) = 2002 GROUP BY p.id_project ++++ | id_project | nm_project | sum( dl.hours) | ++++ |100 | prj1 | 16 | ++++ The problem with this result set is that it does not have projects with zero hours booked. ie. . if there are no records in DAYLOG, then that project is not displayed. I was expecting the left outer join to pick up records (prj2) from PROJECT even if there are no records in DAYLOG. So I tried another variation with the select SELECT p.id_project, p.nm_project, sum( dl.hours)+
Load Data Warnings
I have been using the following code and have been getting warnings: LOAD DATA INFILE 'myfile' INTO TABLE mytable FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' (myfields); Query OK, 206 rows affected (0.13 sec) Records: 206 Deleted: 0 Skipped: 0 Warnings: 14 How do I find out what the warnings are? I haven't been able to find anything about what they are. Please Help! -- ___ Brian Fahey, Web DeveloperOregon Dept of Agriculture [EMAIL PROTECTED] Voice: 503.986.4736 http://oda.state.or.us/FAX: 503.986.4746 ___ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Warnings
I have been using the following code and have been getting warnings: LOAD DATA INFILE 'myfile' INTO TABLE mytable FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' (myfields); Query OK, 206 rows affected (0.13 sec) Records: 206 Deleted: 0 Skipped: 0 Warnings: 14 How do I find out what the warnings are? I haven't been able to find anything about what they are. Please Help! -- ___ Brian Fahey, Web DeveloperOregon Dept of Agriculture [EMAIL PROTECTED] Voice: 503.986.4736 http://oda.state.or.us/FAX: 503.986.4746 ___ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
test and test\_%
I have a database called test in the mysql database db table it is listed as test and test\_% what is the significance of two record that have all the Y/N entries the same? . - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Load Data Warnings
On 15 Aug 2002, at 10:45, Brian Fahey wrote: How do I find out what the warnings are? I haven't been able to find anything about what they are. Paul DuBois has a Perl script, load_diag.pl, that could answer your question: http://www.kitebird.com/mysql-cookbook/ Or you could export the data and compare the output file with the input file. [Filter fodder: SQL] -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 3.23 problems on BSDI 4.1
I downloaded and built mysql-3.23.49 on my BSDI 4.1 system. It configured and built fine, but it hangs whenever I do more than the most trivial operations. It is my dim recollection that there have been problems with the thread libraries in the past. Does this ring a bell? (I can't use the prebuilt 4.2 binaries, because I'm not running 4.2 yet.) -- John R. Levine, IECC, POB 727, Trumansburg NY 14886 +1 607 387 6869 [EMAIL PROTECTED], Village Trustee and Sewer Commissioner, http://iecc.com/johnl, Member, Provisional board, Coalition Against Unsolicited Commercial E-mail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Query help
filter fodder: sql, query Hi all, I feel like I am probly being amazingly stupid, but here goes nothing. I have 3 tables: students undergrads postgrads students holds all common info. eg dt_matric, dob, religion, etc. undergrads hold eg. degree, subject postgrads holds eg. transfer_date, thesis_title What I need to do is something like this (it does _not_ work): set @acyear:='2001'; select students.course_yr, students.dt_start, students.surname, qual_types.abbrv, qual_subjects.name from students, if ( students.st_type='PG',postgrads, undergrads), qual_types, qual_subjects where (postgrads.qskey=qual_subjects.qsid andpostgrads.qtkey=qual_types.qtid andpostgrads.studentkey=students.studentid) or(undergrads.qskey=qual_subjects.qsid andundergrads.qtkey=qual_types.qtid andundergrads.studentkey=students.studentid) and students.studentid=4; how in £$%£$ name can I do this? Donna - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: joining to tables
Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Hi! Probably an easy problem, but I couldn't find any solution on the net.. I have (about) this code: select * from tabell1 where page regexp '$page' and published is not null order by pri desc, published desc limit $this-fra, $this-ant Then, I want to join another table who is has the same structure as this one, except it has an extra row. I then tried this: select * from tabell1, tabell2 where tabell1.temaid = '$this-temaid' and tabell2.temaid = '$this-temaid' order by $this-tabell.pri desc, $this-tabell.published desc limit $this-fra, $this-ant But then I got the same stories in this to tables a lot of times. What is wrong? How do i do this right? (a link to a page with a solution would bee fine). Henrik - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with joining multiple tables
I am having some problems getting multiple joins to work. I have the following code: mysql select customers.customer_id, last, first, company, count(work_order.work_order_number) as WO - from customers left join work_order - on (customers.customer_id=work_order.customer_id) - where customers.last like G% - group by customers.customer_id - order by company, last; Which returns: +-+++---++ | customer_id | last | first | company | WO | +-+++---++ | 83 | Gallagher | Sherry | | 1 | | 84 | Gersh | Duff | | 0 | | 85 | Glasebrook | Millie | | 1 | | 86 | Gordley| Amy| | 1 | | 88 | Grant | Don Mimi | | 1 | | 90 | Graziano | Margaret | | 1 | | 91 | Gressard | Dave | | 1 | | 93 | Grey | Hellen | | 1 | | 95 | Grismer| Dennis | | 1 | | 96 | Guy| Susan | | 1 | | 334 | Gagnon | Bonnie | Cayuse Prairie School | 1 | | 87 | Gotschalk | Jill | Gotschalk's Graphics | 1 | | 94 | Greytak| Don| Old Library Gallery | 1 | | 92 | Grewe | Judy | Ponderosa Gallery | 1 | | 89 | Gray | Darryl | Spirit Talk Press | 0 | +-+++---++ 15 rows in set (0.36 sec) And this code: mysql select customers.customer_id, last, first, company, count(computers.computer_id) as CPU - from customers left join computers - on (customers.customer_id=computers.customer_id) - where customers.last like G% - group by customers.customer_id - order by company, last; Which returns: +-+++---+-+ | customer_id | last | first | company | CPU | +-+++---+-+ | 83 | Gallagher | Sherry | | 0 | | 84 | Gersh | Duff | | 1 | | 85 | Glasebrook | Millie | | 1 | | 86 | Gordley| Amy| | 0 | | 88 | Grant | Don Mimi | | 0 | | 90 | Graziano | Margaret | | 0 | | 91 | Gressard | Dave | | 0 | | 93 | Grey | Hellen | | 0 | | 95 | Grismer| Dennis | | 0 | | 96 | Guy| Susan | | 0 | | 334 | Gagnon | Bonnie | Cayuse Prairie School | 0 | | 87 | Gotschalk | Jill | Gotschalk's Graphics | 2 | | 94 | Greytak| Don| Old Library Gallery | 0 | | 92 | Grewe | Judy | Ponderosa Gallery | 0 | | 89 | Gray | Darryl | Spirit Talk Press | 1 | +-+++---+-+ 15 rows in set (0.01 sec) I am trying to combine these 2 into 1 table, I tried the following: mysql select customers.customer_id, last, first, company, count(work_order.work_order_number) as WO, count(computers.computer_id) as CPU - from customers left join work_order - on (customers.customer_id=work_order.customer_id) - left join computers - on (customers.customer_id=computers.customer_id) - where customers.last like G% - group by customers.customer_id - order by company, last; Which gives me: +-+++---++-+ | customer_id | last | first | company | WO | CPU | +-+++---++-+ | 83 | Gallagher | Sherry | | 1 | 0 | | 84 | Gersh | Duff | | 0 | 1 | | 85 | Glasebrook | Millie | | 1 | 1 | | 86 | Gordley| Amy| | 1 | 0 | | 88 | Grant | Don Mimi | | 1 | 0 | | 90 | Graziano | Margaret | | 1 | 0 | | 91 | Gressard | Dave | | 1 | 0 | | 93 | Grey | Hellen | | 1 | 0 | | 95 | Grismer| Dennis | | 1 | 0 | | 96 | Guy| Susan | | 1 |
Can't locate loadable object DBD::mysql in @INC
Hello Everyone, We are attempting to use a Perl script to access MySQL on Red Hat Linux release 7.2 (Enigma) Kernel 2.4.7-10 on an i686 Unfortunately, the below error keeps appearing: - install_driver(mysql) failed: Can't locate loadable object for module DBD::mysql in @INC (@INC contains: /usr/lib/perl5/5.6.0/i386-linux /usr/lib/perl5/5.6.0 /usr/lib/perl5/site_perl/5.6.0/i386-linux /usr/lib/perl5/site_perl/5.6.0 /usr/lib/perl5/site_perl .) at (eval 1) line 3 Compilation failed in require at (eval 1) line 3. Perhaps a module that DBD::mysql requires hasn't been fully installed at ./mysqltest1 line 7 --- We have installed: mysql-3.23.49-3.i386.rpm mysql-server-3.23.49-3.i386.rpm mysql-devel-3.23.49-3.i386.rpm Msql-Mysql-modules-1.2219 DBI-1.30 DBD-mysql-2.1018 All have tested fine. Of course, mySQL works fine with PHP scripts. We have also upgraded Perl from 5.6 to 5.8 using cpan. Addionally we have copied the objects to the directory that @INC is looking in. cp -p -R /usr/local/lib/perl5/site_perl/5.8.0/i686-linux /usr/lib/perl5/5.6.0/i386-linux Now we receive this error: -- /usr/bin/perl: error while loading shared libraries: /usr/lib/perl5/5.6.0/i386-linux/auto/DBD/mysql/mysql.so: undefined symbol: Perl_get_sv - My guess would be to get @INC {per the initial error} to look into the proper directory {/usr/local/lib/perl5/site_perl/5.8.0/i686-linux} and not {/usr/lib/perl5/5.6.0/i386-linux} Where is the @INC and how can we change it? or any added advice would be appreciated. Thanks in advance. Nik - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Losing data
Hej I have several databases with several tables in them and all works fine except for one database that loses data. I'm running mySQL 4.0.1-alpha-nt and the tables are all INNODB. The problem is as follows: Table B references table A by a foreign key. I've filled table A with all the data I want and are adding data to table B. After a couple of items, only a few of the items are still in the table. Sometimes the other items reappear after a couple of minutes, in other cases all items dissapear. Sometimes when I run a select statement I get an error message from the table handler error code 127. But I have no idea what that means. Has anyone experienced anything like this!? It's just to weird! I have no idea what to do and are ready to give up and export it all to linux and postgreSQL instead. Anna This message was sent using SkyBURST Mail Center. http://www.skyburst.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
Table locking questions
Hi everyone! I'm fairly familiar with the table locking methods in MySQL but I have a problem I can't solve. I have two main tables which are read simultaneously by many clients. The clients only do reads, but they do it very extensively and for 30 secs each. The two main tables needs updates every 30-45 minutes. The process that updates the tables lasts about 50 secs (several queries, updates and inserts). All my tables are properly indexed using EXPLAIN and all the tables are MyISAM types. I'm using MySQL v3.23.47 All the processes are background processes. The problem: Doing a write lock on the two main tables ensures that no clients can access the tables while they are updated, but what about the clients who are in the middle of a chain of queries from the main tables? Solutions? A) The process that updates the main tables can maintain a version number which increases every time the tables are updated. The process WRITE locks the main tables and thus freezez the many clients reading from them. A client reads the version number from the tables before it starts to do its many queries. When the client is finished processing the tables, it reads the version numbers again and compares them. If they are not the same, the process must have been freezed and must be restarted again. The solution is fairly simple to implement, but the problem is the many client programs taking up resources while they are frozen. Any suggestions? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
LIMITing result sets - Spoiled by MySQL
I am used to working in MySQL, and am now working with MS SQLServer :( I'm hoping someone else has been in this unfortunate situation before and can help me out. I'm looking to do pagination of some resultset in JSP. in MySQL I would have used something like: SELECT * FROM mytable ORDER BY somedatefield LIMIT 20,30 to get the third page of results with 10 results per page. MSSQL offers me NOTHING as kind as LIMIT. I have a query that returns ~60,000 results, and I don't want to have to grab them all on each page, and then move to the range that I need. Thanks for the help, MIchael - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: LIMITing result sets - Spoiled by MySQL
Hi, I don't know MSSQL well, but what about TOP ? Regards, Jocelyn - Original Message - From: Michael Marano [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 10:37 PM Subject: LIMITing result sets - Spoiled by MySQL I am used to working in MySQL, and am now working with MS SQLServer :( I'm hoping someone else has been in this unfortunate situation before and can help me out. I'm looking to do pagination of some resultset in JSP. in MySQL I would have used something like: SELECT * FROM mytable ORDER BY somedatefield LIMIT 20,30 to get the third page of results with 10 results per page. MSSQL offers me NOTHING as kind as LIMIT. I have a query that returns ~60,000 results, and I don't want to have to grab them all on each page, and then move to the range that I need. Thanks for the help, MIchael - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: LIMITing result sets - Spoiled by MySQL
Well, I am not sure about MS, but in Oracle you have to use the rownum pseudocolumn and a pseudocolumn, an example: SELECT * FROM (SELECT * FROM mytable ORDER BY somedatefield) WHERE rownum 20 AND rownum 30; or something like that. It may be similar for MSsql, I am not sure. Mike P.S. my example may be wrong, it's been a while since I went to mySQL, and I have not gone back to Oracle. -Original Message- From: Michael Marano [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 2:37 PM To: [EMAIL PROTECTED] Subject: LIMITing result sets - Spoiled by MySQL I am used to working in MySQL, and am now working with MS SQLServer :( I'm hoping someone else has been in this unfortunate situation before and can help me out. I'm looking to do pagination of some resultset in JSP. in MySQL I would have used something like: SELECT * FROM mytable ORDER BY somedatefield LIMIT 20,30 to get the third page of results with 10 results per page. MSSQL offers me NOTHING as kind as LIMIT. I have a query that returns ~60,000 results, and I don't want to have to grab them all on each page, and then move to the range that I need. Thanks for the help, MIchael - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Supplied argument is not a valid MySQL result resource!!
Hi, in the piece of code given below --- $qid = mysql_query( SELECT * FROM 1_nodedata WHERE id = $edit_id ); $frm = mysql_fetch_array($qid); --- i get the follownig error: Warning: Supplied argument is not a valid MySQL result resource in /z/mercury/www/niksun/admin/add_doc.php on line 107 element type: What is it happening so!! regards anil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Losing data
Anna, please check with SHOW VARIABLES if InnoDB is enabled in mysqld. Also check with SHOW CREATE TABLE tablename that your tables really are of the InnoDB type. Error 127 means the 'table is crashed', and I think only MyISAM type tables can return that error number. An upgrade to 4.0.2 is recommended because 4.0.1 is an alpha version, and already 8 months old. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com - Original Message - From: Anna Carlsson [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Thursday, August 15, 2002 11:33 PM Subject: Losing data Hej I have several databases with several tables in them and all works fine except for one database that loses data. I'm running mySQL 4.0.1-alpha-nt and the tables are all INNODB. The problem is as follows: Table B references table A by a foreign key. I've filled table A with all the data I want and are adding data to table B. After a couple of items, only a few of the items are still in the table. Sometimes the other items reappear after a couple of minutes, in other cases all items dissapear. Sometimes when I run a select statement I get an error message from the table handler error code 127. But I have no idea what that means. Has anyone experienced anything like this!? It's just to weird! I have no idea what to do and are ready to give up and export it all to linux and postgreSQL instead. Anna This message was sent using SkyBURST Mail Center. http://www.skyburst.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: creating a database without being an administrator
is there a way to give certain users rights to create and drop mysql databases without being administrators? I'd like to create a new database every time a user runs my code on a new set of data. thanks Josh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Supplied argument is not a valid MySQL result resource!!
Anil, You never created a connection. mysql_connect() Regards. Thursday, August 15, 2002, 1:12:21 PM, you wrote: Hi, in the piece of code given below --- $qid = mysql_query( SELECT * FROM 1_nodedata WHERE id = $edit_id ); $frm = mysql_fetch_array($qid); --- i get the follownig error: Warning: Supplied argument is not a valid MySQL result resource in /z/mercury/www/niksun/admin/add_doc.php on line 107 element type: What is it happening so!! regards anil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Supplied argument is not a valid MySQL result resource!!
hi, m sorry i dint mention that its just a part of code. i am able to delete entries from the database .so i think mysql_connect is not the reason. please tell if u have some more ideas regards anil - Original Message - From: SteveH [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 4:50 PM Subject: Re: Supplied argument is not a valid MySQL result resource!! Anil, You never created a connection. mysql_connect() Regards. Thursday, August 15, 2002, 1:12:21 PM, you wrote: Hi, in the piece of code given below --- $qid = mysql_query( SELECT * FROM 1_nodedata WHERE id = $edit_id ); $frm = mysql_fetch_array($qid); --- i get the follownig error: Warning: Supplied argument is not a valid MySQL result resource in /z/mercury/www/niksun/admin/add_doc.php on line 107 element type: What is it happening so!! regards anil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Losing data more info
create table EAP (eapID int auto_increment primary key, Name varchar(60), Addr1 varchar(50), Addr2 varchar(50), City varchar(30), State varchar(2), index state_ind(state), Foreign key (State) references State(StateShort), Zip varchar(5), RevisionDate Date, FundingSource varchar(15), CEnumber varchar(10), CompanyContact varchar(150), Eligibility text, ProbationaryPeriod text, Sessions text, Copay text, InsuranceInfo text, RequiredForms text, Instructions text ) type = innodb; create table ForCompany (ForCompanyID int auto_increment primary key, eapID int, index eap_ind(eapID), Foreign key (eapID) references EAP(eapID), Name varchar(50) ) type = innodb; These are the tables. It's table ForCompany that loses data. It doesn't really matter what query I run, I've tried a few different. Examples: 1. Select * from ForCompany where eapID = $number; 2. Select * from ForComany; The result differs from time to time. I have put 10 items in table ForCompany and every second time I run query 2 only two items show up, or four, or none at all. I had the database on mySQL 3.23.36 and upgraded recently to 4.0.1-alpha-nt, but nothing changed. I've tried to drop the database and create everything from scratch, but that didn't help either. I couldn't find anything like this in the bug report, and I find it highly unlikly that it is a bug. Someone else should have encountered it long ago. Is there some kind of property I don't know about? The other 4 database are working fine. One of them is in production and I'd like to put the rest in production to, but I don't dare do that until I've found out why this db is misbehaving. Anna This message was sent using SkyBURST Mail Center. http://www.skyburst.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problem connecting to mysql with gui
please how can i set Sql command on connect to be able to connect to mysql.i am a novice.i tried to enter /var/lib/mysql/mysql.sock but still couldn't connect.help please. i have tried with both static and semi-static files. 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
Re: Supplied argument is not a valid MySQL result resource!!
Hi, try : $qid = mysql_query( SELECT * FROM 1_nodedata WHERE id = '$edit_id' ); $frm = mysql_fetch_array($qid); (what does echo edit_id : $edit_id; display ?) Regards, Jocelyn - Original Message - From: Anil Garg [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 11:12 PM Subject: Supplied argument is not a valid MySQL result resource!! Hi, in the piece of code given below --- $qid = mysql_query( SELECT * FROM 1_nodedata WHERE id = $edit_id ); $frm = mysql_fetch_array($qid); --- i get the follownig error: Warning: Supplied argument is not a valid MySQL result resource in /z/mercury/www/niksun/admin/add_doc.php on line 107 element type: What is it happening so!! regards anil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Supplied argument is not a valid MySQL result resource!!
In the last episode (Aug 15), Anil Garg said: Thursday, August 15, 2002, 1:12:21 PM, you wrote: Hi, in the piece of code given below --- $qid = mysql_query( SELECT * FROM 1_nodedata WHERE id = $edit_id ); $frm = mysql_fetch_array($qid); hi, m sorry i dint mention that its just a part of code. i am able to delete entries from the database .so i think mysql_connect is not the reason. please tell if u have some more ideas You don't check the return value of mysql_query to make sure that it succeeded. -- 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: Supplied argument is not a valid MySQL result resource!!
yes..it echos $edit_id fine. i am also feeling strange why its not working! regards anil - Original Message - From: Jocelyn Fournier [EMAIL PROTECTED] To: Anil Garg [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 5:40 PM Subject: Re: Supplied argument is not a valid MySQL result resource!! Hi, try : $qid = mysql_query( SELECT * FROM 1_nodedata WHERE id = '$edit_id' ); $frm = mysql_fetch_array($qid); (what does echo edit_id : $edit_id; display ?) Regards, Jocelyn - Original Message - From: Anil Garg [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 11:12 PM Subject: Supplied argument is not a valid MySQL result resource!! Hi, in the piece of code given below --- $qid = mysql_query( SELECT * FROM 1_nodedata WHERE id = $edit_id ); $frm = mysql_fetch_array($qid); --- i get the follownig error: Warning: Supplied argument is not a valid MySQL result resource in /z/mercury/www/niksun/admin/add_doc.php on line 107 element type: What is it happening so!! regards anil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Supplied argument is not a valid MySQL result resource!!
Let's try this : $qid = mysql_query(SELECT * FROM 1_nodedata WHERE id='$edit_id') or die(mysql_error()); - Original Message - From: Anil Garg [EMAIL PROTECTED] To: Jocelyn Fournier [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 11:42 PM Subject: Re: Supplied argument is not a valid MySQL result resource!! yes..it echos $edit_id fine. i am also feeling strange why its not working! regards anil - Original Message - From: Jocelyn Fournier [EMAIL PROTECTED] To: Anil Garg [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 5:40 PM Subject: Re: Supplied argument is not a valid MySQL result resource!! Hi, try : $qid = mysql_query( SELECT * FROM 1_nodedata WHERE id = '$edit_id' ); $frm = mysql_fetch_array($qid); (what does echo edit_id : $edit_id; display ?) Regards, Jocelyn - Original Message - From: Anil Garg [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 11:12 PM Subject: Supplied argument is not a valid MySQL result resource!! Hi, in the piece of code given below --- $qid = mysql_query( SELECT * FROM 1_nodedata WHERE id = $edit_id ); $frm = mysql_fetch_array($qid); --- i get the follownig error: Warning: Supplied argument is not a valid MySQL result resource in /z/mercury/www/niksun/admin/add_doc.php on line 107 element type: What is it happening so!! regards anil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Supplied argument is not a valid MySQL result resource!!
can u plz tell me how can i check that? regards anil - Original Message - From: Dan Nelson [EMAIL PROTECTED] To: Anil Garg [EMAIL PROTECTED] Cc: SteveH [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 5:41 PM Subject: Re: Supplied argument is not a valid MySQL result resource!! In the last episode (Aug 15), Anil Garg said: Thursday, August 15, 2002, 1:12:21 PM, you wrote: Hi, in the piece of code given below --- $qid = mysql_query( SELECT * FROM 1_nodedata WHERE id = $edit_id ); $frm = mysql_fetch_array($qid); hi, m sorry i dint mention that its just a part of code. i am able to delete entries from the database .so i think mysql_connect is not the reason. please tell if u have some more ideas You don't check the return value of mysql_query to make sure that it succeeded. -- 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: Losing data
Jacob, - Original Message - From: Devore, Jacob [EMAIL PROTECTED] To: 'Heikki Tuuri' [EMAIL PROTECTED] Sent: Friday, August 16, 2002 12:20 AM Subject: RE: Losing data can one change a table from MyISAM tables into something else on the fly? ALTER TABLE tablename TYPE = sometype Thanks, jake Regards, Heikki -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 2:10 PM To: [EMAIL PROTECTED] Subject: Re: Losing data Anna, please check with SHOW VARIABLES if InnoDB is enabled in mysqld. Also check with SHOW CREATE TABLE tablename that your tables really are of the InnoDB type. Error 127 means the 'table is crashed', and I think only MyISAM type tables can return that error number. An upgrade to 4.0.2 is recommended because 4.0.1 is an alpha version, and already 8 months old. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com - Original Message - From: Anna Carlsson [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Thursday, August 15, 2002 11:33 PM Subject: Losing data Hej I have several databases with several tables in them and all works fine except for one database that loses data. I'm running mySQL 4.0.1-alpha-nt and the tables are all INNODB. The problem is as follows: Table B references table A by a foreign key. I've filled table A with all the data I want and are adding data to table B. After a couple of items, only a few of the items are still in the table. Sometimes the other items reappear after a couple of minutes, in other cases all items dissapear. Sometimes when I run a select statement I get an error message from the table handler error code 127. But I have no idea what that means. Has anyone experienced anything like this!? It's just to weird! I have no idea what to do and are ready to give up and export it all to linux and postgreSQL instead. Anna This message was sent using SkyBURST Mail Center. http://www.skyburst.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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Table locking questions
At 8/15/2002, you wrote: Hi everyone! I'm fairly familiar with the table locking methods in MySQL but I have a problem I can't solve. I have two main tables which are read simultaneously by many clients. The clients only do reads, but they do it very extensively and for 30 secs each. The two main tables needs updates every 30-45 minutes. The process that updates the tables lasts about 50 secs (several queries, updates and inserts). All my tables are properly indexed using EXPLAIN and all the tables are MyISAM types. I'm using MySQL v3.23.47 All the processes are background processes. The problem: Doing a write lock on the two main tables ensures that no clients can access the tables while they are updated, but what about the clients who are in the middle of a chain of queries from the main tables? Solutions? A) The process that updates the main tables can maintain a version number which increases every time the tables are updated. The process WRITE locks the main tables and thus freezez the many clients reading from them. A client reads the version number from the tables before it starts to do its many queries. When the client is finished processing the tables, it reads the version numbers again and compares them. If they are not the same, the process must have been freezed and must be restarted again. The solution is fairly simple to implement, but the problem is the many client programs taking up resources while they are frozen. Any suggestions? Hi, Just a simple thought pattern: You could freeze clients UI's (message: please hold on, database is being updated, press refresh to try again) and then wait that all SQL processes are finished (SHOW PROCESSLIST may help here), then flush, lock, update, unlock and open clients again. - Pekka Saarinen http://photography-on-the.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
Is this a known issue?
Well, I am not sure if anyone has experienced the same problem, or if this problem has been documented, but this is what I have noticed: After one of my data table was full, I started to delete old records from the table to allow new data to be inserted. Since then, the LIMIT function stop working. I used to be able to do: SELECT * FROM mytable LIMIT 0, 50 or DELETE FROM mytable LIMIT 0, 50 Now it doesn't work any more. I have to add a WHERE clause in order to make the LIMIT working. For instance: SELECT * FROM mytable WHERE id 0 LIMIT 0, 50 or DELETE FROM mytable WHERE id 0 LIMIT 0, 50 However, this is not a good query considering 15 million records in the table. I have repeated the same problem on two systems with similar setting. Thanks. Jay Song - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Supplied argument is not a valid MySQL result resource!!
At 8/16/2002, you wrote: Hi, in the piece of code given below --- $qid = mysql_query( SELECT * FROM 1_nodedata WHERE id = $edit_id ); $frm = mysql_fetch_array($qid); --- i get the follownig error: Warning: Supplied argument is not a valid MySQL result resource in /z/mercury/www/niksun/admin/add_doc.php on line 107 element type: What is it happening so!! $qid = mysql_query( SELECT * FROM 1_nodedata WHERE id = '$edit_id' ); if (!$qid ) { print mysql_error(); exit; } $frm = mysql_fetch_array($qid); or $qid = mysql_query( SELECT * FROM 1_nodedata WHERE id = '$edit_id' ); if (!$qid ) { print mysql_error(); } if ($qid ) { $frm = mysql_fetch_array($qid); } - Pekka Saarinen http://photography-on-the.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
Query problem
Hey all, I've been given the task of adding a few hundred, and later a few thousand, new records to my database that currently exist in (ugh...) an excel spreadsheet. I was able to very quickly and efficiently deal with the initial insertion of the main data to the main table, but am having difficulty figuring out how to get the related information into the related table. Now, if that didn't make any sense, here's exactly what I'm trying to do: I have a table named suppliers which has, among other things, a column named ID, which is likely to be the only important column for this issue. This is the table that was easy to populate. I also have a second table called suppliercatlink which holds 3 columns as ID, SUPID, CATID. SUPID in this table relates to ID in the supplier table. ID in this table autoincrements. What I need to do is insert into suppliercatlink SUPID,CATID values(supplier.ID,123) where supplier.id 100 and supplier.id 200. the CATID will be the same for all of these entries, the only thing that will vary is the supplier.ID, and the CATID should (theoretically) autoincrement. I'm sure there is a relatively simple way to deal with this, but for the moment I am about as lost on how to properly deal with this. (And in fact feel that I could probably have added the CATID to the spreadsheet and included it in the initial sql statement somehow, but don't want to get that complicated... yet.) Thanks for the help! Jason Drake [EMAIL PROTECTED] query 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
Date comparison assistance please
I have a column defined in a table as type date. I desire to include a date comparison in the WHERE clause of the following statement. The following statement is not working correctly, I suspect that there is a formatting issue. The statement returns true even if USER.elig_date has an earlier date then CURDATE(). Here is my sql query: select user_id from USER where USER.elig_date = CURDATE() ; Thank You - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Is this a known issue?
Hi, What version of MySQL are you using ? Regards, Jocelyn - Original Message - From: Song, Jay [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 11:57 PM Subject: Is this a known issue? Well, I am not sure if anyone has experienced the same problem, or if this problem has been documented, but this is what I have noticed: After one of my data table was full, I started to delete old records from the table to allow new data to be inserted. Since then, the LIMIT function stop working. I used to be able to do: SELECT * FROM mytable LIMIT 0, 50 or DELETE FROM mytable LIMIT 0, 50 Now it doesn't work any more. I have to add a WHERE clause in order to make the LIMIT working. For instance: SELECT * FROM mytable WHERE id 0 LIMIT 0, 50 or DELETE FROM mytable WHERE id 0 LIMIT 0, 50 However, this is not a good query considering 15 million records in the table. I have repeated the same problem on two systems with similar setting. Thanks. Jay Song - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Is this a known issue?
I'm using MYSQL Ver 3.23.49a. Thanks. Jay Song -Original Message- From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 6:20 PM To: Song, Jay; [EMAIL PROTECTED] Subject: Re: Is this a known issue? Hi, What version of MySQL are you using ? Regards, Jocelyn - Original Message - From: Song, Jay [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 11:57 PM Subject: Is this a known issue? Well, I am not sure if anyone has experienced the same problem, or if this problem has been documented, but this is what I have noticed: After one of my data table was full, I started to delete old records from the table to allow new data to be inserted. Since then, the LIMIT function stop working. I used to be able to do: SELECT * FROM mytable LIMIT 0, 50 or DELETE FROM mytable LIMIT 0, 50 Now it doesn't work any more. I have to add a WHERE clause in order to make the LIMIT working. For instance: SELECT * FROM mytable WHERE id 0 LIMIT 0, 50 or DELETE FROM mytable WHERE id 0 LIMIT 0, 50 However, this is not a good query considering 15 million records in the table. I have repeated the same problem on two systems with similar setting. Thanks. Jay Song - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
what dir is mysql.sock in?
what dir is mysql.sock in? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: LIMITing result sets - Spoiled by MySQL
Michael, I do not believe there is a real equivalent. SQL Server supports the 'TOP' statement. It is like using the one-argument variation of MySQL's LIMIT clause. It looks like: SELECT TOP 20 foo FROM BAR The obvious problem is that this is pretty much useless for pagination, since there is no way to specify an offset. The (clumsy) solution I have used in the past is to move the DB pointer to the offset I wanted after the query has returned. In ASP, I use the 'rsObj.move' method. I'm sure there is a JSP equiv. Of course this means you are selecting all 60k rows, and you need about twice as much code, but it works. One more reason not to use SQL Server... - H I am used to working in MySQL, and am now working with MS SQLServer :( I'm hoping someone else has been in this unfortunate situation before and can help me out. I'm looking to do pagination of some resultset in JSP. in MySQL I would have used something like: SELECT * FROM mytable ORDER BY somedatefield LIMIT 20,30 to get the third page of results with 10 results per page. MSSQL offers me NOTHING as kind as LIMIT. I have a query that returns ~60,000 results, and I don't want to have to grab them all on each page, and then move to the range that I need. Thanks for the help, MIchael -- Harold Paulson Sierra Web Design [EMAIL PROTECTED] http://www.sierraweb.com VOICE: 775.833.9500 FAX: 775-201-4458 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL ERROR 1133 MEANING?
Hi friends: I try to grant privileges to a user named 'glen' but not succeed. Here is the script: -# mysql update user set Password=password('tidbs1') where User='glen'; Query OK, 0 rows affected (0.00 sec) Rows matched: 1 Changed: 0 Warnings: 0 mysql select * from user where User='glen'; +---+--+--+-+-+-+-+-+---+-+---+--+---++-+++ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +---+--+--+-+-+-+-+-+---+-+---+--+---++-+++ | localhost | glen | 18c8ccb52a240cd8 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | +---+--+--+-+-+-+-+-+---+-+---+--+---++-+++ 1 row in set (0.00 sec) mysql grant all privileges on test.* to 'glen'@'localhost' identified by 'tidbs1'; ERROR 1133: Can't find any matching row in the user table mysql -### Could you please tell me what the real meaning of the ERROR? The user an doassword just remains in the user table? How come to say Can't find any matching row in the user table? Thank you very much for your help! Duo From: [EMAIL PROTECTED] (John R Levine) To: [EMAIL PROTECTED] Subject: MySQL 3.23 problems on BSDI 4.1 Date: 15 Aug 2002 14:35:34 -0400 I downloaded and built mysql-3.23.49 on my BSDI 4.1 system. It configured and built fine, but it hangs whenever I do more than the most trivial operations. It is my dim recollection that there have been problems with the thread libraries in the past. Does this ring a bell? (I can't use the prebuilt 4.2 binaries, because I'm not running 4.2 yet.) -- John R. Levine, IECC, POB 727, Trumansburg NY 14886 +1 607 387 6869 [EMAIL PROTECTED], Village Trustee and Sewer Commissioner, http://iecc.com/johnl, Member, Provisional board, Coalition Against Unsolicited Commercial E-mail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL ERROR 1133 MEANING?
Hi friends: I try to grant privileges to a user named 'glen' but not succeed. Here is the script: -# mysql update user set Password=password('tidbs1') where User='glen'; Query OK, 0 rows affected (0.00 sec) Rows matched: 1 Changed: 0 Warnings: 0 mysql select * from user where User='glen'; +---+--+--+-+-+-+-+-+---+-+---+--+---++-+++ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +---+--+--+-+-+-+-+-+---+-+---+--+---++-+++ | localhost | glen | 18c8ccb52a240cd8 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | +---+--+--+-+-+-+-+-+---+-+---+--+---++-+++ 1 row in set (0.00 sec) mysql grant all privileges on test.* to 'glen'@'localhost' identified by 'tidbs1'; ERROR 1133: Can't find any matching row in the user table mysql -### Could you please tell me what the real meaning of the ERROR? The user an doassword just remains in the user table? How come to say Can't find any matching row in the user table? Thank you very much for your help! Duo _ Chat with friends online, try MSN Messenger: http://messenger.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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Getting users next slot
I'm working on building an online scheduling system. I want to be able to select all the users who don't have any scheduled commitments on the next weekend and then sort based on when the users next scheduled spot is. I have a few problems however. First of all I have a set of users who don't have any future commitments so they don't show up in a join. In addition in the table that stores time commitments there are 3 users per time commitment. To summarize my table schemes I have 2 tables that are used for this: (I have omitted fields that have nothing to do with this problem) 1. Stores information about people (People) Field Name Type Notes number int(11)Primary id for people name varchar 2. Stores information about scheduled slots (Games) Field Name Type Notes number int (11) Primary id for games date date center int (11) foreign key to people table ar1 int (11) foreign key to people table ar2 int (11) foreign key to people table I want to be able to retrieve something along the lines of name People.number nextcommitmentdate Any ideas how to go about running this query? Thanks Jefferson Cowart [EMAIL PROTECTED] Support Open Instant Messaging Protocols http://www.petitiononline.com/openIM/petition.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Still trying to build libmysqld.a on Tru64
To anyone who can help, I'm still struggling to build a working 4.0.2 libmysqld.a library on the Compaq Tru64 (formerly Dec OSF) platform. I now have access to the Compaq C++ compiler, but any libraries that I build still crash in the thread functions, as follows: Program terminated with signal 11, Segmentation fault. #0 0x3ff8057d728 in __nxm_thread_kill () from /usr/shlib/libpthread.so #1 0x3ff80576564 in pthread_kill () from /usr/shlib/libpthread.so #2 0x3ff80581aec in __excInit () from /usr/shlib/libpthread.so #3 0x3ff807e3aa4 in exc_unwind_rfp () from /usr/shlib/libexc.so And I haven't been able to get a clean compile of the MIT pthreads library on that platform either. Does anyone have any suggestions, or better yet, a working build of libmysqld.a on that platform? Best Regards, Randall Severy Randall Severy[EMAIL PROTECTED]http://www.cyberteams.com/severy CyberTeams, Inc.[EMAIL PROTECTED]http://www.cyberteams.com Frederick, MD (301) 682-8885 Building effective teams in cyberspace 1-888-832-5575 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
startup automatic
Hi all I have Mysql Version: 3.23.49a at RadHat 7.2 I read the documentation about automatic startup/shutdown but when I start the script it wait for a ENTER then it doesn't work at boot I always need do manual startup anybody have any hint ?? ats Paulo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fax to MySQL
Does anyone know of a solution that would allow me to setup faxing into a MySQL database, preferably GNU? 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
RE: Transactions not supported by database - Perl
I have expereience the same behaviour when using the ppm from activestate. Try using the one below, seem to work for me... ppm install http://theoryx5.uwinnipeg.ca/ppmpackages/DBD-mysql.ppd -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 9:33 PM To: Bob Boden Cc: [EMAIL PROTECTED] Subject: Re: Transactions not supported by database - Perl Send the set autocommit=0 just as you send any other query in perl. Bob Boden wrote: Attempts to disable auto-commit mode in Perl using the DBI command $dbh-{AutoCommit} = 0; returns the following message, Transactions not supported by database. I am using the latest version of MySQL-Max (3.23.51) as well as the latest version of DBD::mysql. Executing the following command at the mysql prompt verifies that BDB Transaction enabled tables are supported and turned on. mysql SHOW VARIABLES LIKE have_%; +---+--+ | Variable_name | Value| +---+--+ | have_bdb | YES | | have_gemini | NO | | have_innodb | DISABLED | | have_isam | YES | | have_raid | NO | | have_openssl | NO | +---+--+ 6 rows in set (0.00 sec) Executing SET AUTOCOMMIT=0; at the mysql prompt works fine as well. However, I can not get Perl scripts to recognize the disable auto-commit command. These symptoms are occurring in a Linux/apache web server as well as a Windows 2000 environment running as localhost. Any suggestions would be greatly 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Transactions not supported by database - Perl
Anyone know of an email marketing software suite that works well with MySQL on the backend? I've seen stuff that works with ODBC db connectivity but I'm not interested in moving to MS SQL or Access. Any feedback is appreciated Thanks Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php