Re: Could someone please help in choosing a manual...

2003-07-22 Thread Michael Satterwhite
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 22 July 2003 12:28, Ola Ogunneye wrote: I am still getting my feet wet on mysql. I, however have seen the MYSQL Refereence Manual at the mysql site while I have also seen Mysql Cookbook referenced or mentioned in the list. As a true

RE: Frequent Table Corruption - Please Help

2003-07-16 Thread Tom Roos
:[EMAIL PROTECTED] Sent: 15 July 2003 22:35 To: Heikki Tuuri; [EMAIL PROTECTED] Subject: Re: Frequent Table Corruption - Please Help Thank you very much for the help. I will schedule the upgrade and see if helps. I have 2 other machines running 2.4.18 without problems, but they also do not run

Re: Frequent Table Corruption - Please Help

2003-07-16 Thread Heikki Tuuri
Message - From: Tom Roos [EMAIL PROTECTED] To: Richard Gabriel [EMAIL PROTECTED]; Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 9:59 AM Subject: RE: Frequent Table Corruption - Please Help hi guys i am runing the rh 2.4.20-18.7smp kernel with mysql 4.0.13 and i

Re: Frequent Table Corruption - Please Help

2003-07-16 Thread Richard Gabriel
What do you consider high volume? Also, please keep me in the loop on this. Any configuration changes that help would be appreciated. Thanks! Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 - Original Message - From: Tom Roos [EMAIL PROTECTED] To: Richard

Re: Frequent Table Corruption - Please Help

2003-07-16 Thread Richard Gabriel
[EMAIL PROTECTED] To: Tom Roos [EMAIL PROTECTED] Cc: Richard Gabriel [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 4:10 AM Subject: Re: Frequent Table Corruption - Please Help Have you tried to use a non SMP kernel ? I have also experienced table corruptions 2 years ago

Re: Frequent Table Corruption - Please Help

2003-07-16 Thread Joseph Bueno
PROTECTED] Sent: Wednesday, July 16, 2003 4:10 AM Subject: Re: Frequent Table Corruption - Please Help Have you tried to use a non SMP kernel ? I have also experienced table corruptions 2 years ago with mysql 3.23.xx and a 2.2.14smp kernel. I had several servers with the same configuration

Re: Frequent Table Corruption - Please Help

