Re[2]: Mysql Web interface for normal Users

Hi! Just wanted to bring up an old topic - the situation with mysql web clients is the same as last year or is there any new good software? Something that would be easy to use and look nice to the users? I'm also looking for something quite simple yet enough customizable. Thanks! Martins Tuesd

Re: re[2]: MySQL (GPL License)

Hi Mike, On Jun 8, 2006, at 10:52 AM, mos wrote: At 03:09 AM 6/8/2006, Rob Desbois wrote: Douglas, If you are selling a product which requires your users download MySQL or requires you distribute it with the product, you need a commercial licence. $595?! Ouch indeed...it's much cheaper if

re[2]: MySQL (GPL License)

At 03:09 AM 6/8/2006, Rob Desbois wrote: Douglas, If you are selling a product which requires your users download MySQL or requires you distribute it with the product, you need a commercial licence. $595?! Ouch indeed...it's much cheaper if you're not using InnoDB, although obviously that's a

re[2]: MySQL (GPL License)

Douglas, If you are selling a product which requires your users download MySQL or requires you distribute it with the product, you need a commercial licence. $595?! Ouch indeed...it's much cheaper if you're not using InnoDB, although obviously that's a pretty major trade-off. > < -- O

Re: 2 MySQL Errors

On Fri, Mar 25, 2005 at 07:27:47PM -0800, David Blomstrom wrote: > I can't figure out why I get an error message relating > to fiels "borderstates" and "bordernotes" when I try > to create a new table. One is VARCHAR, the other TEXT, > and both are NULL, like almost every field on the > table. > >

Re[2]: Mysql growing pains, 4 days to create index on one table!

matt on Thursday, July 15, 2004, 11:58:31 AM, wrote: >>Consider replicating to some slave servers and dividing reads among them. mr> I already replicate to slaves, and sites will do read only queries off mr> these slaves mr> 99.9 % of the tables are read only anyway, the only tables we update o

Re[2]: Mysql growing pains, 4 days to create index on one table!

On Thursday, July 15, 2004, 9:10:43 AM, matt wrote: mr> Justin Swanhart wrote: >>Indexes can generate vast amounts of random i/o. >>Because of rotational latency, random i/o can really >>slow you down, especially if you are using IDE or SATA >>disks because they can't do tagged queueing like SCS

Re[2]: MySQL Administrator - Startup Variables

Matt, Thomas, > Oh we are using Red Hat Enterprise Linux WS ver 3.0 Please enter a bug report at http://bugs.mysql.com. Thank you. > Thomas Taylor wrote: >> what platform are you on? >> On Feb 23, 2004, at 4:27 PM, Matt Silva wrote: >> >>> I am using the ~new~ MySQL Administrator and i'm trying

Re[2]: MySQL 4.1.1 Download

>> Are binaries of MySQL 4.1.1 available or we need to >> compile it from the source. > No, binaries are not available yet. They will be available very soon, most probably this week (yes, I know today's Thursday :-). Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH

Re[2]: MySql Server Overload

At 07:34 PM 11/29/2003, you wrote: Hello mike, Saturday, November 29, 2003, 11:45:59 PM, you wrote: m> At 11:14 AM 11/29/2003, you wrote: >>Hello Everybody, >> >>We have a relatively busy e-commerce shop running MySQL 4 + PHP 4. >> >>We have just upgraded to a Pentium 4 - 3ghz , with 1 gb ram bec

Re: Re[2]: mySql BUG

Dyego Souza do Carmo writes: > Sinisa: > > Wednesday, June 11, 2003, 2:16:16 PM, você escreveu: > > ---[inicio]-- > > > > The FileName is l5.zip > > > ---[cortar]-- > > > >

Re[2]: mySql BUG

Sinisa: Wednesday, June 11, 2003, 2:16:16 PM, você escreveu: ---[inicio]-- SM> Hi! SM> Your attachment was stripped off. SM> Please upload it to: SM> ftp://support.mysql.com:/pub/mysql/secret SM> and let us know it's filename. The FileName is l5.zip -

Re: Re[2]: MySql data between Linux and Windows

Character set In windows 2000 latin1 In Linux hosting latin1 Character sets In windows 2000 latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5

Re[2]: MySql data between Linux and Windows

Carlos, > The character sets in both mysql severs in linux and windows are the same. > When I query a table which has the same data in spanish with accents I can see the > characters written are different. 1) So what are the values of the character_set and character_sets variables, anyway? 2) W

Re[2]: MySQL sql query help

