Problem with complex query
Hi, i'm trying to make a simple message board and I need a bit of help to finish up. Here's my database structure first with some example data: TABLE: mboard mid | topic | name| date 1 New site John Doe 2 Re: New site Susie Q TABLE: mboardindex mbiid | mid | message 1 1 1 2 1 2 mboard holds all the data and mboardindex holds what messages go with what. In this case, mid = message = 1 indicates original message. mid =1, message = 2 indicates reply to message 1. Now, my problem is, i'm doing this in PHP4 and without subselects, i'm not sure how to get the data to list like: New siteJohn Doe Re: New siteSusie Q Here's my query: SELECT * FROM mboard,mboardindex WHERE mboard.mid = mboardindex.mid ORDER BY date Well, this gets me everything with mboard.mid = mboardindex.mid = 1 (in the case above). Well, how do I get it mysql to select from the result of the above SELECT statement. For example, I want to select the mboardindex.message from the above select statement results. Normally, I would use a sub-select but we can't do that in mysql. Can anyone help me out? Thanks, 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
Mysql+web+????
Hi there, I have a mysql-database containing data about production of mobile phones. Inside this database there tables with measurement values for each phone and also about failures in the production. Now I need to create a user-interface: On the one hand I need to display query-results in table-apperance, but on the other hand I need to display the results graphically ( for example: measured values over time, measurement histograms or paretto-diagramms for failures) One way to solve it is writing a client application in vcc or an other progamming tool. But in this case I need to distribute to tool to all users wo wants to use the database. The other way is using a web-based solution. In this case the only needs to now the address of the page. For results in table-apperance their is no problem, but is there a way to generate online graphical diagramms ( measured values over time ) and display them in the browser. I intend to use linux for the server, mysql for the database, php for the web-forms. but what is with the diagramms? They were not pregenerated, they must be generated as a result of the user parameters. Best regards Thorsten Guddack Siemens MobilePhones, TestTechnology --- Thorsten Guddack SIEMENS AG ICM MD MP SCM SCCM PI Information and Communication Mobile - Mobile Devices - Mobile Phones *+49-2842-95-4270 Fax +49-2842-95-4256 Südstraße 9 * [EMAIL PROTECTED] D-47475 Kamp-Lintfort --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 question
I have a slave server and a master server both running 3.23.38. Every once in a while the slave stops updating: mysql show slave status; +--+-+-+---+---+---+---+-+-+++--+ | Master_Host | Master_User | Master_Port | Connect_retry | Log_File | Pos | Slave_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last_error | Skip_counter | +--+-+-+---+---+---+---+-+-+++--+ | db1.tias.com | slave | 3306| 60| spode-bin.005 | 912992502 | No| | | 1158 | Slave: query 'drop table tias.avtemp' partially completed on the master and was aborted. There is a chance that your master is inconsistent at this point. If you are sure that your master is ok, run this query manually on the slave and then restart the slave with SET SQL_SLAVE_SKIP_COUNTER=1; SLAVE START; | 0| +--+-+-+---+---+---+---+-+-+++--+ 1 row in set (0.00 sec) Why is this happening and what can be done to prevent it from happening. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 1054 at line 52: Unknown column 'nan' in 'field list'
On Sun, 2 Sep 2001, Michael Widenius wrote: Hi, Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa =?iso-8859-2?Q?Martin_MOKREJ=A9?= writes: And should say that update rep set low='0.00' where id=148; solved my problem for command: mysqldump -f --socket=/tmp/mysql.sock --add-drop-table --extended-insert --quick --databases Cmuridarum rep | mysql -f --host=pednew -C Cmuridarum ... to be complete. ;) -- Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs MIPS / Institute for Bioinformatics http://mips.gsf.de GSF - National Research Center for Environment and Health Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany Sinisa Yes, I saw this. Still, we should fix it. MySQL should never allow you to insert 'nan' into a column. It would be nice to know how this value was inserted in the first place. Hmm, I did not write this code and can't find it quickly, but hust trying to repeat it works: mysql show columns from rep; +--+---+--+-+-+---+ | Field| Type | Null | Key | Default | Extra | +--+---+--+-+-+---+ | id | mediumint(8) unsigned | | PRI | 0 | | | prot_data_id | mediumint(8) unsigned | | MUL | 0 | | | contig_data_id | mediumint(8) unsigned | | MUL | 0 | | | contig_data_code | varchar(100) | | | | | | code | varchar(100) | | MUL | | | | length | int(11) | | | 0 | | | mw | float(10,2) | | | 0.00| | | pI | float(10,2) | | | 0.00| | | class| varchar(255) | | MUL | | | | mem | int(11) | | | 0 | | | low | float(10,2) | | | 0.00| | | nonglob | float(10,2) | | | 0.00| | | coil | float(10,2) | | | 0.00| | | sigp | int(11) | | | 0 | | | loc | varchar(255) | | MUL | | | | summary | text | YES | | NULL| | | geneid | varchar(255) | | MUL | | | | classification | varchar(255) | | MUL | | | | pubmed | varchar(255) | | MUL | | | | comments | text | YES | | NULL| | | remarks | text | YES | | NULL| | | descr| varchar(255) | | MUL | | | | manual | enum('yes','no') | YES | | NULL| | +--+---+--+-+-+---+ mysql update rep set low='nan' where id=148; Query OK, 1 row affected (0.07 sec) Rows matched: 1 Changed: 1 Warnings: 1 'mysqladmin version' gives: mysqladmin Ver 8.21 Distrib 3.23.41, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.41-log Maybe we should check in application for the warning? How can I see the warning? -Not on terminal, not in server logfile ... -- Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs MIPS / Institute for Bioinformatics http://mips.gsf.de GSF - National Research Center for Environment and Health Ingolstaedter Landstrasse 1, D-85764 Neuherberg, 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
Replication Problem
Dear all, I managed to set up 1-way master-slave replication using MySQL version 3.23.33. The replication process run fine. However I found out that the master-bin.001 sited on master server log file is growing every day. My question is, are there any command that I can put into my.cnf on master or slave to flush the file when everything is replicated into slave. Thank you. Emanduel Chan Tain Por System Engineer DotCom Consulting Sdn Bhd DID : 603-62763230 ext. 112 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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+Web+??
Hi there, I have a mysql-database containing data about production of mobile phones. Inside this database there tables with measurement values for each phone and also about failures in the production. Now I need to create a user-interface: On the one hand I need to display query-results in table-apperance, but on the other hand I need to display the results graphically ( for example: measured values over time, measurement histograms or paretto-diagramms for failures) One way to solve it is writing a client application in vcc or an other progamming tool. But in this case I need to distribute to tool to all users wo wants to use the database. The other way is using a web-based solution. In this case the only needs to now the address of the page. For results in table-apperance their is no problem, but is there a way to generate online graphical diagramms ( measured values over time ) and display them in the browser. I intend to use linux for the server, mysql for the database, php for the web-forms. but what is with the diagramms? They were not pregenerated, they must be generated as a result of the user parameters. Best regards Thorsten Guddack Siemens MobilePhones, TestTechnology - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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+web+????
I intend to use linux for the server, mysql for the database, php for the web-forms. but what is with the diagramms? They were not pregenerated, they must be generated as a result of the user parameters. GD might be able to do what you want.. www.boutell.com/gd uhm.. quite sure :-) mysql, query Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Install error
Using RH 7 after a Plain setup I tried to install the rpm's version 37 through 39 with the same error. Not a valid RPM. I tried both Gnome RPM and the command line with the same results. The tar file gave me Child - Error unrecoverable - exiting now.I moved the files and tried again same results so it's not permisions. I thought mabey my install was corrupte, plus I am bored, and reinstalled RH7, and got the same errors.I never had any issues before on this box with RH7 and MySQL. I tried other RPM's I needed for this LAMP install, PHP , Apache and they installed fine, but I need MySQL installed first so I'll redo them later. Help Mike Benzel [EMAIL PROTECTED] for NT Linux-Palm-CASL Support Cross Platform Messaging and TDataSet Components: TAstaPDADataSets Servers (Win32,Linux,Java) Clients (Win32,Linux,Java,Palm,WinCE,Linux PDA's) ASTA Technology Group http://www.astatech.com ASTAWireless http://www.astawireless.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 3.23.41 fails to install as service on Win 2000 Professional
Perhaps it's his platform of choice. On Sun, 2 Sep 2001, Sinisa Milivojevic wrote: What you are trying to do can be done on NT / W2K only. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL crashing in abria merlin server
Hi, have met a following problem, I have on my Win32 work machine the Abria softs merlin server package but the MySQL part of it keeps failing. You do not have to do a thing and it fails, does not give out data anymore. I have to close both Mysql and Apache for it to work again for a few moments. Does anyone else have similar troubles with it? Jari Mäkelä - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Stored Procedures and Triggers
How many types of triggers MySQL have? And what about stored procedures? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: ERROR 1054 at line 52: Unknown column 'nan' in 'field list'
i can reproduce it on 3.23.32 create table test (id int(13),low float(10,2) ) insert into test values (1,1) insert into test values (1,'nan') id low 1 1.00 1 nan doh.. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Stored Procedures and Triggers of MySQL
How many types of triggers MySQL have? And what about stored procedures? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 1054 at line 52: Unknown column 'nan' in 'field list'
Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa =?iso-8859-2?Q?Martin_MOKREJ=A9?= writes: And should say that update rep set low='0.00' where id=148; solved my problem for command: mysqldump -f --socket=/tmp/mysql.sock --add-drop-table --extended-insert --quick --databases Cmuridarum rep | mysql -f --host=pednew -C Cmuridarum ... to be complete. ;) -- Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs MIPS / Institute for Bioinformatics http://mips.gsf.de GSF - National Research Center for Environment and Health Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany Sinisa Yes, I saw this. Still, we should fix it. MySQL should never allow you to insert 'nan' into a column. It would be nice to know how this value was inserted in the first place. Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
On Redhat 7.1
Does mysql work on rehat 7.1. I have installed it but can not get PHP, JAVA to access the database. I just get connection refused. ANy ideas thanks in advance. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Qs: Time for ALTER, space requirements
On Fri, Aug 31, 2001 at 03:36:14PM -0700, Jeff Leung wrote: [snip] Also, will ALTER TABLE table TYPE=MYISAM create a new temporary table to work with and then essentially insert all the rows into the new copy before removing the old table? It will. (I am well past 50% capacity on the machine, so if so, this operation will probably fail.) Ugh. Not fun. One thing I try to do as a rule is make sure I always have enough free disk space to handle a second copy of my largest table (.MYI and .MYD files) plus a few percent. Otherwise you risk running into problems like this. Finally, how does MySQL handle resizing database files? Is growth linear, or are there specific quanta or thresholds at which the table will grow (for example, maybe the table file size will be doubled if the table file is over 75% utilized)? MyISAM files only grow when they need more room, and they only grow enough to hold new data you're trying to insert. So it's linear. There are a few bytes of overhead here and there, but that's not going to be significant. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 3 days, processed 33,362,507 queries (111/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Stored Procedures and Triggers
On Mon, Sep 03, 2001 at 04:23:23PM +0800, Kimman Lui wrote: How many types of triggers MySQL have? And what about stored procedures? Zero and Zero, as explained in the docs. If you need them today, I'd suggest looking at PostgreSQL. If you're patient, they'll likely appear in MySQL someday--I believe both are on the TODO list. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 3 days, processed 33,335,761 queries (111/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: BDB or InnoDB ?
On Sat, Sep 01, 2001 at 11:42:52AM -0400, Jocelyn Bernier wrote: Hi everybody, I am currently looking the transactional part of MySQL and I'm wandering which one is best to use in regard to efficiency and reliability. Which one is the most stable, etc? While I have some of experience with InnoDB and very little experience with BDB tables, here's my take on the situation... BDB tables were/are a nice stepping stone for MySQL. They were the first transactional table type. People who needed transactions (or more fine-grained locking) use BDB, but a lot of folks were still waiting for something like the more traditional systems (Oracle, Sybase, SQL Server, etc). BDB tables do have a few odd qualities. InnoDB performs very well but is newer. It seems to be quite stable if you're not using BLOBs. However, I expect InnoDB to easily surpass BDB in popularity, developer support, and features. For all I know, it already has. I see InnoDB as being one of the more viable MySQL table types for the long-term. You can probably build your application on BDB tables today and be just fine. You can probably build your application on InnoDB today and be just fine if you take backups and keep up to date with MySQL as any InnoDB are fixed. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 3 days, processed 33,371,656 queries (110/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: On Redhat 7.1
7.1 doesn't install php with mysql support enabled. You'll need to install the source rpm, edit the php.spec file and do a rpm -bb php.spec and install the resulting rpms. FYI, redhat is doing this because postgres is no their prefered DBMS. Can't understand why they don't just compile support for both in. --Tony On Sun, 2 Sep 2001, Kalpesh Modha wrote: Does mysql work on rehat 7.1. I have installed it but can not get PHP, JAVA to access the database. I just get connection refused. ANy ideas thanks in advance. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Install error
you using 7.0 or 7.1. If 7.0 try grabbing the rpms from the 7.1 image and see if that works. --Tony On Sun, 2 Sep 2001, Mike wrote: Using RH 7 after a Plain setup I tried to install the rpm's version 37 through 39 with the same error. Not a valid RPM. I tried both Gnome RPM and the command line with the same results. The tar file gave me Child - Error unrecoverable - exiting now.I moved the files and tried again same results so it's not permisions. I thought mabey my install was corrupte, plus I am bored, and reinstalled RH7, and got the same errors.I never had any issues before on this box with RH7 and MySQL. I tried other RPM's I needed for this LAMP install, PHP , Apache and they installed fine, but I need MySQL installed first so I'll redo them later. Help Mike Benzel [EMAIL PROTECTED] for NT Linux-Palm-CASL Support Cross Platform Messaging and TDataSet Components: TAstaPDADataSets Servers (Win32,Linux,Java) Clients (Win32,Linux,Java,Palm,WinCE,Linux PDA's) ASTA Technology Group http://www.astatech.com ASTAWireless http://www.astawireless.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: On Redhat 7.1
Kalpesh Modha writes: I have installed it but can not get PHP, JAVA to access the database. I just get connection refused. Are you trying to connect via TCP to a server started with --skip-networking? Are you connecting to the right port? Does it work when you use unix sockets instead of TCP/IP? Can you connect using the command line client (mysql)? That's all I can think of. :-o //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 me , about mysql replicate!
On Fri, Aug 31, 2001 at 05:44:11PM +0800, Wang Aocheng wrote: Dear All, I have a question: How can build multi-master-host? I have 3 mysql hosts,I want to use mysql data replicate. thanks! And you want all 3 to be masters? If so, you need to configure them in a replication triangle where the master/slave relationship looks like this, where X --Y means Y is a slave of X A -- B -- C -- A Or, easier to visualize in my poor ASCII art: A / ^ / \ v \ B C That should do what you're looking for. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 3 days, processed 33,382,375 queries (110/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
load access-mysql
I have a very large database which was made using Access2000. Because of the difficulty Access has in manipulating the database due to its scale I want to move the database to MySQL. However, because of the size of the database I don't want to spend hours doing it by hand so I want to use LOAD DATA or something similar but what I want to know is - can you use this function, or a similar one, to load a database from access2000 to MySQL, and is there anything I need to be aware of if this is possible? Thanks, Neil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL vs SQL Server
Hi Actually, MySQL is new to me. But I am familiar with SQL Server. Can anyone tell me the difference? It seems to me that they support different interfaces? Regards - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Determine Percentages
Hi, How can I construct a query that would give me a percentage, eg - I would like to replace the hardcoded integer value 1234567, with a calculated SUM figure. The integer 1234567 is the SUM of all the Packets in the whole table. SELECT SrcIp, SUM(Packets), SUM(Packets)/1234567*100 AS Percentage FROM tblIp GROUP BY SrcIp; Chris Andrew Oxspring Network Solutions Limited Tel: +44 (0)1226 761188 Fax: +44 (0)1226 761199 Email: [EMAIL PROTECTED] Web: www.oxspring.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 : Create Index Speed
Thanks to everyone who replied - much appreciated. Ok here is how it went : 1 Creating index first and loading table :saved 1 minute overall 2 Increasing key_buffer - 100M :no difference 3 increasing myisam_max_sort_file_size- 1000M and myisam_sort_buffer_size-100M :no difference Note that the index concerned is about 80M (table about 300M ) so looks like that is as fast as it goes ( and pre-creating in index helps a little bit ) regards Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: BDB questions
On Tue, Aug 28, 2001 at 11:39:54AM -0700, Sheena Sidhu wrote: I had 2 questions related to using BDB and mysql. I don't see any startup options for BDB, so can I safely assume that there are'nt any , so don't need a my.cnf file? There are several. Look in the docs here: http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 3 days, processed 33,423,084 queries (110/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
Zur Information für Lerher der Sozialkunde, Religion, Geographie usw.:
Sehr geehrte Damen und Herren, Zur Information für Lehrer der Sozialkunde, Religion, Geographie usw.: ein neuer Documentarfilm über die Philippinen Good Morning, Sir! der beispielhaft auch für die Lage in anderen Entwicklungsländern steht. Detaillierte Informationen auf der Webseite http://www.karelcorthals.be Für Schulen, Lehrkörper und Bibliotheken wird der Film (62 min.) zusammen mit einer KOSTENLOSEN Unterrichtseinheit angeboten zum Selbstkostenpreis von 15 Euro (Europa) oder 14 USD (auber Europa) (Verzandkosten inklusive und Bezahlen nach Lieferung !) Mit freundlichen Grüssen, Karel Corthals This is a once-only mail but if you would like to be taken out of our database, click [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
Can one use more than one character set with one server instance?
Hello helpful list! For one of our customers we have to store russian and german text in a database. Is is somehow possible to do this with one server instance or do I have to split the data to be stored in two databases on two server instances? Thanks you very much, Goeran Zaengerlein - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 3.23.41 fails to install as service on Win 2000 Professional
Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa Jari Aalto writes: I'm using Ver 3.23.41-max-debug for Win95/Win98 on i32 And command mysqld-nt --install Displays error dialog box Failed to install service In Event viewer the messages simply says: The MySql service terminated unexpectedly. It has done this 1 time(s). The following corrective action will be taken in 0 milliseconds: No action. How Can I help to debug this further? I'm always logged in as Administrator, and W2k inlcudes service pack 2. Jari What messages did you get in the C:\mysql\mysql.err file ? The MySQL windows installation section in the manual contains a lot of suggestion of what you can do to find out what went wrong. I would appreciate if you could spend some time figuring out this so that we can improve the MySQL installation / documentation regarding this. Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: REPLACE or UPDATE/INSERT ?
On Mon, Aug 20, 2001 at 11:00:59AM +0200, Stephan wrote: Hi all, my situation: I generate 300 rows at a time - they should be stored in the a mysql table. 99 % of the keys of these rows already exist in the table, so these rows need an update. The remaining 1 % have to be inserted in the table. I was wondering if it is a good idea to to this with 300 UPDATE statements and if one of them fails do an INSERT. Or if it's recommendable to use a single REPLACE statement. My problem with the REPLACE is that the documentation says that a REPLACE always does an DELETE and then an INSERT. In my case a lot of rows (99%) would be deleted in the index that only need an update. Is it a good idea to do that much index manipulations that aren't necessary? Hmm. Are you asking for performance reasons or just because one is easier to code than the other? It shouldn't be hard to benchmark both options. I'd be curious to hear what you find. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 3 days, processed 33,485,487 queries (110/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Determine Percentages
Chris Andrew writes: I would like to replace the hardcoded integer value 1234567, with a calculated SUM figure. SELECT SrcIp, SUM(Packets), SUM(Packets)/1234567*100 AS Percentage FROM tblIp GROUP BY SrcIp; Either divide it into two queries and use the result of the first when constructing the second, or (if you're just doing raw SQL instead of using some script language) do it to a temporary table which just contains the sum of all Packets. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 question
On Sun, Sep 02, 2001 at 11:40:08AM -0700, Mike Wexler wrote: I have a slave server and a master server both running 3.23.38. Every once in a while the slave stops updating: | db1.tias.com | slave | 3306| 60| spode-bin.005 | 912992502 | No| | | 1158 | Slave: query 'drop table tias.avtemp' partially completed on the master and was aborted. There is a chance that your master is inconsistent at this point. If you are sure that your master is ok, run this query manually on the slave and then restart the slave with SET SQL_SLAVE_SKIP_COUNTER=1; SLAVE START; | 0| [snip] Why is this happening and what can be done to prevent it from happening. Hard to say. Was there actually a problem on the master? Did the slave work fine once you set the skip counter? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 3 days, processed 33,533,446 queries (109/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Is replication inteligent enough for ..... ?
On Fri, Aug 31, 2001 at 11:53:04AM +0200, Warren van der Merwe wrote: I have a triangluar replication system working 100%, A -- B, B -- C, C -- A. What I know want to know is, is replication intelligent enough that if A had to sometimes connect to C, and replicate, and then the next day connect to B again, and so on and so on, would everything still work, or would disaster strike? Sometimes I may want to get urgent info through to C, so instead of dialling into B, and then B dialling into C, I want to Dial C directly from A, but when the daily connection takes place, A will be connecting to B again, etc etc ect Hmm... Are you planning to run a CHANGE MASTER... command on the slave (A) each time? If so, it ought to work if you're careful with making sure that the binary log position number is correct. I assume that the binary logs will be identical in size on all hosts, but haven't personally verified that. It should be pretty easy to test, however. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 3 days, processed 33,496,896 queries (109/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication Problem
On Mon, Sep 03, 2001 at 10:44:57AM +0800, tpchan wrote: Dear all, I managed to set up 1-way master-slave replication using MySQL version 3.23.33. The replication process run fine. However I found out that the master-bin.001 sited on master server log file is growing every day. My question is, are there any command that I can put into my.cnf on master or slave to flush the file when everything is replicated into slave. There is not, because the master doesn't know who all the possible slaves may be. You might script something yourself. Look into the commands here: http://www.mysql.com/doc/R/e/Replication_SQL.html Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 3 days, processed 33,536,473 queries (109/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication problems involving time
On Wed, Aug 29, 2001 at 12:18:02PM -0400, Michael Eklund wrote: Am I the only one that thinks that mysql ought to replicate NOW, CURRENT_DATE, etc. as the time when those actual inserts happened not as NOW,CURRENT_DATE,etc. Probably not. If you are replicating accross a distance (12,15,20 hops) and there is a connectivity problem, then you end up with data that is out of sync. Very true. Also my master.info ends up being wrong whenever the server is rebooted. (binlog.100 becomes binlog.100\n). Can you expand on that problem a bit? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 3 days, processed 33,538,278 queries (109/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
Query help needed
Hi. I'm thinking about a possible database schema for a content management system that is supposed to use MySQL as a backend. The system stores multiple versions for each piece of content. Content is referenced by a content-id (cid), each version gets a version-id (vid). Each version has some meta-data, in the following example only one field meta_example. I want to filter by this metadata. Also, each version is only live (available online) for a given period of time. If multiple versions of one piece of content are live at the same time, the latest one should be used (the one with the higher live_from value). I have created a table called versions: vid int auto_increment # the version-id cid int# the content-id live_from date # when this version goes live live_to date # when this version becomes obsolete meta_example bool # meta-data about this version. Consider the following table-content, where is_live means that live_fromnow() and live_tonow() vid cid is_live meta_example 1 1 TRUE TRUE 2 1 FALSE FALSE Then select * from versions where cid=1 and live_fromnow() and live_tonow() order by live_from desc limit 1; gives me the current version of the content-piece 1, if there is any. *** But the problem is listing all content-pieces, that match a given meta-tag in their current version. I want to do a: select * from versions where meta_example=TRUE and version is the current version of the file *** Or even easier: to list all content-pieces, that are currently live select * from versions where version is the current version of the file But I simply can't find a (good) query without using a subselect. The problem is that I have to check, wheter the live_from value ist the maximum for all the versions of this content-piece. Joining the table with itself doesn't seem to bring me nearer to a solution. :-( I could solve the second problem using the group-and-concatenate-the-interesting-pieces trick, but that is too slow. Can anyone help me out? bye, Paul. -- Paul Mallach ARIVA.DE AG Ostseekai 2 D - 24103 Kiel Tel.: +(49) 0431/97108-24E-Mail: [EMAIL PROTECTED] Fax: +(49) 0431/97108-29 Internet: www.ariva.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Solaris 2.6 /mysql-3.23.41 compile problems
On Fri, Aug 31, 2001 at 10:10:52PM -0700, Jeff Dickison wrote: I am trying to get mysql-3.23.41 to compile under Solaris 2.6 sparc with gcc 2.95.2 and have been running into some problems. Currently I am using this as my comfigure : ./configure --prefix=/usr/local/mysql \ --with-client-ldflags='-R /usr/local/lib'\ --enable-thread-safe-client \ --with-gnu-ld \ --with-low-memory It gives me this error after a bit of compiling: /usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.95.2/libgcc.a: could not read symbols: Bad value collect2: ld returned 1 exit status My version of ld is 2.9 (with BFD 2.9). Has anyone been able to get this to work? I just ran that on an old Solaris 2.6 machine (took a couple hours to run). Everything built fine. You can grab the tarball from here: http://jeremy.zawodny.com/mysql/misc/mysql-3.23.41-sol-2.6.tar.bz2 If you'd like to try the one I built. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 3 days, processed 33,564,785 queries (109/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 1054 at line 52: Unknown column 'nan' in 'field list'
Hi! mmokrejs == mmokrejs iso-8859-2 writes: cut mysql update rep set low='nan' where id=148; mmokrejs Query OK, 1 row affected (0.07 sec) mmokrejs Rows matched: 1 Changed: 1 Warnings: 1 The above will just set '0' in the 'low' column. (The string 'nan' converted to a number is 0) You can verify this by doing a select on the above table. 'nan' is a special float value which stands for 'not a number'. You should not be able to store this into a float column in MySQL. Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: REPLACE or UPDATE/INSERT ?
Hi Mysql, E-Mail vom Montag, 3. September 2001, 12:14:42: Hi Jeremy, E-Mail vom Montag, 3. September 2001, 11:52:55: My problem with the REPLACE is that the documentation says that a REPLACE always does an DELETE and then an INSERT. In my case a lot of rows (99%) would be deleted in the index that only need an update. Is it a good idea to do that much index manipulations that aren't necessary? Hmm. Are you asking for performance reasons or just because one is easier to code than the other? I'm just afraid that the system get's damages Index-files when I do that much unnecessary index-updates. At the moment we get about one damaged file in 2 months (isamcheck). But this replace operation will increase index-manipulation dramatically. It shouldn't be hard to benchmark both options. I'd be curious to hear what you find. Haven't done it yet ... Ciao, Stephan -- sql table - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication problem
On Thu, Aug 16, 2001 at 08:56:33PM -0700, Lists Servers Email wrote: Does any know how to fix this database replication problem. Last Lines from Err File 010815 21:38:55 Slave thread exiting, replication stopped in log 'salem-bin.013' at position 6867 010815 21:38:55 Error running query, slave aborted. Fix the problem, and re-start the slave thread with mysqladmin start-slave. We stopped at log 'salem-bin.013' position 6867 010815 21:38:55 Slave: error running query 'UPDATE themes SET textcolor='#0a' WHERE theme_id = 2 AND theme_name = 'Ocean' AND bgcolor = '#FF' AND textcolor = '#00' AND color1 = '#CC' AND color2 = '#9BB6DA' AND table_bgcolor = '#00' AND header_image = 'images/toxicmold1.gif' AND newtopic_image = 'images/new topic.gif' AND reply_image = 'images/reply.gif' AND linkcolor = '#011001' AND vlinkcolor = '#2100cc' AND theme_default = 0 AND fontface = 'sans-serif' AND fontsize1 = '1' AND fontsize2 = '2' AND fontsize3 = '-2' AND fontsize4 = '+1' AND tablewidth = '95%' AND replylocked_image = 'images/reply_locked-dark.jpg'' ERROR: 1146 Table 'mold_db.themes' doesn't exist Make sure that all the tables and databases which should be replicated actually exist on the slave? How did you setup your inital replication? Perhaps you can use mysqlsnapshot http://jeremy.zawodny.com/mysql/mysqlsnapshot/ to reset things and be sure that it's correct? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 3 days, processed 34,014,583 queries (109/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: On Redhat 7.1
Sure it does, what version, what error? brett Kalpesh Modha wrote: Does mysql work on rehat 7.1. I have installed it but can not get PHP, JAVA to access the database. I just get connection refused. ANy ideas thanks in advance. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- UNIX Ad/DBA/Teaboy/Analyst/Gopher - Intratex Holdings - Pinetown Tel. +27 31 717 4000/4146 Fax. +27 31 717 4001 Rule 1. Before calling me... if its a Windows box... REBOOT IT! Rule 2. If its a Windows box... Don't call me... Rule 3. Windows isn't much good for anything aside from games. Rule 4. Repeat. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Query Question
[EMAIL PROTECTED] writes: [SNIP] Isn't it annoying when it refuses to send your mails to the list and then lets through a ton of spam? Mysql mysql mysql. There. :-E Carl Schrader writes: select Title from inv where Title LIKE '%TOMMY%' OR Content LIKE '%TOMMY%' OR Notes LIKE '%TOMMY%' order by Title What I need is to have the results that match Title LIKE '%TOMMY%' to appear first and then the rest. ORDER BY !LOCATE('tommy',Title), Title should be enough -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Using SELECT * without full field select permissions
I'm trying to avoid the Access Denied messages when using SELECT * FROM table when only a subset of fields are accessible. What I'm looking for is a transparent check of the permissions, replacing * with a list of fields for the associated table. Alternatively, at the layer below SHOW COLUMNS so the user also doesn't *see* the hidden fields, and hence SELECT inherits this behavious also because it won't security-check fields it doesn't know about. While I don't mind adding individual fields to a query for small tables, it can be time consuming. I think it could be a useful feature in MySQL. Any comments? Regards, Richard Lake. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MyODBC, DBUG and multi-threaded clients
I realise that this issue is very specialised, and I'm not sure which mailing list would be best to host a thread based on it, so I'm posting it here to start with: I'm happy to move it to another mysql list if someone would like to suggest one. Over the last year, I've been working on a multi-threaded application (based on OpenLDAP) which queries MySQL via libiodbc and MyODBC (issuing many searches and updates in parallel.) It had been running well and stably, 24 hours a day, for over six months. Then, because of a security vulnerability, I upgraded to the latest version of OpenLDAP, and suddenly the application would not run for more than about three minutes without segfaulting. I've been working on this problem for about three weeks, and I believe I've sorted it: if I'm right, there may be some general implications for MyODBC. My main debugging tool has been mpatrol, a superb and highly-recommended memory-debugging kit. Using this, (aided by coredump examinations in gdb), I found that the segfaults were being caused by attempts to access nonexistent memory: the sources were a number of MyODBC functions (the exact one changed with each test run): the common feature was that in each case, the final address in the mpatrol log traceback pointed to a DBUG_xxx macro (usually DBUG_RETURN). At first, I didn't believe this: then, in an attempt to get more information, I incorporated a patch into the Linux kernel to generate a coredump from the thread which had received the signal (rather than from the application's master thread): the resulting coredump backtraces again pointed to MyODBC source lines containing DBUG macros. I rebuilt mysql without debugging support, then the ODBC libraries and the application. Problem still as above. MyODBC doesn't have a --without-debug option in its configure script (I assume this is because debugging can be activated/deactivated using the debug option in the odbc.ini file.) I therefore went through all the MyODBC code, commenting out all references to the DBUG macros (replacing DBUG_RETURN and DBUG_VOID_RETURN with normal return statements.) I then rebuilt MyODBC and the application. I believe that this gave a result. The application has now been running under full load without segfaulting for over three hours. (That's more than 2h 55m longer than at any time in the last two months. Obviously, it will need to run for a lot longer before I fully trust it again, but I would say that, even at this stage, I'm better than 95% convinced that I've found and eliminated the problem.) Occasionally, within MyODBC, I've seen DBUG_RETURN statements which call MyODBC functions: my best guess at present is that the complex dynamic memory operations going on within these functions is somehow conflicting with DBUG's own dynamic memory management. (I noticed that at the end of the original DBUG manual (mysql-x.xx.xx/dbug/user.r) there is a warning: Programs which use memory allocation functions other than malloc will usually have problems using the standard dbug package. The most common problem is multiply allocated memory.) Has anyone else experienced similar problems with other multi-threaded applications? I guess that two possible ways forward would be either (a) introduce a configure option in MyODBC to totally exclude all the debugging code (as in mysql) - I intend to try this myself; and/or (b) rewrite DBUG's memory allocation to use the facilities in safemalloc. Versions: Linux: Redhat 6.2, kernel 2.2.16-3 (using Terje Malmedal's coredump patch from http://www.movement.uklinux.net - there are a number of patches addressing the threaded coredump issue, but this one was specific for my kernel and it sure as hell did the business 8)) OpenLDAP: originally 2.0.7, then 2.0.11. mysql: 3.23.38 MyODBC: 2.50.33 libiodbc: 3.0.5 mpatrol: 1.4.5 (http://www.cbmamiga.demon.co.uk/mpatrol) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
HELP getting table headings into an OUTFILE
Hi, I am using the INTO OUTFILE 'filename' function, to create .CSV output files from my queries. Whenever I do this, the table headings are removed from the output. Is there a way to get the table headings displayed in the output file? Andrew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
reach the hard limits!?
Hello MySql, I'm dealing with a large (think so) production mysql server. There are up to ~2500 small databases (each ~1-4 MB Data in 10 Tables). The system is growing and the CPU gets more and more loaded. A new behaviour is that apache get sometimes out of clients, caused by bad response times from the mysql server. At the moment the system is running on one machine, however the concept is scalable. I have no feeling/experience where are the limits with mysql. When I have to setup the next db-server? Are ~300 queries per sec. a joke for mysql? It's difficult to valuate if I'm going towards the hard limit or if I have a problem with my db design. Are there people who can share there knowledge about large mysql servers? Linux 2.4.4 SMP 2x PIII 800 512 MB RAM 80 GB EasyRaid System. Lev. 5 (~130 MB sec) average of ~ 330 queries per second. Regards, Oliver Krapp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Starting value for an auto increment column?
Hello: Is there a way to specify a starting value for an auto increment column? I tried this: id INTEGER DEFAULT 1001 PRIMARY KEY AUTO_INCREMENT But, that did not work. Thanks, Neil. -- Neil Aggarwal JAMM Consulting, Inc.(972) 612-6056, http://www.JAMMConsulting.com Custom Internet DevelopmentWebsites, Ecommerce, Java, databases - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Starting value for an auto increment column?
You could make the table, then insert a row with the 1000 as the id, and delete it after you get some other rows in there. rather messy, but it works. James - On Mon, 3 Sep 2001 09:14:46 -0500, Neil wrote: - Hello: Is there a way to specify a starting value for an auto increment column? I tried this: idINTEGER DEFAULT 1001 PRIMARY KEY AUTO_INCREMENT But, that did not work. Thanks, Neil. -- Neil Aggarwal JAMM Consulting, Inc.(972) 612-6056, http://www.JAMMConsulting.com Custom Internet DevelopmentWebsites, Ecommerce, Java, databases - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Starting value for an auto increment column?
Is there a way to specify a starting value for an auto increment column? Take a look at the CREATE TABLE syntax. Peter -- +--- | Data Architect | your data; how you want it | http://www.codebydesign.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: MyODBC, DBUG and multi-threaded clients
Peter Duffy writes: Versions: Linux: Redhat 6.2, kernel 2.2.16-3 (using Terje Malmedal's coredump patch from http://www.movement.uklinux.net - there are a number of patches addressing the threaded coredump issue, but this one was specific for my kernel and it sure as hell did the business 8)) OpenLDAP: originally 2.0.7, then 2.0.11. mysql: 3.23.38 MyODBC: 2.50.33 libiodbc: 3.0.5 mpatrol: 1.4.5 (http://www.cbmamiga.demon.co.uk/mpatrol) Hi! As an example, mysql server is a multi-threaded program and when compile --with-debug it uses DBUG function. There are literally thousands and thousands of locations where mysql server built for debugging is running, without a single problem being caused by those routines. Furthermore, these routines have not been changed for years and have been thoroughly checked with Purify and Pure Coverage which are much better tools then mpatrol. I have my own reservations regarding mpatrol and dmalloc. None of them, for example, worked with my C++ programs. They just crashed/ refused to work. I have tried latest versions and wrote to the authors. That was more then one year ago. It is possible that meanwhile this situation has been fixed. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
reach the hard limits!? (fwd)
Damned, I forgot to change the To: address again. Sorry 'bout that. BTW, does anyone else get lots of error messages from [EMAIL PROTECTED]? Oliver Krapp - etracker.de e.K. writes: I'm dealing with a large (think so) production mysql server. There are up to ~2500 small databases (each ~1-4 MB Data in 10 Tables). The system is growing and the CPU gets more and more loaded. Eek, 2500 databases? As in 2500 directories in one directory? Does the file system handle that well? I have little experience with ext2, but I've seen other file systems turning into molasses before 1000 files per dir. OTOH, with the traditionally messy unix layout the FS had better be used to things like that. At the moment the system is running on one machine, however the concept is scalable. I have no feeling/experience where are the limits with mysql. When I have to setup the next db-server? Are ~300 queries per sec. a joke for mysql? It's difficult to valuate if I'm going towards the hard limit or if I have a problem with my db design. The figures I've seen suggest that 300 q/s isn't all that much for a system like yours, but I guess it depends on the queries. I can imagine there being a horrible number of openings and closings of files if you have 25000 tables, and that can't be good for performance. Are there people who can share there knowledge about large mysql servers? Sorry, very little experience as of now. Once I get the system I'm working on running I might get some experience of hitting the 2GB barrier. :-o //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
images
I was wondering if it's possible to place image files within mysql 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: On Redhat 7.1
Kalpesh Modha [EMAIL PROTECTED] writes: Does mysql work on rehat 7.1. I have installed it but can not get PHP, JAVA to access the database. I just get connection refused. You need to install the php-mysql package, which contains the module PHP needs to support MySQL. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: On Redhat 7.1
Tony Bibbs [EMAIL PROTECTED] writes: 7.1 doesn't install php with mysql support enabled. Yes, we did. FYI, redhat is doing this because postgres is no their prefered DBMS. Can't understand why they don't just compile support for both in. We do compile in support for MySQL, but it's in the php-mysql package - just as at support for PostgreSQL is in php-pgsql. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: reach the hard limits!? (fwd)
I'm not sure if this will help, but have you considered ext3, or any of those experimental file systems (although I believe they are pretty darn stable, I know several places that use ext3). I haven't read much of the specs on ext3, but by chance it might support huge directories like that. - On Mon, 03 Sep 2001 15:21:03 GMT, Carl wrote: - Damned, I forgot to change the To: address again. Sorry 'bout that. BTW, does anyone else get lots of error messages from [EMAIL PROTECTED]? Oliver Krapp - etracker.de e.K. writes: I'm dealing with a large (think so) production mysql server. There are up to ~2500 small databases (each ~1-4 MB Data in 10 Tables). The system is growing and the CPU gets more and more loaded. Eek, 2500 databases? As in 2500 directories in one directory? Does the file system handle that well? I have little experience with ext2, but I've seen other file systems turning into molasses before 1000 files per dir. OTOH, with the traditionally messy unix layout the FS had better be used to things like that. At the moment the system is running on one machine, however the concept is scalable. I have no feeling/experience where are the limits with mysql. When I have to setup the next db-server? Are ~300 queries per sec. a joke for mysql? It's difficult to valuate if I'm going towards the hard limit or if I have a problem with my db design. The figures I've seen suggest that 300 q/s isn't all that much for a system like yours, but I guess it depends on the queries. I can imagine there being a horrible number of openings and closings of files if you have 25000 tables, and that can't be good for performance. Are there people who can share there knowledge about large mysql servers? Sorry, very little experience as of now. Once I get the system I'm working on running I might get some experience of hitting the 2GB barrier. :-o //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: images
From: Neil Davies [mailto:[EMAIL PROTECTED]] I was wondering if it's possible to place image files within mysql tables? http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_15_0 / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: images
yes but not advisable. Check the archives for more info. Cal http://www.calevans.com -Original Message- From: Neil Davies [mailto:[EMAIL PROTECTED]] Sent: Monday, September 03, 2001 10:28 AM To: [EMAIL PROTECTED] Subject: images I was wondering if it's possible to place image files within mysql 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MyODBC, DBUG and multi-threaded clients
Hi Sinisa, Sinisa Milivojevic wrote: As an example, mysql server is a multi-threaded program and when compile --with-debug it uses DBUG function. I know. As I said, one of my main problems is that MyODBC does not have a --without-debug option. There are literally thousands and thousands of locations where mysql server built for debugging is running, without a single problem being caused by those routines. Do you know of any which are specifically accessed by multi-threaded client applications via ODBC? (If so, I'd really like to know, so that I can try to get hold of copies of the client applications to test in my own environment.) Furthermore, these routines have not been changed for years and have been thoroughly checked with Purify and Pure Coverage which are much better tools then mpatrol. I don't doubt that the routines have been thoroughly checked. However, I am talking about specific problems and specific observations in my own work. The application coredumped; the backtraces (persistently) pointed me at the DBUG_ calls in MyODBC; I commented-out the calls; the situation vastly improved. If you could suggest an alternative explanation and approach, I'd be happy to hear it. I have my own reservations regarding mpatrol and dmalloc. None of them, for example, worked with my C++ programs. They just crashed/ refused to work. I have tried latest versions and wrote to the authors. That was more then one year ago. It is possible that meanwhile this situation has been fixed. I'm sorry about your experiences with mpatrol. As I've said, I find it superb: it has already been of enormous assistance in fixing memory leaks, and in the current situation it gave me information that I could not have gained otherwise. Also, I've always found the author of mpatrol to be highly responsive and helpful. I have not used dmalloc. Best regards, Peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 question
Jeremy Zawodny wrote: On Sun, Sep 02, 2001 at 11:40:08AM -0700, Mike Wexler wrote: I have a slave server and a master server both running 3.23.38. Every once in a while the slave stops updating: | db1.tias.com | slave | 3306| 60| spode-bin.005 | 912992502 | No| | | 1158 | Slave: query 'drop table tias.avtemp' partially completed on the master and was aborted. There is a chance that your master is inconsistent at this point. If you are sure that your master is ok, run this query manually on the slave and then restart the slave with SET SQL_SLAVE_SKIP_COUNTER=1; SLAVE START; | 0| [snip] Why is this happening and what can be done to prevent it from happening. Hard to say. Was there actually a problem on the master? Not that I know of. Did the slave work fine once you set the skip counter? In this case yes. At least for a while but inevitably this either happens again. Or I get an error that insert or drop operations are being applied to a (temporary) table that doesn't exist. The latter error usuallly occurs at the beginning of a binlog and usually occurs multiple times. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 3 days, processed 33,533,446 queries (109/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: On Redhat 7.1
Thanks for clearing that up with me...didn't know that. --Tony On 3 Sep 2001, Trond Eivind Glomsrød wrote: Tony Bibbs [EMAIL PROTECTED] writes: 7.1 doesn't install php with mysql support enabled. Yes, we did. FYI, redhat is doing this because postgres is no their prefered DBMS. Can't understand why they don't just compile support for both in. We do compile in support for MySQL, but it's in the php-mysql package - just as at support for PostgreSQL is in php-pgsql. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 22 from isamchk and myisamchk
I have an incorrect key file with mySQL politely suggesting I should repair it. However, when I call isamchk I always get the message isamchk: error: 22 when opening ISAM-table 'table name' on this particular computer (RedHat 7.1), no matter which db I try to inspect or repair. If I move the db files to another computer (RedHat 6.2) isamchk doesn't complain but finds and repairs some errors. What is error 22 (Invalid argument?!) and how do I get around it? Sven M. Sorensen University of Southern Denmark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 when opening mysqld.exe
I get this every time I try to start up MySQLD.exe:: Can't initialize InnoDB as 'innodb_data_file_path' is not set Someone help. Thnx! - Deryck H - http://www.comp-u-exchange.com = I love the Screen Savers __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.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
Error when opening mysqld.exe
I get this every time I try to start up MySQLD.exe:: Can't initialize InnoDB as 'innodb_data_file_path' is not set Someone help. Thnx! - Deryck H - http://www.comp-u-exchange.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error when opening mysqld.exe
At 12:25 03/09/2001 -0500, Deryck Henson wrote: Hi! I get this every time I try to start up MySQLD.exe:: Can't initialize InnoDB as 'innodb_data_file_path' is not set This message is from InnoDB table. If you don't want the InnoDB table, create the /windir/my.ini with the section and key below: [mysqld] skip-innodb Otherwise if you want the InnoDB table, take a look in the Manual how to set the InnoDB variables in the my.ini file before the start. Regards, Miguel Someone help. Thnx! - Deryck H - http://www.comp-u-exchange.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 -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ 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
I got mysqld.exe, now what?
After doing that, I try to connect via DSN via ASP but I get this error:: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [TCX][MyODBC]Can't connect to MySQL server on 24.254.141.32(10061) If someone can help, please do. - Deryck H - http://www.comp-u-exchange.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: Maximum number of keys
Hello. On Wed, Aug 29, 2001 at 12:01:07PM +0200, [EMAIL PROTECTED] wrote: Sorry to repost my question but I did not get any answer. 20 hours is hardly a period of time after which you should assume your message has slipped through. Please avoid early reposting. The list already gets a lot of mail. What is the maximum number of keys for a MyISAM table (without rebuilding mysqld from source), 16 as specified in error message or 32 as in doc. ? I am not able to reproduce the problem: mysql create table t10 (a int, b int, c int, d int, key(a), key(b), key(c), key(d), key(a,b), key(a,c), key(a,d), key(b,a), key(b,c), key(b,d), key(c,a), key(c,b), key(c,d), key(d,a), key(d,b), key(d,c), key(a,b,c), key(a,b,d), key(a,c,b), key(a,c,d)); Query OK, 0 rows affected (0.01 sec) mysql select version(); +-+ | version() | +-+ | 3.23.40-log | +-+ 1 row in set (0.01 sec) [...] According to MySQL documentation (Chap. 7.1 MyISAM Tables): Maximum number of keys/table is 32 as default. Correct. However when I try to create more than 16 keys, I get: ERROR 1069 at line 1: Too many keys specified. Max 16 keys allowed 16 keys/table was the limit before the MyISAM table type was introduced. So you are probably using an ISAM table (or one of the other table types - I don't know about their limits). This table is of MyISAM type. Oh. Well, then I may have made the false conclusions. But you may want to verify the table type once again to be sure, for example with SHOW CREATE TABLE; I am currently running MySQL 3.23.41 on Linux (2.4.5) from precompiled binaries (MySQL-3.23.41-1.i386.rpm). Is there any way to use more than 16 keys ? The need for so much keys may mean that there is some design problem. If everything above does not help, please cite the complete command you are using. Maybe the problem is related to this and not to a real table restriction. Bye, Benjamin. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 mysql client
please can you give me a cooorect programme source using C APIs mysql to acces mysql database ahmed Portail mobile DIALY! visitez www.dialy.net DIALY! mobile portal visit www.dialy.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: C API mysql client
On Mon, Sep 03, 2001 at 06:18:34PM +, ahmed wrote: please can you give me a cooorect programme source using C APIs mysql to acces mysql database http://www.dataloss.nl/software/dteq/ is such a thing. /plug Greetz, Peter -- Monopolyhttp://www.dataloss.nl/monopoly.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Going mad over query
I am (desperately) trying to update a field in table A with the result of a query on table B, as an example : REPLACE INTO TableA (Value) SELECT COUNT(data1) FROM TableB WHERE data1 BETWEEN 2 AND 4 I need to modify this so that the result is stored (for example) where TableA.id=1, but at the moment it just appends to the end of Table A sorry if this is a dumb ass question!! I have scoured the manual etc, but cannot find how to include the reference to table A's id field as well! PLEASE HELP ME ! Chris Thorpe Consultronics Europe Ltd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Going mad over query
On 03-Sep-2001 Chris Thorpe wrote: I am (desperately) trying to update a field in table A with the result of a query on table B, as an example : REPLACE INTO TableA (Value) SELECT COUNT(data1) FROM TableB WHERE data1 BETWEEN 2 AND 4 I need to modify this so that the result is stored (for example) where TableA.id=1, but at the moment it just appends to the end of Table A sorry if this is a dumb ass question!! I have scoured the manual etc, but cannot find how to include the reference to table A's id field as well! REPLACE INTO TableA (id,value) SELECT 1,COUNT(data1) FROM TableB WHERE ... Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. (53kr33t w0rdz: sql table query) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
one no important buffer overflow in mysql client
The problem occurs in the function my_strdup() in an repnz scans ... stuff.If you give a input of more than 82 characters to mysql client as the database name the client will overflow. This is not a big problem since it isn't setuid. hmm... mysql -u user -phmm `perl -e 'print Ax100'` fix the my_strdup function shit stuff Submitter-Id: submitter ID Originator:Renato F. Lima Organization: Cimcorp Telnet MySQL support: none Synopsis: A little overflow Severity:non-critical with no setuid(the default) Priority: low Category: mysql Class: sw-bug Release: mysql-3.22.32 (Source distribution) Environment: System: FreeBSD chronoz.telnet.com.br 4.1.1-RELEASE FreeBSD 4.1.1-RELEASE #2: Sun Jun 17 23:06:35 BRT 2001 [EMAIL PROTECTED]:/usr/src/sys/compile/MYKERNEL i386 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock --with-low-memory --with-mit-threads=yes Perl: This is perl, version 5.005_03 built for i386-freebsd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Stored Procedures and Triggers
A friend of mine mentioned something about perl stored procedures for MYSQL. Has anyone heard about this? I have searched everywhere and only seen posts related to POSTGRESQL. If they have this for MYSQL it would be really helpful. Thanks, Dave On Mon, Sep 03, 2001 at 01:37:23AM -0700, Jeremy Zawodny wrote: On Mon, Sep 03, 2001 at 04:23:23PM +0800, Kimman Lui wrote: How many types of triggers MySQL have? And what about stored procedures? Zero and Zero, as explained in the docs. If you need them today, I'd suggest looking at PostgreSQL. If you're patient, they'll likely appear in MySQL someday--I believe both are on the TODO list. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 3 days, processed 33,335,761 queries (111/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
Re: Question on root login
Michael Rounds writes: The problem is, I am trying to setup phpmyadmin, which, when accessed, is unable to connect and gives a error of MySQL said: Access denied for user: 'root@localhost' (Using password: NO) Have you configured phpmyadmin? I recommend using the 'advanced' authentication couple with some modifications to the phpmyadmin source. Having a password in the config file is not a good thing unless you can limit access to you and you only (e.g. by .htaccess or SSL with client certificates), and the normal 'advanced' auth requires that you give some user read access to the encrypted passwords, and those should be easy enough to crack (56-bit DES I think. Correct me if I'm wrong.) I am having issues with the access denied message as well as getting it to accept my hostname. My hostname is crayon but only will allow connecting to localhost Carefully read the documentation on mysql's privilege system. What's probably missing is access for [EMAIL PROTECTED] (or simply @yourhost, since it's the transalted IP addy that's being used. I don't know what happens in case of round-robin DNS though.) -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
max. value from select statement
I have a table as such where mid is my auto increment primary key: TABLE: mboard mid 2 3 4 5 I'm doing this in combination with PHP4. What I want to do is build a query that will allow me to get the largest mid from the table (mboard) above. The query I have is: select max(mid) from mboard; BUT I tried the following in PHP and it doesn't work: $myquery = SELECT max(mid) FROM mboard; $myresult = mysql_query($myquery); $row = mysql_fetch_object($myresult); print $row-mid is result; Any ideas on how to do this? Mike _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: max. value from select statement
From: Mike Yuen [EMAIL PROTECTED] The query I have is: select max(mid) from mboard; BUT I tried the following in PHP and it doesn't work: $myquery = SELECT max(mid) FROM mboard; $myresult = mysql_query($myquery); $row = mysql_fetch_object($myresult); print $row-mid is result; I don't do any PHP, but I'm guessing that your return column name is something like 'max(mid)'. Try this: $myquery = SELECT max(mid) as max_mid FROM mboard; $myresult = mysql_query($myquery); $row = mysql_fetch_object($myresult); print $row-max_mid is result; --- Rodney Broom Programmer: Desert.Net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Storing Arrays?
Is there a good way that I can store an array in a single row using MySQL? I was taught that under a clean relational database design, arrays should be stored one element per row. However, this makes retrieving the entire array less practical, especially when I have an array of arrays. I've thought about storing an array of words as a VARCHAR() string, and using a FULLTEXT index to search through it, but I'm concerned about efficiency. What should I do? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
myodbc2.50.37 failed to build on ia64
FYI -christian- Date: Sat, 25 Aug 2001 21:46:03 -0700 From: Randolph Chung [EMAIL PROTECTED] To: [EMAIL PROTECTED] Reply-To: Randolph Chung [EMAIL PROTECTED], [EMAIL PROTECTED] Package: myodbc2.50.37 Version: 2.50.37-3 Severity: important See attached build log. Looks like the type detection code in the configure script is broken? randolph - Forwarded message from Randolph Chung [EMAIL PROTECTED] - Subject: Log for failed build of myodbc2.50.37_2.50.37-3 (dist=unstable) From: Randolph Chung [EMAIL PROTECTED] To: [EMAIL PROTECTED] Date: Sat, 25 Aug 2001 21:22:26 -0700 Automatic build of myodbc2.50.37_2.50.37-3.dsc on pippin by sbuild/ia64 1.159 Build started at 20010825-2122 ** ** Using build dependencies supplied by package: Build-Depends: debhelper (= 3.0.0), libmysqlclient10-dev (= 3.23.37-1), zlib1g-dev (= 1:1.1.3), libiodbc2-dev, libtool, automake Checking for already installed source dependencies... debhelper: already installed (in sufficient version 3.0.40 = 3.0.0) libmysqlclient10-dev: missing zlib1g-dev: already installed (in sufficient version 1:1.1.3-15 = 1:1.1.3) libiodbc2-dev: missing libtool: already installed automake: already installed Checking for source dependency conflicts... /usr/bin/sudo /usr/bin/apt-get -q -y install libmysqlclient10-dev libiodbc2-dev Reading Package Lists... Building Dependency Tree... The following extra packages will be installed: libiodbc2 libmysqlclient10 mysql-common The following NEW packages will be installed: libiodbc2 libiodbc2-dev libmysqlclient10 libmysqlclient10-dev mysql-common 0 packages upgraded, 5 newly installed, 0 to remove and 13 not upgraded. Need to get 13.7kB/1237kB of archives. After unpacking 4268kB will be used. Get:1 http://http.us.debian.org unstable/main mysql-common 3.23.40-1 [13.7kB] Fetched 13.7kB in 0s (29.3kB/s) Selecting previously deselected package libiodbc2. (Reading database ... 32232 files and directories currently installed.) Unpacking libiodbc2 (from .../libiodbc2_2.50.3-4_ia64.deb) ... Selecting previously deselected package libiodbc2-dev. Unpacking libiodbc2-dev (from .../libiodbc2-dev_2.50.3-4_ia64.deb) ... Selecting previously deselected package mysql-common. Unpacking mysql-common (from .../mysql-common_3.23.40-1_all.deb) ... Selecting previously deselected package libmysqlclient10. Unpacking libmysqlclient10 (from .../libmysqlclient10_3.23.39-4.1_ia64.deb) ... Selecting previously deselected package libmysqlclient10-dev. Unpacking libmysqlclient10-dev (from .../libmysqlclient10-dev_3.23.39-4.1_ia64.deb) ... Setting up libiodbc2 (2.50.3-4) ... Setting up libiodbc2-dev (2.50.3-4) ... Setting up mysql-common (3.23.40-1) ... Setting up libmysqlclient10 (3.23.39-4.1) ... Setting up libmysqlclient10-dev (3.23.39-4.1) ... Checking correctness of source dependencies... -- dpkg-source: extracting myodbc2.50.37 in myodbc2.50.37-2.50.37 dpkg-buildpackage: source package is myodbc2.50.37 dpkg-buildpackage: source version is 2.50.37-3 dpkg-buildpackage: host architecture is ia64 /usr/bin/fakeroot debian/rules clean dh_testdir dh_testroot rm -f build-stamp install-stamp # Add here commands to clean up after the build process. /usr/bin/make clean make[1]: Entering directory `/home/randolph/debian/myodbc2.50.37-2.50.37' make[1]: *** No rule to make target `clean'. Stop. make[1]: Leaving directory `/home/randolph/debian/myodbc2.50.37-2.50.37' make: [clean] Error 2 (ignored) /usr/bin/make distclean make[1]: Entering directory `/home/randolph/debian/myodbc2.50.37-2.50.37' make[1]: *** No rule to make target `distclean'. Stop. make[1]: Leaving directory `/home/randolph/debian/myodbc2.50.37-2.50.37' make: [clean] Error 2 (ignored) dh_clean rm -f debian/libmyodbc2.50.37.substvars debian/libmyodbc2.50.37.postinst.debhelper debian/libmyodbc2.50.37.postrm.debhelper debian/libmyodbc2.50.37.preinst.debhelper debian/libmyodbc2.50.37.prerm.debhelper rm -rf debian/libmyodbc2.50.37 rm -f debian/files rm -f debian/substvars debian/postinst.debhelper debian/postrm.debhelper debian/preinst.debhelper debian/prerm.debhelper find . -type f -a \( -name \#\*\# -o -name \*\~ -o -name DEADJOE -o -name \*.orig -o -name \*.rej -o -name \*.bak -o -name .\*.orig -o -name .\*.rej -o -name .SUMS -o -name TAGS -o -name core -o \( -path \*/.deps/\* -a -name \*.P \) \) -exec rm -f {} \; debian/rules build dh_testdir libtoolize --force --copy You should update your `aclocal.m4' by running aclocal. aclocal aclocal: both `configure.ac' and `configure.in' present: ignoring `configure.in' ./configure \ --prefix=/usr \ --enable-shared \ --enable-static \ --with-odbc-ini=/etc/odbc.ini \ --with-iodbc=/usr \
Re: Storing Arrays?
From: Philip Mak [EMAIL PROTECTED] Is there a good way that I can store an array in a single row using MySQL? You can simply delimit the data some how. Perhaps with a pipe (|). I was taught that under a clean relational database design, arrays should be stored one element per row. Good teaching. Skipping this misses the point of a relational database. However, this makes retrieving the entire array less practical, especially when I have an array of arrays. That's OK, all you need is a JOIN or two. Keep reading... I've thought about storing an array of words as a VARCHAR() string, and using a FULLTEXT index to search through it, but I'm concerned about efficiency. Good point, quite inefficient. What should I do? Let's say that you've got a table with purchase orders. Each purchase order will have one or more products. We want to see all of the purchase orders and all of the products in each order. Some setup: Table: purchase_order Coumns: id, cust_id Table: po_item Columns: po_id, product_id If you run a join like this: SELECT po.*, prod.* FROM purchase_order po, po_item prod WHERE po.id = prod.po_id You would get results something like this: ++-+---++ | id | cust_id | po_id | product_id | ++-+---++ | 1 | 1 | 1 | 5 | | 1 | 1 | 1 | 6 | | 2 | 1 | 2 | 8 | | 3 | 2 | 3 | 8 | | 3 | 2 | 3 | 9 | | 3 | 2 | 3 | 10 | ++-+---++ Now just itterate over the records returned and load them into whatever you need. If you wanted to do some type of searching, say on the product ID, you could do this: SELECT po.*, prod.* FROM purchase_order po, po_item prod WHERE po.id = prod.po_id AND product_id = 8 Does this help? --- Rodney Broom Programmer: Desert.Net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Stored Procedures and Triggers
At 1:10 PM -0700 9/3/01, David Turner wrote: A friend of mine mentioned something about perl stored procedures for MYSQL. Has anyone heard about this? I have searched everywhere and only seen posts related to POSTGRESQL. If they have this for MYSQL it would be really helpful. That would be MyPerl: http://software.tangent.org/ It looks to be very early on in development, so I'm not sure how much I'd rely on it... -steve Thanks, Dave On Mon, Sep 03, 2001 at 01:37:23AM -0700, Jeremy Zawodny wrote: On Mon, Sep 03, 2001 at 04:23:23PM +0800, Kimman Lui [EMAIL PROTECTED] wrote: How many types of triggers MySQL have? And what about stored procedures? Zero and Zero, as explained in the docs. If you need them today, I'd suggest looking at PostgreSQL. If you're patient, they'll likely appear in MySQL someday--I believe both are on the TODO list. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 3 days, processed 33,335,761 queries (111/sec. avg) -- + Open source questions? + | Steve Edberg University of California, Davis | | [EMAIL PROTECTED] Computer Consultant | | http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ | +--- http://pgfsun.ucdavis.edu/open-source-tools.html ---+ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
install under /usr/local/WWW/www.domain.org/mysql ?
dear people, our ISP asks us to install MySQL ourselves on our own domain. This means i need to install it on /usr/local/WWW/www.domain.org/mysql (on FreeBSD 4.0.1) as a non-root user, using the usual username and password. If this is possible, which i assume it must be, WHERE can i find information on how to do this? thanks, Chris please cc: [EMAIL PROTECTED] PS anyone knows whether we can override the PHP3 on the server with our own PHP4 section? -- C.Hayes Droevendaal 35 6708 PB Wageningen the Netherlands -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
HTML Checkbox - php - MySQL SET
I have a checkbox group in an HTML form that I want to use to populate a MySQL set. The data seems to come into the php array correctly, because when I do a test print loop the proper values are displayed, but the data from $misc is not present for the record in the MySQL database. How do I insert data into a set? HTML: form name=fExample method=post action=example.php table width=330 border=0 tr td width=110 input type=checkbox name=misc[] value=a a /td td width=110 input type=checkbox name=misc[] value=b b /td td width=110 input type=checkbox name=misc[] value=c c /td /tr /table PHP: for ($z = 0; $z count($misc); ++$z) { print $misc[$z]BR; } $queryInsert = INSERT INTO studentInfo (lName, fName, misc) VALUES ('$lName', '$fName', '$misc'); mysql_query($queryInsert, $link); MySQL Table: CREATE TABLE example ( lName VARCHAR(20) NOT NULL, fName VARCHAR(20) NOT NULL, misc SET('a','b','c'), form_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ); === Kenneth E. Lemons Information Technology Office Computer Systems Engineer School of Engineering [EMAIL PROTECTED]and Applied Sciences 804-924-3705University of Virginia - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Stored Procedures and Triggers of MySQL
So sprach »Kimman Lui« am 2001-09-03 um 16:26:33 +0800 : How many types of triggers MySQL have? And what about stored procedures? none and (close to) none. Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 14 hours 27 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
C++ Builder Components
Hello, I'm looking to develop a Windows based application to work with mySQL. Is there any mySQL components available for mySQL or should I just use the standard components with C++ Buider 5. Thanks Neil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: C++ Builder Components
http://www.mysql.com Fourth link on your right: MySQL++ j- k- On Monday 03 September 2001 13:35, Neil Tompkins wrote: Hello, I'm looking to develop a Windows based application to work with mySQL. Is there any mySQL components available for mySQL or should I just use the standard components with C++ Buider 5. Thanks Neil -- Joshua Kugler, Information Services Director Associated Students of the University of Alaska Fairbanks [EMAIL PROTECTED], 907-474-7601 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: REPLACE or UPDATE/INSERT ?
Stephan, REPLACE is logically handled as a DELETE + INSERT, but internally it is often handled as an UPDATE. Probably REPLACE is faster than UPDATE / INSERT, because you save some communications overhead between the client and the server. Regards, Heikki On Mon, Aug 20, 2001 at 11:00:59AM +0200, Stephan wrote: Hi all, my situation: I generate 300 rows at a time - they should be stored in the a mysql table. 99 % of the keys of these rows already exist in the table, so these rows need an update. The remaining 1 % have to be inserted in the table. I was wondering if it is a good idea to to this with 300 UPDATE statements and if one of them fails do an INSERT. Or if it's recommendable to use a single REPLACE statement. My problem with the REPLACE is that the documentation says that a REPLACE always does an DELETE and then an INSERT. In my case a lot of rows (99%) would be deleted in the index that only need an update. Is it a good idea to do that much index manipulations that aren't necessary? Hmm. Are you asking for performance reasons or just because one is easier to code than the other? It shouldn't be hard to benchmark both options. I'd be curious to hear what you find. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 3 days, processed 33,485,487 queries (110/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
Yes!
Dear [EMAIL PROTECTED] , You can earn $46,000 or more in next the 90 days sending e-mail. Seem impossible? Read on for details (no, there is no catch)... AS SEEN ON NATIONAL T.V. Thank you for your time and Interest. This is the letter you've been reading about in the news lately. Due to the popularity of this letter on the internet, a major nightly news program recently devoted an entire show to the investigation of the program described below, to see if it really can make people money. The show also investigated whether or not the program was legal. Their findings proved once and for all that there are, absolutely no laws prohibiting the participation in the program. This has helped to show people that this is a simple, harmless and fun way to make some extra money at home. The results of this show has been truly remarkable. So many people are participating that those involved are doing, much better than ever before. Since everyone makes more as more people try it out, its been very exciting to be a part of lately. You will understand once you experience it. HERE IT IS BELOW *** Print This Now For Future Reference *** The following income opportunity is one you may be interested in taking a look at. It can be started with VERY LITTLE investment and the income return is TREMENDOUS!!! $$$ If you would like to make at least $46,000 in less than 90 days! Please read the enclosed program...THEN READ IT AGAIN!!! THIS IS A LEGITIMATE, LEGAL, MONEY MAKING OPPORTUNITY. It does not require you to come into contact with people, do any hard work, and best of all, you never have to leave the house except to get the mail. If you believe that someday you'll get that big break that you've been waiting for, THIS IS IT! Simply follow the instructions, and your dreams will come true. This multi-level e-mail order marketing program works perfectly...100% EVERY TIME. E-mail is the sales tool of the future. Take advantage of this non-commercialized method of advertising NOW!!! The longer you wait, the more people will be doing business using e-mail. Get your piece of this action!!! MULTI-LEVEL MARKETING (MLM) has finally gained respectability. It is being taught in the Harvard Business School, and both Stanford Research and the Wall Street Journal have stated that between 50% and 65% of all goods and services will be sold through multi-level methods by the mid to late 1990's. This is a Multi-Billion Dollar industry and of the 3,500,000 millionaires in the WORLD, 20% ( 700,000) made their fortune in the last several years in MLM. Moreover, statistics show that over 100 people become millionaires everyday through Multi-Level Marketing. You may have heard this story before, but over the summer Donald Trump (A MULTI-BILLIONAIRE, ONE OF THE WEALTHIEST MEN IN THE WORLD) made an appearance on the David Letterman show. Dave asked him what he would do if he lost everything and had to start over from scratch. Without hesitating, Trump said he would find a good network marketing company and get to work. The audience started to hoot and boo him. He looked out at the audience and dead-panned his response That's why I'm sitting up here and you are all sitting out there! With network marketing you have two sources of income. Direct commissions from sales you make yourself and commissions from sales made by people you introduce to the business. Residual income is the secret of the wealthy. It means investing time or money once and getting paid again and again and again. In network marketing, it also means getting paid for the work of others. This program is currently being utilized in more than 50 different countries across the world. The enclosed INF0RMATION is something I almost let slip through my fingers. Fortunately, sometime later I re-read everything and gave some thought and study to it. My name is Johnathon Rourke. Two years ago, the corporation I worked at for the past twelve years down-sized and my position was eliminated. After unproductive job interviews, I decided to open my own business. Over the past year, I incurred many unforeseen financial problems. I owed my family, friends and creditors over $35,000. The economy was taking a toll on my business and I just couldn't seem to make ends meet. I had to refinance and borrow against my home to support my family and struggling business. AT THAT MOMENT something significant happened in my life and I am writing to share the experience in hopes that this will change your life FOREVER FINANCIALLY!!! In mid December, I received this program via e-mail. Six month's prior to receiving this program I had been sending away for
mysql 3.23 w/ replication enabled silently dies (pluss a littleventing..)
Hi All-- We have a really busy mysql 3.23 server utilizing replication which dies on a daily basis. The mysqld process itself doesn't die, but we have monitoring tools that notifies us saying Can't connect to mysql [..] (60) (60 = Operation timed out). The largest table has over 16 million rows of data. If we simply relied on the process running it would take some time for us to notice things were borked, but with our multiple tools and graphs we are able to catch problems rather quickly. The solution is just to issue a ``kill -TERM pid'' as it's impossible to connect to the mysql server, and then start it again. We probably have about 50-60 dedicated mysql servers all running FreeBSD 3.2/4.[0-3], and I must say I've become more and more dissapointed with mysql lately especially related to servers experiencing many ``ORDER BY'' requests (which causes mysql to require more and more memory and eventually crash because of it using all available memory). I wish development on the 3.22 branch was completed before the 3.23 branch was declared stable while IMO being even more unstable than the previous branch. Sorry, just had to vent a little... :) = System info from master replication server == Key_reads/Key_read_req = 0.0486 Key_writes/Key_writes_req = 0.988 MySQL version: 3.23.41-log # mysqladmin -uroot -p status Enter password: Uptime: 25923 Threads: 22 Questions: 16546781 Slow queries: 0 Opens: 86 Flush tables: 1 Open tables: 80 Queries per second avg: 638.305 # uname -a FreeBSD hostname 3.2-RELEASE FreeBSD 3.2-RELEASE #0: Tue Feb 13 01:06:48 PST 2001 root@hostname:kernel i386 Regards, Atle - Flying Crocodile Inc, Unix Systems Administrator - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: install under /usr/local/WWW/www.domain.org/mysql ?
At 10:59 PM +0200 9/3/01, Chris Hayes wrote: dear people, our ISP asks us to install MySQL ourselves on our own domain. This means i need to install it on /usr/local/WWW/www.domain.org/mysql (on FreeBSD 4.0.1) as a non-root user, using the usual username and password. If this is possible, which i assume it must be, WHERE can i find information on how to do this? Use a source distribution and configure it like this: ./configure --prefix=/usr/local/WWW/www.domain.org/mysql plus any other flags you might normally use with configure on FreeBSD. (see the installation chapter of the MySQL manual for any FreeBSD-specific information. thanks, Chris please cc: [EMAIL PROTECTED] PS anyone knows whether we can override the PHP3 on the server with our own PHP4 section? If the ISP allows you to install MySQL, presumably you can install PHP as well. -- Paul DuBois, [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: MyODBC between MySQL-Server (Linux) and Linux-Client
Hi !! )-Original Message- )From: [EMAIL PROTECTED] )[mailto:[EMAIL PROTECTED]]On Behalf Of Peter Harvey )Sent: Saturday, September 01, 2001 8:13 AM )To: [EMAIL PROTECTED] )Subject: Re: MyODBC between MySQL-Server (Linux) and Linux-Client ) ) ) ) root@workstation3:/home/manuel isql -v MySQLtest dbuser ) [unixODBC][TCX][MyODBC]Can't connect to local MySQL server through socket ) '/var/lib/mysql/mysql.sock' (2) ) [ISQL]ERROR: Could not SQLConnect ) root@workstation3:/home/manuel ) ) It seems to try to connect to a local mysql-server, wich doesn't exist? ) ) My /etc/odbc.ini on the other Linux client (same as on the server): ) ) )How did you add the odbc.ini entry... using ODBCConfig? I am )thinking that you may )have dropped it into the wrong place using a text editor... but )then again... it does )not quite sound like it. Hmmm The default location for the system ini is )/usr/local/lib/etc/odbc.ini or something like that. Using )ODBCConfig (or odbcinst) is )a good way to ensure that you modify the correct ini file. ) Also, check what is the $ODBCINI value and make sure it is really pointing to the expected odbc.ini. If not export ODBCINI to your odbc.ini file path and try. Some times better to include filename also in to the path like export ODBCINI=/usr/etc/odbc.ini Regards Venu -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Venu mailto:[EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Woodside, California USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to get connected to Web DB from Frontpage
Steps I took to create a database connection (which does not work yet): I downloaded the driver for mySQL put it in my system DSN. Then I went to Frontpage 2002's Tools, Web Settings, Database. I selected 'Network Connection to DB Server'. I selected mySQL driver, input my server ip address the database name. I clicked Verify it confirmed the connection was OK. After doing this, Frontpage created a global.asa file which looks like an HTML page but is an ASP page. When I published this file to my web hoster's server, an error message said my web server does not support .ASP files. I said upload anyway tested my site; my query did not execute. See below *. Some documentation re: if your server does not support ASP says to go to Tools, Page Options in Frontpage and uncheck ASP support. I don't know if I should do this or not. If Frontpage needs to use this global.asa file for connectivity but my web hoster's server does not support ASP pages, how do I connect! BTW, my web hoster supports Frontpage 2000 extensions I have this enabled on my web site setup. As far as I know, I am not using Frontpage 2002 features at all in my web site. I have contacted my web hoster they just give me sites to go to like mysql or php to read documentation, so they are not helping me at all since I've read the relevant documentation that's how I got this far by myself but now I'm stuck! * In the script below, the results I get on my site is that I can only see Here is the current schedule:; nothing else is on the page! I don't get any errors! I changed the username password below in order to send this to you. My .php script which I created a hyperlink to is: html head meta name=GENERATOR content=Microsoft FrontPage 5.0 meta name=ProgId content=FrontPage.Editor.Document meta http-equiv=Content-Type content=text/html; charset=windows-1252 titleDave's Schedule/title /head body ?php // Connect to the database server $dbcnx = @mysql_connect(localhost, fakename, 9); if (!$dbcnx) { echo( PUnable to connect to the . database server at this time./P ); exit(); } // Select Dave's database if (! @mysql_select_db(dauerbac) ) { echo( PUnable to locate the schedule . database at this time./P ); exit(); } ? P Here is the current schedule: /P BLOCKQUOTE ?php // Request the students' schedules $result = mysql_query( SELECT First, Last, Monday, Tuesday, Wednesday, Thursday, Friday, Sunday, Comments FROM dauerbac`.`students` LIMIT 0, 30); if (!$result) { echo(PError performing query: . mysql_error() . /P); exit(); } // Display the text of each row in a paragraph while ( $row = mysql_fetch_array($result) ) { echo(P . $row[First, Last, Monday, Tuesday, Wednesday, Thursday, Friday, Sunday, Comments] . /P); } ? /BLOCKQUOTE /body /html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SQL/92 99 Information
Hi, All. Some body nows how I can get a SQL/92 and 99 information. TIA Mario Espinoza Ll. Consultores STI, S.C. [EMAIL PROTECTED] Av. Guadalupe # 618, Col. Chapalita Guadalajara, Jal. México. +52 3122-9004 Ext. 213 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 3.23 w/ replication enabled silently dies (pluss a little venting..)
On Mon, Sep 03, 2001 at 04:06:04PM -0700, Atle Veka wrote: We probably have about 50-60 dedicated mysql servers all running FreeBSD 3.2/4.[0-3] FreeBSD 3.x and 4.{0,1,2} aren't the most stable platform for a heavy-use MySQL server. 4.3 is the first version that appears to have fixed the threading problems which often cause data corruption and mysterious crashes. I'd recommend trying to reproduce the problem on FreeBSD 4.3. You might also look for Ken Menzel's (sp?) posts about compiling MySQL with LinuxThreads on recent versions of FreeBSD. It's another proven path to MySQL stability on FreeBSD. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 4 days, processed 36,844,197 queries (103/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
error with 'make'
-- After: www-pws5: {18} % ./configure --prefix=/usr/local/WWW/www.jma.org/mysql --with- mysqld-user=mysql --with-thread-safe-client --enable-assembler and then 'make' i got this long list of stuff, funished by errors: [] Making all in client g++ -DUNDEF_THREADS_HACK -I./../include - I../include -I./.. -I..-I..-O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -c mysql.cc cc1plus: Invalid option `-fno-exceptions' In file included from mysql.cc:28: ../include/global.h:646: warning: abstract declarator used as declaration *** Error code 1 Stop. *** Error code 1 Stop. *** Error code 1 Stop. -- what is happening? -- C.Hayes Droevendaal 35 6708 PB Wageningen the Netherlands -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Stored Procedures and Triggers
Great thanks, I'll check it out. Dave On Mon, Sep 03, 2001 at 01:49:31PM -0700, Steve Edberg wrote: At 1:10 PM -0700 9/3/01, David Turner wrote: A friend of mine mentioned something about perl stored procedures for MYSQL. Has anyone heard about this? I have searched everywhere and only seen posts related to POSTGRESQL. If they have this for MYSQL it would be really helpful. That would be MyPerl: http://software.tangent.org/ It looks to be very early on in development, so I'm not sure how much I'd rely on it... -steve Thanks, Dave On Mon, Sep 03, 2001 at 01:37:23AM -0700, Jeremy Zawodny wrote: On Mon, Sep 03, 2001 at 04:23:23PM +0800, Kimman Lui [EMAIL PROTECTED] wrote: How many types of triggers MySQL have? And what about stored procedures? Zero and Zero, as explained in the docs. If you need them today, I'd suggest looking at PostgreSQL. If you're patient, they'll likely appear in MySQL someday--I believe both are on the TODO list. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 3 days, processed 33,335,761 queries (111/sec. avg) -- + Open source questions? + | Steve Edberg University of California, Davis | | [EMAIL PROTECTED] Computer Consultant | | http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ | +--- http://pgfsun.ucdavis.edu/open-source-tools.html ---+ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysqld/FreeBSD 4.3 stuck in kernel
Description: This busy mysql server will run well for about one week, with 95% idle cpu. Then at some point it will get stuck, so that it is still very responsive, but cpu utilization changes to 95% system cpu and 0% idle cpu. When the server is in this condition and I use the ktrace utility to trace system calls, the output of ktrace consists of about 44% calls to poll() and 44% calls to gettimeofday(), in a pattern like this: bash-2.05# kdump -Rf ktrace.stuck | more [...] 45689 mysqld 0.11 CALL gettimeofday(0x821ae28,0) 45689 mysqld 0.14 RET gettimeofday 0 45689 mysqld 0.24 CALL poll(0x827,0x92,0x4c) 45689 mysqld 0.41 RET poll 1 45689 mysqld 0.10 CALL gettimeofday(0x821ae28,0) 45689 mysqld 0.15 RET gettimeofday 0 45689 mysqld 0.24 CALL poll(0x827,0x92,0x4c) 45689 mysqld 0.41 RET poll 1 A ktrace of a normal server, in comparison, contains less than 1% each of gettimeofday() and poll(). Here is the output of show status from server in the stuck condition, and the m.cnf file mysql show status; +--++ | Variable_name| Value | +--++ | Aborted_clients | 1333 | | Aborted_connects | 66 | | Bytes_received | 643612919 | | Bytes_sent | 1691709087 | | Connections | 323428 | | Created_tmp_disk_tables | 0 | | Created_tmp_tables | 13686 | | Created_tmp_files| 0 | | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Delayed_errors | 0 | | Flush_commands | 5 | | Handler_delete | 2 | | Handler_read_first | 12791 | | Handler_read_key | 20974993 | | Handler_read_next| 190435337 | | Handler_read_prev| 0 | | Handler_read_rnd | 28883776 | | Handler_read_rnd_next| 1290867357 | | Handler_update | 7457 | | Handler_write| 28333553 | | Key_blocks_used | 145471 | | Key_read_requests| 421502449 | | Key_reads| 145451 | | Key_write_requests | 1236 | | Key_writes | 551| | Max_used_connections | 353| | Not_flushed_key_blocks | 0 | | Not_flushed_delayed_rows | 0 | | Open_tables | 446| | Open_files | 859| | Open_streams | 0 | | Opened_tables| 928| | Questions| 5605574| | Select_full_join | 0 | | Select_full_range_join | 0 | | Select_range | 141218 | | Select_range_check | 0 | | Select_scan | 358753 | | Slave_running| OFF| | Slave_open_temp_tables | 0 | | Slow_launch_threads | 0 | | Slow_queries | 328| | Sort_merge_passes| 0 | | Sort_range | 43265 | | Sort_rows| 28883773 | | Sort_scan| 85805 | | Table_locks_immediate| 5306255| | Table_locks_waited | 11 | | Threads_cached | 3 | | Threads_created | 15889 | | Threads_connected| 145| | Threads_running | 2 | | Uptime | 1054801| +--++ bash-2.05# cat /etc/my.cnf # MySQL config file for greatschools.net # Based on samples/my-large.cnf # # for large system with memory = 512M where the system runs mainly # MySQL. # The following options will be passed to all MySQL clients [client] #password = your_password port= 3306 socket = /tmp/mysql.sock # Here follows entries for some specific programs # The wrapper around mysqld [safe_mysqld] err-log = /var/log/mysql/errorlog # The MySQL server [mysqld] log-bin = /var/log/mysql/binlog log-slow-queries = /var/log/mysql/slow_sql pid-file= /var/log/mysql/mysqld.pid bdb-logdir = /var/log/mysql/berkeley-db port= 3306 socket = /tmp/mysql.sock skip-locking # Variables set-variable= long_query_time=1 set-variable= key_buffer=256M set-variable= max_allowed_packet=1M set-variable= table_cache=1000 set-variable= sort_buffer=1M set-variable= record_buffer=1M set-variable= myisam_sort_buffer_size=64M set-variable= thread_cache=8 set-variable= max_connections=600 # Try number of CPU's*2 for thread_concurrency set-variable= thread_concurrency=2 server-id = 5 # Check Repair tables on startup myisam-recover = BACKUP,FORCE # Uncomment the following if you are using BDB tables set-variable= bdb_cache_size=64M set-variable= bdb_max_lock=10 # Point the following paths to different
MySQL on Windows 98
I have installed mysql on a windows 98 machine and I want to be able to connect to that server from another computer on my network. The other computer is a windows 2000 professional edition. Since I am new at this, I'd like to know if this is even possible, and if so, any documentation detaling how to accomplish this would be appreciated. I have my server up and running, but I don't know what configuration I need to perform so that I can connect to it with jdbc from my other windows 2000 machine. Any help would be appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Alternate word finding with '%'
I'm sure this is disscused somewhere, but I'm not sure how I'd look for it. Is it possible to supply a thesaurus-like file for mysql so when you go %oil% it finds petrol gas and/or lubricant? Does anyone know of a database that will do this? Thanks, Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Data Type Conversion
Hello, I have a problem with the Datagrid in visual basic 6 (sp5) where the data in the date column asspeas as nothing if it is a date or if it isnt a date. I believe that its a problem with the conflicting data types, i was wondering if its possible to get MySQL to convert a type (such as date) to a string or is there something i am missing ? My sql statement is SELECT IF(date is null, NoDateReason, Date_Format(Date,'%d/%m/%Y')) as date from dates; The date field type is DATE and NoDateReason is text The query works fine when displayed in a flex grid but i would prefer not to have to use a flex grid or manually populate the data grid. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
is there facility with replication?
Dear all. about to load sharing DB server, I'd like to use facility which automatically part and execute requests from client , such as : update - Master?load -Slave. previously, Client Master --- Slave ^ update|--- Slave | +--- Slave || load well, I think that I want to facility even more. Is there useful deamon in like above situation. 1) will be supported with mysql new version (4.0 later? ) in this way, Slave -+ | update | Client Slave --- Master load/updateupdate| --- | load| update | Slave + 2) is there PATCH or Proxy-daemon and they are provided already? (e.g. thus it is located in between JDBC and mysql-deamon.) _ Kiyoko Takanabe - engineer email: mailto:[EMAIL PROTECTED] iDimension Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php