Re: Java Related Sites for MySQL
Same Here! Bryan! Do let me know if you find one. - Original Message - From: Aravind N V Gorthy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 11, 2002 12:59 PM Subject: Java Related Sites for MySQL Hi Are there any JAVA based Forum sites which are using MySQL as the backend. I am new to MySQL and I am using JAVA. I want to know whether there are any sites which provide discussion forum,articles and tutorials on Java + MySQL..Just like weberdev.com,which provides discussion forums on PHP+MySQL. Thanks in advance Bryan. __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Heads up re Spam.
At 07:16 2002-01-11, Michael T. Babcock wrote: On Thu, Jan 10, 2002 at 08:55:35PM +0100, Marjolein Katsma wrote: That proves it's a REAL problem for subscribers to this list. No, it proves that some subscribers (like yourself) have real problems. Your E-mails will all be blacklisted at my border if I see you whining about this on-list again; So? whine to the administrators _in private_. This is a matter that concerns all members of this list. If I am in a minority, fine. But even a minority should have a voice. The fact that people are actually *leaving* this list because of the continuing spam should give the administrators (and you ) a clue. Wouldn't they rather lose the spammers than valuable list members? If you raise the noise ratio from .5% to 2.5% by whining so much, who is really the problem? The list management - because they do not limit posting to subscribers only. Your logic skills are extremely lacking. The list administration did not require you to post your whining to the list. I don't want to hear what you have to say about spam; I ignore the spam as, obviously, do the hundreds of other subscribers not whining on the list. My logic skills are fine. The list administrators are forcing me to pay for downloading the spam they let through. They should not. I don't mind paying for member's posts, I do mind paying for spam. As long as spam is allowed here, this will keep coming up. Ignoring spam is not a solution - we *all* pay for it because of the huge costs involved with the bandwidth it takes up. PS, I post to a lot of lists I'm not a member of. So do I. The ones that _require_ membership for me to post lose my traffic as well as my use of their software. The ones that do not require membership to post *all* suffer from spam. Hence I much prefer posting by members only. database,sql,query,table -- Marjolein Katsma HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Java Related Sites for MySQL
Hello all, www.infinitehost.com Kind regards Emmanuel Same Here! Bryan! Do let me know if you find one. - Original Message - From: Aravind N V Gorthy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 11, 2002 12:59 PM Subject: Java Related Sites for MySQL Hi Are there any JAVA based Forum sites which are using MySQL as the backend. I am new to MySQL and I am using JAVA. I want to know whether there are any sites which provide discussion forum,articles and tutorials on Java + MySQL..Just like weberdev.com,which provides discussion forums on PHP+MySQL. Thanks in advance Bryan. __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 - This message was sent using World Mail. http://www.worldonline.co.za - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Spam
Thursday, January 10, 2002, 8:43:04 PM, you wrote: Maybe the list mom/dad doesn't care where you go. Maybe MySQL provides this list for free and doesn't care what you think. If you don't like it, get off the boat. A free list, which puts people in direct contact with the developers, is a plus to me. So what if I get a spam mail from it every now and then. I think the list mom/dad does a good job, considering the figurative mom/dad is a machine. I hate to even make any comments on this because of the amount of resources used to send this one email which has been generated by one SPAM email. In my opinion, people should ignore the spam instead of sending 15 emails back to the list about it. Imagine the bandwidth that would be saved by MySQL. ...and imagine the bandwith saved by everyone if the list admin restricted posting to members only. It probably won't take more than 30 seconds, tops. Spending those 30 secodns, MySQL saves bandwith in three respects; 1. They don't let their list members be spammed. 2. The members that actually don't like spam won't get it from here. I am pretty sure that those who DO like spam can get it elsewhere without any major difficulties. 3. Members who think complaining about spam is spam and waste of bandwith don't have to complain (spam(?)) about it on the list. - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -- Pål Sollie - [EMAIL PROTECTED] Change is good most of the time, but it is bad when it sucks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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-15.5
Tip: try the myvars module (for example: moodss myvars --host myhost), and optimize your server configuration very efficiently, by simply comparing each variable value with its corresponding documentation (only a mouse move away thanks to the balloon help on the variable name). Take a similar approach for dynamic values by also loading the mystatus module. ### CHANGES ### --- version 15.5 --- completely redesigned MySQL myvars and mystatus modules: - added support for 4.x servers - removed support for 3.22.x servers - only display variables returned by the server during the modules initialization phase in order to reduce the risk of internal errors due to the many different servers configurations in the field - dynamic help (through widget tips (balloons)) is now drawn directly from the MySQL documentation for greater accuracy - displayed variable names are now strictly those returned by the corresponding 'SHOW VARIABLES' and 'SHOW STATUS' queries - in mystatus module, added separate table for queries counters - successfully tested with 3.23.47 and 4.0.1 servers in sensors module, forgot to close pipe in local host case in sensors module, added support for values with no limits, such as vid viewers and thresholds with cells pointing to a non existing module would fail (could happen if a module was unloaded prior to saving to a file and then opening that same file) moomps daemon: - added --pid-file option for saving process ID in a file at startup - could crash when loading old configuration files with viewers other than summary tables - added rpm specification file to tarball so that rpms can be rebuilt directly - in rpm, try to add moomps user even when upgrading, not only installing - in rpm, eventually stop moomps daemon when uninstalling or upgrading - in rpm, use process ID file for daemon management module development: column labels no longer need new lines (except for forced formatting) as widget tips (balloons) now wrap lines automatically fixed potential bug when loading a module with a new view from an older save file ### README ### This is moodss (Modular Object Oriented Dynamic SpreadSheet) version 15.5. 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. Moomps (shipped with moodss) is a monitoring daemon which works using configuration files created by moodss. Thresholds, when crossed, create messages in the system log, and eventually trigger the sending of email alert messages. 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, ODBC, 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, arp, cpustats, diskstats, interrupts, kernmods, memstats, minimal, mounts, netdev, pci, ps, random, route, sensors, system modules for Linux, MySQL (myprocs, myquery, mystatus, myvars), odbcquery, ping, snmp, snmptrap for UNIX, apache and apachex, Minimal and Random Perl modules, minipy and randpy Python 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
How do I search and Replace Values
Hi there, I wonder if anyone can help? How would I go through a whole table changing the values: StuartD to stuartd thanks a mil, Stuart Otway. MoveAssist International Ltd Ickleford Manor Turnpike Lane Ickleford, Hitchin Herts SG5 3XE United Kingdom Tel: ++44 1462 452186 Fax: ++44 1462 455164 Email Disclaimer The information in this email is intended only for the addressee named above. Access to the email by anyone else is unauthorised. As this email may contain confidential or privileged information, if you are not the intended recipient any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How do I search and Replace Values
Friday, January 11, 2002, 12:26:00 PM, you wrote: Hi there, I wonder if anyone can help? How would I go through a whole table changing the values: StuartD to stuartd UPDATE users SET username = 'stuartd' WHERE username = 'StuartD'; -- Pål Sollie - [EMAIL PROTECTED] Change is good most of the time, but it is bad when it sucks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Date Field + Time Field = Datetime Field?
Alex, Further to Anvar's suggestions: - in addition to time_to_sec() recommend you look at sec_to_time() - which saves the repeated division to produce 'elapsed time' - alternatively take a look at unix_timestamp() and from_unixtime() which would allow the recording of all times to the second/as seconds, and convert to time/date presentation formats as required - regardless, unless you want large values expressed as hours (even beyond 24 hours) all elapsed time calculations must be divided by 86400 so that the integral part can be passed into a 'date' function, and the remainder into a 'time' function Times/dates can be stored ready for calculation or ready for display - it is always easier to convert a calculated field for display, than to perform arithmetic on a formatted-for-display field! Regards, =dn - Original Message - From: Anvar Hussain K.M. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 11 January 2002 04:05 Subject: Re: Date Field + Time Field = Datetime Field? Hi Alex, I don't think your problem will solved by making the time columns to full datetime columns as there is no functions to subtract two datetime values directly. But you can can keep the time columns and go on like this: convert the time into seconds using time_to_sec function. subtract fromtime from totime. this will yield the difference in seconds now you can take the elapsed time in hours,minutes or seconds. The sql might be something like: Select (time_to_sec(totime) - time_to_sec(fromtime)) / 60 / 60 as hours from table. Section 7.4.11 of the manual explains date and time functions. Anvar At 06:00 PM 10/01/2002 +, you wrote: I've been working with a timesheet database, where all the employees of my small business enter in the hours they work on projects. I've been storing, for each record, a date of work, a start time, and a finish time. When I attempted to write a Perl script to display invoices, though, I ran into the issue that subtracting one time from another yields inconsistent results. Thus, I'm going to convert to datetime fields, which would store just the start and finish times as datetime. I'd like to automate the switchover, so I don't have to go through and maually update. I thought at first that UPDATE time_worked SET dtstart = concat(datework, start); would work, but that gave me a syntax error. I can't seem to find anything in the manual that would help, either. Is there any way to do this without going through and manually updating? I'd really appreciate any hints you could give. FYI, I'm running MySQL 3.23.37. Thanks, Alex Kirk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Test Case (Urgent)
Hi, I am new to test case design in Database. I wants to know Basically how to calculate the Maximum Database. When we have to take backup.? What are steps to be flow please tell me. Thanks in advance. Manish Mehta E-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MyCC WinNT 4.0 SP6a
Hello. I have tried using the latest MyCC on Windows NT 4.0 (SP 6a) Server to connect to a MySQL database on a FreeBSD box. Everything's fine until I connect :-6 Upon connection I get a message that 'The instruction at 0x10006bf5 referenced memory at 0x0014. The memory could not be read.' It's rather sad, because I liked the MyCC Interface (( Kind regards, Konstantin V Semenov aka JHVHS [EMAIL PROTECTED] PromAvtoContract plc. http://www.promavto.ru - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 + php on 7.2
HI guys! I am having a problem with Redhat 7.2. After installation mysql does not talk to php on the apache server. Any time i try to access a page I get a warning message which says path is not included in php.ini. I have not done any modification to the php.ini file. Any help? NB: phpinfo() displays all the neccessary information. Thanks ___ Join the Space Program: Get FREE E-mail at http://www.space.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Installation of mySQL on a Win2000 Pro machine
Thanks for the info Heikki, but life has not got any better. I have bought the mySQL book (Paul DuBois) and I am still baffled. Maybe I am having a blonde week (I am blonde). From the screen shots I have seen of myCC it looks similar to SQL Server. That is what I am looking for. My understanding is that you download mysql-max-3.23.47-win.zip unzip and install. The run the cmd prompt and enter in C:\mysql\bin mysqld-max --standalone and you should get a dos print out. I get an error saying that the cmd is not recognized. What now? I what to design and administer mySQL server through myCC, is this possible? Please somebody help Frustrated - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Installation of mySQL on a Win2000 Pro machine
At 11:57 11/01/02 +, Andrew Aragi wrote: Hi! Thanks for the info Heikki, but life has not got any better. I have bought the mySQL book (Paul DuBois) and I am still baffled. Maybe I am having a blonde week (I am blonde). From the screen shots I have seen of myCC it looks similar to SQL Server. That is what I am looking for. My understanding is that you download mysql-max-3.23.47-win.zip unzip and install. The run the cmd prompt and enter in C:\mysql\bin mysqld-max --standalone and you should get a dos print out. I get an error saying that the cmd is not recognized. What now? Because the path you had typed it isn't correct. The error message is from the Operational System. Are you using a software for to rename the boot hard drive ? Regards, Miguel I what to design and administer mySQL server through myCC, is this possible? Please somebody help Frustrated - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
setup 1 user to connect from 2 hosts.
What is the correct way of having 1 user connect from only 2 hosts to the same database? Since user,host, and db fields are all primary keys in the all of the user, host, db tables. I can't enter a user twice with diffrent hosts as I had planned on doing it. I'd prefer to explicitly state the two hosts, they are on seperate networks so it would be tough to wildcard group them together. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Installation of mySQL on a Win2000 Pro machine
Hi Miguel. I am not using any software to rename the boot HD. Concerning the path C:\mysql\bin mysqld-max --standalone this is out of the pdf manual. What would be the correct path then? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: setup 1 user to connect from 2 hosts.
it seems not possible. however, you may solve with a little trick in Linux systems... For example: If you have a Linux Machine with MySQL. and the computers which will connect to the database has IP numbers 212.45.64.20 and 212.45.64.21 Then, allow user to connect from 212.45.64.??? and deny the port number of MySQL Server from all IP numbers, except 212.45.64.20, and 212.45.64.21 then, You have 1 user, which can connect from two IP numbers (in fact too many IP's in the same class BUT ..) then increase SEUCRITY ofyour FIREWALL about MySQL PORT. best regards... ---Original Message--- From: Jeff Bearer Date: 11 Ocak 2002 Cuma 15:04:52 To: [EMAIL PROTECTED] Subject: setup 1 user to connect from 2 hosts. What is the correct way of having 1 user connect from only 2 hosts tothe same database? Since user,host, and db fields are all primary keysin the all of the user, host, db tables. I can't enter a user twice withdiffrent hosts as I had planned on doing it. I'd prefer to explicitlystate the two hosts, they are on seperate networks so it would be toughto wildcard group them together.-Before posting, please check:http://www.mysql.com/manual.php (the manual)http://lists.mysql.com/ (the list archive)To request this thread, e-mail lt;[EMAIL PROTECTED]To unsubscribe, e-mail lt;[EMAIL PROTECTED]Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php. IncrediMail - Email has finally evolved - Click Here
Re: user / pwd access to db driven website
One step at a time. Your first problem is user authentication? A few options: 1. Directory access (as you mentioned in your message) The user must be authenticated to run the scripts / view the web pages 2. DBMS built-in security Not supported (properly) by MS-Access but can easily be setup with mysql, postgresql, sybase, etc Get username and password via web-form, open connection to database. Main problem with this is that user needs to authenticate on each database request. To avoid this need to store session state (username and password and use cookies) or maintain open connection (perhaps via mod-perl or asp). 3. Create a users table within the database, storing username = password digest pairs (and perhaps last logon, current session id, etc). All users connect to DB under same dummy DBMS account (ignore this for Access). User supplies username and password on web login page. User's credentials are checked against 'users' table and on sucess a unique session cookie is sent back to the browser. In this way the user remains authenticated for the lifetime of the cookie. Looks like you'll have to use method 3 (based on your previous message). Investor wrote: HI all, I would be extremely appreciative with solution suggestions to the problem I am having. I really could use some help right now !! I am trying to get a database driven website up and running that has some amount of security on it (which i intend to make progresively better). It needs user/pwd access to a database of info, after a subscription fee is paid. Currently I am having trouble setting up the basic structure. By the way this is a starup company, and only 5- 10 subscriptions would fund much better software / hardware / server for the site. So my goal is to set up something inexpensive to get those 5 or so subscriptions. Attempt No. 1: I setup a test site ( virtual hosting I think it is called) that utilizes perl ms access. It works oK except I didn't get the user/pwd thing working. It has pwd protected directories - however they told me queries will not work with the pwd protected directory insalled. Technical support is very slow in responding. And I didn't figure out how to provide the needed security mentioned above. Currently I have been reading about mysql and just installed it on windows 98. I am open to changing over to linux based systems. However I would like to create the tempory site to get a few subsciptions prior to forking out the funds. So finally now that you guys know my situation can you please make some suggestions as to how to get the temporary site up ( to get 5 subscriptions or so) and I think I coudl painfully, over time, work on a site that could handle much more. Information: The database would be text only, less than 1 GB ! Right now I think it is at 5 MB but will increase. I am familar with perl 5.6 and ms access. Budget: Shoe string budget for now. :) I would greatly appreciate assistance I am sure many of you dealt with this type of situation before. = Regards, Investorclb __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ ___ Perl-Win32-Users mailing list [EMAIL PROTECTED] http://listserv.ActiveState.com/mailman/listinfo/perl-win32-users - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: setup 1 user to connect from 2 hosts.
One more thing... Are you sure that user/host and db fields are primary keys such that they does not accept double/triple entrance? My User Table is something like this. Host User = localhost root localhost sait localhost wtc-admin some_host testuser and DB table is Host Db User == % test % test\_% localhost phphelpdesk phphdadmin localhost phphelpdesk helpdesk So it seems that, you can INPUT multiple HOSTs, multiple, USERs and multiple DBs... Have a nice day... ---Original Message--- From: Jeff Bearer Date: 11 Ocak 2002 Cuma 15:04:52 To: [EMAIL PROTECTED] Subject: setup 1 user to connect from 2 hosts. What is the correct way of having 1 user connect from only 2 hosts tothe same database? Since user,host, and db fields are all primary keysin the all of the user, host, db tables. I can't enter a user twice withdiffrent hosts as I had planned on doing it. I'd prefer to explicitlystate the two hosts, they are on seperate networks so it would be toughto wildcard group them together.-Before posting, please check:http://www.mysql.com/manual.php (the manual)http://lists.mysql.com/ (the list archive)To request this thread, e-mail lt;[EMAIL PROTECTED]To unsubscribe, e-mail lt;[EMAIL PROTECTED]Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php. IncrediMail - Email has finally evolved - Click Here
Re: Installation of mySQL on a Win2000 Pro machine
At 12:40 11/01/02 +, Andrew Aragi wrote: Hi, Hi Miguel. I am not using any software to rename the boot HD. Concerning the path C:\mysql\bin mysqld-max --standalone this is out of the pdf manual. What would be the correct path then? If you had installed with the default path: c:\mysql\bin\mysqld-max --standalone or if you are into the c:\mysql\bin directory: c:\mysql\binmysqld-max --standalone Regards, Miguel Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- 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: setup 1 user to connect from 2 hosts.
you are correct, my assumption was wrong, you can add the same user to the user table twice, I'm assuming as long as the host-user combination is unique. On Fri, 2002-01-11 at 07:50, Sait Karalar wrote: One more thing... Are you sure that user/host and db fields are primary keys such that they does not accept double/triple entrance? My User Table is something like this. HostUser = localhostroot localhostsait localhostwtc-admin some_hosttestuser and DB table is HostDbUser == %test %test\_% localhost phphelpdesk phphdadmin localhost phphelpdesk helpdesk So it seems that, you can INPUT multiple HOSTs, multiple, USERs and multiple DBs... Have a nice day... ---Original Message--- From: Jeff Bearer Date: 11 Ocak 2002 Cuma 15:04:52 To: [EMAIL PROTECTED] Subject: setup 1 user to connect from 2 hosts. What is the correct way of having 1 user connect from only 2 hosts to the same database? Since user,host, and db fields are all primary keys in the all of the user, host, db tables. I can't enter a user twice with diffrent hosts as I had planned on doing it. I'd prefer to explicitly state the two hosts, they are on seperate networks so it would be tough to wildcard group them together. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail lt;[EMAIL PROTECTED] To unsubscribe, e-mail lt;mysql-unsubscribe-sait=marketweb.net.tr@lists mysql.com Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php . -- Jeff Bearer, RHCE Webmaster PittsburghLIVE.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: Multi-table delete/update
Becky McElroy writes: Thank you for your response and the info. Actually I was using 4.0.1 which I downloaded a couple of days ago: [beckymcelroy@indigo bhm]$ rpm -qa | grep SQL MySQL-Max-4.0.1-2 MySQL-client-4.0.1-2 MySQL-4.0.1-2 [beckymcelroy@indigo bhm]$ [skip] -- Becky McElroy Thank you for your report. This is indeed a bug and since last night I am working on finding the propert fix for it. -- 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: Curious result: Indexing numbers vs. strings
Dr. Frank Ullrich wrote: Steve, what did explain tell you in either case? Good question Dr. Ullrich. mysql explain select rec_no,phone_no from White where phone_no=0636941; +---+--+---+--+-+--+--++ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+--+---+--+-+--+--++ | White | ALL | phone_no | NULL |NULL | NULL | 22160316 | where used | +---+--+---+--+-+--+--++ 1 row in set (0.01 sec) mysql explain select rec_no,phone_no from White where phone_no='0636941'; +---+--+---+--+-+---+--++ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+--+---+--+-+---+--++ | White | ref | phone_no | phone_no | 8 | const |1 | where used | +---+--+---+--+-+---+--++ 1 row in set (0.00 sec) So it's unable to use phone_no as a key, and therefore does a full scan. And then apparently proceeds to scan each row, converting phone_no to an integer to compare to the constant. Seems naive to me, since the datatype of the field is known, why not convert the constant instead? Then everything would work at least as well, and always faster. -steve -- Steve Rapaport World Citizen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Installation of mySQL on a Win2000 Pro machine
Hi Miguel.. still in the dark. I installed mySQL into the c:\mysql directory. So pardon my ignorance but what is the difference between besides the symbol? What does the do. When I use the latter it say that this cmd is not recognized. c:\mysql\bin\mysqld-max --standalone c:\mysql\binmysqld-max --standalone Andrew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Path Variables
What operating system are you using? The path vars etc are found in your mysqld_safe or safe_mysqld script, at least in *NIX systems -Original Message- From: Roman Eisner [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 10, 2002 6:06 PM To: [EMAIL PROTECTED] Subject: Path Variables Hello, I'm trying to change the path variables of an already installed mysql server. Namely, I want to change: pid_file language innodb_log_group_home_dir datadir basedir I viewed these, using the mysqladmin variables command. I'm using 4.0, and I'd like to know the easiest way to change each of these variables, because I'm moving the server to a different directory. Thanks, -Roman - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Installation of mySQL on a Win2000 Pro machine
- Original Message - From: Andrew Aragi [EMAIL PROTECTED] Sent: Friday, January 11, 2002 8:30 AM Subject: Re: Installation of mySQL on a Win2000 Pro machine So pardon my ignorance but what is the difference between besides the symbol? What does the do. When I use the latter it say that this cmd is not recognized. c:\mysql\bin\mysqld-max --standalone c:\mysql\binmysqld-max --standalone The '' character is a traditional DOS/Windows prompt symbol. In documentation such as the above, it would mean the current working directory is c:\mysql\bin, the command executed is mysqld-max, and the argument to the command is --standalone. Ryan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SV: Installation of mySQL on a Win2000 Pro machine
Hi The that you see in the command prompt is only for decoration you can easy change the look on you command prompt to show you something else. The proper way to start your program is: c:\mysql\bin\mysqld-max --standalone not the otherway. Regards Jonas Arvidsson PS. The look and apperance can be changed by issuing prompt=$p$g to something else. -Ursprungligt meddelande- Från: Andrew Aragi [mailto:[EMAIL PROTECTED]] Skickat: den 11 januari 2002 14:30 Till: [EMAIL PROTECTED] Ämne: Re: Installation of mySQL on a Win2000 Pro machine Hi Miguel.. still in the dark. I installed mySQL into the c:\mysql directory. So pardon my ignorance but what is the difference between besides the symbol? What does the do. When I use the latter it say that this cmd is not recognized. c:\mysql\bin\mysqld-max --standalone c:\mysql\binmysqld-max --standalone Andrew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
a very newbie question but very important for me
Sir, I have install Mysql 3.23.41 in my redhat 7.2. For some reason the logic partition of /var is so small, now I want to change the mysql's default directory to another bigger partition. How can I do that? Of course, I do not want to uninstall and reinstall mysql if there is another better solution. Thanks, pine tan _ Do You Yahoo!? µÇ¼Ãâ·ÑÑÅ»¢µçÓÊ! http://mail.yahoo.com.cn font color=#FFÎÞÁÄ£¿ÓôÃÆ£¿¸ßÐË£¿Ã»ÀíÓÉ£¿¶¼À´ÁÄÌì°É£¡/font¡ª¡ª ÑÅ»¢È«ÐÂÁÄÌìÊÒ! http://cn.chat.yahoo.com/c/roomlist.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
MySQL dies
Hi, I'm in desperate need of help. MySQL keeps dying and I just can't figure out why... Here goes: Clients connect from Windows machines via VB and Delphi apps through myodbc doing queries on databases with *big* tables containing over 1.6 million records Often they're losing connection because mysql dies, queries have to be done again. Error log says that mysqld restarted, i.e. safe_mysqld immediately restarts the server. Only mysql is running on the machine. Queries may look like this: CREATE TEMPORARY TABLE tmpTable(FRM varchar(5),ARKL varchar(5),KNR varchar(10),ZWT float(11,5),VPN float(11,5),GRS varchar(32),MNG float(11,5),BRW float(11,5), NTW float(11,5)); INSERT INTO tmpTable(FRM,ARKL,KNR,ZWT,VPN,GRS,MNG,BRW, NTW)SELECT left(MNR,5),right(MNR,5),KNR,ZWT/MNG,VPN,substring_index(GRS,'X',1)* right(substring_index(GRS,'X',2),length(substring_index(GRS,'X',2))-length(s ubstring_index(GRS,'X',1))-1)* right(GRS,length(GRS)-length(substring_index(GRS,'X',2))-1)/1000,MNG,BRW,NTW FROM MASTER WHERE (BLDAT = 20010901 AND BLT = 20011231 AND SRT = '04' AND SRT = '06') MASTER is one *big* table containing 1.6 Million records... Info on the system: netbsd 1.5.2, 512 mb RAM mysql --version mysql Ver 11.13 Distrib 3.23.35, for -netbsd (i386) mysqladmin variables: +-+- --+ | Variable_name | Value | +-+- --+ | ansi_mode | OFF | | back_log| 50 | | basedir | /usr/pkg/ | | binlog_cache_size | 32768 | | character_set | latin1 | | character_sets | latin1 dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 | | concurrent_insert | ON | | connect_timeout | 10 | | datadir | /usr/var/mysql/ | | delay_key_write | ON | | delayed_insert_limit| 100 | | delayed_insert_timeout | 300 | | delayed_queue_size | 1000 | | flush | OFF | | flush_time | 0 | | have_bdb| NO | | have_gemini | NO | | have_innobase | NO | | have_isam | YES | | have_raid | NO | | have_ssl| NO | | init_file | | | interactive_timeout | 28800 | | join_buffer_size| 131072 | | key_buffer_size | 16773120 | | language| /usr/pkg/share/mysql/english/ | | large_files_support | ON | | locked_in_memory| OFF | | log | ON | | log_update | OFF | | log_bin | OFF | | log_slave_updates | OFF | | long_query_time | 10 | | low_priority_updates| OFF | | lower_case_table_names | 0 | | max_allowed_packet | 1047552 | | max_binlog_cache_size | 4294967295 | | max_binlog_size | 1073741824 | | max_connections | 100 | | max_connect_errors | 10 | | max_delayed_threads | 20 | | max_heap_table_size | 16777216 | | max_join_size | 4294967295 | | max_sort_length | 1024 | | max_user_connections| 0 | | max_tmp_tables | 32 | | max_write_lock_count| 4294967295 | | myisam_recover_options | OFF | | myisam_sort_buffer_size | 8388608 | | net_buffer_length | 7168 | | net_read_timeout| 120 | | net_retry_count | 40 | | net_write_timeout | 240 | | open_files_limit| 0 | | pid_file| /usr/var/mysql/unixtest.pid | | port| 3306 | | protocol_version| 10 | | record_buffer | 131072 | | query_buffer_size | 1044480 | | safe_show_database | OFF | | server_id | 1 | | skip_locking| ON | | skip_networking | OFF | | skip_show_database | OFF | | slow_launch_time| 2 | | socket | /tmp/mysql.sock | | sort_buffer | 524280 | | table_cache | 64 | | table_type | MYISAM | | thread_cache_size | 0 | | thread_stack| 65536 | | timezone| CET | | tmp_table_size | 1048576 | | tmpdir | /var/tmp/ | | version | 3.23.35-log | | wait_timeout| 115200 | +-+- --+ | core dumps available... (they're BIG -21M) Help is very much appreciated... Marc - Before posting, please check:
RE: MySQL dies
You might want to increase your max_connections using : -O max_connections=1000 as an option in mysqld_safe. See http://www.mysql.com/doc/S/e/Server_parameters.html for more information. -Original Message- From: Müller, Markus [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 8:00 AM To: '[EMAIL PROTECTED]' Subject: MySQL dies Hi, I'm in desperate need of help. MySQL keeps dying and I just can't figure out why... Here goes: Clients connect from Windows machines via VB and Delphi apps through myodbc doing queries on databases with *big* tables containing over 1.6 million records Often they're losing connection because mysql dies, queries have to be done again. Error log says that mysqld restarted, i.e. safe_mysqld immediately restarts the server. Only mysql is running on the machine. Queries may look like this: CREATE TEMPORARY TABLE tmpTable(FRM varchar(5),ARKL varchar(5),KNR varchar(10),ZWT float(11,5),VPN float(11,5),GRS varchar(32),MNG float(11,5),BRW float(11,5), NTW float(11,5)); INSERT INTO tmpTable(FRM,ARKL,KNR,ZWT,VPN,GRS,MNG,BRW, NTW)SELECT left(MNR,5),right(MNR,5),KNR,ZWT/MNG,VPN,substring_index(GRS,'X',1)* right(substring_index(GRS,'X',2),length(substring_index(GRS,'X',2))-length(s ubstring_index(GRS,'X',1))-1)* right(GRS,length(GRS)-length(substring_index(GRS,'X',2))-1)/1000,MNG,BRW,NTW FROM MASTER WHERE (BLDAT = 20010901 AND BLT = 20011231 AND SRT = '04' AND SRT = '06') MASTER is one *big* table containing 1.6 Million records... Info on the system: netbsd 1.5.2, 512 mb RAM mysql --version mysql Ver 11.13 Distrib 3.23.35, for -netbsd (i386) mysqladmin variables: +-+- --+ | Variable_name | Value | +-+- --+ | ansi_mode | OFF | | back_log| 50 | | basedir | /usr/pkg/ | | binlog_cache_size | 32768 | | character_set | latin1 | | character_sets | latin1 dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 | | concurrent_insert | ON | | connect_timeout | 10 | | datadir | /usr/var/mysql/ | | delay_key_write | ON | | delayed_insert_limit| 100 | | delayed_insert_timeout | 300 | | delayed_queue_size | 1000 | | flush | OFF | | flush_time | 0 | | have_bdb| NO | | have_gemini | NO | | have_innobase | NO | | have_isam | YES | | have_raid | NO | | have_ssl| NO | | init_file | | | interactive_timeout | 28800 | | join_buffer_size| 131072 | | key_buffer_size | 16773120 | | language| /usr/pkg/share/mysql/english/ | | large_files_support | ON | | locked_in_memory| OFF | | log | ON | | log_update | OFF | | log_bin | OFF | | log_slave_updates | OFF | | long_query_time | 10 | | low_priority_updates| OFF | | lower_case_table_names | 0 | | max_allowed_packet | 1047552 | | max_binlog_cache_size | 4294967295 | | max_binlog_size | 1073741824 | | max_connections | 100 | | max_connect_errors | 10 | | max_delayed_threads | 20 | | max_heap_table_size | 16777216 | | max_join_size | 4294967295 | | max_sort_length | 1024 | | max_user_connections| 0 | | max_tmp_tables | 32 | | max_write_lock_count| 4294967295 | | myisam_recover_options | OFF | | myisam_sort_buffer_size | 8388608 | | net_buffer_length | 7168 | | net_read_timeout| 120 | | net_retry_count | 40 | | net_write_timeout | 240 | | open_files_limit| 0 | | pid_file| /usr/var/mysql/unixtest.pid | | port| 3306 | | protocol_version| 10 | | record_buffer | 131072 | | query_buffer_size | 1044480 | | safe_show_database | OFF | | server_id | 1 | | skip_locking| ON | | skip_networking | OFF | | skip_show_database | OFF | | slow_launch_time| 2 | | socket | /tmp/mysql.sock | | sort_buffer | 524280 | | table_cache | 64 | | table_type | MYISAM | | thread_cache_size | 0 | | thread_stack| 65536 | | timezone| CET | | tmp_table_size | 1048576 | | tmpdir | /var/tmp/ | | version | 3.23.35-log | | wait_timeout| 115200 |
RE: Curious result: Indexing numbers vs. strings
Anvar Hussain K.M. writes: Hi, Since the equality test is for a number, the phone_no field of every row of the table is converted into a number first and tested for the equality. This makes it impossible to use the character index and so forces the full table scan. If it were using the index then, I think, it cannot find the intended records . This is because if it were the case, the number 0636941 which is in fact 636941 should be first conveted to string '636941' and the query executed and that is not the logical one to do. Anvar. Good answer ! -- 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
Coldfusion?
Quick Newbie question: Can I use MySQL with Coldfusion server? If yes, are there any limitations or provisos I should know about? Thanks as always Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Coldfusion?
Quick Newbie question: Can I use MySQL with Coldfusion server? If yes, are there any limitations or provisos I should know about? Thanks as always Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: a very newbie question but very important for me
Dnia(at) pi? 11. stycze¨½ 2002 14:56, willinger netcactus napisa?(said): | Sir, | |I have install Mysql 3.23.41 in my redhat 7.2. For | some reason the logic partition of /var is so small, | now I want to change the mysql's default directory to | another bigger partition. How can I do that? | |Of course, I do not want to uninstall and reinstall | mysql if there is another better solution. | | Thanks, |pine tan | | _ | Do You Yahoo!? µÇ¼Ãâ·ÑÑÅ»¢µçÓÊ! http://mail.yahoo.com.cn | | font color=#FFÎÞÁÄ£¿ÓôÃÆ£¿¸ßÐË£¿Ã»ÀíÓÉ£¿¶¼À´ÁÄÌì°É£¡/font¡ª¡ª | ÑÅ»¢È«ÐÂÁÄÌìÊÒ! http://cn.chat.yahoo.com/c/roomlist.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 I do thing like this. Move all directory to the new partition and make a link form the new partition/mysql to /var/lib/mysql. Of course restart mysql demon. zakend -- Znudzilo Ci sie logo w komorce? Wgraj nowe [ http://komorki.onet.pl/dodatki.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: Curious result: Indexing numbers vs. strings
* Steve Rapaport Regarding integer/string conversions: select rec_no,phone_no from White where phone_no=0636941; versus select rec_no,phone_no from White where phone_no='0636941'; Seems naive to me, since the datatype of the field is known, why not convert the constant instead? Then everything would work at least as well, and always faster. ...except it would probably by converted to '636941', not '0636941'... -- Roger database, table, sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL admin with no password
Trond Eivind Glomsrød writes: Is there a clean way to administrate mysqld without a password by root? I'm looking for ways to make it flush logs, reload my.cnf and shut down cleanly, in an automated way - i.e, no password, but by root. (similar to pg_ctl for postgresql or `kill -HUP` for reloading) (e.g. shut down the server on system shutdown, and make log rotation and -- Trond Eivind Glomsrød Red Hat, Inc. kill -HUP will flush everything. -TERM, -QUIT and -INT will shutdown a server. -- 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: Mysql password problem
Are you sure the password for root is christ1 ? Did you try it without the -p ? Kory Wheatley wrote: I have MYSQL installed on a hpux 11.0 unix system I installed the binary and everything started up correctly using /opt/mysql/bin/safe_mysqld but when I try to connect as an user /opt/mysql/bin/mysql -u root -pchrist1 It will not work . Even if I do the following command I get an error /opt/myql/bin/mysqladmin version I receive this error on everything I do error: 'Access denied for user: ' root@localhost:' (Using password =yes) Does any have a solution? -- # Kory Wheatley Academic Computing Analyst Sr. Phone 282-3874 # Everything must point to him. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Compare remote local database
Use the buil-in replication. On the slave machine, insert a record in the database on the master. Then check for that record in the slave database. Jochen Kaechelin wrote: Is there a tool - a php script would be prefered - to compare a local and a remote database for synchronisation? Our aim is to have to identical databases all the time! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Coldfusion?, Database, SQL, etc!
Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Robert, Bjorn et all Thanks for your advice and support - great to know that folks are using it in this way and getting good results. I'm looking forward to getting stuck into this, and appreciate knowing there is an active community out there too. Cheers Mark P.S. By the way, this is the 5th attempt to send this message, I'm getting auto replies from the server telling me that my reply appears to be spam or off-topic. It seems the server filter is very strict as it's rejected a number of my attempts to send today! I've changed the subject as advised by the server responses. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: DATES Optimization
Thanks, Paul. ;) ~rob -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 8:22 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: DATES Optimization At 9:02 -0600 1/9/02, Robert L. Yelvington wrote: Two quick qux for the gurus on the list! 1. If I needed to do date calculations based upon a TIME STAMP field, what's the most efficient way to accomplish this with respect to data types (field types...I already understand how to use the DATE functions and am aware of locale time and UNIX time trappings)? For example, someone signs up on a mailing list via mysql data base, and then I want to know how many people have signed up in Jan, 2001 or March, 1999 or Jan, 2002? OR, another Jan, 2001: SELECT COUNT(*) FROM tbl_name WERE MONTH(t) = 1 AND YEAR(t) = 2001; Others are similar. example, someone signs up and I want to calculate 4 ninety day cycles with a reminder sixty days from sign up, so that if I signed up on Jan 1, 2002 then on Mar 1, 2002, I'd like to send notification that their account needs maintenance by April 1, 2002...kinda like a billing system. Use DATE_ADD(). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Coldfusion?
ColdFusion server on Unix/Linux platform, then yes. The ColdFusion server for Linux/Unix comes complete with the MySQL drivers necessary. I have successfully created CF-MySQL pages without any problem. When I have installed ColdFusion on Windows platforms, it has NOT come with the MySQL drivers. I'm not sure if there's a place to get MySQL drivers for ColdFusion? I haven't tried. The My-ODBC drivers might work. I don't know. Bryan Capitano MSL wrote: Quick Newbie question: Can I use MySQL with Coldfusion server? If yes, are there any limitations or provisos I should know about? Thanks as always Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- CAPITANO WEb CONSULTING http://www.capitanoweb.com Bryan R. Capitano cell (541)760.6288 home (541)929.5060 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Input Needed: Replication issues...
On Thursday 10 January 2002 17:22, Matthew Walker wrote: Where I work, we're at the point of needing to maintain two database servers, one inhouse, and the other at another physical location. We need to replicate between the servers, to keep them both up to date, as both will be getting updated. This leaves us with the problem of resolving primary key conflicts if the servers should ever lose touch with eachother for a while. We're looking at InnoDB, and wondering if it would be able to resolve those sorts of issues using transactions. Input please? We looked closely at native MySQL replication, but after a few questions about the handling of auto increment fields (we use them like row IDs all over the place), we decided that MySQL's replication was broken for our application. We have more than one live database and they replicate to each other. We write our own replication system using our own checkpointing and code. We start with the update logs (we're not happy about the future removal of the update logs because of this). I've looked through the MySQL source to see if I can figure out enough of the format of the binary log to see if I can make some Perl code that will parse it. It is really easy to use the update log since all SQL end with a semicolon as the last character on a line. Since Perl tends to be line-oriented, it is easy to find this. Here's what we do: - we run a special server process on each database. This replicator server will spool update log files on demand. - on each machine, we run a special client process. This process connects to the replicator server (not MySQL's), gets the update log information and puts it into the local database. If necessary, we can rewrite any SQL (we don't). The server process puts a special checkpoint comment between each SQL statement. The checkpoint comments has a special header and trailer so that we can recognize it. It contains the name of the file that is currently being spooled and the byte offset in that file. This information is stored on the client side in a special checkpoint file. If the client process needs to be restarted or the network drops or something causes replication to quit, it will restart where it left off based on the checkpoint file. This functionality is basically identical to the native MySQL replication. The reasons for using the update log and not native MySQL replication are these: - we can have more that two servers coupled together. - we use auto increment fields all over. With native mySQL replication, these fields are filled in with values on the source side. Thus, we get collisions on the target side. We have no need for the row IDs to match on each machine as every row has another unique ID field. We do need the row IDs for purging old data and other things that do not rely on the unique ID field. - we can do SQL rewriting if we really need to. These problems led us to write our own replication. If you have the luxury of redesigning your database or of designing with MySQL's native replication in mind (we did not), then I would use the native version. Best, Kyle - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Heads up re Spam.
While I don't like the idea of limiting messages to subscribers (I hate signing up for things, especially when I'm only going to post a few messages), I think it's still very important. Like any other problem, ignoring it will only send a message of passive acceptance and the amount of spam WILL increase. Don't fool yourselves into thinking that it will go away. Complaining that it's taking too long and too many messages to discuss a problem is frankly a selfish and self-denying point. You're the ones who want to ignore the spam, but at some point the amount of spam will be as numerous as the messages you're complaining about now. Consider this a glimpse at the future if we ignore the problem. I don't believe spam will ever go away since some people are just determined to get it through to everyone they can. However, we CAN eliminate a lot of it because the majority of spammers are lazy. So consider these two options: 1) The list gets restricted to member-posting only or at least something to the effect of PHP's mailing list where your first initial post must be verified to go through, and all subsequent posts are fine. As I said before, since the majority of spammers are lazy, I don't believe many will take the time to verify and send it out again... but you never know. In any case, the list gets restricted and the amount of spam drops, as do these types of arguments. I don't think people are going to raise hell over an occasional spam. Once spamming programs find a way around the verification/subscription programs, there will have to be additional improvements on them to continue to deny those spamming programs. But the bottom line is that spam will drop. 2) The list stays the same. There will inevitably be more discussions like this after a series of spammings, which will take up bandwidth, magnetize your credit cards, and sour your milk. It'll be annoying because we'll all be getting the spams and the protests against it. You'll get annoyed just because of the protesters, but there's really nothing you can do about them. The way I see it, we should go to option #1, as much as I hate subscribing. It just makes the most sense. - Jonathan -Original Message- From: Marjolein Katsma [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 12:30 AM To: Michael T. Babcock [EMAIL PROTECTED] [RegSoft/mysql]; MySQL Subject: Re: Heads up re Spam. At 07:16 2002-01-11, Michael T. Babcock wrote: On Thu, Jan 10, 2002 at 08:55:35PM +0100, Marjolein Katsma wrote: That proves it's a REAL problem for subscribers to this list. No, it proves that some subscribers (like yourself) have real problems. Your E-mails will all be blacklisted at my border if I see you whining about this on-list again; So? whine to the administrators _in private_. This is a matter that concerns all members of this list. If I am in a minority, fine. But even a minority should have a voice. The fact that people are actually *leaving* this list because of the continuing spam should give the administrators (and you ) a clue. Wouldn't they rather lose the spammers than valuable list members? If you raise the noise ratio from .5% to 2.5% by whining so much, who is really the problem? The list management - because they do not limit posting to subscribers only. Your logic skills are extremely lacking. The list administration did not require you to post your whining to the list. I don't want to hear what you have to say about spam; I ignore the spam as, obviously, do the hundreds of other subscribers not whining on the list. My logic skills are fine. The list administrators are forcing me to pay for downloading the spam they let through. They should not. I don't mind paying for member's posts, I do mind paying for spam. As long as spam is allowed here, this will keep coming up. Ignoring spam is not a solution - we *all* pay for it because of the huge costs involved with the bandwidth it takes up. PS, I post to a lot of lists I'm not a member of. So do I. The ones that _require_ membership for me to post lose my traffic as well as my use of their software. The ones that do not require membership to post *all* suffer from spam. Hence I much prefer posting by members only. database,sql,query,table -- Marjolein Katsma HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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/
RE: Coldfusion?
I currently use MySQL along with CF v5 on a Win2k box. After installing MySQL, install the myODBC drivers (also available at MySQL.com), setup your DSN on your win box, then attach them in CF and you are ready to rock. While my install is still new (a few months), I could not be happier after moving from MSSQL. stephen -Original Message- From: MSL [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 09:16 To: MySQL Subject: Coldfusion? Quick Newbie question: Can I use MySQL with Coldfusion server? If yes, are there any limitations or provisos I should know about? Thanks as always Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with MySQL and SMP?
Any suggestions on loging tools I cna run to try to find out more information? The machine is coloced about 3 hours for me, so I would hate to have to drive there and install FreeBSD on it, when it was just something I could have fixed. Gavin Blestan Tabakov wrote: hi! i'm running mysql on a dual pIII for 3 years now and i have no problems . the machine is running slackware 2.2.16 and mysql 3.23.47. so, i think that you have to check the motherboard of the server or even change it ( some bioses crashes linux on smp). the other problem may be is redhat it self - but i'm not sure - i'm always use slack - it' absolutely stable good luck blestan __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Coldfusion? Database, MySQL
database,sql,query,table Hi Stephen Good to hear your very postive notes on Win2K/Coldfusion/MySQL. I'm just setting up, and wondering about some notes in the MySQL documentation: In the following circumstances you will need to use the MySQL configuration file: 1.The install/data directories are different than the default `c:\mysql' and `c:\mysql\data'. 2. If you want to use one of the these servers: mysqld.exe mysqld-max.exe mysqld-max-nt.exe 3. If you need to tune the server settings. There are two configuration files with the same function: `my.cnf' and `my.ini' file, however please note that only of one these should can used. Both les are plain text. The `my.cnf' file should be created in the root directory of drive C and the `my.ini' file on the WinDir directory e.g: `C:\WINDOWS' or `C:\WINNT'. If your PC uses a boot loader where the C drive isn't the boot drive, then your only option is to use the `my.ini' file. Also note that if you use the WinMySQLAdmin tool, only the `my.ini' file is used. The `\mysql\bin' directory contains a help file with instructions for using this tool. Using notepad.exe, create the configuration file and edit the base section and keys: [mysqld] basedir=the_install_path #e.g. c:/mysql datadir=the_data_path #e.g. c:/mysql/data or d:/mydata/data If the data directory is other than the default `c:\mysql\data', you must cut the whole `\data\mysql' directory and paste it on the your option new directory, e.g.: `d:\mydata\mysql'. If you want to use the InnoDB transactional tables, you need to manually create two new directories to hold the InnoDB data and log les, e.g. `c:\ibdata' and `c:\iblogs'. You will also need to add some extra lines to the configuration file. If you don't want to use InnoDB tables, add the skip-innodb option to the configuration file. Now you are ready to test starting the server. I have the MySQL database installed under directory drive letter 'E:\MySQL' , the 'E:\' directory being what I use for all my software, and I use my 'D:\' directory for all data. This would seem to suggest that I fall under number 1. of the above circumstances. However, I am finding the following notes (as copied above) from the documentation less than clear. Can you advise or clarify what the correct process is in this case? Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Bug (?) in mysqld start?
Hey, I would file a bug via mysql_bug but for my fear of emacs, so i am going to attempt to provide as much info here in the hope you don't request a ./mysql_bug report. :) I am trying to install mysql on a client's box, it's latest stable version (mysql-3.23.47), and installed to /usr/local/mysql. However, when i try and start the safe_mysqld daemon, as suggested, i get the following: [root@ns mysql]# bin/safe_mysqld [2] 12268 [root@ns mysql]# Starting mysqld daemon with databases from /var/lib/mysql 020110 20:00:07 mysqld ended [2]- Donesafe_mysqld /var/lib/mysql doesn't exist. Finally, when trying to use the scripts/mysql_install_db script, it creates the relevant directories, yet fails to create the relevant table files. I feel that it is to do with the above, but i'm not sure. I don't know what has happened in the past, except to note that there were mysql binaries and data scattered all over the file system. Any help would be appreciated in discerning what the problem is! Regards, and thanks, James Cox database,sql,query,table -- James Cox :: [EMAIL PROTECTED] Please CC me when replying to my messages on lists. PS: stolen from the mysql bug template: Release: mysql-3.23.47 (Official MySQL binary) Environment: machine, os, target, libraries (multiple lines) System: Linux ns.lanceproductions.com 2.4.2-2 #1 Sun Apr 8 19:37:14 EDT 2001 i586 unknown Architecture: i586 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.1 2.96-81) Compilation info: CC='gcc' CFLAGS='-O3 -mpentium ' CXX='gcc' CXXFLAGS='-O3 -mpentium -felide-constructors' LDFLAGS='-static' LIBC: lrwxrwxrwx1 root root 13 May 27 2001 /lib/libc.so.6 - libc-2.2.2.so -rwxr-xr-x2 root root 5578134 Apr 6 2001 /lib/libc-2.2.2.so -rw-r--r--1 root root 26350254 Apr 6 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 6 2001 /usr/lib/libc.so lrwxrwxrwx1 root root 10 May 27 2001 /usr/lib/libc-client.a - c-client.a Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --wi\ th-server-suffix= --enable-thread-safe-client --enable-assembler --with-mysq ld-ldflags=-all-static --with-client-ldflags=-all-stati\ c --disable-shared - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
More Coldfusion
Hi, I just read the message that Mark posted concerning ColdFusion. It would be much appreciated if Stephen S Zappardo could email me concerning his installation of mySQL on Win2k box as I have been having endless problems doing it. I am going to be doing developing in Coldfusion and wanting to use mySQL instead of MSSQL. Once again this would be much appreciated Stephan. Andrew [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: Problem with MySQL and SMP?
We are having the same problem. Mandrake 8.1, kernel 2.4.17, MySQL 3.23.47. Dual PIII-500, 512MB of RAM, Mylex DAC960 RAID 5. After being up for a few days, the system completely froze. No ssh, no console, nothing. Had to hard reset the server. Yes, we compiled MySQL: we have to. Our application relies on SELECT id ... WHERE id IS NULL behaving the same way as LAST_INSERT_ID(), and to do that, I have to comment out one (yes, just one) line of code. Which means I have to compile. Anyway, this is sort of a longish me too, but I wanted to confirm that Gavin was not alone in this problem. j- k- On Thursday 10 January 2002 21:11, [EMAIL PROTECTED] wrote: I am having a problem with MySQL that I believe is related to SMP. I have a machine that is an exact copy of another machine, only difference is that this one is Dual processor, and the other one is single. The single one has had no problems for the last 6 months the dual dies every 2 days This is the 2nd SMP server that I have had (i thought it was the mobo or something) both produce the same results. I get no output to logs, machine just goes black (and hangs). Any input? This is on RedHat 7.2 linux with the 2.4.17 kernel and MySQL 3.23.47 Gavin -- Joshua Kugler, Information Services Director Associated Students of the University of Alaska Fairbanks [EMAIL PROTECTED], 907-474-7601 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Database Size Limit
Hello everyone, I guess I have the similar question, that has been brought up. I have 36 InnoDB tables, and I have allocated two 2GB partitions for my data. Provided I have very big hard drive, how many partitions at 2GB each could I allocate? As many as my hard drive can handle? I also have questions with regards, to a table size. In my case it will be (4GB)/36 bytes per table? Is it distributed uniformly, or some tables can grow bigger on the expense of the others (if some only have limited data, and others keep having new data inserted into them). Sincerely, Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 email: [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: Problem with MySQL and SMP?
Could be the 2.4.17 kernel.. I run a Dual RH 7.1 machine: mysql status; -- --snip-- Uptime: 57 days 11 hours 57 min 28 sec #uptime 11:36am up 57 days, 13:28, 1 user, load average: 0.00, 0.00, 0.00 #uname -a Linux [hidden] 2.4.8 #3 SMP Tue Aug 14 09:47:47 CDT 2001 i686 unknown --- In a message from Heikki Tuuri [EMAIL PROTECTED] The kernel 2.4.4-SMP-64GB has been very stable on our 2-way computer. Somewhere in about version 2.4.10 Linus changed the virtual memory. I am not sure how stable kernels 2.4.10 - .17 are, but at least some people are running them with success. That could be the problem. Down grade to 2.4.9 or .8, patch up the security holes, if any in that kernel, and give that a test run. - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -Original Message- From: Joshua J.Kugler [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 11:26 AM To: MySQL Subject: Re: Problem with MySQL and SMP? We are having the same problem. Mandrake 8.1, kernel 2.4.17, MySQL 3.23.47. Dual PIII-500, 512MB of RAM, Mylex DAC960 RAID 5. After being up for a few days, the system completely froze. No ssh, no console, nothing. Had to hard reset the server. Yes, we compiled MySQL: we have to. Our application relies on SELECT id ... WHERE id IS NULL behaving the same way as LAST_INSERT_ID(), and to do that, I have to comment out one (yes, just one) line of code. Which means I have to compile. Anyway, this is sort of a longish me too, but I wanted to confirm that Gavin was not alone in this problem. j- k- On Thursday 10 January 2002 21:11, [EMAIL PROTECTED] wrote: I am having a problem with MySQL that I believe is related to SMP. I have a machine that is an exact copy of another machine, only difference is that this one is Dual processor, and the other one is single. The single one has had no problems for the last 6 months the dual dies every 2 days This is the 2nd SMP server that I have had (i thought it was the mobo or something) both produce the same results. I get no output to logs, machine just goes black (and hangs). Any input? This is on RedHat 7.2 linux with the 2.4.17 kernel and MySQL 3.23.47 Gavin -- Joshua Kugler, Information Services Director Associated Students of the University of Alaska Fairbanks [EMAIL PROTECTED], 907-474-7601 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with MySQL and SMP?
i don't have any problem with this config : slackware 7.1, kernel 2.2.18, MySQL 3.23.41 Dual PIII-800, 256MB RAM, SCSI Ultra-160 maybe it's kernel 2.4 fault. HTH (sorry for the duplicated message Joshua, forgot to send to the ML) At 18:26 11/01/2002, you wrote: We are having the same problem. Mandrake 8.1, kernel 2.4.17, MySQL 3.23.47. Dual PIII-500, 512MB of RAM, Mylex DAC960 RAID 5. After being up for a few days, the system completely froze. No ssh, no console, nothing. Had to hard reset the server. Yes, we compiled MySQL: we have to. Our application relies on SELECT id ... WHERE id IS NULL behaving the same way as LAST_INSERT_ID(), and to do that, I have to comment out one (yes, just one) line of code. Which means I have to compile. Anyway, this is sort of a longish me too, but I wanted to confirm that Gavin was not alone in this problem. j- k- On Thursday 10 January 2002 21:11, [EMAIL PROTECTED] wrote: I am having a problem with MySQL that I believe is related to SMP. I have a machine that is an exact copy of another machine, only difference is that this one is Dual processor, and the other one is single. The single one has had no problems for the last 6 months the dual dies every 2 days This is the 2nd SMP server that I have had (i thought it was the mobo or something) both produce the same results. I get no output to logs, machine just goes black (and hangs). Any input? This is on RedHat 7.2 linux with the 2.4.17 kernel and MySQL 3.23.47 Gavin -- Joshua Kugler, Information Services Director Associated Students of the University of Alaska Fairbanks [EMAIL PROTECTED], 907-474-7601 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- .thibaut allender ~ dev:network. @ magic:sq. .tel. : +32 2 / 209 83 71 ~ http://magicsquare.be - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with MySQL and SMP?
Joshua J.Kugler writes: We are having the same problem. Mandrake 8.1, kernel 2.4.17, MySQL 3.23.47. Dual PIII-500, 512MB of RAM, Mylex DAC960 RAID 5. After being up for a few days, the system completely froze. No ssh, no console, nothing. Had to hard reset the server. Yes, we compiled MySQL: we have to. Our application relies on SELECT id ... WHERE id IS NULL behaving the same way as LAST_INSERT_ID(), and to do that, I have to comment out one (yes, just one) line of code. Which means I have to compile. Anyway, this is sort of a longish me too, but I wanted to confirm that Gavin was not alone in this problem. -- Joshua Kugler, Information Services Director Associated Students of the University of Alaska Fairbanks [EMAIL PROTECTED], 907-474-7601 If nothing works as you said, no ssh, no console, this is not MySQL issue. It is either hardware or some unknown (?) 2.4.17 SMP bug. -- 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: Problem with MySQL and SMP?
Forgot to say I was running MySQL v 3.23.39 Also, I read in one of the other messages on this thread that the problem might be RedHat. I don't relly belive this because a kernel is a kernel. RedHat = Every other Distro when it comes to issues with the kernel (memory,diskaccess,etc). In my opinion, I have been wrong before. - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -Original Message- From: Johnny Withers [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 11:40 AM To: 'MySQL' Subject: RE: Problem with MySQL and SMP? Could be the 2.4.17 kernel.. I run a Dual RH 7.1 machine: mysql status; -- --snip-- Uptime: 57 days 11 hours 57 min 28 sec #uptime 11:36am up 57 days, 13:28, 1 user, load average: 0.00, 0.00, 0.00 #uname -a Linux [hidden] 2.4.8 #3 SMP Tue Aug 14 09:47:47 CDT 2001 i686 unknown --- In a message from Heikki Tuuri [EMAIL PROTECTED] The kernel 2.4.4-SMP-64GB has been very stable on our 2-way computer. Somewhere in about version 2.4.10 Linus changed the virtual memory. I am not sure how stable kernels 2.4.10 - .17 are, but at least some people are running them with success. That could be the problem. Down grade to 2.4.9 or .8, patch up the security holes, if any in that kernel, and give that a test run. - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -Original Message- From: Joshua J.Kugler [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 11:26 AM To: MySQL Subject: Re: Problem with MySQL and SMP? We are having the same problem. Mandrake 8.1, kernel 2.4.17, MySQL 3.23.47. Dual PIII-500, 512MB of RAM, Mylex DAC960 RAID 5. After being up for a few days, the system completely froze. No ssh, no console, nothing. Had to hard reset the server. Yes, we compiled MySQL: we have to. Our application relies on SELECT id ... WHERE id IS NULL behaving the same way as LAST_INSERT_ID(), and to do that, I have to comment out one (yes, just one) line of code. Which means I have to compile. Anyway, this is sort of a longish me too, but I wanted to confirm that Gavin was not alone in this problem. j- k- On Thursday 10 January 2002 21:11, [EMAIL PROTECTED] wrote: I am having a problem with MySQL that I believe is related to SMP. I have a machine that is an exact copy of another machine, only difference is that this one is Dual processor, and the other one is single. The single one has had no problems for the last 6 months the dual dies every 2 days This is the 2nd SMP server that I have had (i thought it was the mobo or something) both produce the same results. I get no output to logs, machine just goes black (and hangs). Any input? This is on RedHat 7.2 linux with the 2.4.17 kernel and MySQL 3.23.47 Gavin -- Joshua Kugler, Information Services Director Associated Students of the University of Alaska Fairbanks [EMAIL PROTECTED], 907-474-7601 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with MySQL and SMP?
Yes, this had occured to me. I am thinking about downgrading to kernel 2.4.8, or such. Not sure I really want to do that, but I'd rather do that than face system lock ups. j- k- On Friday 11 January 2002 08:55, Sinisa Milivojevic wrote: If nothing works as you said, no ssh, no console, this is not MySQL issue. It is either hardware or some unknown (?) 2.4.17 SMP bug. On Friday 11 January 2002 08:43, Thibaut Allender wrote: i don't have any problem with this config : slackware 7.1, kernel 2.2.18, MySQL 3.23.41 Dual PIII-800, 256MB RAM, SCSI Ultra-160 maybe it's kernel 2.4 fault. -- Joshua Kugler, Information Services Director Associated Students of the University of Alaska Fairbanks [EMAIL PROTECTED], 907-474-7601 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Coldfusion?
Mark -- We've been running Cold Fusion with MySQL on the Solaris platform for almost two years now and have had such terrible problems with Cold Fusion errors that we have begun the process of migrating to PHP. Our average load has been about 30,000 .cfm pages (linked to MySQL backend) served per week, which I don't consider to be too heavy a load to expect the system to handle successfully. Unfortunately, our log files are riddled with fatal Cold Fusion errors and subsequent restarts. It got so bad that we had to institute a cron job to check for the happiness of the CF processes every 3 minutes and restart them if there was a problem. No amount of MySQL configuration tweaking, query optimization, Cold Fusion configuration tweaking, Cold Fusion query caching, or version upgrades of MySQL or Cold Fusion made much of a dent in the problem. I've heard from a number of other folks concerning similar experiences. Allaire pointed the finger at MySQL, which I've had no reason to believe is the problem. To back that assertion up, I can say that converting our most heavily used dynamic pages from CF to PHP has already had an *incredible* effect on the stability of the system, with no other MySQL changes. If you are thinking of running CF on Solaris, save yourself the headaches and use PHP instead. I can't speak to it's performance on Windows. My 2 cents, Andy Andy Ingham Systems Librarian Academic Affairs Library UNC-Chapel Hill 919-962-1288 [EMAIL PROTECTED] -Original message- Subject: Coldfusion? Date: Fri, 11 Jan 2002 14:16:23 - From: MSL [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Quick Newbie question: Can I use MySQL with Coldfusion server? If yes, are there any limitations or provisos I should know about? Thanks as always Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with MySQL and SMP?
I'm running ok on my Dual PII machine, if this helps anyone. Redhat 7.1, 2.4.2-SGI_XFS kernel, MySQL 3.23.43. [root@willyjr /root]# uptime 1:07pm up 95 days, 4:08, 1 user, load average: 0.08, 0.04, 0.01 [root@willyjr /root]# cat /etc/redhat-release Red Hat Linux release 7.1 (Seawolf) [root@willyjr /root]# uname -a Linux willyjr.noguska.com 2.4.2-SGI_XFS_1.0smp #1 SMP Fri Apr 27 19:07:34 CDT 2001 i686 unknown mysql status -- mysql Ver 11.15 Distrib 3.23.43, for pc-linux-gnu (i686) Connection id: 5774 Current database: Current user: root@localhost Current pager: stdout Using outfile: '' Server version: 3.23.43-log Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:latin1 Server characterset:latin1 UNIX socket:/tmp/mysql.sock Uptime: 9 days 50 min 33 sec Threads: 31 Questions: 103436 Slow queries: 0 Opens: 3449 Flush tables: 1 Open tables: 64 Queries per second avg: 0.133 -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Coldfusion?database,sql,query,table
database,sql,query,table Hi Andy Wow! Well, that's made me take a double take! Sorry to hear of your woes, as I know having to deal with that sort of thing (especially for so long!) is no joke. Seems strange that there are such diverging reports on coldfusion today, but your experience and tales from 3rd parties has to be seriously considered. Trouble is, I'm not too familiar with PHP and like everyone else, don't know where the time can be found to learn yet another format, etc! Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to spool a file to your server from mysql
Hello, I am new to mysql. I know, in Oracle, when you spool file, then spool off, this will create a file on your server. What is the equivalent command for Mysql. For example: sqlplus Spool C:\temp\table_names sqlplus select table_name from user_tables; sqlplus spool off; This will create a file on the server. Cindy Ryan Fox [EMAIL PROTECTED] 01/11 10:10 AM I'm running ok on my Dual PII machine, if this helps anyone. Redhat 7.1, 2.4.2-SGI_XFS kernel, MySQL 3.23.43. [root@willyjr /root]# uptime 1:07pm up 95 days, 4:08, 1 user, load average: 0.08, 0.04, 0.01 [root@willyjr /root]# cat /etc/redhat-release Red Hat Linux release 7.1 (Seawolf) [root@willyjr /root]# uname -a Linux willyjr.noguska.com 2.4.2-SGI_XFS_1.0smp #1 SMP Fri Apr 27 19:07:34 CDT 2001 i686 unknown mysql status -- mysql Ver 11.15 Distrib 3.23.43, for pc-linux-gnu (i686) Connection id: 5774 Current database: Current user: root@localhost Current pager: stdout Using outfile: '' Server version: 3.23.43-log Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:latin1 Server characterset:latin1 UNIX socket:/tmp/mysql.sock Uptime: 9 days 50 min 33 sec Threads: 31 Questions: 103436 Slow queries: 0 Opens: 3449 Flush tables: 1 Open tables: 64 Queries per second avg: 0.133 -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: How to spool a file to your server from mysql
Check out select into outfile. http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SEL ECT Ryan - Original Message - From: Cindy Yu [EMAIL PROTECTED] I am new to mysql. I know, in Oracle, when you spool file, then spool off, this will create a file on your server. What is the equivalent command for Mysql. For example: sqlplus Spool C:\temp\table_names sqlplus select table_name from user_tables; sqlplus spool off; This will create a file on the server. Cindy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Combine data from multiple tables
I have three tables, each with a single column, data. I'd like to form a query that will combine the table columns into a common result column. When I use the query: SELECT * from tab1, tab2, tab3 I get: +-++---+ | data| data | data | +-++---+ | VAL1| VAL2 | VAL3 | +-++---+ But what I want is: +-+ | data| +-+ | VAL1| | VAL2| | VAL3| +-+ Is this possible? BTW, I'm using MySQL 3.23.35 Thanks, Eric - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Debian / MySQL tcp/ip port problem
Hello, I've just recently discovered a problem that I'm having a bit of difficulty solving. I have a MySQL server running (3.23.47) on a Debian machine and everything seemed to be working fine until I tried to connect to the SQL through tcp/ip sockets. It works fine through Unix sockets, but when I connect with tcp/ip, I get the following error: ERROR 2003: Can't connect to MySQL server on 'myhostname' (111) Telnetting to 'myhostname 3306' results in: Trying 127.0.0.1... telnet: Unable to connect to remote host: Connection refused I ran 'mysqladmin variables' and found that the port variable was set to 0. I checked the my.cnf file and ensured that it was set to 3306 and then tried starting the mysql server with the '--port=3306' command line option. After checking the variables again, port was STILL set to 0 and I STILL can't connect through tcp/ip ports. Any help would be greatly appreciated! Thanks. -- Ryan [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
check for server start
hi all, in debian, the /etc/init.d/mysql script waits for the appearance of /var/run/mysqld/mysqld.pid to conclude that the server has started. since the red hat init script does not do that, my program's own installer has to. however we have had a report that waiting for the pidfile is not enough; that the server wasn't ready for connections even after the file appeared. is that possible, and how can we (in sh) better determine when the server is up and ready? thanks, aaron brick. /\ | Aaron Brick (415) 206 - 4685 | | [EMAIL PROTECTED] Room 3501C, SFGH | Programmer Analyst, Functional Genomics Core Sandler Center for Basic Research in Asthma Lung Biology Center, Department of Medicine San Francisco General Hospital University of California, San Francisco - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Database Size Limit
On Thu, 10 Jan 2002, Dan Nelson wrote: In the last episode (Jan 11), Manish Mehta said: As we know that MySql support maximum of 4 GB data per table. Actually, http://www.mysql.com/doc/T/a/Table_size.html says that only Mysql 3.22 had a 4gb table size. With 3.23, the real limit is how big a file your OS can handle. Yes and no. With 3.23, the MyISAM format will, by default, have a 4GB limit (32 bits). You can set flags on the table to allow a 64-bit table, and you'll generally hit an OS or physical limitation long before you run out of space. The downside of the 64-bit version is it's considerably slower. Better to split large datasets up into sub-4GB units. james montebello - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Database Size Limit
Yes and no. With 3.23, the MyISAM format will, by default, have a 4GB limit (32 bits). You can set flags on the table to allow a 64-bit table, and you'll generally hit an OS or physical limitation long before you run out of space. The downside of the 64-bit version is it's considerably slower. Better to split large datasets up into sub-4GB units. why are operations on the 4GB tables slower? and, incidentally, where is that flag set? thanks, aaron brick. /\ | Aaron Brick (415) 206 - 4685 | | [EMAIL PROTECTED] Room 3501C, SFGH | Programmer Analyst, Functional Genomics Core Sandler Center for Basic Research in Asthma Lung Biology Center, Department of Medicine San Francisco General Hospital University of California, San Francisco - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
new bee - Mysql Database Update Problem
Hello, I am new to MYSQL platform: Sun Solaris 2.6 mysql version: 3.22.32 I upgrade the hard drive from 4G to 18G as database was increasing and causing problem now space problem is solved and got in to another problem. Database is not getting updated through C programs and perl scripts( that takes the raw data and update in database) which were working fine before the Hard drive upgrade. While C program is running looking at processlist I actually see data being inserted for a particular day in a particular table. After the program finishes I do a query for that particular day on a particular table I don't see any result. I get Empty Set. When I manually insert an entry and do query I do get result for that entry. I don't know what's going on has anyone ran in to this problem? Thanks __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: How to spool a file to your server from mysql
* Cindy Yu I am new to mysql. I know, in Oracle, when you spool file, then spool off, this will create a file on your server. What is the equivalent command for Mysql. For example: sqlplus Spool C:\temp\table_names sqlplus select table_name from user_tables; sqlplus spool off; This will create a file on the server. mysql have something similar, tee and notee: mysql use mysql Database changed mysql tee c:\trash\qwe.txt Logging to file 'c:\trash\qwe.txt' mysql show tables; +-+ | Tables_in_mysql | +-+ | columns_priv| | db | | host| | tables_priv | | user| +-+ 5 rows in set (0.02 sec) mysql notee Outfile disabled. mysql If the file exist, the output will be appended to the existing file. As you can see, the output is also displayed on the screen. This may not be what you want, especially if the output is big... You could use mysql -e select table_name from user_tables database output.txt or mysql database script.sql output.txt from the os command line. (You may also need to use -u, -p and/or -h, use the same as when you do a 'normal' start of the mysql client.) -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 for server start
a quick fix would be to see if the default port is open or not...something like: netstat -an | grep 3306 you could put that in a shell script and do all sorts of tests against it. -OR- you could use mysqladmin and whatever flag used to check status. hope this helps. ~rob -Original Message- From: Aaron Brick [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 1:01 PM To: [EMAIL PROTECTED] Subject: check for server start hi all, in debian, the /etc/init.d/mysql script waits for the appearance of /var/run/mysqld/mysqld.pid to conclude that the server has started. since the red hat init script does not do that, my program's own installer has to. however we have had a report that waiting for the pidfile is not enough; that the server wasn't ready for connections even after the file appeared. is that possible, and how can we (in sh) better determine when the server is up and ready? thanks, aaron brick. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Database Size Limit
This is speculation: They're slower because many operations have to be done using 64 bit values rather than 32 bit values. You set the flag by setting the max data size when creating the table. You can also alter this after the table is created with ALTER TABLE. The doc suggests you're setting the actual maximum size, but if you set the size to even 1 byte past 4GB (at least on Solaris), it immediately flips to a value way above 4GB, which is probably the Solaris limit (may be 2TB, I forget). Not sure what it does on Linux. We saw a significant performance decrease on Solaris when we tried to use max table sizes above 4GB, and assume it's because of an internal switch from 32-bit pointers to 64-bit pointers. May not make nearly as much of a performance difference on a real 64-bit processor and OS. james montebello On Fri, 11 Jan 2002, Aaron Brick wrote: Yes and no. With 3.23, the MyISAM format will, by default, have a 4GB limit (32 bits). You can set flags on the table to allow a 64-bit table, and you'll generally hit an OS or physical limitation long before you run out of space. The downside of the 64-bit version is it's considerably slower. Better to split large datasets up into sub-4GB units. why are operations on the 4GB tables slower? and, incidentally, where is that flag set? thanks, aaron brick. /\ | Aaron Brick (415) 206 - 4685 | | [EMAIL PROTECTED] Room 3501C, SFGH | Programmer Analyst, Functional Genomics Core Sandler Center for Basic Research in Asthma Lung Biology Center, Department of Medicine San Francisco General Hospital University of California, San Francisco - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Spam
ummm. you go ahead with that and noone will stay on the list. again, now with my stupid reply, there has been more posts about spam than actual spam. let's do the list a favor and put this thread to bed. jOda -Original Message- From: Patrick Crowley [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 10, 2002 11:16 AM To: Keith C. Ivey Cc: MySQL List Subject: Re: Spam I have to say I'm shocked that the list is completely open. That's such a stupid newbie thing to do. Maybe we should initiate a spam strike until the list mom/dad listens. Just subscribe the list to *another* list, and watch the fun begin... best, patrick crowley mokolabs making sure the future doesn't suck... w http://mokolabs.com e [EMAIL PROTECTED] p 646.591.5477 Why *isn't* posting to the MySQL list restricted to subscribers? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
with sql select statement from mysql ??
Below code does not print contents of the select sql statement to file ?? When I run a select on the table i get results in the dos shell. All the code below does is print column names and nothing more ?? code: open(file,C:/perl/bin/mysql.txt) or warn did not open file\n; undef $sql; $sql =select * from regs ; if ($db-Sql($sql)){ print SQL failed.\n; print Error: . $db-Error() . \n; $db-Close(); exit; } print file refcitereg notes \n; # start while loop at line below ## while($db-FetchRow()){ undef %Data; %Data = $db-DataHash(); @data = %Data; my $var1 = $Data{ref}; my $var2 = $Data{cite}; my $var3 = $Data{reg}; my $var4 = $Data{notes}; print file $Data{'ref'} $Data{'cite'} $Data{'reg'}$Data{'NOTES'}\n; # print file '$var1' $var2 $var3 $var4 \n; } # End of while loop close(file); $db-Close(); print file located at C:/perl/bin/mysql.txt ; = Regards, Investorclb = Regards, Investorclb __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Spam
A little higher barrier to entry, even for non-spam posts might not be a bad thing. The list is already pretty well spammed with questions that are either in the manual, or result from a lack of programming experience in general. Making it harder to post might make it a little easier to stay subscribed --- jds [EMAIL PROTECTED] wrote: ummm. you go ahead with that and noone will stay on the list. again, now with my stupid reply, there has been more posts about spam than actual spam. let's do the list a favor and put this thread to bed. jOda -Original Message- From: Patrick Crowley [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 10, 2002 11:16 AM To: Keith C. Ivey Cc: MySQL List Subject: Re: Spam I have to say I'm shocked that the list is completely open. That's such a stupid newbie thing to do. Maybe we should initiate a spam strike until the list mom/dad listens. Just subscribe the list to *another* list, and watch the fun begin... best, patrick crowley mokolabs making sure the future doesn't suck... w http://mokolabs.com e [EMAIL PROTECTED] p 646.591.5477 Why *isn't* posting to the MySQL list restricted to subscribers? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 compile problems on Solaris 8 'floor' undeclared
Solaris 8 GCC 3.03 Ok, first I got an error about iso/math_iso.h not being there so I commented it out of the math.h file. This got me past that error, now I get this error. gcc -O3 -DUNDEF_THREADS_HACK -I./../include -I../include -I./.. -I..-I..-O -DDBUG_OFF -felide-constructors -fno-exceptions -fno-rtti -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_CURSES_H -I/export/home/temp/mysql-3.23.47/include -DHAVE_RWLOCK_T -c mysql.cc mysql.cc: In function `void nice_time(double, char*, bool)': mysql.cc:2409: `floor' undeclared (first use this function) mysql.cc:2409: (Each undeclared identifier is reported only once for each function it appears in.) make[2]: *** [mysql.o] Error 1 make[2]: Leaving directory `/export/home/temp/mysql-3.23.47/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/export/home/temp/mysql-3.23.47' make: *** [all-recursive-am] Error 2 If anyone has any idea of how to fix this please let me know. Thanks, Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Coldfusion?
-Original Message- From: Andy Ingham [mailto:[EMAIL PROTECTED]] We've been running Cold Fusion with MySQL on the Solaris platform for almost two years now and have had such terrible problems with Cold Fusion errors that we have begun the process of migrating to PHP. Our average load has been about 30,000 .cfm pages (linked to MySQL backend) served per week, which I don't consider to be too heavy a load to expect the system to handle successfully. Unfortunately, our log files are riddled with fatal Cold Fusion errors and subsequent restarts. It got so bad that we had to institute a cron job to check for the happiness of the CF processes every 3 minutes and restart them if there was a problem. Oh boy... I'll confirm that as well. I previously worked at Macmillan Computer Publishing (www.mcp.com) when I wrote The Personal Bookshelf and migrated that application from cgi-bin/perl and dbm arrays to Cold Fusion/Oracle all on Solaris. It was CF version 4. And it was really bad. In a development environment where there is limited access, and the machine load is relatively low, it's no problem. Yet, the webstats were saying we had approximately 8,000 users using the Personal Bookshelf at any one time, so it was going to be put under a heavy load once it is in production. Such happened and CF really really choked. The machine suffered under a really high *load*. Typically above 90%. The sysadmins joked that the machine was working so hard it was glowing in the corner. We optimized the code over the course of a couple of weeks scruitinizing the CF markup for more efficient ways to do things in order to get it down to a load. We got the load down to between 60-70% as I remember, which was still too high. Not only was the machine at an unusually high load, but the CF server would die periodically between every 10-45minutes. The sysadmins eventually wrote a script to check the health of the CF server instance that'd run every 3 minutes to determine whether or not it should restart CF automtically. It was a really bad situation. We talked with Allaire and they couldn't believe the problems we had with CF on Solaris. At the time, Allaire said that we had the largest *nix based CF application on the www with a Sun Ultra with 4 GB of RAM tied to a pretty heavy amount of disk space, etc. We provided them with database schema's, data, and our code ... and let them try it out. They did. And they confirmed everything we had said...even in their environment. They said the design of the database and the coding of the pages didn't contribute to the poor performance of the CF engine. Ultimately, they said they couldn't help us because the thing in CF that was causing all of the problems (they said) was a simulated windows registry that CF requires in order to operate. They said that we were also suffering from a lot of errors where CF would loose database connections and not keep threads alive like they would in a non-*nix environment without a heavy load. They had no answers for us at all. They suggested that it be monitored constantly so that the application stays running as much as possible. When I heard about the simulated registry for *nix servers built into CF, I nearly hit the roof! I couldn't hardly believe it. That was a couple of years ago, and CF has went from 4 -- 4.5 -- 5. Under a windows environment, it's probably pretty good. Under *nix (Solaris in my experience) it really left much to be desired. I'd avoid it and stick with php on Solaris any day. Tyler Nally -- __ _Tyler Nally / /__ _(_)___ _ _ [EMAIL PROTECTED] / / _ \/ __ `/ / __ \/ __ \ / __ \/ ___/ __ `/ 317-860-3016 / / __/ /_/ / / /_/ / / / // /_/ / / / /_/ / American Legion Website /_/\___/\__, /_/\/_/ /_(_)/_/ \__, /http://www.legion.org // // - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Spam
i don't consider questions resulting from a lack of programming experience spam. the list SHOULD aid and embrace novice users. i know heikki and sinisa have both helped me with my basic questions, although i took some time to look in the archives and man before i posted. this IS the general list, after all. perhaps splitting it into three child lists: novice, intermediate, and advanced would be advisable. i dunno tho i wholeheartedly agree, though, that do my homework posts and questions easily located in the man or the lists archive are pretty prevalent here. j0da -Original Message- From: Robert Lucier [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 1:55 PM To: jds; Patrick Crowley; Keith C. Ivey Cc: MySQL List Subject: RE: Spam A little higher barrier to entry, even for non-spam posts might not be a bad thing. The list is already pretty well spammed with questions that are either in the manual, or result from a lack of programming experience in general. Making it harder to post might make it a little easier to stay subscribed --- jds [EMAIL PROTECTED] wrote: ummm. you go ahead with that and noone will stay on the list. again, now with my stupid reply, there has been more posts about spam than actual spam. let's do the list a favor and put this thread to bed. jOda -Original Message- From: Patrick Crowley [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 10, 2002 11:16 AM To: Keith C. Ivey Cc: MySQL List Subject: Re: Spam I have to say I'm shocked that the list is completely open. That's such a stupid newbie thing to do. Maybe we should initiate a spam strike until the list mom/dad listens. Just subscribe the list to *another* list, and watch the fun begin... best, patrick crowley mokolabs making sure the future doesn't suck... w http://mokolabs.com e [EMAIL PROTECTED] p 646.591.5477 Why *isn't* posting to the MySQL list restricted to subscribers? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
select and count
Hi, We have a transaction table that has a field called userid. Each time a user makes a purchase, this table get populated. I am using the following query to get the no of transactions per user: select userId, count(*) from transactions group by userid I am using the following query to get a list all consumers that purchased just ONCE select userId, count(*) as txn from transactions group by userid having txn=1 how do i modify this query so that it returns the TOTAL number of consumers that made a purchase just once and not a list of userids? Thanks Pinky - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 compile problems on Solaris 8 'floor' undeclared
I would imagine floor() would be defined in math_iso.h.. Since floor() is a math function.. along with ceiling() (sp?) You need math_iso.h.. Maybe it wasn't in the tar? Can't imagine why it wouldn't be. - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -Original Message- From: Faine, Mark [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 1:56 PM To: '[EMAIL PROTECTED]' Subject: @#$#%@ mysql compile problems on Solaris 8 'floor' undeclared Solaris 8 GCC 3.03 Ok, first I got an error about iso/math_iso.h not being there so I commented it out of the math.h file. This got me past that error, now I get this error. gcc -O3 -DUNDEF_THREADS_HACK -I./../include -I../include -I./.. -I..-I..-O -DDBUG_OFF -felide-constructors -fno-exceptions -fno-rtti -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_CURSES_H -I/export/home/temp/mysql-3.23.47/include -DHAVE_RWLOCK_T -c mysql.cc mysql.cc: In function `void nice_time(double, char*, bool)': mysql.cc:2409: `floor' undeclared (first use this function) mysql.cc:2409: (Each undeclared identifier is reported only once for each function it appears in.) make[2]: *** [mysql.o] Error 1 make[2]: Leaving directory `/export/home/temp/mysql-3.23.47/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/export/home/temp/mysql-3.23.47' make: *** [all-recursive-am] Error 2 If anyone has any idea of how to fix this please let me know. Thanks, Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Coldfusion?
Interesting story. We run Windows 200 servers, and we axed MSSQL and CF/ASP. i would (and do) run php even on a windows box. i guess the only problem it brings is no stored procedures, and people freak out if they don't have that enterprise interface. oh well. mySQL runs better even on a win32 platform (IMHO). -Original Message- From: Nally, Tyler G. [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 2:52 PM To: [EMAIL PROTECTED] Subject: RE: Coldfusion? -Original Message- From: Andy Ingham [mailto:[EMAIL PROTECTED]] We've been running Cold Fusion with MySQL on the Solaris platform for almost two years now and have had such terrible problems with Cold Fusion errors that we have begun the process of migrating to PHP. Our average load has been about 30,000 .cfm pages (linked to MySQL backend) served per week, which I don't consider to be too heavy a load to expect the system to handle successfully. Unfortunately, our log files are riddled with fatal Cold Fusion errors and subsequent restarts. It got so bad that we had to institute a cron job to check for the happiness of the CF processes every 3 minutes and restart them if there was a problem. Oh boy... I'll confirm that as well. I previously worked at Macmillan Computer Publishing (www.mcp.com) when I wrote The Personal Bookshelf and migrated that application from cgi-bin/perl and dbm arrays to Cold Fusion/Oracle all on Solaris. It was CF version 4. And it was really bad. In a development environment where there is limited access, and the machine load is relatively low, it's no problem. Yet, the webstats were saying we had approximately 8,000 users using the Personal Bookshelf at any one time, so it was going to be put under a heavy load once it is in production. Such happened and CF really really choked. The machine suffered under a really high *load*. Typically above 90%. The sysadmins joked that the machine was working so hard it was glowing in the corner. We optimized the code over the course of a couple of weeks scruitinizing the CF markup for more efficient ways to do things in order to get it down to a load. We got the load down to between 60-70% as I remember, which was still too high. Not only was the machine at an unusually high load, but the CF server would die periodically between every 10-45minutes. The sysadmins eventually wrote a script to check the health of the CF server instance that'd run every 3 minutes to determine whether or not it should restart CF automtically. It was a really bad situation. We talked with Allaire and they couldn't believe the problems we had with CF on Solaris. At the time, Allaire said that we had the largest *nix based CF application on the www with a Sun Ultra with 4 GB of RAM tied to a pretty heavy amount of disk space, etc. We provided them with database schema's, data, and our code ... and let them try it out. They did. And they confirmed everything we had said...even in their environment. They said the design of the database and the coding of the pages didn't contribute to the poor performance of the CF engine. Ultimately, they said they couldn't help us because the thing in CF that was causing all of the problems (they said) was a simulated windows registry that CF requires in order to operate. They said that we were also suffering from a lot of errors where CF would loose database connections and not keep threads alive like they would in a non-*nix environment without a heavy load. They had no answers for us at all. They suggested that it be monitored constantly so that the application stays running as much as possible. When I heard about the simulated registry for *nix servers built into CF, I nearly hit the roof! I couldn't hardly believe it. That was a couple of years ago, and CF has went from 4 -- 4.5 -- 5. Under a windows environment, it's probably pretty good. Under *nix (Solaris in my experience) it really left much to be desired. I'd avoid it and stick with php on Solaris any day. Tyler Nally -- __ _Tyler Nally / /__ _(_)___ _ _ [EMAIL PROTECTED] / / _ \/ __ `/ / __ \/ __ \ / __ \/ ___/ __ `/ 317-860-3016 / / __/ /_/ / / /_/ / / / // /_/ / / / /_/ / American Legion Website /_/\___/\__, /_/\/_/ /_(_)/_/ \__, /http://www.legion.org // // - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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)
RE: Spam
I wasn't trying to say that the simple questions are spam, only that if it took a little more effort to post, some people might check with the manual and archives first. Posting to the list would always still be an option if those failed. Maybe the lists could be divided into: 1. mysql compilation and installation, 2. other mysql specific questions (table sizes, corruption recovery, database-level permissions, different table types), 3. writing applications w/mysql (like integrating w/other apps, php, odbc, and general questions about writing database apps, and writing particular sql statements). But it's not terrible as it is now. I would simply argue that making it slightly more difficult to post is *not* going to kill off the list. --- jds [EMAIL PROTECTED] wrote: i don't consider questions resulting from a lack of programming experience spam. the list SHOULD aid and embrace novice users. i know heikki and sinisa have both helped me with my basic questions, although i took some time to look in the archives and man before i posted. this IS the general list, after all. perhaps splitting it into three child lists: novice, intermediate, and advanced would be advisable. i dunno tho i wholeheartedly agree, though, that do my homework posts and questions easily located in the man or the lists archive are pretty prevalent here. j0da -Original Message- From: Robert Lucier [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 1:55 PM To: jds; Patrick Crowley; Keith C. Ivey Cc: MySQL List Subject: RE: Spam A little higher barrier to entry, even for non-spam posts might not be a bad thing. The list is already pretty well spammed with questions that are either in the manual, or result from a lack of programming experience in general. Making it harder to post might make it a little easier to stay subscribed --- jds [EMAIL PROTECTED] wrote: ummm. you go ahead with that and noone will stay on the list. again, now with my stupid reply, there has been more posts about spam than actual spam. let's do the list a favor and put this thread to bed. jOda -Original Message- From: Patrick Crowley [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 10, 2002 11:16 AM To: Keith C. Ivey Cc: MySQL List Subject: Re: Spam I have to say I'm shocked that the list is completely open. That's such a stupid newbie thing to do. Maybe we should initiate a spam strike until the list mom/dad listens. Just subscribe the list to *another* list, and watch the fun begin... best, patrick crowley mokolabs making sure the future doesn't suck... w http://mokolabs.com e [EMAIL PROTECTED] p 646.591.5477 Why *isn't* posting to the MySQL list restricted to subscribers? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try:
RE: Combine data from multiple tables
* Eric Mayers I have three tables, each with a single column, data. I'd like to form a query that will combine the table columns into a common result column. When I use the query: SELECT * from tab1, tab2, tab3 I get: +-++---+ | data| data | data | +-++---+ | VAL1| VAL2 | VAL3 | +-++---+ But what I want is: +-+ | data| +-+ | VAL1| | VAL2| | VAL3| +-+ Is this possible? Yes, it is possible. Use a temporary table and multiple statements: mysql create temporary table tmp1 select * from tab1; Query OK, 1 row affected (0.40 sec) Records: 1 Duplicates: 0 Warnings: 0 mysql insert into tmp1 select * from tab2; Query OK, 1 row affected (0.02 sec) Records: 1 Duplicates: 0 Warnings: 0 mysql insert into tmp1 select * from tab3; Query OK, 1 row affected (0.00 sec) Records: 1 Duplicates: 0 Warnings: 0 mysql select * from tmp1; +--+ | data | +--+ | VAL1 | | VAL2 | | VAL3 | +--+ 3 rows in set (0.01 sec) mysql Sometimes it is also possible to do this with a single statement using LEFT JOIN and the IF() function. -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Restoring database from hotcopy
If it's not too much trouble this is slightly urgent. ~Travis I have the database files, now how do I put them back into mysql? Restore table doesn't seem to work. Thanks in advance, ~Travis _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
User/database permissions
This is going to be a very basic question, so please excuse me. I have a MySQL server running, but when I added users I inadvertently gave them all permissions to everything. They can all access every one else's databases and make what ever changes they want and even delete. How do I lock it down where they only have rights to their own? I don't even know how to view what users are there, much less change their rights. I've been looking in the documentation online, but it seems to assume that I know more than I do. Thank you in advance. -MWhitaker - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Is there a QNX port?
Just wanted to know if anyone has compiled MySQL under QNX, and if they did, how they did it. Any help would be appreciated. Therrel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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/database permissions
You need to take a look at the database called mysql. In it you have: culumns_priv db func host tables_priv user as tables. Use the GRANT command to set the USERS, or you can also do an insert statement like so: insert into mysql.tables_priv VALUES ('10.129.29.%','ai','httpd','pop_materials','gevery2@localhost','','Select,I nsert,Update,Delete','') and that will give the user httpd the Select,Insert,Update,Delete priveleges on that particular table. DB's is a bit different, but look at your output from USE mysql; DESC db; commands. -Original Message- From: Intercession Tech Support [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 3:09 PM To: [EMAIL PROTECTED] Subject: User/database permissions This is going to be a very basic question, so please excuse me. I have a MySQL server running, but when I added users I inadvertently gave them all permissions to everything. They can all access every one else's databases and make what ever changes they want and even delete. How do I lock it down where they only have rights to their own? I don't even know how to view what users are there, much less change their rights. I've been looking in the documentation online, but it seems to assume that I know more than I do. Thank you in advance. -MWhitaker - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 with MySQL and SMP?
On Fri, Jan 11, 2002 at 11:54:26AM -0500, [EMAIL PROTECTED] wrote: Any suggestions on loging tools I cna run to try to find out more information? The machine is coloced about 3 hours for me, so I would hate to have to drive there and install FreeBSD on it, when it was just something I could have fixed. MySQL on FreeBSD won't take advantange of the dual-CPUs nearly as well as Linux, FYI. If it's a dedicated MySQL box, that's a big deal. If it is also running Apache and other stuff, not much of a big deal. 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 8 days, processed 227,520,468 queries (294/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: Restoring database from hotcopy
Do have the files actual files? Or do you have text files which were create from MYSQLDUMP? -Original Message- From: Travis Farmer [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 3:04 PM To: [EMAIL PROTECTED] Subject: Restoring database from hotcopy If it's not too much trouble this is slightly urgent. ~Travis I have the database files, now how do I put them back into mysql? Restore table doesn't seem to work. Thanks in advance, ~Travis _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Updating a field with the result of a select
Hi, Is it possible to update a field with the result of a select. For example: UPDATE ordr_order SET balance = ('SELECT ordr_order.total_cost - sum(ordr_payment.amount) FROM ordr_order LEFT JOIN ordr_payment on ordr_payment.ordr_order_id = ordr_order.id WHERE ordr_order.id = 1') WHERE id = 1 When I execute this query, I don't get an error, but it also doesn't update the field in question. If I execute each query separately, they each work fine. Thanks for your help. Daniel Leighton - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Updating a field with the result of a select
Is it possible to update a field with the result of a select. For example: Try: SELECT @newbalance := ordr_order.total_cost - sum(ordr_payment.amount) FROM ordr_order LEFT JOIN ordr_payment on ordr_payment.ordr_order_id = ordr_order.id WHERE ordr_order.id = 1; UPDATE ordr_order SET balance = @newbalance WHERE id = 1; UPDATE ordr_order SET balance = ('SELECT ordr_order.total_cost - sum(ordr_payment.amount) FROM ordr_order LEFT JOIN ordr_payment on ordr_payment.ordr_order_id = ordr_order.id WHERE ordr_order.id = 1') WHERE id = 1 This doesn't work because it's setting balance to the text of the query, not the result of the query itself. Since balance is probably not a string type, it gets converted to a number which probably ends up making it zero. If MySQL supported subselects it might work except without the single quotes around the 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
returning partial result set
My system tends to generate large result sets, with the first page of results being used and the rest thrown away. I expect this is typical in other systems as well. I've noticed the JDBC driver retrieves the entire result set before letting the application iterate over any results. I'm not sure if this is a limitation in the database or the driver. Oracle has the capability to start returning results as they are generated. Does MySQL have something similar? If not, is there anything I can do to alleviate this behavior? Thanks, Bret - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FW: returning partial result set
Just making sure my post got processed. I replied to the join confirmation after sending my first post. Sorry for the potential redundancy. Bret -Original Message- From: Bret Ewin [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 5:47 PM To: [EMAIL PROTECTED] Subject: returning partial result set My system tends to generate large result sets, with the first page of results being used and the rest thrown away. I expect this is typical in other systems as well. I've noticed the JDBC driver retrieves the entire result set before letting the application iterate over any results. I'm not sure if this is a limitation in the database or the driver. Oracle has the capability to start returning results as they are generated. Does MySQL have something similar? If not, is there anything I can do to alleviate this behavior? Thanks, Bret - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: returning partial result set
If all you want is the first page, then simply use SELECT ... LIMIT n, which will only return the first n rows of the set. To page through data, use LIMIT offset, n, which will return n rows starting at offset rows into the dataset. Note that doing this on a changing table will give results that may not be useful, like skipped or duplicated rows between pages. james montebello On Fri, 11 Jan 2002, Bret Ewin wrote: My system tends to generate large result sets, with the first page of results being used and the rest thrown away. I expect this is typical in other systems as well. I've noticed the JDBC driver retrieves the entire result set before letting the application iterate over any results. I'm not sure if this is a limitation in the database or the driver. Oracle has the capability to start returning results as they are generated. Does MySQL have something similar? If not, is there anything I can do to alleviate this behavior? Thanks, Bret - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: returning partial result set
In your select statement, use the LIMIT option SELECT * FROM table limit 10; will return the first ten rows, or SELECT * FROM table limit 100,10 will return rows 101-110 -Original Message- From: Bret Ewin [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 4:47 PM To: [EMAIL PROTECTED] Subject: returning partial result set My system tends to generate large result sets, with the first page of results being used and the rest thrown away. I expect this is typical in other systems as well. I've noticed the JDBC driver retrieves the entire result set before letting the application iterate over any results. I'm not sure if this is a limitation in the database or the driver. Oracle has the capability to start returning results as they are generated. Does MySQL have something similar? If not, is there anything I can do to alleviate this behavior? Thanks, Bret - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL admin with no password
Sinisa Milivojevic [EMAIL PROTECTED] writes: Trond Eivind Glomsrød writes: Is there a clean way to administrate mysqld without a password by root? I'm looking for ways to make it flush logs, reload my.cnf and shut down cleanly, in an automated way - i.e, no password, but by root. (similar to pg_ctl for postgresql or `kill -HUP` for reloading) (e.g. shut down the server on system shutdown, and make log rotation and kill -HUP will flush everything. We used to do that, but got complaints: https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=51711 It wreaked havoc on bin-logs. OTOH, we need to be able to have scripts controlling the DB as root, while not needing to have a passwordless DB account. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Redhat 7.2 Linux Maximum Database/Table Size
On Fri, Jan 11, 2002 at 08:51:33AM +0100, Dr. Frank Ullrich wrote: Benjamin, can you also grow MyISAM tables to such sizes? You can. -- 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 8 days, processed 229,155,814 queries (294/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: returning partial result set
Thank you! I can use the LIMIT option several places in the system. However, in places where a changing result set is not acceptable I must read the whole result set (or at least as many as I allow pagination across) in the initial query. I tried Statement.setFetchSize() but that doesn't appear to help. Any suggestions in this area? Thanks, Bret -Original Message- From: James Montebello [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 5:57 PM To: Bret Ewin Cc: [EMAIL PROTECTED] Subject: Re: returning partial result set If all you want is the first page, then simply use SELECT ... LIMIT n, which will only return the first n rows of the set. To page through data, use LIMIT offset, n, which will return n rows starting at offset rows into the dataset. Note that doing this on a changing table will give results that may not be useful, like skipped or duplicated rows between pages. james montebello On Fri, 11 Jan 2002, Bret Ewin wrote: My system tends to generate large result sets, with the first page of results being used and the rest thrown away. I expect this is typical in other systems as well. I've noticed the JDBC driver retrieves the entire result set before letting the application iterate over any results. I'm not sure if this is a limitation in the database or the driver. Oracle has the capability to start returning results as they are generated. Does MySQL have something similar? If not, is there anything I can do to alleviate this behavior? Thanks, Bret - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: returning partial result set
Well, as long as you don't mind the overhead, you could simply prevent the table from changing as you page by locking the table while you're paging through it: LOCK TABLE table READ; SELECT ... LIMIT o,n; ... UNLOCK TABLES; as long as the paging process doesn't take too long and/or the update rate is pretty low, this shouldn't be a problem. You could simply grab as many pages as you wish to show into local memory and display the data out of there instead of directly out of the database. Assumes some local storage you can use across HTTP requests, of course. james montebello On Fri, 11 Jan 2002, Bret Ewin wrote: Thank you! I can use the LIMIT option several places in the system. However, in places where a changing result set is not acceptable I must read the whole result set (or at least as many as I allow pagination across) in the initial query. I tried Statement.setFetchSize() but that doesn't appear to help. Any suggestions in this area? Thanks, Bret -Original Message- From: James Montebello [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 5:57 PM To: Bret Ewin Cc: [EMAIL PROTECTED] Subject: Re: returning partial result set If all you want is the first page, then simply use SELECT ... LIMIT n, which will only return the first n rows of the set. To page through data, use LIMIT offset, n, which will return n rows starting at offset rows into the dataset. Note that doing this on a changing table will give results that may not be useful, like skipped or duplicated rows between pages. james montebello On Fri, 11 Jan 2002, Bret Ewin wrote: My system tends to generate large result sets, with the first page of results being used and the rest thrown away. I expect this is typical in other systems as well. I've noticed the JDBC driver retrieves the entire result set before letting the application iterate over any results. I'm not sure if this is a limitation in the database or the driver. Oracle has the capability to start returning results as they are generated. Does MySQL have something similar? If not, is there anything I can do to alleviate this behavior? Thanks, Bret - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Spam - a possible cause ?
I am an experienced programmed and have worked on Unix and with Oracle and Informix for many years. I personally am struggling to get my head around Mysql (getting there now though) I think part of the reason I am posting simple questions is. 1.) I find the manual quite combersome for particular reference, ie I found finding information on adding users and the like quite hard to find easy and had to trawl through similar topics when someone on this list got me on the right track straight away and it was easy to reference the manual from the info given on this list. 2.) My past experience in other languages and RDBMS is hindering my quite bad, ie I am expecting certain restuls from certain situations and not getting them, somethings that seem quite straight forward to people using mysql is totally confusing for someone used to other products. 3.) There is a lot of conflicting information. I have a number of books on Mysql and some conradict each other and the manual, so the only way to make sure is to play/test the methods mentioned, then ask the list when something doesn't make scense 4.) People of All levels join and leave the list each day (I imagane) so reposts are quite common, If they do not apply to me or I don't feel I can help I delete them, otherwist I reply, the number or reposts is becoming a problem due (in my opinion) to a select few elite mysql people, who have strong skills with MySql and have been using it for a while, instead of ignoring the reposts (which I am sure they have seen hundereds of times) they reply back with harsh (again my opinion) or acidic comments, like this was posted 3 days ago, read the manual before wasting our time. This points out peoples re-posts to others who are not so bothered, if they just deleted what did not apply I am sure someone of similar level to the question poster would reply with a helpfull comment. On the other hand these elitist people do provide good info when needed so I don't intend to be too blaming on them. I really like the way this list works, and I have found %90 usefull and had some really indepth discussions on even the simplist questions, giving me a better understanding of the problem that I first asked. Not sure how close to the mark I am but I thought I would put my opinion in. Matt. -Original Message- From: Robert Lucier [mailto:[EMAIL PROTECTED]] Sent: 11 January 2002 19:55 To: jds; Patrick Crowley; Keith C. Ivey Cc: MySQL List Subject: RE: Spam A little higher barrier to entry, even for non-spam posts might not be a bad thing. The list is already pretty well spammed with questions that are either in the manual, or result from a lack of programming experience in general. Making it harder to post might make it a little easier to stay subscribed --- jds [EMAIL PROTECTED] wrote: ummm. you go ahead with that and noone will stay on the list. again, now with my stupid reply, there has been more posts about spam than actual spam. let's do the list a favor and put this thread to bed. jOda -Original Message- From: Patrick Crowley [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 10, 2002 11:16 AM To: Keith C. Ivey Cc: MySQL List Subject: Re: Spam I have to say I'm shocked that the list is completely open. That's such a stupid newbie thing to do. Maybe we should initiate a spam strike until the list mom/dad listens. Just subscribe the list to *another* list, and watch the fun begin... best, patrick crowley mokolabs making sure the future doesn't suck... w http://mokolabs.com e [EMAIL PROTECTED] p 646.591.5477 Why *isn't* posting to the MySQL list restricted to subscribers? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Inserting Object property in MySQL
I've got the following query executing in my php code: $query = INSERT INTO table1(created,updated,ses) values(now(),now(),'$this-PNPSES-ses'); MYSQL_QUERY($query); query executes fine, but when I look at the ses column in inserted row it says Object-ses instead of a value. Any ideas why? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to retrieve image from MySQL
Hai, I am doing sthing about store the image inside the mysql database using blob datatype, programm be Visual Basic 6.0. It is fine when i store it image in, however i unable to retieve the image. I have test my program in Ms Access and it work fine. Another thing i found that if we want to insert binary data into a BLOB column, some special characters must be represented by escape sequences, is it any function available in VB? Is any one know what forum is discuss about VB and MySQL? Thanks Regards, Jenny
Re: Inserting Object property in MySQL
THis is more of a PHP issue, but: When PHP evaluates variables in a double-quoted string, it sees your $this (the object reference) and immediately evaluates it (just returning its type - Object). If you want to tell PHP to dereference $this-PNPSES-ses properly, do $query = INSERT INTO table1(created,updated,ses) values(now(),now(),'.$this-PNPSES-ses.'); or $query = INSERT INTO table1(created,updated,ses) values(now(),now(),'{$this-PNPSES-ses}'); The later method should work, according to the docs, but I haven't tried it. For more info, see: http://www.php.net/manual/en/language.types.string.php and http://www.php.net/manual/en/language.types.string.php#language.typ http://www.php.net/manual/en/language.types.string.php#language.types.string .parsing -steve At 05:19 PM 1/11/02 , [EMAIL PROTECTED] wrote: I've got the following query executing in my php code: $query = INSERT INTO table1(created,updated,ses) values(now(),now(),'$this-PNPSES-ses'); MYSQL_QUERY($query); query executes fine, but when I look at the ses column in inserted row it says Object-ses instead of a value. Any ideas why? ++ | Steve Edberg [EMAIL PROTECTED] | | Database/Programming/SysAdmin(530)754-9127 | | University of California, Davis http://pgfsun.ucdavis.edu/ | +-- Gort, Klaatu barada nikto! --+ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Test Case (Urgent)
On Fri, Jan 11, 2002 at 04:48:18PM +0530, Manish Mehta wrote: Hi, I am new to test case design in Database. I wants to know Basically how to calculate the Maximum Database. A database can consist of several tables. Each table is stored (essentially) as a file. The size of a that file depends on a) your operating system, and b) which table type you use. See the list's archives for some specific numbers. When we have to take backup.? What do you mean by 'backup'? Copying the database's files directly to tape? That depends on your computer's disk subsystem, and what you're writing them to. 'Dumping' the database to a file? That also depends on your computer's disk subsystem, and might also be limited to your CPU and how much physical memory you have. What are steps to be flow please tell me. The 'best' thing to do, for whatever methods your speaking of, is: 1) install MySQL on the hardware where all of this would take place; the software is freely available. 2) create a database and a table, and try to fill it; shouldn't take more than a couple of hours, assuming you're willing to cobble a script together. 3) try to back up the database you just created. Honestly, your own experiments will give you the most concrete numbers, given the hardware and methods you have... Thanks in advance. Manish Mehta E-mail: [EMAIL PROTECTED] -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php