Unicode
Hi all, Iam doing a bilingual site in english and other in Arabic. I know that MySQL doesn't support unicode..and in which format i have to store into the database... can any one explain Vasan S __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.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
Problem with max() on select
I have a database of bids on auctions that I keep separate from the auction information. The problem comes when I attempt to generate a list of auctions with highest bid information. I set the database for bids like this: ANum, varchar(20), the auction number Bidders, int(4), number of bidders at time of this bid Bidder, varchar(50), username of current bidder CPrice, decimal(9,2), current bid Typical records: 12345 1 bidder1 20.00 12345 2 bidder2 25.00 12345 3 bidder3 30.00 I tried: select ANum, max(Bidders), Bidder, CPrice from Bids group by ANum and it returns: 12345 3 bidder1 20.00 which gives me the higest bid number, but the information from the first bid in the database. How can I retrieve the records that reflect the highest bids for each auction??? Thanx, Jim - 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: Accessing MySql database using Bash shell Script
On 17 Aug 2001 06:13:08 +, Munish Malhotra wrote: Dear Sir, Can you please tell me how to access data from a MySql database using a Bash Shell Script i.e. how to connect to a MySql database and retrive records and to disconnect from database. I shall be very thankful to you. [tonu@x153 tonu]$ /usr/local/mysql/bin/mysql -e SELECT NOW(); SELECT VERSION() +-+ | NOW() | +-+ | 2001-08-17 14:55:42 | +-+ +-+ | VERSION() | +-+ | 4.0.0-debug-log | +-+ [tonu@x153 tonu]$ There are some additional flags which can be used to turn headers and boxes around data off if you need to. -- 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: Downsides of MySQL?
Steve Edberg wrote: Do these people even know what they mean by 'enterprise management functionality', or did they just crib from an Oracle brochure? DO they have any specifics about what they require? Managers do that all to often when comparing software. They look at the feature sheets and then take the one with the highest count and coolest names. I think the Oracle advertising people write better than the MySQL people. When I once wanted to get Photoshop, I had a manager with a recent PC World (or one of those rags) article comparing it with Corel PhotoPaint. He wanted to get Corel based on the extensive (mostly eye candy) feature list. Forget about how well the program actually performs. Frank. - 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: synchron of two databases.
Date |Thu, 16 Aug 2001 14:57:59 +0300 From |[EMAIL PROTECTED] [EMAIL PROTECTED] Hello! S I have a very interesting question. S I have a program that works on 2 computers, using some king of p2p protocol. S Each side is using mysql for work. How I can synchronise two databases on S these computers. Why you don't use ONE mysql server through tcp ? ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ 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: Accessing MySql database using Bash shell Script
Date |17 Aug 2001 06:13:08 - From |Munish Malhotra [EMAIL PROTECTED] Hello! M M Dear Sir, M M Can you please tell me how to access data from a MySql database using a Bash Shell Script i.e. how to connect to a MySql database and retrive records and to disconnect from database. M M I shall be very thankful to you. You need to use command line driven 'mysql' command For example echo select * from test;|mysql test; ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ 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: hello
Date |Thu, 16 Aug 2001 13:40:16 + From |Brian Johnson Jaber [EMAIL PROTECTED] Hello! BJJ Dear Sirs BJJ Hello, i have questions on mysql i create a table and i create an index key BJJ in it i want to know how can i know in mysql if the date that i import it BJJ into the table are fully indexd. BJJ please reply. BJJ best regards. BJJ nabil jaber. Indexation of data work at insert stage (on the fly). Look in www.mysql.com/doc/ for more information. ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ 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: Got and mirrored it... (Re: MySQL-MAX 3.23.41 download link is dead... (need a download))
Matt Wagner writes: Matt Wagner writes: Jeremy Zawodny writes: On Thu, Aug 16, 2001 at 06:00:16PM -0700, Jeremy Zawodny wrote: Does anyone have the latest 3.23.41 I could grab a copy of? I managed to fetch it from ftp.mysql.com. A copy is now available here as well: http://jeremy.zawodny.com/mysql/mysql-max-3.23.41-pc-linux-gnu-i686.tar.gz Hi, Thanks Jeremy for providing the quick work-around. I have temporarily fixed this by redirecting to the ftp.sunet.se mirror. Er.. I have been schnookered by some sunet.se automatching-closest-filename thing (when you click on the .41 links, sunet.se auto-redirects you to .40 files!). Turns out they only have .40 also. :( Fixing... will mail back soon. Done. -- 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
RE: Accessing MySql database using Bash shell Script
Sincerely, Melinda Odom [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] www.mdesigner.org http://www.mdesigner.org/ *** Hosting, Ecommerce, $15/yr Domains www.modom.adgrafix.com http://www.modom.adgrafix.com/ www.wsmdomains.com http://www.wsmdomains.com/ Toll free in the U.S. and Canada: 800.952.4233 x 350 Outside the U.S. and Canada: +1 978.440.9988 x 350 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: Friday, August 17, 2001 2:28 AM To: Munish Malhotra Cc: [EMAIL PROTECTED] Subject: Re: Accessing MySql database using Bash shell Script Munish Malhotra wrote: Dear Sir, Can you please tell me how to access data from a MySql database using a Bash Shell Script i.e. how to connect to a MySql database and retrive records and to disconnect from database. I shall be very thankful to you. Yours Truly, Munish Malhotra Hi, You can use 'mysql' client. Regards -- Joseph Bueno NetClub/Trader.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: Optimising for 4096MB RAM
On Mon, Aug 13, 2001 at 06:16:10AM +0100, Corin Hartland-Swann wrote: I have also set tmp_table_size to 1024M, which according to the manual should mean that temporary tables will be created in RAM unless they're going to be bigger than that. When I do the following query: SELECT char_field,COUNT(*) AS c FROM table GROUP BY char_field HAVING c 3 ORDER BY char_field It creates a temporary table on disk even though it was only about 200MBs - huh? Can you run EXPLAIN on that query and show us the output? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 0 days, processed 393,861 queries (101/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: Accessing MySql database using Bash shellScript-mysql-subscribe@lists.mysql.com
[EMAIL PROTECTED] Sincerely, Melinda Odom [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] www.mdesigner.org http://www.mdesigner.org/ *** Hosting, Ecommerce, $15/yr Domains www.modom.adgrafix.com http://www.modom.adgrafix.com/ www.wsmdomains.com http://www.wsmdomains.com/ Toll free in the U.S. and Canada: 800.952.4233 x 350 Outside the U.S. and Canada: +1 978.440.9988 x 350 -Original Message- From: Grigory Bakunov [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 2:35 AM To: Munish Malhotra Cc: [EMAIL PROTECTED] Subject: Re: Accessing MySql database using Bash shell Script Date |17 Aug 2001 06:13:08 - From |Munish Malhotra [EMAIL PROTECTED] Hello! M M Dear Sir, M M Can you please tell me how to access data from a MySql database using a Bash Shell Script i.e. how to connect to a MySql database and retrive records and to disconnect from database. M M I shall be very thankful to you. You need to use command line driven 'mysql' command For example echo select * from test;|mysql test; ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ 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 - 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: table level replication
On Thu, Aug 16, 2001 at 03:57:02PM -0400, Brian Burke wrote: All, I'm hitting some stumbling blocks getting replication working, and so I decided to join the list for support. Welcome... Here is what I'm trying to do: GRANT FILE on dbname.tablename to user@% IDENTIFIED BY 'passwd'; Here is the error I get: ERROR 1144: Illegal GRANT/REVOKE command. Please consult the manual which privileges can be used. The following commands work for database level replication: GRANT FILE on * to user@% IDENTIFIED BY 'passwd'; GRANT FILE on *.* to user@% IDENTIFIED BY 'passwd'; I've looked through the documentation and haven't been able to find what I need. Is this possible, or must I do database level replication? I suspect that you can't actually GRANT the file privilege to a particular db.table combination. If that's the case, the fact that '*.*' worked may be a bug. Hmm. The manual isn't too clear on this point (where I looked, at least). Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 0 days, processed 409,266 queries (99/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
Downsides of MySQL?
Chris Boget wrote: MySQL - as I said at our meeting, we would not be comfortable with this as an enterprise strength solution. MySQL is unsupported freeware As has already been pointed out, MySQL is commercially supported by MySQL AB. What strikes me most significantly is that, if you purchase support there, you have access to the original development team.. Is that true of the competing databases? We all know that the original author always has more insight into a piece of software than any maintainer can ever achieve. Which do you want - a small company consisting mainly of the original development team, who have lived and breathed with the product for years, or a huge company in which your problem is handed over to some newly-hired graduate who arrived six months ago and will move on in another six. For your support money, you go to the top instead of the bottom. Alec - 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
Insert values in tables with indices
Hi List, I've a question about inserting values in tables with promary-keys. I have two tables: 1. Table ( contains limits for testing ) - int limitId primary key - int lowerlimit - int upperlimit - char(5) measureunit - char(10) measurename 2. Table ( contains measured values ) - int measureid - float measuredvalue In the 2nd table I stored all measurements taken in a production. For one day that will be more than 10 values. In the 1st table I stored the testlimits. maybe 100 diffrent values Table 1 and Table 2 were linked togther with the id's. So every measured value in tab2 has a testlimit definition in tab1. Later I want to do a query about all measured values for measureid=limitid, and make some statistics about nr of failed, passed, average or standarddeviation. The query is not my problem. My problem is how to insert values into these two tables. My thougts were: Every time I put a new measured value into tab 2 I need first to query tab1 to find out the limitid that I have to use as the measureid for tab2. So for every insert I need one query on tab1? Or is their a better way to get the idvalue for tab2? In the first design a had all values ( measureid, lowerlimit, upperlimit, unit, name, measuredvalue ) in one table. This works fine. But with 10 rows per day, the table grows to much. SO want to change the design and use the id's. Best regards Thorsten Guddack - 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
ANNOUNCE: moodss-14.4
Hi everybody: here is a new version of moodss. Check it out! (or at least the screenshots at http://jfontain.free.fr/moodss3.gif or http://jfontain.free.fr/moodss4.gif :). ### CHANGES ### --- version 14.4 --- all data tables now feature thinner separation lines so that more data can be visible in thresholds and preferences dialog boxes, check syntax of email adresses and eventually report errors interactively MySQL myvars module updated to support 3.23.41 server in thresholds dialog box, clicking several times on a row cell would deselect some of the others in thresholds dialog box, emails list and script entries states now depend on thresholds row selection no longer tries to find BLT or tkTable shared libraries in current directory when those packages are not properly installed requires the newest tkTable widget library version 2.7 (rpm on my homepage) successfully tested with Tcl/Tk 8.4a3 successfully tested with tcllib 1.0 anecdote: moodss and its modules now total more than 2 lines of Tcl code (actually 132 columns wide lines, which is roughly equivalent to 3 normal lines) ### README ### This is moodss (Modular Object Oriented Dynamic SpreadSheet) version 14.4. Moodss won in the Best System Admin Technology category (Tcl Tips and Tricks, Valuable Real World Programming Examples) at the O'Reilly Tcl/Tk 1999 Conference. Linux Magazine calls it a lifesaver. Tucows gives it 5 stars (cows or penguins :-). Moodss is a modular application. It displays data described and updated in one or more modules, which can be specified in the command line or dynamically loaded or unloaded while the application is running. Data is originally displayed in tables. Graphical views (graph, bar, 3D pie charts, ...), summary tables (with current, average, minimum and maximum values) and free text viewers can be created from any number of table cells, originating from any of the displayed viewers. Thresholds can be set on any number of cells. Specific modules can easily be developed in the Tcl, Perl and Python scripting languages or in C. A thorough and intuitive drag'n'drop scheme is used for most viewer editing tasks: creation, modification, type mutation, destruction, ... and thresholds creation. Table rows can be sorted in increasing or decreasing order by clicking on column titles. The current configuration (modules, tables and viewers geometry, ...) can be saved in a file at any time, and later reused through a command line switch, thus achieving a dashboard functionality. The module code is the link between the moodss core and the data to be displayed. All the specific code is kept in the module package. Since module data access is entirely customizable (through C code, Tcl, Perl, Python, HTTP, ...) and since several modules can be loaded at once, applications for moodss become limitless. For example, thoroughly monitor a dynamic web server on a single dashboard with graphs, using the Apache, MySQL, cpustats, memstats, ... modules. If you have replicated servers, dynamically add them to your view, even load the snmp module on the fly and let your imagination take over... Along with a core trace module, random, ps, cpustats, memstats, diskstats, mounts, route, arp, kernmods, netdev, pci, system, MySQL (myquery, mystatus, myprocs, myvars) modules for Linux, ping, snmp and snmptrap for UNIX, apache and apachex modules are included (running wish moodss ps cpustats memstats mimics the top application with a graphic edge and remote monitoring capability). Thorough help is provided through menus, widget tips, a message area, a module help window and a global help window with a complete HTML documentation. Moodss is multi-langual thanks to Tcl internationalization capabilities. So far only English and partially French are supported. Help with other languages will be very warmly welcomed. Development of moodss is continuing and as more features are added in future versions, backward module code compatibility will be maintained. I cannot thank the authors of the tkTable, BLT, MIME/SMTP and the HTML libraries enough for their great work. In order to run moodss, you need to install the following packages (unless you can use the rpm utility, see below): Tcl/Tk 8.3.1 or above, at (or at a mirror near you) http://dev.scriptics.com/ or ftp://ftp.scriptics.com/ the latest tkTable widget library at: http://www.hobbs.wservice.com/tcl/main.html the latest BLT library at: ftp://tcltk.sourceforge.net/pub/tcltk/blt/ eventually the latest tclperl library for writing modules in Perl, or the latest tclpython library for writing modules in Python at: http://jfontain.free.fr/ (see the INSTALL file for complete instructions, for UNIX and also Windows platforms). You also have the option of using the moodss rpm file (also in my homepage), if you are using a Redhat Linux system (6.0 or above). You can find the required tcl, tk, tktable, blt, tcpperl and other rpms at:
Re: Problem with max() on select
On Friday 17 August 2001 07:13, Jim Lynn wrote: I have a database of bids on auctions that I keep separate from the auction information. The problem comes when I attempt to generate a list of auctions with highest bid information. I set the database for bids like this: ANum, varchar(20), the auction number Bidders, int(4), number of bidders at time of this bid Bidder, varchar(50), username of current bidder CPrice, decimal(9,2), current bid Typical records: 12345 1 bidder1 20.00 12345 2 bidder2 25.00 12345 3 bidder3 30.00 I tried: select ANum, max(Bidders), Bidder, CPrice from Bids group by ANum and it returns: 12345 3 bidder1 20.00 which gives me the higest bid number, but the information from the first bid in the database. How can I retrieve the records that reflect the highest bids for each auction??? AFAIK this can only be done in a single SQL statement with a subselect, eg: SELECT * FROM bids WHERE Bidder IN (SELECT MAX(Bidders) FROM bids GROUP BY ANum) Unfortunately MySQL does not yet support subselect (see: http://www.mysql.com/doc/M/i/Missing_Sub-selects.html ), so the only way round this I can see would be on the application side, e.g. SELECT MAX(Bidders), Bidder FROM bids GROUP BY ANum then step through the result set selecting the row for each auction individually using Bidder as the selection criterium. HTH in some way. (If there is a more elegant solution to this problem in MySQL I'd love to hear it) Ian Barwick -- Ian Barwick - Developer - [EMAIL PROTECTED] akademie.de asp GmbH - http://www.akademie.de To query tables in a MySQL database is more fun than eating spam - 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
find mysql
Hi, I have received mysql db files with extensions .frm, .ISD, .ISM I was told that all I need to do is to put them in mysql data directory and it should work ok. I have RH6.2 with mysql rpm and I cannot locate where mysql data directory is. Any idea how to locate it. I wish I had received .csv files but that wasn't possyble. Regards Ajdin - 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: Upsides of MySQL?
Frank Fisher writes: Tyrone Mills wrote: good. Maybe MySQL needs to charge support fees comparable to M$ and Oracle to make these pinheads happier. Have a special support contract, don't offer anything different, just call it something Corporate sounding and charge 10 times as much... Monty should seriously consider this. As Tyron said, come of with a fancy name like Select Corporate Support or something else, promise 24-hour turnaround on MySQL support (which you pretty much do already), and charge just under the MS price. Frank. It is truly a fine idea ... -- 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: Problems installing mysql3.23.41 source version
sachin shetty writes: Hello I get the following error message when i complie the source version of mysql3.23.41. checking character sets... configure: error: No number was found in ./sql/share/charsets/Index for the latin1 character set. This is a bug in the MySQL distribution. Please report this message to [EMAIL PROTECTED] Is there something amiss in the source distribution or is there something else to it Thanks in advance Sachin What GNU make, automake, autoconf versions do you use and what compiler do you use ?? -- 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: SMALL MYSQL Problem
O'SULLIVAN JOHN writes: Hi I am just starting to write my first client with MYSQL 3.23.39 under RH Linux 7.1 and I had the following code. The code compiles fine but the call to mysql_query( ) fails with following error I used the exact same query at the MYSQL prompt and it worked fine Could anyone please tell me where I am going wrong. john First, you did not say what error. Second, before you execute mysql_query, shoot out a string to stdout. You probably forgot to escape quotes or something similar. -- 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: Table corruption at MySQL 4.0.0 shutdown ?
Fournier Jocelyn [Presence-PC] writes: Hi, I noticed an annoying behaviour with MySQL 4.0.0. I have 11 tables with a lot of rows (about 1 Million and more) which are constantly updated by a php script. It seems after a shutdown of mysql (mysqladmin -uroot -p shutdown) and a restart, some tables are corrupted (and not the same, it randomly occurs), and I have to run a myisamchk to repair them. Here is the structure of the table : CREATE TABLE searchhardwarefr9 ( mot varchar(30) NOT NULL, topic mediumint(8) unsigned DEFAULT '0' NOT NULL, date date DEFAULT '-00-00' NOT NULL, pseudo varchar(35) NOT NULL, numreponse int(10) unsigned DEFAULT '0' NOT NULL, PRIMARY KEY (mot, pseudo, date, numreponse, topic), KEY pseudo (pseudo, date, numreponse, topic), KEY numreponse (numreponse, topic), KEY topic (topic) ); -=[root@s15]=(/usr/local/var/Hardwarefr)# myisamchk -o searchhardwarefr9.MYI (17:31:25) - recovering (with keycache) MyISAM-table 'searchhardwarefr9.MYI' Data records: 977549 Duplicate key 1 for record at 30977704 against new record at 30946580 Duplicate key 1 for record at 30977736 against new record at 30946612 Duplicate key 1 for record at 30977768 against new record at 30946644 Duplicate key 1 for record at 30977796 against new record at 30946672 Duplicate key 1 for record at 30977828 against new record at 30946704 Duplicate key 1 for record at 30977860 against new record at 30946736 Duplicate key 1 for record at 30977896 against new record at 30946772 Duplicate key 1 for record at 30977928 against new record at 30946804 Duplicate key 1 for record at 30977960 against new record at 30946836 Duplicate key 1 for record at 30977992 against new record at 30946868 Duplicate key 1 for record at 30978024 against new record at 30946900 Data records: 977538 myisamchk: warning: 11 records have been removed Any idea ? (hardware related or mysql related ?) Thank you :) Jocelyn Fournier Presence-PC As you know very well, we would truly need a repeatable test case. We are very keen of fixing our 4.0 bugs, and this could be one. It could be hardware too, but how could we know ? -- 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: BDB and InnoDB in windows nt versions
Thanks for the input Heikki, I got it the right version mysql-max-nt going now. The problem was that winmysqladmin automatically started the wrong service- mysqld - so I had to uninstall that service before it would recognise any changed I made in the my.ini file done with winmysqladmin. Now I can use bdb, and show variables gives InnoDB as disabled. I've tried setting up the InnoDB variables in winmysqladmin like this, but the server won't start: [mysqld] basedir=C:/mysql #bind-address=139.133.200.222 datadir=C:/mysql/data language=C:/mysql/share/english #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M # startup parameters for InnoDB tables innodb_data_file_path = ibdata1:5M innodb_data_home_dir = C:\mysql\data\bruce\ibdata set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = C:\mysql\data\bruce\iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=5M set-variable = innodb_log_buffer_size=5M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = c:\mysql\data\bruce\iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=5M set-variable = innodb_additional_mem_pool_size=5M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 I created all the directories mentioned, but something is preventing it working. If I comment out the InnoDB lines mysql starts. Thanks in advance. At 03:16 PM 8/16/2001 +0100, you wrote: Hi all, I'm trying to work out which distribution of mysql supports BDB or InnoDB tables. I've downloaded 3.23.40 and checked 'show variables' asnd it says these tables are not supported. I know the docs say they should be available in the distro, but it seems not in this version. So, who can tell me which one does? Cheers, Bruce - 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 Cheers, Dr. Bruce A. Scharlau Dept. of Computing Science Aberdeen University Aberdeen AB24 3UE [EMAIL PROTECTED] 01224 272193 - 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
'managed' replication
hi folks, i have a problem. i want to replicate a (master)database which has no direct network connection to the slave. the only way to get the data from the master to the slave db is to 'ftp' them. the databases are used in an internet environment so i am searching for a solution without any downtime... my question is: is there a way to copy the binary log from the master db to the slave and apply the binary log to the slave database?! if it exists - is this feature 'production ready'?! has anyone faced this kind of problem and how have you solved it? thanx! |) |) |)ernd |)ecker AGI Brunnenstrasse 24, 10119 Berlin Fon ++49 (0)30 473728.0, Fax ++49 (0)30 473728.50 +++news+++news+++news+++ AGI holt Bronze-Loewen in Cannes! http://www.agi.de/tagebuch http://www.agi.com/diary (english) - 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: Error altering column name
I had this error under win when using phpMyAdmin quite frequently. It turned out that mysql creates temp files and somehow the process terminates. To get along, I dump the table, edit the sql file and reimport. Never had a problem with this method. Charles Mégnin schrieb am Freitag, 17. August 2001, 11:00:08: I am trying to change the name of a table column and get the following error message. I've tried both as a user and as root with no success. Thanks for your ideas mysql use music Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql alter table label - change name label_name varchar(30); ERROR 1: Can't create/write to file './music/#sql-28a_2d.frm' (Errcode: 13) - 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 -- 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: find mysql
Hi Can anybody recomend me a Mysql replication webpage with feedback ? - Original Message - From: AJDIN BRANDIC [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 17, 2001 12:35 PM Subject: find mysql Hi, I have received mysql db files with extensions .frm, .ISD, .ISM I was told that all I need to do is to put them in mysql data directory and it should work ok. I have RH6.2 with mysql rpm and I cannot locate where mysql data directory is. Any idea how to locate it. I wish I had received .csv files but that wasn't possyble. Regards Ajdin - 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: find mysql
hi i found it /var/lib/mysql/ regards Ajdin On Fri, 17 Aug 2001, AJDIN BRANDIC wrote: Hi, I have received mysql db files with extensions .frm, .ISD, .ISM I was told that all I need to do is to put them in mysql data directory and it should work ok. I have RH6.2 with mysql rpm and I cannot locate where mysql data directory is. Any idea how to locate it. I wish I had received .csv files but that wasn't possyble. Regards Ajdin - 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: problem running compiled version of mysql-3.23.41 with innodb
[EMAIL PROTECTED] writes: Hi all, i am not sure if i am at the right list. But i will ask my question anyway. Here is the problem. I have compiled Mysql version 3.23.41 with Forte 6 update 1 from Sun. I have done this on a SPARC system and complied it 64bit. I didn't had any prblems in compiling it with the option innodb no errors only some warnings. After i have instlled it i am creating my my.cnf file with all the directory etc... When i start it up i is creating the files, and then at the last logs it creates it but then hangs. you can wait for days but nothing happens after that. Does anybody know how i can solve this. Here is my my.cnf file # Uncomment the following if you are using Innobase tables innodb_data_file_path = ibdata1:400M innodb_data_home_dir = /ibdata innodb_log_group_home_dir = /ext/innodblog innodb_log_arch_dir = /ext/innodblog set-variable = innodb_mirrored_log_groups=1 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=5M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_archive=0 set-variable = innodb_buffer_pool_size=16M set-variable = innodb_additional_mem_pool_size=2M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 Thanks in advance Filip ps: the main problem is that there is no error message it simply stays there and does not give me in the error file ready to take connections Checkout for free space on /ibdata partition and for Unix privileges. -- 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:DBI bug, InnoDB bug, MySQL bug, or I'm just plain missing something.
Eric,
it was not immediately clear to me what your application
does. Does one connection update the table and
another connection do the SELECT? Then the problem
might be the consistent read. I have copied below a segment
from the InnoDB manual at www.innodb.com :
When you issue a consistent read, that is, an ordinary SELECT statement,
InnoDB will give your transaction a timepoint according to which your query
sees the database. Thus, if transaction B deletes a row and commits after
your timepoint was assigned, then you will not see the row deleted.
Similarly with inserts and updates.
You can advance your timepoint by committing your transaction and then doing
another SELECT.
This is called multiversioned concurrency control.
User A User B
set autocommit=0; set autocommit=0;
time
| SELECT * FROM t;
| empty set
|INSERT INTO t VALUES (1, 2);
|
v SELECT * FROM t;
empty set
COMMIT;
SELECT * FROM t;
empty set;
COMMIT;
SELECT * FROM t;
--
| 1|2 |
--
Thus user A sees the row inserted by B only when B has committed the insert,
and A has committed his own transaction so that the timepoint is advanced
past the the commit of B.
If you want to see the 'freshest' state of the database, you should use a
locking read:
SELECT * FROM t LOCK IN SHARE MODE;
The problem you might have is that ::dbh-commit() really does not do
a commit. Have you tested it? If you do a ::dbh-commit() after inserting
some rows with autocommit switched off, and then do ::dbh-do(ROLLBACK),
do the rows get inserted or not?
Eric, executing a commit through ::do-(COMMIT) is a perfectly
valid way to do a commit.
By the way, Sinisa, who is responsible for the DBI driver for MySQL?
It might be outdated.
Regards,
Heikki
Copied message:
I've got a part of a complex system that isn't behaving as expected. I've
got one perl program running with autocommit off that creates entries in a
table and commits the changes. At some point, the rows have their state
field changed from 'active' to 'closed', and these changes are
thencommitted.
The next step in the process is the part I'm having problems with. The
next step is supposed to pull up a list of the records that have a state
of 'closed' and process them. It works fine the first time through, or if
I limit the number of results in the select that gathers the list that I
use to process them it will loop through as many times as necessary to
process them all, but once it has processed everything that was available
when the program was first run, it stops and won't see any records that
were updated after the first run.
The interesting part is, if I run the program with autocommit on, it
works fine. Unfortunately, transactions are essential. I found that the
program works if I turn autocommit on but wrap the critical table updates
in $dbh-do(BEGIN;) and $dbh-do(COMMIT;), but I haven't tested it to
make sure there are no side-effects, and I'd rather use the mechanism
it seems that I'm supposed to use with DBI.
Has anyone seen this problem?
Is do'ing the BEGIN and COMMIT valid?
Anyway, here's the table and the second-stage program (trimmed down as far
as possible).
I'm using MySQL 3.23.41, DBI-1.19, andMsql-Mysql-modules-1.2216.
CREATE TABLE LCCer(switchId CHAR(10) BINARY NOT NULL PRIMARY KEY,
activity INT UNSIGNED NOT NULL,dnis CHAR(10),
state ENUM('active','closed','broken','summed','completed',
'archived') NOT NULL,flags
SET('needs_transreq'),
data TEXT NOT NULL,INDEX state (state),
INDEX activity (activity,dnis)) TYPE = INNODB;#!/usr/bin/perluse DBI;
use strict;
my($livedsn)=DBI:mysql:live;mysql_read_default_file=/home/archuser/.my.cnf
;
my($testdsn)=DBI:mysql:test;mysql_read_default_file=/home/archuser/.my.cnf
;
$main::livedbh=DBI-connect($livedsn,undef,undef, { RaiseError = 1,
AutoCommit = 0 });
$main::testdbh=DBI-connect($testdsn,undef,undef, { RaiseError = 1,
AutoCommit = 0 });
$main::dbh=$main::testdbh;while(1){my($rows,$switchId,$dnis,$data,$count
);
my($cmd)=SELECT switchId,dnis,data FROM LCCer WHERE state='closed'
ORDER BY activity;;
my($sth)=$main::dbh-prepare($cmd);$sth-execute();
while(($switchId,$dnis,$data)=$sth-fetchrow_array()){
$main::dbh-do(UPDATE LCCer SET state='summed' where
switchId='$switchId';);
$main::dbh-commit(); $count++;}$sth-finish();if($count1)
{
print(sleeping for 10\n); sleep(10);}}
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Re: BDB and InnoDB in windows nt versions
At 11:50 17/08/2001 +0100, Bruce Scharlau wrote: Hi! Thanks for the input Heikki, I got it the right version mysql-max-nt going now. The problem was that winmysqladmin automatically started the wrong service- mysqld - so I had to uninstall that service before it would recognise any changed I made in the my.ini file done with winmysqladmin. Now I can use bdb, and show variables gives InnoDB as disabled. I've tried setting up the InnoDB variables in winmysqladmin like this, but the server won't start: [mysqld] basedir=C:/mysql #bind-address=139.133.200.222 datadir=C:/mysql/data language=C:/mysql/share/english #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M # startup parameters for InnoDB tables innodb_data_file_path = ibdata1:5M You need to use a data file = 10 MB and = 2GB Stop the server. Delete all the files from ..\ibadata and ..\iblogs. Change the value above and restart the server. Regards, Miguel innodb_data_home_dir = C:\mysql\data\bruce\ibdata set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = C:\mysql\data\bruce\iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=5M set-variable = innodb_log_buffer_size=5M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = c:\mysql\data\bruce\iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=5M set-variable = innodb_additional_mem_pool_size=5M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 I created all the directories mentioned, but something is preventing it working. If I comment out the InnoDB lines mysql starts. Thanks in advance. At 03:16 PM 8/16/2001 +0100, you wrote: Hi all, I'm trying to work out which distribution of mysql supports BDB or InnoDB tables. I've downloaded 3.23.40 and checked 'show variables' asnd it says these tables are not supported. I know the docs say they should be available in the distro, but it seems not in this version. So, who can tell me which one does? Cheers, Bruce - 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 Cheers, Dr. Bruce A. Scharlau Dept. of Computing Science Aberdeen University Aberdeen AB24 3UE [EMAIL PROTECTED] 01224 272193 - 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 -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ 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: BDB and InnoDB in windows nt versions
Bruce, the tablespace must be = 10 MB. You have only specified 5M. I tested with .41 and got the following error message: C:\trybuild\client_debugmysqld --console InnoDB: Error: tablespace size must be at least 10 MB 010817 15:28:15 Can't init databases Regards, Heikki Copied message: Thanks for the input Heikki, I got it the right version mysql-max-nt going now. The problem was that winmysqladmin automatically started the wrong service- mysqld - so I had to uninstall that service before it would recognise any changed I made in the my.ini file done with winmysqladmin. Now I can use bdb, and show variables gives InnoDB as disabled. I've tried setting up the InnoDB variables in winmysqladmin like this, but the server won't start: [mysqld]basedir=C:/mysql #bind-address=139.133.200.222 datadir=C:/mysql/data language=C:/mysql/share/english #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M # startup parameters for InnoDB tables innodb_data_file_path = ibdata1:5M innodb_data_home_dir = C:\mysql\data\bruce\ibdata set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = C:\mysql\data\bruce\iblogs set-variable = innodb_log_files_in_group=3set-variable = innodb_log_file_size=5M set-variable = innodb_log_buffer_size=5Minnodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = c:\mysql\data\bruce\iblogsinnodb_log_archive=0 set-variable = innodb_buffer_pool_size=5M set-variable = innodb_additional_mem_pool_size=5M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 I created all the directories mentioned, but something is preventing it working. If I comment out the InnoDB lines mysql starts.Thanks in advance. - 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 mysql
Date |Fri, 17 Aug 2001 11:35:28 +0100 (BST) From |AJDIN BRANDIC [EMAIL PROTECTED] Hello! AB Hi, AB I have received mysql db files with extensions .frm, .ISD, .ISM AB I was told that all I need to do is to put them in mysql data directory AB and it should work ok. I have RH6.2 with mysql rpm and I cannot locate AB where mysql data directory is. AB Any idea how to locate it. I wish I had received .csv files but that AB wasn't possyble. AB Regards AB Ajdin Look into /var/lib/mysql In RH all bases here by default. ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ 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: BDB and InnoDB in windows nt versions
Thanks guys. Just one thing, why isn't this somewhere in the docs? A small note near the beginning of section 7.6.2 InnoDB startup options would seem to be an ideal place. cheers, Bruce At 03:30 PM 8/17/2001 +0300, you wrote: Bruce, the tablespace must be = 10 MB. You have only specified 5M. I tested with .41 and got the following error message: C:\trybuild\client_debugmysqld --console InnoDB: Error: tablespace size must be at least 10 MB 010817 15:28:15 Can't init databases Regards, Heikki Copied message: Thanks for the input Heikki, I got it the right version mysql-max-nt going now. The problem was that winmysqladmin automatically started the wrong service- mysqld - so I had to uninstall that service before it would recognise any changed I made in the my.ini file done with winmysqladmin. Now I can use bdb, and show variables gives InnoDB as disabled. I've tried setting up the InnoDB variables in winmysqladmin like this, but the server won't start: [mysqld]basedir=C:/mysql #bind-address=139.133.200.222 datadir=C:/mysql/data language=C:/mysql/share/english #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M # startup parameters for InnoDB tables innodb_data_file_path = ibdata1:5M innodb_data_home_dir = C:\mysql\data\bruce\ibdata set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = C:\mysql\data\bruce\iblogs set-variable = innodb_log_files_in_group=3set-variable = innodb_log_file_size=5M set-variable = innodb_log_buffer_size=5Minnodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = c:\mysql\data\bruce\iblogsinnodb_log_archive=0 set-variable = innodb_buffer_pool_size=5M set-variable = innodb_additional_mem_pool_size=5M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 I created all the directories mentioned, but something is preventing it working. If I comment out the InnoDB lines mysql starts.Thanks in advance. Cheers, Dr. Bruce A. Scharlau Dept. of Computing Science Aberdeen University Aberdeen AB24 3UE [EMAIL PROTECTED] 01224 272193 - 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: BDB and InnoDB in windows nt versions
Bruce, you are right. There is only a small note about the 10M limit in the options list in the manual. I will add a note also right after Win option examples. Regards, Heikki http://www.innodb.com ... Thanks guys. Just one thing, why isn't this somewhere in the docs? A small note near the beginning of section 7.6.2 InnoDB startup options would seem to be an ideal place.cheers,Bruce At 03:30 PM 8/17/2001 +0300, you wrote: Bruce, the tablespace must be = 10 MB. You have only specified 5M. - 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
Problems with the unique properties...
*This message was transferred with a trial version of CommuniGate(tm) Pro* Hi, I have a table in my database that has one field named design_name. The design_name is varchar(200) unique. After I created the table the need appeared to have duplicates in this field. So I tried to remove the unique property. I used: alter table designs modify design_name varchar(200); I get an ok message but the unique property still stays among the field properties. How can I remove the unique property??? Thank you, Cip - 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
win98 - perl
Hi all Ive got perl happily talking to mysql on an NT box, but I can't make it happen on win98 - although on win98 I can connect just fine to mysql through a dos box. The obvious thing would have been no mysql driver for perl on the win98 machine, but both return these values: ADO ExampleP Multiplex Proxy mysql when I run this script: use DBI; @drivers = DBI-available_drivers; print @drivers; Any ideas? Sammi Thompson Futura Interactive Ltd 1-5 Clerkenwell Road London EC1M 5PA T +44 [0]20 7608 1616 F +44 [0]20 7608 1605 www.futura.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:problem running compiled version of mysql-3.23.41 with innodb
Filip, Sinisa's suggestion about user access rights to the created data and log files might be the explanation. At least one user is running on 64-bit Sparc, but he uses gcc. What does ls -l say about the data and log files and access rights? Was InnoDB able to create them the right size? Can you run the program in a debugger (compiled with the debug info) so that we see where it stops? Regards, Heikki Copied message: [EMAIL PROTECTED] writes Hi all, i am not sure if i am at the right list. But i will ask my question anyway. Here is the problem. I have compiled Mysql version 3.23.41 with Forte 6 update 1 from Sun. I have done this on a SPARC system and complied it 64bit. I didn't had any prblems in compiling it with the option innodb no errors only some warnings. After i have instlled it i am creating my my.cnf file with all the directory etc... When i start it up i is creating the files, and then at the last logs it creates it but then hangs. you can wait for days but nothing happens after that. Does anybody know how i can solve this. Here is my my.cnf file # Uncomment the following if you are using Innobase tables innodb_data_file_path = ibdata1:400M innodb_data_home_dir = /ibdata innodb_log_group_home_dir = /ext/innodblog innodb_log_arch_dir = /ext/innodblog set-variable = innodb_mirrored_log_groups=1 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=5M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_archive=0 set-variable = innodb_buffer_pool_size=16M set-variable = innodb_additional_mem_pool_size=2M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 Thanks in advance Filip ps: the main problem is that there is no error message it simply stays there and does not give me in the error file ready to take connections Checkout for free space on /ibdata partition and for Unix privileges.-- 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
Manipulation of data - batch processing!
Hi I've got the following: Table: Erf Column Name : PortionNumber DataType: varchar(5) Records: 39000 The values of these records are all numbers that starts at 0 and ends at 200. I would like to insert one or more '0', infront of all the numbers to make sure that the length of each record are 5 numbers. I know how to update a single record, but obviously 39000 wouldn't allow me to have a weekend :) Liana [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: 'managed' replication
Could you tunnel threw on the FTP port to solve this? Simon -Original Message- From: Bernd Becker - AGI [mailto:[EMAIL PROTECTED]] Sent: 17 August 2001 12:16 To: [EMAIL PROTECTED] Subject: 'managed' replication hi folks, i have a problem. i want to replicate a (master)database which has no direct network connection to the slave. the only way to get the data from the master to the slave db is to 'ftp' them. the databases are used in an internet environment so i am searching for a solution without any downtime... my question is: is there a way to copy the binary log from the master db to the slave and apply the binary log to the slave database?! if it exists - is this feature 'production ready'?! has anyone faced this kind of problem and how have you solved it? thanx! |) |) |)ernd |)ecker AGI Brunnenstrasse 24, 10119 Berlin Fon ++49 (0)30 473728.0, Fax ++49 (0)30 473728.50 +++news+++news+++news+++ AGI holt Bronze-Loewen in Cannes! http://www.agi.de/tagebuch http://www.agi.com/diary (english) - 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: Problems with the unique properties...
Ciprian A. wrote: *This message was transferred with a trial version of CommuniGate(tm) Pro* Hi, I have a table in my database that has one field named design_name. The design_name is varchar(200) unique. After I created the table the need appeared to have duplicates in this field. So I tried to remove the unique property. I used: alter table designs modify design_name varchar(200); alter table designs change column design_name design_name varchar(200); I get an ok message but the unique property still stays among the field properties. How can I remove the unique property??? Thank you, Cip - 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 -- Gerald L. Clark [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: Problems with the unique properties...
UNIQUE is an index property. You need to remove the index with the drop command. Ciprian A. schrieb am Freitag, 17. August 2001, 15:01:51: *This message was transferred with a trial version of CommuniGate(tm) Pro* Hi, I have a table in my database that has one field named design_name. The design_name is varchar(200) unique. After I created the table the need appeared to have duplicates in this field. So I tried to remove the unique property. I used: alter table designs modify design_name varchar(200); I get an ok message but the unique property still stays among the field properties. How can I remove the unique property??? Thank you, Cip - 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 -- 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
mysql and link
Hi, could you say me a way for link the .dbf files to mysql? Ex.: .dbf -- MySQL files -- Server thanks _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - 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
Pb with mysql client display
I have the following problem: When displaying a select * query from a table I get the following: (just showing the end). | | | 2928 | 1611100 | | | | 2929 | 1251300 | +--++--+--+--+ The last column is empty, which is normal but the first isn't. In fact when performy a query on the first column select item I get the following. item UV UV UV UV This is an innodb table of about 200.000.000 million rows. Raw bcp is about 6 G. Thanks for any 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: Manipulation of data - batch processing!
On Fri, 17 Aug 2001 15:13:22 +0200
Liana Wiehahn [EMAIL PROTECTED] wrote:
Hi
I've got the following:
Table: Erf
Column Name : PortionNumber
DataType: varchar(5)
Records: 39000
The values of these records are all numbers that starts at 0 and ends at
200.
I would like to insert one or more '0', infront of all the numbers to make
sure that the length of each record are 5 numbers.
I would keep that simple and just do it manually:
UPDATE Erf SET PortionNumber=Concat('0',PortionNumber) where length(PortionNumber)5;
repeat this 4 times (or: until 0 rows affected).
Assumed is that the string is not padded with leading or trailing spaces...
regards,
rene
I know how to update a single record, but obviously 39000 wouldn't allow me
to have a weekend :)
Liana
[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: Manipulation of data - batch processing!
hi.
update Erf set PortionNumber = CONCAT('0', PortionNumber) where
LENGTH(PortionNumber) = 4;
update Erf set PortionNumber = CONCAT('00', PortionNumber) where
LENGTH(PortionNumber) = 3;
update Erf set PortionNumber = CONCAT('000', PortionNumber) where
LENGTH(PortionNumber) = 2;
update Erf set PortionNumber = CONCAT('', PortionNumber) where
LENGTH(PortionNumber) = 1;
have a nice weekend!
-ravi.
-Original Message-
From: Liana Wiehahn [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 17, 2001 9:13 AM
To: [EMAIL PROTECTED]
Subject: Manipulation of data - batch processing!
Hi
I've got the following:
Table: Erf
Column Name : PortionNumber
DataType: varchar(5)
Records: 39000
The values of these records are all numbers that starts at 0 and ends at
200.
I would like to insert one or more '0', infront of all the numbers to make
sure that the length of each record are 5 numbers.
I know how to update a single record, but obviously 39000 wouldn't allow me
to have a weekend :)
Liana
[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
Quick REGEXP problem
Hello, Can any one tell me why $sql=SELECT * FROM table WHERE pcsort REGEXP '^.$parts[0].[0-9]'; (pcscot being a CHAR(10), $parts[0] being a single alpha charcater.) works OK in 3.23 but not in 3.22. I'm trying to find UK postcodes such as e17 but not ee17. All the best, Lee - 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:DBI bug, InnoDB bug, MySQL bug, or I'm just plain missing something.
On Fri, 17 Aug 2001, Heikki Tuuri wrote: Problem resolved, thank you very much. It was indeed my missing a concept, description below: it was not immediately clear to me what your application does. Does one connection update the table and another connection do the SELECT? Yes, as it's two seperate programs. We've got a directory of dynamically loadable modules for the second part of the functionality, and the first part of the functionality takes too long to start up, so we've broken the two steps into seperate programs, so that the second part can exit and reload any time any of the loadable modules change, or a new one is added. You can advance your timepoint by committing your transaction and then doing another SELECT. This is what was throwing me. As soon as I did a ::dbh-commit() regardless of whether I updated any records, the SELECT timepoint was getting properly updated. This is the concept I was missing. I've worked with DBs that supported transactions before, but not multiversioning. If you want to see the 'freshest' state of the database, you should use a locking read: SELECT * FROM t LOCK IN SHARE MODE; The problem you might have is that ::dbh-commit() really does not do a commit. Have you tested it? If you do a ::dbh-commit() after inserting some rows with autocommit switched off, and then do ::dbh-do(ROLLBACK), do the rows get inserted or not? It's a real commit, ::dbh-do(ROLLBACK) didn't undo the ::dbh-commit(), so the problem was almost definitely my lack of understanding of the multiversioning of InnoDB. Eric, executing a commit through ::do-(COMMIT) is a perfectly valid way to do a commit. Good to know. I wasn't expecting the autocommit mode to affect SELECTs, so I was thrown off track when ::dbh-do(COMMIT) seemed to have different side-effects than ::dbh-commit(). Nice to know that they are equivelent, it was the AutoCommit on/off that made the difference. - 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
Data import sticks on auto_increment?
Problem: I'm experimenting with using mysqldump to backup my data, which seems to work ok. However, in recreating the tables I run into a problem. Using either LOAD DATA INFILE or mysqlimport methods I get the error Error: Duplicate entry '102' for key 1 Field def: record_id SMALLINT UNSIGNED AUTO_INCREMENT PRIMARY KEY ; There is no duplicate record_id '102', but I'm concerned that, since the data in the text file is not in record_id order, that the AUTO_INCREMENT option I've assigned to record_id may be causing the problem - record_id 100 comes much earlier in the file, for instance. Do you know if either LOAD DATA or mysqlimport disables auto increment? Is there something else I should be doing? 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
naming feilds
Is it possible to create a table,with say 200 feilds (named 1-200) using phpmyadmin and then import a text file into this table and have the first row of the text file as the feild names and rename the feilds names on the 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
Re: Pb with mysql client display
On Thu, Aug 16, 2001 at 10:38:46PM -0400, Xavier Leoncini wrote: I have the following problem: When displaying a select * query from a table I get the following: (just showing the end). | | | 2928 | 1611100 | | | | 2929 | 1251300 | +--++--+--+--+ The last column is empty, which is normal but the first isn't. In fact when performy a query on the first column select item I get the following. item UV UV UV UV This is an innodb table of about 200.000.000 million rows. Raw bcp is about 6 G. Thanks for any help. Looks like you inserted characters like \m in your database. Control caracters. The 'UV'`s are there but you cannot see them because the last column data has scrmbled your display. The shifted |`s hint to that. Good luck. -- The Moon is Waning Crescent (3% of Full) nieuw.nl - 2dehands.nl - 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: Manipulation of data - batch processing!
Thanks everybody
Ravi's syntax worked and I'm on my way to have a nice weekend!:)
cheers
Liana
-Original Message-
From: Ravi Raman [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 17, 2001 4:39 PM
To: Liana Wiehahn; [EMAIL PROTECTED]
Subject: RE: Manipulation of data - batch processing!
hi.
update Erf set PortionNumber = CONCAT('0', PortionNumber) where
LENGTH(PortionNumber) = 4;
update Erf set PortionNumber = CONCAT('00', PortionNumber) where
LENGTH(PortionNumber) = 3;
update Erf set PortionNumber = CONCAT('000', PortionNumber) where
LENGTH(PortionNumber) = 2;
update Erf set PortionNumber = CONCAT('', PortionNumber) where
LENGTH(PortionNumber) = 1;
have a nice weekend!
-ravi.
-Original Message-
From: Liana Wiehahn [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 17, 2001 9:13 AM
To: [EMAIL PROTECTED]
Subject: Manipulation of data - batch processing!
Hi
I've got the following:
Table: Erf
Column Name : PortionNumber
DataType: varchar(5)
Records: 39000
The values of these records are all numbers that starts at 0 and ends at
200.
I would like to insert one or more '0', infront of all the numbers to make
sure that the length of each record are 5 numbers.
I know how to update a single record, but obviously 39000 wouldn't allow me
to have a weekend :)
Liana
[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
Logging in for the first time
I use webmin to administer my MySQL database on a Linux Slackware 8 box. I installed MySql in /usr/local/mysql and got Webmin to see it. When I try to connect, it needs an administrative login. I've tried the root login for the system and it doesn't seem to do it. Any idea what the login might be by default? Denis Denis A. Baldwin (A+/MCP/I-Net+/Net+/CCA) Network Administrator, CAE, Inc. 810-231-9373, ext. 229 [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
Innodb performance (again)
Though i would give Innodb another go with the latest mysql-max RPM's (3.23.41) for linux running on a Redhat machine. This is on a Compaq ML-370, 667Mhz with 1gig mem on kernel 2.2.19. Disks are Raid-5. Huge performance difference between Innodb and MyISAM for a simple table create (7 times slower!). Total size of original maillog.email table is around 700meg (varchar, thus packed), so we ar maybe looking at around 100-150meg for the new table: mysql select count(*) from maillog.email; +--+ | count(*) | +--+ | 6744395 | +--+ 1 row in set (0.00 sec) mysql create table mailtest type=innodb select * from maillog.email limit 100; Query OK, 100 rows affected (7 min 9.92 sec) Records: 100 Duplicates: 0 Warnings: 0 mysql create table mailtest2 select * from maillog.email limit 100; Query OK, 100 rows affected (1 min 56.13 sec) Records: 100 Duplicates: 0 Warnings: 0 my.cnf: [mysqld] #log-long-format log = mysqld.log #log-slow-queries = mysqld-slow.log set-variable = key_buffer=64M #set-variable = max_allowed_packet=1M set-variable = table_cache=128 set-variable = sort_buffer=4M set-variable = record_buffer=1M #set-variable = thread_cache=8 #set-variable = thread_concurrency=8 # Try number of CPU's*2 #set-variable = myisam_sort_buffer_size=64M innodb_data_file_path = ibdata1:512M innodb_data_home_dir = /data/innodb/ibdata set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = /data/innodb/iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30M set-variable = innodb_log_buffer_size=16M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = /data/innodb/iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=80M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 [myisamchk] set-variable = key_buffer=256M set-variable = sort_buffer=256M set-variable = read_buffer=2M set-variable = write_buffer=2M -- Richard Ellerbrock [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
Formatting Price Field in my Table so 0.20 does not become 0.2....
Hi people, Anyone know how to get a field in one of my table in a form that any number that I want to be displayed as 0.20 doesn't round off as 0.2? So 0.20 for the cost instead of 0.2? Or do I have to do this with the Server Side Language I'm using to format the value? Or some extra SQL command? Thanxs Steve Griff - 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
Possible problem with MySQL 3.23.41 RPM source distribution on Linux RH7.0
May be a red herring, however this ate several hours, so...
..enjoy! :-
Description:
Possible problem with using the existing 3.23.41 SRC RPM distribution
This package may have some bug.
This is the source RPM package downloaded from mysql.com, with MD5-hash:
MySQL-3.23.41-1.src.rpm -- 91eb 9ef7 30cc 81a3 32d3 23dd baca 848a
The mysqld created by that distribution does not work correctly,
although it is being compiled without big ado.
Immediately after installation, I connect to MySQL:
mysql SHOW DATABASES;
+--+
| Database |
+--+
| |
| |
| |
| |
| |
| |
| |
| |
+--+
8 rows in set (0.00 sec)
mysql USE mysql
Database changed
mysql SHOW TABLES;
Empty set (0.00 sec)
mysql DESCRIBE user;
+-+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+-+-+--+-+-+---+
| Host| char(60) binary | | PRI | | |
| User| char(16) binary | | PRI | | |
| Password| char(16) binary | | | | |
| Select_priv | enum('N','Y') | | | N | |
| Insert_priv | enum('N','Y') | | | N | |
| Update_priv | enum('N','Y') | | | N | |
| Delete_priv | enum('N','Y') | | | N | |
| Create_priv | enum('N','Y') | | | N | |
| Drop_priv | enum('N','Y') | | | N | |
| Reload_priv | enum('N','Y') | | | N | |
| Shutdown_priv | enum('N','Y') | | | N | |
| Process_priv| enum('N','Y') | | | N | |
| File_priv | enum('N','Y') | | | N | |
| Grant_priv | enum('N','Y') | | | N | |
| References_priv | enum('N','Y') | | | N | |
| Index_priv | enum('N','Y') | | | N | |
| Alter_priv | enum('N','Y') | | | N | |
+-+-+--+-+-+---+
17 rows in set (0.00 sec)
How-To-Repeat:
Not an intermittent bug
Fix:
Downloaded the src tarball from mysql.com for version
3.23.41-1 with MD5-hash:
60ae e5de 4dba 86a7 4174 f2da 303c 4d36
Compiled the daemon and dropped the binary mysqld into place of the
existing RPM-issued mysqld (some fixing of my.cnf required). This does
the trick:
mysql SHOW DATABASES;
+--+
| Database |
+--+
| mysql|
| test |
| tmp |
+--+
3 rows in set (0.00 sec)
mysql USE mysql
Database changed
mysql SHOW TABLES\g
+-+
| Tables_in_mysql |
+-+
| columns_priv|
| db |
| func|
| host|
| tables_priv |
| user|
+-+
6 rows in set (0.00 sec)
Submitter-Id: David Tonhofer
Originator:root
Organization: m-plify S.A.
MySQL support: none
Synopsis: RPM package gives buggy msqld
Severity: serious
Priority: low
Category: mysql
Class: sw-bug
Release: mysql-3.23.41 (Official MySQL RPM)
Server: /usr/bin/mysqladmin Ver 8.21 Distrib 3.23.41, for pc-linux-gnu on
i686
Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.41
Protocol version10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 29 min 56 sec
Threads: 1 Questions: 7 Slow queries: 0 Opens: 7 Flush tables: 1 Open
tables: 1 Queries per second avg: 0.004
Environment:
machine, os, target, libraries (multiple lines)
System: Linux neutrino 2.2.16-22 #1 Tue Aug 22 16:49:06 EDT 2000 i686
unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 2731 (Red Hat Linux 7.0)
Compilation info: CC='egcs' CFLAGS=' -O3' CXX='egcs'
-O3 -felide-constructors -fno-exceptions -fno-rtti '
LDFLAGS=''
LIBC:
lrwxrwxrwx1 root root 14 Jul 4 17:02 /lib/libc.so.6 -
libc-2.1.92.so
-rwxr-xr-x1 root root 4776568 Aug 30 2000 /lib/libc-2.1.92.so
-rw-r--r--1 root root 22607104 Aug 30 2000 /usr/lib/libc.a
-rw-r--r--1 root root 178 Aug 30 2000 /usr/lib/libc.so
Configure command:
./configure --disable-shared --with-mysqld-ldflags=-all-static --with-clien
t-ldflags=-all-static --without-berkeley-db --without-innodb --enable-assemb
ler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.so
ck --prefix=/
Re: check if an index exists?
On Fri, 17 Aug 2001, Christopher Teli wrote: How can I check if an index exists on a table??? Is there some where I can query the admin tables? SHOW INDEX FROM tablename - 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: check if an index exists?
On Fri, Aug 17, 2001 at 09:32:05AM -0700, Christopher Teli wrote: How can I check if an index exists on a table??? Is there some where I can query the admin tables? 'DESCRIBE tablename' or 'SHOW COLUMNS FROM tablename'. Figure out where it says 'index' for yourself :) (since I don't know exactly :) Greetz, Peter -- Against Free Sex! http://www.dataloss.nl/Megahard_en.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: check if an index exists?
thank you, i was actually trying to access the table through C-API and had trouble with show index when I used the following query. show index from db.table i will have to try show index from table from db thank you, Chris -Original Message- From: Philip Mak [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 10:16 AM To: Christopher Teli Cc: Mysql (E-mail) Subject: Re: check if an index exists? On Fri, 17 Aug 2001, Christopher Teli wrote: How can I check if an index exists on a table??? Is there some where I can query the admin tables? SHOW INDEX FROM tablename - 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: check if an index exists?
show index from tablename; This returns a result set listing all indexes on the table. --Greg Johnson -Original Message- From: Christopher Teli [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 12:32 PM To: Mysql (E-mail) Subject:check if an index exists? How can I check if an index exists on a table??? Is there some where I can query the admin tables? Chris - 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: Formatting Price Field in my Table so 0.20 does not become 0.2....
Dear Steve, use TRUNCATE or ROUND. Manual: http://www.mysql.com/doc/M/a/Mathematical_functions.html Like: SELECT TRUNCATE(my_col, 2) FROM my_tbl Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # Tel: +49-30-46307-382 Fax: +49-30-46307-388 - Original Message - From: pc [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 17, 2001 6:15 PM Subject: Formatting Price Field in my Table so 0.20 does not become 0.2 Hi people, Anyone know how to get a field in one of my table in a form that any number that I want to be displayed as 0.20 doesn't round off as 0.2? So 0.20 for the cost instead of 0.2? Or do I have to do this with the Server Side Language I'm using to format the value? Or some extra SQL command? Thanxs Steve Griff - 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: check if an index exists?
Dear Chris, How can I check if an index exists on a table??? The manual sais: SHOW INDEX FROM tbl_name [FROM db_name] Check: http://www.mysql.com/doc/S/H/SHOW.html Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # Tel: +49-30-46307-382 Fax: +49-30-46307-388 - Original Message - From: Christopher Teli [EMAIL PROTECTED] To: Mysql (E-mail) [EMAIL PROTECTED] Sent: Friday, August 17, 2001 6:32 PM Subject: check if an index exists? How can I check if an index exists on a table??? Is there some where I can query the admin tables? Chris - 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: Formatting Price Field in my Table so 0.20 does not become 0.2....
try varchar. pc schrieb am Freitag, 17. August 2001, 18:15:10: Hi people, Anyone know how to get a field in one of my table in a form that any number that I want to be displayed as 0.20 doesn't round off as 0.2? So 0.20 for the cost instead of 0.2? Or do I have to do this with the Server Side Language I'm using to format the value? Or some extra SQL command? Thanxs Steve Griff - 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 -- 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
Backups from Server to localhost
Hi everybody I want to make backing up for my databases from the server into my pc, I login to the server with the administrator username and password, how could this backing up be done? and is there any risk that i should be aware of ? is there any softwares that could be used for administrator managemnet or shall we still keep using the command prompt ? Yours: Hanan M. Khader _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - 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 optional file (my.cnf) problem
The server doesn't look for a users .my.cnf. This would only be useful for the client programs. Fai wrote: Does any body know how to prevent mysql server looking for user specific optional file ( .my.cnf)? So, user cannot put the optional file (.my.cnf) in his home directory to affect the mysql server behaviour. Thank you very much! -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql optional file (my.cnf) problem
On Sat, 18 Aug 2001, Fai wrote: Does any body know how to prevent mysql server looking for user specific optional file ( .my.cnf)? So, user cannot put the optional file (.my.cnf) in his home directory to affect the mysql server behaviour. Even if user can put the optional file in his home directory, it does not affect the mysql server behavior. It only affects the mysql client behavior. - 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: Formatting Price Field in my Table so 0.20 does not become0.2....
While there may be a way to manipulate this with MySQL, you may find that the interface language is simpler. PHP and Perl both offer a command 'printf' which allows you to heavily format a string or number. Like: printf(The price is $%.2f, today only, $sqlResultRow-amount); would yield The price is $24.95, today only. This differs a bit between perl and PHP, but it's pretty much the same. Nelson Anyone know how to get a field in one of my table in a form that any number that I want to be displayed as 0.20 doesn't round off as 0.2? So 0.20 for the cost instead of 0.2? Or do I have to do this with the Server Side Language I'm using to format the value? Or some extra SQL command? - 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: Backups from Server to localhost
On Fri, 17 Aug 2001, hanan khader wrote: Hi everybody I want to make backing up for my databases from the server into my pc, I login to the server with the administrator username and password, how could this backing up be done? and is there any risk that i should be aware of ? is there any softwares that could be used for administrator managemnet or shall we still keep using the command prompt ? You can run mysqldump to get a local copy of the CREATE TABLE and INSERT statements needed to re-create the tables. This is the easiest way, but if your database is tens of megabytes or larger, it takes longer than it should. The other option is to copy the data files (.MYD, .FRM) directly from the MySQL data directories. In order to get a consistent snapshot of those files, you need to flush the buffers (only MySQL root can flush) and lock the tables first. You'll also have to use a UNIX user that can read the data files directly. So what you could do is something like: - open MySQL connection to remote host as MySQL user root - open FTP connection to remote host as UNIX user mysql - execute LOCK TABLES on all the tables you want to get - execute FLUSH TABLES - download the .MYD and .FRM files via FTP - execute UNLOCK TABLES - close the FTP and MySQL connection You can replace rsync with FTP in order to transfer the file faster on subsequent backups. Note that while you're waiting for the FTP to complete, the tables will remain locked so no one else can use them. If this would take too long, then you should LOCK TABLES, copy the data files to another location on the same system (should only take a few seconds), UNLOCK TABLES, then FTP the copied data files. - 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: web clients: frustrated beyond my sanity
Daniel Woods noted this error: Warning: MySQL Connection Failed: Access denied for user: 'mysite@localhost' (Using password: NO) in /home/mysite/public_html/phpMyAdmin/lib.inc.php3 on line 170 I have added users apache and mysite to /etc/group for group mysql, restarted Apache and mysql. Why is saying 'mysite@localhost' when the script is set to use mysql user 'dbuser' with valid password. Logging in as 'mysite', and trying 'mysql -u dbuser -p mysql' works. From another site at work, 'mysql -u dbuser -h mysite.ca -p mysql' works. It sounds like MySQL is denying access to user mysite. The OS isn't causing you problems; only MySQL is. As I understand your description, the user that is running the MySQL daemon is 'mysite'. You are trying to log in as 'dbuser', but for some reason MySQL is not getting that information and defaulting to the user that runs the daemon, mysite, with no password. However, my guess is that 'mysite' is not a granted privileges in MySQL so MySQL is denying access. Have you tried 'mysql -u mysite'? If you cannot get in, then part of the problem is not having 'mysite' set up with MySQL. Here is the page from the documentation that should help with setting up user 'mysite': http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm inistration.html#User_Account_Management You have a second problem: why isn't phpMyAdmin using 'dbuser' and 'mysql'? I have no experience with php so I'm sorry I can't help you there. Best of luck, Kurt Hansen [EMAIL PROTECTED] http://www.charityweb.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
mind twisting question on date functions
I've ran into a wall with the MAX() function when used with DATE_ADD(). I'm posting to the list in hopes that someone has an idea, comments, or suggestions for me. This is the problem at hand: Given: SELECT (TO_DAYS(MAX(DATE_ADD(T.StartDate, INTERVAL T.Duration Day - (TO_DAYS(T.StartDate)) AS aDate FROM Tasks T; Explanation: StartDate = The start date of a task Duration = The length (in days) of a task I'm attempting to find the number of days between a Task's StartDate and the latest (MAX()) End Date in the table. I am using DATE_ADD with Duration instead of an EndDate column because the Duration field will make linking tasks easier for me in the future. When the above SQL code is executed on the table Tasks, the result I receive is correct and all is well in the world. The problem comes when a no GROUP column is added into the SELECT statement. For example: SELECT T.TaskName, (TO_DAYS(MAX(DATE_ADD(T.StartDate, INTERVAL T.Duration Day - (TO_DAYS(T.StartDate)) AS aDate FROM Tasks T; This will not work because you can't mix No GROUP columns with GROUP columns WITHOUT a GROUP BY clause. Simple fix... add GROUP BY TaskID. TaskID is the primary key and therefore unique so we shouldn't have problems grouping by it. Now I have: SELECT T.TaskName, (TO_DAYS(MAX(DATE_ADD(T.StartDate, INTERVAL T.Duration Day - (TO_DAYS(T.StartDate)) AS aDate FROM Tasks T GROUP BY T.TaskID; I execute the above code which *should* be good and WOAH! Without changing my code for aDate, the result has changed and exactly mirrors the Duration field. Take the no GROUP column out (T.TaskName in this case) and the GROUP BY clause and all is well in the world again. IF the no GROUP column is taken out but the GROUP BY clause is left in, I still get messed up results. I'm sure the GROUP BY has to be messing something up here, I just don't know what. I can't get rid of the GROUP BY if I'm using MAX() with other columns though. Any ideas, suggestions, creative criticism, etc, would be greatly appreciated. Other Notes: I've also tried GROUP BY TaskName,ParentID which is unique. Same results that mirror the Duration. Possibly GROUP BY is throwing off the DATE_ADD() or MAX() function? Thanks in advance for any help. -- Phil Stewart [EMAIL PROTECTED] - email (323) 402-1223 x7845 - voicemail/fax __ FREE voicemail, email, and fax...all in one place. Sign Up Now! http://www.onebox.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
User specific query
Hi all, We want to set up a user in mysql and allow him to send his queries to our database from his server. (PHP) The data in our database contains our other customers' as well as the guy who wants to directly access it. We would like to check his queries before send it to the database. For example: If he sends in select * from table, we would like the mysql actaully execute select * from table where hisID=1000; Basically, we want mysql database to screen the query sent from a certain user, and apply some conditions on that query. Is it possible to do it? Is there a better way to do it? Thanks in advance. Jiang
Replication problem
Does any know how to fix this database replication problem. Last Lines from Err File 010815 21:38:55 Slave thread exiting, replication stopped in log 'salem-bin.013' at position 6867 010815 21:38:55 Error running query, slave aborted. Fix the problem, and re-start the slave thread with mysqladmin start-slave. We stopped at log 'salem-bin.013' position 6867 010815 21:38:55 Slave: error running query 'UPDATE themes SET textcolor='#0a' WHERE theme_id = 2 AND theme_name = 'Ocean' AND bgcolor = '#FF' AND textcolor = '#00' AND color1 = '#CC' AND color2 = '#9BB6DA' AND table_bgcolor = '#00' AND header_image = 'images/toxicmold1.gif' AND newtopic_image = 'images/new topic.gif' AND reply_image = 'images/reply.gif' AND linkcolor = '#011001' AND vlinkcolor = '#2100cc' AND theme_default = 0 AND fontface = 'sans-serif' AND fontsize1 = '1' AND fontsize2 = '2' AND fontsize3 = '-2' AND fontsize4 = '+1' AND tablewidth = '95%' AND replylocked_image = 'images/reply_locked-dark.jpg'' ERROR: 1146 Table 'mold_db.themes' doesn't exist .013' at position 6867 I have done mysqladmin start-slave and it does not work, The master is a Linux and the slave is Windows 2000 pro. Slave Ver Server version 3.23.40-nt #This File was made using the WinMySQLAdmin 1.2 Tool #8/14/2001 11:42:25 PM #Uncomment or Add only the keys that you know how works. #Read the MySQL Manual for instructions [mysqld] basedir=C:/mysql #bind-address=10.100.4.105 datadir=C:/mysql/data #language=C:/mysql/share/your language directory #slow query log#= #tmpdir#= #port=3306 master-host=10.100.4,102 master-user=repl1 master-password=eatme master-port=3306 server-id=2 replicate-do-db=mold_counter_db replicate-do-db=mold_db peplicate-do-db=vpopmail #set-variable=key_buffer=16M [WinMySQLadmin] Server=C:/mysql/bin/mysqld-nt.exe user=repl1 password=eatme QueryInterval=10 Master Ver Server version 3.23.40-log # Example mysql config file for small systems. # # This is for a system with little memory (= 64M) where MySQL is only used # from time to time and it's important that the mysqld deamon # doesn't use much resources. # # You can copy this file to # /etc/mf.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /usr/local/var) or # ~/.my.cnf to set user-specific options. # # One can in this file use all long options that the program supports. # If you want to know which options a program support, run the program # with --help option. # The following options will be passed to all MySQL clients [client] #password = your_password port= 3306 socket= /var/lib/mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port= 3306 socket= /var/lib/mysql/mysql.sock skip-locking set-variable = key_buffer=16K set-variable = max_allowed_packet=1M set-variable = thread_stack=64K set-variable = table_cache=4 set-variable = sort_buffer=64K set-variable = net_buffer_length=2K server-id = 1 log-bin # Uncomment the following if you want to log updates #log-bin # Uncomment the following if you are NOT using BDB tables #skip-bdb # Uncomment the following if you are using Innobase tables #innodb_data_file_path = ibdata1:100M #innodb_data_home_dir = /usr/local/var/ #innodb_log_group_home_dir = /usr/local/var/ #innodb_log_arch_dir = /usr/local/var/ #set-variable = innodb_mirrored_log_groups=1 #set-variable = innodb_log_files_in_group=3 #set-variable = innodb_log_file_size=5M #set-variable = innodb_log_buffer_size=8M #innodb_flush_log_at_trx_commit=1 #innodb_log_archive=0 #set-variable = innodb_buffer_pool_size=16M #set-variable = innodb_additional_mem_pool_size=2M #set-variable = innodb_file_io_threads=4 #set-variable = innodb_lock_wait_timeout=50 [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] set-variable = key_buffer=8M set-variable = sort_buffer=8M [myisamchk] set-variable = key_buffer=8M set-variable = sort_buffer=8M [mysqlhotcopy] interactive-timeout - 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: Backups from Server to localhost
Dear Hanan, try PhpMyAdmin (www.phpmyadmin.com). Nice and easy to backup databases and tables, and easy to import from the backup SQL files. It's browser based, so it's platform independent. It's not secure, though (http://www.securereality.com.au/studyinscarlet.txt), so make sure to protect the directory it's installed in with .htaccess when running it on a public server. Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # Tel: +49-30-46307-382 Fax: +49-30-46307-388 - Original Message - From: hanan khader [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 17, 2001 7:47 PM Subject: Backups from Server to localhost Hi everybody I want to make backing up for my databases from the server into my pc, I login to the server with the administrator username and password, how could this backing up be done? and is there any risk that i should be aware of ? is there any softwares that could be used for administrator managemnet or shall we still keep using the command prompt ? Yours: Hanan M. Khader _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - 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
FULLTEXT search plus additional qualifiers
If I am using the MATCH function to search within a field with a
FULLTEXT index, can I add additional qualifiers to refine that
search? For example:
SELECT *, MATCH (Description) AGAINST ('unique') AS score FROM
Tags.web WHERE MATCH (Description) AGAINST ('unique') AND
type='Record'
Will this work to search the field defined with the FULLTEXT index,
but also be constrained by the AND operator to only includes certain
records (in this case records with the text 'Record' in the field
type).
Would this have to be a sub-select? (though I know MySQL is not able
to do sub-selects in a strict sense)
--
Michael
__
||| Michael Collins |||
||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED]
||| Seattle, WA, USA ||| http://www.lassodev.com
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
Select *,count(*) not returning 0 when needed
Doc: Try this... SELECT C.domain, email, telephone, count(*) FROM Customers AS C LEFT JOIN Orders AS O ON O.domain=C.domain GROUP BY C.domain, email, telephone ; Cheers, Kent [fodder=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
User specific queries.
Hi all, We want to set up a user in mysql and allow him to send his queries to our database from his server. (PHP) The data in our database contains our other customers' as well as the guy who wants to directly access it. We would like to check his queries before send it to the database. For example: If he sends in select * from table, we would like the mysql actaully execute select * from table where hisID=1000; Basically, we want mysql database to screen the query sent from a certain user, and apply some conditions on that query. Is it possible to do it? Is there a better way to do it? Thanks in advance. Jiang - 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: Formatting Price Field in my Table so 0.20 does not become 0
On 17-Aug-2001 pc wrote: Hi people, Anyone know how to get a field in one of my table in a form that any number that I want to be displayed as 0.20 doesn't round off as 0.2? So 0.20 for the cost instead of 0.2? float(9,2); 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. (53kr33t w0rdz: sql table query) - 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 specific queries.
On Fri, 17 Aug 2001, Mysql Mailing List wrote: If he sends in select * from table, we would like the mysql actaully execute select * from table where hisID=1000; Basically, we want mysql database to screen the query sent from a certain user, and apply some conditions on that query. Is it possible to do it? Is there a better way to do it? As far as I know, the permissions control system of MySQL can only restrict operations at the table level, not the row level. Someone correct me if I'm wrong. I think you would have to write a middleware layer that accepts queries directly from the user, then modifies the queries so that they only affect the rows that they should. If you do this, you have to be very careful in parsing the queries. For example, what if you provide a function to him that executes this query: SELECT ___ WHERE hisID=1000 AND ___ and let him fill in the ___. Guess what, that's not secure at all! He could do: SELECT * FROM table WHERE hisID=1000 AND 1 OR 1 and he's bypassed your security check. You'll have to think about this carefully if you try to do this. - 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: web clients: frustrated beyond my sanity
Kurt, Warning: MySQL Connection Failed: Access denied for user: 'mysite@localhost' (Using password: NO) in /home/mysite/public_html/phpMyAdmin/lib.inc.php3 on line 170 I have added users apache and mysite to /etc/group for group mysql, restarted Apache and mysql. Why is saying 'mysite@localhost' when the script is set to use mysql user 'dbuser' with valid password. Logging in as 'mysite', and trying 'mysql -u dbuser -p mysql' works. From another site at work, 'mysql -u dbuser -h mysite.ca -p mysql' works. It sounds like MySQL is denying access to user mysite. The OS isn't causing you problems; only MySQL is. Apache server is running as apache, however my host mysite.ca runs su-exec'ed as user/group mysite/mysite. And virtual host hersite.ca runs as regular hersite/apache. Either way, it fails. The mysqld is as user 'mysql: root 17657 1 1 14:45 pts/1 00:00:00 /bin/sh /usr/bin/safe_mysqld --datadir=/var/lib/mysql/data --pid-file=/var/lib/mysql/data/www.mysite.ca. mysql 17682 17657 3 14:45 pts/1 00:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql/data --user=mysql --pid-file=/var/lib/mysql/data/www.mysite.ca As I understand your description, the user that is running the MySQL daemon is 'mysite'. You are trying to log in as 'dbuser', but for some reason MySQL is not getting that information and defaulting to the user that runs the daemon, mysite, with no password. However, my guess is that 'mysite' is not a granted privileges in MySQL so MySQL is denying access. I am trying to use 'dbuser' and valid password (works on command line), however it seems that MySQL returns an error for the UNIX user 'mysite'. I did add 'mysite' to mysql.user table and it works from command line, however it still won't work. Have you tried 'mysql -u mysite'? If you cannot get in, then part of the problem is not having 'mysite' set up with MySQL. Here is the page from the documentation that should help with setting up user 'mysite': No problems from the command line. http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm inistration.html#User_Account_Management You have a second problem: why isn't phpMyAdmin using 'dbuser' and 'mysql'? I have no experience with php so I'm sorry I can't help you there. I am starting over the permissions from scratch fingers crossed ;) Thanks... Dan. - 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 Spawns Many Processes and Uses 100% CPU! PART #1
This message is broken into two parts because the MySQL list blocked it as being too big!!! Okay, here is the problem: everyone once in a while, say once or twice a day, my web server running RH 7.2, PHP 4.0.6 and MySQL, will seem to freeze (from a web users point of view). Upon SSH'ing into the server, and running top I see the system load averages in the 90s (!!!) and all I see for processes on the list is mysqld. The CPU usage is at 100%, and the top mysqld process ususally is taking 14% or so, then 12% then a lot of 10%, and on down until it goes off the list. Below, I have included a copy of the top status during one of the afore mentioned problem times: 3:17pm up 23 min, 1 user, load average: 87.18, 54.78, 24.56 282 processes: 203 sleeping, 79 running, 0 zombie, 0 stopped CPU0 states: 96.14% user, 3.0% system, 0.0% nice, 0.0% idle CPU1 states: 95.5% user, 4.9% system, 0.0% nice, 0.0% idle Mem: 1026964K av, 757988K used, 268976K free, 56K shrd,8116K buff Swap: 2048248K av, 0K used, 2048248K free 312316K cached PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND 4784 mysql 18 0 28472 27M 2236 R15.5 2.7 0:02 mysqld 4944 mysql 18 0 26316 25M 2236 R 7.6 2.5 0:00 mysqld 4940 mysql 19 0 26316 25M 2236 S 7.2 2.5 0:00 mysqld 4942 mysql 17 0 26316 25M 2236 S 7.2 2.5 0:00 mysqld 5049 mysql 19 0 24948 24M 2236 R 3.9 2.4 0:00 mysqld 4810 mysql 20 0 26316 25M 2236 R 3.1 2.5 0:01 mysqld 4808 mysql 20 0 26316 25M 2236 R 3.0 2.5 0:01 mysqld 4806 mysql 17 0 26316 25M 2236 R 2.8 2.5 0:01 mysqld 4727 mysql 20 0 28472 27M 2236 R 2.7 2.7 0:02 mysqld 4751 mysql 20 0 28472 27M 2236 R 2.7 2.7 0:02 mysqld 4759 mysql 20 0 28472 27M 2236 R 2.7 2.7 0:02 mysqld 4794 mysql 20 0 26468 25M 2236 R 2.7 2.5 0:01 mysqld 4799 mysql 14 0 26204 25M 2236 R 2.7 2.5 0:01 mysqld 4804 mysql 15 0 26316 25M 2236 R 2.7 2.5 0:01 mysqld 4823 mysql 20 0 26316 25M 2236 R 2.7 2.5 0:01 mysqld 4868 mysql 20 0 26316 25M 2236 R 2.7 2.5 0:01 mysqld 4798 mysql 14 0 26156 25M 2236 R 2.6 2.5 0:01 mysqld 4802 mysql 19 0 26316 25M 2236 R 2.5 2.5 0:01 mysqld 4866 mysql 20 0 26316 25M 2236 R 2.5 2.5 0:01 mysqld 4963 mysql 20 0 26316 25M 2236 R 2.5 2.5 0:01 mysqld 4762 mysql 16 0 28472 27M 2236 S 2.4 2.7 0:02 mysqld 4795 mysql 19 0 26580 25M 2236 R 2.4 2.5 0:01 mysqld 4821 mysql 18 0 26316 25M 2236 S 2.4 2.5 0:01 mysqld 4957 mysql 20 0 26316 25M 2236 R 2.4 2.5 0:01 mysqld 4997 mysql 20 0 26316 25M 2236 R 2.4 2.5 0:00 mysqld 4769 mysql 18 0 28472 27M 2236 S 2.3 2.7 0:02 mysqld And here is my my.cnf file: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock set-variable = max_connections=300 [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid When I do an /etc/rc.d/init.d/mysqld restart the server restarts, though a bit slowly, and I sometimes have to manually kill a few mysqld processes, but returns to normal. I have tried all kinds of things to figure out what is going on here. I raised the max_connections from 100 to 300, and edited the following httpd.conf settings: MinSpareServers 15 MaxSpareServers 30 StartServers 15 MaxClients 150 MaxRequestsPerChild 1000 Ryan Shrout Owner - Amdmb.com http://www.amdmb.com/ [EMAIL PROTECTED]
Single Quotes in a Select Statement
Greetings MySQLers! This messages is about MySQL. (had to put that in for the spam filter) I have a record in my database: productID Title 4 This title has a ' in it. In the database, this is actually stored as: productID Title 4 This title has a \' in it. I have a query: Select * from product where title = 'This title has a \' in it.'; This query does not work. Can anyone tell me how to build a query that will return that title? Things I have tried: Select * from product where title = 'This title has a ' in it.'; Select * from product where title = 'This title has a \' in it.'; Select * from product where title = 'This title has a ''' in it.'; Select * from product where title = 'This title has a '' in it.'; TIA for any help, Cal http://www.calevans.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: Pb with mysql client display
[EMAIL PROTECTED] wrote: On Thu, Aug 16, 2001 at 10:38:46PM -0400, Xavier Leoncini wrote: I have the following problem: When displaying a select * query from a table I get the following: (just showing the end). | | | 2928 | 1611100 | | | | 2929 | 1251300 | +--++--+--+--+ The last column is empty, which is normal but the first isn't. In fact when performy a query on the first column select item I get the following. item UV UV UV UV This is an innodb table of about 200.000.000 million rows. Raw bcp is about 6 G. Thanks for any help. Looks like you inserted characters like \m in your database. Control caracters. The 'UV'`s are there but you cannot see them because the last column data has scrmbled your display. The shifted |`s hint to that. Good luck. Thanks, it was indeed a problem inherited from the lend of lines differneces between Unix and windows, and the last column was not really empty. Dankje wel Xavier - 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 Spawns Many Processes and Uses 100% CPU! PART #1
On Fri, Aug 17, 2001 at 06:54:59PM -0400, Ryan Shrout wrote: This message is broken into two parts because the MySQL list blocked it as being too big!!! Okay, here is the problem: everyone once in a while, say once or twice a day, my web server running RH 7.2, PHP 4.0.6 and MySQL, will seem to freeze (from a web users point of view). Upon SSH'ing into the server, and running top I see the system load averages in the 90s (!!!) and all I see for processes on the list is mysqld. The CPU usage is at 100%, and the top mysqld process ususally is taking 14% or so, then 12% then a lot of 10%, and on down until it goes off the list. Below, I have included a copy of the top status during one of the afore mentioned problem times: Your system has a fair amount of memory. Can we see the output of SHOW PROCESSLIST, SHOW STATUS, and maybe SHOW VARIABLES when this happens? You might want to try out mytop http://public.yahoo.com/~jzawodn/mytop/ to get an idea of what MySQL is doing at various times. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 0 days, processed 10,728,969 queries (174/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: MySQL Spawns Many Processes and Uses 100% CPU! PART #1
It may be that MySQL is simply spawning too many processes for your machine to handle. I might be wrong, but here's something to try: 1. Set MySQL max_connections to 45. 2. Set httpd MaxClients to 50. That will limit the number of processes MySQL is allowed to start, and also makes sure that Apache will delay web requests such that it won't try to service a request when MySQL is at the maximum number of processes. This may keep your machine from spinning out of control. However, there might be a bug somewhere that's making MySQL take up more system resources than it should, and my solution does not address that possibility. Maybe someone else has an idea about this. - 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 DBI connect
I am having a problem with MySQL. I am seeking some advice on either what is wrong
or how to pursue the cause of this bug.
I am using Perl DBI to interface with MySQL and when i execute the
following statement:
$dbh = DBI-connect('DBI:mysql:database=dbmysql2', undef, undef,
{PrintError =0}) || die $ DBI::errstr;
it causes the error:
[Fri Aug 17 09:59:50 2001] productioncontent14.pl: Access denied for user:
'@localhost'
to database 'dbmysql2' at productioncontent14.pl line 29, STDIN line 1
the dbi connect is being invoked by a perl program which is run from the
command line.
when i execute the above DBI-connect statement with my MySQL userid and
password it works fine.
i have MySQL (not unix) root level privileges. for performance and
security reasons i prefer to execute the version of the connect which is
failing.
i am running MySQL as described below:
Server version 3.23.36
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
i am running Perl 5.6 and Red Hat 7.1 Linux 2.4.3-12
i checked that i have access to mysql.sock
in addition to a my local host with my user name which is fully
privileged, i currently show local host with no user name and no password
in the mysql user table and with no privileges. i tried, as mysql root, to
grant all privileges to localhost, which has no user name, via the sql command:
grant all privileges on * to %@localhost;
this resulted in a user table entry of no host name, a user name of
%@localhost and no privileges. this didn't seem useful so i deleted the
new user name, %localhost from all of the mysql security tables.
Re: Quick REGEXP problem
On Fri, Aug 17, 2001 at 03:46:11PM +0100, Lee Denny wrote: Hello, Can any one tell me why $sql=SELECT * FROM table WHERE pcsort REGEXP '^.$parts[0].[0-9]'; (pcscot being a CHAR(10), $parts[0] being a single alpha charcater.) works OK in 3.23 but not in 3.22. I'm trying to find UK postcodes such as e17 but not ee17. It was probably a bug fixed along the way... -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 0 days, processed 11,210,313 queries (177/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: Single Quotes in a Select Statement
On Fri, 17 Aug 2001, Cal Evans wrote:
Select * from product where title = 'This title has a \' in it.';
This query does not work. Can anyone tell me how to build a query that will
return that title?
Are you sure you're not overlooking something? I just tried the following
commands and had no problems with the single quote...
mysql create temporary table product (title varchar(80));
Query OK, 0 rows affected (0.01 sec)
mysql insert into product values ('This title has a \' in it.');
Query OK, 1 row affected (0.00 sec)
mysql select * from product;
+---+
| title |
+---+
| This title has a ' in it. |
+---+
1 row in set (0.00 sec)
smysql select * from product where title='This title has a \' in it.';
+---+
| title |
+---+
| This title has a ' in it. |
+---+
1 row in set (0.00 sec)
-
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: aggressive dolphin?
At 3:00 PM +0200 8/16/01, Theo Richel wrote: I am a very dedicated user of Mysql, but I am somewhat disappointed that you chose the dolphin for your logo because of the good nature of this animal. In the New York Times (1999) I read: But scientists, following a trail of bloody clues, are discovering that dolphins are far from the happy, peaceful creatures that humans think they know. Are you from NuSphere? (perhaps this is how they feel about Flipper at this point) -- 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
mysql dbi connect
I am having a problem with MySQL. I am seeking some advice on either what is wrong
or how to pursue the cause of this bug.
I am using Perl DBI to interface with MySQL and when i execute the
following statement:
$dbh = DBI-connect('DBI:mysql:database=dbmysql2', undef, undef,
{PrintError =0}) || die $ DBI::errstr;
it causes the error:
[Fri Aug 17 09:59:50 2001] productioncontent14.pl: Access denied for user:
'@localhost'
to database 'dbmysql2' at productioncontent14.pl line 29, line 1
the dbi connect is being invoked by a perl program which is run from the
command line.
when i execute the above DBI-connect statement with my MySQL userid and
password it works fine.
i have MySQL (not unix) root level privileges. for performance and
security reasons i prefer to execute the version of the connect which is
failing.
i am running MySQL as described below:
Server version 3.23.36
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
i am running Perl 5.6 and Red Hat 7.1 Linux 2.4.3-12
i checked that i have access to mysql.sock
in addition to a my local host with my user name which is fully
privileged, i currently show local host with no user name and no password
in the mysql user table and with no privileges. i tried, as mysql root, to
grant all privileges to localhost, which has no user name, via the sql command:
grant all privileges on * to %@localhost;
this resulted in a user table entry of no host name, a user name of
%@localhost and no privileges. this didn't seem useful so i deleted the
new user name, %localhost from all of the mysql security tables.
PHP/MYSQL Consultation
I am in need of consultation services concerning my PHP scripts and MYSQL database. if you are interested please email me at [EMAIL PROTECTED] or [EMAIL PROTECTED] with credentials and how much you charge, and whatever else I may need to know. Here is my problem. I have a web server and a database server and I don't see any difference in performance from when everything was on one server. Thanks RJ --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.268 / Virus Database: 140 - Release Date: 8/7/2001 - 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
MS Excel to MySQL upload macro?
I have data I create daily in MS Excel. I need to insert this data into MySQL data base on my web server every night. Does anyone here have a VB technique to upload to MySQL from Excel via a macro? Thanks Craig [EMAIL PROTECTED]
Re: MySQL Spawns Many Processes and Uses 100% CPU! PART #1
Jeremy, it was included in PART #2 of the problem message. Did you get that? Ryan Shrout Owner - Amdmb.com http://www.amdmb.com/ [EMAIL PROTECTED] - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Ryan Shrout [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, August 17, 2001 8:28 PM Subject: Re: MySQL Spawns Many Processes and Uses 100% CPU! PART #1 On Fri, Aug 17, 2001 at 06:54:59PM -0400, Ryan Shrout wrote: This message is broken into two parts because the MySQL list blocked it as being too big!!! Okay, here is the problem: everyone once in a while, say once or twice a day, my web server running RH 7.2, PHP 4.0.6 and MySQL, will seem to freeze (from a web users point of view). Upon SSH'ing into the server, and running top I see the system load averages in the 90s (!!!) and all I see for processes on the list is mysqld. The CPU usage is at 100%, and the top mysqld process ususally is taking 14% or so, then 12% then a lot of 10%, and on down until it goes off the list. Below, I have included a copy of the top status during one of the afore mentioned problem times: Your system has a fair amount of memory. Can we see the output of SHOW PROCESSLIST, SHOW STATUS, and maybe SHOW VARIABLES when this happens? You might want to try out mytop http://public.yahoo.com/~jzawodn/mytop/ to get an idea of what MySQL is doing at various times. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 0 days, processed 10,728,969 queries (174/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
Nesting Problem for Multilevel Marketing
Hi Everyone, I have a few questions based on a scenario that was posed to me, and I have no idea how to go about it... For example, a multi-level / multilevel marketing project has the following Membertable with 2 fields for a generated Account Number the first field is Member's Unique Account Number (Column A) and the second field is Referrer's Account Number (Column B)... So if I join the multilevel program, I will have to provide my recruiter's Account Number which will be placed in Column B and I will be given my new Account Number which will be placed in Column A. The problems would be: how do I generate a Member's Report, which will show the five members above me, and the five LEVELS of numerous members which join below me.
parameters?
I'm a newbie to MySql / Php and heres what i'm trying to accomplish: I have a set of hard coded links that each have a sql parameter value like below: a href=http://www.foo.com/agent_result.php3?$agent_id=9805;My Link Text/a I'm trying to pass that parameter into a query on another page and have it display the results based on the variable. ?php $db = mysql_connect(localhost, user,password); mysql_select_db(db_name); $result = mysql_query(SELECT * FROM agentdb WHERE '$agent_id' = agent_id); php? Then the data gets displayed: img src=http://www.foo.com/agentpics/?php printf(mysql_result($result,0,first_name)); ?_?php printf(mysql_result($result,0,last_name)); ?.jpg width=89 height=92 vspace=5 hspace=5 I'm still thinking in an access box, i'm sure...can somebody give me a push in the right direction? TIA, Chris - 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
Can you go back and forth between PHP and MySQL for a nesting procedure?
I noticed that most if not all the mysql_fetch_object, and mysql_fetch_array
and mysql_fetch_row all have print in the while brackets...
what I want to do is to assign the result to a $variable first WITHOUT
printing the result, and reassigning the $variable into a second query,
before printing... how should this be done the right way, because I've been
getting parse errors.
Here's what I want to do:
$FirstQuery = select * from table where field = condition
then with PHP
$variable = while ( )
{ statement about the first query becomes a long string
}
After this, I want to go back to MySQL
$SecondQuery = select * from table where field = $variable
How can I do this without nesting, but assigning a $variable instead to
place in the second query?
What's an alternative solution to this?
