Re: Can't run the mysql deamon on linux
Date |Tue, 28 Aug 2001 03:16:59 -0230 (NDT) From |Neil Zanella [EMAIL PROTECTED] Hello! NZ RedHat 7.1 users: NZ The command used to start mysqld on this platform is simply (as root): NZ # /etc/init.d/mysqld start NZ This is _all_ that is required. NZ Once that works you can set NZ the mysql root user's password NZ with mysqladmin if you are NZ concerned about security NZ on your intranet. NZ Neil You can also read more about post-installation procedures here: http://www.mysql.com/doc/P/o/Post-installation.html ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ 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: Select in groups of 5
Date |Mon, 27 Aug 2001 18:32:57 -0500 From |Tyler Longrne [EMAIL PROTECTED] Hello! TL Hello everyone, TL Is there any way to make selections in groups of 5. I want to get 5 record TL sets at a time until we get to a point that there's 4 or less records. TL Thank you everyone, TL Tyler TL database,sql,query,table You can use select ... limit x,y syntax http://www.mysql.com/doc/S/E/SELECT.html or make slightly more complex query - for example select * from test where x1 and x5 ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ 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
reports? from MySQL
hello. with a lot of help from many of you and some very nice folks, i have been able to build some example/experiment/'mess around' type of dbs. yay. i'd like to ask... if any of you are familar with (File Maker Pro, most recent versions)... how does one go about using MySQL to create a printable report? e.g., where you select the fields you wanted in the report and then create a layout and page setup for the report, (then print it)? ALL 'directional' aids are welcome... books, websites, tips, personal knowledge. EXAMPLES are super. Thanks in Advance. TR - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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+InnoDB
Date |Mon, 27 Aug 2001 18:16:43 -0400 From |alexus [EMAIL PROTECTED] Hello! A hi A i'm trying to setup mysql w/ InnoDB A i followed all steps from http://www.mysql.com/doc/I/n/InnoDB_start.html A and i'm end up with this in my log every time i run mysql and in addition it A ends A here is log file from first time i run mysql A InnoDB: Error: all log files must be created at the same time. A InnoDB: If you want bigger or smaller log files, A InnoDB: shut down the database and make sure there A InnoDB: were no errors in shutdown. A InnoDB: Then delete the existing log files. Edit the .cnf file A InnoDB: and start the database again. A 010827 17:11:13 Can't init databases A 010827 17:11:13 mysqld ended A any ideas? A thank you in advance You can read answer in your logs. Just stop mysqld daemon, remove all log files and start daemon again. ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ 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: msg board with efficient threaded view design?
Date |Mon, 27 Aug 2001 14:14:22 -0700 From |PR [EMAIL PROTECTED] Hello! P I was wondering if anyone could point me to a message board (perl or php) P that has a very efficient database design to handle threaded views. I know P that this is a difficult task under mysql and have seen the threads on P recursive queries, but I'd like to find some real life examples rather than P start completely from scratch. P I'm currently using wwwthreads, but under under really high user loads it P can get bogged down because of the number of queries it's making to get all P the replies in the proper threaded order. I know UBB and vBulletin don't P do threaded views. Has anyone seen one that handles threading reasonably P efficiently? Check http://phorum.org/ - it's not big phorum system with threaded view and mysql as one of data storage. ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ 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: image data type
Date |Mon, 27 Aug 2001 15:31:26 -0700 From |John Meyer [EMAIL PROTECTED] Hello! JM At 09:15 AM 8/28/01 +1200, you wrote: Hi there, I treat image data type as text, does anyone know how to insert an image into the table? JM the image data type is actually a BLOB, not text. Usually, it's more JM efficent to have the field be text, and just store the path to the image JM (C:\my\path\to\image.gif (Win32) or /home/user/path/to/image.gif (Unix)). It's right. I can add also what may be you want to use MEDIMUBLOB or LARGEBLOB types. Read more about it here: http://www.mysql.com/doc/B/L/BLOB.html and here: http://www.mysql.com/doc/n/o/node_361.html ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ 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
Updating auto_increment ID Column/Selecting Duplicate Rows
hi, i have 2 questions that i badly need answered. i use phpmyadmin, but any answers containing SQL syntax should work in this app... 1) this should be simple but i don't know it. i use the following mysql table field as the Key for my tables: id int(10) unsigned NOT NULL auto_increment, now, when i have to clean up items in my tables, like when users have sent off a .html form multiple times and i want to delete duplicate submissions, how can i quickly easily update all of the 'id' fields in the entire table, to reflect the numeration change? now, using phpmyadmin, if i go in and delete a few entries, the id's have gaps in them. 2) in a table i have a column called User. some people have entered things into this table multiple times. how do i create a SELECT statement to select only those rows that have multiple Users? i need something like this (but this is wrong, of course): SELECT * FROM mail_form2 WHERE 'count(User) 1' many thanks from a newbie, tom - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Need Help Setting Up MySQL on Win98
Date |Mon, 27 Aug 2001 12:54:25 -0700 (PDT) From |S K Bryan [EMAIL PROTECTED] Hello! SKB Hello - SKB I'm very new at this, so please pardon the very beginner questions... SKB I'm attemtping to install MySQL to my local machine running Win98. The SKB install seems to go alright, but when I try mysqld--standalone it SKB gives me an error. Then I tried mysqld -standalone, which seemed to SKB work. SKB Then I entered, mysqladmin create testDB and I got the error message SKB Can't connect to MySQL Server on 'localhost'. I tried telnetting to SKB telnet localhost 3306 and got an error that it couldn't connect. SKB Can anyone offer help? You need to use just c:\mysql\bin\mysqld command to start mysqld Also note that you need to have winsock 2 installed on your Win. http://www.mysql.com/doc/W/i/Win95_start.html ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ 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
Help with blobs
Hi All, can someone point me in the right direction for saving formatted RichEdit Text to a blob field and then loading the RichEdit field with the data from the blob. I am using Borland Builder 5 odbc to MySQL database. Regards Doug [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
Need info
Hello Everybody :-) Well, I just suscribed to the mailing lists and would like to know a few more things about mysql. I have heard a lot about it and i think i will enjoy learning it a lot. I would be glad if anyone could care answering to my query. what is mysql most usefull for ,i mean in what areas of technology are people using mysql, is it web or whatever and how successfull is it. I am sorry if i sound stupid. hope i can get a response as soon as possible. many thanx Nilesh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Need info
Hi Nilesh MySQL is very fast but has not got all the things SQL can have (this is for speed). So we use it for web sites and for authenticating users over radius. Simon -Original Message- From: Nilesh Keshavji Parmar [mailto:[EMAIL PROTECTED]] Sent: 28 August 2001 09:05 To: [EMAIL PROTECTED] Subject: Need info Hello Everybody :-) Well, I just suscribed to the mailing lists and would like to know a few more things about mysql. I have heard a lot about it and i think i will enjoy learning it a lot. I would be glad if anyone could care answering to my query. what is mysql most usefull for ,i mean in what areas of technology are people using mysql, is it web or whatever and how successfull is it. I am sorry if i sound stupid. hope i can get a response as soon as possible. many thanx Nilesh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: unique()
Date |Sat, 25 Aug 2001 00:24:07 +0200 From |Boaz Yahav [EMAIL PROTECTED] Hello! BY Hi BY I have a table with a filed that is unique (used unique() in the BY creation). BY how do I undo this unique()? unique is an index property. Just remove them by ALTER TABLE command http://www.mysql.com/doc/A/L/ALTER_TABLE.html ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ 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: ERROR: Lost connection to MySQL server during query
Date |Fri, 24 Aug 2001 14:08:43 -0400 (EDT) From |boulat [EMAIL PROTECTED] Hello! B Hi group, B Im using the latest mySQL 3.23.41, ever since I installed the new B version I've been getting Lost connection to MySQL server during query B 50% of the time on my mySQL server. I have a load average of 247 queries B per second accordig to mysqladmin status. B Anyone experienced the same problem with mySQL? B Regards, B Boulat Looks like you need to increase queries packet buffer by start mysqld with -O max_alowed_packed=# http://www.mysql.com/doc/G/o/Gone_away.html ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ 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: Error: 6 (Errcode: 13)
Date |Fri, 24 Aug 2001 14:09:20 -0500 From |Tyler Longren [EMAIL PROTECTED] Hello! TL DROP TABLE Track TL Error: 6 - Error on delete of '.\sports\track.ISD' (Errcode: 13) TL Anyone know what that means? As you can see, it came from tryign to do a TL DROP on a table. TL Thanks, TL Tyler Longren Looks like file permissions problems. Check this instructions: http://www.mysql.com/doc/F/i/File_permissions.html ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ 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: Max table size in MySQL on Redhat 7.0 be default
Date |Fri, 24 Aug 2001 10:29:53 -0700 From |Benjamin Arai [EMAIL PROTECTED] Hello! BA What is the maximum table size allowed by MySQL and Redhat 7.0 be default? BA Benjamin Arai Read about it here: http://www.mysql.com/doc/T/a/Table_size.html ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ 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 and GPL license: questions and discussion
Neil Zanella writes: 1. What was the name of the first GPL file release of MySQL? 3.23.xx 2. Which portions are not distributed by mysql.com as part of MySQL? All are. 3. Which portions of the Windows MySQL release are not released under the GPL if any? For instance is the windows installer program (is there one?) released under the GPL? All stuff built by us is under GPL. Install program is not ours, it is standard Windows program. 4. Are the Linux versions shipped with Red Hat 7 and 7.1 entirely distributed under the GPL? Yes. 5. Do PHP web applications that use PHP and MySQL require a MySQL license? Such applications are not derivative works as they are merely interfaces. Thus they do not require a license. Correct? Only if you sell your PHP application to somebody, and that somebody requires to install server. Otherwise, no licence. References: 1. http://www.mysql.com/news/article-36.html (announces GLP release of source code) The most ambiguous aspect of the GPL is that it does not seem to clearly specify what and what not comprises a derivative work. Does a web application which uses MySQL comprise a derivative work. I don't think so. Do such web applications have to be placed under the GPL. I don't see anything in the GPL that states this. Thanks for the clarification, Neil If you use that PHP program for your site, there are no licences and no need to publish anything. -- 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
Equivalent as UNION (Oracle)
Hi, We have Oracle SQL statements that uses UNION is there an equivalent for this in mySQL? // Jocke - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ezmlm response
Hi all, I work with mysql 3.23.40 on Mac Os X 10.0.x and have created a Database. This Database has to move to another mysql server 3.23.40 on a Mac OS X Server. In older versions (up to 3.23.39 I think) it was sufficient to create an empty database on the destination machine and just copy and paste the whole information (all three tables, complete with PK table to the new destination). This will not work any longer. (Mysql does not find the .frm tables, but we can see them in the terminal listed at the appropiate place in the database). Is there a built in way to export complete Databases in mysql? We searched the docs but in vain. Does sql provide for this situation anyway and we just don't know about this? Is there any way to get the database from machine a to machine b? Please help- there must be a way:-). Thanks. Ute _ 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
SQL syntax near 'IDENTIFIED BY'...
Hello! These query produces an SQL syntax error in 3.23.29a-gamma: GRANT ALL PRIVILEGES ON databases.* TO 'foo'@'localhost' IDENTIFIED BY 'bar'; SHOW TABLES FROM databases; Probably this is because of databases is a keyword. However, mysqladmin does allow to create database 'databases'. Is it a bug? Or is that already fixed in later releases? Please honor my address when replying, currently I'm not a subscriber. 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
More info
Sorry, It was a little mistake in my previous letter. mysqladmin create databases does not output any error messages, however it does not create database databases. However, mysqladmin drop databases produce this: /usr/local/mysql/etc/ access.grant mysqladmin drop databases Dropping the database is potentially a very bad thing to do. Any data stored in the database will be destroyed. Do you really want to drop the 'databases' database [y/N] y mysqladmin: drop of 'databases' failed; error: 'You have an error in your SQL syntax near 'databases' at line 1' Regards. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Equivalent as UNION (Oracle)
Jrkeborn Joacim wrote: Hi, We have Oracle SQL statements that uses UNION is there an equivalent for this in mySQL? Not yet. It should be in version 4.0 -- _/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] - _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 5215625 _/ _/ _/ ==* http://szukaj.wp.pl *==-- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
autoincrement
When you have just inserted a record into a table that autoincrements the primary key, is there a way of retrieving the id assigned at the same time? I'm using ASP to write the code in question , and I'm trying to find a better solution that looking at the max key value just before/after in code, and praying no other query was run at the same time. Thanks Sean - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MERGE tables for different databases
HEllo! Is it possible to create a merge table for tables from different databases. I wrote this script for database collection: CREATE TABLE dict ( url_id int(11) DEFAULT '0' NOT NULL, word varchar(32) DEFAULT '' NOT NULL, intag int(11) DEFAULT '0' NOT NULL, KEY url_id (url_id), KEY word_url (word) ) TYPE=MERGE UNION=(www.url,dbms.url); MySQL took it without any errors. However, when I try to access MERGE table in collection database, it fails: -- /usr/home/bar mysql collection Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 210 to server version: 3.23.29a-gamma-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql select * from dict; ERROR 1017: Can't find file: 'dict.MRG' (errno: 2) mysql --- I think this may helps in solving: In /usr/local/mysql/var/collection/dict.MRG I can see this: url url I supposed it should be www.url dbms.url Is that a bug? I suggest this to be fixed in future release. I use 3.23.29a-gamma. Please make a copy to me when replying... 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
strange problems with MySQL db
Hello list. I am having strange problems with my Tables since the partition had been running out of space and mysql crashed. I repaired all the tables and thought it was a success (no errors were detected anymore) but some days later there was an error in another table and I fixed it but then there was another error and so on. I cannot reproduce the error. The error is: 1 clients is using or hasn't closed the table properly Normally this is not a problem... just someone is using the table. But the table sometimes crashes. What may be my problem? Mfg S. winter +---++ | Wintercom New Media | Telefon: +49 (0)2381/378373 | | Eibenweg 12 | Fax:+49 (0)2381/378374 | | D-59071 Hamm | E-Mail: [EMAIL PROTECTED] | | Germany | http://www.wintercom.de| | || | Wir freuen uns auf Ihre Anfrage...|| +---++ | Web-Design, Webhosting, Server-Housing, Netzwerktechnik und mehr | +---++ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Still a wise choice for developers?
Let me add my $.02 CHP A) There's no *point* in keeping the image in the database. CHP A DBMS is all about searching, comparing, relations, etc. You CHP get *none* of these by storing the image data in the DB. Sometimes it just easier to store all things in same place. Right now I working on one web project where there is exist notion of user profiles. User can edit various fields and upload his/her pictures. Right now it is implemented in 'right' way. I.e. database stores only pathnames of files. But I thinking to rewrite it and store pictures in database to simplify my code. CHP B) Unless you're careful, you totally defeat both the CHP web servers and the clients ability to make use of caching CHP mechanisms. While you may not see a big difference on the CHP server, it can make one h... of a difference to the user CHP stuck behind a 33.6K modem. It is not that hard. Code which takes images from database should generate headers like Last-Modified and so on. Often web server works together with proxy working in web accelerate mode. In such case images will be served from database only on first hit and all next requests will be served from proxy cache. Such approach removes unnecessary load from database and gives speed of static data requests. -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- | Ilya Martynov (http://martynov.org/)| | GnuPG 1024D/323BDEE6 D7F7 561E 4C1D 8A15 8E80 E4AE BE1A 53EB 323B DEE6 | | AGAVA Software Company (http://www.agava.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
query
for a particular query i have to select data from five tables. can any one suggest me a best way to do that in terms of performace.. thanks in advance muruganandam - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: autoincrement
On Tuesday 28 August 2001 12:36, [EMAIL PROTECTED] wrote: When you have just inserted a record into a table that autoincrements the primary key, is there a way of retrieving the id assigned at the same time? I'm using ASP to write the code in question , and I'm trying to find a better solution that looking at the max key value just before/after in code, You mean using SELECT LAST_INSERT_ID() ? and praying no other query was run at the same time. Try locking the table for writes just before your insertion, do the insert, SELECT LAST_INSERT_ID() and release the lock. This should prevent another insert being carried out before you retrieve the ID. HTH Ian Barwick -- Ian Barwick - Developer - [EMAIL PROTECTED] akademie.de asp GmbH - http://www.akademie.de To query tables in a MySQL database is more fun than eating spam - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Deleted mysql.host Table!
Hallo, i'm new to mysql. I delete a mysal.host table. Does it means i can't access the rest of my tables in the database? If so, can i rebuild this table or is there another way, to access the rest of the tables? I'am running MySQL under Linux. Thank's for Comment's, Help ... Steffen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: autoincrement
On Tuesday 28 August 2001 13:55, Harald Fuchs wrote: In article 01082813314101.11299@redgrave, Ian Barwick [EMAIL PROTECTED] writes: You mean using SELECT LAST_INSERT_ID() ? and praying no other query was run at the same time. Try locking the table for writes just before your insertion, do the insert, SELECT LAST_INSERT_ID() and release the lock. This should prevent another insert being carried out before you retrieve the ID. This is not necessary. LAST_INSERT_ID is client-specific; thus you get guaranteed the ID of the last INSERT issued by yourself, regardless of what other clients might do in the meantime. Aha, thanks, nice to know. I tend to assume the worst with MySQL (slight personal prejudice due to lack of referential integrity etc., please don't flame, I think it is excellent otherwise, else I would't be using it ;-) Note to self: RTFM more often... Ian Barwick -- Ian Barwick - Developer - [EMAIL PROTECTED] akademie.de asp GmbH - http://www.akademie.de To query tables in a MySQL database is more fun than eating spam - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
autoincrement
When you have just inserted a record into a table that autoincrements the primary key, is there a way of retrieving the id assigned at the same time? I'm using ASP to write the code in question , and I'm trying to find a better solution that looking at the max key value just before/after in code, and praying no other query was run at the same time. Does mysql have any feature to accomadate this? Thanks Sean - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Feature suggestion
Hello! Currently replication is implemented between two mysqld. I would like to suggest new feature. Make it possible for two mysqld to exchange data between each other. For example, MERGE tables distributed between two machines. Question to authors. How do you think, will it ever be implemented. If so, how soon? Thanks... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error: 6 (Errcode: 13)
It means mysql does not have write permission on the sports directory. Grigory Bakunov wrote: Date |Fri, 24 Aug 2001 14:09:20 -0500 From |Tyler Longren [EMAIL PROTECTED] Hello! TL DROP TABLE Track TL Error: 6 - Error on delete of '.\sports\track.ISD' (Errcode: 13) TL Anyone know what that means? As you can see, it came from tryign to do a TL DROP on a table. TL Thanks, TL Tyler Longren Looks like file permissions problems. Check this instructions: http://www.mysql.com/doc/F/i/File_permissions.html ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ 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 -- Gerald L. Clark [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: Feature suggestion
See V 4 -Original Message- From: Alexander Barkov [mailto:[EMAIL PROTECTED]] Sent: 28 August 2001 14:13 To: [EMAIL PROTECTED] Subject: Feature suggestion Hello! Currently replication is implemented between two mysqld. I would like to suggest new feature. Make it possible for two mysqld to exchange data between each other. For example, MERGE tables distributed between two machines. Question to authors. How do you think, will it ever be implemented. If so, how soon? 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
MYSQL Stops for no reason
Hello all Please if could someone help, I am running MYSQL to record print transactions at my company..the way I have set this up is by after a print job has completeda bat file is run whih basically says...go and insert into the table the following values Now on more than 1 occasion the MYSQL database has stopped recording the transactionssimple solution is recreate the table and change the bat file to point to the new tableHOWEVER this as you will all agree with me is not a proper solution.. Please advise Kind regards 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
Re: strange problems with MySQL db
When the temp directory runs out of space, the thread executing will wait for space to become free. If you kill the server, this client has not closed the table properly. How do you determine that the server crashed ? If it stopped responding, maybe it is just waiting for space to become available. Killing it at this point may crash a table. Wintercom New Media wrote: Hello list. I am having strange problems with my Tables since the partition had been running out of space and mysql crashed. I repaired all the tables and thought it was a success (no errors were detected anymore) but some days later there was an error in another table and I fixed it but then there was another error and so on. I cannot reproduce the error. The error is: 1 clients is using or hasn't closed the table properly Normally this is not a problem... just someone is using the table. But the table sometimes crashes. What may be my problem? Mfg S. winter +---++ | Wintercom New Media | Telefon: +49 (0)2381/378373 | | Eibenweg 12 | Fax:+49 (0)2381/378374 | | D-59071 Hamm | E-Mail: [EMAIL PROTECTED] | | Germany | http://www.wintercom.de| | || | Wir freuen uns auf Ihre Anfrage...|| +---++ | Web-Design, Webhosting, Server-Housing, Netzwerktechnik und mehr | +---++ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [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
limits to volume handled by MySQL
Hi there We are switching to a MySQL 3.23.38 on a PIII 933 MHz machine running with a FreeBSD and a web Apache server 1.3.19 . The hosting company has just argued MySQL cannot handle more than 1Go in database files opened per session. Is it true ? If so how to go over that 1Go limit ? ( :-) yes i know scratch the project .. seriously ?) Cheers Bernard Clist Bernard-Olivier Clist Administrateur du site Internet de l'OGE Site Web : http://www.geometre-expert.fr/ Mél : [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: MySQLgui problems
[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: database,sql,query,table 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: I didn't find file edfile.o even in Fl_Editor package but I suppose that libfleditor is enough. The really problem is that I didn't find (and I don't imagine where to search) the rcl (maybe librcl.so) and rcleditor (maybe librcleditor.so). Please help Regards, Stefan Murariu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Updating auto_increment ID Column/Selecting Duplicate Rows
Tom Churm wrote: hi, i have 2 questions that i badly need answered. i use phpmyadmin, but any answers containing SQL syntax should work in this app... 1) this should be simple but i don't know it. i use the following mysql table field as the Key for my tables: id int(10) unsigned NOT NULL auto_increment, now, when i have to clean up items in my tables, like when users have sent off a .html form multiple times and i want to delete duplicate submissions, how can i quickly easily update all of the 'id' fields in the entire table, to reflect the numeration change? now, using phpmyadmin, if i go in and delete a few entries, the id's have gaps in them. You don't reorder them. The gaps remain. Besides, if the id is used in any other table, changing a value would be a serious data integrity issue. 2) in a table i have a column called User. some people have entered things into this table multiple times. how do i create a SELECT statement to select only those rows that have multiple Users? i need something like this (but this is wrong, of course): SELECT * FROM mail_form2 WHERE 'count(User) 1' many thanks from a newbie, tom What things, besides user names, would people be entering here? If you are concerned about duplicate user names, add a unique index on this column, you can use 'ALTER IGNORE mail_form2 add unique (User)', but I'm not sure this is what you meant. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [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
design
Hi Is there any design document available of the complete architecture of the mysql database. I wanted to try out small changes . I want to make sure that it does not effect any transactions or anythings like that in any way. mallik -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQLGUI Version 1.7.5 Question and Comment
I've been trying out MySQLGUI Version 1.7.5, and it seems to work fine on my Win 98SE client. I do have a question about the menu entries under Commands, Tables for Edit table and Create tables. I've searched through the help file and didn't find any mention of these two menu entries, and when I select them nothing seems to happen. What is the purpose of these menu items and shouldn't they at least give me an Info message when I select them? My comment or suggestion is that the help needs to have a section relating functional capabilities to user interface items such as menus and mouse actions. I really liked your program, but it wasn't so easy to decipher how to operate the user interface, which I thought was clean and useful once I begin to see how things worked. Something along the lines of a short How-To list would be useful. Or, one could make a list of all user interface items with a description of what they do. Thank you for your consideration. Marion Berryman [EMAIL PROTECTED] __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.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: limits to volume handled by MySQL
Hi! On Aug 28, Bernard-Olivier Clist wrote: Hi there We are switching to a MySQL 3.23.38 on a PIII 933 MHz machine running with a FreeBSD and a web Apache server 1.3.19 . The hosting company has just argued MySQL cannot handle more than 1Go in database files opened per session. Is it true ? That's not true. I've myself played with 12GB tables on FreeBSD - I didn't face a single problem with it. 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: Updating auto_increment ID Column/Selecting Duplicate Rows
This would give you a list of all users that have entered things more than once; However, it would not give you all the rows that are duplicated. SELECT Count(User) from mail_form2 GROUP BY User HAVING Count(User) 1 Hope this helps! Daniel Von Fange -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 2) in a table i have a column called User. some people have entered things into this table multiple times. how do i create a SELECT statement to select only those rows that have multiple Users? i need something like this (but this is wrong, of course): SELECT * FROM mail_form2 WHERE 'count(User) 1' SELECT * from mail_form2 GROUP BY User HAVING Count(User) 1 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Maximum number of keys
Hello, According to MySQL documentation (Chap. 7.1 MyISAM Tables): Maximum number of keys/table is 32 as default. However when I try to create more than 16 keys, I get: ERROR 1069 at line 1: Too many keys specified. Max 16 keys allowed This table is of MyISAM type. I am currently running MySQL 3.23.41 on Linux (2.4.5) from precompiled binaries (MySQL-3.23.41-1.i386.rpm). Is there any way to use more than 16 keys ? Thanks your help -- Joseph Bueno NetClub/Trader.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Trying to build MySQL 3.23.39 on LynxOS 3.1.0
Hello, I'm trying to build MySQL 3.23.39 for a LynxOS 3.1.0 platform. I believe that I only need the client, and have selected the no-server options. However, when trying to run make it bombs out in the client directory due to the sql_string.cc file which has declared an include for floatingpoint.h. Apparently, I do not have this file. I did some searching on some other systems and found a floatingpoint.h file however using this file comes with it's own set of problems (I knew it was risky, but I tried it anyways out of desparation). Does anyone out there have any other suggestions? Thanks Brian. PS - Some config information OS = LynxOS3.1.0 Processor = PPC Compiler = gcc2.8.1 (I've tried to upgrade to 2.95.X but I am having other problems there) Thanks again. Brian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Roles
In Oracle, I remember working with roles that I could assign to a user. Is there such a mechanism, or are there plans to implement such a mechanism, in MySQL. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Please..Desperate for Help |||||||
I am trying to install the dbf2mysql converter and really getting a headache. Someone told me that I need to install the Include files and libraries for MySQL and I have been searching frantically all over the web for the source for this. All I have been able to find is the RPM's. I am on Mac OS X Server and would like to set this up. Is it possible to install the developer edition of MySQL for X Server ?? If so, can someone point me to where I can get this. I have got to get this converter to work under X Server but it seems that I have to have the mysql-devel installed. Can someone please help me? 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
mySQL
Hi mySQL, I have a huge problem and unfortunately my Domain Hosting Services has no interest in helping me. I am running mySQL with ASP and use a DSN-less call to connect to mySQL. The problem is a little bit weird because running the query using phpmyadmin gives me a perfect recordset. Running it in ASP using ADO returns an empty recordset. The MySQL manual talks about setting the option flag return matching rows. Since I haven't got the faintest idea of how to do this, I assume that's the reason for my empty recordset. Can anyone please tell me how to do this and preferable using a DSN-less call to MySQL. Kind regards, Thomas Christensen NB! The SQL query is listed below. strSQL = SELECT COUNT(Bog.Bogid), Brugere.Navn FROM Brugere INNER JOIN Bog ON Bog.mailadresse = Brugere.mailadresse GROUP BY Brugere.Navn objRs.CursorLocation = adUseClient objRs.Open strSQL, strConnect, adCmdText - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Roles
In Oracle, I remember working with roles that I could assign to a user. Is there such a mechanism, or are there plans to implement such a mechanism, in MySQL. This sounds a lot link granting a user certain privileges. Here's the part of the documentation that talks about this: http://www.mysql.com/doc/U/s/User_Account_Management.html HTH, Kurt Hansen [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: Roles
At 09:57 AM 8/28/01 -0700, you wrote: In Oracle, I remember working with roles that I could assign to a user. Is there such a mechanism, or are there plans to implement such a mechanism, in MySQL. This sounds a lot link granting a user certain privileges. Here's the part of the documentation that talks about this: Actually, you grant the permissions to a role (such as manager, secretary, etc), and then you grant the role to a specific user. It madkes user management a whole lot easier. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: problems compiling on FreeBSD 3.3 (mysql-3.23.41)
I just update the gcc version and still the same problem : absa# gcc -v Reading specs from /usr/local/lib/gcc-lib/i386-unknown-freebsd3.3/3.0.1/specs Configured with: ../configure --enable-languages=c++ Thread model: posix gcc version 3.0.1 Any Ideas ? thanks - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Angel Behar [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, August 23, 2001 11:50 PM Subject: Re: problems compiling on FreeBSD 3.3 (mysql-3.23.41) On Thu, Aug 23, 2001 at 01:50:36PM -0700, Angel Behar wrote: Hi !! I'm trying to compile mysql-3.23.41 on a FreebSD 3.3 box but I can't I'm using latest gnu make version and this is the first time that I have problems compiling mysql so if any of you can help me I'll appreciate. Thanks in advance. Which compiler version are you using? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 6 days, processed 89,579,267 queries (148/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
Re: reports? from MySQL
linking tables via MyODBC + MS Access works great for me. dpk - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 28, 2001 12:06 AM Subject: reports? from MySQL hello. with a lot of help from many of you and some very nice folks, i have been able to build some example/experiment/'mess around' type of dbs. yay. i'd like to ask... if any of you are familar with (File Maker Pro, most recent versions)... how does one go about using MySQL to create a printable report? e.g., where you select the fields you wanted in the report and then create a layout and page setup for the report, (then print it)? ALL 'directional' aids are welcome... books, websites, tips, personal knowledge. EXAMPLES are super. Thanks in Advance. TR - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Drop Down Boxes
HI We are trying to populate a form drop down box (HTML) with a column from our database. What is the query that will get us that without repeating the items (in the 500 or so records this column has only 12 non-repeated items) Thanks. Kevin Pottie Internet Designer O'Dell Web Design http://www.odellwebdesign.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: Drop Down Boxes
Select Distinct. Cal * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com * - Original Message - From: Webmaster Odell [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Tuesday, August 28, 2001 04:56 Subject: Drop Down Boxes HI We are trying to populate a form drop down box (HTML) with a column from our database. What is the query that will get us that without repeating the items (in the 500 or so records this column has only 12 non-repeated items) Thanks. Kevin Pottie Internet Designer O'Dell Web Design http://www.odellwebdesign.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: Drop Down Boxes
On Tue, Aug 28, 2001 at 02:56:13PM -0700, Webmaster Odell wrote: We are trying to populate a form drop down box (HTML) with a column from our database. What is the query that will get us that without repeating the items (in the 500 or so records this column has only 12 non-repeated items) You need to use the DISTINCT keyword in your query. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 11 days, processed 135,375,627 queries (136/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 Error Codes
I'm developing some MySQL applications using VB6 and ADO, and need to do some work on error handling. I can get the error code easily enough from ADO's Error collection, but is there a list of error codes and their descriptions. I've been doing this by generating errors and seeing what codes come back, but it would be nice to have a definitive list. Aaron - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: reports? from MySQL
If you're accessing via Windows, you can use MyODBC and a reporting package such as Crystal Reports or Quick Reports or just about any ODBC-compliant reporting package. You should also be able to link MS Access to your MySQL database... For simple reports where you just want to print some data, you can use a tool like urSQL (http://www.urbanresearch.com/ursql) and MyODBC to build your query and then export the results. Results can be exported to HTML, Text, Excel, etc... - Original Message - i'd like to ask... if any of you are familar with (File Maker Pro, most recent versions)... how does one go about using MySQL to create a printable report? e.g., where you select the fields you wanted in the report and then create a layout and page setup for the report, (then print 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: MySQL Error Codes
Check the source. include/mysqld_error.h A. Clausen wrote: I'm developing some MySQL applications using VB6 and ADO, and need to do some work on error handling. I can get the error code easily enough from ADO's Error collection, but is there a list of error codes and their descriptions. I've been doing this by generating errors and seeing what codes come back, but it would be nice to have a definitive list. Aaron - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [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
BDB questions
Greetings everyone! I had 2 questions related to using BDB and mysql. I don't see any startup options for BDB, so can I safely assume that there are'nt any , so don't need a my.cnf file? Also, how do I specify 'autocommit off' every time BDB starts, instead of specifying it explicitly whenever needed, also I believe even if it is on, I can use begin and end transaction to achieve the same ? Thanks! Sheena. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 problem please help
I have problems only converting certain DBF files to mysql with dbf2mysql. Some work but some don't and when they dont' I get the following error bash-2.05$ dbf2mysql -d maria -t cusine -c -P pass -U user CUSINE.DBF Error creating table! Detailed report: You have an error in your SQL syntax near 'DESC varchar(20) not null) ' at line 2 I have no clue why this happens if anyone could help it would be great thanks Armando - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: dbf2mysql problem please help
Hi !!! )-Original Message- )From: Armando Cerna [mailto:[EMAIL PROTECTED]] )Sent: Tuesday, August 28, 2001 1:27 PM )To: [EMAIL PROTECTED] )Subject: dbf2mysql problem please help ) ) )I have problems only converting certain DBF files to mysql with )dbf2mysql. )Some work but some don't and when they dont' I get the following error ) )bash-2.05$ dbf2mysql -d maria -t cusine -c -P pass -U user CUSINE.DBF )Error creating table! )Detailed report: You have an error in your SQL syntax near 'DESC )varchar(20) )not null) You can't use the SQL/MySQL standard keywords as the table/column names. Here DESC is a standard keyword. So, change DESC to DESC1 and it will absolutely work fine. Regards Venu -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Venu mailto:[EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Woodside, 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
Progress indicator in a query
Hi guys, could anybody help me? I have a very big database. When I make querys to my database, depends on the type of query, it takes a lot of time. I want to implement a progress indicator. Is there any way to implement something like this? Thanks Claudio P. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
What is Pupport ? :)
Not really a MySQL question, but it is related to the MySQL web site If I go to: http://www.mysql.com/udmsearch/search.php the Support link is spelled Pupport (on other pages it is spelled correctly, however)whoops :) --Sam Sam Masiello Software Quality Assurance Engineer (providing quality Pupport :) ) Synacor (716) 853-1362 x289 [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: What is Pupport ? :)
On Tue, Aug 28, 2001 at 05:10:17PM -0400, Sam Masiello wrote: Not really a MySQL question, but it is related to the MySQL web site I forwarded it to [EMAIL PROTECTED], which is where that sort of thing should go... Few folks on this list have any control of MySQL's web site. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 11 days, processed 137,301,168 queries (137/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
Re: fwd: What is Pupport ? :)
Hi, Damn you guys are fast! :) Fixed. But the udmsearch is busted right now for unknown reasons. I will fix shortly. Matt Jeremy Zawodny writes: FYI... - Forwarded message from Sam Masiello [EMAIL PROTECTED] - From: Sam Masiello [EMAIL PROTECTED] To: MySQL General [EMAIL PROTECTED] Date: Tue, 28 Aug 2001 17:10:17 -0400 X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) Subject: What is Pupport ? :) Not really a MySQL question, but it is related to the MySQL web site If I go to: http://www.mysql.com/udmsearch/search.php the Support link is spelled Pupport (on other pages it is spelled correctly, however)whoops :) --Sam Sam Masiello Software Quality Assurance Engineer (providing quality Pupport :) ) Synacor (716) 853-1362 x289 [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 - End forwarded message - -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 11 days, processed 137,299,690 queries (137/sec. avg) -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota 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
show create table URGENT
This is really stupid, but I can remember how to save results of SHOW CREATE TABLE tbl_name and SHOW COLUMNS FROM tbl_name in to text file. I'm running mysql 23.41 on Win2k. Thanks in advance -- Martin Jeremic mailto:[EMAIL PROTECTED] http://solair.eunet.yu/~martinj/ ICQ# : 128620743 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
cannot get mysqld to start
Hello, I just installed mysql-max-3.23.41 on Linux. All went smooth but alas cannot get myqld to start. here is the log from the systemname.err file in mysql/data directory: 010828 14:26:30 mysqld started Can't initialize InnoDB as 'innodb_data_file_path' is not set 010828 14:26:30 /usr/local/mysql-max-3.23.41-pc-linux-gnu-i686/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010828 14:26:30 mysqld ended Now, I am interested in BDB only, so don't care about Innodb. Seems like I have to . But what do I do about the host.frm file ? Gosh , can someone PLEASE help me here ??? Thanks, Sheena. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FULLTEXT exact match queries?
How do I do exact phrase matches using FULLTEXT? I have this 2 million row table, full of text data, that I want to search for an exact phrase. When I say: select * from Laws WHERE MATCH(Line) AGAINST ('MDMA') ORDER BY ID; It works correctly, returning 1 row, MUCH faster than doing a select ... LIKE! But when I do: select * from Laws WHERE MATCH(Line) AGAINST ('growth hormone') ORDER BY ID; MySQL returns every row with either growth OR hormone in it, which isn't what I wanted. Is there a way to only return the rows where the exact phrase growth hormone is present? -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Paris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: FULLTEXT exact match queries?
Hi! On Aug 28, Ed Carp wrote: How do I do exact phrase matches using FULLTEXT? I have this 2 million row table, full of text data, that I want to search for an exact phrase. When I say: select * from Laws WHERE MATCH(Line) AGAINST ('MDMA') ORDER BY ID; It works correctly, returning 1 row, MUCH faster than doing a select ... LIKE! But when I do: select * from Laws WHERE MATCH(Line) AGAINST ('growth hormone') ORDER BY ID; MySQL returns every row with either growth OR hormone in it, which isn't what I wanted. Is there a way to only return the rows where the exact phrase growth hormone is present? Try select * from Laws WHERE MATCH(Line) AGAINST ('growth hormone') AND Line like '%growth hormone%' ORDER BY ID; 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: FULLTEXT exact match queries?
On Aug 28, Ed Carp wrote: How do I do exact phrase matches using FULLTEXT? I have this 2 million row table, full of text data, that I want to search for an exact phrase. When I say: select * from Laws WHERE MATCH(Line) AGAINST ('MDMA') ORDER BY ID; It works correctly, returning 1 row, MUCH faster than doing a select ... LIKE! But when I do: select * from Laws WHERE MATCH(Line) AGAINST ('growth hormone') ORDER BY ID; MySQL returns every row with either growth OR hormone in it, which isn't what I wanted. Is there a way to only return the rows where the exact phrase growth hormone is present? Try select * from Laws WHERE MATCH(Line) AGAINST ('growth hormone') AND Line like '%growth hormone%' ORDER BY ID; It works - thanks! Hmmm...why didn't I think of that? ;) -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Paris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 1044: Access denied
Hello, I have a problem with the access : I have created 2 users with no privileges in the user table (privileges are set in the db table, so those users can only access one particular db). the first user has all the privileges set to Y for the db hello, this user works fine. the second user has exactly the same config as the first one, but with less privileges : only the Select_priv, Insert_priv, Update_priv and Delete_priv set to 'Y' for the db hello. I can connect my sql with that user, but I can't use the db hello : mysql use hello ERROR 1044: Access denied for user: '@localhost' to database 'hello' mysql I'm surprised to have this error message... do I have to set a particular privilege to 'Y' in order to allow this user to connect to the db ??? Table db : HostDbUserSelect_privInsert_privUpdate_privDelete_privCreate_privDrop_privGr ant_privReferences_privIndex_privAlter_priv localhosthellouser2NN localhosthellouser1YY Thanks for your help ! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: cannot get mysqld to start
This is covered in the mysql manual here: http://www.mysql.com/doc/P/o/Post-installation.html First, you need to install the default databases ( installs mysql/host.frm ): bash mysql_install_db Then tell mysql not to use InnoDB: put this in your /etc/my.cnf file: [mysqld] skip-innodb dpk - Original Message - From: Sheena Sidhu [EMAIL PROTECTED] To: Mysql (E-mail) [EMAIL PROTECTED] Sent: Tuesday, August 28, 2001 2:42 PM Subject: cannot get mysqld to start Hello, I just installed mysql-max-3.23.41 on Linux. All went smooth but alas cannot get myqld to start. here is the log from the systemname.err file in mysql/data directory: 010828 14:26:30 mysqld started Can't initialize InnoDB as 'innodb_data_file_path' is not set 010828 14:26:30 /usr/local/mysql-max-3.23.41-pc-linux-gnu-i686/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010828 14:26:30 mysqld ended Now, I am interested in BDB only, so don't care about Innodb. Seems like I have to . But what do I do about the host.frm file ? Gosh , can someone PLEASE help me here ??? Thanks, Sheena. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 1044: Access denied
ERROR 1044: Access denied for user: '@localhost' to database 'hello' This says that you are connected as user '' ( blank ) from localhost. Make sure you're logging on correctly and try again. dpk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 1044: Access denied
- Original Message - From: Dana Powers [EMAIL PROTECTED] To: Pierre-Yves [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, August 29, 2001 1:22 AM Subject: Re: ERROR 1044: Access denied ERROR 1044: Access denied for user: '@localhost' to database 'hello' This says that you are connected as user '' ( blank ) from localhost. Make sure you're logging on correctly and try again. dpk but I use the following command to connect mysql : mysql --user=user2 --host=localhost (there is no password for this user) and when I do this with the user1 it is working... so i don't think that's the problem. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to import a text file into the mysql database
hello all, i am trying to install web calendar software on my machine, which is available at sourceforge.net website. to run that software first of all a textfile named tables-mysql.sql needs to imported into the mysql database. for doing that i typed the following command at the shell prompt shell # mysqlimport -u root -p webcalendar tables-mysql.sql where, 'webcalendar' is the database that i have created for this purpose. after entering the password at the password prompt it is displaying the following error: mysqlimport: Error: You have an error in your SQL syntax near 'tables-mysql' at line 1, when using table: tables-mysql how can i avoid this error? TIA = Chakravarthy K Sannedhi Research Assistant, CTER, UAB Birmingham, AL-35205 Ph: (205) 821-6805 (M) http://www.dpo.uab.edu/~kalyan __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.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: ERROR 1044: Access denied
The way mysql access tables work, if it cant find a user named 'user2', it will default to the blank user ( '' ). dpk - Original Message - From: Pierre-Yves [EMAIL PROTECTED] To: Dana Powers [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, August 28, 2001 4:39 PM Subject: Re: ERROR 1044: Access denied - Original Message - From: Dana Powers [EMAIL PROTECTED] To: Pierre-Yves [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, August 29, 2001 1:22 AM Subject: Re: ERROR 1044: Access denied ERROR 1044: Access denied for user: '@localhost' to database 'hello' This says that you are connected as user '' ( blank ) from localhost. Make sure you're logging on correctly and try again. dpk but I use the following command to connect mysql : mysql --user=user2 --host=localhost (there is no password for this user) and when I do this with the user1 it is working... so i don't think that's the problem. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
mysqladmin is missing from RPM distribution
Description: I downloaded, via ftp, and installed MySQL-3.23.41-1.i386.rpm. The user instructions at the end of the rpm -i ./*.rpm command proscripbed the use of /usr/bin/mysqladmin -u root -p password 'new-password' and /usr/bin/mysqladmin -u root -h 'my-dns-name' -p password 'new-password'. Unfortunately, 'mysqladmin' cannot be found on the machine, via find / -name mysqladmin*. A list of the distribution files also shows it missing; via rpm -qpl ./*.rpm. How-To-Repeat: run rpm -qpl MySQL-3.23.41-1.i386.rpm. look for /usr/bin/mysqladmin Fix: Found and installed /usr/bin/mysqladmin from a previous rpm Submitter-Id: submitter ID Originator:root Organization: MySQL support: none Synopsis: mysqladmin missing from MySQL-3.23.41-1.i386.rp. Severity: non-critial Priority: medium Category: mysql Release: mysql-3.23.41 (Official MySQL RPM) Environment: System: Linux ravi2.orem.volera.com 2.4.2-2 #1 Sun Apr 8 20:41:30 EDT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-81) Compilation info: CC='egcs' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='egcs' CXXFLAGS='-O6 -fno-omit-frame-pointer-felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Aug 24 08:37 /lib/libc.so.6 - libc-2.2.2.so -rwxr-xr-x1 root root 1236396 Apr 6 15:58 /lib/libc-2.2.2.so -rw-r--r--1 root root 26350254 Apr 6 13:27 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 6 13:27 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berkeley-db --without-innodb --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Root password revisited
Hi all, I just joined list. I spent a couple hours in the archive and decided MySQL better improve their install message regarding setting the root password! Half the posts are about it going badly. ;) I believe I found the answer in the archives, but they all aren't the same answer. So is the concensus for resetting the root password, whether it was set or not the following? If it is, add it to your binaries! (I'm actually quite friendly and patient :) root# ./bin/safe_mysqld --user=mysql --skip-grant-tables root# ./bin/mysql -u root -p Enter password: (hit return at this point) UPDATE user SET Password=PASSWORD(desiredpasswordhere) WHERE User=root; Exit root# ./bin/mysqladmin flush-privileges root# ./bin/mysql -u root -p Enter password: desiredpasswordhere - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Install MySQL Binary on AIX
Hi! ajgrif == ajgrif [EMAIL PROTECTED] writes: Description: ajgrif I downloaded the lated AIX binary from mysql.com, and unpacked it to /usr/local/mysql. I then cd'd to /usr/local/mysql and ran scripts/mysql_install_db per the INSTALL-BINARY file. This is the error I recieve: ajgrif exec(): 0509-036 Cannot load program ./bin/my_print_defaults because of the following errors: ajgrif 0509-130 Symbol resolution failed for my_print_defaults because: ajgrif 0509-136 Symbol strcat (number 60) is not exported from ajgrifdependent module /usr/local/lib/libz.a(shr.o). ajgrif 0509-136 Symbol memmove (number 61) is not exported from ajgrifdependent module /usr/local/lib/libz.a(shr.o). ajgrif 0509-136 Symbol bcopy (number 62) is not exported from ajgrifdependent module /usr/local/lib/libz.a(shr.o). ajgrif 0509-192 Examine .loader sections symbols with the ajgrif 'dump -Tv' command. ajgrif I also recieve similar errors to that referencing ./bin/mysqld instead of ./bin/my_print_defaults. cut Thanks for the bug report; We will start building 3.23.42 shortly and I will try to build this staticly on AIX. In the mean time; Please use the source distribution on AIX if the binary doesn't work for you. Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Solaris 2.8 configure problem...
Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa Jeremy Zawodny writes: I have a fairly new Solaris 2.8 (Ultra Sparc) machine on which I'm trying to build the MySQL client libraries. According to the INSTALL-SOURCE file, I need to use a command-line like this: CC=gcc CFLAGS=-O3 CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti ./configure --without-server --with-low-memory --enable-assembler config.err When I do that and look at config.err, I see the error message: configure: error: can not run test program while cross compiling Here's the whole thing (since the list won't take attachments). It's not too long. According to the INSTALL-SOURCE file, that error means you have something wrong with your compiler installation! But I've already used this exact same compiler to bulild a *ton* of other packages on the machine. What can I do to fix/debug this problem? cut Sinisa Jeremy, Sinisa In our manual, chapter on Solaris, there are instructions on which Sinisa lines to delete from configure script in the case like above. Sinisa Just do that ! This was up a short while ago and it seams like Jeremy hasn't yet updated our documentation regarding this. Here is the missing information regarding this: If you are using the SFW version of gcc (which comes with Solaris 8), you must add /opt/sfw/lib to the environment variable LD_LIBRARY_PATH before running configure. If you are using the gcc available from sunfreeware.com, you may have many problems. You should recompile gcc and GNU binutils on the machine you will be running them from to avoid any problems. Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Root password revisited
Hi all, I got a No Database Chosen. What's the syntax for adding the database? I tried *.*, mysql, and test between UPDATE and user but all returned syntax error. Thanks much, Gregg UPDATE user SET Password=PASSWORD(desiredpasswordhere) WHERE User=root; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RE: FULLTEXT exact match queries?
Alok K. Dhir ([EMAIL PROTECTED]) writes: select * from Laws WHERE MATCH(Line) AGAINST ('growth hormone') AND Line like '%growth hormone%' ORDER BY ID; This defeats the purpose of the fulltext index, don't you think? Not really - since the WHERE clause is executed left to right, the LIKE clause is run against the output of the MATCH clause, a much smaller subset. I tried it - on a 250MB database containing almost 1.7 million records, the query time went from 100+ seconds to just under 1 second - a significant increase in speed! -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Is your web site data driven? Are you swamped with work managing, updating, and deploying that data on to your web site? You need Escapade! Check us out at http://www.squishedmosquito.com/cgi-bin/esp?PAGE=esp_intro.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
binary bin problems on HPUX 11.0
Hi, we are using mysql 3.23.33 on HPUX11 and every time we reboot the machine, it overwrites the binary log and starts from 001 again. This is only happening on a couple of machines. It doesn't do this if i manually restart mysql, only when the machine is rebooted. On one of the machines, mysql receives signal 10, dies and restarts, this once again only occurs when the machine is rebooted. Any help is greatly appreciated, William - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how to import a text file into the mysql database
shell # mysqlimport -u root -p webcalendar tables-mysql.sql where, 'webcalendar' is the database that i have created for this purpose. after entering the password at the password prompt it is displaying the following error: mysqlimport: Error: You have an error in your SQL syntax near 'tables-mysql' at line 1, when using table: tables-mysql Looks like there's nothing wrong with the command. Instead, you have bad sql syntax on line 1, or first uncommented line in the tables-mysql.sql file. Thanks... Dan. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
New MySQL Site
Just a kudos to those that redid the MySQL site. DAMMM IT LOOKS GOOD Excellent job!!! Cheers M;) Quote from The Young Ones: I suppose you think it's pretty weird, don't you Mike? Well, you'd be right. Because THAT's the kind of guy I am, right! WEIRD! Which is why I go over people's heads...a bit like a aeroplane! You think I'm an aeroplane, don't you, Mike? Well, I'm not! - Rik DATBASE MySQL ENLIGHTENMENT - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
reports? from MySQL (oops, on a Mac)
i'd like to ask... if any of you are familar with (File Maker Pro, most recent versions)... how does one go about using MySQL to create a printable report? e.g., where you select the fields you wanted in the report and then create a layout and page setup for the report, (then print it)? Thanks again. (Mac OS 9 or X) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: query
Date |Tue, 28 Aug 2001 16:32:49 +0530 From |muruganandam [EMAIL PROTECTED] Hello! M for a particular query i have to select data from five tables. M can any one suggest me a best way to do that in terms of performace.. M thanks in advance M muruganandam Please give more details. Like table structures, indexes etc. ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ 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
compiling mysql with InnoDB for AMD Athlon cpu
G'day, Is it possible to compile mysql with InnoDB for AMD Athlon processor ? Error produced during compilation follows: make[4]: Entering directory `/usr/local/src/mysql-3.23.41/innobase/sync' gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../../include -I../include -DDBUG_OFF -O3 -DDBUG_OFF-DDEBUG_OFF -DUNIV_INTEL_X86 -c sync0sync.c sync0sync.c: In function `sync_gnuc_intelx86_test_and_set': sync0sync.c:187: impossible register constraint in `asm' sync0sync.c:187: impossible register constraint in `asm' sync0sync.c:187: impossible register constraint in `asm' sync0sync.c:1259: confused by earlier errors, bailing out make[4]: *** [sync0sync.o] Error 1 make[4]: Leaving directory `/usr/local/src/mysql-3.23.41/innobase/sync' make[3]: *** [all-recursive] Error 1 make[3]: Leaving directory `/usr/local/src/mysql-3.23.41/innobase' make[2]: *** [all-recursive-am] Error 2 make[2]: Leaving directory `/usr/local/src/mysql-3.23.41/innobase' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/src/mysql-3.23.41' make: *** [all-recursive-am] Error 2 Thank you beforehand. With best regards, Stanislav Dmitrenko - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php