Re: MySQL 4.0.5(a) is released
Dear Stefan,
Stefan Hinz, iConnect (Berlin) wrote:
Dear Lenz,
Removed variable `safe_show_database' as it was not used anymore.
What will ISPs say about this one? They use 'safe_show_database' for their
MySQL setups, so their customers on virtual MySQL hosts cannot see other
customers' databases. (It's more likely that you won't attack something
which you cannot see.)
Or am I missing out on something?
Functionality is still there, but implemented at the place it belongs to.
Pay attention on Privlieges tables 4.0.5 uses. You will see there is:
`Show_db_priv` enum('N','Y') NOT NULL default 'N'
i.e. User must be granted explicitly this privilege in order to be able to use:
SHOW DATABASES;
Suggested way for setting this Ptivilege is ofcourse command:
GRANT SHOW DATABASES;
I hope you will agree that this approach provides much better flexibility and is
more natural than mysqld starting option.
If you still have concerns, please don't hesitate to share them with us.
--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Alexander Keremidarski [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria
___/ 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: Problems with InnoDB
Marek, please address these general questions to [EMAIL PROTECTED] - Original Message - From: Marek Lewczuk [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 29, 2002 10:04 AM Subject: Problems with InnoDB Hello!! I have read some post about this problem, but there wasn't any good answers. So after many hours of thinking I've decided to post my problem to you - I hope you will help me with this. I have to tables tbl1 (primary key `group_id`) and tbl2 (primary key `element_id`,foreign key `group_id` with on delete contraint). In tbl1 I have 4 records, in tbl2 I have 3 records. Every record from tbl2 is connected to correct group_id from tbl1. And my problem is when I need to change group_id in tbl2 to another (which is also in tbl1) - when I want to do this update mysql gives me this error: Cannot delete a parent row: a foreign key constraint fails. I realy don't know why ?? I don't want to delete, I just want to update it... I tested this and it worked ok. Are you sure you have defined the foreign key relationship in the right direction? Looks like you have made tbl1 to reference to tbl2, and not the other way around. Your MySQL connection id is 1 to server version: 4.0.6-gamma-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql create table tbl1 (a int not null, primary key (a)) type = innodb; Query OK, 0 rows affected (0.09 sec) mysql create table tbl2 (b int not null, a int not null, primary key (b), index (a), foreign key (a) references tbl1(a) on delete cascade) type = innodb; Query OK, 0 rows affected (0.07 sec) mysql insert into tbl1 values (1); Query OK, 1 row affected (0.02 sec) mysql insert into tbl1 values (2); Query OK, 1 row affected (0.00 sec) mysql insert into tbl1 values (3); Query OK, 1 row affected (0.00 sec) mysql insert into tbl1 values (4); Query OK, 1 row affected (0.00 sec) mysql insert into tbl2 values (1, 1); Query OK, 1 row affected (0.00 sec) mysql insert into tbl2 values (2, 1); Query OK, 1 row affected (0.00 sec) mysql insert into tbl2 values (3, 2); Query OK, 1 row affected (0.00 sec) mysql update tbl2 set a = 3 where b = 1; Query OK, 1 row affected (0.05 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql select * from tbl1; +---+ | a | +---+ | 1 | | 2 | | 3 | | 4 | +---+ 4 rows in set (0.00 sec) mysql select * from tbl2; +---+---+ | b | a | +---+---+ | 2 | 1 | | 3 | 2 | | 1 | 3 | +---+---+ 3 rows in set (0.01 sec) mysql ... I have found the simple solution, before the query I do this: SET FOREIGN_KEY_CHECKS = 0. But it's not a good solution. Maybe you have better solution. Thanks. ML Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB 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: numbers of similar rows
* Urmas Buhvestov
I have MySQL database with data like
name points
a20
b20
c19
d18
e18
use test;
create table MyTable (name char(1), points int);
insert into MyTable values ('a',20),('b',20),('c',19),('d',18),('e',18);
is it possible to get with mysql commands ONLY outpt
place repeatings name points
1 2 a 20
1 2 b 20
3 1 c 19
4 2 d 18
4 2 e 18
/pre
first column shows how many persons have beter points +1
second column shows how many records have same number of points
Try a self join.
This will only work on a small amount of data, because each row is joined
with every other row in the table with higher or same score. This will take
a lot of time on a big table. If this becomes a problem for you, try adding
a WHERE clause limiting the number of rows examined, for instance WHERE
t1.points 15.
select
sum(t2.pointst1.points)+1 place,
sum(t2.points=t1.points)+1 repeatings,
t1.name,
t1.points
FROM MyTable t1
LEFT JOIN MyTable t2 ON
t2.name t1.name AND
t2.points = t1.points
GROUP BY t1.name,t1.points
ORDER BY t1.points DESC;
+---++--++
| place | repeatings | name | points |
+---++--++
| 1 | 2 | a| 20 |
| 1 | 2 | b| 20 |
| 3 | 1 | c| 19 |
| 4 | 2 | d| 18 |
| 4 | 2 | e| 18 |
+---++--++
5 rows in set (0.00 sec)
HTH,
--
Roger
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: Can a big transaction cause the error in max_allowed_packet?
Ha-nyung, - Original Message - From: Chung Ha-nyung [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Friday, November 29, 2002 8:25 AM Subject: Can a big transaction cause the error in max_allowed_packet? My table structure is very simple and does not use big column like text nor blub at all. But when I load several million rows into master server using mysqlimport, on slave I got the error like 021129 13:24:40 Error reading packet from server: log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master (server_errno=1236) 021129 13:24:40 Got fatal error 1236: 'log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master' from master when reading data from binary log I have two questions. First, mysqlimport does not commit until the entire data are imported? it uses LOAD DATA INFILE, which does not COMMIT before the data has been imported. Second, If the answer to the first question is Yes, it can cause the above error? I guess yes. This is the 3rd similar bug report associated with big imports. I will forward this to the replication developer of MySQL AB. What is your MySQL version? :query -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.com 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Can a big transaction cause the error in max_allowed_packet?
Thanks for your rapid reply. :) I'm using MySQL 4.0.5a binary from MySQL AB. -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.com -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: Friday, November 29, 2002 7:48 PM To: [EMAIL PROTECTED] Subject: Re: Can a big transaction cause the error in max_allowed_packet? Ha-nyung, - Original Message - From: Chung Ha-nyung [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Friday, November 29, 2002 8:25 AM Subject: Can a big transaction cause the error in max_allowed_packet? My table structure is very simple and does not use big column like text nor blub at all. But when I load several million rows into master server using mysqlimport, on slave I got the error like 021129 13:24:40 Error reading packet from server: log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master (server_errno=1236) 021129 13:24:40 Got fatal error 1236: 'log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master' from master when reading data from binary log I have two questions. First, mysqlimport does not commit until the entire data are imported? it uses LOAD DATA INFILE, which does not COMMIT before the data has been imported. Second, If the answer to the first question is Yes, it can cause the above error? I guess yes. This is the 3rd similar bug report associated with big imports. I will forward this to the replication developer of MySQL AB. What is your MySQL version? :query -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.com 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
ssl support in mysql
Hello. Can somebody tell me how can i enable ssl support in mysql? Thanks Giannis Vrentzos - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ssl support in mysql
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday 29 November 2002 12:23, Giannis Vrentzos wrote: Can somebody tell me how can i enable ssl support in mysql? By recompiling with OpenSSL support: http://www.mysql.com/doc/en/Secure_requirements.html We plan to offer binaries with SSL enabled in the near future as well. Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) iD8DBQE9509PSVDhKrJykfIRAiDoAJ9xBeNc1WZvXg5Oup0VccuK1k3SHwCfYeTn zReFAN8ZMWCAXtmTvDsibPY= =ayRb -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
PURGE MASTER LOGS
In my network there are 1 master and 3 slaves all with 3.52 on WIN NT. All slaves are linked correctly to the same bin-log file PISSARRO-BIN.047. With the command SHOW MASTER LOGS I see 3 files PISSARRO-BIN.045 PISSARRO-BIN.046 PISSARRO-BIN.047 If I use the command purge logs file to pissarro-bin.046 appear the error A purgeable log is in use, will not purge. But I am sure there is no slave connected to this file. Which is my error ? - Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] 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: [Fwd: possible problems with FLUSH TABLES WITH READ LOCK]
Antoine, Thursday, November 28, 2002, 4:17:48 PM, you wrote: A Sorry to insist, but nobody has any clues about this ? A I can supply further info if needed. A Is the FLUSH TABLES WITH READ LOCK functionality well tested ? A Having corrupted backups is annoying, and I can't really A take the system down for a 4-hour tape backup... ;( A Message original A Sujet: possible problems with FLUSH TABLES WITH READ LOCK A De: Antoine [EMAIL PROTECTED] A Date: Mar, 26 Novembre 2002, 17:27 A A: [EMAIL PROTECTED] A Hi, A I am using FLUSH TABLES WITH READ LOCK to get consistent A snapshots of my database without shutting it down. A The setup is : A - bi-P4 Xeon with Redhat 7.3 A - 2.4.19 kernel with properly patched LVM (compiled from source) A - MySQL server 4.0.4 (compiled from source) A - ext3 filesystem on a 44 GB LVM logical volume named /dev/vgdata/data - A the whole database is 20 GB in size A - all tables are MYISAM ; some with dynamic records, some fixed, A some compressed A - some tables - not all - are created with DELAYED_KEY_WRITE=1 to get A more speed (30% faster thanks to this) A The backup sequence is : A - FLUSH TABLES WITH READ LOCK A - lvcreate -L 5G -c 256k -s -n backup /dev/vgdata/data A (this creates a 5GB snapshot volume named backup from the logical A volume containing the database) A - UNLOCK TABLES A - mount /dev/vgdata/backup /backup -oro,noatime A - cd /backup/ ; tar cvf /dev/st0 * You need to do it with 2 sessions. According MySQL manual: If you are using a Veritas filesystem, you can do: 1. From a client (or Perl), execute: FLUSH TABLES WITH READ LOCK. 2. From another shell, execute: mount vxfs snapshot. 3. From the first client, execute: UNLOCK TABLES. 4. Copy files from snapshot. 5. Unmount snapshot. A Today I've tried restoring a backup on a test partition just to see A (you're never too careful). Restoring is OK (of course) but when I run A myisamchk -c *.MYI, just to be sure, I get various kinds of errors, on A some tables but not all. Common errors include : A 1 clients is using or hasn't closed the table properly A error: Size of indexfile is: 17404928Should be: 17507328 A warning: Size of datafile is: 24922872Should be: 24896378 A error: Found 185731 keys of 186676 A error: Found key at page 1024 that points to record outside datafile A In fact, all kind of errors that you'd expect to find if you copy your A files without doing a FLUSH TABLES WITH READ LOCK first. Thus I A was wondering if the latter command does work properly. Is it likeky to A be due to : A - SMP problems ? (it has hyperthreading enabled, BTW, but this shouldn't A make any further difference : it just sees 4 logical CPUs instead of 2) - A DELAYED_KEY_WRITE ? (but some tables that aren't created as such have A problems too, so this shouldn't be the _only_ problem) A - specific Linux locking behaviour wrt flushing locking tables ? - A Linux LVM bug ? (unlikely in my opinion, it seems heavily used) A - other... ? A Please note : tables are written to in a continuous way, so it's no A surprise many tables get corrupted if the lock is not absolutely A consistent and fail-proof ;)) A Also, I know the backup volume is large enough (I print the occupied size A at the end of the backup procedure). A Well, of course, it may just be the backup tape itself that was screwed A up, but it doesn't seem very likely, at least in my opinion, otherwise A un-tar-ing it should have failed somewhere. -- 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: Error No: 2013. Lost Connection MySQL server during query
Cem, Friday, November 29, 2002, 9:31:21 AM, you wrote: CY I am trying to connect to mysql server (3.23.52) on Linux Redhat 8 thru CY win2000 with using any Front End applications CY (SQLyog251, MySqlwinadmin, winmysqladmin, ...). On every try, I am CY getting the same error message: Error No: 2013 Lost Connection CY MySQL server during query. I am being crazy. On the server side each CY connection try is leaving a paragraph in the /var/log/mysqld.log just CY like: CYNumber of processes running now:1 CY mysqld process hanging, pid 2 - killed CY 022323 15:02:24 mysqld restarted CY /user/libexec/mysqld: ready for connection CY I am dying to see any database or table with establishing this CY connection. Most likely this is related to a known glibc bug: https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=75128 -- 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: LOAD DATA LOCAL INFILE
John, Thursday, November 28, 2002, 7:02:58 PM, you wrote: JC Thanks very much. JC Following on your suggestions, I then went ahead and put the text file JC into my directory: JC /usr/local/mysql JC so that the file was then /usr/local/mysql/absence.txt JC and, with that done, the JC LOAD DATA LOCAL INFILE absence.txt into table absence; JC command in the mysql client successfully did load it. JC (It didn't work when put into the /usr/local/mysql/scripts directory JC or in the /usr/local/mysql/data directory.) JC Is there anyway to change the place where the client looks when given JC the relative pathname of a file to be LOADed, or is one stuck with JC having to put all text files in that one immutable location? Nope. And storing text files in /usr/local/mysql is not a good idea .. If you execute LOAD DATA LOCAL from your own client application/script, store path to the dir in some configuration variable and so on. JC (On the Mac, we aren't allowed to see the contents of JC /usr/local/mysql/ in the GUI. We have to access it through the UNIX JC Terminal program, and then fiddle with permissions, which, I am not JC bashful to say, I am reluctant to start doing without comprehending the JC implications, which, I also am not bashful to say, I don't.) -- 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: MySQL 4.0.5(a) is released
Stefan Hinz, iConnect \(Berlin\) writes: Dear Lenz, Removed variable `safe_show_database' as it was not used anymore. What will ISPs say about this one? They use 'safe_show_database' for their MySQL setups, so their customers on virtual MySQL hosts cannot see other customers' databases. (It's more likely that you won't attack something which you cannot see.) Or am I missing out on something? Regards, -- Stefan Hinz [EMAIL PROTECTED] CEO / Geschäftsleitung iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 Hi! Variable has been removed but the option --safe-show-database remain. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ssl support in mysql
Lenz Grimmer wrote: On Friday 29 November 2002 12:23, Giannis Vrentzos wrote: Can somebody tell me how can i enable ssl support in mysql? By recompiling with OpenSSL support: http://www.mysql.com/doc/en/Secure_requirements.html Thanks for your answer. I can only find binary packages. Any link for the source code? Giannis We plan to offer binaries with SSL enabled in the near future as well. Bye, LenZ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ssl support in mysql
On Fri, 2002-11-29 at 13:23, Giannis Vrentzos wrote: Hello. Can somebody tell me how can i enable ssl support in mysql? All is in manual. And manual is included with MySQL distribution and http://www.mysql.com. Always. In case of security-specific questions not covered in manual, come back and tell what you haven't found and you get answer from list plus manual gets updated. Tõnu (Did this SSL part) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ssl support in mysql
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday 29 November 2002 12:45, Giannis Vrentzos wrote: I can only find binary packages. Any link for the source code? Look deeper down on the download pages - the sources are at the bottom of the page. Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) iD8DBQE951f/SVDhKrJykfIRAj0TAJ9LlpHH/XZEhZK1fryHYAnxc+K/+gCaAwIv LqA25fs/b0Fg4wu1rw2IYkg= =mLmc -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error No: 2013. Lost Connection MySQL server during query
Hi, Old story.You have many options.Perhaps the most convenient solutions are to start MySQL daemon with --skip-name-resolve(documentation - 4.1 Configuring MySQL) or you can add the client IP address and alias in the /etc/host. Other options are: -download MySQL 3.23.53a binary distribution . -upgrade your glibc to .42 or downgrade to .39. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Cem Yagli [EMAIL PROTECTED] To: Mysql maillist [EMAIL PROTECTED] Sent: Friday, November 29, 2002 9:31 AM Subject: Error No: 2013. Lost Connection MySQL server during query Hi all, I am trying to connect to mysql server (3.23.52) on Linux Redhat 8 thru win2000 with using any Front End applications (SQLyog251, MySqlwinadmin, winmysqladmin, ...). On every try, I am getting the same error message: Error No: 2013 Lost Connection MySQL server during query. I am being crazy. On the server side each connection try is leaving a paragraph in the /var/log/mysqld.log just like: Number of processes running now:1 mysqld process hanging, pid 2 - killed 022323 15:02:24 mysqld restarted /user/libexec/mysqld: ready for connection I am dying to see any database or table with establishing this connection. Is there anybody will help me? Sincerely. Cem Yagli key words: 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ssl support in mysql
Lenz Grimmer wrote: On Friday 29 November 2002 12:45, Giannis Vrentzos wrote: I can only find binary packages. Any link for the source code? Look deeper down on the download pages - the sources are at the bottom of the page. Bye, LenZ - -- I was looking for mysql 4.0.x source that 's why i didn 't see any.I found mysql 3.23.53 source. Thanks for your answer. Giannis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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_query sort
Hallo,
I want to sort my array (example: array[Ortslage, Strasse, Weg]) comming
from a query. Following script shows Warning: sort() expects parameter 1 to
be array, resource given in .../formular.php on line 36
var_dump($query) shows: resource(6) of type (mysql result)
How should I do this?
$query=select oart_bez from oart;
$result=safe_query($query);
$result=sort($result);
while($wert=mysql_fetch_row( $result ))
{ print OPTION VALUE=\ . $wert[0] . \ selected . $wert[0];
}
greetings, Wolfgang Gliese
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: [Fwd: possible problems with FLUSH TABLES WITH READ LOCK]
Hello Victoria,
You need to do it with 2 sessions.
According MySQL manual:
If you are using a Veritas filesystem, you can do:
1. From a client (or Perl), execute: FLUSH TABLES WITH READ LOCK.
2. From another shell, execute: mount vxfs snapshot.
3. From the first client, execute: UNLOCK TABLES.
4. Copy files from snapshot.
5. Unmount snapshot.
Thank you for the answer. My backup script is a Perl script and it
keeps the MySQL connection during the snapshot. Here it is :
#!/usr/bin/perl
use strict;
use DBI;
my $dbh = DBI-connect(dbi:mysql:, login, pass, {RaiseError = 1});
print Flushing database with read lock...\n;
$dbh-do(FLUSH TABLES WITH READ LOCK);
print Creating snapshot...\n;
system(lvcreate -L 10G -c 256k -s -n backup /dev/vgdata/data);
print Unlocking database...\n;
$dbh-do(UNLOCK TABLES);
print Closing MySQL connection...\n;
$dbh-disconnect;
print Mounting snapshot...\n;
system(mount /backup);
print Backuping snapshot...\n;
system(cd /backup ; /usr/bin/time tar cvf /dev/st0 *);
print Snapshot statistics... please check it doesn't get full!\n;
system(lvdisplay /dev/vgdata/backup);
print Rewinding and ejecting tape...\n;
system(mt -f /dev/st0 eject);
print Destroying snapshot...\n;
system(umount /backup);
system(lvremove -f /dev/vgdata/backup);
print Backup successfully done!\n\n;
I check the console output in the mail that cron automatically sends,
and everything is correct (no error message). Is there anything wrong in
this script ?
Regards
Antoine.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
LEGAL information about MySQL.
Hi, I'm beginner in maillist and my english is limited.. I want know about LEGAL MySQL software information. On www.mysql.com page, in download section I read that: You need to purchase commercial non-GPL MySQL licenses: If you distribute MySQL Software with your non open source software, If you want warranty from MySQL AB for the MySQL software, If you want to support MySQL development. distribute MySQL Software with means that my application (non open source) can use mysql if I not distribute MySQL with my application? Thanks. Darney - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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_query sort
* Wolfgang Gliese
I want to sort my array (example: array[Ortslage, Strasse, Weg]) comming
from a query.
A mysql query returns a 'resultset', not an 'array'. In PHP you can
transform the resultset to an array, and this array can be sorted using a
PHP function. However, this is a mysql list, and there is an (easier) mysql
solution... read on. :)
Following script shows Warning: sort() expects
parameter 1 to
be array, resource given in .../formular.php on line 36
var_dump($query) shows: resource(6) of type (mysql result)
I guess you mean var_dump($result), otherwise it would be strange...
How should I do this?
$query=select oart_bez from oart;
Try this:
$query=select oart_bez from oart ORDER BY oart_bez;
$result=safe_query($query);
$result=sort($result);
while($wert=mysql_fetch_row( $result ))
{ print OPTION VALUE=\ . $wert[0] . \ selected . $wert[0];
}
Read more about ORDER BY and other usefull options in the manual:
URL: http://www.mysql.com/doc/en/SELECT.html
--
Roger
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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.5(a) is released
Dear Lenz,
`Show_db_priv` enum('N','Y') NOT NULL default 'N'
i.e. User must be granted explicitly this privilege in order to be
able to use:
SHOW DATABASES;
Suggested way for setting this Ptivilege is ofcourse command:
GRANT SHOW DATABASES;
Sound it bit strange in a GRANT select, show databases, update context
as it has two words, in opposite to all other privileges that have only
one word.
I hope you will agree that this approach provides much better
flexibility and
is more natural than mysqld starting option.
Totally agree :)
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: Alexander Keremidarski [EMAIL PROTECTED]
To: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]
Cc: Lenz Grimmer [EMAIL PROTECTED]; MySQL announce list
[EMAIL PROTECTED]; MySQL mailing list [EMAIL PROTECTED]
Sent: Friday, November 29, 2002 11:15 AM
Subject: Re: MySQL 4.0.5(a) is released
Dear Stefan,
Stefan Hinz, iConnect (Berlin) wrote:
Dear Lenz,
Removed variable `safe_show_database' as it was not used anymore.
What will ISPs say about this one? They use 'safe_show_database' for
their
MySQL setups, so their customers on virtual MySQL hosts cannot see
other
customers' databases. (It's more likely that you won't attack
something
which you cannot see.)
Or am I missing out on something?
Functionality is still there, but implemented at the place it belongs
to.
Pay attention on Privlieges tables 4.0.5 uses. You will see there is:
`Show_db_priv` enum('N','Y') NOT NULL default 'N'
i.e. User must be granted explicitly this privilege in order to be
able to use:
SHOW DATABASES;
Suggested way for setting this Ptivilege is ofcourse command:
GRANT SHOW DATABASES;
I hope you will agree that this approach provides much better
flexibility and is
more natural than mysqld starting option.
If you still have concerns, please don't hesitate to share them with
us.
--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Alexander Keremidarski
[EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria
___/ 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: MySQL secure access
Dear Alice,
but what i meant is my customer want to have the access on their
database.
and i don't want them to view those databases that not belongs to the
particular customer. customer only access their own database only.
In MySQL 4.0.5a:
Start the server with --safe-show-databases
In MySQL = 4.0.5:
GRANT ... ON customer1_db.* TO 'customer1'@'localhost' IDENTIFIED BY
'customer1_pw'
If not explicitely granted, this command will not grant the show
databases privilege, so customer1 cannot see other databases except for
customer1_db.
Hope it helps,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: Alice Tan [EMAIL PROTECTED]
To: Pae Choi [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED]
Sent: Friday, November 29, 2002 2:54 AM
Subject: Re: MySQL secure access
of course i will full access on those databases in all the databases
store
in
our server, and i able to view/update all of them.
but what i meant is my customer want to have the access on their
database.
and i don't want them to view those databases that not belongs to the
particular customer. customer only access their own database only.
- Original Message -
From: Pae Choi [EMAIL PROTECTED]
To: Alice Tan [EMAIL PROTECTED]; MySQL
[EMAIL PROTECTED]
Sent: Thursday, November 28, 2002 8:33 PM
Subject: Re: MySQL secure access
If I am your customer and the data related to my web contents and/or
services stored(this is more than likely if the hosting service is
used)
in the database at your site, I would definitely claim that the
access to
data will be appropriate. Ex, You have Web services using a hosting
service. And the Web services collect the customers' info. Shouldn't
you need to access the database which stored all your customers'
info.
In addition, it's a trust-based relationship. But the hosting
service
should
not have access to the customers' data even though the customers'
databases reside at the hosting site. That's more appropriate in the
business process and prevent the possible legal matter. Because the
customers can simply claim that It's my data and not yours!
The right practice will be to seperate your company's database and
customer's databases on different hosts. And your company can
provide
the proper access to your customers to their databases. Otherwise,
they
will move on to somewhere else who can do for their needs.
Pae
Hi, all,
I am now using MySQL with MySQL Front, where i knew that it
can
access
ALL
the databases that store remotely.
My company is doing hosting services. And we are using MySQL
as
our database system. Currently, we have our own databases +
customer's
databases
store in our hosting server. But our customer requested to have
their
own access on their databases, which i don't want them to see
those
databases
that not belongs to them. Can i do that ?
Thanx in advance for anyhelp.
regards,
alice
/---
\
Confidential and/ or privileged information may be contained in
this
e-mail and any attachments transmitted with it ('Message'). If you
are
not the addressee indicated in this Message (or responsible for
delivery of this Message to such person),you are hereby notified
that
any dissemination, distribution, printing or copying of this
Message or
any part thereof is prohibited. Please delete this Message if
received
in error and advise the sender by return e-mail. Opinions,
conclusions
and other information in this Message that do not relate to the
official business of this company shall be understood as neither
given
nor endorsed by this company.
This mail is certified Virus Free by *ProtectNow! (InternetNow Sdn
Bhd)
*Scanner Engine powered by Norman Virus Control
\---
---/
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
[EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
Wont use Index when data is not evenly distributed
Cant figure out why MySQL wont use index on a big table. Ok, the data is not evenly distributed which might be the problem. Look here: I have a table with 1 million records, with the following fields: IdUser, int X, int Y, int Z, int C, char(10) no, varchars, text, or blobs. IdUser is a user identity. As things are right now, only 3 users are registered. iduser=2, 34, 39 User 39 owns 99.999 % of the data in the table. When using EXPLAIN, Mysql tells me that when querying the table with IdUser=39, MySQL will not use index. Querying the table with all other idusers than 39, causes MySQL to use index. Has anyone of you seen this behavious before? /Claus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SQL: Shared hosting and innodb support
Greetings: I've seen posts in a variety of forums where it states a lot of hosting companies do not offer support for Innodb SQL type tables. Is there a reason for this issue? What are the reason(s)? 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
SQL: Shared hosting and innodb support
Greetings: I've seen posts in a variety of forums where it states a lot of hosting companies do not offer support for Innodb SQL type tables. Is there a reason for this issue? What are the reason(s)? 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: Wont use Index when data is not evenly distributed
Claus Reestrup wrote: Cant figure out why MySQL wont use index on a big table. Ok, the data is not evenly distributed which might be the problem. Look here: I have a table with 1 million records, with the following fields: IdUser, int X, int Y, int Z, int C, char(10) no, varchars, text, or blobs. IdUser is a user identity. As things are right now, only 3 users are registered. iduser=2, 34, 39 User 39 owns 99.999 % of the data in the table. When using EXPLAIN, Mysql tells me that when querying the table with IdUser=39, MySQL will not use index. Querying the table with all other idusers than 39, causes MySQL to use index. Has anyone of you seen this behavious before? /Claus Yes. It is even described in the manual: 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. (see http://www.mysql.com/doc/en/MySQL_indexes.html) Regards, Joseph Bueno - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ssl support in mysql
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello Giannis, Friday, November 29, 2002, 12:36:45 PM, you wrote: Lenz Grimmer wrote: On Friday 29 November 2002 12:45, Giannis Vrentzos wrote: I can only find binary packages. Any link for the source code? Look deeper down on the download pages - the sources are at the bottom of the page. Bye, LenZ - -- I was looking for mysql 4.0.x source that 's why i didn 't see any.I found mysql 3.23.53 source. i do see the source for 4.0.x http://www.mysql.com/Downloads/MySQL-4.0/mysql-4.0.5a-beta.tar.gz http://www.mysql.com/Downloads/MySQL-4.0/MySQL-4.0.5-0.src.rpm http://www.mysql.com/Downloads/MySQL-4.0/mysql-4.0.5-beta-win-src.zip which will send you to a page full of mirrors Thanks for your answer. Giannis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - -- Best regards, Solidmailto:[EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (MingW32) iD8DBQE953Ls2PEgI0nAJngRAr2cAJ9u2/mN0QkUQn1/hs+n5yLYjWnRoACgnlZn TGnFypzWM5IBVWY7UCpYJ6U= =7vMS -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Wont use Index when data is not evenly distributed
* Claus Reestrup Cant figure out why MySQL wont use index on a big table. Ok, the data is not evenly distributed which might be the problem. Look here: I have a table with 1 million records, with the following fields: IdUser, int X, int Y, int Z, int C, char(10) no, varchars, text, or blobs. IdUser is a user identity. As things are right now, only 3 users are registered. iduser=2, 34, 39 User 39 owns 99.999 % of the data in the table. When using EXPLAIN, Mysql tells me that when querying the table with IdUser=39, MySQL will not use index. Querying the table with all other idusers than 39, causes MySQL to use index. Has anyone of you seen this behavious before? URL: http://www.mysql.com/doc/en/MySQL_indexes.html From the first paragraph: If the table has an index for the columns in question, MySQL can quickly get a position to seek to in the middle of the datafile without having to look at all the data. If a table has 1000 rows, this is at least 100 times faster than reading sequentially. Note that if you need to access almost all 1000 rows it is faster to read sequentially because we then avoid disk seeks. In other words: mysql does not use the index because it is faster to do a full table scan in this case. -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Wont use Index when data is not evenly distributed
Just added more indexes and found a good one. thanx for the advise ! =) /C - Original Message - From: Claus Reestrup [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 29, 2002 2:28 PM Subject: Wont use Index when data is not evenly distributed Cant figure out why MySQL wont use index on a big table. Ok, the data is not evenly distributed which might be the problem. Look here: I have a table with 1 million records, with the following fields: IdUser, int X, int Y, int Z, int C, char(10) no, varchars, text, or blobs. IdUser is a user identity. As things are right now, only 3 users are registered. iduser=2, 34, 39 User 39 owns 99.999 % of the data in the table. When using EXPLAIN, Mysql tells me that when querying the table with IdUser=39, MySQL will not use index. Querying the table with all other idusers than 39, causes MySQL to use index. Has anyone of you seen this behavious before? /Claus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: SQL: Shared hosting and innodb support
On Fri, Nov 29, 2002 at 08:59:22AM -0500, Peter M. Perchansky wrote: I've seen posts in a variety of forums where it states a lot of hosting companies do not offer support for Innodb SQL type tables. AFAIK, there is no easy way to do space management on a per-customer basis with InnoDB tables. With MyISAM tables you can easily set a user's drive space limitations and the tables won't grow anymore at that point. With InnoDB tables, all the data is stored in monolithic files. -- Michael T. Babcock CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc) http://www.fibrespeed.net/~mbabcock/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Shared hosting and innodb support
Greetings Michael: Thank you for your prompt response. When you state, With InnoDB tables, all the data is stored in monolithic files does that mean every database, every database table, etc. all reside within the same file systems? Thank you. At 10:17 AM 11/29/2002 -0500, you wrote: On Fri, Nov 29, 2002 at 08:59:22AM -0500, Peter M. Perchansky wrote: I've seen posts in a variety of forums where it states a lot of hosting companies do not offer support for Innodb SQL type tables. AFAIK, there is no easy way to do space management on a per-customer basis with InnoDB tables. With MyISAM tables you can easily set a user's drive space limitations and the tables won't grow anymore at that point. With InnoDB tables, all the data is stored in monolithic files. -- Michael T. Babcock Peter M. Perchansky, President/CEO Dynamic Net, Inc. Helping companies do business on the Net 420 Park Road; Suite 201 Wyomissing PA 19610 Non-Toll Free: 1-610-736-3795 Personal Email: [EMAIL PROTECTED] Company Email: [EMAIL PROTECTED] Web: http://www.dynamicnet.net/ http://www.manageddedicatedservers.com/ http://www.wemanageservers.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: SQL: Shared hosting and innodb support
On Fri, Nov 29, 2002 at 10:32:10AM -0500, Peter M. Perchansky wrote: When you state, With InnoDB tables, all the data is stored in monolithic files does that mean every database, every database table, etc. all reside within the same file systems? Same files, not file systems. (See MySQL documentation) InnoDB uses individual files that are not directly related to which databases and tables are stored therein. -- Michael T. Babcock CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc) http://www.fibrespeed.net/~mbabcock/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: database replication and network traffic
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: Hello, I'd like to know how much traffic the slave generates on master server in a database replication configuration. I'm interested in knowing this: does the slave generate traffic even if no updates are done on the master (traffic for waiting data?) ? Thanks Paul Please reply to my email. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Users and Databases
Ryan, Thursday, November 28, 2002, 9:56:00 PM, you wrote: RM Please pardon my extreme case of the NEWBs on this but I need some help please. RM Ok I just purchased a book to hopefully clear things up for me, but to no RM avail. So this is my dilemma: I want to know about MySQL administration, RM specifically the user management portion of the admining. I want to be able to RM allow users to create whatever DBs they need. One DB for my Multi-media RM collection, one for an address book, one DB for links for a web site. Whatever RM the case may be! But it seems like I can't give a user the option to create RM and/or delete any DBs that only user X made. So I the admin would have to RM create each DB and assign appropriate privileges to appropriate users? RM So to sum up my situation into a question: Is it possible for me to give a user RM the ability to create and/or delete only their DBs? Only with MySQL - nope. RM Or do I have to make the DB RM for them and then Grant appropriate privileges for that user to that DB? It's much easier.. -- 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: ssl support in mysql
Giannis, Friday, November 29, 2002, 2:36:45 PM, you wrote: GV I was looking for mysql 4.0.x source that 's why i didn 't see any.I GV found mysql 3.23.53 source. Check it here: http://www.mysql.com/downloads/mysql-standard-4.0.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
MySQL 3.23.49 Merger table
Hi. Why merge table have been done with table that have column char type not varchar type. Have anyone succesfully with varchar type merge table and how to do that. And how to use union query if merge table not work with varchar or what SQL to use for convert varchar back to char Kittiphum Worachat,MT. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Recovery with binary logs.
Hi Martin, Thank you very much. My system is Linux based so your answers are exactly what I need. One more question though: when you use the --record_log_pos option in mysqlhotcopy, where is that position recorded? In the logging output of the program or somewhere else? Thanks again, Manuel -Original Message- From: Martin Waite [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 28, 2002 3:19 AM To: Manuel Villasante Cc: '[EMAIL PROTECTED]' Subject: Re: Recovery with binary logs. Hi Manuel, On Tue, 2002-11-26 at 21:38, Manuel Villasante wrote: Hi, I have a few questions regarding recovery of a database using binary logs. 1) If you have a set of binary logs in your directory mylog-bin.001 to mylog-bin.nmp, is there an easy way to find out which logs you need to run since the last backup? In other words, when according to the instructions, after replacing the database files with the backup ones, you run the command: mysqlbinlog mylog-bin.[0-9]* | mysql does it know automatically which set to include so as to not incorporate logs that are too old? Or do we have to manually perform a selection? If so, is there a way to figure out easily the subset if one has not been watching it? At the time of backup, you need to record the master position of the server you are backing up - or perform reset master, but this might threaten your recovery if you have a failure during the current backup process and have to roll-forward from your previous dump (requiring the binary logs that reset master have just deleted). If you record the master position (file name, offset) during your dump, you need to ensure all tables involved in the dump are locked. mysqlhotcopy can do all this for you, see the --record_log_pos option. Unfortunately, mysqlhotcopy only works on Unix-like OSes, and so you will need to roll your own if your OS is not supported. 2) If a loss of data has been caused by an unwanted statement like DROP DATABASE... or DROP TABLE VeryImportantOne, how can one delete that statement from the bin-log before using it for recovery and repeat the mistake? You could write the output of mysqlbinlog to file, edit the file, and then pipe the file into the mysql monitor: mysqlbinlog mylog-bin.[0-9]* file.sql edit file.sql mysql file.sql good luck, Martin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PURGE MASTER LOGS
I found the problem ! The command is case sensitive also on WINDOWS . I wrote the command as upcase and all is ok. - Original Message - From: Massimo Petrini [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 29, 2002 12:33 PM Subject: PURGE MASTER LOGS In my network there are 1 master and 3 slaves all with 3.52 on WIN NT. All slaves are linked correctly to the same bin-log file PISSARRO-BIN.047. With the command SHOW MASTER LOGS I see 3 files PISSARRO-BIN.045 PISSARRO-BIN.046 PISSARRO-BIN.047 If I use the command purge logs file to pissarro-bin.046 appear the error A purgeable log is in use, will not purge. But I am sure there is no slave connected to this file. Which is my error ? - Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.5(a) is released
On Friday 29 November 2002 00:32, Stefan Hinz, iConnect \(Berlin\) wrote: Dear Lenz, Removed variable `safe_show_database' as it was not used anymore. What will ISPs say about this one? They use 'safe_show_database' for their MySQL setups, so their customers on virtual MySQL hosts cannot see other customers' databases. (It's more likely that you won't attack something which you cannot see.) Or am I missing out on something? It is not that bad :) Now safe_show_database is a sort of default. And if you need user which can see all databases you can grant him SHOW_DATABASE privelege. So ISPs should be only happy with this change :) -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Peter Zaitsev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Moscow, Russia ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ERROR 2013
Hello mysql,
Backpacker lost, heading back down to the foothills of mySQL.
How do I get mysql prompt?
When I try to get the mySQL prompt:
C:\mySQL\bin\mysql -u root -p
Enter Password:
ERROR 2013 Lost connection to mySQL server during query
The above use to work, and I have not knowingly set a root password.
I recently removed 4.0.4 (stopped the service, -remove and then uninstalled
4.0.4)and did a clean install of mysqld-4-0-5-beta-max (Windows 2k
SP3).
4.0.5b is working. I can use it.
myODBC with UID root and no password! {MySQL ODBC 3.51 Driver}
also MySQLProv.3.0MySQL OLE DB Provider (MyOLEDB) v.3.0
Both use Access 2k as a front end (ADO clientside cursor).
Also I can access mySQL with some tools I use.
--
Best regards,
Arthur 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
sarnia - problem one solved
Hi The pest from Sarnia. I think I solved the first problem, made them as a csv file, but my DOS program will only write 64 characters per line (doesn't csv have to be on one line)?? I have a few records with over 3,000 characters. Still haven't figure out how to use MySQL. Would it be better if I found a search engine that could do text files?? You people are geniuses. I wish there was a group for beginners to databases. Thanks Norm SAR0260,999 feb try13,INFORMATION SARNIA LAMBTON,,, ,,,180 North College Avenue,Sarnia,ON,N7T 7X2, (519) 332-2814,,,(519) 542-4566,, ,[EMAIL PROTECTED],http://www.informsarnialambton.org,; Ray Beggs,Chairman,,,Norm Lamoureux,Database Manager,Sue Wright, Secretary,,Assists the public in locating or obtaining information about any organization, agency, program, club, group, event, or service in Sarnia- Lambton from a computer database. Provides appropriate resources. Numbers available for out-of-town services. The database is also available on the Internet.,INFORMATION AND REFERRAL,2002-01-15, - Visit me - http://www2.ebtech.net/~nlamoure/index.htm - Information Sarnia Lambton - http://www.informsarnialambton.org - Sarnia Computer Users' Group - http://www.sarnia.com/scug - Lawrence House Centre for the Arts - http://www.lawrencehouse.ca - Good computer website - http://www.techtv.com Looking for Star Wars and View Masters ! Also any U.S. state quarters. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Complex Query
Hi, I need help with a complex query that I can't figure it out myself. Suppose that I have the following tables 1) stations -id -name 2) invitations -id -station_id -invitation_status (confirmed, cancelled, postponed) I need a query that generate a report about each station with ther corresponding number of invitations and a breaddown of inviations to show total number of each invitation_status stations.name | # of invitations | # confirmed | # cancelled | # postponed - station A|30|20 | 5 |5 - station B|25|14 | 3 |8 - station C|47|29 | 6 |12 - what query should I use to get the previous output, and if I can't get these results with a direct query how would I manage to generate this report. Thanks Ahmed - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: LEGAL information about MySQL.
On Fri, 2002-11-29 at 14:59, Darney Lampert wrote: Hi, I'm beginner in maillist and my english is limited.. I want know about LEGAL MySQL software information. On www.mysql.com page, in download section I read that: You need to purchase commercial non-GPL MySQL licenses: If you distribute MySQL Software with your non open source software, If you want warranty from MySQL AB for the MySQL software, If you want to support MySQL development. distribute MySQL Software with means that my application (non open source) can use mysql if I not distribute MySQL with my application? In very brief: GPL licence protects original author of software from competing against own software. For example if somebody integrates MySQL into their software and starts to sell it, this is not allowed because then MySQL authors have do not have access to parts added to MySQL. You can integrate non-GPL software with GPL one only if: You never distribute it or You provide source code under GPL back to community. On all other cases you do not have this right under GPL licence. If you still want to integrate GPL and non-GPL software you need ask authors permission to use software under different conditions. In MySQL this means you have to pay for it and this seems fair to me. Tonu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: LEGAL information about MySQL.
If your software utilize the software under GPL license, you can simply add those GPL licenses as well as make a note that you are only selling, i.e. the price is only for your own software, your own software, you should be fine. Just to pretect your own benefit, you can add a statment saying that all rights of GPL license reserved by them. And those are provided just for your convenience. Pae On Fri, 2002-11-29 at 14:59, Darney Lampert wrote: Hi, I'm beginner in maillist and my english is limited.. I want know about LEGAL MySQL software information. On www.mysql.com page, in download section I read that: You need to purchase commercial non-GPL MySQL licenses: If you distribute MySQL Software with your non open source software, If you want warranty from MySQL AB for the MySQL software, If you want to support MySQL development. distribute MySQL Software with means that my application (non open source) can use mysql if I not distribute MySQL with my application? In very brief: GPL licence protects original author of software from competing against own software. For example if somebody integrates MySQL into their software and starts to sell it, this is not allowed because then MySQL authors have do not have access to parts added to MySQL. You can integrate non-GPL software with GPL one only if: You never distribute it or You provide source code under GPL back to community. On all other cases you do not have this right under GPL licence. If you still want to integrate GPL and non-GPL software you need ask authors permission to use software under different conditions. In MySQL this means you have to pay for it and this seems fair to me. Tonu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
tools for characterizing performance?
It seems strange to me that the tools in the MySQL distribution that let you run automatic performance tests rely on DBI and perl. If I want to test the performance of MySQL, why is it a good idea to do this while relying on another technology, one that is distributed by someone else, one that may have integration issues with pre-release versions of MySQL? I imagine that the perl part of this makes it easier to generate those nice little reports. So, why would one not use MySQL tools to run the performance tests and dump out to a raw format, which would then be fed into a completely separate application, written in perl for example, that would then pretty-print the data? This would seem to be a much less fragile solution. It would also have the benefit that one could test the performance of MySQL without polluting the results with perl and DBI cruft. Would anybody care to defend the current approach? thanx - ray - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Date()
Is it possible for mySQL to recognize and compare dates written in this format: MM/DD/YY? I know standard date format for mySQL is YYY-MM-DD, but I need to be able to support this other format if possible. For example, I have a string of 01/30/02 and I just need to compare it to another value already in the dB, being held as a varchar with a value of 02/28/02. I need to compare these to determine if one date preceeds the other. Any way of doing this with the resources mySQL already has built in - without having to convert the format of the date values? Thanks. Neal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Date()
Look at the DATE_FORMAT function. http://www.mysql.com/doc/en/Date_and_time_functions.html -Original Message- From: hotel [mailto:[EMAIL PROTECTED]] Sent: Friday, November 29, 2002 6:07 PM To: mySQL Subject: Date() Is it possible for mySQL to recognize and compare dates written in this format: MM/DD/YY? I know standard date format for mySQL is YYY-MM-DD, but I need to be able to support this other format if possible. For example, I have a string of 01/30/02 and I just need to compare it to another value already in the dB, being held as a varchar with a value of 02/28/02. I need to compare these to determine if one date preceeds the other. Any way of doing this with the resources mySQL already has built in - without having to convert the format of the date values? Thanks. Neal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
No port listed
I'm running mysql 3.23.53 on Red hat linux 7.1. When i do mysqladmin version, it does not list a port and when I do mysqladmin -h 'hostname' version, it says that Host 'hostname' is not allowed to connect to this MySQL server. Any help would be appreciated David --- [This E-mail scanned for viruses by Declude Virus] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Complex Query
try this: select a.name, b.invitation_status, count(*) from stations a, invitations b where a.id = b.station_id group by a.name, b.invitation_status - Original Message - From: Ahmed Farouk [EMAIL PROTECTED] Date: Fri, 29 Nov 2002 22:50:34 +0200 To: [EMAIL PROTECTED] Subject: Complex Query Hi, I need help with a complex query that I can't figure it out myself. Suppose that I have the following tables 1) stations -id -name 2) invitations -id -station_id -invitation_status (confirmed, cancelled, postponed) I need a query that generate a report about each station with ther corresponding number of invitations and a breaddown of inviations to show total number of each invitation_status stations.name | # of invitations | # confirmed | # cancelled | # postponed - station A|30|20 | 5 |5 - station B|25|14 | 3 |8 - station C|47|29 | 6 |12 - what query should I use to get the previous output, and if I can't get these results with a direct query how would I manage to generate this report. Thanks Ahmed - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Default MySQL Buffer Cache size
Does anyone please know the default MySQL buffer cache size? I didn't set it while doing a source install and I'm wondering what it is? 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
GROUP BY .. HAVING . bug or feature?
Hello. I have a following table. mysql SELECT * FROM group_test ; +--+--+--+ | a| b| c| +--+--+--+ |1 |1 |1 | |1 |1 |1 | |1 |1 |1 | |2 |2 |2 | |2 |2 |2 | |3 |3 |3 | +--+--+--+ 6 rows in set (0.00 sec) mysql SELECt a, COUNT(*) FROM group_test - GROUP BY a, b ; +--+--+ | a| COUNT(*) | +--+--+ |1 |3 | |2 |2 | |3 |1 | +--+--+ 3 rows in set (0.00 sec) But, when I use HAVING and IN() togather, MySQL returns no rows. mysql SELECt a, COUNT(*) FROM group_test - GROUP BY a, b - HAVING COUNT(*) IN ( 1, 2, 3 ) ; Empty set (0.00 sec) Other relational operators works well. I'm using MySQL 4.0.3 Thank you for advanced answer!. Have a nice weekend. ## Heo, Jungsu Mr. SimpleX Internet. http://www.simplexi.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
Re: LEGAL information about MySQL.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Pae Choi wrote: If your software utilize the software under GPL license, you can simply add those GPL licenses as well as make a note that you are only selling, i.e. the price is only for your own software, your own software, you should be fine. Uh, no. See http://www.gnu.org/licenses/gpl.html if you're not sure what you're agreeing to when using GPL software. Just to pretect your own benefit, you can add a statment saying that all rights of GPL license reserved by them. And those are provided just for your convenience. If you are not sure exactly how the GPL works, and you have read the license terms that I've referenced above, and still want to distribute your software that uses and/or links to software licensed under the GPL, I suggest you first seek a lawyer's opinion, and have it explained to you in non-legalese. In basic terms, the GPL says if you include GPL software via use and-or linking in your software, you must distribute _your_ software under GPL terms. What you advocate is the same as saying that you if stick a pirated copy of windows in with your software, but disclaim in your documentation that you're only paying for your software, not the copy of windows that is not following Microsoft's licensing terms. -Mark - -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.1.90 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE96D8CtvXNTca6JD8RAga+AJ9I4TCWenn5VvhmXW9LyUBMza4SiQCfS7nF n7vAbQDwcBLfVb4MLnXrEck= =clzO -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Default MySQL Buffer Cache size
You mean bdb_cache_size, binlog_cache_size, max_binlog_cache_size, thread_cache_size, or thread_cache_size? PB - - Original Message - From: Geetika Tewari [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 29, 2002 8:11 PM Subject: Default MySQL Buffer Cache size Does anyone please know the default MySQL buffer cache size? I didn't set it while doing a source install and I'm wondering what it is? 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
getting InnoDB running on windows 2000
I have mysql running using its standard myisam database. The server is version 3.23.39-max, client 3.23.36 Operating system Windows 2000 5.00.2195 Service pack 2 I am using the following my.ini #This File was made using the WinMySQLadmin 1.1 Tool #11/21/2002 9:16:12 PM #Uncomment or Add only the keys that you know how works. #Read the MySQL Manual for instructions [mysqld] basedir=C:/mysql #bind-address=192.168.1.100 datadir=C:/mysql/data #language=C:/mysql/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M # my.ini file to invoke InnoDB option for mysql # - example form page 508 of manual # innodb_data_file_path = ibdata1:50M:autoextend # # set buffer pool size to 50- 80% (for now less) # #set-variable = innodb_buffer_pool_size=60M #set-variable = innodb_additional_mem_pool_size=10M # # log file 25% of buffer pool size # #set-variable = innodb_log_file_size=20M #set-variable = innodb_log_buffer_size=8M # # flush log commit - value of 0 loses transactions #innodb_flush_log_at_trx_commit=1 [WinMySQLadmin] Server=C:/mysql/bin/mysqld-max-nt.exe user=Bruce password=Lillian1 I get the following message: - 020329 1:07:55 Aborted connection 1 to db: 'test' user: 'ODBC' host: `localhost' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html 020329 12:55:30 Aborted connection 4 to db: 'unconnected' user: 'ODBC' host: `localhost' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html the database will not come up or generate the files needed for InnoDB, and when I bring up in default - haveinnodb = DISABLED It creates the database InnoDB in the Mysql database but there is no corresponding file. Can anyone tell me what I am doing wrong? Thanks Bruce A R Kuppers B.Sc.(Hons), M.Sc., Ph.D. Phone: (250) 656-3678 Toll Free: (866) 605-0259 E-Commerce -- Wave of the Future! Get Involved! Claim Your Future! Ask How! Visit: www.kuppersinernational.com Password: bruce - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
