Re: cobalt binary version
>>>>> "a" == archive writes: a> any binary version for cobalt qube2 (mips processor) ?? a> have mysql ever tested install at cobalt qube/raq ?? a> how is it done? There used to be a version on the cobalt ftp site in the contrib area. Don't know what's there now, since they seem to be ignoring the MIPS based equipment lately. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Help with FreeBSD 4.2 Native Threads (was: Compile broken:
Your filter really makes having a discussion difficult. I think I'll just go away. > "m" == mysql <[EMAIL PROTECTED]> writes: m> Your message cannot be posted because it appears to be either spam or m> simply off topic to our filter. To bypass the filter you must include m> one of the following words in your message: m> database,sql,query m> If you just reply to this message, and include the entire text of it in the m> reply, your reply will go through. However, you should m> first review the text of the message to make sure it has something to do m> with MySQL. You have written the following: > "DF" == David Favor <[EMAIL PROTECTED]> writes: >>> make install" and be done with it. The port is extremely nicely done. DF> The problem is I do not have root access, so have no permission to do this. m> You can tell the ports to install themselves wherever you like. Just m> copy the necessary "port" files, then make it in your own directory m> with the base install derectory changed. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help with FreeBSD 4.2 Native Threads (was: Compile broken: mysql-3.23.38/mit-pthreads)
> "DF" == David Favor <[EMAIL PROTECTED]> writes: DF> The problem is the Web hosting service I use does not have this DF> package installed. In other words, there is no libpthreads.* in DF> any of the library directories. But FreeBSD native threads do not need any libpthreads.* files. Your best bet on FreeBSD is to "cd /usr/ports/database/mysql323-server; make install" and be done with it. The port is extremely nicely done. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 force mysql to use certain indexes
>>>>> "PJM" == Patrick J Militzer <[EMAIL PROTECTED]> writes: PJM> I'm using mysql 3.22.27. How can I force mysql to use index's in PJM> my select statement? You don't. SQL is a 4GL and you only describe what you want, and it is up to the language interpreter and optimizer to do it efficiently. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 3.23.37 released
> "MW" == Michael Widenius <[EMAIL PROTECTED]> writes: MW> We are just now building the first MySQL-Max binaries with support for MW> Berkeley DB and InnoDB tables. The first one will be a Linux x86 RPM Does this imply that BDB tables are stable enough for production use, or is it still considered Beta as per http://www.mysql.com/doc/S/t/Stability.html ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Indexes on Nulls
>>>>> "DG" == Dennis Gearon <[EMAIL PROTECTED]> writes: DG> Is it true no indexing on Nulls In the Innobase database tables and DG> MyIASM DG> tables? Dunnow about Innobase tables, but MyISAM tables let you have indexes on nullable columns. ISAM did not. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql speed :)
>>>>> "PD" == Paul DuBois <[EMAIL PROTECTED]> writes: PD> But why does it matter? MySQL will convert the strings to numbers PD> anyway. But according to earlier threads here, it will mess up with BIGINTs Also it may screw up with LIMIT: $sth = $dbh->prepare("SELECT foo FROM bar LIMIT ?,?") or die; $sth->execute($start,$howmany); may fail depending on how you set $start and $howmany. I got this error the other day, where $start was the string "3" and DBI tried to quote it, making my query look like this: ... LIMIT '3',2 and resulting in a parse error. The fix was to call $sth->execute($start+0,$howmany+0) and then DBI did the right thing. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Running crash-me against remote M$ SQL Server
> "GC" == Gerald Clark <[EMAIL PROTECTED]> writes: GC> Perl/DBI, or any mysql client on Linux should connect to mysql on NT GC> with no problem. Why would you need ODBC? Except that perl/DBI requires an underlying C library for the DBMS in question. I understand that the sybase libs might be able to talk to MS SQL server, so that may be an option. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: email only two columns
>>>>> "PM" == Prasad Mhatre <[EMAIL PROTECTED]> writes: PM> Is it possible to mail only three columns from a database ? Third column PM> being email ID? PM> I need to send email to all with a valid email ID in a database. MySQL doesn't send email. Perhaps you need to write a program that queries the database and then sends the mail you want. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
stability documentation up to date?
Is the http://www.mysql.com/doc/S/t/Stability.html document up to date? In particular, I'm interested in the current stability level of BDB tables, since I'm in need of transactions for a particular project. Also, the MyISAM handler is still listed as gamma, not stable. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 3.23.36 is relased
> "MW" == Michael Widenius <[EMAIL PROTECTED]> writes: MW>* Added `SET TRANSACTION ISOLATION LEVEL ...' How about documenting this? http://www.mysql.com/doc/S/E/SET_TRANSACTION.html is quite uninformative as to what the different levels mean. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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_auth HELP!
>>>>> "LL" == Linsen Limsico <[EMAIL PROTECTED]> writes: LL> Does anyone know how to get the .htaccess file to check the LL> database if the password exists, then the .htpasswd if the LL> password doesn't exist in the database? If you use my version, then yes, you can. Just specify AuthMySQLAuthoritative Off in your config. However, getting Apache to determine which order to apply the password checks is beyond my experience. You can find my version at ftp://ftp.kciLink.com/pub/ Please be sure to download the instructions with it. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL vs PostreSQL ??
>>>>> "t" == topmailbox writes: t> How does PostreSQL compair to MySQL ? Did you read what it has to say about this in the manual? t> I'm sure each has it's own advantages & disadvantages. Yes. t> What are some of the major ones? Depends on what your needs are. One person's advantage is another's disadvantage. t> Which would be more capible in a large web base t> database where the database was very large and the hit t> rate very high? Again, it depends on what your specific needs are. Most likely, you'll need to evaluate them both yourself probably with some benchmarks and then decide which is "better". -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
DBD::mysql to support transactions?
Is there any work going on with DBD::mysql for Perl to support transactions at the DBI abstraction? If you attempt to use DBI autocommit=>0, DBD::mysql croaks. It would seem that with BDB and the other new table types that support transactions, it will become necessary... -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
multiple charsets per server?
I need to do some tests for a client involving japanese text. I've recompiled the server with extra charsets = complex to have multi-byte support. I see how I can select the default charset upon startup. How can I tell mysql that a particular set of tables (or the whole DB) should use the japanese charset while leaving the other tables and DBs alone (using default Latin1)? Is this possible withour running multiple instances of mysqld? -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqldump Error
>>>>> "JC" == Joel Caturia <[EMAIL PROTECTED]> writes: JC> I've searched around a bit, and haven't been able to find what an JC> errcode 13 is, so I'm out of ideas. mysql comes with a program called perror. Run "perror 13" and see what it has to say. Also, what are your mysql permissions (from the GRANT commands you've issued) for your currently logged in user? Also, is the mysql daemon process allowed to write to the directory you are asking it to write to? -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: HOWTO: Get column types & enum values using perl
>>>>> "MW" == Mark Worsdall <[EMAIL PROTECTED]> writes: MW> When I do this:- MW> my $types = $sth->{TYPE}; MW> # MW> if ($$types[0] = &Mysql::FIELD_TYPE_STRING) { MW> print "Type is a SRING"; MW> } Perhaps you mean if ($$types[0] == &Mysql::FIELD_TYPE_STRING) you are doing an assignment, not a comparison. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Setting a specific default value on a field
>>>>> "JSB" == Jamie S Buchanan <[EMAIL PROTECTED]> writes: JSB> More specifically, I have two DateTime fields (A and B), in my creation JSB> script I want to set the default value of B to the value of A so that JSB> when I write a new record to the table the position of B can be left what's wrong with INSERT INTO goo (A,B) VALUES (NOW(),A) -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Having a hard time installing MySQL
>>>>> "DN" == Dan Nelson <[EMAIL PROTECTED]> writes: DN> This looks like you used the binary package, right? That was built for DN> FreeBSD 4.2, which has a different set of c++ libraries from 4.0. DN> You'll have to either upgrade to 4.2, or build mysql from ports. I'd highly recommend upgrading to FreeBSD 4.2-STABLE so that you also get the very important C++ library/compiler fixes. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Long deletes
>>>>> "MV" == Michael Villalba <[EMAIL PROTECTED]> writes: MV> Thanks, Fred. The delete job has been running for 21 hours MV> at this point, and now rather simple queries on other tables hang MV> (e.g. SELECT COUNT(*) FROM other_table WHERE index=some_value). MV> I'll let it run overnight to see what happens, but I'm not hopeful. This is a major issue for us as well. We have some tables that need periodic cleaning of old data and it can take hours upon hours to do that. What our workaround is, and it is IMHO, sub-optimal, is to use the LIMIT feature of DELETE in MySQL, and issue the delete in a loop until no more items are deleted. Something like this, in Perl: my $sth = $dbh->prepare("DELETE LOW_PRIORITY FROM playlog $clause LIMIT ?"); $sleeptime = 0; do { print "Sleeping... $sleeptime seconds\n"; sleep($sleeptime); my $stime = time; print scalar localtime $stime," (start delete)\n"; $sth->execute($limit); $affectedRows = $sth->rows(); my $etime = time; print scalar localtime $etime,": "; my $diff = $etime-$stime; print "Deleted $affectedRows rows... $diff seconds\n"; $sth->finish(); # sleep half the time it took to delete, if longer than 30 seconds. $sleeptime = $diff > 30 ? int($diff/2) : 1; } until ($affectedRows < $limit); Assuming $clause = 'WHERE .' is your match for rows to delete, this will delete things in batch size of $limit (I use 200 rows), and sleep between the deletes to let other threads do their thing with not too much delay. Ideally, MySQL would allow the delete to be concurrent with other operations. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Multiple Column list index
>>>>> "M" == MikeBlezien <[EMAIL PROTECTED]> writes: M> I have a table that stores business locations, which contains M> 'city','state' and 'zip' and this table is utilize for search M> queries. Which type of indicing take full advantage of the MySQL M> optimizer, create a multiple column index (city,state,zip) or M> separate indices on each column. The use of indexes depends on your queries. What do your queries look like? There's no point building an index unless your queries can take advantage of it. M> - M> Before posting, please check: M>http://www.mysql.com/manual.php (the manual) M>http://lists.mysql.com/ (the list archive) M> To request this thread, e-mail <[EMAIL PROTECTED]> M> To unsubscribe, e-mail <[EMAIL PROTECTED]> M> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mod_auth_mysql
>>>>> "JDZ" == Jeremy D Zawodny <[EMAIL PROTECTED]> writes: >> Does anyone know if mod_auth_mysql is still under active >> development, and if so, where can I find current information on it? JDZ> Which one? JDZ> There appear to be two. Go here and search for "mysql" JDZ> http://modules.apache.org/ My version is still maintained, but since there have been no major problems with it in a looong time, there is really nothing to change in it. :-) Try my version, I'm sure you'll find it works just fine. The only note I have to add is that if you also use php4 with mysql built-in, then absolutely make sure that php is built to use the system mysql library and not its own copy. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Binary distribution on FreeBSD4.0
>>>>> "d" == drew <[EMAIL PROTECTED]> writes: d>Just wondering if anyone could help me out here? I have recently d> downloaded the binary distribution of mysql for FreeBSD (mysql- d> 3.23.32-unknown-freebsdelf4.2-i386.tar.gz). Now my problem is d> probably an easy fix but here goes. When I try and run Your best bet on FreeBSD is to build the MySQL port form /usr/ports. It is really well done. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Off topic, help please!
Wee Chua wrote: >I am sorry for asking this off topic question but I just need some opinions >or answers from you all. The question is "What are the limitations of >software testing?" You can't demonstrate something is correct; you can only demonstrate if it is incorrect. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Linking MySQL with other programs
>"-lm" has been specified in the linker option line. Before or after the -lmylsqlclient flag? It needs to be after. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: taxes
> "MK" == Mikel King <[EMAIL PROTECTED]> writes: MK> guys I think you are making this a way bigger problem than it MK> really is...e-merce crap is generally taxed based on the location MK> of the vendor; much the same way in which mail order businesses MK> are taxed. You really only have to worry about the state/locality What world (or country) do you live in? When was the last time you ordered something from Dell or Apple on line? What tax rate did you pay? You pay your local rate; not the rate of the location of the store. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: table too big to dump?
> "BR" == Brian Reichert <[EMAIL PROTECTED]> writes: BR> When I try to do a mysqldump on the localhost, I get an out-of-memory BR> error: BR> # mysqldump -uroot -proot customer audit_trail_271 BR> mysqldump: Out of memory (Needed 8164 bytes) BR> mysqldump: Got error: 2008: MySQL client run out of memory By default mysql client reads the whole result set into memory then writes the output. You can alter this behavior with the "-q" option to mysqldump, so it writes out as it reads from the server without buffering in memory. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 running mySQL via Telnet
> "TT" == The Tilghman <[EMAIL PROTECTED]> writes: TT> You're trying to use a Telnet client with a MySQL server. Instead, TT> use a MySQL client with a MySQL server and a Telnet client with a TT> Telnet server. Mixing protocols doesn't really work for anybody. well, you can use the telnet client to speak to any service, as long as you are capable of typing the poper protocol characters. Telnet clients are handy for debugging SMTP servers, for example. But in general, you want to use the mysql command line client to speak to mysql. That is, unless you're debugging the mysql protocol ;-) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Boolean Datatype
> "RD" == Russ Davies <[EMAIL PROTECTED]> writes: RD> Thanks for the suggestion, but this would still mean converting the data RD> type from within ASP (the 'True' type) down to a char ('T') would it not? then use ENUM('False','True') instead. Enum can have any string you want. I personally prefer to use the order False, True since then it also has the numeric values 0 and 1. >> CREATE TABLE logInfo2 >> ( >> logID INT NOT NULL UNIQUE, >> ipAddress VARCHAR(20) NOT NULL DEFAULT 'None', >> boolVarsENUM ('T', 'F') DEFAULT 'F' >> ) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Memory Requirements...
> "DK" == Daniel Kirk <[EMAIL PROTECTED]> writes: DK> 30gb eide hdd DK> Will the machine fall over because it doesn't have enough ram/CPU DK> power (for about 20k users per week as below)? any ball park DK> comments eg no worries, close call, not a chance? Your bottleneck on a database is almost never the CPU. It is almost always the disk. Get a faster disk. More RAM never hurts, either. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problems migrating from mysql 3.22.22 to 3.23.32
> "NR" == Noah Romer <[EMAIL PROTECTED]> writes: mysql> insert into bugs_activity (bug_id,who,when,field,oldvalue,newvalue) NR> values (334,18,20010131145149,'bug_status','NEW','RESOLVED'); NR> ERROR 1064: You have an error in your SQL syntax near NR> 'when,field,oldvalue,newvalue) values NR> (334,18,20010131145149,'bug_status','NEW','' at line 1 Check the list of reserved words that are new in 3.23. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mySQL IS winning
> "RH" == Rolf Hopkins <[EMAIL PROTECTED]> writes: RH> That also depends on your definition of *PRODUCTION* status. If you are RH> going to make a profit using MySQL then you need to purchase a license. Not any more; MySQL is GPL in the current version. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mySQL is winning
>>>>> "AS" == Alexander Skwar <[EMAIL PROTECTED]> writes: AS> Well, I still don't get it - why should I want to shell out a huge AS> amount of money? I mean, your post would fit a lot better, if AS> this was a Oracle mailinglist The point, I beleive, is that Oracle finds MySQL such a threat to their business that they have to put out a migration kit to make it easy for people to switch to their product. It shows that the popularity of MySQL is being taken seriously by the majors. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Running two "Makes"
> "EJD" == Evan James Dembskey <[EMAIL PROTECTED]> writes: EJD> is it possible to install Gnu make onto teh Dec in a way that it does not EJD> interfere at all with the rest of the system? If so, how do I do it? When you install gnu make, call it "gmake". Then run "gmake" when you need it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Backup?
>>>>> "SB" == Scott Baker <[EMAIL PROTECTED]> writes: SB> That's the way that I do. I setup my server to shutdown the MySQL process SB> at 3am, zip up my var directory, and then restart the process. Can you SB> copy the data with the server running? See mysqlhotcopy that comes with recent mysql versions. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: idle CPU
> "TS" == Tim Samshuijzen <[EMAIL PROTECTED]> writes: TS> We're running a large database on a dedicated server. TS> When I look in the list of active processes, I notice that a TS> complicated query takes up no more than about 30 % of CPU. TS> During this time the CPU is more than 60 % idle. TS> Is there some way to speed up the process? Make your disks infinitely fast. Then the CPU will be your bottleneck rather than your disks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 with the UPDATE
> "GLC" == Gerald L Clark <[EMAIL PROTECTED]> writes: GLC> You do not say what version you are running. GLC> Older versions did not allow updating the primary key field in that GLC> manner. he's not updating the primary key field. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Install trouble on FreeBSD4.2
>>>>> "JN" == Jeff Neuffer <[EMAIL PROTECTED]> writes: JN> I'm seeing this error when installing mysql-server-3.23.32 on FreeBSD4.2. Use /usr/ports on FreeBSD, and make sure you have the C++ compiler fixes from mid-january (ie, update FreeBSD to 4.2-STABLE). -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: What causes table corruption? (isamchk -r required)
> "jds" == j d stumbles <[EMAIL PROTECTED]> writes: jds> I'm running 3.22.32 on Solaris 5.6 on a sparc ultra-1, and have processes jds> updating the tables concerned continuously, via REPLACE INTO, INSERT INTO jds> or UPDATE statements. I've never had table corruption on a Solaris box, even with older MySQL versions. We don't use REPLACE INTO since I find it to be quite useless, really. Anyhow, here are some stats. These are using binary versions of MySQL from the www.mysql.com site. mysqladmin Ver 7.8 Distrib 3.22.14-gamma, for sun-solaris2.6 on sparc TCX Datakonsult AB, by Monty Server version 3.22.14-gamma Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 108 days 6 hours 38 min 40 sec Threads: 7 Questions: 12566861 Slow queries: 65925 Opens: 120 Flush tables: 1 Open tables: 116 [prod-rtm]% uname -a SunOS prod-rtm.xxx.xxx 5.6 Generic_105181-17 sun4u sparc SUNW,Ultra-250 and another box: mysqladmin Ver 7.8 Distrib 3.22.20a, for sun-solaris2.6 on sparc TCX Datakonsult AB, by Monty Server version 3.22.20a Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 217 days 7 hours 16 min 26 sec Threads: 1 Questions: 43556764 Slow queries: 10224 Opens: 967 Flush tables: 1 Open tables: 255 [prod-rtm2]% uname -a SunOS prod-rtm2.xxx.xxx 5.6 Generic_105181-20 sun4u sparc SUNW,Ultra-250 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: BSDI 4.2?
> "AH" == Alan Halls <[EMAIL PROTECTED]> writes: AH> Anyone have any luck building Mysql 3.32.23 on a BSDI 4.2 machine? I get an AH> error during the make command. Using extreme powers of mental telepathy, we might be able to guess your problem. However, if you told us exactly what the errors were, it would be much easier for those of us without such powers. My guess is you need to use "gmake" instead of "make". That always worked for me. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: What proportion of sites use MySQL.
>>>>> "AS" == Andy Stowell <[EMAIL PROTECTED]> writes: AS> One of my clients has asked me to find out a rough idea as to what AS> proportion of database enabled websites use the MySQL database. Exactly 67.2341231123123% Now really, how on earth do you expect to come up with such a statistic? How can you even tell when a site is database backed let alone what database it is using? You just can't do it. So therefore, sticking with the rule that 93.234% of all statistics are just made up, I made one up for you ;-) -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mySQL vs Oracle
> "AR" == Ann Ricchiazzi <[EMAIL PROTECTED]> writes: AR> I am trying to choose between mySQL and Oracle for a Linux server. My AR> specific questions are: AR> 1) Will mySQL handle 3000 hits/day well? You need to define what a "hit" is. Is it a simple select on the primary key of a single table or a multi-table join without indexes? How are your "hits" distributed over the duration of the day? Also, how big are you expecting your data tables to be? I'd venture to say that yes, MySQL can handle 3000 queries per day, but it is hard to say without knowing what your load expectations are. AR> 2) Does mySQL handle multi-media file formats? For example, if I want to AR> store audio clips, or Flash movie clips, or PowerPoint presentations, AR> can I do so? MySQL can store binary objects. You probably don't want to do that for these things but instead store a pointer to a URL or filesystem location. The file system access would be much faster than cramming the data down the database socket connection. AR> We make the decision this decision at 3:00 today. Your advice will be AR> most helpful. Luckily you're on the west coast. It is already 3:30 here. ;-) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: INSTALLATION QUESTION on Cobalt Raq3
> "l" == lkeeton <[EMAIL PROTECTED]> writes: l> First does anybody know the website address for that searchable l> site that allows you to search on mysql archive emails. I would l> appreciate if I could get that. I also am looking for opinions on Does anyone read the footers on the messages they get from the mailing list or are they just wasting electrons on my box? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: inserts with now() resulting in replication-problems
> "JK" == Jan Kirchhoff <[EMAIL PROTECTED]> writes: JK> If the Slave gets out of sync (loses the connection to the server), connects JK> again and tries to catch up, it processes those two queries *within one JK> second* which would result in an duplicate primary key on the slave. The JK> Slave would abort with an error and the replication would stop. But then the slave is still not in sync since the data is different. That doesn't seem to make sense for a replication scheme... Just seems wrong to me, but what do I know ;-) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: bug in 3.23.22-beta
> "MS" == Marc Swanson <[EMAIL PROTECTED]> writes: MS> As you can see the date field has been updated to the current date/time even MS> though the update query was only supposed to modify the text field. For MS> claarity the date field started out with 2001-01-07 08:00:00 and ended up MS> with 2001-01-19 08:23:32 (the time I tested this bug). It is not a date field. It is a timestamp field. Read the manual on what the difference is. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: [Make Crashes and Burns on myisam - "Don't know how to make mi_test_all"]
> "MW" == Matt Wagner <[EMAIL PROTECTED]> writes: >> As far as I know, just try building it on an i386 running BSDI 4.1 MW> Who was the guy that just contributed the BSDI 4.2 tarball? Maybe he MW> could give Aaron here some pointers. Try using gmake for bsd systems. The makefiles are proably not totally compatible with berkeley make. -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: <[EMAIL PROTECTED]> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php