varchar to char in table with several varchar's
I have a table with several columns of type 'varchar'. How can I change all columns to fixed width char's ? Doing a 'alter' from varchar to char has no effect since the column is changed back to varchar. - 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: connecting to mysql from different computer
I suspect that you need to add an entry at the MySQL host for the machine that you are connecting from. This can be done with a GRANT statement: - Format: grant all privileges on databaseName.tableName to 'userName'@'hostName' identified by 'somePassword'; - Example: grant all privileges on myDB.* to 'clyde'@'coolPlace.org' identified by 'secretPass'; Then you'll need to reload the access privileges. It can be done at the command line like this: % mysqladmin -u rootUserName reload Remember, you may need to add the -p switch and suply a password for this command. Is this enough info? One more important question, if these privileges are now granted, will it then be possible for me to connect from MySQL client at the local machine to MySQL server at the remote machine? More so will i need to open MySQL server on my local machine before running MySQL client to connect to the remote machine e.g. c:mysql\bin\mysqld c:mysql\bin mysql -h coolPlace.org -u clyde -psecretPass Or I will just run the MySQL client to connect to remote machine without neccessarily running MySQL server at the local machine c:mysql\bin mysql -h coolPlace.org -u clyde -psecretPass Thanks for giving me relieve. -kamal. - 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: MS Access and mysql databases
Yes it is perfectly possible. I did that some months ago and it worked perfectly. I, however, had to install MyODBC on the windows box. There is a good tutorial I used at http://www.devshed.com/Server_Side/MySQL/ODBC/page1.html Its a good tutorial By W.J. Gilmore. Please take note of the decimal fields in access and make sure you change the default settings in MyAccess. On Tue, 11 December 2001, Rosyna wrote: Is it possible to export a database from mysql so MS Access can read it as its own? I am not able to install MyODBC on the windows box (not admin) -- Sincerely, Rosyna Keller Technical Support/Holy Knight/Always needs a hug Unsanity: Unsane Tools for Insane People - 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 ___ Join the Space Program: Get FREE E-mail at http://www.space.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: connecting to mysql from different computer
[EMAIL PROTECTED] writes: More so will i need to open MySQL server on my local machine before running MySQL client to connect to the remote machine e.g. A client is a client and a server is a server. The point of separating the two is that you can then run the client somewhere and and the server elsewhere. So no, you do not need to have mysqld running locally to connect to a remote server. An decent analogy would be that you do not need to have a web server running to surf the web. I'd recommend you not to run anything that you do not need. Each additional server or daemon is a potential security hole. This is certainly true for mysqld, where the default privileges are very permissive. //C - pissed off at procter gamble for screwing up his shampoo. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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
Blocked MySQL.
When I try to do anything with MySQL, I always see Ignoring query to other database on my screen. When I type status, the computer prints: All updates ignored to this database. after Current user. Could anybody help me ? Does anybody know how can I unblock MySQL ? robertix - 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: A News Group Perhaps.
Hi, I was wondering if the mysql list had any plans to be put onto a news group. I have only been a memeber a short time but I have found %50 of the information to be usefull. This does however mean that %50 is does not apply to me at this time. Due to this I get a lot of emails that are of no use to me at the moment. I would be keen to talk about hosting this list as a news group to make it browsable so myself and others could pick out infromation that is usefull to me at this time. The email list could stay for mass contributions but I would rather just browse for information I need. Any thoughts on this ? Thanks, Matt. - 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
changing allowed number of connections
Hi, Where one can alter the number of connections going to MySQL? Jari Mäkelä - 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: [OT] A News Group Perhaps.
Hi Matt, I am sure this has been said before so my apologies if I bore! Most mail clients let you setup rules. For the mySQL list I automatically redirect all messages into a separate folder based on the [EMAIL PROTECTED] email address. This creates a fabulous resource that can be searched (title and text) and can be read or ignored by choice. I am not a great fan of Newsgroups - they get spammed too much and messages get lost or archived. Some ISPs carry them, some don't. All too hit and miss for a resource on which I rely and am very grateful for. Tony - Original Message - From: Matthew Darcy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, December 12, 2001 10:58 AM Subject: RE: A News Group Perhaps. Hi, I was wondering if the mysql list had any plans to be put onto a news group. I have only been a memeber a short time but I have found %50 of the information to be usefull. This does however mean that %50 is does not apply to me at this time. Due to this I get a lot of emails that are of no use to me at the moment. I would be keen to talk about hosting this list as a news group to make it browsable so myself and others could pick out infromation that is usefull to me at this time. The email list could stay for mass contributions but I would rather just browse for information I need. Any thoughts on this ? Thanks, Matt. - 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
How to create clients option file !!!
Compliments, I was able to uccessful install MySQLGUI version 1.75 on my win 98 running MySQL server 3.23.43 -max-debug client version 3.23.3 alpha. I was also able to connect to the server. At the bottom of the window I saw one button with plus sign, when I do mouse over on it there is this pop msg ; you have not created client options file, which is highly recommended. Pls, how do i create this and of what important is the file. Regards. kamal. - 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
feature request: privileged connection quotas
Hi, I'd like to be able to reserve some connections to the MySQL server for emergencies - eg. someone issued a slow query and locked out several hundred updates from several hundred other connections. Currently in this sort of situation, it is possible to completely run out of connections and then the only solution is to restart mysqld or just wait for the slow query to end. Would it be possible to add a feature to MySQL so that a configurable number of connections are reserved for a configurable list of users ? Then, an administrator would always be able to connect and clear any blockages. regards, Martin - 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
concurrent insert documentation clarification
The MySQL documentation says: To ensure that the update log/binary log can be used to re-create the original tables, MySQL will not allow concurrent inserts during INSERT SELECT Does this mean: A. An INSERT...SELECT cannot run if any other SELECT is running on the table OR B. An INSERT...SELECT cannot run if another INSERT...SELECT is already running on the table Which is correct? The wording of the documentation suggests that B is correct, but my actual tests on the server indicate A is correct (MySQL 3.23.43 RH Linux 7.1) Thanks - 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: A News Group Perhaps.
Tony Buckley writes: I am not a great fan of Newsgroups - they get spammed too much and messages get lost or archived. Some ISPs carry them, some don't. All too hit and miss for a resource on which I rely and am very grateful for. I agree, but sadly enough the spam part is true for this list as well. I completely agree with whomever proposed to have this list modified to accept mails from subscribed people only, and to require that subscribed email addresses are valid. I'm sure it'd be possible to allow bug reports from people not on the list. As for people who post questions to the list without being subscribed, I think that they should either join and contribute to and/or learn from the discussion, or just buy a support contract instead. Something that would be really great is if someone would gather all relevant things that are being said on this list and make one huge FAQ out of it. Carsten's FAQ is good, but it's not as big as it could've been, had someone paid him to create it. Then again, if MySQL would pay someone to make a really good FAQ, they'd probably lose a lot of support contracts. Not that I believe them to be that greedy/cynical, but anyway. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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: Default 1 == Default 16777216 ?
Philip Molter writes: On Mon, Dec 10, 2001 at 02:55:04PM -0700, Nathan wrote: : Dave Burgess had a good suggestion; I suppose you could specify the default in hex... : (default = 0x1) - as long as this is NOT in quotes it will input the hex value 1. I compiled a 3.23.46 last night and I have the same problem. I tried using 0x1, and the default is still set to 16777216 (and values get input with that value as well). Can anyone else verify that this is the case? I'm seeing it both with MyISAM tables and InnoDB tables, so I doubt it's a table handler. * Philip Molter * Texas.net Internet * http://www.texas.net/ * [EMAIL PROTECTED] Hi! Can you make a test case so that we can test your bug ?? If there is our binary for your OS, please try that one first. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Feature Requests
Mike Wexler writes: Quentin Bennett wrote: Shell escape mysql !rm /tmp/data.txt mysql select col into outfile '/tmp/data.txt' from table; mysql select col into local outfile '/tmp/data.txt' from table Would these options prove useful to others? Yes. Especially the local outfile. Regards Quentin Bennett Transport Systems Division Infinity Solutions web http:\\www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone : +64 9 358 9720 Fax : +64 9 309 4142 Hi! Regarding shell commands it is doable. Regarding local outfile, there are some clients that do it already, like mysqlgui. Fixing it to work in general case is also doable, but it is not a small feature. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Default 1 == Default 16777216?
Philip Molter writes: Description: When I do this: mysqlcreate table test_default ( testint int not null default 1 ); mysqldesc test_default; I get: +-+-+--+-+--+---+ | Field | Type| Null | Key | Default | Extra | +-+-+--+-+--+---+ | testint | int(11) | | | 16777216 | | +-+-+--+-+--+---+ 1 row in set (0.00 sec) Why does my default not go in as '1'. I've tried it with and without quotes. This is vexing. Is there something obvious that I'm just not doing correctly? How-To-Repeat: Hi! As there is a binary for your SPARC Solaris 2.8, please try it out and see if you get the same result. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [OT] A News Group Perhaps.
also screen what you don't need. I delete everything regarding installation. I don't have solaris and I don't have red hat so 80% of the install questions I can't help. You can set up pretty complex sorting rules. It might take a couple of weeks to set up, but once it's done you should receive only wanted informations. My 2 cents Etienne Tony Buckley wrote: Hi Matt, I am sure this has been said before so my apologies if I bore! Most mail clients let you setup rules. For the mySQL list I automatically redirect all messages into a separate folder based on the [EMAIL PROTECTED] email address. This creates a fabulous resource that can be searched (title and text) and can be read or ignored by choice. I am not a great fan of Newsgroups - they get spammed too much and messages get lost or archived. Some ISPs carry them, some don't. All too hit and miss for a resource on which I rely and am very grateful for. Tony - Original Message - From: Matthew Darcy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, December 12, 2001 10:58 AM Subject: RE: A News Group Perhaps. Hi, I was wondering if the mysql list had any plans to be put onto a news group. I have only been a memeber a short time but I have found %50 of the information to be usefull. This does however mean that %50 is does not apply to me at this time. Due to this I get a lot of emails that are of no use to me at the moment. I would be keen to talk about hosting this list as a news group to make it browsable so myself and others could pick out infromation that is usefull to me at this time. The email list could stay for mass contributions but I would rather just browse for information I need. Any thoughts on this ? Thanks, Matt. - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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
LEFT JOIN trouble. Please help.
Hi, I've got this problem: I have two tables and I want create third one with LEFT JOIN First table table1 containts field AA as a primary key (AA is NOT NULL). Second table table2 containts field AA as a primary key (AA is NOT NULL) too. Ex: CREATE TABLE a (PRIMARY KEY(AA)) SELECT table1.AA FROM table2 LEFT JOIN table1 ON table2.AA=table1.AA WHERE ...; The problem is, that mysql creates new table with field AA, but it's not NOT NULL (it's allow NULL) = I cannot create primary key on this field. Is it bug or I'm wrong ??? Regards 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
Re: ADV: Dear Future Millionaire:
How come this passed the spam filter? Which word it had that was on the mandatory words list ? There is no sql, query, database in the text... Etienne Bege John wrote: I'll make you a promise. READ THIS E-MAIL TO THE END! - follow what it says to the letter and you will not worry whether a RECESSION is coming or not, who is President, or whether you keep your current job or not. Yes, I know what you are thinking. I never responded to one of these before either. One day though, something just said you throw away $25.00 going to a movie for 2 hours with your wife. What the heck. Believe me, no matter where you believethose feelings come from, I thank goodness every day that I had that feeling.I cannot imagine where I would be or what I would be doing had I not. Read on. It's true. Every word of it. It is legal. I checked. Simply because you are buying and selling something of value. AS SEEN ON NATIONAL TV: Making over half million dollars every 4 to 5 months from your home.THANK'S TO THE COMPUTER AGE AND THE INTERNET ! == BE AN INTERNET MILLIONAIRE LIKE OTHERS WITHIN A YEAR!!! Before you say ''Bull'', please read the following. This is the letter you have been hearing about on the news lately. Due to the popularity of this letter on the Internet, a national weekly news program recently devoted an entire show to the investigation of this program described below, to see if it really can make people money. The show also investigated whether or not the program was legal. Their findings proved once and for all that there are ''absolutely NO Laws prohibiting the participation in the program and if people canfollow the simple instruction they are bound to make some mega bucks with only $25 out of pocket cost''. DUE TO THE RECENT INCREASE OF POPULARITY RESPECT THIS PROGRAM HAS ATTAINED, IT IS CURRENTLY WORKING BETTER THAN EVER. This is what one had to say: '' Thanks to this profitable opportunity. I was approached many times before but each time I passed on it. I am so glad I finally joined just to see what one could expect in return for the minimal effort and money required. To my astonishment, I received a total $ 610,470.00 in 21 weeks, with money still coming in''. Pam Hedland,Fort Lee, New Jersey. == Another said: this program has been around for a long time but I never believed in it. But one day when I received this again in the mail I decided to gamble my $25 on it. I followed the simple instructions and walaa . 3 weeks later the money started to come in. First month I only made $240.00 but the next 2 months after that I made a total of $290,000.00. So far, in the past 8 months by re-entering the program, I have made over $710,000.00 and I am playing it again. The key to success in this program is to follow the simple steps and NOT change anything.'' More testimonials later but first, PRINT THIS NOW FOR YOUR FUTURE REFERENCE If you would like to make at least $500,000 every 4 to 5 months easily and comfortably, please read the following...THEN READ IT AGAIN and AGAIN !!! FOLLOW THE SIMPLE INSTRUCTION BELOW AND YOUR FINANCIAL DREAMS WILL COME TRUE, GUARANTEED! INSTRUCTIONS: =Order all 5 reports shown on the list below = For each report, send $5 CASH, THE NAME NUMBER OF THE REPORT YOU ARE ORDERING and YOUR E-MAIL ADDRESS to the person whose name appears ON THAT LIST next to the report. MAKE SURE YOUR RETURN ADDRESS IS ON YOUR ENVELOPE TOP LEFT CORNER in case of any mail problems. ===WHEN YOU PLACE YOUR ORDER, MAKE SURE ==YOU ORDER EACH OF THE 5 REPORTS! === You will need all 5 reports so that you can save them on your computer and resell them. YOUR TOTAL COST $5 X 5 = $25.00. Within a few days you will receive, via e-mail, each of the 5 reports Save them on your computer so they will be accessible for you to send to the 1,000's of people who will order them from you. Also make a floppy of these reports and keep it on your desk in case something happens to your computer. IMPORTANT - DO NOT alter the names of the people who are listed next to each report, or their sequence on the list, in any way other than what is instructed below in step '' 1 through 6 '' or you will loose out on the majority of your profits. Once you understand the way this works, you will also see how it does not work if you change it. Remember, this method has been tested, and if you alter it, it will NOT work !!! People have tried to put their friends/relatives names on all five thinking they could get all the money. But it does not work this way. Believe us, some have tried to be greedy and then nothing happened. So Do Not try to change anything other than what is instructed.
Re: ADV: Dear Future Millionaire: (very OT in a way)
Etienne Marcotte writes: How come this passed the spam filter? Which word it had that was on the mandatory words list ? EEek! Noo... but that can't be.. or...? Is the whole thing about the MySQL database just a hoax to get people to subscribe to this list so that the people at MySQL can get rich by sending us spam? :-o //C - In insane conspiracy theory generation mode -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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
Embedded MySQL server the outside world
Hi folks, does embedded server tcp-listen to the outside world i.e. it could be used by another app or perhaps been accessed by the same app using ODBC? OR is MySQL C API the only way to control it? Thanks, Marek - 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: [OT] A News Group Perhaps.
I would vote in favor of using vbulletin (www.vbulletin.com) it's got forums for talk like this, web-based, and runs off of the MySQL server as a back-end. An example in action is vbulletin itself or community.installshield.com. Very slick indeed. Kelly FYI, I'm somewhat biased in favor of it because I have set up this program and know how well it works. It's a great example of PHP and MySQL working together. Hi Matt, I am sure this has been said before so my apologies if I bore! Most mail clients let you setup rules. For the mySQL list I automatically redirect all messages into a separate folder based on the [EMAIL PROTECTED] email address. This creates a fabulous resource that can be searched (title and text) and can be read or ignored by choice. I am not a great fan of Newsgroups - they get spammed too much and messages get lost or archived. Some ISPs carry them, some don't. All too hit and miss for a resource on which I rely and am very grateful for. Tony - Original Message - From: Matthew Darcy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, December 12, 2001 10:58 AM Subject: RE: A News Group Perhaps. Hi, I was wondering if the mysql list had any plans to be put onto a news group. I have only been a memeber a short time but I have found %50 of the information to be usefull. This does however mean that %50 is does not apply to me at this time. Due to this I get a lot of emails that are of no use to me at the moment. I would be keen to talk about hosting this list as a news group to make it browsable so myself and others could pick out infromation that is usefull to me at this time. The email list could stay for mass contributions but I would rather just browse for information I need. Any thoughts on this ? Thanks, Matt. - 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 -- Kelly Firkins [EMAIL PROTECTED] _ Chat with friends online, try MSN Messenger: http://messenger.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
How to create clients option file !!!
Compliments, I was able to uccessful install MySQLGUI version 1.75 on my win 98 running MySQL server 3.23.43 -max-debug client version 3.23.3 alpha. I was also able to connect to the server. At the bottom of the window I saw one button with plus sign, when I do mouse over on it there is this pop msg ; you have not created client options file, which is highly recommended. Pls, how do i create this and of what important is the file. Regards. kamal. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to create clients option file !!!
[EMAIL PROTECTED] writes: Compliments, I was able to uccessful install MySQLGUI version 1.75 on my win 98 running MySQL server 3.23.43 -max-debug client version 3.23.3 alpha. I was also able to connect to the server. At the bottom of the window I saw one button with plus sign, when I do mouse over on it there is this pop msg ; you have not created client options file, which is highly recommended. Pls, how do i create this and of what important is the file. Regards. kamal. It is not that important. But it might be beneficial. It could enable you to view help file, store history where you wish , share it with mysql etc ... There are some conf files that came with mysqlgui. This is all thoroughly documented in documentation that came with mysqlgui. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Embedded MySQL server the outside world
Marek Kustka writes: Hi folks, does embedded server tcp-listen to the outside world i.e. it could be used by another app or perhaps been accessed by the same app using ODBC? Nope. OR is MySQL C API the only way to control it? Yes, so far. But other API's could be built on top of it ... Thanks, Marek -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
I must be mental but.
I compiled without problem mysql on Redhat linux 7.1 I have just started the sever using nohup /usr/local/mysql/libexec/mysqld This started fine without problem. as I am used to using Oracle and new to mysql I decided to do an mysql_install_db which prompted me saying remember to change password using mysqladmin -p password `password` I did this and it asked me for a password ?? what is the password and how do I change it. This command to me suggests that -p password enters the password password and the `password` is the new password ??? can someone explain ?? Thanks, Matt. - 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: Default 1 == Default 16777216?
On Wed, Dec 12, 2001 at 02:35:15PM +0200, Sinisa Milivojevic wrote: : Philip Molter writes: : Description: : : When I do this: : :mysqlcreate table test_default ( testint int not null default 1 ); :mysqldesc test_default; : : I get: : :+-+-+--+-+--+---+ :| Field | Type| Null | Key | Default | Extra | :+-+-+--+-+--+---+ :| testint | int(11) | | | 16777216 | | :+-+-+--+-+--+---+ :1 row in set (0.00 sec) : : Why does my default not go in as '1'. I've tried it with and : without quotes. This is vexing. Is there something obvious that : I'm just not doing correctly? : : How-To-Repeat: : : : Hi! : : As there is a binary for your SPARC Solaris 2.8, please try it out : and see if you get the same result. Yeah, let me amend this. It's not happening with MyISAM tables, only with InnoDB tables, and it is happening with the pre-compiled binaries from the web site. It's definitely an endian issue. * Philip Molter * Texas.net Internet * http://www.texas.net/ * [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: find_in_set syntax
mysql create table gd_records( - id int unsigned auto_increment, - res_skills set(skills1,skills2,skills3,skills4,skills5,skills6), - res_skills_ma set(skills_ma1,skills_ma2,skills_ma3,skills_ma4,skills_ma5,skills_ma6), - primary key(id)); Query OK, 0 rows affected (0.00 sec) [Enter some values] mysql select * from gd_records; ++-++ | id | res_skills | res_skills_ma | ++-++ | 1 | skills1,skills2 | skills_ma4,skills_ma5 | | 2 | skills2,skills4 | skills_ma2,skills_ma3 | | 3 | skills1,skills3 | skills_ma3,skills_ma6 | | 4 | skills4,skills5 | skills_ma2,skills_ma6 | | 5 | skills1,skills4 | skills_ma2,skills_ma3 | | 6 | skills1,skills2,skills3 | skills_ma1,skills_ma3,skills_ma5 | | 7 | skills3,skills4,skills5,skills6 | skills_ma1,skills_ma2,skills_ma3,skills_ma5,skills_ma6 | | 8 | skills1,skills3,skills4,skills6 | skills_ma2,skills_ma4,skills_ma5,skills_ma6| ++-++ 8 rows in set (0.00 sec) mysql SELECT FROM gd_records WHERE FIND_IN_SET(skills3,res_skills) AND FIND_IN_SET(skills_ma3,res_skills_ma); ++-++ | id | res_skills | res_skills_ma | ++-++ | 3 | skills1,skills3 | skills_ma3,skills_ma6 | | 6 | skills1,skills2,skills3 | skills_ma1,skills_ma3,skills_ma5 | | 7 | skills3,skills4,skills5,skills6 | skills_ma1,skills_ma2,skills_ma3,skills_ma5,skills_ma6 | ++-++ 3 rows in set (0.00 sec) Tadam you can't use the WHERE col_name value ehrne you have more than one SET afaik HTH, Etienne Wiliam Stephens wrote: At 17:40 11/12/01, you wrote: Can you provide your table description? You have two set colums? One called res_skills and one called res_skills_ma ? Yeah, Both are SET columns. Wil -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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: [OT] A News Group Perhaps.
Well that's called a forum and it's not at all like a mailing list :-) But yes there could be a forum, but there are already some on the net www.devshed.com have a mySQL part and a Perl part and a PHP part. Plus a forum requires servers, space, web hosting, DNS, maintenance, moderation, programming.. the mailing list is al up and running. I don't like vbulletin, well I don't like the fact that you get the header and wait, wait and wait for the body to display, it's getting the messages out of the DB everytime a user loads a page and the little 3-4 seconds it takes to get the info is annoying :) my 2 cents Etienne Kelly Firkins wrote: I would vote in favor of using vbulletin (www.vbulletin.com) it's got forums for talk like this, web-based, and runs off of the MySQL server as a back-end. An example in action is vbulletin itself or community.installshield.com. Very slick indeed. Kelly FYI, I'm somewhat biased in favor of it because I have set up this program and know how well it works. It's a great example of PHP and MySQL working together. Hi Matt, I am sure this has been said before so my apologies if I bore! Most mail clients let you setup rules. For the mySQL list I automatically redirect all messages into a separate folder based on the [EMAIL PROTECTED] email address. This creates a fabulous resource that can be searched (title and text) and can be read or ignored by choice. I am not a great fan of Newsgroups - they get spammed too much and messages get lost or archived. Some ISPs carry them, some don't. All too hit and miss for a resource on which I rely and am very grateful for. Tony - Original Message - From: Matthew Darcy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, December 12, 2001 10:58 AM Subject: RE: A News Group Perhaps. Hi, I was wondering if the mysql list had any plans to be put onto a news group. I have only been a memeber a short time but I have found %50 of the information to be usefull. This does however mean that %50 is does not apply to me at this time. Due to this I get a lot of emails that are of no use to me at the moment. I would be keen to talk about hosting this list as a news group to make it browsable so myself and others could pick out infromation that is usefull to me at this time. The email list could stay for mass contributions but I would rather just browse for information I need. Any thoughts on this ? Thanks, Matt. - 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 -- Kelly Firkins [EMAIL PROTECTED] _ Chat with friends online, try MSN Messenger: http://messenger.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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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
user permissions in linux
Hi, I'm new to both MySQL and LINUX, however still managed to kind of get them up and running. I installed MySQL whilst I was logged in as ROOT. Now I can only run it when I log is as ROOT. How do change permissions of the other users so they can also run MySQL or create a new user which will have full access to MySQL (basically grants so a user can take advantage of MyODBC. Regards, Faizal. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - 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: Each user have only see databases they have access too
I believe that phpmyAdmin uses the show databases syntax to see what is available. To prevent it from seeing any db which the user is not authorized, set the safe_show_database = 1 in the my.ini file (or my.cnf). This will prevent show databases from returning a list of all dbs available. kelly Im running MySQL on my Win98 Desktop and Ive created a new user and only granted access to one database, but when I use myPhpAdmin the user can still see all the databases. What can I do so that each user only see the databases they have access too. Always an Email Away Kevin Campbell Chief Executive Officer The Club Mix, Inc. http://www.theclubmix.com -- Kelly Firkins [EMAIL PROTECTED] _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.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: connecting to mysql from different computer
Good morning Kamal, From: [EMAIL PROTECTED] More so will i need to open MySQL server on my local machine before running MySQL client to connect to the remote machine e.g. No. The service (mysqld) is strictly assigned to managing the local database(s) and to serve access to those databases to whomever it sees fit. The question of who is seen as fit is determined by the GRANT statements used earlier. The client simply connects to a MySQL server someplace. That server might be local, or it might be on the other side of the planet. --- Rodney Broom Programmer: Desert.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
RE: [OT] A News Group Perhaps.
Actually I setup a vBulletin forum for MySQL over at www.mysqlforums.com and I am the moderator of the MySQL and Server Configuration forums over at www.vbulletin.com/forum/ I've been keeping an archive of the mailing lists, mainly for my own purposes to search through old questions and answers from these lists, but I certainly would like to offer it to others that would find it useful for searching for older threads and for those that prefer a web-based solution over email lists. Chris Schreiber -Original Message- From: Kelly Firkins [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 8:22 AM To: [EMAIL PROTECTED] Subject: Re: [OT] A News Group Perhaps. I would vote in favor of using vbulletin (www.vbulletin.com) it's got forums for talk like this, web-based, and runs off of the MySQL server as a back-end. An example in action is vbulletin itself or community.installshield.com. Very slick indeed. Kelly FYI, I'm somewhat biased in favor of it because I have set up this program and know how well it works. It's a great example of PHP and MySQL working together. Hi Matt, I am sure this has been said before so my apologies if I bore! Most mail clients let you setup rules. For the mySQL list I automatically redirect all messages into a separate folder based on the [EMAIL PROTECTED] email address. This creates a fabulous resource that can be searched (title and text) and can be read or ignored by choice. I am not a great fan of Newsgroups - they get spammed too much and messages get lost or archived. Some ISPs carry them, some don't. All too hit and miss for a resource on which I rely and am very grateful for. Tony - Original Message - From: Matthew Darcy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, December 12, 2001 10:58 AM Subject: RE: A News Group Perhaps. Hi, I was wondering if the mysql list had any plans to be put onto a news group. I have only been a memeber a short time but I have found %50 of the information to be usefull. This does however mean that %50 is does not apply to me at this time. Due to this I get a lot of emails that are of no use to me at the moment. I would be keen to talk about hosting this list as a news group to make it browsable so myself and others could pick out infromation that is usefull to me at this time. The email list could stay for mass contributions but I would rather just browse for information I need. Any thoughts on this ? Thanks, Matt. - 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 -- Kelly Firkins [EMAIL PROTECTED] _ Chat with friends online, try MSN Messenger: http://messenger.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 - 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: Anti-SPAM (was: A News Group Perhaps)
On Wed, 2001-12-12 at 06:49, Carl Troein wrote: Tony Buckley writes: I am not a great fan of Newsgroups - they get spammed too much and messages get lost or archived. Some ISPs carry them, some don't. All too hit and miss for a resource on which I rely and am very grateful for. I agree, but sadly enough the spam part is true for this list as well. I completely agree with whomever proposed to have this list modified to accept mails from subscribed people only An alternative that has just been implemented on the PHP lists is to keep an approved list of addresses in addition to a subscribed list. If mail is sent from either approved or subscribed addresses, then it is sent on to the list. Otherwise, an automated reply is sent to the sending address that requires a reply to allow the post to go through - this eliminates 99%+ of spam I'd bet - at least from examining my Shred folder (I file the, uh, stuff there and feed it to an anti-spam system called Razor once a day). Anyway, if a reply is made to the automated message, then the address is added to the approve pile for future posts. Billy -- database,sql,query,table - 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
To many processes, 100% CPU usage...HELP
We just upgraded a box (RH 7.2) to current Apache, PHP, and MySQL. We used the MySQL binary for 3.23.46. On the old box which was nearly identical we were running 3.23.43 (I think). The old box didn't have any problems w/ MySQL but this box is having problems. The only real thing that changed was the version of MySQL, PHP, RH, etc. Can someone offer some insight into what might be going on here? Any suggestions on how to fix the problem. The connections are PHP non-persistent connections for a very active web based message board system. Again, keep in mind that this very similar setup was working flawlessly the day before yesterday on a lesser box. Current Box: Dual PIII 1G, w/ 2G of ram. Database is a message board database that is only 250,000 rows and only 57M in size. The problem is that mysqld is taking up all the CPU. Usually there are only a dozen mysqlds running sometimes there are as many as 200+. Regardless of how many daemons are running they take all the CPU and it appears that memory used is possibly growing. Sometimes the RSS will run up to 120M+ Please HELP, this is a live box (not so live now) and my users can't access the site. I can't turn up the old box because it's in transit via UPS back from my Co-location facility.1 TIA, Charlie Here's a sample from top PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND 20395 mysql 17 0 58104 56M 1696 R48.2 2.8 0:04 mysqld 20477 mysql 15 0 58108 56M 1696 R30.1 2.8 0:02 mysqld 20338 mysql 16 0 58104 56M 1696 S 4.3 2.8 0:06 mysqld 20492 mysql 20 0 58712 57M 1696 R 4.2 2.8 0:01 mysqld 20265 mysql 17 0 58104 56M 1696 R 4.1 2.8 0:10 mysqld 20353 mysql 18 0 58104 56M 1696 R 4.1 2.8 0:04 mysqld 20359 mysql 16 0 58104 56M 1696 S 4.1 2.8 0:06 mysqld 20362 mysql 16 0 58104 56M 1696 R 4.1 2.8 0:05 mysqld 20413 mysql 18 0 58108 56M 1696 R 4.0 2.8 0:04 mysqld 20349 mysql 17 0 58104 56M 1696 R 3.9 2.8 0:06 mysqld 20496 mysql 17 0 58712 57M 1696 R 3.9 2.8 0:01 mysqld 19458 mysql 14 0 57724 56M 1696 S 3.8 2.8 0:08 mysqld 20437 mysql 16 0 58108 56M 1696 R 3.8 2.8 0:02 mysqld 20444 mysql 16 0 58108 56M 1696 R 3.8 2.8 0:03 mysqld 20445 mysql 17 0 58108 56M 1696 R 3.7 2.8 0:03 mysqld 20522 mysql 18 0 58712 57M 1696 R 3.7 2.8 0:01 mysqld 20335 mysql 14 0 58104 56M 1696 S 3.6 2.8 0:07 mysqld 20388 mysql 20 0 58652 57M 1696 R 3.6 2.8 0:05 mysqld 20391 mysql 20 0 58652 57M 1696 R 3.6 2.8 0:04 mysqld 20410 mysql 14 0 58108 56M 1696 R 3.5 2.8 0:04 mysqld 20474 mysql 15 0 58108 56M 1696 R 3.5 2.8 0:03 mysqld 20489 mysql 17 0 58152 56M 1696 R 3.5 2.8 0:01 mysqld 20527 mysql 20 0 58728 57M 1696 R 3.5 2.8 0:01 mysqld - - 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
[OT] RE: ADV: Dear Future Millionaire: (very OT in a way)
GRIN The problem is that you all are close-minded. Here, somebody as taken the time to offer you an opportunity to make millions from the internet, and you insult him. INGRATES...all of you...INGRATES I, for plan to avail myself of this fine opportunity. In a year, I'll be basking on the beaches of Monaco, while you all slave over a hot terminal worried about mySQL's next release. BWA-HA-HA-HA-HA-... /GRIN -Original Message- From: Carl Troein [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 7:19 AM To: [EMAIL PROTECTED] Subject: Re: ADV: Dear Future Millionaire: (very OT in a way) Etienne Marcotte writes: How come this passed the spam filter? Which word it had that was on the mandatory words list ? EEek! Noo... but that can't be.. or...? Is the whole thing about the MySQL database just a hoax to get people to subscribe to this list so that the people at MySQL can get rich by sending us spam? :-o //C - In insane conspiracy theory generation mode -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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
NOT NULL field accepting NULL
Hi All, In MySQL, Even i declared a field as NOT NULL it is accepting nulls .What might be the problem. please let me know. regards, sreedhar - 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: user permissions in linux
Check out the GRANTS section in the MYSQL manual -Original Message- From: Faizal Mangera [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 9:38 AM To: [EMAIL PROTECTED] Subject: user permissions in linux Hi, I'm new to both MySQL and LINUX, however still managed to kind of get them up and running. I installed MySQL whilst I was logged in as ROOT. Now I can only run it when I log is as ROOT. How do change permissions of the other users so they can also run MySQL or create a new user which will have full access to MySQL (basically grants so a user can take advantage of MyODBC. Regards, Faizal. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - 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: Each user have only see databases they have access too
Which group(s) would this go under in the my.cnf ?? On Wed, 12 Dec 2001 07:27:54 -0600, Kelly Firkins [EMAIL PROTECTED] wrote: I believe that phpmyAdmin uses the show databases syntax to see what is available. To prevent it from seeing any db which the user is not authorized, set the safe_show_database = 1 in the my.ini file (or my.cnf). This will prevent show databases from returning a list of all dbs available. kelly Im running MySQL on my Win98 Desktop and Ive created a new user and only granted access to one database, but when I use myPhpAdmin the user can still see all the databases. What can I do so that each user only see the databases they have access too. Always an Email Away Kevin Campbell Chief Executive Officer The Club Mix, Inc. http://www.theclubmix.com Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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: Circular replication
even/odd is a little limiting, what happens down the road when another site needs to be added. A better method might be to use a unique session ID for each client site in combination with a generated sequence ID see the white paper at:http://www.ambysoft.com/persistenceLayer.html in particular the persistenceLayer.pdf document on that page. Duncan Maitland wrote: My questions concern a setup where a public server is running at our hosting company and a local office server is behind a firewall (connected to the net via a somewhat unreliable ADSL). The servers are configured in a circular master-slave relationship but only a limited number of tables in the database are replicated between the two (public doesn't need all of them, so no use in replicating). Of these tables only 3 need to accept writes from both the public and office server (all the other writes happen at the office). Of those 3 tables only 1 makes use of a unique primary key. So my questions are: 1) Replicating a table with a primary key raises the possibility of conflicts if, while the office link is broken, two records are created with the same key. So I plan to generate my own keys in the project source code (without auto_increment) - the public site generates records with even numbers, the office site with odd numbers. Is this a reasonable setup or is there a more correct way? Out of interest, how will MySQL 4.0 replication handle this situation? 2) MySQL docs state It is possible for client A to make an update to co-master 1, and in the meantime, before it propagates to co-master 2, client B could make an update to co-master 2 that will make the update of client A work differently than it did on co-master 1. Thus when the update of client A will make it to co-master 2, it will produce tables that will be different than what you have on co-master 1, even after all the updates from co-master 2 have also propagated. Say the office link is down, and a particular record in the above-mentioned table is edited on both the public and office servers. When the servers re-sync will one record take precedence (if so, which one?) or does the public get one and the office get the other? The former seems to be the case when doing basic testing on my LAN at home, but the MySQL doc is confusing in that it implies the latter. To those of you who have read all the way down to here, I thank you very much! :) Cheers, from Duncan Maitland [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 -- Regards, Brent interactivetools.com, inc. Tel: (604)689-3347 - Fax: (604)689-3342 - Toll Free: 1(800)752-0455 Software for your Website - http://www.interactivetools.com/ Attachments accepted: TXT, HTML, RTF, PDF I do not accept attachments which are capable of harbouring viruses, for example Word for Windows. Please use File/Save As RTF or HTML. - 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: NOT NULL field accepting NULL
At 7:12 PM +0530 12/12/01, sreedhar wrote: Hi All, In MySQL, Even i declared a field as NOT NULL it is accepting nulls .What might be the problem. please let me know. regards, sreedhar That's not enough information. Let's see the CREATE TABLE statement, a sample INSERT statement, and the resulting record. - 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: NOT NULL field accepting NULL
No, it's not accepting NULL if it was declared as NOT NULL. It's just accepting an empty sting ( ). CREATE TABLE test (t VARCHAR(10) NOT NULL); INSERT INTO test SET t = NULL; INSERT INTO test SET t = ''; First insert will tell you what you're waiting for. And the second one will do what you're asking for. Empty string is not NULL. sreedhar wrote: s: Date: Wed, 12 Dec 2001 19:12:41 +0530 s: From: sreedhar [EMAIL PROTECTED] s: To: mysql [EMAIL PROTECTED] s: Subject: NOT NULL field accepting NULL s: s: Hi All, s: s: In MySQL, Even i declared a field as NOT NULL it is accepting nulls .What s: might be the s: problem. please let me know. s: s: regards, s: sreedhar s: s: s: - s: Before posting, please check: s:http://www.mysql.com/manual.php (the manual) s:http://lists.mysql.com/ (the list archive) s: s: To request this thread, e-mail [EMAIL PROTECTED] s: To unsubscribe, e-mail [EMAIL PROTECTED] s: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php s: -- Sherzod Ruzmetov [EMAIL PROTECTED] http://www.UltraCgis.com, Consultant 989.774.6265 ++ | There is nothing wrong with your tools.| | But we can make a better one. | ++ - 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 to char in table with several varchar's
At 9:32 AM +0100 12/12/01, Willem Bison wrote:
I have a table with several columns of type 'varchar'. How can I change all
columns to fixed width char's ? Doing a 'alter' from varchar to char has no
effect since the column is changed back to varchar.
You have to change them all at ones in the same ALTER TABLE statement.
Here's a Perl DBI function that takes a database handle and a table
name, and returns the ALTER TABLE statement to do what you want.
(You have to execute the statement yourself; the return value is undef
if the table contains no applicable columns.)
sub alter_to_char
{
my ($dbh, $tbl_name) = @_;
my ($sth, $str);
$sth = $dbh-prepare (SHOW COLUMNS FROM $tbl_name);
$sth-execute ();
while (my @row = $sth-fetchrow_array ())
{
if ($row[1] =~ /^varchar/) # it's a VARCHAR column
{
$row[1] =~ s/^var//;
$str .= ,\n\t if $str;
$str .= MODIFY $row[0] $row[1];
$str .= ($row[2] eq YES ? : NOT) . NULL;
$str .= DEFAULT . $dbh-quote ($row[4]);
}
}
$sth-finish ();
$str = ALTER TABLE $tbl_name\n\t$str if $str;
return ($str);
}
Or, if you wanna go in the other direction:
sub alter_to_varchar
{
my ($dbh, $tbl_name) = @_;
my ($sth, $str);
$sth = $dbh-prepare (SHOW COLUMNS FROM $tbl_name);
$sth-execute ();
while (my @row = $sth-fetchrow_array ())
{
if ($row[1] =~ /^char/) # it's a CHAR column
{
$row[1] = var . $row[1];
$str .= ,\n\t if $str;
$str .= MODIFY $row[0] $row[1];
$str .= ($row[2] eq YES ? : NOT) . NULL;
$str .= DEFAULT . $dbh-quote ($row[4]);
}
}
$sth-finish ();
$str = ALTER TABLE $tbl_name\n\t$str if $str;
return ($str);
}
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
my.cnf settings
Which group(s) would the following options be put under to enable in the my.cnf. safe_show_database skip_show_database Thx's mysql sql database Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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 in NFS
I have done oracle on NFS and it is not really the best option due to NFS locking. ie a poor network or if the NFS server drops, or the NIS/NIS+ (assuming you are using automount maps) dies this will hold your development/production up no end. Also oracle's table locking (not sure if mysql has this) causes problems over NFS. The only time I have seen it work ok was on a veritas cluster using the Oracle/NFS export as a failover and it worked BAD the machine failed over quite a few times and picked up but the machines had to be very powerfull as there was tons of rollbacks and non commited transactions, and non bound variables over NFS was s slow. I am sure you could do it but it is not wise. I have stored Oracle binarys on NFS so that clients could access oracle and manage it over NFS but never had good performance keeping the data on NFS. Matt. -Original Message- From: Shen, Lei (CIT) [mailto:[EMAIL PROTECTED]] Sent: 12 December 2001 14:28 To: [EMAIL PROTECTED] Subject: Mysql in NFS Hi! Dose anyone has a experience to building mysql database in network files system? and php? can you get me some information? thank you -Original Message- From: Marek Kustka [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 8:23 AM To: [EMAIL PROTECTED] Subject: Embedded MySQL server the outside world Hi folks, does embedded server tcp-listen to the outside world i.e. it could be used by another app or perhaps been accessed by the same app using ODBC? OR is MySQL C API the only way to control it? Thanks, Marek - 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
Problem with bk://work.mysql.com ?
Hi, When I try to do a bk pull, I have the following unexpected message : bk pull bk://work.mysql.com:7001: No route to host What's wrong ? Best Regards, Jocelyn Fournier Presence-PC - 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
Select with multiple records
Greetings- I have a MySQL database with a table (job_table) containing information concerning jobs I run. Among the fields on the table are job_id (varchar(10)), and timestamp (a timestamp). As I run jobs, I add an entry to the table with the job_id, timestamp, and associated information, so the table contains multiple entries for any given job_id. I would like to be able to run a select on the table to retrieve the latest entry for each job_id so I can display a latest status message for every job. How do I (assuming that I can) construct the SELECT statement to do this? Thanks! Greg Lindstrom Acxiom Corporation,mail: CWY10011149 InfoBase Products Development office: (501) 342-1626 301 Industrial Blvd, Conway, AR, 72032 fax: (501) 336-3911 email: [EMAIL PROTECTED] Programming requires discipline. Period. If you're depending on a compiler to catch sloppy thinking, then you've got trouble. John Roth - 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: Nested Inner Joins
On Tue, Dec 11, 2001 at 07:34:11PM -0800, Kendra L Knudtzon wrote: I am having problems with this nested inner join statement: SELECT tblMethodType.MethodType, tblMethodParm.MethodName, tblParm.ParmName, tblParm.Label, tblParm.Value, tblParm.Unit, tblParm.Tip FROM tblMethodType INNER JOIN (tblMethod INNER JOIN (tblParm INNER JOIN tblMethodParm ON tblParm.idParm = tblMethodParm.idParm) ON tblMethod.MethodName = tblMethodParm.MethodName) ON tblMethodType.MethodType = tblMethod.MethodType; I have not had much experience with INNER JOINS, and I read one website that said the MySql can't support grouped inner joins... If this is true, how do I get this type of command to execute under MySql (I inherited this code but the statement apparently worked with Microsoft Access) MySQL supports grouped INNER JOINs just fine. But you can't put an inner INNER JOIN between the outer INNER JOIN and the ON keyword. Try FROM (inner INNER JOIN clause) INNER JOIN tblMethodType ON ... Do the same thing with the innermost INNER JOIN clause. What you typed above works fine in Access because Access doesn't care about the order. Bob Hall -- Kanskje, kanskje en gang - sier du til meg - database, table, query RolfJacobSQL - 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: find_in_set syntax
At 17:40 11/12/01, you wrote: Can you provide your table description? You have two set colums? One called res_skills and one called res_skills_ma ? Yeah, Both are SET columns. Wil - 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
matching an option from SET list
Hello
I've got a problem selecting values that match an option from a SET column.
My two columns are set up as follows:
res_places SET('North','West','South')
res_places_re SET('Aber','Cardiff','Bangor')
And I'm currently using the following MySQL query:
SELECT * FROM gd_records WHERE (res_places 3) AND (res_places_re
1);
Which turns out very strange resutls.
What I'm trying to do (in english) is to select records from the database
which matches option 3 in SET column res_places AND matches option 1 in SET
column res_places_re.
For some reason my SQL query does not give me the desired results. I know
that a record matches both these criteria but yet this omits that record
when returning result.
Is the SQL query I am using correct? Is this the correct way of going about
what I'm trying to do? I don't want to use FIND_IN_SET because I won't
always know the SET option name to pass to FIND_IN_SET.
Thanks for your help.
Wiliam Stephens
Web Developer
http://www.fbagroup.co.uk
-
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 in NFS
For mysql, if your datafiles will not fit in ram, I would highly recommend not putting it on nfs. Mysql doesn't have any data caching, so every query will have to go thru the network to get the data. if, however, you do have enough ram on the machine to store all the datafiles in memory, then we have not seen this problem. But the other points that Matthew brought up about network connectivity till apply. OT, Matthew, we've got oracle running over NFS on NetAPP filers and we've had extremely good performance. Of course we have 100Meg or GigE between them, but the only problems we ever have is when we have queries that do full table scans. Anyways just my couple pennies.. --shak Matthew Darcy wrote: I have done oracle on NFS and it is not really the best option due to NFS locking. ie a poor network or if the NFS server drops, or the NIS/NIS+ (assuming you are using automount maps) dies this will hold your development/production up no end. Also oracle's table locking (not sure if mysql has this) causes problems over NFS. The only time I have seen it work ok was on a veritas cluster using the Oracle/NFS export as a failover and it worked BAD the machine failed over quite a few times and picked up but the machines had to be very powerfull as there was tons of rollbacks and non commited transactions, and non bound variables over NFS was s slow. I am sure you could do it but it is not wise. I have stored Oracle binarys on NFS so that clients could access oracle and manage it over NFS but never had good performance keeping the data on NFS. Matt. -Original Message- From: Shen, Lei (CIT) [mailto:[EMAIL PROTECTED]] Sent: 12 December 2001 14:28 To: [EMAIL PROTECTED] Subject: Mysql in NFS Hi! Dose anyone has a experience to building mysql database in network files system? and php? can you get me some information? thank you -Original Message- From: Marek Kustka [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 8:23 AM To: [EMAIL PROTECTED] Subject: Embedded MySQL server the outside world Hi folks, does embedded server tcp-listen to the outside world i.e. it could be used by another app or perhaps been accessed by the same app using ODBC? OR is MySQL C API the only way to control it? Thanks, Marek - 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 -- Shakeel Sorathia Systems Administrator (626) 660-3502 - 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: Select with multiple records
can't you select the latest timestamp? On Wed, 12 Dec 2001, Lindstrom Greg - glinds wrote: Greetings- I have a MySQL database with a table (job_table) containing information concerning jobs I run. Among the fields on the table are job_id (varchar(10)), and timestamp (a timestamp). As I run jobs, I add an entry to the table with the job_id, timestamp, and associated information, so the table contains multiple entries for any given job_id. I would like to be able to run a select on the table to retrieve the latest entry for each job_id so I can display a latest status message for every job. How do I (assuming that I can) construct the SELECT statement to do this? Thanks! Greg Lindstrom Acxiom Corporation,mail: CWY10011149 InfoBase Products Development office: (501) 342-1626 301 Industrial Blvd, Conway, AR, 72032 fax: (501) 336-3911 email: [EMAIL PROTECTED] Programming requires discipline. Period. If you're depending on a compiler to catch sloppy thinking, then you've got trouble. John Roth - 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
FW: Embedded Server Binary
-Original Message- From: Scroggin, Steve Sent: Tuesday, December 11, 2001 8:47 AM To: '[EMAIL PROTECTED]' Cc: Firemon Support Subject: Embedded Server Binary MySQL Representative: Your website states that downloading the binary is better than compiling from the source code; however, there isn't a Windows download link for an embedded server binary. I downloaded the source code and the file mysql.cc was missing. Would you send me a Windows embedded server binary (libmysqld.lib)? We have plans to purchase MySQL for use in our product, FireMon, a Check Point Firewall revision control application. Respectfully, Steve Steven Scroggin Programmer FishNet Security Ph: 816-421-6611 http://www.fishnetsecurity.com/ Breaking News: FishNet's product, FireMon http://www.firemon.com, achieves Check Point's OPSEC http://www.opsec.com certification 2000 Top 10 Kansas City Small Business 2000 Deloitte Touche Fast 50 Rising Star 2000 Check Point Fastest Central Region Revenue Growth Award Winners 1999 Check Point Fastest Central Region Revenue Growth Award Winners 1999 CRN Top 25 Computer Executives 1998 Check Point Excellence Award Winners Some Integrators have Network Security Divisions, FishNet is a Network Security Company. Who would you trust with your Network Security ? __ The information transmitted in this e-mail is intended only for the addressee and may contain confidential and/or privileged material. Any interception, review, retransmission, dissemination, or other use of, or taking of any action upon this information by persons or entities other than the intended recipient is prohibited by law and may subject them to criminal or civil liability. If you received this communication in error, please contact us immediately at 816.421.6611, and delete the communication from any computer or network system. __ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
High load problem with 3.23.45
Maybe some coding/mysql master out there knows an answer to this tricky problem... We've recently migrated all our mysql servers from 3.23.42 to 3.23.45 without any problems except for one server. That linux server shows after startup of mysql after 1 or 2 minutes an exceptionally high load and the load will rise until the server ends up in nirvana (I've seen a load of 80 and more) Some infos on the server: Distribution: Suse 7.2 kernel: 2.4.4 glibc: 2.2.2 gcc: 2.9.53 We've profiled mysqld with following results (grpof): *** Flat profile: Each sample counts as 0.01 seconds. % cumulative self self total time seconds secondscalls us/call us/call name 48.10 4.69 4.69 3682 1273.76 1273.76 _nl_get_alt_digit 23.90 7.02 2.33 getpid 20.92 9.06 2.04 regex_compile 4.10 9.46 0.40 708096 0.56 0.56 __array_type_info type_info function 1.44 9.60 0.14 lock_update_insert 0.31 9.63 0.03 12 2500.00 2500.09 chk_del 0.21 9.65 0.02 28869.4469.44 find_best(JOIN *, unsigned long, unsigned int, double, double) 0.21 9.67 0.02 __mktime_internal 0.10 9.68 0.01 285302 0.04 0.04 sort_get_next_record 0.10 9.69 0.0121066 0.47 0.47 _IO_vfscanf 0.10 9.70 0.01 4106 2.44 9.73 mysql_execute_command(void) *** As you can see most of the time is spend in the functions _nl_get_alt_digit, getpid and regex_compile. The profile log of another server running mysql 3.23.45 looks completely different. Most of the time on this server is spend in the select method what seems to be just perfect. Here is the profile log of the functioning server: *** Flat profile: Each sample counts as 0.01 seconds. % cumulative self self total time seconds secondscalls us/call us/call name 13.92 0.11 0.11 select 11.39 0.20 0.091 9.00 9.33 buf_pool_create 7.59 0.26 0.06 memset 6.33 0.31 0.05 __libc_accept 6.33 0.36 0.05 __mcount_internal 6.33 0.41 0.05 chunk_alloc 6.33 0.46 0.05 vfprintf 5.06 0.50 0.04 336311.8911.89 init_io_cache 5.06 0.54 0.04 pthread_handle_sigrestart 2.53 0.56 0.02 2721 7.35 7.35 create_new_thread(THD *) 2.53 0.58 0.02 12 1666.67 1666.67 hash_create 2.53 0.60 0.021 2.00 21666.67 recv_apply_hashed_log_recs 2.53 0.62 0.02 __pthread_alt_unlock ** We've compiled mysql on both servers with following configure options: CFLAGS=-O3 -p -mpentiumpro CXX=gcc CXXFLAGS=-O3 -p -mpentiumpro -felide-constructors -fno-exceptions -fno-rtti ./configure --prefix=/usr/local/mysql --enable-assembler --with-debug --with-mysqld-ldflags=-all-static -p --localstatedir=/usr/local/mysql/data -with-innodb And both servers are running the same system and (hopefully) the same configuration. Any ideas Thanks in advance for your help. - 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
Problem with ODBC and BLOB
HI I installed MyODBC on an NT server to connect via the internet to my Linux box that runs mysql3.23. I have already populated tables in a db that I am trying to link to the NT server via ODBC, but I am getting errors when trying to do this. The table is created with an id field ( BIGINT (255)) , a key field varchar(16) and then a whole bunch of other fields of type text. All have Null = No yet some of the fields do have null entries (not sure if this is where the problem comes in). So, when we tried to connect, MS SQL complains about a fieldname that has no entry and quits. As soon as I temporarily put something in that field for that specific row, it goes further, to the next empty field and then complains about it. So it seems like MS SQL doesn't like the fact that I either used text as the type, or it doesn't like the fact that some fields are empty. Strangest of all, when I do a statis import in access of the same table as is, it imports it 100%. How can I fix this? Is this a problem of conversion between mysql and ms-sql? Should I fix this on the mysql side or on the ms-sql side? What is the correct type to use for my fields ( I only read normal form text field data from websites, so I though text was the correct type to use as I don't really cae if some of the fields are empty), and what should my fields be then, null or not null? I normally use phpMyAdmin to create new tables on the fly and it's default setting is Null = no, and it always worked fine for me so far. Please can someone help me to fix this, I don't want to change my field types fi not absolutely necessary due to incorrect practise on my side. I already have an entire system running on these tables and wouldn't want to go and fiddle around with field types and run the danger that some obscure sql string somewhere in my long forgotten code will now fail to add to some tables because of that, so, basically I'd like to see a ms-sql fix for this unless, like I said, you can clearly show me that I used improper protocol to create my tables from the start, and that to conform to accepted SQL standards, I should change field types... Thanks for your help. - 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: Anti-SPAM (was: A News Group Perhaps)
Hi, The TurboPower new groups (news://news.turbopower.com) seem to work fine, with little spam. Because they host the news groups themselves, there is no problem with them not being hosted by a particular ISP. It would be really nice to have a new group, but the ground has been covered so many times before, it obviously isn't going to happen. m2cw QB -Original Message- From: Thrill [mailto:[EMAIL PROTECTED]] Sent: Thursday, 13 December 2001 2:39 a.m. To: [EMAIL PROTECTED] Subject: Re: Anti-SPAM (was: A News Group Perhaps) On Wed, 2001-12-12 at 06:49, Carl Troein wrote: Tony Buckley writes: I am not a great fan of Newsgroups - they get spammed too much and messages get lost or archived. Some ISPs carry them, some don't. All too hit and miss for a resource on which I rely and am very grateful for. I agree, but sadly enough the spam part is true for this list as well. I completely agree with whomever proposed to have this list modified to accept mails from subscribed people only An alternative that has just been implemented on the PHP lists is to keep an approved list of addresses in addition to a subscribed list. If mail is sent from either approved or subscribed addresses, then it is sent on to the list. Otherwise, an automated reply is sent to the sending address that requires a reply to allow the post to go through - this eliminates 99%+ of spam I'd bet - at least from examining my Shred folder (I file the, uh, stuff there and feed it to an anti-spam system called Razor once a day). Anyway, if a reply is made to the automated message, then the address is added to the approve pile for future posts. Billy -- database,sql,query,table - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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
multiple select with single command.
Are there plans for mysql to have the capabilities to execute single sql statement with nested SELECT . or Is there a way around this for the time being? Thanks - 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
Maximum Entries MySQL Can Hande
Hello there, Wondering if anyone could help with a problem. I'm upgrading a customer's server from a text based version of our program, to a MySQL based. There are 2 databases, DB1 and DB2, which contain 5 and 4 tables respectively. The upgrade script I am running simply adds information to 3 of these tables. First, a table in DB1 which contains 23 columns, each entry having from 2 to 100 characters. Then, the other two tables, one in DB1 and one in DB2, which each contain 5 columns. First column contains a number with a maximum of 5 digits, and the other four columns contain 1 digit each. Now, the upgrade script simply grabs information from many different text files and inserts it into the 3 MySQL tables. However, for some unknown reason, MySQL seems to stall or time out just after 43,530 entries. I have upgraded probably over 30 web servers now, and there has never been a problem except for this one. This one is the largest database I have upgraded yet though. Any ideas??? Would an upgrade to Oracle help at all? Is this pushing the limits of MySQL? Thank you, Matt Wagner Envex Developments Your CGI Script Specialists http://www.envex.net/ Phone: (780) 707-2657 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: High load problem with 3.23.45
Hi, I have a similar load problem when I start MySQL-4.0 and there is high number of apache process requesting MySQL connection. I had to shutdown and restart apache otherwise the load often goes up to 200 and more (!!). (there are more than 250 visitors always connected to the server, so it generates high stress for the server). This behaviour seems to occur since we upgrade the server from 2.2.x kernel to 2.4.x kernel (actually a 2.4.12-ac6 kernel). I'm wondering if this issue couldn't be linked to the new VM in 2.4.x kernel... If someone have any idea about how to solve this problem... Thanks in advance :) Jocelyn Fournier Presence-PC - Original Message - From: Arndt Jenssen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, December 12, 2001 8:27 PM Subject: High load problem with 3.23.45 Maybe some coding/mysql master out there knows an answer to this tricky problem... We've recently migrated all our mysql servers from 3.23.42 to 3.23.45 without any problems except for one server. That linux server shows after startup of mysql after 1 or 2 minutes an exceptionally high load and the load will rise until the server ends up in nirvana (I've seen a load of 80 and more) Some infos on the server: Distribution: Suse 7.2 kernel: 2.4.4 glibc: 2.2.2 gcc: 2.9.53 We've profiled mysqld with following results (grpof): *** Flat profile: Each sample counts as 0.01 seconds. % cumulative self self total time seconds secondscalls us/call us/call name 48.10 4.69 4.69 3682 1273.76 1273.76 _nl_get_alt_digit 23.90 7.02 2.33 getpid 20.92 9.06 2.04 regex_compile 4.10 9.46 0.40 708096 0.56 0.56 __array_type_info type_info function 1.44 9.60 0.14 lock_update_insert 0.31 9.63 0.03 12 2500.00 2500.09 chk_del 0.21 9.65 0.02 28869.4469.44 find_best(JOIN *, unsigned long, unsigned int, double, double) 0.21 9.67 0.02 __mktime_internal 0.10 9.68 0.01 285302 0.04 0.04 sort_get_next_record 0.10 9.69 0.0121066 0.47 0.47 _IO_vfscanf 0.10 9.70 0.01 4106 2.44 9.73 mysql_execute_command(void) *** As you can see most of the time is spend in the functions _nl_get_alt_digit, getpid and regex_compile. The profile log of another server running mysql 3.23.45 looks completely different. Most of the time on this server is spend in the select method what seems to be just perfect. Here is the profile log of the functioning server: *** Flat profile: Each sample counts as 0.01 seconds. % cumulative self self total time seconds secondscalls us/call us/call name 13.92 0.11 0.11 select 11.39 0.20 0.091 9.00 9.33 buf_pool_create 7.59 0.26 0.06 memset 6.33 0.31 0.05 __libc_accept 6.33 0.36 0.05 __mcount_internal 6.33 0.41 0.05 chunk_alloc 6.33 0.46 0.05 vfprintf 5.06 0.50 0.04 336311.8911.89 init_io_cache 5.06 0.54 0.04 pthread_handle_sigrestart 2.53 0.56 0.02 2721 7.35 7.35 create_new_thread(THD *) 2.53 0.58 0.02 12 1666.67 1666.67 hash_create 2.53 0.60 0.021 2.00 21666.67 recv_apply_hashed_log_recs 2.53 0.62 0.02 __pthread_alt_unlock ** We've compiled mysql on both servers with following configure options: CFLAGS=-O3 -p -mpentiumpro CXX=gcc CXXFLAGS=-O3 -p -mpentiumpro -felide-constructors -fno-exceptions -fno-rtti ./configure --prefix=/usr/local/mysql --enable-assembler --with-debug --with-mysqld-ldflags=-all-static -p --localstatedir=/usr/local/mysql/da ta -with-innodb And both servers are running the same system and (hopefully) the same configuration. Any ideas Thanks in advance for your help. - 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
lib error?
Hi I'd like to compile the new PHP 4.1.0, but it always stops at the libmysqlclient.a with these error messages: /usr/lib/mysql/libmysqlclient.a(dbug.o): In function `_db_unlock_file': dbug.o(.text+0xaf4): multiple definition of `_db_unlock_file' /usr/lib/mysql/libmysqlclient.a(ctype-tis620.o)(.data+0x1701): first defined here /usr/lib/mysql/libmysqlclient.a(ctype-tis620.o): In function `my_strnncoll_tis620': ctype-tis620.o(.text+0x244): multiple definition of `my_strnncoll_tis620' /usr/lib/mysql/libmysqlclient.a(ctype.o)(.data+0x684): first defined here /usr/lib/mysql/libmysqlclient.a(ctype.o): In function `find_compiled_charset_by_name': ctype.o(.text+0x0): multiple definition of `find_compiled_charset_by_name' /usr/lib/mysql/libmysqlclient.a(array.o)(.text+0x78): first defined here /usr/lib/mysql/libmysqlclient.a(array.o): In function `alloc_dynamic': array.o(.text+0xc4): multiple definition of `alloc_dynamic' and so on... We use the latest stable mysql (3.23.46-1). Could you help me, what's wrong with it? Thanks in advance! Regards Istvan - 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
Bi-Directional Replications on MySQL
Hello all, I'm moving from ASP to PHP MSSQL to Mysql, but I have some doubt. It is possible in MySQL Bi-Directional Replications? If it's, then I need to find some documentation about it. Where can I find it? TIA Pedro - 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: Select with multiple records
Greg, I have a MySQL database with a table (job_table) containing information concerning jobs I run. Among the fields on the table are job_id (varchar(10)), and timestamp (a timestamp). As I run jobs, I add an entry to the table with the job_id, timestamp, and associated information, so the table contains multiple entries for any given job_id. I would like to be able to run a select on the table to retrieve the latest entry for each job_id so I can display a latest status message for every job. How do I (assuming that I can) construct the SELECT statement to do this? =it appears that what you want is to group the job table rows by job_id and then take the most recent row as defined by the timestamp field. =The function required to choose the 'latest' (highest number) timestamp is appropriately enough called MAXIMUM(). In order to get the count to apply to a particular set of job_id rows use the GROUP BY clause (of SELECT). =Please check out the online manual for syntax and wider explanations. =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
mysql log?
Hi How can I set up our mysql server to write its logs into a log file? Thanks in advance! Regards Istvan - 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 bk://work.mysql.com ?
Fournier Jocelyn [Presence-PC] writes: Hi, When I try to do a bk pull, I have the following unexpected message : bk pull bk://work.mysql.com:7001: No route to host What's wrong ? Hi, It should be fixed now. We were doing an internet connection upgrade (from 10mb to 100mb). Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Feature request
Hi, I've got a feature request which I don't think should be all that hard to implement (if not already) With in the mysql fulltext search system if your search words exist in more than 50% of the records; it is ignored. How about having mysql return either an error or set something that can be retrieved which will notify if this event happens. A feature like this would allow people that use the FTS as the bases of a search engine to return nifty little `google like' results. The following words were not included in the search because of their commonality with in our database .. 'words' etc. -- Colin Faber (303) 859-1491 fpsn.net, Inc. - 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 bk://work.mysql.com ?
Hi, Take a look here : http://www.mysql.com/doc/I/n/Installing_source_tree.html Best Regards, Jocelyn Fournier - Original Message - From: Alexander Skwar [EMAIL PROTECTED] To: Fournier Jocelyn [Presence-PC] [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, December 12, 2001 10:47 PM Subject: Re: Problem with bk://work.mysql.com ? So sprach »Fournier Jocelyn [Presence-PC]« am 2001-12-12 um 15:04:13 +0100 : When I try to do a bk pull, I have the following unexpected message : What's a bk pull? Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.iso-top.de | Jabber: [EMAIL PROTECTED] iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 5 days 9 hours 9 minutes - 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 / ODBC BLOB problems
HI I installed MyODBC on an NT server to connect via the internet to my Linux box that runs mysql3.23. I have already populated tables in a db that I am trying to link to the NT server via ODBC, but I am getting errors when trying to do this. The table is created with an id field ( BIGINT (255)) , a key field varchar(16) and then a whole bunch of other fields of type text. All have Null = No yet some of the fields do have null entries (not sure if this is where the problem comes in). So, when we tried to connect, MS SQL complains about a fieldname that has no entry and quits. As soon as I temporarily put something in that field for that specific row, it goes further, to the next empty field and then complains about it. So it seems like MS SQL doesn't like the fact that I either used text as the type, or it doesn't like the fact that some fields are empty. Strangest of all, when I do a statis import in access of the same table as is, it imports it 100%. How can I fix this? Is this a problem of conversion between mysql and ms-sql? Should I fix this on the mysql side or on the ms-sql side? What is the correct type to use for my fields ( I only read normal form text field data from websites, so I though text was the correct type to use as I don't really cae if some of the fields are empty), and what should my fields be then, null or not null? I normally use phpMyAdmin to create new tables on the fly and it's default setting is Null = no, and it always worked fine for me so far. Please can someone help me to fix this, I don't want to change my field types fi not absolutely necessary due to incorrect practise on my side. I already have an entire system running on these tables and wouldn't want to go and fiddle around with field types and run the danger that some obscure sql string somewhere in my long forgotten code will now fail to add to some tables because of that, so, basically I'd like to see a ms-sql fix for this unless, like I said, you can clearly show me that I used improper protocol to create my tables from the start, and that to conform to accepted SQL standards, I should change field types... Thanks for your help. - 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: I must be mental but.
I compiled without problem mysql on Redhat linux 7.1 I have just started the sever using nohup /usr/local/mysql/libexec/mysqld This started fine without problem. as I am used to using Oracle and new to mysql I decided to do an mysql_install_db which prompted me saying remember to change password using mysqladmin -p password `password` I did this and it asked me for a password ?? what is the password and how do I change it. This command to me suggests that -p password enters the password password and the `password` is the new password ??? can someone explain ?? Thanks, Matt. - 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: Feature request
Hi! On Dec 12, Colin Faber wrote: Hi, I've got a feature request which I don't think should be all that hard to implement (if not already) With in the mysql fulltext search system if your search words exist in more than 50% of the records; it is ignored. How about having mysql return either an error or set something that can be retrieved which will notify if this event happens. A feature like this would allow people that use the FTS as the bases of a search engine to return nifty little `google like' results. The following words were not included in the search because of their commonality with in our database .. 'words' etc. Colin, unfortunately this feature would be difficult to add. The word that exists more than in 50% rows is not, in fact, ignored - it does not recieve any special treatment at all. What happens, is that word weight uses log((total_number_of_rows-rows_matched)/rows_matched) You see, that if rows_matched total_number_of_rows/2, this gives negative number and, as weight cannot be negative, is replaced by zero. This formula was chosen from a number of different weighting schemes in a series of tests aimed at best search effectivity. By modifying ftdefs.h it can be replaced by a formula that always produces positive weights, thus removing 50% limit. Still, all this can be changed in MySQL 4.1 or 4.2 Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
No Database Encryption
The new programmer for our company is not using the dataType password or any encryption what so ever for our user accounts (accounts that our customers use for getting into our system) in our database. Instead he is using the VarChar dataType. Can someone explain to me how I can exploit this and show them it is very dangerous. Thanks James - 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
check table
is there a way to instruct check table to check all tables without listing each table in the sql statement? - 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
Why MySQL GUI download don't work?
I tried to download MySQL GUI from these links: http://www.mysql.com/Downloads/mysqlgui/mysqlgui-win32-static-1.7.5-2.zip and http://www.mysql.com/Downloads/mysqlgui/mysqlgui-linux-static-1.7.5-1.tar.gz But all these don't work. Alex - Original Message - From: Matthew Darcy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, December 12, 2001 9:22 AM Subject: RE: I must be mental but. I compiled without problem mysql on Redhat linux 7.1 I have just started the sever using nohup /usr/local/mysql/libexec/mysqld This started fine without problem. as I am used to using Oracle and new to mysql I decided to do an mysql_install_db which prompted me saying remember to change password using mysqladmin -p password `password` I did this and it asked me for a password ?? what is the password and how do I change it. This command to me suggests that -p password enters the password password and the `password` is the new password ??? can someone explain ?? Thanks, Matt. - 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: I must be mental but.
There shouldn't be a space after -p password, also don't forget to put the user in there, unless you are using the default user (usually root, although i've noticed on win32 it seems to be 'ODBC') ex: if your password is test, the command would be mysqladmin -u user -ptest newpassword By all means, correct me if i'm wrong. It's happened before ;) Mike -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 9:22 AM To: [EMAIL PROTECTED] Subject: RE: I must be mental but. I compiled without problem mysql on Redhat linux 7.1 I have just started the sever using nohup /usr/local/mysql/libexec/mysqld This started fine without problem. as I am used to using Oracle and new to mysql I decided to do an mysql_install_db which prompted me saying remember to change password using mysqladmin -p password `password` I did this and it asked me for a password ?? what is the password and how do I change it. This command to me suggests that -p password enters the password password and the `password` is the new password ??? can someone explain ?? Thanks, Matt. - 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: No Database Encryption
it's not all that dangerous. it just means that you can read your users' passwords. anyone who can read that db table can become any of your users. password fields are just another safeguard against a just in case someone gets read access to this scenario. they also serve to provide more privacy to your users. re: some of your users may not want you / the admins of whatever service you're providing being able to read their passwords. but maybe you want to be able to read your users' passwords, for testing purposes or whatever. -tcl. On Wed, 12 Dec 2001, James McLaughlin wrote: The new programmer for our company is not using the dataType password or any encryption what so ever for our user accounts (accounts that our customers use for getting into our system) in our database. Instead he is using the VarChar dataType. Can someone explain to me how I can exploit this and show them it is very dangerous. Thanks James - 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: No Database Encryption
In the last episode (Dec 12), James McLaughlin said: The new programmer for our company is not using the dataType password or any encryption what so ever for our user accounts (accounts that our customers use for getting into our system) in our database. Instead he is using the VarChar dataType. Can someone explain to me how I can exploit this and show them it is very dangerous. It's only dangerous if a customer can trick your web frontend into displaying the output of SELECT * FROM USERS, for example. If the frontend only uses hardcoded queries, or quotes every user-supplied parameter, there's no problem. In fact, you need the password in plaintext to support a I forgot my password; email it to me feature. -- 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
4 G table limit?
Hi 3 months ago starting using mysql to archive a live news feed that our company is paying for. Being a lazy unit, I am putting all the document bodies into one table. After 3 months, that table has grown to 2G - so its a natural enough assumption to assume that in another 3, it will grow to 4G or so - around the current mysql table size limit ( mysql v. 3.23.36, kernel 2.4.2-2). As mentioned above, I'm a lazy unit, so if possible would like to avoid restructuring the DB to spread the document body table across 1 table (thus enabling 4 G of doc bodies), so am looking for some easier way to do it (eg upgrading mysql, or using a different fs type etc). Does anyone out there know of any - future plans by the mysql development crew to increase table size limits by eg using their own custom filesystem type? - any kernel fs patches I might apply to get around the 4G limit imposed by the linux kernel - any alternative filesystems (JFS?) that might permit greater table sizes under mysql - any other tested and functioning workarounds to this issue? Any suggestions will be appreciated Cheers Tim -- Tim Wood Predictive Technologies ph +61 3 8344 0395 (BH) +61 413 845 317 This is clearly another case of too many mad scientists, and not enough hunchbacks. - 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: Circular replication
Just tell your boss that if you ever have turnover the former employee will be able to log into all the customers' accounts and do whatever he wants. Dave On Thu, Dec 13, 2001 at 03:29:41AM +1100, Duncan Maitland wrote: My questions concern a setup where a public server is running at our hosting company and a local office server is behind a firewall (connected to the net via a somewhat unreliable ADSL). The servers are configured in a circular master-slave relationship but only a limited number of tables in the database are replicated between the two (public doesn't need all of them, so no use in replicating). Of these tables only 3 need to accept writes from both the public and office server (all the other writes happen at the office). Of those 3 tables only 1 makes use of a unique primary key. So my questions are: 1) Replicating a table with a primary key raises the possibility of conflicts if, while the office link is broken, two records are created with the same key. So I plan to generate my own keys in the project source code (without auto_increment) - the public site generates records with even numbers, the office site with odd numbers. Is this a reasonable setup or is there a more correct way? Out of interest, how will MySQL 4.0 replication handle this situation? 2) MySQL docs state It is possible for client A to make an update to co-master 1, and in the meantime, before it propagates to co-master 2, client B could make an update to co-master 2 that will make the update of client A work differently than it did on co-master 1. Thus when the update of client A will make it to co-master 2, it will produce tables that will be different than what you have on co-master 1, even after all the updates from co-master 2 have also propagated. Say the office link is down, and a particular record in the above-mentioned table is edited on both the public and office servers. When the servers re-sync will one record take precedence (if so, which one?) or does the public get one and the office get the other? The former seems to be the case when doing basic testing on my LAN at home, but the MySQL doc is confusing in that it implies the latter. To those of you who have read all the way down to here, I thank you very much! :) Cheers, from Duncan Maitland [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: 4 G table limit?
In the last episode (Dec 13), Tim Wood said: As mentioned above, I'm a lazy unit, so if possible would like to avoid restructuring the DB to spread the document body table across 1 table (thus enabling 4 G of doc bodies), so am looking for some easier way to do it (eg upgrading mysql, or using a different fs type etc). Does anyone out there know of any - future plans by the mysql development crew to increase table size limits by eg using their own custom filesystem type? You mean the MyISAM RAID table extension, or the Innodb tablespace format? Done. Check the manual for details. - any kernel fs patches I might apply to get around the 4G limit imposed by the linux kernel - any alternative filesystems (JFS?) that might permit greater table sizes under mysql 2.4.2 should support 64-bit files just fine. -- 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: No Database Encryption
Yes. 1. Read the manual sections concerning setting up new accounts with special emphasis on passwords. 2. When you thoroughly understand those matters, take the issue to the system administrator and/or management. hth, Doug Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. -- Albert Einstein On Wed, 12 Dec 2001 15:55:04 -0700, James McLaughlin wrote: The new programmer for our company is not using the dataType password or any encryption what so ever for our user accounts (accounts that our customers use for getting into our system) in our database. Instead he is using the VarChar dataType. Can someone explain to me how I can exploit this and show them it is very dangerous. Thanks James - 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
Password encryption
How can I encrypt password in database and how can I retrieve the encrypted password? Thanks ST Ooi Malaysia - Original Message - From: Dan Nelson [EMAIL PROTECTED] To: James McLaughlin [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, December 13, 2001 7:06 AM Subject: Re: No Database Encryption In the last episode (Dec 12), James McLaughlin said: The new programmer for our company is not using the dataType password or any encryption what so ever for our user accounts (accounts that our customers use for getting into our system) in our database. Instead he is using the VarChar dataType. Can someone explain to me how I can exploit this and show them it is very dangerous. It's only dangerous if a customer can trick your web frontend into displaying the output of SELECT * FROM USERS, for example. If the frontend only uses hardcoded queries, or quotes every user-supplied parameter, there's no problem. In fact, you need the password in plaintext to support a I forgot my password; email it to me feature. -- 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 - 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 in NFS
As always with these things, horses for courses. In my situation, I have a mysql server mounted off a netapp, It is the backend for a website serving 10m+ page impressions per month. I wanted to put the data on a netapp for easy backup ( I can shutdown the server do a snapshot and bring it back up in a few seconds). We started off with 2 servers - a master and slave replication pair, but the early versions of replication proved to be far too unstable. With the latest version, replication seems to be stable and I hope to reimplement the original architecture - (selects off the slaves on local disk, updates on the master off NFS) The database is not huge ( 5-6GB ), everything works pretty well. The website is PHP/Zend Cache based. All the best, John. Matthew Darcy wrote: I have done oracle on NFS and it is not really the best option due to NFS locking. ie a poor network or if the NFS server drops, or the NIS/NIS+ (assuming you are using automount maps) dies this will hold your development/production up no end. Also oracle's table locking (not sure if mysql has this) causes problems over NFS. The only time I have seen it work ok was on a veritas cluster using the Oracle/NFS export as a failover and it worked BAD the machine failed over quite a few times and picked up but the machines had to be very powerfull as there was tons of rollbacks and non commited transactions, and non bound variables over NFS was s slow. I am sure you could do it but it is not wise. I have stored Oracle binarys on NFS so that clients could access oracle and manage it over NFS but never had good performance keeping the data on NFS. Matt. -Original Message- From: Shen, Lei (CIT) [mailto:[EMAIL PROTECTED]] Sent: 12 December 2001 14:28 To: [EMAIL PROTECTED] Subject: Mysql in NFS Hi! Dose anyone has a experience to building mysql database in network files system? and php? can you get me some information? thank you -Original Message- From: Marek Kustka [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 8:23 AM To: [EMAIL PROTECTED] Subject: Embedded MySQL server the outside world Hi folks, does embedded server tcp-listen to the outside world i.e. it could be used by another app or perhaps been accessed by the same app using ODBC? OR is MySQL C API the only way to control it? Thanks, Marek - 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: Password encryption
you can use the password() mysql function to crypt it. you cannot retrieve the encrypted password -- only compare input (password() the input) against the saved encrypted password. if the resulting text matches, the password is good. if not, the authentication in your application should fail. -tcl. On Thu, 13 Dec 2001, ST Ooi wrote: How can I encrypt password in database and how can I retrieve the encrypted password? Thanks ST Ooi Malaysia - Original Message - From: Dan Nelson [EMAIL PROTECTED] To: James McLaughlin [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, December 13, 2001 7:06 AM Subject: Re: No Database Encryption In the last episode (Dec 12), James McLaughlin said: The new programmer for our company is not using the dataType password or any encryption what so ever for our user accounts (accounts that our customers use for getting into our system) in our database. Instead he is using the VarChar dataType. Can someone explain to me how I can exploit this and show them it is very dangerous. It's only dangerous if a customer can trick your web frontend into displaying the output of SELECT * FROM USERS, for example. If the frontend only uses hardcoded queries, or quotes every user-supplied parameter, there's no problem. In fact, you need the password in plaintext to support a I forgot my password; email it to me feature. -- 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 - 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: concurrent insert documentation clarification
Hi. On Wed, Dec 12, 2001 at 04:32:27AM -0700, [EMAIL PROTECTED] wrote: The MySQL documentation says: To ensure that the update log/binary log can be used to re-create the original tables, MySQL will not allow concurrent inserts during INSERT SELECT Does this mean: Normally, with MyISAM tables, MySQL will not allow any INSERT, UPDATE..., while a SELECT is running and vice versa (they block each other only if they are on the same table, of course). They will be queued up and run sequentielly. This is handled by implicit locks. Btw, there may only be one INSERT running on a table at a time, but several SELECTs. concurrent inserts is a feature which allows one INSERT to run parallel to the running SELECTs on a table (with MyISAM tables), without being blocked by the selects (under certain prerequisites, which don't matter here), but still blocking subsequents selects. The advantage is that a long running select doesn't block inserts, which will block all following selects (which normally could run in parallel to the slow select). The note above explains that these concurrent INSERTs won't be allowed while an INSERT ... SELECT is running. While another INSERT on the target table won't be allowed anyhow (only one at a time!), INSERTs on the source table won't be allowed, either. A. An INSERT...SELECT cannot run if any other SELECT is running on the table No, that is not what the note is about. The note is about concurrent inserts, not selects. OR B. An INSERT...SELECT cannot run if another INSERT...SELECT is already running on the table Of course, it cannot: Two INSERTs at a time are never allowed, they will be run one after the other. Which is correct? The wording of the documentation suggests that B is correct, but my actual tests on the server indicate A is correct (MySQL 3.23.43 RH Linux 7.1) I agree that the wording of the documentation looks ambigious. It should clearly state whether the source or the target table is meant. And I could reproduce your testing (on 3.23.42). You are right that case A, an already running SELECT, will block an INSERT ... SELECT (but not a simple INSERT), which I think is a bug. Or the note is incomplete. Bye, Benjamin. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: No Database Encryption
It's only dangerous if a customer can trick your web frontend into displaying the output of SELECT * FROM USERS, for example. If the frontend only uses hardcoded queries, or quotes every user-supplied parameter, there's no problem. In fact, you need the password in plaintext to support a I forgot my password; email it to me feature. To explain further, MySQL account passwords are encrypted using the (one-way) password function. This works in a similar way to the UNIX passwd file so that people who do have access to the mysql.user table (possibly through a read-only backup account or whatever) can't (without a lot of effort) get any unencrypted passwords back, so they can't log in to the database as another user. You could use PASSWORD to encrypt passwords for user accounts in your database app if there is any chance that unauthorised people could access the table, otherwise it is not necessary. (Plus there is the issue of staff turnover mentioned earlier). As a side note, absolutely *all* user-supplied parameters should be verified. Sure, you can quote, but what if a user paramater includes something like abc; delete from customers; . The quote has been closed, and then the user can do anything he likes. You also need to scan the user input for special characters like and then escape them (\), something which PHP will do for you (if you have it configured that way). Cheers, from Duncan - 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: matching an option from SET list
Hi.
On Wed, Dec 12, 2001 at 02:39:07PM +, [EMAIL PROTECTED] wrote:
Hello
I've got a problem selecting values that match an option from a SET column.
My two columns are set up as follows:
res_places SET('North','West','South')
res_places_re SET('Aber','Cardiff','Bangor')
And I'm currently using the following MySQL query:
SELECT * FROM gd_records WHERE (res_places 3) AND (res_places_re
1);
Which turns out very strange resutls.
What I'm trying to do (in english) is to select records from the database
which matches option 3 in SET column res_places AND matches option 1 in SET
column res_places_re.
For some reason my SQL query does not give me the desired results. I know
that a record matches both these criteria but yet this omits that record
when returning result.
[...]
You used the wrong integer values. The n-th value is represented by
power(n-1, 2), i.e. 1, 2, 4, 8, 16, and so on.
SELECT * FROM gd_records WHERE (res_places 4) AND (res_places_re 1);
should work. This is documented here:
http://www.mysql.com/doc/S/E/SET.html
Bye,
Benjamin.
--
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 4 G table limit?
In the last episode (Dec 13), Tim Wood said: Does anyone out there know of any - future plans by the mysql development crew to increase table size limits by eg using their own custom filesystem type? You mean the MyISAM RAID table extension, or the Innodb tablespace format? Done. Check the manual for details. - any kernel fs patches I might apply to get around the 4G limit imposed by the linux kernel - any alternative filesystems (JFS?) that might permit greater table sizes under mysql 2.4.2 should support 64-bit files just fine. It turns out I should have RTFM a bit more closely. For those wondering how to use 2.4.x mysql to get 4G tables, here's the deal: the 4G limit is a default (not a FS /kernel imposed limitation as I'd previously surmised). To get 4G using vanilla isam table type, you need to specify the max_rows and/or avg_row_length parameters at table creation time. The other options (raid , innobase) Dan mentioned look easy enough to implement as well - but for now I'll just go with a very long running alter table. Thanks Dan Tim - 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: Each user have only see databases they have access too
My apologies, I was writing that from work, without immediate access to a box running mysql. I tried it just now and have been having problems attempting to put it into a config file. So far, I've only been able to get it to work by passing --safe-show-database to the service as it starts. If/when I discover how to add this option to the my.cnf file I'll let you know. Kelly - Original Message - From: Mike(mickalo)Blezien [EMAIL PROTECTED] To: Kelly Firkins [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, December 12, 2001 11:36 AM Subject: Re: Each user have only see databases they have access too Which group(s) would this go under in the my.cnf ?? On Wed, 12 Dec 2001 07:27:54 -0600, Kelly Firkins [EMAIL PROTECTED] wrote: I believe that phpmyAdmin uses the show databases syntax to see what is available. To prevent it from seeing any db which the user is not authorized, set the safe_show_database = 1 in the my.ini file (or my.cnf). This will prevent show databases from returning a list of all dbs available. kelly I'm running MySQL on my Win98 Desktop and I've created a new user and only granted access to one database, but when I use myPhpAdmin the user can still see all the databases. What can I do so that each user only see the databases they have access too. Always an Email Away Kevin Campbell Chief Executive Officer The Club Mix, Inc. http://www.theclubmix.com Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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: Each user have only see databases they have access too
Kelly, If you use the 'skip-show-database' in the [mysqld] group in the my.cnf file, this will give you the same results at start up [mysqld] skip-show-database This will then disable any user from viewing other databases they do not have access too. On Wed, 12 Dec 2001 19:35:29 -0600, Kelly [EMAIL PROTECTED] wrote: My apologies, I was writing that from work, without immediate access to a box running mysql. I tried it just now and have been having problems attempting to put it into a config file. So far, I've only been able to get it to work by passing --safe-show-database to the service as it starts. If/when I discover how to add this option to the my.cnf file I'll let you know. Kelly - Original Message - From: Mike(mickalo)Blezien [EMAIL PROTECTED] To: Kelly Firkins [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, December 12, 2001 11:36 AM Subject: Re: Each user have only see databases they have access too Which group(s) would this go under in the my.cnf ?? Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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: Each user have only see databases they have access too
I guess I gave up too quickly. Thanks for the info. :) Kelly - Original Message - From: Mike(mickalo)Blezien [EMAIL PROTECTED] To: Kelly [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, December 12, 2001 7:35 PM Subject: Re: Each user have only see databases they have access too Kelly, If you use the 'skip-show-database' in the [mysqld] group in the my.cnf file, this will give you the same results at start up [mysqld] skip-show-database This will then disable any user from viewing other databases they do not have access too. On Wed, 12 Dec 2001 19:35:29 -0600, Kelly [EMAIL PROTECTED] wrote: My apologies, I was writing that from work, without immediate access to a box running mysql. I tried it just now and have been having problems attempting to put it into a config file. So far, I've only been able to get it to work by passing --safe-show-database to the service as it starts. If/when I discover how to add this option to the my.cnf file I'll let you know. Kelly - Original Message - From: Mike(mickalo)Blezien [EMAIL PROTECTED] To: Kelly Firkins [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, December 12, 2001 11:36 AM Subject: Re: Each user have only see databases they have access too Which group(s) would this go under in the my.cnf ?? Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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 questions
Taken from an email from Mike(mickalo)Blezien [EMAIL PROTECTED] If you use the 'skip-show-database' in the [mysqld] group in the my.cnf file, this will give you the same results at start up [mysqld] skip-show-database This will then disable any user from viewing other databases they do not have access too. - Original Message - From: Cedric Tardif [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, December 12, 2001 1:49 PM Subject: mysql questions Hi all, 2 littles questions. 1. How can i log all connection attempt to the mysql database without logging all the query in the mysql database ? 2. It is possible to prevent user to the 'show database' command, i know they can't use it depending on the right granted but it will be pleasent to deny access to this command so they can't see with database are running on this server. Regards Cédric - 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
Fw: Each user have only see databases they have access too
I guess I gave up too quickly. Thanks for the info. :) Kelly - Original Message - From: Mike(mickalo)Blezien [EMAIL PROTECTED] To: Kelly [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, December 12, 2001 7:35 PM Subject: Re: Each user have only see databases they have access too Kelly, If you use the 'skip-show-database' in the [mysqld] group in the my.cnf file, this will give you the same results at start up [mysqld] skip-show-database This will then disable any user from viewing other databases they do not have access too. On Wed, 12 Dec 2001 19:35:29 -0600, Kelly [EMAIL PROTECTED] wrote: My apologies, I was writing that from work, without immediate access to a box running mysql. I tried it just now and have been having problems attempting to put it into a config file. So far, I've only been able to get it to work by passing --safe-show-database to the service as it starts. If/when I discover how to add this option to the my.cnf file I'll let you know. Kelly - Original Message - From: Mike(mickalo)Blezien [EMAIL PROTECTED] To: Kelly Firkins [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, December 12, 2001 11:36 AM Subject: Re: Each user have only see databases they have access too Which group(s) would this go under in the my.cnf ?? Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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
Fw: mysql questions
Taken from an email from Mike(mickalo)Blezien [EMAIL PROTECTED] If you use the 'skip-show-database' in the [mysqld] group in the my.cnf file, this will give you the same results at start up [mysqld] skip-show-database This will then disable any user from viewing other databases they do not have access too. - Original Message - From: Cedric Tardif [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, December 12, 2001 1:49 PM Subject: mysql questions Hi all, 2 littles questions. 1. How can i log all connection attempt to the mysql database without logging all the query in the mysql database ? 2. It is possible to prevent user to the 'show database' command, i know they can't use it depending on the right granted but it will be pleasent to deny access to this command so they can't see with database are running on this server. Regards Cédric - 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
JOIN and Table Full error
Hi all, I'm pretty new with MySQL and am trying to implement my first join. All works as expected until I try to order the output with an order by clause; select * from Players,Roster where Roster.playerId=Players.id order by Players.plast limit 1,10 and I receive an error from the MySQL interpreter; ERROR 1114: The table 'SQLe1b02_0' is full I have no tables by that name, must be a temp? There seems to be ample space in my filesystem, can someone tell me why this is happening and, even better, how to fix it? - 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
Inches and Degrees
I am creating a database for a website that sells tools. Unfortunately they aren't measured in metric. Most of the measurements look something like: 1 1/16 3/8 3/16 1 5/32 45º 10º 2 7/16 These aren't pretty numbers to enter into a database. The simple way would be to enter them as CHAR's and forget about them, but then searching on that could cause problems. Does anyone have any idea what would be the best way to enter these number and as what type? Thanks in advance, Jonathan Duncan - 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
Browser caching problem OR mysql/perl code?
Hello, Coming from an ASP world, I'm trying to learn how to break the browser from caching. I am using variables and their values in the querystring to update a mysql database with perl. I am also re-querying the database to pull back the record. I was hoping to pull back the updated record but it appears to either cache the info in the browser and/or mysql is caching the query; dunno. I have tried a few things, they are 1) turn off cache in IE, 2) pass a datestamp through the querystring, 3) HTML cache buster code. Being none of these worked, I am resorting to believe it is the queries I am using in perl. Any ideas how I can write my queries in a select so that it is sure to pick up any recently changed data from the database that might have just been written? Thanks, - Jack p.s. please cc: to [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: NOT NULL field accepting NULL
Hello,
CREATE TABLE tblTEST(field1 VARCHAR(20) NOT NULL, field2 VARCHAR(20) NOT
NULL);
INSERT INTO tblTEST (field1) VALUES (NULL);
INSERT INTO tblTEST (field2) VALUES (NULL);
INSERT INTO tblTEST (field1,field2) VALUES (NULL,'HELLO');
not accepting NULL values; but
INSERT INTO tblTEST (field1) VALUES ('HELLO');
This statement inserting empty value in 'field2'.
field1 field2
HELLO
so how can we make INSERT statement to fail if value of NOT NULL field is
not supplied.
thanks
regards,
sreedhar
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: sreedhar [EMAIL PROTECTED]; mysql [EMAIL PROTECTED]
Sent: Wednesday, December 12, 2001 11:25 PM
Subject: Re: NOT NULL field accepting NULL
At 7:12 PM +0530 12/12/01, sreedhar wrote:
Hi All,
In MySQL, Even i declared a field as NOT NULL it is accepting nulls .What
might be the
problem. please let me know.
regards,
sreedhar
That's not enough information.
Let's see the CREATE TABLE statement, a sample INSERT statement, and
the resulting record.
-
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 determination of hostname?
How does MySQL determine hostnames when checking access permissions? I assume it uses whatever methods are available to the system (/etc/hosts, NIS, DNS, etc...). Will it use those services in the order they are listed in nsswitch.conf (Solaris)? What about for determining its local hostname? Does it use the hostname function? Thanks, Shon - 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: NOT NULL field accepting NULL
On Thu, Dec 13, 2001 at 09:50:11AM +0530, sreedhar wrote:
Hello,
CREATE TABLE tblTEST(field1 VARCHAR(20) NOT NULL, field2 VARCHAR(20) NOT
NULL);
INSERT INTO tblTEST (field1) VALUES (NULL);
INSERT INTO tblTEST (field2) VALUES (NULL);
INSERT INTO tblTEST (field1,field2) VALUES (NULL,'HELLO');
not accepting NULL values; but
INSERT INTO tblTEST (field1) VALUES ('HELLO');
This statement inserting empty value in 'field2'.
field1 field2
HELLO
so how can we make INSERT statement to fail if value of NOT NULL field is
not supplied.
You don't.
MySQL supplies a default value for any field that isn't specified.
You should verify that you have a value for field1 before issuing
the insert. You'd have to handle an error anyway.
thanks
regards,
sreedhar
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: sreedhar [EMAIL PROTECTED]; mysql [EMAIL PROTECTED]
Sent: Wednesday, December 12, 2001 11:25 PM
Subject: Re: NOT NULL field accepting NULL
At 7:12 PM +0530 12/12/01, sreedhar wrote:
Hi All,
In MySQL, Even i declared a field as NOT NULL it is accepting nulls .What
might be the
problem. please let me know.
regards,
sreedhar
That's not enough information.
Let's see the CREATE TABLE statement, a sample INSERT statement, and
the resulting record.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: LEFT JOIN trouble. Please help.
Hi, I have two tables and I want create third one with LEFT JOIN First table table1 containts field AA as a primary key (AA is NOT NULL). Second table table2 containts field AA as a primary key (AA is NOT NULL) too. Ex: CREATE TABLE a (PRIMARY KEY(AA)) SELECT table1.AA FROM table2 LEFT JOIN table1 ON table2.AA=table1.AA WHERE ...; The problem is, that mysql creates new table with field AA, but it's not NOT NULL (it's allow NULL) = I cannot create primary key on this field. Is it bug or I'm wrong ??? Your nulls are created by LEFT JOIN (it returns null if there is no matching values for table2.AA in table1).Maybe you should try: CREATE TABLE a (PRIMARY KEY(AA)) SELECT table1.AA FROM table2, table1 WHERE table2.AA=table1.AA AND ...; or: CREATE TABLE a (PRIMARY KEY(AA)) SELECT table1.AA FROM table2 LEFT JOIN table1 ON table2.AA=table1.AA WHERE table1.AA IS NOT NULL AND ...; Regards, Sasa - 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 Alpha Linux binary distribution: Core dumped on AlphaServer 1200
Hi, I'm trying to use the available MySQL Linux Alpha binary distribution on this AlphaServer: Linux jive.shadowtrance.com 2.4.9-12smp #1 SMP Tue Oct 30 17:54:45 EST 2001 alpha unknown Running RedHat 7.1 Alpha Deluxe, Using MySQL 3.23.46 from: http://prdownloads.sourceforge.net/mysql/mysql-3.23.46-unknown-linux-gnu-alp haev6.tar.gz [root@jive mysql]# ./scripts/mysql_install_db Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ./scripts/mysql_install_db: line 1: 1008 Illegal instruction (core dumped) ./bin/mysqld --bootstrap --skip-grant-tables --basedir=. --datadir=./data -- skip-innodb --skip-gemini --skip-bdb Installation of grant tables failed! [root@jive mysql]# ./bin/safe_mysqld [1] 3062 [root@jive mysql]# Starting mysqld daemon with databases from /usr/local/mysql/data ./bin/safe_mysqld: line 273: 3080 Illegal instruction (core dumped) $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 491213 04:08:37 mysqld ended I have tried compiling from source however the benchmark results after doing so are worse than an intel 500mhz box thats running a binary installation. You would think that a 5/533 dual processor alpha box with 3 GB memory would beat out a 500 MHz dual processor intel box with 512 MB any day of the week no matter what compile flags you used ;). Any and all suggestions are welcome. Thanks in advance! Ron Jamison - 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
POSTGRESQL VS MYSQL
Hello, I was wondering if anybody new of any articles out there that benchmarked mysql and postgresql recently.I have a few that have favored and have not seen any other ones that favor mysql accept for the benchmarks on the mysql website Thanks Randy - 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
