Re: apache stops in make
On 19 Aug 2001 19:44:40 +0200, Greennet wrote: /usr/local/mysql-3.23.41/lib/libmysqlclient.a(my_compress.o): In function 'my_uncompress': my_compress.o(text+0x9a): undefined reference to 'uncompress' /usr/local/mysql-3.23.41/lib/libmysqlclient.a(my_compress.o): In function 'my_compress_alloc': my_compress.o(text+0x12a): undefined reference to 'compress' This symbol is defined in libz: [tonu@x153 tonu]$ nm /usr/lib/libz.a | grep compress compress.o: T compress 00ac T compress2 T uncompress 187c t compress_block [tonu@x153 tonu]$ Have you zlib-devel RPM installed? -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ 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: ANNOUNCE: MyVCC-0.3.2.pre-alpha released
Hi Shu, At 20:08 19/08/2001 -0700, Shu Xiao wrote: John, I got problem using this new release. When I opened the connection dialog, I typed in the host name, database name and user name * password. I specified a database other than mysql. But I always got the error saying Access denied for user 'xx' to database 'mysql'. This error indicates that you may have entered a wrong password. Section 6.16: Causes of Access denied Errors in the MySQL User Manual gives full details and solutions to this problem. I think mysql is the default database if the user doesn't enter the database name in the dialog, but I did. Why it always tries to access 'mysql'? The database mysql is where user privileges are stored. If this is a new installation try to log on as root with no password. I have the MySQL Server running on both remote Linux and Windows machines on my local network and I am able to connect to either locally - localhost or remotely without a problem therefore I believe your problem relates to the setup of your user privileges I checked the MySQL server log and saw connection log, which was a real connection request to 'mysql'. This is not correct. My server is running on the other machine. Please have a look at this. Thanks, Shu At 08:44 AM 8/18/2001 +0100, John Dean wrote: Hi I have released a new version of MySQL Visual Control Center for Windows. This release includes the following revisions:- 1. Help viewer with help files in HTML format. These help files can also be viewed outside of MyVCC using your favorite web browser so they can also be used as the project documentation 2. Fixed bug in Create Fields Dialog which limited the field length to 99 characters. The limit on field length is now dependent on Data Type 3. Submit Button on startup is now disabled until a connection has been established 4. Tools Menu on startup is now disabled until a connection has been established 5. Fixed bug related to submitting queries. Previously the query would fail if there was no WHERE and/or ORDER BY clause. This has now been fixed. 6. The problem relating to MyVCC not being able to find the SQL drivers has been fixed. 7. This release includes libmysql.dll from the V3.23.40 release of MySQL. Therefore, provided mysqld is running MyVCC will work without having to copy the DLLs to your Windows system directory. To download this release, please visit the MyVCC project at http://sourceforge.net/projects/mycc Regards John -- MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / John Dean [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mansfield, England, UK ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: how to create a table and a column..?
http://www.mysql.com/doc/C/r/Creating_tables.html Look over http://www.mysql.com/doc/index.html Also have a look at www.devshed.com for some tutorials.. mysql, query Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Nesting Problem for Multilevel Marketing
Hi For performance reasons, the best way to deal with the network is to separate it from your clients table because you would be searching the network heavily and if the table is short, that would be much faster. So, create a new table called network with only two integer fields, where you put the unique id of the client (id1), and referrer's account (id2). To find first level people below, you do: select id2 from network where id1=1 where number 1 is the id of the client you are searching for. To find second level people you do: select id2 from network where id1 in (select id2 from network where id1=1) and so on. (Note that the subquery is the same as the previous query) You must change this to use temporary tables because MySQL doesn't support subselects yet. :-( Hope that help you --- Andres Berger Garcia Gerente de Marketing Preventix S.A.C. -- http://www.zapantivirus.com - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, August 18, 2001 12:45 AM Subject: Nesting Problem for Multilevel Marketing Hi Everyone, I have a few questions based on a scenario that was posed to me, and I have no idea how to go about it... For example, a multi-level / multilevel marketing project has the following Membertable with 2 fields for a generated Account Number the first field is Member's Unique Account Number (Column A) and the second field is Referrer's Account Number (Column B)... So if I join the multilevel program, I will have to provide my recruiter's Account Number which will be placed in Column B and I will be given my new Account Number which will be placed in Column A. The problems would be: how do I generate a Member's Report, which will show the five members above me, and the five LEVELS of numerous members which join below me. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Explanation: Problems with MYSQL-D-MAX for win 98 DROP TABLE
I have tried to install Mysql 3.23.40 again. The problem also persists using the program directly mysql.exe of the directory mysql/bin and with an access ODBC performing the same commands. To the attempt to perform the command DROP TABLE the error it is always 1051. Thanks Regards Subject: Re: Explanation: Problems with MYSQL-D-MAX for win 98 DROP TABLE At 08:52 16/08/2001 +0200, Luciano Pulvirenti wrote: Hi! Sorry but I wasn't able to repeat the bug reported. However I did my tests with the DOS mysql client and others GUI clients, since the Mascom trial package that I have denied the start on my Win9x machines, so I assume you have an environment issue or Mascom behavior. Regards, Miguel I will try of to be clearer. Operating system: WIN98 Version of Mysql 3.23.40 EXE : Mysql-d-max I create a table of example. Create table test ( Field1 tinyint not null ) type=BDB The table is created regularly. The statement DROP TABLE testresponds Error 1051 - Unknown table test The only way to delete the table is: alter table test , type=MyISAM DROP TABLE test The tests have been effected with Mascon. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication
On Sun, Aug 19, 2001 at 10:50:58PM +0200, Michael Großegesse wrote: Hi I'd like to know if it is possible to scp the database files to a backup server while mysql is still running on both machines? As long as you are careful to flush and lock tables when you do it, yes. Alternatively, is there any replication mechanism to keep the backup server up to date without shuting down mysql? What about using MySQL's built-in replication? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 2 days, processed 37,059,555 queries (144/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
Using MySql with Database
Hi, Any pointers as to how can mysql database can be used with Weblogic. If it can be... TIA, Rohit
Speaking of tree searches
I have an upcoming project which will require me doing a recursive function in PHP, doing a tree calculating optimum route between defined points in the database. The function is going to have to do a SELECT on the MySQL database on each iteration. It could concievably do thousands of iterations on about a hundred points in the database. Anyone think MySQL can handle the load, or do I have to try a workaround and put the whole database in an array first? No two SELECTs should be the same, so I'd have to play with that array a lot if I did that. Frank. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Data Security
Hi everyone Does anyone know if a secure socket is automatically established when: 1.The server running my-sql (a unix box) is secure and 2.You use Delphi, via Zeus components, to connect to it and upload/download data ? Thanks everyone! Regards Elizabeth
Re: Problem with Win32 MySQLGUI 1.7.5
Shu Xiao writes: Hi, I notice a problem with Win32 MySQLGUI 1.7.5. When I get the result for the query. I see the escape character \ was not removed in the result table window. Anybody notice the same problem? Thanks, Shu Yes, all cells are escaped in order to display all values. But if your values are binary, you can view them with a zoom feature in their natural binary form. -- 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: how to create a table and a column..?
You have to create a database first, then tell MySQL to use that databases. mysqlCREATE DATABASE myfirstdb; mysqlUSE myfirstdb; mysqlCREATE TABLE tableone - Original Message - From: B. van Ouwerkerk [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 20, 2001 12:50 AM Subject: RE: how to create a table and a column..? http://www.mysql.com/doc/C/r/Creating_tables.html Look over http://www.mysql.com/doc/index.html Also have a look at www.devshed.com for some tutorials.. mysql, query Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 memory leaks !!! (?)
Hi I have a mysql server: mysqld Ver 3.23.33 for pc-linux-gnu on i686 I use C API to communicate with database, a simple connection could look like this: -- test.c -- #include stdio.h #include mysql/mysql.h int main() { MYSQL *conn; conn = mysql_init(NULL); if (!mysql_real_connect (conn, host, user, pass, database, 0, NULL, 0)) { printf(%s\n, mysql_error(conn)); return 1; } mysql_close(conn); return 0; } - and compilation: gcc test.c -o test -lmysqlclient -g At the software creating, it's worth using (at least for tests) functions from header mcheck.h. It's very usefull for finding memory leaks. Now, take a look at second example: - test2.c #include stdio.h #include mysql/mysql.h #include mcheck.h /* mtrace(); muntrace(); */ int main() { MYSQL *conn; setenv(MALLOC_TRACE,/tmp/mtrace.log,1); mtrace(); conn = mysql_init(NULL); if (!mysql_real_connect (conn, host, user, pass, database, 0, NULL, 0)) { printf(%s\n, mysql_error(conn)); return 1; } mysql_close(conn); muntrace(); return 0; } - after compilation: gcc test2.c -o test2 -lmysqlclient -g program execution: ./test2 and mtrace log parsing: mtrace test2 /tmp/mtrace.log I achieve many lines (76 in fact) of places where memory is not freed. Does anybody knows what is going on ? (it's my fault or it's mysql functions fault or mtrace fault ;-) ?) Any help would be appreciated. - Jakub Trzetrzelewski - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Speaking of tree searches
--- Frank Fisher [EMAIL PROTECTED] wrote: I have an upcoming project which will require me doing a recursive function in PHP, doing a tree calculating optimum route between defined points in the database. Maybe it's just me, but it sounds like you need to reconsider you're database structure. I can't think of any reason that such a schema would be required. Hans [EMAIL PROTECTED] __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Documentation says DECIMAL is floating-point but it is fixed-point
On Mon, Aug 20, 2001 at 11:08:47AM +0200, Ernst Kloppenburg wrote: Description: with DECIMAL the number of digits before and after the decimal point is fixed. Thus it should be described in the documentation as a fixed point number How-To-Repeat: the manual is correct. the number is stored internaly as a floating point number with all of its benifets and drawbacks. formating information is only used when the number is retrieved. if a number is stored in atable with more significant digets than the coulum will alow, and the table is later restructured to show aditional precision, the number will show mour preciosion. try it. - DISCLAIMER: Anyone sending me unsolicited commercial electronic mail automatically agrees to be held to the following legal terms: US Code Title 47, Sec.227(a)(2)(B), a computer/modem/printer meets the definition of a telephone fax machine. By Sec.227(b)(1)(C), it is unlawful to send any unsolicited advertisement to such equipment. By Sec.227(b)(3)(C), a violation of the aforementioned Section is punishable by action to recover actual monetary loss, or $500, whichever is greater, for each violation. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Documentation says DECIMAL is floating-point but it is fixed-point
On Mon, Aug 20, 2001 at 06:06:22 -0600, Benjamin David Hildred wrote: On Mon, Aug 20, 2001 at 11:08:47AM +0200, Ernst Kloppenburg wrote: Description: with DECIMAL the number of digits before and after the decimal point is fixed. Thus it should be described in the documentation as a fixed point number How-To-Repeat: the manual is correct. the number is stored internaly as a floating point number with all of its benifets and drawbacks. formating information is only used when the number is retrieved. if a number is stored in atable with more significant digets than the coulum will alow, and the table is later restructured to show aditional precision, the number will show mour preciosion. try it. Hello, did you maybe mix this up with DOUBLE(M,D)? DOUBLE is of course stored as a float and M and D control the display at retrieval of a number. For DECIMAL the manual says the number is stored as a string, using one character for each digit of the value. The decimal point and, for negative numbers, the `-' sign, are not counted in M (but space for these are reserved). If D is 0, values will have no decimal point or fractional part. The maximum range of DECIMAL values is the same as for DOUBLE, but the actual range for a given DECIMAL column may be constrained by the choice of M and D. I still think this sounds like *storing* in a fixed point format. E. Kloppenburg -- Dr. Ernst Kloppenburg Robert Bosch GmbH, Abt. FV/FLI Tel. 0711/811-6739, BCN 9020-6739 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Speaking of tree searches
Hans Zaunere wrote: Maybe it's just me, but it sounds like you need to reconsider you're database structure. I can't think of any reason that such a schema would be required. It's simply a database of locations on the globe, and I need to calculate how to get to one place from another using any locations in between. The database layout is one simple table with all of the point info, such as latitude and longitude, on each record. The recursive calculation to search all possible routes and pick the best one isn't too hard, I'm just worried that the number of database queries all at one time as the function digs down into itself might overload the server. Frank. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Documentation says DECIMAL is floating-point but it is fixed-point
On Mon, Aug 20, 2001 at 06:39:55 -0600, Benjamin David Hildred wrote: On Mon, Aug 20, 2001 at 02:00:29PM +0200, Kloppenburg Ernst (FV/FLI) * wrote: On Mon, Aug 20, 2001 at 06:06:22 -0600, Benjamin David Hildred wrote: On Mon, Aug 20, 2001 at 11:08:47AM +0200, Ernst Kloppenburg wrote: Description: with DECIMAL the number of digits before and after the decimal point is fixed. Thus it should be described in the documentation as a fixed point number How-To-Repeat: the manual is correct. the number is stored internaly as a floating point number with all of its benifets and drawbacks. formating information is only used when the number is retrieved. if a number is stored in atable with more significant digets than the coulum will alow, and the table is later restructured to show aditional precision, the number will show mour preciosion. try it. Hello, did you maybe mix this up with DOUBLE(M,D)? DOUBLE is of course stored as a float and M and D control the display at retrieval of a number. For DECIMAL the manual says the number is stored as a string, using one character for each digit of the value. The decimal point and, for negative numbers, the `-' sign, are not counted in M (but space for these are reserved). If D is 0, values will have no decimal point or fractional part. The maximum range of DECIMAL values is the same as for DOUBLE, but the actual range for a given DECIMAL column may be constrained by the choice of M and D. I still think this sounds like *storing* in a fixed point format. E. Kloppenburg sorry about the misinormation, I was using a verry old manual. recent versions do have a bcd number types. checking the most recent manual (online) in section 6.2.1: Numeric Types, in paragraph two it says explecetly that they are not folating point. So what was the complaint? In the overview at the beginning of section 6.2 (before the start of 6.2.1), DECIMAL is described as An unpacked floating-point number This is the statement I find misleading. I think the term fixed-point number should be used here. Of course, in 6.2.1 things become very clear, but if you do not read that far... E. Kloppenburg -- Dr. Ernst Kloppenburg Robert Bosch GmbH, Abt. FV/FLI Tel. 0711/811-6739, BCN 9020-6739 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Speaking of tree searches
Definitely pull the data out into an array with one large query. It'll be much faster than the thousands/millions of queries you'd be generating otherwise. Graph-theory problems like this go exponential really fast. Rene At 02:05 PM 8/20/01, you wrote: Hans Zaunere wrote: Maybe it's just me, but it sounds like you need to reconsider you're database structure. I can't think of any reason that such a schema would be required. It's simply a database of locations on the globe, and I need to calculate how to get to one place from another using any locations in between. The database layout is one simple table with all of the point info, such as latitude and longitude, on each record. The recursive calculation to search all possible routes and pick the best one isn't too hard, I'm just worried that the number of database queries all at one time as the function digs down into itself might overload the server. -- René Churchill [EMAIL PROTECTED] Vermont Web Wizard, LLC802-244-5151 Specializing in Web Programming802-244-5512 (fax) http://www.vtwebwizard.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: compile error - ld: cannot find -lrt
Faine, Mark writes: Ok, so I've downgraded my compiler (gcc) to 2.95.3 since mysql seems to be incompatible with 3.0, yet I'm still getting an error during the make: /usr/local/sparc-sun-solaris2.8/bin/ld: cannot find -lrt collect2: ld returned 1 exit status make[3]: *** [mysqld] Error 1 make[3]: Leaving directory `/export/home6/temp/mysql-3.23.41/sql' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory `/export/home6/temp/mysql-3.23.41/sql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/export/home6/temp/mysql-3.23.41' make: *** [all-recursive-am] Error 2 my config: ./configure --enable-static --enable-assembler --disable-shared --with-libwrap --without-debug --with-mysqld-ldflags=-all-static --without-docs --without-bench --with-charset=latin1 --with-berkeley-db --with-innodb --with-mysqld-user=mysql OS: Solaris 8 Looks like a missing library to me but I checked and it's there? -Mark MySQL builds just fine with gcc 3.0. All you have to do is : export CXXLD=g++ prior to running configure -- 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
MySQL OLEDB
Hello, I us emysql oledb driver to connect on my database. When I use that localy on the computer where mysql run, I can connect correctly on any of my database. When I try from another computer (where I have installed the MySQL oledb driver) I get this message. Why ? Test connection failed because of an error in initializing provider. Catastrophic Failure... P.S.: I have try from more than one diferrent computer running Windows 2000 professionnal... Tanks for your help... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: synchronisation (replication)
On Thu, Aug 16, 2001 at 12:20:07PM +, Neil Tompkins wrote: Hello Below is a message I posted earlier. But what I'm really looking for is does MySQL provide synchrosisation of data. If so, can someone point me in the right direction Yes it does. It is described in the Replication section of the manual, as I alluded to in my original reply. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 3 days, processed 40,062,735 queries (139/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
innodb on linux raw partitions
Hello I read in http://www.mysql.com/doc/I/n/InnoDB_Disk_i_o.html that Innodb supports raw partitions on some unixes. We look forward to use innodb on debian (intel): are linux raw partitions supported? Is it wise to try to use linux2.4 raw partitions with innodb on a production system? I haven't found linux documentation about raw partitions. Has anyone a pointer? One question I have: is it possible to mirror (software RAID 1) raw partitions on linux? (If not then I guess they are pretty useless without a hardware raid). Some thoughts about possible loss of memory due to using buffered (non-raw) partitions: We will use mysql-innodb on the same machine as apache. Apache will serve static files (about 200 MB or so, growing; most hits go to a small subset of this, however) which are generated from innodb content. Most items are requested from static files much more often (i.e. 1000's of times more) than from innodb. Some (personalized stuff) are requested as often from innodb than from cache. I guess because of these usage patterns linux will use most disk buffer for apache's files, not for the innodb partition, so there won't be much loss of memory? If I make an infrequent mysql query that has to read most of the tables content (i.e. 200MB out of the 800MB used table space), is linux throwing away all disk buffers used by apache in favour of the innodb partition, or is it recognizing that apache will request it's buffers soon again? (Ideally innodb partition reads would buffer only for a short p! eriod (since innodb has it's own buffer anyway) and thus only take little memory.) (I've been planning to use 512MB ram on this machine.) christian. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Formatting the DATE field on a web page
Hi people I am using mySQL and PHP for my web page database management thingy. I've managed to get my date field from my Table into my page ($myDate). I was wondering, how would I format the date from -MM-DD format to something a bit nicer like DD/MM/YY ? Is this meant to be a SQL side thing or a server side language formatting thingy? Thanxs Steve Griff. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Failover
I have two identical primarily readonly databases that I want to be able to upgrade on the fly. What I want to be able to do is take one down and have all my connections redirected to the second database automatically. I would also like the same auto failover when a database crashes, because of cpu, disk, etc. In oracle I can setup tnsnames failover. Is there a similar mechanism in MYSQL to redirect failed connections to a secondary database? Thanks, Dave Turner - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: innodb on linux raw partitions
Christian, Linux raw partitions are of course supported. Peter Duffy already got them working with 3.23.40. In .41 I have removed data file size checks if you put the keyword 'newraw' or 'raw' after the file size. Look in the manual! The idea in using raw partitions is that then the i/o bypasses the operating system file cache. Thus InnoDB reads will not push away web content that you have in the operating system file cache. Also the efficiency problems in Linux fsync should be avoidable this way. Another good thing is that bugs in the Linux file system cannot lose whole raw partitions :). But to make sure that this works as expected in Linux, I need reports from users, for example you Christian :). I do not know about software RAID on raw partitions. An option is that I implement software RAID inside InnoDB, since I have the impression that current sofware RAID is not reliable in Linux. Regards, Heikki http://www.innodb.com Peter Duffy's message from the mailing list, July 17: Hi, In the InnoDB section of the MySQL manual, it mentions that InnoDB can be used with raw disks, rather than data files. I've been trying to get this to work under Linux (RedHat 6.2), but so far without success. I installed a new slave disk on the second IDE bus, brought up the system and verified that the disk was available and partitionable at /dev/hdd. Then, in /etc/my.cnf, I pointed innodb_data_home_dir and innodb_data_file_path at /dev/hdd, with a size calculated from the autodetected values as reported in /var/log/messages. I then started mysql: it reported that the given size was not the same as the actual file size for /dev/hdd, and ended. I delved into the code and ran a few experiments: the problem appears to be that the code uses the lseek system call to determine the file size, and this reports 0 for the /dev/hdd device special file. I tried using a raw device grafted onto the /dev/hdd device, but sameresult. Has anyone else tried this under Linux and, if so, have they got it to work? (If not, do we have a route towards getting it to work?) .. Copied message: Hello I read in http://www.mysql.com/doc/I/n/InnoDB_Disk_i_o.html that Innodb supports raw partitions on some unixes. We look forward to use innodb on debian (intel): are linux raw partitions supported? Is it wise to try to use linux2.4 raw partitions with innodb on a production system? I haven't found linux documentation about raw partitions. Has anyone a pointer? One question I have: is it possible to mirror (software RAID 1) raw partitions on linux? (If not then I guess they are pretty useless without a hardware raid). Some thoughts about possible loss of memory due to using buffered (non-raw) partitions: We will use mysql-innodb on the same machine as apache. Apache will serve static files (about 200 MB or so, growing; most hits go to a small subset of this, however) which are generated from innodb content. Most items are requested from static files much more often (i.e. 1000's of times more) than from innodb. Some (personalized stuff) are requested as often from innodb than from cache. I guess because of these usage patterns linux will use most disk buffer for apache's files, not for the innodb partition, so there won't be much loss of memory? If I make an infrequent mysql query that has to read most of the tables content (i.e. 200MB out of the 800MB used table space), is linux throwing away all disk buffers used by apache in favour of the innodb partition, or is it recognizing that apache will request it's buffers soon again? (Ideally innodb partition reads would buffer only for a short p! eriod (since innodb has it's own buffer anyway) and thus only take little memory.) (I've been planning to use 512MB ram on this machine.) christian. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Formatting the DATE field on a web page
Hi Steve, have a look at the DATE_FORMAT(date,format) function. You can retrieve the date in exactly the format you want doing it on the SQL side. Thomas On Mon, 20 Aug 2001, pc wrote: Hi people I am using mySQL and PHP for my web page database management thingy. I've managed to get my date field from my Table into my page ($myDate). I was wondering, how would I format the date from -MM-DD format to something a bit nicer like DD/MM/YY ? Is this meant to be a SQL side thing or a server side language formatting thingy? Thanxs Steve Griff. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 OLEDB
Hi !!! )-Original Message- )From: Bruce Stewart [mailto:[EMAIL PROTECTED]] )Sent: Monday, August 20, 2001 8:41 AM )To: 'Roy, Steeve'; [EMAIL PROTECTED] )Subject: RE: MySQL OLEDB ) ) )Steeve, ) )I have had the same problem for months, with no solutions. )If you find a solution, please let be know. ) )Thanks, )Bruce ) )-Original Message- )From: Roy, Steeve [mailto:[EMAIL PROTECTED]] )Sent: Mon, 20 August 2001 16:21 )To: '[EMAIL PROTECTED]' )Subject: MySQL OLEDB ) ) )Hello, I us emysql oledb driver to connect on my database. When I use that )localy on the computer where mysql run, I can connect correctly on )any of my )database. When I try from another computer (where I have installed )the MySQL )oledb driver) I get this message. Why ? ) ) ) Test connection failed because of an error in initializing provider. )Catastrophic Failure... ) ) ) P.S.: I have try from more than one diferrent computer )running Windows )2000 professionnal... ) Only one option I can think is MSDSDK. Did you installed it on the second system where you are getting the catastrophic error ? If it is, try to install the same version of the original one (MSDSDK) on the second one and see whether it works or not. Regards Venu -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Woodside, California USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: FreeBSD and multiple daemons
Hi Jerry, Someone has already answered why the load stays at 1.3 to 1.5. Sounds like one query may be slowing down the others, mytop (/usr/ports/databases/mytop) might help identify that query also try enabling the slow-log and track down any long queries. Have you tuned any of the cache parameters for the large amount of memory you have? Examples can be found in the support-files directory of MySQL. What options were used to compile MySQL? This can affect FreeBSD, the ports (/usr/ports/databases/mysql323-server) has excellent parameters for building MySQL (see the make file or my previous posts on this subject). To answer your other question, running two daemons on the same databases in not necessasarily a good idea. First, you will have to have one listen on a different port and second there may be file locking issues. However, if you install from the ports you can build MySQL with WITH-LINUXTHREADS=yes which will use both processors, but that may not help you if the problem is a locked table or slow query, I have found processor usage on my 800mhz systems to be typically 12 to 25% of one processor. Third of course is the option of purchasing a support contract from MySQL AB. Their commercial support is excellent ( see http://www.mysql.com/support/arrangements/types.html or http://www.mysql.com/support/index.html ) I recommend this if you are running a server that must be up (like we are!). Hope this helps, Ken - Original Message - From: PR [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, August 19, 2001 2:27 AM Subject: FreeBSD and multiple daemons I'm having a problem with my server getting bogged down once in a while and I'm pretty sure it's due to the mysql daemon getting maxed out with what it can do... when this happens there might be anywhere from 100 to 150 processes in the processlist and it might take as much as 30 seconds to return a query via a web browser. When it happens mysql is usually using almost 100% cpu, but load stays around 1.3 to 1.5. I'm running FreeBSD 4.3-Release and mysql 3.23.40 We recently upgraded both because of some of the past comments about the sleeping threads on the list in slightly older versions. The server is dual P3-1G, 1g ram with SCSI drives on single channel raid card. Is there a very stable way to run multiple daemons on FreeBSD? A howto or some such thing that might describe setting it up. I can run the memory up to 4g on the machine if necessary to handle the extra memory requirements. Also, are there changes I'll have to make to my apps that use mysql to deal with this? I searched the list for multiple daemons and didn't find much there, maybe I'm using the wrong keywords to search for. Any pointers or help would be greatly appreciated. Jerry - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Formatting the DATE field on a web page
Hi As the Perl hackers say, tmtowtdt (there's more than one way to do this) - you are free to do format your dates wherever you like. If you're that way inclined you could even do the formatting on the client side in JavaScript ;-) IIRC correctly PHP offers a lot of inbuilt date formatting wotsits. In SQL (at least MySQL, database developers also believe tmtowtdt ;-) you can use the DATE_FORMAT function, see: http://www.mysql.com/doc/D/a/Date_and_time_functions.html HTH Ian Barwick [EMAIL PROTECTED] On Monday 20 August 2001 18:02, pc wrote: Hi people I am using mySQL and PHP for my web page database management thingy. I've managed to get my date field from my Table into my page ($myDate). I was wondering, how would I format the date from -MM-DD format to something a bit nicer like DD/MM/YY ? Is this meant to be a SQL side thing or a server side language formatting thingy? -- Ian Barwick - Developer - [EMAIL PROTECTED] akademie.de asp GmbH - http://www.akademie.de To query tables in a MySQL database is more fun than eating spam - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
libmysql - secure connection
If I'm using libmysql to connect from Delphi to mysql - does it automatically provide a secure connection then? Regards Elizabeth
error creating webobjects tables with mysql
config: debian linux testing, kernel 2.2.18pre21, mysql 3.23.36, webobjects 5 I copied the sql from eomodeler and am attempting to use it with mysql. it says: ERROR 1064 at line 35: You have an error in your SQL syntax near ')' at line 1 here's an excerpt from the sql: 30 31 CREATE TABLE story_assets (asset_id int , id int NOT NULL, story_id int ); 32 33 CREATE TABLE story_types (id int NOT NULL, story_type char(50) ); 34 35 CREATE TABLE EO_PK_TABLE (NAME char(40), PK long); 36 37 ALTER TABLE EO_PK_TABLE ADD PRIMARY KEY (NAME); 38 39 CREATE UNIQUE INDEX EO_PK_TABLE NAME; 40 help, please. Paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
setting a character set
I'm trying to use a charset different than latin1. I did this: I created a file - c:\my.cnf - and inserted the following text into it: [client] default-character-set=win1250 I restarted mysql server and I still have latin1. What am I doing wrong ? Thanks, Tadej P.S. For the filter: database,sql,query,table How about including 'mysql' in filter words ??? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 becomes slow
-- I am having the same kind of difficulty. Slow returns on results. It may be bad database architecture or implementation (perhaps both), but I need to be able to pick out text fragments . . . like %value%. I understand that indexes do not help with LIKE %value% queries, is there anything else that I can do to speed up the return on results. Thanks, Brett Osus writes: Hi, SELECT * FROM table WHERE OK=1 it gets about 4 or 5 second at least. I have indexes. That main table have 27 indexes to supply all possible searches. Some searches are made on text fileds, something like WHERE field like '%key%' being field text field. I have updated mysql and apache, checked, repaired, optimized tables. I run fschk on all the partitions. What can I do? I need to reduce that times... Thanks Having 27 indexes and using queries with LIKE %...% is a nice recepee for slowness. Try normalising your schema and using fulltext search instead of LIKE %...%. %..% queries can't use indices. -- 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: error creating webobjects tables with mysql
here's another error: ERROR 1064 at line 80: You have an error in your SQL syntax near 'id' at line 1 the offending line: create index ad_sections id; according to the docs, the syntax is: CREATE [UNIQUE|FULLTEXT] INDEX index_name ON tbl_name (col_name[(length)],... ) so i tried: CREATE INDEX ad_sections ON ad_sections id; no luck. Paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: innodb on linux raw partitions
On Mon, Aug 20, 2001 at 07:35:17PM +0300, Heikki Tuuri wrote: I have the impression that current sofware RAID is not reliable in Linux. Does this impression come from your bad experiences or those of others? I ask because we're about to upgrade one of our Linux MySQL servers to the 2.4.x kernel series and are looking to use software RAID + ReiserFS on it. If that's a lost cause, it'll save us some work and frustration knowing sooner rather than later... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 3 days, processed 42,982,312 queries (144/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql becomes slow
winnecon writes: -- I am having the same kind of difficulty. Slow returns on results. It may be bad database architecture or implementation (perhaps both), but I need to be able to pick out text fragments . . . like %value%. I understand that indexes do not help with LIKE %value% queries, is there anything else that I can do to speed up the return on results. Thanks, Brett Of course. Use FULLTEXT indexing. Read a manual on the subject. -- 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: setting a character set
Tadej Guzej writes: I'm trying to use a charset different than latin1. I did this: I created a file - c:\my.cnf - and inserted the following text into it: [client] default-character-set=win1250 I restarted mysql server and I still have latin1. What am I doing wrong ? Thanks, Tadej P.S. For the filter: database,sql,query,table How about including 'mysql' in filter words ??? May be you can try putting it under [mysqld] options header. Kak je v Sloveniji ?? -- 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
RH Linux 7.1 - Source or Binary
Good Afternoon, I have read conflicting reports in the MySQL documentation concerning which type of MySQL is better to install in Linux - Source or Binary? Can some of you please enlighten me to which type you prefer or which you have been successful with? Thank you in advance. -Rob *** Robert T. Hoey Systems Analyst I Management Information Systems Division NEC America, Inc. E-mail: [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
Replication and temporary tables
Is there any reason why I shouldn't create temporary tables on a slave server? The tables only last until the client closes its connection, they aren't visible to other clients. I don't do any INSERT INTO permanentTable SELECT ... FROM temporaryTable - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: innodb on linux raw partitions
Hi! My impression comes from a MySQL AB computer with Red Hat 6.2 (kernel something like 2.2.19). There were strange disk read errors. I tracked it down to a problem where 8 bytes sometimes were reset to zero at an 8 kB page boundary when the OS had read a large block of about 300 kB. Also, just today a large MySQL user reported a software RAID 'meltdown' with kernel 2.4, I think. It is encouraging to hear good experiences from others :). Regards, Heikki -Original Message- From: Matt Wagner [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Cc: Heikki Tuuri [EMAIL PROTECTED] Date: Monday, August 20, 2001 10:02 PM Subject: Re: innodb on linux raw partitions Jeremy Zawodny writes: On Mon, Aug 20, 2001 at 07:35:17PM +0300, Heikki Tuuri wrote: I have the impression that current sofware RAID is not reliable in Linux. Does this impression come from your bad experiences or those of others? I ask because we're about to upgrade one of our Linux MySQL servers to the 2.4.x kernel series and are looking to use software RAID + ReiserFS on it. If that's a lost cause, it'll save us some work and frustration knowing sooner rather than later... Jeremy/Heikki, I have been running kernel 2.4.x with Software RAID + ReiserFS on all of my systems ever since 2.4 came out. I've never experienced any problems. It has been a great combination for me. Although I've never gone thru an HD crash/recovery with this setup yet... :) We also run many systems at MySQL AB with Software RAID, although those systems are not using ReiserFS, but EXT2 instead. Same experiences, it's been completely stable; however we've never had to deal with HD crash/recovery yet. Regards, Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with nested delete - help
On Sat, 18 Aug 2001, Ram wrote: Date: Sat, 18 Aug 2001 06:16:39 -0700 (PDT) From: Ram [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Problem with nested delete - help Hi, I have a problem with nested delete query. I want to delete some record from one table based on the select result of another query. e.g. delete from tab1 where uid in (select uid from tab2 where today = 'any_date'); Will it work? Not in the database. You will have to do this at the application level, i.e., do one query to get the uid's from tab2 and then issue separate deletes for each uid. Quite fast with prepared statements in perl. I tried, but it says that 'syntex error near 'select.' at line 1. If anybody know how to do that, ple let me know. Thanks in advance. Ram __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: RH Linux 7.1 - Source or Binary
[EMAIL PROTECTED] writes: I have read conflicting reports in the MySQL documentation concerning which type of MySQL is better to install in Linux - Source or Binary? Can some of you please enlighten me to which type you prefer or which you have been successful with? Source can be tuned more, the binary ones shipped with Red Hat Linux 7.1 have been regression tested, tested for integration with other components etc. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication and temporary tables
On Mon, Aug 20, 2001 at 02:04:09PM -0500, Mike Wexler wrote: Is there any reason why I shouldn't create temporary tables on a slave server? The tables only last until the client closes its connection, they aren't visible to other clients. I don't do any INSERT INTO permanentTable SELECT ... FROM temporaryTable As long as the slave isn't also a master for another slave, things should work as expected. Even if it is, you probably won't run into problems, but I haven't tried... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 3 days, processed 44,177,066 queries (145/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
Problem with INSERT INTO ... SELECT
Hello, This is the situation: Table1: ID Startnr TijdAfstand SlagDatum Opmerking CRvan CRtot PR Categorie Table2: Identical columns. What is the problem? I'm trying to append all the values from table2 to table1. I was trying this SQL query: insert into table1 select Startnr, Tijd, Afstand, Slag, Datum, Opmerking, CRvan,CRtot,PR,Categorie from table2; This doesn't work, it says Column count doesn't match value count at row 1 I understand the problem. But I can't use my ID column in the select query because both tables have an AUTO INCREMENT ID. Does someone have any suggestions how to work around this?? Thanks in advance Michiel Leegwater - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Failover
On Mon, Aug 20, 2001 at 09:28:20AM -0700, David Turner wrote: I have two identical primarily readonly databases that I want to be able to upgrade on the fly. What I want to be able to do is take one down and have all my connections redirected to the second database automatically. I would also like the same auto failover when a database crashes, because of cpu, disk, etc. In oracle I can setup tnsnames failover. Is there a similar mechanism in MYSQL to redirect failed connections to a secondary database? There is not mechanism built into MySQL currently. You might look at the Linux Virtual Server (LVS) for a solution. I believe it'll give you just what you're looking for... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 3 days, processed 44,686,278 queries (146/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: innodb on linux raw partitions
On 20 Aug 2001 11:09:37 -0700, Jeremy Zawodny wrote: Does this impression come from your bad experiences or those of others? I ask because we're about to upgrade one of our Linux MySQL servers to the 2.4.x kernel series and are looking to use software RAID + ReiserFS on it. If that's a lost cause, it'll save us some work and frustration knowing sooner rather than later... Maybe this is not what you want to know but hardware IDE controller is really cheap. I personally prefer cheap tuned ATA100 disks on top of hardware RAID. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ 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: Failover
Great, thanks, Dave On Mon, Aug 20, 2001 at 01:04:10PM -0700, Jeremy Zawodny wrote: On Mon, Aug 20, 2001 at 09:28:20AM -0700, David Turner wrote: I have two identical primarily readonly databases that I want to be able to upgrade on the fly. What I want to be able to do is take one down and have all my connections redirected to the second database automatically. I would also like the same auto failover when a database crashes, because of cpu, disk, etc. In oracle I can setup tnsnames failover. Is there a similar mechanism in MYSQL to redirect failed connections to a secondary database? There is not mechanism built into MySQL currently. You might look at the Linux Virtual Server (LVS) for a solution. I believe it'll give you just what you're looking for... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 3 days, processed 44,686,278 queries (146/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Problem with INSERT INTO ... SELECT
Michiel i believe you need to tell the target what fields it will have too... INSERT INTO Table1 (A, B) SELECT Table2.A, Table2.B FROM Table2 Of course you can omit the Table2. part in this trivial case. making it INSERT INTO Table1 (A, B) SELECT A, B FROM Table2 -Original Message- From: Michiel Leegwater [mailto:[EMAIL PROTECTED]] Sent: Monday, August 20, 2001 3:25 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Problem with INSERT INTO ... SELECT Hello, This is the situation: Table1: ID Startnr TijdAfstand SlagDatum Opmerking CRvan CRtot PR Categorie Table2: Identical columns. What is the problem? I'm trying to append all the values from table2 to table1. I was trying this SQL query: insert into table1 select Startnr, Tijd, Afstand, Slag, Datum, Opmerking, CRvan,CRtot,PR,Categorie from table2; This doesn't work, it says Column count doesn't match value count at row 1 I understand the problem. But I can't use my ID column in the select query because both tables have an AUTO INCREMENT ID. Does someone have any suggestions how to work around this?? Thanks in advance Michiel Leegwater - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Problem with INSERT INTO ... SELECT
On Mon, 20 Aug 2001, Michiel Leegwater wrote: insert into table1 select Startnr, Tijd, Afstand, Slag, Datum, Opmerking, CRvan,CRtot,PR,Categorie from table2; This doesn't work, it says Column count doesn't match value count at row 1 I understand the problem. But I can't use my ID column in the select query because both tables have an AUTO INCREMENT ID. Does someone have any suggestions how to work around this?? What if you do: SELECT NULL, Startnr, Tijd, ... FROM table2 Put NULL in place of the AUTO INCREMENT id. That might work. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Failover
It looks like this will only run on Linux and I must either use Sparc Solaris or X86. I hate to implement the failover within the application. Thanks anyway, Dave On Mon, Aug 20, 2001 at 01:04:10PM -0700, Jeremy Zawodny wrote: On Mon, Aug 20, 2001 at 09:28:20AM -0700, David Turner wrote: I have two identical primarily readonly databases that I want to be able to upgrade on the fly. What I want to be able to do is take one down and have all my connections redirected to the second database automatically. I would also like the same auto failover when a database crashes, because of cpu, disk, etc. In oracle I can setup tnsnames failover. Is there a similar mechanism in MYSQL to redirect failed connections to a secondary database? There is not mechanism built into MySQL currently. You might look at the Linux Virtual Server (LVS) for a solution. I believe it'll give you just what you're looking for... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 3 days, processed 44,686,278 queries (146/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
Install Mysql in Ibm-Aix 4.3.2.0
Please, if anyone could help me. I have a question: - I give a download of mysql 3.23.41 for aix-ibm 4.3.3.0 (binary version), but my version of aix is 4.3.2.0, I don´t know if it is a problem. - The problem is that when I give the instalation command: shell scripts/mysql_install_db I receive this error mensage: Cannot load program ./bin/my_print_defaults because of the following errors: Cannot load library libz.a[shr.o] I know that this instalation give everytime this mensage about libz.a[srh.0] Please What´s this error? Where can I get this library libz.a? Is this because the my version of aix is 4.3.2.0 instead 4.3.3.0? Thanks for attention, and excuse me for the english. Simone Cincotto Souto [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
synopsis of the problem (one line)
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.32 (Source distribution) Environment: System: Linux fallenangel 2.4.8 #2 SMP Sat Aug 11 13:37:56 PDT 2001 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/i486-suse-linux/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='-O2 -m486' CXX='c++' CXXFLAGS='-O2 -m486' LDFLAGS='' LIBC: -rwxr-xr-x1 root root 1382179 Jan 18 2001 /lib/libc.so.6 -rw-r--r--1 root root 2585872 Jan 18 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Jan 18 2001 /usr/lib/libc.so -rw-r--r--1 root root 851660 Jan 19 2001 /usr/lib/libc-client.a lrwxrwxrwx1 root root 19 Aug 7 18:02 /usr/lib/libc-client.so - libc-client.so.2000 -rwxr-xr-x1 root root 714876 Jan 19 2001 /usr/lib/libc-client.so.2000 Configure command: ./configure --enable-shared --enable-assembler --infodir=/usr/share/info --libdir=/usr/lib --libexecdir=/usr/sbin --localstatedir=/var/lib/mysql --mandir=/usr/share/man --prefix=/usr --sysconfdir=/etc --with-mysqld-user=mysql --without-debug --datadir=/usr/share --includedir=/usr/include --with-extra-charsets=complex --with-unix-socket-path=/var/lib/mysql/mysql.sock --without-berkeley-db - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: innodb on linux raw partitions
Tonu Samuel [EMAIL PROTECTED] writes: On 20 Aug 2001 11:09:37 -0700, Jeremy Zawodny wrote: Does this impression come from your bad experiences or those of others? I ask because we're about to upgrade one of our Linux MySQL servers to the 2.4.x kernel series and are looking to use software RAID + ReiserFS on it. If that's a lost cause, it'll save us some work and frustration knowing sooner rather than later... Maybe this is not what you want to know but hardware IDE controller is really cheap. I personally prefer cheap tuned ATA100 disks on top of hardware RAID. 3ware is nice :) -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL dump 8.9 and telephone field - need help
MySQL dump 8.9 is doing weird things on me, I wonder what's going on. I have the following SQL column type : com_tel_fax_cr char(3), com_tel_fax_no varchar(8), the com_tel_fax_no is for storing an seven-digit phone number and the '-', ie: 727-1163 When the data is dumped, all char and varchar fields are writed with ' ', but not the com_tel_fax_no varchar. Here is what I get in the MySQL dump file : ... '800',727-1163, ... Notice that there is no ' around the phone number ? Worst, when I run MySQL dump in order to input sql from this file, it does the substraction (727-1163 = -436). I tried removing the - in the middle, didn't help, the field still comes out with no ' '. What puzzles me is that all other varchar and char fields get outputted right. Notice the '800' is the dump file. It does that with all phone number fields. This is stange. Anybody has any idea ? J. Lambert http://perl.xotechnologies.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: innodb on linux raw partitions
On Tue, Aug 21, 2001 at 03:37:28AM +0800, Tonu Samuel wrote: On 20 Aug 2001 11:09:37 -0700, Jeremy Zawodny wrote: Does this impression come from your bad experiences or those of others? I ask because we're about to upgrade one of our Linux MySQL servers to the 2.4.x kernel series and are looking to use software RAID + ReiserFS on it. If that's a lost cause, it'll save us some work and frustration knowing sooner rather than later... Maybe this is not what you want to know but hardware IDE controller is really cheap. I personally prefer cheap tuned ATA100 disks on top of hardware RAID. Well, we've already got these high-end 36GB SCSI drives in the machine... :-) -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 3 days, processed 45,314,758 queries (147/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
Help with a simple query ..
I have 2 tables: bases, and properties base has a ZIPCODE field in the table, as does the properties table. I'm trying to find all bases that do NOT have a property in that zip code. What I've tried is: select distinct cb.*, cp.* from classified_bases as cb left join classified_properties as cp ON cb.ZIP != cp.ZIPCODE where cb.BASEORLOC = 'B' and cb.STATE = 'VA' AND cb.STATE = cp.STATE; but this returns 4 entries for every base (except the one where there is a record, where it returns 3), since there are 4 entries in the properties table. I know WHY it's doing it, it's comparing every base record to each single record in the property table .. I just don't know how to fix it to do what I want. I tried to explain this as best I could, if I need to clarify it some more, let me know. Thanks, Chad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
explain query question
sql optimize Please help me. I can't understand why i've got this results.I have very simple table with name cz Field TypeNullKey Default Extra Privileges tv int(11) MUL 0 select,insert,update,references rez_id int(11) 0 select,insert,update,references it filled with tv rez_id 2 0 2 0 2 0 2 0 2 0 2 0 1 0 1 0 when i do: desc select rez_id from cz.rez_inc where tv=1 i got: table typepossible_keys key key_len ref rowsExtra rez_inc ref tv tv 4 const 2 where used but,when i do: desc select rez_id from cz.rez_inc where tv=2 table typepossible_keys key key_len ref rowsExtra rez_inc ALL tv NULLNULLNULL8 where used is it right? (i mean diffrent TYPE ,key ,ley_len) may be you can advise some articles about mysql optimisation? thanks. -- ___ Talk More, Pay Less with Net2Phone Direct(R), up to 1500 minutes free! http://www.net2phone.com/cgi-bin/link.cgi?143 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
UPDATE problem
Hello, I have created a predictionscompetition and some code counts te total score of a match of a person. On the screen it workes, but in de database it goes wrong. Each person gets the total of the last person. There must be something wrong with the update statement. I hope someone can help me. Cheers, Martin. $number = MYSQL_NUMROWS($result); $i = 0; WHILE ($i $number): $naam = mysql_result($result,$i,naam); $uit_gr = mysql_result($result,$i,uit_gr); $uit_te = mysql_result($result,$i,uit_te); $ru_gr = mysql_result($result,$i,ru_gr); $ru_te = mysql_result($result,$i,ru_te); $minuut = mysql_result($result,$i,minuut); $toto = mysql_result($result,$i,toto); /* Count everything*/ $t01 = $u1+$r1+$b1+$m1+$t1; $sqlb = UPDATE voorspelling1 SET totaal='$t01' WHERE id_voorspelling = '$id_voorspelling'; $resultb = mysql_query($sqlb); PRINT $naam $uit_gr $uit_te $u1 $r1 $b1 $m1 $t1 $t01BR; PRINT $t1BR; $i++; ENDWHILE;
RE: Help with a simple query ..
I have 2 tables: bases, and properties base has a ZIPCODE field in the table, as does the properties table. I'm trying to find all bases that do NOT have a property in that zip code. What I've tried is: The general answer: http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_10_0 In your case, it comes out to something like: SELECT cb.*, cp.* FROM classified_bases AS cb LEFT JOIN classified_properties AS cp ON cb.ZIP = cp.ZIPCODE WHERE cp.ZIPCODE IS NULL AND cb.BASEORLOC = 'B' AND cb.STATE = 'VA' AND cb.STATE = cp.STATE; / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Cancelling a slave
On Sun, Aug 19, 2001 at 02:39:36PM -0600, Michael Blood wrote: I setup a slave on my database by placeing the correct lines in /etc/my.cnf. I have since removed those lines and restarted the server but I still get this line error in my .err file. 010819 14:31:13 Slave thread: error connecting to master:Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)(0), retry in 60 Where else could this be stored at? How can I find exactly which configuration file it actually used? Remove the master.info file on the slave. MySQL doesn't consult my.cnf if the master.info already exists (which, I contend, is a bug). Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 3 days, processed 46,496,356 queries (149/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help with a simple query ..
Try this. I couldn't find if MYSQL supports not in's so I followed there outer joins. You can read up on in in the mysql manual, do a search on outer joins. select base.zipcode,properties.zipcode from base right join properties on base.zipcode=properties.zipcode where base.zipcode is null; On Mon, Aug 20, 2001 at 04:39:11PM -0400, Chad Day wrote: I have 2 tables: bases, and properties base has a ZIPCODE field in the table, as does the properties table. I'm trying to find all bases that do NOT have a property in that zip code. What I've tried is: select distinct cb.*, cp.* from classified_bases as cb left join classified_properties as cp ON cb.ZIP != cp.ZIPCODE where cb.BASEORLOC = 'B' and cb.STATE = 'VA' AND cb.STATE = cp.STATE; but this returns 4 entries for every base (except the one where there is a record, where it returns 3), since there are 4 entries in the properties table. I know WHY it's doing it, it's comparing every base record to each single record in the property table .. I just don't know how to fix it to do what I want. I tried to explain this as best I could, if I need to clarify it some more, let me know. Thanks, Chad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Aliasing
Is there a way to have MySQL label columns returned from a select query with the complete column name, in table.column format? So if a column name is id, which is in the main table, can MySQL return main.id instead of just id. Sure I could alias each column, but if there is 30 columns, that's a lot of aliasing. Is there a way to alias a whole table, so each returned column is prefixed by a specified string? Any feedback would be great. Thank you Hans [EMAIL PROTECTED] __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Invalid authorization specification: Access denied for user: 'prodoc@ns' (Using password: YES)
Dear Madam, Sir, I created a new user with : ./mysql -u root -p1234 mysql grant select,insert,update,delete,create,drop on prodoc to prodoc@% identified by '1234'; In my asp script that is opening the connection I use : cnnString = DRIVER=org.gjt.mm.mysql.Driver;URL={jdbc:mysql://xxx.xxx.xxx.xx:3306/dbname };uid=username;pwd=1234; The error : Invalid authorization specification: Access denied for user: 'username@ns' (Using password: YES) Strange thing is that when I replace username with root, all works well... I even creates an admin with full rights, both for localhost and @%, but still no good. All hints are wellcome. Kind regards, Harry M. Aasterud - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
notice from your webhost
This email is being sent to you on behalf of your current webspace provider. This message is not a spam or junk email, your email address was supplied to WebHosting.com You will not receive any more messages from WebHosting.com this is a one time special offer notice. WebHosting.com is offering a selected number of webhost's member's the following special offer. This offer is not available on our website at www.webhosting.com or anywhere else, this is a special offer and is valid only for a limitied time. Read on to learn more about this amazing offer. For only $6.25 (one time fee) you can get: 500mb webspace unlimited pop3 email addresses cgi-bin full ftp access php, ssi, my-sql, asp support mySQL database FREE DOMAIN REGISTRATION (.com .net .org) unlimited bandwidth miva merchant account secure server for transactions accept credit cards 24hour technical support You did read it right, all this will only cost you $6.25. There are no monthly fees or any other costs. You are probably wondering how WebHosting.com can offer all this for the very low price of only $6.25, the answer is that WebHosting.com will make a lot of revenue from extra webspace charges - people wishing to have more than 500mb can pay $10 per 10mb per month. If you would like to receive this excellent offer all you have to do is send your details to the following email address and your username and password will be emailed to you within 5 business days. Then you will be able to login at the members area of WebHosting.com and configure your account (add domains, setup scripts etc.). Please send all of the following details: Your Full Name Your Full Address Your Phone Number Your Email Address Your Credit Card Number Your Credit Card Expiry Date Your Credit Card Type (eg. visa, mastercard etc.) Send all of the above to [EMAIL PROTECTED] Thank you and I hope you enjoy this very special offer John Simmons Head of Special Promotions, Webhosting.com - WebHosting.com is a member of the CNS International Internet Businesses Association - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 v.3.23.41 - Brazilian Portuguese Error Messages Files Update
Hello, I'm forwarding you the attached file named- mysql_3.23.41_pt-brazil.zip - which containsthe updatedBrazilian Portuguese idiom version of files ERRMSG.TXT and ERRMSG.SYS, to be parked in directory mySQL\share\portuguese. Thetranslation of error messages to Brazilian Portuguese idiom were again checked, revised and extended. So, they are now trackingexactly the current 3.23.41 English version of mySQL. Any problems, please, let me know.Best Regards, Roberto de Martin Serqueira P.S.: In order to compensate an eventual stripping of my attachment by your mailing list manager, I have also uploaded the referred file to address ftp://support.mysql.com:/pub/mysql/Incoming. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
information about ADODB for PHP4
is there a source for further information connecting to databases with ADODB for PHP4? I only know http://php.weblogs.com/ADODB -- WA-P : Jochen Kaechelin Programmierung - Beratung - Hosting Stuttgarter Strasse 3, D-73033 Göppingen Tel. 07161 - 92 95 94, Fax 92 95 98 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: innodb on linux raw partitions
On Mon, 20 Aug 2001 22:24:26 +0300 Heikki Tuuri [EMAIL PROTECTED] wrote: My impression comes from a MySQL AB computer with Red Hat 6.2 (kernel something like 2.2.19). From what I read, RedHat often patches their kernels with inofficial stuff (and the famous inofficial/buggy gcc thing (in 7.0) says probably enough, too). BTW yes, I've almost forgotten about the discussion from last month. (Well I hadn't seen the success of Peter Duffy). So I'll try it out in a few days. Christian. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
compilation problem
Description: When I compiled my program with the new installed mysql-3.23.41-pc-linux-gnu-i686 binary version I got the following eror message: gcc -I. -I/usr/local/mysql/include regprg.c net.o util2k.o httppost.c syslog.o -o regprg -L. -L/usr/local/mysql/lib -lmysqlclient /usr/local/mysql/lib/libmysqlclient.a(my_compress.o): In function `my_uncompress': my_compress.o(.text+0x9a): undefined reference to `uncompress' /usr/local/mysql/lib/libmysqlclient.a(my_compress.o): In function `my_compress_alloc': my_compress.o(.text+0x12a): undefined reference to `compress' collect2: ld returned 1 exit status make: *** [regprg] Error 1 How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:Kenneth Chao Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: compilation problem Severity: Priority: Category: mysql Class: Release: mysql-3.23.41 (Official MySQL binary) Environment: System: Linux test.acermsoft.com 2.2.14-5.0 #1 Tue Mar 7 21:07:39 EST 2000 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/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='-O3 -mpentium ' CXX='gcc' CXXFLAGS='-O3 -mpentium -felide-constructors' LDFLAGS='-static' LIBC: lrwxrwxrwx1 root root 13 Jul 26 03:25 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x1 root root 4101324 Mar 1 2000 /lib/libc-2.1.3.so -rw-r--r--1 root root 20272704 Mar 1 2000 /usr/lib/libc.a -rw-r--r--1 root root 178 Mar 1 2000 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared Perl: This is perl, version 5.005_03 built for i386-linux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
replace/insert into ... 150,000 -plus rows
The problem= The 'addy1' column or field (in attdata) is tainted with incorrect data entries ... e.g. 'addy1' should only have addresses stored however, some bright person(s) have managed to input company names in the address/addy1 field. I'm presented the task of fixing this data before incorporating it into my *mysql database*. I have chosen the following method in an attempt to get the above done. In my 'attdata' table I have the following fields: id INT(9) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, comp VARCHAR(70) NULL, addy1 VARCHAR(50) NULL, - In my 'biz' table I have these fields: cid INT(9) NULL, bname VARCHAR(70) NULL, baddy VARCHAR(25) NULL, populating biz.cid -and- biz.bname *from* attdata.id -and- attdata.comp using the following syntax works; insert into biz (cid, bname) select id, comp from attdata; -- no need for selective insert; data in these fields are *not* tainted. (the above worked like as described) - Now the immediate problem. This third field attdata.addy1 has the wrong data entered in in thousands of rows. e.g this is an address field, someone entered company names in this field on certain rows. I resort to using regexp within a where-clause to facilitate selectively extracting from attdata.addy1 then, inserting/replacing those entries/addresses beginning with 0-9 into the biz.baddy column. Below is the syntax I use and the results: mysql insert into biz (baddy) select addy1 from attdata where addy1 regexp ^[0-9]; Query OK, 173012 rows affected (23.70 sec) Records: 173012 Duplicates: 0 Warnings: 0 Everything looks ok from this output but, when I query the biz.baddy... nothing at all was inserted or replaced in to the biz.baddy column for any rows. I have also tried other syntax variants such as: mysql insert biz (baddy) select addy1 from attdata where addy1 regexp ^[0-9]; mysql replace into biz (baddy) select addy1 from attdata where addy1 regexp ^[0-9]; mysql replace biz (baddy) select addy1 from attdata where addy1 regexp ^[0-9]; - I have also tried changing the default value of the column from NULL to 'not null then re-ran all the above syntax and still, I can *not* get the biz.baddy to be replaced with the data extracted from attdata.addy1. - NOTE: all of the above happens when I first use the following syntax: insert into biz (cid, bname) select id, comp from attdata; - NOTE-2: If I start with a completely empty biz table and issue either of the following queries, all the data is transferred properly but, this would defeat my purpose (remember) the addy1 field is tainted with company names in the address field. mysql insert into biz (cid, bname, baddy) select id, comp, addy1 from attdata; mysql insert into biz (cid, bname, baddy) select id, comp, addy1 from attdata where addy1 regexp ^[0-9]; The cherry on top of this ice-cream cone is, update will fix my issue however I have over 150,000 rows of data that are pretty much messed-up because of the tainted 'addy1' field. Can you imagine the time and, possibly even more mistakes that would take place if update had to be done on every row just to fix this? I'll not trust this task to anyone other than myself. Any Ideas on what I am typing wrong within the insert/replace syntax shown above? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: Correction added= replace/insert into
Sorry for the duplicate msg. I forgot to state what version server I was running (next line) server version: 3.23.32 - Original Message - From: Network [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 20, 2001 11:38 PM Subject: replace/insert into ... 150,000 -plus rows The problem= The 'addy1' column or field (in attdata) is tainted with incorrect data entries ... e.g. 'addy1' should only have addresses stored however, some bright person(s) have managed to input company names in the address/addy1 field. I'm presented the task of fixing this data before incorporating it into my *mysql database*. I have chosen the following method in an attempt to get the above done. In my 'attdata' table I have the following fields: id INT(9) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, comp VARCHAR(70) NULL, addy1 VARCHAR(50) NULL, - In my 'biz' table I have these fields: cid INT(9) NULL, bname VARCHAR(70) NULL, baddy VARCHAR(25) NULL, populating biz.cid -and- biz.bname *from* attdata.id -and- attdata.comp using the following syntax works; insert into biz (cid, bname) select id, comp from attdata; -- no need for selective insert; data in these fields are *not* tainted. (the above worked like as described) - Now the immediate problem. This third field attdata.addy1 has the wrong data entered in in thousands of rows. e.g this is an address field, someone entered company names in this field on certain rows. I resort to using regexp within a where-clause to facilitate selectively extracting from attdata.addy1 then, inserting/replacing those entries/addresses beginning with 0-9 into the biz.baddy column. Below is the syntax I use and the results: mysql insert into biz (baddy) select addy1 from attdata where addy1 regexp ^[0-9]; Query OK, 173012 rows affected (23.70 sec) Records: 173012 Duplicates: 0 Warnings: 0 Everything looks ok from this output but, when I query the biz.baddy... nothing at all was inserted or replaced in to the biz.baddy column for any rows. I have also tried other syntax variants such as: mysql insert biz (baddy) select addy1 from attdata where addy1 regexp ^[0-9]; mysql replace into biz (baddy) select addy1 from attdata where addy1 regexp ^[0-9]; mysql replace biz (baddy) select addy1 from attdata where addy1 regexp ^[0-9]; - I have also tried changing the default value of the column from NULL to 'not null then re-ran all the above syntax and still, I can *not* get the biz.baddy to be replaced with the data extracted from attdata.addy1. - NOTE: all of the above happens when I first use the following syntax: insert into biz (cid, bname) select id, comp from attdata; - NOTE-2: If I start with a completely empty biz table and issue either of the following queries, all the data is transferred properly but, this would defeat my purpose (remember) the addy1 field is tainted with company names in the address field. mysql insert into biz (cid, bname, baddy) select id, comp, addy1 from attdata; mysql insert into biz (cid, bname, baddy) select id, comp, addy1 from attdata where addy1 regexp ^[0-9]; The cherry on top of this ice-cream cone is, update will fix my issue however I have over 150,000 rows of data that are pretty much messed-up because of the tainted 'addy1' field. Can you imagine the time and, possibly even more mistakes that would take place if update had to be done on every row just to fix this? I'll not trust this task to anyone other than myself. Any Ideas on what I am typing wrong within the insert/replace syntax shown above? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
bianary dist, of 3.23.41 ...
hi all, is there a way i can install the rpm's with a path of /usr/local/mysql ? or how would i go by confguring to install in that path using the src.rpm ? TIA Andre __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problems with cin.ignore()
Hello. My name is Mike. I am writing a c++ program which uses mysql++. In my program I used cin.ignore() function in order to flush the stdin. When I try to compile, it gives me such an error message: no matching function for call to _IO_istream_withassign::mysql_ignore()'. I created one test program which uses cin.ignore() function and it's working, but if I will include in my program at least one header file from mysql++(for example sqlplus.hh) that error message appears. I don't know how to fix this problem. Please if anybody could help me, I would appreciate that. Thank you.
SELECT COUNT(*) question ...
Howdy all, I have two tables as described further down below ... I use the following query to get the data I need ... sql = SELECT tblTempConsolidation.*, tblCustomer.customerLibrary FROM tblCustomer, tblTempConsolidation WHERE tblCustomer.customerId = tblTempConsolidation.customerId AND tblTempConsolidation.customerId = Cint(intCustomerId) ; (I'm using VBScript) I need to know how many records this SELECT returns to me. I am currently doing this with a seperate SELECT COUNT(*) statement and it works fine, however it would be nice to do the whole lot in one. The manual tells me I can not mix GROUP and no GROUP columns without having a GROUP BY. From my rather limited SQL knowledge, I suspect that I can not do this with the data that I have.. Any suggestions? TIA. # # Table structure for table 'tblCustomer' # CREATE TABLE tblCustomer ( customerId int(11) NOT NULL DEFAULT '0' auto_increment, customerName char(10) NOT NULL DEFAULT '' , customerPW char(10) , customerLibrary char(50) , customerEmail char(50) , interfaceTypeId int(11) NOT NULL DEFAULT '0' , customerUSMARC tinyint(4) , PRIMARY KEY (customerId), KEY customerName (customerName), KEY interfaceTypeId (interfaceTypeId) ); # # Table structure for table 'tblTempConsolidation' # CREATE TABLE tblTempConsolidation ( sequence int(11) NOT NULL DEFAULT '0' auto_increment, customerId int(11) NOT NULL DEFAULT '0' , 020A char(10) NOT NULL DEFAULT '' , orderPrice decimal(20,4) NOT NULL DEFAULT '0.' , orderQty smallint(6) NOT NULL DEFAULT '0' , orderSource tinyint(3) unsigned NOT NULL DEFAULT '0' , 245A char(50) , 100A char(50) , 260B char(50) NOT NULL DEFAULT '' , GroupID int(11) NOT NULL DEFAULT '0' , PRIMARY KEY (customerId,020A), KEY sequence (sequence), KEY customerId (customerId), KEY 020A (020A), KEY GroupID (GroupID) ); Greg Lawrie C i m t e c h 51 Byron Place Adelaide South Australia 5000 Phone +618 8212 8799 Fax +618 8212 8766 Email [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Computer Sales :: Network Design and Installation Software Development :: Database Design -- The information contained in this e-mail message may be confidential. If you are not the intended recipient any use, distribution, disclosure or copying of this information is prohibited. If you receive this e-mail in error, please tell us by return e-mail or phone 08 8212 8799 and delete it and any attachments from your system. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php