Re: Java Related Sites for MySQL

[D Bamud]

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.

[Marjolein Katsma]

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

[emmanuel]

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

[Pål Sollie]

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

[Jean-Luc Fontaine]

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

[Stuart Otway]

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

[Pål Sollie]

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?

[DL Neil]

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)

[Manish Mehta]

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

[Konstantin V. Semenov]

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

[callis]

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

[Andrew Aragi]

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

[Miguel Angel Solorzano]

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.

[Jeff Bearer]

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

[Andrew Aragi]

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.

[Sait Karalar]

  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

[Simon Oliver]

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.

[Sait Karalar]

  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

[Miguel Angel Solorzano]

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.

[Jeff Bearer]

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

[Sinisa Milivojevic]

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

[Steve Rapaport]

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

[Andrew Aragi]

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

[Gary . Every]

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

[Ryan Fox]

- 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

[Jonas Arvidsson]

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

[willinger netcactus]

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

[Müller, Markus]

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

[Gary . Every]

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

[Sinisa Milivojevic]

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?

[MSL]

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?

[MSL]

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

[Zdzislaw A. Kaleta]

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

[Roger Baklund]

* 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

[Sinisa Milivojevic]

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

[Gerald Clark]

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

[Gerald Clark]

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!

[MSL]

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

[Robert L. Yelvington]

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?

[Bryan Capitano]

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...

[Kyle Hayes]

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.

[Jonathan Hilgeman]

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?

[Stephen S Zappardo]

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?

[gavin]

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

[MSL]

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?

[James Cox]

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

[Andrew Aragi]

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?

[Joshua J . Kugler]

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

[Demirchyan Oganes-AOD098]

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?

[Johnny Withers]

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?

[Thibaut Allender]

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?

[Sinisa Milivojevic]

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?

[Johnny Withers]

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?

[Joshua J . Kugler]

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?

[Andy Ingham]

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?

[Ryan Fox]

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

[MSL]

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

[Cindy Yu]

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

[Ryan Fox]

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

[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?

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

[Ryan Hagan]

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

[Aaron Brick]

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

[James Montebello]

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

[Aaron Brick]

 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

[samit darne]

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

[Roger Baklund]

* 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

[Robert L. Yelvington]

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

[James Montebello]

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

[jds]

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 ??

[Investor]

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

[Robert Lucier]

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

[Faine, Mark]

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?

[Nally, Tyler G.]

 -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

[jds]

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

[Pinky Thakkar]

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

[Johnny Withers]

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?

[Mike Grabski]

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

[Robert Lucier]

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

[Roger Baklund]

* 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

[Travis Farmer]

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

[Intercession Tech Support]

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?

[Therrel Griffin]

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

[Gary . Every]

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?

[Jeremy Zawodny]

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

[Rick Emery]

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

[Webolution]

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

[Chris Bolt]

 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

[Bret Ewin]

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

[Bret Ewin]

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

[James Montebello]

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

[Gary . Every]

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

[Trond Eivind Glomsrød]

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

[Jeremy Zawodny]

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

[Bret Ewin]

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

[James Montebello]

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 ?

[Matthew Darcy]

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

[PinkeshP]

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

[Jenny]

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

[Steve Edberg]

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)

[Brian Reichert]

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