random number between 0-100 for database
does anyone know how i might be able to create a random number between 0 and 100 using java? using the number in my database. thanks, Kit _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Urgent!!! core dump, why???
On Thu, Aug 23, 2001 at 06:55:42AM -0700, xiyuan qian wrote: > > Hi, I am running mysql-3.22.27 for many months. But today, the > mysqld always core dump. The running platform is FreeBSD3.4. > > I checked the dumped core and find that it seems that the core dump > has something with the /usr/lib/libc_r.so file when it called the > thread subroutine. That version of FreeBSD has threading issues. I've found that they go away completely if you upgrade to FreeBSD 4.3. And you'll probably want to use a newer MySQL just to stay current (3.23.41 works well). Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 6 days, processed 89,604,261 queries (148/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 action
Martijn Rotteveel schrieb am Freitag, 24. August 2001, 00:21:53: > i need a SIMPLE method for performing some pre defined actions on my tables, > these actions involve retrieving strings, recombining them and inserting > into another table. I don't know exactly what you mean, but if I do, I would write some functions which do the job. For example, this function retrieves the address of a client from the client ID: function getAddr($id){ ... } In these functions, you are not limited in any way except by your skills and fantasy. Herzlich Werner -- MySQL in Deutschland: Anpassung, Unterstützung, Schulung für Sie __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Dr. Werner Stürenburg <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Consultant /_/ /_/\_, /___/\___\_\___/ Bielefeld, Germany <___/ www.mysql.com +49-5224-997-407 Fax -409 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 compiling on FreeBSD 3.3 (mysql-3.23.41)
On Thu, Aug 23, 2001 at 01:50:36PM -0700, Angel Behar wrote: > Hi !! > > I'm trying to compile mysql-3.23.41 on a FreebSD 3.3 box but I can't > > I'm using latest gnu make version and this is the first time that I > have problems compiling mysql so if any of you can help me I'll > appreciate. > > Thanks in advance. Which compiler version are you using? Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 6 days, processed 89,579,267 queries (148/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: using index
On Thu, Aug 23, 2001 at 07:54:38PM +0200, Osus wrote: [snip] > when I run this query > mysql> explain select Nick from mytable where Inicial='P' AND Sexo=1 and > ok=1; > . > +--+--+---+-+--- > --+---+--++ > | table| type | possible_keys | key | > key_len | ref | rows | Extra | > +--+--+---+-+--- > --+---+--++ > | mytable | ref | ok,inicial,sexo | ok | 1 | const | 10 | where > used | > +--+--+---+-+--- > --+---+--++ > > only one index is used, why? > > ok is 1 or 0 > sexo is 1 or 0 > > but inicial is A, B, C, D, E, F, G.Z > So it would be better to use Inicial as index bacause should get > less records... Actually, you sort of answered yourself. Since inicial can have many possible values, odds are that you'll get *fewer* rows by using it to limit the query results. Imagine a table with 1 million records and the keys are equally distributed. Using either "ok" or "sexo" columns will only eliminate about 50% of the rows. The "inicial" column will eliminate many more. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 6 days, processed 89,557,252 queries (148/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: installing mysql - what should go where [linuxppc]
Sorry, one more thing occurred to me. Should I install these in any particularorder? George - Original Message - From: George Pitcher <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, August 24, 2001 7:37 AM Subject: installing mysql - what should go where [linuxppc] > Hi all, > > Having ditched yesterday's attempts to get MySQL up and running with PHP I'm > trying again from scratch. > > I'm currently downloading the 3.23.27-1 rpm's from ausmac.net. Theye are: > 'db engine', client, devel, shared, bench (should I also download and > install the xmbase-grok as well. > > In order to tell whether these have been installed properly, what sould I be > able to see afterwards? IE which folders should be where and what should be > in them? > > Sorry to be so basic. > > > Regards > > George Pitcher > > Technical Manager > HERON Project > Napier University > Edinburgh EH10 5DT > > [EMAIL PROTECTED] > [EMAIL PROTECTED] > [EMAIL PROTECTED] > > http://www.heron.ac.uk > >programmer - A device for transmuting caffeine into code. > > > > > _ > Do You Yahoo!? > Get your free @yahoo.com address at http://mail.yahoo.com > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
installing mysql - what should go where [linuxppc]
Hi all, Having ditched yesterday's attempts to get MySQL up and running with PHP I'm trying again from scratch. I'm currently downloading the 3.23.27-1 rpm's from ausmac.net. Theye are: 'db engine', client, devel, shared, bench (should I also download and install the xmbase-grok as well. In order to tell whether these have been installed properly, what sould I be able to see afterwards? IE which folders should be where and what should be in them? Sorry to be so basic. Regards George Pitcher Technical Manager HERON Project Napier University Edinburgh EH10 5DT [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] http://www.heron.ac.uk programmer - A device for transmuting caffeine into code. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ORDER BY queries optimizing with INDEX
On Thu, Aug 23, 2001 at 07:21:10PM +0200, Gregorio Ramón Alberdi Díaz wrote: > > A query with a ORDER BY clause over a numeric field, will be fast if > this field have a index or this doesn't influence the anwer time of > the query. MySQL is going to prefer an index on the column(s) used in the WHERE clause of your query. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 6 days, processed 89,548,458 queries (148/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
compiling error
i configured mysql with ./configure --prefix=/usr/local --localstatedir=/usr/local/var --with-mysqld-ldflags=-all-static --disable-shared --with-unix-socket-path=/usr/local/var/mysql.sock --with-pthread --enable-thread-safe-client --with-mysqld-user=mysql --without-debug --with-extra-charsets=complex --with-innodb i got this errow gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../../include -I../include-DDBUG_OFF -O3 -DDBUG_OFF-DDEBUG_OFF -DUNIV_INTEL_X86 -c sync0sync.c sync0sync.c: In function `sync_gnuc_intelx86_test_and_set': sync0sync.c:185: impossible register constraint in `asm' sync0sync.c:185: impossible register constraint in `asm' sync0sync.c:185: impossible register constraint in `asm' sync0sync.c:1259: Unrecognizable insn: (insn 11 31 16 (parallel[ (set (reg/v:SI 0 eax [43]) (asm_operands/v:SI ("movl $1, %%eax; xchgl (%%ecx), %%eax") ("=eax") 0[ (reg:SI 1 edx) ] [ (asm_input:SI ("ecx")) ] ("sync0sync.c") 185)) (set (mem:SI (reg/v/f:SI 0 eax [42]) 6) (asm_operands/v:SI ("movl $1, %%eax; xchgl (%%ecx), %%eax") ("=m") 1[ (reg:SI 1 edx) ] [ (asm_input:SI ("ecx")) ] ("sync0sync.c") 185)) (clobber (reg:QI 19 dirflag)) (clobber (reg:QI 18 fpsr)) (clobber (reg:QI 17 flags)) ] ) -1 (insn_list 4 (nil)) (nil)) sync0sync.c:1259: confused by earlier errors, bailing out make[4]: *** [sync0sync.o] Error 1 make[4]: Leaving directory `/usr/local/src/mysql-3.23.41/innobase/sync' So any suggestions to solve this problem ??? Thanx Michal Dvoracek - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: password()
On Thu, Aug 23, 2001 at 04:09:24AM -0500, Andres Berger wrote: > > Oracle gives to system managers a "feel of security" because if > something goes wrong, they can blame Oracle as their last resort, > but if they choose MySQL and the system fails for any reason, the > CEO will doubt about his expertise and could be fired. That is the > way the world works. > > MySQL needs more than glossy brochures, needs to work his brand to > build this "feel of security". Maybe a type of warranty could help. Can you post a copy of Oracle's warranty? From that we might be able to come up with something similar for MySQL. (I'm only half serious. I'd love to see Oracle's warranty...) Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 6 days, processed 89,311,258 queries (148/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: blobs
On Thu, Aug 23, 2001 at 05:07:35PM -0500, Gary Jollymore wrote: > > how would i get a file such as /files/photo.jpg into a mysql table > such as > > create table photo ( code decimal(6,0), photo blob); > > i tried insert into photo values('4142','/files/photo.jpg'); which > of course just put the file name into the 'photo' column. Check out LOAD DATA in the manual. -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 6 days, processed 89,280,627 queries (148/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication Config Bug (Re: master.info and my.cnf updates)
On Thu, Aug 23, 2001 at 01:15:25PM -0400, Robinson, Mike wrote: > > I just set up a master/slave replication scheme and all is well, but > through the procedure did get bit on the tail. > > After the setup, and after the master and slave mysql servers had > been started, I got some error messages that pointed to a type in > the slave's my.cnf file. I shut the slave down, fixed the typo, and > restarted. Got the same error. > > I had a look at the master.info, and noticed it contained old > information from the previous my.cnf. There were no binary log > entries in it, so I shut the slave down, deleted the master.info, > and restarted the slave. This fixed the problem and they're > replicating fine. (A terrific feature, my thanks to the mysql team > for that one.) > > Question is, is this behaviour by design? Seems to me if you edit > my.cnf and restart the mysql slave the master.info entries > corresponding to the my.cnf file should be updated. Thanks for any > insight. That's a common problem. Very common. You have to remove the master.info file, or edit it by hand. :-( I've called it a bug several times in the past, but it occurs to me that I may have never told the person who wrote the replication code. So... Sasha: Can this be fixed? In my mind it's a bug. One that has bitten too many people already. If not, we at least to get it documented here: http://www.mysql.com/doc/R/e/Replication_Features.html Thoughts? Thanks, Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 6 days, processed 88,944,778 queries (148/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: question about use JDBC to connect with MySQL in JSP,please help
Hi !!! )-Original Message- )From: aDragon [mailto:[EMAIL PROTECTED]] )Sent: Thursday, August 23, 2001 10:22 PM )To: [EMAIL PROTECTED] )Subject: question about use JDBC to connect with MySQL in JSP,please help ) ) )hello,everyone, )I am using JDBC in JSP to connect with MySQL under BEA )WEBLOgic Server 6.0, )I have copied the following codes from a book, but the server )always says that )It was wrong, expecial the variable "con", I don't know why even )thinking hard! ) please help,thanks. ) )the code following: )== ) ) )<% Properties P = System.getProperties(); )P.put("jdbc.drivers", "org.gjt.mm.mysql.Driver"); )System.setProperties(P); ) )Java.sql.connection con=DriverManager.getConnection("JDBC:MySQL://localhost:3306","root","root") ; I too don't know much about JSP. But as a first glance, the problem looks to be with the Coonection object declaration. It should be Connection not connection. Regards Venu -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Venu <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Woodside, California USA <___/ 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
question about use JDBC to connect with MySQL in JSP,please help
hello,everyone, I am using JDBC in JSP to connect with MySQL under BEA WEBLOgic Server 6.0, I have copied the following codes from a book, but the server always says that It was wrong, expecial the variable "con", I don't know why even thinking hard! please help,thanks. the code following: == <% Properties P = System.getProperties(); P.put("jdbc.drivers", "org.gjt.mm.mysql.Driver"); System.setProperties(P); Java.sql.connection con=DriverManager.getConnection("JDBC:MySQL://localhost:3306","root","root"); Java.sql.Statement Stmt = con.createStatement(); Stmt.executeUpdate("INSERT INTO table1 (col1, col2) VALUES (1054,Whatis)"); %> aDragon from China [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication advice needed...
On Thu, Aug 23, 2001 at 03:19:17PM -0700, Bryan Coon wrote: > Hi, > > We have a somewhat tricky problem that I need some help with. What > we have is one machine (the master) that we use for database > development, and two dedicated nodes (slaves) on a beowulf cluster > that house the non-dev databases. > > What we need is to mirror the master to the slaves, but not > necessarily moment to moment. Once a day or even once a week would > be fine. > > I originally set up replication which worked just fine for a short > time. But then I noticed that replication was crashing 3 or 4 times > a day. Yuck! That's clearly not good. Were the servers running the same version of MySQL? What sort of "crash" did you see? What error messages appeared in the error logs on the slaves? > I think it had to do with the heavy development on the master- this > machine is used to read in new tables from txt files, create loads > of temporary tables and in general get beat to hell. It seemed that > the slaves were choking on some particular line from the binary > logs, and could not get going again. Could be. > Speaking of which, how to start replication at the next 'good' line > number? I couldn't figure out how to find that line number. Here http://www.mysql.com/doc/R/e/Replication_SQL.html you'll see SET SQL_SLAVE_SKIP_COUNTER. You can use that command to skip a bad query. > Anyways, I scoured the docs, but could not find a list of what > happens for example if the master loads a new table from a text > file. Does this command 'read ... from infile...' go into the > binary logs? It does. You can use the mysqlbinlog program to view what's actually in the binary log, if you're curious. > What happens to the slave when it tries to read in a text file that > doesnt exist? It generates and error, and replication [probably] fails. > What kind of errors can the slave deal with, and which ones cause > replication to fail? Replication is fairly sensitive (and conservative). It stops on most errors, from what I've seen. > For a while, I just figured replication was a bad idea with a > development db as the master. It may be in your case. You aren't interesting in having the slaves run all those queries themselves--you're just interested in having them be in sync once in a while, right? > But then when I tried to find alternatives, I hit another brick > wall. A bit off topic, but how does one take a 'snapshot' of the > master db and migrate that out to the slaves? There are a couple ways. You can use rsync to transfer the data. You can use myrepl (a script I posted a while ago). I wrote it for taking replication snapshots. But it assumes that the "master" is actually running a binary log. You can use tar and scp. > Besides the obvious and (imho clumsy) tar, gzip and scp of about 4 > gigs of data, I thought of adding the entire db to cvs, but then > there are inherent problems with that ( try adding a 1.2 gig table > to a repository when you only have 256 megs of ram :P) CVS would be a bad idea. It's not too good at handling binary files. And you probably don't want to dump the data just to put it in CVS. > Is replication the right tool for this job? If it is, what is the > best model for our needs? If not, does anyone have any other > suggestions? Based on what I think you're saying, replication may not be best for you. Perhaps a periodic rsync (or something similar) would work better for you. Hope that helps... Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 6 days, processed 88,300,780 queries (149/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Encryption of Data
Elizabeth, sorry. misleading information. ssl support is still on the to-do list for mysql version 4.0, so not available yet as production.. It is documented anyhow and i bumped into it. try stunnel for the time being... sorry it's late. regards, rene On Thu, 23 Aug 2001 08:44:36 +0100 "Elizabeth Alderton" <[EMAIL PROTECTED]> wrote: > Dear Jeremy, Gregor > > Thanks and sorry for not being more specific. > > First of all we use an ISP who runs a Unix server. They won't give us ssh > without a dedicate server - too expensive for us. > Then we use Windows clients (95, 98) not on a network. > > We transfer the data down a phone line from the server -> client and from > client - > server. > > Thanks for suggesting cron - can you tell me what it is? > > Regards > > Elizabeth > -Original Message- > From: Jeremy Falcon <[EMAIL PROTECTED]> > To: Elizabeth Alderton <[EMAIL PROTECTED]>; [EMAIL PROTECTED] > <[EMAIL PROTECTED]> > Date: 22 August 2001 20:26 > Subject: Re: Encryption of Data > > > >What do you mean by "bring data down?" Would this be over a network? If > >so, what OS would the other machine be running? I'll assume it's Unix > >because that's my favorite. Seeing that mysql prints to STDOUT you could > >write a script to interface with MySQL, get the output, encrypt it, and > then > >send it across the line. > > > >Your application could send encrypted data to the server. For security > >reasons I wouldn't suggest trying to pull off some Telnet/SSH schema to run > >a script from your program. I'd use something like cron to run the script > >at intervals to import what you uploaded. The script could then decrypt > the > >data and run mysql to send it whatever. > > > >If you are looking for a more specific solution, then be more detailed in > >your question. > > > >Cheers, > > > >Jeremy > > > >- Original Message - > >From: "Elizabeth Alderton" <[EMAIL PROTECTED]> > >To: <[EMAIL PROTECTED]> > >Sent: Wednesday, August 22, 2001 10:00 AM > >Subject: Encryption of Data > > > > > >If I do a SELECT query to bring data down to a PC (this is being done > >through Delphi) how can I encrypt the data so that it comes safely? > > > >Equally when doing UPDATE and INSERT in the other direction I would want to > >encrypt the data. > > > >Can anyone help please? > > > >Regards > > > >Elizabeth > > > > > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: Encryption of Data
Elizabeth, sorry, 1 mistake: binary seems not to support mysql by default. so at least i'm not sure, maybe somebody else can clear this out. However using mysql's built-in ssl support seems like the best and easiest solution to me, prefered above tunneling. regards, rene On Thu, 23 Aug 2001 08:44:36 +0100 "Elizabeth Alderton" <[EMAIL PROTECTED]> wrote: > Dear Jeremy, Gregor > > Thanks and sorry for not being more specific. > > First of all we use an ISP who runs a Unix server. They won't give us ssh > without a dedicate server - too expensive for us. > Then we use Windows clients (95, 98) not on a network. > > We transfer the data down a phone line from the server -> client and from > client - > server. > > Thanks for suggesting cron - can you tell me what it is? > > Regards > > Elizabeth > -Original Message- > From: Jeremy Falcon <[EMAIL PROTECTED]> > To: Elizabeth Alderton <[EMAIL PROTECTED]>; [EMAIL PROTECTED] > <[EMAIL PROTECTED]> > Date: 22 August 2001 20:26 > Subject: Re: Encryption of Data > > > >What do you mean by "bring data down?" Would this be over a network? If > >so, what OS would the other machine be running? I'll assume it's Unix > >because that's my favorite. Seeing that mysql prints to STDOUT you could > >write a script to interface with MySQL, get the output, encrypt it, and > then > >send it across the line. > > > >Your application could send encrypted data to the server. For security > >reasons I wouldn't suggest trying to pull off some Telnet/SSH schema to run > >a script from your program. I'd use something like cron to run the script > >at intervals to import what you uploaded. The script could then decrypt > the > >data and run mysql to send it whatever. > > > >If you are looking for a more specific solution, then be more detailed in > >your question. > > > >Cheers, > > > >Jeremy > > > >- Original Message - > >From: "Elizabeth Alderton" <[EMAIL PROTECTED]> > >To: <[EMAIL PROTECTED]> > >Sent: Wednesday, August 22, 2001 10:00 AM > >Subject: Encryption of Data > > > > > >If I do a SELECT query to bring data down to a PC (this is being done > >through Delphi) how can I encrypt the data so that it comes safely? > > > >Equally when doing UPDATE and INSERT in the other direction I would want to > >encrypt the data. > > > >Can anyone help please? > > > >Regards > > > >Elizabeth > > > > > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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-server.sh gone in freebsd
On Thu, Aug 23, 2001 at 06:30:37PM -0700, Armando Cerna wrote: > HI installed the mysql-server port in freebsd and the > /usr/local/etc/rc.d/mysql-server.sh file just disapeared its done this before > and I fixed it by reinstalling I think but I would like to avoid this. Does > anyone know anything about this? Why can't you just make a copy? You generally save all config files you can before doing anything in Unix. Make a backup of your entire /etc dir now: { as root } cd /etc tar czf /some_big_dir/backup/$today_etc.tgz . -- Any technology distinguishable from magic is insufficiently advanced. TopQuark Software & Serv. Contract programmer, server bum. [EMAIL PROTECTED]Give up Spammers; I use procmail. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: use LOAD DATA INFILE to update
On Fri, Aug 24, 2001 at 09:05:35AM +0800, Osman Omar wrote: > Hi, Hi yourself. Sorry for my last reply. I regret the insult. > Example, I have data inside my table > > id model data_in > 1 str-de453 20010910 > > Now I have new update data inside text file > > eg model date_in >str-de453 20010911 > > How can I use LOAD DATA INFILE REPLACE to update new data into my table > ***I read manual but cannot file any example*** > thanks The definition is (stolen from MySQL by Paul DuBois, pg. 565): load data [low_priority] [local] infile 'file.name' [ignore | replace ] into table tbl_nam _import options_ [ ignore n lines ] [ (column_list) ] ... depending on your version of mysql. I've seen suggestions on how to use this in the manual. It's how I got going. Well, not with replace, but with load data. >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) -- Any technology distinguishable from magic is insufficiently advanced. TopQuark Software & Serv. Contract programmer, server bum. [EMAIL PROTECTED]Give up Spammers; I use procmail. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Encryption of Data
Elizabeth, Last conversation i recommended tools like ssh (you could also succesfully use stunnel (http://www.stunnel.org), i tried and it works well).. but.. there is an easier way. Guess that it depends on the mysql version your ISP is running, elsewise ask them to upgrade.. Also make sure you have a recent libmysql dll/so. Then use the function mysql_real_connect (see manual: http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#mysql_real_connect ) : mysql_init(MyDB); //you must call mysql_init first mysql_real_connect(MyDB,PChar(your_isp), PChar(User), PChar(Passw), PChar(Database), 3306, nil, CLIENT_SSL); This would, if available, use a SSL layer to connect to the MySQL server. I'm not too sure since which version SSL is available, the changelog mentions you can check for 'have_ssl' with "show variables" in version 3.23.30 so at least from this version and up, but maybe functionality is there much longer. Also afaik the binary rpm is compiled with ssl. Also i'm not too sure what happens if ssl is not available (cannot test that now!), maybe it just refuses to connect (desired behavior) or maybe it just connects w/o ssl, i cannot tell. hope this helps. regards, rene On Thu, 23 Aug 2001 08:44:36 +0100 "Elizabeth Alderton" <[EMAIL PROTECTED]> wrote: > Dear Jeremy, Gregor > > Thanks and sorry for not being more specific. > > First of all we use an ISP who runs a Unix server. They won't give us ssh > without a dedicate server - too expensive for us. > Then we use Windows clients (95, 98) not on a network. > > We transfer the data down a phone line from the server -> client and from > client - > server. > > Thanks for suggesting cron - can you tell me what it is? > > Regards > > Elizabeth > -Original Message- > From: Jeremy Falcon <[EMAIL PROTECTED]> > To: Elizabeth Alderton <[EMAIL PROTECTED]>; [EMAIL PROTECTED] > <[EMAIL PROTECTED]> > Date: 22 August 2001 20:26 > Subject: Re: Encryption of Data > > > >What do you mean by "bring data down?" Would this be over a network? If > >so, what OS would the other machine be running? I'll assume it's Unix > >because that's my favorite. Seeing that mysql prints to STDOUT you could > >write a script to interface with MySQL, get the output, encrypt it, and > then > >send it across the line. > > > >Your application could send encrypted data to the server. For security > >reasons I wouldn't suggest trying to pull off some Telnet/SSH schema to run > >a script from your program. I'd use something like cron to run the script > >at intervals to import what you uploaded. The script could then decrypt > the > >data and run mysql to send it whatever. > > > >If you are looking for a more specific solution, then be more detailed in > >your question. > > > >Cheers, > > > >Jeremy > > > >- Original Message - > >From: "Elizabeth Alderton" <[EMAIL PROTECTED]> > >To: <[EMAIL PROTECTED]> > >Sent: Wednesday, August 22, 2001 10:00 AM > >Subject: Encryption of Data > > > > > >If I do a SELECT query to bring data down to a PC (this is being done > >through Delphi) how can I encrypt the data so that it comes safely? > > > >Equally when doing UPDATE and INSERT in the other direction I would want to > >encrypt the data. > > > >Can anyone help please? > > > >Regards > > > >Elizabeth > > > > > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: Create Table Syntax for DEFAULT
At 5:18 PM -0700 8/23/01, Igbar Foosenhopper wrote: >Is it possible to use current_date (mysql function) to generate a >default for a column? No. Defaults must be constants. http://www.mysql.com/doc/C/R/CREATE_TABLE.html > >If so .. what would the syntax look like. I have tried several things >and it doesn't seem to like it. > >If not .. how could I generate a default of todays date (of course >dependent on the date of insert)? Use a TIMESTAMP, which gets the current date and time automatically if you set it to NULL or leave it out of the INSERT statement altogether. Alternative, use a DATETIME and set it to NOW() when you insert a record. > >Thanks > > > > >-- >Best regards, > Igbar mailto:[EMAIL PROTECTED] -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql-server.sh gone in freebsd
HI installed the mysql-server port in freebsd and the /usr/local/etc/rc.d/mysql-server.sh file just disapeared its done this before and I fixed it by reinstalling I think but I would like to avoid this. Does anyone know anything about this? Armando - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
data model, tips for online dictionary
Hello all, I'm planning to create an web-based glossary (actually Spanish<>English glossary of retail banking terminology, so my buddies and I can collaboratively prepare to interpret at a conference in a few months). I'll be using either Perl/DBI or PHP, the only languages I speak. Is there anyone out there who has done an online dictionary or glossary and can share some tips about the data model and techniques? I know this wheel has been invented before (yes I checked the archives; someone mentioned he's done one but that's all he says). At the very crudest, I can envision a table such as this CREATE TABLE english_terms ( id smallint(5) unsigned NOT NULL auto_increment, term varchar(255) DEFAULT '' NOT NULL, translation text DEFAULT '' NOT NULL, PRIMARY KEY (id) ); If you wanted to look up a term, your application might say SELECT translation FROM english_terms WHERE term = 'usurious' and so on. I can envision offering the user the option of searching for a term that "is", "begins with", or "contains" what they type into a textfield. But again, I wonder if anyone has any advice. TIA! David Mintz Spanish Interpreter US District Court, Southern District of New York Web Design & Hosting http://www.dmintzweb.com/ Personal http://www.panix.com/~dmintz/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
use LOAD DATA INFILE to update
Hi, Example, I have data inside my table id model data_in 1 str-de453 20010910 Now I have new update data inside text file eg model date_in str-de453 20010911 How can I use LOAD DATA INFILE REPLACE to update new data into my table ***I read manual but cannot file any example*** thanks - Text from MySQL Manual. (LOAD DATA INFILE) The REPLACE and IGNORE keywords control handling of input records that duplicate existing records on unique key values. If you specify REPLACE, new rows replace existing rows that have the same unique key value. If you specify IGNORE, input rows that duplicate an existing row on a unique key value are skipped. If you don't specify either option, an error occurs when a duplicate key value is found, and the rest of the text file is ignored - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Building on Win32
At 19:51 23/08/2001 -0400, [EMAIL PROTECTED] wrote: >Thanks for the info. > >You refer to file mysql.dsw for the 3.23.41 distribution. Yes. Just now I am working in the 4.0 tree. When I finished it I will send an e-mail for our lists, how to do. Regards, Miguel >I was specifically interested in building the 4.0 distribution downloaded >using BitKeeper. There is no mysql.dsw file in that source tree. The only >workspace file is mysql-4.0/bdb/build_win32/Berkely_DB.dsw. Is that the >file to use and are the build instructions the same? Thanks. > > >- >Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"; before >posting. To request this thread, e-mail [EMAIL PROTECTED] > >To unsubscribe, send a message to the address shown in the >List-Unsubscribe header of this message. If you cannot see it, >e-mail [EMAIL PROTECTED] instead. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil <___/ 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: Distributed Query
On Thu, Aug 23, 2001 at 04:15:47PM -0700, Edgart Gonzalez wrote: > Hi guys, > Could you please tell us if can I make a distributed query inside ob mysql> > Something like : > > SELECT A.c1, b.c2 from serverA.TableA A, serverB.TableB B Wow, that would slow a db down. Not only are you waiting for disk and RAM, throw in network latencies as well! >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) I'd say check the above. MySQL is very up front about what it doesn't do, will do, or never will do. database, ... -- Any technology distinguishable from magic is insufficiently advanced. TopQuark Software & Serv. Contract programmer, server bum. [EMAIL PROTECTED]Give up Spammers; I use procmail. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Create Table Syntax for DEFAULT
Is it possible to use current_date (mysql function) to generate a default for a column? If so .. what would the syntax look like. I have tried several things and it doesn't seem to like it. If not .. how could I generate a default of todays date (of course dependent on the date of insert)? Thanks -- Best regards, Igbar 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
Hi.. i have a question
I am currenly using Valueweb.net and they do not support ODBC connection. So i have to use MySql to connect my .MDB to the web. but i need a guide how to do it.. i am using MS access 97 right now I will pay for the support if you can get this to work for me please contact me ASAP thanks, Paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Distributed Query
Hi guys, Could you please tell us if can I make a distributed query inside ob mysql> Something like : SELECT A.c1, b.c2 from serverA.TableA A, serverB.TableB B Or if this functionality is schedule for a future (which) release. Thank you much in advance. Edgart - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Does anyone know why fetchrow_hashref failed?
At 1:09 PM -0700 8/23/01, Truoc Duong wrote: >Hi, > >I am using mod_perl and MySQL 3.23.38 on Red Hat Linux >6.2 and my following codes occasionally got an error. > >$SQL = 'SELECT col1,col2 FROM table1'. > ' WHERE keya=1 AND keyb=2'; >$STH = $DBH->prepare($SQL) || die $SQL; >if ($STH->execute() >= 1) { >$rec = $STH->fetchrow_hashref; >$STH->finish(); >} > >The error was: > >DBD::mysql::st fetchrow_hashref failed: fetch() >without execute() at program-name line . Looks to me like it would be impossible for fetchrow_hashref() to be executed without execute() having first been called, because the test in the if() requires execute() to be called before the test can be evaluated. Do you have another fetchrow_hashref() call somewhere? However, execute() returns undef or true for a SELECT statement, not a row count. You seem to be using it as though it returns a row count. > >It only happened once in a few dozen transactions. If > anyone knows the cause of this and knows the solution >for it, please let me know. > >Thank you very much in advance. > >Truoc Duong. > >__ >Do You Yahoo!? >Make international calls for as low as $.04/minute with Yahoo! Messenger >http://phonecard.yahoo.com/ > >- >Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql select * to hash?
At 4:06 PM -0600 8/23/01, Tom Burkhardt wrote: >Greetings List, > >Using mysql, after doing a query using the "select *" statement, how do >is place this into a hash? Or a >text file for that matter? There must be a rather simple answer around. There may be, but your message doesn't contain enough detail to give you much of an answer. Are you issuing the query from within the context of some programming language? If so, which one? > >Your input is most apprecitated. > >Tom -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error using Msql-Mysql-modules-1.2216 with MySQL
From: chad To: [EMAIL PROTECTED] Subject: Error using Msql-Mysql-modules-1.2216 with MySQL >Description: I am trying to install Msql-Mysql-modules-1.2216 for Perl. The 'make' runs just fine, but when I run the test suite 'make test', it gives the following error (extremely verbose, I know): t/00baseinstall_driver(mysql) failed: Can't load '.././blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: .././blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: __mempcpy at /usr/lib/perl5/i386-linux/5.00404/DynaLoader.pm line 168. at (eval 1) line 2 Perhaps a required shared library or dll isn't installed where expected at t/00base.t line 38 dubious Test returned status 2 (wstat 512, 0x200) Undefined subroutine &Test::Harness::WCOREDUMP called at /usr/lib/perl5/Test/Harness.pm line 252. make[1]: *** [test_dynamic] Error 2 make[1]: Leaving directory `/root/Msql-Mysql-modules-1.2216/mysql' make: *** [test] Error 2 It seems to be a problem with the mysql libraries, so I'm posting to the mysql list... I've tried a hundred different things, and I always get the same sort of error. It also happened when I was trying to install the DBD-mysql module. MySQL was installed by another person here, but the installation looks pretty standard, and I'm sure he did a good job of it. I would like to avoid wiping the MySQL installation because it is already in use by a suite of PHP scripts, and they are working. Also, Perl is in use quite a bit by the web site. I am successfully using the DBD-mysql module to connect to this same database while developing on a Windows NT ActivePerl setup. So, after spending two whole days on this problem, I felt it was time to seek professional help. :-) Any help would be appreciated. Thanks, Chad. >How-To-Repeat: installing 'Msql-Mysql-modules-1.2216', in the 'make test' stage. >Fix: None yet... tried various 'workarounds', none have worked. >Submitter-Id: >Originator: >Organization: >MySQL support: none >Synopsis: >Severity: <[ non-critical | serious | critical ] (one line)> >Priority: <[ low | medium | high ] (one line)> >Category: mysql >Class: <[ sw-bug | doc-bug | change-request | support ] (one line)> >Release: mysql-3.23.39 (Official MySQL binary) >Environment: System: Linux linus2.tnrdlib.bc.ca 2.0.36 #1 Tue Oct 13 22:17:11 EDT 1998 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/local/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/local/lib/gcc-lib/i686-pc-linux-gnu/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='-O3 -mpentium ' CXX='gcc' CXXFLAGS='-O3 -mpentium -felide-constructors' LDFLAGS='-static' LIBC: lrwxrwxrwx 1 root root 13 Feb 18 1999 /lib/libc.so.6 -> libc-2.0.7.so -rwxr-xr-x 1 root root 3070220 Oct 13 1998 /lib/libc-2.0.7.so -rw-r--r-- 1 root root 7603158 Oct 13 1998 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Oct 13 1998 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared Perl: This is perl, version 5.004_04 built for i386-linux _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
database action
Hi all, i need a SIMPLE method for performing some pre defined actions on my tables, these actions involve retrieving strings, recombining them and inserting into another table. i thought about MySql++, but is there a simpler way to accomplish this kind of tasks ? regards, Martijn. Netherlands. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: AW: Setup own DB for each user?
Sorry... correction again... I don't use this particular command so I actually had to test it. :) It's "safe-show-database" .. notice the - instead of _ . [EMAIL PROTECTED] wrote: It's "safe_show_database", not "safe_show_databases" "Ulv Michel" <[EMAIL PROTECTED]> wrote: > > > Or you can add > > safe_show_database > > to your my.cnf, or call safe_mysqld with the added option " > --safe_show_database" do you have to compile mysql with some special parameter? My version (3.23.37, SuSE rpm) fails with a "unrecognized command" error when I try to start it after having inserted "safe_show_databases" or "skip_show_databases" into my.cnf - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Changes between 3.22 and 3.23
Well, looks like I found the culprit. Increasing thread_cache_size from 0 to 50 totally alleviated the stress (both on the database and our clients). Recommended by the manual, of course. For list-archival's sake: FreeBSD 4.3-STABLE /etc/my.cnf: [mysqld] user=mysql set-variable = wait_timeout=3600 set-variable = tmp_table_size=800 set-variable = max_connections=500 set-variable = table_cache=256 set-variable = sort_buffer=4M set-variable = key_buffer=64M set-variable = thread_cache_size=50 top: CPU states: 66.3% user, 0.0% nice, 30.2% system, 3.1% interrupt, 0.4% idle Mem: 33M Active, 92M Inact, 29M Wired, 8368K Cache, 35M Buf, 87M Free Swap: 1024M Total, 88K Used, 1024M Free mytop (a great utiltiy, may I add) is reassuring: Queries Total: 129,866Avg/Sec: 450.92 Slow: 0 Threads Total: 3 Active: 1 Cached: 48 Key Efficiency: 99.73% Bytes in: 16,118,135 Bytes out: 26,368,181 Unfortunately, the application does make a new connection for every hit, which is why thread_cache_size probably made a difference. Out of curiousity, what was different about 3.22? Anyway, Thanks to all who responded. > We upgraded our convergent e-business enterprise database server from mysql > 3.22 to 3.23 yesterday. The upgrade process itself was smooth and > sexy. > > Unfortunately, the dbms is overall slower for us. What's worse, > some maintenance scripts are losing their connections in the > middle of their runs. > > I have indeed read the appropriate section in the manual for upgrading > from 3.22 to 3.23. > > I have a number of hunches as to where I could start, but I was just > wondering if there is anything I should be aware of that may save > me some time ("You idiot, mysql 3.23 introduced a turbo switch. It's > just off by default"). > -- Michael Bacarella <[EMAIL PROTECTED]> Technical Staff / System Development, New York Connect.Net, Ltd. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication advice needed...
Hi, We have a somewhat tricky problem that I need some help with. What we have is one machine (the master) that we use for database development, and two dedicated nodes (slaves) on a beowulf cluster that house the non-dev databases. What we need is to mirror the master to the slaves, but not necessarily moment to moment. Once a day or even once a week would be fine. I originally set up replication which worked just fine for a short time. But then I noticed that replication was crashing 3 or 4 times a day. Yuck! I think it had to do with the heavy development on the master- this machine is used to read in new tables from txt files, create loads of temporary tables and in general get beat to hell. It seemed that the slaves were choking on some particular line from the binary logs, and could not get going again. Speaking of which, how to start replication at the next 'good' line number? I couldn't figure out how to find that line number. Anyways, I scoured the docs, but could not find a list of what happens for example if the master loads a new table from a text file. Does this command 'read ... from infile...' go into the binary logs? What happens to the slave when it tries to read in a text file that doesnt exist? What kind of errors can the slave deal with, and which ones cause replication to fail? For a while, I just figured replication was a bad idea with a development db as the master. But then when I tried to find alternatives, I hit another brick wall. A bit off topic, but how does one take a 'snapshot' of the master db and migrate that out to the slaves? Besides the obvious and (imho clumsy) tar, gzip and scp of about 4 gigs of data, I thought of adding the entire db to cvs, but then there are inherent problems with that ( try adding a 1.2 gig table to a repository when you only have 256 megs of ram :P) Is replication the right tool for this job? If it is, what is the best model for our needs? If not, does anyone have any other suggestions? Thanks, Bryan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
blobs
how would i get a file such as /files/photo.jpg into a mysql table such as create table photo ( code decimal(6,0), photo blob); i tried insert into photo values('4142','/files/photo.jpg'); which of course just put the file name into the 'photo' column. gary [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
mysql select * to hash?
Greetings List, Using mysql, after doing a query using the "select *" statement, how do is place this into a hash? Or a text file for that matter? There must be a rather simple answer around. Your input is most apprecitated. Tom - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: store and display image with java
Bin Cai schrieb am Donnerstag, 23. August 2001, 23:24:01: > could you tell me how to store image in mysql database and display on web > using java. urgently Do it like any other insert, but care for special characters. In php, you would wrap data with addSlashes() and remove them on retrieval with stripSlashes(). But... you better not insert images into a table. Yes, you can do it, but it is generally considered a bad idea. Read about it at http://www.bitbybit.dk/mysqlfaq/ - if the images have to be provided by users, use the upload functions of your system. php for example has upload support built in. Next you have to care for the appropriate write rights for those files. These can be handled safely without compromising system security. Store all data associated with the pictures in a table except the picture itself, which should be taken care of by the file sytem. rasmus on files in databases: When dealing with images, it is of course possible to insert the image data into the database as binary blobs. However, the value in doing that is questionable. Until databases provide you with cool pattern recognition tools that will let you search a blob for a picture of a rose, having the image data itself in the database isn't of much use. Every operating system comes with a finely tuned blob database. It is called your file system. So, just put the full-path filename into the database and leave the images sitting somewhere on your disk. You will save yourself much aggrevation in the long run. http://conf.php.net/pres/index.php?p=slides%2Fintro&id=or2001 Herzlich Werner -- MySQL in Deutschland: Anpassung, Unterstützung, Schulung für Sie __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Dr. Werner Stürenburg <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Consultant /_/ /_/\_, /___/\___\_\___/ Bielefeld, Germany <___/ www.mysql.com +49-5224-997-407 Fax -409 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
store and display image with java
Hi, could you tell me how to store image in mysql database and display on web using java. urgently Thank you very much bin cai - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Changes between 3.22 and 3.23
We upgraded our convergent e-business enterprise database server from mysql 3.22 to 3.23 yesterday. The upgrade process itself was smooth and sexy. Unfortunately, the dbms is overall slower for us. What's worse, some maintenance scripts are losing their connections in the middle of their runs. I have indeed read the appropriate section in the manual for upgrading from 3.22 to 3.23. I have a number of hunches as to where I could start, but I was just wondering if there is anything I should be aware of that may save me some time ("You idiot, mysql 3.23 introduced a turbo switch. It's just off by default"). Thanks. -- Michael Bacarella <[EMAIL PROTECTED]> Technical Staff / System Development, New York Connect.Net, Ltd. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
"alter table mytable order by my_column" is too slowly, why? Please help me.
I execute this SQL with mysql 3.23.39 (all platform, Windows98, Windows2000 and Redhat Linux 7.1), but it's very very slowly. alter table mytable order by my_column; mytable has 3,000,000 rows, my_column is define as char(15). But when mytable has 1,000,000 rows, it's very fast, about 1.5 minute. === http://sms.163.comÍøÒ׶ÌÐÅ ·¢×ÔÄÚÐÄ http://love.163.com Ç£ÒÁÖ®ÊÖ¹²ÏíÈËÉú»¶Ó飡NEW£¡ http://alumni.163.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 import problem
Hello List! I am having an extremely unusual problem with MySQL3.22.27 running on a Sun UltraII Solaris 7 (latest patches applied). This implementation of MySQL 3.22.27 has been rock solid for better than 2 years now. We have a primary/failover system here, and the primary 'syncs' itself to the secondary via mysqldump every X hours. What has been happening is, on the failover box, when importing the dump from mysqldump the db hangs. Connections are allowed, but access to the db in question freezes. I have done quite a bit of debugging, and have determined that the freeze occurs as the 'user' table is getting loaded. I recompiled mysql with debug on, and the log file for the import dies right after trying to load that table. Additionally, after a freeze, I can restart mysql, and look at all of the db, except that user is an empty set (should be about 81000 records). I have the _exact_same_ dump occuring to a different box running the same version of MySQL just fine, religiously. I have fsck'ed the drives that the mysql instance lived on (no problems). I trussed the mysql process below with no relevant output (will post to the list if requested). I have recompiled and reinstalled mysql with the same results (having first deleted in entirety the old install) Information: Command to import: bin/mysql -uroot -pblah dbname < /path/to/mysqldump User table info: bin/isamchk -d var/layoutwizard/user.ISM ISAM file: var/layoutwizard/user.ISM Data records: 81491 Deleted blocks: 0 Recordlength: 301 Record format: Packed table description: Key Start Len Index Type 1 1 4 unique long 2 9 8 multip. binary 3 5 4 multip. long 4 45255 multip. text Any help anyone can offer will be greatly appreciated. This is fairly critical, as I have no failover box, and am out of ideas for what is causing this. TIA -- Matthew Boeckman(816) 777-2160 Manager - Systems Integration Saepio Technologies Time is nature's way of making sure that everything doesn't happen at once. Space is nature's way of making sure that everything doesn't happen to 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
How i should make a databases replication ?
Hello thanks before all, i've have a mysql 3.22.15 gamma , and 3.22.16 gamma in two Solaris on Sparc ( SunOS 5.7, 5.8 ). This mysql are in a site in "production", and i'd like to join the data bases in another data base in another machine ( solaris on Sparc ). I've installed in this third machine a mysql version 3.23.40 and i've readen about replication in mysql web. I've readen that if i want to replicate i must have minium version 3.23.33 in all machine's, and activate a log binary in all mysql's. I belive that i should "upgrade" the oldest database first, and then activate the binary-log in this , later , activate binary-log in the third data base ( 3.23.40 ), and then if i copy all databases that exists in the first two machine's ( mysqldump or copyng all data directoris ) , without stop it , and put it into the new mysql's machine , i can do it. I understand that log-binary only log update or delete's , and if i do it i'll be able to do it. The asks are , How i should upgrade of two new database's ?, install a new mysql version in another path ( for example if it was installed on "/usr/local/mysql", the new on "/usr/etc/mysql" ?, Can i install it on the same path and all the database existents will remain intact ? of course i'll do a backup before do something Can anybody help me ? thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Building on Win32
At 08:02 23/08/2001 -0400, [EMAIL PROTECTED] wrote: Hi! >Are instructions available for building the MySQL source tree on a Win32 >platform for a Win32 target? Not yet. However here the basic steps. Minimal Requirements: - VC++ 6.0 compiler - MySQL source distribution: http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.41-win-src.zip Optional Requirements (recommended) - The MS macro compiler 5.0 (masm.exe) or 6.x (ml.exe). If you don't have either the Masm 5.x or Masm 6.x you can obtain the last one from Microsoft according with the instructions in the URL below: http://msdn.microsoft.com/vstudio/sp/vs6sp5/faq.asp Notice that you need to download the Service Package 4 or 5 and the Macro Assembler Package. Also after the update verify, if you need to set again the environment paths for Visual Studio. - Set the macro assembler in the environment path. Building the MySQL Stuff - Create a work directory (e.g.: workdir). - Unpacked the source distribution in the above directory. - Run the VC++ 6.0 compiler. - Using the Menu File. Click on Open Workspace. - Open the mysql.dsw Workspace that you find on the work directory. - Preparing the strings.lib compilation - If you don't have any macro assembler or you don't want to use it, close the workspace, using the explorer go to \workdir\strings\NoMASM directory and copy the strings.dsp and strings.dsw files and rewrite the ones them on \workdir\strings directory. After this repeat the steps before and go ahead. - If you have the MASM 5.x, do nothing. Go ahead. - If you have the MASM 6.x: - Right click over the strings project and click Set as Active Project. - Right click again and click Settings. - Open the strings tree. - Click over the Strings.asm file and at right side click the tab Custom Build. In the windows Commands, change the line: masm -Mx -t -DDOS386 -DM_I386 $(InputPath),$(Outdir)\$(InputName).obj,,, by the below line: ml /Cx /nologo /DDOS386 /DM_I386 /Zm /coff /c /Fo $(Outdir)\$(InputName).obj $(InputPath) - Do the same with the file Strxmov.asm. - Change the assembler command for the Win32 debug and release trees. - Now from the Build menu, select the Set Active Configuration menu. - Clicking over the screen select mysqld - Win32 Debug and click Ok. - Press F7. To begin the build of the debug server and libs and some client applications. - When the compilation finish, copy the libs and the executables for a separate directory. - Compile the release versions that you want, in the same way. - Create the directory for the MySQL stuff: e.g. c:\mysql - From the workdir directory copy for the c:\mysql directory the following directories: - Data - Docs - Share - Create the directory c:\mysql\bin and copy all the servers and clients that you had compiled before. - If you want create also the lib directory and copy the libs that you had compiled before. - Make a clean using the Visual Studio. Only this. Regards, Miguel >- >Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"; before >posting. To request this thread, e-mail [EMAIL PROTECTED] > >To unsubscribe, send a message to the address shown in the >List-Unsubscribe header of this message. If you cannot see it, >e-mail [EMAIL PROTECTED] instead. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil <___/ 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
Does anyone know why fetchrow_hashref failed?
Hi, I am using mod_perl and MySQL 3.23.38 on Red Hat Linux 6.2 and my following codes occasionally got an error. $SQL = 'SELECT col1,col2 FROM table1'. ' WHERE keya=1 AND keyb=2'; $STH = $DBH->prepare($SQL) || die $SQL; if ($STH->execute() >= 1) { $rec = $STH->fetchrow_hashref; $STH->finish(); } The error was: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at program-name line . It only happened once in a few dozen transactions. If anyone knows the cause of this and knows the solution for it, please let me know. Thank you very much in advance. Truoc Duong. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Encryption of Data
Jeremy Falcon schrieb am Donnerstag, 23. August 2001, 21:46:02: > Contact your ISP and ask them if they already have and/or willing to set-up > something for you. Yes, there are always many ways to do things - but before I give another, I'd really like to hear about the kind of task at hand here. For example: how often do you need that, how much data is transferred, what about the skills of the person who is in charge, can it be done manually at all, etc. I think it is good to ask about the cost of a solution in terms of time and effort and (therefore) money. So many people have answered this one without knowing anything about the job at hand - and I guess this can go on like this for a while. Herzlich Werner -- MySQL in Deutschland: Anpassung, Unterstützung, Schulung für Sie __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Dr. Werner Stürenburg <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Consultant /_/ /_/\_, /___/\___\_\___/ Bielefeld, Germany <___/ www.mysql.com +49-5224-997-407 Fax -409 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Encryption of Data
Contact your ISP and ask them if they already have and/or are willing to set-up something for you. Here's an instance. One host I have used before is TierraNet. They use cron to run a CGI script, named crontask.cgi, at 3AM. You can put anything you want to in that script (Perl, C/C++, etc.) to work with MySQL. So, maybe you could see if your ISP will do something like that. If that's not the case, and if your program is not intended to be publicly distributed, you could just run the CGI script manually. Or, (just another option) if they support SSI you could create a SHTML file with some system commands to do it. And lastly, PHP works wonders. If they don't have PHP installed then you're using a bum ISP, IMHO. :o) Unfortunately from the web, the file permissions have to set to publicly read and execute. So, set-up some sort of password protection (.htacess maybe) or anyone will be able to run the CGI script. Jeremy > Dear Jeremy, Gregor > > Thanks and sorry for not being more specific. > > > First of all we use an ISP who runs a Unix server. They won't give us ssh > > without a dedicate server - too expensive for us. > Then we use Windows > clients (95, 98) not on a network. > > We transfer the data down a phone line > from the server - > client and from> client - > server. > > Thanks for > suggesting cron - can you tell me what it is? > > Regards > > Elizabeth - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: FreeBSD and multiple daemons
>also try enabling the slow-log and track down any long queries. just did that, so we'll go through that now, there are some in there... >Have you tuned any of the cache parameters for the large amount of >memory you have? yes, we have done extensive tuning. Is there something I can provide to see how are changes might be affecting this? >What options were used to compile MySQL? /configure --localstatedir=/var/db/mysql --without-debug --without-bench --with-low-memory --with-libwrap --enable-assembler --with-berkeley-db --prefix=/usr/local Also, I don't know if this matters, but are there any general rules of thumb on the size of the mysql daemon on FreeBSD? Right now it shows 164MB according to this line from top 21366 mysql 58 0 164M 146M RUN1 32.5H 57.32% 57.32% mysqld Jerry >> I'm having a problem with my server getting bogged down once in a >while and >> I'm pretty sure it's due to the mysql daemon getting maxed out with >what it >> can do... when this happens there might be anywhere from 100 to 150 >> processes in the processlist and it might take as much as 30 seconds >to >> return a query via a web browser. When it happens mysql is usually >using >> almost 100% cpu, but load stays around 1.3 to 1.5. I'm running >FreeBSD >> 4.3-Release and mysql 3.23.40 We recently upgraded both because of >some >> of the past comments about the sleeping threads on the list in >slightly >> older versions. The server is dual P3-1G, 1g ram with SCSI drives >on >> single channel raid card. >> >> Is there a very stable way to run multiple daemons on FreeBSD? A >howto or >> some such thing that might describe setting it up. I can run the >memory up >> to 4g on the machine if necessary to handle the extra memory >requirements. >> Also, are there changes I'll have to make to my apps that use mysql >to deal >> with this? I searched the list for multiple daemons and didn't find >much >> there, maybe I'm using the wrong keywords to search for. Any >pointers or >> help would be greatly appreciated. >> >> Jerry >> - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problems compiling on FreeBSD 3.3 (mysql-3.23.41)
Hi !! I'm trying to compile mysql-3.23.41 on a FreebSD 3.3 box but I can't I'm using latest gnu make version and this is the first time that I have problems compiling mysql so if any of you can help me I'll appreciate. Thanks in advance. Angel. Making all in client gmake[2]: Entering directory `/usr/home/abehar/mysql-3.23.41/client' c++ -DUNDEF_THREADS_HACK -I./../include -I../include -I./.. -I.. -I..- O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -DMYSQLD_N ET_RETRY_COUNT=100 -c mysql.cc cc1plus: Invalid option `-fno-exceptions' In file included from mysql.cc:28: ../include/global.h:646: warning: abstract declarator used as declaration gmake[2]: *** [mysql.o] Error 1 gmake[2]: Leaving directory `/usr/home/abehar/mysql-3.23.41/client' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/usr/home/abehar/mysql-3.23.41' gmake: *** [all-recursive-am] Error 2 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: AW: Setup own DB for each user?
It's "safe_show_database", not "safe_show_databases" "Ulv Michel" <[EMAIL PROTECTED]> wrote: > > > Or you can add > > safe_show_database > > to your my.cnf, or call safe_mysqld with the added option " > --safe_show_database" do you have to compile mysql with some special parameter? My version (3.23.37, SuSE rpm) fails with a "unrecognized command" error when I try to start it after having inserted "safe_show_databases" or "skip_show_databases" into my.cnf - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Encryption of Data
Elizabeth Alderton schrieb am Donnerstag, 23. August 2001, 09:44:36: > Thanks for suggesting cron - can you tell me what it is? cron is a program on Linux to run scheduled programs. So you write a program and tell cron to execute it in any kind of interval you can think of. I don't know if you must have root access to be able to do that - if so, your ISP won't give it to you. Normally, you should be quite seasoned in Linux to work with cron ... Herzlich Werner -- MySQL in Deutschland: Anpassung, Unterstützung, Schulung für Sie __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Dr. Werner Stürenburg <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Consultant /_/ /_/\_, /___/\___\_\___/ Bielefeld, Germany <___/ www.mysql.com +49-5224-997-407 Fax -409 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Urgent:MySql problem
Look at your /etc/my.cnf where the location of mysql socket is specified. Also, I think RH 7.0 has a MySQL rpm installation already there. All you do is to enable it with /usr/sbin/setup. Hope this helps. Shu At 01:28 PM 6/1/2006 +0530, sachin wrote: >Hello, >I am working on RH Linux 7.0 >MySql is not working at all. >My MySql files are under /usr/bin. > >It gives the following error on running any mysql command > >Can't connect to localMySql server through socket >'var/lib/mysql/mysql.sock'(111) > >Please Help me. > >Thank You >Sachin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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[2]: GLIBC 2.2.4
Hello Trond, Thursday, August 23, 2001, 8:01:33 PM, you wrote: TEG> Peter Zaitsev <[EMAIL PROTECTED]> writes: >> I'm trying to compile mysql 3.23.41 with recent glibc 2.2.4 but this >> somehow does not work with the following diagnose: TEG> It builds just fine with glibc 2.2.4 on a current development version TEG> of Red Hat Linux (Roswell + a few minor updates). Yes. I'm shure it builds OK then glibc is installed as standart. I'm having a system with glibc 2.2.0 and trying to compile MYSQL with glibc 2.2.4 laying in a special directory. But if fails. The stranges thing is - is somehow builds something dynamic there I selected to bild everything static. TEG> Did you compile glibc yourself or have you used gcc 3? Yes. I compiled it myself using gcc 2.95.2 which whould be OK ? -- Best regards, Petermailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: experiences with table corruption-should this be in a faq?
I think you have bigger issues going on with your setup than killing a perl script causing corruption issues. I have experienced very little (almost no) corruption with any of my mysql tables using various versions of mysql for extended periods of time (the times the tables were corrupted it was user error). First thing I would recommend is for you upgrade to mysql 3.23.41, and then try you application again to see if the corruption continues. If it does, send a message back to this list with more information reguarding your setup (OS, hardware, mysql compile options, ect.. ). Then perhaps we can help find the cause of your problem. ryan > These are some remarks on mysql(3.23.32) with regard to > my experience > with data crash and recovery. It is not meant to be > negative in any sense > and I am actually very thankful there is a database > like Mysql around. > On the other hand, if these experiences are not due > to some mistake on my part and if my workarounds are > reasonable, it might be worth > including them in some documentation of faqs. > > First, it is fairly EASY to get table corruption . > I am using a perl/DBI script to parse > some data files and store them in Mysql tables. > It looks like it > is a little safer to close the Database handle before > attempting > say a mysqldump. > To optimize queries I am storing the data in tables > according > to some attribute. For example if this were a grocery > shop > inventory, the tables would looks like: > Table: Bananas > item_no quantity price > > Table: Oranges > > item_no quantity price > > etc.. > > This is because I have a lot of data and I am mostly > interested in issuing > queries on each species separately. Needless to say, > this creates a very large > number of tables(more than ls or rm can handle at a > time and of course also > more than what myisamchk can repair in a shot) > > I have found that if DBI dies for some reason, then > there is an almost certainity that at least some > tables are > corrupted. > In most cases myisamchk is able to only recover part > of the records > (from 50 to 80-90%) > > For recovery,the perl script uses a system call to > mysqldump every N files that are parsed. > Unfortunately, this gives some problems too. Sometimes > mysqldump does not complete and sometimes > even though it completes, one cannot subsequently > recover > all data because mysql ... about duplicate > primary keys. This appears to be traceable to the > creation > of files /var/lib/mysql/host-name-bin.xxx . These > files > appear to contain sql statements like what is produced > by mysqldump > Not only can these files get quite big, taking a lot of > space > in /var/lib/mysql(this is a mount point in a logical > volume group) > but I also found that removing the last one was > essential for being able to > get rid of the duplicate primary keys message. > Removing these > files(at least the last one) allowed the recreation of > the database tables > from the mysqldump obtained backups > > Another issue is the temporary files in TMPDIR; > According to the manual one can control where these > will go > by editing TMPDIR in safe_mysqld; I have not found any > such line in safe_mysqld > > I am also worried about a reported 8 hr limit(I need to > run in > continuous mode, i.e. get data continuously), but I > have not yet experienced > corruption that was definitely attributable to this. > > Any comments? > > Thanks, > S.Alexiou > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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
Column permissions bug on Win98...and workaround.
I had trouble learning column permissions on Win98 because a possible bug got in my way. I think that there is a problem with the tables_priv part of the user verification. According to mysqld, I am using "Ver 3.23.39-max-debug for Win95/Win98 on i32" of the program. I submit this bug because I didn't read about it in my hour of searching through the mysql mailing list archives. Here's how I reproduce it on a database UN where user search@localhost has usage permissions on *.*: As root, from within UN: 1. create table Test (Trial int, Trib int) 2. insert into Test values (3, 4) 3. grant select (Trial) on Test to search@"%" As a user, from within UN (in my case, search@localhost): 4. select Trial from Test That caused MySQL to tell me that I had no select permission for the table 'test'. However, if I go back to my root session... 5. update mysql.tables_priv set table_name="test" where table_name="Test" and db="UN" 6. flush privileges ...and go back to my query as [EMAIL PROTECTED] 7. select Trial from Test ...everything works fine. I can select the column "Trial", but selecting column "Trib" will correctly throw a column-select error. I have taken special care to make sure that I typed table and column names with the perfect case sensitivity, as if I was using MySQL on a *nix platform. I apologize for not using the mysqlbug script mentioned in the documentation. I've been using MySQL for only 5 days, and this problem has made my head spin a little bit. Also, I think this bug is the reason that something like 'grant select on UN.Test to search@"%"' doesn't work for me, but 'grant select on UN.* to search@"%"' does work. Michael L. Semon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Data Encryption
My thoughts exactly when i fisrt suggested a VPN. I think it would be one of the best alternatives. You said you use an ISP. Do you mean a dialup? How long does this data transfer normally take? Chris Lathem Network Administrator SkyHawke Technologies [EMAIL PROTECTED] 601.605.6100 Ext. 109 Fax: 601.605.9225 - Original Message - From: "Harald Fuchs" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 23, 2001 7:59 AM Subject: Re: Data Encryption > In article <010801c12ba5$9cb52540$e92a7dc2@default>, > "Elizabeth Alderton" <[EMAIL PROTECTED]> writes: > > > Dear Chuck > > Your idea has given me an idea. > > > How about: > > > When we actually collect the data, we encrypt it so that it is actually held > > in mysql in an encrypted form? Then it can speed up and down the phone > > lines in the 'raw' so to speak, but it's still in code so no one can get it > > anyway? > > > We wouldn't need SSH or SSL then would we? > > > Or is that too simplistic? > > To me that's too complicated. Today you need one client/server pair > to talk to each other securely over the Internet, tomorrow you need > another where you have to find another special solution. > > Set up a VPN (ssh, IPsec or something else) and you're done once and > for all. > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: Query optimization issue.
> > mysql> explain select * from dominf.domip order by ip desc; > > 'ORDER BY something DESC' does not use an index. It must > be ascending. See the manual. Also, I forgot, if you do this often and it needs to be in DESC order, you can always alter the app to create and use an extra column 'ip_desc unsigned int not null' and set it in an insert to (0x - ip) and have an index on ip_desc. (If the column was signed you would use 0x7FF - thevariable, but ip numbers need to be stored as unsigned). Sincerely, Steven Roussey http://Network54.com/?pp=e PS: I'm trying to set aside a week in September to augment the MySQL code to use an index even with DESC in these situations. MySQL AB has some unfinished code to do this that I'm working from. I'm just familiarizing myself with the context of the code right now. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Bug
Chris, mysqld.exe in version .38 was accidentally compiled with __NT__ defined. Use mysqld-max.exe from the same distribution or download a newer version from www.mysql.com Note that the web page www.innodb.com/bugfixes.html contains information about known bugs, patches to them, and, if already fixed, the version number of the fixed release. For example, the above bug appears there at May 30, 2001. Regards, Heikki http://www.innodb.com Copied message: . I recently installed MySQL, Ver 11.15 Distrib 3.23.38, for Win95/Win98 (i32), on a Windows 95 system running version 4.00.950C. When I tried to initialise the database I got the following error: C:\mysql\bin>mysqld InnoDB: The first specified data file c:\dbData\dbData1 did not exist: InnoDB: a new database to be created! InnoDB: Setting file c:\dbData\dbData1 size to 31457280 InnoDB: Database physically writes the file full: wait... InnoDB: Data file c:\dbData\dbData2 did not exist: new to be created InnoDB: Setting file c:\dbData\dbData2 size to 31457280 InnoDB: Database physically writes the file full: wait... InnoDB: Log file .\ib_logfile0 did not exist: new to be created InnoDB: Setting log file .\ib_logfile0 size to 5242880 InnoDB: Log file .\ib_logfile1 did not exist: new to be created InnoDB: Setting log file .\ib_logfile1 size to 5242880 Innobase: Assertion failure in thread 4293192801 in file M:\mysql-3.23\innobase\ os\os0file.c line 187 Innobase: we intentionally generate a memory trap. Innobase: Send a bug report to [EMAIL PROTECTED] 010823 14:40:24 C:\MYSQL\BIN\MYSQLD.EXE: Got signal 11. Aborting! 010823 14:40:24 Aborting InnoDB: Warning: shutting down not properly started database 010823 14:40:24 C:\MYSQL\BIN\MYSQLD.EXE: Shutdown Complete For info, below is the my.cnf file. The only changed/added lines are marked <=== and relate to the filespaces used by the database. As this is a test install I made to spaces fairly small (30M each). Example mysql config file. # Copy this file to c:\my.cnf to set global options # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password=my_password port=3306 #socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] innodb_data_file_path = dbData1:30M;dbData2:30M < innodb_data_home_dir = c:\\dbData < port=3306 #socket=MySQL skip-locking default-character-set=latin1 set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = flush_time=1800 # Uncomment the following row if you move the MySQL distribution to another # location #basedir = d:/mysql/ [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key=16M [client_fltk] help_file= c:\mysql\sql_client\MySQL.help client_file= c:\mysql\MySQL.options history_length=20 database = test queries_root= c:\mysql\queries last_database_file= c:\mysql\lastdb Can you advise how I can fix this problem. Thanks, Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 answer time
On 23-Aug-2001 Filippo Galante wrote: > I´m converting an old DBF aplication to MySql an I´m having a very strange > problem. > When I first execute a query it takes from 12 to 30 seconds to have an > answer, after that it runs in about 2 or 3 seconds. Because it's got the index ( & maybe the result) in cache memory. > It´s a very large file (ZipCodes) and I must seek by ZipCode, by > State/City/Street (where the problem occurs) or by State/Street (not so > important) > In a first step we are using MyODBC (the programs are still in Visual Fox) > afterwards they will be converted to another language. > > the whole line is something like that > > SELECT * FROM cepect USE INDEX (cepect1) WHERE state="SP" AND city="SAO > PAULO " AND LEFT(street,6) = "ESTELA" ORDER BY uf,cidade,logradouro > > comments : > cepect ==> file name > cepect1 ==> index name (ordered by uf,cidade,logradouro) > we use LEFT because I need all streets with that begins whith that name > we had to put the order clause because it was retriving in another order > (why the output isn´t in the named index order ?) > Index(es) are for finding records, not imposing order. so drop the 'USE INDEX'. MySQL is pretty good at choosing the proper one to use. That LEFT clause is going to mess up the optimizer. try ... AND street LIKE 'ESTELA%'. Also put an index on state ( & mabe city). > (why the output isn´t in the named index order ?) > SQL results have no order, you must specify it with an 'ORDER BY' clause. > Well that´s the problem.. > Other considerations : > > - I´m an old guy... > - I´m used to control my whole file (dbf, c-tree, and so on) Same reason that (most) Perl hackers don't C, & C folks don't do assembler. Once proven, a low-level implemtation is abstracted to a black-box. > - I´m from the time that develloper´s had to knew what they wanted and > mastered the whole file > Then you musta been thrilled changing from dbm to ndbm. > The old program used a grid and the pointer just skip to the first record > that matched the desired key, so the user could look around and choose the > desired record (In that case it´s really a good feature) > The question is don´t you have direct acess routines where I could : > - "find" or select a record passing a key (an old find/seek command) > - "skip" records (on both sides using the actual index of course) > - retrieve records these records > Or in one line : > - direct access and control to files for productivity programs > in another line : > - may I skip SQL processor... Not if you plan on using SQL. > > If you can explain me the first problem I´ll be pleased, the job is for a > courier and this query is one of the main ones (and more used) > The other questions are just ..., well probably there are other developers > that know exactly with record must be updated and need speed... > Thanks a lot > There's always the source ... Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. (53kr33t w0rdz: sql table 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: 4 fields to form key
On 23-Aug-2001 Tim Cowan wrote: > Hi > > Is it possible to use 2 or more fields to become the primary key. I have a > table > > CREATE TABLE tmptraining ( > rowid int(10) unsigned NOT NULL auto_increment, > sid char(32) NOT NULL default '', > expiry date NOT NULL default '-00-00', > arenaid tinyint(1) unsigned NOT NULL default '0', > time time NOT NULL default '00:00:00', > date date NOT NULL default '-00-00', > equip enum('Y','N') NOT NULL default 'N', > PRIMARY KEY (rowid) > ) > > and I want to constrain the information on four fields; arena, time, date > and sid. That way if someone clicks the refresh or reload button it will > not add another row, if all FOUR of the fields have the same value as > another row. Is there a way to do this? > Yes. mysql> desc hist_hits; +-+---+--+-++---+ | Field | Type | Null | Key | Default| Extra | +-+---+--+-++---+ | hitdate | date | | PRI | -00-00 | | | wmid| smallint(5) unsigned | | PRI | 0 | | | site| char(2) | | PRI | sh | | | urlid | bigint(20) unsigned | | PRI | 0 | | | rurlid | bigint(20) unsigned | | PRI | 0 | | | hits| mediumint(8) unsigned | | | 0 | | | clicks | smallint(5) unsigned | | | 0 | | +-+---+--+-++---+ 7 rows in set (0.00 sec) localhost.dread$ mysqldump -d WS hist_hits # MySQL dump 8.14 # # Host: localhostDatabase: JAWS # # Server version3.23.38 # # Table structure for table 'hist_hits' # CREATE TABLE hist_hits ( hitdate date NOT NULL default '-00-00', wmid smallint(5) unsigned NOT NULL default '0', site char(2) NOT NULL default 'sh', urlid bigint(20) unsigned NOT NULL default '0', rurlid bigint(20) unsigned NOT NULL default '0', hits mediumint(8) unsigned NOT NULL default '0', clicks smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (wmid,hitdate,urlid,rurlid,site), KEY idx_d (hitdate) ) TYPE=MyISAM; localhost.dread$ Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. (53kr33t w0rdz: sql table 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: font broblems
On 23-Aug-2001 Giannis wrote: > I cant appear greek fonts in my web pages. > My configuration is:(linux, apache-tomcat, JBoss application server and > mysql) > I make some JSP pages and i have problem with the greek fonts. > I put a meta tag: > but i doesnt work. > What is my wrong? > do you have the "Content-Language:" tag ? Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. (53kr33t w0rdz: sql table 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
using index
I have this table +---+--+--+-++-- --+ | Field | Type | Null | Key | Default| Extra | +---+--+--+-++-- --+ | ID| int(10) unsigned | | PRI | NULL | auto_increment | | Nick | varchar(50) | | MUL || | | Sexo | tinyint(1) | | MUL | 0 | | | OK| tinyint(1) | | MUL | 0 | | | Inicial | char(1) | | MUL || | +---+--+--+-++-- --+ With this index | genteirc | 0 | ID_2 |1 | ID | A | 22632 | NULL | NULL | | | genteirc | 1 | ok |1 | OK | A | 2 | NULL | NULL | | | genteirc | 1 | inicial |1 | Inicial | A | 22632 | NULL | NULL | | | genteirc | 1 | sexo |1 | Sexo | A | 22632 | NULL | NULL | | when I run this query mysql> explain select Nick from mytable where Inicial='P' AND Sexo=1 and ok=1; . +--+--+---+-+--- --+---+--++ | table| type | possible_keys | key | key_len | ref | rows | Extra | +--+--+---+-+--- --+---+--++ | mytable | ref | ok,inicial,sexo | ok | 1 | const | 10 | where used | +--+--+---+-+--- --+---+--++ only one index is used, why? ok is 1 or 0 sexo is 1 or 0 but inicial is A, B, C, D, E, F, G.Z So it would be better to use Inicial as index bacause should get less records... whta's happening? Thnaks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 statement didn't return results though there should be results
--- Werner Stürenburg <[EMAIL PROTECTED]> wrote: > > > Calvin Xu schrieb am Donnerstag, 23. August 2001, > 03:16:09: > > > select > subject,subhead,subsubhead,data2,data3,see_also > > from npl_detail where ( (subject like '% asia %' > OR > > subhead like '% asia %' OR subsubhead like '% asia > %' > > or data2 like '% asia %' or data3 like '% asia %' > or > > see_also like '% asia %')) AND NOT (subject like > > '%winter%' OR subhead like '%winter%' OR > subsubhead > > like '%winter%' OR data2 like '%winter%' OR data3 > like > > '%winter%' OR see_also like '%winter%') ORDER BY > > subject, subhead, subsubhead desc limit 0, 15 > > > But if I shorten some OR condition with NOT(), > some > > results would return. > > The query looks fine to me. I would investigate if > the result is > not correct, i.e. you don't have any record that > complies to the > constraint. > > But also consider, if you don't want to ask for > > select > subject,subhead,subsubhead,data2,data3,see_also > from npl_detail > > where (subject like '% asia %' > AND NOT subject like '%winter%') > OR > (subhead like '% asia %' > AND NOT subhead like '%winter%') > OR > (subsubhead like '% asia %' > AND NOT subsubhead like '%winter%') > OR > (data2 like '% asia %' > AND NOT data2 like '%winter%') > OR > (data3 like '% asia %' > AND NOT data3 like '%winter%') > OR > (see_also like '% asia %' > AND NOT see_also like '%winter%') > > ORDER BY > subject, subhead, subsubhead desc > limit 0, 15 > THanks for the kind reply. The above statement still doesn't return any result. However, if I change it to as follows, it will return results: select subject,subhead,subsubhead,data2,data3,see_also from npl_detail where (subject like '% asia %' AND subject NOT like '%winter%') OR (subhead like '% asia %' AND subhead NOT like '%winter%') OR (subsubhead like '% asia %' AND subsubhead NOT like '%winter%') OR (data2 like '% asia %' AND data2 NOT like '%winter%') OR (data3 like '% asia %' AND data3 NOT like '%winter%') OR (see_also like '% asia %' AND see_also NOT like '%winter%') ORDER BY subject, subhead, subsubhead desc limit 0, 15 Logically, there is no difference between this and the one you gave me. MySql is new to me. Does it mean any difference in MySQL? I am trying more changes. Thanks. Calvin __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ORDER BY queries optimizing with INDEX
A query with a ORDER BY clause over a numeric field, will be fast if this field have a index or this doesn't influence the anwer time of the query. Thanks. -- Gregorio R. Alberdi Díaz - <[EMAIL PROTECTED]> AVILÉS (ASTURIAS) - España. --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 parsing hex to make an ip address
try using inet_ntoa() function. On Thu, 23 Aug 2001 12:19:54 -0700 Jamil Farshchi <[EMAIL PROTECTED]> wrote: > Hello, > > I am trying to convert a hex number that is stored in a mysql db into an ip > address. Here is my problem: I can convert the original integer into a hex > number like so: > > For example: > mysql> select distinct HEX(ip_src) from iphdr; > --- > |ip_src| > ---| > |80B7EB99 | > |-- > > Now, I need mysql to parse the hex number and then convert the parsed data > into base 10. For example: > > 80B7EB99 (hex) = 128.183.235.153 > to convert the hex into the ip address, we need to do this: > 80 (hex) = 128 > B7 (hex) = 183 > EB (hex) = 235 > 99 (hex) = 153 > > so I need mysql to parse the hex number into 4 parts, convert each part > from hex to base 10, and then add a "." between each base 10 number. > > I know how to do this in perl, but I was wondering if it was possible to do > strictly in mysql. I really hope so because it would help out a lot. > > Any help would be greatly appreciated, > -jamil > > > Jamil D. Farshchi > Computer Specialist, Inspections and Assessments > NASA Office of Inspector General > Washington, DC 20546 > Phone: (202) 358-1897 > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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
master.info and my.cnf updates
I just set up a master/slave replication scheme and all is well, but through the procedure did get bit on the tail. After the setup, and after the master and slave mysql servers had been started, I got some error messages that pointed to a type in the slave's my.cnf file. I shut the slave down, fixed the typo, and restarted. Got the same error. I had a look at the master.info, and noticed it contained old information from the previous my.cnf. There were no binary log entries in it, so I shut the slave down, deleted the master.info, and restarted the slave. This fixed the problem and they're replicating fine. (A terrific feature, my thanks to the mysql team for that one.) Question is, is this behaviour by design? Seems to me if you edit my.cnf and restart the mysql slave the master.info entries corresponding to the my.cnf file should be updated. Thanks for any insight. Mike Robinson IT / Developer - Toronto Star TV Phone: 416.945.8786 Fax: 416.869.4566 Email: [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
MySQL Bug
I recently installed MySQL, Ver 11.15 Distrib 3.23.38, for Win95/Win98 (i32), on a Windows 95 system running version 4.00.950C. When I tried to initialise the database I got the following error: C:\mysql\bin>mysqld InnoDB: The first specified data file c:\dbData\dbData1 did not exist: InnoDB: a new database to be created! InnoDB: Setting file c:\dbData\dbData1 size to 31457280 InnoDB: Database physically writes the file full: wait... InnoDB: Data file c:\dbData\dbData2 did not exist: new to be created InnoDB: Setting file c:\dbData\dbData2 size to 31457280 InnoDB: Database physically writes the file full: wait... InnoDB: Log file .\ib_logfile0 did not exist: new to be created InnoDB: Setting log file .\ib_logfile0 size to 5242880 InnoDB: Log file .\ib_logfile1 did not exist: new to be created InnoDB: Setting log file .\ib_logfile1 size to 5242880 Innobase: Assertion failure in thread 4293192801 in file M:\mysql-3.23\innobase\ os\os0file.c line 187 Innobase: we intentionally generate a memory trap. Innobase: Send a bug report to [EMAIL PROTECTED] 010823 14:40:24 C:\MYSQL\BIN\MYSQLD.EXE: Got signal 11. Aborting! 010823 14:40:24 Aborting InnoDB: Warning: shutting down not properly started database 010823 14:40:24 C:\MYSQL\BIN\MYSQLD.EXE: Shutdown Complete For info, below is the my.cnf file. The only changed/added lines are marked <=== and relate to the filespaces used by the database. As this is a test install I made to spaces fairly small (30M each). Example mysql config file. # Copy this file to c:\my.cnf to set global options # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password=my_password port=3306 #socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] innodb_data_file_path = dbData1:30M;dbData2:30M < innodb_data_home_dir = c:\\dbData < port=3306 #socket=MySQL skip-locking default-character-set=latin1 set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = flush_time=1800 # Uncomment the following row if you move the MySQL distribution to another # location #basedir = d:/mysql/ [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key=16M [client_fltk] help_file= c:\mysql\sql_client\MySQL.help client_file= c:\mysql\MySQL.options history_length=20 database = test queries_root= c:\mysql\queries last_database_file= c:\mysql\lastdb Can you advise how I can fix this problem. Thanks, Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Redundancy within rows
Being a newbie to database design, I wonder if those more experienced could give me an opinion on what constitutes "good practice" - as opposed to what is technically possible. I know what I want to do is technically possible, but am I lining mself up for trouble by doing it? I know that it is a good database design never to have a particular datum more than once in the database, and to construct views of the database using Joins. I interpret this as a general invocation against redundancy. However, I want to used some redundancy within a row, and wonder if this is regarded as a bad idea. I have three data: start, finish, and length, and I may want to search by different combinations of them Obviously, these are redundant: length=finish - start. If I choose to store start and finish, I can obtain them in (say) length order by doing SELECT (finish-start) AS length from table ORDER BY length ; and obviously I an do the reverse calculation if I choose to store start and length. However, this involves MySQL in doing significant calculations as part of the search. Searches will obviously be faster if it doesn't have any calculations to do - I can even index by length, making the searches much faster again. But I don't have any feel for how much faster. I can easily afford the disk space for the extra column. Things that make the redundancy less dangerous are: All inserts will be done by one application (well, today) and can therefore be funnelled through one routine There are no updates (again, as of today) Is this a reasonable thing to do, or a bad idea? Thanks in advance of any opinions. Alec Cawley <<-- This e-mail is intended for the named addressees only. Its contents may be privileged or confidential and should be treated as such. If you are not an intended recipient please notify the sender immediately; do not copy, distribute, or take any action based on this e-mail; and then delete it. In the pursuit of its legitimate business activities and its conformance with relevant legislation, Quantel Ltd. may access any e-mail (including attachments) it originates and receives, for potential scrutiny. Version 10 of the Quantel Digital Factbook is now online - http://www.quantel.com/dfb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
font broblems
I cant appear greek fonts in my web pages. My configuration is:(linux, apache-tomcat, JBoss application server and mysql) I make some JSP pages and i have problem with the greek fonts. I put a meta tag: but i doesnt work. What is my wrong? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 parsing hex to make an ip address
Hello, I am trying to convert a hex number that is stored in a mysql db into an ip address. Here is my problem: I can convert the original integer into a hex number like so: For example: mysql> select distinct HEX(ip_src) from iphdr; --- |ip_src| ---| |80B7EB99 | |-- Now, I need mysql to parse the hex number and then convert the parsed data into base 10. For example: 80B7EB99 (hex) = 128.183.235.153 to convert the hex into the ip address, we need to do this: 80 (hex) = 128 B7 (hex) = 183 EB (hex) = 235 99 (hex) = 153 so I need mysql to parse the hex number into 4 parts, convert each part from hex to base 10, and then add a "." between each base 10 number. I know how to do this in perl, but I was wondering if it was possible to do strictly in mysql. I really hope so because it would help out a lot. Any help would be greatly appreciated, -jamil Jamil D. Farshchi Computer Specialist, Inspections and Assessments NASA Office of Inspector General Washington, DC 20546 Phone: (202) 358-1897 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Data Encryption
> From: Elizabeth Alderton [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 23, 2001 9:26 AM >... > Dear Chuck > > Your idea has given me an idea. > > How about: > > When we actually collect the data, we encrypt it so that it is > actually held > in mysql in an encrypted form? Then it can speed up and down the phone > lines in the 'raw' so to speak, but it's still in code so no one > can get it > anyway? Err.. and if all data is encrypted, how do you go about specifying the WHERE clause for your SELECTs, UPDATEs and DELETEs? / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: GLIBC 2.2.4
Peter Zaitsev <[EMAIL PROTECTED]> writes: > I'm trying to compile mysql 3.23.41 with recent glibc 2.2.4 but this > somehow does not work with the following diagnose: It builds just fine with glibc 2.2.4 on a current development version of Red Hat Linux (Roswell + a few minor updates). Did you compile glibc yourself or have you used gcc 3? -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
compile problems with mysqlgui-src-1.7.5....
main.cc: In function `void if_conn()': main.cc:464: no matching function for call to `MysqlConnection::clinet_info ()' main.cc:529: no matching function for call to `MysqlConnection::clinet_info ()' make: *** [main.o] Error 1 I am using mysql++-1.7.9, and do not see any references to clinet_info being declared in connectionXXX.h in directory mysql++-1.7.9/sqlplusint. any thoughts? ronyd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: shadow tables?
on 8/23/01 12:35 AM, Werner Stürenburg wrote: > Is it an option to drop the table and recreate and repopulate it? > > I would give it a try and think that your problem will be gone. > You can easily do that with mysqldump. Ask again if you need more > help. Hi, Werner: I tried this, and it didn't solve the problem. I also tried creating a new database (with a different name) and new tables by hand. The new database has the same problems. -Alex -- Alex Pukinskis Web and Internet Consultant Satori Design and Development http://satoridesign.com [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: where should the mysql folder be?
OK folks - I found it - tucked away in the /home/ folder. GP - Original Message - From: George Pitcher <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 23, 2001 3:59 PM Subject: Re: where should the mysql folder be? > > - Original Message - > From: <[EMAIL PROTECTED]> > To: George Pitcher <[EMAIL PROTECTED]> > Sent: Thursday, August 23, 2001 4:03 PM > Subject: Re: where should the mysql folder be? > > > > 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: > > > > database,sql,query,table > > > > If you just reply to this message, and include the entire text of it in > the > > reply, your reply will go through. However, you should > > first review the text of the message to make sure it has something to do > > with MySQL. Just typing the word MySQL once will be sufficient, for > example. > > > > You have written the following: > > > > hi all, > > > > having now installed the client I can't find the damn folder! > > > > I thought that it should have been in /usr/local/ but it ain't. I don't > know > > how to find a folder being a linux newbie as well. > > > > Any hints? > > > > George in Edinburgh > > > > > > _ > > Do You Yahoo!? > > Get your free @yahoo.com address at http://mail.yahoo.com > > > > > _ > Do You Yahoo!? > Get your free @yahoo.com address at http://mail.yahoo.com > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SELECT answer time
I´m converting an old DBF aplication to MySql an I´m having a very strange problem. When I first execute a query it takes from 12 to 30 seconds to have an answer, after that it runs in about 2 or 3 seconds. It´s a very large file (ZipCodes) and I must seek by ZipCode, by State/City/Street (where the problem occurs) or by State/Street (not so important) In a first step we are using MyODBC (the programs are still in Visual Fox) afterwards they will be converted to another language. the whole line is something like that SELECT * FROM cepect USE INDEX (cepect1) WHERE state="SP" AND city="SAO PAULO " AND LEFT(street,6) = "ESTELA" ORDER BY uf,cidade,logradouro comments : cepect ==> file name cepect1 ==> index name (ordered by uf,cidade,logradouro) we use LEFT because I need all streets with that begins whith that name we had to put the order clause because it was retriving in another order (why the output isn´t in the named index order ?) Well that´s the problem.. Other considerations : - I´m an old guy... - I´m used to control my whole file (dbf, c-tree, and so on) - I´m from the time that develloper´s had to knew what they wanted and mastered the whole file The old program used a grid and the pointer just skip to the first record that matched the desired key, so the user could look around and choose the desired record (In that case it´s really a good feature) The question is don´t you have direct acess routines where I could : - "find" or select a record passing a key (an old find/seek command) - "skip" records (on both sides using the actual index of course) - retrieve records these records Or in one line : - direct access and control to files for productivity programs in another line : - may I skip SQL processor... If you can explain me the first problem I´ll be pleased, the job is for a courier and this query is one of the main ones (and more used) The other questions are just ..., well probably there are other developers that know exactly with record must be updated and need speed... Thanks a lot - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: where should the mysql folder be?
- Original Message - From: <[EMAIL PROTECTED]> To: George Pitcher <[EMAIL PROTECTED]> Sent: Thursday, August 23, 2001 4:03 PM Subject: Re: where should the mysql folder be? > 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: > > database,sql,query,table > > If you just reply to this message, and include the entire text of it in the > reply, your reply will go through. However, you should > first review the text of the message to make sure it has something to do > with MySQL. Just typing the word MySQL once will be sufficient, for example. > > You have written the following: > > hi all, > > having now installed the client I can't find the damn folder! > > I thought that it should have been in /usr/local/ but it ain't. I don't know > how to find a folder being a linux newbie as well. > > Any hints? > > George in Edinburgh > > > _ > Do You Yahoo!? > Get your free @yahoo.com address at http://mail.yahoo.com > _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't initialize InnoDB as 'innodb_data_file_path'
Hi! Maybe you already have a my.ini or my.cnf file in winnt or winnt\system directory, or some other directory and that overshadows the file you have in C:\ What do dir /s my.cnf dir /s my.ini say? Your innodb start options look ok. For some reason MySQL does not see the options you have specified. Regards, Heikki http://www.innodb.com Copied message: I read the mannual to use InnoDB. following is my c:\my.cnf file. I am still getting above message. I tried with 3.23.39a-win and also with mysql-3.23.41-win.zip. I do have data and logs directory created. Please help vitthal # Example mysql config file for medium systems.# # This is for a system with little memory (32M - 64M) where MySQL plays # a important part and systems up to 128M very MySQL is used togetherwith # other programs (like a web server)## You can copy this file to # /etc/mf.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /usr/local/mysql/var) or # ~/.my.cnf to set user-specific options.# # One can in this file use all long options that the program supports. # If you want to know which options a program support, run the program # with --help option.# The following options will be passed to all MySQL clients [client]#password = your_passwordport = 3306#socket = /tmp/mysql.sock # Here follows entries for some specific programs# The MySQL server[mysqld] port = 3306#socket = /tmp/mysql.sockskip-lockingset-variable = key_buffer=64M set-variable = max_allowed_packet=1Mset-variable = table_cache=64 set-variable = sort_buffer=4Mset-variable = record_buffer=1M set-variable = net_buffer_length=8Kset-variable = myisam_sort_buffer_size=8M # Uncomment the following if you are using Innobase tables innodb_data_file_path = ibdata1:2000M;ibdata2:2000M innodb_data_home_dir = c:/mysql/dataset-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = c:/mysql/logs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30Mset-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1innodb_log_arch_dir = c:/mysql/logs innodb_log_archive=0set-variable = innodb_buffer_pool_size=80M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50[mysqldump]quick set-variable = max_allowed_packet=16M[mysql]no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates[isamchk]set-variable = key_buffer=20M set-variable = sort_buffer=20Mset-variable = read_buffer=2M set-variable = write_buffer=2M[myisamchk]set-variable = key_buffer=20M set-variable = sort_buffer=20Mset-variable = read_buffer=2M set-variable = write_buffer=2M[mysqlhotcopy]interactive-timeout - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
numrows
I tried it in the command line. And it works. But in the programm is still doesn't. MySQL Query Failed. Error 1030: Got error -1 from table handler > > Message-Id: <[EMAIL PROTECTED]> > Date: Thu, 23 Aug 2001 04:53:44 -0400 > To: [EMAIL PROTECTED] > From: "Jason G." <[EMAIL PROTECTED]> > Subject: Re: numrows > Mime-Version: 1.0 > Content-Type: text/plain; charset="us-ascii"; format=flowed > > Another tip that I have used ALOT... > > When a query fails, go to the command line and try executing it and > variations of it there to find the problem. > > -Jason Garber > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Installing on Linuxppc???
Thanks Paul, Can I install the Client from the same rpm that the server came from or is it a diff download? George - Original Message - From: Paul Foxton <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 23, 2001 3:02 PM Subject: RE: Installing on Linuxppc??? > Hiya, > > Yes, when you install from an rpm you just get the server, so you need to > download the client programs binary in a seperate rpm and install them too. > > > Also, the rpm decides where to install everything so you don't actually end > up with a base install dir for MySQL. Your data directory should end up as > /var/lib/mysql > > If all goes well then you should just be able to go > > shell> mysql > > and off you go : ) > > This worked fine for me on red hat 7.1 > > cheers, > > Paul > > > -Original Message- > > From: George Pitcher [mailto:[EMAIL PROTECTED]] > > Sent: 23 August 2001 14:52 > > To: [EMAIL PROTECTED] > > Subject: Installing on Linuxppc??? > > > > > > Hi all, > > > > Brand new to this list. > > > > I have MySQL running happily on my NT laptop. I decided it was time to > > migrate to Linux so I have set up an old Mac (nubus) with > > Linux-PPC-2000Q4 > > and have tried to install MySQL with varying degrees of difficulty. > > > > After some very futile attempts at a source compilation due to mising > > headers I have downloaded the version 3.23.27 ppc.rpm and > > rpm -i'd it. I > > now see that the daemon is indeed running but I have no > > control over it. > > > > There is no mysql folder outside the /var/bin/ folder so I > > cannot set up > > passwords or create databases etc. > > > > Can I just add a client to do this for me (if so where do I > > get it and how > > do I install over the daemon?) or is there another package > > which I should > > install to replace the one which is running (how do I stop it > > without any > > control?) > > > > Sorry my first posting is such a bummer. > > > > > > Regards > > > > George Pitcher > > > > Technical Manager > > HERON Project > > Napier University > > Edinburgh EH10 5DT > > > > [EMAIL PROTECTED] > > [EMAIL PROTECTED] > > [EMAIL PROTECTED] > > > > http://www.heron.ac.uk > > > >programmer - A device for transmuting caffeine into code. > > > > > > > > > > _ > > Do You Yahoo!? > > Get your free @yahoo.com address at http://mail.yahoo.com > > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Developer??
Hello, I am trying to find a distribution of the source for the "Include files and libraries for develpment" for OS X. Does anybody know where I can get this?? I'm trying to get the dbf2mysql converter to work in OS X but somebody told me that I needed to install the developer edition of MySQL. Can anybody point me in the right direction? Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mySQL Interface Programs
Assuming you are on windoze, try www.mysqlfront.de. I use it on my NT laptop. GP - Original Message - From: j.urban <[EMAIL PROTECTED]> To: Neil Tompkins <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, August 23, 2001 3:08 PM Subject: Re: mySQL Interface Programs > Check out urSQL from http://www.urbanresearch.com/ursql > > On Thu, 23 Aug 2001, Neil Tompkins wrote: > > > Hello, > > > > Currently to connect to mySQL server I use MS Access and ODBC. I have > > noticed that the update when scrolling through records is not very good. > > Can anyone recommend and suggestion so FREE programs to view and edit data. > > > > Thanks > > > > Neil > > > > _ > > Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp > > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > 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 _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
apache stops in make
Hello, I have libz-1.1.3-284 installed on my Linux but when i try install apache 1.3.20 with mysql 3.23 and php 4, i've the message collect2: ld returned 1 exit status make[2]: *** [target_static] Error 1 make[2]: Leaving directory `/home2/mvmendes/apache/apache_1.3.20/src' make[1]: *** [build-std] Error 2 make[1]: Leaving directory `/home2/mvmendes/apache/apache_1.3.20' make: *** [build] Error 2 I need hellp! Marcus Mendes Analista de Sistemas Jornal Estado de Minas - http://www.uai.com.br Av. Getulio Vargas, 291 - Belo Horizonte - MG Superintendencia de Internet - CEP: 30112-020 Tel: +55(31)3263-5369 - Fax: +55(31)3263-5039 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Installing on Linuxppc???
Hiya, Yes, when you install from an rpm you just get the server, so you need to download the client programs binary in a seperate rpm and install them too. Also, the rpm decides where to install everything so you don't actually end up with a base install dir for MySQL. Your data directory should end up as /var/lib/mysql If all goes well then you should just be able to go shell> mysql and off you go : ) This worked fine for me on red hat 7.1 cheers, Paul > -Original Message- > From: George Pitcher [mailto:[EMAIL PROTECTED]] > Sent: 23 August 2001 14:52 > To: [EMAIL PROTECTED] > Subject: Installing on Linuxppc??? > > > Hi all, > > Brand new to this list. > > I have MySQL running happily on my NT laptop. I decided it was time to > migrate to Linux so I have set up an old Mac (nubus) with > Linux-PPC-2000Q4 > and have tried to install MySQL with varying degrees of difficulty. > > After some very futile attempts at a source compilation due to mising > headers I have downloaded the version 3.23.27 ppc.rpm and > rpm -i'd it. I > now see that the daemon is indeed running but I have no > control over it. > > There is no mysql folder outside the /var/bin/ folder so I > cannot set up > passwords or create databases etc. > > Can I just add a client to do this for me (if so where do I > get it and how > do I install over the daemon?) or is there another package > which I should > install to replace the one which is running (how do I stop it > without any > control?) > > Sorry my first posting is such a bummer. > > > Regards > > George Pitcher > > Technical Manager > HERON Project > Napier University > Edinburgh EH10 5DT > > [EMAIL PROTECTED] > [EMAIL PROTECTED] > [EMAIL PROTECTED] > > http://www.heron.ac.uk > >programmer - A device for transmuting caffeine into code. > > > > > _ > Do You Yahoo!? > Get your free @yahoo.com address at http://mail.yahoo.com > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mySQL Interface Programs
Check out urSQL from http://www.urbanresearch.com/ursql On Thu, 23 Aug 2001, Neil Tompkins wrote: > Hello, > > Currently to connect to mySQL server I use MS Access and ODBC. I have > noticed that the update when scrolling through records is not very good. > Can anyone recommend and suggestion so FREE programs to view and edit data. > > Thanks > > Neil > > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: Re[4]: GLIBC 2.2.4
Peter Zaitsev writes: > Hello Sinisa, > > > If I'm not mistaken this shows version 2.2.4 > > > SM> And your compiler was built with which glibc ?? > 2.2.0 from suse 7.1 > > > > > -- > Best regards, > Petermailto:[EMAIL PROTECTED] > > You have got only one vestige left : Run : grep -Fl 2.2.3 .../lib* where ... are one by one all directories from /etc/ld.so.conf plus gcc-lib directory with libgcc.a. Then run same search on *.o in the same places. -- 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
strange error
when i'm connecting to the base with the prompt => no problem in a file test toto.c : mysql_connect(&MSQL_IDENBASE,localhost,root,mysql); ==> no problem But in a big application, when i try to connect by mysql_connect(&MSQL_IDENBASE,localhost,root,mysql); ==> error 2004 Somebody know something about that thank you Nicolas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Installing on Linuxppc???
Hi all, Brand new to this list. I have MySQL running happily on my NT laptop. I decided it was time to migrate to Linux so I have set up an old Mac (nubus) with Linux-PPC-2000Q4 and have tried to install MySQL with varying degrees of difficulty. After some very futile attempts at a source compilation due to mising headers I have downloaded the version 3.23.27 ppc.rpm and rpm -i'd it. I now see that the daemon is indeed running but I have no control over it. There is no mysql folder outside the /var/bin/ folder so I cannot set up passwords or create databases etc. Can I just add a client to do this for me (if so where do I get it and how do I install over the daemon?) or is there another package which I should install to replace the one which is running (how do I stop it without any control?) Sorry my first posting is such a bummer. Regards George Pitcher Technical Manager HERON Project Napier University Edinburgh EH10 5DT [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] http://www.heron.ac.uk programmer - A device for transmuting caffeine into code. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Urgent!!! core dump, why???
Hi, I am running mysql-3.22.27 for many months. But today, the mysqld always core dump. The running platform is FreeBSD3.4. I checked the dumped core and find that it seems that the core dump has something with the /usr/lib/libc_r.so file when it called the thread subroutine. Please help me! Best regaurds! --xiyuan __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Solaris JDBC
Sir, I was able to successfully use the JDBC driver to connect from a Linux computer to a mysql database resident on another computer running Linux. The Linux computers are running Java Version 1.1. I am now trying to use the same JDBC driver to connect from a Sun Solaris 8 to a Linux computer containing mysql. The Sun computer is running Java Version 1.2.2. I get the error 'No suitable driver'. What is the problem? I created the CLASSPATH as before and placed the driver in /usr/local/mysql/mm.mysql-2.0.4-bin.jar. Any help will be greatly appreciated. Thanks. vince - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 2004
somebody know what means this error (with mysql_connect) thank you Nicolas. PS : i don't have the file "mysqld_errors.txt" - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Good references for Theory??
How about 'Database System Concepts' by Abraham Silberschatz and others. It takes you from relational calculus through index data structures, transactions, concurrency control and new db applications. You could also look at the classics by Date Introduction to database systems 7th ed. --- Claudia M. Castaneda Phone 301 286 3397 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
experiences with table corruption-should this be in a faq?
These are some remarks on mysql(3.23.32) with regard to my experience with data crash and recovery. It is not meant to be negative in any sense and I am actually very thankful there is a database like Mysql around. On the other hand, if these experiences are not due to some mistake on my part and if my workarounds are reasonable, it might be worth including them in some documentation of faqs. First, it is fairly EASY to get table corruption . I am using a perl/DBI script to parse some data files and store them in Mysql tables. It looks like it is a little safer to close the Database handle before attempting say a mysqldump. To optimize queries I am storing the data in tables according to some attribute. For example if this were a grocery shop inventory, the tables would looks like: Table: Bananas item_no quantity price Table: Oranges item_no quantity price etc.. This is because I have a lot of data and I am mostly interested in issuing queries on each species separately. Needless to say, this creates a very large number of tables(more than ls or rm can handle at a time and of course also more than what myisamchk can repair in a shot) I have found that if DBI dies for some reason, then there is an almost certainity that at least some tables are corrupted. In most cases myisamchk is able to only recover part of the records (from 50 to 80-90%) For recovery,the perl script uses a system call to mysqldump every N files that are parsed. Unfortunately, this gives some problems too. Sometimes mysqldump does not complete and sometimes even though it completes, one cannot subsequently recover all data because mysql ... http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 4 fields to form key
Tim Cowan wrote: > > Hi > > Is it possible to use 2 or more fields to become the primary key. I have a > table > Yes > CREATE TABLE tmptraining ( > rowid int(10) unsigned NOT NULL auto_increment, > sid char(32) NOT NULL default '', > expiry date NOT NULL default '-00-00', > arenaid tinyint(1) unsigned NOT NULL default '0', > time time NOT NULL default '00:00:00', > date date NOT NULL default '-00-00', > equip enum('Y','N') NOT NULL default 'N', > PRIMARY KEY (rowid) > ) > > and I want to constrain the information on four fields; arena, time, date > and sid. That way if someone clicks the refresh or reload button it will > not add another row, if all FOUR of the fields have the same value as > another row. Is there a way to do this? > Just create an "unique index" on these fields (arena, time, date, sid). See 'alter table' command in MySQL manual. > Thanks > > Tim > Regards -- Joseph Bueno NetClub/Trader.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[2]: GLIBC 2.2.4
Peter Zaitsev writes: > Hello Sinisa, > > Thursday, August 23, 2001, 3:42:53 PM, you wrote: > > This is strange As I've compiled plain gcc 2.2.4 into other directory > and now running --with-other-libc= and It swears about glibc 2.2.3 > therefore my system glibc is 2.2.0 and I have never used 2.2.3 > > SM> Check also version of your /lib/libdl.so.* > > > > > -- > Best regards, > Petermailto:[EMAIL PROTECTED] > > Have you checked libdl version ?? And your compiler was built with which glibc ?? -- 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: 4 fields to form key
I am not sure about the primary key. You can create a UNIQUE index on (field1, field2, field3, field4)... (I have done this) This will prevent any duplicate rows from being inserted. Hope it Helps, -Jason Garber Lead Programmer - pulseaday.com At 08:07 AM 8/23/2001 -0400, you wrote: >Hi > >Is it possible to use 2 or more fields to become the primary key. I have a >table > >CREATE TABLE tmptraining ( > rowid int(10) unsigned NOT NULL auto_increment, > sid char(32) NOT NULL default '', > expiry date NOT NULL default '-00-00', > arenaid tinyint(1) unsigned NOT NULL default '0', > time time NOT NULL default '00:00:00', > date date NOT NULL default '-00-00', > equip enum('Y','N') NOT NULL default 'N', > PRIMARY KEY (rowid) >) > >and I want to constrain the information on four fields; arena, time, date >and sid. That way if someone clicks the refresh or reload button it will >not add another row, if all FOUR of the fields have the same value as >another row. Is there a way to do this? > >Thanks > >Tim > >- >Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > >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[2]: GLIBC 2.2.4
Hello Sinisa, Thursday, August 23, 2001, 3:42:53 PM, you wrote: SM> Peter Zaitsev writes: >> Hello mysql, >> >> I'm trying to compile mysql 3.23.41 with recent glibc 2.2.4 but this >> somehow does not work with the following diagnose: >> >> l/var\""-DSHAREDIR="\"/usr/local/mysql/share/mysql\"" >-DHAVE_CONFIG_H -I../bdb/build_unix -I../innobase/include > -I./../include >>-I./../regex-I. -I../include -I.. -I.-O3 -DDBUG_OFF >-g -O6 -mpentiumpro -fno-omit-frame-pointer -pipe -I/usr/local/glibc-2.2.4/include >-c password.c >> /bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF -g -O6 -mpentiumpro >-fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -pipe >-fno-implicit-templates -fno-exceptions >> -fno-rtti -fpermissive -I/usr/local/glibc-2.2.4/include -static >-L/usr/local/glibc-2.2.4/lib -o mysqlbinlog mysqlbinlog.o mini_client.o net_serv.o >mini_client_errors.o violite.o password.o >> ../isam/libnisam.a ../merge/libmerge.a >../myisam/libmyisam.a ../myisammrg/libmyisammrg.a ../heap/libheap.a > >> ../mysys/libmysys.a ../dbug/libdbug.a >../regex/libregex.a ../strings/libmystrings.a -lpthread -lz >-lcrypt -lnsl -lm -lpthread >> mkdir .libs >> gcc -O3 -DDBUG_OFF -g -O6 -mpentiumpro -fno-omit-frame-pointer -felide-constructors >-fno-exceptions -fno-rtti -pipe -fno-implicit-templates -fno-exceptions -fno-rtti >-fpermissive >> -I/usr/local/glibc-2.2.4/include -L/usr/local/glibc-2.2.4/lib -o mysqlbinlog >mysqlbinlog.o mini_client.o net_serv.o mini_client_errors.o violite.o password.o >../isam/libnisam.a ../merge/libmerge.a >> ../myisam/libmyisam.a ../myisammrg/libmyisammrg.a ../heap/libheap.a >../mysys/libmysys.a ../dbug/libdbug.a ../regex/libregex.a ../strings/libmystrings.a >-lpthread -lz -lcrypt -lnsl -lm -lpthread >> /usr/local/glibc-2.2.4/lib/libpthread.so: undefined reference to >`_dl_cpuclock_offset' >> /usr/local/glibc-2.2.4/lib/libc.so.6: undefined reference to >`[EMAIL PROTECTED]' >> /usr/local/glibc-2.2.4/lib/libc.so.6: undefined reference to >`[EMAIL PROTECTED]' >> collect2: ld returned 1 exit status >> make[3]: *** [mysqlbinlog] Error 1 >> make[3]: Leaving directory `/home/mysql/mysql-3.23.41g/sql' >> make[2]: *** [all-recursive] Error 1 >> make[2]: Leaving directory `/home/mysql/mysql-3.23.41g/sql' >> make[1]: *** [all-recursive] Error 1 >> make[1]: Leaving directory `/home/mysql/mysql-3.23.41g' >> make: *** [all-recursive-am] Error 2 >> >> This is rather strange as static option is not passed therefor I'm >> compiling it with --all-static option. >> >> >> -- >> Best regards, >> Peter mailto:[EMAIL PROTECTED] >> SM> Can't help you as I can't install 2.2.4 as it they clearly stated that SM> it must not be compiled with gcc 3.0 and I use 3.0.1. SM> The above error happens when some of the libs or modules still have SM> references to the older glibc version, like for example GCC objects SM> and other ones. This is strange As I've compiled plain gcc 2.2.4 into other directory and now running --with-other-libc= and It swears about glibc 2.2.3 therefore my system glibc is 2.2.0 and I have never used 2.2.3 SM> Check also version of your /lib/libdl.so.* -- Best regards, Petermailto:[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
4 fields to form key
Hi Is it possible to use 2 or more fields to become the primary key. I have a table CREATE TABLE tmptraining ( rowid int(10) unsigned NOT NULL auto_increment, sid char(32) NOT NULL default '', expiry date NOT NULL default '-00-00', arenaid tinyint(1) unsigned NOT NULL default '0', time time NOT NULL default '00:00:00', date date NOT NULL default '-00-00', equip enum('Y','N') NOT NULL default 'N', PRIMARY KEY (rowid) ) and I want to constrain the information on four fields; arena, time, date and sid. That way if someone clicks the refresh or reload button it will not add another row, if all FOUR of the fields have the same value as another row. Is there a way to do this? Thanks Tim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Connection delay problem
Are you using BIND? You may want to make sure you applied your new changes to it and also make sure your /etc/host.conf has the right order for searching in it. Rob - Original Message - From: "Tim Cadell" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Wednesday, August 22, 2001 8:26 PM Subject: Re: Connection delay problem > Nope, didn't solve it. I added that to the mysqld command and restarted > it (checked with ps -ef to make sure it took) and it still does it. > > Sasha also suggested that I try using straight IP addresses everywhere, > and I did that, but it hasn't helped yet. > > Thanks for the suggestion, though. > > Tim Cadell > Total Net > > -Original Message- > From: "Jason Brooke" <[EMAIL PROTECTED]> > To: "Tim Cadell" <[EMAIL PROTECTED]>, "MySQL List" > <[EMAIL PROTECTED]> > Date: Thu, 23 Aug 2001 10:16:58 +1000 > Subject: Re: Connection delay problem > > > > We're having problems with connecting to our MySQL database after > > making > > > some changes to our system. Unfortunately, we had to reassign it's IP > > > address and, at the same time, our customer wanted to change the > > domain > > > name for the system. Changing both seems to have been a bad thing. > > > > > > Now, with every connection method I've tried (perl DBI, mysql command > > > line), there is a 15 second delay before the connection succeeds, > > which > > > it always does. > > > > > > Can anyone give me a hint on this one? > > > > > > Tim Cadell > > > Total Net > > > > It's probably trying to resolve each host that connects to it, although > > from > > your description it even sounds like connecting from the localhost is > > getting the same behaviour too which is strange since your /etc/hosts > > file > > should have an entry for that > > > > --skip-name-resolve in the startup line would probably fix it > > > > jason > > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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