Re: Problems with Time field
i got an error msg. that this was not posted... hence i am doing it once more Praveen On Mon, 06 May 2002 p j j wrote : hi all, I am using mysql on Win98 platoform. Am facing problems using the Time field in SQL queries being executed from a VB program. Would it be possible for someone to help me out with this At mysql prompt 1. CREATE TABLE TEST(field Time) success 2. INSERT INTO TEST(field) VALUES ('11:00:00')-- success 3. SELECT * FROMTEST --- success 11:00:00 But from a VB program - the first two queries get executed successfully ; the values were checked from mysql prompt has been entered successfully But the 3rd query (SELECT) when executed from the VB program returns a result set of Null. kindly help Praveen _ Click below to visit monsterindia.com and review jobs in India or Abroad http://monsterindia.rediff.com/jobs - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Click below to visit monsterindia.com and review jobs in India or Abroad http://monsterindia.rediff.com/jobs - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication
Hi ! Just read about the possibility of replicating two databses. Can you tell me how to do it or send me a (link to a) manual? Thanks, Sven On Monday, May 6, 2002, at 03:11 PM, Dicky Wahyu Purnomo wrote: On Mon, 6 May 2002 07:44:04 +0200 Ewan Sadie [EMAIL PROTECTED] wrote: I have installed MySQL on two of my MS-Proxy servers. I am logging all web browser logs to MySQL. I want to replicate the database to a central server where I can do queries on the data. I do not want to run select statement agains the proxy server itself. How can I replicate the data to a different server (like with slave master replication) and then delete the data on the proxy server, without deleting it on the central server. What I actually want to do is something like a selecy into but between different server/databases. I am evaluation MySQL and if I can get this right I will chuck out my MS-SQL databases. From my experience, I can tell you this : Master -- Slave Replication Every query that change the data on master will be replicated on slave. But I think you can try this : binlog-db : DB_A biglog-ignore-db : DB_B DB_A is the database which will be replicated. you can do the delete query with using DB_B database, e.g. : use DB_B; delete from table DB_A.Table_A; Correct me if i'm wrong ... ;-) -- We are using Linux daily to UP our productivity - so UP yours! -- Adapted from Pat Paulsen by Joe Sloan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication
On Mon, 6 May 2002 15:21:54 +0900 Sven Bentlage [EMAIL PROTECTED] wrote: Hi ! Just read about the possibility of replicating two databses. Can you tell me how to do it or send me a (link to a) manual? Actually is not only replicating 2 DB, but replication between several DB server. You can read on MySQL manual which already included in your mysql installation package or see on mysql.com homepage. -- How should I know if it works? That's what beta testers are for. I only coded it. -- Attributed to Linus Torvalds, somewhere in a posting - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SpamAssassin tags messages from the list as spam (was: [fwd] *****SPAM***** Re: Problems with Time field (from: dump_pj@rediffmail.com))
Hi! As you can see below, SpamAssassin tags messages from the MySQL list as spam. The main reason that this happens, is: SPAM: Hit! (3.5 points) URI: URL of page called unsubscribe That's because: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Would it be possible to rename this page? Maybe to rem.php, or something like this. It would be enough, if this would be a symlink on the server to unsubscribe.php. Thanks, Alexander Skwar - Forwarded message from p j j [EMAIL PROTECTED] - From: p j j [EMAIL PROTECTED] Date: 6 May 2002 06:09:01 - Subject: *SPAM* Re: Problems with Time field To: [EMAIL PROTECTED] Envelope-to: [EMAIL PROTECTED] Delivery-date: Mon, 06 May 2002 01:17:24 -0500 Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org) List-ID: mysql.mysql.com List-Help: mailto:[EMAIL PROTECTED] List-Unsubscribe: mailto:[EMAIL PROTECTED] List-Post: mailto:[EMAIL PROTECTED] List-Subscribe: mailto:[EMAIL PROTECTED] Reply-To: p j j [EMAIL PROTECTED] X-Spam-Status: Yes, hits=5.0 required=4.9 tests=CLICK_BELOW,UNSUB_PAGE version=2.20 X-Spam-Flag: YES X-Spam-Level: * X-Spam-Checker-Version: SpamAssassin 2.20 (devel $Id: SpamAssassin.pm,v 1.77 2002/04/06 19:28:30 hughescr Exp $) SPAM: Start SpamAssassin results -- SPAM: This mail is probably spam. The original message has been altered SPAM: so you can recognise or block similar unwanted mail in future. SPAM: See http://spamassassin.org/tag/ for more details. SPAM: SPAM: Content analysis details: (5 hits, 4.9 required) SPAM: Hit! (1.5 points) BODY: Asks you to click below SPAM: Hit! (3.5 points) URI: URL of page called unsubscribe SPAM: SPAM: End of SpamAssassin results - i got an error msg. that this was not posted... hence i am doing it once more Praveen On Mon, 06 May 2002 p j j wrote : hi all, I am using mysql on Win98 platoform. Am facing problems using the Time field in SQL queries being executed from a VB program. Would it be possible for someone to help me out with this At mysql prompt 1. CREATE TABLE TEST(field Time) success 2. INSERT INTO TEST(field) VALUES ('11:00:00')-- success 3. SELECT * FROMTEST --- success 11:00:00 But from a VB program - the first two queries get executed successfully ; the values were checked from mysql prompt has been entered successfully But the 3rd query (SELECT) when executed from the VB program returns a result set of Null. kindly help Praveen _ Click below to visit monsterindia.com and review jobs in India or Abroad http://monsterindia.rediff.com/jobs - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Click below to visit monsterindia.com and review jobs in India or Abroad http://monsterindia.rediff.com/jobs - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 - Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.iso-top.de |Jabber: [EMAIL PROTECTED] iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 16 hours 19 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
One slow connection make mysql slow
I use mysql to register data in an accounting system, comunications happen in a 200 Mbit network and database is really fast, so lock situation ( ie delete after a long select ... ) is really fast and does not create problems. When I connect from a dialup connection obviously query take the same time but sending results to me may take 30 seconds. The problem is that mysql locks the table up to the end of the data sending process so other local client can't work. Is this a bug? Are there a logical explanation? Thanks for your help Luca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with udf_example.cc
Hi, I'm using MySQL4.0.1-alpha under linux and want to use my own udfs. I tried to get working the udf_example and followed the MySQL manual. Compiling the file and using the CREATE FUNCTION command didn't succeed. I got the following error messages: gcc -shared -o udf_example.so -rdynamic udf_example.o mysql CREATE FUNCTION metaphon RETURNS STRING SONAME udf_example.so; ERROR 1126: Can't open shared library 'udf_example.so' (errno: 2 /usr/lib/udf_example.so: undefined symbol: default_charset_info) gcc -c -o udf_example.so -rdynamic udf_example.cc mysql CREATE FUNCTION metaphon RETURNS STRING SONAME udf_example.so; ERROR 1126: Can't open shared library 'udf_example.so' (errno: 2 udf_example.so: ELF file's phentsize not the expected size) What am I doing wrong? I would be grateful for an advice. Thanks in advance. Stefan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
blob problem
hi, I want to insert binary structure into the mysql blob column. I have a my own structure called MSG_STRUCT msg_struct; Now i want to insert the whole structure (binary) into table having a column of blob data type. I tried by end = strmov(query,INSERT INTO retry (msisdn, msg) values(); *end++ = '\''; end += mysql_real_escape_string(*sql, end,91984503,11); *end++ = '\''; *end++ = ','; *end++ = '\''; end += mysql_real_escape_string(*sql, end, msg_struct, sizeof(msg_struct)); *end++ = '\''; *end++ = ')'; I have mysql Ver 11.15 Distrib 3.23.41, for pc-linux-gnu (i686). I have included the -lmysqlclient library but it says undefined reference for strmov. What lib do i include for strmov ? Also when the value is inserted into the blob fieldwhat will i see in the table ? binary or hex value ? When i retrieve that field by select msg from retry;.what format will i get the binary data ? Do i need to do any conversion ? Please guide me regarding inserting blob (binary) type and including strmov function. Thank you Chirag - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: installation problems on freebsd
I have started all over again on a fresh Freebsd installation. I have all the files in my /usr/local/mysql directory and I run Scripts/mysql_install_db After that I take the following action $ chown -R root /usr/local/mysql $ chgrp -R mysql /usr/local/mysql $ chown -R mysql /usr/local/mysql/data Than something happens that I don't really understand When I run bin/safe_mysqld -user=mysql The daemon starts followed by the message that mysqld ended. This does not seem to happen when I run bin/safe_mysqld . I don't know the difference but the service keeps on running with the latter I have copied support-files/mysql.server to /usr/local/etc/rc.d (the startup directory) but when I reboot I have to start mysqld manual again The ./bin/mysqladmin -p password does not seem to let me update the password. Any ideas? Cheers -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Monday, 6 May 2002 8:27 a.m. To: Defryn NZ Cc: [EMAIL PROTECTED] Subject: Re: installation problems on freebsd On Mon, May 06, 2002 at 08:12:30AM +1200, Defryn NZ wrote: Is /tmp/mysql.sock missing after you start the MySQL server using `bin/safe_mysqld'? When I run bin/safe_mysqld I get the message that it is unable to connect to 'hostname' through /tmp/mysql.sock and that it is missing That's really strange. Starting a MySQL server shouldn't ever result in it attempting to contact itself via /tmp/mysql.sock. It sounds like something is rather messed up in your configuration. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 87 days, processed 2,267,702,000 queries (300/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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Installation issues
Dear MySQL, I am installing Mysql for Unix-3.23.49 for sun-solaris2.8-sparc machine. While i am attempting to run the script called mysql_install_db under scripts directory. It throws me the following piece of results and a result no databases were created in mysql/data/mysql as well as mysql/data/test. Please let me know how i will proceed from this error. ld.so.1: ./bin/my_print_defaults: fatal: libz.so.1: open failed: No such file or directory WARNING: The host 'inatp12wks99' could not be looked up with resolveip. This probably means that your libc libraries are not 100 % compatible with this binary MySQL version. The MySQL deamon, mysqld, should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ld.so.1: ./bin/mysqld: fatal: libpthread.so.1: version `SUNW_1.2' not found (required by file ./bin/mysqld) Killed Installation of grant tables failed! Examine the logs in ./data for more information. You can also try to start the mysqld daemon with: ./bin/mysqld --skip-grant You can use the command line tool ./bin/mysql to connect to the mysql database and look at the grant tables: shell ./bin/mysql -u root mysql mysql show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in ./data that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com Please consult the MySQL manual section: 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source is the MySQL email archive. Please check all of the above before mailing us! And if you do mail us, you MUST use the ./bin/mysqlbug script! Thanks and regards, R.M.Ramnarayanan, iNautix Technologies India Private Limited, 10th Floor , Tidel Park , 4, Canal Bank Road, Taramani, Chennai - 600113. Ph : 2540888, 2540656 Ext : 1283 EMail - [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
Access denied irregularities
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I'm getting intermittent 'Access denied' errors when running a php script to admin a mysql db. I've looked in the manual but cannot work out why I can connect in some parts of the script and not in others Perhaps there is some common 'gotchas' you might let me know about? Here is the code I use to connect: function _db_connect() { if(!$this-link_id) { $this-link_id=mysql_connect($this-host, $this-user, $this-pass); } if(!$this-link_id) { return FALSE; } $db=mysql_select_db($this-db) or die (can't select db); return TRUE; } Many thanks for any help :-) - -- Nick Wilson // www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE81ls+HpvrrTa6L5oRAp0nAJwLLRlGpFV6ZQndPhqqF1+pW6w2MwCeK+H8 bsslUwVkhNA+8vVU/8S4qTc= =jhe5 -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL on Mac OS X
Hi. I've just installed MySQL 3.23.49 on Mac OS X.1.4. The installation went fine (into /usr/local/) but now I'm having what I believe is a common permission problem. When trying to add a database I get the following error: [localhost:~] phil% mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 12 to server version: 3.23.49-entropy.ch Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql create database CONTACT; ERROR 1044: Access denied for user: '@localhost' to database 'CONTACT' mysql I couldn't find anything in the archives so I wondered, could somebody let me know the workaround I need to do on the permissions to get me started? Any help appreciated. Regards, Phil. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 on Mac OS X
on my box the following helped: (su to root) chown -R mysql /usr/local/mysql/var (check if this is the path to your mysql var ) (exit root) that should do it. also check in the user and host table if a connection from localhost is allowed for the specific user.. Cheers, Sven On Monday, May 6, 2002, at 07:42 PM, Phil Dobbin wrote: Hi. I've just installed MySQL 3.23.49 on Mac OS X.1.4. The installation went fine (into /usr/local/) but now I'm having what I believe is a common permission problem. When trying to add a database I get the following error: [localhost:~] phil% mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 12 to server version: 3.23.49-entropy.ch Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql create database CONTACT; ERROR 1044: Access denied for user: '@localhost' to database 'CONTACT' mysql I couldn't find anything in the archives so I wondered, could somebody let me know the workaround I need to do on the permissions to get me started? Any help appreciated. Regards, Phil. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
hostname.err
The file hostname.err description: mysqld started /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) mysql ended The file host.frm exists in /var/lib/mysql/mysql I can't open mysql using 'mysql' from prompt.I see an error: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (111) Any ideas? -- registered linux user #123707 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Alpha 4 would have been beta Q4/2001
...Users are not recommended to switch their production systems to MySQL 4.0 until it is released in beta version later Q4/2001... Source: http://www.mysql.com/products/mysql-4.0/index.html Well, now it is Q2/2002 What is the new date for the beta release ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 on Mac OS X
On 6/5/02 at 19:53, [EMAIL PROTECTED] (Sven Bentlage) wrote: on my box the following helped: (su to root) chown -R mysql /usr/local/mysql/var (check if this is the path to your mysql var ) (exit root) that should do it. also check in the user and host table if a connection from localhost is allowed for the specific user.. Having looked, I have no /usr/local/mysql/var. The installation instructions (from Marc Liyanage's excellent website) were as follows (in part): sudo chown -R mysql /usr/local/mysql/* followed by: sudo ./bin/safe_mysqld --user=mysql Also, how do I check the user/host table? Thanks for your help, Regards, Phil. On Monday, May 6, 2002, at 07:42 PM, Phil Dobbin wrote: Hi. I've just installed MySQL 3.23.49 on Mac OS X.1.4. The installation went fine (into /usr/local/) but now I'm having what I believe is a common permission problem. When trying to add a database I get the following error: [localhost:~] phil% mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 12 to server version: 3.23.49-entropy.ch Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql create database CONTACT; ERROR 1044: Access denied for user: '@localhost' to database 'CONTACT' mysql I couldn't find anything in the archives so I wondered, could somebody let me know the workaround I need to do on the permissions to get me started? Any help appreciated. Regards, Phil. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
quota on mysql
Hi all, How do I go about applying user quota on mysql databases, so that I = can keep track of the disk space used by all the databases users. I am using RH linux 7.0 =20 Mysql 3.23.40 installed on /var/lib/mysql/ quota-2.00pre3-7 applied on /home partation Thanks in advance Praful - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Group by counted records...
[snip] iduser | dtaccess --- 10 | '2000-10-02' 3 | '2000-12-04' 4 | '2000-10-09' 3 | '2000-12-04' 5 | '2001-02-10' 10 | '2001-03-01' 10 | '2001-01-10' 10 | '2001-01-11' 3 | '2000-12-10' I need to group the records by the number of time some user (iduser) appears in the table, and i need to know how many users appears once, how many appears twice and so on. Example: for these data, the resultset must bring: num_times | num_users - 1 | 2 3 | 1 4 | 1 - i.e: 2 users appears twice, one user - three times, one user - four times. Does anyone knows how can i do that? [/snip] SELECT COUNT(*) AS num_times, iduser FROM table GROUP BY iduser ORDER BY num_times HTH! Jay mysql, sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: LOAD DATA LOCAL error
Hi, Neil Bobstone wrote: Hi, cut I Have compile Mysql 3.23.49 with : --enable-local-infile But when I want to use LOAD DATA LOCAL its says : The used command is not allowed with this MySQL version cut --enable-local-infile affects client library libmysqlclient Can you check if client library you are using is installed from same source? - the one you compiled. It often happens that you have different files from different releases installed. Proper way to upgrade if you use source is: 1. cd new_src; ./configure ... your opts; make; 2. cd old_src; make uninstall 3. stop mysqld 4. cd new_src; make install 5. start mysqld make uninstall will clean all libraries, headers and binaries, but will not touch your datadir nor config files. (/etc/my.cnf /etc/rc.d if any) -- Best regards -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Keremidarski [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria ___/ www.mysql.com M: +359 88 231668 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: hostname.err
Samuel, Monday, May 06, 2002, 1:55:44 PM, you wrote: SM REALFROM: Samuel Mendelowski [EMAIL PROTECTED] SM HOUR: 2002050614 SM The file hostname.err description: SMmysqld started SM/usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) SMmysql ended SM The file host.frm exists in /var/lib/mysql/mysql # perror 13 Error code 13: Permission denied MySQL doesn't have permissions on the MySQL data dir. SM I can't open mysql using 'mysql' from prompt.I see an error: Can't connect SM to local MySQL server through socket '/var/run/mysql/mysql.sock' (111) SM Any ideas? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem on Load Data!
Jack, Monday, May 06, 2002, 7:40:08 AM, you wrote: J Two Question : J 1. J I know that the 'LOAD DATA' command loads a bulk of data into a table, but J what happen if i only want to load the data into specifc fields on a table J instead of whole table. J eg. J Let say i had a file with 3 column of data, and i want to load these data J into a 'ABC' table's field 3 to 5 and leave field 1 2 as it was! You can load data in certain table columns. Look at: http://www.mysql.com/doc/L/O/LOAD_DATA.html J 2. J I copied a file into server's root directory, and i was trying to load that J file's data to table which i had failed using the following command in J MYSQL: J LOAD DATA infile 'c:\hkd_rate.csv' into table hkd_deposit1 fields J terminated by ',' J It said couldn't find the file! J but if i put the file into the data directory of mysql, then it can find it! Yeah, because MySQL doesn't have permissions on that dir. J So what should i do if i want mysql will able to find that file from root J directory? You should change permissions on file and pathname dirs. J -- J Thx a lot! J Jack -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: quota on mysql
Praful, Monday, May 06, 2002, 2:41:54 PM, you wrote: PSHow do I go about applying user quota on mysql databases, so that I = PS can keep track of the disk space used by all the databases users. PS I am using RH linux 7.0 =20 PS Mysql 3.23.40 installed on /var/lib/mysql/ PS quota-2.00pre3-7 applied on /home partation You can use usual disk quotes. If the database size is more than available space for a user(or group), an error will take place. PS Thanks in advance PS Praful -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL on Mac OS X
Phil, Monday, May 06, 2002, 1:42:28 PM, you wrote: PD I've just installed MySQL 3.23.49 on Mac OS X.1.4. The installation went fine (into /usr/local/) but now I'm having what I believe is a common permission problem. When trying to add a database I PD get the following error: PD [localhost:~] phil% mysql PD Welcome to the MySQL monitor. Commands end with ; or \g. PD Your MySQL connection id is 12 to server version: 3.23.49-entropy.ch PD Type 'help;' or '\h' for help. Type '\c' to clear the buffer. PD mysql create database CONTACT; PD ERROR 1044: Access denied for user: '@localhost' to database 'CONTACT' PD I couldn't find anything in the archives so I wondered, could somebody let me know the workaround I need to do on the permissions to get me started? By default anonymous user ('') has permissions only on the database 'test'. You should have permissions to create databases. You can find a lot of info about MySQL privilege system in our manual: http://www.mysql.com/doc/P/r/Privilege_system.html http://www.mysql.com/doc/U/s/User_Account_Management.html PD Any help appreciated. PD Regards, PD Phil. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Access denied irregularities
Nick, Monday, May 06, 2002, 1:30:22 PM, you wrote: NW Hi all, I'm getting intermittent 'Access denied' errors when running a NW php script to admin a mysql db. I've looked in the manual but cannot NW work out why I can connect in some parts of the script and not in others NW Perhaps there is some common 'gotchas' you might let me know about? NW Here is the code I use to connect: NW function _db_connect() { NW if(!$this-link_id) { NW $this-link_id=mysql_connect($this-host, $this-user, NW $this-pass); NW } NW if(!$this-link_id) { NW return FALSE; NW } NW $db=mysql_select_db($this-db) or die (can't select db); NW return TRUE; NW } NW Many thanks for any help :-) Access denied error occurs when you have no required privileges to connect to the MySQL server. You gave incomplete error message and I can't give you detailed answer. Please, check the following link, you can find description of this error there: http://www.mysql.com/doc/A/c/Access_denied.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Transfer data/ Insert +select
Sven, Saturday, May 04, 2002, 4:52:00 PM, you wrote: SB The mySQL DB I have to rebuild was only one big table. Afer developing a SB new DB design for it, I ran into the problem of transfering the data SB from the old to the new database. SB I need to split up the records and insert them into the specific tables. SB My problem is that I can not figure out (as a total novice on mySQL) how SB to insert the data properly. Every time I try there's either a SQL error SB or the data is messed up and not ordered as it should be. SB I tried to use the following statement: SB insert into priv_details (hobbies, experi, quali, marital [.]) SB select me.hobbies, me.experi [..] from memberscopy me, priv_details pd SB where pd.id=me.id; SB What can i do? First of all, read the manual: http://www.mysql.com/doc/I/N/INSERT_SELECT.html You can't use your table priv_details in the SELECT statement. SB Regards, SB Sven -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: General error: Got error 12 from table handler on Linux.
Doron, Monday, May 06, 2002, 3:44:02 AM, you wrote: D I got the above error when inserting a row into a heap table on linux D mySQL version 3.23.49a from the Java JDBC driver. This is not reproduceable D on a win32 DB. This does not appear to be space related as it failed after D only about 200 rows. Just wondering if anyone has seen this before? # perror 12 Error code 12: Cannot allocate memory Heap table is stored in memory. So, looks like your memory limit is exhausted. D -Doron -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error 28
I'm using DBTools Table Manager to make table changes in Mysql 3.23... I'm trying to add an auto_increment ID field to 2 tables that already have data in them.. 1 table worked fine, the other table I get Got Error 28 from Table Handler can anyone tell me why I get this? TIA - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Access denied irregularities
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Egor Egorov declared Access denied error occurs when you have no required privileges to connect to the MySQL server. You gave incomplete error message and I can't give you detailed answer. Please, check the following link, you can find description of this error there: http://www.mysql.com/doc/A/c/Access_denied.html Yes, I've already been there. No luck. the problem seems to be on/off part of the time it is okay and at other times not. It is just a regular 'Access denied to user 'nick@localhost using passwore YES' error. - -- Nick Wilson // www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE81n36HpvrrTa6L5oRAsTCAKCmYg8C6gO98Ci95gUJFFDP29KIGgCgh3AF nA5VXs3zxNVcnd4HsLB6cS8= =dTXx -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: display days between two dates?
Hello, Tim Carlson wrote: Hello, Newbie SQL person here. I am hoping to be able to do the following. Given two dates, I would like to display all of the days between them. So if I had the dates 2002-02-08 and 2002-02-12, I would like to have MySQL spit back 2002-02-08 2002-02-09 2002-02-10 2002-02-11 2002-02-12 Any way I can do this directly in MySQL without constructing a table? I've looked through the date maniplulation routines in the manual, but nothing jumps out at me. Any pointers would be appreciated. Suppose you have some table with column called date_col DATE. i.e. containing dates as above Now if your question is: How to select all rows where is true that date_col is between dates 2002-02-08 and 2002-02-12? You can use almost same spelling. (SQL is written to be close to natural english) mysql SELECT date_col FROM your_table WHERE date_col BETWEEN '2002-02-08' AND '2002-02-12'; will be valid statement :) -- Best regards -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Keremidarski [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria ___/ www.mysql.com M: +359 88 231668 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
insert into integer field
When I try and insert a string into an integer field, instead of throwing an error MySQL accepts the insert and set that field's value to zero (I assume default value). I am using the php mysql module by the way (not PEAR). I would like to get an error when I insert the wrong data type into a column. Is this something I need to setup in MySQL or is the fault of the PHP MySQL module? -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: insert into integer field
{snip] When I try and insert a string into an integer field, instead of throwing an error MySQL accepts the insert and set that field's value to zero (I assume default value). I am using the php mysql module by the way (not PEAR). I would like to get an error when I insert the wrong data type into a column. Is this something I need to setup in MySQL or is the fault of the PHP MySQL module? [/snip] This is default behavior for MySQL. It will give a warning, but not an error. If memory serves there is nothing in the setup that will change this behavior. Jay Blanchard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 3.23.50???
Balteo, MySQL/InnoDB-3.23.50 for Windows is available for download at http://www.mysql.com/downloads/mysql-3.23-pre.html. The 'prerelease' status only concerns Linux, where a new glibc and a new compiler are tested. For other platforms this is a normal stable release. For the InnoDB changelog see http://www.innodb.com/ibman.html#InnoDB_history. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com - Original Message - From: [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Monday, May 06, 2002 3:25 AM Subject: 3.23.50??? What's going on at Mysql?? When can we expect 3.23.50??? Balteo. - Original Message - From: Rodrigo Pérez [EMAIL PROTECTED] To: Sent: Sunday, May 05, 2002 11:32 PM Subject: Re: Optimization Thanks Jay, Actually what i want to do is much more simple. I want to have on the same query result, the first 10 rows with this word and the total of rows from the table with this specific word. The result should be like a search engine page result. Has the total of pages with that word and the first 10 results. I want to put it together in only one query. Is it possible ? SELECT COUNT(*) from TABLE where name=JOHN SELECT * from TABLE where name=JOHN limit 10 Thanks, Rodrigo - Original Message - From: Jay Blanchard [EMAIL PROTECTED] To: 'Rodrigo Pérez' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, May 03, 2002 2:23 PM Subject: RE: Optimization [snip] I want to optimize one of my php scripts to acess mysql only once. Is there anyway to put these two queries together: SELECT COUNT(*) from TABLE where name=JOHN SELECT * from TABLE where name=JOHN limit 10 [/snip] try select *, sum(if(name = 'JOHN', 1, 0)) AS COUNT from table where name = 'JOHN' group by name HTH! Jay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Performance issues between two servers
Have you checked the network connection? You should be running at full-duplex so you don't get collisions. But more importantly, make sure you aren't getting errors on the line. A poor crimp or pinched wire could really slow things down, especially if you try running at 100MB. Try copying a single large file between APPDEV1/SQLDEV0 and APPDEV1/SQLDEV1. See what the speed difference is. Backgroud: We have a process that runs on a server (APPDEV1) that writes records to a mysql server (SQLDEV0). We attempted to move the databases from SQLDEV0 to SQLDEV1 and have run into some sort of performance bottleneck. The server SQLDEV0 is a Compac server with ~2GB of ram and two processors. The server SQLDEV1 is also a Compac server. It has 4GB of ram and two processors that are a bit faster than the ones in SQLDEV0. One big difference between SQLDEV0 and SQLDEV1 is the version of RedHat. SQLDEV0 is running RedHat 7.2. SQLDEV1 is running an enterprise version of RedHat 7.2 so that it can take advantage of the 4GB of ram. All the table spaces are using Innodb. Problem: The process on APPDEV1 can write records to the box SQLDEV0 about eight time faster than to SQLDEV1. We've looked over the my.sql configurations and they seem to be ok. In fact we adjusted the my.cnf file on SQLDEV1 so that it was identicle to SQLDEV0 but it did not help. The systems are running ~70-95% cpu idle so cpu is not a bottle neck. In testing, raw disk I/O rates are about 50% faster on SQLDEV1 as SQLDEV0. We don't see a bottle neck on I/O. This is the only process using mysql on SQLDEV1. On SQLDEV0 it shares access with several other programs but the box is not very busy. Thoughts? Comments? Criticism? Carl McNamee Systems Administrator/DBA Billing Concepts (210) 949-7282 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 28
You can use perror error_code to see what that error code is perror 28 Error code 28: No space left on device Seems like you ran out of space? Gurhan -Original Message- From: Scott Raley [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 8:44 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Error 28 I'm using DBTools Table Manager to make table changes in Mysql 3.23... I'm trying to add an auto_increment ID field to 2 tables that already have data in them.. 1 table worked fine, the other table I get Got Error 28 from Table Handler can anyone tell me why I get this? TIA - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Access denied irregularities
Make sure that the user + host combination you are giving has privileges in the MySQL server you are trying to connect. You may wanna check user table in the mysql database. Gurhan -Original Message- From: Nick Wilson [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 6:30 AM To: [EMAIL PROTECTED] Subject: Access denied irregularities -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I'm getting intermittent 'Access denied' errors when running a php script to admin a mysql db. I've looked in the manual but cannot work out why I can connect in some parts of the script and not in others Perhaps there is some common 'gotchas' you might let me know about? Here is the code I use to connect: function _db_connect() { if(!$this-link_id) { $this-link_id=mysql_connect($this-host, $this-user, $this-pass); } if(!$this-link_id) { return FALSE; } $db=mysql_select_db($this-db) or die (can't select db); return TRUE; } Many thanks for any help :-) - -- Nick Wilson // www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE81ls+HpvrrTa6L5oRAp0nAJwLLRlGpFV6ZQndPhqqF1+pW6w2MwCeK+H8 bsslUwVkhNA+8vVU/8S4qTc= =jhe5 -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Access denied irregularities
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Gurhan Ozen declared Make sure that the user + host combination you are giving has privileges in the MySQL server you are trying to connect. You may wanna check user table in the mysql database. Well, there must be privileges because as I said, I can connect sometimes and not others. - -- Nick Wilson // www.tioka.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE81oh/HpvrrTa6L5oRApPXAJ4uZhnlEh1uVOUva5QJRXtFq8H82ACfedLj ss8aXzi5/Spgwn2migqqnW4= =HVzX -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FULLTEXT search bugs in 4.0.1 alpha?...
Is there anyway to see what bugs have been reported for fulltext search in 4.0.1 alpha ? I know that Jeremy Zawodny has mentioned that a few bugs were found in fulltext search in 4.0.1 , but didn't tell what they were. I have installed 4.0.1 and ran it as second mysqld in my web server, mainly to utilize its fulltext search in boolean mode capability, but I have encountered some discrepancies. I don't want to resubmit them if they have already been submitted. Gurhan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Every user can access the databases
I have tried almost everything and nothing works. The problem is, I have a server with different MySQL databases from different people. User 1 should not access database 2 and user 2 should not access database 1. What is the easiest way to prevent user 1 to access database 2. I can't get it right. Thanks in advance, Dennis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Access denied irregularities
Nick, Monday, May 06, 2002, 3:58:34 PM, you wrote: NW * and then Egor Egorov declared Access denied error occurs when you have no required privileges to connect to the MySQL server. You gave incomplete error message and I can't give you detailed answer. Please, check the following link, you can find description of this error there: http://www.mysql.com/doc/A/c/Access_denied.html NW Yes, I've already been there. No luck. the problem seems to be on/off NW part of the time it is okay and at other times not. It is just a regular NW 'Access denied to user 'nick@localhost using passwore YES' error. Did you have successfully connected as 'nick@localhost' with the same password before or Access denied error appeared after you added this user? If you have no successful connections before, how did you set up privileges for your user? Are you sure that your password is correct? Check also privilege tables, if there are any conflict entries. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Turning on logging SQL-Commands
Hi! Can I turn on logging of all SQL-Commands send by one particular client on the server side? Turning on logging for all clients seems to be possible. Does it work for one client only too? -- Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: quota on mysql
HI, Praful Saijare wrote: Hi all, How do I go about applying user quota on mysql databases, so that I = can keep track of the disk space used by all the databases users. I am using RH linux 7.0 =20 Mysql 3.23.40 installed on /var/lib/mysql/ quota-2.00pre3-7 applied on /home partation Thanks in advance Praful Place user databases in their home dirs with some conventional names and make symlinks into mysql datadirs. Example: mkdir /home/user1/mysql_db chmod 700 /home/user1/mysql_db chown mysql home/user1/mysql_db ln -s /home/user1/mysql_db /var/lib/mysql/user1_db -- Best regards -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Keremidarski [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria ___/ www.mysql.com M: +359 88 231668 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Every user can access the databases
[snip] The problem is, I have a server with different MySQL databases from different people. User 1 should not access database 2 and user 2 should not access database 1. What is the easiest way to prevent user 1 to access database 2. I can't get it right. [/snip] http://www.mysql.com/doc/G/R/GRANT.html GRANT priv_type [(column_list)] [, priv_type [(column_list)] ...] ON {tbl_name | * | *.* | db_name.*} TO user_name [IDENTIFIED BY [PASSWORD] 'password'] [, user_name [IDENTIFIED BY 'password'] ...] Notice the second line of the query ON {tbl_name | * | *.* | db_name.*}, this is where you set permissions for a given database and/or table. Jay Blanchard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 search bugs in 4.0.1 alpha?...
Hi! On May 06, Gurhan Ozen wrote: Is there anyway to see what bugs have been reported for fulltext search in 4.0.1 alpha ? I know that Jeremy Zawodny has mentioned that a few bugs were found in fulltext search in 4.0.1 , but didn't tell what they were. I have installed 4.0.1 and ran it as second mysqld in my web server, mainly to utilize its fulltext search in boolean mode capability, but I have encountered some discrepancies. I don't want to resubmit them if they have already been submitted. Gurhan Take a look at http://www.mysql.com/doc/N/e/News-4.0.2.html but it's not easy to find out whether your particular bug is covered. I'd recommend to wait till 4.0.2 - it should be out very soon. 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
Newbie Question
Hi everybody, Let's say I do not want to use any microsoft tool on my PC. Is it possible to develop a desktop application using MySQL as database server without having to program in C or C++ to access and display the Data? My question probably should be: If not ODBC, what desktop database application (like MS-Access) can I use in Linux to access MySQL data or to develop and application that can access those data. TIA - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SV: Newbie Question
You could use Kylix from Borland. It's a RAD tool - it's actually Delphi ported to Linux. - Carsten -Oprindelig meddelelse- Fra: Yvon Darang [mailto:[EMAIL PROTECTED]] Sendt: 6. maj 2002 15:31 Til: [EMAIL PROTECTED] Emne: Newbie Question Hi everybody, Let's say I do not want to use any microsoft tool on my PC. Is it possible to develop a desktop application using MySQL as database server without having to program in C or C++ to access and display the Data? My question probably should be: If not ODBC, what desktop database application (like MS-Access) can I use in Linux to access MySQL data or to develop and application that can access those data. TIA - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Every user can access the databases
GRANT ALL PRIVILEGES ON databasename.* TO user IDENTIFIED BY 'password'; http://www.mysql.com/doc/G/R/GRANT.html Gurhan -Original Message- From: Dennis [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 9:52 AM To: [EMAIL PROTECTED] Subject: Every user can access the databases I have tried almost everything and nothing works. The problem is, I have a server with different MySQL databases from different people. User 1 should not access database 2 and user 2 should not access database 1. What is the easiest way to prevent user 1 to access database 2. I can't get it right. Thanks in advance, Dennis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
C++ API for Mysql
Hello, Can someone tell me if there is an C++ API that works smooth with MYSQL on linux. So far I was trying msql++ and SQLAPI++. SQLAPI++ seems to be good by there are problems when runing the program. My system is Redhat 7.2 and Mysql 3.23.49 Thanks, Hisseine - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
C++ API for Mysql
Hello, Can someone tell me if there is an C++ API that works smooth with MYSQL on linux. So far I was trying msql++ and SQLAPI++. SQLAPI++ seems to be good by there are problems when runing the program. My system is Redhat 7.2 and Mysql 3.23.49 Thanks, Hisseine - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SV: C++ API for Mysql
You can download MySQL++ from www.mysql.com - Carsten -Oprindelig meddelelse- Fra: Hisseine Dj. [mailto:[EMAIL PROTECTED]] Sendt: 6. maj 2002 17:24 Til: [EMAIL PROTECTED] Emne: C++ API for Mysql Hello, Can someone tell me if there is an C++ API that works smooth with MYSQL on linux. So far I was trying msql++ and SQLAPI++. SQLAPI++ seems to be good by there are problems when runing the program. My system is Redhat 7.2 and Mysql 3.23.49 Thanks, Hisseine - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
moving databases question...
I have before me what seems to be a very daunting task to someone with my limited SQL knowledge. I'm upgrading our ad server which runs on MySQL 3.22.32 to a newer machine and MySQL 3.23.39. Right now there are 16GB worth of databases that need to be transferred over, and the old server lacks enough hard disks space to even do a dump on one of those tables. So is there a way I can do a mysqldump directly from the old machine to the new one over the network? And if I can or if I'm offered a better way to do this, will the difference in MySQL version affect anything? Thanks in advance for any help/information. --- Richard Idalski System Administrator Nando Media Office: 919.836.4805 AIM: Ryusonuke www.nandomedia.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
New Release
Hi, The long awaited version 1.0.13 is now available for downloading. The list of changes and new features is too long, so I will give you a short description of what we changed: - New relationship editor ( now it can handle add new, update and delete and shows the SQL statement as an example) - New integrated User Manager (Add, Drop and Change all the privileges) - New Table Editor (Quick Editor, looks like MSAccess table design) - Fixed BLOB/TEXT fields when exporting results - Multiple statements is now back - Created format toolbar in the grid view to help cell formatting - Import Wizard and Import Text Wizard now saves the definitions, and these can be run at any time by clicking on the menu options - PHP-WSG now handles updates - Run External SQL now parses big SQL files - Added option to empty a table - Fixed bugs in the Export Data - Text Editor now uses a RichEdit Control, without size limitation - Added copy function in the Table Manager - Added support for FULLTEXT index - Fixed bug when exporting multiple files to text files - Query Editor now starts with the selected database as default - Added option to Go/ Don't Go full screen when starting - Import Wizard was improved a lot, now it can handles some data types better and it is quite faster for XBase tables - Removed the List View, now DBTools uses the HTML View to show object's data The new version can be download at http://www.dbtools.com.br as also all information about it. I'd like to thank all people envolved in the test fase and those who sent suggestions and bug-reports. Crercio O. Silva / DBTools Development - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with udf_example.cc
Hi, I'm using MySQL4.0.1-alpha under linux and want to use my own udfs. I tried to get working the udf_example and followed the MySQL manual. Compiling the file and using the CREATE FUNCTION command didn't succeed. I got the following error messages: gcc -shared -o udf_example.so -rdynamic udf_example.o mysql CREATE FUNCTION metaphon RETURNS STRING SONAME udf_example.so; ERROR 1126: Can't open shared library 'udf_example.so' (errno: 2 /usr/lib/udf_example.so: undefined symbol: default_charset_info) gcc -c -o udf_example.so -rdynamic udf_example.cc mysql CREATE FUNCTION metaphon RETURNS STRING SONAME udf_example.so; ERROR 1126: Can't open shared library 'udf_example.so' (errno: 2 udf_example.so: ELF file's phentsize not the expected size) What am I doing wrong? I would be grateful for an advice. Thanks in advance. Stefan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 search pattern syntax
Hi, It's not quite clear from the manual, but it appears that queries with FULLTEXT search patterns like this: MATCH (some_text_field) AGAINST ('(red pepper) (green bean)') don't produce the result desired, that is, multiple .. elements are not allowed, with or without parentheses... Could someone confirm, please? On a general note, it would be nice to have the formal syntax of FT search patterns in the manual. TIA, Vadim. [sql query - to satisfy the darn spam filter] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Bug or error in SQL syntax - Specifying and using a user variable inside a single select query
Greetings, Upon reading into the user variables section of the mysql manual, I decided to make my life easier inside several of my queries by specifying some user variables. Note that I'm trying to have everything inside the select statement - Primarily because I'm simply passing it through to my data mining software that interfaces through myODBC. I'm trying to accomplish the following query (I'm executing these sql queries directly from the command line) -- == SELECT annual_filing.*, companies.name AS company_name, YEAR(filing_date) AS filing_year, (@predictedYear := 1999) AS predictedYear, (@earliestYear := 1996) AS earliestYear, (@learnYear := 1998) AS learnYear FROM annual_filing, companies WHERE annual_filing.company_id = companies.ds_id AND YEAR(filing_date) = @predictedYear AND YEAR(filing_date) = @earliestYear; == The above query returned an empty set / no rows. Replacing the user variables with actual values, as shown below, returns the appropriate rows (5537 rows) (for obvious reasons because I'm not using any user variables in the WHERE clause): == SELECT annual_filing.*, companies.name AS company_name, YEAR(filing_date) AS filing_year, (@predictedYear := 1999) AS predictedYear, (@earliestYear := 1996) AS earliestYear, (@learnYear := 1998) AS learnYear FROM annual_filing, companies WHERE annual_filing.company_id = companies.ds_id AND YEAR(filing_date) = 1999 AND YEAR(filing_date) = 1996; == I also tried the below ... == SET @predictedYear = 1999; SET @earliestYear = 1996; SET @learnYear = 1998; SELECT company_id, @findEarliestYear AS findEarliestYear, @findLearnYear AS findLearnYear, @findPredictedYear AS findPredictedYear FROM annual_filing WHERE YEAR(annual_filing.filing_date) @findPredictedYear; == And mysql returned no results / an empty set. Trying to debug the problem further, I tried ... == SET @predictedYear = 1999; SET @earliestYear = 1996; SET @learnYear = 1998; SELECT company_id, @findEarliestYear, @findLearnYear, @findPredictedYear FROM annual_filing WHERE YEAR(annual_filing.filing_date) @findPredictedYear; == Still an empty set... And also verified the SET is actually doing its job (which it is) -- == mysql SET @predictedYear = 1999; Query OK, 0 rows affected (0.00 sec) mysql SET @earliestYear = 1996; Query OK, 0 rows affected (0.01 sec) mysql SET @learnYear = 1998; Query OK, 0 rows affected (0.00 sec) mysql SELECT @predictedYear, @earliestYear, @learnYear; ++---++ | @predictedYear | @earliestYear | @learnYear | ++---++ | 1999 | 1996 | 1998 | ++---++ 1 row in set (0.00 sec) == Does anyone have any insights or clues as to what the problem could be? Thanks in advance! === Gregg Graubins [EMAIL PROTECTED] (PGP key available) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 search pattern syntax
Of course, I forgot to mention 'IN BOOLEAN MODE'. ... MATCH (some_text_field) AGAINST ('(red pepper) (green bean)' IN BOOLEAN MODE) ... Vadim P. wrote: Hi, It's not quite clear from the manual, but it appears that queries with FULLTEXT search patterns like this: MATCH (some_text_field) AGAINST ('(red pepper) (green bean)') don't produce the result desired, that is, multiple .. elements are not allowed, with or without parentheses... Could someone confirm, please? On a general note, it would be nice to have the formal syntax of FT search patterns in the manual. TIA, Vadim. [sql query - to satisfy the darn spam filter] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Newbie Question
Hi If you are developing for a Windows desktop, MyODBC with Access, Paradox or Delphi all workm, from experience. If you are developing for Linux desktop, then not sure, but perhaps others have experience Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- -Original Message- From: Yvon Darang [mailto:[EMAIL PROTECTED]] Sent: 06 May 2002 14:31 To: [EMAIL PROTECTED] Subject: Newbie Question Hi everybody, Let's say I do not want to use any microsoft tool on my PC. Is it possible to develop a desktop application using MySQL as database server without having to program in C or C++ to access and display the Data? My question probably should be: If not ODBC, what desktop database application (like MS-Access) can I use in Linux to access MySQL data or to develop and application that can access those data. TIA - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Every user can access the databases
Dennis, Monday, May 06, 2002, 4:51:50 PM, you wrote: D I have tried almost everything and nothing works. D The problem is, I have a server with different MySQL databases from D different people. D User 1 should not access database 2 and user 2 should not access database 1. D What is the easiest way to prevent user 1 to access database 2. I can't get D it right. You should set permissions for user 1 on every required database, except database 2. Use GRANT statement: http://www.mysql.com/doc/G/R/GRANT.html D Thanks in advance, D Dennis -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: C++ API for Mysql
Hi Carsten, I've tried Mysql++ and SQLAPI. I am asking if someone out there know about other best tools in C++ for Mysql on linux. Thanks, Hisseine - Original Message - From: Carsten Gehling [EMAIL PROTECTED] To: Hisseine Dj. [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, May 06, 2002 11:31 AM Subject: SV: C++ API for Mysql You can download MySQL++ from www.mysql.com - Carsten -Oprindelig meddelelse- Fra: Hisseine Dj. [mailto:[EMAIL PROTECTED]] Sendt: 6. maj 2002 17:24 Til: [EMAIL PROTECTED] Emne: C++ API for Mysql Hello, Can someone tell me if there is an C++ API that works smooth with MYSQL on linux. So far I was trying msql++ and SQLAPI++. SQLAPI++ seems to be good by there are problems when runing the program. My system is Redhat 7.2 and Mysql 3.23.49 Thanks, Hisseine - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
please take me off from the mail list thank you
-Original Message- From: Peter Lovatt [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 12:09 PM To: Yvon Darang; [EMAIL PROTECTED] Subject: RE: Newbie Question Hi If you are developing for a Windows desktop, MyODBC with Access, Paradox or Delphi all workm, from experience. If you are developing for Linux desktop, then not sure, but perhaps others have experience Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- -Original Message- From: Yvon Darang [mailto:[EMAIL PROTECTED]] Sent: 06 May 2002 14:31 To: [EMAIL PROTECTED] Subject: Newbie Question Hi everybody, Let's say I do not want to use any microsoft tool on my PC. Is it possible to develop a desktop application using MySQL as database server without having to program in C or C++ to access and display the Data? My question probably should be: If not ODBC, what desktop database application (like MS-Access) can I use in Linux to access MySQL data or to develop and application that can access those data. TIA - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Bug or error in SQL syntax - Specifying and using a user variable inside a single select query
Gregg, Monday, May 06, 2002, 6:57:55 PM, you wrote: GG Upon reading into the user variables section of the mysql manual, I decided GG to make my life easier inside several of my queries by specifying some user GG variables. Note that I'm trying to have everything inside the select GG statement - Primarily because I'm simply passing it through to my data GG mining software that interfaces through myODBC. GG I'm trying to accomplish the following query (I'm executing these sql GG queries directly from the command line) -- GG GG == GG SELECT GGannual_filing.*, GGcompanies.name AS company_name, GGYEAR(filing_date) AS filing_year, GG(@predictedYear := 1999) AS predictedYear, GG(@earliestYear := 1996) AS earliestYear, GG(@learnYear := 1998) AS learnYear GG FROM GGannual_filing, GGcompanies GG WHERE GG annual_filing.company_id = companies.ds_id GGAND GG YEAR(filing_date) = @predictedYear GGAND GG YEAR(filing_date) = @earliestYear; GG GG == GG The above query returned an empty set / no rows. You should first initialize user variables! By default they contain NULL values as SELECT works by first checking WHERE clause and only then works for SELECT. Check the manual: http://www.mysql.com/doc/V/a/Variables.html GG === GG Gregg Graubins [EMAIL PROTECTED] -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
please help: search database - code attached
Hi, I have a table of jobs. I would like user to search the jobs on three columns: description, location, type, on the search page, i have one text field, and one drop down menu. the search field will be used for keywords against the description and location columns. the drop down will choose between the ONLY two types of entry for a type column (permanent and temp) here is my sql (i'm using mysql fulltext search) Select * from tbl_jobs WHERE MATCH (description, location) AGAINST ('%mm_keywords%') AND type = 'mm_type' i keep on getting empty sets. is there anything i am missing here? any help would be greatly appreciated. cheers Shez __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.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
Too Many Connections
MySQL keeps locking up (I get a Too many connections error.) Is there a way that I can increase the number of connections that MySQL will take? SQL and Query David McInnis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 search pattern syntax
Hi.. Rewrite it as: WHERE MATCH (some_text_field) AGAINST ('red pepper' IN BOOLEAN MODE) AND MATCH (some_text_field) AGAINST (green bean' IN BOOLEAN MODE); Gurhan -Original Message- From: Vadim P. [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 12:07 PM To: [EMAIL PROTECTED] Subject: Re: FULLTEXT search pattern syntax Of course, I forgot to mention 'IN BOOLEAN MODE'. ... MATCH (some_text_field) AGAINST ('(red pepper) (green bean)' IN BOOLEAN MODE) ... Vadim P. wrote: Hi, It's not quite clear from the manual, but it appears that queries with FULLTEXT search patterns like this: MATCH (some_text_field) AGAINST ('(red pepper) (green bean)') don't produce the result desired, that is, multiple .. elements are not allowed, with or without parentheses... Could someone confirm, please? On a general note, it would be nice to have the formal syntax of FT search patterns in the manual. TIA, Vadim. [sql query - to satisfy the darn spam filter] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: please help: search database - code attached
Get rid of percentage signs in your keyword... See: http://www.mysql.com/doc/F/u/Fulltext_Search.html Gurhan -Original Message- From: Shehryar Shafiq [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 12:46 PM To: [EMAIL PROTECTED] Subject: please help: search database - code attached Hi, I have a table of jobs. I would like user to search the jobs on three columns: description, location, type, on the search page, i have one text field, and one drop down menu. the search field will be used for keywords against the description and location columns. the drop down will choose between the ONLY two types of entry for a type column (permanent and temp) here is my sql (i'm using mysql fulltext search) Select * from tbl_jobs WHERE MATCH (description, location) AGAINST ('%mm_keywords%') AND type = 'mm_type' i keep on getting empty sets. is there anything i am missing here? any help would be greatly appreciated. cheers Shez __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Too Many Connections
Hi, Change the max_connections variable's value to a higher value. By default it is set to 100. You can see what yours is set to with SHOW VARIABLES command. See: http://www.mysql.com/doc/T/o/Too_many_connections.html http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html Gurhan -Original Message- From: David McInnis [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 12:49 PM To: [EMAIL PROTECTED] Subject: Too Many Connections MySQL keeps locking up (I get a Too many connections error.) Is there a way that I can increase the number of connections that MySQL will take? SQL and Query David McInnis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
MySQLGUI source distribution: files missing
Hi! I have great trouble compiling MySQLGUI 1.7.5: Missing headers: FL/Enumerations.H FL/filename.H FL/fl_ask.H FL/Fl_Bitmap.H Fl/Fl_Box.H FL/Fl_Box.H FL/Fl_Browser.H FL/Fl_Button.H FL/Fl_Check_Button.H FL/Fl_Choice.H FL/Fl_Dial.H FL/Fl_Double_Window.H Fl/fl_draw.H FL/fl_draw.H FL/fl_file_chooser.H FL/Fl_Group.H FL/Fl.H FL/Fl_Hold_Browser.H FL/Fl_Input.H FL/Fl_Light_Button.H FL/Fl_Menu_Bar.H FL/Fl_Menu_Button.H FL/Fl_Menu_.H FL/Fl_Menu.H FL/Fl_Multi_Browser.H FL/Fl_Multiline_Input.H FL/Fl_Output.H FL/Fl_Pixmap.H FL/Fl_Return_Button.H FL/Fl_Round_Button.H Fl/Fl_Scrollbar.H FL/Fl_Scrollbar.H FL/Fl_Scroll.H FL/Fl_Select_Browser.H FL/Fl_Slider.H FL/Fl_Tabs.H Fl/Fl_Tile.H FL/Fl_Tile.H FL/Fl_Valuator.H FL/Fl_Value_Output.H FL/Fl_Value_Slider.H FL/Fl_Widget.H FL/Fl_Window.H mysql++ sqlplus.hh Missing files: the source for edfile.o Missing Flags: -IFL Volker -- The early bird gets the worm. If you want something else for breakfast, get up later. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can't create/write to file
Hello All, I have created a MySQL database on Linux Mandrake 8.0, all is well. I can add fields / tables ok. I moved the contents of the database directory and the mysql directory to another system (Same OS MySQL). I can access the database but can not add fields. Failed to save field : SQL alter table ZControl add pid tinyint(4) failed : './CRdB/#sql-6c4_a.frm' (Errcode: 13) I have verified and checked the file permissions etc... I can create a new database no problems. I am just unable to modify the database I moved over ... Any suggestions would be most greatly appreciated. Marko Palikko [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
Two database servers, same physical server
Has someone done this before? What things do I have to take into consideration The following are things I know that may be issues reading mysql.sock reading my.cnf database directory ( there is a parameter for command line operation ) I would suppose I would have to create a dual instance of the daemon script Anything else I might be missing? What should I do to make this work? --- Why do I want to do this? Replication. One slave can not be slave to mulitple masters. ( as far as I know ). I do not want to have a so many servers as I have clients ( the replication is a saftey thing offered by us, most clients still have thier own replication server, but some just can not afford it, so we replicate for them. ) Now that I have written the above R word, this mail will be completely ignored. Why is that? I have yet to see answers to any questions in regards to replication. Is it that nobody else uses replication except the people who have problems, or just that no person has extended knowlegde on the issue and they just keep their mouths shut so they don't lead others astray. Just curious. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Can't create/write to file
Check your permissions and fileowners one more time. You definitely have permissions problem.. Make sure that all the datafiles are owned by mysql. Gurhan -Original Message- From: Marko Palikko [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 1:00 PM To: [EMAIL PROTECTED] Subject: Can't create/write to file Hello All, I have created a MySQL database on Linux Mandrake 8.0, all is well. I can add fields / tables ok. I moved the contents of the database directory and the mysql directory to another system (Same OS MySQL). I can access the database but can not add fields. Failed to save field : SQL alter table ZControl add pid tinyint(4) failed : './CRdB/#sql-6c4_a.frm' (Errcode: 13) I have verified and checked the file permissions etc... I can create a new database no problems. I am just unable to modify the database I moved over ... Any suggestions would be most greatly appreciated. Marko Palikko [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: FULLTEXT search pattern syntax
Hi! On May 06, Vadim P. wrote: Hi, It's not quite clear from the manual, but it appears that queries with FULLTEXT search patterns like this: MATCH (some_text_field) AGAINST ('(red pepper) (green bean)') don't produce the result desired, that is, multiple .. elements are not allowed, with or without parentheses... Could you explain, what result is desired and what result you are getting ? Because, right now I can only say that multiple .. elements ARE allowed, of course. On a general note, it would be nice to have the formal syntax of FT search patterns in the manual. I do not understand, what is missing in the manual right now ? There is a list of operators, you can use any of them in whatever combination you want. 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
two table's columns into one columns w/o INSERT ... SELECT?
Here is a puzzler for SQL jockies on a Monday afternoon. I have 2 tables, each with what may or may not be a unique range of dates; tblDate1 +++ | field1 | rDate | +++ | 1 | 2002-03-01 | | 2 | 2002-03-03 | | 3 | 2002-03-05 | | 4 | 2002-03-07 | +++ tblDate2 +++ | field1 | rDate | +++ | 1 | 2002-03-02 | | 2 | 2002-03-04 | | 3 | 2002-03-06 | | 4 | 2002-03-08 | | 5 | 2002-03-07 | +++ I need a SQL query that returns these as one column with no duplicates, preferably without having to create a temp table by doing an INSERT SELECT ++ | rDate | ++ | 2002-03-01 | | 2002-03-02 | | 2002-03-03 | | 2002-03-04 | | 2002-03-05 | | 2002-03-06 | | 2002-03-07 | | 2002-03-08 | ++ Has anyone done this before? Jay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: two table's columns into one columns w/o INSERT ... SELECT?
If you have MySQL 4, you can use a UNION. Otherwise you'll need a second table, because what you want is not a join, but a concatenation of result sets. At 12:47 -0500 5/6/02, Jay Blanchard wrote: Here is a puzzler for SQL jockies on a Monday afternoon. I have 2 tables, each with what may or may not be a unique range of dates; tblDate1 +++ | field1 | rDate | +++ | 1 | 2002-03-01 | | 2 | 2002-03-03 | | 3 | 2002-03-05 | | 4 | 2002-03-07 | +++ tblDate2 +++ | field1 | rDate | +++ | 1 | 2002-03-02 | | 2 | 2002-03-04 | | 3 | 2002-03-06 | | 4 | 2002-03-08 | | 5 | 2002-03-07 | +++ I need a SQL query that returns these as one column with no duplicates, preferably without having to create a temp table by doing an INSERT SELECT ++ | rDate | ++ | 2002-03-01 | | 2002-03-02 | | 2002-03-03 | | 2002-03-04 | | 2002-03-05 | | 2002-03-06 | | 2002-03-07 | | 2002-03-08 | ++ Has anyone done this before? Jay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Converting text files to MySQL
I've been trying to import text files into MySQL, but I can't get it to work. I'm new to MySQL and am still getting familiar with it, so perhaps I'm missing something. I'm using the LOAD DATA LOCAL command but I keep getting error 1148 The used command is not allowed with this MySQL version. Now from reading the information in the docs section (http://www.mysql.com/doc/L/O/LOAD_DATA_LOCAL.html) it appears that LOAD DATA LOCAL is sometimes disabled for security reasons, and that there are two ways around this. I've tried both ways but it doesn't seem to work. I tried using the command --enable-local-infile but apparently that's only compatible with version 3.23.48 and before, and we have 3.23.49. Is there something else I should do? Can anyone help me please? Thanks so much! Christy Roberts Technical Project Lead iMIRADOR.com Inc. St. John's, Newfoundland Tel: 709.737.4485 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
High-Speed/Volume Database
We are designing an application that needs to use a relational database to hold quite a large amount of data. In particular there is one table that has about 33 fields, 18 indexes, and 120 bytes per record. Additionally, we are going to need to add about 2 million records per day to the table, delete about 2 million records per day from the table, hold 2 weeks worth of data within the database (approx. 30 million records), and sustain an average add rate of about 23 records per second while, at the same time, sustaining an average delete rate of 23 records per second. My questions are, what database software should we use, what kind of hardware platform will be needed to support the specifications enumerated above, and what kind of average query performance can we expect? _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can't create/write to file (more info)
Wow, Quick response... You guys ( gals) are Great !! All files /var/lib/CRdb/* (Database Directory) are 777 (CHMOD) and ownership mysql All files /var/lib/mysql/mysql/* are 777 as well. hmm. ( Very Puzzled ) Also the file #sql-6c4_a.frm in the error message does not exist. Failed to save field : SQL alter table ZControl add pid tinyint(4) failed : './CRdB/#sql-6c4_a.frm' (Errcode: 13) Thanks Again, Marko Palikko [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: two table's columns into one columns w/o INSERT ... SELECT?
[snip] If you have MySQL 4, you can use a UNION. Otherwise you'll need a second table, because what you want is not a join, but a concatenation of result sets. [snip] Don't have 4.0 yet, probably going to wait until a production release comes out. So if I need a second table I will have to do that...trying to keep one query statement per PHP request. Thanks! Jay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: High-Speed/Volume Database
Over here, we're doing an average of 95 queries per second (that's about 8 mill daily), on a Pentium III @ 900MHz with 768MB of ram. We're working with smaller data sets, than 30 million records, tho. I imagine that you could do well with a high end intel system, or a medium-end Sun box. A dual processor Athlon MP 1900+ system with 4GB of ram, and SCSI raid would probably serve you well. This would run about $5k at most. If you want to go with sun, a E450 would probably do the trick for ya. Figure 8GB of ram (more ram is good -- the more of the DB you can hold in memory, the better you'll do.) and 2 or 4 processors. (Actually, I suspect than an E450 would exceed your needs by a lot.) That sort of box would cost you about $20k, IIRC. HTH, Gabriel. Bob Smith wrote: We are designing an application that needs to use a relational database to hold quite a large amount of data. In particular there is one table that has about 33 fields, 18 indexes, and 120 bytes per record. Additionally, we are going to need to add about 2 million records per day to the table, delete about 2 million records per day from the table, hold 2 weeks worth of data within the database (approx. 30 million records), and sustain an average add rate of about 23 records per second while, at the same time, sustaining an average delete rate of 23 records per second. My questions are, what database software should we use, what kind of hardware platform will be needed to support the specifications enumerated above, and what kind of average query performance can we expect? -- Gabriel Cain Unix Systems Administrator [EMAIL PROTECTED] Dialup USA, Inc. 888-460-2286 ext 208 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Get the next AUTO INCREMENT value for a column
To the originator of this thread: While what you are asking is possible, Id like to put my two cents in and ask you please not to do it. If this is a production database, you have no idea how helpful it will be for you to know by those missing pk numbers that something was deleted manually from the database as opposed to an index error, or some other more disasterous problem. In my experiece leave those holes in the pk sequence, and then later on when someone complains that a record is missing, you can say with some confidence that someone actually deleted it. AS a followup note, I would never allow user permissions to let a regular user delete a record in the first place, and I would stop it with either code, or database user access privelages. Instead create an active/inactive status field and then you can rewrite some code to add a where status = 'active' or similar line of code Then create a purge records' function in your app so that admins who are supposed to know what they are doing can delete records if they really want to. Just my opinion. Rance PS. hey filter, chew on this, MySQL, SQL, From: Arthur Fuller [EMAIL PROTECTED] To: Harrison C. Fisk [EMAIL PROTECTED], [EMAIL PROTECTED], Paul DuBois [EMAIL PROTECTED] Subject: Re: Get the next AUTO INCREMENT value for a column Date: Sun, 5 May 2002 14:06:43 -0400 IMO the desire to know this answer suggests that something is wrong with the design. Again IMO, a PK must be absolutely meaningless. Any attempt to impost meaning on it is by definition wrong. By my lights, the only PK you want to know is the one just added. That's enough information to let you start adding rows to child tables. And that value you can easily obtain. Arthur - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Harrison C. Fisk [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, May 04, 2002 12:34 PM Subject: Re: Get the next AUTO INCREMENT value for a column At 12:29 -0400 5/4/02, Harrison C. Fisk wrote: Actually I think the SHOW TABLE STATUS like 'TABLENAME' command can show you the next auto_increment value. There is no guarantee that this value will actually be used for the next AUTO_INCREMENT value. Suppose another client issues the following query: ALTER TABLE tbl_name AUTO_INCREMENT = 123456; If you were relying on what SHOW TABLE STATUS said, you'd be hosed. :-) Although I can say I wouldn't really ever use it except for personal use, not in an actual application. Harrison - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Son Nguyen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, May 04, 2002 12:16 PM Subject: Re: Get the next AUTO INCREMENT value for a column At 9:01 -0700 5/4/02, Son Nguyen wrote: CREATE table test1 (ID int NOT NULL AUTO INCREMENT, name text, value text, Primary Key (ID)); INSERT into test1 (name, value) values (test1, value1); INSERT into test1 (name, value) values (test2, value2); DELETE from test1 where ID=2; How can obtain the CURRENT value of next ID AUTO INCREMENT value (which is 3 right now) Son Nguyen mysql, query You can't. AUTO_INCREMENT values are not available until you generate them. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: two table's columns into one columns w/o INSERT ... SELECT?
On 6 May 2002, at 13:06, Jay Blanchard wrote: [snip] If you have MySQL 4, you can use a UNION. Otherwise you'll need a second table, because what you want is not a join, but a concatenation of result sets. [snip] Don't have 4.0 yet, probably going to wait until a production release comes out. So if I need a second table I will have to do that...trying to keep one query statement per PHP request. You might be able to use a merge table, but it will require a query to create it. That query could be done earlier, though, if the number of combinations of tables is small. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: High-Speed/Volume Database
At 12:56 PM 5/6/2002, you wrote: We are designing an application that needs to use a relational database to hold quite a large amount of data. In particular there is one table that has about 33 fields, 18 indexes, and 120 bytes per record. Additionally, we are going to need to add about 2 million records per day to the table, delete about 2 million records per day from the table, hold 2 weeks worth of data within the database (approx. 30 million records), and sustain an average add rate of about 23 records per second while, at the same time, sustaining an average delete rate of 23 records per second. My questions are, what database software should we use, what kind of hardware platform will be needed to support the specifications enumerated above, and what kind of average query performance can we expect? Bob, You left out some critical information. 1a) How many concurrent users will there be reading from the busiest table, and 1b) how many will be deleting records from the busiest table? 2) Also how do you determine which records will be deleted? Do you delete an entire days worth of records at a time? If so, you might consider creating a table for each day, like table_mon, table_tue, ... table_sun, table_lastmon, ... table_lastsun so you have 14 tables. When you get a new day, you do a Delete * from table_mon (if it is Monday) which in effect drops the table and recreates it which is extremely fast. To query the entire set of tables, use Merge tables. This only works with MyISAM tables. If on the other hand you need to add and delete records concurrently, try InnoDb table type. It stands up well to deletes and inserts. One suggest I have is to use CHAR() field types rather than VarChar(). If you delete fixed length records (CHAR) then MySQL can re-use the deleted space. VarChar will have internal fragmentation especially when doing all those deletes, so eventually you will need to reload the data. So stick with CHAR if you can. You will need at least dual processors and stuff it with as much RAM as it can hold (2g or more). 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
SOP for hosting services?
Hi, I using Macromedia UltraDev to develop my dynamic web site and would like to use mySQL as the RDBMS. My hosting service folks are telling me that I should only update my database on their server via update transactions. They say this is for security reasons. UltraDev provides many good tools for viewing, adding, updating and deleting records for the database but I'm not sure how to produce add/delete/update transactions from UltraDev and I'm not convinced it is necessary to have the added layer of security. Is this standard operating procedure when making changes to mySQL databases or should I tell them that I want direct access to my database? Any help/suggestions/guidelines in this area would be very helpful. Thanks. Pete - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Two database servers, same physical server
Hi, To run multiple mysqld servers, you at least have to specify a different port number, different socket file path, different pid and error log file to get it started. Different mysqld servers may point to the same database. To do this, just define the necessary information for your new mysqld server in a my.cnf file, and start it with ./bin/safe_mysqld --defaults-file=/path/to/new/my.cnf . Gurhan -Original Message- From: Luc Foisy [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 1:33 PM To: MYSQL-List (E-mail) Subject: Two database servers, same physical server Has someone done this before? What things do I have to take into consideration The following are things I know that may be issues reading mysql.sock reading my.cnf database directory ( there is a parameter for command line operation ) I would suppose I would have to create a dual instance of the daemon script Anything else I might be missing? What should I do to make this work? --- Why do I want to do this? Replication. One slave can not be slave to mulitple masters. ( as far as I know ). I do not want to have a so many servers as I have clients ( the replication is a saftey thing offered by us, most clients still have thier own replication server, but some just can not afford it, so we replicate for them. ) Now that I have written the above R word, this mail will be completely ignored. Why is that? I have yet to see answers to any questions in regards to replication. Is it that nobody else uses replication except the people who have problems, or just that no person has extended knowlegde on the issue and they just keep their mouths shut so they don't lead others astray. Just curious. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: SpamAssassin tags messages from the list as spam (was: [fwd] *****SPAM***** Re: Problems with Time field (from: dump_pj@red
On 6 May 2002, at 7:56, Alexander Skwar wrote: As you can see below, SpamAssassin tags messages from the MySQL list as spam. The main reason that this happens, is: SPAM: Hit! (3.5 points) URI: URL of page called unsubscribe It seems to me that that's a problem with SpamAssassin, not with the list. Many, many legitimate mailing lists have unsubscribe links that contain the word unsubscribe. It's true that many spam messages contain such links, but many spam messages also contain the word money, and marking all messages containing money as spam would be a bad idea. Maybe you need to set your threshold lower, or otherwise adjust the configuration. [Filter fodder: SQL] -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Two database servers, same physical server
Hi If the databases are not too big, and are on the same machine, you could just copy the directory with the databases in. If you need to restore the database just copy it back. I think this is OK, though you might want to stop mysql to lock the database. I have only done this a couple of times (on a quiet database) because I replicate across two servers. If anybody knows better, or thinks this is a bad idea, then I will defer to their greater knowledge! HTH Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- -Original Message- From: Luc Foisy [mailto:[EMAIL PROTECTED]] Sent: 06 May 2002 18:33 To: MYSQL-List (E-mail) Subject: Two database servers, same physical server Has someone done this before? What things do I have to take into consideration The following are things I know that may be issues reading mysql.sock reading my.cnf database directory ( there is a parameter for command line operation ) I would suppose I would have to create a dual instance of the daemon script Anything else I might be missing? What should I do to make this work? --- Why do I want to do this? Replication. One slave can not be slave to mulitple masters. ( as far as I know ). I do not want to have a so many servers as I have clients ( the replication is a saftey thing offered by us, most clients still have thier own replication server, but some just can not afford it, so we replicate for them. ) Now that I have written the above R word, this mail will be completely ignored. Why is that? I have yet to see answers to any questions in regards to replication. Is it that nobody else uses replication except the people who have problems, or just that no person has extended knowlegde on the issue and they just keep their mouths shut so they don't lead others astray. Just curious. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Two database servers, same physical server
more detail on this can be found here http://www.mysql.com/doc/M/u/Multiple_servers.html -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 3:10 PM To: Luc Foisy; MYSQL-List (E-mail) Subject: RE: Two database servers, same physical server Hi, To run multiple mysqld servers, you at least have to specify a different port number, different socket file path, different pid and error log file to get it started. Different mysqld servers may point to the same database. To do this, just define the necessary information for your new mysqld server in a my.cnf file, and start it with ./bin/safe_mysqld --defaults-file=/path/to/new/my.cnf . Gurhan -Original Message- From: Luc Foisy [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 1:33 PM To: MYSQL-List (E-mail) Subject: Two database servers, same physical server Has someone done this before? What things do I have to take into consideration The following are things I know that may be issues reading mysql.sock reading my.cnf database directory ( there is a parameter for command line operation ) I would suppose I would have to create a dual instance of the daemon script Anything else I might be missing? What should I do to make this work? --- Why do I want to do this? Replication. One slave can not be slave to mulitple masters. ( as far as I know ). I do not want to have a so many servers as I have clients ( the replication is a saftey thing offered by us, most clients still have thier own replication server, but some just can not afford it, so we replicate for them. ) Now that I have written the above R word, this mail will be completely ignored. Why is that? I have yet to see answers to any questions in regards to replication. Is it that nobody else uses replication except the people who have problems, or just that no person has extended knowlegde on the issue and they just keep their mouths shut so they don't lead others astray. Just curious. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Two database servers, same physical server
Thanks Don, Gurhan, Peter! uhg. I am sure I searched the docs first. *sigh* -Original Message- From: Don Vu [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 3:19 PM To: Gurhan Ozen; Luc Foisy; MYSQL-List (E-mail) Subject: RE: Two database servers, same physical server more detail on this can be found here http://www.mysql.com/doc/M/u/Multiple_servers.html -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 3:10 PM To: Luc Foisy; MYSQL-List (E-mail) Subject: RE: Two database servers, same physical server Hi, To run multiple mysqld servers, you at least have to specify a different port number, different socket file path, different pid and error log file to get it started. Different mysqld servers may point to the same database. To do this, just define the necessary information for your new mysqld server in a my.cnf file, and start it with ./bin/safe_mysqld --defaults-file=/path/to/new/my.cnf . Gurhan -Original Message- From: Luc Foisy [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 1:33 PM To: MYSQL-List (E-mail) Subject: Two database servers, same physical server Has someone done this before? What things do I have to take into consideration The following are things I know that may be issues reading mysql.sock reading my.cnf database directory ( there is a parameter for command line operation ) I would suppose I would have to create a dual instance of the daemon script Anything else I might be missing? What should I do to make this work? --- Why do I want to do this? Replication. One slave can not be slave to mulitple masters. ( as far as I know ). I do not want to have a so many servers as I have clients ( the replication is a saftey thing offered by us, most clients still have thier own replication server, but some just can not afford it, so we replicate for them. ) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: two table's columns into one columns w/o INSERT ... SELECT?
[snip] If you have MySQL 4, you can use a UNION. Otherwise you'll need a second table, because what you want is not a join, but a concatenation of result sets. [snip] Don't have 4.0 yet, probably going to wait until a production release comes out. So if I need a second table I will have to do that...trying to keep one query statement per PHP request. You might be able to use a merge table, but it will require a query to create it. That query could be done earlier, though, if the number of combinations of tables is small. [/snip] Do you know if there is a limit on table size with MERGE? Jay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
formatting currency in mysql
Does anyone have a quick tip on how to format a float/numeric in the following currency format with a query? $xx,xxx.xx Thanks! Graeme - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Merge tables, was [two table's columns into one columns w/o INSERT ... SELECT?]
I have these two tables; mysql describe tblClass11; +--+---+--+-+-++ | Field| Type | Null | Key | Default | Extra | +--+---+--+-+-++ | ID | int(11) | | PRI | NULL| auto_increment | | RecordID | varchar(6)| YES | | NULL|| | RecordDate | varchar(10) | YES | | NULL|| | CIC | varchar(4)| YES | | NULL|| | Minutes | decimal(12,2) | YES | | NULL|| | FileName | varchar(32) | YES | | NULL|| | RecordNumber | int(11) | YES | | NULL|| | WholeRecord | text | YES | | NULL|| | ReceivedDate | varchar(10) | YES | | NULL|| +--+---+--+-+-++ 9 rows in set (0.00 sec) mysql describe tblClassOthers; +--+---+--+-+-++ | Field| Type | Null | Key | Default | Extra | +--+---+--+-+-++ | ID | int(11) | | PRI | NULL| auto_increment | | RecordID | varchar(6)| YES | | NULL|| | RecordDate | varchar(10) | YES | | NULL|| | CIC | varchar(4)| YES | | NULL|| | Minutes | decimal(12,2) | YES | | NULL|| | FileName | varchar(32) | YES | | NULL|| | RecordNumber | int(11) | YES | | NULL|| | WholeRecord | text | YES | | NULL|| | ReceivedDate | varchar(10) | YES | | NULL|| +--+---+--+-+-++ 9 rows in set (0.00 sec) I attempt to MERGE; mysql CREATE TABLE tblCross1 (ID INT NOT NULL, - RecordID VARCHAR(6), - RecordDate VARCHAR(10), - Minutes DECIMAL(12,2), - KEY(ID)) - TYPE=MERGE - UNION=(tblClass11, tblClassOthers); Query OK, 0 rows affected (0.01 sec) Then I attempt to query;mysql select count(*) from tblCross1; ERROR 1016: Can't open file: 'tblCross1.MRG'. (errno: 143) perror 143 143 = Conflicting table definition between MERGE and mapped table Can anyone help with this? Thanks! Jay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 search pattern syntax
Sergei, here: RH7.2/2.4.9-31/Dual P-III 866MHz/MySQL4.0.2 A snapshot from a live database, sorry, couldn't prepare a more detailed example: -- select tdate, left(header,125) from archivel where match (header) against ('donald rumsfeld' in boolean mode); == 188 rows in set (0.12 sec) -- select tdate, left(header,125) from archivel where match (header) against ('president bush' in boolean mode); == 1979 rows in set (2.40 sec) -- select tdate, left(header,125) from archivel where match (header) against ('president bush donald rumsfeld' in boolean mode); == 1979 rows in set (2.39 sec) -- select tdate, left(header,125) from archivel where match (header) against ('+president bush +donald rumsfeld' in boolean mode); == 1979 rows in set (2.39 sec) -- select tdate, left(header,125) from archivel where match (header) against ('+president bush +donald rumsfeld' in boolean mode); == 1979 rows in set (2.39 sec) -- select tdate, left(header,125) from archivel where match (header) against ('(president bush) (donald rumsfeld)' in boolean mode); == 3522 rows in set (2.61 sec) -- select tdate, left(header,125) from archivel where match (header) against ('+(president bush) +(donald rumsfeld)' in boolean mode); == 1979 rows in set (2.52 sec) -- select tdate, left(header,125) from archivel where match (header) against ('+(president bush) -(donald rumsfeld)' in boolean mode); 1979 rows in set (2.53 sec) -- select tdate, left(header,125) from archivel where match (header) against ('-(president bush) +(donald rumsfeld)' in boolean mode); == 1535 rows in set (2.45 sec) -- Thanks, Vadim. Sergei Golubchik wrote: Hi! On May 06, Vadim P. wrote: Hi, It's not quite clear from the manual, but it appears that queries with FULLTEXT search patterns like this: MATCH (some_text_field) AGAINST ('(red pepper) (green bean)') don't produce the result desired, that is, multiple .. elements are not allowed, with or without parentheses... Could you explain, what result is desired and what result you are getting ? Because, right now I can only say that multiple .. elements ARE allowed, of course. On a general note, it would be nice to have the formal syntax of FT search patterns in the manual. I do not understand, what is missing in the manual right now ? There is a list of operators, you can use any of them in whatever combination you want. 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: Merge tables, was [two table's columns into one columns w/oINSERT ... SELECT?]
At 15:29 -0500 5/6/02, Jay Blanchard wrote: I have these two tables; mysql describe tblClass11; +--+---+--+-+-++ | Field| Type | Null | Key | Default | Extra | +--+---+--+-+-++ | ID | int(11) | | PRI | NULL| auto_increment | | RecordID | varchar(6)| YES | | NULL|| | RecordDate | varchar(10) | YES | | NULL|| | CIC | varchar(4)| YES | | NULL|| | Minutes | decimal(12,2) | YES | | NULL|| | FileName | varchar(32) | YES | | NULL|| | RecordNumber | int(11) | YES | | NULL|| | WholeRecord | text | YES | | NULL|| | ReceivedDate | varchar(10) | YES | | NULL|| +--+---+--+-+-++ 9 rows in set (0.00 sec) mysql describe tblClassOthers; +--+---+--+-+-++ | Field| Type | Null | Key | Default | Extra | +--+---+--+-+-++ | ID | int(11) | | PRI | NULL| auto_increment | | RecordID | varchar(6)| YES | | NULL|| | RecordDate | varchar(10) | YES | | NULL|| | CIC | varchar(4)| YES | | NULL|| | Minutes | decimal(12,2) | YES | | NULL|| | FileName | varchar(32) | YES | | NULL|| | RecordNumber | int(11) | YES | | NULL|| | WholeRecord | text | YES | | NULL|| | ReceivedDate | varchar(10) | YES | | NULL|| +--+---+--+-+-++ 9 rows in set (0.00 sec) I attempt to MERGE; mysql CREATE TABLE tblCross1 (ID INT NOT NULL, - RecordID VARCHAR(6), - RecordDate VARCHAR(10), - Minutes DECIMAL(12,2), - KEY(ID)) - TYPE=MERGE - UNION=(tblClass11, tblClassOthers); Query OK, 0 rows affected (0.01 sec) Then I attempt to query;mysql select count(*) from tblCross1; ERROR 1016: Can't open file: 'tblCross1.MRG'. (errno: 143) perror 143 143 = Conflicting table definition between MERGE and mapped table Can anyone help with this? Thanks! Jay Drop the MERGE table, then try creating it with all the columns in the original tables. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Merge tables, was [two table's columns into one columns w/o INSERT ... SELECT?]
[snip] Then I attempt to query;mysql select count(*) from tblCross1; ERROR 1016: Can't open file: 'tblCross1.MRG'. (errno: 143) perror 143 143 = Conflicting table definition between MERGE and mapped table Can anyone help with this? Drop the MERGE table, then try creating it with all the columns in the original tables. [/snip] OK, that work with two of the tables, I have to merge 3. Is that possible? Do the INDEXES have to exist on the same columns in each table? How identical do the tables have to be? Thanks! Jay P.S. Paul, couldn't help but notice your last name, where are you from? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: SOP for hosting services?
Hi, I using Macromedia UltraDev to develop my dynamic web site and would like to use mySQL as the RDBMS. My hosting service folks are telling me that I should only update my database on their server via update transactions. They say this is for security reasons. UltraDev provides many good tools for viewing, adding, updating and deleting records for the database but I'm not sure how to produce add/delete/update transactions from UltraDev and I'm not convinced it is necessary to have the added layer of security. Is this standard operating procedure when making changes to mySQL databases or should I tell them that I want direct access to my database? Any help/suggestions/guidelines in this area would be very helpful. Thanks. Pete - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mac OS X connection error
Hi, I've installed MySQL through the entropy.ch installer. Everything works fine in the command line utillity but when I try to connect a php script i get this error message: Host 'localhost.127.in-addr.arpa' is not allowed to connect to this MySQL server I have tried various times to correc this but can't quite figure out what is causing this. Thanks ahead for any help. Bernardo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Merge tables, was [two table's columns into one columns w/oINSERT ... SELECT?]
At 15:44 -0500 5/6/02, Jay Blanchard wrote: [snip] Then I attempt to query;mysql select count(*) from tblCross1; ERROR 1016: Can't open file: 'tblCross1.MRG'. (errno: 143) perror 143 143 = Conflicting table definition between MERGE and mapped table Can anyone help with this? Drop the MERGE table, then try creating it with all the columns in the original tables. [/snip] OK, that work with two of the tables, I have to merge 3. Is that possible? Yes. Do the INDEXES have to exist on the same columns in each table? How identical do the tables have to be? Identical. Column names, types, order within tables, and indexes. Thanks! Jay P.S. Paul, couldn't help but notice your last name, where are you from? Huh? Wisconsin. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: formatting currency in mysql
SELECT FORMAT(yourvalue,2) - Original Message - From: Graeme B. Davis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 06, 2002 10:16 PM Subject: formatting currency in mysql Does anyone have a quick tip on how to format a float/numeric in the following currency format with a query? $xx,xxx.xx Thanks! Graeme - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Bug or error in SQL syntax - Specifying and using a user variable inside a single select query
Gregg, Monday, May 06, 2002, 6:57:55 PM, you wrote: GG Upon reading into the user variables section of the mysql manual, I decided GG to make my life easier inside several of my queries by specifying some user GG variables. Note that I'm trying to have everything inside the select GG statement - Primarily because I'm simply passing it through to my data GG mining software that interfaces through myODBC. GG I'm trying to accomplish the following query (I'm executing these sql GG queries directly from the command line) -- GG GG SELECT GGannual_filing.*, GGcompanies.name AS company_name, GGYEAR(filing_date) AS filing_year, GG(@predictedYear := 1999) AS predictedYear, GG(@earliestYear := 1996) AS earliestYear, GG(@learnYear := 1998) AS learnYear GG FROM GGannual_filing, GGcompanies GG WHERE GG annual_filing.company_id = companies.ds_id GGAND GG YEAR(filing_date) = @predictedYear GGAND GG YEAR(filing_date) = @earliestYear; GG GG The above query returned an empty set / no rows. You should first initialize user variables! By default they contain NULL values as SELECT works by first checking WHERE clause and only then works for SELECT. Check the manual: http://www.mysql.com/doc/V/a/Variables.html According to the manual from the above link, where it states: == You can set a variable with the SET syntax: SET @variable= { integer expression | real expression | string expression } [,@variable= ...]. You can also assign a value to a variable in statements other than SET. However, in this case the assignment operator is := rather than =, because = is reserved for comparisons in non-SET statements: mysql SELECT @t1:=(@t2:=1)+@t3:=4,@t1,@t2,@t3; +--+--+--+--+ | @t1:=(@t2:=1)+@t3:=4 | @t1 | @t2 | @t3 | +--+--+--+--+ |5 |5 |1 |4 | +--+--+--+--+ == mysql should be SET'ing the user variables in my query above. If mysql is processing the WHERE first and then the SELECT, shouldn't the user variables be set anyhow (even if the query returns an empty set)? For example: == mysql SELECT -annual_filing.*, -companies.name AS company_name, -YEAR(filing_date) AS filing_year, -@predictedYear := 1999 AS predictedYear, -@earliestYear := 1996 AS earliestYear, -@learnYear := 1998 AS learnYear - FROM -annual_filing, -companies - WHERE - annual_filing.company_id = companies.ds_id -AND - YEAR(filing_date) = @predictedYear -AND - YEAR(filing_date) = @earliestYear; Empty set (25.89 sec) mysql SELECT @predictedYear, @earliestYear, @learnYear; ++---++ | @predictedYear | @earliestYear | @learnYear | ++---++ | NULL | NULL | NULL | ++---++ 1 row in set (0.00 sec) == If I execute a separate SELECT statement beforehand (Or SET for that matter) setting the user variables then it works. However, I'm trying to use MyODBC to connect into the server with my data mining software and I can't perform multiple queries in this fashion (it expects me to only send one query). :( Perhaps there's a workaround? === Gregg Graubins [EMAIL PROTECTED] (PGP key available) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: setting up innodb
I am running mysql on solaris. This is a binary release. However, now I would like to start my server with the innodb functionality. But I can't start my server working for this. I am not able to run the ./configure --with-innodb I dont know how and where innodb_data_file_path should be specified I can't open the mysqld file to add the pathtodatafile Where am I suppose to set the variables at the startup(of mysql) Does someone have step by step process in mind that I can follow. Help would be extremely helpful. Regards. --Azhar Khan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Too Many Connections
On Mon, 06 May 2002 12:56:52 -0400 Gurhan Ozen [EMAIL PROTECTED] wrote: Hi, Change the max_connections variable's value to a higher value. By default it is set to 100. You can see what yours is set to with SHOW VARIABLES command. See: http://www.mysql.com/doc/T/o/Too_many_connections.html http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html but you also have to check your Operating System configuration ... usually they have 1024 max connection to same port / socket. -- Let's call it an accidental feature. -- Larry Wall - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
slow queries/ db performance
Under normal operating conditions our v3.23.47 MySql db server handles about 60 queries per second using 50 threads or less. The host is a dual processor 700MHz Intel machine running the 2.2.14-5.0smp Linux kernel with 256M of RAM. Here's the problem: during spikes of activity where about 90-100 queries/sec are being processed, the number of slow queries ties up an ever-increasing number of threads until our max connection limit is reached. This eventually will cause clients to wait for an inactive thread which effectively freezes our application. The slow query SQL statements are optimized - usually they take .5 sec (~10-20K rows being examined), but when the server is in this state execution time ranges from 10-120 seconds. Questions: 1. Are an abundance of slow queries symptomatic of an overloaded DB server? (or are they simply a contributing factor?) 2. Is there a way to examine the state of a slow query besides the slow-query log? I.e. is there a way to tell exactly why a query is running slow? Running explain shows our SQL to be as optimized as it can get. 1. I've read threads in this group about similar server configurations handling 200 queries/sec. What are the most effective ways of benchmarking a server against an application? I've included the MySql setting below. Any help would be greatly appreciated. mysql show variables; +-+- --+ | Variable_name | Value | +-+- --+ | back_log| 50 | | basedir | /opt/mysql-3.23.47/ | | binlog_cache_size | 32768 | | character_set | latin1 | | character_sets | latin1 dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 | | concurrent_insert | ON | | connect_timeout | 5 | | datadir | /opt/mysql-3.23.47/var/ | | delay_key_write | ON | | delayed_insert_limit| 100 | | delayed_insert_timeout | 300 | | delayed_queue_size | 1000 | | flush | OFF | | flush_time | 0 | | have_bdb| NO | | have_gemini | NO | | have_innodb | NO | | have_isam | YES | | have_raid | NO | | have_openssl| NO | | init_file | | | interactive_timeout | 28800 | | join_buffer_size| 131072 | | key_buffer_size | 8388600 | | language| /opt/mysql-3.23.47/share/mysql/english/ | | large_files_support | ON | | locked_in_memory| OFF | | log | OFF | | log_update | OFF | | log_bin | ON | | log_slave_updates | OFF | | log_long_queries| ON | | long_query_time | 10 | | low_priority_updates| OFF | | lower_case_table_names | 0 | | max_allowed_packet | 16776192 | | max_binlog_cache_size | 4294967295 | | max_binlog_size | 1073741824 | | max_connections | 500 | | max_connect_errors | 10 | | max_delayed_threads | 20 | | max_heap_table_size | 16777216 | | max_join_size | 4294967295 | | max_sort_length | 1024 | | max_user_connections| 0 | | max_tmp_tables | 32 | | max_write_lock_count| 4294967295 | | myisam_max_extra_sort_file_size | 256 | | myisam_max_sort_file_size | 2047 | | myisam_recover_options | 0 | | myisam_sort_buffer_size | 8388608 | | net_buffer_length | 16384 | | net_read_timeout| 30 | | net_retry_count | 10 | | net_write_timeout | 60 | | open_files_limit| 0 | | pid_file| /opt/mysql-3.23.47/var/winston.pid | | port| 3306 | | protocol_version| 10 | | record_buffer | 131072 | | record_rnd_buffer | 131072 | | query_buffer_size | 0 | | safe_show_database | OFF | | server_id | 1 | | slave_net_timeout | 3600 | | skip_locking| ON | | skip_networking | OFF | | skip_show_database
Maximum number of rows in the table
Hi MySql gurus, We are using MySql for our database support in our project. It is a multiserver environment. We are using a single table to store info abt objects of each server. We want to know what is the maximum number of rows that the MySql supports for a table. In our case when the number of rows exceeds 1500 the server crashes. Is it the max number of rows ? with regards, Chandrashekar B.N. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php