2003-07-16 Thread Richard Gabriel
Director of Technology, CoreSense Inc. (518) 306-3043 x3951 - Original Message - From: Joseph Bueno [EMAIL PROTECTED] To: Richard Gabriel [EMAIL PROTECTED] Cc: Tom Roos [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 1:10 PM Subject: Re: Frequent Table Corruption - Please

Frequent Table Corruption - Please Help

2003-07-15 Thread Richard Gabriel
Hi everyone, Since we upgraded to MySQL 4.0.13 from 3.23, we have been getting table corruption often. It happens about twice per week (with about 500 queries per second average). I have even set up a cron to run mysqlcheck every hour to try to do some damage control. The biggest problem is

Re: Frequent Table Corruption - Please Help

2003-07-15 Thread Heikki Tuuri
Message - From: Richard Gabriel [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, July 15, 2003 9:52 PM Subject: Frequent Table Corruption - Please Help Hi everyone, Since we upgraded to MySQL 4.0.13 from 3.23, we have been getting table corruption often. It happens about

Re: Frequent Table Corruption - Please Help

2003-07-15 Thread Richard Gabriel
Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 3:45 PM Subject: Re: Frequent Table Corruption - Please Help Richard, you are running a Red Hat kernel 2.4.18

Re: Frequent Table Corruption - Please Help

2003-07-15 Thread Heikki Tuuri
Richard, - Original Message - From: Richard Gabriel [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 10:53 PM Subject: Re: Frequent Table Corruption - Please Help Thanks for the tip. I'll see about upgrading, but it won't be a small

Re: Frequent Table Corruption - Please Help

2003-07-15 Thread Richard Gabriel
Inc. (518) 306-3043 x3951 - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 4:08 PM Subject: Re: Frequent Table Corruption - Please Help Richard, - Original Message - From: Richard Gabriel [EMAIL PROTECTED

help me please .... deplome project

2003-07-09 Thread Mhd Zaher Ghaibeh
Hi every one : i'm trying to make a db program using Mysql cbuilder6 . on my table a have fields named patient_Id . its an auto_increment value but i got problem . the problem is when i try to get the value of that fields i got nothing just 0 although i execute the commands

Need help with a 1005 error (errno: 150), please...

2003-07-07 Thread Tom Gazzini
I would appreciate some help with a problem. I'm trying to create two tables that have referential integrity. If I try and create the following table it works fine: CREATE TABLE book ( sku INT ) TYPE=INNODB; However, if I creating this table, I get an error: CREATE TABLE book ( sku INT,

Re: Need help with a 1005 error (errno: 150), please...

2003-07-07 Thread gerald_clark
You must create the key (sku), it is not created for you. Tom Gazzini wrote: I would appreciate some help with a problem. I'm trying to create two tables that have referential integrity. If I try and create the following table it works fine: CREATE TABLE book ( sku INT ) TYPE=INNODB; However,

RE: Need help with a 1005 error (errno: 150), please...

2003-07-07 Thread Tom Gazzini
Please ignore my last email. I made a nauseatingly dumb error in the book table (sku should be CHAR(14), not INT). The only help I need is to get some sleep. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Please Help ..working with MySql with a C compiler

2003-07-01 Thread khaled bassyouny
libmysqlclient ) I tried the same code but with a C++ compiler and it worked fine ...anyone has any idea what is the problem between MySQL and C ??? Thanks a lot PLEASE HELP ! __ Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo. http

Help please

2003-06-13 Thread Huw Parker
\bin\mysql - fails with message ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) Have installed / uninstalled / tried several times, always fails at this point. Can you assist please? Thanks very much, Huw Parker -- MySQL General Mailing List For list archives: http

Re: REPOST: FULLTEXT searching help needed. Please somebody help.

2003-06-13 Thread H M Kunzmann
settings: max_sort_length=16M table_cache=256M key_buffer=128M sort_buffer=4M read_buffer_size=1M Should I set anything else ? What can I do to get respectable return times ? Please lend me a helping hand... Thanks in advance. H M Kunzmann -- Herbert Michael Kunzmann Binary Chaos

Please help me!

2003-06-13 Thread Varghonan
Hi! I am new here and wonder if anyone could help me with a problem in my community. The adress is http://trashankarna.net/community/default.php I can't figure this out. I get this message when I choose to read a message in my outbox/utkorg: Warning: 1 is not a valid MySQL-Link resource in

RE: Please help me!

2003-06-13 Thread Mike Hillyer
, Mike Hillyer www.vbmysql.com -Original Message- From: Varghonan [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 10:36 AM To: [EMAIL PROTECTED] Subject: Please help me! Hi! I am new here and wonder if anyone could help me with a problem in my community. The adress is http

Re: REPOST: FULLTEXT searching help needed. Please somebody help.

2003-06-13 Thread Sergei Golubchik
Hi! On Jun 13, H M Kunzmann wrote: The answer is that a fulltext index can only be built on a TEXT field. Even though the mysql documentation describes MEDIUMTEXT and LONGTEXT fields as 'BLOB or TEXT field that can hold..', they can not be used. No, this is wrong. Any xxxTEXT field can be

Qwery help please

2003-06-11 Thread Jay Blanchard
I have two tables; TESTtblRC ++++-+ | id | npanxx | RCname | RCstate | ++++-+ | 1 | 11 | ONE| CA | | 2 | 22 | ONE| CA | | 3 | 33 | ONE| CA | | 4 | 44 | TWO| CA | | 5 | 55 | TWO|

Re[2]: Please help: Can not insert binary data larger than 16 megabytes

2003-06-07 Thread Stefan Hinz
Brad, Edward, Try using 'max_allowed_packet=16M' instead of your current value. You may also find help by reviewing the below. http://www.mysql.com/doc/en/Packet_too_large.html That will set the communication buffer to a maximum of 16 MB, but Brad wants more than that ... From the manual:

Re: Re[2]: Please help: Can not insert binary data larger than 16 megabytes

2003-06-07 Thread Becoming Digital
Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: Stefan Hinz [EMAIL PROTECTED] To: Becoming Digital [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, 07 June, 2003 03:25 Subject: Re[2]: Please help: Can not insert binary data larger than 16 megabytes Brad

Re: REPOST: FULLTEXT searching help needed. Please somebody help.

2003-06-06 Thread H M Kunzmann
When mysql is indexing You can check your data file direcory and You ca see that one file (the index) is growing in size. I see it grow up to 8M and it stays there. Watching this, it grows very slowly. After 5 minutes of indexing, the file size has barely hit 2MB. The command I use is:

Please help: Can not insert binary data larger than 16 megabytes

2003-06-06 Thread brad.simonin
Hello -- I am having trouble inserting binary data that is larger than 16 megabytes into a MySQL database table (binary data such as pdf's, gif's, jpeg's, etc). Can someone take a look at what I am doing and give me any suggestions. If I do insert binary data larger than 16 megabytes I get the

Re: Please help: Can not insert binary data larger than 16 megabytes

2003-06-06 Thread Becoming Digital
better practice to do the latter. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, 06 June, 2003 17:11 Subject: Please help: Can not insert binary data larger than 16 megabytes Hello -- I am having

REPOST: FULLTEXT searching help needed. Please somebody help.

2003-06-05 Thread H M Kunzmann
settings: max_sort_length=16M table_cache=256M key_buffer=128M sort_buffer=4M read_buffer_size=1M Should I set anything else ? What can I do to get respectable return times ? Please lend me a helping hand... Thanks in advance. H M Kunzmann -- MySQL General Mailing List For list archives: http

Re: REPOST: FULLTEXT searching help needed. Please somebody help.

2003-06-05 Thread Santino
respectable return times ? Please lend me a helping hand... Thanks in advance. H M Kunzmann -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com

RE: REPOST: FULLTEXT searching help needed. Please somebody help.

2003-06-05 Thread electroteque
help needed. Please somebody help. I think your index is corrupted because I expect a 1.5 GB index and not 8M! You can see word list wit a utility (sorry I don't remember te name ft_dump). I suggest You to drop fulltext index, duplicate database and remove some rrecords. Then create index index

Re: REPOST: FULLTEXT searching help needed. Please somebody help.

2003-06-05 Thread H M Kunzmann
I think your index is corrupted because I expect a 1.5 GB index and not 8M! You can see word list wit a utility (sorry I don't remember te name ft_dump). I agree with this :-) I suggest You to drop fulltext index, duplicate database and remove some rrecords. Then create index index again.

PLEASE ADD THIS TO DOCUMENTATION...

2003-06-05 Thread Tim Meader
Well, I just discovered through trial and error that threads ARE being spawned on Redhat 8. The problem is that the ps that came with 7.2 7.3 was compiled to show threads as separate processes it seems. On Redhat 8 you have to add the -m switch to ps to make it show all threads. Just thought

Please ADD this to documentation on website...

2003-06-05 Thread Tim Meader
Well, I just discovered through trial and error that threads ARE being spawned on Redhat 8. The problem is that the ps that came with 7.2 7.3 was compiled to show threads as separate processes it seems. On Redhat 8 you have to add the -m switch to ps to make it show all threads. Just thought

Re: Mysql.log error - Please help

2003-04-04 Thread Brian Reichert
On Fri, Apr 04, 2003 at 09:10:50AM +0200, Jocelyn Fournier wrote: Hi, Or simply use perror 28 :) [EMAIL PROTECTED]:~$ perror 28 Error code 28: No space left on device Golly, I had no idea that such a utility came with the MySQL distribution. Kinda handy. Learn something new

Please HELP!!! Re: Database Core Dumps

2003-04-03 Thread TRANTER,STEWART (HP-Germany,ex1)
3.23.54-max for hp-hpux11.11 on hppa2.0w Can anyone offer any suggestions please? We are all totally stumped!!! Many thanks in advance and best regards, Stewart

Re: Please HELP!!! Re: Database Core Dumps

2003-04-03 Thread Stefan Hinz
Stewart, Yesterday I posted the message listed below. I have some more information. We have found the command that pushes our database over the edge! It is: SHOW VARIABLES; All other db commands work (such as SHOW VARIABLES %a;) except for: SHOW VARIABLES % This should be SHOW

Re: Please HELP!!! Re: Database Core Dumps

2003-04-03 Thread Mark Matthews
please? We are all totally stumped!!! | | Many thanks in advance and best regards, | | Stewart There is a known issue on 64 bit platforms with MySQL versions 3.23.56 causing a crash when 'SHOW VARIABLES' is executed. You are right in thinking that the JDBC driver issues this query, because it does

RE: Please HELP!!! Re: Database Core Dumps

2003-04-03 Thread TRANTER,STEWART (HP-Germany,ex1)
:[EMAIL PROTECTED] Sent: 03 April 2003 15:00 To: TRANTER,STEWART (HP-Germany,ex1) Cc: '[EMAIL PROTECTED]' Subject: Re: Please HELP!!! Re: Database Core Dumps -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 TRANTER,STEWART (HP-Germany,ex1) wrote: | Hello Everyone, | | Yesterday I posted the message

Re: Request: please use meaningful subject lines

2003-04-03 Thread Jeremy Zawodny
On Wed, Apr 02, 2003 at 11:14:56AM -0800, Michael Shulman wrote: Please try to use more informative subject lines in your queries. You'll be more likely to get good help quickly. Agreed. I simply delete messages with subject lines that don't say anything specific. I wish ISPs asked all

Mysql.log error - Please help

2003-04-03 Thread Minal Amle
Hello, I am facing a problem while inserting data in one of the tables of my mysql database as: Error writing file '/var/log/mysql.log' (Errcode :28) While records are getting inserted in other tables. I am not getting why this is happening so. Can anybody please help me in this regard? Thanks

Re: Mysql.log error - Please help

2003-04-03 Thread Brian Reichert
On Fri, Apr 04, 2003 at 12:22:18PM +0530, Minal Amle wrote: Hello, I am facing a problem while inserting data in one of the tables of my mysql database as: Error writing file '/var/log/mysql.log' (Errcode :28) I suspect this 'Errcode' corresponds to 'errno' under UNIX systems. On mine,

Re: Mysql.log error - Please help

2003-04-03 Thread Jocelyn Fournier
: Mysql.log error - Please help On Fri, Apr 04, 2003 at 12:22:18PM +0530, Minal Amle wrote: Hello, I am facing a problem while inserting data in one of the tables of my mysql database as: Error writing file '/var/log/mysql.log' (Errcode :28) I suspect this 'Errcode' corresponds to 'errno

Help MySQL Beginner please.

2003-04-02 Thread Webmanhouse
or anything. is there anyone who can help me with basic information that can get me started? Please not too technical please. Something a new commer can understand. Thanks, Jef -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Help MySQL Beginner please.

2003-04-02 Thread B. van Ouwerkerk
am trying to build database for my site and just discovered that my hosting server uses mySQL and i am not use to it. I don't know where to start. don't know how to create table or anything. is there anyone who can help me with basic information that can get me started? Please not too technical

RE: Help MySQL Beginner please.

2003-04-02 Thread Joe Stump
] [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 7:10 AM To: [EMAIL PROTECTED] Subject: Help MySQL Beginner please. Hi all, The best thing that happened to me today is finding this list on the web. I am in deep problem. I am trying to build database for my site and just discovered that my

RE: Help MySQL Beginner please.

2003-04-02 Thread Craig Pyter
] Sent: Wednesday, April 02, 2003 9:10 AM To: [EMAIL PROTECTED] Subject: Help MySQL Beginner please. Hi all, The best thing that happened to me today is finding this list on the web. I am in deep problem. I am trying to build database for my site and just discovered that my hosting server uses mySQL

Re: Help MySQL Beginner please.

2003-04-02 Thread Henning Heil
don't know where to start. don't know how to create table or anything. is there anyone who can help me with basic information that can get me started? Please not too technical please. Something a new commer can understand. Thanks, Jef well, depends on how much in a hurry you are, learning

re: Help MySQL Beginner please.

2003-04-02 Thread Victoria Reznichenko
know where to start. don't know how to create table or anything. is there anyone who can help me with basic information that can get me started? Please not too technical please. Something a new commer can understand. You can find some info in the manual. How to create table: http

Request: please use meaningful subject lines

2003-04-02 Thread Michael Shulman
I'm getting 100 messages a day on this newsgroup. While I love to help, I don't like having to read each message to figure out if it's something I can help with. Here are examples subject lines from the past 24 hours: How many Help MySQL Beginner please. Have a problem

please help me

2003-03-28 Thread Ing.Peter Misovic
i have deleted mysql database, can i restore it with start defaults ? Thanks, Thailon, Slovakia -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

re: please help me

2003-03-28 Thread Egor Egorov
On Friday 28 March 2003 13:59, Ing.Peter Misovic wrote: i have deleted mysql database, can i restore it with start defaults ? mysql_install_db is your solution. :) Thailon, Slovakia -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by

Re: Your professional opinion Please...

2003-03-27 Thread Brian
Thanks Mark: - Original Message - From: Mark C. Roduner, Jr. [EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 3:45 PM Subject: RE: Your professional opinion Please... Brian, Here's Some hints on how to accomplish an efficiant way to index the data Regular Expressions: ([\w\d

Re: Your professional opinion Please...

2003-03-27 Thread Brian
Thanks Peter: - Original Message - From: Peter L. Berghold [EMAIL PROTECTED] To: Brian [EMAIL PROTECTED] Cc: MySQL [EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 4:07 PM Subject: Re: Your professional opinion Please... On Tue, 2003-03-25 at 18:11, Brian wrote: What mechanism do you

Re: Your professional opinion Please...

2003-03-25 Thread Peter L. Berghold
On Mon, Mar 24, 2003 at 06:41:07PM -0800, Brian wrote: I have a client with approximately 2 gigabytes of un-indexed document files (includes text and graphics). He wants to be able to enter a few parameters and bring up a list of all If they are flat text files this should not be too big an

Re: Your professional opinion Please...

2003-03-25 Thread Joe Lewis
Peter L. Berghold wrote: On Mon, Mar 24, 2003 at 06:41:07PM -0800, Brian wrote: I have a client with approximately 2 gigabytes of un-indexed document files (includes text and graphics). He wants to be able to enter a few parameters and bring up a list of all [snip] I'd leave them as flat text

RE: Your professional opinion Please...

2003-03-25 Thread James E Hicks III
I'd use MySQL, Apache, and UDMSEARCH. It provides the web interface for the google search engine (Apache and UDMSearch), while connecting to MySQL. If you want, the re-indexing can occur using a cron, and then by making apache serve the documents from the root and doing the fancy

mysql install---help please

2003-03-25 Thread katherine bjork
PROTECTED]' (Using password: NO)' Also tried /usr/local/mysql/bin/mysqladmin -u root -h $hostname password 'new-password' but was denied. How the heck do I give myself access to mysql? Please don't point me to the mysql.org page...been there I do not understand the grants et al. Need plain

Re: Your professional opinion Please...

2003-03-25 Thread Brian
Hi Nick: - Original Message - From: Nick Arnett [EMAIL PROTECTED] To: Brian [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED] Sent: Monday, March 24, 2003 7:47 PM Subject: RE: Your professional opinion Please... I have a client with approximately 2 gigabytes of un-indexed document files

Re: Your professional opinion Please...

2003-03-25 Thread Brian
On Mon, Mar 24, 2003 at 06:41:07PM -0800, Brian wrote: I have a client with approximately 2 gigabytes of un-indexed document files (includes text and graphics). He wants to be able to enter a few parameters and bring up a list of all... If they are flat text files this should not be

RE: mysql install---help please

2003-03-25 Thread Jennifer Goodie
: katherine bjork [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 3:02 PM To: mysql Subject: mysql install---help please Tried for the second time to install mysql on my mac and again a problem during the install related to the password. I typed in /usr/local/mysql/bin/mysqladmin -u root password

Re: Your professional opinion Please...

2003-03-25 Thread Brian
- Original Message - From: Joe Lewis [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Cc: Brian [EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 8:42 AM Subject: Re: Your professional opinion Please... Peter L. Berghold wrote: On Mon, Mar 24, 2003 at 06:41:07PM -0800, Brian wrote: I

Re: Your professional opinion Please...

2003-03-25 Thread Brian
- Original Message - From: James E Hicks III [EMAIL PROTECTED] To: Joe Lewis [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED] Cc: Brian [EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 8:56 AM Subject: RE: Your professional opinion Please... I'd use MySQL, Apache, and UDMSEARCH. It provides

RE: Your professional opinion Please...

2003-03-25 Thread Mark C. Roduner, Jr.
(easier UI). Mark C. Roduner, Jr. Medical Systematics Research -Original Message- From: Brian [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 3:12 PM To: Peter L. Berghold Cc: MySQL Subject: Re: Your professional opinion Please... On Mon, Mar 24, 2003 at 06:41:07PM -0800, Brian

RE: mysql install---help please

2003-03-25 Thread Black, Kelly W [PCS]
bjork; mysql Subject: RE: mysql install---help please You said that you changed the password to the password you wanted, but in all the examples you are trying to access the server without a password. Try using the -p flag so it prompts you for your password, then type in whatever you set

Re: Your professional opinion Please...

2003-03-25 Thread Peter L. Berghold
On Tue, 2003-03-25 at 18:11, Brian wrote: What mechanism do you recommend? Something in perl, python or php? Well... I tend to be a Perl bigot so I'd choose Perl. I would do a couple of things. 1) I'd develop a list of words to ignore such as and, if ,but etc. etc.. This may take time

RE: mysql install---help please

2003-03-25 Thread Black, Kelly W [PCS]
] Sent: Tuesday, March 25, 2003 4:13 PM To: Black, Kelly W [PCS] Subject: Re: mysql install---help please I typed in /usr/local/mysql/bin/mysql -u userid -p -h localhost password: prompted for password, gave only one I ever use response was ERROR 1045: Access denied for user: '[EMAIL PROTECTED

Your professional opinion Please...

2003-03-24 Thread Brian
Hello Dear Friends: I have a client with approximately 2 gigabytes of un-indexed document files (includes text and graphics). He wants to be able to enter a few parameters and bring up a list of all documents that fit, and then be able to download them over a web interface - sort of like a

Re: Your professional opinion Please...

2003-03-24 Thread Martin Gainty
Brian- why not use grep or fgrep on the files and catch the hyperlink resultset to formatted html..? Regards, Martin - Original Message - From: Brian [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Monday, March 24, 2003 7:41 PM Subject: Your professional opinion Please... Hello

RE: Your professional opinion Please...

2003-03-24 Thread Nick Arnett
-Original Message- From: Brian [mailto:[EMAIL PROTECTED] ... I have a client with approximately 2 gigabytes of un-indexed document files (includes text and graphics). He wants to be able to enter a few parameters and bring up a list of all documents that fit, and then be able to

Query help needed please

2003-03-21 Thread Charles Kline
- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php

Re: Query help needed please

2003-03-21 Thread Bruce Feist
AND p.id = a1.person_id AND p.id = a2.person_id AND p.id = a3.person_id AND a1.dra_id = dra1.id AND a2.dra_id = dra2.id AND a3.dra_id = dra3.id - Before posting, please check: http://www.mysql.com/manual.php (the manual

Test Please Ignore :)

2003-03-19 Thread Karthikeyan Balasubramanian
Test -- Karthikeyan Balasubramanian [EMAIL PROTECTED] -- http://www.fastmail.fm - Access your email from home and the web - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: please rename dbug.h

2003-03-19 Thread Lenz Grimmer
you please consider making this change in the master codelines? (ideally it would be nice if you prefixed all your header files with my_to avoid future clashes with system header files) Thanks for pointing this out! Monty has now fixed it in the 4.0 tree and it will be merged into 4.1 as well

Please tell me why to use KEY (a_id, b_id) rather than KEY (a_id), KEY (b_id)

2003-03-18 Thread Daevid Vincent
by Paul Dubois. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL

Re: Please tell me why to use KEY (a_id, b_id) rather than KEY (a_id), KEY (b_id)

2003-03-18 Thread Dan Nelson
] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http

RE: Please tell me why to use KEY (a_id, b_id) rather than KEY (a_id), KEY (b_id)

2003-03-18 Thread Daevid Vincent
). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http

Re: Please tell me why to use KEY (a_id, b_id) rather than KEY (a_id), KEY (b_id)

2003-03-18 Thread Jeff Kilbride
- Original Message - From: Daevid Vincent [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 4:59 PM Subject: RE: Please tell me why to use KEY (a_id, b_id) rather than KEY (a_id), KEY (b_id) Ah ha! So if I had: CREATE TABLE `rep_table` ( `rep_id` smallint(5

Re: Please tell me why to use KEY (a_id, b_id) rather than KEY (a_id),KEY (b_id)

2003-03-18 Thread Bruce Feist
enough to realize that the order of the conditions is irrelevant. I assume that this is true of MySql. But, I'm a newcomer to MySql, and I could be wrong. Bruce Feist - Before posting, please check: http://www.mysql.com

please rename dbug.h

2003-03-14 Thread Jonathan Stockley
is simple, rename the mysql dbug.h to my_dbug.h and change the include in my_global.h to #include my_dbug.h instead. Rather than my having to fix this with every new mysql release I download, could you please consider making this change in the master codelines? (ideally it would be nice if you

BDB Crash log sequence error. Please ANY HELP !!!!

2003-03-10 Thread Santiago LLobet
LLobet - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED

RE: very slow mysql server, help please

2003-03-07 Thread William Wang
To: William Wang; [EMAIL PROTECTED] Subject: Re: very slow mysql server, help please On Thursday 06 Mar 2003 3:11 am, William Wang wrote: Question 1: Does sleeping processes slow down database server? Nope, I have had many a discussion whats best to use, pcconect or normall connect but have yet

Re: very slow mysql server, help please

2003-03-06 Thread Ken Menzel
Hi William, Sleeping processes are the result of persisitant connections and should not slow down your server. As to why you server is so slow you will have to provide specific examples of what is slow. We reach speeds of 600 queries per second on slower hardware. Also please indicated

Re: very slow mysql server, help please

2003-03-06 Thread John Wards
on. I would say try installing linuxthreads then recompile your current version of mySQL to have linuxthread support. If that doesn't work try upgrading to 4. HTH Cheers John Wards SportNetwork.net - Before posting, please check

very slow mysql server, help please

2003-03-05 Thread william wang
_ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

very slow mysql server, help please

2003-03-05 Thread William Wang
- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com

re: update/delete bug, please fix, thank you!

2003-03-04 Thread Victoria Reznichenko
- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http

update/delete bug, please fix, thank you!

2003-03-01 Thread root
' '--with-comment=Official MySQL RPM' 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' - Before posting, please check: http

update/delete bug, please fix, thank you!

2003-03-01 Thread miniwar
MySQL RPM' 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' - Before posting, please check: http://www.mysql.com

Little help please

2003-02-27 Thread Tom Ray
posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: [PHP] Little help please

2003-02-27 Thread 1LT John W. Holmes
PHPMyAdmin? You can configure it so that it checks the mysql.user table. ---John Holmes... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: Please clarify copyright of shared library. (fwd)

2003-02-20 Thread David Axmark
- -- Forwarded message -- Date: Sun, 10 Nov 2002 18:23:50 +0100 From: Christian Hammers [EMAIL PROTECTED] To: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Please clarify copyright of shared library. Hello The follwing bug was reported against the Debian libmysqlclient10 package. Can you

ERROR 1005 , Please help

2003-02-14 Thread sindhu
3307 Uptime: 12 hours 47 min 21 sec Sindhu K. Pillai Database Administrator / Developer Fungal Genomics Concordia University - Before posting, please check: http://www.mysql.com/manual.php (the manual

Please IGNORE my previous bug report. Script errors.

2003-02-06 Thread mwahal
Description: Please IGNORE my previous bug report. I had another script which was deleting the data. Stupid user error. How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:Mudit Wahal Organization: MySQL support: [none | licence | email support

RE: mysql.sock is missing - Please....

2003-02-03 Thread Diana Soares
thought his mysql server was configured to have the sock file there. :-) Thanx, -- Diana Soares - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

RE: mysql.sock is missing - Please....

2003-02-02 Thread B. van Ouwerkerk
. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php

Re: mysql.sock is missing - Please....

2003-02-01 Thread Diana Soares
Soares - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL

Re: mysql.sock is missing - Please....

2003-01-30 Thread Thomas Schlagbauer
/mysqld.sock' (2) the file mysqld.sock doesn't exist on the server. I also can't find the file mysql.server. I'm using Debian 3.0. Debian-Package: mysql-server shell mysql --version gives the following: mysql Ver 11.16 Distrib 3.23.49, for pc-linux-gnu (i686) Please help me! Thank you

Re: mysql.sock is missing - Please....

2003-01-30 Thread Stefan Hinz, iConnect \(Berlin\)
: mysql.sock is missing - Please Hi, I don't know who is receiving my message, but i have an important request on you. I also have the same problem. I installed MySQL on my server and after reboot i got the error message when starting mysql: ERROR 2002: Can't connect to local MySQL server

3.23 thread error - help/advice please

2003-01-28 Thread my5ql _
- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php

<    2   3   4   5   6   7   8   9   10   11   >