How to write query to select the Max(version) for each unique file_name record?

2003-07-20 Thread Tanamon
Hello All, I am a MySQL newbie trying to write a query that selects file_name records possessing the highest numbered version for that unique file_name. I show sample data and two trial queries below. Logically I want to use max(version) as a constraint in a Where Clause. However, the max

Version 5

2003-07-18 Thread Andy Hartman
After I downloaded the Ver 5 Dev tree how do I get it active. I tried the Windows stuff on the Mysql site with no luck. I run WIndows/ME and have Ver3.23 running. When I try to use the instructions for Compile it fails looking for .c pgms How do I get this to work... would like to use

Re: Version 5

2003-07-18 Thread Paul DuBois
At 19:15 -0500 7/18/03, Andy Hartman wrote: After I downloaded the Ver 5 Dev tree how do I get it active. I tried the Windows stuff on the Mysql site with no luck. the Windows stuff? Please be more specific. The INSTALL-WIN-SOURCE file in the top-level directory of the source tree may be of

Re: Difference of MySQL Standard and Max Version

2003-07-17 Thread Jeremy Zawodny
On Mon, Jul 07, 2003 at 10:57:52AM -0500, Dan Nelson wrote: In the last episode (Jul 07), Nils Valentin said: Thank you for the superfast reply. I actually was looking for other information. I understood the actual feature difference of the standard and f.e max version. Sorry if this didnt

Re: Difference of MySQL Standard and Max Version

2003-07-17 Thread Dan Nelson
of the standard and f.e max version. Sorry if this didnt came out so clear. I will try to make it clearer. My question was more aiming at what advantages the dynamically linking or the statically linking have (except the memory usage of course). I was thinking when given 2 times

Re: dropping foreign key constraint (version 4.1.0-alpha-max-nt)

2003-07-09 Thread Heikki Tuuri
Hi! Starting from version 4.0.13, InnoDB supports ALTER TABLE ... DROP FOREIGN KEY internally_generated_foreign_key_id You have to use SHOW CREATE TABLE to look the internally generated foreign key id when you want to drop a foreign key. Version 4.0.13 came in May, but 4.1.0-alpha was released

Difference of MySQL Standard and Max Version

2003-07-07 Thread Nils Valentin
Hi MySQL Fans ;-); I know that the MySQL Max Server Version is app. 7MB big while the Standard Version is 10MB big. Having looked further into the downloaded files than I see that the max version is dynamically linked while the standard version is statically linked. What is the reason

Re: Difference of MySQL Standard and Max Version

2003-07-07 Thread Delfim Machado
http://www.mysql.com/downloads/mysql-4.0.html The Standard binaries are recommended for most users, and includes the InnoDB storage engine. The Max version includes additional features such as the Berkeley DB storage engine and other features that have not been exhaustively tested

Re: Difference of MySQL Standard and Max Version

2003-07-07 Thread Nils Valentin
Dear Delfim, Thank you for the superfast reply. I actually was looking for other information. I understood the actual feature difference of the standard and f.e max version. Sorry if this didnt came out so clear. I will try to make it clearer. My question was more aiming at what advantages

Re: Difference of MySQL Standard and Max Version

2003-07-07 Thread Dan Nelson
In the last episode (Jul 07), Nils Valentin said: Thank you for the superfast reply. I actually was looking for other information. I understood the actual feature difference of the standard and f.e max version. Sorry if this didnt came out so clear. I will try to make it clearer. My

Re: Difference of MySQL Standard and Max Version

2003-07-07 Thread Nils Valentin
Hi Dan, 2003 7 8 00:57Dan Nelson : In the last episode (Jul 07), Nils Valentin said: Thank you for the superfast reply. I actually was looking for other information. I understood the actual feature difference of the standard and f.e max version. Sorry if this didnt came out so clear

Re: Lookup used Version of MySql MySql Foreign Keys and Referencial Integrity

2003-06-29 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-28 16:56:13 +0200: I use mySQL on HP/UX 11.i - unfortunateley I am unable to lookup the used version. What is the command to do that? (according to mysql.info it is Version 3.23.42. ) SELECT VERSION(); -- If you cc me or remove the list(s) completely I'll

