Re: Oracle , what else ?

2009-04-22 Thread mos
At 07:13 PM 4/21/2009, you wrote: It will great if the MYSQL guys were to buy mysql from Oracle for half the price that Sun paid. Yeah, I'm sure Widenous is writing a check as we speak. rofl He is busy working on Maria, a stripped down branch of MySQL.

Re: Oracle , what else ?

2009-04-22 Thread Martijn Tonies
It will great if the MYSQL guys were to buy mysql from Oracle for half the price that Sun paid. Yeah, I'm sure Widenous is writing a check as we speak. rofl He is busy working on Maria, a stripped down branch of MySQL. http://monty-says.blogspot.com/2008/01/maria-engine-is-released.html

Re: Oracle , what else ?

2009-04-22 Thread Krishna Chandra Prajapati
i agree with you, Since mysql code is GPL anyone can start developing further wither another name say 'MySQL NEW' I don't understand how any company can own since mysql code is GPL. On Wed, Apr 22, 2009 at 11:48 AM, mos mo...@fastmail.fm wrote: At 07:13 PM 4/21/2009, you wrote: It will

mysqldump.exe gives Access Denied for user

2009-04-22 Thread John Sun
Gurus, I'm running a Windows Server 2003 cmd shell script to backup my databases using: %mysqldir%\bin\mysqldump -B %dbname% -u %dbuser% -p%dbpass% %bkupdir%\dbBkup_%dbname%_%yy%%mm%%dd%.sql @ECHO Done! New File: dbBkup_%dbname%_%yy%%mm%%dd%.sql It's been running fine until I've had to change

I thin'k MySQL will be the 'Oracle Personal Edition'

2009-04-22 Thread José I . Merino
The main question is: Will Oracle permits a cheaper DB in his portfolio with almost the same reliability than his main and expensive DB? Ok. MySQL is the main database in a wide 'open source' community. That people never will bought Oracle to build a phpBB forum or to install Joomla, but what

Re: I thin'k MySQL will be the 'Oracle Personal Edition'

2009-04-22 Thread Thomas Pundt
José I. Merino schrieb: The main question is: Will Oracle permits a cheaper DB in his portfolio with almost the same reliability than his main and expensive DB? It already has, it's called Oracle Express Edition. Ciao, Thomas -- MySQL General Mailing List For list archives:

Re: I thin'k MySQL will be the 'Oracle Personal Edition'

2009-04-22 Thread Arthur Fuller
The revenue that MySQL has accrued to date comes (obviously) from the support contracts. Oracle has no interest in derailing this revenue stream. It may well slow down the version cycle, which may be a good thing, but that aside, I cannot see Oracle killing the MySQL stream. There's no argument

Re: I thin'k MySQL will be the 'Oracle Personal Edition'

2009-04-22 Thread Lin Chun
XE store up to 4GB of user data, use up to 1GB of memory, and use one CPU on the host machine. On Wed, Apr 22, 2009 at 3:51 PM, Thomas Pundt mli...@rp-online.de wrote: José I. Merino schrieb: The main question is: Will Oracle permits a cheaper DB in his portfolio with almost the same

Creating / Lookup Users For Database

2009-04-22 Thread Carlos Williams
This seems to be a simple beginer question for MySQL and I have searched online but I wanted to ask before I really confuse myself. I have MySQL running on Linux and right now I have created a 2nd production database: mysql show databases; +-+ | Database

1064 errors

2009-04-22 Thread Matthew Stuart
Hi, I have several procedures that I have taken from an old Microsoft database, and I have tired to use them in a MySQL 5.1.32 database, but I am getting errors when trying to input them. There are three in total that I am struggling with and would appreciate some guidance... This is a

Re: 1064 errors

2009-04-22 Thread Peter Brawley
Matthew, CREATE PROCEDURE 'x'.'CrossSelling' () BEGIN SELECT TOP 5 OrderDetails.ProductID, OrderDetails.ProductName, Count(OrderDetails.ProductID) AS CountOfProductID FROM OrderDetails WHERE (((OrderDetails.OrderID) In (select OrderID from OrderDetails where ProductID=[pid]))) GROUP BY

my final 1064 error

