Re: ANN: Upscene releases Database Workbench 5.4.4

2018-07-09 Thread webmaster




Sent from my Samsung Galaxy smartphone.
 Original message From: "Martijn Tonies (Upscene Productions)" 
 Date: 09/07/2018  13:17  (GMT+00:00) To: 
firebird-to...@yahoogroups.com, mysql@lists.mysql.com Subject: ANN: Upscene 
releases Database Workbench 5.4.4 
Upscene Productions is proud to announce the availability of the next version 
of the popular multi-DBMS development tool:

" Database Workbench 5.4.4 “

This release includes support for MariaDB 10.1 and 10.2, MySQL 5.7 and Azure 
and the latest version of PostgreSQL. Previous releases included a custom 
report writer, a renewed stored routine debugger with full support for Firebird 
3 Stored Functions and Packages and several other features.

Database Workbench 5 comes in multiple editions with different pricing models, 
there's always a version that suits you!

Here's the full list of changes
http://www.upscene.com/go/?go=tracker=5.4.x=12

For more information, see What's new in Database Workbench 5?
( http://www.upscene.com/database_workbench/whatsnew )


Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server,
SQL Anywhere, NexusDB, PostgreSQL and InterBase, comes in multiple editions and 
is licensed based on selectable modules.

It includes tools for database design, database maintenance, testing, data 
transfer,
data import & export, database migration, database compare and numerous other 
tools.


About Database Workbench
Database Workbench is a database developer tool, over 12 years in the making and
is being used by thousands of developers across the globe who have come to rely 
on it
every day. From database design, implementation, to testing and debugging, it 
will aid you 
in your daily database work.

About Upscene Productions
Based in The Netherlands, Europe, this small but dedicated company has been 
providing
database developers with useful tools for over 14 years. Slowly expanding the 
product portfolio
and gaining recognition amongst InterBase and Firebird database developers, 
they now offer
tools for a whole range of database systems, including Oracle and Microsoft SQL 
Server.

RE: Machine Learning

2012-08-24 Thread webmaster
Hi Garot,

How is the visual diagram coming along ?

I'd be good to have a good idea of core system specifics so that DB design can 
be tailored to that ... of course, knowing that things will change as the 
concept evolves.

Thanks,
Justin

-Original Message-
From: Garot Conklin [mailto:garotconk...@yahoo.com] 
Sent: 23 August 2012 20:14
To: Martin Gainty; ag4ve...@gmail.com
Cc: webmas...@lisol.co.uk; mysql@lists.mysql.com
Subject: Re: Machine Learning

That is in fact a very interesting approach... I like it very much.  Any 
architectural thoughts on an auto-population attempt? Odly I have not created a 
db like this before, not from this large of an import anyway... Please share 
some thoughts there and I will get that rolling... seems that if we can get 
something physical going I would like to offer it up as a sandbox to all those 
interested.  I have a few X336's lying around my house just collecting dust, 
they would be a great testing environment for all to work on.


 
garotconk...@yahoo.com



 From: Martin Gainty mgai...@hotmail.com
To: ag4ve...@gmail.com; garotconk...@yahoo.com
Cc: webmas...@lisol.co.uk; mysql@lists.mysql.com mysql@lists.mysql.com
Sent: Thursday, August 23, 2012 11:30 AM
Subject: RE: Machine Learning
 

Shawn and Garot

I like the parsing capability of the lucene and its ability to stem incoming 
queries..
If you are able to start populating your data then we *should* be able to start 
identifying which root terms we can pull for building lucene-indexes I have an 
upcoming 
stuck-in-JFK-airport-on-labor-day-waiting-for-the-next-am-flight-of-USscare for 
an interrupted timeframe(i never learned how to 'sleep' in airport terminal) as 
long as I can find a wifi connection (and an AC connection within 6 hours) and 
use a working MySQL JDBC connection string..I should be able to bang out a 
quick prototype..

Let me know how i can help out,
Martin Gainty
__
..place long-winded disclaimer here..


 From: ag4ve...@gmail.com
 Date: Thu, 23 Aug 2012 10:42:55 -0400
 Subject: Re: Machine Learning
 To: garotconk...@yahoo.com
 CC: webmas...@lisol.co.uk; mgai...@hotmail.com; mysql@lists.mysql.com
 
 just a few thoughts (things to look into)
 
 if you want to populate a db with command parameters, i'd mine the man 
 pages. it's a consistent format and you should be able to find a 
 parser for whatever language you prefer.
 
 if you want to see what has been entered and statistics about that 
 process, look at the audit framework. it won't tell you success or 
 failure, but you might be able to derive that based on the time, 
 memory, and process usage that you can get from audit. auditd also 
 maintains a db - you might look into the engine and schema they use.
 
 you might also find some interesting topics looking into language 
 processing (after all, commands are a type of language). people 
 generally use other database engines to do this type of thing - 
 elastic search or some other things people have done with lucene 
 maybe.
 
 do let us know where you go with this. it sounds quite interesting 
 (and might help me with something i've been looking into)... and 
 getting zsh to autocomplete options might be a bonus if you parse man 
 pages and shove it into a db (i might do that part for you if i get a 
 lazy afternoon).
 
 On Wed, Aug 22, 2012 at 7:51 PM, Garot Conklin garotconk...@yahoo.com wrote:
  I am going to work up a visual diagram for this to better... 
  visualize (LOL) the lay of the land. I will forward it when i have 
  it completed then I hope we can continue the architectural 
  discussion here!  Thanks
 
  -Garot
 
 
  garotconk...@yahoo.com
 
 
  
   From: Garot Conklin garotconk...@yahoo.com
  To: Garot Conklin garotconk...@yahoo.com; webmas...@lisol.co.uk 
 webmas...@lisol.co.uk; 'Martin Gainty' mgai...@hotmail.com; 
 mysql@lists.mysql.com mysql@lists.mysql.com
  Sent: Tuesday, August 21, 2012 4:40 PM
  Subject: Re: Machine Learning
 
  to elaborate:
 
  I would almost rather qualify from the OS perspective what will work in 
  advance, but take into consideration any failing condition.  I may be 
  getting a bit too specific at this juncture however as I am already apply 
  this logic to issues I see in MY environment rather than total ambiguity, 
  which is a best position here.
 
  I am ultimately expecting the learning algorithm to create new and 
  excitingly effective ways of stringing commands together to solve issues, 
  this being a notable aspect in and of itself, then creating some 
  centralization based on what the machine determines as a best solution.
 
  Seems a relative snapshot of the system pre and post execution would be 
  favorable as well so long as resources are not taxed as a result.  This 
  discussion is leading me to believe that this will be a multifaceted db 
  solution without a doubt comprised of multiple layers of 

RE: Machine Learning

2012-08-21 Thread webmaster
Hi Garot,

 

Ok, the concept is getting clearer, but let’s bring this down to earth a
little bit more. I love DB design and problem-solving and am quite curious
about this.

 

Is the idea that you have a central computer (not HAL J) somewhere so that
other computers can:

1)  Refer to it for ‘knowledge’ (for instance, of what the latest
version of a command is)

2)  Send their ‘knowledge’ (for instance, of the latest command
versions) to it for storage and distribution to others

 

If this is the model, then the knowledge base can build up organically over
time – I think. Or is this too simplistic ?

 

Thanks,

Justin

 

From: Martin Gainty [mailto:mgai...@hotmail.com] 
Sent: 21 August 2012 00:25
To: garotconk...@yahoo.com; webmas...@lisol.co.uk; mysql@lists.mysql.com
Subject: RE: Machine Learning

 

When I hear 'AI' I always imagine theres a HAL 9001 behind the scenes that
is running the show constantly admonishing its creator to take another
stress pill

Sounds like a fun project

Keep us apprised,
Martin Gainty 
__ 
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité


Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene
Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte
Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht
dient lediglich dem Austausch von Informationen und entfaltet keine
rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von
E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen.

Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le
destinataire prévu, nous te demandons avec bonté que pour satisfaire
informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie
de ceci est interdite. Ce message sert à l'information seulement et n'aura
pas n'importe quel effet légalement obligatoire. Étant donné que les email
peuvent facilement être sujets à la manipulation, nous ne pouvons accepter
aucune responsabilité pour le contenu fourni.





  _  

Date: Mon, 20 Aug 2012 13:50:04 -0700
From: garotconk...@yahoo.com
Subject: Re: Machine Learning
To: webmas...@lisol.co.uk; mgai...@hotmail.com; mysql@lists.mysql.com

Ya the idea is not anything new, but must be apparently quit difficult or
not a priority as I have yet to find it already implemented anywhere... Far
be it from me to not make some attempt here anyway...

 

I am creating a fully automated framework from which a distributed
infrastructure can be maintained.  I have been writing automation
scripts/code for some time now and the logical progression is to embark on a
full concept of systems health auto remediation.  I have numerous
monitoring solutions under my control however none that properly (in my
opinion) implements any real learning algorithms from which to draw even a
minimalists view of automation.  I like mySQL therefor began thinking about
creating the aspects (lobes) of the brain as a relational database(s).  So
this is only one facet of what I am trying to do, however leveraging a full
command set of shell utilities/commands/programs seemed to be a good
starting point before I get into the hard stuff ! 

 

-Garot

 

garotconk...@yahoo.com

  _  

From: webmas...@lisol.co.uk webmas...@lisol.co.uk
To: 'Martin Gainty' mgai...@hotmail.com; garotconk...@yahoo.com;
mysql@lists.mysql.com 
Sent: Monday, August 20, 2012 3:55 PM
Subject: RE: Machine Learning


Hi Garot,



You'll have to elaborate some more ... I understand you may want to protect
the idea as well, so if you can narrow it down to some technical specifics
then it'll help.



What is the objective of this system, for instance ?



Thanks,

Justin



From: Martin Gainty [mailto:mgai...@hotmail.com] 
Sent: 20 August 2012 19:23
To: garotconk...@yahoo.com; webmas...@lisol.co.uk; mysql@lists.mysql.com
Subject: RE: Machine Learning





From: garotconk...@yahoo.com
Subject: Re: Machine Learning
To: webmas...@lisol.co.uk; mgai...@hotmail.com; mysql@lists.mysql.com


My initial thought was to propagate the db with everything and allow the
algorithm to then begin to determin trends/patterns
MGwhich trends or patterns will you be modelling?

and begin either an indexing methodology
MGwhich indexes are you considering: Unique index, primary index or foreign
index?

additional table/db creation process or both to further optimize the calls
being made
MGoptimize based on execution time or diskspace allocated, EliminatingFTS
or some other criteria?
MGhttps://dev.mysql.com/doc/refman/5.5/en/optimization.html

and build in some internal levels of redundancy.
MGwhat about replication
MGhttp://dev.mysql.com/doc/refman/5.5/en/replication.html

I am actually approaching this with some degree of biological conception in
the multipathing within our own brains however until I have something up and
running under some substantial load however I may not get a complete
picture. 

Thanks,


RE: Machine Learning

2012-08-21 Thread webmaster
Ah,

 

Getting clearer and clearer.

 

So these ‘nodes’ could ‘learn’ and ‘teach’ at the same time – right ? For 
instance, N1 runs a command in ‘domain’ D20 which it successful – it send 
information to node N20 that is the authority on domain D20 and N20 records it 
as success; N5 runs a command in domain D20 which goes wrong, and sends info to 
N20 and N20 records failure and sends a correct call to N5. Is this what you 
have in mind ?

 

There are a lot of variables to be considered, for instance:

1)  Command A version 1 can run very happily on operating system version 2, 
but fails in OS version 1

2)  Command A version 1 can run happily on OS version 2 on a 2G RAM, but 
fail on OS version 2 on 1G RAM

3)  etc

 

I think the DB design issues will become straightforward once the model is 
quite clear.

 

Justin

 

From: Garot Conklin [mailto:garotconk...@yahoo.com] 
Sent: 21 August 2012 17:14
To: webmas...@lisol.co.uk; 'Martin Gainty'; mysql@lists.mysql.com
Subject: Re: Machine Learning

 

1)Refer to it for ‘knowledge’ (for instance, of what the latest
version of a command is)

It would most likely end up being central in this sense:

A distributed collection of systems; i.e. (possible defined in roles)

DB's

FE's

REPL's

Cache's

Each DB would have its own collection of remediation's that would then 
be indexed to populate a central db for trending/correlation etc...

The Collective itself would function as a single conceptual 
implementation. A VIP for example might be associated with a specific role, say 
Web FE's and remediate only/all of them, but only have some relative access to 
the core db of say the Network from a Primary index perspective to make/draw 
associations/conclusions to issues at hand.

 


2)Send their ‘knowledge’ (for instance, of the latest command
versions) to it for storage and distribution to others

Rather than latest command versions I envision this to be more 
encapsulated as latest successful invocation of the command string and it 
inverse as well (to trend/metric-ize the failures thus lending to perpetual 
optimization).

 

I like how this is fleshing out... This is helping me to define what I am 
really trying to accomplish. Thanks very much for everyone responding here, 
this is wonderful, please keep this going...

 

garotconk...@yahoo.com

  _  

From: webmas...@lisol.co.uk webmas...@lisol.co.uk
To: 'Martin Gainty' mgai...@hotmail.com; garotconk...@yahoo.com; 
mysql@lists.mysql.com 
Sent: Tuesday, August 21, 2012 11:19 AM
Subject: RE: Machine Learning


Hi Garot,



Ok, the concept is getting clearer, but let’s bring this down to earth a
little bit more. I love DB design and problem-solving and am quite curious
about this.



Is the idea that you have a central computer (not HAL J) somewhere so that
other computers can:

1)  Refer to it for ‘knowledge’ (for instance, of what the latest
version of a command is)

2)  Send their ‘knowledge’ (for instance, of the latest command
versions) to it for storage and distribution to others



If this is the model, then the knowledge base can build up organically over
time – I think. Or is this too simplistic ?



Thanks,

Justin



From: Martin Gainty [mailto:mgai...@hotmail.com] 
Sent: 21 August 2012 00:25
To: garotconk...@yahoo.com; webmas...@lisol.co.uk; mysql@lists.mysql.com
Subject: RE: Machine Learning



When I hear 'AI' I always imagine theres a HAL 9001 behind the scenes that
is running the show constantly admonishing its creator to take another
stress pill

Sounds like a fun project

Keep us apprised,
Martin Gainty 
__ 
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité


Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene
Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte
Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht
dient lediglich dem Austausch von Informationen und entfaltet keine
rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von
E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen.

Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le
destinataire prévu, nous te demandons avec bonté que pour satisfaire
informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie
de ceci est interdite. Ce message sert à l'information seulement et n'aura
pas n'importe quel effet légalement obligatoire. Étant donné que les email
peuvent facilement être sujets à la manipulation, nous ne pouvons accepter
aucune responsabilité pour le contenu fourni.





  _  

Date: Mon, 20 Aug 2012 13:50:04 -0700
From: garotconk...@yahoo.com
Subject: Re: Machine Learning
To: webmas...@lisol.co.uk; mgai...@hotmail.com; mysql@lists.mysql.com

Ya the idea is not anything new, but must be apparently quit difficult or
not a priority as I 

RE: Machine Learning

2012-08-20 Thread webmaster
Hi Garot,

This sounds an interesting idea.

Are you looking to store all known commands and their options or are you
looking for a 'formula' for calling any unix command ?

The reason for my question is that, at the end of the day, a unix command is
just a program that is run in the operating system. Each program comes with
its own options and acceptable inputs. I don't know if there is a rule or
convention for structuring these commands.

Are you then looking to build a system that 'knows' all commands and 'how
to' call them ?

Thanks,
Justin

-Original Message-
From: Garot Conklin [mailto:garotconk...@yahoo.com] 
Sent: 20 August 2012 03:39
To: Martin Gainty; mysql@lists.mysql.com
Subject: Re: Machine Learning

The initial goal is to provide a working framework from which to call all
UNIX shell command combinations as the underlying storage mechanism for a
machine learning algorithm.  I would like to build a completely self aware
instantiation that will maintain itself on all levels... I postulate that
the first place to start would be in determining a method for maintaining
all possible remediation combinations including the unknown to eventually be
learned from and populate new knowledge into the database.  Thank you for
the reply,

Garot


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql



RE: Machine Learning

2012-08-20 Thread webmaster
Hi Garot,

 

You'll have to elaborate some more ... I understand you may want to protect
the idea as well, so if you can narrow it down to some technical specifics
then it'll help.

 

What is the objective of this system, for instance ?

 

Thanks,

Justin

 

From: Martin Gainty [mailto:mgai...@hotmail.com] 
Sent: 20 August 2012 19:23
To: garotconk...@yahoo.com; webmas...@lisol.co.uk; mysql@lists.mysql.com
Subject: RE: Machine Learning

 

 

From: garotconk...@yahoo.com
Subject: Re: Machine Learning
To: webmas...@lisol.co.uk; mgai...@hotmail.com; mysql@lists.mysql.com


My initial thought was to propagate the db with everything and allow the
algorithm to then begin to determin trends/patterns
MGwhich trends or patterns will you be modelling?

and begin either an indexing methodology
MGwhich indexes are you considering: Unique index, primary index or foreign
index?

additional table/db creation process or both to further optimize the calls
being made
MGoptimize based on execution time or diskspace allocated, EliminatingFTS
or some other criteria?
MGhttps://dev.mysql.com/doc/refman/5.5/en/optimization.html

 and build in some internal levels of redundancy.