Lookup used Version of MySql MySql Foreign Keys and Referencial Integrity

2003-06-28 Thread Vince Veggus
Hello, I use mySQL on HP/UX 11.i - unfortunateley I am unable to lookup the used version. What is the command to do that? (according to mysql.info it is Version 3.23.42. ) Are foreign keys and referencial integrity supported by MySQL Version 3.23.42. ? If yes - why is the second insert

New mtop/mkill version available

2003-06-23 Thread Marc Prewitt
in this version: mtop has new options to control how many seconds elapse before a slow query is highlighted. Available from: http://mtop.sourceforge.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Latest version of MySQL for windows

2003-06-13 Thread Rajendra . Wadje
What's the latest version of MySQL for windows? Mysql.com says it's 4.1 alpha but the download that reads 4.1 alpha is actually 4.0.12. Is there no version 4.1 available for Windows? Many thanks, rajendra Unless expressly stated to the contrary, the views expressed in this email

Re: Latest version of MySQL for windows

2003-06-13 Thread Becoming Digital
] Sent: Friday, 13 June, 2003 11:57 Subject: Latest version of MySQL for windows What's the latest version of MySQL for windows? Mysql.com says it's 4.1 alpha but the download that reads 4.1 alpha is actually 4.0.12. Is there no version 4.1 available for Windows? Many thanks, rajendra Unless

Which version do I install?

2003-06-12 Thread Jason
I am used to using P3 and P4 machines with the x86 download. I just got myself a Dual Xeon 2.60 Ghz machine. Does this still use the x86 download, or is there a better binary to use (ie IA64)? Any other tips for someone new to the Xeon chip family with linux would be nice too. -- MySQL

Re: Which version do I install?

2003-06-12 Thread William R. Mussatto
I am used to using P3 and P4 machines with the x86 download. I just got myself a Dual Xeon 2.60 Ghz machine. Does this still use the x86 download, or is there a better binary to use (ie IA64)? Any other tips for someone new to the Xeon chip family with linux would be nice too. -- This

Re: Which version do I install?

2003-06-12 Thread Curtis Maurand
x86 IA64 is Itanium. Curtis On Thu, 12 Jun 2003, Jason wrote: I am used to using P3 and P4 machines with the x86 download. I just got myself a Dual Xeon 2.60 Ghz machine. Does this still use the x86 download, or is there a better binary to use (ie IA64)? Any other tips for someone

Re: Find out what version I am using?

2003-06-04 Thread Paul DuBois
At 10:10 +0900 6/4/03, Nils Valentin wrote: offlist Hi Paul, did I get something wrong or did you actually mean mysql SELECT VERSION(); instead of mysql SHOW VERSION(); ??? You're right, I'm wrong. SELECT VERSION(); (In case I am right, I didnt post as I thought is not so polite

Re: Moving to version 4.1

2003-06-02 Thread Daniel Kasak
Robert Mark Bram wrote: Howdy all! I now know that I was running 3.23.55 and that I need 4.1 for Unicode support. I am running Windows XP Pro and in my add or remove programs utility, I see MySQL ODBC 3.51 Driver and MySQL Servers and Clients 3.23.55. If I use Windows add or remove programs

Re: Find out what version I am using?

2003-06-02 Thread Paul DuBois
At 22:52 -0400 5/31/03, Mehrdad Ziaei wrote: That will give you version of mysql client you're running, That seems to have been what the original question was. For version of mysql server, after successful connection to mysql, use status command. mysql status Or telnet to port 3306 of server

Find out what version I am using?

2003-06-01 Thread Robert Mark Bram
Howdy all! How do I find out what version of mysql I am running from the command line? Is there a type of system select statement I can execute? Rob :) :- :-} -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Find out what version I am using?

2003-06-01 Thread Steven Kreuzer
$ mysql --version On Sat, 2003-05-31 at 22:21, Robert Mark Bram wrote: Howdy all! How do I find out what version of mysql I am running from the command line? Is there a type of system select statement I can execute? Rob :) :- :-} -- MySQL General Mailing List For list archives

Re: Find out what version I am using?

