Convert ISAM table to MyISAM
Hi all. I'm going to upgrade a mysql-3.22 Linux Pentium server to mysql-3.23.49a. Which is the best way to convert a database of ISAM table to MyISAM? mysqldump? How to do it? Iago. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: running script through C program
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 1:00 PM To: Chetan Lavti Subject: Re: running script through C program Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Hi, I have written one script for backup .. now, I want to run this script from the C program,,, How can I do this ...?? please, help me !!=20 Thanks and regards, Chetan Lavti - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Retrive distinct data from two tables
Try: SELECT B.name FROM B LEFT JOIN A ON A.name = B.name WHERE A.name is null; -Original Message- From: Pichan M. [mailto:[EMAIL PROTECTED]] Sent: Thursday, 14 March 2002 12:19 PM To: [EMAIL PROTECTED] Subject: Retrive distinct data from two tables I have 2 tables, let says, table A and table B. Each table record person name. select B.name from B, A where B.name = A.name Query above should return the name which recorded in both tables (duplicate name) In reverse, how can I retrive the name which recorded in Table B and not present in Table A? Table A name id Johnson |1203 Jack|1192 Mary |5509 Jimmy |1189 Table B name level Johnson | AA Mary| AC Alex | AA Chris| AA select B.name from B, A where B.name A.name this query not work as I expect, also with join _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql, query :running script through C program
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 2:22 PM To: Chetan Lavti Subject: Re: mysql, query :running script through C program Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Hi, I have written one script for backup .. now, I want to run this script from the C program,,, How can I do this ...?? please, help me !!=3D20 Thanks and regards, Chetan Lavti - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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] Multiple WHERE options in SELECT
i wonder if its possible to perform multiple WHERE statements in one mysql SELECT statement like: SELECT * FROM table WHERE field1=3D'one' AND field2=3D'two' OR field3=3D'three'; it works with as many AND and it works with OR but not together is there something like brackets or other logical opertators thanks in advance jan -- __ i-gap MULTIMEDIA OEG Schwingenschlögl Jan tel +43 676 545 88 31 fax +43 7442 55155 32 mailto:[EMAIL PROTECTED] http://www.i-gap.at __ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Making UPDATE return the no. of rows matched
Hi all, I have changed database for my Java app to MySQL. The app was developed with SQL Server. Some of the logic is dependent on getting the no. of rows updated returned after an UPDATE query. MySQL does only return the rows that are really updated, not the rows matched of an UPDATE. This causes problems. Is there an easy way to get MySQL always return the number of rows matched in an UPDATE? Regards, Rune Steinseth __ Sjekk snørapporter... fra 500 ski-destinasjoner i Europa på http://no.snow.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: [mysql] Multiple WHERE options in SELECT
Jan, i wonder if its possible to perform multiple WHERE statements in one mysql SELECT statement like: SELECT * FROM table WHERE field1=3D'one' AND field2=3D'two' OR field3=3D'three'; it works with as many AND and it works with OR but not together is there something like brackets or other logical opertators There is a wealth of operators and functions (including precedence-controlling brackets). Manual: 6.3 Functions for Use in SELECT and WHERE Clauses Regards, =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Changing character X to Y in a table
Hi Jari, have not figured out if one can do character changes with mysql, any one know how to do the following for fields in a table Altering all the x-characters to character y ? =You sure can. Manual reference: 6.3.2 String Functions REPLACE() will find the x-characters and replace them all with character y. =Regards, =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
two-way replication
hello, i'm new to the list and don't know if this has been discussed before, so excuse me if repeating. i have the idea of setting up a two-way replication system with 2 mysql servers for my radius database. i need them to act interchangeably: 1. if server1 is alive, all selects and updates (radius acct) should go to server1. server2 should act as a slave for server1. 2. if server1 dies, all selects and updates (radius acct) should go to server2. so far, so good. but here comes the tricky (for me) part - when server1 comes up again, it shold do 2 things: a) catch up with server2. b) become master again, leaving server2 as it's slave (same situation as in 1. above). how could this happen ? all ideas are appreciated (pointing to reading - also), thanks in advance. kosio - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql hotcopy
Mark, Wednesday, March 13, 2002, 9:53:08 PM, you wrote: MS Quick question - MS I have a db named content with user admin and pass mypass Do I still MS use -u root p maypass ? or would I use MS mysqlhotcopy -u admin -p mypass content /path/to/copy/the/data/to MS Thanks again for your help. If your user 'admin' has permissions to execute mysqlhotcopy you can use user 'admin'. To be able to execute mysqlhotcopy you need write access to the backup directory, SELECT privilege to the tables you are about to copy and the MySQL Reload privilege (to be able to execute FLUSH TABLES). MS Mark -- 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
adding administrative users in mysql
mailing, Wednesday, March 13, 2002, 9:41:11 PM, you wrote: ml I am attempting to add the ROOT user as a MYSQL administrator using the ml following syntax: ml mysqladmin -u root password 12345 This command doesn't add user 'root', it can only change password for that user. ml and I recieve the following error: ml mysqladmin: connect to server at 'localhost' failed error: 'Access denied ml for user: 'root@localhost' (Using password: YES)' ml anyone have any ideas? Are you sure that you have supplied a correct password for user 'root'? ml Adrian -- 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
Retrive distinct data from two tables
Pichan, Thursday, March 14, 2002, 6:19:23 AM, you wrote: PM I have 2 tables, let says, table A and table B. Each table record person PM name. PM select B.name from B, A where B.name = A.name PM Query above should return the name which recorded in both tables (duplicate PM name) PM In reverse, how can I retrive the name which recorded in Table B and not PM present in Table A? PM Table A PM name id PM PM Johnson |1203 PM Jack|1192 PM Mary |5509 PM Jimmy |1189 PM PM Table B PM name level PM PM Johnson | AA PM Mary| AC PM Alex | AA PM Chris| AA PM PM select B.name from B, A where B.name A.name PM this query not work as I expect, also with join SELECT B.name from B LEFT JOIN A ON B.name=A.name where A.name IS NULL; You can find info about JOIN clause at: http://www.mysql.com/doc/J/O/JOIN.html -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
a quick sanity check...
denonymous, Wednesday, March 13, 2002, 9:06:48 PM, you wrote: d Hi all -- I just need a quick sanity check on a query. d I have two tables: d CREATE TABLE users ( d userID VARCHAR(10) NOT NULL PRIMARY KEY, d [many other fields] d ) d CREATE TABLE subscriptions ( d userID VARCHAR(10) NOT NULL, d listID INT NOT NULL d ) d In these tables, users.userID == subscriptions.userID. d The users table keeps 1 record per userID, and the subscriptions table keep d multiple records per userID (one for each listID to which they're d subscribed). d If I wanted to select all users from the users table that *do not* appear in d the subscriptions table, I'd want the following query: d SELECT users.* d FROM users d LEFT JOIN subscriptions d ON users.userID=subscriptions.userID d WHERE subscriptions.userID IS NULL d Correct? Looks like it is correct. You can check your query result on any test database. d I know that this is a pretty base example, but I'd like to confirm it d (outside of an example in a book) with someone a bit more knowledgable than d me. There are a couple other reports here that calculate this number in d other ways, and I'd like to be able to positively state that this is the d be-all end-all for the needed data. d Much thanks! -- 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
Convert ISAM table to MyISAM
Iago, Thursday, March 14, 2002, 10:17:10 AM, you wrote: IS I'm going to upgrade a mysql-3.22 Linux Pentium server to mysql-3.23.49a. IS Which is the best way to convert a database of ISAM table to MyISAM? IS mysqldump? IS How to do it? You can use mysqlcheck or ALTER TABLE statement. You can find example of changing table type from ISAM to MYISAM at: http://www.mysql.com/doc/I/S/ISAM.html IS Iago. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Changing character X to Y in a table
Hi Jari, have not figured out if one can do character changes with mysql, any one know how to do the following for fields in a table Altering all the x-characters to character y ? =You sure can. Manual reference: 6.3.2 String Functions REPLACE() will find the x-characters and replace them all with character y. =Regards, =dn Thanks, I got the same reply moment ago :) somehow had the impression I cannot use fields in the replace but just strings That reply has not yet shown up on the list (yet) - perhaps the person does not realise that by doing list members the 'favor' of not adding to list volumes, it also does a disservice because others cannot see that you have received a response and so waste their time and effort trying to help you out. (choice: more msgs to DELete, or wasting my time composing an answer to a solved problem? - I know which I prefer!) I'm not sure if I understand what you're saying here... The manual gives a single example: select REPLACE('www.mysql.com', 'w', 'Ww'); which certainly does only use string-constant values. However the template says str, ie string expression (anything as long as it evaluates to a string); so you can code: select REPLACE( colNm, 'w', 'Ww'); and that will work. However, if you want to try: select REPLACE( colNm1, colNm2, colNm3 ); then I wouldn't like to say/haven't tried it - but have my doubts! If that's your plan, then please try it, and I'll be interested to hear how you get on... In case you are a newbie: may I suggest that you add a new column to the table (ALTER TABLE) and either copy the column that you are going to string-edit (as a 'backup' that you could subsequently, quickly 'restore') or code the UPDATE to amend/insert at the new column instead of overwriting the existing column - thus you can easily see 'before' and 'after' values/debug! Of course, before you debug any UPDATE/DELETE etc code, you backup the entire (valuable) table - right!? Regards, =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: a quick sanity check...
- Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, 14 March, 2002 12:48 Subject: a quick sanity check... : denonymous, : Wednesday, March 13, 2002, 9:06:48 PM, you wrote: : : d Hi all -- I just need a quick sanity check on a query. : : : d I have two tables: : : d CREATE TABLE users ( : d userID VARCHAR(10) NOT NULL PRIMARY KEY, : d [many other fields] : d ) : : d CREATE TABLE subscriptions ( : d userID VARCHAR(10) NOT NULL, : d listID INT NOT NULL : d ) : : : d In these tables, users.userID == subscriptions.userID. : d The users table keeps 1 record per userID, and the subscriptions table keep : d multiple records per userID (one for each listID to which they're : d subscribed). : : d If I wanted to select all users from the users table that *do not* appear in : d the subscriptions table, I'd want the following query: : : d SELECT users.* : d FROM users : d LEFT JOIN subscriptions : d ON users.userID=subscriptions.userID : d WHERE subscriptions.userID IS NULL subscriptions.userID will never be NULL (the field is created that way). maybe a good idea is to let it be NULL so you can tell when there is no coresponding record in the users table. : : d Correct? : : Looks like it is correct. You can check your query result on any test : database. : : d I know that this is a pretty base example, but I'd like to confirm it : d (outside of an example in a book) with someone a bit more knowledgable than : d me. There are a couple other reports here that calculate this number in : d other ways, and I'd like to be able to positively state that this is the : d be-all end-all for the needed data. : : d Much thanks! : : : : : -- : 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 : - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
LEFT OUTER JOIN where not null datetime column is null gives incorrect result.
Description: Left outer join on null datetime column produces incorrect result. The 2nd select below produces no rows, which is incorrect and inconsistent with the fourth select which produces 1 row. I get the same results with server version 3.23.41 - binary version from mysql.com How-To-Repeat: create table foo (a int); insert into foo values(1); insert into foo values(2); create table bar1 (a int, b datetime not null); insert into bar1 values(1, '25-12-2001'); create table bar2 (a int, b datetime); insert into bar2 values(1, '25-12-2001'); create table bar3 (a int, b char(20) not null); insert into bar3 values(1, 'Wensleydale'); select * from foo left outer join bar1 on foo.a=bar1.a; select * from foo left outer join bar1 on foo.a=bar1.a where b is null; select * from foo left outer join bar2 on foo.a=bar2.a where b is null; select * from foo left outer join bar3 on foo.a=bar3.a where b is null; drop table foo; drop table bar1; drop table bar2; drop table bar3; Fix: Convert the datetime column to nullable? Not really a fix since it breaks the schema. Submitter-Id: submitter ID Originator:Jon Barker Organization: Ingenta PLC MySQL support: none Synopsis: LEFT OUTER JOIN where not null datetime column is null fails. Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.39 (Official MySQL RPM) Server: /usr/bin/mysqladmin Ver 8.21 Distrib 3.23.39, 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.39 Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 37 days 20 hours 51 min 15 sec Threads: 1 Questions: 1855361 Slow queries: 4 Opens: 279 Flush tables: 3 Open tables: 8 Queries per second avg: 0.567 Environment: System: Linux ninetyseven 2.2.19-7.0.1 #2 SMP Fri Sep 28 18:00:32 GMT 2001 i686 unknown Architecture: i686 Also on Linux Mandrake release 8.0 (Traktopel) for i586 Kernel 2.4.3-20mdk on an i686 (AMD 1 CPU) Some paths: /usr/local/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-85) Compilation info: CC='egcs' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='egcs' CXXFLAGS='-O6 -fno-omit-frame-pointer-felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Nov 28 13:00 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 5724759 Oct 3 21:05 /lib/libc-2.2.4.so -rw-r--r--1 root root 27260368 Oct 3 21:03 /usr/lib/libc.a -rw-r--r--1 root root 178 Oct 3 21:03 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berkeley-db --without-innodb --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Compiling problem 3.23.49 under linux (mysql.cc)
It looks like you hit some C++ code on the first line. There are still major problems in using gcc 3.x for compiling C++ on Linux. On my own box, I had to downgrade to gcc 2.9.6. MySQL compiles flawlessly now. On Thu, 2002-03-14 at 01:19, MWP wrote: Hi all... I get: c++-303 -DUNDEF_THREADS_HACK -I./../include -I../include -I./.. -I.. -I.. -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -c mysql.cc In file included from /usr/local/gcc-3.0.3/lib/gcc-lib/i686-pc-linux-gnu/3.0.3/include/curses.h:80, from mysql.cc:48: /usr/include/unctrl.h: In function `int NCURSES_EXPORT(char*)': /usr/include/unctrl.h:57: parse error before `(' token In file included from mysql.cc:48: /usr/local/gcc-3.0.3/lib/gcc-lib/i686-pc-linux-gnu/3.0.3/include/curses.h:396: non-local function `int add_wch(const int NCURSES_EXPORT(char*)::cchar_t*)' uses local type `const int NCURSES_EXPORT(char*)::cchar_t' quite a lot of repeats of the last 3 lines then: mysql.cc:144: cannot declare static function inside another function mysql.cc:145: cannot declare static function inside another function mysql.cc:146: cannot declare static function inside another function mysql.cc:146: cannot declare static function inside another function mysql.cc:147: cannot declare static function inside another function mysql.cc:148: cannot declare static function inside another function mysql.cc:148: cannot declare static function inside another function mysql.cc:149: cannot declare static function inside another function mysql.cc:149: cannot declare static function inside another function with about another 15 of those from teh same file. Any ideas on what could cause this? ** Can you please reply to my email addr... im not on the mailing list ** Thanks, MWP - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Please send me urgent reply
I want to access the mysql through C-language. Please tell me which files I have to patch , from which sites. If u can give me any tuitorial that will be great. Please reply me on my Email-Id given below. My Email-Id is :- [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.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
3rd time and last
This is my last mail trying to get an answer from you to those 2 questions. You could at least say: go to the manual or don't know or don't ask it again or something Is the subject boring ?!?!?! _ Subject: Default RPMs and RAID support I want to use your binaries (i used to build them in my own machine, but i have followed this list and you're always saying to use yours). Just a question: is there a way of using your binaries and have Table type=RAID support ? Subject: An opinion about indexes Hi, I need your opinion about optimizing this query... I would really appreciate your help on this: The following table saves data about views to certain object identified by (cod-campanha,cod_tema,cod_canal,tipocanal,localizacao,seccao) from users. Each tuple (cod-campanha,cod_tema,cod_canal,tipocanal,localizacao,seccao, user) appears only once, and views is count of times he as seen the object. CREATE TABLE `users_views2` ( `cod_campanha` int(10) unsigned NOT NULL default '0', `cod_tema` int(10) unsigned NOT NULL default '0', `cod_canal` int(10) unsigned NOT NULL default '0', `tipocanal` tinyint(3) unsigned NOT NULL default '0', `localizacao` tinyint(3) unsigned NOT NULL default '0', `seccao` tinyint(3) unsigned NOT NULL default '0', `user` varchar(33) NOT NULL default '', `views` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`cod_campanha`,`cod_tema`,`cod_canal`,`tipocanal`,`localizacao`,`seccao`,`user`), KEY `users_views_idx2` (`cod_campanha`,`user`,`cod_canal`,`localizacao`,`seccao`), KEY `users_views_idx3` (`cod_campanha`,`user`,`tipocanal`) ) TYPE=MyISAM PACK_KEYS=1 mysql explain select cod_campanha, count(distinct user) as users, cod_tema from users_views2 where cod_campanha in (16,35,72,80,83,86,92,94,107,108,114,115,118,112) group by cod_campanha,cod_tema; +--+---+---+-+-+--+-+-+ | table| type | possible_keys | key | key_len | ref | rows| Extra | +--+---+---+-+-+--+-+-+ | users_views2 | range | PRIMARY,users_views_idx2,users_views_idx3 | PRIMARY | 4 | NULL | 2480655 | where used; Using index | +--+---+---+-+-+--+-+-+ 1 row in set (0.01 sec) I don't think the indexes created are very well.. Can you give me an opinion about that ? Thanx, -- 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
Re: Replication 2 way
- Original Message - From: [EMAIL PROTECTED] To: Patrick [EMAIL PROTECTED] Sent: Thursday, March 14, 2002 2:05 PM Subject: Re: Replication 2 way Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: hi i have the following situation what would be the best course of action i have 2 x databases on machine a on ip 192.168.1.50 1 x database on machine b on ip 192.168.1.100 i want to replicate the databases on machine a to machine b only the 2 not others and i want to replicate the database on machine b only that one to machine a this is basically just a backup but is this possible and what would i need to do Many Thanks Patrick Head Unix Admin XSInet - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: constraints in InnoDB, or is 3.23.43b _really_ 4.0.1?
Tomasz, are you using a non-latin1 character set? The bug fixed in 3.23.49 MySQL/InnoDB-3.23.49, February 17, 2002 * Fixed a bug: if one defined a non-latin1 character set as the default character set, then definition of foreign key constraints could fail in an assertion failure in dict0crea.c, reporting an internal error 17. might be the root of your problem with 4.0.1. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ Speed up adding of features to MySQL/InnoDB through support contracts See http://www.innodb.com for the online manual and latest news on InnoDB -Original Message- From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Thursday, March 14, 2002 8:57 AM Subject: Re: constraints in InnoDB, or is 3.23.43b _really_ 4.0.1? Tomasz, are you sure you are running 4.0.1? In the rpm of 4.0.0 there were no foreign keys. I tested this on mysql-max-4.0.1, and it worked. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ Speed up adding of features to MySQL/InnoDB through support contracts See http://www.innodb.com for the online manual and latest news on InnoDB ... heikki@hundin:~/mysql-max-4.0.1-alpha-pc-linux-gnu-i686/bin mysql test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.0.1-alpha-max-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB; Query OK, 0 rows affected (0.10 sec) mysql CREATE TABLE child(id INT, parent_id INT, INDEX par_ind (parent_id), - FOREIGN KEY (parent_id) REFERENCES parent(id)) TYPE=INN ODB; Query OK, 0 rows affected (0.00 sec) mysql show table status from test; ++++--++-+- - ---+--+---++-+- - ---+ ++- - -+ | Name | Type | Row_format | Rows | Avg_row_length | Data_length | Max_data_ length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Create_options | Comment | ++++--++-+- - ---+--+---++-+- - ---+ ++- - -+ | child | InnoDB | Fixed |0 | 0 | 16384 | NULL |16384 | 0 | NULL | NULL| NULL | NULL || InnoDB free: 700416 kB; (parent_id) REFER test/pa rent(id) | | parent | InnoDB | Fixed |0 | 0 | 16384 | NULL |0 | 0 | NULL | NULL| NULL | NULL || InnoDB free: 700416 kB | ++++--++-+- - ---+--+---++-+- - ---+ ++- - -+ 2 rows in set (0.03 sec) mysql -Original Message- From: Tomasz Korycki [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Date: Thursday, March 14, 2002 6:53 AM Subject: Re: constraints in InnoDB, or is 3.23.43b _really_ 4.0.1? At 16:57 2002-03-13, Rick Flower wrote: Tomasz writes: From section 16 of http://www.innodb.com/ibman.html you find detailed information about every InnoDB version. For example, 4.0.1 == 3.23.47. Foreign keys should work in 4.0.1. Hmmm... That's what I read, too. And after several unsuccesful attempts to create my own tables, I did those contained on Your site, verbatim (as I put in my original message). Still, no effect. I guess the question then becomes: is 4.0.1 really able to keep track of constraints but unable to show them? In which case, how can one find out what they are (if extant)? Are you sure that you've got a MySQL-Max server, or at least one built with InnoDB support enabled? If you didn't, you might not get an InnoDB table even if you asked for one.. Unfortunately, the SQL parser is somewhat stupid and doesn't bother telling you that you did something dumb or that doesn't make sense in regards to how the server was built.. I've run into things like that numerous times.. SHOW TABLE STATUS sez it's InnoDB... As for listing out the foreign key constraints, that only works if you issue a show table status; for MySQL 3.23.4x, and you will get something like the following REFER statement : OK, which version, exactly, do You get following output from? Oh, never mind, I see it's .47. Which according to Heikki Tuuri of InnoDB is the same as mine... | ITEM | InnoDB | Dynamic| 0 |
SSL
Hi All Do any of you use SSL option in MySQL and if so are there and performance problems when connecting to MySQL? Thanks Simon Green -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 3rd time and last
* ds This is my last mail trying to get an answer from you to those 2 questions. You could at least say: go to the manual or don't know or don't ask it again or something I don't think it is a good idea to reply I don't know or similar... don't know how many readers are on this list, but if everyone replied to all messages the volume would be intolerable. Is the subject boring ?!?!?! No, I think your subjects was ok... except for the current one. :) _ Subject: Default RPMs and RAID support I want to use your binaries (i used to build them in my own machine, but i have followed this list and you're always saying to use yours). You are talking to 'you', ie some mysql employee... (?) This may be a reason for people not responding. Just a question: is there a way of using your binaries and have Table type=RAID support ? From the manual: TYPE = {BDB | HEAP | ISAM | InnoDB | MERGE | MRG_MYISAM | MYISAM } URL: http://www.mysql.com/doc/C/R/CREATE_TABLE.html There is no table type called RAID. This may be a reason not to reply... :) There is however an option called RAID_TYPE, and the manual says this: The RAID_TYPE option will help you to break the 2G/4G limit for the MyISAM data file (not the index file) on operating systems that don't support big files. and RAID_TYPE will work on any OS, as long as you have configured MySQL with --with-raid (same url as above) Subject: An opinion about indexes [...] from users_views2 where cod_campanha in (16,35,72,80,83,86,92,94,107,108,114,115,118,112) I don't have much to say about this, except if this is the normal way to query this database, you should reconsider the design. What does those numbers have in common? Why are exactly those numbers in the list, and not 42, 93 and 111? No matter what the answer is, consider making a new column or maybe even a new table holding this information. -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [bug] MySQLGUI 1.7.5-1 crash with year column type
Alex Vandiver writes: Heya, I've managed to repeatably crash mysqlgui by running a query that returns a column of type year. Though it dumps core, gdb does not provide a useful stack trace. Though this is not a serious bug, it is a bit of an annoyance. - Alex Vandiver -- Networking -- only one letter away from not working. Hi! Yes, this problem is known but is solved in the last version. Please download the latest binary for your OS. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: a quick sanity check...
Konstantin, Thursday, March 14, 2002, 1:04:42 PM, you wrote: KT : denonymous, KT : Wednesday, March 13, 2002, 9:06:48 PM, you wrote: KT : KT : d Hi all -- I just need a quick sanity check on a query. KT : KT : KT : d I have two tables: KT : KT : d CREATE TABLE users ( KT : d userID VARCHAR(10) NOT NULL PRIMARY KEY, KT : d [many other fields] KT : d ) KT : KT : d CREATE TABLE subscriptions ( KT : d userID VARCHAR(10) NOT NULL, KT : d listID INT NOT NULL KT : d ) KT : KT : KT : d In these tables, users.userID == subscriptions.userID. KT : d The users table keeps 1 record per userID, and the subscriptions table KT keep KT : d multiple records per userID (one for each listID to which they're KT : d subscribed). KT : KT : d If I wanted to select all users from the users table that *do not* KT appear in KT : d the subscriptions table, I'd want the following query: KT : KT : d SELECT users.* KT : d FROM users KT : d LEFT JOIN subscriptions KT : d ON users.userID=subscriptions.userID KT : d WHERE subscriptions.userID IS NULL KT subscriptions.userID will never be NULL (the field is created that way). KT maybe a good idea is to let it be NULL so you can tell when there is no KT coresponding record in the users table. Take a closer look at the manual: http://www.mysql.com/doc/J/O/JOIN.html Look at: mysql select * from users; ++ | userid | ++ | egor | | sasha | | vita | ++ mysql select * from subscriptions; +++ | userid | listid | +++ | vita | 1 | | vita | 2 | | masha | 3 | | cate | 4 | +++ 4 rows in set (0.00 sec) mysql select * from users left join subscriptions on users.userid=subscriptions.userid; ++++ | userid | userid | listid | ++++ | egor | NULL | NULL | | sasha | NULL | NULL | | vita | vita | 1 | | vita | vita | 2 | ++++ 4 rows in set (0.01 sec) mysql select users.userid from users left join subscriptions on users.userid=subscriptions.userid where subscriptions.userid is null; ++ | userid | ++ | egor | | sasha | ++ 2 rows in set (0.00 sec) That's all. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
unable to invoke mysql prompt after installation and unable to run mysql_install_db
Unable to invoke mysql prompt after the trial download on sun solaris 2.8 Unix. attaching the error which i got after running the ./scripts/mysql_install_db -- ./scripts/mysql_install_db ld.so.1: ./bin/my_print_defaults: fatal: libz.so: open failed: No such file or directory WARNING: The host 'dbanoc' 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 ld.so.1: /usr/local/mysql/libexec/mysqld: fatal: libpthread.so.1: version `SUNW_1.2' not found (required by file /usr/local/mysql/libexec/mysqld) Killed Installation of grant tables failed! Examine the logs in /usr/local/mysql/var for more information. You can also try to start the mysqld daemon with: /usr/local/mysql/libexec/mysqld --skip-grant You can use the command line tool /usr/local/mysql/bin/mysql to connect to the mysql database and look at the grant tables: shell /usr/local/mysql/bin/mysql -u root mysql mysql show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in /usr/local/mysql/var 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 /usr/local/mysql/bin/mysqlbug script! == --- more dbanoc.err 020313 13:05:54 mysqld started ld.so.1: /usr/local/mysql/libexec/mysqld: fatal: libpthread.so.1: version `SUNW_1.2' not found (required by file /usr/local/mysql/libexec/mysqld) 020313 13:05:54 mysqld ended I would appreciate if you could please let me know the corrective action for the above. Raghu Ramanujam 610 680 2159 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
major performance disparities with mysql/php
Hello Again - I'm posting this again, since it still is an issue that I can not resolve - please help! I've recently installed mySQL on a RH7.2 box without any problems - it runs great. I've been testing some long running queries (full table scans, etc) under different scenarios, and get wildy differing results. Between each test case, I was flushing all tables and re-starting the mysql deamon. When I run one of my longest queries in the mysql command line client, it runs in about 77 seconds. When I run the identical query via PHP running on the box, the same query takes about 930 seconds to complete. For the life of me, I can no figure out why the identical query would run differently from the command line than from PHP. I've repeated this test about 10 times just to be sure - and it is entirely repeatable: command line - about a minute - PHP - about 16 times longer. Any ideas or suggestions? I'm running RH 7.2 (2.4.9-21) on a Dell Poweredge 2550, 1GB memory, RAID, with mysql version 3.23.41 (the standard install unchanged from the RH media). Here is the query...pretty simple: insert into summary_table select frb, denom, series, count(*) as cnt, sum(bills) as bills, sum(bills_hit) as bills_hit, sum(total_hits) as total_hits from detail_table If it a memory/cpu resource problem, how do I set RH to give PHP and Apache the same priority as the mysql deamon? Thanks in advance.. -Hank __ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.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
Please send me urgent reply
fdfghd, Thursday, March 14, 2002, 2:06:05 PM, you wrote: fg I want to access the mysql through C-language. fg Please tell me which files I have to patch , from fg which sites. fg If u can give me any tuitorial that will be great. What about C API for MySQL? You can read about in at: http://www.mysql.com/doc/C/C/C.html fg Please reply me on my Email-Id given below. fg My Email-Id is :- [EMAIL PROTECTED] -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql memory problem
Hi guys, I have a quad Xeon 550 server, 4gb RAM, with a RH Linux 6.2 + patches, kernel 2.4.8 and mysql Ver 11.17 Distrib 3.23.49a. After the start, mysql starts to grow memory usage. It grows until it consumes all machine memory. After a restart it uses only 17Mb of memory, 18 hours latter it is using 415Mb. top: 9735 mysql 9 0 436M 312M 165M S 0.0 8.1 0:00 mysqld 9755 mysql 9 0 436M 312M 165M S 0.0 8.1 0:01 mysqld 9684 mysql 9 0 436M 312M 165M S 4.0 8.1 0:01 mysqld 9733 mysql 9 0 435M 312M 165M S 0.0 8.1 0:00 mysqld 9736 mysql 9 0 435M 312M 165M S 0.0 8.1 0:00 mysqld 9760 mysql 9 0 435M 312M 165M S 0.0 8.1 0:00 mysqld 9685 mysql 9 0 435M 312M 165M S 0.0 8.1 0:02 mysqld 9748 mysql 9 0 435M 312M 165M S 0.0 8.1 0:00 mysqld 9752 mysql 9 0 435M 312M 165M S 0.0 8.1 0:00 mysqld 9765 mysql 9 0 435M 312M 165M S 0.9 8.1 0:00 mysqld 9725 mysql 9 0 435M 312M 165M S 0.0 8.1 0:00 mysqld 9700 mysql 9 0 435M 312M 165M S 0.0 8.1 0:00 mysqld * * thanks Guilherme Bistolfi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: a quick sanity check ++
right, of course ;-) (i neglected the join part) so, now i know exactly whom to ask ;-) i have the following bother (it's in the planning state): i have the idea of setting up a two-way replication system with 2 mysql servers for my radius database. i need them to act interchangeably: 1. if server1 is alive, all selects and updates (radius acct) should go to server1. server2 should act as a slave for server1. 2. if server1 dies, all selects and updates (radius acct) should go to server2. so far, so good. but here comes the tricky (for me) part - when server1 comes up again, it shold do 2 things: a) catch up with server2. b) become master again, leaving server2 as it's slave (same situation as in 1. above). how could this happen ? all ideas are appreciated (pointing to reading - also). kosio - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, 14 March, 2002 14:38 Subject: Re: a quick sanity check... : Konstantin, : Thursday, March 14, 2002, 1:04:42 PM, you wrote: : : KT : d SELECT users.* : KT : d FROM users : KT : d LEFT JOIN subscriptions : KT : d ON users.userID=subscriptions.userID : KT : d WHERE subscriptions.userID IS NULL : : : Take a closer look at the manual: : http://www.mysql.com/doc/J/O/JOIN.html : : mysql select users.userid from users left join subscriptions on users.userid=subscriptions.userid where subscriptions.userid is null; : ++ : | userid | : ++ : | egor | : | sasha | : ++ : 2 rows in set (0.00 sec) : : That's all. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql memory problem
Hi guys, I have a quad Xeon 550 server, 4gb RAM, with a RH Linux 6.2 + patches, kernel 2.4.8 and mysql Ver 11.17 Distrib 3.23.49a. After the start, mysql starts to grow memory usage. It grows until it consumes all machine memory. After a restart it uses only 17Mb of memory, 18 hours latter it is using 415Mb. top: 9735 mysql 9 0 436M 312M 165M S 0.0 8.1 0:00 mysqld 9755 mysql 9 0 436M 312M 165M S 0.0 8.1 0:01 mysqld 9684 mysql 9 0 436M 312M 165M S 4.0 8.1 0:01 mysqld 9733 mysql 9 0 435M 312M 165M S 0.0 8.1 0:00 mysqld 9736 mysql 9 0 435M 312M 165M S 0.0 8.1 0:00 mysqld 9760 mysql 9 0 435M 312M 165M S 0.0 8.1 0:00 mysqld 9685 mysql 9 0 435M 312M 165M S 0.0 8.1 0:02 mysqld 9748 mysql 9 0 435M 312M 165M S 0.0 8.1 0:00 mysqld 9752 mysql 9 0 435M 312M 165M S 0.0 8.1 0:00 mysqld 9765 mysql 9 0 435M 312M 165M S 0.9 8.1 0:00 mysqld 9725 mysql 9 0 435M 312M 165M S 0.0 8.1 0:00 mysqld 9700 mysql 9 0 435M 312M 165M S 0.0 8.1 0:00 mysqld * * thanks Guilherme Bistolfi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Dumping binary data
If a table has a blob type containing binary data, like jpeg images or PDF files for example, can mysqldump be told to encode the data so it is ASCII compatible? (using uuencode or something like that..) I am not sure of the 'right' way to do this, but some informal tests where I dump and reload a table seems to corrupt the binary data. Thanks, -Bob - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
automating mysql command
Hi folks, Let me first say that I am used to using mysql through PHP rather than command line . . . And, as I understand it mysql does not support any sort of timers. I need to use a Unix command like cron to automate either a mysql command or php script to output a selection from a few mysql tables into a comma separated values fixed width text file. Can I just write the mysql commands as a .sql file and tell Unix to execute it? Or is there another way? Andrew Hazen Database Developer Jatech Solutions Inc. 160 Bartley Drive Toronto, ON M4A 1E1 www.jatech.ca 416-288-9833 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 3rd time and last
You said This is my last mail trying to get an answer from you to those 2 questions. You could at least say: go to the manual or don't know or don't ask it again or something Is the subject boring ?!?!?! I reply--- Who is the you you are addressing? This list is a self-help list for MySQL users and enthusiasts. The MySQL team have no obligation at all to provide support on it. Of course, some of the users and enthusiasts are MySQL stagge, who answer questions on a goodwill basis. But, I repeat, there is no obligation for them to do so. If you have a support contract with MySQL, you will have been given an email address upon which they will provide support. You asked Subject: Default RPMs and RAID support I want to use your binaries (i used to build them in my own machine, but i have followed this list and you're always saying to use yours). Just a question: is there a way of using your binaries and have Table type=RAID support ? I reply As I read the documentation, and as I try on my windows machine, no. I think that raid tables are regarded as an obsolecent feature, used by few people and replaced by better features. Options are 1) use an OS which supports 2Gb data files, or 2) use InnoDB table type with multiple InnoDB data bloclks, each of less than 2Gb. Alec Cawley - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error 2002 can't connect to MySQL server through socket /var/lib...
Hello, I work with Suse 7.1 and mysql 3.23.30 gamma. I have killed the mysql settings and so I remove the mysql-RPMs and install mysql 3.23.41 with yast1. Perhaps a mistake, I didn´t reboot the system after removing the RPMs. Then I have same Problems, like: I Funny I still have the same exact problem Egor does. I start mysql with I safe_mysqld, same only server just ends. I do safe_mysqld nothing, I use I mysqld -r root -p password I Nothing I do, that is listed helps. I still have no mysql.sock, and the I server never starts. I do many thinks nothing help. Then I found on my system /usr/share/doc/packages/mysql/README.SuSE. I read it and I remove the RPMs again. Restart the computer. Copy /var/lib/mysql to /backup/var/lib/mysql (or anything else). Remove all Directories and Files in /var/lib/mysql. Start yast1 and install the six RPMs (look README.SuSE). Restart the computer. And MySQL lives again. If you have a similar System, how I, I hope the same procedure will help you. Ciao Oliver Meins - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: automating mysql command
On Thursday, 14. March 2002 15:13, Andrew Hazen wrote: Can I just write the mysql commands as a .sql file and tell Unix to execute it? Or is there another way? When you already use PHP, why don't use php-cli and execute it via cron?! Regards Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [mysql] Multiple WHERE options in SELECT
From: schwingenschloegl jan [EMAIL PROTECTED] i wonder if its possible to perform multiple WHERE statements in one mysql SELECT statement like: SELECT * FROM table WHERE field1=3D'one' AND field2=3D'two' OR field3=3D'three'; it works with as many AND and it works with OR but not together is there something like brackets or other logical opertators Yes, parentheses work fine. This should help you out: SELECT * FROM table WHERE (field1=3D'one' AND field2=3D'two') OR field3=3D'three'; -- denonymous www.coldcircuit.net denonymous.ne.mediaone.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 3rd time and last
and yet there is another novel option to this particular problem. you can pay someone to teach you how to do it. in just about any case where money is in fact exchanging hands, results are expected. then you'd have an actual reason to bitch. jay downs - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, March 14, 2002 9:07 AM Subject: Re: 3rd time and last You said This is my last mail trying to get an answer from you to those 2 questions. You could at least say: go to the manual or don't know or don't ask it again or something Is the subject boring ?!?!?! I reply--- Who is the you you are addressing? This list is a self-help list for MySQL users and enthusiasts. The MySQL team have no obligation at all to provide support on it. Of course, some of the users and enthusiasts are MySQL stagge, who answer questions on a goodwill basis. But, I repeat, there is no obligation for them to do so. If you have a support contract with MySQL, you will have been given an email address upon which they will provide support. You asked Subject: Default RPMs and RAID support I want to use your binaries (i used to build them in my own machine, but i have followed this list and you're always saying to use yours). Just a question: is there a way of using your binaries and have Table type=RAID support ? I reply As I read the documentation, and as I try on my windows machine, no. I think that raid tables are regarded as an obsolecent feature, used by few people and replaced by better features. Options are 1) use an OS which supports 2Gb data files, or 2) use InnoDB table type with multiple InnoDB data bloclks, each of less than 2Gb. Alec Cawley - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: automating mysql command
You sure can do it.. Just put your sql commands into a .sql file and use mysql file.sql syntax to to have them executed by mysql. And you can always use cron in Unix to do it periodically.In your Unix box do: man crontab man cron to learn more about cron jobs. You can also consult to http://www.faqts.com/knowledge_base/view.phtml/aid/1005/fid/436 about cron jobs. Gurhan -Original Message- From: Andrew Hazen [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 9:13 AM To: [EMAIL PROTECTED] Subject: automating mysql command Hi folks, Let me first say that I am used to using mysql through PHP rather than command line . . . And, as I understand it mysql does not support any sort of timers. I need to use a Unix command like cron to automate either a mysql command or php script to output a selection from a few mysql tables into a comma separated values fixed width text file. Can I just write the mysql commands as a .sql file and tell Unix to execute it? Or is there another way? Andrew Hazen Database Developer Jatech Solutions Inc. 160 Bartley Drive Toronto, ON M4A 1E1 www.jatech.ca 416-288-9833 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
glitch or me?
Hi I have 2 SQL fragments that pull up 2 differing results and I have no idea why. The two pieces of code are identical bar one line which is : AND individual_id ='AB00090004' AND Category = 'DXS1047' The code that produces the correct code is: select Raw3_2.category, Raw3_2.Individual_ID, Raw3_2.Inactivate, count(*) as count, min(key_num) as minkey, max(key_num) as maxkey from Raw3_2 where individual_id not like control% and inactivate=0 AND individual_id ='AB00090004' AND Category = 'DXS1047' group by category,Individual_ID,Inactivate gives the CORRECT result below: +--+---++---+-+-+ | category | Individual_ID | Inactivate | count | minkey | maxkey | +--+---++---+-+-+ | DXS1047 | AB00090004| 0 | 3 | 2027223 | 2064251 | +--+---++---+-+-+ Here the count is three, which is correct. When the same code is run but without the line: AND individual_id ='AB00090004' AND Category = 'DXS1047' a fragment of the results is: +--+---++---+-+-+ | category | Individual_ID | Inactivate | count | minkey | maxkey | +--+---++---+-+-+ | DXS1047 | AB00090004| 0 | 1 | 2027223 | 2027223 | +--+---++---+-+-+ | DXS1047 | AB00090004| 0 | 2 | 2063277 | 2064251 | +--+---++---+-+-+ Any ideas why? Any help would be greatly appreciated, Thanks in advance Rich - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
glitch or me?
Hi I have 2 mySQL fragments that pull up 2 differing results and I have no idea why. The two pieces of code are identical bar one line which is : AND individual_id ='AB00090004' AND Category = 'DXS1047' The code that produces the correct code is: select Raw3_2.category, Raw3_2.Individual_ID, Raw3_2.Inactivate, count(*) as count, min(key_num) as minkey, max(key_num) as maxkey from Raw3_2 where individual_id not like control% and inactivate=0 AND individual_id ='AB00090004' AND Category = 'DXS1047' group by category,Individual_ID,Inactivate gives the CORRECT result below: +--+---++---+-+-+ | category | Individual_ID | Inactivate | count | minkey | maxkey | +--+---++---+-+-+ | DXS1047 | AB00090004| 0 | 3 | 2027223 | 2064251 | +--+---++---+-+-+ Here the count is three, which is correct. When the same code is run but without the line: AND individual_id ='AB00090004' AND Category = 'DXS1047' a fragment of the results is: +--+---++---+-+-+ | category | Individual_ID | Inactivate | count | minkey | maxkey | +--+---++---+-+-+ | DXS1047 | AB00090004| 0 | 1 | 2027223 | 2027223 | +--+---++---+-+-+ | DXS1047 | AB00090004| 0 | 2 | 2063277 | 2064251 | +--+---++---+-+-+ Any ideas why? Any help would be greatly appreciated, Thanks in advance Rich - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Couldn´t Performe the edit because another user changer
MySQL Hi all, I am receving this error message sometimes when I tried to update a record. I am using Delphi 3, ODBC connection and TTable object. What I have to do ? Somebody can help me ? Tks, Roberto Alexandre - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 3rd time and last
This has nothing to do with this list... It's just that i'm sorry for the message i sent today, i agree with ppl who answered me and realised i was being..well...you know what. Once again, sorry, i won't do it again and thank you for the answers. -- 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
RE: How to set permissions?
This might not be the best way, but for the people here at my office who aren't familiar with command line interfaces, I've setup MyODBC and MS Access. This let's them add/edit user's account info directly. The only thing you can't do (afaik), is change a user's password. -- Mike Miller -- [EMAIL PROTECTED] -Original Message- From: Yana [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 10:01 AM To: [EMAIL PROTECTED] Subject: RE: How to set permissions? Helo! Is there any other way to set permissions to the list of tables in mysql db (big list!) with similar names (f.e. c%), then running a script on it? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Couldnt Performe the edit because another user changer
The record you want to update is locked by another client. Check return value of your update() What you have to do is approx. the following: while( record_locked) { sleep(...) if( update(...) == OK ) break; } Roberto Freitas Alexandre wrote: MySQL Hi all, I am receving this error message sometimes when I tried to update a record. I am using Delphi 3, ODBC connection and TTable object. What I have to do ? Somebody can help me ? Tks, Roberto Alexandre - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- AK - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Convert ISAM table to MyISAM
Thanks for your help Victoria. Iago. -Mensaje original- De: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Enviado el: jueves 14 de marzo de 2002 11:48 Para: [EMAIL PROTECTED] Asunto: Convert ISAM table to MyISAM Iago, Thursday, March 14, 2002, 10:17:10 AM, you wrote: IS I'm going to upgrade a mysql-3.22 Linux Pentium server to mysql-3.23.49a. IS Which is the best way to convert a database of ISAM table to MyISAM? IS mysqldump? IS How to do it? You can use mysqlcheck or ALTER TABLE statement. You can find example of changing table type from ISAM to MYISAM at: http://www.mysql.com/doc/I/S/ISAM.html IS Iago. -- 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Checking if table empty
I have a strange, but probably easy to fix problem. I need to check to see if something is in a table...that part is easy, but if the table is empty, it doesn't go through my while statement so that I can create something in it. I am sure that if there was something in the table, that I would not be having this problem. Below is my code. --- $searchStmt = SELECT * from division1rank; $stmt= substr($searchStmt, 0, strlen($searchStmt)) ; // Connect to the Database if (!($link=mysql_pconnect($hostName, $userName, $password))) { DisplayErrMsg(sprintf(error connecting to host %s, by user %s, $hostName, $userName)) ; exit() ; } // Select the Database if (!mysql_select_db($databaseName, $link)) { DisplayErrMsg(sprintf(Error in selecting %s database, $databaseName)) ; DisplayErrMsg(sprintf(error:%d %s, mysql_errno($link), mysql_error($link))) ; exit() ; } // Execute the Statement if (!($result =mysql_query($stmt, $link))) { DisplayErrMsg(sprintf(Error in executing %s stmt, $stmt)) ; DisplayErrMsg(sprintf(error:%d %s, mysql_errno($link), mysql_error($link))) ; exit() ; } while (($row = mysql_fetch_object($result))){ if($row-team_id == $team_id){ echo It is in there; }else{ echo We will need to add it to the table; } } } - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
UDF's and Windows
Perhaps this is common knowledge, but is there still no support for UDFs in Windows. If not, are there any work arounds for trying to perform complicated calculations on the server?] Thanks, Craig mysql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
request: mysql install question
After I went through the following steps successfully, (The previous problem I had regarding inability to untar files was solved by downloading stuff on that computer where it was untarred. Before that I was trying to untar stuff downloaded on to a samba share !!!) shell groupadd mysql shell useradd -g mysql mysql shell gunzip mysql-VERSION.tar.gz | tar -xvf - shell cd mysql-VERSION shell ./configure --prefix=/usr/local/mysql shell make shell make install shell scripts/mysql_install_db shell chown -R root /usr/local/mysql shell chown -R mysql /usr/local/mysql/var shell chgrp -R mysql /usr/local/mysql shell cp support-files/my-medium.cnf /etc/my.cnf for shell /usr/local/mysql/bin/safe_mysqld --user=mysql I get, [1] 15387 [root@calamity /root]# Starting mysqld daemon with databases from /usr/local/mysql/var 020314 09:47:12 mysqld ended [1]+ Done/usr/local/mysql/bin/safe_mysqld then when I try to, ./mysqladmin -u root password 'passwd' I get, ./mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! Please advise. I have many more things to do including setting up php and apache. Would also appreciate links to those as well. Also how can I specify RPMs to install to a particular directory like /usr/local/mysql. There was an option, rpm --dbpath path. So could I do a, rpm -Uvh --dbpath /usr/local/mysql rpm then ?? Thanks. _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Files *.TMM and *.TMD
Hi. For what are files with extension .TMM and .TMD? Are residual files of mysqldump? I killed a mysqldump, and I see these files on the directory of the database but I don't know if they were before the mysqldump. Iago. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: constraints in InnoDB, or is 3.23.43b _really_ 4.0.1?
At 01:57 2002-03-14, Heikki Tuuri wrote: Tomasz, are you sure you are running 4.0.1? In the rpm of 4.0.0 there were no foreign keys. I tested this on mysql-max-4.0.1, and it worked. Well... [root@flow11 httpd]# mysqladmin -p version Enter password: mysqladmin Ver 8.23 Distrib 4.0.1-alpha, 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 4.0.1-alpha-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 9 days 6 hours 12 min 44 sec Threads: 1 Questions: 2261 Slow queries: 0 Opens: 108 Flush tables: 1 Open tables: 14 Queries per second avg: 0.003 Best regards, Heikki Tuuri Innobase Oy --- - sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: glitch or me?
* Richard [...] When the same code is run but without the line: AND individual_id ='AB00090004' AND Category = 'DXS1047' a fragment of the results is: +--+---++---+-+-+ | category | Individual_ID | Inactivate | count | minkey | maxkey | +--+---++---+-+-+ | DXS1047 | AB00090004| 0 | 1 | 2027223 | 2027223 | +--+---++---+-+-+ | DXS1047 | AB00090004| 0 | 2 | 2063277 | 2064251 | +--+---++---+-+-+ Any ideas why? Any help would be greatly appreciated, You are not removing the line you say you are removing... this is the expected result when you remove the GROUP BY clause. Check your code... remember that indexed arrays often start at item 0, not item 1... -- Roger query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: How to set permissions?
I have totally different task. I don't want to give users any other privileges but SELECT. But because I use MERGE tables for showing reports to users I must give for these tables UPDATE and DELETE privileges. And here I am talking about several hundreds tables for each user. MySQL doesn't have wild cards for table name field in tables_priv. Otherwise it would be very easy: GRANT ... ON db.ab% for user. The only way I see now is to set privileges for each table for each User manually (I mean script). Do you know any other way? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 10:14 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: How to set permissions? This might not be the best way, but for the people here at my office who aren't familiar with command line interfaces, I've setup MyODBC and MS Access. This let's them add/edit user's account info directly. The only thing you can't do (afaik), is change a user's password. -- Mike Miller -- [EMAIL PROTECTED] -Original Message- From: Yana [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 10:01 AM To: [EMAIL PROTECTED] Subject: RE: How to set permissions? Helo! Is there any other way to set permissions to the list of tables in mysql db (big list!) with similar names (f.e. c%), then running a script on it? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: constraints in InnoDB, or is 3.23.43b _really_ 4.0.1?
At 07:22 2002-03-14, Heikki Tuuri wrote: Tomasz, are you using a non-latin1 character set? No, didn't change the charset. As You can see from my reply to Victoria yesterday, will need to, eventually (for different reasons, though, not books), but right now I am in a proof-of-concept stage: only small tables, easy to change/recreate if I do something stupid. I do not care about charsets, optimization, various other settings in my.cnf. Hm... Maybe that's the problem? Did I miss something? The only thing I changed in my.cnf was adding a larger file for the InnoDB Thanks! sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
VB/MySql/CrystalReport Problem?
Dear folks, Now i try to migrate my Visual Basic Application from MS SQL Server to My SQL, I met problem when my crystal report connect ot My SQL, Below is my code: CrystalReport1.connect = DSN=testDB;uid=amy;pwd=test CrystalReport1.Destination = 0 CrystalReport1.ReportFileName = c:\localfolder\test.rpt sql = select * from score CrystalReport1.SQLQuery = sql CrystalReport1.Action = 1 when execute the last line, Following error message come up: Run-time error: '20534': Error detected by database dll. But when i connect to MS SQL Server, everything work fine. Anybody give me a hand ? __ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.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: automating mysql command
Hi Andrew, Let me first say that I am used to using mysql through PHP rather than command line . . . And, as I understand it mysql does not support any sort of timers. I need to use a Unix command like cron to automate either a mysql command or php script to output a selection from a few mysql tables into a comma separated values fixed width text file. Can I just write the mysql commands as a .sql file and tell Unix to execute it? Or is there another way? =Sure you can. You can either use MySQL or PHP from the command-line: man ref 4.2.8 Connecting to the MySQL Server (alternatively see PHP manual). =Then you can set up the CRON job. =Regards, =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: constraints in InnoDB, or is 3.23.43b _really_ 4.0.1?
Tomasz, I tested also with mysql-4.0.1 and it worked. But are you using a non-latin1 character set? If yes, the bug which was fixed in 3.23.49 might cause the problem. Did you compile MySQL yourself? If yes, what compiler? Please download the official MySQL-Max-3.23.49a binary from www.mysql.com and test it with a freshly created InnoDB database. .49a is the recommended stable version. Regards, Heikki -Original Message- From: Tomasz Korycki [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Thursday, March 14, 2002 5:52 PM Subject: Re: constraints in InnoDB, or is 3.23.43b _really_ 4.0.1? At 01:57 2002-03-14, Heikki Tuuri wrote: Tomasz, are you sure you are running 4.0.1? In the rpm of 4.0.0 there were no foreign keys. I tested this on mysql-max-4.0.1, and it worked. Well... [root@flow11 httpd]# mysqladmin -p version Enter password: mysqladmin Ver 8.23 Distrib 4.0.1-alpha, 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 4.0.1-alpha-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 9 days 6 hours 12 min 44 sec Threads: 1 Questions: 2261 Slow queries: 0 Opens: 108 Flush tables: 1 Open tables: 14 Queries per second avg: 0.003 Best regards, Heikki Tuuri Innobase Oy --- - sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: a quick sanity check ++
At 08:14 2002-03-14, Konstantin Tsolov wrote: right, of course ;-) (i neglected the join part) so, now i know exactly whom to ask ;-) i have the following bother (it's in the planning state): i have the idea of setting up a two-way replication system with 2 mysql servers for my radius database. i need them to act interchangeably: 1. if server1 is alive, all selects and updates (radius acct) should go to server1. server2 should act as a slave for server1. 2. if server1 dies, all selects and updates (radius acct) should go to server2. so far, so good. but here comes the tricky (for me) part - when server1 comes up again, it shold do 2 things: a) catch up with server2. b) become master again, leaving server2 as it's slave (same situation as in 1. above). how could this happen ? all ideas are appreciated (pointing to reading - also). Try here, since You are already thinking of using 2 machines: http://linux-ha.org/LinuxFailSafe/ Works rather well with IP, MAC and Oracle/SAP failover. I believe there is a driver for MySQL, if not You shouldn't t have much trouble writing one, examples are provided. It's all open source, same code _base_ as IRIX FailSafe (HA on SGI machines for the past 7? years). Since this is really off-topic, if You have any further questions, You probably should ask me off the list. I would only suggest using either DRBD or shared-SCSI for storage. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Stop query after first match
Danny, Wednesday, March 13, 2002, 2:30:10 PM, you wrote: DK I'd like to know how I can do the following: DK I want to query a single table like this: DK select field1, field2, field3 from table1 where field1='something' and DK field2=0; DK This query will result in more then one match. It's not possible for me to DK use a more specific query. DK From the result I only need the first hit. All the other rows are not DK important. (e.g. I get 100 rows back, but I only need 1) DK So my question: DK How can I stop the query on the first match and return the result of that DK match and prevent the query from fetching all matching records (and limit DK the results afterwards by using LIMIT 1). This is mainly for boosting the DK performance of mys queries. DK Actually where using mysql to dynamically assign ip addresses to our DK dial-in users. We query the database for available addresses - there are DK more than 1 available but I only need 1! Why don't you use only LIMIT 1 clause to get just one row? DK Thanks in advance! DK Danny Kruitbosch -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: How to set permissions?
Yana, Thursday, March 14, 2002, 5:00:40 PM, you wrote: Y Helo! Y Is there any other way to set permissions to the list of Y tables in mysql db (big list!) with similar names (f.e. c%), Y then running a script on it? No, it's impossible. You should use database name, table name etc or '*' to specify all databases, tables etc. Read about GRANT statement syntax at: http://www.mysql.com/doc/G/R/GRANT.html Y Thanks -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Checking if table empty
Thank You. This did the trick. I knew that it had to be something simple. I wasn't even thinking of a if(!$row) statement. Steve At 10:05 AM 3/14/2002, you wrote: - Original Message - From: Steve Buehler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, 14 March, 2002 17:46 Subject: Checking if table empty : I have a strange, but probably easy to fix problem. I need to check to see : if something is in a table...that part is easy, but if the table is empty, : it doesn't go through my while statement so that I can create something : in it. I am sure that if there was something in the table, that I would : not be having this problem. Below is my code. : : --- : $searchStmt = SELECT * from division1rank; : : $stmt= substr($searchStmt, 0, strlen($searchStmt)) ; : : // Connect to the Database : if (!($link=mysql_pconnect($hostName, $userName, $password))) { :DisplayErrMsg(sprintf(error connecting to host %s, by user %s, : $hostName, $userName)) ; :exit() ; : } : : // Select the Database : if (!mysql_select_db($databaseName, $link)) { :DisplayErrMsg(sprintf(Error in selecting %s database, $databaseName)) ; :DisplayErrMsg(sprintf(error:%d %s, mysql_errno($link), : mysql_error($link))) ; :exit() ; : } : : // Execute the Statement : if (!($result =mysql_query($stmt, $link))) { :DisplayErrMsg(sprintf(Error in executing %s stmt, $stmt)) ; :DisplayErrMsg(sprintf(error:%d %s, mysql_errno($link), : mysql_error($link))) ; :exit() ; : } : substitute while (($row = mysql_fetch_object($result))){ with this here: ---cut-- $row = mysql_fetch_object($result); if (! $row) { // table empty } while ($row) { ---cut-- : if($row-team_id == $team_id){ : echo It is in there; : }else{ : echo We will need to add it to the table; : } and add this here: ---cut-- $row = mysql_fetch_object($result); ---cut-- : } : } : : : - : Before posting, please check: :http://www.mysql.com/manual.php (the manual) :http://lists.mysql.com/ (the list archive) : : 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: UDF's and Windows
OK. So I just read in CHANGES FOR 3.23.37 (patch by Ralph Mason) that there is now support for UDFs in Windows . So anyone know where I might find some Windows specific examples (or info) on them? Thanks, Craig At 09:47 AM 3/14/2002 -0600, you wrote: Perhaps this is common knowledge, but is there still no support for UDFs in Windows. If not, are there any work arounds for trying to perform complicated calculations on the server?] Thanks, Craig mysql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Case sensitivity in Mysql
At 02:05 AM 3/14/2002, you wrote: Hi, I run mysql on windows as well as linux. table creation and access right are given by java program. Problem im facing is., i create a table with name TEMP in windows in creates table with name temp and linux TEMP while giving rights thru GRANTstatement , it fails in windows cause it expect TEMP not temp How can i create table name with upper case in Windows create table TEMP ( x varchar(6), y varchar(6)) this creates a table with name temp..not TEMP help me with mysql Anis, Talking from experience, it is best to create all database names and table names in lower case. It will prevent a lot of grey hairs in the future. You can have upper and lower case column names, but I also put them in lower case to avoid mistyping the case of a letter. If you keep everything in lowercase, life will be much easier. Brent Why or why couldn't MySQL have used case insensitive names in the first place? Store everything in lower case internally, but allow the user to use Invoice_Number or invoice_number or INVOICE_NUMBER in the SQL statement and it should refer to the same column. Same with table names. I don't see why you would want to have 3 different columns in the same table with names Invoice_Number, invoice_number and INVOICE_NUMBER. Maybe it's just me, but it doesn't make a lot of sense to have case insensitive names. It just leads to typos and the code doesn't run. :-( _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Checking if table empty
as you said, the table is empty. mysql_fetch_object should return NULL. that's why the block in the while statement doesn't got executed. while (($row = mysql_fetch_object($result))){ if($row-team_id == $team_id){ echo It is in there; }else{ echo We will need to add it to the table; } } i guess this is what you're trying to do: $searchStmt = SELECT 1 from division1rank where team_id = $team_id; //i'd prefer using bind variable here ... snipped ... if ($row = mysql_fetch_object($result)) { echo It is in here; } else { echo We'll need to add it to the table. } i hope this will help - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL as database for AutoCAD
Has anyone used MySQL as the datasource for AutoCAD? Specifically AUTODESK MAP? Autodesk lists as a capability: # Link to ODBC-compliant databases including Microsoft Access, Excel, Oracle, dBase, FoxPro, Paradox, and SQL Server. Sounds like MAP _should_ work with MyODBC. Has anyone tried this? Thanks Hudson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
root user Access Denied
I am trying to set up MyODBC on a Win2K box to access MySQL on a Linux machine. I am getting an error message that says my host is not allowed to connect. I then tried to run a GRANT query under the mysql on the Linux machine to create a valid user in the hosts table. I am using version 3.22.32 and logged in as root. When I try to perform a GRANT statement, I get the error message ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) Any ideas why root is not allowed rights? How do I give root user root access? Did I set up mysql incorrectly from the start? The root user seems to be able to do everything else. Rob - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Case sensitivity in Mysql
On Thursday 14 March 2002 9:32 am, BD wrote: Why or why couldn't MySQL have used case insensitive names in the first place? Store everything in lower case internally, but allow the user to use Invoice_Number or invoice_number or INVOICE_NUMBER in the SQL statement and it should refer to the same column. Same with table names. I don't see why you would want to have 3 different columns in the same table with names Invoice_Number, invoice_number and INVOICE_NUMBER. Maybe it's just me, but it doesn't make a lot of sense to have case insensitive names. It just leads to typos and the code doesn't run. :-( In SQL92, identifiers can only be uppercase letters and numerals. Therefore, if you are using lowercase, you are NOT writing valid SQL92. Most databases will allow this, of course. SQL99 adds support for lowercase characters but MySQL doesn't claim to implement SQL99 yet. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: New MySQL user question: record security
Hi All; I have just recieved a request to build a database using mySQL and I have a bit of a dilemma. The database is to be used for relations between politicians and their constituents, and I have to have tables for constituents and their information. I would like to have one main database and not seperate databases for each politician, but I would like to make sure that they can only see information on THEIR OWN constituants and not the constituants of their competitors. Is there any way to grant permissions only where the constituency matches theirs? I can do this easily enough through the application, but I would like to extend such security to the database itself. Mike Hillyer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
manip.cc
is anyone getting errors when trying to install mysql++, after installing the patch for gcc3? i've gotten a flood of errors which i've fixed, step by step, by adding std:: to various variables. manip.cc is spitting out error messages like this one: manip.cc:141:choosing 'std::basic_ostreamchar,_Traitsstd:operator(std::basic_ostreamchar,_Traits,const char'). i suspect this has something to do with namespace, but i haven't been able to figure it out... thanks a lot. p - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: VB/MySql/CrystalReport Problem?
IMHO - I would use ADO over the MyODBC layer to retrieve disconnected recordsets representing your report data from MySQL, then pass said adors to Crystal Report's viewer. To learn more about this approach, search seagate.com for ado disconn. rs, which utilizes ttx files (tab delimited text files) to create the report in design view. hth Chris mcdba mcse www.mydba2000.com From: yue cheng [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: VB/MySql/CrystalReport Problem? Date: Thu, 14 Mar 2002 08:09:57 -0800 (PST) Dear folks, Now i try to migrate my Visual Basic Application from MS SQL Server to My SQL, I met problem when my crystal report connect ot My SQL, Below is my code: CrystalReport1.connect = DSN=testDB;uid=amy;pwd=test CrystalReport1.Destination = 0 CrystalReport1.ReportFileName = c:\localfolder\test.rpt sql = select * from score CrystalReport1.SQLQuery = sql CrystalReport1.Action = 1 when execute the last line, Following error message come up: Run-time error: '20534': Error detected by database dll. But when i connect to MS SQL Server, everything work fine. Anybody give me a hand ? __ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.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 _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Making UPDATE return the no. of rows matched
At 10:41 +0100 3/14/02, Rune Steinseth wrote: Hi all, I have changed database for my Java app to MySQL. The app was developed with SQL Server. Some of the logic is dependent on getting the no. of rows updated returned after an UPDATE query. MySQL does only return the rows that are really updated, not the rows matched of an UPDATE. This causes problems. Is there an easy way to get MySQL always return the number of rows matched in an UPDATE? There's a flag you can set to control this when connecting to the MySQL server, if you're using the C API or the Perl DBI API. I don't think there's an option for this in Java, at least if you're using the MM.MySQL driver. It seems to set the CLIENT_FOUND_ROWS flag unconditionally. I guess you could change the source and recompile. Regards, Rune Steinseth __ Sjekk snørapporter... fra 500 ski-destinasjoner i Europa på http://no.snow.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
root user Access Denied
Rob, Thursday, March 14, 2002, 7:01:02 PM, you wrote: RQ I am trying to set up MyODBC on a Win2K box to access MySQL on a Linux machine. I am getting an error message that says my host is not allowed to connect. I then tried to run a GRANT query RQ under the mysql on the Linux machine to create a valid user in the hosts table. RQ I am using version 3.22.32 and logged in as root. When I try to perform a GRANT statement, I get the error message ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) RQ Any ideas why root is not allowed rights? How do I give root user root access? Did I set up mysql incorrectly from the start? The root user seems to be able to do everything else. You can use GRANT statement if you set GRANT OPTION for your user. So it looks like that your mysql user don't have privileges to set grants. Show me the output of the following: SHOW GRANTS FOR 'username'@'hostname'; RQ Rob -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Using MySQL with Mingw32
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi: I'm using MySQL 3.2.3.39 for Win98. Has anybody been able to develop applications using Mingw32 compiler? If so, where can I get a version of the libmysqlclient library that will work with this compiler? Thank you. - -- Alfredo J. Cole http://www.acyc.com (Accounting Systems) http://www.clshonduras.com (Linux Hardware) PGP Key available from certserver.pgp.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.5 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE8kOWAu5DxuPWE298RAss1AJ99zdbTZHb4Nlc6ED++J6WsQu9+UgCfX/vZ EB+WU6RiQYPZLVJot6s8oHw= =WMmW -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
innodb or Berkeley DB default for mysql max
What is the default table engine used in the binary version of mysql-max -- innodb or Berkeley? If not innodb, how do I get the innodb to be the default? Can someone point me to the manual section? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Invalid Duplicate Key 1062 Error
Product : MySql Version : 3.23.45 Error : Invalid duplicate key error for large numeric primary key's Description --- When a large numeric primary key is created ID NUMERIC(38) PRIMARY KEY (ID) And you insert two records with different Id's ID1= 17001 ID2= 17002 You get an error 1062 : Duplicate Key Diagnosis --- I noticed that this problem only happens when you insert keys greater than 19 chars which is around the maximum size of a long. I thought it might be possible that the key comparison was being done using a field that was not large enough to handle the data for that column. Michael Connor __ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.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
Linux 7.1 Professional MySQL startup.
Hi: Installed the following packages (with no errors) from the Red Hat Linux V7.1 RPM files. It installed MySQL3 3.23.36-1, MySQL-devel3.23.36-1, MySQL-Server3.23.36-1, and MySQLclient9.3.23.22.4. However, following instructions, I typed in, at the command line, mysql and received the following error message Error 2002 Can't connect to local MySQL server through socket /var/likb/mysql/mysql.sock (2). I'm sure that I'm not the first to have this problem, but bad luck does tend to follow me. Also, I downloaded the manual and I can't find anything in there discussing the MySQLclient application. Can anyone tell me how its used, when it can be used, etc. Thank you in advance Joe Krusick[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: Changing Default for Not Null to NOTHING
ok, more specific: here is a table: CREATE TABLE FOO (foo1 int NOT NULL, foo2 int NOT NULL Default 1) If I do an insert into the FOO table with the following: INSERT INTO FOO (foo1,foo2) VALUES (1,1) Everything works as planned. If I do an insert into the FOO table with the following: INSERT INTO FOO (foo1) VALUES (1) Everything works as planned If I do an insert into the FOO table with the following: INSERT INTO FOO (foo2) VALUES (1) I want an error. But what happens is that the db engine explicitly defines a default of 0 to the foo1 column even though I defined it as int NOT NULL and did not give it a default. After I change the configuration with the following: CXXFLAGS=-DDONT_USE_DEFAULT_FIELDS ./configure and re-create my table in a new database, I do get an error on INSERT INTO FOO (foo2) VALUES (1) because I didn't give a value for foo1, but I also get an error on this: INSERT INTO FOO (foo1) VALUES (1) even though I have explicitly defined a default for foo2. So. What I want: No default unless I define one Error on NOT NULL if I don't define a default Default inserted if NOT NULL and I define a default and I don't specify a value in an insert statement Does this make more sense? Thanks, David - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 13, 2002 6:54 AM Subject: Re: Changing Default for Not Null to NOTHING David, Friday, March 08, 2002, 11:03:30 PM, you wrote: DMP I just tried something and would a second opinion: DMP I re-configured my MySQL server on my RH Linux machine using the following : DMP CXXFLAGS=-DDONT_USE_DEFAULT_FIELDS ./configure DMP and ran the following SQL: DMP CREATE TABLE FOO (foo int NOT NULL DEFAULT 5, foo1 INT NULL); DMP INSERT INTO FOO (foo1) VALUES (1); DMP MySQL-Error: DMP == DMP 1048 - Column 'foo' cannot be null. DMP So is it true that you either have an installation of MySQL that will have DMP defaults for NOT NULL defined columns (explicity or implied) or you can have DMP an installation that does not allow default values for NOT NULL defined DMP columns? Yes, if you specify CXXFLAGS=-DDONT_USE_DEFAULT_FIELDS ./configure you will have errors in INSERT statements for NOT NULL columns inserting NULL values. DMP What I want is to be able to create a table that has columns defined as NOT DMP NULL and if I don't assign a default to that column, I want an error if I DMP don't give it a value on insert. What I DON'T want is to define a column as DMP NOT NULL with NO EXPLICIT DEFAULT to get a value if it is left out of an DMP insert statements list of column/value set. DMP Does this make sense?? Looks like it does but try to be more clear. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Quits in Replication
We are having a serious problem with a simple replication setup using MySQL. One small database with 12 tables is being replicated one way - one master, one slave. Write transaction load is small, about 1 record per second, usually on only one of the tables. Read load is also light. The replication starts out fine. However, after a few hours the mysql daemon on either the master or the slave just quits. No error is logged. No core dump. It just quits. As far as we can tell, nothing special is going on with the system at the time the mysql daemon quits. For example, yesterday, we did a fresh install at about 3:30 pm. At about 7:05 pm the master mysql daemon quit. We restarted it and about 9:30 am this morning the slave mysql daemon quit. ??? Systems using the same versions, but without replication, have never experienced a loss of the mysql daemon. The entire daemon quits? That's not something I've ever run across, and it seems even stranger with the fact that both the master and the slave have done it. Yes, mysqld disappears. Poof! Have you checked both the mysql error logs and the replication logs? The replication logs should be in the MySQL data directory. When a slave stops replication, that's where the last known error is logged, and usually sheds insight into *that* problem. Nothing in the MySQL error logs. Don't know what you are refering to as the replication log. There is no binlog for the slave and there are no other logs in the data directory or log directory. Is this something that has to be enabled? Al __ Al Johnson Network Storage Solutions voice 865.675-4070 ext 2 cell 865.604.5869 [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: Linux 7.1 Professional MySQL startup.
Hi Joe, On Thu, 14 Mar 2002 11:00:33 -0800 Joe Krusick [EMAIL PROTECTED] wrote: Hi: Installed the following packages (with no errors) from the Red Hat Linux V7.1 RPM files. It installed MySQL3 3.23.36-1, MySQL-devel3.23.36-1, MySQL-Server3.23.36-1, and MySQLclient9.3.23.22.4. However, following instructions, I typed in, at the command line, mysql and received the following error message Error 2002 Can't connect to local MySQL server through socket /var/likb/mysql/mysql.sock (2). I'm sure that I'm not the first to have this problem, but bad luck does tend to follow me. You haven't started the MySQL server. Try this as root: # /etc/rc.d/init.d/mysqld start --bk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem in Instalation DBD-mysql-2.1011
Hi: I work with Linux Cobalt (identic to RedHAT), gcc-2.7.2 and MySQL-3.22.32-1. I need install DBD-mysql-2.1011, but I received the next error in the instalation: (I execute make): rm -f blib/arch/auto/DBD/mysql/mysql.so LD_RUN_PATH=/usr/lib/mysql:/usr/lib /sbin/perl myld cc -shared -L/usr/local/lib dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.so -L/usr/lib/mysql -lmysqlclient -lz chmod 755 blib/arch/auto/DBD/mysql/mysql.so chmod: blib/arch/auto/DBD/mysql/mysql.so: No such file or directory make: *** [blib/arch/auto/DBD/mysql/mysql.so] Error 1 I can't upgrade my system. Are there any module that work with this feature?... What 's the problem? Regards, Roberto C. Salazar M. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: replication through port forwarded firewall
John Hunter wrote: I have a mysql server behind a firewall. The firewall forwards port 3306 requests to the server, so the outside world can use it. I want to replicate this database with a slave outside the firewall. So the slave would request port 3306 on the firewall, but get the internal server instead. My concern is about the machine names. The slave thinks the master server is named eg, master.name.com, but the master server thinks it is named master.internal.domainname. So I am wondering if this will muck things up. No. Just have the slave connect to the master using the ip address. Has anyone done this before? Certainly. Thanks, John Hunter Regards, Van -- = Linux rocks!!! http://www.dedserius.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
ARG! Anyone using webmin on Solaris to manage MySQL?
I have tried the last 10 releases of webmin and cannot get it to work with MySQL. I have a standard install of Mysql 3.23 into /usr/local/mysql. Webmin keeps complaining that it cannot find the libraries. The MySQL libraries are here: /usr/local/mysql/lib/mysql I have set that path both in the config and LD_LIBRARY_PATH. I have tried copying all the mysql libs to /lib and pointing to them there. Nothing has worked. Anyone have better luck on Solaris 8? (I have tried this on 4 Solaris 8 systems) Thanks, CC - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: replication through port forwarded firewall
Treat the master and slave as if the firewall wasn't there. It shouldn't be any different than a router. The outside computer shouldn't care what it is called on the internal network. If that's not fact, then its my strong opinion :) -Original Message- From: John Hunter [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 2:36 PM To: MySQL mailing list Subject: replication through port forwarded firewall I have a mysql server behind a firewall. The firewall forwards port 3306 requests to the server, so the outside world can use it. I want to replicate this database with a slave outside the firewall. So the slave would request port 3306 on the firewall, but get the internal server instead. My concern is about the machine names. The slave thinks the master server is named eg, master.name.com, but the master server thinks it is named master.internal.domainname. So I am wondering if this will muck things up. Has anyone done this before? Thanks, John Hunter Master: mysql Ver 11.13 Distrib 3.23.36, for redhat-linux-gnu (i386) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Quits in Replication
From: Al Johnson [EMAIL PROTECTED] Nothing in the MySQL error logs. Don't know what you are refering to as the replication log. There is no binlog for the slave and there are no other logs in the data directory or log directory. Is this something that has to be enabled? I was referring to the slave's replication binlogs, but it appears you don't have them (they'd be on the slave in the MySQL data directory, afaik). I don't know much about replication setup, I'm only going by our setup here. Sorry I can't be of more help! -- denonymous www.coldcircuit.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Case sensitivity in Mysql
At 11:17 AM 3/14/2002, you wrote: On Thursday 14 March 2002 9:32 am, BD wrote: Why or why couldn't MySQL have used case insensitive names in the first place? Store everything in lower case internally, but allow the user to use Invoice_Number or invoice_number or INVOICE_NUMBER in the SQL statement and it should refer to the same column. Same with table names. I don't see why you would want to have 3 different columns in the same table with names Invoice_Number, invoice_number and INVOICE_NUMBER. Maybe it's just me, but it doesn't make a lot of sense to have case insensitive names. It just leads to typos and the code doesn't run. :-( In SQL92, identifiers can only be uppercase letters and numerals. Therefore, if you are using lowercase, you are NOT writing valid SQL92. Most databases will allow this, of course. SQL99 adds support for lowercase characters but MySQL doesn't claim to implement SQL99 yet. I don't mind switching to uppercase entities if it means I won't have to be on the lookout for the SQL police. The next knock on the door could be SQL police coming to confiscate my database or levy heavy fines. :-) (Don't laugh. I don't know if you know this or not, but in Quebec there are language laws preventing store owners from having English only signs or signs where the English text is larger than the French text. The English text must be smaller than the French text otherwise the language police will come knocking on your door and will force you to take the sign down or fine you. The people who refuse end up in court. I hope the ANSI standards committee isn't listening because I could be in big trouble!) Seriously though, you're right, the table and column names should be in uppercase. It is strange though the MySQL related books I've read have kept table and column names to lower case, maybe because they're easier to read. (Hey, maybe I'll blame this on Paul.bg) I only wish MySQL could have the case insensitive names. I see no point in having case sensitive table and column names. Brent (Oops.. I've got to go. There is someone knocking on the door...) _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: problem in telent to mysql server
Can you telnet into anything else? How about a webserver? Try port 80 or 25 if you have a mail server. If you can't, you need to make sure you have telnet rights -Original Message- From: Jianping Zhu [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 1:58 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: problem in telent to mysql server I use: telnet mysqlserverhostname 3306 and get following response: Host 'mylocalcomputer' is not allowed to connect to this MySQL server What does this mean? and how to fix the problem? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem in telent to mysql server
At 14:58 -0500 3/14/02, Jianping Zhu wrote: I use: telnet mysqlserverhostname 3306 and get following response: Host 'mylocalcomputer' is not allowed to connect to this MySQL server What does this mean? and how to fix the problem? The MySQL client-server protocol is a binary protocol. It makes no sense to telnet to the server. Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: root user Access Denied
Show me the output of the following: SHOW GRANTS FOR 'username'@'hostname'; output: mysql show grants for 'root@localhost'; ERROR 1064: You have an error in your SQL syntax near 'grants for 'root@localhost'' at line 1 I noticed that my user table doesn't seem to have all the fields it should. I upgraded from an older version of mysql back in November. There are 4 fields missing (Grant_priv, References_priv, Index_priv, Alter_priv). I just read on www.mysql.com that I need to run mysql_install_db. I assume this will alter the table structure to include the new fields, but will it also mess up my previously defined users? Rob Egor Egorov [EMAIL PROTECTED] 03/14/02 12:08PM Rob, Thursday, March 14, 2002, 7:01:02 PM, you wrote: RQ I am trying to set up MyODBC on a Win2K box to access MySQL on a Linux machine. I am getting an error message that says my host is not allowed to connect. I then tried to run a GRANT query RQ under the mysql on the Linux machine to create a valid user in the hosts table. RQ I am using version 3.22.32 and logged in as root. When I try to perform a GRANT statement, I get the error message ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) RQ Any ideas why root is not allowed rights? How do I give root user root access? Did I set up mysql incorrectly from the start? The root user seems to be able to do everything else. You can use GRANT statement if you set GRANT OPTION for your user. So it looks like that your mysql user don't have privileges to set grants. Show me the output of the following: SHOW GRANTS FOR 'username'@'hostname'; RQ Rob -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: problem in telent to mysql server
On Thu, 14 Mar 2002, Todd Williamsen wrote: telbet to webserer is OK, I use telnet thesamename 80 get following messge !DOCTYPE HTML PUBLIC -//IETF//DTD HTML 2.0//EN HTMLHEAD TITLE501 Method Not Implemented/TITLE /HEADBODY H1Method Not Implemented/H1 M to /inde .htm not supported.P Invalid method in request MP HR ADDRESSApache/1.3.2 Server at A HREF=mailto:root@localhost;_default_/A Port 80/ADDRESS /BOD /HTML Can you telnet into anything else? How about a webserver? Try port 80 or 25 if you have a mail server. If you can't, you need to make sure you have telnet rights -Original Message- From: Jianping Zhu [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 1:58 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: problem in telent to mysql server I use: telnet mysqlserverhostname 3306 and get following response: Host 'mylocalcomputer' is not allowed to connect to this MySQL server What does this mean? and how to fix the problem? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Jianping Zhu Department of Computer Science Univerity of Georgia Athens, GA 30602 Tel 706 5423900 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 on OSF1
While doing make on a Dec 3000 OSF1 V4.0 I got the following error: echo timestamp linked_libmysql_r_sources make all-recursive No Suffix list Making all in include No suffix list. Make: % rule can only use a single ''/ Stop. Exit 1 There currently isn't a y2k patch installed. I haven't been able to find one, so the computer currently thinks it's 1996, I found that that messed up the gcc install, but I never got an error like this during that. I untarred the package with tar -xmf filename so that it would set the time to the system time. Any Ideas? Please forward responses to [EMAIL PROTECTED] Thanks for your time Cj B - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: problem in telent to mysql server
I didn't realize you were trying to telnet to a client. You cannot do that. You need to telnet to the SERVER. Whatever the server is You need to make sure the user you are trying to use has access rights for the user for telnet -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 2:19 PM To: Jianping Zhu Cc: [EMAIL PROTECTED] Subject: Re: problem in telent to mysql server At 14:58 -0500 3/14/02, Jianping Zhu wrote: I use: telnet mysqlserverhostname 3306 and get following response: Host 'mylocalcomputer' is not allowed to connect to this MySQL server What does this mean? and how to fix the problem? The MySQL client-server protocol is a binary protocol. It makes no sense to telnet to the server. Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: character encoding problems with org.gjt.mm.mysql jdbc1.0
lol list spam filter is quite severe sql, query - Original Message - From: Sylvain Hamel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 14, 2002 3:47 PM Subject: character encoding problems with org.gjt.mm.mysql jdbc1.0 environment : java jdbc, with MM driver, jdk 1.3.1-b24 This problem only occurs on some linux machines. I havent been able to pinpoint the cause. My problem is that I have to put ?useUnicode=truecharacterEncoding=ISO8859-1 at the end of the connection string otherwise i will have to force iso encoding like this String(rs.getBytes(columnname),ISO8859-1) in order to get (french) accented characters instead of question marks(?). The strange part is that phpMyAdmin seems to handle accented characters fine on these servers and a simple page displaying out.println(èèè) will also display correctly in the browser from tomcat. I assume the driver is causing this problem but I cant seem to find out why. Can anybody help? Sylvain - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Re: where are my.cnf anf mysql log file.
I don't know if this will help you but try this: # mysqld --help | grep dir: basedir: / datadir: /var/lib/mysql/ tmpdir: /tmp/ So, you'll find mysql log files in your datadir (is this case, /var/lib/mysql/). my.cnf is usually at /etc/my.cnf If you don't have it, find a configuration sample file: # find your_basedir -name my*.cnf and copy one (which is better for you) to /etc/. Maybe there are better ways to do this... But i think this will do the trick. On Thu, 2002-03-14 at 17:56, Jianping Zhu wrote: I installed following two files MySQL-VERSION.i386.rpm MySQL-client-VERSION.i386.rpm but I can not fild my.cnf and mysql log files. Why? Thanks Jianping Zhu Department of Computer Science Univerity of Georgia Athens, GA 30602 Tel 706 5423900 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- 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
RE: problem in telent to mysql server
At 14:46 -0600 3/14/02, Todd Williamsen wrote: I didn't realize you were trying to telnet to a client. You cannot do that. You need to telnet to the SERVER. Whatever the server is He *is* telnet-ing to the server (port 3306 is the server port). But it doesn't make sense. A Web server might be willing to speak ASCII to you. The MySQL server is not. You need to make sure the user you are trying to use has access rights for the user for telnet -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 2:19 PM To: Jianping Zhu Cc: [EMAIL PROTECTED] Subject: Re: problem in telent to mysql server At 14:58 -0500 3/14/02, Jianping Zhu wrote: I use: telnet mysqlserverhostname 3306 and get following response: Host 'mylocalcomputer' is not allowed to connect to this MySQL server What does this mean? and how to fix the problem? The MySQL client-server protocol is a binary protocol. It makes no sense to telnet to the server. Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Upgrading to InnoDB tables
Hi, We have Mysql standard distribution (ver 3.23.32) for Solaris and we just realised that we needed InnoDB support. What would be the easiest way to add InnoDB table type? Is it possible to do it without affecting the tables and databases that are already present. thanks, Sanjay Chigurupati __ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.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: problem in telent to mysql server
Thanks for your advices. In the offical mysql webpage, there is a paragraph tell us how to usinng telnet test mysql server connectivity. --- http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html If you get the error message Can't connect to MySQL server on some_hostname, you can try the following things to find out what the problem is : Check if the serveis up by doing telnet your-host-name tcp-ip-port-number and press Enter a couple of times. If there is a MySQL server running on this port you should get a responses that includes the version number of the running MySQL server. If you get an error like telnet: Unable to connect to remote host: Connection refused, then there is no server running on the given port. - Why i do this test is because I have trouble to use jdbc to connect to mysql server and i am afraid that my mysql server is not configureed properly. (I have redhat 7.2 os) On Thu, 14 Mar 2002, Paul DuBois wrote: At 14:46 -0600 3/14/02, Todd Williamsen wrote: I didn't realize you were trying to telnet to a client. You cannot do that. You need to telnet to the SERVER. Whatever the server is He *is* telnet-ing to the server (port 3306 is the server port). But it doesn't make sense. A Web server might be willing to speak ASCII to you. The MySQL server is not. You need to make sure the user you are trying to use has access rights for the user for telnet -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 2:19 PM To: Jianping Zhu Cc: [EMAIL PROTECTED] Subject: Re: problem in telent to mysql server At 14:58 -0500 3/14/02, Jianping Zhu wrote: I use: telnet mysqlserverhostname 3306 and get following response: Host 'mylocalcomputer' is not allowed to connect to this MySQL server What does this mean? and how to fix the problem? The MySQL client-server protocol is a binary protocol. It makes no sense to telnet to the server. Thanks Jianping Zhu Department of Computer Science Univerity of Georgia Athens, GA 30602 Tel 706 5423900 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: problem in telent to mysql server
Thanks for your advices. In the offical mysql webpage, there is a paragraph tell us how to usinng telnet test mysql server connectivity. That test tells you only whether or not there's a MySQL server listening on the port. It doesn't tell you that you should actually try to communicate with the server in any way. If the server is running and you're having problems establishing a connection to it using a program that actually uses a client-server API (like a JDBC driver), then the problem is that the grant tables don't have an entry for the MySQL user and password that you're supplying. You might find it easier to perform your testing by using the mysql client program from the command line. --- http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html If you get the error message Can't connect to MySQL server on some_hostname, you can try the following things to find out what the problem is : Check if the serveis up by doing telnet your-host-name tcp-ip-port-number and press Enter a couple of times. If there is a MySQL server running on this port you should get a responses that includes the version number of the running MySQL server. If you get an error like telnet: Unable to connect to remote host: Connection refused, then there is no server running on the given port. - Why i do this test is because I have trouble to use jdbc to connect to mysql server and i am afraid that my mysql server is not configureed properly. (I have redhat 7.2 os) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqld dies on MATCH query using IN BOOLEAN MODE
Description: When I run a MATCH query against a full-text index using the IN BOOLEAN MODE option, the mysqld server crashes. How-To-Repeat: see the information below Fix: I haven't figured it out yet. Submitter-Id: none Originator:Owen Borseth Organization: SnapNames.com, Inc. MySQL support: none Synopsis: mysqld dies on MATCH query using IN BOOLEAN MODE Severity: serious Priority: high Category: mysql Class: bug Release: mysql-4.0.1-alpha (Official MySQL binary) Environment: Dual P-III 1GHz System: Linux windmill 2.4.17 #3 SMP Wed Feb 27 12:10:33 PST 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-slackware-linux/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='-O3 -mpentium ' CXX='gcc' CXXFLAGS='-O3 -mpentium -felide-constructors' LDFLAGS='-static' LIBC: lrwxrwxrwx1 root root 13 Dec 17 10:54 /lib/libc.so.6 - libc-2.2.3.so -rwxr-xr-x1 root root 4783716 May 25 2001 /lib/libc-2.2.3.so -rw-r--r--1 root root 24721042 May 25 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 May 25 2001 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-thread-safe-client --enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared Here is the stack: 0x807db7f 0x823d64a 0x821c6de 0x8053a68 0x80555bc 0x804a979 0x8075afe 0x80a6e5c 0x80a65f5 0x80a6373 0x809f5e4 0x80ac1c0 0x8085b4b 0x808a262 0x8084e57 0x808a694 0x8084296 Here is the test DB schema I was using: mysql desc test; ++--+--+-+-++ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-++ | id | int(11) | | PRI | NULL| auto_increment | | string | varchar(255) | YES | MUL | NULL|| ++--+--+-+-++ 2 rows in set (0.00 sec) Here is what is in the table: mysql select * from test; +++ | id | string | +++ | 1 | this is a test of the emergency system | | 2 | this is a big fat test | | 3 | test | | 4 | testing 123| | 5 | happy cow hand | | 6 | I wish I had a horse | | 7 | there is a pig in the bushes | | 8 | there is a pig in the car | +++ 8 rows in set (0.00 sec) Here is the query I ran: select *, match (string) against ('there is a pig' IN BOOLEAN MODE) as score from test; Here is the message that I got after I ran the query: ERROR 2013: Lost connection to MySQL server during query Here is the message in the error log: mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=16773120 record_buffer=131072 sort_buffer=524280 max_used_connections=0 max_connections=100 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 80379 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Stack range sanity check OK, backtrace follows: 0x807db7f 0x823d64a 0x821c6de 0x8053a68 0x80555bc 0x804a979 0x8075afe 0x80a6e5c 0x80a65f5 0x80a6373 0x809f5e4 0x80ac1c0 0x8085b4b 0x808a262 0x8084e57 0x808a694 0x8084296 Stack trace seems successful - bottom reached Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Re$ stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x841e538 = select *, match (string) against ('there is a pig' IN BOOLEAN MODE) as score from test thd-thread_id=1 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 1 did to cause the crash. In some cases of really bad corruption, the values shown above may be