Hi Bruce, Thanks for your reply. I just got the time to take a look at it, and it makes sense. However, for the first test: SELECT distinct t.name FROM Teacher t INNER JOIN (TeacherClass tc2 INNER JOIN Class c2 ON tc2.classid = c2.id AND c2.name = 'English') ON t.teacherid = tc2.teac

Re[2]: MySQL Feature

Luc, Zak, >> SELECT aField, COLUMN_IF( some_expression, 'afield2' AS 'aColumn' ) FROM aTable > You can use a WHERE clause to get an effect like this. > SELECT CASE expression > WHEN 'value' > THEN column > ... > ELSE 'default result' > END > FROM Tabl

Re[2]: MySQL 4.0.10 is released

Dan, DR> this is exactly what i am asking , when u say "new gamma development DR> release" (use this for new development) what does it all mean , is it DR> stable for production use ? i would like to know to convince work to start DR> using it ? This discussion is in the list archives a couple

Re: Re[2]: mysql 4.0.8- crash on TCP connection

--- Original Message - From: "Christopher E. Brown" <[EMAIL PROTECTED]> To: "Gelu Gogancea" <[EMAIL PROTECTED]> Cc: "Andrew Sitnikov" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thurs

Re[2]: mysql monitoring?

Hello David, DL> is there an snmp mib or something available for snmp to monitor mysql DL> server? or, does anyone have a script that they would like to share that DL> they use to monitor and gather statistics about mysql? MYSQLSTAT - A set of utilities to monitor, store and display Mysql DBMS us

Re: Re[2]: mysql 4.0.8- crash on TCP connection

On Thu, 9 Jan 2003, Gelu Gogancea wrote: > > Functions gethostby* ,from glibc, work directly with the /etc/hosts file.If > this functions didn't find an entry for the client, will be crashed. > I try to find in the Andrew e-mail if he has installed the glibc 2.2.x but i > don't see nothing about i

Re: Re[2]: mysql 4.0.8- crash on TCP connection

EMAIL PROTECTED]> Sent: Thursday, January 09, 2003 7:48 PM Subject: Re: Re[2]: mysql 4.0.8- crash on TCP connection > On Thu, 9 Jan 2003, Gelu Gogancea wrote: > > > Hi, > > This is a glibc problem.In this case you can start mysql daemon with option > > "--skip

Re: Re[2]: mysql 4.0.8- crash on TCP connection

On Thu, 9 Jan 2003, Gelu Gogancea wrote: > Hi, > This is a glibc problem.In this case you can start mysql daemon with option > "--skip-name-resolve" and in this situation is no need to add the IP address > of every client in hosts file.The disadvantage is that the client can not > connect to the s

Re: Re[2]: mysql 4.0.8- crash on TCP connection

" <[EMAIL PROTECTED]> Cc: "Gelu Gogancea" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, January 09, 2003 7:19 PM Subject: Re[2]: mysql 4.0.8- crash on TCP connection > Hello Christopher, > > CEB> This sounds like what I just submitted a bug

Re: re[2]: MySql 4.1 Sub Selects

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday 11 November 2002 13:03, Richard Morton wrote: > according to this link... 4.1 will have stored procedures > > http://www.mysql.com/products/mysql-4.0/index.html Oops, that page needs to be updated. Stored procedures will come with MySQL 5.0

re[2]: MySql 4.1 Sub Selects

Hi according to this link... 4.1 will have stored procedures http://www.mysql.com/products/mysql-4.0/index.html Rich >> With the efficiency comment below, I was using the strategy that I'd >> prefer >> to wait for 4.1's impending (?) release rather than rewrite SQL in a >> workaround

re: 2 MySQL Servers running on the same machine

Benoit, Thursday, October 10, 2002, 11:32:14 PM, you wrote: BSJ> Is there any documentation/hints/tips avaible on how BSJ> to install 2 (or more) MySQL servers (and clients) on BSJ> the same Windows 2000 box? Some time ago there was a discussion in the mailing list: http://lists.mysql.com/c

Re: 2 mysql daemons starting - both with different configs

At 12:15 +0100 7/28/02, Matt Darcy wrote: >Hi, > >I have copied the file ./support-files/mysql.server to >/etc/init.d/mysql_server. > >I have edited the /etc/init.d/mysql_server to set the basedir to >/usr/local/mysql and the datadir to /usr/local/mysql/var > >When I compiled mysql I set the --wit

Re: re[2]: MySQL Errors -

Richard, Tuesday, July 23, 2002, 3:56:36 PM, you wrote: RM> What instances can cause a Table to crash? RM> Is this caused by a bug in itself, a power failure, or something else? It may be a bug in MySQL, hardware errors, abnormal shutdown, running myisamchk, when mysqld is running ... Some of

