Re: InnoDB Performance
Eko and all, The MyIsam storage engine is a non transactional engine and InnoDb is a transactional engine. That is the main difference. So I think the MyIsam engine should be faster. However, some file systems that have journals are faster than non journalling file system. It's not always that clear cut. I've just switched a number of big customer databases to InnoDB and noone's noticed any difference - if anything it's going faster. DSL ( mysql, sql ) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: book advice
David, Can anyone recommend this book? Or, if not, what book can you recommend for a newbie. I always recommend Paul Dubois' New Riders Book: * http://www.kitebird.com/mysql-book/ Paul's probably lurking on the list. I bought the 1999 edition and I still refer to it :) DSL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Replication
Hi There, I have a replication setup on my local network (so any updates can be transported at around ethernet speed). Here's the behaviour I see: * MySQL Master - I do a whole slew of drop table and create tables * MySQL Slave - It doesn't pick them up ... until ... - I restart the slave It doesn't appear to have a problem with a single database table being dropped, only when I drop a whole heap at once [I'm replacing the underlying scheme with a heap of drop table ifs followed by create table]. I'm running the official mysql-4.1.10 Apple binaries. One on my OS X server [which is the master] and another on OS X [not server] [which is the slave]. Anywhere I can work out what might be happening or why the updates are being sent through? DSL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Setting up an organization's member database
Fafa, I am running this non-profit organization working together with various charity organizations across the world. We would like to setup an efficient member database using MySQL rather than having some ugly formatted MS Word document listing them. What would be the purest and cleanest way of setting one up, and maintaining it? It should support all personal biodata fields, arranged under individual, organizational, corporate and honorary memberships. I hope anybody has been in the same situation as me. Look for a project at http://freshmeat.net/ - there's a few of them around (go searching - eg. member database or some such thing). DSL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Grant Tables problem (I think)
Hi, I have a problem connecting to the mysql server. I installed a new server with mysql 4.1.9, apache2, php4 on freebsd5.3 and have some websites running on it using the mysql server. Last friday I had a crash of one off my other servers and I copied the websites and db's to this new server. (old server was mysql 3). After that the mysql server didn't startup anymore. I then chown'ed the data dir to mysql:mysql. After that I was able to start the server with --skip-grant-tables . But it didn't start with out the --skip-grant-tables option. So I found out to use mysql_install_db to create new grant tables. After that the server starts with and without --skip-grant-tables. But only with the --skip-grant-tables option, websites can connect to the databases. I can't find any real errors in the logs and I can't find anything on the web or forum. I run mysql_fix_privilege_tables and installed a root passwd. Hopefully somebody can help me on this. I wonder if putting: [mysql] old-passwords ...in your my.cnf (I always use /etc/my.cnf because trying to guess where the 'real' data directory is, is painful). http://dev.mysql.com/doc/mysql/en/password-hashing.html DSL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL
Theresa, Knowing that MySQL is an open source software I'm in favour of this application and wldlike to try out this product, wonder why I can download this application for my necessary practice for both Client/Server application. I assume you mean How can I download the Mysql server and client as opposed to Why can I download it. Here is a good start: * http://www.mysql.com/downloads/index.html The documentation (check the documentation link) gives more details. There are also books you can purchase: * Paul DuBois' Using MySQL (New Riders) is very good DSL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Daylight Savings Time
James, We had a strange instance happen here with one of our MySQL servers. We have multiple MySQL installations, and one of the MySQL servers had a problem with daylight savings time. Basically, when we ran a select now(); MySQL reported time that was two hours ahead of the actual time. The system /bin/date command was correct however. Were they all on the same operating system and version? DSL -- The Open Source Business Network in SA ...will be open soon! Watch this space. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Optimal Disk Configuration
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jim, What would be the ideal RAID configuration for a dedicated MySQL db server running on FreeBSD? We're also running some MySQL databases on Windows 2000 Servers. What about the best configuration for a dedicated W2k server running MySQL? That depends on what your definition of optimal is... ;-P -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQE/B4xxmk7m2JX6ki4RAoOaAJ9JCEj8XSPY6X9vh14O7UVk/GU1fwCeLE7C 59yx9fQEV1xX8oqXEtw2RDY= =Nuab -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: *****SPAM***** confirm subscribe to mysql@lists.mysql.com
On 23 Nov 2002 12:49:33 - [EMAIL PROTECTED] wrote: SPAM: Start SpamAssassin results -- SPAM: This mail is probably spam. The original message has been altered SPAM: so you can recognise or block similar unwanted mail in future. SPAM: See http://spamassassin.org/tag/ for more details. SPAM: SPAM: Content analysis details: (4.20 hits, 4 required) SPAM: NO_REAL_NAME (1.3 points) From: does not include a real name SPAM: FORGED_RCVD_FOUND (0.8 points) Possibly-forged 'Received:' header found SPAM: SPAM_PHRASE_05_08 (1.6 points) BODY: Spam phrases score is 05 to 08 (medium) SPAM: [score: 6] SPAM: MAILTO_TO_SPAM_ADDR (0.7 points) URI: Includes a link to a likely spammer email address SPAM: SIGNATURE_SHORT_DENSE (-0.3 points) Short signature present (no empty lines) SPAM: MSG_ID_ADDED_BY_MTA_2 (0.1 points) 'Message-Id' was added by a relay (2) SPAM: SPAM: End of SpamAssassin results - Hi! This is the ezmlm program. I'm managing the [EMAIL PROTECTED] mailing list. To confirm that you would like [EMAIL PROTECTED] added to the mysql mailing list, please send an empty reply to this address: mysql-sc.1038055773.fmkjmofeihfglclhmmci-lloy0076=adam.com.au@list s.mysql.com Usually, this happens when you just hit the reply button. If this does not work, simply copy the address and paste it into the To: field of a new message. This confirmation serves two purposes. First, it verifies that I am able to get mail through to you. Second, it protects you in case someone forges a subscription request in your name. Some mail programs are broken and cannot handle long addresses. If you cannot reply to this request, instead send a message to [EMAIL PROTECTED] and put the entire address listed above into the Subject: line. --- Administrative commands for the mysql list --- I can handle administrative requests automatically. Please do not send them to the list address! Instead, send your message to the correct command address: To subscribe to the list, send a message to: [EMAIL PROTECTED] To remove your address from the list, send a message to the address in the List-Unsubscribe header of messages from the list. If you don't know how to display headers and haven't changed E-mail addresses since subscribing, you'll be successful with an e-mail to: [EMAIL PROTECTED] Send mail to the following for info and FAQ for this list: [EMAIL PROTECTED] [EMAIL PROTECTED] Similar addresses exist for the digest list: [EMAIL PROTECTED] [EMAIL PROTECTED] To get messages 123 through 145 (a maximum of 100 per request), mail: [EMAIL PROTECTED] To get an index with subject and author for messages 123-456 , mail: [EMAIL PROTECTED] They are always returned as sets of 100, max 2000 per request, so you'll actually get 100-499. To receive all messages with the same subject as message 12345, send an empty message to: [EMAIL PROTECTED] The messages do not really need to be empty, but I will ignore their content. Only the ADDRESS you send to is important. You can start a subscription for an alternate address, for example [EMAIL PROTECTED], just add a hyphen and your address (with '=' instead of '@') after the command word: [EMAIL PROTECTED] To stop subscription for this address, mail: [EMAIL PROTECTED] In both cases, I'll send a confirmation message to that address. When you receive it, simply reply to it to complete your subscription. If despite following these instructions, you do not get the desired results, please contact my owner at [EMAIL PROTECTED] Please be patient, my owner is a lot slower than I am ;-) --- Enclosed is a copy of the request I received. Return-Path: [EMAIL PROTECTED] Received: (qmail 22014 invoked by uid 7797); 23 Nov 2002 12:49:33 - Delivered-To: request processor for [EMAIL PROTECTED] Received: (qmail 22009 invoked from network); 23 Nov 2002 12:49:31 - Received: from monster.filearena.net (202.6.159.69) by www.mysql.com with SMTP; 23 Nov 2002 12:49:31 - Received: from lightning.adam.com.au (lightning.adam.com.au [203.2.124.20]) by monster.filearena.net (8.12.6/8.12.6) with SMTP id gANCnRbT035234 for [EMAIL PROTECTED]; Sat, 23 Nov 2002 23:19:28 +1030 (CST)(envelope-from [EMAIL PROTECTED]) Received: (qmail 70429 invoked from network); 23 Nov 2002 12:49:23 - Received: from 202-6-129-44.ip.adam.com.au (HELO localhost) (202.6.129.44) by eden.adam.com.au with SMTP; 23 Nov 2002 12:49:23 - Date: Sat, 23 Nov 2002 23:31:12 +1030 From: David Lloyd [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: subscribe Message-Id: [EMAIL PROTECTED] X-Mailer: Sylpheed version 0.8.5 (GTK+ 1.2.9; i686-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit
Re: *****SPAM***** confirm subscribe to mysql@lists.mysql.com
On 23 Nov 2002 12:54:52 - [EMAIL PROTECTED] wrote: SPAM: Start SpamAssassin results -- SPAM: This mail is probably spam. The original message has been altered SPAM: so you can recognise or block similar unwanted mail in future. SPAM: See http://spamassassin.org/tag/ for more details. SPAM: SPAM: Content analysis details: (4.20 hits, 4 required) SPAM: NO_REAL_NAME (1.3 points) From: does not include a real name SPAM: FORGED_RCVD_FOUND (0.8 points) Possibly-forged 'Received:' header found SPAM: SPAM_PHRASE_05_08 (1.6 points) BODY: Spam phrases score is 05 to 08 (medium) SPAM: [score: 6] SPAM: MAILTO_TO_SPAM_ADDR (0.7 points) URI: Includes a link to a likely spammer email address SPAM: SIGNATURE_SHORT_DENSE (-0.3 points) Short signature present (no empty lines) SPAM: MSG_ID_ADDED_BY_MTA_2 (0.1 points) 'Message-Id' was added by a relay (2) SPAM: SPAM: End of SpamAssassin results - Hi! This is the ezmlm program. I'm managing the [EMAIL PROTECTED] mailing list. To confirm that you would like [EMAIL PROTECTED] added to the mysql mailing list, please send an empty reply to this address: mysql-sc.1038056092.mkconkllmfaolhocmndb-lloy0076=adam.com.au@list s.mysql.com Usually, this happens when you just hit the reply button. If this does not work, simply copy the address and paste it into the To: field of a new message. This confirmation serves two purposes. First, it verifies that I am able to get mail through to you. Second, it protects you in case someone forges a subscription request in your name. Some mail programs are broken and cannot handle long addresses. If you cannot reply to this request, instead send a message to [EMAIL PROTECTED] and put the entire address listed above into the Subject: line. --- Administrative commands for the mysql list --- I can handle administrative requests automatically. Please do not send them to the list address! Instead, send your message to the correct command address: To subscribe to the list, send a message to: [EMAIL PROTECTED] To remove your address from the list, send a message to the address in the List-Unsubscribe header of messages from the list. If you don't know how to display headers and haven't changed E-mail addresses since subscribing, you'll be successful with an e-mail to: [EMAIL PROTECTED] Send mail to the following for info and FAQ for this list: [EMAIL PROTECTED] [EMAIL PROTECTED] Similar addresses exist for the digest list: [EMAIL PROTECTED] [EMAIL PROTECTED] To get messages 123 through 145 (a maximum of 100 per request), mail: [EMAIL PROTECTED] To get an index with subject and author for messages 123-456 , mail: [EMAIL PROTECTED] They are always returned as sets of 100, max 2000 per request, so you'll actually get 100-499. To receive all messages with the same subject as message 12345, send an empty message to: [EMAIL PROTECTED] The messages do not really need to be empty, but I will ignore their content. Only the ADDRESS you send to is important. You can start a subscription for an alternate address, for example [EMAIL PROTECTED], just add a hyphen and your address (with '=' instead of '@') after the command word: [EMAIL PROTECTED] To stop subscription for this address, mail: [EMAIL PROTECTED] In both cases, I'll send a confirmation message to that address. When you receive it, simply reply to it to complete your subscription. If despite following these instructions, you do not get the desired results, please contact my owner at [EMAIL PROTECTED] Please be patient, my owner is a lot slower than I am ;-) --- Enclosed is a copy of the request I received. Return-Path: [EMAIL PROTECTED] Received: (qmail 22305 invoked from network); 23 Nov 2002 12:54:44 - Received: from monster.filearena.net (202.6.159.69) by www.mysql.com with SMTP; 23 Nov 2002 12:54:44 - Received: from lightning.adam.com.au (lightning.adam.com.au [203.2.124.20]) by monster.filearena.net (8.12.6/8.12.6) with SMTP id gANCsfbT035321 for [EMAIL PROTECTED]; Sat, 23 Nov 2002 23:24:41 +1030 (CST)(envelope-from [EMAIL PROTECTED]) Received: (qmail 72873 invoked from network); 23 Nov 2002 12:54:37 - Received: from 202-6-129-44.ip.adam.com.au (HELO localhost) (202.6.129.44) by eden.adam.com.au with SMTP; 23 Nov 2002 12:54:37 - Date: Sat, 23 Nov 2002 23:36:27 +1030 From: David Lloyd [EMAIL PROTECTED] To: [EMAIL PROTECTED] Message-Id: [EMAIL PROTECTED] X-Mailer: Sylpheed version 0.8.5 (GTK+ 1.2.9; i686-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit -- I'm sure you'll see there's more to Martin Guerre than a name! (From the musical, Martin Guerre) -- I'm sure you'll see there's more
Programming APIs for MySQL
I know that there are binding that allow one to speak SQL to MySQL for: * PHP * Perl * Java ...there must be more, all with their own idiosyncrancies, strong points and weaknesses. Rather than having a holy war about which binding is better (I prefer Perl but I certainly use PHP when it's appropriate), why don't we talk about which bindings exist and their features... And then we may be able to present some useful, constructive information to the world. DSL -- Angel of Music, why deny me? Turning from true beauty! Angel of music, do not shun me, Turn to your strange Angel! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql Innodb performance slow
Mark, Note that mysql does not support bind variables. If you think you'reusing them, whatever API you are using is filling them in beforesending the statement to mysql. Bind variables do solve quotingproblems, though, so if you use them, know why you're using them :) Rumour has it, though, that DBD::MySQL (or whichever module it is) performs better with the bound variable versions than the non bound variable versions. DSL -- The Linux C Programming Lists: * http://lists.linux.org.au/listinfo/linuxcprogramming/ The Linux C++ Programming Lists: * http://lists.linux.org.au/listinfo/tuxcpprogramming/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Structure
Stephanie, Does anyone know if there's a way in MySQL have the same functionality without installing the whole program on a users machine? I'm using a Java program along with Connector/J and a MySQL DB. We are trying to make it so the user doesn't have to install MySQL everytime they want to install the program on their machine. Somewhere on the MySQL (query) site I saw something about embedded mysql... DSL -- Somewhere where I hope to find someone Still I find myself near you If I hear the words I'll go. (from the musical Martin Guerre) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Recommended Books
Actually, I'd suggest the New Riders Book by Paul DuBois, Mysql...what was it you wanted to achieve with your book: * do you want a reference * a tutorial ...? mysql,query DSL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Embedded MySQL
What's the advantages of using Embedded MySQL instead of, say, Berkely's DB? [mysql, query] DSL -- Qualcuno no mi basta. Vivere cercando il grande amore. Vivere come se mai dovessimo morire. (Anastasio, Valli e Travato) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 (?!)
Any reason you can't upgrade to a newer version? mysql,query DSL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 as a desktop DB
Adam, Obviously MySQL would have advantages if I intended to use it as a server database with concurrent users. But is it faster than Access in the single-user environment, when dealing with large databases? MySQL in a single user environment is a pain in the arse because of its lack of an Access Like front end that is actually useful and featureful (Access is crap, but it's a better database frontend than currently exists). (mysql, query) DSL -- I reniad lin ne mor, nuithannen In gwidh ristennin, i fae narchannen I lach Anor ed ardhon gwannen (Soundtrack LOTR - and it's not LATIN) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: first dbi access with perl and lost
Gerald,
#!perl
use strict;
use DBI();
# Connect to the database.
my $dbh = DBI-connect(DBI:mysql:database=club;host=localhost,
jwp, x,
{'RaiseError' = 1});
$drh = DBI-install_driver(\mysql);
I am not sure what is wrong.
I get the following error:
Global sysmbol $drh requires explicit package name at dbtest.pl line 12
That's a Perl error.
You've told Perl not to allow you to use a variable unless you declare
it with:
my
local
our
(and possibly other keywords but these are the most common)
If you substitute:
my $drh=
...then you'll be fine.
You might want to find out more information on what the use strict
actually does too. A good place would be the perl documentation
(perldoc) or http://www.perl.org/
Hope this helps.
DSL
[mysql,query]
--
I reniad lin ne mor, nuithannen
In gwidh ristennin, i fae narchannen
I lach Anor ed ardhon gwannen
(Soundtrack LOTR)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: first dbi access with perl and lost
Gerald, Now I am getting the following: install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC contains; C:/Perl/lib C:/Perlsite/lib .) at (eval 1) line 3; I can't mysql.pm on my PC. Was it not generated when I installed MySQL? How do I fix this? No, it's separate from the distribution of MySQL. If you're using ActiveState then start the ppm (Perl Package Manager Utility) and look for: DBD::mysql You'll find it here: * http://theoryx5.uwinnipeg.ca/mod_perl/cpan-search?request=search (Search for DBD::mysql) I don't really know the best way to install Perl modules on Windows (I avoid Windows like the plague). DSL -- I reniad lin ne mor, nuithannen In gwidh ristennin, i fae narchannen I lach Anor ed ardhon gwannen (Soundtrack LOTR) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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...
Joao, I think I've already asked this before, but I will try again. Do I loose too much performance using InnoDB tables in autocommit mode instead of using MyISAM tables? Possibly, but too much is really relative on what your needs are. What are you trying to achieve and what is more important to you: * speed * reliability * ability to roll back commits mysql,query ?? DSL -- I reniad lin ne mor, nuithannen In gwidh ristennin, i fae narchannen I lach Anor ed ardhon gwannen (Soundtrack LOTR) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: SHOW VARIABLES bug in 4.0.3 on solaris 2.7?
Mysql Query --- Just out of interest, do you see the equivalent of a core file when this happens? Or anything in the mysql logs? DSL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need to cleanly uninstall
Spiros, linux:/home/db/TMPOUT # rpm -q mysql package mysql is not installed linux:/home/db/TMPOUT # rpm -qa | grep MySQL MySQL-shared-4.0.3-0 MySQL-client-4.0.3-0 MySQL-devel-4.0.3-0 MySQL-4.0.3-0 linux:/home/spiros/TMPOUT # Ok. mypc@linux:~ /usr/bin/mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) mypc@linux:~ /usr/bin/mysqld_safe /usr/bin/mysqld_safe: my_print_defaults: command not found The file /usr/sbin/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/mysqld_safe. @linux:~ Does this mean the rpm is no good? What next Possibly. What version of Linux are you using? DSL -- Con te partiro, su navi per mari Che io lo so, no, no non esistono piu Con te io li vivro. (Sartori F, Quarantotto E) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need to cleanly uninstall
Hmmm, (mysql, query) Thanks That's OK. It's 2.4.18 Sorry, I meant distribution...eg is it RedHat, Slackware ;-? So, I will try to unistall and install from the tarball, yes? It wouldn't hurt. How did you install it in the first place? DSL -- Con te partiro, su navi per mari Che io lo so, no, no non esistono piu Con te io li vivro. (Sartori F, Quarantotto E) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help with WHERE string searching
H,
Suppose I have a field named title that contains
one
of these
I am a Man
I am a Woman
We are Men
We are Women
Why not split this into two fields:
pronoun enum('I','WE')
gender enum('MAN','WOMAN')
OR a SET
title SET(I,WE,MAN,MEN,WOMAN,WOMEN)
...and then get your application to parse the various sentences and
store the data correctly.
(mysql,query)
DSL
--
Con te partiro, su navi per mari
Che io lo so, no, no non esistono piu
Con te io li vivro.
(Sartori F, Quarantotto E)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need to cleanly uninstall
You could do something like: linux:/home/db/TMPOUT # rpm -e MySQL-4.0.3-0.i386.rpm error: package MySQL-4.0.3-0.i386.rpm is not installed Don't add the RPM on the end. Also, what does: * rpm -qa | grep MySQL ...show. It will be in there. Use that name. mysql,query DSL -- Con te partiro, su navi per mari Che io lo so, no, no non esistono piu Con te io li vivro. (Sartori F, Quarantotto E) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Select all with an excpetion
Hmmm... Specify the fields you want in your query. example: SELECT stat_id, stat_name, stat_data FROM build_stats WHERE stat_date LIKE ... I think you miss the point of the question. What if you have table with 50 fields and you just don't want field 45, 46 and 48? It would be much easier to use an except clause here rather than have to specify 47 fields... DSL (this mysql query spam filter is spam) -- Con te partiro, su navi per mari Che io lo so, no, no non esistono piu Con te io li vivro. (Sartori F, Quarantotto E) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 programming question
You may want to check out CPAN for: Apache::DBIx ... (kill the mysql query spam thingo) DSL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to read table names within database?
Mark, I notice that lots of mysql gui's all can find out the contents (tables) of any given database, how do they do this? Is it an sql command? Parse the contents of SHOW DATABASES and then use the ouput of that to SHOW TABLES... mysql, query. DSL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
InnoDB Question
Hi There, (mysql, query) From the online manual I see: -- innodb_data_file_path Paths to individual data files and their sizes. The full directory path to each data file is acquired by concatenating innodb_data_home_dir to the paths specified here. The file sizes are specified in megabytes, hence the 'M' after the size specification above. Do not set a file size bigger than 4000M, and on most operating systems not bigger than 2000M. InnoDB also understands the abbreviation 'G', 1G meaning 1024M. The sum of the sizes of the files must be at least 10 MB. -- This implies that I have to preguess how large each data file will be. Now, I understand with MyISAM tables that they just grow until they fill up your filesystem or hit some OS limit such as the 2Gb limit in Linux 2.4.X. A few questions: 1) If I setup InnoDB with a 500Mb data file then suddenly run out of space could I: * seemlessly just stack another data file by adjusting my startup options * seemlessly just make the data file larger by changing the file size (i.e. don't add another datafile, just increase the file size) 2) Is there a way to make this more dynamic? * what if a user wants to add a 10Mb blob into my database, but the datafile has only 5Mb of space left for data... (with MyISAM tables they just seem to grow as needed) DSL -- Con te partiro, su navi per mari Che io lo so, no, no non esistono piu Con te io li vivro. (Sartori F, Quarantotto E) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: primary/foreign key contraints
Neal, Sorry for the MySQL newbie question ... but are there not primary/foreign key constraints in MySQL 3? In MyISAM tables or ISAM tables no. I can't imagine that this is right. Perhaps I'm just overlooking something innodb? (mysql query) DSL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Installing mysql-3.23.52
( mysql, query ) Can anyone help. I'm installing (at the mo) 4.0.3 Beta, but the error message is the same which ever version.. libmysql.c: In function `mysql_real_connect': libmysql.c:1675: warning: passing arg 5 of `gethostbyname_r' from incompatible pointer type libmysql.c:1675: too few arguments to function `gethostbyname_r' libmysql.c:1675: warning: assignment makes pointer from integer without a cast There's an argument mismatch; I don't have the source to this version so I can't help you. However, what architecture/compiler are you using? This might help the others help you :-) DSL -- Say you'll share with me one love, one lifetime Lead me, save me from my solitude. Say you'll want me with you, here beside you Anywhere you go let me go too... (Webber/Hart/Black) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Lock Permissions
H... ( mysql, query ) What permissions does a user need to issue: LOCK TABLES blah WRITE ??? I have a user which I have: GRANT ALL ON * TO user (blah blah) ...but that user can't lock any tables. Only the mysql root user can... Version 4.0.2, built from source on RH 7.1. DSL -- Say you'll share with me one love, one lifetime Lead me, save me from my solitude. Say you'll want me with you, here beside you Anywhere you go let me go too... (Webber/Hart/Black) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 replication protocol
Paul, (mysql, query) It *can* use TCP, but that's just the transport protocol through which the replication information is processed. Replication can also be done between two servers on the same host, using a UNIX socket or (on a Windows box) a named pipe. The replication protocol itself is MySQL-specific. I would assume, then, that if it were done over TCP/IP that one could setup ipsec to secure it. Just out of interest (and hit me if it's in the manual somewhere ;-P), does the replication protocol offer any cryptographically secure method of replication if one wants it? DSL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: convert ms access mdb file to file that can be imported in mysql
Andy, ( mysql, query ) you could install MyODBC to write the tables directly from MS A. to MySQL via ODBC. Works ok and did a good job for me. I've looked through the archives of this list but all methods of porting a ms access db to mysql seem to require installing additional software under Windows. You have missed his point. He's asking Microsoft to support MySQL as a native backend. YEAH RIGHT I'd suggest the original asker rephrase his question into something a little more useful... DSL -- Say you'll share with me one love, one lifetime Lead me, save me from my solitude. Say you'll want me with you, here beside you Anywhere you go let me go too... (Webber/Hart/Black) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: file size limit
Paul et al, At 18:59 -0400 8/31/02, qlarry wrote: here a file size limit in my sql What? I think that loosely should translate as Where is a file size limit in MySQL which I would then interpret as Is there a file size limit in MySQL. All MyISAM tables are stored on the local file system so it is dependant on the file system and operating system you are running. Or to put it another way, your MyISAM table (MySQL's default type) are stored as files, and it is your operating system that limits the file size and not MySQL. As for other types such as BDB and InnoDB I don't know the answer. I hope this helps. DSL -- Say you'll share with me one love, one lifetime Lead me, save me from my solitude. Say you'll want me with you, here beside you Anywhere you go let me go too... (Webber/Hart/Black) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Syntax
David [ mysql,query ] update CompanyContacts set ByEmailAddress = '[EMAIL PROTECTED]' where Description like '%marve%' Can you show us the output of: describe CompanyContacts ...and also what is the exact error message? Are you connected as a user who is allowed to update the CompanyContacts table? I often have select only users and forget that I can't update/delete etc on the database tables :-) DSL -- Say you'll share with me one love, one lifetime Lead me, save me from my solitude. Say you'll want me with you, here beside you Anywhere you go let me go too... (Webber/Hart/Black) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: *****SPAM***** Query problem
Amit, I am trying to run the following query:- select red,green,blue from colorchanger where colorcode = select value from jobattributekit where attributekit = Color and jobnumber = 28200124RB4-001 and scenario=JN75K; It doesn't support subselects. It's having a problem with the second select... I believe that subselects are on the wish list and will (eventually) appear but not at the moment in a stable release. DSL mysql, 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: *****SPAM***** when I installed mysql 3.23.43
Dave [ mysql query] when I installed mysql 3.23.43 it instructed me to be sure to add a password with the following results- : seaport2:/# /usr/mysql/bin/mysqladmin -u root -p password 'new-password' Enter password: /usr/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' Read the man pages for mysqladmin for full details on all options (there are lots of them ;-P). The option -p is the password you use to connect to the server, however on a default installation you should specify no password. Essentially what you're doing is saying: Connect me to the server at 'localhost' with the password 'password' and user 'root' ...which is NOT what you want to do because the default databases don't expect a password _at all_ [which is why it is strongly suggested you change the passsword] Drop the -p so it looks like: /usr/mysql/bin/mysqladmin -uroot password 'newpassword' Also, don't forget to flush the privileges after changing the password. DSL -- We are not the United States' ally We are the 53rd sovereign state of the Federation - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: generating random integer id
[ mysql, query ] could someone point me to the right direction please Are you generating it in MySQL (using sql) or are you using a programming language to do it? DSL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 vs. Oracle (not speed) - not part of the rant, but real information
Adam, [ mysql, query ] However, you can do it manually (I think) by playing around with both the order of the where clause and the order of the join clause Yes. Also, MySQL has a really wimpy default configuration (I can't figure out why). Here is my /etc/my.cnf (I don't know what the equivalent is on windows) Most likely to cater for people running MySQL on servers without a lot of memory. Fancy having a key-buffer of 256M if you only had 128M of real memory... DSL (ps: how the world has this discussion gone from Oracl to Micorosft SQL Server...lol) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Relation Among Tables Urgent()
l, I want to create an one to one relationship among tables using SQL. How can i do this. I creates an relation but it dose not expect my needs. For Ex they are two table say tbset nad tb tbprocess. If i set an one to one relation between the two tables in which the master table is tbset. If i change the values in the tbset table the change should be refleted in the slave table that is tbprocess. I think i can do this in msacess. But i changed to mysql in which i need to write the Query(There is no gui for mysql as like msacess). Pls Reply me regarding this Balaji __ Give your Company an email address like ravi @ ravi-exports.com. Sign up for Rediffmail Pro today! Know more. http://www.rediffmailpro.com/signup/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- We are not the United States' ally We are the 53rd sovereign state mysql,query I think you're asking for foreign key updates, which aren't currently supported in MyISAM tables. DSL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 duplicate table
Brent Don't know if that's what you are trying to do. But I can't think of any reason to permanently replicate a table in the same database. Maybe the other person is duplicating the data to do test stuff to it... mysql,query [I hope the spam thing lets this through] DSL -- We are not the United States' ally We are the 53rd sovereign state of the Federation - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Create a column the multiple of two other columns
[in order to avoid the spam filter] mysql mysql sql [end avoid] (this is a test, I've got the pips with the spam filter when I'm not a spammer -- especially when MOST of the messages from this list register above 3 on http://www.spamassassin.org/) GRUMBLE James Foley wrote: Hi, If this is trivial, please bare with me: How do I alter a table in Sql to add a column which is the multiple of two existing columns: A Table has columns a,b,c and I want to add column d which will be b*c Many Thanks Beginner - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- At the end of the day you're another day older And the shirt on your back doesn't keep out the chill! (At the End of the Day -- Les Miserables [the musical]) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