2003-06-01 Thread Mehrdad Ziaei
That will give you version of mysql client you're running, For version of mysql server, after successful connection to mysql, use status command. mysql status Or telnet to port 3306 of server running mysql C:\telnet 192.168.1.2 3306 you'll see few garbage and mysql version number in there too

Moving to version 4.1

2003-06-01 Thread Robert Mark Bram
Howdy all! I now know that I was running 3.23.55 and that I need 4.1 for Unicode support. I am running Windows XP Pro and in my add or remove programs utility, I see MySQL ODBC 3.51 Driver and MySQL Servers and Clients 3.23.55. If I use Windows add or remove programs utility to remove MySQL

MySQL 4.0.12 -max-nt Error 1148: Used command is not allowed with this MySQL Version

2003-04-02 Thread DavidCraig
I am trying to load a table from a test delimited file. This worked in the previous version. Any advice on how to accomplish this? D. H. Craig, CSM Have a grateful day! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

MySQL 4.0.12 -max-nt Error 1148: Used command is not allowed with this MySQL Version

2003-04-02 Thread DavidCraig
I am trying to load a table from a test delimited file. This worked in the previous version. Any advice on how to accomplish this? D. H. Craig, CSM Have a grateful day! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: MySQL 4.0.12 -max-nt Error 1148: Used command is not allowed with this MySQL Version

2003-04-02 Thread Martin Gainty
Try sqlimport (it is in the bin directory) Martin - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 4:33 PM Subject: MySQL 4.0.12 -max-nt Error 1148: Used command is not allowed with this MySQL Version I am trying to load a table from

Linux kernel diferences between all kernel version -- differences between all soaps ...

2003-04-01 Thread Luiz Rafael Culik Guimaraes
TheBS Do you mean the stock kernel branches TheBS (2.0, 2.2, 2.4, 2.6)? yes, as you point I need to enumerate the changes between all Version Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Upgrading from 3.23.5x to 4.0.12 version 4 show no tables in any database

2003-04-01 Thread gerald_clark
) 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 4.0.12 Protocol version10 Connection Localhost via UNIX

RE: Upgrading from 3.23.5x to 4.0.12 version 4 show no tables in any database

2003-04-01 Thread Marko Hrastovec
on other four computers which have all RedHat Linux installed. Regards Marko -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 4:26 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Upgrading from 3.23.5x to 4.0.12 version 4 show

Upgrading from 3.23.5x to 4.0.12 version 4 show no tables in any database

2003-03-31 Thread marko . hrastovec
. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 4.0.12 Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 3 days 15 hours 11 min 33

disabling version number

2003-03-24 Thread Florian Effenberger
Hi, is there any configuration directive of disabling the output of the MySQL servers version number? Thanks Florian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: disabling version number

2003-03-24 Thread Paul DuBois
At 16:45 +0100 3/24/03, Florian Effenberger wrote: Hi, is there any configuration directive of disabling the output of the MySQL servers version number? Thanks Florian No, why? -- Paul DuBois http://www.kitebird.com/ sql, query -- MySQL General Mailing List For list archives: http

Re: disabling version number

2003-03-24 Thread Florian Effenberger
No, why? Part of my security concept, I generally disable all version numbers. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: disabling version number

2003-03-24 Thread Joseph Bueno
Florian Effenberger wrote: No, why? Part of my security concept, I generally disable all version numbers. You can patch mysql source and recompile ;) However, if someone has enough access rights on your system to run select version();, showing mysql version number should be the least

RE: disabling version number

2003-03-24 Thread Jeremy Tinley
Authorized != trusted. If you're a hosting provider who allows access to MySQL for customers, your users have access to see the version number by way of simply connecting to their own database. Not that mysql --version from a shell doesn't give you the same thing... but paying for a low end

Re: disabling version number

2003-03-24 Thread Florian Effenberger
;-) - Original Message - From: Joseph Bueno [EMAIL PROTECTED] To: Florian Effenberger [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, March 24, 2003 5:39 PM Subject: Re: disabling version number You can patch mysql source and recompile ;) However, if someone has enough access

RE: disabling version number

2003-03-24 Thread Paul DuBois
At 11:02 -0600 3/24/03, Jeremy Tinley wrote: Authorized != trusted. If you're a hosting provider who allows access to MySQL for customers, your users have access to see the version number by way of simply connecting to their own database. Not that mysql --version from a shell doesn't give you

