RE: Parse error?

2001-05-16 Thread Robert Henkel
Shouldn't you have on line 7 print (OK 2 ); and not print (OK 2 ) Im not a PHP person but thats what I noticed in your code. And if ; terminates a command that can't be helping magic words sql database -Original Message- From: MTF [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 16,

RE: upgrade from SUSE7.0

2001-05-15 Thread Robert Henkel
I'm not for sure but when you create a user you can allow that user to only connect from specific locations. Such as localhost or from anywhere or even a specfied locationm 123.222.111.2. Not sure if this will help at all?? Good Luck. -Original Message- From: stephane parenton

RE: Making MySQL DB Remotely Accessible

2001-05-15 Thread Robert Henkel
Try this program. Go to http://www.artronic.hr/mysql/index.htm and get mysqladmin. Its a windows client to manage mysql databases. You then can put in the ip address of the computer you want to connect to that is running a mysql database. So you would put your win2000 server ip. Then put in a

RE: Varchar binary field auto-trimmed??

2001-05-15 Thread Robert Henkel
I'm not a database god, but why would you want to store binary data in a varchar feild when there are feilds of type binary to do store that type of data? How can binary be upper or lower case? -Original Message- From: VVM Ravikumar Sarma Chengalvala [mailto:[EMAIL PROTECTED]] Sent:

RE: Hom many columns is too many?

2001-05-14 Thread Robert Henkel
Without knowing more detail about the data and the requirements of that data its hard to say how the database structure should be. To say I am right over you and you are right over me is pointless. Its very dependant on the data. I agree you can have a entity with 75+ attributes and its not

RE: MySQL 3.23.38 released

2001-05-14 Thread Robert Henkel
Can you compile a win32 version of this? Or will there be a binary for win32 soon? Thanks -Original Message- From: Michael Widenius [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 4:51 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: MySQL 3.23.38

RE: MySQL 3.23.38 released

2001-05-14 Thread Robert Henkel
Sorry its early for me and I didnt read the bottom of this email. Sorry:) -Original Message- From: Robert Henkel [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 8:40 AM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: MySQL 3.23.38

RE: Hom many columns is too many?

2001-05-11 Thread Robert Henkel
With relational database design you can more then likely break that 75 column table down into many different tables. Look up information on NORMAL FORM this will help you design an effective database. Usually from what I know and have been taught 3rd normal form is as low a level as you want

RE: InnoDB, BDB, and Gemini

2001-05-11 Thread Robert Henkel
Have you noticed a significant speed decline using Gemini tables? RH -Original Message- From: Warren van der Merwe [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 11:31 AM To: 'Steve Ruby'; 'Kevin McBrearty'; [EMAIL PROTECTED] Subject: RE: InnoDB, BDB, and Gemini Goodday to you

RE: Hom many columns is too many?

2001-05-11 Thread Robert Henkel
Well with tables not normalized you will more then likely at some point in get redundant data at some point. For instance I enter Joe smith with phone of 123-123-1222 then Joe Smith buys a new home keeps the other home and now has two active phone number with on table you would have to reenter

RE: simultaneous connections

2001-05-11 Thread Robert Henkel
PREVIOS THREAD ON THIS TOPIC: Hope it helps Hi, Make sure that MySQL on your OS supports 5000 connections ! Check OS specific restrictions in MySQL documentation. Regards -- Joseph Bueno NetClub/Trader.com John Barton wrote: Try putting a line like the following in your my.cnf file: This

RE: Having success with 20 million rows

2001-05-09 Thread Robert Henkel
Well normally its not the best to add columns after the fact if the design met the specs. But this is not always the case. As we all now the specs change about every hour. -Original Message- From: Joshua J. Kugler [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 2:49 PM To:

RE: Having success with 20 million rows

2001-05-09 Thread Robert Henkel
I take that back the word not the best shouldnt be used. I should of said in a perfect world we shouldnt have to add columns. -Original Message- From: Robert Henkel [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 2:56 PM To: 'Joshua J. Kugler'; [EMAIL PROTECTED] Subject: RE

RE: database recovery (errcode 13)?

2001-05-09 Thread Robert Henkel
When you say you moved the data base I'm assumeing you are meaning you reinstalled MySQL then moved the db files over to the new install? Each data base goes into its own directory. So the database files for the database named thedb would be in a subdirectory called thedb of the directory data

RE: MySQL HA

2001-05-09 Thread Robert Henkel
So those of us not in the world of HA, mission critical would be equivalent? -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 3:20 PM To: Billy Passauer Cc: carlos ospina; [EMAIL PROTECTED] Subject: Re: MySQL HA On Wed, May 09, 2001 at