function question

2003-06-22 Thread Anthony W.
Hi, I'm just wondering is there a function instead of update to overwrite data that has expired?? Or can mysql automatically deletes records or rows that has expires just like cookies delete themselves after expiring. Thanx for the info Anthony -- MySQL General Mailing List For list

join error

2003-06-18 Thread Anthony W.
Hi, I think this is an error, anyways i'm trying to join 6 tables together. and when i do EXPLAIN SELECT i get the message in comments Impossible WHERE noticed after reading const tables this is my statment basically SELECT table1.id FROM table1,table2,table3,table4,table5,place WHERE

Re: join error

2003-06-18 Thread Anthony W.
Hi, I saw the error. For interested it is in the place.latitude BETWEEN section Anthony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

4.1 Download

2002-12-20 Thread Anthony W. Marino
Where/how can I get a copy of 4.1? Thanks, Anthony sql,query,queries,smallint - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

[Fwd: 3rd Attempt: Fwd: Access Denied (1045)]]

2002-10-23 Thread Anthony W. Marino
Any thoughts with regards to the problem outlined below would be appreciated! Thank You, Anthony Original Message Subject: 2nd Attempt: Fwd: Access Denied (1045)] Date: Fri, 18 Oct 2002 06:59:21 -0400 From: Anthony W. Marino [EMAIL PROTECTED] To: [EMAIL PROTECTED] I'm

2nd Attempt: Fwd: Access Denied (1045)]

2002-10-18 Thread Anthony W. Marino
I'm boxed in a corner and would appreciate some suggestions, please! Thank You, Anthony Original Message Subject: Access Denied (1045) Date: Tue, 15 Oct 2002 08:47:05 -0400 From: Anthony W. Marino [EMAIL PROTECTED] To: [EMAIL PROTECTED] Ive searched about and still haven't

Access Denied (1045)

2002-10-15 Thread Anthony W. Marino
Ive searched about and still haven't been able to resolve my problem. Scenario: 1) OS is RH 7.3. 2) Installing MySQL 4.04-Pro binary tarball. 3) Ordinary user, userX.grpX, is installing tarball themselves on a shared server accessed via telnet. 4) This installation will be userX's instance

Re: MySQl db as filesystem.

2002-10-12 Thread Anthony W. Marino
Pretty interesting stuff: http://www.osnews.com/story.php?news_id=836 http://newsforge.com/article.pl?sid=02/03/22/204220tid=9 Anthony Anthony W. Marino Pres./CTO, AWM Objects David Garamond wrote: Jan Steinman wrote: Today's modern operating systems really stopped evolving in the 80

Re: MySQl db as filesystem.

2002-10-12 Thread Anthony W. Marino
Here's something: http://no.spam.ee/~tonu/modules.php?name=Newsnew_topic=2 Anthony Jayce^ wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Actually, I remember reading about a mysqlfs system, like that, cd to a table, ls for records.. rm to remove and such. that was over a year ago at

Re: User Specific Instance Running

2002-10-11 Thread Anthony W. Marino
Victoria Reznichenko wrote: Anthony, Friday, October 11, 2002, 5:26:39 AM, you wrote: AWM There is non-root user implementation of MySQL-Pro 4.0.4 linux binary in AWM this users environment (RH 7.3). AWM my.cnf has been modified to include individual user, port , AWM bind-address and host

User Specific Instance Running

2002-10-10 Thread Anthony W. Marino
. Data directories are already available with this user/group's ownership. All attempts to run mysql -u root file and other privledged commands (also tried --skip-grant-tables) end up with Error 1045 Access Denied ? -- Anthony Anthony W. Marino Pres./CTO, AWM Objects Phone: (732) 610

mysql.server Mods for Multiple Instances/Users

2002-10-09 Thread Anthony W. Marino
What are the issues if I were to remove the following snippets from mysql.server on a RH 7.2 system running multiple instances of MySQL under multiple users?: # Make lock for RedHat / SuSE if test -w /var/lock/subsys then touch /var/lock/subsys/mysql fi

Recent Updates

2002-05-30 Thread Anthony W. Marino
Where/how can I access the most recently updated code for MySQL Max 4.x. Thanks, Anthony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

Re: Recent Updates

2002-05-30 Thread Anthony W. Marino
Thanks alot!!! Anthony In the last episode (May 30), Anthony W. Marino said: Where/how can I access the most recently updated code for MySQL Max 4.x. http://www.mysql.com/doc/I/n/Installing_source_tree.html - Before

Re: Select Past 7 days

2002-05-01 Thread Anthony W. Marino
unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Anthony W. Marino Pres./CTO, AWM Objects email: [EMAIL PROTECTED] phone: (732) 610-2441 - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: Mysql 4.0.x enough stable to be in production ?

2002-04-23 Thread Anthony W. Marino
://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Anthony W. Marino Pres./CTO, AWM Objects email: [EMAIL PROTECTED] phone: (732) 610

Re: [linux-lvm] System Suggestions

2002-03-07 Thread Anthony W. Marino
We have 10 of the 3ware cards, and while the drive is GPLd and in the kernel, we have not been satisfied with the stability of the system Is there anything that I can avoid while still using the card (ie; specific RAID config)? We haven't had a chance yet to qual the