RE: disabling version number

2003-03-24 Thread Adam Nelson
I would be wary of disabling version(). That's the kind of annoying thing that sys admins do when they don't understand the life of a developer. Some programs and modules require the version() function to work. Security to that extreme is only useful if you understand that it may cause more

RE: disabling version number

2003-03-24 Thread Keith C. Ivey
On 24 Mar 2003 at 11:02, Jeremy Tinley wrote: but paying for a low end account, finding the version number the host is running and finding an exploit for that version would probably be what the original poster had in mind of preventing. Suppose you prevented customers from seeing the version

RE: disabling version number

2003-03-24 Thread Paul DuBois
At 13:35 -0500 3/24/03, Adam Nelson wrote: I would be wary of disabling version(). That's the kind of annoying thing that sys admins do when they don't understand the life of a developer. Some programs and modules require the version() function to work. Security to that extreme is only useful

Re: mysqladmin processlist = weird in version 4.0.12

2003-03-19 Thread Lenz Grimmer
] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE

mysqladmin processlist = weird in version 4.0.12

2003-03-18 Thread Andrew Braithwaite
Hi all, Anyone know why mysqladmin processlist is not showing the host that is connected, but instead is showing the following in v4.0.12: truncated excerpt +-+-+--+--+ | Id | User| Host | db | Command

Re: mysqladmin processlist = weird in version 4.0.12

2003-03-18 Thread R. Hannes Niedner
The change log for 4.012 mentions (Lenz Grimmer just posted this a couple of messages ago): Functionality added or changed: * `SHOW PROCESSLIST' will now include the client TCP port after the hostname to make it easier to know from which client the request originated. I guess whenever

RE: mysqladmin processlist = weird in version 4.0.12

2003-03-18 Thread Jennifer Goodie
to make it easier to know from which client the request originated. -Original Message- From: Andrew Braithwaite [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 2:36 PM To: [EMAIL PROTECTED] Subject: mysqladmin processlist = weird in version 4.0.12 Hi all, Anyone know why mysqladmin

RE: mysqladmin processlist = weird in version 4.0.12

2003-03-18 Thread Andrew Braithwaite
processlist = weird in version 4.0.12 The change log for 4.012 mentions (Lenz Grimmer just posted this a couple of messages ago): Functionality added or changed: * `SHOW PROCESSLIST' will now include the client TCP port after the hostname to make it easier to know from which client the request

RE: mysqladmin processlist = weird in version 4.0.12

2003-03-18 Thread Andrew Braithwaite
Anyone else notice this, or is it just me? Andrew -Original Message- From: Andrew Braithwaite Sent: Tuesday 18 March 2003 23:05 To: 'R. Hannes Niedner'; MySQL Mailinglist Subject: RE: mysqladmin processlist = weird in version 4.0.12 Hi, I do understand what you're saying and I did

Problems with Berkeley DB support in version 3.23.55

2003-03-03 Thread Carsten Thoene
Hallo, we have downloaded the new 3.23.55 mysql DB from you as Source Download Tarball (tar.gz) and want to build them in our environment for tests under SUN OS. We have tared the downloaded version in our Scource Directory environment. (for example directory/mysql/src/mysql-3.23.55) After

Problems with Innobase DB support in version 3.23.55

