perform on mysqlbug man page
The mysqlbug man page has the weird word perform at the end of this sentence: The script will place you in an editor with a copy of the report to be sent. Edit the lines near the beginning that indicate the nature of the problem. Then write the file to save your changes, quit the editor, and mysqlbug will send the report by email. perform. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: uninstall 4.0.18 on Windows (was: Re: mysqlbug)
Hi Tracy, all, I am following up to my own mail, as Tracy's reply was not sent to the list. In most cases (including this one), this is _no_ good idea, as the collective wisdom of the list is greater than a personal one, and others might be interested in the responses as well. Joerg Bruehe wrote: Tracy wrote: Dear sir, I am trying to uninstall my old Mysql version 4.0, however, I don't know how to. Please give me some directions on how to do that. You have a very high trust in the capabilities of our crystal balls ... For a question like this, you should definitely _at least_ tell your platform and the package format you used for installation, also the exact MySQL version might be interesting. These are the informations Tracy sent me: | I have version 4.0.18 presently installed. I am operating on Windows XP | Professional with SP2 (that means service pack 2 in case your crystal | ball doesn't clarify that for you). The installation was performed using | Winzip to extract the files to my C: drive and then I ran Setup.exe. So you used a package with an included installer. AFAIK, a right-click on the package and/or calling the installer again should provide you with an option to uninstall. Windows users might check / correct / explain better. | Since the website doesn't offer any clarifying explanation about how | to uninstall the application, I would like to get some instructions | on that. These should be in the manual, not on the web site in general. | Hopefully this is sufficient information for you to instruct me on the | procedures necessary to uninstall your product. Just very general, see above. Maybe you did not notice, but I am definitely _not_ a Windows expert (even though I know the term SP2), so I refer you to the list for further details. HTH, Joerg -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: uninstall 4.0.18 on Windows (was: Re: mysqlbug)
Hi Joerg, all, I am just so thrilled on how nice and helpful the people at MySql are. Thanks!! Sincerely, Tracy Huang On 11/7/05, Joerg Bruehe [EMAIL PROTECTED] wrote: Hi Tracy, all, I am following up to my own mail, as Tracy's reply was not sent to the list. In most cases (including this one), this is _no_ good idea, as the collective wisdom of the list is greater than a personal one, and others might be interested in the responses as well. Joerg Bruehe wrote: Tracy wrote: Dear sir, I am trying to uninstall my old Mysql version 4.0, however, I don't know how to. Please give me some directions on how to do that. You have a very high trust in the capabilities of our crystal balls ... For a question like this, you should definitely _at least_ tell your platform and the package format you used for installation, also the exact MySQL version might be interesting. These are the informations Tracy sent me: | I have version 4.0.18 presently installed. I am operating on Windows XP | Professional with SP2 (that means service pack 2 in case your crystal | ball doesn't clarify that for you). The installation was performed using | Winzip to extract the files to my C: drive and then I ran Setup.exe. So you used a package with an included installer. AFAIK, a right-click on the package and/or calling the installer again should provide you with an option to uninstall. Windows users might check / correct / explain better. | Since the website doesn't offer any clarifying explanation about how | to uninstall the application, I would like to get some instructions | on that. These should be in the manual, not on the web site in general. | Hopefully this is sufficient information for you to instruct me on the | procedures necessary to uninstall your product. Just very general, see above. Maybe you did not notice, but I am definitely _not_ a Windows expert (even though I know the term SP2), so I refer you to the list for further details. HTH, Joerg -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com http://www.mysql.com -- Tracy Nelson 6641 Coleus Ct. West Jordan, UT 84084 U.S.A. (801)840-0838
Re: uninstall 4.0.18 on Windows (was: Re: mysqlbug)
Does that mean that his suggestion(s) worked? (it should have) Others that find your question in the archive would probably like to know. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Tracy [EMAIL PROTECTED] wrote on 11/07/2005 12:06:05 PM: Hi Joerg, all, I am just so thrilled on how nice and helpful the people at MySql are. Thanks!! Sincerely, Tracy Huang On 11/7/05, Joerg Bruehe [EMAIL PROTECTED] wrote: Hi Tracy, all, I am following up to my own mail, as Tracy's reply was not sent to the list. In most cases (including this one), this is _no_ good idea, as the collective wisdom of the list is greater than a personal one, and others might be interested in the responses as well. Joerg Bruehe wrote: Tracy wrote: Dear sir, I am trying to uninstall my old Mysql version 4.0, however, I don't know how to. Please give me some directions on how to do that. You have a very high trust in the capabilities of our crystal balls ... For a question like this, you should definitely _at least_ tell your platform and the package format you used for installation, also the exact MySQL version might be interesting. These are the informations Tracy sent me: | I have version 4.0.18 presently installed. I am operating on Windows XP | Professional with SP2 (that means service pack 2 in case your crystal | ball doesn't clarify that for you). The installation was performed using | Winzip to extract the files to my C: drive and then I ran Setup.exe. So you used a package with an included installer. AFAIK, a right-click on the package and/or calling the installer again should provide you with an option to uninstall. Windows users might check / correct / explain better. | Since the website doesn't offer any clarifying explanation about how | to uninstall the application, I would like to get some instructions | on that. These should be in the manual, not on the web site in general. | Hopefully this is sufficient information for you to instruct me on the | procedures necessary to uninstall your product. Just very general, see above. Maybe you did not notice, but I am definitely _not_ a Windows expert (even though I know the term SP2), so I refer you to the list for further details. HTH, Joerg -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com http://www.mysql.com -- Tracy Nelson 6641 Coleus Ct. West Jordan, UT 84084 U.S.A. (801)840-0838
Re: mysqlbug
Dear Tracy, Tracy wrote: Dear sir, I am trying to uninstall my old Mysql version 4.0, however, I don't know how to. Please give me some directions on how to do that. You have a very high trust in the capabilities of our crystal balls ... For a question like this, you should definitely _at least_ tell your platform and the package format you used for installation, also the exact MySQL version might be interesting. Jörg PS: This is quite a common omission on this list, but I really cannot understand how (these) posters expect others can help them. -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqlbug
Dear sir, I am trying to uninstall my old Mysql version 4.0, however, I don't know how to. Please give me some directions on how to do that. Thanks! Sincerely, Tracy Huang
Re: mysqlbug
Hello. Please let me know how to install MySQL successfully on Linux. You may use official binaries. See: http://dev.mysql.com/downloads/ [snip] I was installing MySQL on Linux. At that time it was giving some problem when I did ./configure. Your libc libraries are not 100% compatible with MySQL version. Mysqld should work normally with the exception that hostname resolving will not work. This means that you should use IP address instead of host name when specifying Mysql privileges. Please let me know how to install MySQL successfully on Linux. Waiting for your valuable reply. Regards Sheela. Sheela_Belagutti [EMAIL PROTECTED] wrote: [snip] -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqlbug
Hi I was installing MySQL on Linux. At that time it was giving some problem when I did ./configure. Your libc libraries are not 100% compatible with MySQL version. Mysqld should work normally with the exception that hostname resolving will not work. This means that you should use IP address instead of host name when specifying Mysql privileges. Please let me know how to install MySQL successfully on Linux. Waiting for your valuable reply. Regards Sheela. ** This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. **
Re: mysqlbug
Hello. See: http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html Jerome Campbell [EMAIL PROTECTED] wrote: Hello, I've been using MySQL for a while on my computer to host a couple of things and since today I've got this error: 2003 - Can't connect to MySQL server on 'localhost' (10061) I have no clue why MySQL isn't even connecting any more, if you have any information why, please email me. Thanks. - Jerome -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqlbug
Hello, I've been using MySQL for a while on my computer to host a couple of things and since today I've got this error: 2003 - Can't connect to MySQL server on 'localhost' (10061) I have no clue why MySQL isn't even connecting any more, if you have any information why, please email me. Thanks. - Jerome -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqlbug
At 03:31 PM 2/21/2005, Jerome Campbell wrote: Hello, I've been using MySQL for a while on my computer to host a couple of things and since today I've got this error: 2003 - Can't connect to MySQL server on 'localhost' (10061) I have no clue why MySQL isn't even connecting any more, if you have any information why, please email me. Thanks. - Jerome Jerome, Perhaps the MySQL service is no longer running (in WIndows look at the Services Manager), or the password has changed. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqlbug report
From: lrpbfd To: [EMAIL PROTECTED] Subject: [50 character or so descriptive subject here (for reference)] Description: precise description of the problem (multiple lines) How-To-Repeat: code/input/activities to reproduce the problem (multiple lines) Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: submitter ID Originator:lrpbfd Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-4.0.21-standard (Official MySQL-standard binary) C compiler: C++ compiler: Environment: machine, os, target, libraries (multiple lines) System: SunOS hexagon.lrp.com 5.9 Generic_112234-03 i86pc i386 i86pc Architecture: i86pc Some paths: /usr/bin/perl /usr/ccs/bin/make /usr/local/bin/gcc GCC: Reading specs from /usr/local/lib/gcc/i386-pc-solaris2.9/3.4.0/specs Configured with: ../configure --with-as=/usr/ccs/bin/as --with-ld=/usr/ccs/bin/ld --disable-nls Thread model: posix gcc version 3.4.0 Compilation info: CC='cc' CFLAGS='-xO3 -mt -fsimple=1 -ftrap=%none -nofstore -xbuiltin=%all -xlibmil -xlibmopt -xtarget=native' CXX='CC' CXXFLAGS='-xO3 -mt -fsimple=1 -ftrap=%none -nofstore -xbuiltin=%all -xlibmil -xlibmopt -xtarget=native' LDFLAGS='' ASFLAGS='' LIBC: -rw-r--r-- 1 root bin 1886116 Nov 4 2002 /lib/libc.a lrwxrwxrwx 1 root root 11 May 31 22:37 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 795704 Nov 4 2002 /lib/libc.so.1 lrwxrwxrwx 1 root other 9 Jul 27 21:46 /lib/libc.so.6 - libc.so.1 -rw-r--r-- 1 root bin 1886116 Nov 4 2002 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 May 31 22:37 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 795704 Nov 4 2002 /usr/lib/libc.so.1 lrwxrwxrwx 1 root other 9 Jul 27 21:46 /usr/lib/libc.so.6 - libc.so.1 Configure command: ./configure '--prefix=/usr/local/mysql' '--localstatedir=/usr/local/mysql/data' '--libexecdir=/usr/local/mysql/bin' '--with-comment=Official MySQL-standard binary' '--with-extra-charsets=complex' '--with-server-suffix=-standard' '--enable-thread-safe-client' '--enable-local-infile' 'CC=cc' 'CFLAGS=-xO3 -mt -fsimple=1 -ftrap=%none -nofstore -xbuiltin=%all -xlibmil -xlibmopt -xtarget=native' 'CXX=CC' 'CXXFLAGS=-xO3 -mt -fsimple=1 -ftrap=%none -nofstore -xbuiltin=%all -xlibmil -xlibmopt -xtarget=native' '--with-named-curses=-lcurses' '--disable-shared' '--with-embedded-server' '--with-innodb' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Suggest improvement for mysqlbug
Description:
I had some difficulties to send a bug report by mysqlbug. It
inserted my UNIX user name as From: and used some default mail
agent, which used my UNIX username @ local domain as the
sender address. While the first is merely uncomfortable, the
latter inhibited the mail from being delivered.
I improved mysqlbug so that it respects two environment
variables, if present (see the diffs below):
REAL_EMAIL - From: address. This is used by bitkeeper too.
MAIL_AGENT - Program to use for sending mail (I have one that
uses the From: address as sender).
How-To-Repeat:
Fix:
Here my changes (output of bk -r diffs -c):
= scripts/mysqlbug.sh 1.6 vs edited =
*** /tmp/mysqlbug.sh-1.6-1881 Fri Dec 20 13:58:17 2002
--- edited/scripts/mysqlbug.sh Tue Jan 6 18:07:16 2004
***
*** 44,57
# How to read the passwd database.
PASSWD=cat /etc/passwd
! if test -f /usr/lib/sendmail
then
! MAIL_AGENT=/usr/lib/sendmail -oi -t
! elif test -f /usr/sbin/sendmail
! then
! MAIL_AGENT=/usr/sbin/sendmail -oi -t
! else
! MAIL_AGENT=rmail $BUGmysql
fi
# Figure out how to echo a string without a trailing newline
--- 44,60
# How to read the passwd database.
PASSWD=cat /etc/passwd
! if test x$MAIL_AGENT = x
then
! if test -f /usr/lib/sendmail
! then
! MAIL_AGENT=/usr/lib/sendmail -oi -t
! elif test -f /usr/sbin/sendmail
! then
! MAIL_AGENT=/usr/sbin/sendmail -oi -t
! else
! MAIL_AGENT=rmail $BUGmysql
! fi
fi
# Figure out how to echo a string without a trailing newline
***
*** 208,214
SEND-PR: Lines starting with \`SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in \`' and \`').
SEND-PR:
! From: ${USER}
To: ${BUGADDR}
Subject: $SUBJECT_C
--- 211,217
SEND-PR: Lines starting with \`SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in \`' and \`').
SEND-PR:
! From: ${REAL_EMAIL:-${USER}}
To: ${BUGADDR}
Subject: $SUBJECT_C
Submitter-Id: submitter ID
Originator:MySQL Development
Organization: private
MySQL support: none
Synopsis: Suggest improvement for mysqlbug
Severity: non-critical
Priority: medium
Category: mysql
Class: change-request
Release: mysql-5.0.0-alpha (Source distribution)
C compiler:gcc (GCC) 3.3.3 20031206 (prerelease) (Debian)
C++ compiler: gcc (GCC) 3.3.3 20031206 (prerelease) (Debian)
Environment: PC, Debian GNU/Linux (sid), Pentium 4
libc62.3.2.ds1-10
zlib1g 1.2.1-3
System: Linux chilla 2.6.0-test11 #1 Sun Jan 4 17:04:51 CET 2004 i686 GNU/Linux
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i486-linux/3.3.3/specs
Konfiguriert mit: ../src/configure -v
--enable-languages=c,c++,java,f77,pascal,objc,ada,treelang --prefix=/usr
--mandir=/usr/share/man --infodir=/usr/share/info
--with-gxx-include-dir=/usr/include/c++/3.3 --enable-shared --with-system-zlib
--enable-nls --without-included-gettext --enable-__cxa_atexit --enable-clocale=gnu
--enable-debug --enable-java-gc=boehm --enable-java-awt=xlib --enable-objc-gc
i486-linux
Thread model: posix
gcc-Version 3.3.3 20031229 (prerelease) (Debian)
Compilation info: CC='gcc' CFLAGS='-g -march=pentium4' CXX='gcc' CXXFLAGS='-g
-march=pentium4 -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' ASFLAGS=''
LIBC:
lrwxrwxrwx1 root root 13 2003-11-15 12:44 /lib/libc.so.6 -
libc-2.3.2.so
-rw-r--r--1 root root 1243076 2003-11-05 20:17 /lib/libc-2.3.2.so
-rw-r--r--1 root root 2537670 2003-11-05 20:18 /usr/lib/libc.a
-rw-r--r--1 root root 204 2003-11-05 20:07 /usr/lib/libc.so
Configure command: ./configure '--prefix=/usr/local/mysql'
'--with-unix-socket-path=/usr/local/mysql/tmp/mysql.sock' '--with-debug' 'CFLAGS=-g
-march=pentium4' 'CXXFLAGS=-g -march=pentium4 -felide-constructors -fno-exceptions
-fno-rtti' 'CXX=gcc'
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fw: mysqlbug
i have fixed it! sorry (c:\my_cfg*) - Original Message - From: Richard Korebrits To: [EMAIL PROTECTED] Sent: Sunday, September 07, 2003 2:15 PM Subject: mysqlbug hello, previously is had installed a complete installation of apache/php/mysql but now i tried to install them all apart, but now i have the problem that when is try to start mysql i get this error: C:\Apache2\mysql\binmysqld-nt --standalone 030907 14:09:53 Can't find messagefile 'C:\phpdev5\mysql\share\english\errmsg.s ys' 030907 14:09:53 Aborting what can i do about this?
mysqlbug
hello, previously is had installed a complete installation of apache/php/mysql but now i tried to install them all apart, but now i have the problem that when is try to start mysql i get this error: C:\Apache2\mysql\binmysqld-nt --standalone 030907 14:09:53 Can't find messagefile 'C:\phpdev5\mysql\share\english\errmsg.s ys' 030907 14:09:53 Aborting what can i do about this?
mysqlbug
shell groupadd mysql shell useradd -g mysql mysql shell cd /usr/local shell gunzip /path/to/mysql-VERSION-OS.tar.gz | tar xvf - shell ln -s full-path-to-mysql-VERSION-OS mysql shell cd mysql shell scripts/mysql_install_db shell chown -R root . shell chown -R mysql data I'm getting the error: data directory doesn't exist What is the most likely cause of this? - Jim Gronquist Computer Network and Programming Analyst Office of the Bursar Indiana University 812.856.3026 x6-3026 [EMAIL PROTECTED]
Re: mysqlbug
On Tuesday, September 02, 2003 5:01 PM CET, Gronquist, Jim M wrote: shell groupadd mysql shell useradd -g mysql mysql shell cd /usr/local shell gunzip /path/to/mysql-VERSION-OS.tar.gz | tar xvf - shell ln -s full-path-to-mysql-VERSION-OS mysql shell cd mysql shell scripts/mysql_install_db shell chown -R root . shell chown -R mysql data I'm getting the error: data directory doesn't exist What is the most likely cause of this? This looks like a MySQL installation... right? Well, you already said what the cause is ;) Then they might just have forgotten to create the directory in the tar.gz file. Try to create it on your own by mkdir data just before the chown -R mysql datd This should help. -- Yves Goergen [EMAIL PROTECTED] Please don't CC me (causes double mails) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqlbug
On Tuesday, September 02, 2003 7:20 PM CET, Gronquist, Jim M wrote: Yves, Thanks so much! Yes, I was able to create the data directory and get farther along. Now, when I try and start cd ~ /etc/rc.d/rc3.d/S90mysql start starting mysql daemon with db from /usr/local/mysql/var 030902 11:02 mysql d ended Any ideas? Jim Ehm, sorry no. But I forwarded this question to the mysql list again... ;) PS: you can use the 'reply to all' function of your mailer next time. -- Yves Goergen [EMAIL PROTECTED] Please don't CC me (causes double mails) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqlbug
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote: I have uninstall and reinstall mysql 2 to 3 three times at my home. I am trying to create a database by doing some inserts but it will not let me. It is just blank. I would really like to know what I am doing wrong or do I just need to remove all the components and start over again? I do not know what the problem is and I need help. Please, describe what exactly did you do. You can find examples how to create database, tables at: http://www.mysql.com/doc/en/Database_use.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqlbug
I have uninstall and reinstall mysql 2 to 3 three times at my home. I am trying to create a database by doing some inserts but it will not let me. It is just blank. I would really like to know what I am doing wrong or do I just need to remove all the components and start over again? I do not know what the problem is and I need help. Tammy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqlbug
Hi, I am a Sun solaris 5.6 user. I do not have su or any other system permissions We have PERL5.005 on the box We do not have DBD::mysql So I wanted to install that module into my private library. Mysql server is on a remote unix box So when I try to install the DBD::mysql module its looking for client and development file of the mysql. Please tell which is the best way to get these files.Also let me know if I am missing something. I tried to download mysql source and run the configure -server option...but running into permissions problems. If I can download those files from anywhere,please let me where I cant get them. Thanks, Santosh
Re: output from mysqlbug
amg [EMAIL PROTECTED] wrote: Description: In the Tutorial, section 3.3.3, the command: mysql LOAD DATA LOCAL INFILE pet.txt INTO TABLE pet; generates the following error msg: ERROR 1148: The used command is not allowed with this MySQL version How-To-Repeat: You can find answer on your question in the following section of the MySQL manual: http://www.mysql.com/doc/en/LOAD_DATA_LOCAL.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
output from mysqlbug
SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). SEND-PR: From: amg To: [EMAIL PROTECTED] Subject: [Command in the Tutorial generates error msg] Description: In the Tutorial, section 3.3.3, the command: mysql LOAD DATA LOCAL INFILE pet.txt INTO TABLE pet; generates the following error msg: ERROR 1148: The used command is not allowed with this MySQL version How-To-Repeat: Just run the above command again Fix: Unknown - your job Submitter-Id: [EMAIL PROTECTED] Originator: Organization: Professional Programmer MySQL support: [none] Synopsis: Command in the Tutorial Fails Severity: Serious pain in the ass - my company was looking at using MySQL for production Priority: medium Category: mysql Class: doc-bug Release: mysql-3.23.56 (Source distribution) Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.56, for slackware-linux 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.56-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/run/mysql/mysql.sock Uptime: 2 hours 58 min 35 sec Threads: 1 Questions: 38 Slow queries: 0 Opens: 14 Flush tables: 1 Open tables: 2 Queries per second avg: 0.004 Environment: machine, os, target, libraries (multiple lines) System: Linux UrsaPro 2.4.20 #4 Mon Mar 17 22:08:41 PST 2003 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-slackware-linux/3.2.2/specs Configured with: ../gcc-3.2.2/configure --prefix=/usr --enable-shared --enable-threads=posix --enable-__cxa_atexit --disable-checking --with-gnu-ld --verbose --target=i386-slackware-linux --host=i386-slackware-linux Thread model: posix gcc version 3.2.2 Compilation info: CC='i386-slackware-linux-gcc' CFLAGS='-O3 -march=i486 -mcpu=i686' CXX='gcc' CXXFLAGS='-O3 -march=i486 -mcpu=i686 -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Apr 27 14:44 /lib/libc.so.6 - libc-2.3.1.so -rwxr-xr-x1 root root 1435624 Mar 5 00:57 /lib/libc-2.3.1.so -rw-r--r--1 root root 2425490 Mar 5 00:57 /usr/lib/libc.a -rw-r--r--1 root root 178 Mar 5 00:50 /usr/lib/libc.so Configure command: ./configure '--prefix=/usr' '--with-mysqld-user=mysql' '--with-unix-socket-path=/var/run/mysql/mysql.sock' '--localstatedir=/var/lib/mysql' '--enable-assembler' '--with-raid' '--without-debug' '--without-readline' '--enable-thread-safe-client' '--without-bench' '--with-extra-charsets=complex' '--program-prefix=' '--program-suffix=' 'i386-slackware-linux' 'CFLAGS=-O3 -march=i486 -mcpu=i686' 'CXXFLAGS=-O3 -march=i486 -mcpu=i686 -felide-constructors -fno-exceptions -fno-rtti' 'CXX=gcc' 'build_alias=i386-slackware-linux' 'host_alias=i386-slackware-linux' 'target_alias=i386-slackware-linux' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqlbug
Joanne Yow [bizfront] wrote: Hi, I am trying to install MySQL 3.23 to Solaris 2.8. After the step - scripts/mysql_install_db I try the command - chown -R root, error show usage: chown [-fhR] owner[:group] file... You entered the command incorrectly. You gave it no files or directories to change. Why would you change the ownership to root? and the command - chrgrp -R mysql, error show chgrp [-fhR] group file... Do i need to groupadd for the root? Same problems here. What problems will cause by this? Thanks in advance. Regards, Joe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqlbug
Joanne Yow [bizfront] schrieb: I am trying to install MySQL 3.23 to Solaris 2.8. After the step - scripts/mysql_install_db I try the command - chown -R root, error show usage: chown [-fhR] owner[:group] file... and the command - chrgrp -R mysql, error show chgrp [-fhR] group file... $ man chown $ man chgrp you would do something like this ? # chown -R mysql:mysql /path/to/your/file_or_directory oops, file:///usr/share/doc/mysql-3.23.56/manual.html shell groupadd mysql shell useradd -g mysql mysql shell cd /usr/local shell gunzip /path/to/mysql-VERSION-OS.tar.gz | tar xvf - shell ln -s full-path-to-mysql-VERSION-OS mysql shell cd mysql shell scripts/mysql_install_db shell chown -R root . shell chown -R mysql data shell chgrp -R mysql . shell bin/safe_mysqld --user=mysql or shell bin/mysqld_safe --user=mysql if you are running MySQL 4.x -- shrek-m -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqlbug : problem while installing mysql
I've heard a lot of cases where upgrading a windows 98 machine to windows 2000 will cause problems later on. This may be the case with your system. The only thing I can say is try using that same downloaded executable on a friend's machine and see if it works there. If not, theproblem is with your computers. Operating system upgrades aren't very reliable. - Steve REVATI ASHUTOSH wrote: Hi, I am Revati, graduate student from University of Texas at Dallas. I want to use mysql for learning puopose, so I have downloaded mysql-3.23.55-win.zip file. While I unziping it using winzip, it gives meaage of INSTALL NOW. After I click install it gives me following error: The NTVDM CPU has encountered an illegal instruction. Chose CLOSE to terminate the application. Plase help me to install mysql on my windows 2k pc. About the Pc operating system, I had windows 98, but I upgrated it to windoes 2k. Thanks. = Revati Ingale Ashutosh Joharapurkar 1245 Lakeside Drive #1009 Sunnyvale, CA 94085 Phone Number: 408 245 1904 __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.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
mysqlbug : problem while installing mysql
Hi, I am Revati, graduate student from University of Texas at Dallas. I want to use mysql for learning puopose, so I have downloaded mysql-3.23.55-win.zip file. While I unziping it using winzip, it gives meaage of INSTALL NOW. After I click install it gives me following error: The NTVDM CPU has encountered an illegal instruction. Chose CLOSE to terminate the application. Plase help me to install mysql on my windows 2k pc. About the Pc operating system, I had windows 98, but I upgrated it to windoes 2k. Thanks. = Revati Ingale Ashutosh Joharapurkar 1245 Lakeside Drive #1009 Sunnyvale, CA 94085 Phone Number: 408 245 1904 __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.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: mysqlbug
Hi Ing. Conti You need to install the Dynamic loading compatibility library http://www.opendarwin.org/projects/dlcompat I would recommend that you install fink (http://fink.sf.net). Then all you need to do is fink install mysql which automatically installs the dlcompat and compiles mysql. If you want to compile it yourself you could still use fink install dlcompat dlcompat-dev to install dlcompat (which includes dlfcn.h) Hope this helps, Chris. On Samstag, Januar 4, 2003, at 06:11 Uhr, ing.conti wrote: platform. OSX 10.2 ( jaguar) when I try to compile the source distro, i get: sql_udf.cc:57:19: dlfcn.h: No such file or directory sql_udf.cc: In function `void init_syms(udf_func*)': sql_udf.cc:88: `dlsym' undeclared (first use this function) sql_udf.cc:88: (Each undeclared identifier is reported only once for each function it appears in.) sql_udf.cc: In function `void udf_init()': sql_udf.cc:182: `dlopen' undeclared (first use this function) sql_udf.cc:185: `dlerror' undeclared (first use this function) sql_udf.cc:198: `dlclose' undeclared (first use this function) make[4]: *** [sql_udf.o] Error 1 make[3]: *** [all-recursive] Error 1 make[2]: *** [all] Error 2 make[1]: *** [all-recursive] Error 1 make: *** [all] Error 2 and make stops ANY IDEA? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlbug
platform. OSX 10.2 ( jaguar) when I try to compile the source distro, i get: sql_udf.cc:57:19: dlfcn.h: No such file or directory sql_udf.cc: In function `void init_syms(udf_func*)': sql_udf.cc:88: `dlsym' undeclared (first use this function) sql_udf.cc:88: (Each undeclared identifier is reported only once for each function it appears in.) sql_udf.cc: In function `void udf_init()': sql_udf.cc:182: `dlopen' undeclared (first use this function) sql_udf.cc:185: `dlerror' undeclared (first use this function) sql_udf.cc:198: `dlclose' undeclared (first use this function) make[4]: *** [sql_udf.o] Error 1 make[3]: *** [all-recursive] Error 1 make[2]: *** [all] Error 2 make[1]: *** [all-recursive] Error 1 make: *** [all] Error 2 and make stops ANY IDEA? Ing. Conti via s. Gottardo 76 20052 MONZA MI ITALY 0039-39-324723 www.ingconti.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
mysqlbug
Hello, i install binary version of the mysql . i skipped first 2 stage while installing (that is creating user group) and directly run binary script file. when i run this command, i got following error. mysql -u root mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111). How to solve this error. or how to unstall binary version . so that i can reinstall rpm version. thanks amit _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqlbug
On Tuesday 10 December 2002 12:02, amit parikh wrote: i install binary version of the mysql . i skipped first 2 stage while installing (that is creating user group) and directly run binary script file. when i run this command, i got following error. mysql -u root mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111). How to solve this error. Is MySQL server running? Check it with ps ax | grep mysqld -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
User Install Bug (Was: mysqlbug)
From: amit parikh [EMAIL PROTECTED] i install binary version of the mysql . i skipped first 2 stage while installing (that is creating user group) and directly run binary script file. when i run this command, i got following error. mysql -u root mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111). How to solve this error. Uhm, re-install without skipping any steps? -- : Jan Steinman -- nature Transography(TM): http://www.Bytesmiths.com : Bytesmiths -- artists' services: http://www.Bytesmiths.com/Services : Buy My Step Van! http://www.Bytesmiths.com/van - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
'mysqlbug
Dear Sir, I am very new to the mySQL product. I am trying to do some RD on the possibility to port the MS SQL to mySQL for our system. I have tried with mysql-3.23.53-win. I able to start the mySQL and run the mysqlshow command and others. However, if I try with the mysql-max-4.0.4-beta-win, I started the mysql using mysqld -standalone. When I try to execute the mysqlshow command, there is no respond from the dos prompt. And then my PC become very slow in responding. Please help. Thank you very much. Regards, Kee Lang - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 'mysqlbug
At 18:06 14/11/2002 +0800, Wong, Kee Lang wrote: Hi, Sorry but I wasn't be able for to repeat the behavior reported: Microsoft Windows 2000 [Versão 5.00.2195] (C) Copyright 1985-1999 Microsoft Corp. D:\c:\mysql\bin\mysqld --standalone Microsoft Windows 2000 [Versão 5.00.2195] (C) Copyright 1985-1999 Microsoft Corp. D:\c:\mysql\bin\mysql --version c:\mysql\bin\mysql Ver 12.14 Distrib 4.0.4-beta, for Win95/Win98 (i32) D:\c:\mysql\bin\mysqlshow +---+ | Databases | +---+ | mysql | | test | +---+ It is worked fine to me. Dear Sir, I am very new to the mySQL product. I am trying to do some RD on the possibility to port the MS SQL to mySQL for our system. I have tried with mysql-3.23.53-win. I able to start the mySQL and run the mysqlshow command and others. However, if I try with the mysql-max-4.0.4-beta-win, I started the mysql using mysqld -standalone. When I try to execute the mysqlshow command, there is no respond from the dos prompt. And then my PC become very slow in responding. Please help. Thank you very much. Regards, Kee Lang - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ São Paulo - Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlbug
After i install the Redhat 7.3 and mysql i cannot connect to the mysql server , it shutdown automatically [root@localhost root]/usr/bin/safe_install [1]2023 [root@localhost root]Starting mysql daemon with databases from /var/lib/mysql 020923 00:36:23 mysqld ended [1]+ Done /usr/bin/safe_install [root@localhost root}# mysql -u root mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'(111) _ 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: mysqlbug
Hey there, That means that the MySQL server is unable to find the mysql socket. Check your error log for more info. Stuart --- Perlboy.org - Professional Perl Programming Services Carpet-Head.com - Sally's Blog -Original Message- From: Winnie Kwok [mailto:[EMAIL PROTECTED]] Sent: Monday, 23 September 2002 2:38 AM To: [EMAIL PROTECTED] Subject: mysqlbug After i install the Redhat 7.3 and mysql i cannot connect to the mysql server , it shutdown automatically [root@localhost root]/usr/bin/safe_install [1]2023 [root@localhost root]Starting mysql daemon with databases from /var/lib/mysql 020923 00:36:23 mysqld ended [1]+ Done /usr/bin/safe_install [root@localhost root}# mysql -u root mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'(111) _ 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqlbug
Hi Winnie, You can run rpm -qa |grep -i mysql to see exactly what the installed packages are named. Then you should be able to uninstall (rpm -e) these packages. On the other hand, there could be some package dependencies, which means, that some other software installed will not run without the RedHat MySQL RPMs... Regards, Michael - Original Message - From: Winnie Kwok [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 17, 2002 4:33 PM Subject: mysqlbug first of all , thanks for your help, i cannot install mysql yet as run: rpm -e MySQL;rpm -e MySQL-server error:package MySQL is not installed error:package MySQL-server is not installed From: Michael Paesold [EMAIL PROTECTED] To: Winnie Kwok [EMAIL PROTECTED] Subject: Re: mysqlbug Date: Mon, 16 Sep 2002 20:06:41 +0200 Winnie Kwok wrote: using REDHAT 7.3 After run [root@localhost root]#cd /usr/local/ [root@localhost local]#rpm -i MySQL-3.23.52-1.i386.rpm MySQL-client-3.23.52-1.i386.rpm error:failed dependencies: MySQL conflicts with -3.23.49-3 MySQL-server conflicts with MySQL-server-3.23.49-3 This is not a bug. You have already installed MySQL RPM's provided by RedHat on your server. You have to remove those first before you can install the RPM's from www.mysql.com. rpm -e MySQL; rpm -e MySQL-server There could be some dependencies, though. Regards, Michael _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlbug
after install mysql [root@localhost mysql]./scripts/mysql_install_db bash:./scripts/mysql_install_db:no such file or directory Is the files not install ? _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqlbug
Hello, Check your working directory (type pwd) and check if the scripts directory exists at all (type ls). What version did you install and on what operating system? Was it a binary or a source release? Regards, Iikka On Tue, 17 Sep 2002, Winnie Kwok wrote: after install mysql [root@localhost mysql]./scripts/mysql_install_db bash:./scripts/mysql_install_db:no such file or directory Is the files not install ? _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqlbug
At 16:45 + 9/17/02, Winnie Kwok wrote: after install mysql [root@localhost mysql]./scripts/mysql_install_db bash:./scripts/mysql_install_db:no such file or directory Is the files not install ? If you installed a binary distribution, look in the bin directory where mysql and the other client programs are installed. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlbug
SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). SEND-PR: From: bug To: [EMAIL PROTECTED] Subject: [50 character or so descriptive subject here (for reference)] Description: when configuring the problem is that configure cant find some libs: libstdc++.so.3. libstdc++.so.2 exits What can I do? precise description of the problem (multiple lines) How-To-Repeat: ./configure -with-mit-threads Creating db table Creating host table Creating user table Creating func table Creating tables_priv table Creating columns_priv table Installation of grant tables failed! /usr/libexec/ld-elf.so.1: Shared object libc_r.so.4 not found Examine the logs in ./data for more information. You can also try to start the mysqld demon with: ./bin/mysqld --skip-grant You can use the command line tool ./bin/mysql to connect to the mysql database and look at the grant tables: shell ./bin/mysql -u root mysql mysql show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in ./data that may be helpful. The latest information about MySQL is available on the web at code/input/activities to reproduce the problem (multiple lines) Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: submitter ID Originator:Engeniy V.Lyapin Organization: Albumin organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-3.22.32 (Source distribution) Environment: machine, os, target, libraries (multiple lines) System: FreeBSD andreyco 3.3-RELEASE FreeBSD 3.3-RELEASE #0: Thu Sep 16 23:40:35 GMT 1999 [EMAIL PROTECTED]:/usr/src/sys/compile/GENERIC i386 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: gcc version 2.7.2.3 Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock --wi th-low-memory --with-mit-threads=yes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlbug
I purchased a book entitled PHP3 programming browser-based Applications it came with a cd that contained a copy of MySql-3.22.16a-gamma for any linux distribution. Anyhow, I am having problems installing the software on my SuSe 7.1 linux box. Basically, there are eleven steps that the author david medinets requires in order to properly install the software, but of those eleven, I am having problems with step 8. From root directory linux: ~ # - 1 cd /usr/local/src/mysql-3.22.16a-gamma 2 ./configure --prefix=/usr/local/mysql 3 make 4 make install 5 echo /usr/local/mysql/lib/mysql /etc/ld.so.conf 6 ldconfig -v | grep libmysqlclient 7 echo /usr/local/mysql/bin/safe_mysqld /dev/null /etc/rc.d/rc.local 8 ./scripts/mysql_install_db 9 /usr/local/mysql/bin/safe_mysqld /dev/null 10 ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql 11 ln -s /usr/local/mysql/bin/mysql /usr/bin/mysqlshow after this, the author gives you a sample code to test the database. _ step 8 after entering this at the prompt: linux: usr/local/src/mysql-3.22.16a-gamma # ./scripts/mysql_install_db an error message ( did'nt find /usr/local/mysql/libexec/mysql ) ( You should do a make install before executing this script ) I tryed to run the sample code with out this being installed correctly, but no luck. I would really like any help from anyone on solving this problem. As far as libexec not be found, well there is a lib directory with a subdirectory of mysql. Why its looking for libexec? Well, I simply don't know. Thanks [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: mysqlbug
On Thu, 2002-03-14 at 00:04, [EMAIL PROTECTED] wrote: Please, i'll need some help. I've installed mysql-3.22.32 in my machine, and when i run (from /usr/local/mysql) ./bin/safe_mysqld this is the bug that present (from my *.err file) /*/ mysqld started on Mon Mar 4 15:44:29 PST 2002 /usr/local/mysql/libexec/mysqld: ready for connections mysqld started on Mon Mar 4 15:52:32 PST 2002 /usr/local/mysql/libexec/mysqld: Can't change dir to '/usr/local/mysql/data/' (Errcode: 2) 020304 15:52:33 Aborting /***/ What is wrong??? Use the command perror to see what an error means: localhost:~# perror 2 Error code 2: No such file or directory mysqld is trying to change into your datadir /usr/local/mysql/data, which does not exists, so it fails. Try to create it (and give the proper ownership and permissions to your mysql user). -- dsoares (sql) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlbug
Good afternoon Please, i'll need some help. I've installed mysql-3.22.32 in my machine, and when i run (from /usr/local/mysql) ./bin/safe_mysqld this is the bug that present (from my *.err file) /*/ mysqld started on Mon Mar 4 15:44:29 PST 2002 /usr/local/mysql/libexec/mysqld: ready for connections mysqld started on Mon Mar 4 15:52:32 PST 2002 /usr/local/mysql/libexec/mysqld: Can't change dir to '/usr/local/mysql/data/' (Errcode: 2) 020304 15:52:33 Aborting /***/ What is wrong??? Thank's Sincerely Ricardo Castro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqlbug
error 2 says the file cannot be found...did you run the mysql_install_db script? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 7:05 PM To: [EMAIL PROTECTED] Subject: mysqlbug Good afternoon Please, i'll need some help. I've installed mysql-3.22.32 in my machine, and when i run (from /usr/local/mysql) ./bin/safe_mysqld this is the bug that present (from my *.err file) /* / mysqld started on Mon Mar 4 15:44:29 PST 2002 /usr/local/mysql/libexec/mysqld: ready for connections mysqld started on Mon Mar 4 15:52:32 PST 2002 /usr/local/mysql/libexec/mysqld: Can't change dir to '/usr/local/mysql/data/' (Errcode: 2) 020304 15:52:33 Aborting /* **/ What is wrong??? Thank's Sincerely Ricardo Castro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqlbug
I might be interested in hiring someone to do some PhP, and MySQL programming on SuSQ 7.3. anyone live near Raleigh North Carolina? I am not sure I can learn what I need in the time frame I need to do it in. Mark - Original Message - From: Gregory Junker [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, March 13, 2002 7:13 PM Subject: RE: mysqlbug error 2 says the file cannot be found...did you run the mysql_install_db script? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 7:05 PM To: [EMAIL PROTECTED] Subject: mysqlbug Good afternoon Please, i'll need some help. I've installed mysql-3.22.32 in my machine, and when i run (from /usr/local/mysql) ./bin/safe_mysqld this is the bug that present (from my *.err file) /* / mysqld started on Mon Mar 4 15:44:29 PST 2002 /usr/local/mysql/libexec/mysqld: ready for connections mysqld started on Mon Mar 4 15:52:32 PST 2002 /usr/local/mysql/libexec/mysqld: Can't change dir to '/usr/local/mysql/data/' (Errcode: 2) 020304 15:52:33 Aborting /* **/ What is wrong??? Thank's Sincerely Ricardo Castro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
mysqlbug - installation problem
New to MySQL. Have got RH Linux 7.2 on Intel-based processor Installed MySql from a mysql-max-3.23.49a-pc-linux-gnu-i686.tar.gz Followed the documentation instructions given in Chapter 2 online at http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Installing_binary I get the following [root@coolnis-ar mysql]# bin/safe_mysqld --user=mysql [1] 2796 [root@coolnis-ar mysql]# Starting mysqld daemon with databases from /var/lib/mysql 020312 14:56:50 mysqld ended [1]+ Donebin/safe_mysqld --user=mysql [root@coolnis-ar mysql]# I do not get any .err file either and the MySQL server doen't start. Please help Thank you Aman _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlbug
Hi everybody! I am a new for MYSQL. I want to install MYSQL on AIX 4.3.2 (UNIX). And I got the following error message. Could someone can help me? Shell set MYSQL = '/adm/ac/listserv/Calendar/mysql' Shell echo $MYSQL /adm/ac/listserv/Calendar/mysql Shell scripts/mysql_install_db Could not load program ./bin/my_print_defaults Could not load library libz.a[shr.o] Error was: No such file or directory WARNING: The host 'skipper' could not be looked up with resolveip. This probably means that your libc libraries are not 100 % compatible with this binary MySQL version. The MySQL deamon, mysqld, should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables Could not load program ./bin/mysqld Could not load library libz.a[shr.o] Error was: No such file or directory Installation of grant tables failed! Examine the logs in ./data for more information. You can also try to start the mysqld daemon with: ./bin/mysqld --skip-grant You can use the command line tool ./bin/mysql to connect to the mysql database and look at the grant tables: shell ./bin/mysql -u root mysql mysql show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in ./data that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com Please consult the MySQL manual section: 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source is the MySQL email archive. Please check all of the above before mailing us! And if you do mail us, you MUST use the ./bin/mysqlbug script! Thanks, - Benmin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlbug
Hi , I downloaded mysql-3.22.32.tar.gz and began installing the source. I installed this on Solaris 2.6. However when I 'make', I came across this problem: -- Making all in support-files make: Fatal error: Don't know how to make target `all' Current working directory /net/mscsvr_f01/vol/vol0/home0/ckng/RDBMS/mysql-3.22.3 2/support-files *** Error code 1 make: Fatal error: Command failed for target `all-recursive' Current working directory /net/mscsvr_f01/vol/vol0/home0/ckng/RDBMS/mysql-3.22.3 2 *** Error code 1 make: Fatal error: Command failed for target `all-recursive-am' -- Could you please advise what needs to be done? Thank you. Regards, Edwin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlbug
rcastro, Wednesday, February 27, 2002, 12:28:01 AM, you wrote: r Hi! r My name is Ricardo Castro and i'm writing for Ensenada, Mexico. My problem r installing MySQL is next: r I've unzipped MySQL (mysql-max-3.23.49-pc-linux-gnu-i686.tar.gz)in /usr/local/; r i've follow all the steps that the INSTALL-BINARY indicates; but i have the r problem that in the moment to want to run mysql, indicates me: r ERROR 2002: Can't connect to local MySQL server through r socket '/tmp/mysql.sock' (111) r I've made r find / -name mysql.sock r And, surprise, there is no file anywhere. mysql.sock is created when mysqld is started. Is your MySQL server running? r When i run the steps, nothing indicates me a mistake or something like that r What is happened???. Check your privileges on the socket file and on the dir that contains socket file. You can find the description of this error at: http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html r Thank's r Ricardo Castro. -- 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
mysqlbug
Hi! My name is Ricardo Castro and i'm writing for Ensenada, Mexico. My problem installing MySQL is next: I've unzipped MySQL (mysql-max-3.23.49-pc-linux-gnu-i686.tar.gz)in /usr/local/; i've follow all the steps that the INSTALL-BINARY indicates; but i have the problem that in the moment to want to run mysql, indicates me: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) I've made find / -name mysql.sock And, surprise, there is no file anywhere. When i run the steps, nothing indicates me a mistake or something like that What is happened???. Thank's Ricardo Castro. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlbug: SIGALRM hangs read() on socket racecondition
Description:
I'm seeing random hung reads() after a mysql insert that appears to be
related to a sig alarm race condition. The basic workflow of this program
is
while (1)
recvfrom() /* few hundred packets a sec */
parse packet
insert into sql
However, once per second a sig alarm is generated which does house keeping
and what-not. This will work for minutes or hours, but eventually the
read(3, ...) blocks , which is the mysql socket. When this occurs you just
see the repeated sig alarms being catch, but immediately returning to that
read() which never returns. Note there is still hundreds of udp packets
coming in but never able to be read because the never-returing read(3,) on
the mysql sock.
Normal syscalls resemble:
write(3, \1\1\0\0\3INSERT INTO call_logging.de..., 261) = 261
read(3, \3\0\0\1, 4) = 4
read(3, \0\1\0, 3)= 3
recvfrom(5, ...) = 398
When the condition occurs:
read(3, 0x814a6b0, 4) = ? ERESTARTSYS (To be restarted)
--- SIGALRM (Alarm clock) ---
time(NULL) = 1014267832
rt_sigaction(SIGALRM, {SIG_IGN}, {0x4002fa10, [ALRM], SA_RESTART|0x400}, 8)
= 0
alarm(1)= 0
rt_sigaction(SIGALRM, {0x4002fa10, [ALRM], SA_RESTART|0x400}, {SIG_IGN}, 8)
= 0
sigreturn() = ? (mask now [])
read(3, 0x814a6b0, 4) = ? ERESTARTSYS (To be restarted)
--- SIGALRM (Alarm clock) ---
time(NULL) = 1014267833
rt_sigaction(SIGALRM, {SIG_IGN}, {0x4002fa10, [ALRM], SA_RESTART|0x400}, 8)
= 0
alarm(1)= 0
rt_sigaction(SIGALRM, {0x4002fa10, [ALRM], SA_RESTART|0x400}, {SIG_IGN}, 8)
= 0
sigreturn() = ? (mask now [])
read(3, 0x814a6b0, 4) = ? ERESTARTSYS (To be restarted)
--- SIGALRM (Alarm clock) ---
Fix:
Have to restart entire program to get it working again.
Submitter-Id: [EMAIL PROTECTED]
MySQL support: none
Synopsis: sig alarm hangs read
Severity: critical
Priority: high
Category: mysql
Class: sw-bug
Release: mysql-3.23.49 (Official MySQL Binary)
Server: /usr/local/mysql/bin/mysqladmin Ver 8.23 Distrib 3.23.49, for pc-linux-gnu
on i686
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.49
Protocol version10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 17 hours 21 min 38 sec
Threads: 2 Questions: 3721598 Slow queries: 2 Opens: 227 Flush tables: 1 Open
tables: 7 Queries per second avg: 59.547
Environment:
System: Linux mmlog2 2.4.9-21smp #1 SMP Thu Jan 17 14:01:48 EST 2002 i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98)
Compilation info: CC='gcc' CFLAGS='-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch
-Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec
-Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro
-O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-Wimplicit -Wreturn-type
-Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat
-Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings
-Woverloaded-virtual -Wextern-inline -Wsign-promo -Wreorder -Wctor-dtor-privacy
-Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -mcpu=pentiumpro -O3
-fno-omit-frame-pointer' LDFLAGS=''
LIBC:
lrwxrwxrwx1 root root 13 Feb 19 06:53 /lib/libc.so.6 - libc-2.2.4.so
-rwxr-xr-x1 root root 1283964 Dec 8 07:14 /lib/libc-2.2.4.so
-rw-r--r--1 root root 27314296 Dec 8 07:02 /usr/lib/libc.a
-rw-r--r--1 root root 178 Dec 8 07:02 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr/local/mysql --enable-assembler
--with-extra-charsets=complex --enable-thread-safe-client
--with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static
--with-other-libc=/usr/local/mysql-glibc '--with-comment=Official MySQL Binary'
--prefix=/usr/local/mysql --with-extra-charset=complex --enable-thread-safe-client
--enable-local-infile 'CFLAGS=-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch
-Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec
-Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro
-O3 -fno-omit-frame-pointer' 'CXXFLAGS=-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch
-Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec
-Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings
mysqlbug
Hai! I tried to install MySQL in my linux box (redhat 7.2) by using the rpm files. Where should the files get after installation. In mine the get to /usr/bin and when i use MySQL with som appliction,i get error message which includes somethings about could not find libmysqlclient.so.6 What is wrong here? best regards Nasser - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlbug
Nasser, Friday, January 18, 2002, 12:26:09 PM, you wrote: NR I tried to install MySQL in my linux box (redhat 7.2) by using the rpm NR files. NR Where should the files get after installation. NR In mine the get to /usr/bin and when i use MySQL with som appliction,i get NR error message which includes somethings about could not find NR libmysqlclient.so.6 NR What is wrong here? Installation from MySQL's rpms should go clear. Are you sure you have installed the MySQL distributive correctly (rpm --install..)? Please tell us more about the problem appeared. About /etc/ld.so.conf, and ls /usr/lib/libmysqlclient* -- Egor Egorov [EMAIL PROTECTED] MySQL AB / Ensita.net For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.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
Upgrade Problem (Mysqlbug)
I am trying to upgrade from mysql server v. 3.22.32 up to v. 3.23.47 on my RedHat6.2 box. When I try rpm -Uhv MySQL. , I get:: Preparing...##[100%] file /usr/bin/mysqlbug from install of MySQL-3.23.47-1 conflicts with file from package MySQL-client-3.22.32-1 I thought maybe the upgrade went ok anyway, so I started the server with mysqld, and connected via my client successfully, but it says I have connected to server 3.22.32. I saw in the docs that the 3.22.32 client should be able to connect to a 3.23.* server just fine. So I have done nothing with my client. I have not located anything in the mail archives with such a problem. Any ideas on how to get around this problem and get the server upgraded? Thanks, Rob Mazur p.s. I actually have this symptom on two RedHat6.2 machines... - Before posting, please check: http://www.mysql.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
mysqlbug
heloo I installed the binary verison of mysql mysql-max-3.23.41-sun-solaris2.8-sparc.tar.gz on solaris box. I could not found libmysqlclient.so file in lib directory Instead i fould libmysqlclient.a file how can get libmysqlclient.so ? srini - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqlbug
On Thu, Sep 06, 2001 at 06:08:00PM +0800, Chun-Hung Chen wrote: When configuring mysql, some errors happened.The report of config.log and error messages are listed below.The environment I use is Sun Solaris 8(SunOS 5.8) with gcc 2.95.3. [snip] configure:2376: checking return type of sprintf == error message: checking return type of sprintf... configure: error: can not run test program while cross compiling Where is GCC installed? Try using LD_LIBRARY_PATH=/usr/local/lib in your environment (or whatever path is appropriate). It fixed it for me on Solaris 2.8 with GCC 2.95.3. There was a thread about 1-2 weeks ago on the mailling list about it. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 1 days, processed 17,353,292 queries (180/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlbug
When configuring mysql, some errors happened.The report of config.log
and error messages are listed below.The environment I use is Sun Solaris
8(SunOS 5.8) with gcc 2.95.3.
config.log:
This file contains any messages produced by compilers while
running configure, to aid debugging if configure makes a mistake.
configure:813: checking host system type
configure:834: checking target system type
configure:852: checking build system type
configure:887: checking for a BSD compatible install
configure:940: checking whether build environment is sane
configure:975: checking whether make sets ${MAKE}
configure:1021: checking for working aclocal
configure:1034: checking for working autoconf
configure:1047: checking for working automake
configure:1060: checking for working autoheader
configure:1073: checking for working makeinfo
configure:1175: checking whether to enable maintainer-specific portions of Makefiles
configure:1217: checking whether build environment is sane
configure:1234: checking whether make sets ${MAKE}
configure:1302: checking for gawk
configure:1302: checking for mawk
configure:1302: checking for nawk
configure:1334: checking for gcc
configure:1447: checking whether the C compiler (gcc ) works
configure:1463: gcc -o conftest conftest.c 15
configure:1489: checking whether the C compiler (gcc ) is a cross-compiler
configure:1494: checking whether we are using GNU C
configure:1503: gcc -E conftest.c
configure:1522: checking whether gcc accepts -g
configure:1558: checking for c++
configure:1590: checking whether the C++ compiler (c++ ) works
configure:1606: c++ -o conftest conftest.C 15
configure:1632: checking whether the C++ compiler (c++ ) is a cross-compiler
configure:1637: checking whether we are using GNU C++
configure:1646: c++ -E conftest.C
configure:1665: checking whether c++ accepts -g
configure:1697: checking how to run the C preprocessor
configure:1718: gcc -E conftest.c /dev/null 2conftest.out
configure:1833: checking for ranlib
configure:1943: checking for ld used by GCC
configure:2005: checking if the linker (/usr/ccs/bin/ld) is GNU ld
configure:2021: checking for BSD-compatible nm
configure:2057: checking whether ln -s works
ltconfig:603: checking for object suffix
ltconfig:604: gcc -cconftest.c 15
ltconfig:629: checking for executable suffix
ltconfig:630: gcc -o conftest conftest.c 15
ltconfig:776: checking if gcc PIC flag -fPIC works
ltconfig:777: gcc -c -fPIC -DPIC conftest.c 15
ltconfig:829: checking if gcc supports -c -o file.o
ltconfig:830: gcc -c -o out/conftest2.o conftest.c 15
ltconfig:862: checking if gcc supports -c -o file.lo
ltconfig:863: gcc -c -c -o conftest.lo conftest.c 15
ltconfig:914: checking if gcc supports -fno-rtti -fno-exceptions
ltconfig:915: gcc -c -fno-rtti -fno-exceptions -c conftest.c conftest.c 15
ltconfig:958: checking if gcc static flag -static works
ltconfig:959: gcc -o conftest -static conftest.c 15
ltconfig:1653: checking if global_symbol_pipe works
ltconfig:1654: gcc -cconftest.c 15
ltconfig:1657: eval /usr/ccs/bin/nm -p conftest.o | sed -n -e 's/^.*[ ]\([BDT]\)[
][ ]*\(\)\([_A-Za-z][_A-Za-z0-9]*\)$/\1
\2\3 \3/p' conftest.nm
ltconfig:1709: gcc -o conftest -fno-builtin -fno-rtti -fno-exceptions conftest.c
conftstm.o 15
configure:2257: checking for a BSD compatible install
configure:2315: checking for bison
configure:2315: checking for byacc
configure:2348: checking for pdftex
configure:2376: checking return type of sprintf
==
error message:
checking return type of sprintf... configure: error: can not run test program while
cross compiling
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlBUG
Dear I did install MySQL on win95 which is simple. But got stuck when installing on SunSolaris (On PentiumII) at shellmake install given page 56 chapter 4 of MySQL manual. Please advise me what to do next. Waiting for your reply. With Best Regards Sohail Aziz Quidwai
MySQLBug - Script mysql_install_db Empty
I am evaluating MySQL on a Solaris8 Intel machine, and followed your instruction for the installation. I used GNU tar to unzip the files into /usr/local/mysql-3.23.39-pc-solaris2.8-i386. There was no error in the tar process of the downloaded file. However, in the /usr/local/mysql-3.23.39-pc-solaris2.8-i386/scripts directory, file mysql_install_db is present, but is ZERO byte. What did I do wrong? Thanks. Steve Wu, Ph.D. Oracle DBA NORDSTROM.com (206) 215-7383 (Phone) (206) 215-7583 (Fax) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MySQLBug - Script mysql_install_db Empty
What about the version of the file which should be in /usr/local/mysql-3.23.39-pc-solaris2.8-i386/bin ?? (which is the one you should be running from the 'mysql' directory as ./bin/mysql_install_db ) - Original Message - From: Wu, Steve [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Sfikas, Ted [EMAIL PROTECTED] Sent: Thursday, July 19, 2001 9:08 AM Subject: MySQLBug - Script mysql_install_db Empty I am evaluating MySQL on a Solaris8 Intel machine, and followed your instruction for the installation. I used GNU tar to unzip the files into /usr/local/mysql-3.23.39-pc-solaris2.8-i386. There was no error in the tar process of the downloaded file. However, in the /usr/local/mysql-3.23.39-pc-solaris2.8-i386/scripts directory, file mysql_install_db is present, but is ZERO byte. What did I do wrong? Thanks. Steve Wu, Ph.D. Oracle DBA NORDSTROM.com (206) 215-7383 (Phone) (206) 215-7583 (Fax) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
mysqlbug
Can not start mysql nor run mysqladmin like: [root@MrTamada data]# more MrTamada.err 010717 23:26:58 mysqld started 010717 23:26:58 /usr/local/mysql-3.23.39-unknown-linux-gnu-sparc/bin/mysqld: Ca n't create/write to file '/usr/local/mysql-3.23.39-unknown-linux-gnu-sparc/data/ MrTamada.pid' (Errcode: 13) 010717 23:26:58 /usr/local/mysql-3.23.39-unknown-linux-gnu-sparc/bin/mysqld: Ca n't find file: './mysql/host.frm' (errno: 13) 010717 23:26:58 /usr/local/mysql-3.23.39-unknown-linux-gnu-sparc/bin/mysqld: Er ror on delete of '/usr/local/mysql-3.23.39-unknown-linux-gnu-sparc/data/MrTamada .pid' (Errcode: 13) 010717 23:26:58 mysqld ended [root@MrTamada bin]# ./mysqladmin version ./mysqladmin: error in loading shared libraries: libmysqlclient.so.10: cannot op en shared object file: No such file or directory __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqlbug
hallo With reference to root on 14.07 20:31: Hello: When attempting to perform rpm installation I get: [root@...]# rpm -i MySQL-3.23.39-1.i386.rpm error: MySQL-3.23.39-1.i386.rpm cannot be installed first try this rpm -qa | grep mysql the original rpms have only lowercases with rpm -hUv you can upgrade the mysql with rpm -e you can uninstall the packages try it with rpm -hiv i hope telling you more error, perhaps missing dependence I am running RedHat 7.0 kernel 2.2.16-22 on an i586 (AMD K6-2 to be exact). Thank you for your assistance. Dylan Doxey [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 -- Gruß bye Michael Ott - - Siemens AG - IS IT PS 51 ERL - - Werner-von-Siemens-Strasse 60 - - 91050 Erlangen- - Tel. +49 91 31 7 42 0 54 - - [EMAIL PROTECTED] - - open-source and you have much fun - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlbug
mysql£¬ÄúºÃ£¡ СµÜÔÚsco openserver5Öа²×°Mysqlʱ£¬³öÏֵĴíÎóÌáʾÈçÏ£º scripts/mysql_install_db: 11738 Killed scripts/mysql_install_db: 11739 Killed WARNING: Your libc libraries are not 100 % compatible with this MySQL version mysqld should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! Creating db table Creating host table Creating user table Creating func table Creating tables_priv table Creating columns_priv table dynamic linker : ./bin/mysqld : error opening libz.so scripts/mysql_install_db: 11740 Killed Installation of grant tables failed! ¸ÃÈçºÎ´¦Àí£¿ ÇëÇó¸ßÊÖÔ®Öú£¬²»Ê¤¸Ð¼¤£¡ Ö Àñ£¡ xg [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
mysqlbug
Hello: When attempting to perform rpm installation I get: [root@...]# rpm -i MySQL-3.23.39-1.i386.rpm error: MySQL-3.23.39-1.i386.rpm cannot be installed I am running RedHat 7.0 kernel 2.2.16-22 on an i586 (AMD K6-2 to be exact). Thank you for your assistance. Dylan Doxey [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
mysqlbug
I am trying to install MYSQL 3.23.38 on an SGI machine running IRIX 6.5 I can gunzip the tar.gz file and tar it aswell, however then when I run the scripts/mysql_install_db it fails saying ' ./bin/mysqld: Program not supported by architecture Installation of grant tables failed! I therefore am stuck and cant install the software, it is the verision specifically for IRIX aswell ?? Please Help Regards Simon === Domain Name Registration At The Right Price - www.domaindomain.co.uk === === Before making any enquiries please refer to our 'frequently asked questions' If you need to reply to this message please do so enclosing any past correspondence, your username and domain name. === The information contained in this email is confidential and intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. Knightmaster Enterprises Uk Ltd will accept no responsibility or liability in respect to this email other than to the addressee.
mysqlbug
Hi! My name is Cathy and I have a problem after installing MySQL. I cannot get connection to the localhost. Whenever I type mysqld I get this message: C:\mysql\binmysqld Can't initialize InnoDB as 'innodb_data_file_path' is not set. I'm using Microsoft Windows 98 and the version of MySQL is 3.23. I hope you can help as soon as possible. Thank you. Regards, Cathy
Re: mysqlbug
At 13:53 24/5/2001 +0200, Catherine Vi Clausen wrote: Hi! The mysqld.exe was compiled with an instruction for NT/Win2k platforms. Then instead of it, use mysqld-opt.exe or mysqld-max.exe for to have support for tables BDB and InnoDB. If you want to use mysqld-max.exe, read the instructions about the my.ini/my.cnf file sets for InnoDB tables. In the next release the mysqld.exe will work on Win9x OS too. Regards, Miguel Hi! My name is Cathy and I have a problem after installing MySQL. I cannot get connection to the localhost. Whenever I type mysqld I get this message: C:\mysql\binmysqld Can't initialize InnoDB as 'innodb_data_file_path' is not set. I'm using Microsoft Windows 98 and the version of MySQL is 3.23. I hope you can help as soon as possible. Thank you. Regards, Cathy __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solórzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ São Paulo, Brazil ___/ Development Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqlbug
At 1:53 PM +0200 5/24/01, Catherine Vi Clausen wrote: Hi! My name is Cathy and I have a problem after installing MySQL. I cannot get connection to the localhost. Whenever I type mysqld I get this message: C:\mysql\binmysqld Can't initialize InnoDB as 'innodb_data_file_path' is not set. I'm using Microsoft Windows 98 and the version of MySQL is 3.23. I hope you can help as soon as possible. Thank you. http://www.mysql.com/doc/W/i/Windows_installation.html says this: NOTE: If you want to use InnoDB tables, there are certain startup options that must be specified in your `my.ini' file! See section 8.7.2 InnoDB startup options. http://www.mysql.com/doc/I/n/InnoDB_start.html (section 8.7.2) discusses some options you should try, to make the message you're seeing go away. Regards, Cathy -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlbug report
Hi.. I'm from seoul,korea. Now i'm trying to install mysql 3.23.38 through source install. I'm using Redhat 7.1 with 128M memory,Intel Pentium III 500. I'm trying like this.. ./configure --prefix=/usr/local/mysql --with-charset=euc_kr make so far there is no problems. but when i try like 'make install',i got this error message and Installation is stopped. ... /usr/bin/install -c copy-db /usr/local/mysql/sql-bench/copy-db /usr/bin/install: `copy-db' and `/usr/local/mysql/sql-bench/copy-db' are the same file make[2]: *** [install-benchSCRIPTS] error1 make[2]: exit `/usr/local/mysql/sql-bench' directory make[1]: *** [install-am] error 2 make[1]: exit `/usr/local/mysql/sql-bench' directory make: *** [install-recursive] error 1 [root@chris mysql]# --- RPM installation is successful but source installation failed like above. Can you give me some help? Thanks in advance. from chang - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlbug
on linux what user do u instal mysql with ? root or a normal user ? Regards Khuram Khan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlbug
i typed this when installing binary version of mysql .. chown -R mysql /usr/local/mysql/var i get error message --- no such file or directory ! whats wrong ? Regards Khuram Khan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqlbug
Maybe the is no such file or directory. Or maybe you are not root when you execute the command. Did you check that the directory exists? Maybe this binary version puts it somewhere else. try : find / -name mysql -print and see where it might be installed. [EMAIL PROTECTED] wrote: i typed this when installing binary version of mysql .. chown -R mysql /usr/local/mysql/var i get error message --- no such file or directory ! whats wrong ? Regards Khuram Khan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqlbug
hi i downloaded Linux (Intel libc6 systems) [pc-linux-gnu-i686] i have uncompressed it and untarred it onto a PC. but i cannot find the necessary make and make install files to compile and run sql ! why is that ? machine i am running on is P166, 64mb ram using red hat linux 7. thanks i hope you can help ! Regards Khuram Khan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqlbug
That is a binary tarball. If you want to compile it, download the source. [EMAIL PROTECTED] wrote: hi i downloaded Linux (Intel libc6 systems) [pc-linux-gnu-i686] i have uncompressed it and untarred it onto a PC. but i cannot find the necessary make and make install files to compile and run sql ! why is that ? machine i am running on is P166, 64mb ram using red hat linux 7. thanks i hope you can help ! Regards Khuram Khan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqlbug
#--That is a binary tarball. #--If you want to compile it, download the source. What you mean with tarball? Its supposed just to uncompress it and it should work?
RE: mysqlbug
it seems to be working after i type safe_mysqld --log but i get this message when i try to run mysql , i try creating a database using mysqladmin but the same socket thing comes into it ! my error message mysql admin connection to localhost failed error can't connect to local mysql server through socket /var/lib/mysql/mysql.sock (111) check that mysqld is running and the socket /var/lib/mysql/mysql.sock exists ! ok everythings is running ! but why do i get this when i try and run 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: RE: mysqlbug
hello RE: Linux (Intel libc6 systems) [pc-linux-gnu-i686] downloaded the above file. nad am trying to get it going ! i have read the readme files but not much help there ! uncompressed it and untarred the sql ! what is it i do next ! please if it is not too much help how do i get it going ! have had loads of problems with this (first time using this you see ) thanks much 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
Fw: mysqlbug Adding an index to a HEAP table breaks WHERE col LIKE 502-%
Tried to post this to mailing.database.mysql, but earthlink's news servers suck, and it seems the message got dropped. Bleh. Anyway..: Jeff S Wheeler [EMAIL PROTECTED] wrote in message news:... Below is a filled-out mysqlbug form. Indexes on HEAP tables are ignored in numerous queries in which I think they should be utilized, but this is the first I've noticed where mysql actually _does_ use the index, and as a result it produces wrong query results. Description: Adding an index to a HEAP table breaks WHERE col LIKE "502-%" How-To-Repeat: mysql SELECT COUNT(*) FROM t4 WHERE BillN LIKE "502-%"\G *** 1. row *** COUNT(*): 4378 1 row in set (0.03 sec) mysql CREATE INDEX BillN ON t4 (BillN); Query OK, 42854 rows affected (0.15 sec) mysql SELECT COUNT(*) FROM t4 WHERE BillN LIKE "502-%"\G *** 1. row *** COUNT(*): 0 1 row in set (0.00 sec) Fix: Do not use indexes on HEAP tables. Of course, I really would like to be able to use them, as I have a nasty LEFT JOIN that would be really fast in comparison, if it wouldn't improperly return zero rows. Submitter-Id: Originator: Jeff S Wheeler [EMAIL PROTECTED] Organization: Five Elements, Inc. MySQL support: none Synopsis: Indexes break some queries on HEAP tables Severity: serious Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.33-pc-linux-gnu-i686 (Binary distribution) Environment: System: Linux neptune 2.4.2 #2 SMP Tue Mar 13 22:15:19 EST 2001 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='-O2 -fomit-frame-pointer' CXX='g++' CXXFLAGS='-O2 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno -rtti' LDFLAGS='' Configure command: ./configure --enable-shared --without-readline --enable-assembler --with-my sqld-user=mysql --with-unix-socket-path=/var/run/mysqld/mysqld.sock --prefix =/usr --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc/mysql --da tadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/share/info -- includedir=/usr/include --mandir=/usr/share/man 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: Fw: mysqlbug Adding an index to a HEAP table breaks WHERE col LIKE 502-%
Jeff S Wheeler writes:
Tried to post this to mailing.database.mysql, but earthlink's news servers
suck, and it seems the message got dropped. Bleh. Anyway..:
Jeff S Wheeler [EMAIL PROTECTED] wrote in message news:...
Below is a filled-out mysqlbug form. Indexes on HEAP tables are ignored in
numerous queries in which I think they should be utilized, but this is the
first I've noticed where mysql actually _does_ use the index, and as a
result it produces wrong query results.
Description:
Adding an index to a HEAP table breaks WHERE col LIKE "502-%"
How-To-Repeat:
mysql SELECT COUNT(*) FROM t4 WHERE BillN LIKE "502-%"\G
*** 1. row ***
COUNT(*): 4378
1 row in set (0.03 sec)
mysql CREATE INDEX BillN ON t4 (BillN);
Query OK, 42854 rows affected (0.15 sec)
mysql SELECT COUNT(*) FROM t4 WHERE BillN LIKE "502-%"\G
*** 1. row ***
COUNT(*): 0
1 row in set (0.00 sec)
Fix:
Do not use indexes on HEAP tables. Of course, I really would like to
be able to use them, as I have a nasty LEFT JOIN that would be really
fast in comparison, if it wouldn't improperly return zero rows.
Submitter-Id:
Originator: Jeff S Wheeler [EMAIL PROTECTED]
Organization: Five Elements, Inc.
MySQL support: none
Synopsis: Indexes break some queries on HEAP tables
Severity: serious
Priority: low
Category: mysql
Class: sw-bug
Release: mysql-3.23.33-pc-linux-gnu-i686 (Binary distribution)
Environment:
System: Linux neptune 2.4.2 #2 SMP Tue Mar 13 22:15:19 EST 2001 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='-O2 -fomit-frame-pointer' CXX='g++'
CXXFLAGS='-O2 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno
-rtti' LDFLAGS=''
Configure command:
./configure --enable-shared --without-readline --enable-assembler --with-my
sqld-user=mysql --with-unix-socket-path=/var/run/mysqld/mysqld.sock --prefix
=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc/mysql --da
tadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/share/info --
includedir=/usr/include --mandir=/usr/share/man
Perl: This is perl, version 5.005_03 built for i386-linux
Hi!
Our manual specifies very clearly that indices in HEAP tables can be
used only for = and !=.
Therefore, for the case like above, you are better without it.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlbug CREATE TEMPORARY TABLE ... TYPE=MERGE ...; fails
You cannot create a temporary table as TYPE=MERGE. I have tried it using both a temporary and a "normal" on-disk table in the UNION paramater without success. This might be useful to, say, the guy who posted thread "Tuple length Question" earlier today...:) I'm sure you can duplicate this on any platform so I'm not going to bother with actual mysqlbug output unless a MySQL A.B. person wishes me to do so. This could easily end up being a documentation bug, with the fix to document that it is not possible to create temporary merge tables. :) --- Jeff S Wheeler [EMAIL PROTECTED] Software DevelopmentFive Elements, Inc http://www.five-elements.com/~jsw/ mysql CREATE TABLE language_en (id INT NOT NULL); Query OK, 0 rows affected (0.04 sec) mysql CREATE TEMPORARY TABLE language (id INT NOT NULL) TYPE=MERGE UNION=(language_en); ERROR 1017: Can't find file: '#sql3f8_1_0.MRG' (errno: 2) mysql CREATE TABLE language (id INT NOT NULL) TYPE=MERGE UNION=(language_en); Query OK, 0 rows affected (0.00 sec) mysql DROP TABLE language; Query OK, 0 rows affected (0.01 sec) mysql DROP TABLE language_en; Query OK, 0 rows affected (0.00 sec) mysql CREATE TEMPORARY TABLE language_en (id INT NOT NULL); Query OK, 0 rows affected (0.00 sec) mysql CREATE TEMPORARY TABLE language (id INT NOT NULL) TYPE=MERGE UNION=(language_en); ERROR 1017: Can't find file: '#sql3f8_1_2.MRG' (errno: 2) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlbug may pick the wrong complier
Description: The code that checks for cc may pick the "first" cc it finds in its path, which may not be the same cc used for compling, eg it may choose /usr/bin/gcc over /usr/local/bin/gcc How-To-Repeat: Look in the code for mysqlbug Fix: Ah this depends on finding the complier used for compling, maybe a makefile addition to add the path / CC used. Submitter-Id: submitter ID Originator:root (aka greg) Organization: Never ! MySQL support: [none ] Synopsis: mysqlbug may pick the wrong complier Severity: Priority: Category: mysql Class: Release: mysql-3.23.34a (Source distribution) Server: /usr/local/mysql/bin/mysqladmin Ver 8.18 Distrib 3.23.34a, for pc-linux-gnu on i686 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.34a-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 9 min 46 sec Threads: 2 Questions: 9 Slow queries: 0 Opens: 7 Flush tables: 1 Open tables: 1 Queries per second avg: 0.015 Environment: System: Linux duck.webarmadillo.com 2.4.2-ac18 #1 Sun Mar 11 21:09:43 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/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) ^^ This is wrong for my system. I actually used: Reading specs from /usr/local/lib/gcc-lib/i686-pc-linux-gnu/pgcc-2.95.2.1/specs gcc version pgcc-2.95.2.1 20001224 (release) Compilation info: CC='/usr/local/bin/gcc' CFLAGS='-O6 -mpentiumpro -mstack-align-double' CXX='/usr/local/bin/gcc' CXXFLAGS='-O6 -mpentiumpro -mstack-align-double -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 May 21 2000 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x1 root root 4101836 Jan 15 15:49 /lib/libc-2.1.3.so -rw-r--r--1 root root 20273324 Jan 15 15:49 /usr/lib/libc.a -rw-r--r--1 root root 178 Jan 15 15:49 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql-3.23.34a --with-mysqld-ldflags=-all-static --with-mysqld-user=mysql --without-debug --with-berkeley-db --with-innobase --without-bench --datadir=/var/lib/mysql --localstatedir=/var/lib/mysql --sysconfdir=/etc --infodir=/usr/local/info --mandir=/usr/local/man --enable-assembler --with-libwrap 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
mysqlbug
Sir, Iam Roopa mailing you from linux learning centre. I have a slight problem regarding mysql-3.23.22-6 I have installed this for the first time using rpm packages.after installation when i run mysql_install_db , but when i try to start mysql daemon using safe_mysqld am encountering an error saying "mysql daemon ended" i checked the error log file too .according to which the error is "can't find file :host.frm". iam unable to trace what has to be done to eliminate this error. so please guide me in this direction. eagerly waiting for ur reply, Thanking you Roopa.S - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
