myisamchk: Can't unlock file (Errcode: 11)
Hi, I am using mysql 4.0.0-aplha on win 2000 professional. I install mysql in c:\mysql. I write a script ( customerscript.txt) and i save this script in c:\mysql\bin. The contents of customerscript.txt I will paste at the bottom of this mail. Then,I run my script at the command prompt. C:\mysql\bin>mysql < customerscript.txt And later on I try to check the table using the command below. And I get the error and warning. C:\mysql\bin>myisamchk ../data/test/customer Checking MyISAM file: ../data/test/customer Data records: 1 Deleted blocks: 0 myisamchk: warning: 1 clients is using or hasn't closed the table properly - check file-size - check key delete-chain - check record delete-chain - check index reference - check data record references index: 1 myisamchk: Can't unlock file (Errcode: 11) - check record links myisamchk: error: 11 when locking indexfile '../data/test/customer' Can anybody tell me what actually is this error? ** customerscript.txt ** use test; create table customer( id integer not null auto_increment primary key, name varchar(20), address varchar(150) ); insert into customer (id,name,address) values (null,'Good customer','Good customer address'); quit ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 code 28: No space left on device
Hi, What will happen on Error code 28: No space left on device? Will mysql crash down?... Will there be posibility of reading data from tables? Best Regards, -- Jarek - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with BLOB field
--- Egor Egorov <[EMAIL PROTECTED]> wrote: > deep, > Thursday, August 08, 2002, 4:08:22 PM, you wrote: > > dk> It looks like a simple bug but I have spent lots > of > dk> hours try to solved it but not success yet. > > dk> Application: Visual Basic 6.0 > dk> Database used: MySQL 4.0.1 & MySQL 4.0.2 > dk> ODBC: MyODBC 3.51.03 > > dk> I have created a table which contains the BLOB > field > dk> for storing images, but when I create a > recordset on > dk> that table and check the DefinedSize property of > that > dk> field it returns 64K which means I cannot store > images > dk> bigger than 64K. > > Table Structure --> > dk> CREATE TABLE Attachment > dk> ( > dk> AttachmenId INT AUTO_INCREMENT NOT NULL PRIMARY, > dk> AttachmentName VARCHAR(255), > dk> Attachment BLOB > dk> )TYPE = InnoDB > > It's not a bug, 64K is the maximum size of BLOB :) > Use LONGBLOB instead. > I have changed the datatype to LONGBLOB but problem is still unsolved, the DefinedSize property of ADO recordset for Attachment fields still says its 64K. __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.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
source command
At the prompt mysql> I type a command : SOURCE SCRIPTS\MT_INV_TBL.TXT. The command returns the following error message: Failed to open file [FileName] Error 2. So what is this error 2. What does it mean? Your help will be appreciated. _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: database create fails with error 28
> What the hell is error 28? Where can I find description? > mysqlcheck --all-databases # says everything is ok mysql does come with a little utiltiy, perror, which can be used to translate error numbers into readable messages: $ perror 28 Error code 28: No space left on device Did you check if you have enough disk space? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem on win2k
Yes, don't lock the table. MySQL will handle the lock for you on the insert. this isn't access. its a multi-user system. with access you have to lock the table. Curtis On Tue, 6 Aug 2002, Pradeep Dsouza wrote: > Dear list > > I have written a large application which i call Edupro which uses > PEAR and Mysql as the DB > > Everything was fine till i notied that when > i was trying to lock the tables for WRITE access It showed an > error and the table couldnt be locked > > Is there something i need to do before i lock a table on Win2k > Please help i cannot proceed without the Lock > This same code works perfectly fine on 98 > Does it have some thing to do with the NTFS file system > i feel it does please tell me how to get around this > > This iswhat i am doing LOCK tables tablename Write; > > I get an error immedieatley > Thanks in Advance > Pradeep > > > > # Pradeep Dsouza > # RH-04 E-11 Sector -09 > # CBD Navi Mumbai > # Maharashtra > # India > # > # Tel: 091 - 022 - 7573097 > # Mob: 98205 80286 > # Email : [EMAIL PROTECTED] > # http://www.naharonline.com > # Multiple platforms ... Multiple technologies ... We provide it all... > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: install mysql on RedHat7.1
Actually, in my redhat 7.1 distribution, it has only mysql-VERSION.rpm, mysql-server-VERSION.rpm and mysql-devel-VERSION.rpm only, it's missing it's client rpm. I checked with my previous 7.0 cd set, it's missing the client too. So is it possible to install without client. Now i'm tring it with latest tar.gz, and following the online tutorial http://perl.about.com/ but when i run the command "/support-files/mysql.server start", it says permission denied problem. I tried to execute as root and the created mysql user, but the same error returns. Can anybody explain me how to install latest mysql tar.gz on RedHat linux 7.1,step by step, or send me a link to a good tutorial. V.k. Abaya -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 8:52 AM To: 'Viraj Kalinga Abayarathna '; '[EMAIL PROTECTED] ' Subject: RE: install mysql on RedHat7.1 Can you please post the error message and/or number that you are receiving? -Original Message- From: Viraj Kalinga Abayarathna To: [EMAIL PROTECTED] Sent: 8/7/02 8:43 PM Subject: install mysql on RedHat7.1 hi, I'm tring to install mysql RPMs which ships with redhat 7.1. Rpms installed successfully, but when mysqld it says var/lib/mysql/mysql.error , if anybody knows the solution please explain me, or send me a url to a online tutorial, i have tried the mysql installation guide, it id not help me. I download the latest tar.gz available on mysql site, it gives some errormessae.sys not existed problem. please help on the same vk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
database create fails with error 28
>Description: When creating a database with mysqladmin create -p the system responds with "can't create database, error number 28" >How-To-Repeat: >Fix: I've done mysql_install_db, changed ownership and group of the /usr/local/mysql and /usr/local/mysql/var to recommended values shell> safe_mysqld --user=mysql shell> mysqladmin -u root password 'mypassword' shell> mysqladmin -p create SomeDatabase ** failed: errno=28 What the hell is error 28? Where can I find description? mysqlcheck --all-databases # says everything is ok >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: cannot create database >Severity: serious >Priority: high >Category: mysql >Class: >Release: mysql-3.23.51 (Source distribution) >Environment: System: Linux BARAJAS.MIT.EDU 2.4.2-2 #1 Sun Apr 8 20:41:30 EDT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-81) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 May 23 2001 /lib/libc.so.6 -> libc-2.2.2.so -rwxr-xr-x2 root root 1236396 Apr 6 2001 /lib/libc-2.2.2.so -rw-r--r--1 root root 26350254 Apr 6 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 6 2001 /usr/lib/libc.so lrwxrwxrwx1 root root 10 May 23 2001 /usr/lib/libc-client.a -> c-client.a Configure command: ./configure --prefix=/usr/local/mysql --quiet - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problems enabling local-infile
Yes, LOCAL is when client and server are on different boxes and the file is LOCAL to the client. You don't need that keyword otherwise. Regards, Bhavin. - Original Message - From: "David Sammons" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 08, 2002 10:20 AM Subject: RE: problems enabling local-infile > I've got it. I was using the LOCAL attribute in my LOAD DATA command and it > wouldn't work. After getting rid of LOCAL, it works. > > ds > > -Original Message- > From: David Sammons [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 08, 2002 11:03 AM > To: [EMAIL PROTECTED] > Subject: RE: problems enabling local-infile > > > Yes, I've checked the manual and have tried several applicable commands. > I'm running both the server and client on this pc. > > I've tried: > > \mysql\bin> mysql --enable-local-infile; [unrecognized option error] > \mysql\bin> mysql --local-infile=1; [no error, but LOAD DATA LOCAL INFILE > command not enabled] > > I'm just testing to use this command to populate some tables. For testing > purposes I've created a simple table (3 fields: field1, field2, field3) and > a simple text file with 3 tab-delimited records. Help?! > > ds > > -Original Message- > From: DL Neil [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 08, 2002 10:47 AM > To: David Sammons; [EMAIL PROTECTED] > Subject: Re: problems enabling local-infile > > > Hi David, > > > Help?! I'm new to mySQL and am having a heck of a time enabling > > local-infile to populate a table. I'm running v3.23.51 on win200pro. Any > > ideas? > > > > I've tried several different command-line options with no luck. Help?! > > > So you've checked the manual and performed whatever is necessary > version-wise. > Is the Win2000 running both server and client, or are there two physical > machines here? > > Please post your current command, and the errmsg received. > > I have 3.23.51-nt too. If it is not sensitive, and also post the > schema/CREATE TABLE and a few data records, I'll try it here for you. > > Regards, > =dn > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: Using unix mysql db files under windows mysql
If you have 'root' privileges to the server itself, then shutdown mysql and restart it with --skip-grant-tables. This should allow you to log in as root without being prompted for a password. Regards, Bhavin. - Original Message - From: "Norris, Joseph" <[EMAIL PROTECTED]> To: "'Kevin Bednar'" <[EMAIL PROTECTED]>; "Norris, Joseph" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, August 08, 2002 9:56 AM Subject: RE: Using unix mysql db files under windows mysql > Do you have any user for the db? If so you might have the permissions to do > the dump. Its worth a try. > > > -Original Message- > From: Kevin Bednar [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 08, 2002 9:50 AM > To: 'Norris, Joseph'; [EMAIL PROTECTED] > Subject: RE: Using unix mysql db files under windows mysql > > > I don't have the root login password for mysql Joe. This was a machine > we inhertited and has 1 site on it. This is why we want to move > everything off of it. Can you do a mysqldump without the root mysql > login? > > Kevin Bednar > Network Engineer > Dedicated Access Support > 1-888-TELLURIAN > (973) 300-9211 Ext. 126 > Tellurian Networks - Le Package Totale > http://www.tellurian.net > > > > -Original Message- > From: Norris, Joseph [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 08, 2002 12:48 PM > To: 'Kevin Bednar'; [EMAIL PROTECTED] > Subject: RE: Using unix mysql db files under windows mysql > > > You can not do mysqldump on unix, rebuild on windows? > > > -Original Message- > From: Kevin Bednar [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 08, 2002 9:42 AM > To: [EMAIL PROTECTED] > Subject: Using unix mysql db files under windows mysql > > > Hello all, > I have access to the database files themselves from a linux > installation of mysql, but not the root login priveleges under mysql > itself. I know that if I could connect via mysql itself I could just > copy the databases from one server to another but I cant. I copied the > db files over via ftp onto a windows server running mysql and it sees > the 2 databases but if I try to actually access the colums, etc. I get > errors. I also noticed the file extensions on the unix files are > different, except for the .frm files. Is there an import tool or > something else I can run to import these files into the windows version > of mysql so that I can start using them again? The web site these are > used for is being migrated off unix onto windows. TIA! > > Kevin Bednar > Network Engineer > Dedicated Access Support > 1-888-TELLURIAN > (973) 300-9211 Ext. 126 > Tellurian Networks - Le Package Totale > http://www.tellurian.net > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql crashes after adding memory.
If it is saying that it cannot bind to port 3306, then maybe the port is still locked by another process, mysqld or otherwise. netstat -na | grep 3306 should show you that. Kill that process and try again. Regards, Bhavin. - Original Message - From: "Johannes Ullrich" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 08, 2002 11:31 AM Subject: mysql crashes after adding memory. > > Yesterday, I increased the memory in my mysql server from > 2 GByte to 4 GByte. > > Here the log file as it died: > > Number of processes running now: 1 > mysqld process hanging, pid 1015 - killed > 020808 09:40:12 mysqld restarted > 020808 9:40:12 Can't start server: Bind on TCP/IP port: Address already in use020808 9:40:12 Do you already have another mysqld server running on port: 3306 ? > 020808 9:40:12 Aborting > > 020808 9:40:12 /usr/local/mysql/bin/mysqld: Shutdown Complete > > 020808 09:40:12 mysqld ended > > >The database was under heavy load at the time. The machine is > a 'vanilla' dual 1 GHz P-III running RedHat Linux and a 2.4.17 kernel > Server version: 3.23.49a-max-log > >After doing the memory upgrade, I also adjusted some of the > parameters, in particular, I increased the key buffer to 2 Gig. > >The database has a very large (100,000,000 row, 30 GigByte) > MyISAM table, and a few smaller myisam and innodb tables. It ran > ok for at least half a year (last machine reboot). So far, it does > not look like any data was corrupted. > >Usually, only a small number of client (10 or so) is connected. > > Here my my.cnf file: > > set-variable=max_connections=200 > set-variable=max_allowed_packet=10M > set-variable=key_buffer=2000M > set-variable=join_buffer_size=200M > set-variable=sort_buffer=150M > set-variable=record_buffer=50M > set-variable=record_rnd_buffer=50M > set-variable=table_cache=200 > set-variable=thread_concurrency=4 > set-variable=long_query_time=5 > > innodb_data_home_dir=/usr/local/mysql/innodb > innodb_data_file_path=data1/ibdata1:1M;data2/ibdata1:1M > set-variable=innodb_buffer_pool_size=50M > set-variable=innodb_additional_mem_pool_size=10M > innodb_log_group_home_dir=/opt/innodb_logs > innodb_log_arch_dir=/opt/innodb_logs > innodb_log_archive=1 > set-variable = innodb_log_files_in_group=3 > set-variable = innodb_log_file_size=3M > set-variable = innodb_log_buffer_size=100 > innodb_flush_log_at_trx_commit=1 > set-variable = innodb_file_io_threads=4 > set-variable = innodb_lock_wait_timeout=50 > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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 crashes after adding memory.
Yesterday, I increased the memory in my mysql server from 2 GByte to 4 GByte. Here the log file as it died: Number of processes running now: 1 mysqld process hanging, pid 1015 - killed 020808 09:40:12 mysqld restarted 020808 9:40:12 Can't start server: Bind on TCP/IP port: Address already in use020808 9:40:12 Do you already have another mysqld server running on port: 3306 ? 020808 9:40:12 Aborting 020808 9:40:12 /usr/local/mysql/bin/mysqld: Shutdown Complete 020808 09:40:12 mysqld ended The database was under heavy load at the time. The machine is a 'vanilla' dual 1 GHz P-III running RedHat Linux and a 2.4.17 kernel Server version: 3.23.49a-max-log After doing the memory upgrade, I also adjusted some of the parameters, in particular, I increased the key buffer to 2 Gig. The database has a very large (100,000,000 row, 30 GigByte) MyISAM table, and a few smaller myisam and innodb tables. It ran ok for at least half a year (last machine reboot). So far, it does not look like any data was corrupted. Usually, only a small number of client (10 or so) is connected. Here my my.cnf file: set-variable=max_connections=200 set-variable=max_allowed_packet=10M set-variable=key_buffer=2000M set-variable=join_buffer_size=200M set-variable=sort_buffer=150M set-variable=record_buffer=50M set-variable=record_rnd_buffer=50M set-variable=table_cache=200 set-variable=thread_concurrency=4 set-variable=long_query_time=5 innodb_data_home_dir=/usr/local/mysql/innodb innodb_data_file_path=data1/ibdata1:1M;data2/ibdata1:1M set-variable=innodb_buffer_pool_size=50M set-variable=innodb_additional_mem_pool_size=10M innodb_log_group_home_dir=/opt/innodb_logs innodb_log_arch_dir=/opt/innodb_logs innodb_log_archive=1 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=3M set-variable = innodb_log_buffer_size=100 innodb_flush_log_at_trx_commit=1 set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: fulltext phrase search
In the last episode (Aug 08), Christopher Book said:
> Using mysql 4.0.2 I get the following behaviour (phrase searching):
>
> match (field) against ('"pack of"' in boolean mode)
>
> gives me all results with 'pack of', not just 'pack'. So MySQL isn't
> ignoring 'of' even though the word is too short to normally be
> considered.
>
> However if I use: match(field) against ('"of the'" in boolean mode)
>
> then the whole query is ignored.
>
> It this working as designed? Should the short words be "sometimes"
> ignored?
If mysql internally does phrase searches by searching for "+word1 +word2",
then scanning the results for records where the words are also
adjacent, that would be consistent with the results you're seeing. As
long as one of the words in the phrase is indexed, you'll get results.
--
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: Which binary fro which platforms?
As regards the HP part of your question: The 'hppa1' part of the package name is a reference to the processor architecture. PA2 machines will run PA1 code unchanged (in theory); the reverse is not true. HPUX 10.20 is a 32-bit release. Although you can install a 32-bit version of HPUX 11, most v11 installations are 64-bit, but will run 32-bit apps without complaint. Which shouldn't be an issue for you in this case, as the packages would seem to be 32-bit. Short version: the hp 10.20 package would appear to the lowest common denominator. You might also check the HP porting and archive center (hpux.cs.utah.edu) for an swinstall-able package. Your customers will appreciate the ability to cleanly remove your software when they're done with it. www.sunfreeware.com is a good source for Sun binaries. www.bullfreeware.com for AIX packages. HTH. Good luck. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 12:30 PM To: [EMAIL PROTECTED] Subject: Which binary fro which platforms? I have a product for which I would like to use mySql to hold information used in a product demonstration. The product runs on Windows, HP, Solaris and AIX. The demonstration (and the mySql database) will be distributed with the product. I am trying to determine the correct binary distribution of mySql to distribute to end users. I would like to use stable releases only, in binary format. For Windows, the correct release is pretty clear. However, say a customer has HP 11.x. The "current stable release" on mysql.org is for hp 10.20 (mysql-3.23.51-hp-hpux10.20-hppa1); there is a release on sourceforge for hp 11.0 (mysql-hpux-11.0-hppa2), but is that considered stable? If not, can they use the binary for 10.20 instead? What if the customer later upgrades to a newer version of HP - must they then use a different version of the binary? Similar question pertain to Solaris (currently 2.8) and AIX (currently 4.3). Thanks for any pointers. John - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql - sql - auto-update cmd?
Mike,Mark, Thanks for responding to my post. I understand now about "triggers". I can see doing the calculations in the queries. That makes sense. thanks, -Original Message- From: Michael Fanara [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 3:29 PM To: Seifuddin, Lamar T.* (LSEIFUDD); [EMAIL PROTECTED] Subject: RE: mysql - sql - auto-update cmd? Lamar, Why store that information? You'll be constantly updating your table. I do something similar keeping softball stats for my team. I just keep the raw data and do all calculations, i.e. batting average, slg pct, winning pct, obp pct, etc. in the queries that generate the web pages or reports. BTW - you would need some type of Trigger for what you're talking about and I don't think mySQL supports triggers yet. mike Thnx. -Original Message- From: Seifuddin, Lamar T.* (LSEIFUDD) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 4:21 PM To: [EMAIL PROTECTED] Subject: mysql - sql - auto-update cmd? Hello All, I am using mysql on Linux - RedHat 7.1. The basic stuff is simple, cool, too. I am a newbie, so forgive me if this is too simple a question. Is there a mechanism available somewhere in doing an "automated" update of a field. example. team is a table. wins, losses, pct are fields of team table. I want to enter wins and/or losses and have pct be automatically updated. where pct is wins/(wins + losses) or do I have to write a script (not lazy, just wanted to know if something was available) I appreciate any advice or direction. thanks, Lamar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Cookbook [warning: shameless plug]
It looks like the booksellers are starting to creating listings for this book, so I've added links to them on the web site that I maintain as the book's online presence. The site is available here: http://www.kitebird.com/mysql-cookbook/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 - sql - auto-update cmd?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Seifuddin, Lamar T.* (LSEIFUDD) wrote: | Hello All, | | I am using mysql on Linux - RedHat 7.1. | The basic stuff is simple, cool, too. | | I am a newbie, so forgive me if this is too simple a question. | | Is there a mechanism available somewhere in doing an "automated" update of a | field. | | example. | | team is a table. | | wins, losses, pct are fields of team table. | | I want to enter wins and/or losses and have pct be automatically updated. | | where pct is wins/(wins + losses) | | or do I have to write a script (not lazy, just wanted to know if something | was available) | | I appreciate any advice or direction. What you're talking about is a trigger. MySQL doesn't have them yet. In general they're used inappropriately anyways. This example would be an inappropriate use (in most cases). Simply compute the "pct" field when you do your queries: ~ SELECT wins, losses, wins / (wins + losses) as pct FROM team -Mark - -- For technical support contracts, visit https://order.mysql.com/?ref=mmma ~__ ___ ___ __ ~ / |/ /_ __/ __/ __ \/ / Mark Matthews <[EMAIL PROTECTED]> ~ / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java ~ /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ~<___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.1.90 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE9UtVvtvXNTca6JD8RAn3BAKCCYFuHTd4n7tEVhyowe8E6pt7RzACgmtw+ WJvOchcYHV8c0rON8Lzom3Y= =7JJY -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: mysql - sql - auto-update cmd?
Lamar, Why store that information? You'll be constantly updating your table. I do something similar keeping softball stats for my team. I just keep the raw data and do all calculations, i.e. batting average, slg pct, winning pct, obp pct, etc. in the queries that generate the web pages or reports. BTW - you would need some type of Trigger for what you're talking about and I don't think mySQL supports triggers yet. mike Thnx. -Original Message- From: Seifuddin, Lamar T.* (LSEIFUDD) [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 4:21 PM To: [EMAIL PROTECTED] Subject: mysql - sql - auto-update cmd? Hello All, I am using mysql on Linux - RedHat 7.1. The basic stuff is simple, cool, too. I am a newbie, so forgive me if this is too simple a question. Is there a mechanism available somewhere in doing an "automated" update of a field. example. team is a table. wins, losses, pct are fields of team table. I want to enter wins and/or losses and have pct be automatically updated. where pct is wins/(wins + losses) or do I have to write a script (not lazy, just wanted to know if something was available) I appreciate any advice or direction. thanks, Lamar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 - sql - auto-update cmd?
Hello All, I am using mysql on Linux - RedHat 7.1. The basic stuff is simple, cool, too. I am a newbie, so forgive me if this is too simple a question. Is there a mechanism available somewhere in doing an "automated" update of a field. example. team is a table. wins, losses, pct are fields of team table. I want to enter wins and/or losses and have pct be automatically updated. where pct is wins/(wins + losses) or do I have to write a script (not lazy, just wanted to know if something was available) I appreciate any advice or direction. thanks, Lamar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
fulltext phrase search
Hi,
Using mysql 4.0.2 I get the following behaviour (phrase searching):
match (field) against ('"pack of"' in boolean mode)
gives me all results with 'pack of', not just 'pack'. So MySQL isn't
ignoring 'of' even though the word is too short to normally be considered.
However if I use: match(field) against ('"of the'" in boolean mode)
then the whole query is ignored.
It this working as designed? Should the short words be "sometimes" ignored?
Chris Book
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