System Suggestions

2002-03-06 Thread Anthony W. Marino
Could someone, please, provide me with a link and/or facilitate some suggestons for configuration of the following components for a new DB server hosting MySQL 4.01MAX? I'm only looking to get a start and don't expect THE answer since all things are relative and I will have to further test

MySQL Availability

2002-03-06 Thread Anthony W. Marino
Where can I find most recent (ie; 4.0.2 builds ;Nightly/CVS) at? Thank You, Anthony sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: MySQL Availability

2002-03-06 Thread Anthony W. Marino
- From: Anthony W. Marino [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 06, 2002 12:12 PM Subject: MySQL Availability Where can I find most recent (ie; 4.0.2 builds ;Nightly/CVS) at? Thank You, Anthony sql

Re: [linux-lvm] System Suggestions

2002-03-06 Thread Anthony W. Marino
On Wednesday 06 March 2002 02:40 pm, Petro wrote: On Wed, Mar 06, 2002 at 11:52:30AM -0500, Anthony W. Marino wrote: Could someone, please, provide me with a link and/or facilitate some suggestons for configuration of the following components for a new DB server hosting MySQL 4.01MAX? I'm

Re: Can't restart MySQL after innodb table filled up

2002-03-04 Thread Anthony W. Marino
On Monday 04 March 2002 03:21 pm, Heikki Tuuri wrote: Erik, this is probably not a bug. Your log files probably are not the ones which belong together with the current data file(s). When you start the database it tries to use the obsolete log files in recovery. From the manual: If

Re: I heard that MySQL 4.01 supports Views?

2002-02-27 Thread Anthony W. Marino
On Wednesday 27 February 2002 05:16 pm, you wrote: At 17:09 -0500 2/27/02, Anthony W. Marino wrote: On Wednesday 27 February 2002 04:59 pm, Paul DuBois wrote: Does MySQL 4.01 support Views? And if so, how? Ask the person who told you that it does to substantiate the assertion

MySQL 4/XFS Journalling FS

2002-02-26 Thread Anthony W. Marino
Would anyone like to share their experiences with MySQL 4 on XFS and kernel 2.4.16? I'm getting prepared to create a system with the above and would appreciate any thoughts. Thank You In Advance! Anthony - Before posting,

Re: MySQL 4.x Timeline

2002-02-25 Thread Anthony W. Marino
On Sunday 24 February 2002 06:26 pm, Arjen Lentz wrote: Hi Anthony, On Fri, 2002-02-22 at 23:43, Anthony W. Marino wrote: On Fri, 2002-02-22 at 18:59, [EMAIL PROTECTED] wrote: Is there a timeline/status for 4.x functionality available? I would like to use MySQL 4.x, however, I'm

Re: MySQL 4.x Timeline

2002-02-22 Thread Anthony W. Marino
On Friday 22 February 2002 02:15 am, Jeremy Zawodny wrote: On Thu, Feb 21, 2002 at 08:07:39PM -0500, Anthony W. Marino wrote: Is there a timeline/status for 4.x functionality available? No. It'll be ready when it's ready. :-) There are folks using 4.0.x in production and/or testing now

Re: Paul DuBois Book

2002-02-22 Thread Anthony W. Marino
On Friday 22 February 2002 05:48 am, Simon Green wrote: It would be nice to see some thing for V4. PS Paul...its only because we liked the first one so much. -Original Message- From: D Bamud [mailto:[EMAIL PROTECTED]] Sent: 22 February 2002 10:47 To: [EMAIL PROTECTED] Subject:

Re: MySQL 4.x Timeline

2002-02-22 Thread Anthony W. Marino
On Friday 22 February 2002 06:26 am, Arjen Lentz wrote: Hi Alec, On Fri, 2002-02-22 at 18:59, [EMAIL PROTECTED] wrote: Is there a timeline/status for 4.x functionality available? I would like to use MySQL 4.x, however, I'm looking for some of the highly requested functionality (ie;

Transaction Enhanced Formats

2002-02-22 Thread Anthony W. Marino
Can anyone point me to a comparison of +'s and -'s with each Transaction enhanced formats (ie; InnoDb, SleepyCat and others) for MySQL. Thanks, Anthony - Before posting, please check: http://www.mysql.com/manual.php (the

MySQL 4.x Timeline

2002-02-21 Thread Anthony W. Marino
Is there a timeline/status for 4.x functionality available? I would like to use MySQL 4.x, however, I'm looking for some of the highly requested functionality (ie; subselects, SP's, triggers and Views) and would like to know where/when in the sequence of things todo does everything fall into

Re: raid tables

2001-06-18 Thread Anthony W . Marino
Isn't this something that RAID O does for you on a larger scale anyway? I would expect that most would have some sort of raid on their mutliple drive system. On Monday 18 June 2001 01:52 am, you wrote: On Sun, Jun 17, 2001 at 11:48:04PM -0700, Jamie Krasnoo wrote: Is there a way to tell

GEMNI,InnoDB and BDB

2001-06-17 Thread Anthony W . Marino
Any thoughts on the best support of transactional/ACID attributes for db tables in MySQL? Thank You, Anthony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/