Cannot access MySql after OS upgrade
I had to upgrade my SGI server to operating system IRIX 6.5.18m from 6.5.15m after the upgrade I can access MySql from the command line but I cannot make an ODBC connection and my web pages using mysql do not work. Other than the OS upgrade no other changes were made. I have tried reinstalling the mysql software version 3.23.54a and it made no difference. My MySql log file has the following entries which show that it is starting fine: 030123 20:15:00 /usr/freeware/sbin/mysqld: Shutdown Complete 030123 20:15:00 mysqld ended 030123 20:31:54 mysqld started /usr/freeware/sbin/mysqld: ready for connections 030123 20:46:44 /usr/freeware/sbin/mysqld: Normal shutdown 030123 20:46:45 /usr/freeware/sbin/mysqld: Shutdown Complete 030123 20:46:45 mysqld ended 030123 20:47:51 mysqld started /usr/freeware/sbin/mysqld: ready for connections - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
copying innodb data
(It sucks; sql,query,mysql,...) (B (BHello folks (B I need to move my database from a WindowsNT environment to a Linux (BRedHat7.0 Box. I am now using innodb tables. Is there any easy way of (Bcopying my existing tables in NT Box to Linux? (B (B (BThanks for any suggestions (B (Bregards (B (B (B (B- (BBefore posting, please check: (B http://www.mysql.com/manual.php (the manual) (B http://lists.mysql.com/ (the list archive) (B (BTo request this thread, e-mail [EMAIL PROTECTED] (BTo unsubscribe, e-mail [EMAIL PROTECTED] (BTrouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Multi-table summary SQL problem/question
Dear Listers, This is presenting a challenge to my SQL skills of how to attack this, hopefully someone else might be able to help point me in the right direction. I'm building an application to track sports contests. Essentially players, each of whom are members of a specific club, guess every week on who will win a game and what the score is. So I have a table of games: Id, Visitor_id, Home_id, Visitor_score, Home_Score And teams: Id, Visitor_id, Home_id, Visitor_score, Home_Score And players: Id, Player_name, Club_id And clubs: Id, Club_Name And every week, I populate my picks table with picks from players: Id, Player_id, Game_id, Visitor_score_guess, Home_score_guess So what I'm trying to do is to get a list of player rankings by correct/incorrect guesses (or wins and losses). On a given week, several players will enter one or more records (rows) in the picks db, each referring to a game, and guesses the game score. So what I want to do is compare the pick scores (stored in the picks DB) to the actual score (stored in the games db), determine if the player guessed correctly, and flag that as a win (ie a correct guess) or a loss (incorrect guess). Then sum that result over time to determine player rankings, ie the player with the most wins is at the top of the list. Any input, general direction or (best case) sample code would be greatly, greatly appreciated. Best, Peter D Bethke - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
High list latency?
Is anyone else seeing it take 4-8 hours for mail to get thru this list recently? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.8: up 5 days, processed 145,791,837 queries (323/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 it normal?
And does anyone know what column type I should use if I want a precise calculation? I've even tried with text and blob, but they are not working either. Only the int type is precise? Thanks. Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [EMAIL PROTECTED] - Original Message - From: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] To: Octavian Rasnita [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED] Sent: Monday, January 20, 2003 11:42 PM Subject: Re: Is it normal? Octavian, mysql create table test(id float); mysql insert into test values(1.123), (3.1495); mysql select * from test where id=1.123; Empty set (0.00 sec) Shouldn't this last query show me the record that has the id=1.123? Well ... 1.123 is greater than 1.123, see: mysql select id from octavian where id 1.123; ++ | id | ++ | 1.123 | | 3.1495 | ++ 2 rows in set (0.00 sec) Now here's why. Floats are simply not precise: mysql select id*1 from octavian where id 1.123; +-+ | id*1| +-+ | 11230.000257492 | -- | 31494.998931885 | +-+ 2 rows in set (0.00 sec) What query should I use to do this? I leave this one to Paul or one of the other gurus. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Octavian Rasnita [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Monday, January 20, 2003 9:34 AM Subject: Is it normal? Hi all, I've tried the following SQL queries: mysql create table test(id float); Query OK, 0 rows affected (0.00 sec) mysql insert into test values(1.123), (3.1495); Query OK, 2 rows affected (0.01 sec) Records: 2 Duplicates: 0 Warnings: 0 mysql select * from test where id=1.123; Empty set (0.00 sec) Shouldn't this last query show me the record that has the id=1.123? What query should I use to do this? Thank you. Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re:ODBC Driver?
you can get all you need from here. http://www.mysql.com/articles/dotnet/index.html -- Jeffrey Powell [EMAIL PROTECTED] writes: Return-Path: [EMAIL PROTECTED] Received: from mx06.lax.untd.com (mx06.lax.untd.com [10.130.24.66]) by maildeliver04.nyc.untd.com with SMTP id AAA9DBTT3AFWQBTA for [EMAIL PROTECTED] (sender [EMAIL PROTECTED]); Thu, 23 Jan 2003 23:51:05 -0500 (EST) Received: from web.mysql.com (web.mysql.com [213.136.49.183]) by mx06.lax.untd.com with SMTP id AAA9DBTT2ATKMRW2 for [EMAIL PROTECTED] (sender [EMAIL PROTECTED]); Thu, 23 Jan 2003 20:51:04 -0800 (PST) Received: (qmail 27781 invoked by uid 7797); 23 Jan 2003 23:29:54 - Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org) List-ID: mysql.mysql.com Precedence: bulk List-Help: mailto:[EMAIL PROTECTED] List-Unsubscribe: mailto:[EMAIL PROTECTED] List-Post: mailto:[EMAIL PROTECTED] List-Subscribe: mailto:[EMAIL PROTECTED] Delivered-To: mailing list [EMAIL PROTECTED] Received: (qmail 27763 invoked from network); 23 Jan 2003 23:29:53 - Content-Type: text/plain; charset=us-ascii From: Jeffrey Powell [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Organization: Yonezawa English School To: [EMAIL PROTECTED] Subject: ODBC Driver? Date: Fri, 24 Jan 2003 08:29:35 +0900 User-Agent: KMail/1.4.3 MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: [EMAIL PROTECTED] -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I am preparing to migrate a client from using a large MS-ACCESS database to using a linux hosted MySql as the datasource. Or at least I'd like to be able to export tables as a backup. Please tell me where I can get a driver. Thanks, - -- Jeff Powell [EMAIL PROTECTED] http://www.yonezawa-english-school.com http://www.yonezawa-english-school.com/powell -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE+MHrobJk3zHBW5lARAhyFAKDQ/bsoPm04VQVsq43+EpZNKb/DrwCeMmjO B8Sf38yWG3Lb+ex3Rdoy1Rs= =DajP -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Column present in diffrent tables
Dear Helpers, I want to check one column name is present in how many table in a databse , and name of those tables. does mysql supports this function ? Ex : Tables 1 Item master columns are ItemID, ItemName 2 Item details columns are ItemID,Dateof purchase etc 3Item Dispatch columns are ItemID, Date of Dispatch. You can see the coulmn ItemID present in three tables , i want query so that i can know itemid preset in these tables ,pls help me Thanks regards, shashi - DISCLAIMER - This message, along with any attachments, is proprietary to Velankani Information Systems and is intended solely for the use of the individual to whom it is addressed. It may contain privileged or confidential information and should not be circulated or used for any purpose other than for what it is intended. If you have received this message in error, please notify the originator immediately. If you are not the intended recipient, you are notified that you are strictly prohibited from using, copying, altering, or disclosing the contents of this message. Velankani Information Systems accepts no responsibility for loss or damage arising from the use of the information transmitted by this email including damage from virus. -- Velankani Information Systems Ltd, Bangalore, India - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 1064 and sol 8
okay - mysql build is killing me here .. when I run mysql_install_db, gives me the following error ERROR 1064 : use mysql; INVALID SYNTAX I cannot get mysqld to start - it keeps saying ERROR: 1064 syntax error near '' at line 1 what is goign on here ... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
My SQL
How do I download and install My SQL for Mac OS 9? Thanks, Jonas *-*-*-*-*-*-*-*-*-*-*-* Jonas Rosenbloom 1042 Shirley Drive Henderson, NC 27536 Phone: 252-492-5754 [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: MYSQL Open Office
sql,query,queries,smallint What became of the discussion between Open Office.org and Monty at LWE? Ruben -- __ Brooklyn Linux Solutions __ DRM is THEFT - We are the STAKEHOLDERS http://fairuse.nylxs.com http://www.mrbrklyn.com - Consulting http://www.inns.net -- Happy Clients http://www.nylxs.com - Leadership Development in Free Software http://www2.mrbrklyn.com/resources - Unpublished Archive or stories and articles from around the net http://www2.mrbrklyn.com/downtown.html - See the New Downtown Brooklyn 1-718-382-0585 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re:Re: Is this possible?
I thought sub-select is a 4.x feature.. -- Frank Peavy [EMAIL PROTECTED] writes: Return-Path: [EMAIL PROTECTED] Received: from mx6.nyc.untd.com (mx6.nyc.untd.com [10.140.24.66]) by maildeliver03.nyc.untd.com with SMTP id AAA9DBZJZAVXT492 for [EMAIL PROTECTED] (sender [EMAIL PROTECTED]); Fri, 24 Jan 2003 01:28:39 -0500 (EST) Received: from web.mysql.com (web.mysql.com [213.136.49.183]) by mx6.nyc.untd.com with SMTP id AAA9DBZJZAEVS6MS for [EMAIL PROTECTED] (sender [EMAIL PROTECTED]); Fri, 24 Jan 2003 01:28:39 -0500 (EST) Received: (qmail 15275 invoked by uid 7797); 24 Jan 2003 00:25:19 - Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org) List-ID: mysql.mysql.com Precedence: bulk List-Help: mailto:[EMAIL PROTECTED] List-Unsubscribe: mailto:[EMAIL PROTECTED] List-Post: mailto:[EMAIL PROTECTED] List-Subscribe: mailto:[EMAIL PROTECTED] Delivered-To: mailing list [EMAIL PROTECTED] Received: (qmail 15255 invoked from network); 24 Jan 2003 00:25:18 - Message-Id: [EMAIL PROTECTED] X-Sender: [EMAIL PROTECTED] X-Mailer: QUALCOMM Windows Eudora Version 5.1 Date: Thu, 23 Jan 2003 16:24:11 -0800 To: Doug Coning [EMAIL PROTECTED], [EMAIL PROTECTED] From: Frank Peavy [EMAIL PROTECTED] Subject: Re: Is this possible? In-Reply-To: 023f01c2c313$5a2feb40$0a01a8c0@GIDEON References: [EMAIL PROTECTED] Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed I believe a sub-select with the DISTINCT command would do it. You would have to look up the syntax. Also, it seems that some people seem to be having a problem with sub-selects but I don't have any direct experience to convey. At 01:12 PM 1/23/03 -0600, Doug Coning wrote: Is this possible in MySQL without using a temporary table with multiple SQL commands: I am trying to SELECT the results of multiple columns into 1 column or Alias, group them and sort them. So if I had a table with 4 fields: Cat1, Cat2, Cat3, Cat4 like such: +-+--+-+--+ | Cat1| Cat2 | Cat3| Cat4 | +-+--+-+--+ | F | A | | A | | D | C | H | A | | G | | | | | F | B | I | A | +-+--+-+--+ It would select all the values, merge them into 1 column, group them, and sort them like such so that the result would be a single column, returning only 1 instance of each returned value: ++ | Result | ++ | A | | B | | C | | D | | F | | G | | H | | I | ++ Is there as singe Select command that can do this? Right now I am using a temporary table where I first clear out the values, then copy each column one at a time over into the tables... It works, however, I was wondering if there is an easier way to get the single column result with all the merged information without having to use a temporary table... Thanks, Doug Coning - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Left join returns records it shouldn't
On Wednesday 22 January 2003 20:28, gordon at hammy dot lonestar dot org wrote: Description: The following silly query (silly because it should return no records since it is impossible for a.type to have two different values simultaneously), returns two records when it should return none with the enclosed test data. select a.*, b.* from dns_rec a left join dns_rec b on (a.zone = b.zone and a.rightside = b.rightside and a.type = 'A' and b.type = 'A' and a.leftside = '' and b.leftside != '') where b.zone is null and a.type = 'MX' ; This happens because you include filtering condition like a.type='A' in ON clause. This is old and known behaviour. If you move out these conditions from ON part to the WHERE, you get correct result: mysql select a.*, b.* from dns_rec a left join dns_rec b on (a.zone = b.zone and a.rightside = b.rightside) where a.type = 'A' and b.type = 'A' and a.leftside = '' and b.leftside != '' and b.zone is null and a.type = 'MX'; Empty set (0.00 sec) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Writing program to communicate with remote internet MySQL server?
Hi Gelu, I agree with you, and it's an excellent suggestion. On the other hand, I am generally interested in whether or not it's within my abilities / available toolset to do this, and it would allow me to develop far more specific / personalised 'synchronisation' processes. Anyone have any thoughts on how this could be achieved? Regards and best wishes, Murray Wells -Original Message- From: Gelu Gogancea [mailto:[EMAIL PROTECTED]] Sent: Friday, 24 January 2003 7:24 AM To: Murray Wells; [EMAIL PROTECTED] Subject: Re: Writing program to communicate with remote internet MySQL server? Hi, IMHO: I think the better way is to use replication between your local MySQL server and MySQL from the Web Server. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Murray Wells [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 23, 2003 4:30 PM Subject: Writing program to communicate with remote internet MySQL server? Hello All, For some time I've been wondering if it's possible to write a program that can automatically check my local MySQL server, create a recordset containing any new or updated records found in my local table(s) since the last check, and upload those new / updated records to the MySQL server my web site uses at phpwebhosting.com. My background is VB / VBA, but I also have access to Perl, Python and Ruby. I'm wondering if anyone can tell me if it's possible, using one of these languages, to connect to a remote MySQL server over the internet and to manipulate tables on the remote server as though they were recordset objects, similarly to how you might achieve this on a local server using MyODBC? The end goal is to develop a program I can fire as a Windows XP scheduled task to synchronize the remote database with the local one. Any help appreciated! Regards and best wishes, M Wells - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: updating tables
Stefan, The problem look be solved; i've just changed structure of the updatable table. First this table have only 1 primary key, now my table have some indexed unique keys. and now if i do a replace into command look's like to work fine. I have just a question: i need also to change structure of the master table (have only a primary key) or the changes made on the updatable_table are enough? regards, fabrizio On Fri, 24 Jan 2003 00:10:19 +0100 Stefan Hinz, iConnect \(Berlin\) [EMAIL PROTECTED] wrote: Fabrizio, please send the table structures of table_1 and table_2 (DESCRIBE ...) so we can do more for you than just guess what the problem might be. REPLACE seems good in the first place, but if it just INSERTs then there's a problem with the (primary) keys. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Fabrizio Tivano [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 23, 2003 5:22 PM Subject: updating tables hello dear all, i have a problem updating tables: in my queries i try to use REPLACE but is same like INSERT command. ...i need only to refresh table_1 with new entries from table_2. any ideas? TIA fabrizio - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 -- Fabrizio Tivano WAN System Administrator SAD Trasporto Locale S.p.a. Corso Italia 13/N 39100 BOLZANO e-mail : [EMAIL PROTECTED] Tel: +390471450268 Fax: +390471450253 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
insert query
how to insert only blank spaces into a field using insert query. Its getting trimmed off. Regards, Murthy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 3.23.55 is released
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL 3.23.55, a new version of the popular Open Source Database, has been released. It is now available in source and binary form for a number of platforms from our download pages at http://www.mysql.com/downloads/ and mirror sites. Note that not all mirror sites may be up to date at this point of time - if you can't find this version on some mirror, please try again later or choose another download site. This is a bugfix release for the current stable tree. Users who use MySQL in an untrusted multi-user environment should consider upgrading to this version, which also fixes a bug that enabled valid local users to crash mysqld by using a specially modified mysql client application. From the ChangeLog: * Fixed double `free''d pointer bug in `mysql_change_user()' handling, that enabled a specially hacked version of MySQL client to crash `mysqld'. *Note*, that one needs to login to the server by using a valid user account to be able to exploit this bug. * Fixed bug with the `--slow-log' when logging an administrator command (like `FLUSH TABLES'). * Fixed bug in `GROUP BY' when used on BLOB column with `NULL' values. * Fixed a bug in handling `NULL's in `CASE ... WHEN ...'. * Bugfix for `--chroot' (*note `--chroot': News-3.23.54.) is reverted. Unfortunately, there is no way to make it to work, without introducing backward-incompatible changes in `my.cnf'. Those who need `--chroot' functionality, should upgrade to MySQL 4.0. (The fix in the 4.0 branch did not break backward-compatibility). * Make `--lower-case-table-names' default on MacOSX as the file system is case insensitive. * Fixed a bug in `scripts/mysqld_safe.sh' in `NOHUP_NICENESS' testing. * Transactions in `AUTOCOMMIT=0' mode didn't rotate binary log. * Fixed a bug in `scripts/make_binary_distribution' that resulted in a remaining `@HOSTNAME@' variable instead of replacing it with the correct path to the `hostname' binary. * Fixed a very unlikely bug that could cause `SHOW PROCESSLIST' to core dump in pthread_mutex_unlock() if a new thread was connecting. * Forbid `SLAVE STOP' if the thread executing the query has locked tables. This removes a possible deadlock situation. Additional Notes: - Unfortunately we are currently unable to provide Solaris binaries other than Solaris8 due to hardware problems. We're working on adding two more Solaris build hosts to be able to offer special versions for Solaris 2.7 and Solaris9 for future MySQL releases. We apologize for any inconvenience this may cause you. Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE+MRoESVDhKrJykfIRAjorAJ9JcU/Sm1oLPyjK4/LzRbAXBfz9rwCfdY7Z J1GZ93RGTA5QA2TxirIR6Ks= =BQbY -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
insert query
sql,query,queries,smallint how to insert only blank spaces into a field. Its getting trimmed off. Regards, Murthy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Column present in diffrent tables
Shashi, please send these general MySQL questions to [EMAIL PROTECTED] Thank you, Heikki sql query - Original Message - From: N Shashidhara [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 24, 2003 7:37 AM Subject: Column present in diffrent tables Dear Heikki, I need i more help from you I want to check one column name is present in how many table in a databse , and name of those tables. does mysql supports this function ? Ex : Tables 1 Item master columns are ItemID, ItemName 2 Item details columns are ItemID,Dateof purchase etc 3Item Dispatch columns are ItemID, Date of Dispatch. You can see the coulmn ItemID present in three tables , i want query so that i can know itemid preset in these tables ,pls help me Thanks regards, shashi - DISCLAIMER - This message, along with any attachments, is proprietary to Velankani Information Systems and is intended solely for the use of the individual to whom it is addressed. It may contain privileged or confidential information and should not be circulated or used for any purpose other than for what it is intended. If you have received this message in error, please notify the originator immediately. If you are not the intended recipient, you are notified that you are strictly prohibited from using, copying, altering, or disclosing the contents of this message. Velankani Information Systems accepts no responsibility for loss or damage arising from the use of the information transmitted by this email including damage from virus. -- Velankani Information Systems Ltd, Bangalore, India - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: help with query
* Justin French I have four (relevant) tables: category partner(pid,pname,etc) service(sid,sname,cid) sid2pid(sid,pid) This works fine, listing all services available within a category: SELECT service.sid,service.sname FROM service WHERE cid='3' ORDER BY service.sname ASC eg: Adventure Group Guided Tours Singles Skiing Under 35's But I want to get a count of how many times service.sid is found in the table pid2sid as well... eg: Adventure (0) Group (4) Guided Tours (2) Singles (45) Skiing (0) Under 35's (12) I know I need to include a count(), and select from both service and pid2sid, but other than that, I'm lost :) pid2sid or sid2pid...? ;) You need a JOIN, and because the count could be 0 (zero), you need a LEFT JOIN: SELECT service.sid,service.sname,count(*) FROM service LEFT JOIN pid2sid ON pid2sid.sid = service.sid WHERE cid='3' GROUP BY service.sid,service.sname ORDER BY service.sname ASC ... or with the USING clause: SELECT service.sid,service.sname,count(*) FROM service LEFT JOIN pid2sid USING(sid) WHERE cid='3' GROUP BY service.sid,service.sname ORDER BY service.sname ASC ... and in this case you could even use NATURAL JOIN: SELECT service.sid,service.sname,count(*) FROM service NATURAL LEFT JOIN pid2sid WHERE cid='3' GROUP BY service.sid,service.sname ORDER BY service.sname ASC Note that compared to your original query, I have only added count(*) to the field list, the join, and GROUP BY + [all fields in the field list except group functions, like count()]. All three variants should give the same result, it's the same join, only with different syntax. URL: http://www.mysql.com/doc/en/JOIN.html HTH, -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB is losing records, there are gaps in autoincrementsequence
Hi. - Original Message - InnoDB appears to be losing records. The version I am using is 3.32.53 in Windows 2000. Gaps are appearing in the autoincrement sequence when the application does not permit record deletions. Records disappear although they have been retrieved for printing earlier. We seem to be having the same problem: Even though there is not a single delete statement referencing the table in question from time to time records seem to disappear. I even let mysql do an update log and couldn't find a delete statement there either. Today I found the following article in the mailing list archives: http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:40074 It explains how a REPLACE statement on a table with multiple unique keys might cause more than one row to be deleted. I am not sure if this is definite cause of the disappearing records in my application, but I am going to investigate this further. Regards, Robert. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[Fwd: Bind Variables.]
Hi everybody: I 'm actually having an problem trying to mygrate to mysql. it's true that mysql does not support bind variables ? . Actually the development in my company is over Centura team developer connected to Centura Sqlbase , and the code of the aplications is widely using bind variables . there is a workaround for this ? there is a posibility that in the future releases of mysql bind variables will be supported ?' thanks in advance. Alvaro. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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/InnoDB-3.23.55 is released
Hi! InnoDB is a MySQL table type which supports transactions, foreign key constraints, and a non-free hot backup tool. Version 3.23.55 is a bugfix release of the stable 3.23 branch, which is recommended for production use. Users who have had concurrency problems in INSERT INTO ... SELECT ... FROM t2 ... may benefit from the removing of the MySQL table lock on t2. If you have configured the combined log size 2 GB in a 32-bit computer, you should upgrade because a major bug has been fixed in this version. For more information, please see http://www.innodb.com/ibman.html. The full changelog: * In the SQL command INSERT INTO t1 SELECT ... FROM t2 WHERE ... MySQL previously set a table level read lock on t2. This lock is now removed. * Fixed a bug: if the combined size of InnoDB log files was = 2 GB in a 32-bit computer, InnoDB would write log in a wrong position. That could make crash recovery and InnoDB Hot Backup to fail in log scan. * Fixed a bug: index cursor restoration could theoretically fail. * Fixed a bug: an assertion in btr0sea.c, in function btr_search_info_update_slow could theoretically fail in a race of 3 threads. * Fixed a bug: purge could cause a hang in a BLOB table where the primary key index tree was of height 1. Symptom: semaphore waits caused by an X-latch set in btr_free_externally_stored_field(). * Fixed a bug: if MySQL estimated a query in the middle of a SELECT statement, InnoDB could hang on the adaptive hash index latch in btr0sea.c. * Fixed a bug: InnoDB could report table corruption and assert in page_dir_find_owner_slot() if an adaptive hash index search coincided with purge or an insert. * Fixed a bug: some file system snapshot tool in Windows 2000 could cause an InnoDB file write to fail with error 33 ERROR_LOCK_VIOLATION. In synchronous writes InnoDB now retries the write 100 times at 1 second intervals. * An outstanding bug: SET FOREIGN_KEY_CHECKS=0 is not replicated properly in the MySQL replication. The fix will appear in 4.0.11 and will probably not be backported to 3.23. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.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: Safe to delete duplicate root user? Any users?
You state that you searched the web and the documentation, but did you search the MySQL manual? 4.2 General Security Issues and the MySQL Access Privilege System http://www.mysql.com/doc/en/Privilege_system.html 4.3 MySQL User Account Management http://www.mysql.com/doc/en/User_Account_Management.html And, specifically, read 4.3.5 Adding New Users to MySQL http://www.mysql.com/doc/en/Adding_users.html On Thu, 23 Jan 2003 18:15:00 -0500, Robert K S wrote: I have just set up MySQL and the phpmyadmin script and I would like to add some users and do some other administrative tasks to assure security. Above all, I want to make sure no user (or php script) will have access to any databases without a user name and password. Right now if I look at the list of users, I see: Any hostname root hostname Any localhost root localhost 1. What's the difference between hostname users and localhost users? Why are there two? Is one of them safe to delete? If so, which one (hostname or localhost)? (If it's of any relevance, I only plan on accessing the databases through SSH sessions to the host machine on which the MySQL server is running, and through PHP scripts also running on the same host machine. 2. If there IS a difference, when I create new users, do I need to create two of each? I.e., newuser1 hostname newuser1 localhost 3. What's the deal with the Any users? Why do they exist? Can I delete them? Like I said, I don't want anyone to have access to the databases without a MySQL username and password. I've searched the documentation and the web for answers, but I can't seem to find what I'm looking for. Thanks to you if you can help, and you rock. All the best, Robert K S _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: High list latency?
You mean like your inquiry which took 8:01:27 between the time you sent it and when it hit my mail server? Doug On Thu, 23 Jan 2003 20:44:56 -0800, Jeremy Zawodny wrote: Is anyone else seeing it take 4-8 hours for mail to get thru this list recently? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.8: up 5 days, processed 145,791,837 queries (323/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: InnoDB is losing records, there are gaps in autoincrement sequence
Robert, yes, if there are multiple UNIQUE keys in a table, then in the REPLACE implementation there is a loop which DELETEs all records which have conflicting UNIQUE key values. Since you have kept the binlog of your database, you can rerun the SQL statements and try to find where your rows magically disappear. I am not fond of the REPLACE statement. It is 'implicit programming', which can produce hard-to-find bugs in your application. Similar implicit bugs arise from the use of ON DELETE/UPDATE CASCADE and triggers. Regards, Heikki sql query Subject: Re: InnoDB is losing records, there are gaps in autoincrement sequence From: Robert Wunderer Date: 24 Jan 2003 12:53:04 +0100 Hi. - Original Message - InnoDB appears to be losing records. The version I am using is 3.32.53 in Windows 2000. Gaps are appearing in the autoincrement sequence when the application does not permit record deletions. Records disappear although they have been retrieved for printing earlier. We seem to be having the same problem: Even though there is not a single delete statement referencing the table in question from time to time records seem to disappear. I even let mysql do an update log and couldn't find a delete statement there either. Today I found the following article in the mailing list archives: http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:40074 It explains how a REPLACE statement on a table with multiple unique keys might cause more than one row to be deleted. I am not sure if this is definite cause of the disappearing records in my application, but I am going to investigate this further. Regards, Robert. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to write this query??
If you have the option to change the table structure, just replace the date and time columns with a timestamp column. If you must keep the current structure then the following wil work, but it will not use indexes in the search: select ... where concat(today,' ',heure1) between '2002-01-01 17:00:00' and '2002-01-30 08:00:59'; To allow MySQL to use an index on today, add an extra clause: select ... where today between '2002-01-01' and '2002-01-30' and concat(today,' ',heure1) between '2002-01-01 17:00:00' and '2002-01-30 08:00:59'; The following would also work, and might allow an index scan of an index on (today, heure1): select ... where today between '2002-01-01' and '2002-01-30' and (today '2002-01-01' or heure1 = '17:00:00') and (today '2002-01-30' or heure1 = '08:00:59'); From: Inandjo Taurel [EMAIL PROTECTED] Subject: How to write this query?? Date: Thu, 23 Jan 2003 18:36:40 + hi all, i have a table trans with this structure: today(date) | heure1(time) | amount(double) | client(varchar 30) Now i need to write a query that would take the start date and time, end date and time, and return all the records between the two. So for example, the query should return all records between 01/01/2002 at 17:00 and 01/30/2002 at 08:00. How can i get that query in one query?? SQL SQL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
A sensible way to create indexes!
hi all, i wanted to know how best i could create indexes on a given table. My database is not normalised, so i have a huge transaction table that i used to generate my reports. The thing is that there are at least 5 fields that i can use as indexes in my queries, to speed them up. Do you think it's best to have something like: alter table table_name add key main(field1,field2,field3); or to have individual indexes like these: alter table table_name add key main1(field1); alter table table_name add key main2(field2); alter table table_name add key main3(field3); Which of the two can give me the most efficiency?? _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: insert query
* Murthy how to insert only blank spaces into a field using insert query. Its getting trimmed off. The spaces are automatically trimmed off of CHAR and VARCHAR fields, because they are normally not wanted. You can use TINYTEXT or TEXT to avoid this trimming. URL: http://www.mysql.com/doc/en/String_types.html -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: insert query
Are you using a field of type CHAR or VARCHAR ? You should use a TEXT field instead. According to the documentation (http://www.mysql.com/doc/en/BLOB.html) : There is no trailing-space removal for BLOB and TEXT columns when values are stored, as there is for VARCHAR columns. Hope this helps, -- Joseph Bueno Murthy wrote: how to insert only blank spaces into a field using insert query. Its getting trimmed off. Regards, Murthy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
smallest dumpfiles in Windows in one step?
Good morning everyone, I'm running short on harddrive space on my Windows computer. What's the best way to get the smallest dump file in one step in Windows XP? On my FreeBSD computer, the following command produces an 808MB dumpfile from an 11GB database in one step: mysqldump -q -uusername -p dbname | gzip -c dbname.gz I tried the following in Windows; but stopped mysqldump after the resulting file exceeded 1GB: mysqldump -q -C -uusername -ppassword dbname dbname.dmp Thanks, Andrew Gould __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: insert query
Murthy, how to insert only blank spaces into a field using insert query. Its getting trimmed off. If you are using VARCHAR for this, you're right. It's a documented behaviour of MySQL (Values are not padded; instead, trailing spaces are removed when values are stored. (This space removal differs from the ANSI SQL specification.)): http://www.mysql.com/doc/en/CHAR.html If you need the spaces, you will have to use CHAR. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Murthy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 24, 2003 11:44 AM Subject: insert query how to insert only blank spaces into a field using insert query. Its getting trimmed off. Regards, Murthy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: updating tables
Fabrizio, (still only guessing, as you did not post the table structures ...) i need also to change structure of the master table (have only a primary key) or the changes made on the updatable_table are enough? Your updatable_table needs to have a unique key (best is a primary key), so REPLACE can tell whether it should INSERT a record (if there is no unique key entry) or actually REPLACE an existing record (if there is an entry with this key already). Let's say you have tbl1 with your original data: mysql SELECT * FROM tbl1; ++--+ | id | sometext | ++--+ | 1 | foo | | 2 | bar | | 3 | foofoo | | 4 | barbar | ++--+ 4 rows in set (0.00 sec) Now, you have tbl2 with some data: mysql SELECT * FROM tbl2; ++--+ | id | sometext | ++--+ | 3 | foofoo | | 4 | barbar | ++--+ 2 rows in set (0.00 sec) 'id' in tbl2 needs to be unique (in my case, it's the primary key), so REPLACE will work as expected: mysql REPLACE INTO tbl2 SELECT * FROM tbl1; Query OK, 4 rows affected (0.00 sec) Datensõtze: 4 Duplikate: 2 Warnungen: 0 Note that 4 records were affected, but there were 2 duplicates. The records with id 3 and 4 were overwritten by the REPLACE statement. Now tbl2 has these data: mysql SELECT * FROM tbl2; ++--+ | id | sometext | ++--+ | 1 | foo | | 2 | bar | | 3 | foofoo | | 4 | barbar | ++--+ 4 rows in set (0.01 sec) HTH, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Fabrizio Tivano [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 24, 2003 10:50 AM Subject: Re: updating tables Stefan, The problem look be solved; i've just changed structure of the updatable table. First this table have only 1 primary key, now my table have some indexed unique keys. and now if i do a replace into command look's like to work fine. I have just a question: i need also to change structure of the master table (have only a primary key) or the changes made on the updatable_table are enough? regards, fabrizio On Fri, 24 Jan 2003 00:10:19 +0100 Stefan Hinz, iConnect \(Berlin\) [EMAIL PROTECTED] wrote: Fabrizio, please send the table structures of table_1 and table_2 (DESCRIBE ...) so we can do more for you than just guess what the problem might be. REPLACE seems good in the first place, but if it just INSERTs then there's a problem with the (primary) keys. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Fabrizio Tivano [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 23, 2003 5:22 PM Subject: updating tables hello dear all, i have a problem updating tables: in my queries i try to use REPLACE but is same like INSERT command. ...i need only to refresh table_1 with new entries from table_2. any ideas? TIA fabrizio - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 -- Fabrizio Tivano WAN System Administrator SAD Trasporto Locale S.p.a. Corso Italia 13/N 39100 BOLZANO e-mail : [EMAIL PROTECTED] Tel: +390471450268 Fax: +390471450253 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: My SQL
You can't. The only reason you can get MySQL for OSX is because of it's Unix underpinnings which made it possible to port MySQL to OSX. MySQL would have to be completely rewritten to run under OS9. If you want to use MySQL on a Mac, you need to have at least one OSX box. You could then design a web interface to your database using PHP, Perl or many other things. The OS9 machines would access it through their web browser. On Friday, January 24, 2003, at 01:34 AM, Jonas Rosenbloom wrote: How do I download and install My SQL for Mac OS 9? -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: High list latency?
I noticed a lag yesterday...but simply attributed it to our internal mail setup (which is bad in oh-so-many-ways). Peter ^_^ -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 11:45 PM To: [EMAIL PROTECTED] Subject: High list latency? Is anyone else seeing it take 4-8 hours for mail to get thru this list recently? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.8: up 5 days, processed 145,791,837 queries (323/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: Writing program to communicate with remote internet MySQL server?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Murray -- ...and then M Wells said... % ... % On the other hand, I am generally interested in whether or not it's ... % % Anyone have any thoughts on how this could be achieved? You could always read the mysqld source code and see how it does it :-) HTH HAND mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+MUJJGb7uCXufRwARAnpbAKDlROaUbAyoQADNl2+nsC0LFiYZBwCg3WEb KmvYayALKseFG8qHCSbPcT0= =+dr1 -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: ODBC Driver?
On Friday 24 January 2003 01:29, Jeffrey Powell wrote: I am preparing to migrate a client from using a large MS-ACCESS database to using a linux hosted MySql as the datasource. Or at least I'd like to be able to export tables as a backup. Please tell me where I can get a driver. Take a look at: http://www.mysql.com/downloads/api-myodbc.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: copying innodb data
On Friday 24 January 2003 06:24, kayamboo wrote: I need to move my database from a WindowsNT environment to a Linux RedHat7.0 Box. I am now using innodb tables. Is there any easy way of copying my existing tables in NT Box to Linux? You can use mysqldump utility. For more info check the InnoDB manual: http://www.innodb.com/ibman.html#Moving -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySql Programmer Needed
Looking for someone who is willing to write a mysql script(?) for a website database. The database has been created. Just need someone to write the programming. Will send more information if needed. Doll - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Is this possible?
sub-selects are not yet (to the best of my knowledge) supported in MySQL. =C= * * Cal Evans * Techno-Mage * http://www.calevans.com * - Original Message - From: Frank Peavy [EMAIL PROTECTED] To: Doug Coning [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, January 23, 2003 6:24 PM Subject: Re: Is this possible? I believe a sub-select with the DISTINCT command would do it. You would have to look up the syntax. Also, it seems that some people seem to be having a problem with sub-selects but I don't have any direct experience to convey. At 01:12 PM 1/23/03 -0600, Doug Coning wrote: Is this possible in MySQL without using a temporary table with multiple SQL commands: I am trying to SELECT the results of multiple columns into 1 column or Alias, group them and sort them. So if I had a table with 4 fields: Cat1, Cat2, Cat3, Cat4 like such: +-+--+-+--+ | Cat1| Cat2 | Cat3| Cat4 | +-+--+-+--+ | F | A | | A | | D | C | H | A | | G | | | | | F | B | I | A | +-+--+-+--+ It would select all the values, merge them into 1 column, group them, and sort them like such so that the result would be a single column, returning only 1 instance of each returned value: ++ | Result | ++ | A | | B | | C | | D | | F | | G | | H | | I | ++ Is there as singe Select command that can do this? Right now I am using a temporary table where I first clear out the values, then copy each column one at a time over into the tables... It works, however, I was wondering if there is an easier way to get the single column result with all the merged information without having to use a temporary table... Thanks, Doug Coning - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Writing program to communicate with remote internet MySQL server?
Hi, If i undertsand well you wish to make an application which to synchronization data between your local MySQL with the MySQL which is on the Web Server. I think you must have distinct connection to be able to pass the data from one server to other. I think you can do this with VB(..using ADO-MyODBC) or Perl.I don't know about Python or Ruby if have facility to accesing MySQL using MyODBC or if have something like MySQL database driver. Another option for VB is to use GMySQL (MySQL API for VB).In samples you will find a code which is near with your requirment. You can download it from : http://www.a1vbcode.com/app.asp?ID=1764 I hope it help. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: M Wells [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 24, 2003 11:32 AM Subject: RE: Writing program to communicate with remote internet MySQL server? Hi Gelu, I agree with you, and it's an excellent suggestion. On the other hand, I am generally interested in whether or not it's within my abilities / available toolset to do this, and it would allow me to develop far more specific / personalised 'synchronisation' processes. Anyone have any thoughts on how this could be achieved? Regards and best wishes, Murray Wells -Original Message- From: Gelu Gogancea [mailto:[EMAIL PROTECTED]] Sent: Friday, 24 January 2003 7:24 AM To: Murray Wells; [EMAIL PROTECTED] Subject: Re: Writing program to communicate with remote internet MySQL server? Hi, IMHO: I think the better way is to use replication between your local MySQL server and MySQL from the Web Server. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Murray Wells [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 23, 2003 4:30 PM Subject: Writing program to communicate with remote internet MySQL server? Hello All, For some time I've been wondering if it's possible to write a program that can automatically check my local MySQL server, create a recordset containing any new or updated records found in my local table(s) since the last check, and upload those new / updated records to the MySQL server my web site uses at phpwebhosting.com. My background is VB / VBA, but I also have access to Perl, Python and Ruby. I'm wondering if anyone can tell me if it's possible, using one of these languages, to connect to a remote MySQL server over the internet and to manipulate tables on the remote server as though they were recordset objects, similarly to how you might achieve this on a local server using MyODBC? The end goal is to develop a program I can fire as a Windows XP scheduled task to synchronize the remote database with the local one. Any help appreciated! Regards and best wishes, M Wells - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Is it normal?
Any calculation involving a floating point number will be imprecise. It does not mater what column types are involved. Octavian Rasnita wrote: And does anyone know what column type I should use if I want a precise calculation? I've even tried with text and blob, but they are not working either. Only the int type is precise? Thanks. Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [EMAIL PROTECTED] - Original Message - From: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] To: Octavian Rasnita [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED] Sent: Monday, January 20, 2003 11:42 PM Subject: Re: Is it normal? Octavian, mysql create table test(id float); mysql insert into test values(1.123), (3.1495); mysql select * from test where id=1.123; Empty set (0.00 sec) Shouldn't this last query show me the record that has the id=1.123? Well ... 1.123 is greater than 1.123, see: mysql select id from octavian where id 1.123; ++ | id | ++ | 1.123 | | 3.1495 | ++ 2 rows in set (0.00 sec) Now here's why. Floats are simply not precise: mysql select id*1 from octavian where id 1.123; +-+ | id*1| +-+ | 11230.000257492 | -- | 31494.998931885 | +-+ 2 rows in set (0.00 sec) What query should I use to do this? I leave this one to Paul or one of the other gurus. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Octavian Rasnita [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Monday, January 20, 2003 9:34 AM Subject: Is it normal? Hi all, I've tried the following SQL queries: mysql create table test(id float); Query OK, 0 rows affected (0.00 sec) mysql insert into test values(1.123), (3.1495); Query OK, 2 rows affected (0.01 sec) Records: 2 Duplicates: 0 Warnings: 0 mysql select * from test where id=1.123; Empty set (0.00 sec) Shouldn't this last query show me the record that has the id=1.123? What query should I use to do this? Thank you. Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL in combination with PHP problem
Hi. The below problem isn't realy MySQL problem, but is somehow colegated with MySQL, so please look below ;) I got a task to program a search engine for a site which is all around based on sessions and persistent connections to MySQL. The problem is that I first have to select a subset of those data and then I have to join them all around and output results. I'm using temporary tables for this but there is a problem. Temporary tables are visible trough the entire connection. So in future one browser window can interact (can display) with results from another browser window. Does anyone have a sugestion how to solve this? I was thinking to close a persistent connection (I don't know how???) on each result page at the begining and then reopen it at the end ... for my code I was thinking on using normal connections. Any better idea? I thik I just can't live without temporary tables till I will not have subqueryes. Regards, Dezo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: mysqld getting signal 14
Unfortunately, we cannot - it's a production environment that runs 24 x 7 (telco) and we cannot do this without major difficulty. Is there a general cause of this SIGALRM - is thread 4 significant? Thx, R On Wednesday 22 January 2003 16:34, rick wrote: I'm running mysql 3.23.42 on multiple machines (Solars 8, 32 bit) and on a couple of the machines I see the following in the .err log: .. 030120 9:11:10 Warning: Got signal 14 from thread 4 030120 9:11:10 Warning: Got signal 14 from thread 4 030122 2:20:09 Warning: Got signal 14 from thread 4 030122 2:20:09 Warning: Got signal 14 from thread 4 .. It only occurs on a few machines, although all do the same type of processing. On one machine, mysqld crashed and restarted (it had been running for several months). It's worth noting that on most machines, the .err log is error-free and mysqld has been up for 6-9 months in most cases. What is the cause of this SIGALRM? And it's always thread 4, on every machine that it occurs?. Is this a known bug or problem fixed in a later release (and yes, I went through the list of fixes and did not see this explicitly)? Could you check it on the latest stable version? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RedHat 8 SRC RPM 4.0.9
It doesn't appear to build. This is on a RedHat 8 machine with all current patches applied from RedHat and kernel 2.4.18-19.8.0 Any ideas? # rpmbuild -bb --target i686 mysql-4.0.9-gamma.spec (snip) rm -rf .libs _libs rm -f *.lo rm -f Makefile bdb/Makefile stamp-h stamp-h[0-9]* rm -f config.h rm -f libtool rm -f TAGS ID GTAGS GRTAGS GSYMS GPATH make[1]: Leaving directory `/usr/src/redhat/BUILD/mysql-4.0.9-gamma' rm -f config.status config.cache config.log + mv Docs/manual.ps.save Docs/manual.ps + automake configure.in:7: your implementation of AM_INIT_AUTOMAKE comes from an configure.in:7: old Automake version. You should recreate aclocal.m4 configure.in:7: with aclocal and run automake again. automake: strings/Makefile.am: Assembler source seen but `CCAS' not defined in `configure.in' automake: strings/Makefile.am: Assembler source seen but `CCASFLAGS' not defined in `configure.in' error: Bad exit status from /var/tmp/rpm-tmp.14004 (%build) RPM build errors: Bad exit status from /var/tmp/rpm-tmp.14004 (%build) # rpm -qa | grep -i gcc compat-gcc-c++-7.3-2.96.110 gcc-g77-3.2-7 compat-gcc-7.3-2.96.110 gcc-3.2-7 compat-gcc-java-7.3-2.96.110 gcc-gnat-3.2-7 compat-gcc-objc-7.3-2.96.110 libgcc-3.2-7 gcc-java-3.2-7 compat-gcc-g77-7.3-2.96.110 gcc-objc-3.2-7 gcc-c++-3.2-7 # rpm -qa | grep -i automake automake-1.6.3-1 automake14-1.4p6-3 automake15-1.5-4 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: High list latency?
On Thu, 23 Jan 2003, Jeremy Zawodny wrote: Is anyone else seeing it take 4-8 hours for mail to get thru this list recently? Yes. The message that I sent in yesterday (and that you replied to, which -WORKED-, by the way! Thank you!) was sent at 12:55EST and I got it back from the listserv at 5:51EST. So about 5 hours, yeah. I was watching the phenomenon with amusement by reloading the index on lists.mysql.com and checking my inbox. -j PS- SQL :) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
count in subselect problem
1st problem: SELECT F.id, F.title, F.description, F.created, (select count(*) from forum F, topic T where F.id=T.forum_id AND T.reply_id=0 ) count1, (select count(*) from forum F, topic T where F.id=T.forum_id ) count2 from forum F, topic T where F.id=T.forum_id AND T.reply_id=0 GROUP BY F.id 2nd problem: SELECT T.title, T.id, P.nick, (select count(*) from topic where reply_id = T.reply_id) replies FROM topic T, profile P WHERE T.author_id=P.id AND T.forum_id=1 and reply_id=0; what is wrong with these queries? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: copying innodb data
I need to move my database from a WindowsNT environment to a Linux RedHat7.0 Box. I am now using innodb tables. Is there any easy way of copying my existing tables in NT Box to Linux? Download MySQLFront from: http://mysqlfront.sstienemann.de/ Install it on your windows machine and log in to the MySQL server on your windows machine. Then open another window and log in to your linux box in MySQLFront. Click on the Import/Export option and select Export tables. Select the Another Host/Db option. I hope this works, let me know if you have any other problems. Scott Pippin [EMAIL PROTECTED] (sql, query, mysql) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL/InnoDB-3.23.55 is released
Rogger, - Original Message - From: Rogger Vasquez [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, January 24, 2003 4:43 PM Subject: Re: MySQL/InnoDB-3.23.55 is released How do I upgrade from a previous version of mysql, to the want just released ? I use Innodb tables Correct me if I am wrong, (is the first time I will do a upgrade) 1. Backup Innodb data files a Log Files (COPY THEM) 2. Do I have to copy the file structure from /var/lib/mysql or do I have to dump the DATA with the files definitions 3.Un install the previous version 4. Install the new version using the previous configuration files ? an upgrade of MySQL is normally just that you install the new MySQL binary over the old installation. No conversion of old data files or tables is needed. We will prominently inform users if it ever becomes necessary to convert files in a MySQL upgrade. Thanks in advance ... MySQL, SQL Rogger Best regards, Heikki - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Building MySQL with LinuxThreads
Heya Folkth: I have built mysql (4.0.9) on freebsd (4.7-RELEASE) with linuxthreads (2.2.3) and still encounter the 'strange threading' behavior described in J. Zawodny's blog. Here's the situation... 1/ there are three threads which lock and then write to two different tables...the locks are gotten using 'low_priority write'; the writing threads are continually waiting for locks (i.e two are waiting, one is executing); 2/ I do a select count(*) from one of the tables; Sometimes the select returns pretty quick witht the count; however, frequently the selecting thread will simply hang waiting to get the lock--if I look at the thread in [top] the thread will be taking a LOT of cpu time; if I look at the offending thread in the processlist it has a status of 'waiting for tables'. It's my understanding that the selecting thread should be given the table lock as soon as the writing thread that has the write lock has finished. *All three writing threads keep processing* while the select thread is waiting: I can see their debug output in my terminals. So perhaps this isn't a FreeBSD threading issue? Peter ^_^ -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 6:07 PM To: Jonathan Disher Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Building MySQL with LinuxThreads On Thu, Jan 23, 2003 at 12:55:33PM -0500, Jonathan Disher wrote: I have been trying, for the past two days, to successfully build MySQL 3.23.54 using LinuxThreads on a FreeBSD 5.0-RELEASE SMP box. Unfortunately, I have been unable to get a successful, working build. FWIW, my FreeBSD 4.x LinuxThreads recipie (if you want to call it that) is now on-line. http://jeremy.zawodny.com/blog/archives/000458.html (I've had several requests for it recently.) Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.8: up 4 days, processed 141,294,688 queries (327/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: Bind Variables.]
Hi, With MySQL you can use variables which are represented using @ character. You can not use this variable like in Oracle or DB2 because ,for the moment, MySQL didn't have necessary tools which can handle like bind, this variables. I guess you can make some improvisations to suit at your needs. For example : If you wish to store an entire row(...or selective items from one row) in the one variable and after this to insert in other table: @a:=''; /* initialise the variable a*/ select @a:=CONCAT(FIRST_ITEM,',',SECOND_ITEM,',',THIRD_ITEM...etc) from YOUR_TABLES where SOME_CONDITIONS. insert into other_table values(MID(@,POSITION_OF1-st_ITEM,LENGTH),MID(@,POSITION_2-nd,LENGTH)etc ) Also, this can be replaced very well,if you use INSERT...SELECT statement. Another example which can help you to avoid bind array variable and also to avoid FOREACH() function is: insert into YOUR_TABLES SET YOUR_1-st_FIELD=1-st_ITEM,YOUR_2-nd_FIELD=2-nd_ITEM...etc select IF(1-st_ITEM SOME_FILTERING_CONDITIONS,RETURN_IF_TRUE,RETURN_IF_FALSE)...etc from OTHER_TABLE where CONSTRAINT_CONDITION... I hope it help, Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Alvaro Avello [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 24, 2003 1:54 PM Subject: [Fwd: Bind Variables.] Hi everybody: I 'm actually having an problem trying to mygrate to mysql. it's true that mysql does not support bind variables ? . Actually the development in my company is over Centura team developer connected to Centura Sqlbase , and the code of the aplications is widely using bind variables . there is a workaround for this ? there is a posibility that in the future releases of mysql bind variables will be supported ?' thanks in advance. Alvaro. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Building MySQL with LinuxThreads
To update on the threading problem that I see even with Linuxthreads on FreeBSD... The select thread which isn't given the read lock it requests cycles through the states 'NULL', 'Waiting for tables', 'Locked', 'System Lock', and 'Reopen Tables' from what I've seen so far (there could be more? Also, this problem appears whether I have skip-external-locks or not. Peter ^_^ -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 6:07 PM To: Jonathan Disher Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Building MySQL with LinuxThreads On Thu, Jan 23, 2003 at 12:55:33PM -0500, Jonathan Disher wrote: I have been trying, for the past two days, to successfully build MySQL 3.23.54 using LinuxThreads on a FreeBSD 5.0-RELEASE SMP box. Unfortunately, I have been unable to get a successful, working build. FWIW, my FreeBSD 4.x LinuxThreads recipie (if you want to call it that) is now on-line. http://jeremy.zawodny.com/blog/archives/000458.html (I've had several requests for it recently.) Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.8: up 4 days, processed 141,294,688 queries (327/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: smallest dumpfiles in Windows in one step?
In the last episode (Jan 24), Andrew Gould said: I'm running short on harddrive space on my Windows computer. What's the best way to get the smallest dump file in one step in Windows XP? On my FreeBSD computer, the following command produces an 808MB dumpfile from an 11GB database in one step: mysqldump -q -uusername -p dbname | gzip -c dbname.gz I tried the following in Windows; but stopped mysqldump after the resulting file exceeded 1GB: mysqldump -q -C -uusername -ppassword dbname dbname.dmp You can get gzip for windows at http://www.gzip.org/#exe . That will let you use the same commandline as you used on the FreeBSD system. -- Dan Nelson [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: insert query
Stefan Hinz, iConnect (Berlin) wrote: Murthy, how to insert only blank spaces into a field using insert query. Its getting trimmed off. If you are using VARCHAR for this, you're right. It's a documented behaviour of MySQL (Values are not padded; instead, trailing spaces are removed when values are stored. (This space removal differs from the ANSI SQL specification.)): http://www.mysql.com/doc/en/CHAR.html BTW, why is this? - Cs. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
question about date range
Hi, I inherited a db that has a varchar(30) column that holds a date/time stamp in the form of MMDDHHmmss (ex: 20030124093952) Well I want to select a range based on the first 8 characters(MMDD). I currently select a single day by select * from orderheader where orderid like '$date' ; The $date variable equals 20030124% What can I do to get this range selection query to work? Thanks, Chuck Barnett - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Storeing images in Database
Hello community !!! The software house on i'm work want to store images ( TIF FILES +/- 100kb compressed with gzip ) on database... using InnoDB database... ( files or raw devices ) The discussion is : - The innodb ( or myisam ) is sufficient robust to allow store 10.000.000 images ( with 100kb ) without problems ( corrupt or fail ) ? - If is sufficient robust , the speed to join and get images from database is not slow ( slow for me is 2 seconds )? - The best solution is store images in files ( ex : c:\images\img00.tif) or database ? The responses and experience of all community is very welcome ! special for Heikki and Monty , what do you think ? store in files or in database ? Please it is very important for my software house !!! my preference is into database... but i'm afraid the volume is big... MySQL version: 4.0.9 Table Type : InnoDB Operation System : Windows ( 98/ME/NT ) and Linux ( 2.4 ) Disk Types : IDE and SCSI ( depend of volume ) sql,query,urgent,hehe - ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento - E S C R I B A I N F O R M A T I C A - The only stupid question is the unasked one (somewhere in Linux's HowTo) Linux registred user : #230601 -- $ look into my eyes Phone : +55 041 296-2311 r.112 look: cannot open my eyes Fax : +55 041 296-6640 - Reply: [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: MySql Programmer Needed
i can help you if you want tel me what do you need exactly On Fri, 24 Jan 2003 08:55:04 -0500 Doll Hargrove [EMAIL PROTECTED] wrote: Looking for someone who is willing to write a mysql script(?) for a website database. The database has been created. Just need someone to write the programming. Will send more information if needed. Doll - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
BUG:ALTER TABLE (MySQL 4.1)
Hi, I guess is as a bug in ALTER TABLE with MySQL 4.1,compiled from BK TREE on 2003-01-22. Table schema : CREATE TABLE cmdlivrare(IDCMD INT(9) NOT NULL PRIMARY KEY DEFAULT 2000,mUser CHAR(16),Dep CHAR(4),IDCLI INT(16),FactExt CHAR(20),LivrFinish SMALLINT(1),DataIntro DATE,DataIese DATE,INDEX(Dep),INDEX(FactExt),INDEX(IDCLI),INDEX(mUser),INDEX(LivrFinish),I NDEX(DataIntro),INDEX(DataIese)); I wish to alter this table and modify the definition of IDCMD to IDCMD INT(9) AUTO_INCREMENT NOT NULL PRIMARY KEY DEFAULT 3 For this i do : alter table cmdlivrare modify IDCMD INT(9) AUTO_INCREMENT NOT NULL PRIMARY KEY DEFAULT 3; MySQL daemon got signal 11. MySQL log said: = mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=402653184 read_buffer_size=2093056 sort_buffer_size=2097144 max_used_connections=0 max_connections=100 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 802415 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x865b0a0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xbe7fd6f8, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x8114078 0x40039951 0x816785a 0x8167167 0x81807ac 0x8182370 0x8121257 0x8124c45 0x811f8a7 0x811f4fe 0x811ee79 0x4003376e 0x402687da New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x865e3c8 = alter table cmdlivrare modify IDCMD INT(9) AUTO_INCREMENT NOT NULL PRIMARY KEY DEFAULT 3 thd-thread_id=1 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 1 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid. The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash. = resolve_stack_dump succesfully does : 0x8114078 handle_segfault + 416 0x40039951 _end + 936099857 0x816785a _Z11pack_fieldsiR4ListI12create_fieldE + 170 0x8167167 _Z16rea_create_tableP3THDPcP24st_ha_create_informationR4ListI12create_fieldE jP6st_key + 883 0x81807ac _Z18mysql_create_tableP3THDPKcS2_P24st_ha_create_informationR4ListI12create_ fieldERS5_I3KeyEbbj + 2500 0x8182370 _Z17mysql_alter_tableP3THDPcS1_P24st_ha_create_informationP13st_table_listR4 ListI12create_fieldERS6_I3KeyERS6_I10Alter_dropERS6 + 2736 0x8121257 _Z21mysql_execute_commandP3THD + 2803 0x8124c45 _Z11mysql_parseP3THDPcj + 221 0x811f8a7 _Z16dispatch_command19enum_server_commandP3THDPcj + 879 0x811f4fe _Z10do_commandP3THD + 110 0x811ee79 handle_one_connection + 813 0x4003376e _end + 936074798 0x402687da _end + 938389146 I has the bad inspiration to compile without debug option.I try to recompile now and i will try to study to see what happened. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [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
Bug: MYSQL_FIELD-flags indicates NOT NULL with aggregates
This looks like it was generated using mysqlbug, but actually I took another post and pasted in the values. Description: The mysql_fetch_field() function returns a MYSQL_FIELD structure with the flags field set to a value including NOT_NULL_FLAG even if the field is an aggregate, if that aggregate is on the primary key. If there are no rows in the table, then MAX(pri_key_column) will return NULL. However, the MYSQL_FIELD structure will indicate that the MAX(pri_key_column) field does not allow NULL. If the column is not a primary key, but is NOT NULL, then the MYSQL_FIELD flags will correctly indicate that the aggregate can allow NULL. How-To-Repeat: In MySQL: CREATE TABLE foo (bar int PRIMARY KEY); In C: MYSQL *cnn = mysql_init(NULL); mysql_real_connect(cnn, NULL, NULL, NULL, test, 0, NULL, 0); const char* select_query = SELECT MAX(bar) FROM foo; mysql_query(cnn, select_query); MYSQL_RES* res = mysql_store_result(cnn); MYSQL_FIELD* fld = mysql_fetch_field(res); char* name = strdup(fld-name); bool isNotNull = ((fld-flags NOT_NULL_FLAG) 0); printf(column `%s`: notnull=%d\n, name, isNotNull); MYSQL_ROW row = mysql_fetch_row(res); printf(value: %s, row[0] ? row[0] : NULL); mysql_close(cnn); Fix: None. Originator:Matt Solnit Organization: Iteration Software, Inc. http://www.iteration.com Release: mysql-4.0.9-gamma (Binary distribution) Environment: System: Windows XP Professional Architecture: Pentium IV - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: crash-me
quick crash-me question the web page lists several numbers for the performance of several databases ( MySQL sybase access). The one I'm most insterested in is max table row length What does that number symbolize? The maximum number of bytes in a row? the max number of rows? what? It says that Access only supports 2025. 2025 what? rows in a table? bytes in a row? Thanks -- --- Geoffrey Greene [EMAIL PROTECTED] Autometric Inc 703 923 4152 --- -- --- Geoffrey Greene [EMAIL PROTECTED] Autometric Inc 703 923 4152 --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Writing program to communicate with remote internet MySQL server?
Absolutely it is possible (With cavaets). The cavaets are... 1. Does you web hosting company allow external access to your MySQL database. I do not know for sure but it looks like they might (telnet works to port 3306). 2. Is your Mysql user set up to allow external access. 3. If you are going to try to synchronize the tables yourself. Not an easy task. My 3 suggestions to you for this are: a. Whenever your application changes the database, log the changes to a separate table. (Not really reliable since you can change the tables in the MySQL client program that would never get logged). b. Write a program that checks every record in the 2 seperate database, making changes when you find them. (not very fast). c. Turn on the bin-log on your local server, then issue the same commands to the remote server. (Most definately the way to go.) As for your question on how to do it on the remote server. Since you are already familiar with VB/MyODBC the that is definately the way to go. Just create a separate DSN for the remote server and use whatever tool you are familiar with to do the updates. Hope this helps. Roger -Original Message- From: M Wells [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 9:32 AM To: [EMAIL PROTECTED] Subject: Writing program to communicate with remote internet MySQL server? Hello All, For some time I've been wondering if it's possible to write a program that can automatically check my local MySQL server, create a recordset containing any new or updated records found in my local table(s) since the last check, and upload those new / updated records to the MySQL server my web site uses at phpwebhosting.com. My background is VB / VBA, but I also have access to Perl, Python and Ruby. I'm wondering if anyone can tell me if it's possible, using one of these languages, to connect to a remote MySQL server over the internet and to manipulate tables on the remote server as though they were recordset objects, similarly to how you might achieve this on a local server using MyODBC? The end goal is to develop a program I can fire as a Windows XP scheduled task to synchronize the remote database with the local one. Any help appreciated! Regards and best wishes, M Wells - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
HELP : SQL command parser broken
I compiled and installed mysql-max-3.23.51. Installation process seems to go fine. When I go to run mysql_install_db however, I get the following error : ERROR : 1064 use mysql; syntax error I try starting mysqld without grant tables - and I can. However, when I connect via a client, none of the sql commands are accepted. It simply says ERROR : 1064 : Syntax error. The only thing I can do is use mysql; If I try to CREATE DATABASE name; I get ERROR : 1064 : Syntax error at DATABASE name; I am getting really frustrated. Can someone help me. Attached is my.cnf that I am using . # Example mysql config file for small systems. # # This is for a system with little memory (= 64M) where MySQL is only used # from time to time and it's important that the mysqld deamon # doesn't use much resources. # # You can copy this file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /var/sendmail/mysql) or # ~/.my.cnf to set user-specific options. # # One can in this file use all long options that the program supports. # If you want to know which options a program support, run the program # with --help option. # The following options will be passed to all MySQL clients [client] #password = your_password port= 3306 socket = /var/slms/slms-mysql/slms-mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port= 3306 socket = /var/slms/slms-mysql/slms-mysql/mysql.sock skip-locking set-variable= max_connections=50 set-variable= key_buffer=51M set-variable= max_allowed_packet=1M set-variable= table_cache=512 set-variable= sort_buffer=2048K set-variable= record_buffer=2048K set-variable= net_buffer_length=16K set-variable= myisam_sort_buffer_size=32M # Try number of CPU's*2 for thread_concurrency set-variable= thread_stack=128K set-variable= thread_cache_size=16 set-variable= thread_concurrency=2 log-bin server-id = 1 # Uncomment the following if you are using Innobase tables innodb_data_home_dir = innodb_data_file_path = /var/slms/slms-mysql/slms-mysql/ibdata/ibdata1:100M:autoextend innodb_log_group_home_dir = /var/slms/slms-mysql/slms-mysql/ibdata innodb_log_arch_dir = /var/slms/slms-mysql/slms-mysql/ibdata set-variable = innodb_mirrored_log_groups=1 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=76M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit = 1 innodb_log_archive = 0 set-variable = innodb_buffer_pool_size=512M set-variable = innodb_additional_mem_pool_size=2M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] set-variable= key_buffer=32M set-variable= sort_buffer=32M set-variable= read_buffer=2M set-variable= write_buffer=2M [myisamchk] set-variable= key_buffer=32M set-variable= sort_buffer=32M set-variable= read_buffer=2M set-variable= write_buffer=2M [mysqlhotcopy] interactive-timeout Here are the config args CC=gcc CFLAGS=-O3 -fno-omit-frame-pointer CXX=gcc CXXFLAGS=-O3 \ -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti ./configure \ --prefix=/usr/local/sendmail/slms-mysql-1.0/mysql \ --localstatedir=/var/slms/slms-mysql \ --with-unix-socket-path=/var/slms/slms-mysql-1.0/mysql.sock \ --enable-local-infile \ --enable-assembler \ --disable-shared \ --with-extra-charsets=complex \ --with-server-suffix=-max \ --with-innodb \ --enable-thread-safe-client \ --with-named-curses-libs=-lcurses --program-prefix=-max' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: RE: MySQL in combination with PHP problem
I'm using temporary tables for this but there is a problem. Temporary tables are visible trough the entire connection. So in future one browser window can interact (can display) with results from another browser window. Does anyone have a sugestion how to solve this? You could do something like: drop table tmp1 if exists; create temporary table tmp1... At some point MySQL was going to change the call to change the user to also reset the connection to a default state (this would drop the temp table, rollback uncommitted transactions, etc.). I imagine this is done on the server side. Does 4.0.9 support this? If so, I can produce a patch to fix PHP to use it. I sent it a long time ago, but you know how things are... -steve- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: BUG:ALTER TABLE (MySQL 4.1)
...like usually i forget some details: Table type is MyISAM and was created with MySQL ver 3.23.47 But if i create the table with ver.4.1 the behaviour is the same. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Gelu Gogancea [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, January 24, 2003 8:49 PM Subject: BUG:ALTER TABLE (MySQL 4.1) Hi, I guess is as a bug in ALTER TABLE with MySQL 4.1,compiled from BK TREE on 2003-01-22. Table schema : CREATE TABLE cmdlivrare(IDCMD INT(9) NOT NULL PRIMARY KEY DEFAULT 2000,mUser CHAR(16),Dep CHAR(4),IDCLI INT(16),FactExt CHAR(20),LivrFinish SMALLINT(1),DataIntro DATE,DataIese DATE,INDEX(Dep),INDEX(FactExt),INDEX(IDCLI),INDEX(mUser),INDEX(LivrFinish),I NDEX(DataIntro),INDEX(DataIese)); I wish to alter this table and modify the definition of IDCMD to IDCMD INT(9) AUTO_INCREMENT NOT NULL PRIMARY KEY DEFAULT 3 For this i do : alter table cmdlivrare modify IDCMD INT(9) AUTO_INCREMENT NOT NULL PRIMARY KEY DEFAULT 3; MySQL daemon got signal 11. MySQL log said: = mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=402653184 read_buffer_size=2093056 sort_buffer_size=2097144 max_used_connections=0 max_connections=100 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 802415 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x865b0a0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xbe7fd6f8, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x8114078 0x40039951 0x816785a 0x8167167 0x81807ac 0x8182370 0x8121257 0x8124c45 0x811f8a7 0x811f4fe 0x811ee79 0x4003376e 0x402687da New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x865e3c8 = alter table cmdlivrare modify IDCMD INT(9) AUTO_INCREMENT NOT NULL PRIMARY KEY DEFAULT 3 thd-thread_id=1 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 1 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid. The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash. = resolve_stack_dump succesfully does : 0x8114078 handle_segfault + 416 0x40039951 _end + 936099857 0x816785a _Z11pack_fieldsiR4ListI12create_fieldE + 170 0x8167167 _Z16rea_create_tableP3THDPcP24st_ha_create_informationR4ListI12create_fieldE jP6st_key + 883 0x81807ac _Z18mysql_create_tableP3THDPKcS2_P24st_ha_create_informationR4ListI12create_ fieldERS5_I3KeyEbbj + 2500 0x8182370 _Z17mysql_alter_tableP3THDPcS1_P24st_ha_create_informationP13st_table_listR4 ListI12create_fieldERS6_I3KeyERS6_I10Alter_dropERS6 + 2736 0x8121257 _Z21mysql_execute_commandP3THD + 2803 0x8124c45 _Z11mysql_parseP3THDPcj + 221 0x811f8a7 _Z16dispatch_command19enum_server_commandP3THDPcj + 879 0x811f4fe _Z10do_commandP3THD + 110 0x811ee79 handle_one_connection + 813 0x4003376e _end + 936074798 0x402687da _end + 938389146 I has the bad inspiration to compile without debug option.I try to recompile now and i will try to study to see what happened. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [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
Re: Is this possible?
On Fri 2003-01-24 at 07:59:16 -0600, [EMAIL PROTECTED] wrote: sub-selects are not yet (to the best of my knowledge) supported in MySQL. To be a bit more precise: They are not supported in any stable release of MySQL. They are going to be supported in Version 4.1, which is still declared alpha. Most basic and not-so-basic tests already work fine, AFAICS. HTH, Benjamin. -- [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: copying innodb data
Hello folks I need to move my database from a WindowsNT environment to a Linux RedHat7.0 Box. I am now using innodb tables. Is there any easy way of copying my existing tables in NT Box to Linux? 1. Download MysqlFront from http://mysqlfront.sstienemann.de/ 2. Install on Windows machine. Open a connection window to both your windows MySQL server and your Linux MySQL server. 3. Click on the import/export menu and select export tables. 4. click on the Another Host/db option and select you Linux MySQL Server, then copy the tables over. This worked a lot better for me than mysqldump. The larger tables seemed to transfer faster than with mysqldump. Let me know if you have any other questions. Scott Pippin [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:Re: Is it normal?
use double with specific precision like create table b (id double (5, 3)); then: insert into b values (1.123, 3.14); and then select * from b where id 1.123; shows only one record (3.14). select * from b where id 1.123; empty set. select * from b where id = 1.123; returns a result table with one record 1.123. -- Octavian Rasnita [EMAIL PROTECTED] writes: Return-Path: [EMAIL PROTECTED] Received: from mx09.lax.untd.com (mx09.lax.untd.com [10.130.24.69]) by maildeliver04.nyc.untd.com with SMTP id AAA9DCAFXAKM8WJA for [EMAIL PROTECTED] (sender [EMAIL PROTECTED]); Fri, 24 Jan 2003 04:00:37 -0500 (EST) Received: from web.mysql.com (web.mysql.com [213.136.49.183]) by mx09.lax.untd.com with SMTP id AAA9DCAFWAP7ZG5J for [EMAIL PROTECTED] (sender [EMAIL PROTECTED]); Fri, 24 Jan 2003 01:00:36 -0800 (PST) Received: (qmail 11889 invoked by uid 7797); 24 Jan 2003 04:49:19 - Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org) List-ID: mysql.mysql.com Precedence: bulk List-Help: mailto:[EMAIL PROTECTED] List-Unsubscribe: mailto:[EMAIL PROTECTED] List-Post: mailto:[EMAIL PROTECTED] List-Subscribe: mailto:[EMAIL PROTECTED] Delivered-To: mailing list [EMAIL PROTECTED] Received: (qmail 11871 invoked from network); 24 Jan 2003 04:49:19 - Message-ID: 002901c2c364$59877270$[EMAIL PROTECTED] From: Octavian Rasnita [EMAIL PROTECTED] To: Stefan Hinz, iConnect \(Berlin\) [EMAIL PROTECTED], MySQL [EMAIL PROTECTED] References: 006101c2c09a$9c0f7330$[EMAIL PROTECTED] 01e601c2c0ce$1a5cf1d0$dc4fc7d9@mephisto Subject: Re: Is it normal? Date: Thu, 23 Jan 2003 22:13:07 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600. X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600. And does anyone know what column type I should use if I want a precise calculation? I've even tried with text and blob, but they are not working either. Only the int type is precise? Thanks. Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [EMAIL PROTECTED] - Original Message - From: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] To: Octavian Rasnita [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED] Sent: Monday, January 20, 2003 11:42 PM Subject: Re: Is it normal? Octavian, mysql create table test(id float); mysql insert into test values(1.123), (3.1495); mysql select * from test where id=1.123; Empty set (0.00 sec) Shouldn't this last query show me the record that has the id=1.123? Well ... 1.123 is greater than 1.123, see: mysql select id from octavian where id 1.123; ++ | id | ++ | 1.123 | | 3.1495 | ++ 2 rows in set (0.00 sec) Now here's why. Floats are simply not precise: mysql select id*1 from octavian where id 1.123; +-+ | id*1| +-+ | 11230.000257492 | -- | 31494.998931885 | +-+ 2 rows in set (0.00 sec) What query should I use to do this? I leave this one to Paul or one of the other gurus. Regards, -- Stefan Hinz [EMAIL PROTECTED] Gesch䦴sf��r / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Octavian Rasnita [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Monday, January 20, 2003 9:34 AM Subject: Is it normal? Hi all, I've tried the following SQL queries: mysql create table test(id float); Query OK, 0 rows affected (0.00 sec) mysql insert into test values(1.123), (3.1495); Query OK, 2 rows affected (0.01 sec) Records: 2 Duplicates: 0 Warnings: 0 mysql select * from test where id=1.123; Empty set (0.00 sec) Shouldn't this last query show me the record that has the id=1.123? What query should I use to do this? Thank you. Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Re: smallest dumpfiles in Windows in one step?
Andrew, Good morning everyone Thanks for your optimism. It's 5 o'clock in the afternoon, here in Berlin ;) I tried the following in Windows; but stopped mysqldump after the resulting file exceeded 1GB: mysqldump -q -C -uusername -ppassword dbname dbname.dmp Well, Unix seems to be so much better in many ways as you can do modularized things like mysqldump -q -uusername -p dbname | gzip -c dbname.gz But this won't help you too much. Here's how I solved the problem of backing up my MySQL databases on a Win2K box at home to a Linux box in my office. A mysqldump of all my databases will only produce about 50 MB of SQL, so maybe this solution isn't suitable for you. On the other hand, I have only 128 MBit upstream from my Win machine, and maybe you will have a faster network connection. I use: c:\mysql\bin mysqldump --all-databases --add-drop-table mysql -h myoffice -u username -p This will take some time, and it's most probably not the smartest thing one could do, but it works nicely. HTH, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Andrew Gould [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 24, 2003 1:47 PM Subject: smallest dumpfiles in Windows in one step? Good morning everyone, I'm running short on harddrive space on my Windows computer. What's the best way to get the smallest dump file in one step in Windows XP? On my FreeBSD computer, the following command produces an 808MB dumpfile from an 11GB database in one step: mysqldump -q -uusername -p dbname | gzip -c dbname.gz I tried the following in Windows; but stopped mysqldump after the resulting file exceeded 1GB: mysqldump -q -C -uusername -ppassword dbname dbname.dmp Thanks, Andrew Gould __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Windows InnoDB
Is the InnoDB table type available on Windows? Darren Young [EMAIL PROTECTED] mysql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
order by birthday not year
Hi, I want to use the order by clause to list the birthday field by the birthday not year. How do i do this? example birthday=1972/02/14 How do i tell mysql to order by the day (14) only so that I can list same birthday in a month in acending order. Thanks -- Mike Doanh Tran Shuffle Master Inc. Website: http://internal.shufflemasterrd.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: query cache not working with alter table rename as...
Thank you very much for the speedy response. Because of your positive attitude I'm going to try and talk my boss into purchasing a few MySQL licences to help you with development. (the query caching has effectively helped us to reduce hardware costs as 65% of our queries are coming out of memory and not hitting the disks (and I'm talking about thousands of queries per second)). Thanks again, Andrew Sql,query -Original Message- From: Sanja Byelkin [mailto:[EMAIL PROTECTED]] Sent: 23 January 2003 23:56 To: Andrew Braithwaite Cc: [EMAIL PROTECTED] Subject: query cache not working with alter table rename as... Hi! Thank you for bugreport. This bug is fixed now. Here is patch for it: diff -Nrc a/sql/sql_table.cc b/sql/sql_table.cc *** a/sql/sql_table.cc Fri Jan 24 01:54:55 2003 --- b/sql/sql_table.cc Fri Jan 24 01:54:55 2003 *** *** 1432,1437 --- 1432,1439 } send_ok(thd-net); } + table_list-table=0; // For query cache + query_cache_invalidate3(thd, table_list, 0); DBUG_RETURN(error); } -- Regards, Alexander - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 3.23.5x documentation
Helloo people, I am looking for a Windows help file (.*hlp or .*chm) or PDF file with the MySQL manual for version 3.23.5x. Also i would like the HTML version with multiple HTML files (tar.gz). I have been looking on the MySQL website, but everything is version 4.0.x . Can anyone help me with this or knows where to download these files. I`ve tried google, but unsuccesfull I would prefer a recent version 3.23.5x whatever. Thanks alot ppl, Best regards, Davy Obdam mailto:[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
Help with unsubscribing.
Query. How can I unsubscribe? I tried it according to the website, but it didn't work. Thanks in advance, Phil __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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
Fixed table format with VARCHAR
Dear gurus, does someone have background information on the following problem (How does MySQL do this?): CREATE TABLE myisamFixed (col VARCHAR(10)) TYPE=MyISAM ROW_FORMAT=FIXED; CREATE TABLE myisamDynamic (col CHAR(10)) TYPE=MyISAM ROW_FORMAT=DYNAMIC; SHOW TABLE STATUS LIKE 'myisam%'; +--+++ | Name | Type | Row_format | +--+++ | myisamDynamic| MyISAM | Dynamic| | myisamFixed | MyISAM | Fixed | +--+++ Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
GPL online backup for innodb tables
Greetings! I would like to know whether in MySQL I can do an online (hot) backup of innodb type tables using a 'free' (GPL) tool. Or even if it is possible by writing my own shell script as you can do in Oracle with: alter tablespace tablespace_name_1 begin backup; then use cp to copy the tablespace file alter tablespace tablespace_name_1 end backup; alter tablespace tablespace_name_2 begin backup; and so on for all tablespaces. Thanks in advance. Enrico -- Enrico Indiogine Systems Analyst Information Systems Eastern New Mexico University - Roswell 505-624-7493 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Client History
Where does the mysql client store the query history information? I'm referring to the information that it pulls up when you hit the up or down arrow keys. There was a rather complex query that I came up with a while ago and don't feel like 'up arrowing' all night... Thanks, Darren Young mysql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Rollback problem
Hi! I've got the following problem with Version 4.0.9 of Mysql: The page http://www.mysql.com/doc/en/COMMIT.html says: 'If you do a ROLLBACK when you have updated a non-transactional table you will get an error (ER_WARNING_NOT_COMPLETE_ROLLBACK) as a warning. All transactional safe tables will be restored but any non-transactional table will not change.' When I change both, an InnoDB table and a MyISAM table there is no table restored; not even the InnoDB table. Maybe there is an obvious error in my testing, maybe an error in Mysql. Please tell me. :o) You can find a detailed log at http://www.phlybye.de/sql.txt . Thanks, bye, Philipp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mod_Auth_MySQL for Apache 2 and Windows?
Just wondering whether anyone had a working, compiled mod_auth_mysql module for doing basic auth against a MySQL database on a Windows system (XP to be exact). If not, has anyone ever compiled one on Windows? I found one for Apache 2.0.43 at this site: http://www.pcp-computer.de/gkn/apache/httpd-2.0/win32/modules/ but it only crashes the Apache server. (Other people have had the same problem with this version as well.) -- Guy Davis Phone: (403) 301-3426 Fax: (403) 301-3499 Pason Systems Calgary, AlbertaCanada Digitally signed by GnuPG (DSA ID 759A998E at www.keyserver.net) PGP Fingerprint: F685 97D0 0FC6 F016 E9EB CCD3 F183 1BC7 759A 998E - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mod_Auth_MySQL for Apache 2 and Windows?
Just wondering whether anyone had a working, compiled mod_auth_mysql module for doing basic auth against a MySQL database on a Windows system (XP to be exact). If not, has anyone ever compiled one on Windows? I found one for Apache 2.0.43 at this site: http://www.pcp-computer.de/gkn/apache/httpd-2.0/win32/modules/ but it only crashes the Apache server. (Other people have had the same problem with this version as well.) -- Guy Davis http://www.guydavis.caCalgary, Alberta, Canada Digitally signed by GnuPG (DSA ID 30D52F0B at www.keyserver.net) PGP Fingerprint: 8DC8 4A6F C1AD 393B 39DB CDBF 196D 31D0 30D5 2F0 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Need nulls in my join
I have an SQL query that LEFT JOINs four different tables to a main table, based on several foreign keys. It's returning only stories in a section that have photos, but I need it to return all the stories in a section whether it has a photo or not. I think the problem is in the WHERE evtphoto.phtusage = 1 -- if there's no photo, then there's no phtusage. Should I split this up into two queries, to get all the story IDs for a section/day and then get the photos for the stories in a 2nd query? Or do I need a different join type? Or do I put the WHERE clauses in a different order? Here's the query: SELECT evtstorysection.secid, evtstory.styid, evtstory.styheadline, evtstory.stysummary, evtstory.styintro, evtstory.stypubdate, evtphoto.phturl, evtphoto.phtcaption, evtstoryorder.stoorder, evtlayoutsum.lytstring FROM evtstory LEFT JOIN evtlayoutsumON evtstory.slytid = evtlayoutsum.lytid LEFT JOIN evtstorysection ON evtstory.styid = evtstorysection.styid LEFT JOIN evtstoryorder ON evtstory.styid = evtstoryorder.styid LEFT JOIN evtphotoON evtstory.styid = evtphoto.styid WHERE evtphoto.phtusage = 1 AND evtstorysection.secid = 3 AND evtstoryorder.secid = 3 AND evtstoryorder.stodate = '2003-01-24' AND evtstory.stypubdate = '2003-01-24' AND evtstory.styexpdate '2003-01-24' ORDER BY evtstoryorder.stoorder - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Storeing images in Database
Hello community !!! The software house on i'm work want to store images ( TIF FILES +/- 100kb compressed with gzip ) on database... using InnoDB database... ( files or raw devices ) The discussion is : - The innodb ( or myisam ) is sufficient robust to allow store 10.000.000 images ( with 100kb ) without problems ( corrupt or fail ) ? - If is sufficient robust , the speed to join and get images from database is not slow ( slow for me is 2 seconds )? - The best solution is store images in files ( ex : c:\images\img00.tif) or database ? The responses and experience of all community is very welcome ! special for Heikki and Monty , what do you think ? store in files or in database ? Please it is very important for my software house !!! my preference is into database... but i'm afraid the volume is big... MySQL version: 4.0.9 Table Type : InnoDB Operation System : Windows ( 98/ME/NT ) and Linux ( 2.4 ) Disk Types : IDE and SCSI ( depend of volume ) sql,query,urgent,hehe Since you obviously aren't going to search the images themselves there is no reason to put them into a database. File systems are designed for this. I might suggest using an Id field and then split them into subdirectories based on the 1st or last digit of the ID (0..9). This would reduce the number of files in a given directory which can be a problem with VERY large numbers of files. You can also put them on a totally differnet drive from the database data to increase performance. The cost is bit of setup (have to create the directories) and programming. This should allow the database rows to be uniform in size which should help performance. William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Slave on same machine?
Hi, I know, it sounds a bit like a stupid question, but can I run a slave mysqld server on the same machine? The idea of just running a slave for the purpose of bringing it down, each night, to make a backup, is quite appealing. I now use the hotcopy method. Thanks! - 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: BUG:ALTER TABLE (MySQL 4.1)
Hi! On Jan 24, Gelu Gogancea wrote: Hi, I guess is as a bug in ALTER TABLE with MySQL 4.1,compiled from BK TREE on 2003-01-22. Table schema : CREATE TABLE cmdlivrare(IDCMD INT(9) NOT NULL PRIMARY KEY DEFAULT 2000,mUser CHAR(16),Dep CHAR(4),IDCLI INT(16),FactExt CHAR(20),LivrFinish SMALLINT(1),DataIntro DATE,DataIese DATE,INDEX(Dep),INDEX(FactExt),INDEX(IDCLI),INDEX(mUser),INDEX(LivrFinish),I NDEX(DataIntro),INDEX(DataIese)); I wish to alter this table and modify the definition of IDCMD to IDCMD INT(9) AUTO_INCREMENT NOT NULL PRIMARY KEY DEFAULT 3 For this i do : alter table cmdlivrare modify IDCMD INT(9) AUTO_INCREMENT NOT NULL PRIMARY KEY DEFAULT 3; No crash for me on a recent bk tree (Jan 24, that is). Try a fresh pull. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php