2009-04-22 Thread Matthew Stuart
Here is my final problem that I am struggling to overcome... SELECT Vouchers.VoucherID, Vouchers.VoucherCode, Vouchers.StartDate, Vouchers.EndDate, Vouchers.Discount, Vouchers.VoucherTypeID FROM Vouchers WHERE (((DateDiff('d',[StartDate],Date()))=0) AND ((DateDiff('d',

Re: my final 1064 error

2009-04-22 Thread Peter Brawley
Matthew SELECT Vouchers.VoucherID, Vouchers.VoucherCode, Vouchers.StartDate, Vouchers.EndDate, Vouchers.Discount, Vouchers.VoucherTypeID FROM Vouchers WHERE (((DateDiff('d',[StartDate],Date()))=0) AND ((DateDiff('d',[EndDate],Date()))=0)); Square brackets and your DateDiff syntax are MSSQL,

Re: Creating / Lookup Users For Database

2009-04-22 Thread Carlos Williams
On Wed, Apr 22, 2009 at 2:40 PM, Carlos Williams carlosw...@gmail.com wrote: On Wed, Apr 22, 2009 at 11:53 AM, Brent Baisley brentt...@gmail.com wrote: All user information is stored in the mysql database. If you want to see a list of users that have been created, query the user information

Re: Creating / Lookup Users For Database

2009-04-22 Thread George Larson
On Wed, Apr 22, 2009 at 2:40 PM, Carlos Williams carlosw...@gmail.com wrote: On Wed, Apr 22, 2009 at 2:40 PM, Carlos Williams carlosw...@gmail.com wrote: On Wed, Apr 22, 2009 at 11:53 AM, Brent Baisley brentt...@gmail.com wrote: All user information is stored in the mysql database. If you want

Re: Creating / Lookup Users For Database

2009-04-22 Thread Carlos Williams
On Wed, Apr 22, 2009 at 2:45 PM, George Larson george.g.lar...@gmail.com wrote: Is this what you mean? SELECT * FROM user; Yes. That was exactly what I was looking for. Thank you for that info. Still learning these commands so pardon my ignorance. Now I did create that new database called

Re: Creating / Lookup Users For Database

2009-04-22 Thread Carlos Williams
On Wed, Apr 22, 2009 at 3:04 PM, Carlos Williams carlosw...@gmail.com wrote: Now I did create that new database called 'forums' and would like to create a new user who has access only to that specific database from localhost. I can't seem to find the command via Google on how I create the user

Re: Creating / Lookup Users For Database

2009-04-22 Thread George Larson
On Wed, Apr 22, 2009 at 3:11 PM, Carlos Williams carlosw...@gmail.com wrote: On Wed, Apr 22, 2009 at 3:04 PM, Carlos Williams carlosw...@gmail.com wrote: Now I did create that new database called 'forums' and would like to create a new user who has access only to that specific database from

Mysql on Ultrasparc T2 and floating point performance

2009-04-22 Thread Rod Heyd
Hi, I've been running mysql on a T1000 (Ultrasparc T1) system for several years now, and while I've been happy with the performance overall, the poor floating point capability on these systems has been a disappointment. Recently, I got my hands on a Sunfire T5420 system and I've been comparing

Re: Mysql on Ultrasparc T2 and floating point performance

2009-04-22 Thread Dan Nelson
In the last episode (Apr 22), Rod Heyd said: I've been running mysql on a T1000 (Ultrasparc T1) system for several years now, and while I've been happy with the performance overall, the poor floating point capability on these systems has been a disappointment. Recently, I got my hands on a

Re: Mysql on Ultrasparc T2 and floating point performance

2009-04-22 Thread Rod Heyd
On Wed, Apr 22, 2009 at 1:27 PM, Dan Nelson dnel...@allantgroup.com wrote: In the last episode (Apr 22), Rod Heyd said: I've been running mysql on a T1000 (Ultrasparc T1) system for several years now, and while I've been happy with the performance overall, the poor floating point

Re: Mysql on Ultrasparc T2 and floating point performance

2009-04-22 Thread mos
At 03:49 PM 4/22/2009, you wrote: On Wed, Apr 22, 2009 at 1:27 PM, Dan Nelson dnel...@allantgroup.com wrote: In the last episode (Apr 22), Rod Heyd said: I've been running mysql on a T1000 (Ultrasparc T1) system for several years now, and while I've been happy with the performance overall,

Re: Oracle , what else ?

2009-04-22 Thread Joshua D. Drake
On Tue, 2009-04-21 at 15:19 +0200, Martijn Tonies wrote: Hey Gilles, After MySQL bought by the java maker, and now Sun bought by Oracle, what are we gonna run as RDBMS ? How about PostgreSQL? Joshua D. Drake -- PostgreSQL - XMPP: jdr...@jabber.postgresql.org Consulting,