MGwhat about replication
MGhttp://dev.mysql.com/doc/refman/5.5/en/replication.html

I am actually approaching this with some degree of biological conception in
the multipathing within our own brains however until I have something up and
running under some substantial load however I may not get a complete
picture. 

Thanks,

Garot


Interesting
Martin

  _  

From: webmas...@lisol.co.uk webmas...@lisol.co.uk; 
To: 'Garot Conklin' garotconk...@yahoo.com; 'Martin Gainty'
mgai...@hotmail.com; mysql@lists.mysql.com; 
Subject: RE: Machine Learning 
Sent: Mon, Aug 20, 2012 7:13:25 AM 


Hi Garot,

This sounds an interesting idea.

Are you looking to store all known commands and their options or are you
looking for a 'formula' for calling any unix command ?

The reason for my question is that, at the end of the day, a unix command is
just a program that is run in the operating system. Each program comes with
its own options and acceptable inputs. I don't know if there is a rule or
convention for structuring these commands.

Are you then looking to build a system that 'knows' all commands and 'how
to' call them ?

Thanks,
Justin

-Original Message-
From: Garot Conklin [mailto:garotconk...@yahoo.com] 
Sent: 20 August 2012 03:39
To: Martin Gainty; mysql@lists.mysql.com
Subject: Re: Machine Learning

The initial goal is to provide a working framework from which to call all
UNIX shell command combinations as the underlying storage mechanism for a
machine learning algorithm.  I would like to build a completely self aware
instantiation that will maintain itself on all levels... I postulate that
the first place to start would be in determining a method for maintaining
all possible remediation combinations including the unknown to eventually be
learned from and populate new knowledge into the database.  Thank you for
the reply,

Garot

 



RE: Database design help

2010-09-01 Thread webmaster
Hi Neil,

May be your question is too vague.

You have already identified the 'real world' objects that you want
represented in the database.

Have you identified the specific pieces of information that you want stored
for each object ? After you do that, you can then start to see what the
relationships between the objects are.

And you can then ask people that don't know anything about your application
more specific questions like:

- this is what I have in this and that object : how do I get this and that
to relate to this and that ?

Thanks,
Justin

-Original Message-
From: Tompkins Neil [mailto:neil.tompk...@googlemail.com] 
Sent: 01 September 2010 12:52
To: [MySQL]
Subject: Fwd: Database design help

Looking for some help / comments if possible ?

Cheers
Neil

-- Forwarded message --
From: Neil Tompkins neil.tompk...@googlemail.com
Date: Tue, Aug 31, 2010 at 8:48 PM
Subject: Database design help
To: mysql@lists.mysql.com


Hi

I've a soccer application consisting of managers, teams players and
fixtures/results. Basically each manager will get points for each game which
will depend on the result.

What would be the best table design bearing in mind that a manager can move
to a different club.

My thought was to have a field in the fixtures/results table for the manager
points but i think that I will also need a users field so that I can
remember which points belong to which manager.

Is this the correct approach??

Cheers Neil



__ Information from ESET NOD32 Antivirus, version of virus signature
database 5414 (20100901) __

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

 

__ Information from ESET NOD32 Antivirus, version of virus signature
database 5414 (20100901) __

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com
 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



RE: Count Query question

2010-05-13 Thread webmaster
Hi Keith,

The way I would go about this is to try and pinpoint what the issue is, by 
breaking the query up.

For instance, if you remove the 'product_quantity  0' condition, do you get 
any more rows in your result ?

I also notice that your 'products_date_avaiable' is defaulting to '2008-10-01 
00:00:00' which is the same date in your two sample rows.

Run a query like
  SELECT distinct (products_date_available) FROM products

and see if there are there are any other dates ... if there are only 2, then 
you'll get only two rows.

Thanks,
Justin Tifang

-Original Message-
From: Keith Clark [mailto:keithcl...@k-wbookworm.com] 
Sent: 13 May 2010 14:11
To: mysql@lists.mysql.com
Subject: Re: Count Query question

Bob,

Here are a few rows of my data:

17462, 0, '0929998596', '/GraphicNovels/0929998596.jpg', '8.5000',
'2010-05-12 19:02:47', '2008-10-01 00:00:00', '2008-10-01 00:00:00',
'0.50', 1, 1, 7429, 0, '1', 

17461, 1, '1561481912', '/Cooking/1561481912.jpg', '3.', '2010-05-12
19:00:17', '2008-10-01 00:00:00', '2008-10-01 00:00:00', '0.50', 1, 1,
7428, 0, '1', 

Here is the query I ran:

SELECT date(products_date_available) as Date,
COUNT(products_quantity) as 'Titles Available',
SUM(products_quantity) as 'Books Available'
FROM products
WHERE products_quantity  0
GROUP BY date(products_date_available);

And I only got back two rows from over 2 years of daily entries:

'2008-01-01', 3327, '3736'
'2008-10-01', 2739, '2904'

I'm not sure I understand where I'm going wrong.

Keith


On Wed, 2010-05-12 at 21:54 -0500, Bob Cole wrote:
 Kevin:
 I assumed the following data:
 products_id   products_date_available products_quantity
 112010-05-01  1
 112010-05-02  0
 112010-05-03  3
 112010-05-04  3
 112010-05-05  3
 112010-05-06  1
 112010-05-07  0
 112010-05-08  3
 112010-05-09  3
 112010-05-10  3
 112010-05-11  3
 112010-05-12  3
 222010-05-01  1
 222010-05-02  2
 222010-05-03  0
 222010-05-04  3
 222010-05-05  3
 222010-05-06  1
 222010-05-07  0
 222010-05-08  3
 222010-05-09  0
 222010-05-10  3
 222010-05-11  3
 222010-05-12  3
 332010-05-01  1
 332010-05-02  2
 332010-05-03  3
 332010-05-04  3
 332010-05-05  3
 332010-05-06  0
 332010-05-07  0
 332010-05-08  3
 332010-05-09  3
 332010-05-10  0
 332010-05-11  3
 332010-05-12  3
 
 and used the following query:
  SELECT products_date_available, COUNT(products_quantity), 
 SUM(products_quantity)
  FROM products
  WHERE products_quantity  0
  GROUP BY products_date_available
 
 and got the following results:
  products_date_available   COUNT   SUM
  2010-05-01 00:00:00  3   3
  2010-05-02 00:00:00  2   4
  2010-05-03 00:00:00  2   6
  2010-05-04 00:00:00  3   9
  2010-05-05 00:00:00  3   9
  2010-05-06 00:00:00  2   2
  2010-05-08 00:00:00  3   9
  2010-05-09 00:00:00  2   6
  2010-05-10 00:00:00  2   6
  2010-05-11 00:00:00  3   9
  2010-05-12 00:00:00  3   9
 
 One line for each day except that 2010-05-07 is missing because each product 
 had 0 quantity on that day.
 For example, on 2010-05-01, there were 3 products (each with a quantity of 1) 
 for a total quantity of 3.
 I wonder if I am representing your situation correctly.  What am I missing?
 Bob
 
 On May 12, 2010, at 8:00 PM, Keith Clark wrote:
  Hi Bob,
  No, actually it does not.  I'm looking for the count of items.  From
  your query example I only get two rows.  This table has over 2 1/2 years
  of daily sales data.
  Maybe I'm not stating my question correctly...h
  Thanks for responding though, greatly appreciated.
  Keith
  On Wed, 2010-05-12 at 19:46 -0500, Bob Cole wrote:
  Keith:
  Does this work?
  SELECT products_date_available, COUNT(products_quantity)
  FROM products
  WHERE products_quantity  0
 GROUP BY products_date_available
  Hope this helps,
  Bob
  On May 12, 2010, at 3:06 PM, Keith Clark wrote:
  On Wed, 2010-05-12 at 10:13 -0400, Keith Clark wrote:
  Chris,
  Here is my full table definition:
  
  CREATE TABLE `products` (
  `products_id` int(15) NOT NULL AUTO_INCREMENT,
  `products_quantity` int(4) NOT NULL,
  `products_model` varchar(15) NOT NULL DEFAULT '',
  `products_image` varchar(64) DEFAULT NULL,
  `products_price` decimal(15,4) DEFAULT NULL,
  `products_date_added` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `products_last_modified` datetime DEFAULT '2008-10-01 00:00:00',
  `products_date_available` datetime DEFAULT '2008-10-01 00:00:00',
  `products_weight` decimal(5,2) 

Re: Upgrade Mysql

2009-05-21 Thread Webmaster Studio Informatica
Thank You for all the help.

I was upgrading from 4.0.x to 5.0.x

The new mysql recognized the old databases without problems.

Bye :)

Upgrade Mysql

2009-05-20 Thread Webmaster Studio Informatica
Hi,

 

I need to upgrade Mysql 4 to Mysql 5 on Linux.

 

I will uninstall version 4 and install version 5.

 

 

With uninstallation usually database files remain in /var/lib/mysql/

 

 

 

I want to know if with the installation of Mysql 5 those database will be 
recognized and imported to work with the new version automatically.

 

 

 

Thank You.

Joins with sums

2007-01-30 Thread webmaster
I'm missing something really silly in a query.

I want to produce a list of accounts, the invoices and receipts and the
balance against them.

Simply, there is an accounts table, invoices and receipts.

I want to show the account details, sum(invoices), sum(receipts) and the
balance. There is a situation where there maybe receipts and no invoices,
and visa-versa, hence the if statement.

SELECT account.accountId, account.name,
if(count(invoices.invoiceId)=0,0,sum(invoices.amount)) as debits,
if(count(receipts.receiptId)=0,0,sum(receipts.amount)) as credits,
if(count(invoices.invoiceId)=0,0,sum(invoices.amount))-if(count(receipts.rec
eiptId)=0,0,sum(receipts.amount)) as balance
FROM family
LEFT JOIN invoices ON invoices.accountId=account.accountId
LEFT JOIN receipts ON receipts.accountId=account.accountId
WHERE invoices.invoiceDate=CURDATE()
GROUP BY account.accountId

For some reason, I'm getting results with multiple invoices etc against them
- normally 3. Can anyone point out where I've gone wrong?

Cheers
Nunners


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)

2006-04-25 Thread Webmaster

Hello,

Not wanting to hijack this thread, but what is the best source for a 
zip code database?  The best free one I could find was from census 
data from the last census.  Sometimes it won't recognize all the zips 
from large cities.


Thanks,
R

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



One question about Perl DBI interface.

2004-11-29 Thread webmaster
Good morning!

Important: SQL Server used: MySQL (version 4.0.17) on UNIX FreeBSD.

Answer this question please:
Can I make a request, consisting of several SQL commands at one step, like this:
use DBI; 
my $db = DBI-new();
$db = DBI-connect(...) or die Can't connect to DataBase:, error code, 
\n; 
$db-do(CREATE TEMPORARY TABLE tmptable (field1 INT(4) UNSIGNED ZEROFILL 
DEFAULT '' NOT NULL,field2 DOUBLE(16,2) DEFAULT '0.00' NOT NULL); LOCK 
TABLES table1 read; INSERT INTO tmptable SELECT field1, MAX(field2) FROM table1 
GROUP BY field1;); 

I can do it by sending these commands one by one in series, like this:
use DBI; 
my $db = DBI-new();
$db = DBI-connect(...) or die Can't connect to DataBase:, error code, 
\n; 
$db-do(CREATE TEMPORARY TABLE tmptable (field1 INT(4) UNSIGNED ZEROFILL 
DEFAULT '' NOT NULL,field2 DOUBLE(16,2) DEFAULT '0.00' NOT NULL);); 
$db-do(LOCK TABLES table1 read;); 
$db-do(INSERT INTO tmptable SELECT field1, MAX(field2) FROM table1 GROUP BY 
field1;);

I think last solution is more time expensive.

#
Truly yours
Sviridov Vladislav.
[EMAIL PROTECTED]

It is possible to copy the database of mysql-3.22.32 on version 4.0.20? There is possibility that they work?

2004-11-19 Thread webmaster
It is possible  to copy the database of mysql-3.22.32 (/usr/local/mysql/var) on 
version 4.0.20 (/usr/local/mysql_new/var)?  

There is possibility that they work?

My O.S. is Solaris 8


Thank's
Alessio

P.S.
In that case I must use the function mysqlhotcopy? I don't have the 
possibility to use mysqldump --all-databases  all_databases.sql



Fw: Mysql-4.1.7 and client library - Client does not support authentication protocol requested by server; consider upgrading MySQL client

