Book recommendation
The Mysql/Msql book I have from O'Reilly is definitely showing its age. I know there are books in the MySQL FAQ, butI am looking for recommendations. Any books that stand out as better than others? I'm also looking for a good PHP book that is a bit more advanced than the Beginning PHP book (from Wrox) I've just finished... c - 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: Book recommendation
PHP - PHP Essentials by Julie Mooloni is the best book inexpensive too. MYSQL - by Paul Dubois - Techmedia is also great. Nothing can beat the official manuals. elearn. php.linuxcampus.net: C::O::M::I::N::G:S::O::O::N:: mysql.linuxcampus.net Navin Dhanuka, I still feel that I am a Newbee - Original Message - From: Chris Lott [EMAIL PROTECTED] To: MySQL List (E-mail) [EMAIL PROTECTED] Sent: Sunday, July 08, 2001 11:55 AM Subject: Book recommendation The Mysql/Msql book I have from O'Reilly is definitely showing its age. I know there are books in the MySQL FAQ, butI am looking for recommendations. Any books that stand out as better than others? I'm also looking for a good PHP book that is a bit more advanced than the Beginning PHP book (from Wrox) I've just finished... c - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.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: Book recommendation
On Sat, Jul 07, 2001 at 10:25:45PM -0800, Chris Lott wrote: The Mysql/Msql book I have from O'Reilly is definitely showing its age. I know there are books in the MySQL FAQ, butI am looking for recommendations. Any books that stand out as better than others? Yeah, the O'Reilly folks told me a year ago that the knew the book was bad and that they had someone working on revising it. Apparently they lost interest. But don't worry. Paul's MySQL published by New Riders is excellent. It covers all but the newest MySQL features. Certainly worth the money. I'm also looking for a good PHP book that is a bit more advanced than the Beginning PHP book (from Wrox) I've just finished... Just PHP, or PHP and MySQL? If PHP and MySQL, I've heard good things about PHP and MySQL Web Development. Haven't read it myself, though. But the Amazon.com customer feedback is pretty good. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 21 days, processed 163,065,400 queries (86/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: re-sorting auto_increment fields
tj marlin wrote: you can postpone this problem for a very long time by using an unsigned bigint (0 - 2**64-1) note i said postpone, not eliminate. Have you done calculations, how long it takes to reuse all id-s? I have done :). I bet that auto_increment field will be still young, fresh and alive even when this application is already dead after many years. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ 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: Where is the MySQL-DBI-perl-bin RPM?
citizen wrote: $ rpm --test -i MySQL-bench-3.23.39-1.i386.rpm error: failed dependencies: MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.39-1 Where is the MySQL-DBI-perl-bin RPM? ftp://ftp.mysql.com/RPMS/i386 fox example is one place for it. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ 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: BACKUP TABLE command error
Michael Collins wrote: I could not get the backup to work using the mysql client program. The table is a MyISAM type and I have a version (3.23.36) that should support the BACKUP TABLE SQL command. First I created a directory called dbbackup and then used the following: mysql BACKUP TABLE Example.Import_Web TO '/dbbackup'; +++--+--+ | Table | Op | Msg_type | Msg_text | +++--+--+ | Import_Web | backup | error| Failed copying .frm file: errno = 13 | | Example.Import_Web | backup | status | Operation failed | +++--+--+ 2 rows in set (0.02 sec) Anyone recognize the error? Use the utility perror to get meaning of OS low level errors. This is an Access denied and means that in some reason you are not allowed to write into this / directory. I think, this is normal :) -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ 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: direct ISAM access vs. SQL parser
Jeremy Zawodny wrote: Perhaps, but it's not listed here: http://www.mysql.com/doc/manual.php?search_query=handlerdepth=0 I *think* that only searches the 3.23.xx docs. I just found the same thing. :-( Sure. We do not want to confuse people with manual of incomplete and unreleased version of MySQL. I know many people including me use it in production systems but they are people who trust MySQL enough. Officially we can't put this online yet until MySQL-4.0 is out. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ 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: direct ISAM access vs. SQL parser
On Sun, Jul 08, 2001 at 10:29:04AM +0307, Tonu Samuel wrote: Jeremy Zawodny wrote: Perhaps, but it's not listed here: http://www.mysql.com/doc/manual.php?search_query=handlerdepth=0 I *think* that only searches the 3.23.xx docs. I just found the same thing. :-( Sure. We do not want to confuse people with manual of incomplete and unreleased version of MySQL. I know many people including me use it in production systems but they are people who trust MySQL enough. Officially we can't put this online yet until MySQL-4.0 is out. Maybe you could put it on-line but not link to it from the rest of the site.? I'm just *really* fond of the on-line search you folks have built. It makes finding stuff so much easier than loading the HTML up in a browser and doing it the old fashioned way. You could post the URL to the mysql-internals list and not promote it elsewhere. Put a disclaimer on it in big red letters telling folks that they shouldn't be there. Or just tell me to suck it up and use the HTML version. You probably have better things to spend your time on. :-) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 21 days, processed 163,162,048 queries (86/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
PHP and Mysql
Hi All, Has anyone ever had this problem when using PHP 4.06 and MySQL 3.23.39 running on Apache 1.3.20 on Windows 2000 Professional SP!? br bWarning/b: Supplied argument is not a valid MySQL result resource in bd:\program files\apache group\apache\www.lemonlaineydesign.com\www\top_frame.php/b on line b68/bbr And here is the line in my HTML... any ideas what might be wrong? This works on my Unix box with no problems... while ($results = mysql_fetch_array($sth)) { Thanks, Kevin Smith Netsmith Limited - 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[2]: Localization with MySQL
This is how I did it on http://kuehnle.de I don't rely on browser information, though. I let users make their choice. I didn't try to find a single solution for all purposes. Instead, I have a general translation table 'strings' for words or sentences that normally would appear in my code and then other tables with specialized content, i.e. a table for the menu structure, another for the short description for the carriages with a varchar field, then one with the long description for the same article, this time a text field etc. If we chose to add another language, I would have to add a new column to all these tables, which is not that much of an effort. This could have been constructed better, using a key field with the language code instead of separate columns. The translations can be handled by home working people using their browser. I have a table 'workLog' which logs their activity. They have to be identified, using a simple password dialog. I store the info in a cookie, so they don't have to bother more than once. They get a simple form on screen with the text to be translated and their input in their respective language. We didn't have trouble yet, but if the context of the text was needed, I could provide that, too. The code makes sure that there is a fallback mode. If the user chooses French and there is no Franch translation yet, the code will look for English. If there is no English, it will take German. I made a CMS system for another customer, where everything is steered by the menu table. He has plans for the full fledged menu, but only few are ready. The menu is stored in the menu table. The moment he adds (German) content to that menu item, it will appear for the surfer in German, no matter what language they chose. His translators can add the translations likewise later. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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[3]: characters supported in MySQL fields
See http://www.mysql.com/doc/S/t/String_syntax.html I thought that the way the data was stored you could not use certain characters. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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
DB Tools - OT
If someone has been using the database browser tool, DB Tools, I've got a few questions, if you could possibly contact me off the list, I'd appreciate it. :) THX 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
InnoDB is on summer vacation July 9th to July 16th
Hi! Sun is shining and the weather is excellent in Helsinki :). I will be on vacation July 9th to July 16th. I will read email a couple of times. Regards, Heikki Tuuri Innobase Oy (Bait for mail filter: database sql) - 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: probably a stupid question but...
Use an index If you mean use a primary key to create a unique record regardless of the other data in the row, I've already done that. However I'm using that primary key as a means of creating a relationship with another table. What I don't want, is the same category name and customerID twice, even if it does have an index column that differentiates it from other rows. Because, even if there is an index creating a unique row, there is still the possibility of 2 of the same categorynames for one customer. I don't want duplicates like this to be shown to the user. Unless I'm misunderstanding what you mean by using an index... I'm a bit new to mysql, I've worked a lot with Access, and I've actually created a flat file relational database once, but that's it. Here's the table again: ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, customerID INT UNSIGNED, categoryname VARCHAR(20) With customer ID pointing to a customers table. I've tried this: ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, customerID INT UNSIGNED, categoryname VARCHAR(20) UNIQUE but I get an error Right now I'm trying to figure out what, and how to use an index for my situation, but I find the mysql docs are badly organized and hard to read. any help is much 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
Assigning New Users
Hi All, When assigning new Users to various databases, and access settings, in order to have it take effect immediately, all that is needed is to do a FLUSH PRIVILEGES or does the MySQL server need to be restarted?? THX, 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
use of RENAME???
[mysql] is this how to change the the name of an existing populated db? RENAME DATABASE old_name TO new_name; TR - 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: probably a stupid question but...
On 08-Jul-01 Jonah Klimack wrote: What I don't want, is the same category name and customerID twice, even if it does have an index column that differentiates it from other rows. I've tried this: ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, customerID INT UNSIGNED, categoryname VARCHAR(20) UNIQUE but I get an error Right now I'm trying to figure out what, and how to use an index for my situation, but I find the mysql docs are badly organized and hard to read. Get your duplicates out then: ALTER TABLE da_table ADD UNIQUE KEY idx_catcus (categoryname,customerID); Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do 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
total rows in table?
I'd like to include a line in certain output lists like this: Showing 97 contacts out of 324 Other than doing a SELECT...FROM CONTACTS and getting the count from that result and THEN doing a SELECTWHERE for the results I actually want to see, is there some more efficient way of getting the total number of rows in a particular table? It just seems like doing two searches would be a waste of time or am I wrong? The information is there in SHOW TABLE STATUS, but I don't know how to get it out. I didn't find anything else at mysql.com or in any of my books that helped here. I'm using PHP for the interface. I've thought about storing a few bits of information like that in a separate table (that would be updated once a day), but don't know if that would be more efficient. Thank you, Nelson -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: use of RENAME???
No. To rename a database, rename the directory in mysql's data dir. There is no SQL command to rename a database. [mysql] is this how to change the the name of an existing populated db? RENAME DATABASE old_name TO new_name; TR - 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: total rows in table?
On 08-Jul-01 Nelson Goforth wrote: I'd like to include a line in certain output lists like this: Showing 97 contacts out of 324 Other than doing a SELECT...FROM CONTACTS and getting the count from that result and THEN doing a SELECTWHERE for the results I actually want to see, is there some more efficient way of getting the total number of rows in a particular table? It just seems like doing two searches would be a waste of time or am I wrong? The information is there in SHOW TABLE STATUS, but I don't know how to get it out. I didn't find anything else at mysql.com or in any of my books that helped here. I'm using PHP for the interface. I've thought about storing a few bits of information like that in a separate table (that would be updated once a day), but don't know if that would be more efficient. Lotta busy-work for not checking the manual mysql_numrows(); Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do 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
RE: total rows in table?
I thought mysql_numrows(result_identifier) - which I'm using to get the number of rows in the found set - was ONLY to get the number of rows in the result set. What I'm after is how to get the number of rows in an entire table without doing a search to find everything in the table (concerned that this a waste of processor time). However, I did try it without argument as you suggest, but got an error message (wrong parameter count). Nelson At 10:32 AM -0500 7/8/01, Don Read wrote: I'd like to include a line in certain output lists like this: Showing 97 contacts out of 324 Other than doing a SELECT...FROM CONTACTS and getting the count from that result and THEN doing a SELECTWHERE for the results I Lotta busy-work for not checking the manual mysql_numrows(); -- - 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: PHP and Mysql
Well, it's difficult to tell but I would say it would be your SQL statement but since you didn't provide us with that... shrug - Original Message - From: Kevin Smith [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, July 08, 2001 17:40 Subject: PHP and Mysql Hi All, Has anyone ever had this problem when using PHP 4.06 and MySQL 3.23.39 running on Apache 1.3.20 on Windows 2000 Professional SP!? br bWarning/b: Supplied argument is not a valid MySQL result resource in bd:\program files\apache group\apache\www.lemonlaineydesign.com\www\top_frame.php/b on line b68/bbr And here is the line in my HTML... any ideas what might be wrong? This works on my Unix box with no problems... while ($results = mysql_fetch_array($sth)) { Thanks, Kevin Smith Netsmith Limited - 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: Help - Selecting from many to many table.
I would say it is because you need and or in ct.Fk_Targets_Id='1' and ct.Fk_Targets_Id='3' and not an and. How can a column equal 2 different values at the same time? - Original Message - From: Simon [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Sent: Sunday, July 08, 2001 2:08 Subject: Help - Selecting from many to many table. Hello, I am new to SQL and just learning. I have a table of clients and a table of targets. I have a clients_targets table holding the keys for relating. I am having troble trying to select clients that are in more than one target. Eg. Select c.First_Name, ... From clients as c, clients_targets as ct, targets as t Where ct.Fk_Client_Id=c.Id and ct.Fk_Targets_Id=t.Id and ct.Fk_Targets_Id='1' and ct.Fk_Targets_Id='3' Group By c.Id Thanks in Advance, Simon - 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: F IRST TIME USER of MySQL
That's probably because you didn't set up access for root from www.mydomain.com If you have logged into the server through telnet, you shouldn't need the -h option. If you do, it should then be localhost and not yourdomainname. - Original Message - From: Anoop K Gupta [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, July 07, 2001 22:45 Subject: F IRST TIME USER of MySQL Hi everybody I am still having problem.. please help I am able to connect to my remote mysql server but fail to create, user any database ... I let you know step by step.. what I have done 1. First I have connected to my remote server through Telnet. After becoming root... I had supplied following command... 2. mysql -h mydomainname -u root -p it prompts for password : it is blank so I just pressed enter. and Mysql prompt appeared.. mysql Then I typed 3. mysql use mysql; Result : - ERROR 1045 Access deneid for user [EMAIL PROTECTED] using password : no Can you please help me in this regards? Thanks Anoop Buy Feng Shui Package for Rs. 151/- only, at http://shopping.rediff.com/shopping/fengshui_mailer.htm - 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: total rows in table?
On 08-Jul-01 Nelson Goforth wrote: I thought mysql_numrows(result_identifier) - which I'm using to get the number of rows in the found set - was ONLY to get the number of rows in the result set. What I'm after is how to get the number of rows in an entire table without doing a search to find everything in the table (concerned that this a waste of processor time). I got the impression you were displaying the whole table, sorry. to get the number of rows: $qry='SELECT count(*) as cnt from da_table'; $res = mysql_query($qry); if ($res) { $row = mysql_fetch_object($res); echo 'There\'s ', $row-cnt, ' row(s) in there'; } else { die ('PRut-row ' .mysql_errno() .mysql_error()); } However, I did try it without argument as you suggest, but got an error message (wrong parameter count). That was a reference to the manual entry, not a code snippet. Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do 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
Re: total rows in table?
Hi, SELECT COUNT(*) FROM TABLE; will give you the number of rows in the entire table. Don't worry about performance, this query is optimized by mysql. Check: http://www.mysql.com/doc/W/h/Where_optimizations.html for details Regards -- Joseph Bueno NetClub/Trader.com Nelson Goforth wrote: I thought mysql_numrows(result_identifier) - which I'm using to get the number of rows in the found set - was ONLY to get the number of rows in the result set. What I'm after is how to get the number of rows in an entire table without doing a search to find everything in the table (concerned that this a waste of processor time). However, I did try it without argument as you suggest, but got an error message (wrong parameter count). Nelson At 10:32 AM -0500 7/8/01, Don Read wrote: I'd like to include a line in certain output lists like this: Showing 97 contacts out of 324 Other than doing a SELECT...FROM CONTACTS and getting the count from that result and THEN doing a SELECTWHERE for the results I Lotta busy-work for not checking the manual mysql_numrows(); - 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
bug report on WinMySQLadmin 1.1
_ Win98 4.10.98, AMD Duron, 128 MB RAM MySQL 3.23.39 running on localhost _ Query is DELETE FROM staticStrings WHERE ruri LIKE 'staticAnzeigen%' _ Error is Lost connection to MySQL server during query _ WinMySQLadmin crashes with the following message: MYSQLD-OPT verursachte einen Fehler durch eine ungültige Seite in Modul MYSQLD-OPT.EXE bei 017f:0047e56a. Register: EAX= CS=017f EIP=0047e56a EFLGS=00010246 EBX=409f7604 SS=0187 ESP=0178f2d0 EBP=00a8330a ECX= DS=0187 ESI=409f7505 FS=ccff EDX=0001 ES=0187 EDI=009f7f68 GS= Bytes bei CS:EIP: _ isamchk -s ../var/pferdezeitung/staticStrings.ISM C:\mysql\binisamchk -s ..\data\pferdezeitung\staticStrings.ism C:\MYSQL\BIN\ISAMCHK.EXE: ISAM file ..\data\pferdezeitung\staticStrings.ism C:\MYSQL\BIN\ISAMCHK.EXE: error: Size of indexfile is: 13312 Should be : 15360 C:\MYSQL\BIN\ISAMCHK.EXE: error: Size of datafile is: 778515 Should be : 839240 C:\MYSQL\BIN\ISAMCHK.EXE: error: Found key at page 1024 that points to record ou tside datafile C:\MYSQL\BIN\ISAMCHK.EXE: error: Record-count is not ok; is 27 Should be: 28 C:\MYSQL\BIN\ISAMCHK.EXE: warning: Found 28 partsShould be: 29 parts ISAM-table '..\data\pferdezeitung\staticStrings.ism' is corrupted Fix it using switch -r or -o _ -r shows C:\mysql\binisamchk -r ..\data\pferdezeitung\staticStrings.ism - recovering ISAM-table '..\data\pferdezeitung\staticstrings.ism' Data records: 28 - Fixing index 1 - Fixing index 2 Data records: 27 _ in consequence the error is gone and WinMySQLadmin doesn't crash. I uploaded the table files, if you need a superb crashed table. As I didn't have an ftp account and creation of such didn't work as it should, I worked it out as follows: You can get http://art-quarter.com/staticstrings.ism and http://art-quarter.com/staticStrings.frm directly, but http://art-quarter.com/staticstrings.ISD does not work in the browser, so I created http://art-quarter.com/crashedTable.php3 which does not work with IE, but fine with Netscape, so please use that if you need it - I have several complaints about IE and workarounds, but none works for me, so I give up. Hope that helps. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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: Assigning New Users
At 8:36 AM -0500 7/8/01, MikemickaloBlezien wrote: Hi All, When assigning new Users to various databases, and access settings, in order to have it take effect immediately, all that is needed is to do a FLUSH PRIVILEGES or does the MySQL server need to be restarted?? If you use the GRANT statement to assign users/privileges, then you do not need to do anything else - effect is immediate. If you edit the mysql.* tables (eg; user, db, host, etc.) directly (not recommended), you need to issue a FLUSH PRIVILEGES to activate your changes. -steve -- +-- Factoid: Of the 100 largest economies in the world, 51 are --+ | Steve Edberg University of California, Davis | | [EMAIL PROTECTED] Computer Consultant | | http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ | +--- corporations -- http://www.ips-dc.org/reports/top200text.htm ---+ - 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: BACKUP TABLE command error
At 10:09 AM +0307 7/8/01, Tonu Samuel wrote: Use the utility perror to get meaning of OS low level errors. This is an Access denied and means that in some reason you are not allowed to write into this / directory. I think, this is normal :) I had checked the directory to make sure I had permission (chmod 777) but the problem was actually that I neglected to realize I was connecting to the mysql client with an admin Un/password that did not have access to the database. When I logged in as root (using sudo) I was able to perform the BACKUP. Funny but I had used Grant as follows: GRANT ALL ON *.* TO mylogin IDENTIFIED BY xxx; flush privileges; And the mysql.user table shows the following: Host | User | Password % | mylogin | 50c0b4554dfdf0a (and a Y on everything but Grant) Doesn't that mean I can log in to administer MySQL with that username? BTW I do not have any my.cnf file. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.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: Book recommendation
MySQL, Paul DuBois, New Riders publishing, 2000, $40 At 10:25 PM 7/7/01 -0800, you wrote: The Mysql/Msql book I have from O'Reilly is definitely showing its age. I know there are books in the MySQL FAQ, butI am looking for recommendations. Any books that stand out as better than others? I'm also looking for a good PHP book that is a bit more advanced than the Beginning PHP book (from Wrox) I've just finished... c - 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 -- tom marlin [EMAIL PROTECTED] fax / voice mail: 714 507 3802 ext 4881 Never be afraid to try something new. Remember that - amateurs built the ark. - professionals built the Titanic.
mysql on OSX v. 10.0.4
database install problem: I'm having difficulty getting 3.23.3x to install on MacOS X 10.0.4. I didn't have any problems on 10.0.0 or 10.0.2. And I've tried to compile 3.23.37, 38, and 39. I also went through a variety of flag combinations and tried running the make process as root, as was suggested in a comment in the on-line manual. The error I get is binary-configure.sh binary-configure-t /bin/mv binary-configure-t binary-configure make[2]: Nothing to be done for `all-am'. thanks in advance for any tips. -j - 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
Storing multi-page texts
What kind of methods have any of you used for storing text that needs to be displayed as both multi-page (for reading) and single-page (for printing)? My plan is to store the articles with basic HTML formatting that will render based on the site stylesheet(s). I'm using MySQL. My main question is how to deal with the multiple pages. Higher-ups would prefer that article authors not have to split the file into various fields when composing. My idea is to have the authors insert a code/comment that indicates a page break in the text (something like, cryptically, PAGEBREAK) and then when pulling the article from the DB, create a menu for selecting pages (there has to be a small menu at the bottom of each article with a link to each article page and an indication where the user is), display the proper page, etc. I've still not got my head completely around how I am going to do this, so I am looking for suggestions on how other sites manage this need. c - 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: Relational Database WITHOUT server?
At 10:36 AM 7/8/01 -0700, you wrote: Hello, I am creating a database that will be used by about 5 people very infrequently. I have looked into things like xbase, which would be acceptable, but are there any relational db's with a c/c++ api that would access the files directly without a server? Is this possible? If so, could SQL be used with it? Dan Mingus [EMAIL PROTECTED] You could look at Access, but using that across a network is the type of thing that gives me nightmares. BTW, MySQL can run on a client computer, in case you're confusing a hardware server and a software server. John Meyer [EMAIL PROTECTED] Programmer If we didn't have Microsoft, we'd have to blame ourselves for all of our programs crashing - 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 on OSX v. 10.0.4
When I was running OS X, I just used the installer that I found on versiontracker.com . If you do a search for MySQL, it should bring up a precompiled version of MySQL. It should be the most rescent, the guy who provides it usually keeps it up to date. He even has instructions on his site about setting it up. Good luck = r a n d y / sesser at mac.com From: [EMAIL PROTECTED] Date: Sun, 8 Jul 2001 14:39:42 -0400 To: [EMAIL PROTECTED] Subject: mysql on OSX v. 10.0.4 database install problem: I'm having difficulty getting 3.23.3x to install on MacOS X 10.0.4. I didn't have any problems on 10.0.0 or 10.0.2. And I've tried to compile 3.23.37, 38, and 39. I also went through a variety of flag combinations and tried running the make process as root, as was suggested in a comment in the on-line manual. The error I get is binary-configure.sh binary-configure-t /bin/mv binary-configure-t binary-configure make[2]: Nothing to be done for `all-am'. thanks in advance for any tips. -j - 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: Storing multi-page texts
At 10:38 AM 7/8/01 -0800, Chris Lott wrote: What kind of methods have any of you used for storing text that needs to be displayed as both multi-page (for reading) and single-page (for printing)? My plan is to store the articles with basic HTML formatting that will render based on the site stylesheet(s). I'm using MySQL. My main question is how to deal with the multiple pages. Higher-ups would prefer that article authors not have to split the file into various fields when composing. My idea is to have the authors insert a code/comment that indicates a page break in the text (something like, cryptically, PAGEBREAK) and then when pulling the article from the DB, create a menu for selecting pages (there has to be a small menu at the bottom of each article with a link to each article page and an indication where the user is), display the proper page, etc. I've still not got my head completely around how I am going to do this, so I am looking for suggestions on how other sites manage this need. Why not just split on the newlines? You could conceivably, say that you will limit yourself to 5 newlines (paragraphs) per page. T John Meyer [EMAIL PROTECTED] Programmer If we didn't have Microsoft, we'd have to blame ourselves for all of our programs crashing - 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: PHP and Mysql
Hit the nail on the head... infact, the problem wasn't the query itself, it was the way in which I imported the tables and data from a Unix platform to my Windows platform that caused the problems... sorry. Many thanks for you help, as it made me look at running the query as you suggested which caused me to realise the database wasn't able to be read by Windows. :) Thanks, Kevin - Original Message - From: Jason Burfield [EMAIL PROTECTED] To: Kevin Smith [EMAIL PROTECTED] Sent: Sunday, July 08, 2001 4:15 PM Subject: Re: PHP and Mysql Kevin... This means that your result set is empty. Try running the query on the command line and see if you get a result. If you do, check the syntax in your code. If you don't, that's the problem. -- Jason On 7/8/01 5:40 AM, Kevin Smith was heard saying: Hi All, Has anyone ever had this problem when using PHP 4.06 and MySQL 3.23.39 running on Apache 1.3.20 on Windows 2000 Professional SP!? br bWarning/b: Supplied argument is not a valid MySQL result resource in bd:\program files\apache group\apache\www.lemonlaineydesign.com\www\top_frame.php/b on line b68/bbr And here is the line in my HTML... any ideas what might be wrong? This works on my Unix box with no problems... while ($results = mysql_fetch_array($sth)) { Thanks, Kevin Smith Netsmith Limited - 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
reference anyone?
Hello, I'm architecting a web-based system that needs to be able to handle 5 million records and roughly up to 3,000 inserts an hour. Although I'm willing to sacrifice referencial integrity for speed, I must have transaction support (commit/rollback) and row-level locking. Is anyone out there running a MySql production system with similar specifications? I would love to hear from you (especially if I can make a reference to your organization in my proposal). It would also be helpful to know what platform the db is running on (Linux, Solaris, etc). Thanks! Chris Kmiec _ Get your FREE download of MSN Explorer at http://explorer.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Where is the MySQL-DBI-perl-bin RPM?
- Original Message - From: Tonu Samuel [EMAIL PROTECTED] To: citizen [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, July 07, 2001 11:57 PM Subject: Re: Where is the MySQL-DBI-perl-bin RPM? citizen wrote: $ rpm --test -i MySQL-bench-3.23.39-1.i386.rpm error: failed dependencies: MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.39-1 Where is the MySQL-DBI-perl-bin RPM? ftp://ftp.mysql.com/RPMS/i386 for example is one place for it. Excellent. I hope this URL will find its way into above error message. Saves time. Thank you. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ 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: mysql on OSX v. 10.0.4
At 11:47 AM -0700 7/8/01, { randy } wrote: When I was running OS X, I just used the installer that I found on versiontracker.com . I also had no problem using the pre-built installer at: http://www.entropy.ch/software/macosx/ Here are some others: http://www-u.life.uiuc.edu/~mwvaugh/MacOSX/ http://miltonshole.thespacemonkey.com/osx/mysql.html Here is an article on it: http://www.stepwise.com/Articles/Workbench/2001-03-24.01.html -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.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: Book recommendation
At 11:15 AM -0700 7/8/01, tj marlin wrote: MySQL, Paul DuBois, New Riders publishing, 2000, $40 better price here: http://www.bookpool.com/.x/SSCOLL/sm/0735709211 I have no association with this book dealer -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.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
Question,
I am trying to get on of my apps to display only 5 records at a time. With Perl attaching to a mysql database. Does anyone have any good Ideas of how to do this. Is there a way of doing a select and out of the results saying only give me 5-10 or 10-15? Any help would be greatly appreciated Thank you Jason - 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: Relational Database WITHOUT server?
I needed to add a couple of things to the original posting. What i'm trying to do is have a browser interface for manipulating and viewing the data. The database would be manipulated with cgi on a linux machine. I thought about access, but i don't believe there are api's for creating and manipulating the table definitions? If there is that would be great. Is there a unix version of access i wonder? A relational database that fits in a single file(or more, doesn't matter) and has an odbc driver that attaches to the file(s) that is available on unix? - 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: Relational Database WITHOUT server?
I needed to add a couple of things to the original posting. What i'm trying to do is have a browser interface for manipulating and viewing the data. The database would be manipulated with cgi on a linux web server. I thought about access, but i don't believe there are api's for creating and manipulating the table definitions? If there is that would be great. Is there a unix version of access i wonder? A relational database that fits in a single file(or more, doesn't matter) and has an odbc driver that attaches to the file(s) that is available on unix? - 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: Question,
You want to search for the LIMIT keyword at http://mysql.com Is there a way of doing a select and out of the results saying only give me 5-10 or 10-15? -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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
saving in mysql
I've been dealing with this problem for a few days now and I got no idea what's going on: the base is working properly but for one thing - when changing anything in base, i.e. saving new record or creating new tables or dropping tables - anything that involves change in the base - MySQL says: "unable to save result set in example.php on line 30" [for example] but strangest thing is that the record GETS saved/altered/dropped anyway... do you have any idea whats going on ? Thanx in advance Stink - 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: Where is the MySQL-DBI-perl-bin RPM?
- Original Message - From: Tonu Samuel [EMAIL PROTECTED] To: citizen [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, July 07, 2001 11:57 PM Subject: Re: Where is the MySQL-DBI-perl-bin RPM? citizen wrote: $ rpm --test -i MySQL-bench-3.23.39-1.i386.rpm error: failed dependencies: MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.39-1 Where is the MySQL-DBI-perl-bin RPM? ftp://ftp.mysql.com/RPMS/i386 for example is one place for it. Evidently not, at least not if by it you mean ftp://ftp.mysql.com/RPMS/i386/Mysql-DBI-perl-bin-1.1825-1.i386.rpm $ rpm -qa | egrep -i '(dbi|mysql)' MySQL-client-3.23.39-1 Mysql-DBI-perl-bin-1.1825-1 MySQL-3.23.39-1 DBI-perl-bin-0.93-1 $ rpm --test -i MySQL-bench-3.23.39-1.i386.rpm error: failed dependencies: MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.39-1 If I resort to --nodeps to force the installation, the test procedures obviously have no idea where the components of MySQL that are needed to execute the tests are located, so it appears to me that either the information you gave me is not operative or the MySQL testbench RPM resulting from a --rebuild of the MySQL 3.23.39-1 SRPM on SourceForge was not tested. -- Maximize end-user autonomy. - 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: BACKUP TABLE command error
At 10:09 AM +0307 7/8/01, Tonu Samuel wrote: Use the utility perror to get meaning of OS low level errors. I have taken a look at the perror utility for viewing the text for MySQL error codes and decided I wanted to see all the MySQL error messages so I created a simple PERL script: #!/usr/bin/perl $inc = 1; $err =''; do { $err = system (/usr/local/bin/perror -v $inc;); print $err.\r; $inc++; } while ($err ne '') I am not a PERL coder at all, this is one of my first attempts. Can anyone suggest a good way to stop printing out the list, when there are no more errors to report on? The output is as follows Error code 86: Bad CPU type in executable Error code 87: Shared library version mismatch Error code 88: Malformed Mach-o file Error code 89: Unknown error: 89 Error code 90: Unknown error: 90 and then keeps repeating but I get some odd results with two lines for error 120, 121, 123 and so on: Error code 119: Unknown error: 119 Error code 120: Unknown error: 120 120 = Didn't find key on read or update Error code 121: Unknown error: 121 121 = Duplicate key on write or update Error code 122: Unknown error: 122 Error code 123: Unknown error: 123 123 = Someone has changed the row since it was read; Update with is recoverable Error code 124: Unknown error: 124 124 = Wrong index given to function Error code 125: Unknown error: 125 Error code 126: Unknown error: 126 126 = Index file is crashed / Wrong file format Error code 127: Unknown error: 127 127 = Record-file is crashed Error code 128: Unknown error: 128 Error code 129: Unknown error: 129 Error code 130: Unknown error: 130 Error code 131: Unknown error: 131 131 = Command not supported by database Error code 132: Unknown error: 132 I realize it is simpler if I know how may there are: #!/usr/bin/perl for ($inc = 1; $inc 90; $inc++) { system (/usr/local/bin/perror -v $inc;); } -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.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: BACKUP TABLE command error
On 08-Jul-01 Michael Collins wrote: At 10:09 AM +0307 7/8/01, Tonu Samuel wrote: Use the utility perror to get meaning of OS low level errors. I have taken a look at the perror utility for viewing the text for MySQL error codes and decided I wanted to see all the MySQL error messages so I created a simple PERL script: #!/usr/bin/perl $inc = 1; $err =''; do { $err = system (/usr/local/bin/perror -v $inc;); print $err.\r; $inc++; } while ($err ne '') I am not a PERL coder at all, this is one of my first attempts. Can anyone suggest a good way to stop printing out the list, when there are no more errors to report on? try em all | grep -v trash. $ jot 4096 | xargs -n 16 perror | grep -v Unknown error: Error code 86: Bad CPU type in executable Error code 87: Shared library version mismatch Error code 88: Malformed Mach-o file Error code 89: Unknown error: 89 Error code 90: Unknown error: 90 and then keeps repeating but I get some odd results with two lines for error 120, 121, 123 and so on: Error code 119: Unknown error: 119 Error code 120: Unknown error: 120 120 = Didn't find key on read or update Error code 121: Unknown error: 121 121 = Duplicate key on write or update Error code 122: Unknown error: 122 Error code 123: Unknown error: 123 123 = Someone has changed the row since it was read; Update with is recoverable Error code 124: Unknown error: 124 124 = Wrong index given to function Error code 125: Unknown error: 125 Error code 126: Unknown error: 126 126 = Index file is crashed / Wrong file format Error code 127: Unknown error: 127 127 = Record-file is crashed Error code 128: Unknown error: 128 Error code 129: Unknown error: 129 Error code 130: Unknown error: 130 Error code 131: Unknown error: 131 131 = Command not supported by database Error code 132: Unknown error: 132 Looks like it checks for the OS error 120 first, then the MySQL error code 120, producing: Error code 120: Unknown error: 120 120 = Didn't find key on read or update I realize it is simpler if I know how may there are: $ jot 4096 | xargs -n 16 perror | grep -v Unknown error: | tail 136 = No more room in index file 137 = No more records (read after end of file) 138 = Unsupported extension used for table 139 = Too big row (= 16 M) 140 = Wrong create options 141 = Duplicate unique key or constraint on write or update 142 = Unknown character set used 143 = Conflicting table definition between MERGE and mapped table 144 = Table is crashed and last repair failed 145 = Table was marked as crashed and should be repaired $ jot 4096 | xargs -n 16 perror | grep -v Unknown error: | wc -l 107 $ uname -sr FreeBSD 4.3-STABLE Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do 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
Re: PHP and Mysql
On Sun, 8 Jul 2001 19:10, Kevin Smith wrote: Hi All, Has anyone ever had this problem when using PHP 4.06 and MySQL 3.23.39 running on Apache 1.3.20 on Windows 2000 Professional SP!? br bWarning/b: Supplied argument is not a valid MySQL result resource in bd:\program files\apache group\apache\www.lemonlaineydesign.com\www\top_frame.php/b on line b68/bbr And here is the line in my HTML... any ideas what might be wrong? This works on my Unix box with no problems... while ($results = mysql_fetch_array($sth)) { Thanks, Kevin Smith Netsmith Limited Use mysql_error() after your database call to get any error messages that mysql returns. -- David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA The guy who writes all those bumper stickers HATES New York. - 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: Relational Database WITHOUT server?
Of course there is no unix versions of Access. Microsoft wouldn't create anything to assist their competitor. If you are setting up a Linux machine, what's wrong with setting it up to run a DB server? MySQL would be quite suitable as it is quite easy to use, allows you to connect from Windows machine using MyODBC and you can display the contents on a web page if you install a web server. You can also get GUIs for it as well. But it doesn't mean you have to rule out other DBs as there are features that aren't yet implemented in MySQL. Have a look through the manual and decide for yourself. - Original Message - From: srf3 [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 09, 2001 6:17 Subject: Re: Relational Database WITHOUT server? I needed to add a couple of things to the original posting. What i'm trying to do is have a browser interface for manipulating and viewing the data. The database would be manipulated with cgi on a linux machine. I thought about access, but i don't believe there are api's for creating and manipulating the table definitions? If there is that would be great. Is there a unix version of access i wonder? A relational database that fits in a single file(or more, doesn't matter) and has an odbc driver that attaches to the file(s) that is available on unix? - 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: saving in mysql
My guess is that you have logging on for php but it has problems saving to it's current location but I'm not psychic so I don't know. (ie. provide the list with some code) - Original Message - From: "Stink" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 09, 2001 7:05 Subject: saving in mysql I've been dealing with this problem for a few days now and I got no idea what's going on: the base is working properly but for one thing - when changing anything in base, i.e. saving new record or creating new tables or dropping tables - anything that involves change in the base - MySQL says: "unable to save result set in example.php on line 30" [for example] but strangest thing is that the record GETS saved/altered/dropped anyway... do you have any idea whats going on ? Thanx in advance Stink - 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: Relational Database WITHOUT server?
I realize that i'm regressing by trying to achieve a flatfile style of database as opposed to a DBMS, but for my purpose it would be sufficient. In my quest for a solution, I realize that to run a full DBMS would actually waste resources due to lack of use, but I'd still like to utilize SQL and relational tables. Are there really no database structures available for linux where an odbc connection could be attached to a file(s)? - 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
AUTO INCREMENT Q U E S T I O N in MySQL
Greetings ! Suppose I have a table in MySQL Database: idName - 1 ABC 2 BBB 3 CAB like this id being auto_increment. If I delete all the three records and start with new then it starts from id 4, while I need it to be started from 1. Can anyone suggest, how can I achieve this? Looking forward to hear from you soon. Warm Regards, DT - 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: re-sorting auto_increment fields
i know it is large. the user must do his own calculations to determine if he can substitute eliminate for postpone. this is his call; not mine nor yours. At 09:57 AM 7/8/01 +0307, you wrote: tj marlin wrote: you can postpone this problem for a very long time by using an unsigned bigint (0 - 2**64-1) note i said postpone, not eliminate. Have you done calculations, how long it takes to reuse all id-s? I have done :). I bet that auto_increment field will be still young, fresh and alive even when this application is already dead after many years. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com -- tom marlin [EMAIL PROTECTED] fax / voice mail: 714 507 3802 ext 4881 Never be afraid to try something new. Remember that - amateurs built the ark. - professionals built the Titanic.
RE: AUTO INCREMENT Q U E S T I O N in MySQL
You should refer to manual, your case depends on the type of your table. MyISAM tables do assign new number always, and there's some another kind of table which is reusing numbers the same way you need. I don't remember what type exactly, so refer to the manual. -Original Message- From: Deependra B. Tandukar [mailto:[EMAIL PROTECTED]] Sent: Monday, July 09, 2001 8:07 AM To: [EMAIL PROTECTED] Subject: AUTO INCREMENT Q U E S T I O N in MySQL Greetings ! Suppose I have a table in MySQL Database: idName - 1 ABC 2 BBB 3 CAB like this id being auto_increment. If I delete all the three records and start with new then it starts from id 4, while I need it to be started from 1. Can anyone suggest, how can I achieve this? Looking forward to hear from you soon. Warm Regards, DT - 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: Question,
Jason, Hope this will help you get what you want. Of course you need at least one more loop (calculating the number of 'display' actions from sth-numrows()) to repeat the display process for rows 5-10, 11-15, etc. #!/usr/bin/perl use DBD::mysql; #connect to database $dbh = DBI-connect(DBI:mysql:lablog:$dbhost,$dbuser,$dbpass) || die No database connection; #do your query $sth=$dbh-prepare(SELECT * FROM table WHERE something='wanted'); $sth-execute(); #display 5 rows containing 3 columns, for (i=0; i=4; i++) { ($column1, $col2, $col3)=($sth-fetchrow()); print Result: $column1, $col2, $col3\n; } Regards, Sebastiaan J.A. Kamp -Original Message- From: Jason Whitlow [mailto:[EMAIL PROTECTED]] Sent: maandag 9 juli 2001 0:21 To: '[EMAIL PROTECTED]' Subject: Question, I am trying to get on of my apps to display only 5 records at a time. With Perl attaching to a mysql database. Does anyone have any good Ideas of how to do this. Is there a way of doing a select and out of the results saying only give me 5-10 or 10-15? Any help would be greatly appreciated Thank you Jason - 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
?
Hello mysql, I meet in share ver. of MySQL different lang. driver but no where UKRAINIAN. AND now I ask - I wont translete errmsg.txt and errmsg.sys for UKRAINIAN lang? Waiting for ansver! -- Best regards, suh mailto:[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