Re: rpm requires perl5 on redhat 7.0
SATYAN NAIR writes: dear friends, i am not able to install MySQL-3.23.30-1.i386.rpm on redhat 6.2 and 7.0 it says REQUIRES PERL5 at /usr/bin/perl5 and under /usr/bin i have perl as well as perl5.006 please let me know how do i install the rpm on linux!! Hi! We have fixed this problem for the *upcoming* 3.23.31 release. For now, you can just pass '--no-deps' to the RPM install command, and it should work. Regards, Matt -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Matt Wagner [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ River Falls, Wisconsin, USA ___/ Developer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ld: cannot linking
Description: gcc -O2 -s -I/usr/include/ncurses -DNCURSES -I/usr/local/mysql/include -I/usr/local/iceb/include -DCONFIG_PATH=\"./\" sozs qlbaz.o -o sozsqlbaz -lncurses -L/usr/local/iceb/lib -ldev -lbuh -lutil -lscr -lsql -lconfig -L/usr/local/mysql/lib -lmysqlclient -lm /usr/local/mysql/lib/libmysqlclient.a(my_compress.o): In function `my_uncompress': my_compress.o(.text+0x97): undefined reference to `uncompress' /usr/local/mysql/lib/libmysqlclient.a(my_compress.o): In function `my_compress_alloc': my_compress.o(.text+0x12b): undefined reference to `compress' collect2: ld returned 1 exit status How-To-Repeat: nothing Fix: i don't know :) Submitter-Id: submitter ID Originator: Organization: organization of PR author (multiple lines) MySQL support: none Synopsis: none Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.30-gamma (Official MySQL binary) Environment: Intel Pentium III (Katmai), redhat 6.2, i386, standart distrib without any upgrade System: Linux plumzyk 2.2.15-net-snd-zip #4 Sat Jan 6 19:06:34 MSK 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) Compilation info: CC='gcc' CFLAGS='-O6 -mpentium -fomit-frame-pointer' CXX='gcc' CXXFLAGS='-O6 -mpentium -fomit-frame-pointer -felide-constructors' LDFLAGS='-static' LIBC: lrwxrwxrwx1 root root 13 mAJ 4 2000 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x1 root root 4101324 fEW 29 2000 /lib/libc-2.1.3.so -rw-r--r--1 root root 20272704 fEW 29 2000 /usr/lib/libc.a -rw-r--r--1 root root 178 fEW 29 2000 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared Perl: This is perl, version 5.005_03 built for i386-linux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Dropping a field from a table
Hi ! I'm new to the list, new to MYSQL in general, although not to SQL, and i was wondering if it is possible to drop a field from a table in MYSQL and what is the correct sintax to drop it. I have been searching in the Dubois's MySQL book but it didn't told any about, or at least i didn't found it. Thanks in advance
Re: Dropping a field from a table
The ALTER TABLE syntax is explained thoroughly on section 7.8 on the manual pages. ALTER [IGNORE] TABLE tbl_name alter_spec [, alter_spec ...] alter_specification: ADD [COLUMN] create_definition [FIRST | AFTER column_name ] orADD [COLUMN] (create_definition, create_definition,...) orADD INDEX [index_name] (index_col_name,...) orADD PRIMARY KEY (index_col_name,...) orADD UNIQUE [index_name] (index_col_name,...) orADD FULLTEXT [index_name] (index_col_name,...) or ADD [CONSTRAINT symbol] FOREIGN KEY index_name (index_col_name,...) [reference_definition] orALTER [COLUMN] col_name {SET DEFAULT literal | DROP DEFAULT} orCHANGE [COLUMN] old_col_name create_definition orMODIFY [COLUMN] create_definition orDROP [COLUMN] col_name orDROP PRIMARY KEY orDROP INDEX index_name orRENAME [TO] new_tbl_name orORDER BY col ortable_options Regards Jorge MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mexico City, Mexico ___/ - Original Message - From: "Xavi Gracia" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 11, 2001 4:33 AM Subject: Dropping a field from a table Hi ! I'm new to the list, new to MYSQL in general, although not to SQL, and i was wondering if it is possible to drop a field from a table in MYSQL and what is the correct sintax to drop it. I have been searching in the Dubois's MySQL book but it didn't told any about, or at least i didn't found it. Thanks in advance - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Install:MySQL, RedHat7, Dell Poweredge 2400 dual PIII 700 MHz
Hello! I want to install mysql-3.23.29-1.src.rpm on an Dell Poweredge 2400 with 2 PIII 700 MHz processors. After rebuilding the src code, i install the rpms. My problem is, that I can't start the mysqld deamon. I've tried to install the pre-compiled rpm files with the same result. The same files work fine on an other server (with only one processor). Is it possible, that the second processor is the problem with this version of mysql. Which version of mysql should I use instead? Please help me! Any suggestion will be welcome. Thanks Lars Freymark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Tables in memory
Hi, check the following for a description on HEAP tables. http://www.mysql.com/documentation/mysql/commented/manual.php?section=HEAP HEAP tables are suitable as temporary tables since they are not saved to disk. What you can do if heap tables suite your needs is to write a script which writes all of the records to another table. Keep in mind that if you use HEAP tables and mysql crashes, you will loose all the data. Regards Jorge MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mexico City, Mexico ___/ - Original Message - From: "Thierry Coopman" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 11, 2001 5:04 AM Subject: Tables in memory Hi, I have read on some presentation that you can create a table in memory that then gets written to disk once every few hours. I can't find information about that in the documentation, but it would be a perfect solution for me. I need 500+ updates per second, so a table in memory would be the most ideal. But I was wondering if that table can be written to disc automaticly. (Once per day schould be enough actually) -- Thierry Coopman - [EMAIL PROTECTED] My opinions are personal, and have really nothing or nothing to do with Keytrade! You know that you are drinking too much coffee if: ... You speed walk in your sleep. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Can't connect to local Mysql server (111)
hi, i've Mysql installed on linux, binary install, i launched the server : bin/safe_mysqld and if i try to connect to mysql ( mysql -u root -p mysql ) i get this message : Can't connect to local Mysql server (111) i tried : mysql -u root test but i get the same message. how to debug this ??? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Please read the manual
Mr. Samuel, Im new in this field (mysql, linux, etc.), I am a MCSE, and at this time, I try to impulse this software (Mysql, Linux, etc) in Central America, I see many feactures in this software but I need to Know if exist a maillist for dummies as I, mybe in a two months I can give to people like you (MySQL Development Team) a good feed back to make this software the best of the world, that I think is your objetive, please, patience sir. Thanks Edwin Neff Patrick K ha escrito: Maybe it is the lack of coffee this morning talking or maybe it is the fact that I have spent 4 days trying to get mysql up and running on linux(a platform I am unfamiliar with) but I assumes this mailing list would allow me to have contact with other users who have been thru the same issues I have had. Apparently I was wrong. You see I am a newbie too and what turned me on to mysql ,linux and the open source movement was the fact that it seems to focus on the power of people and there combined knowledge. I am not stupid and I can read in fact I have look over this manual about 100 times now the last four evenings. I apologize for wasting anyone's time but before I can become a valid contributor to a group dealing with a specific software I first have to be able to get the thing running. I in fact finally got mysql up and running last night but not one word in your manual helped me do it. So in fact all the reading in the world would have left me sitting in the same position. I am sorry to rant and rave but maybe if some seasoned user on this mailing list (not the developers) would help us newbies then we could all work together to. That is my two cents sorry to waste your time with it. -Original Message- From: Tnu Samuel [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 10, 2001 4:58 PM To: [EMAIL PROTECTED] Subject: Please read the manual Maybe it is my depression and I see everything in black but please read manual before posting questions in this list. Manual covers at least 90% questions asked here. If manual does not cover them, we will put new chapters in it. This is all because what we do in this list can be called FREE support. As much I know, most of our developers are spending 2..4 hours per day just reading all related groups and answering questions "Error 2002: Can't connect via socket /tmp/mysql.sock". Also I wanted to ask everyone who gets revenue from MySQL still buy support contract. While MySQL is free to users there are people behind it who eat, buy books, pay for internet connection get hardware and buy icecream to kids. This is not about home users. There are companies on NASDAQ who use heavily different open source software for their success and have never paid a penny. For that money you get guaranteed answers. MySQL is free, support in this list is partially free but do not abuse it, then it can stay free in future. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: [EMAIL PROTECTED] If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: 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 -- Edwin Martinez G. Ingenieria Aplicada S.A. / Grupo MICRO Guatemala, Guatemala Tel: +(502) 3326480 / 3345175 Web: http://www.micro.com.gt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Please read the manual
In order to conserver bw I'll only through my $0.01 in...;) I do believe that if you search the list you will see that many of us who are not on the devteam do answer questions. Although I do whole heartedly believe in RTFM; I agree with you about the power of the people, and feel it is important for all of us to help by giving back to our community...;D Cheers, Mikel Neff Patrick K wrote: Maybe it is the lack of coffee this morning talking or maybe it is the fact that I have spent 4 days trying to get mysql up and running on linux(a platform I am unfamiliar with) but I assumes this mailing list would allow me to have contact with other users who have been thru the same issues I have had. Apparently I was wrong. You see I am a newbie too and what turned me on to mysql ,linux and the open source movement was the fact that it seems to focus on the power of people and there combined knowledge. I am not stupid and I can read in fact I have look over this manual about 100 times now the last four evenings. I apologize for wasting anyone's time but before I can become a valid contributor to a group dealing with a specific software I first have to be able to get the thing running. I in fact finally got mysql up and running last night but not one word in your manual helped me do it. So in fact all the reading in the world would have left me sitting in the same position. I am sorry to rant and rave but maybe if some seasoned user on this mailing list (not the developers) would help us newbies then we could all work together to. That is my two cents sorry to waste your time with it. -Original Message- From: Tnu Samuel [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 10, 2001 4:58 PM To: [EMAIL PROTECTED] Subject: Please read the manual Maybe it is my depression and I see everything in black but please read manual before posting questions in this list. Manual covers at least 90% questions asked here. If manual does not cover them, we will put new chapters in it. This is all because what we do in this list can be called FREE support. As much I know, most of our developers are spending 2..4 hours per day just reading all related groups and answering questions "Error 2002: Can't connect via socket /tmp/mysql.sock". Also I wanted to ask everyone who gets revenue from MySQL still buy support contract. While MySQL is free to users there are people behind it who eat, buy books, pay for internet connection get hardware and buy icecream to kids. This is not about home users. There are companies on NASDAQ who use heavily different open source software for their success and have never paid a penny. For that money you get guaranteed answers. MySQL is free, support in this list is partially free but do not abuse it, then it can stay free in future. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: [EMAIL PROTECTED] If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Please read the manual
It is not that the "seasoned veterans" don't want to help you. They want to know that you have helped yourself first before seeking help from them. It is obvious when someone asks a question and they haven't tried reading the manual first. A question that comes up from time to time is "how do I install mysql?". This is obviously a sign that the person hasn't even bothered trying to read the manual. The installation isn't just a simple process and each platform has its differences and odd little quirks. How can seasoned veterans answer such a question? They can either quote the whole manual or tell you to download and read it for yourself. If you had said "I did this, this and this as per the manual but got this error/have this problem", people are more than willing to assist you, if they know the answer, and they will also have some idea of where you are going wrong. Quoting a sentence/example from the manual will show that you have at least tried on your own first. I answered one guy's question earlier on today who did just that. Quoted from the manual, that is. At least that shows he tried first before seeking help. If you are a newbie to SQL in general, ie. you don't even know how to write simple SELECT, INSERT and DELETE statements, then you have most certainly come to the wrong place. I was a newbie once, but through trial and error and reading and re-reading, I managed to get it up and running. I have only asked once from the list as I was a little confused with one section of the manual, but generally, I thought it is quite a comprehensive and excellent manual, not like Oracle's which is like a set of Encyclopedias. I have also found this list and the archive of this list to be far more valuable than the manual itself as the problems are real problems. If you really find the manual that confusing, perhaps you should suggest to the MySQL team on how they can improve it to make it easier for others who will follow in your footsteps. - Original Message - From: "Edwin Martinez" [EMAIL PROTECTED] To: "Neff Patrick K" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, January 11, 2001 22:08 Subject: Re: Please read the manual Mr. Samuel, Im new in this field (mysql, linux, etc.), I am a MCSE, and at this time, I try to impulse this software (Mysql, Linux, etc) in Central America, I see many feactures in this software but I need to Know if exist a maillist for dummies as I, mybe in a two months I can give to people like you (MySQL Development Team) a good feed back to make this software the best of the world, that I think is your objetive, please, patience sir. Thanks Edwin Neff Patrick K ha escrito: Maybe it is the lack of coffee this morning talking or maybe it is the fact that I have spent 4 days trying to get mysql up and running on linux(a platform I am unfamiliar with) but I assumes this mailing list would allow me to have contact with other users who have been thru the same issues I have had. Apparently I was wrong. You see I am a newbie too and what turned me on to mysql ,linux and the open source movement was the fact that it seems to focus on the power of people and there combined knowledge. I am not stupid and I can read in fact I have look over this manual about 100 times now the last four evenings. I apologize for wasting anyone's time but before I can become a valid contributor to a group dealing with a specific software I first have to be able to get the thing running. I in fact finally got mysql up and running last night but not one word in your manual helped me do it. So in fact all the reading in the world would have left me sitting in the same position. I am sorry to rant and rave but maybe if some seasoned user on this mailing list (not the developers) would help us newbies then we could all work together to. That is my two cents sorry to waste your time with it. -Original Message- From: Tnu Samuel [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 10, 2001 4:58 PM To: [EMAIL PROTECTED] Subject: Please read the manual Maybe it is my depression and I see everything in black but please read manual before posting questions in this list. Manual covers at least 90% questions asked here. If manual does not cover them, we will put new chapters in it. This is all because what we do in this list can be called FREE support. As much I know, most of our developers are spending 2..4 hours per day just reading all related groups and answering questions "Error 2002: Can't connect via socket /tmp/mysql.sock". Also I wanted to ask everyone who gets revenue from MySQL still buy support contract. While MySQL is free to users there are people behind it who eat, buy books, pay for internet connection get hardware and buy icecream to kids. This is not about home users. There are companies on NASDAQ who use heavily different open source software for their success and have
Re: ERROR 1044
- Original Message - From: "Franck ABELLI" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 11, 2001 23:29 Subject: ERROR 1044 i can now connect to mysql but when i login as root with the root password i get the ERROR 1044 : Access denied. if i don't give any password i can connect but if i write: mysql use mysql i've got the same message, so i can't do anything neither connect nor create database,tables... -i made the install described in the doc of mysql (groupadd, useradd...) -it worked and when i've changed the root password, i restart mysqld and i've got the error since this moment. i changed the owner/group of the /mysql dir to set it to root/root, changed the permisions to 777, but it's still the same. That is not such a good idea. I suggest changing it back. What is the exact command you used to change the root password and the exact command you used to login? ADVICE: Replace the password with Xs or something, unless you want the world to be able to log into your machine and do what they like with your DB. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Failed test
Hiya I compiled mysql-3.23.30-gamma.tar.gz using pggc version pgcc-2.95.2.1 and kernel 2.4.0 CFLAGS="-Os -O6 -march=pentium" CXXFLAGS=$CFLAGS configure: ./configure --enable-static --prefix=/usr/local/mysql --localstatedir=/home/mysql --enable-assembler when running the tests: ... join_outer0.25 0.13 1.13 [ pass ] key 0.16 0.11 0.46 [ pass ] key_diff 0.19 0.08 0.29 [ pass ] key_primary 0.21 0.05 0.29 [ pass ] keywords 0.13 0.12 0.28 [ pass ] limit 0.18 0.08 0.30 [ pass ] merge 0.19 0.09 0.93 [ pass ] null 0.14 0.12 0.29 [ pass ] null_key [ fail ] Error at line 48: Result length mismatch Aborting. To continue, re-run with '--force'. Ending Tests Shutting-down MySQL daemon i guess i shouln't fail :) so the question is did i do something wrong or you? Greetz, Wico - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Failed test
Hiya update: when using --force this one fails too and the system is redhat 6.2 rename0.16 0.12 0.32 [ pass ] replace 0.19 0.08 0.30 [ pass ] rollback 0.17 0.09 0.26 [ pass ] rpl01 [ fail ] Error at line 13: query 'select * from foo' failed: 1146: Table 'test.foo' doesn't exist Ending Tests Shutting-down MySQL daemon Greetz, Wico At 17:12 11-1-01 +0100, Wico de Leeuw wrote: Hiya I compiled mysql-3.23.30-gamma.tar.gz using pggc version pgcc-2.95.2.1 and kernel 2.4.0 CFLAGS="-Os -O6 -march=pentium" CXXFLAGS=$CFLAGS configure: ./configure --enable-static --prefix=/usr/local/mysql --localstatedir=/home/mysql --enable-assembler when running the tests: ... join_outer0.25 0.13 1.13 [ pass ] key 0.16 0.11 0.46 [ pass ] key_diff 0.19 0.08 0.29 [ pass ] key_primary 0.21 0.05 0.29 [ pass ] keywords 0.13 0.12 0.28 [ pass ] limit 0.18 0.08 0.30 [ pass ] merge 0.19 0.09 0.93 [ pass ] null 0.14 0.12 0.29 [ pass ] null_key [ fail ] Error at line 48: Result length mismatch Aborting. To continue, re-run with '--force'. Ending Tests Shutting-down MySQL daemon i guess i shouln't fail :) so the question is did i do something wrong or you? Greetz, Wico - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Visual Basic and MySQL connection
So you've "bound" the datasource to the text box. I've never done that. I've always done all my ado updates manually. I suggest you look into doing all the ADO work on the backend, and manually update your text boxes. I've never had any problems doing that. Binding isn't very good practice. At 04:48 PM 1/11/2001 +0100, Vladimir Novakovic wrote: Are you binding the datasource to the text box? Or using are you using ado to manually update it? Well I tried to bind the datasource to the text box. I used as model MSDN advice to ADO. It look like: To create a simple front-end database application * Draw an ADO Data Control on a form. (The icon's ToolTip is "ADODC.") If the control is not available in the Toolbox, press CTRL+T to display the Components dialog box. In the Components dialog, click Microsoft ADO Data Control. * On the Toolbox, click the ADO Data Control to select it. Then press F4 to display the Properties window. * In the Properties window, click Use ODBC Data Source Name to display the Use ODBC Data Source Name dialog box. * Choose sample-MySQL * In the Autentication put username and password * In the RecordSource choose command type: 8 - adCmdUnknown * For Command Text (SQL) put: SELECT * FROM tblsites WHERE fldSITEId = 12 (fldSITEId is number format in MySQL). * Create Textbox * For DataSource choose: Adodc1 * For DataField choose: fldSITEName (fldSITEName is text format field in MySQL). * Run program (F5) Maybe this will help you to understand what did I do. Regards, Vladimir - Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] "Always bear in mind that your own resolution to success is more important than any other one thing." - Abraham Lincoln - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: rpm requires perl5 on redhat 7.0
Try building from source from the mirror site http://mysql.hjc.edu.sg if u are in India. Cheers. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL server has gone away error
I posted a couple of days ago abou this error and got no response, so I am trying again with a bit more detail this time. I am running mysql 3.23.28-gamma on a pretty much stock RH 6.2 box. I am accessing the database using Perl CGI scripts and the DBI API. I have reset the max_allowed_packet and wait_timeout values to 10M and 32 hours respectively as is suggested in the manual, but this has had no effect. Here are the specifics from the error logs: DBD::mysql::st execute failed: MySQL server has gone away at /cgi-bin/common/utility.pl line 85. 010109 14:37:27 Aborted connection 265218 to db: '' user: '' host: `localhost' (Got timeout reading communication packets) 010109 14:37:27 /usr/local/libexec/mysqld: Shutdown Complete 010109 14:37:27 mysqld ended\n Sean Conley - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Please read the manual
Doug Young wrote: If I may add my 0.5c here too, the MySQL manual, like so many of its kind was obviously written by a highly skilled developer(/s) but who, like virtually all of that ilk, lacks the ability to impart knowledge to others. The MySQL manual available at www.mysql.com is terrific. It's not perfect, because nothing is, and because nothing that is meant for general-purpose use can ever be perfect for all situations. However, it's still terrific. a similar situation to that existing with most unix / linux man pages time time again we see experts going on about RTFM, however all those things do is totally confuse newbies. There are two possible assertions that you could have made in your email, and I'm not sure which one you actually did. They are: * The existing MySQL documentation is poor. * The MySQL user community (especially the newbies) would be well-served by parrallel documentation that was delivered in more of a tutorial format. If you mean the latter, then sure, I agree. Hey, why not agree? It's easy to fluff off the job of writing a tutorial into the realm of wishes and other people's work. If you mean the former, then I disagree. There's a difference between newbies being totally confused about (e.g.) some of the finer points of advanced SQL (which is forgivable), and people who are too lazy to read the documentation regarding how to reset a MySQL password they'd forgotten. (This example is my most-hated, most-often-experienced question on this list.) Cheers, Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: rpm requires perl5 on redhat 7.0
SATYAN NAIR wrote: dear friends, i am not able to install MySQL-3.23.30-1.i386.rpm on redhat 6.2 and 7.0 it says REQUIRES PERL5 at /usr/bin/perl5 and under /usr/bin i have perl as well as perl5.006 RedHat includes perl5, it is the dependency rule which is broken. Just install as rpm -Uhv --nodeps MySQL*-3.23.30-1.i386.rpm The --nodeps option tells rpm to ignore dependencies. /matthew costello - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
limit to the number of characters allowed in a query?
I'm trying to run a very long query and after trying it in various ways, it seems like there is a limit to the number of characters allowed in a query. If this is true, is it possible to increase the number of characters allowed. (the database is hosted at an ISP) I've tried -q and -f in the query, but it didnt help TIA Mark Dale - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: urgent question
Surely this is a PHP question, not a MySQL Question -Original Message- From: Ryan Hagan [SMTP:[EMAIL PROTECTED]] Sent: Friday, January 12, 2001 1:14 PM To: [EMAIL PROTECTED] Subject: urgent question Greetings, I have just subscribed to this list, so I am really sorry if I'm asking a question that has been asked already, but I wasn't having any luck plowing through the archives, so I thought I'd try my luck with the list. I'm using MySQL 3.23.29 with PHP4 and apache 1.3.14 on a FreeBSD 4.2 machine. When do a standard query statement from a PHP page, it seems to get the data, but I can't get it to display? Basically, if I have a table, Users, which consists of id, name and job with the following data: 1, ryan, ditch digger 2, bob, programmer 3, james, window washer When I run the query, "SELECT * FROM Users," and print it out, I get a table that looks like this: | id | name | job | - | | | | - | | | | - | | | | - In other words, it fetches 3 rows, but there's no data. However, it works as expected when I telnet into the machine and use the mysql command line tool. Any idea what's going on? The same code worked perfectly with the same setup when I was running Mandrake 7.1 and MySQL 3.22. Thanks for your time. --- Ryan Hagan President, IncaGold USA, Ltd. [EMAIL PROTECTED] http://www.incagold.com/ ICQ: 161019 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is 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
RE: limit to the number of characters allowed in a query?
There is a limit to the size of a packet sent to mysqld, which is configurable. Check the manual for it, and see if you are hitting that. Regards Quentin -Original Message- From: Mark Dale [SMTP:[EMAIL PROTECTED]] Sent: Friday, January 12, 2001 12:39 PM To: [EMAIL PROTECTED] Subject: limit to the number of characters allowed in a query? I'm trying to run a very long query and after trying it in various ways, it seems like there is a limit to the number of characters allowed in a query. If this is true, is it possible to increase the number of characters allowed. (the database is hosted at an ISP) I've tried -q and -f in the query, but it didnt help TIA Mark Dale - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is 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
Re: index corruption and mysqld crash
I can think of only one suggestion. See if there is a cron job or something killing a process. I doubt it though. Hope it helps. - Original Message - From: "Joseph Bueno" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 12, 2001 1:31 Subject: index corruption and mysqld crash Hello, I have switched this morning our Web server from mSQL to MySQL. I am using MySQL 3.22.32 installed from MySQL-3.22.32-1.i386.rpm on a Linux server (RedHat 6.2). mysqld dies very ofen (uptime is between 2mn and 20mn) and the only messages I have in error file look like : Number of processes running now: 1 mysqld process hanging, pid 10827 - killed mysqld restarted on jeu jan 11 17:35:58 CET 2001 /usr/sbin/mysqld: ready for connections Number of processes running now: 1 mysqld process hanging, pid 7973 - killed mysqld restarted on jeu jan 11 17:38:25 CET 2001 /usr/sbin/mysqld: ready for connections I have shut down mysqld several times and run isamchk. Each time, I had to repair at least one table. Is it possible to run isamchk while mysqld is running ? In this case, is it enough to remove --skip-locking option (set in safe_mysqld) or should I also add --enable-locking ? Does anybody have any suggestion on where I could look in order to find what is causing these corruptions ? Thanks for your help -- Joseph Bueno NetClub/Trader.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Enough is Enough.
Years ago when AOL first provided its users access to newsgroups, they very quickly into what I've seen in this list in the past few days. People ask questions that are contained within FAQs and manuals, and then they get smacked in the face. And ofcourse, they respond with their hurt egos. The battles ensue with the "me too" ways, and finally people like me who are looking to help someone, anyone, even the people with simple questions, are stuck downloading 25 messages that don't have anything to do with MySQL. I've gotten alot of help from this list, with PHP and MySQL questions, because some things don't work like the documentation says. I appreciate all the help, and I'm glad that I can help people, even if their question is in the documentation. To those who don't have the time to answer anything but the serious beefy questions, thats alright, because there are tons of other people here. Most posts get atleast 5 replies. Don't waist your time, if thats what you feel it is, a waist. Take this message, think about it. Take what you agree with and dismiss the rest, and remember. There's no need to reply to the WHOLE list.
Re: query much slower when function used...?
okay, with gdb i can see that this column becomes a blob (thereby not allowing heap tables to be used - which has got to be costing me speed), is there any function i can use to 'cast' this column to a fixed length? hrm, apparently LEFT(SUBSTRING(MAX(CONCAT())), N) will do that for me... sorry for thinking out loud ;-) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php