RE: Parse error?
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, 2001 2:13 PM To: [EMAIL PROTECTED] Subject: Parse error? I am new to MySQL and am using Paul DuBois's book to MySQL guide me. (Great Book!) I am attempting to use PHP, My scripts always connect to the MySQL server OK, and the Databases to, but my queries always fail with the following message: OK 1 OK 2 Parse error: parse error in /home/httpd/html/test10.php3 on line 8 (I place the OK 1 etc to help me find problems) This is the PHP3 script ?php $link = mysql_pconnect (localhost, test, test) or die (Could not connect); print (OK 1 ); mysql_select_db (samp_db) or die (Could not select database); print (OK 2 ) $query = SELECT COUNT(*) FROM president; $result = mysql_query ($query) or die (Query failed); Print (OK 3 ) ? Using PHP I can create drop databases all OK but every query I've tried gives me a parse error and I've looked trough all my books and can't find any mention of what they are and how you fix them. Thanks Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: upgrade from SUSE7.0
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 [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 9:43 AM To: Andy Woo Cc: 'mysql' Subject: Re: upgrade from SUSE7.0 Andy Woo wrote: I have the same problem. Whatsssup? :-) /usr/bin/mysqladmin: connect to server at 'breguet' failed error: 'Host 'breguet.experia.com' is not allowed to connect to this MySQL server' what can I do to solve this ?... I don't know i removed the things, and tried to install the 3.23.38 release instead, my the problem is not solved I've tried every thing to get connected, but nothing went right I could do a mysqladmin version, and the answer was correct, but no connection... So, I re-install the whole box (it's a test box...) in order to see if i was wrong somewhere, and where i could have messed things up but I'm curious to find an answer... Stephane - 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: Making MySQL DB Remotely Accessible
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 user and a password. Leave the port at 3306 unless you changed it. Probably need to use root user to get in the first time. Hope this helps some. Robert -Original Message- From: Ray Pollard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 11:42 AM To: '[EMAIL PROTECTED]' Subject: Making MySQL DB Remotely Accessible I am new to the world of mySQL and have just installed it on a Windows 2000 Advanced Server and I need to figure out how make the db accessible from a remote PC for administration. Can anyone provide me with some direction in that area? Bear in mind, I am a newbie. Thanks very much, Ray - 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: Varchar binary field auto-trimmed??
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: Tuesday, May 15, 2001 1:04 PM To: ryc Cc: [EMAIL PROTECTED] Subject: Re: Varchar binary field auto-trimmed?? Hi, We can decalre a varchar field as BINARY if we need case sensitive storage of field values. Regards, Ravi --- ryc [EMAIL PROTECTED] wrote: Varchar fields are not binary, blobs are. ryan Hi Help! I would like to store some short binary data (encrypted). I used a varchar(24) binary field for this. But it seems that MySQL cuts white-spaces from the end when storing the data in the table. When the encrypted string now has a white-space at end, MySQL will cut it and this will result in a wrong decryption (next time when the string is read and decrypted). When using TinyBlob instead of varchar binary, all works fine. Is this a feature of varchar binary? In my opinion, binary data shouldn't be trimmed! Please answer me via mail as I don't receive the mailing list. Thanks for your support! ... tobias wiersch - 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 Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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: Hom many columns is too many?
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 going to be demoralized. I have worked with databases with over 200 attributes that were fully normalized. There is more then one way to solve any problem. 50 of the ways are great 50 of them suck but all will get the job done. That is the beauty of database design and programming, I think. -Original Message- From: ryc [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 4:09 PM To: [EMAIL PROTECTED] Subject: Re: Hom many columns is too many? Just because one table has many columns does not mean it is not normalized. The original message stated that there is all kinds of different information about a contact from their first/last name to the high school they graduated from. Given enough information about a person it would be easy to fill 75 columns of DIFFERNT data. Sure there may be a column to store phone numbers... but that doesnt mean that in order to add another phone number for a particular contact that you would insert a whole new row. Either a) you decide not to keep more than one phone number per contact, and use an update to change the phone number for that contact or b) create a phone number table so you can create a one to many relationship (one row in the contact table can have multiple rows in the phone number table). In case b yes some information is taken out of the contact table and put into another table, however that is just one column. For things like mothers maden name and other unique and SINGLE data elements putting that data in the contact table does not denormalize the table. The only situation in which I can think to create a seperate table with this sort of information is a) one contact may have many of column y or b) a majority of the contacts dont have information for column y, so you create a seperate table for column y to store the few rows you do have information for, so that your contact table doesnt have a bunch of empty fields. Hope this helps. ryan 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 information already in the database on Joe Smith unless you keep adding more columns to accommodate each new phone number(this would be very poor database design). Its basic normalizing of tables that will keep this from happening. Its is very dependent on the nature of the data on whether you need to break that table up or not. I would find it very hard to believe that all the information needed for customer/contact data from there name all the way to where they went to high school could be stored in one table logically or more importantly efficiently. -Original Message- From: ryc [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 11:58 AM To: 'Richard Reina'; [EMAIL PROTECTED] Subject: Re: Hom many columns is too many? I dont think the problem was redudant data. He is talking about 75 distinct fields that no other table contains and ALL data is related to the contact. It makes sence that a table with more columns would have a higher overhead when parsing the queries, but but other than that I dont _think_ there should be a major problem having a table with that many columns. However 75 does seem like it is a very obscene amount for one table, so you may want to consider creating one table that stores the contacts primary information (name, address, phone #, business name, ect... ) that is imparative to working with the contact, and then have another table that contains more detailed background information. This way if you need the information from the second table you can left join it, and if you dont need it you dont have to. Or another scheme is only insert detailed data for the contacts you have that information on, and leave the rest blank (in this case you wont be able to use left join because if the column you join on is missing from the details table the query will return empty, even though the contact is in the primary table). Either way there are trade offs, decide what is best based on how much detail information you have from the contacts, and how you want to lay out your code. Hope that helps, ryan 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 to go. But this also depends on things such as how large
RE: MySQL 3.23.38 released
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 released Hi! This release includes mainly fixes for BDB and InnoDB tables. You can now find MySQL-Max (MySQL binaries with support for the above table types) for most supported platforms at http://www.mysql.com/downloads/mysql-max-3.23.html The windows binary is under testing and should hopefully be released tomorrow (if we don't find any unexpected bugs in BDB or InnoDB under windows). Changes in release 3.23.38 -- * Fixed a bug in `REPLACE()' when using the ujis character set. * Applied Sleepycat BDB patches 3.2.9.1 and 3.2.9.2. * Added option `--skip-stack-trace' to `mysqld'. * `CREATE TEMPORARY' now works with `InnoDB' tables. * `InnoDB' now promotes sub keys to whole keys. * Added option `CONCURRENT' to `LOAD DATA'. * Better error message when slave `max_allowed_packet' is to low to read a very long log event from the master * Fixed bug when too many rows where removed when using `SELECT DISTINCT ... HAVING'. * `SHOW CREATE TABLE' now returns `TEMPORARY' for temporary tables. * Added `Rows_examined' to slow query log. * Fixed problems with function returning empty string when using together with a group functions and a `WHERE' that didn't match any rows. * New program `mysqlcheck'. * Added database name to output for administrative commands like `CHECK', `REPAIR', `OPTIMIZE'. * Lots of portability fixes for InnoDB. * Changed optimizer so that queries like `SELECT * FROM table_name,table_name2 ... ORDER BY key_part1 LIMIT #' will use index on `key_part1' instead of `filesort'. * Fixed bug when doing `LOCK TABLE to_table WRITE,...; INSERT INTO to_table... SELECT ...' when `to_table' was empty. * Fixed bug with `LOCK TABLE' and BDB tables. Regards, Monty PS: Please use a mirror for downloading (Note that it will probably take 24 hours until our mirrors are up to date) - To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail the address shown in the List-Unsubscribe header of this message. For additional commands, e-mail: [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 3.23.38 released
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 released 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 released Hi! This release includes mainly fixes for BDB and InnoDB tables. You can now find MySQL-Max (MySQL binaries with support for the above table types) for most supported platforms at http://www.mysql.com/downloads/mysql-max-3.23.html The windows binary is under testing and should hopefully be released tomorrow (if we don't find any unexpected bugs in BDB or InnoDB under windows). Changes in release 3.23.38 -- * Fixed a bug in `REPLACE()' when using the ujis character set. * Applied Sleepycat BDB patches 3.2.9.1 and 3.2.9.2. * Added option `--skip-stack-trace' to `mysqld'. * `CREATE TEMPORARY' now works with `InnoDB' tables. * `InnoDB' now promotes sub keys to whole keys. * Added option `CONCURRENT' to `LOAD DATA'. * Better error message when slave `max_allowed_packet' is to low to read a very long log event from the master * Fixed bug when too many rows where removed when using `SELECT DISTINCT ... HAVING'. * `SHOW CREATE TABLE' now returns `TEMPORARY' for temporary tables. * Added `Rows_examined' to slow query log. * Fixed problems with function returning empty string when using together with a group functions and a `WHERE' that didn't match any rows. * New program `mysqlcheck'. * Added database name to output for administrative commands like `CHECK', `REPAIR', `OPTIMIZE'. * Lots of portability fixes for InnoDB. * Changed optimizer so that queries like `SELECT * FROM table_name,table_name2 ... ORDER BY key_part1 LIMIT #' will use index on `key_part1' instead of `filesort'. * Fixed bug when doing `LOCK TABLE to_table WRITE,...; INSERT INTO to_table... SELECT ...' when `to_table' was empty. * Fixed bug with `LOCK TABLE' and BDB tables. Regards, Monty PS: Please use a mirror for downloading (Note that it will probably take 24 hours until our mirrors are up to date) - To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail the address shown in the List-Unsubscribe header of this message. For additional commands, e-mail: [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: Hom many columns is too many?
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 to go. But this also depends on things such as how large your db will be. Sometimes redundant data is not always a bad think. In that case a lower normal form would be fine too. Its an art not a science:) RH -Original Message- From: Richard Reina [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 1:26 PM To: [EMAIL PROTECTED] Subject: Hom many columns is too many? I am designing an in house database app. for sales/contact management. We've identified out about 75 things to know about a customer/contact from there name all the way to where they went to highschool. Should all these attributes be in one table since they all describe the contact or should they be broken up into seperate tables like education, professional backround, business backtound special interests? - 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: InnoDB, BDB, and Gemini
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 all Gemini tables are busy being beta tested, and therefore are available. I personally use them and so far so good. I really love having row level locking in MYSQL, and it works like a dream. contact www.nusphere.com for more info. There are currently running with 3.23.36 Enjoy Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] ]On Behalf Of Steve Ruby Sent: 11 May 2001 06:10 To: Kevin McBrearty; [EMAIL PROTECTED] Subject: Re: InnoDB, BDB, and Gemini InnoDB definately provides more features that BDB, and is probably going to be faster, Gemini isn't available yet. BDB might be more complete/stable. So I'd say Gemini is out of the picture unless you are looking longer term. I'd do some testing with both we found some bugs in the 3.23.37 distribution with regard to BDB, Monty sais they are fix in .38 Kevin McBrearty wrote: I have re-read the appropriate manual sections several times, trying to decide what is the best option for my database table types. I am using 3.32.37 on Linux, and am torn between InnoDB, BDB, and Gemini table types. Transaction handling is very important for my application (commit, rollback, etc.). I am leaning toward InnoDB at this point but was wondering if anyone could offer any information, other than what is in the manual, regarding the pros and cons of these table types. TIA Kevin McBrearty ATG Automation Technologies Group Ltd. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: Hom many columns is too many?
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 information already in the database on Joe Smith unless you keep adding more columns to accommodate each new phone number(this would be very poor database design). Its basic normalizing of tables that will keep this from happening. Its is very dependent on the nature of the data on whether you need to break that table up or not. I would find it very hard to believe that all the information needed for customer/contact data from there name all the way to where they went to high school could be stored in one table logically or more importantly efficiently. -Original Message- From: ryc [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 11:58 AM To: 'Richard Reina'; [EMAIL PROTECTED] Subject: Re: Hom many columns is too many? I dont think the problem was redudant data. He is talking about 75 distinct fields that no other table contains and ALL data is related to the contact. It makes sence that a table with more columns would have a higher overhead when parsing the queries, but but other than that I dont _think_ there should be a major problem having a table with that many columns. However 75 does seem like it is a very obscene amount for one table, so you may want to consider creating one table that stores the contacts primary information (name, address, phone #, business name, ect... ) that is imparative to working with the contact, and then have another table that contains more detailed background information. This way if you need the information from the second table you can left join it, and if you dont need it you dont have to. Or another scheme is only insert detailed data for the contacts you have that information on, and leave the rest blank (in this case you wont be able to use left join because if the column you join on is missing from the details table the query will return empty, even though the contact is in the primary table). Either way there are trade offs, decide what is best based on how much detail information you have from the contacts, and how you want to lay out your code. Hope that helps, ryan 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 to go. But this also depends on things such as how large your db will be. Sometimes redundant data is not always a bad think. In that case a lower normal form would be fine too. Its an art not a science:) RH -Original Message- From: Richard Reina [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 1:26 PM To: [EMAIL PROTECTED] Subject: Hom many columns is too many? I am designing an in house database app. for sales/contact management. We've identified out about 75 things to know about a customer/contact from there name all the way to where they went to highschool. Should all these attributes be in one table since they all describe the contact or should they be broken up into seperate tables like education, professional backround, business backtound special interests? - 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: simultaneous connections
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 has always worked for me, including 3.23.37 set-variable = max_connections= John Barton Unix Systems Administrator Primary Networks, Inc. [EMAIL PROTECTED] On Thu, 10 May 2001, Mark Lo (3) wrote: Hi, I would like to set a higher values in max_connections for mysql. I have tried to use the following command mysqld --set-variables max_connections=900 -u root -ppassword. Then, it shows that I have successfully changed the variable of max_connections. But, when I check it with the command of mysqladmin variables -u root -ppassword. The max_connections return to 100 which is the default value. I wonder what is wrong with mysql3.23.37. Is this a bug, or I am using the wrong command. In additions, Can I set the max_connections values higher than 5000. Thank you 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 - 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 -Original Message- From: Don Pro [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 2:37 PM To: msql list Subject: simultaneous connections Hi, I'm reading in my documentation (I have a book) that MySQL allows up to 101 simultaneous connections. Gadzooks! How can MySQL claim to be at the Enterprise level with this limit? Is there any way around this? Thanks, Don - 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: Having success with 20 million rows
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: [EMAIL PROTECTED] Subject: Re: Having success with 20 million rows FOUR days!?!? THAT'S patience. But I'm glad to hear the success story. j- k On Wednesday 09 May 2001 11:08, David J. Potter wrote: Just wanted to say that we are having success using MySql. Even though our tables are large, over 20 million rows, selects, updates and inserts occur very fast. We use both Windows and Linux. Adding a column is the only action that is slow (it took 4 days once to add a column), but that is OK since we don't change columns often. Overall MySql is turning to be a great fast database. David -- Joshua Kugler Associated Students of the University of Alaska Fairbanks Information Services Director [EMAIL PROTECTED] 907-474-7601 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: Having success with 20 million rows
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: Having success with 20 million rows 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: [EMAIL PROTECTED] Subject: Re: Having success with 20 million rows FOUR days!?!? THAT'S patience. But I'm glad to hear the success story. j- k On Wednesday 09 May 2001 11:08, David J. Potter wrote: Just wanted to say that we are having success using MySql. Even though our tables are large, over 20 million rows, selects, updates and inserts occur very fast. We use both Windows and Linux. Adding a column is the only action that is slow (it took 4 days once to add a column), but that is OK since we don't change columns often. Overall MySql is turning to be a great fast database. David -- Joshua Kugler Associated Students of the University of Alaska Fairbanks Information Services Director [EMAIL PROTECTED] 907-474-7601 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: database recovery (errcode 13)?
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 . I am talking from a windows environment maybe its different on Linux. root=mysql sub1=data sub2=thedb---database files for thedb go here -Original Message- From: Kay Aleksic [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 2:10 PM To: MySQL List (E-mail) Subject: database recovery (errcode 13)? Hi list, I am dealing with my first MySQL server/db, and I ran into some trouble. The server where the db was located got hacked and I had to reinstall the whole thing. The old HD is preserved as was and the server got a new HD. I moved the old db to the new disk and when I try to access it, I get the following error: mysql use thedb; Can't read dir of './thedb/' (Errcode: 13) Database changed mysql show tables; ERROR 12: Can't read dir of './thedb/' (Errcode: 13) mysql (RedHat 6.2, MySQL 2.23.37) How can I recover or fix it? Thanks in advance for any help. K. Aleksic - 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 HA
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 03:59:45PM -0400, Billy Passauer wrote: -Original Message- From: carlos ospina [mailto:[EMAIL PROTECTED]] I wanna know if someone has ever setup any kind o HA with MySQL. OK, I'll bite. What is an HA ? High Availability. -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 126 days, processed 781,270,256 queries (71/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