re[2]: MySQL Errors -

What instances can cause a Table to crash? Is this caused by a bug in itself, a power failure, or something else? Richard >> William_dw, >> Tuesday, July 23, 2002, 10:34:16 AM, you wrote: >> WS> I'm hoping someone can give me a pointer as to what's going wrong >> that's >> WS> crashi

Re[2]: MySQL 4

Hello MikeParton, Thursday, May 23, 2002, 9:47:13 PM, you wrote: M> What is it you are trying to accomplish with MySQL? M> I have MySQL 4.0.1a running on WinNT 4.0 SP6a with Apache 2.0.36 and PHP M> 4.2.1. So far, in a development environment, MySQL 4.0.1 has done all I M> have asked it to do

Re[2]: --- MySQL

Hello Victoria, Wednesday, April 10, 2002, 3:07:01 PM, you wrote: VR> Hello maxim, VR> Wednesday, April 10, 2002, 2:14:54 PM, you wrote: m>> ñ ÐÉÛÕ ÄÉÐÌÏÍ, É-ÎÅÔ ÍÁÇÁÚÉÎ MySQL+php+Apache .. m>> ÷ÏÐÒÏÓ: ÇÄÅ ÍÏÖÎÏ ÎÁÊÔÉ ÐÏÄÒÏÂÎÕÀ ÄÏËÕÍÅÎÔÁÃÉÀ Ï ÏÓÏÂÅÎÎÏÓÔÑÈ m>> ÉÐÏÌØÚÏ×ÁÎÉÉ SQL × MySQL .. É

Re: Re[2]: Mysql reconnect hang

