Re: [LICENSING] why so hazy? Comparing to Samba.

2007-02-22 Thread software advocate
In all seriousness... If the developer is really worried about paying the fee, he can develop his own mysql client. As far as the pointed out documentation links from earlier, the information is there. You do not have to GPL your application if you read the docs. The license of those docs only co

Re: [LICENSING] why so hazy? Comparing to Samba.

2007-02-22 Thread mos
At 04:33 PM 2/22/2007, Barry Newton wrote: At 05:00 PM 2/22/2007, mos wrote: On the other hand, if you developed a web application that ran on MySQL (an accounting package say) and you want to distribute it to 1000 MySQL users without giving them your source code, then you will need a My

Re: [LICENSING] why so hazy? Comparing to Samba.

2007-02-22 Thread Jay Pipes
software advocate wrote: On 2/22/07, Jay Pipes <[EMAIL PROTECTED]> wrote: I do see your point about the sockets layer/client protocol and that language is being removed/has been removed from our website because it has been, as you point out, a source of confusion; I will agree with you there.

Re: [LICENSING] why so hazy? Comparing to Samba.

2007-02-22 Thread software advocate
On 2/22/07, Jay Pipes <[EMAIL PROTECTED]> wrote: I do see your point about the sockets layer/client protocol and that language is being removed/has been removed from our website because it has been, as you point out, a source of confusion; I will agree with you there. There is one more piece

Re: [LICENSING] why so hazy? Comparing to Samba.

2007-02-22 Thread software advocate
But, on a general note, I *don't* think that MySQL licensing is confusing, and any confusion thereof stems from confusion about what the GPL itself states. I hear tons of times how developers claim that they fall under the mere aggregation clause when in fact they do not -- it's just an attempt

Re: FullText Scoring With Two Databases

2007-02-22 Thread Philip Mather
-BEGIN PGP SIGNED MESSAGE- Hash: SHA512 Neil, The short answer is probably "merge the two databases manually and rebuild the index". I don't think there's any real answer otherwise. Given the old version of MySQL you aren't going to be able to do anything fancy like federating the two t

Re: [LICENSING] why so hazy? Comparing to Samba.

