Mysqld crashed : strange logs.
Bonjour, mysql Ver 11.15 Distrib 3.23.47, for sun-solaris2.8 (sparc) It crashed after more than a month with no problem and here are the logs : 020225 11:04:48 mysqld started 020225 11:04:50 InnoDB: Started /usr/local/mysql/libexec/mysqld: ready for connections 020226 12:01:05 failed in send_file() : Failed reading file name 020227 12:00:43 failed in send_file() : Failed reading file name 020228 12:01:12 failed in send_file() : Failed reading file name 020301 12:01:00 failed in send_file() : Failed reading file name 020302 12:00:48 failed in send_file() : Failed reading file name 020303 12:00:43 failed in send_file() : Failed reading file name 020304 12:00:46 failed in send_file() : Failed reading file name 020305 12:01:22 failed in send_file() : Failed reading file name 020306 12:00:54 failed in send_file() : Failed reading file name 020307 12:01:04 failed in send_file() : Failed reading file name 020308 12:00:59 failed in send_file() : Failed reading file name 020309 12:00:52 failed in send_file() : Failed reading file name 020310 12:00:47 failed in send_file() : Failed reading file name 020311 12:00:56 failed in send_file() : Failed reading file name 020312 12:01:15 failed in send_file() : Failed reading file name 020313 08:23:08 mysqld restarted 020313 8:23:10 InnoDB: Started /usr/local/mysql/libexec/mysqld: ready for connections 020313 8:23:10 Warning: Checking table: './contenu/news' 020313 8:23:10 Warning: Checking table: './cotations/instrument' 020313 8:23:10 Warning: Checking table: './contenu/calendrier' 020313 8:23:13 Warning: Checking table: './pratique/news' 020313 08:25:29 mysqld started ld.so.1: /usr/local/mysql/libexec/mysqld: fatal: libstdc++.so.2.10.0: open failed: No such file or directory 020313 08:25:30 mysqld ended 020313 08:54:08 mysqld started 020313 8:54:11 InnoDB: Started /usr/local/mysql/libexec/mysqld: ready for connections The last 3 lines are when I restarted it manually. And it's running fine now. Any idea ? Regards, Alex. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Inserting strings containing spaces only fails?
Hello Wout, Appareantly it's impossible to insert a string, consisting entirely out of spaces, in a textual field (I've tried varchar(19) and char(2) types, they both don't work). MySQL doesn't complain about it, but it trims the strings down to the empty string. If I try a select searching for the spaces-only string afterwards, it gives me zero results. The same problem occurs when updating. The problem does not occur, however, when converting the columns to text types. MySQL version: 3.23.47-nt OS: Windows NT 4.0 Problem can be reproduced with MySQLGui and Java using the JDBC-MySQL bridge driver. Is this a bug or do I have to do something special to disable the 'string trimming'? Any help would be greatly appreciated! Please note the last few lines of each msg on this list. It required five seconds and the first 'hit' on a single search of the manual to find a reference. Please read the (fine) manual: 6.2.3.1 The CHAR and VARCHAR Types The CHAR and VARCHAR types are similar, but differ in the way they are stored and retrieved. The length of a CHAR column is fixed to the length that you declare when you create the table. The length can be any value between 1 and 255. (As of MySQL Version 3.23, the length of CHAR may be 0 to 255.) When CHAR values are stored, they are right-padded with spaces to the specified length. When CHAR values are retrieved, trailing spaces are removed. 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: mySQL connection problem!!!
Hello Sherwin, Thanks for ur prompt reply. Yes, I have gone thru the mySQL manual chapter that you have mentioned.. But what I think the problem is somewhere else.. when I try to execute the command 'mysql' (when I log in as user 'babul') on command line, I get the following error: ERROR 2002: Can't conect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) It seems that the mySQL server is not running on the system... where as when I in superuser mode or login thru mysql user, I get just the mysql prompt..!! This is my first time with mySQL.. I m actually trying to restore a web database into my loca machine.. then update it locally and later withh restore it to the web server.. Babul --- Sherwin T. Ang [EMAIL PROTECTED] wrote: hello, regardless on what system user you are, root or ordinary system user, you can still connect to the mysql server with MYSQL ROOT privileges as long as you know the password of root. Because a SYSTEM ROOT is different from MYSQL ROOT user. well in the case of your problem, you should read the GRANT and REVOKE syntax in the manual to make it clearer. http://www.mysql.com/doc/G/R/GRANT.html Regards, Sherwin T. Ang Web Technical Administrator / Programmer Alchemy Solutions http://www.alchemy.com.ph Creative. Technology. Tridel Technologies, Inc. 7th Floor Hanston Building Emerald Ave., Ortigas Center Pasig City Philippines Tel: (632) 634-5141/ (632) 634-5140 Local 1040 Fax: (632) 634-5139 - Original Message - From: b g [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 12, 2002 11:38 PM Subject: mySQL connection problem!!! Hello, I m ina great problem.. I am not able to conenct to mySQL server.. the problem is like.. when I m in root or mysql USER login.. then I can login to mySQL server.. its fine.. but other than 'root' and 'mysql', i can not connect to the database server.. thats why I am not able to run any web based database connection.. can u pls explain wht to do now? I hv created one mysql user using this: $ su passwd: $ mysql -u root mysql mysql grant all priviliges on *.* to user@localhost with grant option; mysql\q $ and then i am able to connect.. that too when i was in superuser mode.. else frm other users, i m not able to conenct.. pls help.. the mysqld is running! Babul in India.. __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! 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 __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! 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
Thanks in advance
Hi, How to take part in a mail list for Redhat and FreeBSD such as this one. Thanks, Dominic 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
Is this a bug in TIMESTAMP?
Hi everybody! I have found following 'bug' in type TIMESTAMP: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1279 to server version: 3.23.48-Max-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql Create a table with 2 TIMESTAMP fields: CREATE TABLE `prueba` ( `id` int(10) unsigned NOT NULL auto_increment, `fecha1` timestamp(14) NOT NULL, `fecha2` timestamp(14) NOT NULL, PRIMARY KEY (`id`) ); Insert some data: mysql INSERT INTO prueba VALUES (NULL,20020313100138,20020313100340); mysql INSERT INTO prueba VALUES (NULL,20020313094114,20020312094031); mysql select * from prueba; ++++ | id | fecha1 | fecha2 | ++++ | 1 | 20020313100138 | 20020313100340 | ++++ And then: mysql UPDATE prueba SET fecha1= '20020313101000' WHERE id=1; mysql select * from prueba; ++++ | id | fecha1 | fecha2 | ++++ | 1 | 20020313101000 | 20020313100340 | ++++ It's OK. But if: mysql UPDATE prueba SET fecha2= '20020313101000' WHERE id=1; mysql select * from prueba; ++++ | id | fecha1 | fecha2 | ++++ | 1 | 20020313101501 | 20020313101000 | ++++ mysql select now(); +-+ | now() | +-+ | 2002-03-13 10:15:23 | +-+ Field 'fecha1' has changed to 'now()'. Is this a bug? Thanks, José Ceferino Ortega - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 bit OT: ColdFusion can't connect to MySQL via ODBC (newbie)
Hello, list! I'm not quite sure that this is the right place to ask, but I'm having problems getting MySQL and ColdFusion Server 5 to work together. I have a ColdFusion server that connects to MySQL via ODBC. I've configured the Merant MySQL ODBC driver via the ColdFusion administrator, and it is able to connect to my MySQL database (at least it claims that the connection was successful when clicking verify in the CF admin). The datasource name is hpTest. However, trying to connect to the database in an CFM doesn't seem to work at all. My error message is ODBC Error Code = 08003 (Connection not open) [MERANT][ODBC lib] Connection not open The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (2:1) to (2:114). and the code goes like this: cfquery name=Test dbtype=ODBC dbname=hpTest datasource=hpTest SELECT * FROM hpTest /cfquery cfoutput query=hpTest#FieldName1#, #FieldName2#br/cfoutput I've been reading TFM, browsing TFW, reading TFML and I've even been to (*ghasp*) Microsofts ODBC-pages looking for an answer (and you know it's -bad- when that happens!g). Reading the manual I got the impression that coldfusion would open the connection when using a cfquery-tag. Any help is greatly appreciated. Cheers, Markus, tearing big lumps of hair out. -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Is this a bug in TIMESTAMP?
* Ceferino Ortega mysql UPDATE prueba SET fecha2= '20020313101000' WHERE id=1; mysql select * from prueba; ++++ | id | fecha1 | fecha2 | ++++ | 1 | 20020313101501 | 20020313101000 | ++++ mysql select now(); +-+ | now() | +-+ | 2002-03-13 10:15:23 | +-+ Field 'fecha1' has changed to 'now()'. Is this a bug? No, it is a feature. URL: http://www.mysql.com/doc/D/A/DATETIME.html In short: the first timestamp field of a table is automatically updated when the row is updated/inserted. -- 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
Losing connection during a REPAIR TABLE
Hi! rafe == rafe [EMAIL PROTECTED] writes: Description: rafe I am not subscribe to this list so please cc me in your reply. rafe I created a ~5GB table full of large (TINY|BIG)TEXT fields in it. This is a fresh build and there has been no activity except for the following: rafe 1) Record inserts from flat file parsing. rafe 2) OPTIMIZE TABLE wich died in batch caused me to try and run the REPAIR. rafe I've also tried complete rebuilds with the same data and I get the same crashi but builds with less data (~4GB) have worked. rafe The REPAIR TABLE dies repeatedly with: mysql repair table dna; rafe ERROR 2013: Lost connection to MySQL server during query rafe I've tried '-O max_allowed_packet=33554432' as per section A.2.2. But with the same results. REPAIR should be independent of max_allowed_packet. We have many users of MySQL with tables bigger than 4G, so this is not a general problem. Please take a backup of your table and try a repair with the 'myisamchk' utility. As Sinisa said, please try REPAIR with our latest binary. If you get the same problem with MySQL 3.23.49, can you give us access to a copy of that table so that we can fix this problem ASAP ? Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: a bug or not a bug??
* Douglas Nusbaum Referencing your tutorial I created a text file to use with LOAD DATA LOCAL INFILE ../data/pet.txt INTO TABLE pet; I have tried every possible combination that I could think of of , \t \\t \, \T etc as delimiters in the data strings such as Fluffy,Harold,cat,f,1993-02-04\N and nothing results in a correct load of the data. No matter what I do everyting gets loaded into the first field or I get a lot of NULL's or some other version of trash. Am I just stupid, or is this a bad version of your code or what??? Note that by using the terms FIELDS TERMINATED BY ... I got things to work. Bus should this be necessary. Also, it only seems to work on commas, not other delimiters From the manual: manual.txt If you don't specify a `FIELDS' clause, the defaults are the same as if you had written this: FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' /manual.txt This means you don't need to specify anything if your fields are terminated by tab characters. As your fields are separated by commas, you have to specify this. You say it does not work with other delimiters... what delimiters have you tried, and what was the result? -- 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
Default RPMs and RAID support
I want to use the MySQL default binaries (i used to build them in my own machine, but i have followed this list and you're always saying to use the default ones). My question is: is there a way of using the default binaries and have Table type=RAID support ? Thanks in advance. -- 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: can not backup table
On Wed, 2002-03-13 at 01:48, Abi wrote: Hi, I have this following error when back up table : mysql lock tables mytable read; Query OK, 0 rows affected (0.02 sec) mysql select * into outfile '/home/myhome/dump/mytable.txt' from mytable; ERROR 1: Can't create/write to file '/home/myhome/dump/mytable.txt' (Errcode: 13) what does errcode:13 mean ? Use perror utility to see what an error means. # perror 13 Error code 13: Permission denied So, you (the user who runs mysqld) don't have permissions to write to /home/myhome/dump/. -pgl- -- 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: GUI for MySQL
In article [EMAIL PROTECTED], Simon Green wrote: I am just installing a new MySQL server at the moment. We are using PHPMyAdmin witch is ok as we can limit what each user can do, but some tables do not work with it. We have 2.1.0 at the moment. Do I 1. Just go for the latest PHPMyAdmin 2. Use MySQL GUI (can I restrict what each user can do?) 3. Is there some thing mush better out there? Thanks Simon Green Internet Systems Engineer Hi Simon Why not give EMS MySQL Manager a try. This is not open source I'm afraid, but I find it heaps better than PHPMyAdmin. ($95 single or $695 site licence) You can download a fully functional 30 day trial copy from http://www.mysqlmanager.com/ to see if you like it. Cheers John Morrison - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 connection problem
On Wed, 2002-03-13 at 08:08, b g wrote: when I m in root or mysql USER login.. then I can login to mySQL server.. its fine.. but other than 'root' and 'mysql', i can not connect to the database server.. With which user are you trying to connect ? Did you grant permissions to that user ? Be more specific. thats why I am not able to run any web based database connection.. i get could not connect to database.. can u pls explain wht to do now? I hv created one mysql user using this: $ su passwd: shell mysql --user=root mysql mysql GRANT ALL PRIVILEGES ON *.* TO babul@localhost - IDENTIFIED BY 'babul123' WITH GRANT OPTION; - \q $ then i am able to connect using the database user/pass .. that too when i was in super-user mode.. else frm other users, i m not able to conenct.. pls help.. the mysqld is running! Babul in India.. -- 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
Composite primary key in MySQL
Dear all, Will MySQL supports composite primary key constraint? If so what is the actual syntax? How foreign key relationship can be established in MySQL? Please help me. Prasad. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Where is MySQL-DBI-perl-bin.rpm?
Hi. I've installed mysql-3.23.49a rpm packages from www.mysql.com on a Pentium RedHat 7.2 machine. When I try to install MySQL-bench-3.23.49a-1.i386.rpm package it depends in MySQL-DBI-perl-bin package. I failed to find MySQL-DBI-perl-bin package in www.mysql.com, where is it? and what version I need for MySQL-bench-3.23.49a-1.i386.rpm package. Thanks in advance. 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: always this happenes to me
Two things to check: 1. Ensure the mysql server is running. mysql.sock is automatically created when the server is started. 2. If you still get the error, it may be in another subdirectory, usually var/lib/mysql. Once you locate mysql.sock, modify the my.cnf file to point to the correct location. Regards, Doug On 13 Mar 2002 06:04:58 -, nagendra prasad wrote: hi ,i got this error 3 -4 times ,then i reinstalled mysql the it used to work properly. Once i come baack to office the next day run the page again,it gives the same error again. the error is __ an error can't connect to MYSQL server through socket /tmp/mysql.sock __ but when i go to the /tmp search for this socket mysql.sock i donh't find it there. i don't understand what the probs is. plz help me.i'm badly struck. tnx prasad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
history of MySQL
Does anybody know the evolution of MySQL. I understand it evolved from mSQL, but the company is unwilling to discuss this history. I write a computer encyclopedia and am trying to trace back the product. Can anyone help? Is there some major secret going on here some CIA mission. Or has everyone at MySQL simply forgotten? Any answers would be appreciated. Thanks. Alan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 installed on a CD
Hi, I have an application I have developed in java using tomcat as a webserver and mySQL as a DB. Is it possible to distribute this package on a CD? To do this I need to put tomcat, my application, JRE and mySQL on the CD. Anybody tryed this before to use mySQL without installing it first or using directly on a CD? Thanks, /mike _ Chatta med vänner online, prova MSN Messenger: http://messenger.msn.se - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Text Limitation
shaj, Tuesday, March 12, 2002, 3:12:18 PM, you wrote: s Can any one tell me what is the text limitation for mySQL?? What do you mean text limitation? You can read about blob and text column types at: http://www.mysql.com/doc/B/L/BLOB.html Read also about storage requirements at: http://www.mysql.com/doc/n/o/node_368.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
Stop query after first match
Hi, I'd like to know how I can do the following: I want to query a single table like this: select field1, field2, field3 from table1 where field1='something' and field2=0; This query will result in more then one match. It's not possible for me to use a more specific query. From the result I only need the first hit. All the other rows are not important. (e.g. I get 100 rows back, but I only need 1) So my question: How can I stop the query on the first match and return the result of that match and prevent the query from fetching all matching records (and limit the results afterwards by using LIMIT 1). This is mainly for boosting the performance of mys queries. Actually where using mysql to dynamically assign ip addresses to our dial-in users. We query the database for available addresses - there are more than 1 available but I only need 1! Thanks in advance! Danny Kruitbosch - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
dbf2mysql
I've read in the read-me that dbf2mysql doesn't handle memo files. Does this mean that it won't work for any tables that include memo fields? Neil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Text Limitation
On Tue, 12 Mar 2002, shaj wrote: Can any one tell me what is the text limitation for mySQL?? TEXT datatype is limited to a maximum length of 65535 (2^16 - 1) characters. LONGTEXT allows up to 4'294'967'295 (2^32 - 1) characters, which is enuf for most applications. The real limitation is that fulltext indexing only works for VARCHAR and TEXT. Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
always this happenes to me
nagendra, Wednesday, March 13, 2002, 8:04:58 AM, you wrote: np hi ,i got this error 3 -4 times ,then i reinstalled np mysql the it used to work properly. np Once i come baack to office the next day run the page np again,it gives the same error again. np the error is np __ np an error can't connect to MYSQL server through socket np /tmp/mysql.sock np __ np but when i go to the /tmp search for this socket np mysql.sock i donh't find it there. File mysql.sock is created when MySQL server is running. Is your MySQL server running? Check your privileges on the socket file and on the dir that contains socket file. You can find the description of this error at: http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html np i don't understand what the probs is. np plz help me.i'm badly struck. np tnx np prasad -- 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: constraints in InnoDB, or is 3.23.43b _really_ 4.0.1?
Tomasz, InnoDB in 3.23 and 4.0 is the same codebase. InnoDB versions are best counted from the 3.23 series, because they appear more frequently. I am sorry that this is confusing. MySQL/InnoDB-3.23.50 has not been released yet. It will probably be out at the end of March. 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. Starting from version 3.23.50 InnoDB returns the foreign key definitions of a table when you call SHOW CREATE TABLE yourtablename You can also list the foreign key constraints for a table T with SHOW TABLE STATUS FROM yourdatabasename LIKE 'T' The foreign key constraints are listed in the table comment of the output. 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: Tomasz Korycki [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Date: Wednesday, March 13, 2002 1:05 AM Subject: constraints in InnoDB, or is 3.23.43b _really_ 4.0.1? Here is an excerpt from http://www.innodb.com/ibman.html#InnoDB_distros, section 4.2: Starting from version 3.23.43b InnoDB features foreign key constraints. InnoDB is the first MySQL table type which allows you to define foreign key constraints... Now, I assumed the version number above was suspiciously similar to MySQL one - and since I use 4.0.1, I thought I was OK (I need them references... ON DELETE and friends would be great, but plain references save most of the hassle). After trying to (and failing to) create my own tables, I did tables as in the example on InnoDB site: CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=InnoDB; CREATE TABLE child(id INT, parent_id INT, INDEX par_ind (parent_id), FOREIGN KEY (parent_id) REFERENCES parent(id)) TYPE=InnoDB; And what do I see? I see indices in the tables, but no FK! Yes, tables _are_ InnoDB. I have proper indices - so on to the next step (there was no error return), just in case - it says: Starting from version 3.23.50 InnoDB allows you to add a new foreign key constraint to a table... So, here I go: ALTER TABLE child ADD CONSTRAINT FOREIGN KEY (parent_id) REFERENCES parent(id); No error. No effect, either... So, here comes the big question: What am I doing wrong? -- sql, query Tomasz Korycki [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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Converting MyISAM to InnoDB
Hi! You should add a new data file as explained in section 5 of http://www.innodb.com/ibman.html. 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: ImpactNET - Edgar R Gutierrez [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Date: Wednesday, March 13, 2002 9:25 AM Subject: Converting MyISAM to InnoDB Hello, We are currently in the process of converting our MyISAM tables to InnoDB to make our tables transaction safe. Unfortunately, I am getting the following error on one of the tables... mysql alter table SUBSCRIBERS type = InnoDB; ERROR 1114: The table '#sql-fcc_1' is full mysql What value should I set the following. Currently, I set it to 512M... set-variable = innodb_buffer_pool_size=512M My SYSTEM runs V4.0.1-alpha and my server has 1GB of RAM. 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
SV: problem with mysql3.23.49 server under freebsd 4.5
sql,query I cant get the server to starts more than one thread. I have installed the server from the port collections and im running freebsd 4.5 stable Regards leo de geer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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++ samples are not working?
Specialized SQL structs do not yet work with VC++. -- 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: mysql under FreeBSD 4.5 HEADSUP
Ken Menzel writes: Hi everyone, If you have increased your MAXDSIZ variable in FreeBSD to above 2048 the mysqld will crash on FreeBSD 4.5. Please set it to 2047 or lower: options MAXDSIZ=(2047*1024*1024) to quote a very intelligent source (Thanks Sinisa!) It happens with MySQL as it is the only one trying to create threads. So, as threads take up stack, FBSD checks for available memory. And as it is saved in signed int, it crashes Don't forget to install the new kernel (make kernel) after lowering MAXDSIZ. If you are using the GENERIC kernel you won't have this problem. You will only have this problem if you added MAXDSIZ to you kernel config and set it above 2047. Hope this helps, Ken You are always welcome ... ;o) -- 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: Text Limitation
Hi! On Mar 13, Thomas Spahni wrote: On Tue, 12 Mar 2002, shaj wrote: Can any one tell me what is the text limitation for mySQL?? TEXT datatype is limited to a maximum length of 65535 (2^16 - 1) characters. LONGTEXT allows up to 4'294'967'295 (2^32 - 1) characters, which is enuf for most applications. The real limitation is that fulltext indexing only works for VARCHAR and TEXT. Thomas What do you mean ? It works for all *TEXT types, from TINYTEXT and up to LONGTEXT. And for VARCHAR, yes. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Datawarehousing
DIVIDE ET EMPERA Hi, OK you wish to discuss about CONCEPTUAL point of view. You said: Partitioning data and Parallelism. We begin to talk about this principle, but i feel, something is missing here.Ohhh...yeaaa... is calling DISTRIBUTION DATA.And if we talk about how or what tasks/process we need(complementary, further from what offered any RDBMS engine) to distribute data in our HETEROGENEUS/HOMOGENEOUS SYSTEM DATABASE we must add in our discussion and: -HOW ORGANIZE DATA FLOW? -HOW ORGANIZE WORK FLOW DEPEND ON THE DATA DISPOSITION? -AVOIDING POINTS WHERE BOYCE-CODD RULES ARE COMPROMISE? -HOW WE CREATE FACILITIES FOR ONLINE TRASACTION PROCESSING ? -HOW WE PROCESSING MULTIDIMENSIONAL DATA? -HOW WE CREATE A MULTI-TIER APPLICATION? -HOW WE CREATE A DRIVER DATABASE? -HOW WE CREATE A SEMAPHORE SYSTEM? -HOW ESTABLISH A LEVEL PRIORITY OF PROCESSES? Now... we can talk about partitioning(serialize,recursive...) and parallelism interdependence.We cannot make any dissociation.When we think what table must split (especially when we have mirroring database) on whatever database on whatever host machine, we must already know in what block of our database system network we wish to balance some processes.Also we must think of what ways offering for users to read/write and processing data properly. This mean : a- create a database with rules about how must work the entire system.(Configuration Database) b- create a Server Application who manage User requirment and interact with DataBases(that level is between User and DataBase).This is 3 tier application. -This server must doing at least: -run an administrative process and maintain tables from our databases on whatever host machine depend on configuration. -User access gate management.(In configuration database you can put parameter MAX_USERS_ACCESS_ALLOW_PER_DATABASE=10.000.In this case this task can check what database are less then 10.000 and guide the User to the available database for working). -User requirment interpretor -SQL generator. ...etc. In this case we can write our own function MERGE(Apropos ... and mySQL know about MERGE beginning with Version 3.23.25). ie. We use two type of table work table and historical table.Why? Because we wish to prevent working with very huge tables(tens or few hundred of GB/table.Is possible to reach terabytes if we talk about database(s) size)especially when we need OLTP(in my opinion, mySQL is a power tools for OLTP but only in this conditions). So... we create the fact table and let's say in configuration database exist the parameter RENAME_TABLE_WHEN_THE_MONTH_CHANGE_AND_CREATE_OTHER=TRUE The Administrative(i make reference to 3 tier Server Application) process check if this table is in conformity with parameter aforementioned and if has, we must do something in this point : 1. retrieve summary data from this table and put on apart in a maintenance database in a table who name is table_summary_description.This data can be :MAX(sales),SUM(sales),MIN(sales)...(what we considered can be criteria searching)etc., but most important is the new suffix of the new name of the table who should be create(concat(fact,_,april2001)=fact_april2001) and the MIN(ID),MAX(ID).Now User can ask :In what month i have thin sales?.Server Application invoke :User requirement interpretorand after this, SQL generator create the SQL(we are subscribed in the mysql mailing list;i use the mysql syntax): select suffix_table_name,MIN(sales) from table_summary_description group by sales limit 1; Application Server take the result and is send to the user. On the others cases is when User ask:Give me sales from '05/05/2001' or Give me sales from '05/05/2001' to 06/05/2001.Scenario is the same, but further, the first result is taking by SQL generator and make another SQL: select * from fact_april2001 where ID='05/05/2001' or : ... if we using MERGE this fact_merge must specify in maintenance database.(I use my own MERGE). In mySQL it's very simple to create and it work fine(i tested under Linux): create table fact_merge(id date,sales numeric(10,2)) union=(fact_april2001,fact_may2001); flush tables; ...E VOILA... ...if you wish to add other table we can use: alter table fact_merge union(fact_april2001,fact_may2001,fact_june2001); flush tables; and also if we wish to exclude tables we can use: alter table fact_merge union(fact_april2001,fact_june2001); flush tables; ...and work very good if we don't insert/delete data from this tables(like merge i mean).If we wish to delete some data we can create a FLAG field to mark if row there is VALID or NOT.(I prefer this way because i see OS reaction.The OS eat a lot of resources when must working with the physical files.And i think is normal - I/O operations.Once/week we can stop a block of database and delete from it the information who are
RE: mySQL connection problem!!!
I think I read somewhere about this issue. I think it had to do with multiple mySQL servers running concurrently. See if there is multiple servers running using the ps command. If so, then kill one of them. Also, when adding a user, do you select a database first before adding a user? -Original Message- From: b g [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 2:35 AM To: Sherwin T. Ang Cc: [EMAIL PROTECTED] Subject: Re: mySQL connection problem!!! Hello Sherwin, Thanks for ur prompt reply. Yes, I have gone thru the mySQL manual chapter that you have mentioned.. But what I think the problem is somewhere else.. when I try to execute the command 'mysql' (when I log in as user 'babul') on command line, I get the following error: ERROR 2002: Can't conect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) It seems that the mySQL server is not running on the system... where as when I in superuser mode or login thru mysql user, I get just the mysql prompt..!! This is my first time with mySQL.. I m actually trying to restore a web database into my loca machine.. then update it locally and later withh restore it to the web server.. Babul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Is it possible to support single and double byte characters in the same database?
Is it possible to support both single and double-byte characters in the same database? We have offices all over the world -- and want to share information, but in some cases, there will be japanese and possibly hebrew text in the database - in addition to English, Dutch, french, and Spanish. Is it possible to support all of this from a single mySQL db? If so, how do i set that up? I've run some tests, and right now we can support English, etc., but not the double byte languages. Thanks, Kim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: install prob - different error
Aman, Wednesday, March 13, 2002, 2:32:29 AM, you wrote: AR I re-installed MySql from RH Linux 7.2 cd and now I am getting the following AR [root@coolnis-ar mysql]# Starting mysqld daemon with databases from AR /var/lib/mysql AR 020312 18:29:52 mysqld ended AR [1]+ Donebin/safe_mysqld --user=mysql --err-log=my.err AR [root@coolnis-ar mysql]# AR [root@coolnis-ar mysql]# AR [root@coolnis-ar mysql]# AR [root@coolnis-ar mysql]# more my.err AR 020312 18:29:14 mysqld started AR Cannot initialize InnoDB as 'innodb_data_file_path' is not set. AR If you do not want to use transactional InnoDB tables, add a line AR skip-innodb AR to the [mysqld] section of init parameters in your my.cnf AR or my.ini. If you want to use InnoDB tables, add for example, AR innodb_data_file_path = ibdata1:30M AR But to get good performance you should adjust for your hardware AR the InnoDB startup options listed in section 2 at AR http://www.innodb.com/ibman.html AR 020312 18:29:14 /usr/local/mysql/bin/mysqld: Can't find file: AR './mysql/host.frm' (errno: 13) AR 020312 18:29:14 mysqld ended AR any suggestions ? $ perror 13 Error code 13: Permission denied Please, check your permissions on mysql data dir. AR Aman -- 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: 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
Sub-select look-alike?
Hi, I have two tables: languages: id tinyint(3) unsigned not null, language varchar(30) not null language_pairs: from tinyint(3) unsigned not null, to tinyint(3) unsigned not null language_pairs.from and language_pairs.to are linked with languages.id (both tables are simplified in this mail and contains a lot more columns, but they are not relevant) Now I want to do a query giving me the names of the languages (languages.language) instead of language_pairs.from og .to. I can only see a solution requiring the use of sub-selects which MySQL doesn't (yet :) has support for. Anyone smarter than me who can see a solution? I want to avoid use of sub-queries if possible, and my emergency plan is to extract all records from `languages` into an array in PHP and simply use PHP to join .from and .to with the matching language. That's not in any way optimal, that's why I'm asking you guys :) regards, //andreas http://phpwizard.dk (in Danish only) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Transactional sql tables with columns that can have NULL values
Hi, I would like to use transactional sql tables that support columns with NULL values. I think that only BDB and InnoDB tables types support transactions, but I have read that: Only the MyISAM table type supports indexes on columns that can have NULL values. In other cases you must declare such columns NOT NULL or an error results. The problem is that MyISAM table is non-transactional. How can I solve this? Thank you very much TERE - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Sub-select look-alike?
SELECT f.language as From, t.language as To FROM language f, language t, language_pairs lp WHERE f.id = lp.from AND t.id = lp.to; --Greg Johnson -Original Message- From: Andreas Frøsting [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 10:13 AM To: [EMAIL PROTECTED] Subject: Sub-select look-alike? Hi, I have two tables: languages: id tinyint(3) unsigned not null, language varchar(30) not null language_pairs: from tinyint(3) unsigned not null, to tinyint(3) unsigned not null language_pairs.from and language_pairs.to are linked with languages.id (both tables are simplified in this mail and contains a lot more columns, but they are not relevant) Now I want to do a query giving me the names of the languages (languages.language) instead of language_pairs.from og .to. I can only see a solution requiring the use of sub-selects which MySQL doesn't (yet :) has support for. Anyone smarter than me who can see a solution? I want to avoid use of sub-queries if possible, and my emergency plan is to extract all records from `languages` into an array in PHP and simply use PHP to join .from and .to with the matching language. That's not in any way optimal, that's why I'm asking you guys :) regards, //andreas http://phpwizard.dk (in Danish only) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Sub-select look-alike?
Is that what you want? SELECT languages.language, languages.fieldN, .., language_pairs.fieldX FROM language_pairs INNER JOIN Languages ON languages.id=language_pairs.id WHERE /* conditions */ -Original Message- From: Andreas Frøsting [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 10:13 AM To: [EMAIL PROTECTED] Subject: Sub-select look-alike? Hi, I have two tables: languages: id tinyint(3) unsigned not null, language varchar(30) not null language_pairs: from tinyint(3) unsigned not null, to tinyint(3) unsigned not null language_pairs.from and language_pairs.to are linked with languages.id (both tables are simplified in this mail and contains a lot more columns, but they are not relevant) Now I want to do a query giving me the names of the languages (languages.language) instead of language_pairs.from og .to. I can only see a solution requiring the use of sub-selects which MySQL doesn't (yet :) has support for. Anyone smarter than me who can see a solution? I want to avoid use of sub-queries if possible, and my emergency plan is to extract all records from `languages` into an array in PHP and simply use PHP to join .from and .to with the matching language. That's not in any way optimal, that's why I'm asking you guys :) regards, //andreas http://phpwizard.dk (in Danish only) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Sub-select look-alike?
Hi Greg, SELECT f.language as From, t.language as To FROM language f, language t, language_pairs lp WHERE f.id = lp.from AND t.id = lp.to; I really need to get some sleep I think. So simple, and yet my buggy mind didn't come up with that solution. Thanks, //andreas (sql, query - just to satisfy the filter) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 / MS Access subforms
Hi, I've been migrating an MS Access database from Access to use a MySQL linked-table backend. Most problems have been fixed by the advice on the MyODBC FAQ and other resources but I am having trouble with a sub form to which I cannot find an answer... The database is a customers/stock/orders database. To place an order you select an option on the customer form which opens a new order record linked to the customer. Order-details are entered (such as payment) then a subform is used to enter items onto the order. But when you move onto the next item, any previous items show up as the item just entered, eg (imagine these s are record selectors and _ is the cursor): Enter an item 1_ And another 1 2_ Try and enter a third and 2 2 _ Enter another, move and... 3 3 3 _ and so on. The data is fine if you requery the subform, and seems fine if you go back into the order and start entering data. The same happens if I create a new order record in ADO and open it up to start entering data. Access seems to be forgetting that it has added new items, because it keeps requerying the table for the subform with primarykey=null, if this helps explain what is happening. I have installed the latest Jet 4 SP5, MDAC 2.7, MyODBC 2.50.39, MySQL 3.22.32 (-6 Debian). It happens in Access 2000 and Access XP, with latest service packs. All the tables have a sensible timestamp and a primary key. Any ideas? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Hi all, I'm sorry my English. I 'm install mysql 3.23-49 en Linux and I have the next problem during to instalation: I execute : make creating libmysqlclient.la (cd .libs rm -f libmysqlclient.la ln -s ../libmysqlclient.la libmysqlclient.la) make[2]: Leaving directory `/home/mysql/instalador/mysql-3.23.49/libmysql' Making all in client make[2]: Entering directory `/home/mysql/instalador/mysql-3.23.49/client' gcc -DUNDEF_THREADS_HACK -I./../include -I.. /include -I./.. -I..-I..-O3c cc1plus: Invalid option `-fno-exceptions' In file included from client_priv.h:19, from mysql.cc:28: ../include/global.h:685: warning: abstract declarator used as declaration make[2]: *** [mysql.o] Error 1 make[2]: Leaving directory `/home/mysql/instalador/mysql-3.23.49/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/home/mysql/instalador/mysql-3.23.49' make: *** [all-recursive-am] Error 2 What is 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
MySQL Quits in Replication
Hi, 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. Ideas? Suggestions? Environment is NetBSD 1.5Y with MySQL 3.23.47 (the latest supported by NetBSD). 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: Foreign keys in mysqldump?
David, a Solaris version of InnoDB Hot Backup is planned, as well as a FreeBSD version. Currently I am working with beta testers trying to get the Large file support on Linux to work :). Regards, Heikki Tuuri Innobase Oy -Original Message- From: David Felio [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Date: Tuesday, March 12, 2002 7:18 PM Subject: Re: Foreign keys in mysqldump? InnoDB Hot Backup-0.33 beta is now available for Windows NT/2000/XP and Linux. Any plans for Solaris by the May 2002 release date? From: Heikki Tuuri [EMAIL PROTECTED] The beta testing of InnoDB Hot Backup (a non-free add-on tool) started on Monday. If you want to take part in the beta testing, look at http://www.innodb.com sql David Felio Software Developer Information Network of Arkansas http://www.AccessArkansas.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Transactional sql tables with columns that can have NULL values
Hi! Where did you read that? That text should be updated! At least InnoDB supports indexes on columns which can have a NULL value. Regards, Heikki Tuuri Innobase Oy -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Date: Wednesday, March 13, 2002 5:23 PM Subject: Transactional sql tables with columns that can have NULL values Hi, I would like to use transactional sql tables that support columns with NULL values. I think that only BDB and InnoDB tables types support transactions, but I have read that: Only the MyISAM table type supports indexes on columns that can have NULL values. In other cases you must declare such columns NOT NULL or an error results. The problem is that MyISAM table is non-transactional. How can I solve this? Thank you very much TERE - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 instalation
You could probably save yourself some trouble by installing binaries. But what version of Linux? And what version of gcc? There are many problems associated with using gcc 3.x that I won't get into here. But it helps to pass along these details. On Wed, 2002-03-13 at 11:04, Roberto C. Salazar M. wrote: Hi all, I'm sorry my English. I 'm install mysql 3.23-49 en Linux and I have the next problem during to instalation: I execute : make creating libmysqlclient.la (cd .libs rm -f libmysqlclient.la ln -s ../libmysqlclient.la libmysqlclient.la) make[2]: Leaving directory `/home/mysql/instalador/mysql-3.23.49/libmysql' Making all in client make[2]: Entering directory `/home/mysql/instalador/mysql-3.23.49/client' gcc -DUNDEF_THREADS_HACK -I./../include -I.. /include -I./.. -I..-I..-O3c cc1plus: Invalid option `-fno-exceptions' In file included from client_priv.h:19, from mysql.cc:28: ../include/global.h:685: warning: abstract declarator used as declaration make[2]: *** [mysql.o] Error 1 make[2]: Leaving directory `/home/mysql/instalador/mysql-3.23.49/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/home/mysql/instalador/mysql-3.23.49' make: *** [all-recursive-am] Error 2 What is 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error running scripts/mysql_install_db While installing AIX binaries
Description: shr.o not found in libz.a when running mysql-install_db How-To-Repeat: Output from mysql_install_db: root@cedar:/work/work/mysql/mysql-max-3.23.46-ibm-aix4.3.3.0-rs6000 scripts/mysql_install_db exec(): 0509-036 Cannot load program ./bin/my_print_defaults because of the following errors: 0509-150 Dependent module /usr/local/lib/libz.a(shr.o) could not be loaded. 0509-152 Member shr.o is not found in archive WARNING: The host 'cedar' 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 exec(): 0509-036 Cannot load program ./bin/mysqld because of the following errors: 0509-150 Dependent module /usr/local/lib/libz.a(shr.o) could not be loaded. 0509-152 Member shr.o is not found in archive Installation of grant tables failed! Examine the logs in ./data for more information. You can also try to start the mysqld daemon with: ./bin/mysqld --skip-grant You can use the command line tool ./bin/mysql to connect to the mysql database and look at the grant tables: shell ./bin/mysql -u root mysql mysql show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in ./data that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com Please consult the MySQL manual section: 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source is the MySQL email archive. Please check all of the above before mailing us! And if you do mail us, you MUST use the ./bin/mysqlbug script! Fix: NONE Submitter-Id: submitter ID Originator:[EMAIL PROTECTED] Organization: Silicon Valley Internet MySQL support: None Synopsis: mysql_install_db fails on AIX Binary Install Severity: non-critical Priority: low Category: mysql Class: Release: mysql-3.23.46-max (Official MySQL-max binary) Environment: System: AIX cedar 1 5 002351434C00 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/cc Compilation info: CC='gcc' CFLAGS='-O3 -mcpu=powerpc -Wa,-many ' CXX='c++' CXXFLAGS='-O3 -mcpu=powerpc -Wa,-many -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx 1 bin bin 19 Nov 24 13:27 /lib/libc.a - /usr/ccs/lib/libc.a lrwxrwxrwx 1 bin bin 19 Nov 24 13:27 /usr/lib/libc.a - /usr/ccs/lib/libc.a Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL-max binary' --with-extra-charsets=complex --with-server-suffix=-max --enable-thread-safe-client --disable-shared --with-berkeley-db --with-innodb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 instalation
I work with Linux Cobalt (like to RedHat) My gcc version is gcc-2.7.2 RCS - Original Message - From: Jim Philips To: Roberto C. Salazar M. Cc: [EMAIL PROTECTED] Sent: Wednesday, March 13, 2002 11:18 AM Subject: Re: Problem in instalation You could probably save yourself some trouble by installing binaries. But what version of Linux? And what version of gcc? There are many problems associated with using gcc 3.x that I won't get into here. But it helps to pass along these details. On Wed, 2002-03-13 at 11:04, Roberto C. Salazar M. wrote: Hi all, I'm sorry my English. I 'm install mysql 3.23-49 en Linux and I have the next problem during to instalation: I execute : make creating libmysqlclient.la (cd .libs rm -f libmysqlclient.la ln -s ../libmysqlclient.la libmysqlclient.la) make[2]: Leaving directory `/home/mysql/instalador/mysql-3.23.49/libmysql' Making all in client make[2]: Entering directory `/home/mysql/instalador/mysql-3.23.49/client' include -I.. /include -I./.. -I..-I..-O3c cc1plus: Invalid option `-fno-exceptions' In file included from client_priv.h:19, from mysql.cc:28: ../include/global.h:685: warning: abstract declarator used as declaration make[2]: *** [mysql.o] Error 1 make[2]: Leaving directory `/home/mysql/instalador/mysql-3.23.49/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/home/mysql/instalador/mysql-3.23.49' make: *** [all-recursive-am] Error 2 What is 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 instalation
I am not at all familiar with Cobalt. But your gcc version is pretty old. Everything compiles without error on my RedHat 7.2 system with gcc 2.96. Or, you might want to consider the binary...since upgrading gcc might not solve the problem. On Wed, 2002-03-13 at 11:20, Roberto C. Salazar M. wrote: I work with Linux Cobalt (like to RedHat) My gcc version is gcc-2.7.2 - Original Message - From: Jim Philips To: Roberto C. Salazar M. Cc: [EMAIL PROTECTED] Sent: Wednesday, March 13, 2002 11:18 AM Subject: Re: Problem in instalation You could probably save yourself some trouble by installing binaries. But what version of Linux? And what version of gcc? There are many problems associated with using gcc 3.x that I won't get into here. But it helps to pass along these details. On Wed, 2002-03-13 at 11:04, Roberto C. Salazar M. wrote: Hi all, I'm sorry my English. I 'm install mysql 3.23-49 en Linux and I have the next problem during to instalation: I execute : make creating libmysqlclient.la (cd .libs rm -f libmysqlclient.la ln -s ../libmysqlclient.la libmysqlclient.la) make[2]: Leaving directory `/home/mysql/instalador/mysql-3.23.49/libmysql' Making all in client make[2]: Entering directory `/home/mysql/instalador/mysql-3.23.49/client' gcc -DUNDEF_THREADS_HACK -I./../include -I.. /include -I./.. -I..-I..-O3c cc1plus: Invalid option `-fno-exceptions' In file included from client_priv.h:19, from mysql.cc:28: ../include/global.h:685: warning: abstract declarator used as declaration make[2]: *** [mysql.o] Error 1 make[2]: Leaving directory `/home/mysql/instalador/mysql-3.23.49/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/home/mysql/instalador/mysql-3.23.49' make: *** [all-recursive-am] Error 2 What is 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Losing connection during a REPAIR TABLE
I believe I needed to upgrade at least to version 3.23.42. There was a bug fix where certain record lengths killed the REPAIR (See D.2.9). So I tried an upgrade problem is gone... whether or not my diagnosis was correct. I want to thank all that replied for your dead-on help. Also I have to say that not only was the help accurate succinct but the turnaround time was also stellar. rafe Michael Widenius wrote: Hi! rafe == rafe [EMAIL PROTECTED] writes: Description: rafe I am not subscribe to this list so please cc me in your reply. rafe I created a ~5GB table full of large (TINY|BIG)TEXT fields in it. This is a fresh build and there has been no activity except for the following: rafe 1) Record inserts from flat file parsing. rafe 2) OPTIMIZE TABLE wich died in batch caused me to try and run the REPAIR. rafe I've also tried complete rebuilds with the same data and I get the same crashi but builds with less data (~4GB) have worked. rafe The REPAIR TABLE dies repeatedly with: mysql repair table dna; rafe ERROR 2013: Lost connection to MySQL server during query rafe I've tried '-O max_allowed_packet=33554432' as per section A.2.2. But with the same results. REPAIR should be independent of max_allowed_packet. We have many users of MySQL with tables bigger than 4G, so this is not a general problem. Please take a backup of your table and try a repair with the 'myisamchk' utility. As Sinisa said, please try REPAIR with our latest binary. If you get the same problem with MySQL 3.23.49, can you give us access to a copy of that table so that we can fix this problem ASAP ? Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: history of MySQL
On Wed, Mar 13, 2002 at 07:05:40AM -0500, Alan Freedman wrote: Does anybody know the evolution of MySQL. I understand it evolved from mSQL, but the company is unwilling to discuss this history. It did not evolve from mSQL. It copied the mSQL API, but the code itself evolved from Unireg. Some folks at MySQL know the history quite well, as they often discuss it in presentations at conferences. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 34 days, processed 1,083,834,424 queries (367/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql hotcopy
Can anyone give me an example of how to run mysqlhotcopy from the command line? What can I expect as the output and where is the file created/ stored? Thanks Mark -Original Message- From: Michael Grassman [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Tuesday, March 12, 2002 11:59 PM Subject: xp and mysql 3.23.49-win I am trying to install mysql for use with iis4 and when I click on the setup.exe file an error message pops up but closes right away so I can't see the problem. has anyone had this frustrating experiance. If so please help. Thank Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error running scripts/mysql_install_db While installing AIX binaries
[EMAIL PROTECTED] writes: Description: shr.o not found in libz.a when running mysql-install_db How-To-Repeat: Output from mysql_install_db: root@cedar:/work/work/mysql/mysql-max-3.23.46-ibm-aix4.3.3.0-rs6000 scripts/mysql_install_db exec(): 0509-036 Cannot load program ./bin/my_print_defaults because of the following errors: 0509-150 Dependent module /usr/local/lib/libz.a(shr.o) could not be loaded. 0509-152 Member shr.o is not found in archive WARNING: The host 'cedar' 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 exec(): 0509-036 Cannot load program ./bin/mysqld because of the following errors: 0509-150 Dependent module /usr/local/lib/libz.a(shr.o) could not be loaded. 0509-152 Member shr.o is not found in archive Installation of grant tables failed! Hi! Yes, this is a known problem and will be fixed in 3.23.50, which should be out in 2 weeks. -- 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: MySQL Quits in Replication
From: Al Johnson [EMAIL PROTECTED] 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. 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. I don't know if it'll show anything, but if you haven't checked that, it may be worth a shot. Good luck! -- 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: installation problem
Hi, Try to start mySQL daemon like service in init 3. Good luck, Gelu - Original Message - From: Aman Raheja [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 13, 2002 12:00 AM Subject: Re: installation problem This is what's going on [root@coolnis-ar mysql]# Starting mysqld daemon with databases from /var/lib/mysql 020312 15:57:31 mysqld ended [1]+ Done./bin/safe_mysqld --user=mysql --err-log=my.err [root@coolnis-ar mysql]# more my.err 020312 15:56:40 mysqld started 020312 15:56:40 Can't start server : Bind on unix socket: Permission denied 020312 15:56:40 Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ? 020312 15:56:40 Aborting 020312 15:56:40 /usr/local/mysql/bin/mysqld: Shutdown Complete 020312 15:56:40 mysqld ended 020312 15:57:31 mysqld started 020312 15:57:31 Can't start server : Bind on unix socket: Permission denied 020312 15:57:31 Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ? 020312 15:57:31 Aborting 020312 15:57:31 /usr/local/mysql/bin/mysqld: Shutdown Complete 020312 15:57:31 mysqld ended [root@coolnis-ar mysql]# Any suggestions ? Thank you Aman Raheja _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
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 in advance, -- dsoares (sql) -- 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
Delete problem
Hi all, I'm trying to delete records with this query on php program: delete from Bands where ID_ALBUM IN (select ID_ALBUM from Albums where ID_GROUP = '$group') I use it on MSSQL and work fine but on mysql don't work, there's some other query that make the same result on mysql Thank's all - Moreno Riccardi - www.webtrade.it - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: [PHP-DB] Delete problem
MySQL does not currently support sub-selects. The manual says: DELETE [LOW_PRIORITY | QUICK] FROM table_name [WHERE where_definition] [ORDER BY ...] [LIMIT rows] Did you review the manual first? -Original Message- From: Riccardi Moreno [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 9:48 AM To: Php List; Mysql List Subject: [PHP-DB] Delete problem Hi all, I'm trying to delete records with this query on php program: delete from Bands where ID_ALBUM IN (select ID_ALBUM from Albums where ID_GROUP = '$group') I use it on MSSQL and work fine but on mysql don't work, there's some other query that make the same result on mysql Thank's all - Moreno Riccardi - www.webtrade.it -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.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
R: [PHP-DB] Delete problem
Yes i review manual many times without success -Messaggio originale- Da: Rick Emery [mailto:[EMAIL PROTECTED]] Inviato: mercoledì 13 marzo 2002 16.52 A: 'Riccardi Moreno'; Php List; Mysql List Oggetto: RE: [PHP-DB] Delete problem MySQL does not currently support sub-selects. The manual says: DELETE [LOW_PRIORITY | QUICK] FROM table_name [WHERE where_definition] [ORDER BY ...] [LIMIT rows] Did you review the manual first? -Original Message- From: Riccardi Moreno [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 9:48 AM To: Php List; Mysql List Subject: [PHP-DB] Delete problem Hi all, I'm trying to delete records with this query on php program: delete from Bands where ID_ALBUM IN (select ID_ALBUM from Albums where ID_GROUP = '$group') I use it on MSSQL and work fine but on mysql don't work, there's some other query that make the same result on mysql Thank's all - Moreno Riccardi - www.webtrade.it -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.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
Conflicting results using PHP/Mysql
Hi all, Posted this yesterday and got no response. Trying again today. I'm having a small problem with a biggish query. The query: $Itemlistquery= select [a whole load of fields from 3 tables] ending with ; $Itemlistquery.= transactions.Pdownload ; $Itemlistquery.= from bib_extract,scanrates,transactions where ; $Itemlistquery.= (transactions.CourseID = '$Course_ID' and ; $Itemlistquery.= bib_extract.E_ID=transactions.ExtractID and ; $Itemlistquery.= scanrates.finrate=transactions.finrate) ; The problem: If I do a simple count of transactions.CourseID='$Course_ID' I get 18 (for a particular course) and the above query only displays 3 results. Any suggestions? I didn't want to clog the list with the whole query but I can if it's necessary. George, in Edinburgh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Delete problem
Hi, If you expect only 1 result you can try: select (@myvar:=ID_ALBUM) from Bands where ID_GROUP='$group'; delete from Bands where ID_ALBUM=@myvar; Good luck, Gelu - Original Message - From: Riccardi Moreno [EMAIL PROTECTED] To: Php List [EMAIL PROTECTED]; Mysql List [EMAIL PROTECTED] Sent: Wednesday, March 13, 2002 5:48 PM Subject: Delete problem Hi all, I'm trying to delete records with this query on php program: delete from Bands where ID_ALBUM IN (select ID_ALBUM from Albums where ID_GROUP = '$group') I use it on MSSQL and work fine but on mysql don't work, there's some other query that make the same result on mysql Thank's all - Moreno Riccardi - www.webtrade.it - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Problem with openSSL and MySQL
Hello all. I downloaded the mysql v4.0.1 source and openssl 0.9.6c source. I built openssl OK I built mysql as follows: ./configure --with-vio --with-openssl make make install The build went well all the way. The mysql server seem to start ok. When I try to connect with mysql client after a few seconds I get the following error message mysqlshow databases; ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id:8 Current database: *** NONE *** a show variables; mysql show variables like 'have%'; ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id:15 Current database: *** NONE *** +---+---+ | Variable_name | Value | +---+---+ | have_bdb | NO| | have_innodb | YES | | have_isam | YES | | have_raid | NO| | have_symlink | YES | | have_openssl | YES | +---+---+ 6 rows in set (0.14 sec) I can see that ipenssl is running, but the server keeps loosing the connection. If I buld mysql without the --with-vio --with-openssl options all works ok, except of course I have no ssl. Has anyone gotten 4.0.1 to run with openssl? If so, please let me know what you did to make it work. Should I use an older version of openssl? Maybe 0.9.6b or 0.9.6a? Thanks, Jorge - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
starting mysql
i'm moving MySQL over to unix and i can't for the life of me get anything to work. i just want to use MySQL from my directory. no root users or anything like that. i just want to noodle around with the db as a 'local' user. so i installed the binaries, created my symbolic link, configured the db, and tried starting with mysql. (and safe_mysqld and safe_mysqld --user=mysqladmin) i receive a ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) i checked with my admin, and the socket exists. prior to this, we tried configuring the root user, changed owners, groups, etc and still no luck. (different error messages... usually tried starting with a password, password failed (password = YES) error... went through all the documented changes necessary to avoid this message. still got this message. gave up) any help would be appreciated. thanks, christian : yes, i've read the manual. and i'm reading the MySQL book - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Try the following: mysqlhotcopy -u root -p password dbname /path/to/copy/the/data/to so, if you want to copy the db foobar, you do the following: mysqlhotcopy -u root -p password foobar /backup/data and a new dir will be created called /backup/data/foobar with all the tables there -dan On Wednesday 13 March 2002 11:45, you wrote: Can anyone give me an example of how to run mysqlhotcopy from the command line? What can I expect as the output and where is the file created/ stored? Thanks Mark -Original Message- From: Michael Grassman [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Tuesday, March 12, 2002 11:59 PM Subject: xp and mysql 3.23.49-win I am trying to install mysql for use with iis4 and when I click on the setup.exe file an error message pops up but closes right away so I can't see the problem. has anyone had this frustrating experiance. If so please help. Thank Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysql hotcopy
Try the following: mysqlhotcopy -u root -p password dbname /path/to/copy/the/data/to so, if you want to copy the db foobar, you do the following: mysqlhotcopy -u root -p password foobar /backup/data and a new dir will be created called /backup/data/foobar with all the tables there -dan On Wednesday 13 March 2002 11:45, you wrote: Can anyone give me an example of how to run mysqlhotcopy from the command line? What can I expect as the output and where is the file created/ stored? Thanks Mark -Original Message- From: Michael Grassman [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Tuesday, March 12, 2002 11:59 PM Subject: xp and mysql 3.23.49-win I am trying to install mysql for use with iis4 and when I click on the setup.exe file an error message pops up but closes right away so I can't see the problem. has anyone had this frustrating experiance. If so please help. Thank Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Multiple charsets
I'm very much interested to know how do you manage multiple language support with mySQL. I haven't found how i can define different character sets for different tables or even for separate databases. Do i have to run several mySQL servers, one per each charset? Maybe, it is the solution for you, Kim: to run special daemon for serving two-byte charsets? Kim Albee wrote: I've run some tests, and right now we can support English, etc., but not the double byte languages. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Create database if does not exist.
I want to create a database test_db1, if test_db1 does not exist in the server using sql script. Is it possible? _ 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
JDBC and applet
Hello friends, I am having a problem using the MySQL JDBC driver from an applet. In my local machine's browser and on very few remote machine's browsers the applet works correctly, however in most remote machine's browsers it cannot find a suitable driver. What is wrong with my Java code? Or my applet tag? The applet is located at http://gharms.dhs.org/3.html. The Java code that calls JDBC is in http://gharms.dhs.org/Examples/FifthApplet/JDBCDataSource.java. Thanks in advance. Best regards, Gunnar Harms - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Multiple Column Keys with Auto Increment
At 01:02 AM 3/13/2002, you wrote: Greetings!!! I would just like to know if the following is normal: I created a file TRANSACTION_LOG.sql to create an InnoDB table with MULTIPLE KEYs with one AUTO COLUMN. The file consists of the following SQL commands: drop table TRANSACTION_LOG; create table TRANSACTION_LOG (SESSION_ID int(10) not null, TRANS_CODE int(5) not null, TRANS_LOG_ID int(10) not null auto_increment, primary key (TRANS_CODE,TRANS_LOG_ID)) TYPE = InnoDB; Unfortunately , I get the following error: [root@oracle /root]# mysql accounting TRANSACTION_LOG.sql ERROR 1075 at line 2: Incorrect table definition; There can only be one auto column and it must be defined as a key Does InnoDB tables support MULTIPLE KEYS with an AUTO COlumn? Edgar, Not officially. The InnoDb manual states auto-increment fields must be in a key by themselves. :-( But I've discovered you can have a compound index with an auto-increment field as long as the auto-increment field is the *first* field of the index. So if you switch your primary key to primary key (TRANS_LOG_ID,TRANS_CODE) it should work. :-) Brent _ 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: A bit OT: ColdFusion can't connect to MySQL via ODBC (newbie)
Hi !! -Original Message- From: Markus Lervik [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 1:22 AM To: [EMAIL PROTECTED] Subject: A bit OT: ColdFusion can't connect to MySQL via ODBC (newbie) Hello, list! I'm not quite sure that this is the right place to ask, but I'm having problems getting MySQL and ColdFusion Server 5 to work together. I have a ColdFusion server that connects to MySQL via ODBC. I've configured the Merant MySQL ODBC driver via the ColdFusion administrator, and it is able to connect to my MySQL database (at least it claims that the connection was successful when clicking verify in the CF admin). The datasource name is hpTest. However, trying to connect to the database in an CFM doesn't seem to work at all. My error message is ODBC Error Code = 08003 (Connection not open) [MERANT][ODBC lib] Connection not open The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (2:1) to (2:114). and the code goes like this: cfquery name=Test dbtype=ODBC dbname=hpTest datasource=hpTest SELECT * FROM hpTest /cfquery cfoutput query=hpTest#FieldName1#, #FieldName2#br/cfoutput I've been reading TFM, browsing TFW, reading TFML and I've even been to (*ghasp*) Microsofts ODBC-pages looking for an answer (and you know it's -bad- when that happens!g). Reading the manual I got the impression that coldfusion would open the connection when using a cfquery-tag. Any help is greatly appreciated. Cheers, Markus, tearing big lumps of hair out. We don't recommend to use third-party drivers with MySQL unless if they are from our parters or directly linking with MySQL. As we never tested the above driver(s) with MySQL, we can't comment any thing. We appriciate if you can make use of the following MySQL ODBC Drivers, as they are tested and working fine with CF. - MyODBC 2.50 (stable) and - MyODBC 3.51 (developmemt). For more information about MySQL ODBC, refer to http://www.mysql.com/products/myodbc/ Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Unicode support for MySQL
Victoria, Monday, March 11, 2002, 11:24:00 AM, you wrote: RT I am just wondering if the latest stable build of MySQL has support RT for Unicode character set so I can use it to store english, chinese and RT korean characters. If so please let me know. And also if there is going RT to be any problems to perform SELECT statements to search for a RT particular pattern. Much appreciated. VR Unicode will be supported in 4.0.3 version of MySQL. According to current schedule, unicode will be supported in 4.1 branch. -- 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
Composite primary key in MySQL
nagendra, Wednesday, March 13, 2002, 1:06:18 PM, you wrote: np Dear all, np Will MySQL supports composite primary key constraint? If so what np is the actual syntax? Yes, MySQL supports composite primary key. CREATE TABLE table1( id1 int NOT NULL, id2 int NOT NULL, PRIMARY KEY(id1, id2)); You can read about creating indexes in Paul DoBois's book MySQL. np How foreign key relationship can be np established in MySQL? Please help me. You can read about foreign keys in MySQL at: http://www.mysql.com/doc/A/N/ANSI_diff_Foreign_Keys.html Check this link, there you will find examples of foreign keys usage: http://www.mysql.com/doc/e/x/example-Foreign_keys.html np Prasad. -- 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
Delete problem
Riccardi, Wednesday, March 13, 2002, 5:48:28 PM, you wrote: RM Hi all, RM I'm trying to delete records with this query on php program: RM delete from Bands where ID_ALBUM IN (select ID_ALBUM from Albums where RM ID_GROUP = '$group') RM I use it on MSSQL and work fine but on mysql don't work, there's some other RM query that make the same result on mysql RM Thank's all MySQL doesn't currently support sub-selects. RM - Moreno Riccardi -- 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
Multiple charsets
Alex, Wednesday, March 13, 2002, 7:16:02 PM, you wrote: AK I'm very much interested to know how do you manage multiple language support with AK mySQL. AK I haven't found how i can define different character sets for different tables or AK even for separate databases. AK Do i have to run several mySQL servers, one per each charset? You can use only one character set at a time for one instance of mysqld. If you want to use two character sets you need to restart or start another instance of mysqld. AK Kim Albee wrote: -- 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
history of MySQL
Alan, Wednesday, March 13, 2002, 2:05:40 PM, you wrote: AF Does anybody know the evolution of MySQL. I understand it evolved from AF mSQL, but the company is unwilling to discuss this history. AF I write a computer encyclopedia and am trying to trace back the product. AF Can anyone help? You can look in the manual and find a short story at: http://www.mysql.com/doc/H/i/History.html AF Thanks. AF Alan -- 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: Sub-select look-alike?
If I understand your question, you just need to join with the languages table twice, using aliases: select LF.language, LT.language from language_pairs P, languages LF, languages LT where LF.id = P.from and LT.id = P.to; From: =?iso-8859-1?Q?Andreas_Fr=F8sting?= [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Sub-select look-alike? Date: Wed, 13 Mar 2002 16:12:31 +0100 Hi, I have two tables: languages: id tinyint(3) unsigned not null, language varchar(30) not null language_pairs: from tinyint(3) unsigned not null, to tinyint(3) unsigned not null language_pairs.from and language_pairs.to are linked with languages.id (both tables are simplified in this mail and contains a lot more columns, but they are not relevant) Now I want to do a query giving me the names of the languages (languages.language) instead of language_pairs.from og .to. I can only see a solution requiring the use of sub-selects which MySQL doesn't (yet :) has support for. Anyone smarter than me who can see a solution? I want to avoid use of sub-queries if possible, and my emergency plan is to extract all records from `languages` into an array in PHP and simply use PHP to join .from and .to with the matching language. That's not in any way optimal, that's why I'm asking you guys :) regards, //andreas http://phpwizard.dk (in Danish only) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Create database if does not exist.
On Wed, Mar 13, 2002 at 09:40:44AM -0800, Radhakrishna Mohan Tadepalli wrote: I want to create a database test_db1, if test_db1 does not exist in the server using sql script. Is it possible? From http://mysql.com/doc/C/R/CREATE_DATABASE.html 6.5.1 CREATE DATABASE Syntax CREATE DATABASE [IF NOT EXISTS] db_name CREATE DATABASE creates a database with the given name. Rules for allowable database names are given in section 6.1.2 Database, Table, Index, Column, and Alias Names. An error occurs if the database already exists and you didn't specify IF NOT EXISTS. Did you even check the on-line manual? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 and MSAccess
Haven't done a great deal of this but it does work pretty well. Obviously connection speed is a bit of an issue especially where you are dealing with INSERTS into several linked tables from a form. I couldn't find an equivalent field in MySQL for the Yes/No type in Access so it you create an a 2 character INT field and populate it with either 0 (no) or -1 (Yes) then you can get them to work quite well. I'm sure that some guru will have a better idea than that! What sort of stuff are you doing? Craig shepherd -Original Message- From: Chris Becker [mailto:[EMAIL PROTECTED]] Sent: 11 March 2002 20:08 To: [EMAIL PROTECTED] Subject: MySQL and MSAccess Anyone using MySQL on Linux/Unix with a MSAccess front end? Using odbc bound controls? Any issues, insights, suggestions? How's the interaction with the Jet engine? Any performance issues? Thanks in advance. Chris _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: starting mysql
ensure that /tmp has correct read-write-execute permissions -Original Message- From: Hresko, Christian A. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 10:57 AM To: '[EMAIL PROTECTED]' Subject: starting mysql i'm moving MySQL over to unix and i can't for the life of me get anything to work. i just want to use MySQL from my directory. no root users or anything like that. i just want to noodle around with the db as a 'local' user. so i installed the binaries, created my symbolic link, configured the db, and tried starting with mysql. (and safe_mysqld and safe_mysqld --user=mysqladmin) i receive a ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) i checked with my admin, and the socket exists. prior to this, we tried configuring the root user, changed owners, groups, etc and still no luck. (different error messages... usually tried starting with a password, password failed (password = YES) error... went through all the documented changes necessary to avoid this message. still got this message. gave up) any help would be appreciated. thanks, christian : yes, i've read the manual. and i'm reading the MySQL book - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
a quick sanity check...
Hi all -- I just need a quick sanity check on a query. I have two tables: CREATE TABLE users ( userID VARCHAR(10) NOT NULL PRIMARY KEY, [many other fields] ) CREATE TABLE subscriptions ( userID VARCHAR(10) NOT NULL, listID INT NOT NULL ) In these tables, users.userID == subscriptions.userID. The users table keeps 1 record per userID, and the subscriptions table keep multiple records per userID (one for each listID to which they're subscribed). If I wanted to select all users from the users table that *do not* appear in the subscriptions table, I'd want the following query: SELECT users.* FROM users LEFT JOIN subscriptions ON users.userID=subscriptions.userID WHERE subscriptions.userID IS NULL Correct? I know that this is a pretty base example, but I'd like to confirm it (outside of an example in a book) with someone a bit more knowledgable than me. There are a couple other reports here that calculate this number in other ways, and I'd like to be able to positively state that this is the be-all end-all for the needed data. Much thanks! -- 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
problem with installing
I tried to run mysql.server start on mysql that I just installed. OS I use is SCO Open Server Rel 5.00 The error I received is [EMAIL PROTECTED] [/usr/local/mysql]:mysql.server start ./support-files/mysql.server: @HOSTNAME@: not found [EMAIL PROTECTED] [/usr/local/mysql]:Starting mysqld daemon with databases from /usr/local/mysql/data 020313 14:07:14 mysqld ended Description : mysqld ended everytime I start the server which's not supposed to. Any help is really highly appreciated M Waluyo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Hello, I am attempting to add the ROOT user as a MYSQL administrator using the following syntax: mysqladmin -u root password 12345 and I recieve the following error: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' anyone have any ideas? Regards, Adrian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[bug] MySQLGUI 1.7.5-1 crash with year column type
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. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Thanks Dan - Quick question - I have a db named content with user admin and pass mypass Do I still use -u root p maypass ? or would I use mysqlhotcopy -u admin -p mypass content /path/to/copy/the/data/to Thanks again for your help. Mark -Original Message- From: Dan Patnaude [EMAIL PROTECTED] To: Mark Stringham [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Wednesday, March 13, 2002 10:41 AM Subject: Re: mysql hotcopy Try the following: mysqlhotcopy -u root -p password dbname /path/to/copy/the/data/to so, if you want to copy the db foobar, you do the following: mysqlhotcopy -u root -p password foobar /backup/data and a new dir will be created called /backup/data/foobar with all the tables there -dan On Wednesday 13 March 2002 11:45, you wrote: Can anyone give me an example of how to run mysqlhotcopy from the command line? What can I expect as the output and where is the file created/ stored? Thanks Mark -Original Message- From: Michael Grassman [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Tuesday, March 12, 2002 11:59 PM Subject: xp and mysql 3.23.49-win I am trying to install mysql for use with iis4 and when I click on the setup.exe file an error message pops up but closes right away so I can't see the problem. has anyone had this frustrating experiance. If so please help. Thank Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Selecting across servers
Is it possible to issue 1 select that gathers data from databases on 2 separate servers? =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * 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: varchar attributes
Sorry, please excuse this post. I found the problem. A single space in front of the account number. Thanks Richard D. Williams [EMAIL PROTECTED] wrote: 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 all, I am new to the list. Situation: A field in a table is set to a length of 10 and varchar. When alpha and numeric characters are in the field select using the equal sign is no problem. But, if only numeric characters are in the field the equal relation does not select any records. If I use the like relationship the records are selected, but much slower. Question: Is there a valid problem here? Is there a special way to get these records selected using the equal operator? Again, just to be clear; SELECT * FROM wip WHERE acct_num = '111', does not select records. SELECT * FROM wip WHERE acct_num like '%111%', does select records. acct_num is a 10,varchar field Thanks, Richard D. Williams - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Multiple charsets
At 13:26 2002-03-13, Victoria Reznichenko wrote: Alex, Wednesday, March 13, 2002, 7:16:02 PM, you wrote: AK I'm very much interested to know how do you manage multiple language support with AK mySQL. AK I haven't found how i can define different character sets for different tables or AK even for separate databases. AK Do i have to run several mySQL servers, one per each charset? You can use only one character set at a time for one instance of mysqld. If you want to use two character sets you need to restart or start another instance of mysqld. Is it something that someone is thinking about? Examples of it's use are abundant, to use a trivial one: my books. I have books in German, English, French, Polish, Russian and Czech. Obviously, they will require differing charsets to represent their titles and authors. As obviously, if I search for all the books on a specific subject, I want to find all I have, no matter which language they were published in. Single-charset restriction prevents me from doing that, I will have to perform as many searches as I have languages, wasting both time and resources: both at runtime and during development. Or am I completely out of my tree? -- 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: problem with installing
On Wed, 13 Mar 2002, Mohamad Waluyo wrote: I tried to run mysql.server start on mysql that I just installed. OS I use is SCO Open Server Rel 5.00 The error I received is [EMAIL PROTECTED] [/usr/local/mysql]:mysql.server start ./support-files/mysql.server: @HOSTNAME@: not found [EMAIL PROTECTED] [/usr/local/mysql]:Starting mysqld daemon with databases from /usr/local/mysql/data 020313 14:07:14 mysqld ended Description : mysqld ended everytime I start the server which's not supposed to. Any help is really highly appreciated Do you have all the patches installed? This version had major flaws that only an upgrade to at least 5.0.4 will fix. I really recommend updating to 5.0.6a You have to have all patches installed to even have a chance of it working. Make sure you have installed the threads package and the libraries and linkers. Then install the patches. Some patches for the Developement System fix libraries and the linker. You may also need to install some of the Skunkware files. This version needed the Skunkware to be installed as well. Good Luck, -- Boyd Gerber [EMAIL PROTECTED] ZENEZ 3748 Valley Forge Road, Magna Utah 84044 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 08:13 2002-03-13, Heikki Tuuri wrote: Tomasz, InnoDB in 3.23 and 4.0 is the same codebase. InnoDB versions are best counted from the 3.23 series, because they appear more frequently. I am sorry that this is confusing. MySQL/InnoDB-3.23.50 has not been released yet. It will probably be out at the end of March. OK, so I can just hang up my hat till then. 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)? Starting from version 3.23.50 InnoDB returns the foreign key definitions of a table when you call And which MySQL uses it? Can it be plugged into existing MySQL? SHOW CREATE TABLE yourtablename You can also list the foreign key constraints for a table T with SHOW TABLE STATUS FROM yourdatabasename LIKE 'T' The foreign key constraints are listed in the table comment of the output. Best regards, Thanks a lot, hopefully You helped not just me 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: Tomasz Korycki [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Date: Wednesday, March 13, 2002 1:05 AM Subject: constraints in InnoDB, or is 3.23.43b _really_ 4.0.1? Here is an excerpt from http://www.innodb.com/ibman.html#InnoDB_distros, section 4.2: Starting from version 3.23.43b InnoDB features foreign key constraints. InnoDB is the first MySQL table type which allows you to define foreign key constraints... Now, I assumed the version number above was suspiciously similar to MySQL one - and since I use 4.0.1, I thought I was OK (I need them references... ON DELETE and friends would be great, but plain references save most of the hassle). After trying to (and failing to) create my own tables, I did tables as in the example on InnoDB site: CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=InnoDB; CREATE TABLE child(id INT, parent_id INT, INDEX par_ind (parent_id), FOREIGN KEY (parent_id) REFERENCES parent(id)) TYPE=InnoDB; And what do I see? I see indices in the tables, but no FK! Yes, tables _are_ InnoDB. I have proper indices - so on to the next step (there was no error return), just in case - it says: Starting from version 3.23.50 InnoDB allows you to add a new foreign key constraint to a table... So, here I go: ALTER TABLE child ADD CONSTRAINT FOREIGN KEY (parent_id) REFERENCES parent(id); No error. No effect, either... So, here comes the big question: What am I doing wrong? -- sql, query Tomasz Korycki [EMAIL PROTECTED] -- sql, query Tomasz Korycki [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: Selecting across servers
Nope; two databases on the same server OK, but not different servers. Ken - Original Message - From: Cal Evans [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 13, 2002 4:00 PM Subject: Selecting across servers Is it possible to issue 1 select that gathers data from databases on 2 separate servers? =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Solaris, MyODBC, Access DB converter
Does anyone know if the MyODBC binary for Solaris 2.7 will work ok on 2.8, or will I need to compile from source? For anyone who's interested, we're in the process now of migrating from Access/ColdFusion/NT to MySQL/ColdFusion/Solaris in our web development environment. As far as software to convert our old Access DB's, we've had good luck so far with Access-To-MySQL and MySQL-To-Access from http://www.convert-in.com/, although YMMV. It's the only converter we found that actually manages datetime/timestamp migration properly. Thanks! Mark R. Andrachek, Jr. Analyst I Federal Reserve Bank of Richmond [EMAIL PROTECTED] (804) 697-7971 -- The views and opinions expressed above are soley those of the author and may or may not reflect the views of the Federl Reserve Bank of Richmond. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 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.. 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 : | ITEM | InnoDB | Dynamic| 0 | 0 | 16384 |NULL |0 | 0 | NULL | NULL | NULL| NULL || InnoDB free: 4901888 kB | | ITEM_DEF | InnoDB | Dynamic| 0 | 0 | 16384 |NULL |16384 | 0 | NULL | NULL | NULL| NULL || InnoDB free: 4901888 kB; (ITEM_NAME) REFER dbname/ITEM(ITEM_NAME) mysql describe ITEM; +-+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-+---+ | ITEM_NAME | varchar(64) | | PRI | | | | DESCRIPTION | varchar(255) | YES | | NULL| | +-+--+--+-+-+---+ 2 rows in set (0.02 sec) mysql describe ITEM_DEF; ++-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | ++-+--+-+-+---+ | ITEMDEF_ID | int(11) | | PRI | 0 | | | ITEM_NAME | varchar(64) | YES | MUL | NULL| | ++-+--+-+-+---+ 2 rows in set (0.00 sec) show create table ITEM; +---+-- --- ---+ | Table | Create Table | +---+-- --- ---+ | ITEM | CREATE TABLE `ITEM` ( `ITEM_NAME` varchar(64) NOT NULL default '', `DESCRIPTION` varchar(255) default NULL, PRIMARY KEY (`ITEM_NAME`) ) TYPE=InnoDB | +---+-- --- ---+ 1 row in set (0.00 sec) mysql show create table ITEM_DEF; +--+--- --- + | Table| Create Table | +--+--- --- + | ITEM_DEF | CREATE TABLE `ITEM_DEF` ( `ITEMDEF_ID` int(11) NOT NULL default '0', `ITEM_NAME` varchar(64) default NULL, PRIMARY KEY (`ITEMDEF_ID`), KEY `FK_ITEM_NAME_INDEX` (`ITEM_NAME`) ) TYPE=InnoDB | +--+--- --- + 1 row in set (0.00 sec) Hopefully this might shed some light on your problem.. Below are the samples from above that you can feed directly into MySQL and see what it produces.. These work fine on our installation of 3.23.47 -- with InnoDB support enabled of course.. /*==*/ /* Table: ITEM */ /*==*/ create table if not exists ITEM ( ITEM_NAME varchar(64)not null, DESCRIPTIONvarchar(255), primary key (ITEM_NAME) ) TYPE=INNODB; /*==*/ /* Table: ITEM_DEF */
ADO API ODBC Alternative help
Hi, I am a beginner developer trying to use mySQL ODBC with ADO. I am using ADO library version 2.5, and Visual Basic 5.0/6.0 (doesn't really matter). Here is my configuration: - mySQL ODBC Version 02.50.38 - mySQL server Version 02.50.38 - Windows NT 4.0 with SP6 It seems like, mySQL does not implement all the ADO functionality. My questions will be: 1- what is the set of functions in ADO that mySQL supports? Can I find documentation about it? 2- If ADO is not fully supported, what other ways have people used for database programming? DAO? RDO? Raw ODBC API call? Now for the specific problem I have, I have this code in VB: rsTest.AddNew rsTest.Fields(login).Value = CStr(kelvin) rsTest.Update rsTest.Fields(Password).Value = CStr(testing) rsTest.Update rsTest.Fields(Fullname).Value = CStr(my name) rsTest.Update rsTest.Fields(securitylevel).Value = 1 rsTest.Update - I get an adStateOpen for both connection and recordset. - The ADO connection opened correctly. The ADO recordset opened correctly as well. - The AddNew executed without error. - The setting of login value executed without error. - When I hit the line setting value of password, I get the following message: Run-time error '-2147217887 (80040e21)': Multiple-step operation generated errors. Check each status value. What did I do wrong? Kelvin Lam Software Engineer Orbit Technology Corp 1528 Brookhollow Dr, Suite 66 Santa Ana, CA 92705 Phone: (714)427-0555 Fax: (714)427-0556 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ADO API ODBC Alternative help
Get your VB Manuals out, or test your programme against an Access Data Base. Once you have issed an Update statement, you need to either retrieve the record for further update or set all the fields then issue the Update statement! This is very 'Off Topic Clive Smart Kelvin Lam wrote: Hi, I am a beginner developer trying to use mySQL ODBC with ADO. I am using ADO library version 2.5, and Visual Basic 5.0/6.0 (doesn't really matter). Here is my configuration: - mySQL ODBC Version 02.50.38 - mySQL server Version 02.50.38 - Windows NT 4.0 with SP6 It seems like, mySQL does not implement all the ADO functionality. My questions will be: 1- what is the set of functions in ADO that mySQL supports? Can I find documentation about it? 2- If ADO is not fully supported, what other ways have people used for database programming? DAO? RDO? Raw ODBC API call? Now for the specific problem I have, I have this code in VB: rsTest.AddNew rsTest.Fields(login).Value = CStr(kelvin) rsTest.Update rsTest.Fields(Password).Value = CStr(testing) rsTest.Update rsTest.Fields(Fullname).Value = CStr(my name) rsTest.Update rsTest.Fields(securitylevel).Value = 1 rsTest.Update - I get an adStateOpen for both connection and recordset. - The ADO connection opened correctly. The ADO recordset opened correctly as well. - The AddNew executed without error. - The setting of login value executed without error. - When I hit the line setting value of password, I get the following message: Run-time error '-2147217887 (80040e21)': Multiple-step operation generated errors. Check each status value. What did I do wrong? Kelvin Lam Software Engineer Orbit Technology Corp 1528 Brookhollow Dr, Suite 66 Santa Ana, CA 92705 Phone: (714)427-0555 Fax: (714)427-0556 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
How do I get the time?
I'm trying time a export process but I cant figure out what the right sql statement. I tried using getdate() but it gives me an error. Any Ideas??? Kathy Reyes Live Technology International 2975 Westchester Avenue Suite 103 Purchase, NY 10577 Tel: (914) 490-7096 [EMAIL PROTECTED] www.LiveTechnology.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: ADO API ODBC Alternative help
From your point of view it's off-topic (and it is), but from his the problem could be anything, including MySQL. You did, however, produce the proper answer, since this is an ADO issue, and I further provide a link to the relevant Knowledge Base article: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q294160 My suggestion to Kelvin is that you don't Update until you have set all the fields you need to set. GJ -Original Message- From: c.smart [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 5:20 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: ADO API ODBC Alternative help Get your VB Manuals out, or test your programme against an Access Data Base. Once you have issed an Update statement, you need to either retrieve the record for further update or set all the fields then issue the Update statement! This is very 'Off Topic Clive Smart Kelvin Lam wrote: Hi, I am a beginner developer trying to use mySQL ODBC with ADO. I am using ADO library version 2.5, and Visual Basic 5.0/6.0 (doesn't really matter). Here is my configuration: - mySQL ODBC Version 02.50.38 - mySQL server Version 02.50.38 - Windows NT 4.0 with SP6 It seems like, mySQL does not implement all the ADO functionality. My questions will be: 1- what is the set of functions in ADO that mySQL supports? Can I find documentation about it? 2- If ADO is not fully supported, what other ways have people used for database programming? DAO? RDO? Raw ODBC API call? Now for the specific problem I have, I have this code in VB: rsTest.AddNew rsTest.Fields(login).Value = CStr(kelvin) rsTest.Update rsTest.Fields(Password).Value = CStr(testing) rsTest.Update rsTest.Fields(Fullname).Value = CStr(my name) rsTest.Update rsTest.Fields(securitylevel).Value = 1 rsTest.Update - I get an adStateOpen for both connection and recordset. - The ADO connection opened correctly. The ADO recordset opened correctly as well. - The AddNew executed without error. - The setting of login value executed without error. - When I hit the line setting value of password, I get the following message: Run-time error '-2147217887 (80040e21)': Multiple-step operation generated errors. Check each status value. What did I do wrong? Kelvin Lam Software Engineer Orbit Technology Corp 1528 Brookhollow Dr, Suite 66 Santa Ana, CA 92705 Phone: (714)427-0555 Fax: (714)427-0556 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: How do I get the time?
* Kathy Reyes I'm trying time a export process but I cant figure out what the right sql statement. I tried using getdate() but it gives me an error. getdate() is not a valid mysql function, try NOW() or CURTIME(). URL: http://www.mysql.com/doc/D/a/Date_and_time_functions.html -- 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 do I get the time?
Hi Kathy, Are you trying to get current time in mysql ?? If yes, you can do it by issuing: SELECT NOW(); statement... Gurhan -Original Message- From: Kathy Reyes [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 5:17 PM To: [EMAIL PROTECTED] Subject: How do I get the time? I'm trying time a export process but I cant figure out what the right sql statement. I tried using getdate() but it gives me an error. Any Ideas??? Kathy Reyes Live Technology International 2975 Westchester Avenue Suite 103 Purchase, NY 10577 Tel: (914) 490-7096 [EMAIL PROTECTED] www.LiveTechnology.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
Please help! - About doing a delete.
Hi everyone, I've got a really annoying problem with mysql, and I was hoping someone could help. I've got 2 tables in Mysql: Table 1 - Topics | topic_id | name | subject | comment | - | 1 | john | weather| the weather today blah blah| Table 2 - Messages |message_id | topic_id | name | subject | comment | - | 12| 1 | billy | yes it ...| i totally agree| Basically, in the messages table, each row has its own unique id, but also a topic_id column which relates to the topic_id in the Topics table. What I want to do is delete all messages in the message table for which the relating topic_id has been already deleted in the Topics table. For example, if the row with topic_id 5 was deleted in Topics table, I want to make sure there are no messages in the Messages table which have a topic_id of 5. Please please, any help would be greatly appreciated. I'm running MySQL 3.23.46 on UNIX. TIA! sunny - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SELECT is using wrong key AND getting wrong results
Description: SELECT fullTextMatches.realname, fullTextMatches.address, fullTextMatches.address2, fullTextMatches.city, fullTextMatches.state, fullTextMatches.zip, fullTextMatches.country, fullTextMatches.email, fullTextMatches.homephone, fullTextMatches.workphone, fullTextMatches.userid FROM tums.fullTextMatches, orders.header USE INDEX (userId) WHERE header.storeId=/stores/eyarn AND header.userId=fullTextMatches.userId ORDER BY realname generates different results and is much faster than the same query without USE INDEX(userId): Here is the explain with the USE INDEX: +-+--+--++-+--+--++ | table | type | possible_keys| key | key_len | ref | rows | Extra | +-+--+--++-+--+--++ | fullTextMatches | ALL | NULL | NULL |NULL | NULL | 15 | Using filesort | | header | ref | storeId,userid,storeId_2,storeStatus | userid | 4 | fullTextMatches.userid |3 | where used | +-+--+--++-+--+--++ and without: +-+---+--+-+-+--+++ | table | type | possible_keys| key | key_len | ref | rows | Extra | +-+---+--+-+-+--+++ | fullTextMatches | ALL | NULL | NULL |NULL | NULL | 15 | Using filesort | | header | range | storeId,userid,storeId_2,storeStatus | storeStatus | 64 | NULL | 116907 | where used | +-+---+--+-+-+--+++ Without the USE INDEX zero records match. With the USE INDEX I get 13 matches. How-To-Repeat: mysql show fields from orders.header; +---+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-++ | storeId | varchar(64) | | MUL | || | shiptoOrganization| varchar(64) | YES | | NULL|| | shippingAddress | text | YES | | NULL|| | shippingCity | varchar(128) | YES | | NULL|| | shippingState | varchar(20) | YES | | NULL|| | shippingZipCode | varchar(10) | YES | | NULL|| | shippingCountry | varchar(30) | YES | | NULL|| | billtoOrganization| varchar(64) | YES | | NULL|| | billingAddress| text | YES | | NULL|| | billingCity | varchar(128) | YES | | NULL|| | billingState | varchar(20) | YES | | NULL|| | billingZipCode| varchar(10) | YES | | NULL|| | billingCountry| varchar(30) | YES | | NULL|| | businessName | varchar(128) | YES | | NULL|| | customerName | varchar(128) | YES | | NULL|| | shipType | varchar(128) | YES | | NULL|| | paymentType | varchar(128) | YES | | NULL|| | homePhone | varchar(20) | YES | | NULL|| | workPhone | varchar(20) | YES | | NULL|| | referringPage | text | YES | | NULL|| | customerEmail | varchar(128) | YES | MUL |
RE: Selecting across servers
How do you do it from different databases on the same server? David Buerer Senior Designer PLA Designs, Inc. -Original Message- From: Ken Menzel [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 1:21 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Selecting across servers Nope; two databases on the same server OK, but not different servers. Ken - Original Message - From: Cal Evans [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 13, 2002 4:00 PM Subject: Selecting across servers Is it possible to issue 1 select that gathers data from databases on 2 separate servers? =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [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