Peter Zaitsev writes: > Hello Sinisa, > > Wednesday, January 02, 2002, 6:21:59 PM, you wrote: > > > No. This happens then mysql is completely restarted. > I Understand this should not happen but somehow it does. > > > -- > Best regards, > Petermailto:[EMAIL PROTE

Re[2]: Mysql reconnect hang

Hello Sinisa, Wednesday, January 02, 2002, 6:21:59 PM, you wrote: No. This happens then mysql is completely restarted. I Understand this should not happen but somehow it does. >> I've found the following problem often happens to me: >> Then mysqld restarted unclear (sigsegv or server reset) t

Re: Re[2]: Mysql++ and Gcc 3.0 compile problems

BAUMEISTER Alexandre writes: > Do someone see improvements compiling Mysql with Gcc 3.0 ? > > Regards, > Alex. > Don't ask me. I do not have time to install 3.0 on my machine. What improvements would you like to see in the compiled library ?? -- Regards, __ ___ ___ __

Re[2]: Mysql++ and Gcc 3.0 compile problems

SM> I am sending a patch straight to you Do someone see improvements compiling Mysql with Gcc 3.0 ? Regards, Alex. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.my

Re[2]: mysql and PHP problems

>> I have Mysql 3.22 and PHP4 installed with RedHat 7.0 linux >> distribution.I created a script connecting my html page with >> mysql database(function mysql_pconnect).Everything was working >> just fine one day but on the next day I saw a message on my >> screen "Call to undefined function mysql

RE: Re[2]: MySQL FullText improvements in V4.0

At 03:53 PM 5/15/01 +0200, DEVOS BASTIEN wrote: >Excuse me but what do you mean by FullText ? Is this a full-text search >engine in MySQL ??? FULLTEXT is a kind of index in MySQL that allows for faster queries and search-engine like "relevance" values for sorting the results. Here's a link to s

Re: Re[2]: MySQL FullText improvements in V4.0

engine in MySQL ??? > > > -Original Message- > > From: ryc [SMTP:[EMAIL PROTECTED]] > > Sent: Tuesday, May 15, 2001 3:29 PM > > To: James Treworgy; Chris Nichols > > Cc: [EMAIL PROTECTED] > > Subject: Re: Re[2]: MySQL FullText improvements in V4.0 >

RE: Re[2]: MySQL FullText improvements in V4.0

Excuse me but what do you mean by FullText ? Is this a full-text search engine in MySQL ??? > -Original Message- > From: ryc [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, May 15, 2001 3:29 PM > To: James Treworgy; Chris Nichols > Cc: [EMAIL PROTECTED] > Subject:

Re: Re[2]: MySQL FullText improvements in V4.0

What kind of speed can you expect to get from this after tbl_doc_index fills up with tens of millions of rows? Is this scheme suitable for that magnitude of data? Also, if you wish to generate a query that generates all documents that contain token x or token y, would mysql neglect to use the key

Re[2]: MySQL FullText improvements in V4.0

You can do this yourself, pretty easily by building an index in advance. I've been using the following technique to implement full text searching since before it existed in MySQL in any form. Tokenize each unique word in a document and store the word & count in tables: tbl_tokens: token_id int to

Re[2]: Mysql shutdwon very long

Bonjour Heikki, HT> InnoDB will flush the buffer pool and do the purge of old versions HT> at shutdown. It does these operations also when the database is HT> running, but there may be remaining work to do at shutdown. HT> How is the load of your database when you are running it? HT> Does mysqld

Re: Re[2]: MySQL 3.23.33: mysql_character_set_name function in libmysql.dll

Edward Smirnov writes: > Hello Sinisa, > > Saturday, March 31, 2001, 3:45:27 PM, you wrote: > > SM> There is no such function in mysql.h. > > Small piece from mysql.h is below: > ** > char * STDCALL mysql_error(MYSQL *mysql); > char * STDCALL mysql_info

Re[2]: MySQL 3.23.33: mysql_character_set_name function in libmysql.dll

Hello Sinisa, Saturday, March 31, 2001, 3:45:27 PM, you wrote: SM> There is no such function in mysql.h. Small piece from mysql.h is below: ** char * STDCALL mysql_error(MYSQL *mysql); char * STDCALL mysql_info(MYSQL *mysql); unsigned long STDCALL mysql_thread_id

RE: Re[2]: MySQL vs Microsoft SQL

James, >> Gotta say that this is a bad reason to choose one product vs. >> another... because it lacks a GUI to build queries? Undertanding SQL >> is all well and good, but I can tell you that I would give anything to >> have a query builder that works like the one for MS SQL server. You may >>

Re: Re[2]: MySql & Amiga

SixK writes: > Hello Sinisa, > > Saturday, March 24, 2001, 1:38:54 PM, you wrote: > > > I use AmigaOS 3.5 and GCC 2.95.3 (68k). Compatibility to unix is > assumed by the a library called : ixemul.library > > I've planned to port MySql to Morphos that is a brand new OS for PPC > Amiga.

Re[2]: MySql & Amiga

Hello Sinisa, Saturday, March 24, 2001, 1:38:54 PM, you wrote: SM> SixK writes: SM> > Hello, SM> > SM> > First of all, i'm proud to announce the first Port of MySql to SM> > AmigaOs... you know this old gaming computer based on 68000 motorola SM> > chip... you don't know it ?? SM> > never

Re[2]: MySQL vs Microsoft SQL

Gotta say that this is a bad reason to choose one product vs. another... because it lacks a GUI to build queries? Undertanding SQL is all well and good, but I can tell you that I would give anything to have a query builder that works like the one for MS SQL server. You may enjoy writing incredibl

Re[2]: MySQL doesn't support PAM but Radius instead... why Radius?

Hi, PS> If you're looking for PAM modules that authenticate from a mySQL PS> database, I know they exist - although I can't comment on them as I PS> haven't used them before. Nop. I'd like MySQL to authenticate their users through PAM. I want to put userids and passwds on my LDAP server. It w

Re[2]: MYSQL Feature :)

Hello Sinisa, Thursday, March 01, 2001, 3:42:46 PM, you wrote: SM> > I'm not really shure if this is a bug or correct behavior, but still SM> > it leads to toe problems in this case: SM> > SM> > insert into g02layers_stat_hits set counter=1, type=1, page_group=1; SM> > ERROR 1062: Duplicat

Re: Re[2]: MySQL GUI for Windows

CTED]> Cc: indrek siitan <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, February 12, 2001 2:31 PM Subject: Re[2]: MySQL GUI for Windows There is a free, feature-limited version. GBD> Mascon is sweet, but it's not free :) >> can anyone suggest a good GUI client to

Re[2]: MySQL GUI for Windows

There is a free, feature-limited version. GBD> Mascon is sweet, but it's not free :) >> can anyone suggest a good GUI client to suggest to MySQL hosting >> customers? -- Best regards, Jamesmailto:[EMAIL PROTECTED] -

Re[2]: MySQL on a Windows Terminal Server

Thanks for the fast reply, Neil. This is exactly the answer I did not want to hear. Now I am afraid that I have to ask for an "official" statement (Monty, Sinisa?) If it helps, I can dig out my Licence serial number ... Stefan -- Stefan Schmiedl EDV-Beratung, Programmierung, Schulung Loreleystr