2003-03-03 Thread Carsten Thoene
Hallo, we have downloaded the new 3.23.55 mysql DB from you as Source Download Tarball (tar.gz) and want to build them in our environment for tests under SUN OS. We have tared the downloaded version in our Scource Directory environment. (for example directory/mysql/src/mysql-3.23.55

mysqlimport : not allowed with this MySQL version

2003-02-20 Thread Gert Cuppens
I have installed MySQL version Release: mysql-3.23.38 (as found in the mysqlbug.txt). When I use mysqlimport, I get the following error code ERROR 1148 : the used command is not allowed with this MySQL version. I get the same message whenever I use LOAD DATA. WHich version should I install

The Solaris 2.7 version of the binaries

2003-02-18 Thread Nesh Nenad Mijailovic
Hi All, is there a reason why there are no MySQL binaries for Solaris 2.7 any more. I have been downloading the binaries before for Solaris 2.7 from the Web Site and now trying to compile the source doesn't work. Is it possible to put a link on the download page to a Solaris 2.7 binaries if

Re: The Solaris 2.7 version of the binaries

2003-02-18 Thread Alan W. Rateliff, II
- Original Message - From: Nesh Nenad Mijailovic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 18, 2003 5:23 PM Subject: The Solaris 2.7 version of the binaries Hi All, is there a reason why there are no MySQL binaries for Solaris 2.7 any more. I have been

Re: The Solaris 2.7 version of the binaries

2003-02-18 Thread Nesh Nenad Mijailovic
at one of the C++ files - could be I need a newer version of the gcc. This is MySQL version 4.0.9 Gamma by the way. Problem is: make all-recursive Making all in include make all-am Making all in Docs make all-am Making all in readline Making all in pstack Making all in aout Making all

JDBC and LOAD DATA LOCAL INFILE : The used command is not allowed with this MySQL version

2003-02-12 Thread [EMAIL PROTECTED]
with this MySQL version at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497) at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:550) at org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java:635) at org.gjt.mm.mysql.Connection.execSQL(Connection.java:882

Re: JDBC and LOAD DATA LOCAL INFILE : The used command is notallowed with this MySQL version

2003-02-12 Thread Ahmed S K Anis
; It runs well with mysql-3.23.45 but not with mysql-3.23.55 The error message is : java.sql.SQLException: General error: The used command is not allowed with this MySQL version at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497

Re: JDBC and LOAD DATA LOCAL INFILE : The used command is not allowedwith this MySQL version

2003-02-12 Thread Mark Matthews
LOAD DATA LOCAL INFILE \ + FIC_DB + \ REPLACE INTO TABLE news; It runs well with mysql-3.23.45 but not with mysql-3.23.55 The error message is : java.sql.SQLException: General error: The used command is not allowed with this MySQL version at org.gjt.mm.mysql.MysqlIO.sendCommand

[ANN] Beta version of Lasso Studio 6 for Dreamweaver MX

2003-02-12 Thread Bill Doerrfeld
Greetings: If you use Dreamweaver MX and are looking for a very easy way to Web-enable your MySQL databases, please check out today's announcement of the immediate availability of the first beta release of Lasso Studio 6 for Dreamweaver MX. Details at:

Re: RAND() Problems in mysql version 3.23.54 and 3.23.55 (linux)

2003-02-11 Thread Sergei Golubchik
.but after upgrading our redhat 7.2 with mysql version 3.23.54 it stopped to work. It always chooses the same 3 entires. try simply mysql -BNe 'select rand(), rand(), rand(), rand()' mysql -BNe 'select rand(), rand(), rand(), rand()' mysql -BNe 'select rand(), rand(), rand(), rand()' to see

Re: RAND() Problems in mysql version 3.23.54 and 3.23.55 (linux)

2003-02-08 Thread Aman Raheja
Tønning [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 05, 2003 1:38 PM Subject: RAND() Problems in mysql version 3.23.54 and 3.23.55 (linux) Hey, I have discovered a strange error in the mysql versions mentioned in subj. Example. A table with 10 entries ...i want to draw 3

LOG ERROR in windows with 4.0.10 version

2003-02-07 Thread Massimo Petrini
The assertion in the manual referred to windows I think is not correct. In my XP version I found the log file as in Unix ie \mysql\data\hostname.err instead \mysql\data\mysql.err as in previous version. Note in my.ini file there is nothing about log-error option . Which is the correct

RAND() Problems in mysql version 3.23.54 and 3.23.55 (linux)

2003-02-06 Thread Tue Tønning
version 3.23.54 it stopped to work. It always chooses the same 3 entires. using a Seed doesnt make it perfect either (i know that the manual says that RAND() isnt perfect - but now it doesnt work at all). A quick search on google says me that im not the only one having the problem. I can also see

Problem with mysqlhotcopy version 1.17 when using --record_log_pos

2003-01-29 Thread Søren Thing Andersen
Description: With mysqlhotcopy version 1.15 (from MySQL-3.23.49-1) I used to do like this: mysqlhotcopy --user=root --password=foo -q --allowold --record_log_pos backup.log_pos db1 db2 backup $TMPDIR After upgrading to MySQL-3.23.55-1 and thus mysqlhotcopy

Problem (server crashes) with Version 3.23.54 on remoteconnections

2003-01-23 Thread Martin Abell
tail -50 sp31.log Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock Time Id CommandArgument 030122 22:51:47 1 Connect root@localhost on 1 Statistics 1 Quit /usr/libexec/mysqld, Version: 3.23.54-log, started

Re: Problem (server crashes) with Version 3.23.54 on remoteconnections

2003-01-23 Thread Stefan Hinz, iConnect \(Berlin\)
, but as soon as you try a connect from some other machine, mysqld segfaults. In all cases I heard of, the problem was some glibc version that caused all the trouble. You say you use glibc-2.2.93-5 This version # looks a bit strange to me, well ... In a SuSE Linux Newsgroup I heard that everything's okay

Re: Version 4 safe to use?

2003-01-14 Thread Jeremy Zawodny
On Fri, Jan 10, 2003 at 01:48:23PM -0300, Maximo Migliari wrote: Cool, you work for Yahoo? Yup. I do a lot of our internal MySQL advocacy and consulting. I used to post from my work address but decided it'd be easier to manage one on-line identity than two. Plus it might help to keep the

Upgrading to version 4.

2003-01-13 Thread Maximo Migliari
this, it is preferable to change the client to use the new 4.0 API. - My company's website is running version 3.23.53a, and the main client that uses MySQL is PHP 4.2.3. Will mysql_connect() no longer work in PHP? Although this manual entry is talking about the C API functions, I assume PHP uses

Re: Upgrading to version 4.

2003-01-13 Thread Stefan Hinz, iConnect \(Berlin\)
Maximo, My company's website is running version 3.23.53a, and the main client that uses MySQL is PHP 4.2.3. Will mysql_connect() no longer work in PHP? Although this manual entry is talking about the C API functions, I assume PHP uses these to communicated with MySQL. Perhaps I might

Re: Upgrading to version 4.

2003-01-13 Thread Paul DuBois
At 23:45 +0100 1/13/03, Stefan Hinz, iConnect (Berlin) wrote: Maximo, My company's website is running version 3.23.53a, and the main client that uses MySQL is PHP 4.2.3. Will mysql_connect() no longer work in PHP? Although this manual entry is talking about the C API functions, I

Re: Upgrading to version 4.

2003-01-13 Thread Zak Greant
MySQL with CFLAGS=-DUSE_OLD_FUNCTIONS. Instead of doing this, it is preferable to change the client to use the new 4.0 API. - My company's website is running version 3.23.53a, and the main client that uses MySQL is PHP 4.2.3. Will mysql_connect() no longer work in PHP? Although

version 4 or 3

2003-01-11 Thread Nuno Lopes
Hi, I would like to know what are the main differencies between the version 4 and and version 3 of mysql. I heard that sql changed in mysql 4. Is this true?? Must I change my existing programs to update the queries?? Thanking in advance, Nuno Lopes

re: version 4 or 3

2003-01-11 Thread Victoria Reznichenko
On Friday 10 January 2003 23:11, Nuno Lopes wrote: I would like to know what are the main differencies between the version 4 and and version 3 of mysql. Check the manual: http://www.mysql.com/doc/en/News-4.0.x.html http://www.mysql.com/doc/en/Nutshell_Other_features.html

Re: Version 4 safe to use?

2003-01-10 Thread Maximo Migliari
Cool, you work for Yahoo? I'd love to know the extent to which Yahoo uses PHP and MySQL these days. What is the average queries/sec that you are getting with MySQL - what server setup, etc? Maximo. At 17:12 9/1/2003 -0800, you wrote: On Thu, Jan 09, 2003 at 01:51:20PM -0300, Maximo Migliari

Re: Version 4 safe to use?

2003-01-09 Thread Maximo Migliari
:00:51AM -0700, David Rock wrote: Are many people using MySQL version 4 yet? I'm interested in it because I want to use it's SSL capabilities but would like to hear that people are not having trouble with it first. I've had very good luck with MySQL 4 in several high-profile environments. We

Re: Version 4 safe to use?

2003-01-09 Thread Paul DuBois
? Maximo. At 09:47 8/1/2003 -0800, you wrote: On Wed, Jan 08, 2003 at 09:00:51AM -0700, David Rock wrote: Are many people using MySQL version 4 yet? I'm interested in it because I want to use it's SSL capabilities but would like to hear that people are not having trouble with it first. I've

Re: Version 4 safe to use?

2003-01-09 Thread William R. Mussatto
On Thu, 9 Jan 2003, Paul DuBois wrote: Date: Thu, 9 Jan 2003 11:29:03 -0600 From: Paul DuBois [EMAIL PROTECTED] To: Maximo Migliari [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Version 4 safe to use? At 13:51 -0300 1/9/03, Maximo Migliari wrote: What were the main benefits that you

Re: Version 4 safe to use?

2003-01-09 Thread Jeremy Zawodny
On Thu, Jan 09, 2003 at 01:51:20PM -0300, Maximo Migliari wrote: What were the main benefits that you noticed straight away before adapting your code to use the new features that MySQL 4 offers? Replication is faster in 4.0. That's a big win for us, as we use replication pretty heavily.

Version 4 safe to use?

2003-01-08 Thread David Rock
Are many people using MySQL version 4 yet? I'm interested in it because I want to use it's SSL capabilities but would like to hear that people are not having trouble with it first. Thanks, David Rock - Before posting, please

Re: Version 4 safe to use?

2003-01-08 Thread Scott Pippin
Are many people using MySQL version 4 yet? I'm interested in it because I want to use it's SSL capabilities but would like to hear that people are not having trouble with it first. We have been using 4.0.x for about five months now on a production system and have had no problems. Scott Pippin

Re: Version 4 safe to use?

2003-01-08 Thread Jeremy Zawodny
On Wed, Jan 08, 2003 at 09:00:51AM -0700, David Rock wrote: Are many people using MySQL version 4 yet? I'm interested in it because I want to use it's SSL capabilities but would like to hear that people are not having trouble with it first. I've had very good luck with MySQL 4 in several

Which version of MySql compile with gcc 3.0.3 on Solaris ?

2002-12-26 Thread Hsiao Ketung Contr 61 CS/SCBN
Hi, Happy holiday ! I'm not happy right now. I can't compile src distribution of mysql-3.23.54a on Sun Solaris 8 with gcc version 3.0.3. Does anyone has luck with Mysql using gcc 3.0.3 ? Is a version of Mysql other than mysql-3.23.54a that can be compiled with gcc version 3.0.3 ? I've

English version of EasyPHP ??

2002-12-14 Thread tmb
- Is there a version of EasyPHP in English? 2 - Is there an EasyPHP mail list or other online user to user support(in English) ? Thanks in advance for any help. tmb __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http

RE: Bug report: Embedded MySQL version 4.05a

2002-12-11 Thread Henry Bequet
: Henry Bequet Subject: Re: Bug report: Embedded MySQL version 4.05a At 15:39 -0800 12/10/02, Matt Solnit wrote: === Bug report -- MySQL v4.05a, binary distribution === -- Machine specs

Bug report: Embedded MySQL version 4.05a

2002-12-10 Thread Matt Solnit
=== Bug report -- MySQL v4.05a, binary distribution === -- Machine specs: -- Compaq Presario desktop Windows XP Professional SP1 .NET Framework SP2 Problem

Re: Bug report: Embedded MySQL version 4.05a

2002-12-10 Thread Paul DuBois
At 15:39 -0800 12/10/02, Matt Solnit wrote: === Bug report -- MySQL v4.05a, binary distribution === -- Machine specs: -- Compaq Presario desktop Windows XP Professional SP1 .NET

The 4.0.6 version

2002-12-02 Thread Dyego Souza do Carmo
Starting from 4.0.6 mysql is declared as gamma ? sql,query - ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento - E S C

Re: The 4.0.6 version

2002-12-02 Thread David T-G
Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE962B6Gb7uCXufRwARAlfBAKCj6ATEOgIK+JD0hfRaaGBZmCM3IQCg2mdv 4YMiaQGwXj5U/bqWArGVhg8= =bHEM -END PGP SIGNATURE- - Before posting, please

re: The 4.0.6 version

2002-12-02 Thread Egor Egorov
Dyego, Monday, December 02, 2002, 2:54:16 PM, you wrote: DSdC Starting from 4.0.6 mysql is declared as gamma ? Yes. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/

info about an old version (v. 3.22.32)

2002-11-28 Thread Marco Andriolo-Stagno
as NOT NULL I have v. 3.23.53-log and with the same statment I have no error; I guess because the new version add 'not null' automagically. Is it right? Can someone tell me from which version is it true? thank you in advance! bye bye! MAS! -- Marco Andriolo-Stagno (MAS

Re: info about an old version (v. 3.22.32)

2002-11-28 Thread Roger Baklund
or INDEX but is not defined as NOT NULL I have v. 3.23.53-log and with the same statment I have no error; I guess because the new version add 'not null' automagically. Is it right? Yes. Can someone tell me from which version is it true? From 3.23.0: URL: http://www.mysql.com/doc/en

re: info about an old version (v. 3.22.32)

2002-11-28 Thread Egor Egorov
complains: MAS Column 'con' is used with UNIQUE or INDEX but is not defined as NOT MAS NULL MAS I have v. 3.23.53-log and with the same statment I have no error; I MAS guess because the new version add 'not null' automagically. MAS Is it right? Yes, exactly. MAS Can someone tell me from which

Fw: Client API version is wrong or am I?

2002-11-25 Thread Jacob Friis Larsen
I have installed the MySQL database 4.0.4 client, but when I look at phpinfo() I see that it says: Client API version: 4.0.2-alpha Why? Regards, Jacob - Before posting, please check: http://www.mysql.com/manual.php

Re: WinMySQLAdmin.exe in mySQL-build 3.23.53 (Windows version)

2002-11-22 Thread DL Neil
separately] WinMySQLadmin used to work well in its previous incarnation. On behalf of your less-capable Win32 brethren, is there any chance that you could Zip the set of requisite files (for only) that WinMySQLadmin (previous version/v-1) and make them available so that we could load them 'over

Re: Version 4.1

2002-11-21 Thread Heikki Tuuri
Daniel, - Original Message - From: Daniel Kiss [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Thursday, November 21, 2002 7:18 AM Subject: Version 4.1 Hi all, I would like to know when MySQL version 4.1 will be available for windows as compiled install kit? my guess

WinMySQLAdmin.exe in mySQL-build 3.23.53 (Windows version)

2002-11-21 Thread Guenter Kukkukk
contains a version of WinMySqlAdmin.exe which has external references to - CreateToolhelp32Snapshot - Process32First - Process32Next in kernel32.dll, which cannot be resolved on WinNT4.0 SP6a! Testing the same with my currently installed mySQL-version 3.23.47, these external references

Error 1148 The error used Command is not allowed with this MySQL-Version

2002-11-20 Thread kwagner
Hello, I downloded MySQL-Version 3.23 for Windows XP from MySQL-webpage. If I try to load a Database from a textfile I got message Error 1148 The error used Command is not allowed with this MySQL-Version. I used following Command: LOAD DATA LOCAL INFILE verlagdaten.txt INTO TABLE verlag; Any

Re: Error 1148 The error used Command is not allowed with this MySQL-Version

2002-11-20 Thread Insanely Great
Windows GUI for MySQL http://www.webyog.com/sqlyog/download.html - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 20, 2002 5:57 PM Subject: Error 1148 The error used Command is not allowed with this MySQL-Version Hello, I downloded MySQL-Version

RE: Error 1148 The error used Command is not allowed with this MySQL -Version

2002-11-20 Thread Morris, Geoffrey E
Use the mysqlc.exe client instead of mysql.exe -- Geoff Morris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 7:28 AM To: [EMAIL PROTECTED] Subject: Error 1148 The error used Command is not allowed with this MySQL -Version

Version 4.1

2002-11-20 Thread Daniel Kiss
Hi all, I would like to know when MySQL version 4.1 will be available for windows as compiled install kit? Thanks, Daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

<    1   2   3   4   5   6   7   8   9   10   >