2004-11-17 Thread webmaster

 Yare sure that this resolves my problem?
 My problem is the client graphical (webmin or phpmyadmin), working from
 shell (SSH) is all to place.
 Thanks
 Alessio


 - Original Message -
 From: Dathan Vance Pattishall [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
 Sent: Tuesday, November 16, 2004 9:34 PM
 Subject: RE: Mysql-4.1.7 and client library - Client does not support
 authentication protocol requested by server; consider upgrading MySQL
client


  You need to reinstall your mysql api library to talk to mysql-4.1.7:
4.1.7
  has a different auth implementation that is more secure then the 3.23
 mysql
  protocol which your using. I suggest you link against the C-api that
comes
  with 4.1.7.
 
 
 
  DVP
  
  Dathan Vance Pattishall http://www.friendster.com
 
 
   -Original Message-
   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
   Sent: Tuesday, November 16, 2004 11:38 AM
   To: [EMAIL PROTECTED]
   Subject: Mysql-4.1.7 and client library - Client does not support
   authentication protocol requested by server; consider upgrading MySQL
   client
  
   They are successful to install mysql-4.1.7 on o.s. solaris 8 thanks to
 the
   suggestions
   of Gleb Paharenko. Now when use webmin (last version 1.170) o
phpmyadmin
   (last version -2.6.0-pl2) I have this problem:
  
   DBI connect failed : Client does not support authentication protocol
   requested by server; consider upgrading MySQL client
  
   From shell it works all the solution to the problem exists? Or it
is
   better install the version 4.0.21?
  
  
   Thank's
   Alessio
 
 
 



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Mysql-4.1.7 Start - Ended error - Solaris 8

2004-11-16 Thread webmaster
Sorry form my english, I am Italian.

They are successful to install mysql-4.1.7 on o.s. solaris 8 thanks to the 
suggestions of Gleb Paharenko.

Now I have this problem:
When start the command mysqld_safe  mysql start and ended immediately. In 
the log file  I find this error:

041115 20:43:42  mysqld started
041115 20:43:42  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
041115 20:43:42  mysqld ended

Help me, thanks

Alessio


Mysql-4.1.7 and client library - Client does not support authentication protocol requested by server; consider upgrading MySQL client

2004-11-16 Thread webmaster
They are successful to install mysql-4.1.7 on o.s. solaris 8 thanks to the 
suggestions
of Gleb Paharenko. Now when use webmin (last version 1.170) o phpmyadmin (last 
version -2.6.0-pl2) I have this problem:

DBI connect failed : Client does not support authentication protocol requested 
by server; consider upgrading MySQL client

From shell it works all the solution to the problem exists? Or it is 
better install the version 4.0.21?


Thank's
Alessio



Solaris 8 error make on mysql_4.1.7

2004-11-14 Thread webmaster
Sorry form my english, I am Italian.

I have a problem when run make, the error is following

g++ -DUNDEF_THREADS_HACK -I. -I. -I.. -I../include  -g  -DSAFE_MUTEX
-D_FILE_OFFSET_BITS=64 -DHAVE_CURSES_H 
-I/download/mysql_4.1.7/mysql-4.1.7/include -DHAVE_RWLOCK_T -c -o mysql.o `test 
-f 'mysql.cc' || echo './'`mysql.cc
../depcomp: exec: g++: not found
*** Error code 127
make: Fatal error: Command failed for target `mysql.o'
Current working directory /download/mysql_4.1.7/mysql-4.1.7/client
*** Error code 1
make: Fatal error: Command failed for target `all-recursive'
Current working directory /download/mysql_4.1.7/mysql-4.1.7
*** Error code 1
make: Fatal error: Command failed for target `all'
__

Help me, thanks

Alessio




Help query with MySQL 4.0.11

2004-03-24 Thread WebMaster Informática007
Hi

 

I have problem with a Query.

 

It does not recognize EXISTS.

 

My version is MySQL 4.0.11a-gamma

 

The query is:

 

SELECT U.usu_id, U.usu_login

FROM cva_usuario U

WHERE NOT EXISTS (SELECT * FROM cva_grupo_usuario GU WHERE GU.usu_id=U

usu_id Where GU.gru_id=4)

 

Help please.

 

Juan

 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Problem Query EXISTS and IN

2004-03-23 Thread webmaster
Hi

(Sorry by my english, i speak spanish)

I have problem with a Query.

It does not recognize EXISTS nor IN nor NOT IN

My version is MySQL 4.0.11a-gamma

But I do not know if it recognizes those clauses.

I have dealed with the two forms:

1.  SELECT usu_id FROM usuario WHERE NOT EXISTS (SELECT * FROM grupo WHERE
usuario.g_id=grupo.g_id AND grupo.g_id  5)

2.  SELECT usu_id FROM usuario WHERE g_id NOT IN (SELECT g_id FROM grupo WHERE
grupo.g_id  5)


Thanks by your help.

Juan


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Signal 11 shortly after upgrading to 4.0.12

2003-03-20 Thread webmaster
Description:

I upgraded Mysql from 3.23 to 4.0.12, and everything went well. I even
installed MySQL-Max, and the server restarted and apparently was well.

However, when I stopped the daemon with service mysql stop and then 
tried to start it again (service mysql start), refuses to start 
complaining about a signal 11.

Same problem (refuses to start with signal 11) once reverted back to 
3.23. The 4.0.12 version likely corrupted some of the databases.

How-To-Repeat:
I was unable to reproduce the problem with a Red Hat 8.0 machine where 
I did the same upgrade.

Fix:


Submitter-Id:  submitter ID
Originator:Carlos Amengual
Organization:
Healthnet SL
 
MySQL support: none
Synopsis:  Signal 11 when starting the database after upgrade to 4.0.12
Severity:  critical
Priority:  high
Category:  mysql
Class: sw-bug
Release:   mysql-3.23.56 (Official MySQL RPM)

Environment:

System: Linux xxx.healthnet.es 2.4.18-18.7.x #1 Wed Nov 13 20:29:30 EST 2002 i686 
unknown
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 2731 (Red Hat Linux 7.2 2.96-112.7.2)
Compilation info: CC='gcc'  CFLAGS='-O6 -fno-omit-frame-pointer -mpentium'  CXX='gcc'  
CXXFLAGS='-O6 -fno-omit-frame-pointer  -felide-constructors 
-fno-exceptions -fno-rtti -mpentium'  LDFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   13 mar 20 12:30 /lib/libc.so.6 - libc-2.2.4.so
-rwxr-xr-x2 root root  1285884 mar  6 16:03 /lib/libc-2.2.4.so
-rw-r--r--1 root root 27338566 mar  6 15:05 /usr/lib/libc.a
-rw-r--r--1 root root  178 mar  6 15:05 /usr/lib/libc.so
Configure command: ./configure '--disable-shared' '--with-mysqld-ldflags=-all-static' 
'--with-client-ldflags=-all-static' '--without-berkeley-db' '--without-innodb' 
'--enable-assembler' '--enable-local-infile' '--with-mysqld-user=mysql' 
'--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--prefix=/' 
'--with-extra-charsets=complex' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' 
'--sysconfdir=/etc' '--datadir=/usr/share' '--localstatedir=/var/lib/mysql' 
'--infodir=/usr/share/info' '--includedir=/usr/include' '--mandir=/usr/share/man' 
'--with-comment=Official MySQL RPM' 'CC=gcc' 'CFLAGS=-O6 -fno-omit-frame-pointer 
-mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer   -felide-constructors 
-fno-exceptions -fno-rtti -mpentium' 'CXX=gcc'

my.cnf: 
[mysqld]
datadir=/var/lib/mysql
#log-bin
server-id=84
binlog-ignore-db=mysql
innodb_data_file_path = ibdata1:1000M
set-variable = innodb_mirrored_log_groups=1
innodb_data_home_dir = /var/lib/mysql/innodb
innodb_log_group_home_dir = /var/lib/mysql/innodb/logs
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=30M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
innodb_log_arch_dir = /var/lib/mysql/innodb/logs
innodb_log_archive=0
set-variable = innodb_buffer_pool_size=250M
set-variable = innodb_additional_mem_pool_size=10M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



Re: Signal 11 shortly after upgrading to 4.0.12

2003-03-20 Thread Webmaster
The problem appears to be caused by inadvertently running 
mysql_convert_table_format on a database which had a few Berkeley DB 
tables. The other databases seem to work well. The comment given in 
http://www.mysql.com/doc/en/Upgrading-from-3.23.html about the use of 
the script should be more clear.

Carlos Amengual



-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


Load Data Infile problem.

2003-02-14 Thread Webmaster MBT
Hi List.

I have been working on a problem that is driving me crazy.

I have to create a process in which I upload some info to a table. Since I
have to add some different information to that table, I decided to do it
like this.

1.I create a temporary table copying the structure of my final table. I.E.
$query_temp_table=CREATE TEMPORARY TABLE tguias SELECT * FROM guias WHERE
1=0;
$temp_table=mysql_query($query_temp_table, $cosmo_logistic) or
die(mysql_error());
I do this in PHP.
It works fine It seems.
2. I populate the temporary table.
$query_populate_tguias=LOAD DATA LOCAL INFILE
'c:/cosmo/www/upload/guias.txt' INTO TABLE tguias FIELDS TERMINATED BY ','
ENCLOSED BY '\'
(cliente,asesora,extra1,peso,albaran,gerente,tipo,imprimir);
$populate_tguias=mysql_query($query_populate_tguias, $cosmo_logistic) or
die(mysql_error());
3. Then I pass the information along with some other variables to the real
table.
mysql_select_db($database_cosmo_logistic, $cosmo_logistic);
$query_poblar = SELECT * FROM tguias;
$poblar = mysql_query($query_poblar, $cosmo_logistic) or die(mysql_error());
$row_poblar= mysql_fetch_assoc($poblar);
$totalRows_poblar= mysql_num_rows($poblar);
   do { 
mysql_select_db($database_cosmo_logistic, $cosmo_logistic);
$query_poblar_guias=INSERT INTO guias
(cliente,asesora,peso,albaran,gerente,tipo,imprimir,manifiesto,Status)
VALUES
(\.$row_poblar['cliente'].\,\.$row_poblar['asesora'].\,.$row_poblar
['peso'].,\.$row_poblar['albaran'].\,\.$row_poblar['gerente'].\,\
.$row_poblar['tipo'].\,.$row_poblar['imprimir'].,\.$manifiesto.\,\A
\);
$poblar_guias=mysql_query($query_poblar_guias, $cosmo_logistic) or
die(No pude insertar el registro .mysql_error());
} while ($row_poblar=mysql_fetch_assoc($poblar));?

with this source file:
13DAN010,D79406,13DAN010, 1 ,20430002201,75301;753,PAQUETE,1
13DAN010,D55816,13DAN010, 1.32
,20430003101,100201;1002,PAQUETE,1

it Does not work at all. I wonder if it is because it has a . in the number
even as the field receiving it is a decimal(10,2) or if it is because in one
of the field I have ;. 

The thing is that it will import one, and skip one full record each time.
But the one it inserts, is correctly inserted with the ; and the decimal
point correct. Any idea why it might be pasing one row and adding one?

This is driving me crazy.

When I do this same procedure on another table with source code like: 
D79427,LOPEZ DURAN ELISA,ACUEDUCTO TARRAGONA 59,15,PASEOS DEL
BOSQUE,NAUCALPAN,53297, ,LOPEZ DURAN ELISA,,F,T

it Works correctly even as it has two false or true fields.







-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE : Dropping foreing key without losing data

2003-01-31 Thread Webmaster LLBfrance
Hello Zak,

Thanks for your response.
I try the way you told me, but it seems there is
another problem :
The old foreign keys always exist.
In consequence, there are double references.

How can i resolve that problem ?

Thanks in advance.

JeanClaude


-Message d'origine-
De : Zak Greant [mailto:[EMAIL PROTECTED]] 
Envoyé : jeudi 30 janvier 2003 23:16
À : Webmaster LLBfrance
Cc : [EMAIL PROTECTED]
Objet : Re: Dropping foreing key without losing data


On Thu, Jan 30, 2003 at 10:08:08AM +0100, Webmaster LLBfrance wrote:
 Hello,
 
 Can you tell me how to drop or desactivate a foreign key without 
 losing any data in SQL for MySQL 3.23.51 ?

  Hello JeanClaude,

  Unfortunately, foreign keys cannot currently be conveniently dropped.
  :( The InnoDB developer plans to implement this in the near future.

  The only option currently is to recreate the table structure, move the
  data into the new table, drop the old table and then rename the table.

  Cheers!
-- 
 Zak Greant [EMAIL PROTECTED] | MySQL Advocate |
http://zak.fooassociates.com

Developing Dynamic Web Applications with MySQL and PHP
  MySQL Training: San Francisco, February 03-07, 2003
  Visit http://mysql.com/training for more information

GNU/Free Software Foundation (http://www.gnu.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




Dropping foreing key without losing data

2003-01-30 Thread Webmaster LLBfrance
Hello,

Can you tell me how to drop or desactivate a foreign key without
losing any data in SQL for MySQL 3.23.51 ?

Thanks in advance.

JeanClaude


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




ÓòÃû×¢²á,ÐéÄâÖ÷»ú

2003-01-06 Thread webmaster

Ç×°®µÄÅóÓÑ£º
ÄúºÃ£¡
ÕâÊÇÀ´×ÔÏÃÃÅÍòά¿Æ¼¼·¢Õ¹ÓÐÏÞ¹«Ë¾µÄÎʺ¸ÐлÄúÊÕ¿´Õâ·âÓʼþ¡£ÎÒÃÇÕæ³ÏµÄÏ£
ÍûÄúÄܳÉΪÎÒÃÇÔÚ¹óµØÇøµÄÖØÒª»ï°é¡£ÎÒÃÇÊÇÒ»¼ÒÖÂÁ¦ÓÚ»¥ÁªÍøÐÅÏ¢·þÎñ¡¢µç×ÓÉÌÎñ·þ
ÎñºÍÆóÒµÓ¦Ó÷þÎñµÄ¸ßм¼ÊõÆóÒµ¡£ÎÒÃÇÓÐ×ŶàÄê´ÓʲÙ×÷ϵͳµÄ¾­Ñé,ÕâΪÎÒÃǺͿռä
Îȶ¨ÌṩÁ˱£Ö¤.ÎÒÃǵķþÎñ×ÚÖ¼ÊÇ:Îȶ¨Ñ¹µ¹Ò»ÇÐ!ÏêÇéÇëä¯ÀÀ:http://www.onway.net 
email:[EMAIL PROTECTED] лл£¡
¡¡ÎÒÃÇΪÄúÌṩµÄÒÔÏÂÍøÕ¾¿Õ¼ä¶¼¿ÉÖ§³ÖÊý¾Ý¿â£¨CGI¡¢PHP¡¢MYSQL¡¢SQL¡¢ACCESS¡¢AS
P¡¢JSP£©£¬È«ÃæÂú×ãÄúµÄÐèÇó¡£Õ⽫»áÊÇÄú³¬ÖµµÄÑ¡Ôñ¡£

 1¡¢30M¿Õ¼ä£«30MÆóÒµÓʾ֣«1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ240Ôª/Äꣻ
 2¡¢60M¿Õ¼ä£«60MÆóÒµÓʾ֣«1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ280Ôª/Äꣻ
 3¡¢120M¿Õ¼ä£«120MÆóÒµÓʾ֣«1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ330Ôª/Äꣻ
 4¡¢200M¿Õ¼ä£¨ÃÀ¹ú£©£«50¸öÓÊÏ䣫1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ880Ôª/Äê¡£

 ¡°Îȶ¨Ñ¹µ¹Ò»ÇС±ÊÇÈ«ÌåÍòάÈ˵ķþÎñ×ÚÖ¼£¬ÎÒÃÇÖ£ÖسÐŵ£º
 1¡¢ÍòάÖ÷»úÈ«²¿²ÉÓÃÔ­×°Dell PowerApp»¥ÁªÍøÓ¦Ó÷þÎñÆ÷£»
 2¡¢ÍòάÖ÷»úÈ«²¿°²×°Õý°æTurbolinux»òMicrosoft²Ù×÷ϵͳ£»
 3¡¢²ÉÓÃÊÀ½ç±ê×¼µÄSNMP½øÐÐ24x7x365 ϵͳ¼à²â£»
 4¡¢ÍòάÖ÷»ú¿Í»§Ò»¸öÔÂÄÚ¿ÉÎÞÌõ¼þÈ«¶îÍ˿ÆäËü°´Êµ¼ÊÓà¶îÍË¿î¡£


 ×££º¿ªÐÄ£¡Ë³Àû£¡

 ÏÃÃÅÍòά¿Æ¼¼·¢Õ¹ÓÐÏÞ¹«Ë¾
 µØÖ·£ºÏÃÃÅÊйúó´óÏÃ40²ã
 µç»°:0592-5819328¡¢5815780¡¢5814120
 ´«Õæ:0592-5888462























































---
·ÐµãȺ·¢Óʼþ,À´×ÔÈí¼þ¹¤³Ìר¼ÒÍø(http://www.21cmm.com)

½øCMMÍøУ(http://www.21cmm.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 : Optimizing

2002-12-31 Thread BPF Webmaster
The server is mainly a Web server (Linux RedHat 7.3, P3 1GHz, server
chipset, 500M) with CPU usage 5%

CPU states:  1.7% user,  0.3% system,  0.0% nice, 97.8% idle
Mem:   513900K av,  502676K used,   11224K free,   0K shrd,  114640K
buff
Swap:  522072K av,   0K used,  522072K free  321032K
cached

The used RAM moves from 470M tp 510M up and down.

---

my.cnf is very basic:

[root@webserv1 etc]# more my.cnf 
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-innodb
 
[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

---

From phpMmyAdmin SHOW STATUS I get:

Max_used_connections 9 

Other info sounds complicated but I could dump here.

---

SHOW VARIABLES

back_log 50 
basedir /usr/ 
bdb_cache_size 8388600 
bdb_log_buffer_size 32768 
bdb_home /var/lib/mysql/ 
bdb_max_lock 1 

How can I change bdb_home /var/lib/mysql/ to avoid link to
/home/database/ ? 

Then shall I have to changed datadir /var/lib/mysql/ as well? (I want my
DBs to be in /home/database/)

Also get:

max_allowed_packet 1048576 
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_max_extra_sort_file_size 256 
myisam_max_sort_file_size 2047 
myisam_recover_options 0 
myisam_sort_buffer_size 8388608 
net_buffer_length 16384 
net_read_timeout 30 
net_retry_count 10 
net_write_timeout 60 
open_files_limit 0 

---

In phpMyAdmin I saw an optimize table but don't find detail in the
doc...is it worth it?

---

I also find phpMyAdmin slow to display table content...

---

Any idea?

JM


-Original Message-
From: Simon Windsor [mailto:[EMAIL PROTECTED]] 
Sent: Monday, December 30, 2002 12:26 PM
To: MySQL
Subject: Re: Optimizing


Hi

What else is running on the machine ?

What processes are using the computers resources ? Use top to find out.

What are the memory parameters used in my.cnf ?

The answers to these questions will provide some helpfull answers to
your 
problem.

Simon

On Monday 30 Dec 2002 11:16 am, BPF Webmaster wrote:
 I migrated my site from a low end PC mutualized hosting to a brand new

 P3 1GHz 512M server I now manage myself. Unfortunately I found MySQL 
 slower now, the time for a PHP page is now about 6 seconds and was 
 about .6 before!!!

 I haven't done any optimization and the DB is the same, so the size 
 (about 10,000 records).

 The only 2 weaknesses I saw is that:
 1- I use a RedHat 7.3 RPM (haven't compiled myself)
 2- the database folder is on another partition linked from /var/... to

 /home/... but on the same disk (a fast 10Krpm UW-SCSI).

 What would you advise?

 JM

 An example at http://www.labdv.com/forum/index.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




temporary and merge tables

2002-12-30 Thread Webmaster (Corin Langosch)
Hi,

when trying to create a temporary table of type merge, mysql
2.23.53 fails with an error like this:
Can't find file: '#sql24b_776_0.MRG' (errno: 2)

when not using the temporary keyword, everything works fine.
so i assume this is a missing feature (not documented that this
is forbidden/not supported yet) or a bug.

Corin


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re[2]: temporary and merge tables

2002-12-30 Thread Webmaster (Corin Langosch)
Hi,

sorry, didn't look at the changelog... ;)
thanks!

corin

Monday, December 30, 2002, 9:29:12 AM, you wrote:
PD At 9:01 +0100 12/30/02, Webmaster (Corin Langosch) wrote:
Hi,

when trying to create a temporary table of type merge, mysql
2.23.53 fails with an error like this:
Can't find file: '#sql24b_776_0.MRG' (errno: 2)

when not using the temporary keyword, everything works fine.
so i assume this is a missing feature (not documented that this
is forbidden/not supported yet) or a bug.

PD Looks like it's documented to me:

PD http://www.mysql.com/doc/en/News-3.23.54.html


Corin


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Optimizing

2002-12-30 Thread BPF Webmaster
I migrated my site from a low end PC mutualized hosting to a brand new
P3 1GHz 512M server I now manage myself. Unfortunately I found MySQL
slower now, the time for a PHP page is now about 6 seconds and was about
.6 before!!!
 
I haven't done any optimization and the DB is the same, so the size
(about 10,000 records).
 
The only 2 weaknesses I saw is that:
1- I use a RedHat 7.3 RPM (haven't compiled myself)
2- the database folder is on another partition linked from /var/... to
/home/... but on the same disk (a fast 10Krpm UW-SCSI).
 
What would you advise?
 
JM
 
An example at http://www.labdv.com/forum/index.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




ÓòÃû×¢²á,ÐéÄâÖ÷»ú

2002-12-23 Thread webmaster

Ç×°®µÄÅóÓÑ£º
ÄúºÃ£¡
ÕâÊÇÀ´×ÔÏÃÃÅÍòά¿Æ¼¼·¢Õ¹ÓÐÏÞ¹«Ë¾µÄÎʺ¸ÐлÄúÊÕ¿´Õâ·âÓʼþ¡£ÎÒÃÇÕæ³ÏµÄÏ£
ÍûÄúÄܳÉΪÎÒÃÇÔÚ¹óµØÇøµÄÖØÒª»ï°é¡£ÎÒÃÇÊÇÒ»¼ÒÖÂÁ¦ÓÚ»¥ÁªÍøÐÅÏ¢·þÎñ¡¢µç×ÓÉÌÎñ·þ
ÎñºÍÆóÒµÓ¦Ó÷þÎñµÄ¸ßм¼ÊõÆóÒµ¡£ÎÒÃÇÓÐ×ŶàÄê´ÓʲÙ×÷ϵͳµÄ¾­Ñé,ÕâΪÎÒÃǺͿռä
Îȶ¨ÌṩÁ˱£Ö¤.ÎÒÃǵķþÎñ×ÚÖ¼ÊÇ:Îȶ¨Ñ¹µ¹Ò»ÇÐ!ÏêÇéÇëä¯ÀÀ:http://www.onway.net 
email:[EMAIL PROTECTED] лл£¡
¡¡ÎÒÃÇΪÄúÌṩµÄÒÔÏÂÍøÕ¾¿Õ¼ä¶¼¿ÉÖ§³ÖÊý¾Ý¿â£¨CGI¡¢PHP¡¢MYSQL¡¢SQL¡¢ACCESS¡¢AS
P¡¢JSP£©£¬È«ÃæÂú×ãÄúµÄÐèÇó¡£Õ⽫»áÊÇÄú³¬ÖµµÄÑ¡Ôñ¡£

 1¡¢30M¿Õ¼ä£«30MÆóÒµÓʾ֣«1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ240Ôª/Äꣻ
 2¡¢60M¿Õ¼ä£«60MÆóÒµÓʾ֣«1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ280Ôª/Äꣻ
 3¡¢120M¿Õ¼ä£«120MÆóÒµÓʾ֣«1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ330Ôª/Äꣻ
 4¡¢200M¿Õ¼ä£¨ÃÀ¹ú£©£«50¸öÓÊÏ䣫1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ880Ôª/Äê¡£

 ¡°Îȶ¨Ñ¹µ¹Ò»ÇС±ÊÇÈ«ÌåÍòάÈ˵ķþÎñ×ÚÖ¼£¬ÎÒÃÇÖ£ÖسÐŵ£º
 1¡¢ÍòάÖ÷»úÈ«²¿²ÉÓÃÔ­×°Dell PowerApp»¥ÁªÍøÓ¦Ó÷þÎñÆ÷£»
 2¡¢ÍòάÖ÷»úÈ«²¿°²×°Õý°æTurbolinux»òMicrosoft²Ù×÷ϵͳ£»
 3¡¢²ÉÓÃÊÀ½ç±ê×¼µÄSNMP½øÐÐ24x7x365 ϵͳ¼à²â£»
 4¡¢ÍòάÖ÷»ú¿Í»§Ò»¸öÔÂÄÚ¿ÉÎÞÌõ¼þÈ«¶îÍ˿ÆäËü°´Êµ¼ÊÓà¶îÍË¿î¡£


 ×££º¿ªÐÄ£¡Ë³Àû£¡

 ÏÃÃÅÍòά¿Æ¼¼·¢Õ¹ÓÐÏÞ¹«Ë¾
 µØÖ·£ºÏÃÃÅÊйúó´óÏÃ40²ã
 µç»°:0592-5819328¡¢5815780¡¢5814120
 ´«Õæ:0592-5888462
 



































---
·ÐµãȺ·¢Óʼþ,À´×ÔÈí¼þ¹¤³Ìר¼ÒÍø(http://www.21cmm.com)

½øCMMÍøУ(http://www.21cmm.com)£¬³ÉÏîÄ¿¹ÜÀíר¼Ò

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




MySQL on virtual hosting

2002-11-24 Thread Sweethome.co.il Webmaster
Dear list,

Does any of you guys operate a mysql server in virtual hosting environment?
I need some advice on tuning and restriction based on system resources.

My system is running RH7.2 , on an Intel based server, 2x1Ghz CPU's and 1 
giga of RAM.
I have 2 hd's in raid 1 mode (hardware). I currenly run MySQL 3.23.53

Here are few questions I have in mind, any other advice on keeping this 
system in a
sane state will be appreciated.

1. From the following, what would be the best OS to run MySQL as of today?
FreeBSD, Linux, OpenBSD

2. Is it possible to limit number of connections per user or database?
MySQL can eat pretty much resources, if webmasters write bad code, I need 
to restrict
them or charge extras for the usage as well as to protect the system 
against DOS attacks,
which in this case will need to exploit a bad script which accesses the 
database.
Restricting httpd connections is irrelevant here, so I must be able to 
control MySQL
connections.

3. A lot of ready scripts or novice webmasters know very well how to open a 
connection
but closing it... that's beyond them :) What is a sensible timeout and what 
exactly
is the parameter that can kill these connections?

4. If you run a similar system, what would be the most important parameters 
for load
tuning, and how would you set them?

Thanks for all answers,

		Justin Grindea	
		[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



Duplicate key delete record with same key

2002-11-21 Thread BPF Webmaster
Using PHP 4.2.3 with MySQL 3.23.52

Report:
---
- Table has 2 keys: 'account' as PRIMARY and 'id' as unique
- I make an SQL update on an existing a record with id=anid setting
id=anotherid but another record exists with id =anotherid
- The update is performed and the record already existing with
id=anotherid is deleted!!!

Expected behavior:
--
- Update failed with Duplicate key attempt message
I guess it's a bug, isn't it?

The workaround is very easy but I really guess the behavior is weird.

Greetings from France,
JM


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE : Duplicate key delete record with same key

2002-11-21 Thread BPF Webmaster
Sure: 

CREATE TABLE `reg_member` (
`account` bigint(20) NOT NULL auto_increment,
`userid` varchar(48) NOT NULL default 'Your name',
`uilogin` tinyint(4) NOT NULL default '0',
`id` varchar(48) NOT NULL default '',
`password` varchar(10) NOT NULL default '',
`joined` bigint(20) default NULL,
`expired` bigint(20) default NULL,
`status` varchar(20) NOT NULL default '',
PRIMARY KEY (`account`),
UNIQUE KEY `id` (`id`)
) TYPE=MyISAM

A+
JM

-Original Message-
From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, November 21, 2002 3:31 PM
To: BPF Webmaster; MySQL
Subject: Re: Duplicate key delete record with same key

Hi,

Could you give us SHOW CREATE TABLE your_table ?

Greetings from France too ;)
  Jocelyn

- Original Message -
From: BPF Webmaster [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Sent: Thursday, November 21, 2002 2:25 PM
Subject: Duplicate key delete record with same key


 Using PHP 4.2.3 with MySQL 3.23.52

 Report:
 ---
 - Table has 2 keys: 'account' as PRIMARY and 'id' as unique
 - I make an SQL update on an existing a record with id=anid setting 
 id=anotherid but another record exists with id =anotherid
 - The update is performed and the record already existing with 
 id=anotherid is deleted!!!

 Expected behavior:
 --
 - Update failed with Duplicate key attempt message
 I guess it's a bug, isn't it?

 The workaround is very easy but I really guess the behavior is weird.

 Greetings from France,
 JM


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 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 : RE : Duplicate key delete record with same key

2002-11-21 Thread BPF Webmaster
Victoria,

So I looked deeper in my PHP code (I wrote it in February 2002) and saw
I use a REPLACE statement:

class persistent
{
// put method to save properties into the DB
function put($thePrefix)
{
// job not done yet
$returnValue = FALSE;

// build table name and start the SQL REPLACE
statement
$sqlQuery = REPLACE INTO
.$thePrefix.get_class($this). SET ;

// build the SQL REPLACE query
foreach(get_object_vars($this) as
$property=$value)
{
$sqlQuery .= $property. ='.$value.',
;
}

// remove the ,  at the end of the string
$sqlQuery = substr($sqlQuery, 0,
strlen($sqlQuery)-2);

// connect to the DB, put the object and close
the DB
if( $dbLink = mysql_connect(DBHOST, DBUSER,
DBPASSWD) )
{
if( mysql_select_db(DBNAME, $dbLink) )
{ 
if( mysql_query($sqlQuery,
$dbLink) ) $returnValue = TRUE; // job done
}
}
mysql_close($dbLink);
return($returnValue);   // boolean

}

Etc

This is PHP object code to make my member profiles (PHP objects)
persistent in the DB. I use REPLACE so the member-put() method can be
used to create or store change on member profiles.

Therefore I looked at MySQL Manual:
http://www.mysql.com/doc/en/REPLACE.html#IDX1431

 REPLACE works exactly like INSERT, except that if an old record in
the table has the same value as a new record on a UNIQUE index or
PRIMARY KEY, the old record is deleted before the new record is
inserted. 

So the result was predictible, sorry having sollicited the list.

JM

-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, November 21, 2002 6:01 PM
To: [EMAIL PROTECTED]
Subject: re: RE : Duplicate key delete record with same key


BPF,
Thursday, November 21, 2002, 4:36:58 PM, you wrote:

BW CREATE TABLE `reg_member` (
BW `account` bigint(20) NOT NULL auto_increment,
BW `userid` varchar(48) NOT NULL default 'Your name', `uilogin` 
BW tinyint(4) NOT NULL default '0', `id` varchar(48) NOT NULL default 
BW '', `password` varchar(10) NOT NULL default '',
BW `joined` bigint(20) default NULL,
BW `expired` bigint(20) default NULL,
BW `status` varchar(20) NOT NULL default '',
BW PRIMARY KEY (`account`),
BW UNIQUE KEY `id` (`id`)
BW ) TYPE=MyISAM

I tested it with 3.23.53 and it worked fine for me:

mysql update `reg_member` set id=4 where id=2;
ERROR 1062: Duplicate entry '4' for key 2



-- 
For technical support contracts, goto
https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




MySQL Process ID Unix PID

2002-11-13 Thread Sweethome.co.il Webmaster
Hi,

Is there a way to compare between a  mysql process ID showed in top or ps
with a process ID from mysqladmin processlist ?

I'm asking this because we operate a mysql machine used for webhosting and
it has many users and many databases. If users do crazy stuff that result in
high usage of resources, we need to determine who is the user, which 
database is
it accessing and finally what script causes the problem.

Any ideas or utils/scripts for digging this info apreciated.

	Tnx.	
		Justin Grindea
		System Administrator
		SweetHome.co.il





-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



Crystal Reports MySQL

2002-10-15 Thread Webmaster MBTRADINGCO

Hi, does anyone knows if Cristal reports is a good reporter to make
reports out of MySQL, or does anyone knows a good reporter for PHP
MySQL?

Thanks

The Vampmaster



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

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: FLOAT EQUAL OPERATOR

2002-10-10 Thread WebMaster - Infotel Telematica S.r.l.

fuck you!
this is the four time!
can you say me before!

--
INFOTEL TELEMATICA Srl Tel 0541 775927 - Fax 0541 775933 Sede operativa :
Via Nuova Circonvallazione 57/c - 47900 Rimini (RN) Sede legale : Via
Mazzoni 38 - 47900 Rimini (RN) Internet : http://www.infotel.it e-mail :
[EMAIL PROTECTED] ---
---
- Original Message -
From: [EMAIL PROTECTED]
To: WebMaster - Infotel Telematica S.r.l. [EMAIL PROTECTED]
Sent: Wednesday, October 09, 2002 9:52 PM
Subject: Re: FLOAT EQUAL OPERATOR


 Your message cannot be posted to [EMAIL PROTECTED] because it did not
 follow the format expected by our spam/off-topic filter. To this list we
 accept only repeatable bugs reports, meaning that you can describe a
 set of steps we can follow to repeat the bug on our systems.

 If you are having problems with MySQL but are unable to provide the
required
 description, and have not purchased a support contract from MySQL AB,
 you should send your message to [EMAIL PROTECTED] and possibly one of
our
 knowledgable users or developers will help you. However, we do not
guarantee
 that every message on [EMAIL PROTECTED] will be answered. We can
afford
 to provide free code, but unfortunately, we cannot afford to provide
 guaranteed free support on top of that. We do, nevertheless, fix our bugs
 regardless of who reports them and whose systems they affect, and will
 investigate your problem if you can prove to us with a test case that the
 error is in our code and not yours.

 If you have purchased a support contract from MySQL AB, you should follow
 the standard support request procedure to report this problem. Support
 contracts are available at https://order.mysql.com/.

 If you are able to describe how we can repeat the problem, include the
string
 How-To-Repeat: in the body of your message, followed by the detailed
 description of what we need to do to make it happen, and our filter will
 accept your message. If you use mysqlbug script, which comes with the
MySQL
 distribution, to post the message, it will be automatically accepted.

 You have written the following:

 ---start of your  message
 MySQL don't detect the equal float numbers if aren't ineger, left float
 alwais greater then right float es. 1.1  1.1 = true.

 o mysqladmin version

 mysqladmin  Ver 8.21 Distrib 3.23.39, for slackware-linux-gnu on i386
 Copyright (C) 2000 MySQL AB  MySQL Finland AB  TCX DataKonsult AB
 This software comes with ABSOLUTELY NO WARRANTY. This is free software,
 and you are welcome to modify and redistribute it under the GPL license

 Server version  3.23.39-log
 Protocol version10
 Connection  Localhost via UNIX socket
 UNIX socket /var/run/mysql/mysql.sock
 Uptime: 14 days 16 hours 30 min 5 sec

 Threads: 1  Questions: 93427  Slow queries: 0  Opens: 658  Flush tables: 1
 Open tables: 64 Queries per second avg: 0.074

 o manufacturer and model of the machine
 hp netserver lc 2000

 o uname -a
 Linux intranet 2.2.19 #59 Wed Jun 20 21:47:29 PDT 2001 i686 unknown

 o top
   1:06pm  up 15 days, 29 min,  3 users,  load average: 0.14, 0.10, 0.13
 77 processes: 76 sleeping, 1 running, 0 zombie, 0 stopped
 CPU states:  2.4% user,  0.8% system,  0.0% nice,  0.7% idle
 Mem:   257412K av,  245084K used,   12328K free,  113944K shrd,   46844K
 buff
 Swap:  530104K av, 552K used,  529552K free  106924K
 cached

 o compiler
 gcc 2.95.3

 o problems with SELECT statements

 mysql SHOW VARIABLES;

+-+-
 --
--
 --+
 | Variable_name   | Value
 |

+-+-
 --
--
 --+
 | ansi_mode   | OFF

 |
 | back_log| 50
 |
 | basedir | /usr/
 |
 | 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 | 5
 |
 | datadir | /var/lib/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

using php to connect to a 2nd mySQL server

2002-10-09 Thread Webmaster

Hello all,

I am new to this list ... and hope to find an answer to a question
which has come up.

On the server for my websites at my ISP, a mySQL server is installed
to handle different customers' databases (1 database setup for each
customer)

Now, as I have a need for a mySQL server where I can create/delete
databases, my ISP agreed to install a 2nd mySQL server that can be
dedicated to my sole use ... but I am told it would run on a
different port number ... 

My question now is this: How can I tell a php script to not use the
standard mySQL server that exists on this server computer, but to use
the 2nd mySQL server that runs on the different port number ?  
Currently I use info set up in variables like this:

# MySQL database config stuff
$host=localhost;
$username=abcdefg;
$database=database;
$password=123456789;

Is it possible to add the port information somwhere? or does a php
connection always use the standard mySQL port settings?

Any help is greatly appreciated. Thanks!
 
God bless you with His grace and peace
Wolfgang Schneider

-- BibelCenter: http://www.bibelcenter.de/ - Come and See! 
-- Bookstore: http://www.worthy.net/BibelCenter/ - Great offers! Check it out!
-- email: mailto:[EMAIL PROTECTED] 
-- http://awesome.crossdaily.com/vote.php3?sid=952 -- Your Vote! 




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RV: off-topic informix to oracle.

2002-10-03 Thread Webmaster MBTRADINGCO


Sorry but I'm sure one of you guru's knows about the best software (ltl)
to migrate informix database to Oracle, I need to link then oracle to
MySQL, and then to report via crystal reports.

EJB



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




install mysql on osx 10.2

2002-10-01 Thread webmaster

Hi, I am looking for some help installing mysql
I have downloaded a copy and have it on my
desktop , and well I am sorta wondering where to
go from here. Because the instructions are too vague

for me, as a newbie to mysql

please assist   james


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE : How to see warning messages for load data infile

2002-09-30 Thread BPF Webmaster

Maybe try one line...

I got this tons of warnings this morning making an import from Excel.
But it was apparently successful...but all decimal value where store
truncated like 128.00 , the reason is I'm in France and Excel exports
decimal with coma 128,34 but MySQL expects 128.34 so I just replace all
, with . in my CSV file with Ultraedit.

Greetings,
JM

-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]] 
Sent: Monday, September 30, 2002 3:07 PM
To: [EMAIL PROTECTED]
Subject: re: How to see warning messages for load data infile


David,
Saturday, September 28, 2002, 2:37:00 AM, you wrote:

DY Hi all.  I'm trying to load a file into mysql using load data 
DY infile and got a ton of warnings.  Is there any way to see what the

DY warnings are?

MySQL doesn't store warnings anywhere.



-- 
For technical support contracts, goto
https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Îȶ¨Ñ¹µ¹Ò»ÇÐ---ÖÐСÆóÒµÉÏÍøµÄ¾ø¼Ñ·½°¸!

2002-08-15 Thread webmaster


Ç×°®µÄÅóÓÑ£º
ÄúºÃ£¡
ÕâÊÇÀ´×ÔÏÃÃÅÍòά¿Æ¼¼·¢Õ¹ÓÐÏÞ¹«Ë¾µÄÎʺò£¬¸ÐлÄúÊÕ¿´Õâ·âÓʼþ¡£Èç¹ûÄúÒÑÓС¢»òÕý×¼±¸½¨ÉèÍøÕ¾£¬
ÄÇôÇëÄú²Î¹ÛÒ»ÏÂÎÒÃǵÄÍøÕ¾http://www.onway.net£¬ÏàÐÅÄܶÔÄúÓÐËù°ïÖú¡£

ÎÒÃÇΪÄúÌṩµÄÒÔÏÂÍøÕ¾¿Õ¼ä¶¼¿ÉÖ§³ÖÊý¾Ý¿â£¨CGI¡¢PHP¡¢MYSQL¡¢SQL¡¢ACCESS¡¢ASP¡¢JSP£©£¬È«Ãæ
Âú×ãÄúµÄÐèÇó¡£Õ⽫»áÊÇÄú³¬ÖµµÄÑ¡Ôñ¡£

1¡¢30M¿Õ¼ä£«30MÆóÒµÓʾ֣«1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ240Ôª/Äꣻ
2¡¢60M¿Õ¼ä£«60MÆóÒµÓʾ֣«1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ280Ôª/Äꣻ
3¡¢120M¿Õ¼ä£«120MÆóÒµÓʾ֣«1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ330Ôª/Äꣻ
4¡¢200M¿Õ¼ä£¨ÃÀ¹ú£©£«50¸öÓÊÏ䣫1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ880Ôª/Äê¡£

¡°Îȶ¨Ñ¹µ¹Ò»ÇС±ÊÇÈ«ÌåÍòάÈ˵ķþÎñ×ÚÖ¼£¬ÎÒÃÇÖ£ÖسÐŵ£º
1¡¢ÍòάÖ÷»úÈ«²¿²ÉÓÃÔ­×°Dell PowerApp»¥ÁªÍøÓ¦Ó÷þÎñÆ÷£»
2¡¢ÍòάÖ÷»úÈ«²¿°²×°Õý°æTurbolinux»òMicrosoft²Ù×÷ϵͳ£»
3¡¢²ÉÓÃÊÀ½ç±ê×¼µÄSNMP½øÐÐ24x7x365 ϵͳ¼à²â£»
4¡¢ÍòάÖ÷»ú¿Í»§Ò»¸öÔÂÄÚ¿ÉÎÞÌõ¼þÈ«¶îÍ˿ÆäËü°´Êµ¼ÊÓà¶îÍË¿î¡£

ÏêÇéÇëä¯ÀÀ£ºhttp://www.onway.net ÁªÏµemail:[EMAIL PROTECTED] лл£¡

×££º¿ªÐÄ£¡Ë³Àû£¡

ÏÃÃÅÍòά¿Æ¼¼·¢Õ¹ÓÐÏÞ¹«Ë¾
µØÖ·£ºÏÃÃÅÊйúó´óÏÃ40²ã 
µç»°:0592-5819328¡¢5815780¡¢5814120
´«Õæ:0592-5888462





































































---
·ÐµãȺ·¢Óʼþ,À´×ÔÈí¼þ¹¤³Ìר¼ÒÍø(http://www.21cmm.com)

½øCMMÍøУ(http://www.21cmm.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




Îȶ¨Ñ¹µ¹Ò»ÇÐ---ÖÐСÆóÒµÉÏÍøµÄ¾ø¼Ñ·½°¸!

2002-07-26 Thread webmaster


Ç×°®µÄÅóÓÑ£º
ÄúºÃ£¡
ÕâÊÇÀ´×ÔÏÃÃÅÍòά¿Æ¼¼·¢Õ¹ÓÐÏÞ¹«Ë¾µÄÎʺò£¬¸ÐлÄúÊÕ¿´Õâ·âÓʼþ¡£Èç¹ûÄúÒÑÓС¢»òÕý×¼±¸½¨ÉèÍøÕ¾£¬
ÄÇôÇëÄú²Î¹ÛÒ»ÏÂÎÒÃǵÄÍøÕ¾http://www.onway.net£¬ÏàÐÅÄܶÔÄúÓÐËù°ïÖú¡£

ÎÒÃÇΪÄúÌṩµÄÒÔÏÂÍøÕ¾¿Õ¼ä¶¼¿ÉÖ§³ÖÊý¾Ý¿â£¨CGI¡¢PHP¡¢MYSQL¡¢SQL¡¢ACCESS¡¢ASP¡¢JSP£©£¬È«Ãæ
Âú×ãÄúµÄÐèÇó¡£Õ⽫»áÊÇÄú³¬ÖµµÄÑ¡Ôñ¡£

1¡¢30M¿Õ¼ä£«30MÆóÒµÓʾ֣«1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ240Ôª/Äꣻ
2¡¢60M¿Õ¼ä£«60MÆóÒµÓʾ֣«1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ280Ôª/Äꣻ
3¡¢120M¿Õ¼ä£«120MÆóÒµÓʾ֣«1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ330Ôª/Äꣻ
4¡¢200M¿Õ¼ä£¨ÃÀ¹ú£©£«50¸öÓÊÏ䣫1¸ö¹ú¼ÊÓòÃû£¬¹¦ÄÜÈ«Ã棬½öÊÛ880Ôª/Äê¡£

¡°Îȶ¨Ñ¹µ¹Ò»ÇС±ÊÇÈ«ÌåÍòάÈ˵ķþÎñ×ÚÖ¼£¬ÎÒÃÇÖ£ÖسÐŵ£º
1¡¢ÍòάÖ÷»úÈ«²¿²ÉÓÃÔ­×°Dell PowerApp»¥ÁªÍøÓ¦Ó÷þÎñÆ÷£»
2¡¢ÍòάÖ÷»úÈ«²¿°²×°Õý°æTurbolinux»òMicrosoft²Ù×÷ϵͳ£»
3¡¢²ÉÓÃÊÀ½ç±ê×¼µÄSNMP½øÐÐ24x7x365 ϵͳ¼à²â£»
4¡¢ÍòάÖ÷»ú¿Í»§Ò»¸öÔÂÄÚ¿ÉÎÞÌõ¼þÈ«¶îÍ˿ÆäËü°´Êµ¼ÊÓà¶îÍË¿î¡£

ÏêÇéÇëä¯ÀÀ£ºhttp://www.onway.net ÁªÏµemail:[EMAIL PROTECTED] лл£¡

×££º¿ªÐÄ£¡Ë³Àû£¡

ÏÃÃÅÍòά¿Æ¼¼·¢Õ¹ÓÐÏÞ¹«Ë¾
µØÖ·£ºÏÃÃÅÊйúó´óÏÃ40²ã 
µç»°:0592-5819328¡¢5815780¡¢5814120
´«Õæ:0592-5888462
















































































---
·ÐµãȺ·¢Óʼþ,À´×ÔÈí¼þ¹¤³Ìר¼ÒÍø(http://www.21cmm.com)

½øCMMÍøУ(http://www.21cmm.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




MAX_ROWS

2002-06-18 Thread Aborla.net - webmaster

Hello,

I created a table using:
CREATE TABLE a (pa VARCHAR (255) NOT NULL, pi VARCHAR (255), PRIMARY KEY
(pa)) TYPE=HEAP MAX_ROWS=10

Then I inserted 16 recors. Later I done SELECT * FFROM a and mysql returned
16 records. Why this??? Does i should return only the last 10 records I
inserted???

Please help me


Nuno Lopes




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




HEAP tables

2002-06-16 Thread Aborla.net - webmaster

Hello everybody,

I have two questions:
1) If I create a table with MAX_ROWS=10 and I insert 10 records. Then I
insert more 3 records. Does mysql delete older records and insert new ones??

2) I created a table using this:
CREATE TABLE a (pa VARCHAR (255) NOT NULL, pi VARCHAR (255), PRIMARY KEY
(pa)) TYPE=HEAP MAX_ROWS=10

Then I have 16 (SIXTEEN) records. Why this. I think the max rows is
10?!?!?!?

Can anybody help me???


Thanking in advance,
Nuno Lopes




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Need some direction please

2002-05-20 Thread Webmaster

Here's my dilema. Our website runs a quarterly prize giveaway. Currently
we have an ASP form that gathers the inputed info into a database and
then sends us an e-mail confirmation of the entry. Our rules
specifically state that only one entry is allowed per quarter. As I am
not a programmer (just a dabbler in programming) I have no idea on how
to do the following and need some help.

What we need is a script that will check our current database against an
e-mail, last name, and first name entry. If that entry is in our
database a message pops up telling them that they have already
registered with us. If there entry is not located in our database then
the new info passes along unhindered.

We are on a Cobalt RaQ4r with ChiliAsp 3.62 installed and are using
MySQL.

Thanks in advance for the help.

Sincerely,

Stephen M. LaBar, Jr.
(770) 381-3826
Computer Specialist

Please Visit Our Site At:
http://www.csi-atl.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: Re: mysql uses 99% cpu under freebsd 4.3

2002-05-13 Thread webmaster

 So far I've experienced it on one SMP box and one single CPU box.  I
 
 Silly question: what is SMP...?

 Best regards,=20
 Eivind :-)


sql, query


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Maximum number of rows in the table

2002-05-07 Thread webmaster

 I don't think there is a limit.
 Just as long as your harddisk can contain the data there should be no
 problem.

Yes, I guess this should be the case.
Theoretically, though; the limit would be the number of indexable rows, wouldn't it?
Since the integer length used to store this is 11 digits, this would amount to 10^11 = 
100 000 000 000...
Although probably not practially achievable; at least its quite far from 1500...

Best regards, 

Eivind :-)


mysql, 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




MySQL performance issues - PLEASE ADVICE!!

2002-05-07 Thread webmaster

I am having performance problems with my MySQL installation - what would be an 
appropriate channel for requesting help to such a problem?
I have posted to this list twice and another one as well. Volumes are very high on 
using MySQL/standard SQL questions, but not an single suggestion has been submitted to 
my request. 
Is the only valid alternative to go for an annual support deal with MySQL.org? My site 
can't afford that. Lots of enthusiastic 'community' members will be disappointed if it 
should go down because I cant afford proper support. 
Please respond if you have any suggestion where it might be wise to direct my request!

All the best; 

Eivind :-)



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Using RAND()

2002-05-07 Thread webmaster

Hi

When I used the RAND() function (MySQL 3.23.45) I found the results were not
very random, instead I use an extra bit of php code to make sure the results
are more random.

mt_srand((double)microtime()*100);
$sql = select  order by RAND(.mt_rand(0,32767).) limit 50
$rs = mysql_query($sql);
$num=mysql_num_rows($rs);
if($num1) mysql_data_seek($rs,mt_rand(0,$num-1));
$row=mysql_fetch_array($rs);

To get a random record from earlier versions of MySQL you could do something
like this.

mt_srand((double)microtime()*100);
$sql = select... ..where  limit 0,50
$rs = mysql_query($sql);
$num=mysql_num_rows($rs);
if($num1) mysql_data_seek($rs,mt_rand(0,$num-1));
$row=mysql_fetch_array($rs);

if you have a lot of records you can always put random numbers in the limit
clause,  (select ... where ...limit  random_number, random_number + 50) this
will return a random block of records, then use the seek functions to
randomly pick a record from the record block, just make sure random_number
isn't greater than the total records in your recordset.


Pete Kelly


- Original Message -
From: Gurhan Ozen [EMAIL PROTECTED]
To: Cummings, Shawn (GNAPs) [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, May 07, 2002 5:11 PM
Subject: RE: Using RAND()


 You have to have MySQL 3.23 or greater..

 http://www.mysql.com/doc/M/a/Mathematical_functions.html

 Gurhan

 -Original Message-
 From: Cummings, Shawn (GNAPs) [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, May 07, 2002 11:33 AM
 To: [EMAIL PROTECTED]; Ulf Harnhammar
 Cc: [EMAIL PROTECTED]
 Subject: Using RAND()




 The RAND() syntax does not appear to be working for me.

 What version mySQL is required?


 At 04:43 PM 1/29/2002 +0200, Michael Widenius wrote:

 Hi!
 
   Ulf == Ulf Harnhammar [EMAIL PROTECTED] writes:
 
 Ulf On Sun, 27 Jan 2002, Michael Widenius wrote:
   One way to do this is to do as follows:
   SELECT something FROM sometable WHERE somevar=somevalue ORDER BY
   RAND() LIMIT 10


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 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




Problems with MySQL on FreeBSD4.5

2002-05-03 Thread webmaster

(Sorry if I am reposting this now, guys...ehe)


I'm having trouble with a MySQL installation on a FreeBSD4.5 system (MYSQL version 
3.23.49).
From time to time top shows that it runs 98% of CPU time, and of course the site's 
response gets sluggish...
Sometimes queries even times out or MySQL reports that no sockects are free to 
complete the request. 
This actually does not happen anymore, but it did a few times earlier...short time 
after we had a disk crash... ;-)

I had a comment from one of the users regarding this:

I seriously suspect that mySQL under FreeBSD is your problem. On another heavily 
loaded website I use (www.perlmonks.org), we're experiencing similiar problems. 
Current speculation is that it has to do with the way the FreeBSD flock() function is 
broken. 
I imagine what you're seeing is lots of blocked mySQL processes, or where a query 
takes an exceptionally long time to complete. CPU utilization is remaining pretty 
low during the event.

Just want to know if anybody has something to say to this matter, perhaps suggestions 
on where to start for debugging the problem?
I have no clue where to begin looking for reasons, so any tip could very well be a 
good tip for me right now!
Debugging tools or approaches to recommend...? Anybody?

Best regards, 

Eivind, [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




Problems with MySQL on FreeBSD4.5

2002-05-02 Thread webmaster

I'm having trouble with a MySQL installation on a FreeBSD4.5 system (MYSQL version 
3.23.49).
From time to time top shows that it runs 98% of CPU time, and of course the site's 
response gets sluggish...
Sometimes queries even times out or MySQL reports that no sockects are free to 
complete the request. 
This actually does not happen anymore, but it did a few times earlier...short time 
after we had a disk crash... ;-)

I had a comment from one of the users regarding this:

I seriously suspect that mySQL under FreeBSD is your problem. On another heavily 
loaded website I use (www.perlmonks.org), we're experiencing similiar problems. 
Current speculation is that it has to do with the way the FreeBSD flock() function is 
broken. 
I imagine what you're seeing is lots of blocked mySQL processes, or where a query 
takes an exceptionally long time to complete. CPU utilization is remaining pretty 
low during the event.

Just want to know if anybody has something to say to this matter, perhaps suggestions 
on where to start for debugging the problem?
I have no clue where to begin looking for reasons, so any tip could very well be a 
good tip for me right now!
Debugging tools or approaches to recommend...? Anybody?

Best regards, 

Eivind, [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




Sorts

2002-04-29 Thread webmaster

Hi List,

If I run the sql query SHOW STATUS how can I tell how many queries required
sorting?

Here are some of the variables SHOW STATUS returns

Questions  6623371
Sort_merge_passes  357
Sort_range  29213
Sort_rows  11271509
Sort_scan  231944


I want to try and calculate the percentage of sorts that required more than
one pass!!


Any help would be welcome.
Thanks
Peter Kelly


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: general query

2002-04-29 Thread webmaster

Hi

We say MySQL is open source database, so it can easily be adjusted to your
requirements. But I wonder how many administrators have actually gone into
the source code and made any modifications to match their specific needs, if
any. 

The point is you can make modifications if you want to, try making
modifications to Microsoft SQL server source code, and because you have the
source code you can compile the software to suit your own needs, try doing
that with a commercial database product.


If no, then why is MySQL better than other databases available in market,
if we leave the cost alone.

Commercial databases get updated by a limited number of programmers once per
year if your lucky, opensource projects get updated many times per year by
an unlimited about of programmers. If you find a bug in MySql you have the
choice to fix the bug yourself and have your bug fix included in the
release software. If you find a bug in say Microsoft SQL server all you can
do is report the bug to Microsoft and hope they fix it, then to get a copy
of the bug fixed software you will have to buy a new version of the
software.


I do not intend to challenge MySQL, but just wanted to know how this elite
group can help someone if such a need arises !!

This is not an elite group, its just normal people helping each other out,
if you have a problem people will try to help you if they can, opensource is
all about community sprit and not just about dollars in pockets.


Peter Kelly - A Happy MySql  User.
http://www.TrafficG.com





- Original Message -
From: Paras Mukadam [EMAIL PROTECTED]
To: MySQL 
Sent: Monday, April 29, 2002 1:58 PM
Subject: general query


 Hi Guru's,

 We say MySQL is open source database, so it can easily be adjusted to your
 requirements. But I wonder how many administrators have actually gone into
 the source code and made any modifications to match their specific needs,
if
 any. If no, then why is MySQL better than other databases available in
 market, if we leave the cost alone.
 I do not intend to challenge MySQL, but just wanted to know how this elite
 group can help someone if such a need arises !! Has anyone other than the
 core development team tried any changes before ??

 With regards,
 Paras


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 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: What is `Aborted Clients` ?

2002-04-29 Thread webmaster

Hi


Can anyone explain me what is an Aborted Client ? I begin to wonder about
this because this number was about 20 or 30 last week, and now suddenly it
got above 200 ! I have no idea of what it means, so any help would be
appreciated.


This is incremented if one of the following has happened:

The client program did not call mysql_close() before exit.
The client had been sleeping more than wait_timeout or interactive_timeout
without doing any requests.
The client program ended abruptly in the middle of the transfer.



Peter Kelly
http://www.TrafficG.com





- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: João Paulo Vasconcellos [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, April 29, 2002 7:31 PM
Subject: Re: What is `Aborted Clients` ?


 On Mon, Apr 29, 2002 at 02:52:16PM -0300, João Paulo Vasconcellos wrote:
  Hello Everybody,
 
can anyone explain me what is an Aborted Client ? I begin to
  wonder about this because this number was about 20 or 30 last week,
  and now suddenly it got above 200 ! I have no idea of what it means,
  so any help would be appreciated.

 I believe that's the message generated when a client disconnects
 abnormally.
 --
 Jeremy D. Zawodny, [EMAIL PROTECTED]
 Technical Yahoo - Yahoo Finance
 Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936

 MySQL 3.23.47-max: up 81 days, processed 2,094,002,365 queries (298/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






-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

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 first or last row

2002-04-20 Thread webmaster

Hi

MySql Details  My server is running MySQL 3.23.45 and I have
4.0.0-alpha-nt on my local test machine.



What is the fastest way to select the first or the last row from a database?

I have tried queries like this

(id is an auto incrementing primary key)
select * from names order by id desc limit 1
select * from names order by id asc limit 1
select * from names limit 1


if I run the following sql queries with the explain command it returns the
following results


table type possible_keys key key_len ref rows Extra
-  - --- --- ---  -
names index NULL PRIMARY 4 NULL 61368
*

No matter what I do, and what indexes I use, I cannot seem to find a way of
selecting the last or first row without scanning the whole table.


A few times recently I've wished for a new table type, a table that acts
more like a pipe or stack just to solve this problem.

Thanks
Pete Kelly


Other Items on my MySql wish list.

1 . It would also be nice to combine a select and a delete command together
to form a whole new command, (Retrive data and auto delete the row)
2 . Another new command I would like to see is Show Processlist History,
basically this would show the last 30 or so queries run on the server.
3. I often run queries like this

SELECT id FROM users WHERE name = 'pete'
if the row exists
UPDATE users SET visits=visits+1 WHERE name = 'pete'
else
INSERT INTO users (name) VALUES ('pete')

It would be nice to make this type of code quicker.









-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: ADO API ODBC Alternative help

2002-03-13 Thread webmaster

Hi!

Check the MySQL with ASP Forum at www.dwam.net/mysql/
in particular a thread called Multiple Step Error

You can also find working ADO code samples on the site (using AddNew method)

Finally you should consider using the latest MyODBC drivers
2.50.39 if you want to stick to 2.xx version
3.51.02 recommended for ADO support

/  D W A M   W 3   S P A C E  /
Guillaume de Lafontaine - [EMAIL PROTECTED]
. Services Internet : http://www.w3space.com
. Annuaire Aquitaine : http://www.aquitanet.com
. Espace TeleTravail : http://www.w3workers.com
. DWAM.NT Docs  Resources : http://www.dwam.net
  
-Message d'origine-
De : Kelvin Lam [EMAIL PROTECTED]
À : [EMAIL PROTECTED] [EMAIL PROTECTED]; [EMAIL PROTECTED] 
[EMAIL PROTECTED]
Date : mercredi 13 mars 2002 23:13
Objet : ADO API  ODBC Alternative help


|Hi,
|
|I am a beginner developer trying to use mySQL ODBC with ADO.  I am using ADO
|library version 2.5, and Visual Basic 5.0/6.0 (doesn't really matter).
|
|Here is my configuration:
|- mySQL ODBC Version 02.50.38
|- mySQL server Version 02.50.38
|- Windows NT 4.0 with SP6
|
|It seems like, mySQL does not implement all the ADO functionality.  My
|questions will be:
|1- what is the set of functions in ADO that mySQL supports?  Can I find
|documentation about it?
|2- If ADO is not fully supported, what other ways have people used for
|database programming?  DAO?  RDO?  Raw ODBC API call?
|
|Now for the specific problem I have, I have this code in VB:
|rsTest.AddNew
|rsTest.Fields(login).Value = CStr(kelvin)
|rsTest.Update
|rsTest.Fields(Password).Value = CStr(testing)
|rsTest.Update
|rsTest.Fields(Fullname).Value = CStr(my name)
|rsTest.Update
|rsTest.Fields(securitylevel).Value = 1
|rsTest.Update
|
|- I get an adStateOpen for both connection and recordset.
|- The ADO connection opened correctly.  The ADO recordset opened correctly
|as well.
|- The AddNew executed without error.
|- The setting of login value executed without error.
|- When I hit the line setting value of password, I get the following
|message:
|Run-time error '-2147217887 (80040e21)':
|Multiple-step operation generated errors.  Check each status value.
|
|What did I do wrong?
|
|
|
|
|Kelvin Lam
|Software Engineer
|Orbit Technology Corp
|1528 Brookhollow Dr, Suite 66
|Santa Ana, CA 92705
|Phone: (714)427-0555
|Fax: (714)427-0556
|
|
|
|-
|Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before
|posting. To request this thread, e-mail [EMAIL PROTECTED]
|
|To unsubscribe, send a message to the address shown in the
|List-Unsubscribe header of this message. If you cannot see it,
|e-mail [EMAIL PROTECTED] instead.
|


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




update a row without affecting timestamp-type column

2002-01-25 Thread webmaster

Hello all,

I have a question which just may very well be ridiculous.  In one table,
we have a column of type timestamp.  In normal cases, we want any changes
to this row to update this timestamp (hence the nature of this datatype).
 However, there is one case where we do NOT want the timestamp to update
if we make a change to some data in that row.

Is there any way to temporarily avoid updating a timestamp type?

Thanks for your time.

-Ian




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Hoe to create indexes on existing tables

2002-01-24 Thread webmaster



|Hi,
|
|I'm a bit to Mysql. We are trying to use mysql as a backend for our Visual
|Basic application.
|
|I had a set of tables which I exported from Access database.
|But now, I want to index these tables. How do I go about that?
|



Hi!

the simplest solution is to get a GUI client for MySQL, in which indexing or any other 
operation are as easy to do as with Access...
The most famous GUIs are : MASCON, MySQLFront, MySQLGui, DBTools...
Otherwise, you can still use the CREATE INDEX clause with commandlines. Check the doc 
it is very well explained...

All urls for GUIs at www.mysql.com or www.dwam.net/mysql/ 

|
|Also, any suggestions of how cursors work with mysql would be of great
|help.
|


Quite the same as for Access, and the next release of MyODBC (announced for this month 
end) should provide full compatibility with ADO.


/  D W A M   W 3   S P A C E  /
Guillaume de Lafontaine - [EMAIL PROTECTED]
. Services Internet : http://www.w3space.com
. Annuaire Aquitaine : http://www.aquitanet.com
. Espace TeleTravail : http://www.w3workers.com
. DWAM.NT Docs  Resources : http://www.dwam.net
  


|Thanks a lot
|
|Princy.
|
|
|-
|Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before
|posting. To request this thread, e-mail [EMAIL PROTECTED]
|
|To unsubscribe, send a message to the address shown in the
|List-Unsubscribe header of this message. If you cannot see it,
|e-mail [EMAIL PROTECTED] instead.
|


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

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 tables via cron

2002-01-03 Thread Webmaster

I tried to search the archives for this but I can't find it.  (Not saying 
it isn't there just I could not find it.)  I have a table that tracks 
events on a monthly and daily basis.  Currently I am resetting the 
appropriate fields to 0 on a daily and monthly basis (not fun).  Is there a 
way to set a command in the cron table to do this for me 
automatically?  Here are the details.

db name: activity
daily field name: dr (needs to be reset to 0)
monthly field name: mr (same as above)


I know how to tell cron the date/time I want an event to trigger, but I 
don't know the syntax of the command to send.  Any help would be appreciated.


Thanks,
David



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Need Help bad!.. today.. of all days!

2001-12-25 Thread Webmaster

Hello.. of all days i have a project thats to be shown tomorrow.

i cannot get the dam thing to work
it should be simple i'd think

i would post code and all and if asked will

but it comes down to this.. i am using php 4 and mysql.. and doing math
i have say 40 entries in the database, 20 for two differant surveys.. anytime anew 
person fills out the survey they get a unique id
i have it set to grabe the results from each unigue id for each question through 
mysql.. but it seems to stop shot about 4 questions..
i even tried dropped the while loop 4 questions shorter -4 and it still stop the 
same place.. of all days for this to occure.. i know
but if anyone has a clue please offer suggestions.. also plase cc [EMAIL PROTECTED] with 
your reply.. thanks

--
Your Guardian Angel... find out here http://www.angelhaven.com/aodmail/
Come Cruisin with the Angels http://www.AngelCruise.com
Sign up for your free AngelHaven E-mail Today http://www.angelhaven.com/mail/

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Need Help bad!.. today.. of all days!

2001-12-25 Thread Webmaster

the code is huge i'll post whats relevant. there may be a few irrelevant things in 
there... but hell... if your willing to look i'm willing to post

i know what works so will skip down lower to prevent wasting your time
and if ya could please cc your responce to [EMAIL PROTECTED], though if to much trouble 
i understand

i thought i was close.. but then compared the data and it doesnt match.. for instance 
its spitting out the right subcluters.. and untill i asked for the coomparison it was 
fine.. i cant do a percentage match or trial till it gives right info..



  while($i_sub$num_sub){
 $sub_id = 
@mysql_result($result_sub,$i_sub,subcluster_id);
 $result_per = 
mysql_query(select ques_ans from data_1 where ass_id=$ass_id AND user_id=$user_id AND 
subcluster_id='$sub_id',$db);
 $num_per = 
mysql_num_rows($result_per); 
 $i_per=0;   //this 
seems wrong but will count all subclusters equally 1 at a time through the while 
should
 $i_per1 = 0; // need 
a double count so need two seperate
 $cper = 0;
   
while($i_per$num_per){
// so we 
need to run the while, probably need to cut the ending out here to add to end of total
 //gonna 
change this into an include so its not listed 3 times here-maybe
  // do 
math function
 $nper = 
$num_per;
 $nper2 = 
($nper*5);  // max reading to devide by
 //answer 
= // need to add all the answers here
 
while($i_per1$num_per){
   
 $cper = $cper;
   
 $cper1 = @mysql_result($result_per,$i_per1,ques_ans);
   
 $i_per1++;
   
 $cper2 = @mysql_result($result_per,$i_per1,ques_ans);
   
 $cper = ($cper+$cper1+$cper2);
   
// $cper3 = $cper; // this is just an easy extraction
// i think this actualy might work

   echo 
sub=$sub_id = $cperp;
   
 $i_per1++;};  // this should loop through output to count the results total   
//TEST
//echo cper3 = $cper3;
   
 $i_per++;
 };
   $i_sub++;};

i know theres some redundant code in there etc.. but hey.. till it works i dont like 
to delete



-- Original Message --
From: Justin Farnsworth [EMAIL PROTECTED]
Date: Tue, 25 Dec 2001 09:28:53 -0500

I think you need to post the code.  The description of the
problem is a bit ambiguous.

_justin

Webmaster wrote:
 
 Hello.. of all days i have a project thats to be shown tomorrow.
 
 i cannot get the dam thing to work
 it should be simple i'd think
 
 i would post code and all and if asked will
 
 but it comes down to this.. i am using php 4 and mysql.. and doing math
 i have say 40 entries in the database, 20 for two differant surveys.. anytime anew 
person fills out the survey they get a unique id
 i have it set to grabe the results from each unigue id for each question through 
mysql.. but it seems to stop shot about 4 questions..
 i even tried dropped the while loop 4 questions shorter -4 and it still stop the 
same place.. of all days for this to occure.. i know
 but if anyone has a clue please offer suggestions.. also plase cc [EMAIL PROTECTED] 
with your reply.. thanks

Re: Need Help bad!.. today.. of all days!

2001-12-25 Thread Webmaster


hope you version came out better thn mine.. in my mail it was all out of shape.. maybe 
could attach a text file.. doubt the list allows that thoough alot dont

-- Original Message --
From: Webmaster [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date: Tue, 25 Dec 2001 09:53:50 -0500

the code is huge i'll post whats relevant. there may be a few irrelevant things 
in there... but hell... if your willing to look i'm willing to post

i know what works so will skip down lower to prevent wasting your time
and if ya could please cc your responce to [EMAIL PROTECTED], though if to much trouble 
i understand

i thought i was close.. but then compared the data and it doesnt match.. for instance 
its spitting out the right subcluters.. and untill i asked for the coomparison it was 
fine.. i cant do a percentage match or trial till it gives right info..



  while($i_sub$num_sub){
 $sub_id = 
@mysql_result($result_sub,$i_sub,subcluster_id);
$result_per = 
mysql_query(select ques_ans from data_1 where ass_id=$ass_id AND user_id=$user_id 
AND subcluster_id='$sub_id',$db);
 $num_per = 
mysql_num_rows($result_per); 
 $i_per=0;   //this 
seems wrong but will count all subclusters equally 1 at a time through the while 
should
 $i_per1 = 0; // need 
a double count so need two seperate
 $cper = 0;
   
while($i_per$num_per){
// so we 
need to run the while, probably need to cut the ending out here to add to end of total
 //gonna 
change this into an include so its not listed 3 times here-maybe
  // do 
math function
 $nper = 
$num_per;
 $nper2 = 
($nper*5);  // max reading to devide by
 //answer 
= // need to add all the answers here
 
while($i_per1$num_per){
  
  $cper = $cper;
  
  $cper1 = @mysql_result($result_per,$i_per1,ques_ans);
  
  $i_per1++;
  
  $cper2 = @mysql_result($result_per,$i_per1,ques_ans);
  
  $cper = ($cper+$cper1+$cper2);
  
 // $cper3 = $cper; // this is just an easy extraction
// i think this actualy might work

   echo 
sub=$sub_id = $cperp;
  
  $i_per1++;};  // this should loop through output to count the results total   
//TEST
//echo cper3 = $cper3;
   
 $i_per++;
 };
   $i_sub++;};

i know theres some redundant code in there etc.. but hey.. till it works i dont like 
to delete



-- Original Message --
From: Justin Farnsworth [EMAIL PROTECTED]
Date: Tue, 25 Dec 2001 09:28:53 -0500

I think you need to post the code.  The description of the
problem is a bit ambiguous.

_justin

Webmaster wrote:
 
 Hello.. of all days i have a project thats to be shown tomorrow.
 
 i cannot get the dam thing to work
 it should be simple i'd think
 
 i would post code and all and if asked will
 
 but it comes down to this.. i am using php 4 and mysql.. and doing math
 i have say 40 entries in the database, 20 for two differant surveys.. anytime anew 
person fills out the survey they get a unique id
 i have it set to grabe the results from each unigue id for each question through 
mysql.. but it seems

help please!-- i -hate imail! *l* which is why ask a cc to my reg account

2001-12-25 Thread Webmaster

Back | Next | Reply | Reply All | Forward | Delete | Move To  
database / sql/ mysql

  Message: 1 of 11122 Printable Version 

  From: [EMAIL PROTECTED]  Save Address 



  Date: 25 Dec 2001 15:14:07 -
  To: Webmaster [EMAIL PROTECTED]
  Subject: Re:  Re: Need Help bad!.. today.. of all days! 

  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: 


  brad.. no the site kicks ass.. 
  its also currently running another room thats a chat site that runs over 18,000 
people and
  i have no proplems ever with theem logining in or anything.. its nothing to do with 
that..
  it may be my math but i dont think so as i have done math 20 times tougher then this 
and
  the php ran it fine.. this is a simple draw out and count.. i dont get why it freaks
  unless i am missing something 


  -- Original Message -- 
  From: Brad Beaubien [EMAIL PROTECTED] 
  Date: Tue, 25 Dec 01 09:12:19 -0600 

  Hello.. of all days i have a project thats to be shown tomorrow. 
   
  i cannot get the dam thing to work 
  it should be simple i'd think 
   
  i would post code and all and if asked will 
   
  [snip] 
   
  Is the performance of your code data independent? 
  That is to say, if you remove the set of data where it stops, does it 
  stop there again? 
  Does the code stop in the same place with different data? 
   
  Brad 

--
Your Guardian Angel... find out here http://www.angelhaven.com/aodmail/
Come Cruisin with the Angels http://www.AngelCruise.com
Sign up for your free AngelHaven E-mail Today http://www.angelhaven.com/mail/

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




help bad

2001-12-25 Thread Webmaster

i went through my code 20 times.. hit the help sites and all to see if it was a linux 
problem or what..
i am running 4.05 php
2.23.37 mysql (i believe, been awhile sine i touched it *l*)
its definately 2.23 i can say
i even got the 2.1 gd installed with it thought took a week
still shows as 1.6 though so guess it doint matter. aint had time to play to see if it 
works better.. but wouldnt know cause never had time to  play with old gd
i do this crap for a living.. and why this is acting up i dont understand.. its a 
simple while loop that should count as it goes.. i am missing something dumb i guess.. 
just help if ya can.. and thaks if you even bother to look it over..


--
Your Guardian Angel... find out here http://www.angelhaven.com/aodmail/
Come Cruisin with the Angels http://www.AngelCruise.com
Sign up for your free AngelHaven E-mail Today http://www.angelhaven.com/mail/

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: help bad

2001-12-25 Thread Webmaster

i meant 3.23.. just so you all know

-- Original Message --
From: Webmaster [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date: Tue, 25 Dec 2001 10:26:50 -0500

i went through my code 20 times.. hit the help sites and all to see if it was a linux 
problem or what..
i am running 4.05 php
2.23.37 mysql (i believe, been awhile sine i touched it *l*)
its definately 2.23 i can say
i even got the 2.1 gd installed with it thought took a week
still shows as 1.6 though so guess it doint matter. aint had time to play to see if 
it works better.. but wouldnt know cause never had time to  play with old gd
i do this crap for a living.. and why this is acting up i dont understand.. its a 
simple while loop that should count as it goes.. i am missing something dumb i 
guess.. just help if ya can.. and thaks if you even bother to look it over..


--
Your Guardian Angel... find out here http://www.angelhaven.com/aodmail/
Come Cruisin with the Angels http://www.AngelCruise.com
Sign up for your free AngelHaven E-mail Today http://www.angelhaven.com/mail/

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



--
Your Guardian Angel... find out here http://www.angelhaven.com/aodmail/
Come Cruisin with the Angels http://www.AngelCruise.com
Sign up for your free AngelHaven E-mail Today http://www.angelhaven.com/mail/

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




html ina text feild

2001-11-30 Thread Webmaster

I've set up a database with a text feild and want to call that 
information with html code embeded into the text( eg. br). Do I need 
to change the type of field ?. At the moment the html code is being 
returned as plain text.



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Problem mysql installation

2001-10-29 Thread Webmaster

Hi all;

i have problem with mysql -3.23.42 installation on my freebsd 4.3-RELEASE,
when I execute a make
i get an error make: no target to make.

Thanks and have a great day!




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: ASP MySQL

2001-09-10 Thread Webmaster

YES!!!

I use ASP and MySQL... Works Great

(Win2K, IIS5.0)

John
(www.smalltownworld.com)

- Original Message -
From: L_U_I_Z [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, September 10, 2001 2:08 PM
Subject: ASP  MySQL


 I'm developing an application and I have to choose a good database
 server.

 I'm considering MS SQL Server and MySQL.
 I haven't heard very much about MySQL, but from I've read on the web I
 think MySQL is Unix/Linux orientated and works well with PHP.

 I'm going to use a NT platform, with the IIS as web server, and I
 wanted to use ASP. Does MySQL fit good with IIS and ASP?

 Thaks.

  ___
 Consigue tu e-mail gratuito TERRA.ES
  Haz clic en http://www.terra.es/correo/


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 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: Please Advice

2001-09-07 Thread Webmaster

I am using ASP and MySQL and am very happy with the performance!

If you are on a Windows box, and have IIS5, there is no reason not to use
ASP and the MySQL/MyODBC set up... it really does work well... (you could,
of course, install PHP on your Windows box... (www.php.net)... I do like
PHP... and use it in certain circumstances)... really, in my opinion, both
set-ups perform equally well... and it comes down to a C++ feel or a VB
feel when you are scripting...

John Shipp
SmallTownWorld.com


- Original Message -
From: Shaji Khan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, September 07, 2001 11:10 AM
Subject: Please Advice


 Hi, I am a newbie to MySql and I am planning to use MySql and PHP to
develop
 a shopping cart and other components of a full blown ecommerce site. Is
this
 a good choice for this kind of work or do you guys think some thing like
SQL
 Server and ASP is a better choice.

 Experienced users, please advice.

 Thanks for all the help.

 Khan

 _
 Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php






-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Can some PLEASE tell me what this error means

2001-09-07 Thread Webmaster

ASP question... not MySQL (if I understand correctly...)

But just do a replace...



variabletoinsert = replace(thevariablecomingin,',\')

INSERT INTO ASP (title, description, code, user, email, date_created) VALUES
('title', 'description', '  variabletoinsert  ', 'user', 'email', 'now')



you could write a quick function that you could call at will...

function fq(string)
fq = replace(string,',\')
end function


mystr = insert into asp (blah,blah,blah) values ('  fq(inblah)  ',' 
fq(inbalh)  ','  fq(inblah)  ')
conn.execute mystr



- Original Message -
From: Deryck Henson [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Sent: Friday, September 07, 2001 10:10 PM
Subject: Re: Can some PLEASE tell me what this error means


 Except the problem is, this is done through an Active Server Page (ASP).
 The user does the inserting, I just use variables and insert them.
 TRANSLATION::  I have no control over what goes in the database until it's
 there.  So how can it be changed in the connection or sending process?

 - Deryck H
 - http://www.comp-u-exchange.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




Missing libmysqlclient.so.6

2001-09-05 Thread Webmaster

Hi:

How I can install or copy mysqlclient.so.6 without reinstall??

I'm trying to execute PHP script (Phorummail) from shell, but I receive that
this lib is
missing.

[root@corotu docs]# ./phorummail
  php: error in loading shared libraries: libmysqlclient.so.6: cannot open
shared
  object file: No such file or directory


I have MySQL 3.27.23, PHP 4.0.6 and Red Hat Linux 6.0

Thanks for your help.

Peter Brumvig



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Drop Down Boxes

2001-08-28 Thread Webmaster Odell

HI
We are trying to populate a form drop down box (HTML) with a column from our
database. What is the query that will get us that without repeating the
items (in the 500 or so records this column has only 12 non-repeated items)

Thanks.

Kevin Pottie


Internet Designer
O'Dell Web Design
http://www.odellwebdesign.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




New member question

2001-08-04 Thread RCA Webmaster


I have just subscribed to this list, so forgive me if my question has been
answered many times before but I was not sure where else to find this
information.

I am new to mysql and am going to be using it on a website that I maintain.
My question is, is there a program/utility or easy way to convert an MS
Access database to mysql format?

Thanks,

Chris



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.265 / Virus Database: 137 - Release Date: 7/18/01


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Cobalt raq4 and mysql

2001-07-27 Thread webmaster

Hi all,

I'm looking for a beginners resource for working with Mysql on a raq4
linuxbox. Any suggestions?

 Bye, Patje...

Behandel mij met zachtheid, ik ben een overlevende van het vorige
millennium!
Handle with care, I'm a survivor of the previous millennium!



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

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 ROUND numbers

2001-07-25 Thread Arnab (WebMaster)


How to round the result number after the multiplication, 
below are the PHP codes, 

any help greatly appreciated  



?php 

If (@$rcurr ==) 
{ echo (); 

? 
?php 

while ( $row = mysql_fetch_array($result) ) 
{ echo(tr); 
echo(td . $row[Room_Category] . /td); 
echo(td . $row[Room_Size] . /td); 
echo(td align='right' . $row[xsp] . /td); 
echo(td align='right' . $row[xan] . /td); 
echo(/tr); 

} 
echo(/table); 

? 
?php 
} 
else 
{ 
? 
?php 
while ( $row = mysql_fetch_array($result) ) 

{ echo(tr); 
echo(td . $row[Room_Category] . /td); 
echo(td . $row[Room_Size] . /td); 
echo(td align='right' . $row[xsp]*$rcurr . /td); 
echo(td align='right' . $row[xan]*$rcurr . /td); 
echo(/tr); 

} 
echo(/table); 

} 


? 





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




How to round

2001-07-25 Thread Arnab (WebMaster)



How to round the result number after the multiplication, 
below are the PHP codes, 

any help greatly appreciated  



?php 

If (@$rcurr ==) 
{ echo (); 

? 
?php 

while ( $row = mysql_fetch_array($result) ) 
{ echo(tr); 
echo(td . $row[Room_Category] . /td); 
echo(td . $row[Room_Size] . /td); 
echo(td align='right' . $row[xsp] . /td); 
echo(td align='right' . $row[xan] . /td); 
echo(/tr); 

} 
echo(/table); 

? 
?php 
} 
else 
{ 
? 
?php 
while ( $row = mysql_fetch_array($result) ) 

{ echo(tr); 
echo(td . $row[Room_Category] . /td); 
echo(td . $row[Room_Size] . /td); 
echo(td align='right' . $row[xsp]*$rcurr . /td); 
echo(td align='right' . $row[xan]*$rcurr . /td); 
echo(/tr); 

} 
echo(/table); 

} 


? 




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




encrition /security

2001-07-14 Thread webmaster

I have a customer who needs to have a very secure site, more secure than 
usual, he thinks that having a secure server is not enough so what kind 
of security for his transactions can I offer him? we are not talking 
about money transfers, his bussines is not about money is about 
information, I need to implement for him a very secure way in wich the 
infromatino inserted in to a database  (oracle) be encripted, wheren can 
I get info about this= cheers

Ps my customer in in europe, cheers

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Challenging SQL Problem

2001-07-01 Thread PHP Webmaster

Hello, 

I am having a lot of trouble trying to find the best
way to write the SQL to do the following: 

I have a table called referrals. In this table I
have a column called ref. The data in the ref column

are of the form p/$promo_id/$date. An example would
be p/26/20010629 which says promotion number 29
occuring on June 29th 2001. 

My task is to find a way to do a group by of all the
promotion IDs within a certain date range. The
following code is INCORRECT (BETWEEN 'p/%/2001...' IS
NOT VALID), but gives a good picture of what I am
trying to do: 

SELECT ref,SUM(clicks) AS num_clicks FROM referrals
WHERE ref BETWEEN 'p/%/20010601' AND 'p/%/20010630'
GROUP BY ref

The code above is meant to do a group by of all the
clicks generated by each promotion occuring between
June 1 and June 30

I realize that I could hypothetically loop over each
promotional ID and do ref BETWEEN 'p/3/XXX' AND
'p/3/YYY',,p/888/XXX AND p/888/YYY', but this
method is very bad in performance when the promotion
IDS goes into the tens of thousands, so the GROUP BY
is important to keep for me.

Is there a way to account for the date range WITHOUT
having to create a new date column which copies the
date over from ref codes in the column ref? 

My Best Wishes.

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Clarification wanted

2001-06-04 Thread webmaster



Hi,

We are developing a portal which has pictures 
of machines in the form of HTML pages.
I want to know whether I can store HTML in Database 
 can I do search in the HTML pages stored.

Please let me know at the earliest.

Thanks in advance
Infiniti. Infotech India


Powered by MediaRing


setting an index

2001-05-25 Thread Webmaster

I'm not sure if an index would help me or not in this case.. and not
sure how to set one at creation. So I'll explain it all

My main select is 
select * from on_db where time$t_tim ORDER BY place DESC

I also run the query
select * from on_db where time$t_tim AND place='thisplace'

$t_tim is the current unix time -5 mins

the updates are simply
update on_db set time='$time',place='$place' where person='$person';

as you can see by the table below 'person' is the primary key so is
indexed
this table is updated nearly every second and 'time' is the unix time
input so is very possible to get same results so cannot make that unique
nor 'place' unique.. 

mysql describe on_db;
++--+--+-+-+---+
| Field  | Type | Null | Key | Default | Extra |
++--+--+-+-+---+
| person | char(50) |  | PRI | |   |
| time   | int(20)  |  | | 0   |   |
| place  | char(50) |  | | |   |
++--+--+-+-+---+
3 rows in set (0.02 sec)

this is the command i used to create the table;

CREATE TABLE on_db (
  person char(50) DEFAULT '' NOT NULL,
  time int(20) DEFAULT '0' NOT NULL,
  place char(50) DEFAULT '' NOT NULL,
  PRIMARY KEY (handle),
  UNIQUE id (handle)
);

what would be the syntax used to create indexes for time and place at
table creation?
I looked through the docs but it seemed a bit confussing and since this
is a production system i didnt want to just guess.

Also, will the index help or hurt since the time and place keys are
updated constantly
is there and advantage or do you think it would be a waste of time. The
table itself usually ends up with around 15,000 entries which constantly
update based on the person and the time and place they are. 

any thoughts are welcomed.

--
Sign up for your free AngelHaven E-mail Today...
Join the growing community, http://www.AngelHaven.com 
Come Cruisin with the Angels http://www.AngelCruise.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




sql manual

2001-05-22 Thread webmaster

is there any sql manaual over the internet0' no matter that is not a 
mysql specificly, I would like to have a good manual for beguiners, 
cheers 

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To 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 Problem

2001-05-14 Thread webmaster

Hi

Here is my my.cnf. pls suggest the changes to make the 
performance better. I am upgrading to the latest version.

===
# Example mysql config file.
# You can copy this to one of:
# /usr/local/mysql/etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /usr/local/mysql/var) or
# ~/.my.cnf to set user-specific options.
# 
# One can use all long options that the program supports.
# Run the program with --help to get a list of available options

# This will be passed to all mysql clients
[client]
#password   = my_password
port= 3306
socket  = /tmp/mysql.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# The MySQL server
[mysqld]
port= 3306
socket  = /tmp/mysql.sock
skip-locking
set-variable= key_buffer=8M
set-variable= back_log=25
set-variable= max_allowed_packet=1M
set-variable= thread_stack=128K
set-variable= max_connections=50
set-variable= table_cache=32
set-variable= sort_buffer=500K
set-variable= record_buffer=100K
set-variable= net_buffer=5K
# Start logging
log

[mysqldump]
quick
set-variable= max_allowed_packet=16M

[mysql]
no-auto-rehash

[isamchk]
set-variable= key_buffer=16M


=

with best wishes

Arun

Date sent:  Sun, 13 May 2001 18:41:50 -0700
From:   Jeremy Zawodny [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Copies to:  [EMAIL PROTECTED]
Subject:Re: Mysql Problem
Send reply to:  [EMAIL PROTECTED]

 On Fri, May 11, 2001 at 07:48:04PM +0530, [EMAIL PROTECTED] wrote:
  
  I am facing great problems beacuse of Mysql server which is not able
  to take load.
  
  My apache is working fine even when the load average shoots of to
  130 but my mysql server goes sleep when the load of apache shoots
  above 30. I am on a dedicated server.
  
  My Mysql Ver 3.22.32
 
 You may try upgrading to 3.23.xx. There were some performance
 improvements in the newer versions.
 
  I have red hat linux 6.2 as OS and memory of 256 MB .
  
  I am attaching my my.cnf file , pls look into it and suggest ways
  for improving my server performance.
 
 Attachements are filtered by this list, in case you didn't notice.
 
 Jeremy
 -- 
 Jeremy D. Zawodny, [EMAIL PROTECTED]
 Technical Yahoo - Yahoo Finance
 Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951
 
 MySQL 3.23.29: up 130 days, processed 804,119,056 queries (71/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




Mysql Problem

2001-05-11 Thread webmaster

Hi 

I am facing great problems beacuse of Mysql server which is not 
able to take load.

My apache is working fine even when the load average shoots of to 
130 
but my mysql server goes sleep when the load of apache shoots 
above 30. I am on a dedicated server.

My Mysql Ver 3.22.32

I have red hat linux 6.2 as OS and memory of 256 MB .

I am attaching my my.cnf file , pls look into it and suggest ways for 
improving my server performance.

I greatly depend on Mysql for efficient running of my site

Hoping to hear from you all and thanks in advance for your support

with best wishes

Arun

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




SQL help

2001-05-08 Thread Webmaster

How do I write SQL in MySQL to randomly select 5 records from a table?


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: SQL help

2001-05-08 Thread Webmaster

i dont follow step #3.


At 11:42 PM 5/8/2001, Tony Shiu wrote:
 i think it is more suitable to do it in programming level in mysql, though I
 know there is a function is M$sql server.
 
 if your table schema has a unique id field, before submit a query to DB,
 1) select count(*) from it
 2) from the above resultset, program to draw whatever number of records you
 want.
 3) submit the query, select * from it where id in (your random record ids);
 
 
 - Original Message -
 From: Webmaster [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Wednesday, May 09, 2001 11:38 AM
 Subject: SQL help
 
 
  How do I write SQL in MySQL to randomly select 5 records from a table?
 
 
  -
  Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail
  [EMAIL PROTECTED]
  Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 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: database problems

2001-05-04 Thread Webmaster

I have a similar problem to this..

 What happens is somehow something is causing mysql to hang which forces
it to reach max connections.. if i shutdown and restart mysql using
safe_mysqld --skip=networking it starts fine.. will do selects fine but
not inserts because the tables that were being inserted to while the
hang caught have become currupted.. I shutdown mysql, myisamchk -r the
tables, it reports the tables were fixed. I then restart mysql and when
trying to insert into the fixed table it just hangs forever.. if i do a
drop on the table and recreate it it goes back to working fine.. so it
seems the myisamchk is not fixing the tables..
any clues?

-- 
Webmaster
AngelHaven.com



Gerald Clark wrote:
 
 Shut down the server before repairing tables.
 
 Robert Clugston wrote:
 
  List,
  I'm having some serious problems with MySQL. I have some PHP and perl
  scripts that do INSERTs into MySQL. Multiple times during the day various
  tables become corrupted.
  Repairing the table using myisamchk with -r usually fixes the problem,
  but sometimes I have to restart mysqld to get things working again. Any
  ideas as to what is going on or how to fix this?
 
  /var/site/mysql/libexec/mysqld -V
  /var/site/mysql/libexec/mysqld  Ver 3.23.36 for unknown-openbsd2.7 on i386
  /var/site/mysql/bin/myisamchk: ISAM file
  /var/site/mysql/var/MailingList/MailingList.MYI
  /var/site/mysql/bin/myisamchk: error: Size of datafile is: 280400 Should be:
  281328
  /var/site/mysql/bin/myisamchk: error: Found key at page 38912 that points to
  record outside datafile
  /var/site/mysql/bin/myisamchk: error: Record-count is not ok; is 4723 Should
  be: 4738
  /var/site/mysql/bin/myisamchk: warning: Found 4723 parts Should be: 4738
  parts
  MyISAM-table '/var/site/mysql/var/MailingList/MailingList.MYI' is corrupted
  Fix it using switch -r or -o
  /var/site/mysql/bin/myisamchk: ISAM file
  /var/site/mysql/var/bob/announcements_mailinglist.MYI
  /var/site/mysql/bin/myisamchk: error: Size of datafile is: 203460 Should be:
  204312
  /var/site/mysql/bin/myisamchk: error: Found key at page 38912 that points to
  record outside datafile
  /var/site/mysql/bin/myisamchk: error: Record-count is not ok; is 4783 Should
  be: 4804
  /var/site/mysql/bin/myisamchk: warning: Found 4783 parts Should be: 4804
  parts
  MyISAM-table '/var/site/mysql/var/bob/announcements_mailinglist.MYI' is
  corrupted
  Fix it using switch -r or -o
  /var/site/mysql/bin/myisamchk: ISAM file /var/site/mysql/var/bob/contest.MYI
  /var/site/mysql/bin/myisamchk: error: Size of datafile is: 195772 Should be:
  196040
  /var/site/mysql/bin/myisamchk: error: Found key at page 35840 that points to
  record outside datafile
  /var/site/mysql/bin/myisamchk: error: Record-count is not ok; is 4358 Should
  be: 4364
  /var/site/mysql/bin/myisamchk: warning: Found 4358 parts Should be: 4364 par
  ts
  MyISAM-table '/var/site/mysql/var/bob/contest.MYI' is corrupted
  Fix it using switch -r or -o
  /var/site/mysql/bin/myisamchk: MyISAM file
  /var/site/mysql/var/bob/bob_eval.MYI
  /var/site/mysql/bin/myisamchk: warning: 1 clients is using or hasn't closed
  the table properly
  /var/site/mysql/bin/myisamchk: error: Size of datafile is: 3276 Should be:
  3344
  /var/site/mysql/bin/myisamchk: error: Found key at page 1024 that points to
  record outside datafile
  /var/site/mysql/bin/myisamchk: error: Record-count is not ok; is 96 Should
  be: 98
  /var/site/mysql/bin/myisamchk: warning: Found 96 parts Should be: 98 parts
  MyISAM-table '/var/site/mysql/var/bob/bob_eval.MYI' is corrupted
  Fix it using switch -r or -o
 
 
 
  -
  Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail 
[EMAIL PROTECTED]
  Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 --
 Gerald L. Clark
 [EMAIL PROTECTED]
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

--
Sign up for your free AngelHaven E-mail Today...
Join the growing community, http://www.AngelHaven.com 
Come Cruisin with the Angels http://www.AngelCruise.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

Ever heard of anything like this?

2001-04-30 Thread webmaster

I can't connect to my database via mysql

This is the load of crap I'm getting...

I would appreciate any input or feedback you have.

We are on a virtual server..we set up with this
company AITcom.net to be resellers.

First of all we are getting this error message when we try to connect to the database.

Can't connect to local MySQL server through socket '/tmp/mysql.sock'

Here is their version of an answer to my problem


I wanted to get back to you as soon as possible with an answer.  Here is what I 
found.  The Pearl modules will not run in a change root file system.  The user name 
that is being called does not exist on your server.  Also, there may be a problem with 
the version of Pearl being used.
The only solution is to have a dedicated server where you have root access to the 
box.  Our shared hosting solution is designed for a virtual server using a proprietary 
Linux operating system.  With a dedicated server, you can have any version of Linux 
you would like and any version of Pearl.  This would allow you full control over the 
server and as you have stated this works on every other server you have installed.  I 
know this has been a frustrating time for you and I would like to offer a solution.  I 
will transfer all monies paid to AIT over to the cost of a dedicated server 4.  If 
this solution is acceptable, please let me know and I will have the necessary paper 
work sent to you.  I look forward to your response.

Our people are saying that the solution is this...

Tony,
   
If your still getting the .sock error, ask your ISP to
recompile DBD::mysql on the server...
   
There is NO configuration within our programs that
interacts with DBD::mysql in any way that can cause or
effect that error.  When DBD::mysql is compiled (installed),
it makes a note of where MySQL is and always referrs
back to that note for connecting.  If its not connecting, its
likely that DBD::mysql was either installed from RPM or
binaries or copied from another server rather then actually
compiled on that one, OR, the MySQL server has been
moved, changed, upgraded, or otherwise.

Help! Please!

Anthony Giuliani
Director of Operations
21st Century Marketing  Training Solutions, Inc.
[EMAIL PROTECTED]
voice...407-831-8722



INSERT PROBLEM

2001-04-25 Thread Webmaster

Hello all
 I am running linux mandrake with Mysql vers 3.23.23-beta, for
pc-linux-gnu on i686

I've had a problem with recieving to many connections which i am working
on but my MAIN problem currently is that it will not allow me to insert
into tables.
I cleared out all the connections and can query the database and recieve
the answers.. but when i do a standard insert into one of the tables it
just seems to hang there.. its like it catches a lock or something. This
is an old table and these are the same query's its been using for over a
year.. other then fixing the table with myisamchk nothing has changed.
The table needed to be fixed due to the too many connections error which
currupted it appearantly.

Any idea's why it would be hanging on an insert statement?


Ter

--
Join the growing community of AngelHaven.com. 
Sign up for your free AngelHaven E-mail Today...
Visit us at http://www.AngelHaven.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




MySQLGui for macintosh?

2001-04-10 Thread Webmaster

Hi!
   I am currently building a web site for Sciences-Espace. We work on
macintosh computers. I found a version of MySQL for mac but not the
MySQLGui (the API), or MyODBC. Please tell if a version for mac exists
and how I can get it.

Sincerely,
SCRIPT


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




URGENT - daemon dying frequently

2001-04-09 Thread Webmaster Biz

Running mysql 3.22.32-log on Apache virtual server (FreeBSD) 

I can restart my mysql daemon with ./bin/safe_mysqld - but it 
only runs for a few hours before dying. Following hints from 
both the manual and the list, I've tried several things...

I've deleted my mysql database and manually re-installed all 
the tables (instead of using the mysql_install_db script which 
wanted me to do a make compile)

I've looked at the error log, and see nothing that shows why 
it is dying ( though when it starts it does have two messages -
 could they be related?)

Warning: setrlimit couldn't increase number of open files to 
more than 164
Warning: Changed limits: max_connections: 30  table_cache: 62

I've had the logging on but see no queries that should be the 
problem. 

Nothing in the cron file

Any suggestions? 

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Double your website traffic

2001-04-06 Thread webmaster



Do you want to double the number of visitors to your homepage everyday? The 
perfect solution is PopUp Window Exchange!

It's a brand new concept from LinkExchange. It will pop up websites instead 
of traditional banners. As a result, it can bring you REAL web traffic 
instead of raw banner impressions which do not give you unique hits.  

Here is how it works. Let's assume your website currently has 100 visitors 
daily. If you join our free popup exchange, 30 days later, your website can have up to

100*(1+50%)**30days=19175105 visitors/day!

The above calculation is very simple. Since every member needs to insert a 
simple HTML code in their homepage, when other website pops up in your 
homepage, your homepage will also popup in a member's website. Essentially 
giving you a free visitor everytime someone visits your page. If you used 
to have 1 visitor, now you will have 2 (The 2nd visitor is brought to you 
by other members)  

More Information can be found at..
http://GoPopUp.com

-
[EMAIL PROTECTED]
http://GoPopUp.com

To be removed from our mailing list - 
http://gopopup.com/unsubscrib.php?[EMAIL PROTECTED]


---Chinese-Big5
·Q§ó¦h¤Hª¾¹D§Aªººô¯¸¶Ü¡S §Ú­Ì¥i¥HÀ°§A¨C¤Ñ±N§Aªººô¯¸¤H¼Æ¼W¥[Âù­¿.
°²¦p§A¨C¤Ñ²{¦³100­Ó³X«È, ¦pªG§A¥[¤JPopUp Exchange, 30¤Ñ«á¡M
§Aªººô¯¸±N·|¦³19175105­Ó³X«È. 
100 * (1 + 50%) ** 30 days = 19175105 vistors/day
PopUp Exchange ªº¹B§@«D±`²³æ¡C  ¨C¦W¦¨­û¥u»Ý¦b¥Lªººô¯¸¤¤¥[¤J
¤@¬qPopUp HTML_CODE¡C  ³o´N¬O»¡,  ·í¨ä¥¦·|­ûªººô­¶¦b§Aªººô¯¸¤¤
PopUp¤@¦¸¡M ¦P¼Ë¦a¡M §Aªººô­¶¤]·|¦b¨ä¥¦·|­ûªººô¯¸¤¤PopUp¤@¦¸¡C
´N¬O»¡, ¦pªG§A¦³¤@­Ó³X«È¡M ´NÅܦ¨­Ç­Ó¡C
¥t¥~¡M PopUp¤£·|¼vÅT³X«È°ÑÆ[§Aªººô¯¸¡C¼u¥Xµ¡¤fÅã¥Ü¤_§A­ì¦³µ¡¤fªº©³³¡¡C 

½Ð¨ì¥H¤Uºô§}¥[¤J
http://GoPopUp.com/chinese.php

[EMAIL PROTECTED]
http://GoPopUp.com

¨ú®ø¹q¤l³ø¡H - http://gopopup.com/unsubscrib.php?[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




Too Many Connections

2001-03-21 Thread Webmaster

I have been on occasion recieving "Too Many Connections" errors which
lock up mysql.. I know i can set the connections in my.cnf.. atleast
thats what i've seen on this listover the past few months.. 
For starters.. i dont seem to have a my.cnf according to mysqladmin
Default options are read from the following files in the given order:
/etc/my.cnf /var/lib/mysql/my.cnf ~/.my.cnf

None of these files excist so am assuming its running at the defualt 100
connections.

My main concern is I should never currently be near 100 simultanious
connections. When all is running well i show maybe 5-15 tops since most
connections are processed then dropped.

My thoughts are someone was purposely trying to take up all connections.
This happened 4 times in a day and a half.. 

I only access mysql through php so decided to start safe_mysqld with
--skip-networking

This seemed to help.. as i didnt have any trouble for over a week
after.. but then it did happen again. and once more a couple days later.

Also.. the last time it happened I couldnt even get into mysql at all
from the command line and I believe 1 connection is always left open for
just that purpose. 

I also had a problem because in order to solve the too many connections
I was forced to do a mysqladmin shutdown..
This messed up all my auto-increments on all tables tat were in use at
the time of the problem and caused duplicate entry errors forcing me to
dump and remake the tables to correct the problem..

I am running 3.23.23-beta, for pc-linux-gnu on i686

Any thoughts. idea's, help on how i could correct the problem or fix it
if it happens again without dropping all messed up tables would be
appreciated.

Also.. I imagine I should put a my.cnf file in.. I havnt checked the
mysql site yet to see if they have example my.cnf but if someone could
possibly lead me that way i'd appreciate it (but not important since i
myself havnt looked)

Ter

--
Join the growing community of AngelHaven.com. 
Sign up for your free AngelHaven E-mail Today...
Visit us at http://www.AngelHaven.com 

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




mysql error

2001-03-19 Thread webmaster

I have suse linux 7.1, I installed mysql and php, I tyr to  connect to 
the database and I get a socket error why? is there any kind of 
special confg? I type mysql on a terminal window and get the error msg, 
cheers

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

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

2001-03-16 Thread webmaster

test

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




please urgent

2001-02-26 Thread webmaster

I have downloaded the leatest ver of php, php 4.04pl1, I am runing winnt 
4.0, acording to the info for this ver of php this ver has all the odbc 
connetciones incluided, the ver 3.0 has a library called php3_oci80.dll   
wich is used for conections to oracle 8, where can I find all the 
librarys requiered for php4 data base conections?  until now I have not 
had any lucky getting database conections  how do I stablish a dagta 
base conetiion oracle 8i, php4. is tyhere any graphical tool for 
developing forms ? what should I download to have all the files needed 
for data base conectivity? cheers 

On Mon, 26 Feb 2001, Joel Gwynn wrote:

 Date: Mon, 26 Feb 2001 15:04:19 -0500
 From: Joel Gwynn [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Subject: Re: mysql.server ignoring my.cnf?
 
 I tried /etc/my.cnf and got the same results.  As far as $DATADIR or $HOME
 are concerned, I don't see them when I do 'printenv'.  Is there another way
 to find out if those may be set, and by what?
 
 thanks.
 
 At 02:33 PM 2/26/01 -0500, Kent Hoover wrote:
 Sorry. Sent the last message before I was done
 
 If you have a stray $DATADIR/my.cnf or a $HOME/.my.cnf, their
 contents will override what you have set in /etc/my.cnf.
 
 Cheers,
 
 Kent
 
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail 
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 -
 Joel GwynnDesigners' CADD Company, Inc.
 A bus station is where a bus stops. 
 A train station is where a train stops. 
 So now you know why they call this a workstation... 
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 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




JDBC question

2001-02-16 Thread webmaster

I am , well I will have to wioork with oracle and jdeveloper, can some of 
you please please please telll me where canI find examples of conections 
to a database an oracle databse and if I use php again eh the 
same question where can I see examples of conections to an oralce data 
base using php...  information about jdeveloper... and oracle , perhaps a 
user group, a mailling list... is jdeveloper hard to use? are jdevelopers 
graphical interfaces easy to understand? I am not a java programmer so I 
must ask how easy may jdeveloper be I only need to stablish conectivity 
to an oracle database, buid the interfaces for consulting the data base 
and adding datas to it... well thanks a lot inadvance, cheers 

On Fri, 16 Feb 2001, William R. Mussatto wrote:

 Date: Fri, 16 Feb 2001 10:48:57 -0800 (PST)
 From: William R. Mussatto [EMAIL PROTECTED]
 To: Chen Ka Pong [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Subject: Re: JDBC question?
 
 
 Had similar problem, get the current version of the driver.
 
 On Fri, 16 Feb 2001, Chen Ka Pong wrote:
 
  Date: Fri, 16 Feb 2001 20:29:27 +0800
  From: Chen Ka Pong [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Subject: JDBC question?
  
  I cannot use the jdbc connection which the driver is download
  from mysql web site. The error message prompted that
  "invalid JDBC Driver", what can cause this error?
  I predict my classpath is wrong, but I would like to know
  how to set the classpath?
  (at this status, I am not sure if my classpath is correct or not)
  
  Thanks!
  
  Pong
  
 
 Sincerely,
 
 William Mussatto, Senior Systems Engineer
 CyberStrategies, Inc
 ph. 909-920-9154 ext. 27
 
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 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




JDBC-MySql==Sex?????????

2001-02-08 Thread Webmaster-Jumac.com

Hi Everyone,
Sorry for the subject but I am in a very very
desperate state 'coz the whole site is down and if I
cannot connect to the database through my servlet my
@ss is grass.

Everything seems to be working fine except when I
execute the servlet I get this @$#$@$# error:


" Server configuration denies access to data source "


And to connect my servlet code is:

Class.forName("org.gjt.mm.mysql.Driver").newInstance();
con =
DriverManager.getConnection("jdbc:mysql://jumac.com:3306/DBNAME?user=ryanpassword=pw007");


Is the problem with my code or my hosting service?
What should I do?
Please give me detailed instructions as I am not too
familiar with MySql so if you are telling me to make
changes in the database please be specific.

Remember if you help me, when I become a LITTLE richer
than Bill Gates I won't forget you either!

Cheers,
Ryan.
([EMAIL PROTECTED])


__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Problems with mySQL and DBTools

2001-02-08 Thread webmaster

do any one knows about a mailling list of oracle? wich is the eamil 
address for subscribing to it? please mail me back ASAP, cheers

On Thu, 8 Feb 2001, clay bond wrote:

 Date: Thu, 8 Feb 2001 13:23:08 -0500 (EST)
 From: clay bond [EMAIL PROTECTED]
 To: unlisted-recipients:  ;
 Cc: [EMAIL PROTECTED]
 Subject: Re: Problems with mySQL and DBTools
 
 
 
 On Thu, 8 Feb 2001, Curtis, Lorenzo wrote:
 
  2.  Is there a detailed outline to use to compile Apache with PHP and mySQL
  effectively?
 
 www.devshed.com/Server_Side/PHP/Soothingly_Seamless/print.html
 
 --
  /"\
  \ /  ASCII RIBBON CAMPAIGN
   X   AGAINST HTML EMAIL
  / \  AND POSTINGS
 
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 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




  1   2   >