Some more info on what I don't have.
The site is a search engine site similiar to ooh-canada.com (not that I am plugging their site...lol) but it is the best way to describe mine. I have adcycle on it- that doesn't work. I have link sql which doesn't work. There is e-classifieds that doesn't work. Subscribe Me pro doesn't work Auto rank, auto post, web now doesn't work. Even the links on it don't work. I can't get into any admin for any of the above stuff. Virtually I have only a site that is a mess. And so am I... I sure do hope that someone can help. I don't think it is a big problem but some thing that I have not done in my illiterate mind. Like the wrong linking or like that. Thanks for listening.. Louise
How to connect to mysql databases
Hi all . I am on a Linux 6.2 client and accessing MySql directly on the server. I have connected to server using Telnet. I am at mysql prompt and when I say show databases ; it showing me the databases over there. However how can I connect to these databases. I used connect comand but it's not working Amol - http://mail.indiainfo.com India's first ISO certified portal Check world time at http://time.indiainfo.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: Some more info on what I don't have.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello Louise, Well first of all is that, did you change host providers? well if so, have you made a backup/dump of your database in your old host? if so, are u sure that your new host supports PERL DBI which is needed for you to do database connections via Perl (i am concluding it's perl coz you mentioned cgi) If you are all in luck and still have the old server running, you can try phpMyAdmin and use it to dump the database into a text file, then on your new host, install phpMyAdmin too and then restore the database into the new site. Just ask your new provider for the username, password and maybe the mysql port if ever they changed it. You can get a copy of phpMyAdmin at http://www.phpwizard.net/projects/ it's written in PHP though, but you can use the tool for the database migration. Regards, Sherwin T. Ang Web Technical Administrator / Programmer Alchemy Solutions http://www.alchemy.com.ph Creative. Technology. Tridel Technologies, Inc. 7th Floor Hanston Building Emerald Ave., Ortigas Center Pasig City Philippines Tel: (632) 634-5141/ (632) 634-5140 Local 1040 Fax: (632) 634-5139 - - Original Message - From: Louise [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 12:20 AM Subject: Some more info on what I don't have. The site is a search engine site similiar to ooh-canada.com (not that I am plugging their site...lol) but it is the best way to describe mine. I have adcycle on it- that doesn't work. I have link sql which doesn't work. There is e-classifieds that doesn't work. Subscribe Me pro doesn't work Auto rank, auto post, web now doesn't work. Even the links on it don't work. I can't get into any admin for any of the above stuff. Virtually I have only a site that is a mess. And so am I... I sure do hope that someone can help. I don't think it is a big problem but some thing that I have not done in my illiterate mind. Like the wrong linking or like that. Thanks for listening.. Louise -BEGIN PGP SIGNATURE- Version: PGPfreeware 7.0.3 for non-commercial use http://www.pgp.com iQA/AwUBPJp+iHHqbCYZYnEDEQJyoQCeNCIOjV+R8FhDP7AeR4GQng+vnFwAmwR/ 8X4zTk7ZR0zqiC7yTNum4gE6 =MlAV -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: JBuilder6 and mm.mysql-2.0.11
Hi, Lonnie Wormley wrote: Is this the correct file to have in your class path? addpath /home/launi/JBuilder6/lib/mm.mysql-2.0.11/mm.mysql-2.0.11-bin.jar Yes, please add it into jdk.config. :) I have it in there and it still does not work. I have it in my .bash_profile and dbpilot.config and still no luck I also tried the addjars option and it still will not work in the data pilot. Do you want to use mm mysql Driver with JB6's DataPilot? What kind of error does DataPilot say? -- TAKAHASHI,"KEN",Tomohiro Borland -- Enabling a new digital world where our customers have the freedom of choice to develop, deploy, and integrate applications across the enterprise and the Internet. http://www.borland.com Don\'t miss the 13th Annual Borland$B%g(B Conference, May 18-22 in Anaheim, California. Hundreds of sessions are being offered to help you enable the new digital world with best-in-class solutions for Web Services, Java$BQ(Btechnologies, mobile and enterprise computing, cross-platform development, .NET$BQ(Band J2EE$BQ(B platform technologies, and more! Register today! http://www.borland.com/conf2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
about mysqldump
Hi, I want to know, whether the recovery from the file created using mysqldump, will also recover the foreign key between the tables. because when I am doing this it doesn't seems like that.. when I am doing recovery I am loosing all the foreign keys of by database tables. please, tell me it is affecting my database backup and recovery... Thanks and regards, Chetan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
no umlauts in mysql client
Description: mysql (the client program) does not accept umlauts. It does not react to keystrokes with ä,ä,ü,ß. Neither can I enter umlauts using batch input files. This is independent from the database to which mysql connects. The databases store umlaut chars in text fields, though, and select statements retrieve those umlauts, so it is a problem of the client, not of the server. How-To-Repeat: Install SuSE linux 7.1 on a Sony Vaio N505x (standard installation) Then install the latest mysql client package (rpm) from the mysql.com website. Fix: Submitter-Id: submitter ID Originator:sascha mantscheff Organization: qualimedic ag MySQL support: none Synopsis: mysql client does not accept umlauts Severity: non-critical Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.49a (Official MySQL RPM) Environment: System: Linux pico 2.2.18 #1 Fri Jan 19 22:10:35 GMT 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='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: -rwxr-xr-x1 root root 1382179 Jan 19 2001 /lib/libc.so.6 -rw-r--r--1 root root 2585872 Jan 19 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Jan 19 2001 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --with-other-libc=/usr/local/mysql-glibc --without-berkeley-db --without-innodb --enable-assembler --enable-local-infile --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM' CC=gcc 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' CXX=gcc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MS Access to MySQL conversion
We have a Unix server which in addition to running MySQL is also a fileserver for a group of MS Windows PCs (using samba) and it would be useful to be able to convert the Microsoft Access .mdb files put there by users directly to MySQL, or at least to .csv format. Does anyone know of such a utility? Andy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error message
mysql, Wednesday, March 20, 2002, 11:02:01 PM, you wrote: mmlu In my mysql .err file I get a lot of the following error... mmlu Aborted connection 121031 to db: ..connection details... (Got an error mmlu reading communication packets) mmlu What does this mean, and is it bad, and what do I do about it? There are some causes of error 'aborted connection ...'. You can find description of this error at: http://www.mysql.com/doc/C/o/Communication_errors.html mmlu Any help appreciated. mmlu Howard -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
LOAD DATA
Klym, Thursday, March 21, 2002, 6:55:36 AM, you wrote: K I am running the latest stable version: 3.23.49a K but when I use the LOAD DATA command I get the error below: K mysql load data local infile theme.txt into table theme; K ERROR 1148: The used command is not allowed with this MySQL version K any idea what the problem is? Since 3.23.49 version of MySQL and newer you should start mysqld and mysql with '--local-infile' option. You can find info about it at: http://www.mysql.com/doc/L/O/LOAD_DATA_LOCAL.html K thanks -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to connect to mysql databases
amol, Thursday, March 21, 2002, 10:17:53 AM, you wrote: as Hi all . I am on a Linux 6.2 client and accessing MySql directly on as the server. I have connected to server using Telnet. I am at mysql as prompt as and when I say show databases ; it showing me the databases over as there. However how can I connect to these databases. I used connect as comand but it's not working Use following commant: USE database_name; You can also use connection string: mysql -u your_user -p your_database as Amol -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: Access denied on use mysql;
Kathy, Wednesday, March 20, 2002, 7:27:31 PM, you wrote: KR I cant figure out how I have lost access to 'mysql' (default) database. When KR I attempt to use mysql on my Linux machine I get the error message ERROR KR 1045: Access denied for user: 'root@localhost' (Using password: NO) Kathy, error message says that you don't use password for your 'root' user. How did you connect to MySQL server? KR How ever I can login using kreyes and ODBC. KR Can anyone please tell me where I can find that my.cnf file I've looked KR every where on my linux machine and cant find it. You can find examples of *.cnf in /usr/doc/MySQL-X.XX. Copy one of the file under the name my.cnf in /etc or in /usr/local/mysql/var. KR Thanks all!!! -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Fw: Access denied on use mysql;
Hi, Check whether ur mysql is running using the following command. $/etc/rc.d/init.d/mysqld status if the reply is running... then type 'mysql' (if you have anonymous login) otherwise type 'mysql -u root -p' If you don't get the mysql prompt then you will have to add an user using mysqladmin, I haven't done that yet, read the manual. And let me know if you succeed. Regards, Liyju --- Kathy Reyes [EMAIL PROTECTED] wrote: I thought I was sending my email to the [EMAIL PROTECTED] but I guess I wasnt. Thank you so much for your help Alan, I cant figure out how I have lost access to 'mysql' (default) database. When I attempt to use mysql on my Linux machine I get the error message ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) How ever I can login using kreyes and ODBC. Can anyone please tell me where I can find that my.cnf file I've looked every where on my linux machine and cant find it. Thanks all!!! - Original Message - From: alan4100 [EMAIL PROTECTED] To: Kathy Reyes [EMAIL PROTECTED] Sent: Wednesday, March 20, 2002 11:59 AM Subject: Re: Access denied on use mysql; Kathy, First please cc to [EMAIL PROTECTED] . There are others who want to read it. But you said earlier about emails that did not do much of help. I was lucky. Perhaps you have to wait for your turn. First, I feel I am not ready to solve this problem for you because your telneting into the linux machine from Windows 2000 machine. I have never tried this. I can tell you what I know as a complete beginner. I need to correct my saying NET CLOSE SERVER. When it should be NET STOP SERVER. You need to use WINMYSQLADMIN for adding users. There may be other ways, but I only know this way. But in your case about telneting, I am not sure what your doing because I never tried it. I am not clear about telneting, are your accessing data remotely for editing,etc, from your local Mysql server. Or vice versa. your transmitting data from your local machine to the remote Mysql server. I think your just accessing remote data. Your reply may help. I can only describe about my present settings on my pc with mysql. The present settings right after the installation of Windows XP, I did not go anything beyond granting privileges to other users like you do. But it is ready to accept my typing input: USE MYSQL before the database changed in computer's reply. At that point, I assume I am granted access to this MYSQL database. Did you type in USE MYSQL command? I dont know why you cannot. I believe you should cc your emails to [EMAIL PROTECTED] Others will help you. I think you have mentioned emails, but got no help. Sometimes, patience pays off. Good luck. And then enlightment follows. - Original Message - From: Kathy Reyes [EMAIL PROTECTED] To: alan4100 [EMAIL PROTECTED] Sent: Wednesday, March 20, 2002 10:54 AM Subject: Re: Access denied on use mysql; I signed in as follows mysql -h localhost -u kreyes. mysql is installed on a linux machine and I am connecting remotely from a Windows 2000 machine. When I had access as root I was able to add users and grants. I didnt give myself access to the 'msql' database because I didnt really need it. But up until yesterday I was able to go into mysql by telneting into the linux machine and then typing mysql but now I keep getting an error. I'm not sure what you mean by NET CLOSE MYSQL. I am kinda new to mysql. Please enlighten me - Original Message - From: alan4100 [EMAIL PROTECTED] To: Kathy Reyes [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, March 20, 2002 10:55 AM Subject: Re: Access denied on use mysql; Kathy, Sounds like mine, but it is fixed. I still dont know what the fix was. May I ask you how you signed in as Kreyes? Did you add username and password yourself? Since you are denied access to mysql (default) database, it surely sounded like mine. Before I may give you some help, may I ask you again how you signed in as Kreyes. Did you use mysqladmin? How long have you been using MySQL? Did you install recently? It sounds you may need to NET CLOSE MYSQL at DOS PROMPT. And then NET START MYSQL again. I am afraid there are still related programs running in the background. But five it a try. Two times at most. I did that several times over a few days period, before it worked correctly. And let me know. - Original Message - From: Kathy Reyes [EMAIL PROTECTED] To: alan4100 [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, March 20, 2002 10:11 AM Subject: Re: Access denied on use mysql; I've tried everything thats in this email and nothing seems to work for me. I think my
Re: How to connect to mysql databases
There is still error I did as per your say at mysql use test; but the error it gave was ERROR 1044: Access denied for user: '@localhost' to database 'test' even if I do something like this mysql mysql -u amol test -p ERROR 1045: Access denied for user: 'amol@localhost' (Using password: YES)This result we get . What can be way out. Is there any suggestions. Amol On Thu, 21 Mar 2002 16:35:56 -0800 Sherwin T. Ang [EMAIL PROTECTED] wrote: to connect to a certain database type in, mysql use databasename; where databasename is the name of your database. or you can specify the database in the command line like: mysql -uroot databasename -p where root is the user and databasename is the database to use/connect to. Hope that helps =) Regards, Sherwin T. Ang Web Technical Administrator / Programmer Alchemy Solutions http://www.alchemy.com.ph Creative. Technology. Tridel Technologies, Inc. 7th Floor Hanston Building Emerald Ave., Ortigas Center Pasig City Philippines Tel: (632) 634-5141/ (632) 634-5140 Local 1040 Fax: (632) 634-5139 - Original Message - From: amol sonaikar [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 12:17 AM Subject: How to connect to mysql databases Hi all . I am on a Linux 6.2 client and accessing MySql directly on the server. I have connected to server using Telnet. I am at mysql prompt and when I say show databases ; it showing me the databases over there. However how can I connect to these databases. I used connect comand but it's not working Amol - http://mail.indiainfo.com India's first ISO certified portal Check world time at http://time.indiainfo.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 - http://mail.indiainfo.com India's first ISO certified portal Check world time at http://time.indiainfo.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: Java to MySQL connection
which Driver your using? which Operating system your using? If your using linux, as far as I know there is now odbc support. You have to downlaod mm.mysql driver. If your are using windows you will have to create a dsn name for the your selected driver. --- Chris Stewart [EMAIL PROTECTED] wrote: I'm trying to make a connection from a java app to a MySQL database I've created on my local PC. How can I tell the app where to look for the existing database? Code I'm working with: Class.forName(sun.jdbc.odbc.JdbcOdbcDriver).newInstance(); Connection con = DriverManager.getConnection(jdbc:odbc:Testing@localhost:3306, my username , my pass ); System.out.println(Connection Made.); As you can tell from this, my database is named Testing. All I'm trying to do right now is get a connection. Right now when I run this code I get Error: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. I'm not sure I have the odbc driver setup correctly either. I downloaded mm.mysql-2.0.11 but I'm not really sure how to bring it into the mix as far as the driver goes. Thanks for any direction. Chris Stewart [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 __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.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
exanging vars between form/php/javascript
First in generally: How is possible to exange vars between a
form/php/javascript?
I have fetch the data from a MySQL query and I need to pass the $line from a
form to a new php script to show the record in details in one whole page.
I have put a a href with onMouseOver but I'll but rather a form submit
there to a php script. How is possible not to run another php but to stay on
the same php script to show all $line fields in a page?
The code:
===
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
$cnt = $cnt+1;
print \ttr\n;
print \t\ttd bgcolor='#C0C0C0'B$cnt/B/td\n;
$cnt2=0;
foreach ($line as $col_value) {
$cnt2=$cnt2+1;
$ID=$line[ID];
if (($col_value!=$line[ID]) AND ($cnt231)) {
if ($col_value==$line[Name]) { $col_value=a href=.''.$col_value.'
onMouseOver=show_rec(ID)'.$col_value./a; }
if (($cnt % 2) ==0)
print \t\ttd bgcolor='#D0FFD0'$col_value/td\n;
else
print \t\ttd bgcolor='#CC'$col_value/td\n;
}
}
print \t/tr\n;
}
Makis
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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 clients hang when network to server is disrupted!
On Wed, 20 Mar 2002 16:00:15 -0800 Lance Welsh [EMAIL PROTECTED] wrote: It is a big problem for us, and I can only imagine for anyone using MySQL, when a mysql client hangs on an established connection to the mysql server because the network to the server is disrupted (such as someone pulling power to a network hub or many other scenarios). We have changed the source code to fix this, but I'd sure like to hear comments from people that know MySQL. The mysql client can respond with an error if the server dies or is shutdown because the network will cleanup the broken connection. The mysql client can also respond with an error if the server is not available for a connection. But if the connection is already established and the network connection is disrupted, the client simply hangs. Someone please tell me if I am wrong, or if I am doing something wrong. Perhaps there is a feature or option I am overlooking (the option to set a timeout when connecting does not affect existing connections). Perhaps my change here could be incorporated into the source code control if someone will guide me. What we have done to get around this problem is to use poll with a timeout before blindly hanging on a read. I had to alter the vio_read method in the violite.c file: Hi! In some cases you can have a connection to timeout by setting network read and write timeouts on the server. For all other cases, network read and write timeouts will have to be established on the client side too. -- Regards, -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /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: Java to MySQL connection
there is odbc support on linux, you can find a link the the myodbc drive for mysql on mysql.com -Original Message- From: Liyju Janardhan [mailto:[EMAIL PROTECTED]] Sent: 21 March 2002 03:30 To: Chris Stewart; [EMAIL PROTECTED] Subject: Re: Java to MySQL connection which Driver your using? which Operating system your using? If your using linux, as far as I know there is now odbc support. You have to downlaod mm.mysql driver. If your are using windows you will have to create a dsn name for the your selected driver. --- Chris Stewart [EMAIL PROTECTED] wrote: I'm trying to make a connection from a java app to a MySQL database I've created on my local PC. How can I tell the app where to look for the existing database? Code I'm working with: Class.forName(sun.jdbc.odbc.JdbcOdbcDriver).newInstance(); Connection con = DriverManager.getConnection(jdbc:odbc:Testing@localhost:3306, my username , my pass ); System.out.println(Connection Made.); As you can tell from this, my database is named Testing. All I'm trying to do right now is get a connection. Right now when I run this code I get Error: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. I'm not sure I have the odbc driver setup correctly either. I downloaded mm.mysql-2.0.11 but I'm not really sure how to bring it into the mix as far as the driver goes. Thanks for any direction. Chris Stewart [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 __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards(r) http://movies.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
outer joins: tried some sql code myself but doesn't work - should be easy i think ?
Hi, I sent a message to the list earlier today about a problem with an outer join. I tried some stuff myself and checked the archives, but no message described my syntax problem with mysql, so I turn to the list again for some helpful soul to help me: I have two tables that i want to link via an outer join: mysql desc active_monitors; ++--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-+---+ | monitor_id | int(7) | | PRI | 0 | | | endpoint | char(16) | | PRI | | | | monitor| char(75) | YES | | NULL| | | last_value | char(10) | YES | | NULL| | | last_update| datetime | YES | | NULL| | | sentry_profile | char(80) | | PRI | | | | status | char(10) | YES | | NULL| | ++--+--+-+-+---+ and mysql desc endpoints_defined_monitors; ++--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-+---+ | monitor_id | int(7) | | PRI | 0 | | | monitor| char(75) | YES | | NULL| | | endpoint | char(16) | | PRI | | | | sentry_profile | char(80) | | PRI | | | ++--+--+-+-+---+ i link these tables with the following sql statement: select D.monitor, D.endpoint, A.monitor from endpoints_defined_monitors D, active_monitors A where A.monitor_id = D.monitor_ID and A.endpoint = D.endpoint and A.sentry_profile = D.sentry_profile however, in some cases, there is a record in endpoints_defined_monitors that doesn't exist in active_monitors, or maybe even the other way round. Can someone tell me how I can adapt my sql statement so that I also get these records (with the field 'monitor' having a NULL value ?). The problem is that I need 3 where clauses between these 2 tables before I can link the records together. I came up with the following sql statement, but I still don't see any records that are missing in table active_monitors, I assume i am abusing the 'join syntax' but I don't know how to fix it: select D.monitor, D.endpoint ,A.monitor from endpoints_defined_monitors D left outer join active_monitors A on A.monitor_id = D.monitor_ID and A.endpoint = D.endpoint and A.sentry_profile = D.sentry_profile Thanks, Tom. Tom Van Overbeke Atos Origin Managed Services Unix/WAN/Tivoli Minervastraat 7 B-1930 Zaventem Tel. : +32 (2) 712 2650 Fax: +32 (2) 712 2622 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
What is Returned from a query that a record isnt there
Hello , I have a user DB , My perl script on my redhat box scans a drive for
users files , and I want to email, the user to remind them they have a file
that they havent used in months
my problem when the script comes accrosed a new user I want them to be
added to the DB and send me an email stating so , so I can look up their
email address and provide it. My script querys the DB to see if there is a
record , But I am not getting the right negitive response , to run my if
statement.
My DB :
+-++--+
| owner | email | comm |
+-++--+
| t0642k8 | [EMAIL PROTECTED] | |
+-++--+
1 row in set (0.08 sec)
mysql
my code: please note I trimed it up
#
## ##
## select distinct owner phase ##
## ##
#
my $database = shared;
my $data_source = DBI:mysql:$database;
my $username = root;
my $password = elaine;
$dbh = DBI -connect($data_source, $username, $password) or die cant
connect to
$data_source : my $dbh- errstr\n;
#Select Owner
my $sth= $dbh- prepare(select distinct owner from files);
$sth- execute or die unable to execute query ;
my $array_ref = $sth-fetchall_arrayref();
open(LOG, /var/www/html/bad/users.txt);
foreach $row(@$array_ref) {
#
## dump total bad users to text file
#
my ($user_n) = @$row;
print LOG $user_n\n;
#add to users DB
$dbh1 =DBI -connect($data_source, $username, $password) or die cant
connect to
$data_source : my $dbh- errstr\n;
my $sth1 = $dbh1 - prepare(select owner from users where owner =
'$user_n');
$sth1 - execute or die unable to execute query ;
# $sth1 - finish;
# $dbh1-disconnect;
my $array_ref = $sth1 - fetchall_arrayref();
foreach $row(@$array_ref){
my($owner) = @$row;
if($owner eq ){ ### try NULL next
print Entered bracket \n;
$dbh4 =DBI -connect($data_source, $username, $password) or die cant
connect to
$data_source : my $dbh- errstr\n;
my $sth2 = $dbh4 - prepare(insert into users(owner)values('$user_n'));
$sth2 - execute or die unable to execute query ;
}
}
$sth - finished;
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ER Program
i am looking for a ER Design Freeware tool, i'd like to konw if does someone here knows about something like that, the tool name and, if possible, the url for download. currently i am using a DDT (Database Design Tool) V1.5, however i think it's too simple with that i can not create indexes, i saw one named dezign for databases which is a tool indicated by the MySQL AB, although in it's free version i can only create at last 10 entities and in each one i can create about of 10 filds only. thanks advanced. idéias.ual.. Idéias Pontual Desenvolvimento de Software Ltda. Ricardo Striquer Soares CEO e-business Fone: +55 (41) 322-9373 Cel: +55 (41) 9908-3862 Fax: +55 (41) 223-7865 Mr. Lucro : www.mrlucro.com.br _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to do when the table files become bigger and bigger
Hi, all: I am doing a project that we will insert a lot of data to mysql every day, so the table files will become bigger and bigger, it will not only take a long time to query,but also lead to the file size limits. So how to resolve it? Are there some artiles related? Thanks for any help. B.R. budingc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: outer joins: tried some sql code myself but doesn't work - should be easy i think ?
I came up with the following sql statement, but I still don't see any records that are missing in table active_monitors, I assume i am abusing the 'join syntax' but I don't know how to fix it: select D.monitor, D.endpoint ,A.monitor from endpoints_defined_monitors D left outer join active_monitors A on A.monitor_id = D.monitor_ID and A.endpoint = D.endpoint and A.sentry_profile = D.sentry_profile Where D.monitor_id is null following the outer join, d.endpoint will also be null hence a.endpoint = d.endpoint evaluates to false. Chuck a few 'or is null's in and away you go. Jon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 connect to mysql databases
what is the output of show database command --- amol sonaikar [EMAIL PROTECTED] wrote: Hi all . I am on a Linux 6.2 client and accessing MySql directly on the server. I have connected to server using Telnet. I am at mysql prompt and when I say show databases ; it showing me the databases over there. However how can I connect to these databases. I used connect comand but it's not working Amol - http://mail.indiainfo.com India's first ISO certified portal Check world time at http://time.indiainfo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.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: How to connect to mysql databases
Do the folowing mysqlshow grant for root@localhost; mysqlgrant all on test.* to root@localhost identified by 'password'; $mysqladmin reload --- amol sonaikar [EMAIL PROTECTED] wrote: There is still error I did as per your say at mysql use test; but the error it gave was ERROR 1044: Access denied for user: '@localhost' to database 'test' even if I do something like this mysql mysql -u amol test -p ERROR 1045: Access denied for user: 'amol@localhost' (Using password: YES)This result we get . What can be way out. Is there any suggestions. Amol On Thu, 21 Mar 2002 16:35:56 -0800 Sherwin T. Ang [EMAIL PROTECTED] wrote: to connect to a certain database type in, mysql use databasename; where databasename is the name of your database. or you can specify the database in the command line like: mysql -uroot databasename -p where root is the user and databasename is the database to use/connect to. Hope that helps =) Regards, Sherwin T. Ang Web Technical Administrator / Programmer Alchemy Solutions http://www.alchemy.com.ph Creative. Technology. Tridel Technologies, Inc. 7th Floor Hanston Building Emerald Ave., Ortigas Center Pasig City Philippines Tel: (632) 634-5141/ (632) 634-5140 Local 1040 Fax: (632) 634-5139 - Original Message - From: amol sonaikar [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 12:17 AM Subject: How to connect to mysql databases Hi all . I am on a Linux 6.2 client and accessing MySql directly on the server. I have connected to server using Telnet. I am at mysql prompt and when I say show databases ; it showing me the databases over there. However how can I connect to these databases. I used connect comand but it's not working Amol - http://mail.indiainfo.com India's first ISO certified portal Check world time at http://time.indiainfo.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 - http://mail.indiainfo.com India's first ISO certified portal Check world time at http://time.indiainfo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.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: Inserting records with null foreign keys?
Rick, this is fixed in 3.23.50. I changed InnoDB so that it ignores foreign key checks on keys containing SQL NULL values. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB -Original Message- From: Rick Flower [EMAIL PROTECTED] To: MySQL Mailing List [EMAIL PROTECTED] Cc: Heikki Tuuri [EMAIL PROTECTED] Date: Wednesday, March 20, 2002 10:56 PM Subject: Inserting records with null foreign keys? Hi all.. I noticed that the current version of InnoDB that is part of MySQL 3.23.47 does not allow using null foreign keys when doing inserts.. Is this intentional or a bug? This is allowed by SQL Server as a minimum (a test is being done by a co-worker currently against Oracle 8i to see how it behaves). If you don't specify the foreign key, you get a constraint error on the insert.. We're just curious if that is supposed to be that way or not.. If that is a feature, I guess we will have to remove some foreign keys that we've got defined currently.. Thanks for any input on this! -- Rick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
http auth in phpmyadmin help!
I am having a heck of a time trying to get phpMyAdmin to work with 'http or cookie' authentication. I have created the stduser/stdpass like the docs say, but still nothing. Can anyone give any tips/tricks to make this work?? TIA mysql -- Mike Yrabedra [EMAIL PROTECTED] http://www.macsurfshop.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
What is Com_change_db
Hi! hisol == hisol ks_c_5601-1987 writes: hisol I executed mysqladmin extended-status. hisol There was Com_change_db head. But I can't understand what it means. hisol I know Com_xxx means number of times xxx command executes. But hisol what does change_db mean? This is number of times 'use database' is executed. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: http auth in phpmyadmin help!
What kind of box are you on? UNIX? Windows? What happens when you try to access the page? Provide some details. On Thu, 2002-03-21 at 08:52, Mike Yrabedra wrote: I am having a heck of a time trying to get phpMyAdmin to work with 'http or cookie' authentication. I have created the stduser/stdpass like the docs say, but still nothing. Can anyone give any tips/tricks to make this work?? TIA mysql -- Mike Yrabedra [EMAIL PROTECTED] http://www.macsurfshop.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: Re: ER Program
- Original Message - From: [EMAIL PROTECTED] To: Bernhard Doebler [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 1:58 PM Subject: Re: Re: ER Program Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Look out for the Czech Program Case Studio. Regards Bernhard - Original Message -=20 From: Ricardo Striquer Soares [EMAIL PROTECTED] To: Listas (En) - MySQL [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 1:21 PM Subject: ER Program i am looking for a ER Design Freeware tool, i'd like to konw if does someone here knows about something like that, the tool name and, if possible, the url for download. =20 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Boolean Fulltext in 4.0.2 bug
Hello,
CREATE TABLE IF NOT EXISTS test (
id mediumint(6) unsigned NOT NULL DEFAULT '0' ,
txt text ,
PRIMARY KEY (id)
);
#insert. 4 rows
ALTER TABLE test ADD FULLTEXT findind (txt);
select * from test where match(txt) against('+sony -playstation' in boolean
mode)
(25 rows returned)
select * from test where match(txt) against('+sony -playstatio* ' in boolean
mode)
(0 rows returned)
select * from test where match(txt) against('-playstatio* +sony ' in boolean
mode)
(25 rows returned)
Above results from mysql-4.0.2, cloned today (2002-03-21)
With best regards and wishes,
Alexander
--
Uptime: 32 min 45 sec
Threads: 3 Questions: 43493 Slow queries: 0 Opens: 29 Flush tables: 1
Open tables: 1 Queries per second avg: 22.134
--
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
delete vs delete quick
sql Hello, I'm confused as to what 'delete quick' does and when to use it. The manual states: If you specify the word QUICK then the table handler will not merge index leafs during delete, which may speed up certain kind of deletes. What does this actually mean? Viraj. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
scheduled job
Hello, I am planning to call a scheduled (lets say 08:00 am every weekday) batch job at MySql, but I do not want to use operating systems scheduled task nor crontab. Is there a function that mySql supports like Oracle's jobs? Regards Okan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: how to do when the table files become bigger and bigger
What is the problem you wish to resolve? Define it. -Original Message- From: Buding Chen [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 6:33 AM To: [EMAIL PROTECTED] Subject: how to do when the table files become bigger and bigger Hi, all: I am doing a project that we will insert a lot of data to mysql every day, so the table files will become bigger and bigger, it will not only take a long time to query,but also lead to the file size limits. So how to resolve it? Are there some artiles related? Thanks for any help. B.R. budingc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
nothing technical....
Thought some might be interested in such articles. Seems like Oracle's got caught red handed scrambling:) http://reuters.com/news_article.jhtml?type=technologynewsStoryID=725126 Just for the filter: MySQL rocks :) Gurhan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Please Assist
Attempting to set up Payment Gateway Database and attempting mysql.bat file. When it runs, we are getting the following error message D:\INSTALLS\MYSQL\MODSd:\mysql\bin\mysql -t 0d: \Installs\mysql\mods\crpmtgty. sql ERROR 1045: Access denied for user: 'ODBC@localhost' (Using password: NO) D:\INSTALLS\MYSQL\MODSd:\mysql\bin\mysql -t 0d: \Installs\mysql\mods\crsqllog. sql ERROR 1045: Access denied for user: 'ODBC@localhost' (Using password: NO) D:\INSTALLS\MYSQL\MODSd:\mysql\bin\mysql -t 0d: \Installs\mysql\mods\cleanupmy sql.sql ERROR 1045: Access denied for user: 'ODBC@localhost' (Using password: NO) Please assist. Thank you - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: major performance disparities with mysql/php - SOLVED
I found the problem. My production server is running mysql 3.22.29, and I needed to use a SET SQL_BIG_TABLES=1 in many places to prevent a full temp table condition. The new server is running 3.23, and once I removed the SQL_BIG_TABLES=1 from the script (and allowed mysql to use memory instead), everything worked as expected. -Hank __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.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: scheduled job
Hi, No there is not.. You have use crontab with a batch file to do that. Gurhan -Original Message- From: Okan CIMEN [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 9:27 AM To: [EMAIL PROTECTED] Subject: scheduled job Hello, I am planning to call a scheduled (lets say 08:00 am every weekday) batch job at MySql, but I do not want to use operating systems scheduled task nor crontab. Is there a function that mySql supports like Oracle's jobs? Regards Okan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
sqlbindcol
Hi, I am trying to get the following to work but it returns invalid values. SQLINTEGER size; SQLExecDirect (hstmt, Select 8, SQL_NTS); SQLBindCol(hstmt,1, SQL_C_ULONG, size,0,NULL); I tried various datatypes for size but I always get some invalid values. Is the above correct or do I need to make any modification ? Thanks Chetan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: ER Program
At 15:12 2002-03-21, Bernhard Doebler wrote: - Original Message - From: [EMAIL PROTECTED] To: Bernhard Doebler [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 1:58 PM Subject: Re: Re: ER Program Look out for the Czech Program Case Studio. Looks interesting - but it's hardly freeware... Regards Bernhard - Original Message -=20 From: Ricardo Striquer Soares [EMAIL PROTECTED] To: Listas (En) - MySQL [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 1:21 PM Subject: ER Program i am looking for a ER Design Freeware tool, i'd like to konw if does someone here knows about something like that, the tool name and, if possible, the url for download. =20 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Marjolein Katsma HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MySQLl performance on Linux versus XP/W2K
Probably Linux, but it is also pretty spunky on my WinXP machine. Craig At 08:30 PM 3/20/2002 -0800, you wrote: Is MySQL 3.23/4.01 faster on Linux (RH 7.2) or Windows XP/2000 with the same hardware? Thanks. David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
help with index/query
I am hoping I can get some help with a difficulty I am having with a table of mine. I am going to give a lot of background info, so please bear with me. First, let me say that I using 3.23.49. Now some info about the table. It currently has 5687391 rows. There are 3 columns in the table: ID (int), Url (varchar(255)), and Ref (varchar(255)). There are two indexes for the table: one on ID and the other on the first 15 characters of Ref. Now my problem: select queries on this table with no joins searching for a constant in the Refs column only are extremely slow. Here is what all the sql statements look like select Url from table where Ref like 'foo'. Pretty simple right? Here's the deal this table is used only by a little app that I wrote. Each time the app runs it queries this table as shown above about 4600 times with different values for foo. Each query seems to be taking about 2 minutes to execute. This seems odd to me because I tested it while I was writing the app and the queries were taking a little over a second. So I took a look at my table structure and my indexes. I noticed from SHOW INDEX that the CARDINALITY for the index on the Ref column is NULL. From reading about CARDINALITY in the manual that NULL value seems like a very bad thing. Every time my app runs (about once a month) I dump all of the rows in this table and insert about 5 million new rows. I do not drop the table and recreate it. I began thinking that perhaps the dumping and inserting is perhaps creating havoc with my index on the Ref column. So without further ado, here are my questions for the list: Is having a NULL CARDINALITY bad? Do I have to rebuild the index each time I dump the entire table and insert millions of rows? If so, what is the best way to do that - myisamchk -a? Duncan -- Duncan Salada | Titan | www.titan.com/testeval Email: [EMAIL PROTECTED] | Voice: 301-925-3222x375 | Fax: 301-925-3216 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Betr.: ER Program
Try this: Microsoft VisioModeler 3.1 (FREE) on msdn.microsoft.com/downloads jvd Ricardo Striquer Soares [EMAIL PROTECTED] 21-3-02 13:21:20 i am looking for a ER Design Freeware tool, i'd like to konw if does someone here knows about something like that, the tool name and, if possible, the url for download. currently i am using a DDT (Database Design Tool) V1.5, however i think it's too simple with that i can not create indexes, i saw one named dezign for databases which is a tool indicated by the MySQL AB, although in it's free version i can only create at last 10 entities and in each one i can create about of 10 filds only. thanks advanced. idéias.ual.. Idéias Pontual Desenvolvimento de Software Ltda. Ricardo Striquer Soares CEO e-business Fone: +55 (41) 322-9373 Cel: +55 (41) 9908-3862 Fax: +55 (41) 223-7865 Mr. Lucro : www.mrlucro.com.br _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
server startup error on linux
Ok, I guess Im gonna have to do this again I have a Slackware 8.0 distro with the apache, php, and mysql install pkgs off of the cd I am logged in as root (not su'ed to root) and run the mysql_install_db script I run it with or without the --user=mysql qualifier in either case the databases are corrected, and the file permissions and ownership show that root owns all the database files with read and write access to the owner and the group. running safe_mysqld with or without the --user=mysql qualifier results in the same error Table mysql.host doesnt exist There are two tables created by the mysql_install_db script that are called host.xxx I assume that the mysql daemon is looking for one of those owned by mysql. The server will start if I send the --skip-grant-tables option Who wants to run a database with no grant tables Help. Rance _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: server startup error
The group is not really important, as long as mysql owns the data directory and its contents. You can check /etc/group and see if you have a mysql group, or a group to which mysql is a member. Rance Hall wrote: Folks: I think you are on the right track with that Gerald.. I deleted all the files in my data directory (they were just the ones that mysql_install_db creates) and then ran mysql_install_db --user=mysql This time, nothing was created, no files, or anything, cant even find an error message that would say why. So since I know that the server is running under safe_mysqld --user=mysql it couldnt find the files cause under that account name apparently they dont exist. The mysql user is part of what group, so I can chown the dir, and start again? Gerald Clark wrote Does mysql own the mysql database directory, and all its files? You should have run it as mysql_install_db --user=mysql Rance Hall wrote: Hello all I have a slackware 8.0 distro that includes mysql 3.39.x (I'm not at that computer now, so that could be wrong slighly) install pkg I have installed it, and I can get it to run with the --skip-grant-tables option. When I try to run safe_mysqld without the skip option I get the following error: Table 'mysql.host' doesn't exist Now, I ran the mysql_install_db script and it made a bunch of databases including two called host.xxx Question, what is the proper syntax for a creation of the mysql.host table so that I can create it and get past this error. If anyone else has any experience with this, could this be a bug in the install_db script? Thanks for all your help Rance _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Boolean Fulltext in 4.0.2 bug
Hi!
On Mar 21, Alexander Belyaev wrote:
Hello,
CREATE TABLE IF NOT EXISTS test (
id mediumint(6) unsigned NOT NULL DEFAULT '0' ,
txt text ,
PRIMARY KEY (id)
);
#insert. 4 rows
ALTER TABLE test ADD FULLTEXT findind (txt);
select * from test where match(txt) against('+sony -playstation' in boolean
mode)
(25 rows returned)
select * from test where match(txt) against('+sony -playstatio* ' in boolean
mode)
(0 rows returned)
select * from test where match(txt) against('-playstatio* +sony ' in boolean
mode)
(25 rows returned)
Above results from mysql-4.0.2, cloned today (2002-03-21)
Hmm, there were bugs quite similar to this one fixed recently.
Can you create a test case ?
Regards,
Sergei
--
MySQL Development Team
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
___/
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Inserting files from command prompt
Stembridge, Thursday, March 21, 2002, 12:05:31 AM, you wrote: Seoen The problem isn't inserting table schema/data - I know how to do that. Seoen I'm referring to the process of inserting an actual FILE (txt, .bat, .jpg) Seoen via command line. And of pulling it out and giving it a name (test.txt). mysql database_name -e 'Insert into table_name values (1, load_file(/tmp/loadtest.txt))' You can read about usage of MySQL client in the batch mode at: http://www.mysql.com/doc/B/a/Batch_mode.html -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: rpms for redhat 6.2
Shamit, Wednesday, March 20, 2002, 7:49:50 PM, you wrote: SK Hi, can any one suggest where I can get latest MySQL rpms for redhat 6.2 SK with glibc 2.1x... the new rpms .49+ are all for glibc 2.2+ If you use glibc 2.1x you should compile by yourself. Note: compilation by yourself requires attentive attitude. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
scheduled job
Okan, Thursday, March 21, 2002, 4:27:15 PM, you wrote: OC I am planning to call a scheduled (lets say 08:00 am every weekday) batch OC job at MySql, but I do not want to use operating systems scheduled task nor OC crontab. Is there a function that mySql supports like Oracle's jobs? There is no support for scheduling jobs in MySQL. OC Regards OC Okan -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Adding Columns to table
mysql Allon, Thanks for the clear and simple example regarding ENTER keys. You may notice mysql at the top left corner because without it your letter will bonce back like others (users). eek!
log files
Pål, Wednesday, March 20, 2002, 5:52:58 PM, you wrote: PW I have: PW mysql Ver 11.12 Distrib 3.23.32, for redhat-linux-gnu (i386) PW and wonder about the log file /var/log/mysqld.log PW shouldn't that include failed connections?? You can find mysqlds log in the file 'your_hostname.err' or 'mysql.err' (on Windows) that located in mysql datadir. Info about error logging is situated in the manual: http://www.mysql.com/doc/E/r/Error_log.html PW mvh: Pål Wester PW høgskoleingenør/programmerer -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Character Set Problem in MySQL!
Actually I hadn' t this kind of problem. But now I can' t display turkish characters in mysql queries. Can anyone help me? Edakom Internet Sorumlusu Gokce Akkaya - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Adding Columns to table
mysql Thanks, Colin for the reference to winmysql..etc. By the way, do you also get this email at your personal email address besides mailing list? It looks like you have to check at this mailing list site, because almost all personal emails have been bounced back. I only reply notes to [EMAIL PROTECTED]
Re: help with index/query
what about select Url from table where Ref = 'foo' Salada, Duncan wrote: I am hoping I can get some help with a difficulty I am having with a table of mine. I am going to give a lot of background info, so please bear with me. First, let me say that I using 3.23.49. Now some info about the table. It currently has 5687391 rows. There are 3 columns in the table: ID (int), Url (varchar(255)), and Ref (varchar(255)). There are two indexes for the table: one on ID and the other on the first 15 characters of Ref. Now my problem: select queries on this table with no joins searching for a constant in the Refs column only are extremely slow. Here is what all the sql statements look like select Url from table where Ref like 'foo'. Pretty simple right? Here's the deal this table is used only by a little app that I wrote. Each time the app runs it queries this table as shown above about 4600 times with different values for foo. Each query seems to be taking about 2 minutes to execute. This seems odd to me because I tested it while I was writing the app and the queries were taking a little over a second. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Access denied on use mysql;
mysql Hello Kathy, How have you made out with access to mysql?
RE: server startup error on linux
I assume that the mysql daemon is looking for one of those owned by mysql. The server will start if I send the --skip-grant-tables option Who wants to run a database with no grant tables Find out where your databases are located. Think /var/db/mysql is the default. Go there and type: chown -Rf mysql:mysql * to change ownership of databases and tables. Note that mysql:mysql is user:group and if the mysql-user and/or group is different from 'mysql' you should change it. :wq //andreas http://phpwizard.dk (in Danish only) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Adding Columns to table
mysql I tried to d/l winmysql from this website: http://www.winmysql.com/page4.html as freeware, but it did not respond. Guess it is busy. Will try again, later. But would you or others suggest me to put it in a separate folder from MySQL folder after the d/l?
large blob inserts fail even when setting max-allowed-packet to 64M
Description: using mysql 3.23.41 when attempting to insert a large file (around 17 MB) into a longblob field i get the following error ERROR 2006 at line 1: MySQL server has gone away our mysqld init script contains the following line: /usr/bin/safe_mysqld -O key_buffer=16M -O table_cache=128 -O sort_buffer=4M -O record_buffer=4M -O max_allowed_packet=64M -O max_connections=200 our table schema looks like the following: DROP TABLE IF EXISTS file; CREATE TABLE file ( id int(10) unsigned NOT NULL default '0', data longblob ) TYPE=MyISAM; we are base-64 encoding the file before inserting it into the database we've tried: - increasing all the values in our init script - using php to upload the file and insert into the database - using java (jdbc) to insert the file - using the command line to insert the file ALL HAVE FAILED Note: - we can give you this file upon request How-To-Repeat: 1. Get a large file (15+ MB) 2. Create schema as above 3. base-64 encode the file 4. insert into the table Fix: unknown Submitter-Id: submitter ID Originator: Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: large blob inserts fail even when setting max-allowed-packet to 64M Severity: serious Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.41 (Source distribution) Server: /usr/bin/mysqladmin Ver 8.21 Distrib 3.23.41, for redhat-linux-gnu on i386 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.41 Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 54 min 43 sec Threads: 3 Questions: 1406 Slow queries: 0 Opens: 849 Flush tables: 1 Open tables: 128 Queries per second avg: 0.428 Environment: System: Linux abe.commnav.com 2.4.7-10 #1 Thu Sep 6 17:27:27 EDT 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/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98) Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' CXX='c++' CXXFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Mar 1 05:22 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 5723311 Dec 8 09:04 /lib/libc-2.2.4.so -rw-r--r--1 root root 27314296 Dec 8 09:02 /usr/lib/libc.a -rw-r--r--1 root root 178 Dec 8 09:02 /usr/lib/libc.so Configure command: ./configure i386-redhat-linux --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --includedir=/usr/include --libdir=/usr/lib --libexecdir=/usr/libexec --localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/share/man --infodir=/usr/share/info --without-debug --without-readline --enable-shared --with-extra-charsets=complex --with-bench --localstatedir=/var/lib/mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --with-mysqld-user=mysql --with-extra-charsets=all --disable-assember --with-berkeley-db --enable-large-files=yes --enable-largefile=yes --with-thread-safe-client --enable-assembler - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: nothing technical....
One more reason to stick to MySql! For those interested, another article here: Oracle Pricing called into question http://www.eweek.com/article/0,3658,s=1884a=24365,00.asp At 09:42 AM 3/21/2002 -0500, Gurhan Ozen wrote: Thought some might be interested in such articles. Seems like Oracle's got caught red handed scrambling:) http://reuters.com/news_article.jhtml?type=technologynewsStoryID=725126 Just for the filter: MySQL rocks :) Gurhan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: delete vs delete quick
In the last episode (Mar 21), Viraj Alankar said: sql I'm confused as to what 'delete quick' does and when to use it. The manual states: If you specify the word QUICK then the table handler will not merge index leafs during delete, which may speed up certain kind of deletes. Normally when you delete an entry from an index, if the deletion causes an index block to become half-empty (or 25%, or whatever; depends on the algorithm), mysql will start coalescing index blocks. This results in a smaller, more efficient index. If you are simply deleting a bunch of records only to re-insert new ones, there's not much use in trying to optimize the index halfway through the operation. -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: server startup error on linux
I assume that the mysql daemon is looking for one of those owned by mysql. The server will start if I send the --skip-grant-tables option Who wants to run a database with no grant tables Find out where your databases are located. Think /var/db/mysql is the default. Go there and type: chown -Rf mysql:mysql * to change ownership of databases and tables. Note that mysql:mysql is user:group and if the mysql-user and/or group is different from 'mysql' you should change it. :wq //andreas http://phpwizard.dk (in Danish only) sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Query syntax help
I'm trying to figure out a query that will tell me the total number of people in our house email file that physically opted out in the last week. I'm a bit of a mysql newbie as you can tell... This is the general concept, though it doesn't seem to work: select count(id) from contact # my data table where optin='no'# shows they are an opt-out AND bad_email IS NULL # is ticked if it was a bounceback opt-out AND email IS NOT NULL # show only for records that have emails AND date = 2002-03-17; # show data only since last sunday I appear to be getting hung up on the date part. I'm not sure if I can use that kind of operator on a date with that format. Any help is appreciated! Thanks, Rory - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: please, show me!
If you are using KDE, there a great gui mysql program called kmysqladmin, that you can download and install and have running within second, it comes all versions of Sues and a great guy to work with. I know that on the website there is a tar ball and a Red Hat version. Use google.com to find it. Chuck Payne Magi Design and Support On 3/21/02 10:44 AM, Victoria Reznichenko [EMAIL PROTECTED] wrote: Nguyen, Thursday, March 21, 2002, 5:53:08 AM, you wrote: NHN I am using Linux Red Hat 7.2 and I want to execute NHN mysqlgui. After I start this program, have a error is: NHN Can't connect to local mysql server through socket. NHN Please, show me a way to solve this problem. After starting MySQLGUI fill up the entries in Options dialog box and save them. How to fill entries read in the README file. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ANN: EMS MySQL Manager 1.67 released
Dear Sirs and Madams, EMS HiTech company is announcing the next version (1.67) of MySQL Manager -- A Powerful MySQL Administration and Development Tool for Windows95/98/ME/NT/2000/XP. You can download the latest version from http://www.mysqlmanager.com/download.phtml What's new in version 1.67? 1. An ability to run the multiple instances of Query Builder was added. Use New Query Builder item of the Tools menu to open a new window of Query Builder (*). 2. SQL Editor: the ability of executing the selected part of query was added. Just select the part of the query in the editor and then use Alt+F9 shortcut. You can also run the selected part using Execute Selected Only item of editor's popup menu or popup menu of the Execute button. 3. Import Data Wizard: an ability of data formats definition was added. Now the following features are available (*) : a) defining autoincrement values; b) defining constant values; c) defining default values; d) defining quotation actions; e) defining char case; f) defining char set. 4. Environment Options: Transaction Confirmation option was added. Now you can disable transaction confirmation on exit from Query Builder and SQL Editor by specifying the default action: commit or rollback. You can find this option at Tools page of Environment Options dialogue. 5. Query Builder: now you can quickly clear the query by clicking the Clear Query button on a toolbar (*). 6. Fixed bug with adding fields of type ENUM and SET to a table. 7. Fixed bug with manual size editing in Import Data Wizard (*). 8. Some minor bug fixes and small improvements. (*) -- Professional Edition only What is the EMS MySQL Manager? EMS MySQL Manager provides you powerful and effective tools for MySQL Server administration and objects management. Its Graphical User Interface (GUI) allows you to create/edit of all MySQL database objects most easy and simple way, run SQL scripts, manage users and administrate users' privileges, visually build SQL queries, extract or print metadata, export/import data, view/edit BLOBs and many more services that will make you work with MySQL server as easy as you want... Best regards, EMS HiTech development team. http://www.ems-hitech.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: still no umlauts in mysql --experts help needed
sascha, Wednesday, March 20, 2002, 12:52:41 PM, you wrote: sm Am Mittwoch, 20. März 2002 11:24 schrieben Sie: sm I just installed mysql fresh out of the box on a fresh SuSE linux 7.1. sm mysql does not let me enter german umlauts, though. I tried to start it sm with mysql --default-character-set=latin_de, but it complained about sm the character sets not being installed. Then I installed the mysql sm server, which in turn installs the character sets. latin_de is not sm included, though. I tried it with mysql --default-character-set=german1 sm instead. No luck. sm sm Was meinst Du mit does not let me enter? Blockieren die sm entsprechenden Tasten? Erscheint nichts auf dem Bildschirm? Gibt es sm irgendeine Fehlermeldung? Liefert MySQL bei einem SELECT das Falsche sm zurück? sm keystrokes with umlauts do not have any echo on the screen. batch input (text sm files with sql statements with umlauts redirected to mysql) do not insert sm umlauts into the database (but the rest of the text, so that the words are sm mis-spelt). there is no error message. select statements contain any umlauts sm in the database, though, and I can enter umlauts into the database using sm other clients than mysql. Looks like it's a question of readline/local, it's not a MySQL problem. sm s.m. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Access denied on use mysql;
I just gave up, everything that I tried did not work. I killed mysql and then started with safe_mysql --skip-grant-tables then I was able to connect to mysql without an error. But when I tried to Grant all on mysql.* to root@localhost identified by password; it gave me the message Unknown Command. - Original Message - From: alan4100 [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 11:07 AM Subject: Re: Access denied on use mysql; mysql Hello Kathy, How have you made out with access to mysql? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
logrotate problem
Hello there!
I have added recently administrative user to mysql database:
#mysqladmin -u root password someposword
since then I'm getting every day such e-mail from logrotate demon:
Subject: errors rotating logs Message: errors occured while rotating /var/lib/mysql/mysql.log
mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' error running postrotate script
My rogrotate demon have such configuration file for mysql: /var/lib/mysql/mysql.log { rotate 3 daily compress postrotate mysqladmin flush-logs endscript }
Any advice will be greatly appreciated!
- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
database and web servers
Is it possible to have your web server and your MySQL server running at different geographic locations? I'm wondering if I can run my own MySQL server here at home on Linux and have my web site use PHP to connect to it and extract data. Is that a bad idea for security and speed? thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: rpms for redhat 6.2
Hi! Hi, can any one suggest where I can get latest MySQL rpms for redhat 6.2 with glibc 2.1x... the new rpms .49+ are all for glibc 2.2+ I had the same problem. There are four possible solutions: a) The obvious but annoying one: upgrade to RH72... b) The less likely one. Upgrade RH62 to GLIBC22, but this is *STRONGLY DISCOURAGED* by Redhat... c) Trust Sinisa Milivojevic (who is one of MySQL developers). He told me to ignore warnings and force installation of MySQL binaries, since they're statically linked with GLIBC22 d) The difficult way: rebuild binaries. This was my choice (thank to James C. McDonald). In order to rebuild binaries you've to upgrade the gcc compiler, too. Follow these steps: 1. downloaded the gcc-2.95.4-4h.src.rpm from http://rpmfind.net/ (it's from a PPC distro but its RedHat based) 2. built rpms for gcc-2.95-4 on your RH62 box executing: # rpm --rebuild gcc-2.95.4-4h.src.rpm(*) You will find rebuilded packages in /usr/src/redhat/RPMS/i386/ 3. Remove old egcs and install the gcc-2.95-4 rpms you've built. You will need to install gperf-2.7-6.i386.rpm if it is not already installed (it's on your RedHat CD-ROM). # rpm -e egcs-c++-1.1.2-30 # rpm -e egcs-objc-1.1.2-30 # rpm -e egcs-1.1.2-30 # rpm -e cpp-1.1.2-30 # rpm -ivh cpp-2.95.4-4h.i386.rpm # rpm -ivh gcc-2.95.4-4h.i386.rpm # rpm -ivh libstdc++-2.10.0-4h.i386.rpm # rpm -ivh gcc-c++-2.95.4-4h.i386.rpm # rpm -ivh gperf-2.7-6.i386.rpm 4. Rebuild MySQL: # rpm --rebuild MySQL-3.23.49-1.src.rpm 5. Finally install MySQL binaries Regards Gabriele Carioli (*) Actually I'm not sure if you can build directly this version. Infact I formerly built gcc 2.95.2-1i. With this one I built gcc 2.96 (and had to rebuild binutils-2.11 and upgrade to, too), but then it was pointed out that this version of gcc does not work well with mysql. So I finally built gcc-2.95-4 and down-graded to this one. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Query syntax help
AND date = 2002-03-17; -Original Message- From: rory oconnor [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 10:49 AM To: mysql list (choose midget) Subject: Query syntax help I'm trying to figure out a query that will tell me the total number of people in our house email file that physically opted out in the last week. I'm a bit of a mysql newbie as you can tell... This is the general concept, though it doesn't seem to work: select count(id) from contact # my data table where optin='no'# shows they are an opt-out AND bad_email IS NULL # is ticked if it was a bounceback opt-out AND email IS NOT NULL # show only for records that have emails AND date = 2002-03-17; # show data only since last sunday I appear to be getting hung up on the date part. I'm not sure if I can use that kind of operator on a date with that format. Any help is appreciated! Thanks, Rory - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Query syntax help
I'm trying to figure out a query that will tell me the total number of people in our house email file that physically opted out in the last week. I'm a bit of a mysql newbie as you can tell... This is the general concept, though it doesn't seem to work: select count(id) from contact # my data table where optin='no' # shows they are an opt-out AND bad_email IS NULL # is ticked if it was a bounceback opt-out AND email IS NOT NULL # show only for records that have emails AND date = 2002-03-17; # show data only since last sunday I appear to be getting hung up on the date part. I'm not sure if I can use that kind of operator on a date with that format. Any help is appreciated! You need to put the date constant in quotes: ... AND date = '2002-03-17'; -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Rotation of binary logs on replication master?
Just wondering if any Linux users of MySQL out there had written a logrotate configuration file for dealing with MySQL binary logs on a replication Master. I want to rotate these logs (6.5 GB now) as some are over a month old. However, I don't want to confuse any of the replicating slaves. Any tips? Thanks. -- Guy Davis Phone: (403) 301-3426 Pason Systems Fax: (403) 301-3499 PGP: 65BA 484B 0B96 5F3B 4D40 DCA2 B2AE 6B5A F52B 1445 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Getting Found Count When Using Limit
I am trying to get the full found count from a query while using LIMIT to return just a portion of the found records. I can use two queries in a row to get first the found count, then the found records, but that takes twice as long as performing either query by itself. SELECT COUNT(*) FROM database.table WHERE query SELECT fields FROM database.table WHERE query LIMIT 10 If I use COUNT(*),fields in the SQL statement I have to add a GROUP BY clause. If I GROUP BY my auto increment field then COUNT(*) always evaluates to 1. If I GROUP BY a constant in every row then I get one record back with the correct total. Is there any way to get both the number of records found and the first set of results using a single query? Thanks, [fletcher] -- Fletcher Sandbeck [EMAIL PROTECTED] Lasso Product Specialist [EMAIL PROTECTED] Blue World Communications, Inc. http://www.blueworld.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
libmysqlclient libstdc++ question.
OS: Compaq Tru 64 4.0F Compiler: GNU GCC 3.0.4 - libstdc++.3.0.4 MySQL 3.23.49 MySQL Protocol 10 - libmysqlclient.so.10.0.0 After upgrading apache/php with the new 3.23.49 libs all of my previously working 'C' mysql applications have died. This is okay on one hand cause I am moving them to 'php' but I just wanted to check out exactly what I did wrong. I've stayed fairly current in the past and haven't had any troubles. I read in the manual that in any case recompile the .c files against the new libmysqlclient and this should solve your problem. I did. :) But I'm still getting apache 500 errors. I wrote a quick .c program to grab a record from a db and it works. I then add the appropriate html `stuff' and run it from apache and it croaks. A note for you, when I first ran mysql after the upgrade it gave me a libstdc++ loader error. I removed the symlink to the new 3.0.4 and ran the older 3.0 and it then proceeded to work. Maybe I should recompile apache? Will this work with the libstdc++.so.3.0? Ack... I know I'm missing the obvious here but can someone show me the light. I do think that it's a lib issue but don't know where it is. Rob. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Server startup error on Linux
I issued the chown command as indicated by Andreas but it doesnt help I still get the Table mysql.hosts doesnt exist I know that all the tables created by mysql_install_db are infact owned by mysql but the server daemon still cant find them what next? _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Query syntax help
What you had looks fine except the date...change what you had to: AND date = '2002-03-17'; # date needs quotes around it Should work. -Original Message- From: rory oconnor [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 8:49 AM To: mysql list (choose midget) Subject: Query syntax help I'm trying to figure out a query that will tell me the total number of people in our house email file that physically opted out in the last week. I'm a bit of a mysql newbie as you can tell... This is the general concept, though it doesn't seem to work: select count(id) from contact # my data table where optin='no'# shows they are an opt-out AND bad_email IS NULL # is ticked if it was a bounceback opt-out AND email IS NOT NULL # show only for records that have emails AND date = 2002-03-17; # show data only since last sunday I appear to be getting hung up on the date part. I'm not sure if I can use that kind of operator on a date with that format. Any help is appreciated! Thanks, Rory - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: database and web servers
On Thursday 21 March 2002 11:28 am, Klym wrote: Is it possible to have your web server and your MySQL server running at different geographic locations? I'm wondering if I can run my own MySQL server here at home on Linux and have my web site use PHP to connect to it and extract data. Is that a bad idea for security and speed? You can certainly do this. When you connect to a MySQL database, you generally specify _where_ this database is. That said, network bandwidth may become a significant concern. And no, it isn't a good idea for security. A database should be protected by a firewall that only the web server can get through. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: database and web servers
As long as you've got a fat pipe on both ends speed could be ok. But, then again, you never know. Some backhoe in Nebraska could cut your sweb server off from your database. Of course you'll want it to be secure as well. MySQL 4 has support for SSL. I suppose you could setup an ssh port redirection vpn-like system to use with MySQL 3.23 or such. But, it all depends on your needs, your site's traffic, etc. Experiment. :) - Gabriel Klym wrote: Is it possible to have your web server and your MySQL server running at different geographic locations? I'm wondering if I can run my own MySQL server here at home on Linux and have my web site use PHP to connect to it and extract data. Is that a bad idea for security and speed? thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Access denied on use mysql;
mysql Kathy, I see..
Status of InnoDB support.
I was just perusing the Innobase Oy site and read that they've declared MySQL/InnoDB 3.23 stable (it actually says they did this in February). I read somewhere on the MySQL site a while ago stating that InnoDB wasn't included in the non-Max distribution because it was still considered beta. I can't find that notice anymore so I guess it's gone. Is InnoDB actually in a stable/1.0/non-beta state now officially? And does anyone know what the schedule is for the build process for the binary distribution of mysql from mysql.com? I'd like to know when the MacOS X binary will be up to 3.23.49(a?), or if I should just download the source and build it myself? Thanks, Gabriel Ricard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Rotation of binary logs on replication master?
/usr/local/bin/mysql -hhostname -uusername -ppassword -e flush logs; Guy Davis wrote: Just wondering if any Linux users of MySQL out there had written a logrotate configuration file for dealing with MySQL binary logs on a replication Master. I want to rotate these logs (6.5 GB now) as some are over a month old. However, I don't want to confuse any of the replicating slaves. Any tips? Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can you Change Nulls in the MySQLDump from \N?
Is there a way to tell MySQL to put a blank space instead of \N in the tab-delimited files when it does a dump? I'm working on a MySQL to SQL Server migration and having problems with the output files. I'm doing this all in batch fellas so I'm not finding a good search and replace utility. (perl, c++, and other langs are not an option..) Thanks David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Access denied on use mysql;
Now I have a different problem. When I type mysql it gives me the message Access denied for user: 'root@localhost' (Using password: NO) how do I get it to use the password. When I type mysql -u root -p I get in... - Original Message - From: alan4100 [EMAIL PROTECTED] To: Kathy Reyes [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 2:55 PM Subject: Re: Access denied on use mysql; Kathy I see. - Original Message - From: Kathy Reyes [EMAIL PROTECTED] To: alan4100 [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 12:48 PM Subject: Re: Access denied on use mysql; I just gave up, everything that I tried did not work. I killed mysql and then started with safe_mysql --skip-grant-tables then I was able to connect to mysql without an error. But when I tried to Grant all on mysql.* to root@localhost identified by password; it gave me the message Unknown Command. - Original Message - From: alan4100 [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 11:07 AM Subject: Re: Access denied on use mysql; mysql Hello Kathy, How have you made out with access to mysql? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Load Data Command
Using the following inserts data from a text file into a particular MySQL table: LOAD DATA LOCAL INFILE file.txt INTO TABLE whatever; Is there any way to do this, but instead of inserting, it's updating? Michael Kaiser LivingLegend.net [EMAIL PROTECTED] Many folk like to know beforehand what is to be set on the table; but those who have laboured to prepare the feast like to keep their secrets; for wonder makes the words of praise louder. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Access denied on use mysql;
Grant all on mysql.* to 'root'@'localhost' identified by password; What version MySQL are you running? You need 3.23 for GRANT to work. Kathy Reyes wrote: I just gave up, everything that I tried did not work. I killed mysql and then started with safe_mysql --skip-grant-tables then I was able to connect to mysql without an error. But when I tried to Grant all on mysql.* to root@localhost identified by password; it gave me the message Unknown Command. - Original Message - From: alan4100 [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 11:07 AM Subject: Re: Access denied on use mysql; mysql Hello Kathy, How have you made out with access to mysql? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Compile time issue?
Hello, I have compiled mysql-3.23.49 from source distribution on a NetBSD 1.5.2 (sparc) box. Everything compiled fine, no-errors. Installed fine, no-errors. Starts and Stops fine no-errors. But when I go to run mysql or mysqladmin I get the following error: # /usr/local/mysql/bin/mysql Cannot open ../libmysql/.libs/libmysqlclient.so So I created a link from /usr/local/mysql/lib/mysql to /usr/local/mysql/libmysql/.libs This fixes the problem if I am physically in the /usr/local/mysql/bin directory. But obviously I would prefer to be able to run them from anywhere. I am assuming this can be fixed by recompiling, but havn't been able to locate where to make the fix. Thanks in advance, -Kyle - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Getting Found Count When Using Limit
Tough thing to do. Fortunately we thought this through for you in jTalk. Keep your eyes peeled for a formal announcement next week. -Allon On 3/21/02 11:04 AM, Fletcher Sandbeck [EMAIL PROTECTED] wrote: I am trying to get the full found count from a query while using LIMIT to return just a portion of the found records. I can use two queries in a row to get first the found count, then the found records, but that takes twice as long as performing either query by itself. SELECT COUNT(*) FROM database.table WHERE query SELECT fields FROM database.table WHERE query LIMIT 10 If I use COUNT(*),fields in the SQL statement I have to add a GROUP BY clause. If I GROUP BY my auto increment field then COUNT(*) always evaluates to 1. If I GROUP BY a constant in every row then I get one record back with the correct total. Is there any way to get both the number of records found and the first set of results using a single query? Thanks, [fletcher] -- Fletcher Sandbeck [EMAIL PROTECTED] Lasso Product Specialist [EMAIL PROTECTED] Blue World Communications, Inc. http://www.blueworld.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 Allon Bendavid Imacination Software [EMAIL PROTECTED]http://www.imacination.com/ 805-650-8153 Visit Imacination and start selling on the Web today with Ch-Ching! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: JSP or PHP?
Klym wrote: I have built a MySQL database for a web based survey. I am trying to decide between JSP and PHP for my programming interface. The reason I am considering Java is because I have some Java experience. What would you recommend for someone like me who is starting out? If you know java and like java, then use java. Check out the velocity template engine. http://jakarta.apache.org/velocity Cool stuff. I doubt you'll find a host for it though. Best to build your own server. If you are in a shared server environment, you'll probably have to use php or perl. Full Java/Servlet/JSP support is still a few years away for most hosting companies, though some do support it at additional cost. The setup and security considerations using java are a lot more complex than with perl or php. Ken Also, my two current hosting companies don't support JSP. Is this common? Is it more expensive for JSP support? Yes. Yes. thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: logrotate problem
in the postrotate section, you have to add the user and password parameters
to mysqladmin:
mysqladmin -u someuser --password=somepassword flush-logs
s.m.
Am Donnerstag, 21. März 2002 19:23 schrieben Sie:
Hello there!
nlnl
I have added recently administrative user to mysql database:
nlnl
#mysqladmin -u root password someposword
nlnl
since then I'm getting every day such e-mail from logrotate demon:
nlnl
Subject:
errors rotating logs
Message:
errors occured while rotating /var/lib/mysql/mysql.log
nlnl
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
error running postrotate script
nlnl
My rogrotate demon have such configuration file for mysql:
/var/lib/mysql/mysql.log {
nlrotate 3
nldaily
nlcompress
nlpostrotate
nlmysqladmin flush-logs
nlendscript
}
nlnl
Any advice will be greatly appreciated!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED] Trouble
unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Load Data Command
If the table has a unique key then add the REPLACE keyword. This will update the columns with new values if the key already exists and add the row if it doesnt. --Mark Michael Kaiser wrote: Using the following inserts data from a text file into a particular MySQL table: LOAD DATA LOCAL INFILE file.txt INTO TABLE whatever; Is there any way to do this, but instead of inserting, it's updating? Michael Kaiser LivingLegend.net [EMAIL PROTECTED] Many folk like to know beforehand what is to be set on the table; but those who have laboured to prepare the feast like to keep their secrets; for wonder makes the words of praise louder. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
--skip-networking causes daemon to shutdown immediately after startup?
Apologies for sending what may well be a duh problem, but I've run out of web- and documention-based resources... System: I'm running MySQL 3.23.47 on OS X 10.1.2. Symptoms: When I try to run safe_mysqld with --skip-networking (or with the option set in a my.cnf file), everything starts up fine (log entry below), but the moment mysqld proclaims itself ready for connections, something inspires the daemon to perform a normal shutdown. The docs for --skip-networking say it doesn't work with pthreads, so that was my first guess, except that then I found http://www.mysql.com/doc/M/a/Mac_OS_X_Public_Beta.html which seems to imply that OS X (not OS X Server) doesn't use pthreads. Am I just wrong? Or is there something else I'm missing? From data/localhost.err: 020320 01:39:51 mysqld started 020320 1:39:52 InnoDB: Started /usr/local/mysql/bin/mysqld: ready for connections 020320 1:39:52 /usr/local/mysql/bin/mysqld: Normal shutdown 020320 1:39:52 InnoDB: Starting shutdown... 020320 1:40:02 InnoDB: Shutdown completed 020320 1:40:02 /usr/local/mysql/bin/mysqld: Shutdown Complete 020320 01:40:03 mysqld ended (It happens whether or not InnoDB is running; this was just the easier-to-find log entry.) Thanks, Eric - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: JSP or PHP?
http://www.cqhost.com/ I have a JSP app hosted there and they are pretty good. They also provide a MSQL DB Mark -Original Message- From: Ken Anderson [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Thursday, March 21, 2002 2:39 PM Subject: Re: JSP or PHP? Klym wrote: I have built a MySQL database for a web based survey. I am trying to decide between JSP and PHP for my programming interface. The reason I am considering Java is because I have some Java experience. What would you recommend for someone like me who is starting out? If you know java and like java, then use java. Check out the velocity template engine. http://jakarta.apache.org/velocity Cool stuff. I doubt you'll find a host for it though. Best to build your own server. If you are in a shared server environment, you'll probably have to use php or perl. Full Java/Servlet/JSP support is still a few years away for most hosting companies, though some do support it at additional cost. The setup and security considerations using java are a lot more complex than with perl or php. Ken Also, my two current hosting companies don't support JSP. Is this common? Is it more expensive for JSP support? Yes. Yes. thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Error 1067: the process terminated unexpectedly
Can anyone help please! I am unable to start the service on WIN2K since I installed version MySQL-3.23.38. I have tried altering the my.cnf and my.ini files and I have tried running the service as the administrator user. But I am getting the same error message above each time. Any suggestions would be very welcome. ST - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Getting Found Count When Using Limit
On 3/21/02 at 12:51 PM, Allon Bendavid wrote: Tough thing to do. Fortunately we thought this through for you in jTalk. Keep your eyes peeled for a formal announcement next week. Actually, easy thing to do through the APIs or most third-party languages that let you access MySQL. I'm looking for a way to do it using raw MySQL statements. I think I found my answer in the list archives. It's not possible without using multiple SQL statements. [fletcher] -- Fletcher Sandbeck [EMAIL PROTECTED] Lasso Product Specialist [EMAIL PROTECTED] Blue World Communications, Inc. http://www.blueworld.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: Status of InnoDB support.
Gabriel, MySQL-Max-3.23 is now officially stable both in the opinion of MySQL AB and Innobase Oy. It is listed as stable both in the MySQL online manual and on the MySQL AB website front page. The reason for separate MySQL-3.23 and MySQL-Max-3.23 is commercial: there are different support and embedded license prices for these versions. InnoDB version numbers are the same as MySQL version numbers, because new versions appear as part of MySQL distributions. There is currently no standalone version of InnoDB available. Best regards, Heikki Tuuri CEO Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com Copied message: . I was just perusing the Innobase Oy site and read that they've declared MySQL/InnoDB 3.23 stable (it actually says they did this in February). I read somewhere on the MySQL site a while ago stating that InnoDB wasn't included in the non-Max distribution because it was still considered beta. I can't find that notice anymore so I guess it's gone. Is InnoDB actually in a stable/1.0/non-beta state now officially? And does anyone know what the schedule is for the build process for the binary distribution of mysql from mysql.com? I'd like to know when the MacOS X binary will be up to 3.23.49(a?), or if I should just download the source and build it myself? Thanks, Gabriel Ricard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Access denied on use mysql;
mysql Kathy.. Check version of mySQL for me. Did you said after typing mysql -u root -p, you get in fine? Then you type mysql? then access denied... Is this in a sequence? - Original Message - From: Kathy Reyes [EMAIL PROTECTED] To: alan4100 [EMAIL PROTECTED]; mysql [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 3:21 PM Subject: Re: Access denied on use mysql; Now I have a different problem. When I type mysql it gives me the message Access denied for user: 'root@localhost' (Using password: NO) how do I get it to use the password. When I type mysql -u root -p I get in... - Original Message - From: alan4100 [EMAIL PROTECTED] To: Kathy Reyes [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 2:55 PM Subject: Re: Access denied on use mysql; Kathy I see. - Original Message - From: Kathy Reyes [EMAIL PROTECTED] To: alan4100 [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 12:48 PM Subject: Re: Access denied on use mysql; I just gave up, everything that I tried did not work. I killed mysql and then started with safe_mysql --skip-grant-tables then I was able to connect to mysql without an error. But when I tried to Grant all on mysql.* to root@localhost identified by password; it gave me the message Unknown Command. - Original Message - From: alan4100 [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 11:07 AM Subject: Re: Access denied on use mysql; mysql Hello Kathy, How have you made out with access to mysql? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Access denied on use mysql;
mysql kathy, What would happen if you type in mysql -u root -p then type in use mysql
Complex query
I've got a mysql table and I need to perform a complex query on it, but I'm not sure how to formulate it. This is what I need to do: select id,tcc_cn,entered,updated,enteredby,num_bump, status FROM book_hold WHERE 1) There are no books with the tcc_cn that already have a status of 'NOTIFIED'. 2) Its updated date is the MIN(updated) for that tcc_cn. So, for example, if I have the following items: tcc_cn updated status - 990227 03-08-02 WAITING 990227 03-10-02 WAITING 990228 03-08-02 WAITING 990228 03-15-02 NOTIFIED I would get information back for this item: 990227 03-08-02 WAITING Is there a good way to do this in one or two queries? Any tips would be most appreciated. Thanks in advance! Jeff Shipman E-Mail: [EMAIL PROTECTED] Systems Programmer Phone: (505) 835-5748 NMIMT Computer Center http://www.nmt.edu/~jeff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 1067: the process terminated unexpectedly
Try a C:\my.cnf with just the following: [mysqld] datadir = C:/mysql/ tmpdir = C:/temp/ -Original Message- From: Gregory Junker [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 2:25 PM To: Simon Tienery; [EMAIL PROTECTED] Subject: RE: Error 1067: the process terminated unexpectedly have you tried running the server in standalone from the command prompt, to get some more output from the startup sequence? -Original Message- From: Simon Tienery [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 4:40 PM To: [EMAIL PROTECTED] Subject: Error 1067: the process terminated unexpectedly Can anyone help please! I am unable to start the service on WIN2K since I installed version MySQL-3.23.38. I have tried altering the my.cnf and my.ini files and I have tried running the service as the administrator user. But I am getting the same error message above each time. Any suggestions would be very welcome. ST - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql 4.0.1-Alpha: Union + Limit bug.
Description: Take two tables (call them a and b), which have identical structures. Table a has no rows, table b has some (say 10) rows. If you do this: select * from a union select * from b limit 0,5 It works as expected. Now do this: select * from a union select * from b limit 5,5 Now you get _zero_ rows. In version 4.0.0, this worked as expected. How-To-Repeat: mysql desc a; desc b; +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+---+ | data | varchar(50) | YES | | NULL| | +---+-+--+-+-+---+ 1 row in set (0.00 sec) +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+---+ | data | varchar(50) | YES | | NULL| | +---+-+--+-+-+---+ 1 row in set (0.00 sec) mysql select count(*) from a; select count(*) from b; +--+ | count(*) | +--+ |0 | +--+ 1 row in set (0.00 sec) +--+ | count(*) | +--+ | 10 | +--+ 1 row in set (0.00 sec) mysql select * from b; +--+ | data | +--+ | 1| | 2| | 3| | 4| | 5| | 6| | 7| | 8| | 9| | 10 | +--+ 10 rows in set (0.00 sec) mysql select * from a union select * from b limit 0,5; +--+ | data | +--+ | 1| | 2| | 3| | 4| | 5| +--+ 5 rows in set (0.00 sec) mysql select * from a union select * from b limit 5,5; Empty set (0.00 sec) mysql Fix: None known. Submitter-Id: Originator:Eric Poulsen Organization: MySQL support: none Synopsis: Union + Limit issue in 4.0.1 Alpha Severity: non-critical Priority: medium Category: mysql Class: sw-bug Release: mysql-4.0.1-alpha (Official MySQL binary) Environment: System: Linux webserver1 2.4.17 #1 SMP Thu Jan 10 11:10:31 PST 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.2/specs gcc version 2.95.2 2220 (Debian GNU/Linux) Compilation info: CC='gcc' CFLAGS='-O3 -mpentium ' CXX='gcc' CXXFLAGS='-O3 -mpentium -felide-constructors' LDFLAGS='-static' LIBC: lrwxrwxrwx1 root root 14 Mar 13 11:25 /lib/libc.so.5 - libc.so.5.4.46 -rw-r--r--1 root root 586720 Feb 8 1999 /lib/libc.so.5.4.46 lrwxrwxrwx1 root root 13 Jan 17 20:08 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x1 root root 888064 Jan 17 20:08 /lib/libc-2.1.3.so -rw-r--r--1 root root 209 Jan 9 07:11 /usr/lib/libc.a -rw-r--r--1 root root 178 Jan 9 07:11 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-thread-safe-client --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
RE: Getting Found Count When Using Limit
* Fletcher Sandbeck Actually, easy thing to do through the APIs or most third-party languages that let you access MySQL. I'm looking for a way to do it using raw MySQL statements. I think I found my answer in the list archives. It's not possible without using multiple SQL statements. There is a way to do it if you are using version 4... from the manual: SQL_CALC_FOUND_ROWS tells MySQL to calculate how many rows there would be in the result, disregarding any LIMIT clause. The number of rows can be obtained with SELECT FOUND_ROWS(). URL: http://www.mysql.com/doc/S/E/SELECT.html -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
