Re: How to access mysqladmin from IE?
Besides using Phpmyadmin to edit the data. I actually prefer to use something like webmin to manage my data. Do a search on Webmin on the internet. - Original Message - From: "Aqua" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 25, 2002 12:42 PM Subject: How to access mysqladmin from IE? > Hi guys! Does anyone know how to access mysqladmin from Internet Explorer so > I can view and edit my data. > Please help, thanks. > > Aqua > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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
11G .err file
Hi, My mysql error file (hostname.err) had grown to 11G on Red Hat 7.0, kernel 2.4.3, file system type ext2. As I understand it, file size in Terrabytes can be supported under this kernel version, however, mysql semi-crashed at this point, meaning I could not connect to it remotely (I could connect locally but that didnn't help much). I had to kill -9 the process, a simple kill wouldn't work and even after that one mysql process was left hanging which a 'kill -9' wouldn't kill either. When I tried to bring mysql back up it complained about the error file being too large. I had to reboot the server finally to get everything to work. Has anybody seen this before and can explain why it happened? The other question is, Before I brought down the server and after I brought it up, I have been seeing the following message in my .err file: 020625 0:08:13 Error in accept: Invalid argument for probably every single query that gets executed. This is what is filling up my *.err file to 11GB in the first place. The results of the query seem to look fine but I get these errors in the error file...anyone know what they mean? Thanks, Bhavin. Thanks a lot, Bhavin. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: file size limit hitting when "LOAD DATA INFILE"
Yes, MERGE Tables is useful for getting around the file size limit problem. However, Linux 7.2(Kernel 2.4.x), MySql 3.23.47 supports file sizes greater than 4GB. Mysql 3.23 by defaul will create tables that can grow only upto 4G but these can be altered using ALTER TABLE. You willl need to alter AVG_ROW_LENGTH and MAX_ROWS, the product of which is the file size that will be supported. http://www.mysql.com/doc/T/a/Table_size.html Also, if you do not want to go that route, you can use MERGE tables which will merge 2 or more underlying tables, say, AAA1 & AAA2 into AAA. so you can either refer to AAA or indivually to AAA1 and AAA2. Generally, you want to refer to AAA while quering and the indiviudal tables while inserting/updating data. Regards, Bhavin. - Original Message - From: "Buding Chen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 24, 2002 7:23 PM Subject: file size limit hitting when "LOAD DATA INFILE" > Hi, all: > I use MySQL 3.23.47, RH linux 7.2, file size limit is 4G. When "LOAD > DATA INFILE" to a table whose file size is 4G, it fails and mysql_error(...) > reports "Lost connection to MySQL server during query". How can I clearly > know the failed reason is just hit the 4G file size limit? > If the 4G file size limit is hit, I have two ways to resolve it: (1) > create a new table and "LOAD DATA INFILE" into this new table. (2) backup > this table and clear it and reload. However, these two ways are troubled and > not good. Dose some one have a effective way that just "LOAD DATA INFILE" > without hitting file size limit? Dose MERGE Table help it here? > Thanks in advance. > > B.R. > Buding > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Is mySQL support replication ??
Yes it does. http://www.mysql.com/doc/R/e/Replication_Implementation.html - Original Message - From: "Alice" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 24, 2002 6:52 PM Subject: Is mySQL support replication ?? > Hi, all, > > May i know is mySQL support replication > > regards, > alice > > /--- \ > > Confidential and/ or privileged information may be contained in this > e-mail and any attachments transmitted with it ('Message'). If you are > not the addressee indicated in this Message (or responsible for > delivery of this Message to such person),you are hereby notified that > any dissemination, distribution, printing or copying of this Message or > any part thereof is prohibited. Please delete this Message if received > in error and advise the sender by return e-mail. Opinions, conclusions > and other information in this Message that do not relate to the > official business of this company shall be understood as neither given > nor endorsed by this company. > > This mail is certified Virus Free by *ProtectNow! (InternetNow Sdn Bhd) > *Scanner Engine powered by Norman Virus Control > > \--/ > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Inserting images (not the location of the images)
At 18:36 -0700 6/24/02, Emma Grant wrote: >Hi All, > >First of all I want to thank you all for all the help that >you have given me throughout the last week. > >I have learnt a great deal, and through your help and the >resources on the interenet I have successfully been able to create >and connect to a database through MySQL on Linux. Create a user for >that database. Inserted and updated values on the command line, and >I have learnt to insert, update and view the data from the database >through web form using CGI. (Thanks to those who taught me how to >check for errors in my scripts) > >Just to think, I didnÄôt even know how to access MySQL last Thursday ò > >But as you expected, here comes my question; > >I need to be able to insert images into the database through a FILE >FIELD on a web form. I have already tried this through a simple form >that I created, but it only inserts the actual location (eg >C:Documents and SettingsAdministratorDesktoppersonal.jpg) of the >file that I am browsing for on my computer. Is there some sort of >syntax that I have to use that converts the image to binary as it >gets ÄúinsertedÄù into the database, and then can be read by any >program (ie, web browsers) as an image when I select it again from >the database through a SELECT query? This really can't be answered without more context. You'll do this with some kind of web script, but what scripting language are you using? >Why would I do this you ask? (read on if you are interested) ò > >I know that many of you are about to tell me to store the images on >my server, and reference the location from my database field. As I >have read many times throughout my research. But I want the ability >for the user to choose the images they want in a database from the >form field. I donÄôt want them to have to use a FTP program to >upload images, and then insert the image location. I want it to be a >one-stop form. That is part of my project. So if anyone can help, >that would be great. > >Emma - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to access mysqladmin from IE?
At 9:42 +0700 6/25/02, Aqua wrote: >Hi guys! Does anyone know how to access mysqladmin from Internet Explorer so >I can view and edit my data. >Please help, thanks. That's a strange request, given that mysqladmin neither displays table data nor allows it to be edited. What do you mean? > >Aqua - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: How to access mysqladmin from IE?
If you installed correctly and it's running then you likely forgot to add the '/' at the end of the phpmyadmin part i.e. youriphere/phpmyadmin/ not yourip or localhost/phpmyadmin. justin -Original Message- From: Aqua [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 7:42 PM To: [EMAIL PROTECTED] Subject: How to access mysqladmin from IE? Hi guys! Does anyone know how to access mysqladmin from Internet Explorer so I can view and edit my data. Please help, thanks. Aqua - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
How to access mysqladmin from IE?
Hi guys! Does anyone know how to access mysqladmin from Internet Explorer so I can view and edit my data. Please help, thanks. Aqua - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
file size limit hitting when "LOAD DATA INFILE"
Hi, all: I use MySQL 3.23.47, RH linux 7.2, file size limit is 4G. When "LOAD DATA INFILE" to a table whose file size is 4G, it fails and mysql_error(...) reports "Lost connection to MySQL server during query". How can I clearly know the failed reason is just hit the 4G file size limit? If the 4G file size limit is hit, I have two ways to resolve it: (1) create a new table and "LOAD DATA INFILE" into this new table. (2) backup this table and clear it and reload. However, these two ways are troubled and not good. Dose some one have a effective way that just "LOAD DATA INFILE" without hitting file size limit? Dose MERGE Table help it here? Thanks in advance. B.R. Buding - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Is mySQL support replication ??
Hi, all, May i know is mySQL support replication regards, alice /---\ Confidential and/ or privileged information may be contained in this e-mail and any attachments transmitted with it ('Message'). If you are not the addressee indicated in this Message (or responsible for delivery of this Message to such person),you are hereby notified that any dissemination, distribution, printing or copying of this Message or any part thereof is prohibited. Please delete this Message if received in error and advise the sender by return e-mail. Opinions, conclusions and other information in this Message that do not relate to the official business of this company shall be understood as neither given nor endorsed by this company. This mail is certified Virus Free by *ProtectNow! (InternetNow Sdn Bhd) *Scanner Engine powered by Norman Virus Control \--/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Inserting images (not the location of the images)
Hi All, First of all I want to thank you all for all the help that you have given me throughout the last week. I have learnt a great deal, and through your help and the resources on the interenet I have successfully been able to create and connect to a database through MySQL on Linux. Create a user for that database. Inserted and updated values on the command line, and I have learnt to insert, update and view the data from the database through web form using CGI. (Thanks to those who taught me how to check for errors in my scripts) Just to think, I didn’t even know how to access MySQL last Thursday ☺ But as you expected, here comes my question; I need to be able to insert images into the database through a FILE FIELD on a web form. I have already tried this through a simple form that I created, but it only inserts the actual location (eg C:Documents and SettingsAdministratorDesktoppersonal.jpg) of the file that I am browsing for on my computer. Is there some sort of syntax that I have to use that converts the image to binary as it gets “inserted” into the database, and then can be read by any program (ie, web browsers) as an image when I select it again from the database through a SELECT query? Why would I do this you ask? (read on if you are interested) ☺ I know that many of you are about to tell me to store the images on my server, and reference the location from my database field. As I have read many times throughout my research. But I want the ability for the user to choose the images they want in a database from the form field. I don’t want them to have to use a FTP program to upload images, and then insert the image location. I want it to be a one-stop form. That is part of my project. So if anyone can help, that would be great. Emma - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 php question
Taylor ... Check out ... http://hotwired.lycos.com/webmonkey/databases/tutorials/tutorial4.html ... or ... http://vtwebwizard.com/tutorials/mysql/ - Original Message - From: "Taylor Lewick" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 24, 2002 1:16 PM Subject: mysql php question Does anyone have some simple sample code using php to access a mySQL database? Could you post it or send someit to me please? Taylor Lewick Unix System Administrator Fortis Benefits 816 881 6073 "Help Wanted. Seeking Telepath..." "You Know where to apply." Please Note The information in this E-mail message is legally privileged and confidential information intended only for the use of the individual(s) named above. If you, the reader of this message, are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward this E-mail message. If you have received this E-mail in error, please notify the sender. Thank you * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Case Sensitivity for CHECK TABLE ??
Mark: Do you have my.ini (or my.cfg) set to ignore case in table names? set-variable = lower_case_table_names=1 Gerald Jensen - Original Message - From: "Mark Weiler" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 24, 2002 5:56 PM Subject: Case Sensitivity for CHECK TABLE ?? Mac OS X mysql 3.23.47 I have a database with a table named: tname. After several inserts, I run CHECK TABLE tname; No errors are reported. I then run CHECK TABLE TNAME; And errors are reported! Which is it? Errors or no errors? Thanks Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: advantages mysqldump -T option
Check this out: http://www.mysql.com/doc/m/y/mysqldump.html According to the above page, -T option creates a table_name.txt file for each given table, with its CREATE TABLE syntax and the data for its content in the file Gurhan - Original Message - From: "Rachael LaPorte Taylor (SSD)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 24, 2002 2:53 PM Subject: advantages mysqldump -T option > Hi folks, > > Currently I'm using mysqldump with the --opt option to backup > databases. I recently discovered the -T option to output to delimited > files. Aside from only being able to run mysqldump on the same machine > as the mysql daemon, are there any other disadvantages or advantages > of using the -T option? > > -- > Rachael LaPorte Taylor > Senior Technology Architect, FedStats > U.S. Census Bureau > Washington DC 20233 > [EMAIL PROTECTED] > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Build errors with 3.23.51
After much testing, I have managed to overcome the limits on file descriptors and such on linux; and have a mysql daemon that is fairly lean and able to support several thousand simultaneous connections. I still, though, would like to see what kind of improvment gcc-3.0.4 makes as opposed to 2.95. This build error that I had before (it misdetected the gethostbyname_r function) still plagues me, and I have been unable to find a work around for it. Can anyone lend assistance? Attached below (they've also come through the list before on this thread) are the relevant lines from my config.log with regards to the gethost* function(s) Thanks On Sat, Jun 22, 2002 at 02:40:38AM -0500, Shane Allen wrote: > configure:12730: checking style of gethost* routines > configure:12773: gcc -c -O -DDBUG_OFF -O3 -felide-constructors -fno-exceptions >-fno-rtti > -fpermissive -I/usr/local/mysql-glibc-2.2.2/include conftest.cc >&5 > gcc: installation problem, cannot exec `cc1plus': No such file or directory > configure:12776: $? = 1 > configure: failed program was: > #line 12750 "configure" > #include "confdefs.h" > #undef inline > #if !defined(SCO) && !defined(__osf__) && !defined(_REENTRANT) > #define _REENTRANT > #endif > #include > #include > #include > #include > #include > #include > int > main () > { > int skr; > struct hostent *foo = gethostbyaddr_r((const char *) 0, > 0, 0, (struct hostent *) 0, (char *) NULL, 0, &skr); return (foo == 0); > ; > return 0; > } > configure:12792: result: other > configure:12813: checking style of gethostname_r routines > configure:12854: gcc -c -O -DDBUG_OFF -O3 -felide-constructors -fno-exceptions >-fno-rtti > -fpermissive -I/usr/local/mysql-glibc-2.2.2/include conftest.cc >&5 > gcc: installation problem, cannot exec `cc1plus': No such file or directory > configure:12857: $? = 1 > configure: failed program was: > #line 12830 "configure" > #include "confdefs.h" > #undef inline > #if !defined(SCO) && !defined(__osf__) && !defined(_REENTRANT) > #define _REENTRANT > #endif > #include > #include > #include > #include > #include > #include > int > main () > { > int skr; > > skr = gethostbyname_r((const char *) 0, > (struct hostent*) 0, (char*) 0, 0, (struct hostent **) 0, &skr); > ; > return 0; > } > configure:12873: result: other > configure:12892: checking 3 argument to gethostname_r routines > configure:12932: gcc -c -O -DDBUG_OFF -O3 -felide-constructors -fno-exceptions >-fno-rtti > -fpermissive -I/usr/local/mysql-glibc-2.2.2/include conftest.cc >&5 > gcc: installation problem, cannot exec `cc1plus': No such file or directory > configure:12935: $? = 1 > configure: failed program was: > #line 12909 "configure" > #include "confdefs.h" > #undef inline > #if !defined(SCO) && !defined(__osf__) && !defined(_REENTRANT) > #define _REENTRANT > #endif > #include > #include > #include > #include > #include > #include > int > main () > { > int skr; > > skr = gethostbyname_r((const char *) 0, (struct hostent*) 0, (struct hostent_data*) >0); > ; > return 0; > } > > > On Sat, Jun 22, 2002 at 03:09:15AM +0200, Jocelyn Fournier wrote: > > Hi, > > > > It seems to be linked with the gethostname_r detection > > > > "checking style of gethostname_r routines... other" > > > > I think you should have the following line instead : > > > > checking style of gethostname_r routines... glibc2 > > > > Can you take a look at the config.log file and tell us what is wrong ? > > > > (in my case I have the following lines : > > > > configure:15261: checking style of gethostname_r routines > > configure:15309: > > gcc -c -O3 -DDBUG_OFF -Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcommen > > t -W -Wchar-subscripts -Wformat -Wparen > > theses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wsign-promo -Wre > > order -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-con > > structors -fno-exceptions -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-poi > > nter -fno-implicit-templates -fno-exceptions -fno-rtti > > -DUSE_MYSYS_NEW -Werror conftest.cc >&5 > > configure:15312: $? = 0 > > configure:15315: test -s conftest.o > > configure:15318: $? = 0 > > configure:15328: result: glibc2 > > > > ) > > > > Regards, > > Jocelyn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Case Sensitivity for CHECK TABLE ??
Mac OS X mysql 3.23.47 I have a database with a table named: tname. After several inserts, I run CHECK TABLE tname; No errors are reported. I then run CHECK TABLE TNAME; And errors are reported! Which is it? Errors or no errors? Thanks Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: (fwd) sorting question
* Cindy > OK, I determined that at least part of the problem was that I ran out > of space in /var/tmp, so I reset TMPDIR to a directory that's 40G in > size an am trying again. But I'd still be very interested in any > comments on the below select statement given the size of everything > involved (eg, an 1800M file output, 79,603,007 entries to be exact). I > would have thought it would be best to have mysql do the sorting > before writing out the file, instead of letting it write it out > unsorted and using an external sort to sort later? Yes? No? Any > comments at all? Hello? > > > Cindy writes: > > > >I wrote earlier: > > > > >select b.id, a.aid, a.wid, a.start, a.length > > >into outfile 'newindex.txt' > > >from wordindex a, wordforms b > > >where a.wordform = b.wordform > > >order by b.id, a.id, a.wid, a.start; Could you provide some more info? The output of "DESCRIBE select b.id, a.aid..." would be very usefull, and also the output of "SHOW CREATE TABLE wordindex" and "SHOW CREATE TABLE wordforms". -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: copying the structure of a table to a new table
At 04:06 PM 6/24/2002, you wrote: >I want to copy the structure of a table to a brand new table, but I >don't want to use phpmyadmin or some other program. I'm looking for the >command line code. > >Anyone have a link to where I can find it? Or, anyone wanna send me >the code? > >Thanks!! > >mysql Phil, This is only half a solution, but it is better than nothing, right? create table newtable select * from oldtable limit 0; This will create a newtable with the same columns as oldtable and newtable will be empty. Alas, the index definitions are not copied over so that will have to be done manually or someone else can offer a suggestion. I was thinking of writing a PHP function to do it. It's not that difficult (I think?!). Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Load problems with 3.23.51
I used the mysql builds myself. Funny thing is that I use your tool 'mytop', which is very cool by the way, to watch things and it pauses for about 5-8 seconds when refreshing with .51 and is almost instant with .47 Sincerely, Steven Roussey http://Network54.com/?pp=e > -Original Message- > As another data point for you, I've got 3.23.51 running on our master > quite well. The difference is that I built it from source (to get a > critical InnoDB patch). I don't recall which compiler the MySQL folks > used (and which glibc), but my source build used Debian Woody's gcc > 2.95.4. > > That could have something to do with it... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: (fwd) sorting question
OK, I determined that at least part of the problem was that I ran out of space in /var/tmp, so I reset TMPDIR to a directory that's 40G in size an am trying again. But I'd still be very interested in any comments on the below select statement given the size of everything involved (eg, an 1800M file output, 79,603,007 entries to be exact). I would have thought it would be best to have mysql do the sorting before writing out the file, instead of letting it write it out unsorted and using an external sort to sort later? Yes? No? Any comments at all? Hello? Cindy writes: > >I wrote earlier: > > >select b.id, a.aid, a.wid, a.start, a.length > >into outfile 'newindex.txt' > >from wordindex a, wordforms b > >where a.wordform = b.wordform > >order by b.id, a.id, a.wid, a.start; > >I've actually sat down and tried this at the mysql command line. >Problem was, I started it at about 11pm last night and it's 1:20pm >today. Not only is it still sitting there, but it hasn't written a >single thing out yet (if I look at the outfile, it's there, but 0 >length). > >For an idea of how large the file is, when the above command is >done without the order by restrictions, I get a file of >the form > >551772 1 1 44 6 >877857 1 1 52 11 >703278 1 1 65 4 >563277 1 1 71 5 >806092 1 1 78 8 >863071 1 1 88 3 >956338 1 1 93 8 >(etc) > >that output takes about three - four hours to create, and its finished >size is > >-rw-r--r-- 1 ctmoore staff1831793634 Jun 22 22:29 newindex.b.txt > >Is mysql unable to handle something this large when it has to sort as >well? Or are there some whizbit things I can do to fine tune this? > >Thanks, >--Cindy > >- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED] >> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > -- Cindy [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: copying the structure of a table to a new table
Other than all previous comments, you can also do , SHOW CREATE TABLE tablename; and then copy+paste it with a different tablename. Gurhan - Original Message - From: "Phil Schwarzmann" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 24, 2002 5:06 PM Subject: copying the structure of a table to a new table > I want to copy the structure of a table to a brand new table, but I > don't want to use phpmyadmin or some other program. I'm looking for the > command line code. > > Anyone have a link to where I can find it? Or, anyone wanna send me > the code? > > Thanks!! > > mysql > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 create FOREIGN KEY restraints on InnoDb tables
* [EMAIL PROTECTED] [...] > The referred to keys are the same type and are indexed (they are [...] > CREATE TABLE genres ( > genre_idSMALLINT NOT NULL PRIMARY KEY, [...] > genre_idSMALLINT, ...does not look the same to me... ;) -- Roger sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: copying the structure of a table to a new table
>From pg 149 of the New Riders Press book "MySQL" by Paul DuBois (ISBN 0-7357-0921-1): CREATE TABLE new_tbl_name SELECT * FROM tbl_name WHERE 1=0 -- Mark P. Hennessy [EMAIL PROTECTED] On Mon, 24 Jun 2002, Phil Schwarzmann wrote: > Date: Mon, 24 Jun 2002 17:06:19 -0400 > From: Phil Schwarzmann <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: copying the structure of a table to a new table > > I want to copy the structure of a table to a brand new table, but I > don't want to use phpmyadmin or some other program. I'm looking for the > command line code. > > Anyone have a link to where I can find it? Or, anyone wanna send me > the code? > > Thanks!! > > mysql > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: copying the structure of a table to a new table
Hello. On Mon 2002-06-24 at 17:06:19 -0400, [EMAIL PROTECTED] wrote: > I want to copy the structure of a table to a brand new table, but I > don't want to use phpmyadmin or some other program. I'm looking for the > command line code. > > Anyone have a link to where I can find it? Or, anyone wanna send me > the code? I think there is no automatic, MySQL-only way to do that. You can use CREATE TABLE newtable SELECT * FROM oldtable ... but this will lose indexes and maybe get other things different (like varchar vs. char). The method I use with UNIX shell is mysqldump -d mydb oldtable | sed -e 's/oldtable/newtable/' | mysql mydb Of course, "oldtable" should be unique, else the sed regexp should contain some safety delimiters. HTH, Benjamin. -- [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: copying the structure of a table to a new table
mysqldump -d database table > existingTable.sql Then edit existingTable.sql, change the name of the table, save it as newTable.sql mysql database < newTable.sql You could do : mysqldump -d database table | sed | mysql database but I'm not an expert on regex. :) =C+ -Original Message- From: Phil Schwarzmann [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 4:06 PM To: [EMAIL PROTECTED] Subject: copying the structure of a table to a new table I want to copy the structure of a table to a brand new table, but I don't want to use phpmyadmin or some other program. I'm looking for the command line code. Anyone have a link to where I can find it? Or, anyone wanna send me the code? Thanks!! mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: bug in 3.23.51 for windows ?
Victoria Reznichenko wrote: > > Brandon, > Saturday, June 22, 2002, 9:00:49 PM, you wrote: > > BM> Is there any particular reason that anyone knows of that would prevent > BM> mysql 3.23.51 for windows from working upon the execution of the SHOW > BM> STATUS FROM tablename query? > > BM> In Linux it works fine, in windows it crashes mysqld with an illegal op. > BM> Any other SHOW command works but the one I really need for a PHP app to > BM> work. > > There is no command SHOW STATUS FROM in the MySQL. You can use SHOW > TABLE STATUS: > http://www.mysql.com/doc/S/H/SHOW_TABLE_STATUS.html > > my mistake, SHOW TABLE STATUS is what I meant. But anyway I found the problem so this is no longer an issue. My db was created with 3.21.x and I believe SHOW TABLE STATUS wasn't developed until 3.23.x so I recreated my db using 3.23.51 and the command worked w/o crashing mysqld. I'm assuming the fact it was created with an older version was the problem; at the very least the new version creating the db solved whatever was 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
copying the structure of a table to a new table
I want to copy the structure of a table to a brand new table, but I don't want to use phpmyadmin or some other program. I'm looking for the command line code. Anyone have a link to where I can find it? Or, anyone wanna send me the code? Thanks!! mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Binary data mysqldump and restore.
If I remember correctly from the manual, you can dump your data generating the SQL statements (this is what you are doing) and your file will have a bunch of INSERTS. Your problem is that those inserts will have something like SET YourBinaryField = 'a-bunch-of-characters'. The problem is that some of the binary data could make the insert impossible to be executed. What I would try is to export the data as a delimited file, then you will have to files, one with your database structure (that you will run first) and another one with the data (delimited by something). Take a look on the manual about this and good luck! --- "Mark Williams (MWP)" <[EMAIL PROTECTED]> wrote: > Hi all... > > !! First, can you CC to [EMAIL PROTECTED], as > im not on the mailing list. > > I have a few tables which are storing a few MB of > binary data (like jpegs). > I can dump the db fine using mysqldump, but on doing > a "mysql ... < dumpfile" i get many errors, as it > seems mysql isnt accepting the binary data in the > dump file. > > I get hundreds of errors like: > ERROR: > Unknown command '\Z'. > ERROR: > Unknown command '\0'. > ERROR: > Unknown command '\Z'. > ERROR: > Unknown command '\0'. > ERROR: > Unknown command '\"'. > ERROR 1064: You have an error in your SQL syntax > near 'GIF89a2\02\0÷ÿ\0\0\0\0ÀÀÀ\0\0 > >\Z\0\Z 0\" > INSE' at line 1 > Query OK, 0 rows affected (0.00 sec) > > Query OK, 1 row affected (0.01 sec) > > So how do i do this? > > Thanks, > MWP > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list > archive) > > 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!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.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: RecordCount
Some database providers implementation always return -1 no matter the amount of records is returned. That happens to ADO too for certain cursors. The best way to go to count records is Count(*), prepare a query like Select count(MyField) from MyTable Where ... and then get the value. I hope it helps. Good Luck! --- Peter Stöcker <[EMAIL PROTECTED]> wrote: > Hi there! > > I'm using MySQL with Delphi 5. > > After running a query i get a recordcount of -1. But > when I check the result there are records. > > Can anybody help me? > > > Thanks, > peter > __ > FreeMail in der Premiumversion! Mit mehr Speicher, > mehr Leistung, mehr > Erlebnis und mehr Pramie. Jetzt unter > http://club.web.de/?mc=021105 > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list > archive) > > 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!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.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: Load problems with 3.23.51
Hi! I just ran the standard perl run-all-tests --small-test --small-tables --create-options=type=innodb on 3.23.49a and an in-house prerelease of 3.23.51, on Linux 2.4.16. The times were essentially the same. 3.23.50 and .51 are almost identical in source code. But as we remember, 3.23.51 was built by a new build master using a new build procedure. There may be some subtle change in glibc which only demonstrates itself under certain load or platform. Regards, Heikki Innobase Oy - Original Message - From: "Sinisa Milivojevic" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Monday, June 24, 2002 4:14 PM Subject: Re: Load problems with 3.23.51 > Jeremy Zawodny writes: > > On Sat, Jun 22, 2002 at 05:25:59PM -0700, Steven Roussey wrote: > > > > As another data point for you, I've got 3.23.51 running on our master > > quite well. The difference is that I built it from source (to get a > > critical InnoDB patch). I don't recall which compiler the MySQL folks > > used (and which glibc), but my source build used Debian Woody's gcc > > 2.95.4. > > > > That could have something to do with it... > > > > 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.51: up 24 days, processed 523,371,775 queries (248/sec. avg) > > > > Using 2.95.* or 3.* is just fine, with proper configuration, as > explained in our fine manual. > > -- > 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 > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 php question
The one at www.php.net -Original Message- From: Taylor Lewick [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 1:50 PM To: [EMAIL PROTECTED] Subject: Re: mysql php question gotcha, thanks, which manual is that? Taylor Lewick Unix System Administrator Fortis Benefits 816 881 6073 "Help Wanted. Seeking Telepath..." "You Know where to apply." >>> [EMAIL PROTECTED] 06/24/02 01:39PM >>> in the php manual in the section of functions about mysql, it has a few examples. \n"; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { print "\t\n"; foreach ($line as $col_value) { print "\t\t$col_value\n"; } print "\t\n"; } print "\n"; /* Free resultset */ mysql_free_result($result); /* Closing connection */ mysql_close($link); ?> On Monday 24 June 2002 1:16, you wrote: > Does anyone have some simple sample code using php to access a mySQL > database? > > Could you post it or send someit to me please? > > Taylor Lewick > Unix System Administrator > Fortis Benefits > 816 881 6073 > > "Help Wanted. Seeking Telepath..." > "You Know where to apply." > > > Please Note > The information in this E-mail message is legally privileged > and confidential information intended only for the use of the > individual(s) named above. If you, the reader of this message, > are not the intended recipient, you are hereby notified that > you should not further disseminate, distribute, or forward this > E-mail message. If you have received this E-mail in error, > please notify the sender. Thank you > * > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> Trouble > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- mysql, sql, query Please Note The information in this E-mail message is legally privileged and confidential information intended only for the use of the individual(s) named above. If you, the reader of this message, are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward this E-mail message. If you have received this E-mail in error, please notify the sender. Thank you * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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-do logging feature with InnoDB: is it possible ?
Bert, - Original Message - From: "Bert VdB" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Monday, June 24, 2002 11:09 AM Subject: RE: Re-do logging feature with InnoDB: is it possible ? > Hello everybody, > > I have a small question regarding to the Mysql-InnoDB-tables : > > "Is it possible to use an Oracle-like 're-do logging' feature with InnoDB" ? > > This means more or less taking regular consistent backups of your database, > and then in case of corruption, you restore the latest consistent > database-backup and > tell the server to re-apply the logs for a certain time-span. you must use the 'binlog' of MySQL to do this. Add [mysqld] log-bin to my.cnf. To do the roll-forward from a backup you can use the mysqlbinlog program to pipe in the SQL statements in the binlog files: mysqlbinlog --position=766567578 yourhostname-bin.123 | mysql InnoDB Hot Backup (a non-free program) uses the redo log files of InnoDB (the ib_logfile files) in a similar fashion to construct a consistent backup of a running database. But to do the roll-forward from the backup you use the MySQL binlog files. > I haven't found any information on this feature for InnoDB, but I still > would like to consult you guys > before passing a definitive NO CAN DO to the managament of the project here > :) > > > Tnx for you input and time, > CB. Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Load problems with 3.23.51
On Mon, Jun 24, 2002 at 12:43:47PM -0700, Jeremy Zawodny wrote: > > I will second this. > > > > I attempted an upgrade from 3.23.50 to 3.23.51 and hit immediate > > performance problems. I tried for about 20 minutes to see what was > > causing it but to no avail. I reverted to 3.23.50. > > > > At first I thought it was my fault so I decided not to report it > > until I did some further research. > > What OS are you using? And did you use the pre-built binaries or > build from source? Stock Red Hat 7.2. Pre-built mysql-max binaries. InnoDB tables. -- Michael Bacarella | Netgraft Corporation | 545 Eighth Ave #401 Systems Analysis | New York, NY 10018 Technical Support | 212 946-1038 | 917 670-6982 Managed Services | [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: Load problems with 3.23.51
On Mon, Jun 24, 2002 at 03:11:53PM -0400, Michael Bacarella wrote: > I will second this. > > I attempted an upgrade from 3.23.50 to 3.23.51 and hit immediate > performance problems. I tried for about 20 minutes to see what was > causing it but to no avail. I reverted to 3.23.50. > > At first I thought it was my fault so I decided not to report it > until I did some further research. What OS are you using? And did you use the pre-built binaries or build from source? -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.51: up 25 days, processed 549,473,907 queries (246/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
my_gui: a gui module for MySQL (using Python) First public release(0.24)
D. H. Craig, CSM __ This is the first public release for "my_gui". my_gui.py is a simple Grafic User Interface for MySql. It can be used as a Python module to create your own MySQL interface. Sorry, no documentation yet download it at http://www.prosa.it/projects/projects MAS! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Load problems with 3.23.51
I will second this. I attempted an upgrade from 3.23.50 to 3.23.51 and hit immediate performance problems. I tried for about 20 minutes to see what was causing it but to no avail. I reverted to 3.23.50. At first I thought it was my fault so I decided not to report it until I did some further research. -M On Mon, Jun 24, 2002 at 11:52:47AM -0700, Steven Roussey wrote: > I tried 'skip-name-resolve' but it had no impact. :( So it may have > nothing to do with name resolution. > > Here are the results in file RUN-mysql-Linux_2.4.16_0.13smp_i686: > > > I'm going to run the tests on .47 next to see if there is any > difference. > > > Sincerely, > Steven Roussey > http://Network54.com/?pp=e > > > -Original Message- > > From: Michael Widenius [mailto:[EMAIL PROTECTED]] > > Sent: Monday, June 24, 2002 4:24 am > > To: [EMAIL PROTECTED] > > Cc: Steven Roussey; [EMAIL PROTECTED] > > Subject: Re: Load problems with 3.23.51 > > > > > > Hi! > > > > > "Jeremy" == Jeremy Zawodny <[EMAIL PROTECTED]> writes: > > > > Jeremy> On Sat, Jun 22, 2002 at 05:25:59PM -0700, Steven Roussey > wrote: > > >> Hi all, > > >> > > >> I have MySQL 3.23.47 running on our sever. I skipped 48 through 50 > and > > >> tried 51. No dice. It does not handle load, CPU and the load > average go > > >> through the roof. I'm using Red Hat Linux 7.2 and the official > mysql > > >> binaries. It appears to be slow to connect, causing 0.5 to 1.0 > second > > >> delay on connection. Using persistent connections from PHP does not > > make > > >> much of a difference. I thought it might be the hostname lookup > changes > > >> so I chose skip-grant-tables. This doesn't actually skip the > hostname > > >> lookup though and had no effect. > > >> > > >> Most queries are shorter than 1 second so this problem causes > > >> catastrophic problems by making queries last a multiple times > longer, > > >> which make the number of concurrent queries jump exponentially. > This is > > >> a bad thing. And sadly makes 3.23.51 unusable. > > >> > > >> Does anyone else note these types of issues? > > > > Jeremy> As another data point for you, I've got 3.23.51 running on our > > master > > Jeremy> quite well. The difference is that I built it from source (to > get > > a > > Jeremy> critical InnoDB patch). I don't recall which compiler the > MySQL > > folks > > Jeremy> used (and which glibc), but my source build used Debian > Woody's > > gcc > > Jeremy> 2.95.4. > > > > We are using gcc 2.95.3 and a patched glibc, the later one that we > > used in many builds before. > > > > This is the first email I got that 3.23.51 would be slow. > > > > Steven, could you try to run the MySQL benchmark suite on your machine > > and post me the results ? > > > > cd sql-bench > > perl run-all-tests --log > > > > The file I am interested in is the summary file named 'output/RUN-*' > > > > Regards, > > Monty > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > -- Michael Bacarella | Netgraft Corporation | 545 Eighth Ave #401 Systems Analysis | New York, NY 10018 Technical Support | 212 946-1038 | 917 670-6982 Managed Services | [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
my_gui: a gui module for MySQL (using Python) First public release (0.24)
This is the first public release for "my_gui". my_gui.py is a simple Grafic User Interface for MySql. It can be used as a Python module to create your own MySQL interface. Sorry, no documentation yet download it at http://www.prosa.it/projects/projects MAS! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Load problems with 3.23.51
I tried the skip-name-resolve and it had no effect. So there goes my hypothesis. Here are the results from test: Benchmark DBD suite: 2.14 Date of test:2002-06-24 11:19:19 Running tests on:Linux 2.4.16-0.13smp i686 Arguments: Comments: Limits from: Server version: MySQL 3.23.51 log alter-table: Total time: 134 wallclock secs ( 0.35 usr 0.03 sys + 0.00 cusr 0.00 csys = 0.38 CPU) ATIS: Total time: 15 wallclock secs ( 3.87 usr 1.62 sys + 0.00 cusr 0.00 csys = 5.49 CPU) big-tables: Total time: 13 wallclock secs ( 3.39 usr 2.85 sys + 0.00 cusr 0.00 csys = 6.24 CPU) connect: Total time: 45 wallclock secs (18.00 usr 8.45 sys + 0.00 cusr 0.00 csys = 26.45 CPU) create: Total time: 119 wallclock secs ( 7.22 usr 2.13 sys + 0.00 cusr 0.00 csys = 9.35 CPU) insert: Total time: 1162 wallclock secs (361.66 usr 103.25 sys + 0.00 cusr 0.00 csys = 464.91 CPU) select: Total time: 599 wallclock secs (44.00 usr 8.76 sys + 0.00 cusr 0.00 csys = 52.76 CPU) wisconsin: Total time: 9 wallclock secs ( 2.01 usr 1.19 sys + 0.00 cusr 0.00 csys = 3.20 CPU) All 8 test executed successfully Totals per operation: Operation seconds usr sys cpu tests alter_table_add 75.000.240.010.25 992 alter_table_drop 56.000.070.000.07 496 connect5.002.441.003.44 1 connect+select_1_row 8.004.511.305.81 1 connect+select_simple 7.003.551.254.80 1 count 19.000.020.000.02 100 count_distinct19.000.440.030.47 1000 count_distinct_2 20.000.330.060.39 1000 count_distinct_big52.002.411.553.96 120 count_distinct_group 30.000.800.190.99 1000 count_distinct_group_on_key 18.000.290.040.33 1000 count_distinct_group_on_key_parts 30.000.760.210.97 1000 count_distinct_key_prefix 16.000.290.020.31 1000 count_group_on_key_parts 17.000.570.120.69 1000 count_on_key 171.00 13.221.67 14.89 50100 create+drop6.001.700.542.24 1 create_MANY_tables76.002.280.422.70 1 create_index 2.000.000.000.00 8 create_key+drop7.001.540.592.13 1 create_table 0.000.000.000.00 31 delete_all 4.000.000.000.00 12 delete_all_many_keys 22.000.010.000.01 1 delete_big 0.000.000.000.00 1 delete_big_many_keys 22.000.010.000.01 128 delete_key 2.000.360.260.62 1 drop_index 1.000.000.000.00 8 drop_table 0.000.000.000.00 28 drop_table_when_MANY_tables3.000.390.150.54 1 insert72.00 15.108.95 24.05 350768 insert_duplicates 16.003.272.625.89 10 insert_key60.007.622.77 10.39 10 insert_many_fields 4.000.320.060.38 2000 insert_select_1_key2.000.000.000.00 1 insert_select_2_keys 3.000.000.000.00 1 min_max 10.000.020.000.02 60 min_max_on_key83.00 16.112.67 18.78 85000 multiple_value_insert 2.000.560.070.63 10 order_by_big 21.006.834.43 11.26 10 order_by_big_key 13.007.254.73 11.98 10 order_by_big_key2 12.007.024.38 11.40 10 order_by_big_key_desc 13.007.294.50 11.79 10 order_by_big_key_diff 18.007.054.27 11.32 10 order_by_big_key_prefix 11.006.874.55 11.42 10 order_by_key2_diff 1.000.790.341.13 500 order_by_key_prefix2.000.540.220.76 500 order_by_range 2.000.470.200.67 500 outer_join20.000.000.000.00 10 outer_join_found 20.000.000.000.00 10 outer_join_not_found 13.000.000.000.00 500 outer_join_on_key 15.000.000.000.00 10 select_1_row 2.000.390.260.65 1 select_2_rows 2.000.180.320.50 1 select_big
advantages mysqldump -T option
Hi folks, Currently I'm using mysqldump with the --opt option to backup databases. I recently discovered the -T option to output to delimited files. Aside from only being able to run mysqldump on the same machine as the mysql daemon, are there any other disadvantages or advantages of using the -T option? -- Rachael LaPorte Taylor Senior Technology Architect, FedStats U.S. Census Bureau Washington DC 20233 [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: Load problems with 3.23.51
I tried 'skip-name-resolve' but it had no impact. :( So it may have nothing to do with name resolution. Here are the results in file RUN-mysql-Linux_2.4.16_0.13smp_i686: I'm going to run the tests on .47 next to see if there is any difference. Sincerely, Steven Roussey http://Network54.com/?pp=e > -Original Message- > From: Michael Widenius [mailto:[EMAIL PROTECTED]] > Sent: Monday, June 24, 2002 4:24 am > To: [EMAIL PROTECTED] > Cc: Steven Roussey; [EMAIL PROTECTED] > Subject: Re: Load problems with 3.23.51 > > > Hi! > > > "Jeremy" == Jeremy Zawodny <[EMAIL PROTECTED]> writes: > > Jeremy> On Sat, Jun 22, 2002 at 05:25:59PM -0700, Steven Roussey wrote: > >> Hi all, > >> > >> I have MySQL 3.23.47 running on our sever. I skipped 48 through 50 and > >> tried 51. No dice. It does not handle load, CPU and the load average go > >> through the roof. I'm using Red Hat Linux 7.2 and the official mysql > >> binaries. It appears to be slow to connect, causing 0.5 to 1.0 second > >> delay on connection. Using persistent connections from PHP does not > make > >> much of a difference. I thought it might be the hostname lookup changes > >> so I chose skip-grant-tables. This doesn't actually skip the hostname > >> lookup though and had no effect. > >> > >> Most queries are shorter than 1 second so this problem causes > >> catastrophic problems by making queries last a multiple times longer, > >> which make the number of concurrent queries jump exponentially. This is > >> a bad thing. And sadly makes 3.23.51 unusable. > >> > >> Does anyone else note these types of issues? > > Jeremy> As another data point for you, I've got 3.23.51 running on our > master > Jeremy> quite well. The difference is that I built it from source (to get > a > Jeremy> critical InnoDB patch). I don't recall which compiler the MySQL > folks > Jeremy> used (and which glibc), but my source build used Debian Woody's > gcc > Jeremy> 2.95.4. > > We are using gcc 2.95.3 and a patched glibc, the later one that we > used in many builds before. > > This is the first email I got that 3.23.51 would be slow. > > Steven, could you try to run the MySQL benchmark suite on your machine > and post me the results ? > > cd sql-bench > perl run-all-tests --log > > The file I am interested in is the summary file named 'output/RUN-*' > > Regards, > Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 php question
gotcha, thanks, which manual is that? Taylor Lewick Unix System Administrator Fortis Benefits 816 881 6073 "Help Wanted. Seeking Telepath..." "You Know where to apply." >>> [EMAIL PROTECTED] 06/24/02 01:39PM >>> in the php manual in the section of functions about mysql, it has a few examples. \n"; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { print "\t\n"; foreach ($line as $col_value) { print "\t\t$col_value\n"; } print "\t\n"; } print "\n"; /* Free resultset */ mysql_free_result($result); /* Closing connection */ mysql_close($link); ?> On Monday 24 June 2002 1:16, you wrote: > Does anyone have some simple sample code using php to access a mySQL > database? > > Could you post it or send someit to me please? > > Taylor Lewick > Unix System Administrator > Fortis Benefits > 816 881 6073 > > "Help Wanted. Seeking Telepath..." > "You Know where to apply." > > > Please Note > The information in this E-mail message is legally privileged > and confidential information intended only for the use of the > individual(s) named above. If you, the reader of this message, > are not the intended recipient, you are hereby notified that > you should not further disseminate, distribute, or forward this > E-mail message. If you have received this E-mail in error, > please notify the sender. Thank you > * > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> Trouble > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- mysql, sql, query Please Note The information in this E-mail message is legally privileged and confidential information intended only for the use of the individual(s) named above. If you, the reader of this message, are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward this E-mail message. If you have received this E-mail in error, please notify the sender. Thank you * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql php question
Not really a simplistic one, but simple to set-up and use: http://phpnuke.org Very nice dynamic php/mysql based web site you can download and install. Larry Irwin CCA Medical - Original Message - From: "Taylor Lewick" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 24, 2002 2:16 PM Subject: mysql php question Does anyone have some simple sample code using php to access a mySQL database? Could you post it or send someit to me please? Taylor Lewick Unix System Administrator Fortis Benefits 816 881 6073 "Help Wanted. Seeking Telepath..." "You Know where to apply." Please Note The information in this E-mail message is legally privileged and confidential information intended only for the use of the individual(s) named above. If you, the reader of this message, are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward this E-mail message. If you have received this E-mail in error, please notify the sender. Thank you * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 php question
Does anyone have some simple sample code using php to access a mySQL database? Could you post it or send someit to me please? Taylor Lewick Unix System Administrator Fortis Benefits 816 881 6073 "Help Wanted. Seeking Telepath..." "You Know where to apply." Please Note The information in this E-mail message is legally privileged and confidential information intended only for the use of the individual(s) named above. If you, the reader of this message, are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward this E-mail message. If you have received this E-mail in error, please notify the sender. Thank you * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mySQL query help please
[snip] So if the end result is to have the records selected appended to the Customer_Equipment table, I have to make a temporary table based on the characteristics of the Customer_Equipment table... then insert from that temporary table. Correct? [/snip] BINGO! Goofy rules can be frustrating :) Jay sql, mysql, query (goofy spam rule) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mySQL query help please
Greetings Jay: RE: mySQL query help please I love rules that don't make sense ;-) So if the end result is to have the records selected appended to the Customer_Equipment table, I have to make a temporary table based on the characteristics of the Customer_Equipment table... then insert from that temporary table. Correct? Thank you. At 12:29 PM 6/24/2002 -0500, you wrote: >[snip] >INSERT INTO Customer_Equipment SELECT Customer.ID, Server_ID, >Configuration, Equipment_Type, Group_ID, Location, Rack_Location, >Network_Status_Name, Creator_ID, Primary_IP_Address FROM >Customer_Equipment, Customer WHERE SUBSTRING(Server_ID, 5,4) = >Customer.User_ID; > >The select statement works perfectly, but when I try to combine the select >statement with an INSERT INTO statement (I've done this in the past), I get >the error message: > > ERROR 1066: Not unique table/alias: 'Customer_Equipment' >[/snip] > >You cannot INSERT into a table that you have SELECT 'ed from; > >INSERT INTO Customer_Equipment SELECT ... >FROM Customer_Equipment, Customer Peter M. Perchansky, President/CEO Dynamic Net, Inc. Helping companies do business on the Net 420 Park Road; Suite 201 Wyomissing PA 19610 Non-Toll Free: 1-610-736-3795 Personal Email: [EMAIL PROTECTED] Company Email: [EMAIL PROTECTED] Web:http://www.dynamicnet.net/ http://www.manageddedicatedservers.com/ http://www.wemanageservers.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can't create FOREIGN KEY restraints on InnoDb tables
>Description: In CREATE TABLE, column-spec REFERENCES does nothing, as described in the documentation. If FOREIGN KEY (x) REFERENCES othertable(y) is added to the table, as described in the documentation: http://www.mysql.com/doc/S/E/SEC446.html I always get an error like this: ERROR 1005 at line 23: Can't create table './MP3c/xtracks.frm' (errno: 150) I can create the table without FOREIGN KEY restraints. If I try to add them via ALTER TABLE, I get: ERROR 1005 at line 35: Can't create table './MP3c/#sql-8c1_e.frm' (errno: 150) The referred to keys are the same type and are indexed (they are primary keys). The only difference is that they are AUTO_INCREMENT, but even without AUTO_INCREMENT, the same problem occurs. Wiping out the entire InnoDB database and restarting does not make a difference, since the above page says that recreating tables with the same name can be a problem. I've also tried changing the database name and table name, to rule out any previous definitions that might be lying around. >How-To-Repeat: CREATE TABLE artists ( artist_id INTEGER UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, artist VARCHAR (32) NOT NULL UNIQUE ) type=InnoDB; CREATE TABLE albums ( album_idINTEGER UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, album VARCHAR (32) NOT NULL, yearYEAR ) type=InnoDB; CREATE INDEX by_album ON albums(album); CREATE TABLE genres ( genre_idSMALLINT NOT NULL PRIMARY KEY, genre VARCHAR (32) NOT NULL ) type=InnoDB; CREATE TABLE tracks ( track_idINTEGER UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, artist_id INTEGER UNSIGNED NOT NULL, album_idINTEGER UNSIGNED NOT NULL, track SMALLINT, title VARCHAR (32) NOT NULL, genre_idSMALLINT, comment VARCHAR (32) NOT NULL DEFAULT '', filenameVARCHAR (255) NOT NULL, FOREIGN KEY (artist_id) REFERENCES artists(artist_id), FOREIGN KEY (album_id) REFERENCES albums(album_id), FOREIGN KEY (genre_id) REFERENCES genres(genre_id) ) type=InnoDB; CREATE UNIQUE INDEX album_tracks ON tracks(album_id, track); CREATE INDEX by_title ON tracks(title); >Fix: Postgre^H^H^H^H^H^H^HNone. >Submitter-Id: >Originator:Andy Dustman >Organization: > >MySQL support: none >Synopsis: FOREIGN KEYS don't work >Severity: serious >Priority: medium >Category: mysql >Class: sw-bug >Release: mysql-3.23.51 (Official MySQL RPM) >Environment: System: Linux 4.0.0.10.in-addr.arpa 2.4.18 #2 Tue May 28 17:55:48 EDT 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.3 2.96-110) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 May 7 17:53 /lib/libc.so.6 -> libc-2.2.5.so -rwxr-xr-x1 root root 1260480 Apr 15 09:44 /lib/libc-2.2.5.so -rw-r--r--1 root root 2310808 Apr 15 10:02 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 15 09:55 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --with-other-libc=/usr/local/mysql-glibc --without-berkeley-db --without-innodb --enable-assembler --enable-local-infile --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM' CC=gcc 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' CXX=gcc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mySQL query help please
[snip] INSERT INTO Customer_Equipment SELECT Customer.ID, Server_ID, Configuration, Equipment_Type, Group_ID, Location, Rack_Location, Network_Status_Name, Creator_ID, Primary_IP_Address FROM Customer_Equipment, Customer WHERE SUBSTRING(Server_ID, 5,4) = Customer.User_ID; The select statement works perfectly, but when I try to combine the select statement with an INSERT INTO statement (I've done this in the past), I get the error message: ERROR 1066: Not unique table/alias: 'Customer_Equipment' [/snip] You cannot INSERT into a table that you have SELECT 'ed from; INSERT INTO Customer_Equipment SELECT ... FROM Customer_Equipment, Customer HTH! Jay sql, mysql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mySQL query help please
Greetings: RE: mySQL query help please INSERT INTO Customer_Equipment SELECT Customer.ID, Server_ID, Configuration, Equipment_Type, Group_ID, Location, Rack_Location, Network_Status_Name, Creator_ID, Primary_IP_Address FROM Customer_Equipment, Customer WHERE SUBSTRING(Server_ID, 5,4) = Customer.User_ID; The select statement works perfectly, but when I try to combine the select statement with an INSERT INTO statement (I've done this in the past), I get the error message: ERROR 1066: Not unique table/alias: 'Customer_Equipment' What does this error message mean, and how should I accomplish my insert into statement so I can use the results of the select statement above? Thank you. Peter M. Perchansky, President/CEO Dynamic Net, Inc. Helping companies do business on the Net 420 Park Road; Suite 201 Wyomissing PA 19610 Non-Toll Free: 1-610-736-3795 Personal Email: [EMAIL PROTECTED] Company Email: [EMAIL PROTECTED] Web:http://www.dynamicnet.net/ http://www.manageddedicatedservers.com/ http://www.wemanageservers.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Manual: mis-spelled variable
Hi, I came across this problem: where the manual describes Fulltext Fine-tuning it says: * Minimal length of word to be indexed is defined by MySQL variable `ft_min_word_length'. *Note SHOW VARIABLES::. Change it to the value you prefer, and rebuild your `FULLTEXT' indexes. This does not work! It appears that the name of this variable is 'ft_min_word_len' instead. Thomas Spahni - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Load problems with 3.23.51
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > I have MySQL 3.23.47 running on our sever. I skipped 48 through 50 and > tried 51. No dice. It does not handle load, CPU and the load average go > through the roof. I'm using Red Hat Linux 7.2 and the official mysql > binaries. It appears to be slow to connect, causing 0.5 to 1.0 second > delay on connection. We have had the exact opposite reaction on our RH 7.2 boxes. .49 would consistently crash every hour under load (the innodb high avail_cc thingy). But since upgrading to .51 our load has been down, and we've only restarted once, to enact some .cnf changes. For us, the upgrade has been a godsend. This is using the official binaries (not RPM if that makes a difference at all). Jayce^ -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE9F0YmoTgdT9hhlCIRAtTSAJ49rm81dRjAfLq7qWQbyzXJTccWQgCfR/K9 rsRDVWUd3UssqzMcvk1RB64= =C/uf -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Thanks for the solution of Chinese character problem
Dear Monty, At the beginning, I missed doing the step of setting default character-set. After I have done what you said about setting default character set, the correct chinese characters are stored in mysql database. Thank you very much! Best regards, Henry. >From: Michael Widenius <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: "henry lee" <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: Chinese character problem Date: Mon, 24 Jun 2002 14:30:44 +0300 > > >Hi! > > > "henry" == henry lee <[EMAIL PROTECTED]> writes: > >henry> Dear professional people, >henry>When I write a program to store the (Big5) Chinese characters >¯S³\¸gÀç >henry> into mysql database through the mysql ODBC driver, >henry> the original chinese characters change into another characters >¯S³¸gÀç >henry> in mysql database. > >What command did you use for storing data ? > >If you did this with an INSERT SQL statement, you have to escape the \ >ESCAPE character. > >This should however work if you are using prepared statements, as in >this case the MyODBC driver will handle the escaping of your data. > >Have you started the mysqld server with --default-character-set=big5 ? > >Regards, >Monty > >-- >For technical support contracts, goto https://order.mysql.com/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO >/_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ><___/ www.mysql.com _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Netsde Query
you don't. Check the manual. Nested queries are not yet supported. (4.1?) =C= -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 20, 2002 1:53 AM To: [EMAIL PROTECTED] Subject: Netsde Query Hello everybody! I am using mysql-4.0.1-alpha on windows 2000 professional How to exceute nested query in MySql select aeVcharEventId from alarmescalation where aeDtimeTimeStamp = (select max(aeDtimeTimeStamp) from alarmescalation) This query gives an error you have an in your Sql syntax near '(select max(aeDtimeTimeStamp) from alarmescalation)' Regards Harish Varandani - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
RecordCount
Hi there! I'm using MySQL with Delphi 5. After running a query i get a recordcount of -1. But when I check the result there are records. Can anybody help me? Thanks, peter __ FreeMail in der Premiumversion! Mit mehr Speicher, mehr Leistung, mehr Erlebnis und mehr Pramie. Jetzt unter http://club.web.de/?mc=021105 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Netsde Query
Hello everybody! I am using mysql-4.0.1-alpha on windows 2000 professional How to exceute nested query in MySql select aeVcharEventId from alarmescalation where aeDtimeTimeStamp = (select max(aeDtimeTimeStamp) from alarmescalation) This query gives an error you have an in your Sql syntax near '(select max(aeDtimeTimeStamp) from alarmescalation)' Regards Harish Varandani - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
New Manager
Hi, There are a new MySQL Database Manager. Try this site: http://geocities.yahoo.com.br/burbello/ doesn't need to install, just download and execute. Regards Alexander ___ Copa 2002 Yahoo! - Patrocinador oficial da Copa do Mundo da FIFA 2002 http://br.sports.yahoo.com/fifaworldcup/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Chinese character error
Your string contains special characters, and must be properly escaped before storing. Use the appropriate string escaping function in your language ( if it exists ) or write a routine to escape them for you before storing them. The manual lists the special characters. henry lee wrote: > Dear professional people, > > When I write a program to store the (Big5) Chinese characters ¯S³\¸gÀç > into mysql database through the mysql ODBC driver, > the original chinese characters change into another characters ¯S³¸gÀç > in mysql database. > > On the other hand, I have tried the program to store the (Big5) Chinese > characters into another database through another ODBC driver, it is > correct. > The chinese characters remain the same. > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem importing data from SQL server 2000 to mysql
Hi guys, I want to migrate data from SQL Server 2000 to Mysql.I have two problems. First is easy one, First problem is to migrate big fields which had type varchar(7900) or so I tried using Text datatype of mysql, is that the right one or I should have used BLOB. That field doesnt contain any image informtaion or any special information. Only at one place it stores data which is a "email" I am using command LOAD DATA INFILE "c:/mysql/roma/mailmessagetext_table.txt" INTO TABLE mailmessagetext_table; Data which i export from sql server is tab dilimited . Another problem is, For the field messagetext - varchar(7900), it doesnt migrate the only migrated few characters, as this field stores emails. so it has some enter chanracters. SQL server saves them as a special character. But when i try to import, then Mysql cuts the field at that special character, and does not take rest of string. e.g., if i have data like dear roma, how are you thanks abc it will import only "dear roma," as it will find a enter character at the end. I tried using BLob field instead. I tried exporting data using pipe delimited , that does not work either. Please help Thanks Roma - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Load problems with 3.23.51
Jeremy Zawodny writes: > On Sat, Jun 22, 2002 at 05:25:59PM -0700, Steven Roussey wrote: > > As another data point for you, I've got 3.23.51 running on our master > quite well. The difference is that I built it from source (to get a > critical InnoDB patch). I don't recall which compiler the MySQL folks > used (and which glibc), but my source build used Debian Woody's gcc > 2.95.4. > > That could have something to do with it... > > 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.51: up 24 days, processed 523,371,775 queries (248/sec. avg) > Using 2.95.* or 3.* is just fine, with proper configuration, as explained in our fine manual. -- 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: UDF on win2k??
I know version 4.0.1 does. I use Delphi 6 to write my UDF's for it. mike -Original Message- From: Inandjo Taurel [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 23, 2002 9:20 PM To: [EMAIL PROTECTED] Subject: UDF on win2k?? hi, i checked the manual, but i want a confirmation here: Mysql for window doesn't have UDF, right? _ 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
string compare problem with single quote in string
I am comparing songnames from two tables to find a match. My query looks like this: $querymvideo = "select movietable.id, movietable.songname from movietable where TRIM(movietable.songname) LIKE '__$foo' "; The above query works fine except when a songname has the single quote symbol: "'" or maybe it is the comma in the song. Example song: I'll See the Light, Tonight This gives an error: Warning: Supplied argument is not a valid MySQL result resource in /testing/dirlisting4e.php on line 208 MySQL error 1064: You have an error in your SQL syntax near 'll See the Light, Tonight' ' at line 1 How to escape or ignore the single quote: "'" in a variable. Can I use the escape clause somehow in my query: ESCAPE '''; I am using PHP and MySQL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Load problems with 3.23.51
Hi! > "Jeremy" == Jeremy Zawodny <[EMAIL PROTECTED]> writes: Jeremy> On Sat, Jun 22, 2002 at 05:25:59PM -0700, Steven Roussey wrote: >> Hi all, >> >> I have MySQL 3.23.47 running on our sever. I skipped 48 through 50 and >> tried 51. No dice. It does not handle load, CPU and the load average go >> through the roof. I'm using Red Hat Linux 7.2 and the official mysql >> binaries. It appears to be slow to connect, causing 0.5 to 1.0 second >> delay on connection. Using persistent connections from PHP does not make >> much of a difference. I thought it might be the hostname lookup changes >> so I chose skip-grant-tables. This doesn't actually skip the hostname >> lookup though and had no effect. >> >> Most queries are shorter than 1 second so this problem causes >> catastrophic problems by making queries last a multiple times longer, >> which make the number of concurrent queries jump exponentially. This is >> a bad thing. And sadly makes 3.23.51 unusable. >> >> Does anyone else note these types of issues? Jeremy> As another data point for you, I've got 3.23.51 running on our master Jeremy> quite well. The difference is that I built it from source (to get a Jeremy> critical InnoDB patch). I don't recall which compiler the MySQL folks Jeremy> used (and which glibc), but my source build used Debian Woody's gcc Jeremy> 2.95.4. We are using gcc 2.95.3 and a patched glibc, the later one that we used in many builds before. This is the first email I got that 3.23.51 would be slow. Steven, could you try to run the MySQL benchmark suite on your machine and post me the results ? cd sql-bench perl run-all-tests --log The file I am interested in is the summary file named 'output/RUN-*' Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Thank you!I need your help!
You need libtermcap. (libtermcap-2.0.8-28.i386.rpm) You are running a Redhat 7.2 box, use binary distribution instead of source package if you're not familiar with building programs. Regards, Sébastien > > > please tell what mean the follow: > [root@guanqun zsj]# cd /usr/local/src > [root@guanqun src]# cd mysql-3.23.44.tar/ > [root@guanqun mysql-3.23.44.tar]# ./configure --prefix=/usr/local/mysql > bash: ./configure: No such file or directory > [root@guanqun mysql-3.23.44.tar]# ls > mysql-3.23.44 mysql-3.23.44.tar > [root@guanqun mysql-3.23.44.tar]# cd mysql-3.23.44 > [root@guanqun mysql-3.23.44]# ./configure --prefix=/usr/local/mysql > loading cache ./config.cache > checking host system type... i686-pc-linux-gnu > checking target system type... i686-pc-linux-gnu > checking build system type... i686-pc-linux-gnu > checking for a BSD compatible install... (cached) /usr/bin/install -c > checking whether build environment is sane... yes > checking whether make sets ${MAKE}... (cached) yes > checking for working aclocal... missing > checking for working autoconf... missing > checking for working automake... missing > checking for working autoheader... missing > checking for working makeinfo... missing > checking whether to enable maintainer-specific portions of Makefiles... no > checking whether build environment is sane... yes > checking whether make sets ${MAKE}... (cached) yes > checking for gawk... (cached) gawk > checking for gcc... (cached) gcc > checking whether the C compiler (gcc ) works... yes > checking whether the C compiler (gcc ) is a cross-compiler... no > checking whether we are using GNU C... (cached) yes > checking whether gcc accepts -g... (cached) yes > checking for c++... (cached) c++ > checking whether the C++ compiler (c++ ) works... yes > checking whether the C++ compiler (c++ ) is a cross-compiler... no > checking whether we are using GNU C++... (cached) yes > checking whether c++ accepts -g... (cached) yes > checking how to run the C preprocessor... (cached) gcc -E > checking for ranlib... (cached) ranlib > checking for ld used by GCC... (cached) /usr/bin/ld > checking if the linker (/usr/bin/ld) is GNU ld... (cached) yes > checking for BSD-compatible nm... (cached) /usr/bin/nm -B > checking whether ln -s works... (cached) yes > loading cache ./config.cache within ltconfig > checking for object suffix... o > checking for executable suffix... (cached) no > checking for gcc option to produce PIC... -fPIC > checking if gcc PIC flag -fPIC works... yes > checking if gcc supports -c -o file.o... yes > checking if gcc supports -c -o file.lo... yes > checking if gcc supports -fno-rtti -fno-exceptions ... yes > checking if gcc static flag -static works... -static > checking if the linker (/usr/bin/ld) is GNU ld... yes > checking whether the linker (/usr/bin/ld) supports shared libraries... yes > checking command to parse /usr/bin/nm -B output... ok > checking how to hardcode library paths into programs... immediate > checking for /usr/bin/ld option to reload object files... -r > checking dynamic linker characteristics... Linux ld.so > checking if libtool supports shared libraries... yes > checking whether to build shared libraries... yes > checking whether to build static libraries... yes > checking for objdir... .libs > creating libtool > loading cache ./config.cache > checking for a BSD compatible install... /usr/bin/install -c > checking for bison... no > checking for byacc... no > checking for pdftex... no > checking return type of sprintf... int > checking for uname... /bin/uname > checking operating system... Linux > checking if we should use skip-locking as default for linux-gnu... yes > checking for ln... /bin/ln > checking for ln... /bin/ln > checking for mv... /bin/mv > checking for rm... /bin/rm > checking for cp... /bin/cp > checking for sed... /bin/sed > checking for cmp... /usr/bin/cmp > checking for chmod... /bin/chmod > checking for hostname... /bin/hostname > checking for perl... /usr/bin/perl > checking for ps... /bin/ps > checking how to check if pid exists... /bin/ps p $$PID | grep > mysqld > /dev/null > checking for kill... /bin/kill > checking for kill switches... /bin/kill -0 $$PID > /dev/null 2> /dev/null > checking for gcc option to accept ANSI C... > checking whether to use RAID... no > checking for getconf... getconf > checking for CFLAGS value to request large file support... > -D_FILE_OFFSET_BITS=6 > 4 > checking for LDFLAGS value to request large file support... > checking for LIBS value to request large file support... > checking for _FILE_OFFSET_BITS... 64 > checking for _LARGEFILE_SOURCE... no > checking for _LARGE_FILES... no > checking for ANSI C header files... yes > checking for size_t... yes > checking for dirent.h that defines DIR... yes > checking for opendir in -ldir... no > checking for ANSI C header files... (cached) yes > checking for sys/wait.h that is POSIX.1 compatible... yes > checking for fcntl.h... yes > checking for float.h... yes
Re: Thank you!I need your help!
I think the problem is that the mysql package is still tarred. You need to tar -xvf mysqlx.tar This will extract the archive into a new folder, and from within that folder you should run the commands as listed in your original mail (./configure .) So in short, the commands you are trying to use *appears* to be correct, you just need to unpack the files before issuing the commands. Your situation is similar to having a mysql package that is winzipped, you first need to unzip it. Jocelyn Fournier wrote: >Hi, > >checking for working aclocal... missing >checking for working autoconf... missing >checking for working automake... missing >checking for working autoheader... missing >checking for working makeinfo... missing > >You need to install automake and autoconf before trying to compile MySQL. >(texinfo is optional) > >Regards, > Jocelyn Fournier >- Original Message - >From: "ÕÅÉƽð" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Monday, June 24, 2002 12:24 PM >Subject: Thank you!I need your help! > > >>please tell what mean the follow: >>[root@guanqun zsj]# cd /usr/local/src >>[root@guanqun src]# cd mysql-3.23.44.tar/ >>[root@guanqun mysql-3.23.44.tar]# ./configure --prefix=/usr/local/mysql >>bash: ./configure: No such file or directory >>[root@guanqun mysql-3.23.44.tar]# ls >>mysql-3.23.44 mysql-3.23.44.tar >>[root@guanqun mysql-3.23.44.tar]# cd mysql-3.23.44 >>[root@guanqun mysql-3.23.44]# ./configure --prefix=/usr/local/mysql >>loading cache ./config.cache >>checking host system type... i686-pc-linux-gnu >>checking target system type... i686-pc-linux-gnu >>checking build system type... i686-pc-linux-gnu >>checking for a BSD compatible install... (cached) /usr/bin/install -c >>checking whether build environment is sane... yes >>checking whether make sets ${MAKE}... (cached) yes >>checking for working aclocal... missing >>checking for working autoconf... missing >>checking for working automake... missing >>checking for working autoheader... missing >>checking for working makeinfo... missing >>checking whether to enable maintainer-specific portions of Makefiles... no >>checking whether build environment is sane... yes >>checking whether make sets ${MAKE}... (cached) yes >>checking for gawk... (cached) gawk >>checking for gcc... (cached) gcc >>checking whether the C compiler (gcc ) works... yes >>checking whether the C compiler (gcc ) is a cross-compiler... no >>checking whether we are using GNU C... (cached) yes >>checking whether gcc accepts -g... (cached) yes >>checking for c++... (cached) c++ >>checking whether the C++ compiler (c++ ) works... yes >>checking whether the C++ compiler (c++ ) is a cross-compiler... no >>checking whether we are using GNU C++... (cached) yes >>checking whether c++ accepts -g... (cached) yes >>checking how to run the C preprocessor... (cached) gcc -E >>checking for ranlib... (cached) ranlib >>checking for ld used by GCC... (cached) /usr/bin/ld >>checking if the linker (/usr/bin/ld) is GNU ld... (cached) yes >>checking for BSD-compatible nm... (cached) /usr/bin/nm -B >>checking whether ln -s works... (cached) yes >>loading cache ./config.cache within ltconfig >>checking for object suffix... o >>checking for executable suffix... (cached) no >>checking for gcc option to produce PIC... -fPIC >>checking if gcc PIC flag -fPIC works... yes >>checking if gcc supports -c -o file.o... yes >>checking if gcc supports -c -o file.lo... yes >>checking if gcc supports -fno-rtti -fno-exceptions ... yes >>checking if gcc static flag -static works... -static >>checking if the linker (/usr/bin/ld) is GNU ld... yes >>checking whether the linker (/usr/bin/ld) supports shared libraries... yes >>checking command to parse /usr/bin/nm -B output... ok >>checking how to hardcode library paths into programs... immediate >>checking for /usr/bin/ld option to reload object files... -r >>checking dynamic linker characteristics... Linux ld.so >>checking if libtool supports shared libraries... yes >>checking whether to build shared libraries... yes >>checking whether to build static libraries... yes >>checking for objdir... .libs >>creating libtool >>loading cache ./config.cache >>checking for a BSD compatible install... /usr/bin/install -c >>checking for bison... no >>checking for byacc... no >>checking for pdftex... no >>checking return type of sprintf... int >>checking for uname... /bin/uname >>checking operating system... Linux >>checking if we should use skip-locking as default for linux-gnu... yes >>checking for ln... /bin/ln >>checking for ln... /bin/ln >>checking for mv... /bin/mv >>checking for rm... /bin/rm >>checking for cp... /bin/cp >>checking for sed... /bin/sed >>checking for cmp... /usr/bin/cmp >>checking for chmod... /bin/chmod >>checking for hostname... /bin/hostname >>checking for perl... /usr/bin/perl >>checking for ps... /bin/ps >>checking how to check if pid exists... /bin/ps p $$PID | grep mysqld > >> >/dev/null > >>checking for kill... /bin/kill
Re: please modify init.d script
Florin, You may put something like # wait until mysql is ready counter=0 while ! mysqladmin \ -h localhost -u user -pPassword ping >/dev/null 2>&1 do counter=$((counter+1)) if [ $(($counter)) -gt $((200)) ] then echo "mysqld startup failed" fi done into your startup script. But Gerald may be right that this delay is not necessary for everyone. You don't have to do it for every service that uses MySQL but only for the first one to use MySQL. Thomas On 21 Jun 2002, Florin Andrei wrote: > On Fri, 2002-06-21 at 12:09, Gerald Clark wrote: > > Or better yet, > > add a sleep 2 to the beginning of the init.d program you are starting > > that expects to connect to mysql. > > > > Why slow down the booting for everybody when some other daemon that > > expects to connect to mysql > > can not handle a failed connect properly? > > Because you have to do that for every service that uses MySQL (that > means modifying lots of things) when, in fact, the problem is in MySQL's > script (and it could be fixed modifying that one script). > > I don't quite understand why one would care so much about a couple of > seconds of boot time? It's not like you reboot the production servers > every day. > And, BTW, we're talking about Unix, right? Not Windows RebootME. ;-) > > I would be much more concerned about the reliability of the boot-up > process, than with some unrealistic "mine boots up one milisecond faster > that yours". > Reliability is _much_ more important than one second added to boot-up > time. My customers wouldn't care too much if my servers came back one > second later, but they would care very much if the servers came back > without running some critical services. > > This is about playing by the rules too: when the init.d script returns, > and it reports "OK" or success, or whatever, then it should tell the > truth. > Right now, mysql's init.d script is lying; it reports success, while > MySQL didn't in fact finished the boot-up process. It is conceivable > that it might actually fail later, because it still has a few things to > do after the script already returned control (and happily reported > success). > > This rule is observed by the init.d scripts of most of the other > daemons. For example, Squid's script does not return control when > shutting down the daemon until the daemon really closed all > filedescriptors; on a very busy caching proxy, that might take one > minute to complete (and i've seen even longer times occasionally)! But > hey, one has to clean up its own mess, right? > If you don't do that (wait for the proxy to properly terminate > connections/flushing buffers), the init hierarchy would end up > SIGKILLing squid at the end, with the risk of terminating active > filedescriptors, etc. > You only have to SIGKILL it if indeed it takes an exagerated time to > shut down, and that means there's a problem hidden somewhere, and now > you are aware of it and you can fix it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: get months between two dates
Hi Frank, Thanks, but it is fine if the year is same. If years are different then result may comes in -ve value. D K Dubey -Original Message- From: Frank Gates [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 5:09 PM To: D.K.Dubey Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: get months between two dates Use the month(date) function. select month(firstDate) - month(secondDate) from someTable where ...; Hope this helps. Frank "D.K.Dubey" wrote: > Hi, Can anybody tell me how i can calculate the months between two dates in > mysql. > thanks in advance > Regards > D K Dubey > > - > 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. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Out of memory on simple question.
* Simon Green > After running this simple question I get this error. I have looked at the > my.cnf file and all looks fine and the system has 1.256 G of memory. > Can some one please tell me where I have gone wrong. > > select in_names.Username > from in_names, in_names2 > where in_names.Username != in_names2.Username; > ./mysql: Out of memory (Needed 8164 bytes) > ERROR 2008: MySQL client run out of memory If you have many names in these tables, this will consume a lot of memory, yes. You are asking for all combinations of names where the name is not the same. This is an example with only five names in each table: mysql> create table in_names (Username varchar(30)); Query OK, 0 rows affected (0.02 sec) mysql> insert into in_names values("aaa"),("bbb"),("ccc"),("ddd"),("eee"); Query OK, 5 rows affected (0.01 sec) Records: 5 Duplicates: 0 Warnings: 0 mysql> create table in_names2 select * from in_names; Query OK, 5 rows affected (0.03 sec) Records: 5 Duplicates: 0 Warnings: 0 mysql> select in_names.Username,in_names2.Username -> from in_names, in_names2 -> where in_names.Username != in_names2.Username; +--+--+ | Username | Username | +--+--+ | bbb | aaa | | ccc | aaa | | ddd | aaa | | eee | aaa | | aaa | bbb | | ccc | bbb | | ddd | bbb | | eee | bbb | | aaa | ccc | | bbb | ccc | | ddd | ccc | | eee | ccc | | aaa | ddd | | bbb | ddd | | ccc | ddd | | eee | ddd | | aaa | eee | | bbb | eee | | ccc | eee | | ddd | eee | +--+--+ 20 rows in set (0.00 sec) I selected both names, so that you can see what is going on. Each name in one table is matched with _every_ name in the other table, except the one that is the same... just as you asked for. :) -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Out of memory on simple question.
Thanks for this... So I think I need some joins! Simon -Original Message- From: Roger Baklund [mailto:[EMAIL PROTECTED]] Sent: 24 June 2002 12:19 To: Mysql (E-mail) Cc: Simon Green Subject: Re: Out of memory on simple question. * Simon Green > After running this simple question I get this error. I have looked at the > my.cnf file and all looks fine and the system has 1.256 G of memory. > Can some one please tell me where I have gone wrong. > > select in_names.Username > from in_names, in_names2 > where in_names.Username != in_names2.Username; > ./mysql: Out of memory (Needed 8164 bytes) > ERROR 2008: MySQL client run out of memory If you have many names in these tables, this will consume a lot of memory, yes. You are asking for all combinations of names where the name is not the same. This is an example with only five names in each table: mysql> create table in_names (Username varchar(30)); Query OK, 0 rows affected (0.02 sec) mysql> insert into in_names values("aaa"),("bbb"),("ccc"),("ddd"),("eee"); Query OK, 5 rows affected (0.01 sec) Records: 5 Duplicates: 0 Warnings: 0 mysql> create table in_names2 select * from in_names; Query OK, 5 rows affected (0.03 sec) Records: 5 Duplicates: 0 Warnings: 0 mysql> select in_names.Username,in_names2.Username -> from in_names, in_names2 -> where in_names.Username != in_names2.Username; +--+--+ | Username | Username | +--+--+ | bbb | aaa | | ccc | aaa | | ddd | aaa | | eee | aaa | | aaa | bbb | | ccc | bbb | | ddd | bbb | | eee | bbb | | aaa | ccc | | bbb | ccc | | ddd | ccc | | eee | ccc | | aaa | ddd | | bbb | ddd | | ccc | ddd | | eee | ddd | | aaa | eee | | bbb | eee | | ccc | eee | | ddd | eee | +--+--+ 20 rows in set (0.00 sec) I selected both names, so that you can see what is going on. Each name in one table is matched with _every_ name in the other table, except the one that is the same... just as you asked for. :) -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: get months between two dates
Use the month(date) function. select month(firstDate) - month(secondDate) from someTable where ...; Hope this helps. Frank "D.K.Dubey" wrote: > Hi, Can anybody tell me how i can calculate the months between two dates in > mysql. > thanks in advance > Regards > D K Dubey > > - > 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. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 dump/recovery probable bug
Hi! > "Georg" == Georg Richter <[EMAIL PROTECTED]> writes: Georg> On Friday, 21. June 2002 15:43, Stefano Incontri wrote: Georg> Hi, >> >> I found the following problem, which I consider a bug, but maybe I'm >> missing something to make it work correctly. Georg> This is not a bug. Why do you use a reserved word (LOAD) for an index name?! Georg> Rename it and everything should be ok. Georg> See also: http://www.mysql.com/doc/R/e/Reserved_words.html Another option is to use the mysqld option --quote-names. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ 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: Thank you!I need your help!
Hi, checking for working aclocal... missing checking for working autoconf... missing checking for working automake... missing checking for working autoheader... missing checking for working makeinfo... missing You need to install automake and autoconf before trying to compile MySQL. (texinfo is optional) Regards, Jocelyn Fournier - Original Message - From: "ÕÅÉƽð" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 24, 2002 12:24 PM Subject: Thank you!I need your help! > > please tell what mean the follow: > [root@guanqun zsj]# cd /usr/local/src > [root@guanqun src]# cd mysql-3.23.44.tar/ > [root@guanqun mysql-3.23.44.tar]# ./configure --prefix=/usr/local/mysql > bash: ./configure: No such file or directory > [root@guanqun mysql-3.23.44.tar]# ls > mysql-3.23.44 mysql-3.23.44.tar > [root@guanqun mysql-3.23.44.tar]# cd mysql-3.23.44 > [root@guanqun mysql-3.23.44]# ./configure --prefix=/usr/local/mysql > loading cache ./config.cache > checking host system type... i686-pc-linux-gnu > checking target system type... i686-pc-linux-gnu > checking build system type... i686-pc-linux-gnu > checking for a BSD compatible install... (cached) /usr/bin/install -c > checking whether build environment is sane... yes > checking whether make sets ${MAKE}... (cached) yes > checking for working aclocal... missing > checking for working autoconf... missing > checking for working automake... missing > checking for working autoheader... missing > checking for working makeinfo... missing > checking whether to enable maintainer-specific portions of Makefiles... no > checking whether build environment is sane... yes > checking whether make sets ${MAKE}... (cached) yes > checking for gawk... (cached) gawk > checking for gcc... (cached) gcc > checking whether the C compiler (gcc ) works... yes > checking whether the C compiler (gcc ) is a cross-compiler... no > checking whether we are using GNU C... (cached) yes > checking whether gcc accepts -g... (cached) yes > checking for c++... (cached) c++ > checking whether the C++ compiler (c++ ) works... yes > checking whether the C++ compiler (c++ ) is a cross-compiler... no > checking whether we are using GNU C++... (cached) yes > checking whether c++ accepts -g... (cached) yes > checking how to run the C preprocessor... (cached) gcc -E > checking for ranlib... (cached) ranlib > checking for ld used by GCC... (cached) /usr/bin/ld > checking if the linker (/usr/bin/ld) is GNU ld... (cached) yes > checking for BSD-compatible nm... (cached) /usr/bin/nm -B > checking whether ln -s works... (cached) yes > loading cache ./config.cache within ltconfig > checking for object suffix... o > checking for executable suffix... (cached) no > checking for gcc option to produce PIC... -fPIC > checking if gcc PIC flag -fPIC works... yes > checking if gcc supports -c -o file.o... yes > checking if gcc supports -c -o file.lo... yes > checking if gcc supports -fno-rtti -fno-exceptions ... yes > checking if gcc static flag -static works... -static > checking if the linker (/usr/bin/ld) is GNU ld... yes > checking whether the linker (/usr/bin/ld) supports shared libraries... yes > checking command to parse /usr/bin/nm -B output... ok > checking how to hardcode library paths into programs... immediate > checking for /usr/bin/ld option to reload object files... -r > checking dynamic linker characteristics... Linux ld.so > checking if libtool supports shared libraries... yes > checking whether to build shared libraries... yes > checking whether to build static libraries... yes > checking for objdir... .libs > creating libtool > loading cache ./config.cache > checking for a BSD compatible install... /usr/bin/install -c > checking for bison... no > checking for byacc... no > checking for pdftex... no > checking return type of sprintf... int > checking for uname... /bin/uname > checking operating system... Linux > checking if we should use skip-locking as default for linux-gnu... yes > checking for ln... /bin/ln > checking for ln... /bin/ln > checking for mv... /bin/mv > checking for rm... /bin/rm > checking for cp... /bin/cp > checking for sed... /bin/sed > checking for cmp... /usr/bin/cmp > checking for chmod... /bin/chmod > checking for hostname... /bin/hostname > checking for perl... /usr/bin/perl > checking for ps... /bin/ps > checking how to check if pid exists... /bin/ps p $$PID | grep mysqld > /dev/null > checking for kill... /bin/kill > checking for kill switches... /bin/kill -0 $$PID > /dev/null 2> /dev/null > checking for gcc option to accept ANSI C... > checking whether to use RAID... no > checking for getconf... getconf > checking for CFLAGS value to request large file support... -D_FILE_OFFSET_BITS=6 > 4 > checking for LDFLAGS value to request large file support... > checking for LIBS value to request large file support... > checking for _FILE_OFFSET_BITS... 64 > checking for _LARGEFILE_SOURCE... no > checking for _LARGE_FILES... no > checking for ANSI C header files...
FW: Binary data mysqldump and restore.
Just for those people who have the same problem: -Original Message- From: Mark Williams (MWP) [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 11:13 To: Bert VdB Subject: Re: Binary data mysqldump and restore. That did it thanks! MWP > Hi, > > Have you tried making a dump with the --opt option ? > > CB. > > -Original Message- > From: Mark Williams (MWP) [mailto:[EMAIL PROTECTED]] > Sent: Monday, June 24, 2002 09:57 > To: [EMAIL PROTECTED] > Subject: Binary data mysqldump and restore. > > > This message uses a character set that is not supported by the Internet > Service. To view the original message content, open the attached message. > If the text doesn't display correctly, save the attachment to disk, and then > open it using a viewer that can display the original character set. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Thank you!I need your help!
please tell what mean the follow: [root@guanqun zsj]# cd /usr/local/src [root@guanqun src]# cd mysql-3.23.44.tar/ [root@guanqun mysql-3.23.44.tar]# ./configure --prefix=/usr/local/mysql bash: ./configure: No such file or directory [root@guanqun mysql-3.23.44.tar]# ls mysql-3.23.44 mysql-3.23.44.tar [root@guanqun mysql-3.23.44.tar]# cd mysql-3.23.44 [root@guanqun mysql-3.23.44]# ./configure --prefix=/usr/local/mysql loading cache ./config.cache checking host system type... i686-pc-linux-gnu checking target system type... i686-pc-linux-gnu checking build system type... i686-pc-linux-gnu checking for a BSD compatible install... (cached) /usr/bin/install -c checking whether build environment is sane... yes checking whether make sets ${MAKE}... (cached) yes checking for working aclocal... missing checking for working autoconf... missing checking for working automake... missing checking for working autoheader... missing checking for working makeinfo... missing checking whether to enable maintainer-specific portions of Makefiles... no checking whether build environment is sane... yes checking whether make sets ${MAKE}... (cached) yes checking for gawk... (cached) gawk checking for gcc... (cached) gcc checking whether the C compiler (gcc ) works... yes checking whether the C compiler (gcc ) is a cross-compiler... no checking whether we are using GNU C... (cached) yes checking whether gcc accepts -g... (cached) yes checking for c++... (cached) c++ checking whether the C++ compiler (c++ ) works... yes checking whether the C++ compiler (c++ ) is a cross-compiler... no checking whether we are using GNU C++... (cached) yes checking whether c++ accepts -g... (cached) yes checking how to run the C preprocessor... (cached) gcc -E checking for ranlib... (cached) ranlib checking for ld used by GCC... (cached) /usr/bin/ld checking if the linker (/usr/bin/ld) is GNU ld... (cached) yes checking for BSD-compatible nm... (cached) /usr/bin/nm -B checking whether ln -s works... (cached) yes loading cache ./config.cache within ltconfig checking for object suffix... o checking for executable suffix... (cached) no checking for gcc option to produce PIC... -fPIC checking if gcc PIC flag -fPIC works... yes checking if gcc supports -c -o file.o... yes checking if gcc supports -c -o file.lo... yes checking if gcc supports -fno-rtti -fno-exceptions ... yes checking if gcc static flag -static works... -static checking if the linker (/usr/bin/ld) is GNU ld... yes checking whether the linker (/usr/bin/ld) supports shared libraries... yes checking command to parse /usr/bin/nm -B output... ok checking how to hardcode library paths into programs... immediate checking for /usr/bin/ld option to reload object files... -r checking dynamic linker characteristics... Linux ld.so checking if libtool supports shared libraries... yes checking whether to build shared libraries... yes checking whether to build static libraries... yes checking for objdir... .libs creating libtool loading cache ./config.cache checking for a BSD compatible install... /usr/bin/install -c checking for bison... no checking for byacc... no checking for pdftex... no checking return type of sprintf... int checking for uname... /bin/uname checking operating system... Linux checking if we should use skip-locking as default for linux-gnu... yes checking for ln... /bin/ln checking for ln... /bin/ln checking for mv... /bin/mv checking for rm... /bin/rm checking for cp... /bin/cp checking for sed... /bin/sed checking for cmp... /usr/bin/cmp checking for chmod... /bin/chmod checking for hostname... /bin/hostname checking for perl... /usr/bin/perl checking for ps... /bin/ps checking how to check if pid exists... /bin/ps p $$PID | grep mysqld > /dev/null checking for kill... /bin/kill checking for kill switches... /bin/kill -0 $$PID > /dev/null 2> /dev/null checking for gcc option to accept ANSI C... checking whether to use RAID... no checking for getconf... getconf checking for CFLAGS value to request large file support... -D_FILE_OFFSET_BITS=6 4 checking for LDFLAGS value to request large file support... checking for LIBS value to request large file support... checking for _FILE_OFFSET_BITS... 64 checking for _LARGEFILE_SOURCE... no checking for _LARGE_FILES... no checking for ANSI C header files... yes checking for size_t... yes checking for dirent.h that defines DIR... yes checking for opendir in -ldir... no checking for ANSI C header files... (cached) yes checking for sys/wait.h that is POSIX.1 compatible... yes checking for fcntl.h... yes checking for float.h... yes checking for floatingpoint.h... no checking for ieeefp.h... no checking for limits.h... yes checking for memory.h... yes checking for pwd.h... yes checking for select.h... no checking for stdlib.h... yes checking for stddef.h... yes checking for strings.h... yes checking for string.h... yes checking f
Re: I know
you can download your binary for installation if there is supported hardware and OS made binary for you http://www.mysql.com/downloads/mysql-3.23.html - Original Message - ±H¥óªÌ: "ÕÅÉƽð" <[EMAIL PROTECTED]> ¦¬¥óªÌ: <[EMAIL PROTECTED]> ¶Ç°e¤é´Á: 2002¦~6¤ë24¤é PM 04:06 ¥D¦®: I know > I try it over !the question is that i couldn't configure and make the "mysql",so i can't install and run it .i don't know why .i try it as book!please give me the oringal software! > __ > > === > ÐÂÀËÃâ·Ñµç×ÓÓÊÏä (http://mail.sina.com.cn) > ÐÂÀË·ÖÀàÐÅÏ¢£º¶þÊÖÊг¡×ßÒ»×ߣ¬¸Ã³öÊÖʱ¾Í³öÊÖ£¡ (http://classad.sina.com.cn/2shou/) > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: help starting up mysql
I'm trying to start mysql -I have installed the db. t> Now I'm getting the following: t> [localhost:~] lloyd% sudo safe_mysqld --user=root & t> [1] 630 t> [localhost:~] lloyd% Starting mysqld daemon with databases from t> /usr/local/mysql/data t> 020623 20:25:20 mysqld ended mysqld didn't started. Is there any causes of failed start in the .err file? t> mysqladmin version t> ./bin/mysqladmin: connect to server at 'localhost' failed t> error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' t> (61)' t> Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! t> [1] + Done sudo safe_mysqld --user=root t> [localhost:~] lloyd% mysql t> ERROR 2002: Can't connect to local MySQL server through socket t> '/tmp/mysql.sock' (61) You can't connect because your MySQL server is not running. t> What do I need to do, please? t> (Does this list have a searchable archive?) Sure, look at: http://lists.mysql.com/ -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Permissions are now denied from the mysql client
Ruben, Sunday, June 23, 2002, 10:51:59 AM, you wrote: RIS> Of course it's running. I can only get in as the root user RIS> of the system Check where your mysql.sock is located and check permissions on the socket file. RIS> On 2002.06.23 03:51 Brandon McCombs wrote: >> >> >> Ruben I Safir wrote: >> > >> > I recently installed mysql on a new system and the client on works with root? >> > >> > Whats up? >> > >> > ruben@www2:~> !mys >> > mysql -p >> > Enter password: >> > ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' >(2) >> > ruben@www2:~> >> >> mysqld isn't running. Launch mysqld then try using the mysql client to >> access the databases. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: bug in 3.23.51 for windows ?
Brandon, Saturday, June 22, 2002, 9:00:49 PM, you wrote: BM> Is there any particular reason that anyone knows of that would prevent BM> mysql 3.23.51 for windows from working upon the execution of the SHOW BM> STATUS FROM tablename query? BM> In Linux it works fine, in windows it crashes mysqld with an illegal op. BM> Any other SHOW command works but the one I really need for a PHP app to BM> work. There is no command SHOW STATUS FROM in the MySQL. You can use SHOW TABLE STATUS: http://www.mysql.com/doc/S/H/SHOW_TABLE_STATUS.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: cant create tables .....
toby, Monday, June 24, 2002, 10:06:57 AM, you wrote: t> i cant create tables, the tables which had NO foreign keys or they didmt t> refer to another table were created fine t> but the ones WITH foreign key ... refferring to fieldz in other table(s) t> cant be created t> mysql>create table lang ( lang_id int auto_increment primary key, t> lang_ char(20) t> ); t> query ok, 0 rows effected t> mysql>create table usr_inf ( foreign key lang_id refrences lang(lang_id), t> ); t> gives me this error : t> error 1064: u ve an error in ur sql syntex near 'refrences lang(lang_id)'at t> line 1 t> i even tried this without (lang_id) but it still doesnt work t> where m i messing it up guyz First of all both tables must be InnoDB; second you wrote a wrong foreign key constraint. Take a look at: http://www.mysql.com/doc/S/E/SEC446.html you can find example of creating tables with foreign key constraint. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Fw: insert BLOB values
Hytham, Saturday, June 22, 2002, 12:37:21 AM, you wrote: >> > i have a column of type blob, that i wish to store images in it, but >> how >> > can i right the sql statement to insert the image? >> > i mean : >> > insert into tblImages set imageField = ??? where id=999 It's not a correct statement, use UPDATE instead of INSERT. >> > now what the ??? should be ? If images are stored on the server, you can use LOAD_FILE() function: http://www.mysql.com/doc/S/t/String_functions.html f.e. UPDATE tblImages SET imageField = LOAD_FILE('/full/path/to/the/file') WHERE id = 999; -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Your Mail is being returned
plz give me the oringal software about mysql.when i make it will not successful.i have sent the wrong message twice to u. __ === ÐÂÀËÃâ·Ñµç×ÓÓÊÏä (http://mail.sina.com.cn) ÐÂÀË·ÖÀàÐÅÏ¢£º¶þÊÖÊг¡×ßÒ»×ߣ¬¸Ã³öÊÖʱ¾Í³öÊÖ£¡ (http://classad.sina.com.cn/2shou/) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: bizzar display .....
thnx van ... its workin now it was no bug ... no mysql problem no explorer problem my mistake i changed the fontdisplay in my t.htm file from unicode to user defined n its workin fine now thnx n im terrabbly sorry all of u a bit better now ... toby ... _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
file size limit hitting when "LOAD DATA INFILE"
Hi, all: I use MySQL 3.23.47, RH linux 7.2, file size limit is 4G. When "LOAD DATA INFILE" to a table whose file size is 4G, it fails and mysql_error(...) reports "Lost connection to MySQL server during query". How can I clearly know the failed reason is just hit the 4G file size limit? If the 4G file size limit is hit, I have two ways to resolve it: (1) create a new table and "LOAD DATA INFILE" into this new table. (2) backup this table and clear it and reload. However, these two ways are troubled and not good. Dose some one have a effective way that just "LOAD DATA INFILE" without hitting file size limit? Dose MERGE Table help it here? Thanks in advanse. B.R. Buding - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 dump/recovery probable bug
On Friday, 21. June 2002 15:43, Stefano Incontri wrote: Hi, > > I found the following problem, which I consider a bug, but maybe I'm > missing something to make it work correctly. This is not a bug. Why do you use a reserved word (LOAD) for an index name?! Rename it and everything should be ok. See also: http://www.mysql.com/doc/R/e/Reserved_words.html Regards Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Out of memory on simple question.
Hi After running this simple question I get this error. I have looked at the my.cnf file and all looks fine and the system has 1.256 G of memory. Can some one please tell me where I have gone wrong. select in_names.Username from in_names, in_names2 where in_names.Username != in_names2.Username; ./mysql: Out of memory (Needed 8164 bytes) ERROR 2008: MySQL client run out of memory Simon PS Both tables are indexed. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Load problems with 3.23.51
What about using the skip-name-resolve option rather than skip-grant-tables? I'm using the 3.23.51 binaries, also, and would appreciate knowing if this makes a difference. Debian potato 2.95.2 is a known good compiler, too, isn't it Jeremy? I may have to recompile my own anyway to change ft_min_word_length. On another note with 3.23.51, I'm getting these errors every 30 seconds in my slave error logs: 020624 5:00:00 Slave: Failed reading log event, reconnecting to retry, log 'db1-bin.008' position 3112 020624 5:00:00 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'db1-bin.008' at position 3112 020624 5:00:30 Error reading packet from server: (server_errno=1159) Is this just a normal timeout I can ignore? I'm still developing, so there's no real activity on these machines, yet. Is there a timeout value I can adjust? It's just annoying to see my error log growing so much with no activity. Thanks, --jeff - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "Steven Roussey" <[EMAIL PROTECTED]> Cc: "'Mysql'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, June 23, 2002 2:55 AM Subject: Re: Load problems with 3.23.51 > On Sat, Jun 22, 2002 at 05:25:59PM -0700, Steven Roussey wrote: > > Hi all, > > > > I have MySQL 3.23.47 running on our sever. I skipped 48 through 50 and > > tried 51. No dice. It does not handle load, CPU and the load average go > > through the roof. I'm using Red Hat Linux 7.2 and the official mysql > > binaries. It appears to be slow to connect, causing 0.5 to 1.0 second > > delay on connection. Using persistent connections from PHP does not make > > much of a difference. I thought it might be the hostname lookup changes > > so I chose skip-grant-tables. This doesn't actually skip the hostname > > lookup though and had no effect. > > > > Most queries are shorter than 1 second so this problem causes > > catastrophic problems by making queries last a multiple times longer, > > which make the number of concurrent queries jump exponentially. This is > > a bad thing. And sadly makes 3.23.51 unusable. > > > > Does anyone else note these types of issues? > > As another data point for you, I've got 3.23.51 running on our master > quite well. The difference is that I built it from source (to get a > critical InnoDB patch). I don't recall which compiler the MySQL folks > used (and which glibc), but my source build used Debian Woody's gcc > 2.95.4. > > That could have something to do with it... > > 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.51: up 24 days, processed 523,371,775 queries (248/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 > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Binary data mysqldump and restore.
Hi all... !! First, can you CC to [EMAIL PROTECTED], as im not on the mailing list. I have a few tables which are storing a few MB of binary data (like jpegs). I can dump the db fine using mysqldump, but on doing a "mysql ... < dumpfile" i get many errors, as it seems mysql isnt accepting the binary data in the dump file. I get hundreds of errors like: ERROR: Unknown command '\Z'. ERROR: Unknown command '\0'. ERROR: Unknown command '\Z'. ERROR: Unknown command '\0'. ERROR: Unknown command '\"'. ERROR 1064: You have an error in your SQL syntax near 'GIF89a2\02\0÷ÿ\0\0\0\0ÀÀÀ\0\0 \Z\0\Z 0\" INSE' at line 1 Query OK, 0 rows affected (0.00 sec) Query OK, 1 row affected (0.01 sec) So how do i do this? Thanks, MWP - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
I know
I try it over !the question is that i couldn't configure and make the "mysql",so i can't install and run it .i don't know why .i try it as book!please give me the oringal software! __ === ÐÂÀËÃâ·Ñµç×ÓÓÊÏä (http://mail.sina.com.cn) ÐÂÀË·ÖÀàÐÅÏ¢£º¶þÊÖÊг¡×ßÒ»×ߣ¬¸Ã³öÊÖʱ¾Í³öÊÖ£¡ (http://classad.sina.com.cn/2shou/) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 (InnoDB tables) and HP-UX or Solaris
Hi, Which is the best solution ? I use MySQL (exclusively with large InnoDB tables - 150 to 200 tables, 3 or 4 of them with 200 000 lines per day, approx. 40 to 80 Go of datas). I must switch my system to UNIX. So, what is the best solution, HP-UX or Solaris ? Thank's - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ANNOUNCE: moodss-16.3
### CHANGES ### --- version 16.3 --- - thresholds messages are now displayed in the trace module window and tables by default - in preferences, added thresholds trace page so that the user can choose whether thresholds messages are displayed in the trace module window and tables - in displayed tables and viewers, cell colors depended solely of the last occuring thresholds, they now display the most important and latest threshold color - tool bar icons not match menus behavior and are grayed accordingly - use nicer looking icons from KDE 3 in tool bar - when loading from a save file, cells with thresholds crossed immediately would not be colored on the initial refresh cycle (this problem was only partly fixed in 16.2) - in rpm specification file, removed icon entry which caused problems on some other distributions and architectures - completed HTML documentation better organized in user interface parts (although I feel that it should be redone, but I lack the professional skills: I am merely a programmer, help would be warmly welcomed) - in data tables, bottom right cell lower border was not drawn when its color was changed due to a threshold condition - do not allow thresholds as a module name - thresholds emailing successfully checked against a Lotus server in SMTP ### README ### This is moodss (Modular Object Oriented Dynamic SpreadSheet) version 16.3. Moodss won in the Best System Admin Technology category (Tcl Tips and Tricks, Valuable Real World Programming Examples) at the O'Reilly Tcl/Tk 1999 Conference. Linux Magazine calls it a "lifesaver". Tucows gives it 5 stars (cows or penguins :-). Moodss is a modular application. It displays data described and updated in one or more modules, which can be specified in the command line or dynamically loaded or unloaded while the application is running. Data is originally displayed in tables. Graphical viewers (graph, bar, 3D pie charts, ...), summary tables (with current, average, minimum and maximum values) and free text viewers can be created from any number of table cells, originating from any of the displayed viewers. The display area can be extended by adding pages with notebook tabs. Thresholds can be set on any number of cells. Moomps (shipped with moodss) is a monitoring daemon which works using configuration files created by moodss. Thresholds, when crossed, create messages in the system log, and eventually trigger the sending of email alert messages. Specific modules can easily be developed in the Tcl, Perl and Python scripting languages or in C. A thorough and intuitive drag'n'drop scheme is used for most viewer editing tasks: creation, modification, type mutation, destruction, ... and thresholds creation. Table rows can be sorted in increasing or decreasing order by clicking on column titles. The current configuration (modules, tables and viewers geometry, ...) can be saved in a file at any time, and later loaded at the user's convenience, thus achieving a dashboard functionality. The module code is the link between the moodss core and the data to be displayed. All the specific code is kept in the module package. Since module data access is entirely customizable (through C code, Tcl, Perl, Python, HTTP, ...) and since several modules can be loaded at once, applications for moodss become limitless. For example, thoroughly monitor a dynamic web server on a single dashboard with graphs, using the Apache, MySQL, ODBC, cpustats, memstats, ... modules. If you have replicated servers, dynamically add them to your view, even load the snmp module on the fly and let your imagination take over... Along with a core trace module, arp, cpustats, diskstats, interrupts, kernmods, memstats, minimal, mounts, netdev, pci, ps, random, route, sensors, system modules for Linux, MySQL (myerrorlog, myhealth, myprocs, myquery, myreplication, mystatus, myvars), odbcquery, ping, snmp, snmptrap for UNIX, apache and apachex, Minimal and Random Perl modules, minipy and randpy Python modules are included. Running "wish moodss ps cpustats memstats" mimics the "top" application with a graphic edge and remote monitoring capability. Thorough help is provided through menus, widget tips, a message area, a module help window and a global help window with a complete HTML documentation. Moodss is multi-langual thanks to Tcl internationalization capabilities. So far only English and partially French are supported. Help with other languages will be very warmly welcomed. Development of moodss is continuing and as more features are added in future versions, backward module code compatibility will be maintained. I cannot thank the authors of the tkTable, BLT, MIME/SMTP and the HTML libraries enough for their great work. In order to run moodss, you need to install the following packages (unless you can use the rpm utility, see below): Tcl/Tk 8.3.1 or above, at (or at a mirror near you) http://dev.scriptics.com/ or ftp://ftp.scriptics.com/ the latest
Re: bizzar display .....
Toby: Beyond off-topic, but try Netscape... If that isn't the cause; check that the web server has been patched for the chunk-encoding vulnerability that existed on Apache before 1.3.26, which was released last week. Otherwise: try and give some more useful details. Van -- = Linux rocks!!! http://www.dedserius.com/ = toby - wrote: > > guyz > all is down now > i cant even get my explorer to display the unicode it was displaying till > yesterday > now its giving me ALL BOXES for the unicode im trying to store > till yesterday it gave me boxes only for a few characters but the rest were > FINE ! ! ! ! > > has this somethin to do with mysql. is it some bug > > can anyone help me about what it is > > thnx a million > > counting on all of u > > exasperated > toby - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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-do logging feature with InnoDB: is it possible ?
Hello everybody, I have a small question regarding to the Mysql-InnoDB-tables : "Is it possible to use an Oracle-like 're-do logging' feature with InnoDB" ? This means more or less taking regular consistent backups of your database, and then in case of corruption, you restore the latest consistent database-backup and tell the server to re-apply the logs for a certain time-span. I haven't found any information on this feature for InnoDB, but I still would like to consult you guys before passing a definitive NO CAN DO to the managament of the project here :) Tnx for you input and time, CB. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Chinese character error
Dear professional people, When I write a program to store the (Big5) Chinese characters ¯S³\¸gÀç into mysql database through the mysql ODBC driver, the original chinese characters change into another characters ¯S³¸gÀç in mysql database. On the other hand, I have tried the program to store the (Big5) Chinese characters into another database through another ODBC driver, it is correct. The chinese characters remain the same. Would you help me to solve the problem? How-To-Repeat: 1. Create a table (named TestTb) in mysql database with the following fields : Field RecNum Type INT Length 4 Not Null Extra auto_increment Field DataField Type CHAR Length 20 2. Create mysql ODBC (named TESTODBC) which points to the database having the above table. 3. Create an ASP program as follows: <%@ Language=VBScript %> <% set oConn = Server.CreateObject("ADODB.Connection") oConn.Open "DSN=TESTODBC;UID=root;Password=;" FieldContent = "¯S³\¸gÀç" response.write "Input =" & FieldContent & "" sql = "insert into TestTb (DataField) values ('" & FieldContent & "')" oConn.execute(sql) sql = "select * from TestTb" set oRs = oConn.execute(sql) do while not oRs.EOF response.write "RecNum=" & oRs("RecNum") & "" response.write "DataField=" & oRs("DataField") & "" oRs.movenext loop %> 4. run the ASP program to see the special result. My contact email address is [EMAIL PROTECTED] Thanks for help! Best regards, Henry. _ 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: get months between two dates
That'll only work if the months are in the same year. Here's a more general one: SELECT PERIOD_DIFF( EXTRACT( YEAR_MONTH FROM date1 ), EXTRACT( YEAR_MONTH FROM date2 ) ); Dean Harding. -Original Message- From: Dogaru Dragos [mailto:[EMAIL PROTECTED]] Sent: Monday, 24 June 2002 5:30 pm To: D.K.Dubey; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: get months between two dates select month(current_date)-month(fild_name) from database where your_critteria This should show you the months between the current date and the date contained in the fild_name - Original Message - From: "D.K.Dubey" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> Sent: Monday, June 24, 2002 10:23 AM Subject: RE: get months between two dates > Hi Van, > > I read that before sending u the query. In that no where is mention to > subtract the dates and finding the no months between dates. > > D K Dubey > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of Van > Sent: Monday, June 24, 2002 11:43 AM > To: D.K.Dubey > Cc: [EMAIL PROTECTED] > Subject: Re: get months between two dates > > > Consider taking a look at the manual: > http://www.mysql.com/doc/D/a/Date_and_time_functions.html > > Perhaps read parts of it, too. > > Fix your PC's date (the current year for most of us is 2002). Many of us > who > receive e-mail dated in the past filter it to /dev/null. > > Van > > -- > = > Linux rocks!!! http://www.dedserius.com/ > = > > > "D.K.Dubey" wrote: > > > > Hi, Can anybody tell me how i can calculate the months between two dates > in > > mysql. > > thanks in advance > > Regards > > D K Dubey > > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: get months between two dates
Really? MONTH(date) Returns the month for date, in the range 1 to 12: mysql> SELECT MONTH('1998-02-03'); -> 2 There're other functions that will also be useful tools for you to achieve what I can only guess is your goal. I can think of 10 ways off-hand to solve your problem using the MySQL APIs. But, remember: all MySQL can give you is the tools (and, having great documentation for those who have the tenacity to self-educate effectively is nice to get for free, also). "How i can calculate the months between two dates?" The tools are right before you, as you've stated; use them. Best Regards, Van -- = Linux rocks!!! http://www.dedserius.com/ = "D.K.Dubey" wrote: > > Hi Van, > > I read that before sending u the query. In that no where is mention to > subtract the dates and finding the no months between dates. > > D K Dubey > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 2 servers on the same Win 2K machine
Hi, I have 2 version installed on my win2k machinge (.49 , .50 and .51) As long as you install in different directories , take care of config files and don't try to start 2 server simultaniously, I don't see why this should give problems. (At least, I haven't got any problems ;) ) CB. -Original Message- From: Okan CIMEN [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 08:09 To: [EMAIL PROTECTED] Subject: installing 2 servers on the same Win 2K machine Hello, I am planning to install 2 mysql servers on the same box whish runs Win2K. Has anyone experianced this before? Regards Okan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
bizzar display .....
guyz all is down now i cant even get my explorer to display the unicode it was displaying till yesterday now its giving me ALL BOXES for the unicode im trying to store till yesterday it gave me boxes only for a few characters but the rest were FINE ! ! ! ! has this somethin to do with mysql. is it some bug can anyone help me about what it is thnx a million counting on all of u exasperated toby _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: get months between two dates
select month(current_date)-month(fild_name) from database where your_critteria This should show you the months between the current date and the date contained in the fild_name - Original Message - From: "D.K.Dubey" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> Sent: Monday, June 24, 2002 10:23 AM Subject: RE: get months between two dates > Hi Van, > > I read that before sending u the query. In that no where is mention to > subtract the dates and finding the no months between dates. > > D K Dubey > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of Van > Sent: Monday, June 24, 2002 11:43 AM > To: D.K.Dubey > Cc: [EMAIL PROTECTED] > Subject: Re: get months between two dates > > > Consider taking a look at the manual: > http://www.mysql.com/doc/D/a/Date_and_time_functions.html > > Perhaps read parts of it, too. > > Fix your PC's date (the current year for most of us is 2002). Many of us > who > receive e-mail dated in the past filter it to /dev/null. > > Van > > -- > = > Linux rocks!!! http://www.dedserius.com/ > = > > > "D.K.Dubey" wrote: > > > > Hi, Can anybody tell me how i can calculate the months between two dates > in > > mysql. > > thanks in advance > > Regards > > D K Dubey > > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: get months between two dates
Hi Van, I read that before sending u the query. In that no where is mention to subtract the dates and finding the no months between dates. D K Dubey -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Van Sent: Monday, June 24, 2002 11:43 AM To: D.K.Dubey Cc: [EMAIL PROTECTED] Subject: Re: get months between two dates Consider taking a look at the manual: http://www.mysql.com/doc/D/a/Date_and_time_functions.html Perhaps read parts of it, too. Fix your PC's date (the current year for most of us is 2002). Many of us who receive e-mail dated in the past filter it to /dev/null. Van -- = Linux rocks!!! http://www.dedserius.com/ = "D.K.Dubey" wrote: > > Hi, Can anybody tell me how i can calculate the months between two dates in > mysql. > thanks in advance > Regards > D K Dubey > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php