2007-02-22 Thread Jay Pipes
software advocate wrote: On 2/22/07, Jay Pipes <[EMAIL PROTECTED]> wrote: I have no idea what this means. :( First, you were complaining about PHP and Jim noted that we have a PHP native driver in the works. Then, you move on to Python and Java... sounds like you're just flame-baiting. I d

4.0.17 subquery

2007-02-22 Thread Miles Thompson
This works: SELECT geodesic_classifieds_userdata.id FROM geodesic_classifieds_userdata LEFT JOIN subscriber ON geodesic_classifieds_userdata.id=subscriber.GeoClassID WHERE subscriber.GeoClassID IS NULL; Please check this syntax for a DELETE statement DELETE geodesic_user_data gud, subscri

Re: [LICENSING] why so hazy? Comparing to Samba.

2007-02-22 Thread software advocate
On 2/22/07, Jay Pipes <[EMAIL PROTECTED]> wrote: I have no idea what this means. :( First, you were complaining about PHP and Jim noted that we have a PHP native driver in the works. Then, you move on to Python and Java... sounds like you're just flame-baiting. I don't mean to sound like I'

Re: [LICENSING] why so hazy? Comparing to Samba.

2007-02-22 Thread Jay Pipes
software advocate wrote: Wow, well that is just neat. It's too bad I left PHP for TurboGears. The second problem is the buzz of frameworks (TurboGears, JBoss, etc) which use/want to use MySQL as a backend. This is really the only issue I have with MySQL. They do support other databases, and its

Re: pre-create innodb tablespace

2007-02-22 Thread Maciej Dobrzanski
""Gary Richardson"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Can I pre-create innodb tablespace using something like dd (or any other > better tool)? I'm afraid it can't be done that way, because fresh datafile is not simply an empty file filled with zeros. You should be ab

Re: [LICENSING] why so hazy? Comparing to Samba.

2007-02-22 Thread software advocate
Wow, well that is just neat. It's too bad I left PHP for TurboGears. The second problem is the buzz of frameworks (TurboGears, JBoss, etc) which use/want to use MySQL as a backend. This is really the only issue I have with MySQL. They do support other databases, and its not like anyone is twistin

Re: [LICENSING] why so hazy? Comparing to Samba.

2007-02-22 Thread Jim Winstead
On Thu, Feb 22, 2007 at 01:39:49PM -0900, software advocate wrote: > This is exactly why someone needs to develop a non-gpl mysql drop in client > for PHP. This would get around license costs, despite what MySQL AB has to > say, this would be completely legal. Ask your local rep from the FSF. One >

Re: [LICENSING] why so hazy? Comparing to Samba.

2007-02-22 Thread software advocate
I've personally emailed them in the past. Their response was for me to by a license. When I asked them about creating my own client without reading their docs or source code, they still insisted I buy a license. Anyone who knows the GPL well, knows the communication layer is NOT covered by GPL. S

Re: [LICENSING] why so hazy? Comparing to Samba.

2007-02-22 Thread software advocate
On 2/22/07, mos <[EMAIL PROTECTED]> wrote: At 12:51 PM 2/22/2007, software advocate wrote: >Let me present what I've read from the MySQL site so far. > >The MySQL protocol notice > http://dev.mysql.com/doc/internals/en/licensing-notice.html > >Okay, really confusing. What if someone creates a my

Re: [LICENSING] why so hazy? Comparing to Samba.

2007-02-22 Thread software advocate
This is exactly why someone needs to develop a non-gpl mysql drop in client for PHP. This would get around license costs, despite what MySQL AB has to say, this would be completely legal. Ask your local rep from the FSF. One could always reverse engineer the protocol like the Samba team. Also the

Re: [LICENSING] why so hazy? Comparing to Samba.

2007-02-22 Thread Barry Newton
At 05:00 PM 2/22/2007, mos wrote: On the other hand, if you developed a web application that ran on MySQL (an accounting package say) and you want to distribute it to 1000 MySQL users without giving them your source code, then you will need a MySQL AB license for each copy ($595,000 in to

Re: [LICENSING] why so hazy? Comparing to Samba.

2007-02-22 Thread mos
At 03:05 PM 2/22/2007, Raul Andres Duque wrote: What do the license say about using MySQL on web aplications (with PHP)?? Regards, RAUL DUQUE Bogotá, Colombia Paul, Use of MySQL (with or without PHP) on a webserver falls into the GPL license because you are not technically distributing

Re: [LICENSING] why so hazy? Comparing to Samba.

2007-02-22 Thread Raul Andres Duque
What do the license say about using MySQL on web aplications (with PHP)?? Regards, RAUL DUQUE Bogotá, Colombia - Original Message - From: "mos" <[EMAIL PROTECTED]> To: Sent: Thursday, February 22, 2007 3:32 PM Subject: Re: [LICENSING] why so hazy? Comparing to Samba. At 12:51 PM

Re: [LICENSING] why so hazy? Comparing to Samba.

2007-02-22 Thread mos
At 12:51 PM 2/22/2007, software advocate wrote: Let me present what I've read from the MySQL site so far. The MySQL protocol notice http://dev.mysql.com/doc/internals/en/licensing-notice.html Okay, really confusing. What if someone creates a mysql client without looking at docs or source code o

[LICENSING] why so hazy? Comparing to Samba.

2007-02-22 Thread software advocate
Let me present what I've read from the MySQL site so far. The MySQL protocol notice http://dev.mysql.com/doc/internals/en/licensing-notice.html Okay, really confusing. What if someone creates a mysql client without looking at docs or source code of the MySQL client? What if someone simply sniffs

Re: [Fwd: search issue] Duplicating contents of DB within same DB with different prefix

2007-02-22 Thread Istvan Hubay Cebrian
Istvan Hubay Cebrian wrote: > > Hi everyone, > > I revert to this mailing list to ask for help accomplishing a specific > task. I'll try to explain as best I can. > > Say I have a DB named... well... "database1", this db has the following > tables: > > pt_table1 > pt_table2 > pt_table3 > >

RE: Disable DNS reserve lookup for auth

2007-02-22 Thread Gary W. Smith
> We have 4 development servers that are fairly configured the same way. > We have an admin account on each server using %" for the hostname. > This > works on 3 of the 4 servers. The 4th server seems to do a lookup and > since the client machine (i.e. my workstation) isn't specifically > specifie

Re: Duplicating contents of DB within same DB with different prefix

2007-02-22 Thread Michael Dykman
This should do what you are asking for (not that I approve of your linguistic appraoch ;-)) CREATE TABLE PREFIX_pt_table1 LIKE pt_table1; INSERT INTO PREFIX_pt_table1 SELECT * from pt_table1; On 2/22/07, Istvan Hubay Cebrian <[EMAIL PROTECTED]> wrote: Hi everyone, I revert to this mailing l

Re: [Fwd: search issue] Duplicating contents of DB within same DB with different prefix

2007-02-22 Thread Istvan Hubay Cebrian
Martijn Tonies wrote: > > >> >> Anyway of accomplishing this? Ideally without having to state each of > the >> >> tables names. And also that this would work so that you could only >> > duplicate >> >> tables that have a certain prefix, so: duplicate only tables that >> start >> > with >> >> "

Re: [Fwd: search issue] Duplicating contents of DB within same DB with different prefix

2007-02-22 Thread Martijn Tonies
> >> Anyway of accomplishing this? Ideally without having to state each of the > >> tables names. And also that this would work so that you could only > > duplicate > >> tables that have a certain prefix, so: duplicate only tables that start > > with > >> "pt_" and change prefix to "es_" for examp

pre-create innodb tablespace

2007-02-22 Thread Gary Richardson
Hi, Can I pre-create innodb tablespace using something like dd (or any other better tool)? I have a server that is getting low on innodb table space and I want to add 15GB or so, but I want to minimize downtime. The server is a bit slow and I estimate it will take around 10-20 minutes or so. I w

FullText Scoring With Two Databases

2007-02-22 Thread Neil Tompkins
I've been using the MATCH() with FullText Scoring for quite a while now on one table. I now need to combine the data from another database. I have : Database1.Table1 with Database2.Table1 If I use the the FullText scoring using just one database/table it is OK, but when I query the databas

Re: [Fwd: search issue] Duplicating contents of DB within same DB with different prefix

2007-02-22 Thread Istvan Hubay Cebrian
Martijn Tonies wrote: > > Hi, > >> I revert to this mailing list to ask for help accomplishing a specific > task. >> I'll try to explain as best I can. >> >> Say I have a DB named... well... "database1", this db has the following >> tables: >> >> pt_table1 >> pt_table2 >> pt_table3 >> >> What

Re: [Fwd: search issue] Duplicating contents of DB within same DB with different prefix

2007-02-22 Thread Istvan Hubay Cebrian
Chris McKeever-2 wrote: > > On 2/22/07, Istvan Hubay Cebrian <[EMAIL PROTECTED]> wrote: >> >> Hi everyone, > >> >> Say I have a DB named... well... "database1", this db has the following >> tables: > >> What I want to do is copy each of the tables (exactly as they are, >> including >> primary

Re: Duplicating contents of DB within same DB with different prefix

2007-02-22 Thread Martijn Tonies
Hi, > I revert to this mailing list to ask for help accomplishing a specific task. > I'll try to explain as best I can. > > Say I have a DB named... well... "database1", this db has the following > tables: > > pt_table1 > pt_table2 > pt_table3 > > What I want to do is copy each of the tables (exac

Re: Duplicating contents of DB within same DB with different prefix

2007-02-22 Thread Chris McKeever
On 2/22/07, Istvan Hubay Cebrian <[EMAIL PROTECTED]> wrote: Hi everyone, Say I have a DB named... well... "database1", this db has the following tables: What I want to do is copy each of the tables (exactly as they are, including primary keys, data, etc) but at the same time change the pr

Duplicating contents of DB within same DB with different prefix

2007-02-22 Thread Istvan Hubay Cebrian
Hi everyone, I revert to this mailing list to ask for help accomplishing a specific task. I'll try to explain as best I can. Say I have a DB named... well... "database1", this db has the following tables: pt_table1 pt_table2 pt_table3 What I want to do is copy each of the tables (exactly as th

Disable DNS reserve lookup for auth

2007-02-22 Thread Gary W. Smith
We have 4 development servers that are fairly configured the same way. We have an admin account on each server using %" for the hostname. This works on 3 of the 4 servers. The 4th server seems to do a lookup and since the client machine (i.e. my workstation) isn't specifically specified access is