Re: command is not allowed with this MySQL version

2014-12-12 Thread hsv
>>>> 2014/12/12 02:10 +0100, Christophe >>>> When the app tries to do this, it raises an error : 'The used command is not allowed with this MySQL version' The used MySQL version is 5.5.40 from Debian Wheezy package. I found that some parameters or variables

[Solved] Re: command is not allowed with this MySQL version

2014-12-12 Thread Christophe
Hi, Le 12/12/2014 11:51, Johan De Meersman a écrit : - Original Message - From: "yoku ts." Subject: Re: command is not allowed with this MySQL version Christophe has already told, The used MySQL version is 5.5.40 from Debian Wheezy package. No, that's the new versi

Re: command is not allowed with this MySQL version

2014-12-12 Thread Johan De Meersman
- Original Message - > From: "yoku ts." > Subject: Re: command is not allowed with this MySQL version > > Christophe has already told, >> > The used MySQL version is 5.5.40 from Debian Wheezy package. No, that's the new version. It'd be

Re: command is not allowed with this MySQL version

2014-12-11 Thread yoku ts.
Hi, Christophe has already told, > > The used MySQL version is 5.5.40 from Debian Wheezy package. Maybe you missed *mysql command-line client's --local-infile option* $ bin/mysql mysql> SELECT @@version; ++ | @@version | ++ | 5.5.40-log | +

Re: command is not allowed with this MySQL version

2014-12-11 Thread Johan De Meersman
- Original Message - > From: "Christophe" > Subject: command is not allowed with this MySQL version > > 'The used command is not allowed with this MySQL version' Out of sheer morbid curiosity, what version were they running? -- Unhappiness is discou

command is not allowed with this MySQL version

2014-12-11 Thread Christophe
dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy) When the app tries to do this, it raises an error : 'The used command is not allowed with this MySQL version' The used MySQL version is 5.5.40 from Debian Wheezy package. I found that some parameters or variables (local_infile

Re: How to get all known bugs on specified mysql version?

2014-07-07 Thread shawn l.green
Hello, On 7/6/2014 7:42 PM, 娄帅 wrote: Hi, all, I want to use MySQL 5.6.18 in production, so i want to get all known bugs on this version. Now i check the "bugfix" section in MySQL 5.6.19 and above version. Am i doing the right thing? Or Do you have a better method? Any input will be appreciate

Re: How to get all known bugs on specified mysql version?

2014-07-07 Thread Reindl Harald
Am 07.07.2014 12:37, schrieb wagnerbianchi.com: > Why do not use GTID? Just curious...WB just read the changelogs and endless count of bugreports it's a new feature and it works as buggy as replication years ago where you had the rebuild the slave all the time and maybe still if temporary table

Re: How to get all known bugs on specified mysql version?

2014-07-07 Thread wagnerbianchi.com
Why do not use GTID? Just curious...WB 2014-07-07 3:18 GMT-03:00 louis liu : > don't use GTID is my suggestion :) > > > > 2014-07-07 7:42 GMT+08:00 娄帅 : > > > Hi, all, > > > > I want to use MySQL 5.6.18 in production, so i want to get all known bugs > > on this version. Now i check the "bugfix"

Re: How to get all known bugs on specified mysql version?

2014-07-06 Thread louis liu
don't use GTID is my suggestion :) 2014-07-07 7:42 GMT+08:00 娄帅 : > Hi, all, > > I want to use MySQL 5.6.18 in production, so i want to get all known bugs > on this version. Now i check the "bugfix" section in MySQL 5.6.19 and above > version. Am i doing the right thing? Or Do you have a better

How to get all known bugs on specified mysql version?

2014-07-06 Thread 娄帅
Hi, all, I want to use MySQL 5.6.18 in production, so i want to get all known bugs on this version. Now i check the "bugfix" section in MySQL 5.6.19 and above version. Am i doing the right thing? Or Do you have a better method? Any input will be appreciated!

RE: MySQL version 3.23 to 5.x features

2013-09-05 Thread Rick James
m] > Sent: Thursday, August 22, 2013 12:16 AM > To: shawn green > Cc: mysql@lists.mysql.com > Subject: Re: MySQL version 3.23 to 5.x features > > wow it really helped me a lot. I really thank Shawn,Dale Jesper for there > inputs > > > On Wed, Aug 21, 2013 at 7:13 PM,

Re: MySQL version 3.23 to 5.x features

2013-08-22 Thread Nagaraj S
wow it really helped me a lot. I really thank Shawn,Dale Jesper for there inputs On Wed, Aug 21, 2013 at 7:13 PM, shawn green wrote: > Hello Naga, > > > On 8/21/2013 6:45 AM, Nagaraj S wrote: > >> Hello, >> >> Can anyone share the features/comparison from MySQL

Re: MySQL version 3.23 to 5.x features

2013-08-21 Thread Jesper Wisborg Krogh
Hi Naga, On 21/08/2013 23:43, shawn green wrote: Hello Naga, On 8/21/2013 6:45 AM, Nagaraj S wrote: Hello, Can anyone share the features/comparison from MySQL version 3.23 to 5.x in single document? I can get from Google, however I have to navigate different pages/sites, if it is in single

Re: MySQL version 3.23 to 5.x features

2013-08-21 Thread shawn green
Hello Naga, On 8/21/2013 6:45 AM, Nagaraj S wrote: Hello, Can anyone share the features/comparison from MySQL version 3.23 to 5.x in single document? I can get from Google, however I have to navigate different pages/sites, if it is in single document that will be useful to see the overview of

MySQL version 3.23 to 5.x features

2013-08-21 Thread Nagaraj S
Hello, Can anyone share the features/comparison from MySQL version 3.23 to 5.x in single document? I can get from Google, however I have to navigate different pages/sites, if it is in single document that will be useful to see the overview of mysql features -Naga

Re: How often should we upgrade MySQL version

2011-11-18 Thread muad shibani
; If you're in such a mission critical situation, you should have spare > servers and live hot-swapable backups anyways right. > > > -Original Message- > From: Neil Tompkins [mailto:neil.tompk...@googlemail.com] > Sent: Friday, November 18, 2011 11:54 AM > To: MySQL

RE: How often should we upgrade MySQL version

2011-11-18 Thread Daevid Vincent
pkins [mailto:neil.tompk...@googlemail.com] Sent: Friday, November 18, 2011 11:54 AM To: MySQL ML Subject: How often should we upgrade MySQL version We are running MySQL 5.1.46 with master to master replication with 3 other servers for 3 different websites in 3 different parts of the world. My q

How often should we upgrade MySQL version

2011-11-18 Thread Neil Tompkins
We are running MySQL 5.1.46 with master to master replication with 3 other servers for 3 different websites in 3 different parts of the world. My question is how often should we be looking to upgrade our MySQL version considering we can't really afford any downtime. Thanks Neil --

Re: Mysql version of database link?

2009-12-07 Thread Johan De Meersman
The FEDERATED engine is what you're looking for, but it probably doesn't quite do what you expect. Full documentation is at http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html . The major gotcha - in my opinion - is that it doesn't actually use indices. If you only need to run sel

Re: Mysql version of database link?

2009-12-07 Thread Steve Edberg
At 12:16 PM -0600 12/7/09, Bryan Cantwell wrote: Does anyone have a suggestion on how a database link (like in Oracle) could be established between two Mysql databases on different servers? It would be awesome if I could write sql that will query both databases in one query... You are probab

Mysql version of database link?

2009-12-07 Thread Bryan Cantwell
Does anyone have a suggestion on how a database link (like in Oracle) could be established between two Mysql databases on different servers? It would be awesome if I could write sql that will query both databases in one query... -- MySQL General Mailing List For list archives: http://lists.mys

How to enable partition in MySQL version 5.0.81-community

2009-11-08 Thread Jeetendra Ranjan
Hi, We are using MySQL version 5.0.81-community.We need to partition few tables but the have_partition option is not available that means this version doesn't support partition feature. Does MySQL provide any patch to enable the feature of partition in the same version of MySQL or h

Re: Using Replication in mySQL version 5

2008-11-20 Thread Jed Reynolds
Tompkins Neil wrote: Hi We are looking to upgrade our version of mySQL to the latest version of mySQL 5. One of the main features we are going to think about using is replication for our website data. Basically we have 2 websites located in the UK and US which share similar information, and we

Re: Using Replication in mySQL version 5

2008-11-19 Thread Jim Lyons
You will probably want to set read_only = 1 in the my.cnf on the slave so only super users can change tables. If you do partial replication, you must be sure your developers do not cross-reference schemas where one is replicated and the other is not. You will either get a replication error tellin

RE: Using Replication in mySQL version 5

2008-11-19 Thread Mary Bahrami
M-M 5.0 replication and M-S 5.1 replication configs running okay for a while -Original Message- From: Tompkins Neil [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2008 2:16 AM To: [MySQL] Subject: Using Replication in mySQL version 5 Hi We are looking to upgrade our versi

Re: Using Replication in mySQL version 5

2008-11-19 Thread Roman Eberle
>Date: Mon, 17 Nov 2008 10:16:16 + >From: "Tompkins Neil" <[EMAIL PROTECTED]> >Subject: Using Replication in mySQL version 5 >We are looking to upgrade our version of mySQL to the latest version of >mySQL 5. One of the main features we are going to think abou

Using Replication in mySQL version 5

2008-11-17 Thread Tompkins Neil
Hi We are looking to upgrade our version of mySQL to the latest version of mySQL 5. One of the main features we are going to think about using is replication for our website data. Basically we have 2 websites located in the UK and US which share similar information, and we are going to be using r

Re: We have just moved to a new web server where we are running mysql version: 5.0.45

2008-04-09 Thread Malka Cymbalista
a Cymbalista wrote: >>We have just moved to a new web server where we are running mysql >>version: 5.0.45 >>On the old machine, when we gave the following command: >>update table1 set passwd = password('xx') where user_name="xx"; >> >>and th

Re: We have just moved to a new web server where we are running mysql version: 5.0.45

2008-04-09 Thread Paul DuBois
At 1:13 PM +0300 4/9/08, Malka Cymbalista wrote: We have just moved to a new web server where we are running mysql version: 5.0.45 On the old machine, when we gave the following command: update table1 set passwd = password('xx') where user_name="xx"; and then gave t

We have just moved to a new web server where we are running mysql version: 5.0.45

2008-04-09 Thread Malka Cymbalista
We have just moved to a new web server where we are running mysql version: 5.0.45 On the old machine, when we gave the following command: update table1 set passwd = password('xx') where user_name="xx"; and then gave the following command, SELECT user_name FROM alon_

Re: Stable MySQL Version

2007-12-19 Thread Amit Nair
Thanks Rob & Team, Installer mysql-essential-5.0.45-win32 worked for me. Rob Wultsch <[EMAIL PROTECTED]> wrote: On Dec 19, 2007 5:26 AM, Amit Nair wrote: > Hi Team > > Sorry for replying late, > > I have downloaded & tried installation with 3 installers. I am getting the > below messsage whi

Re: Stable MySQL Version

2007-12-19 Thread Rob Wultsch
On Dec 19, 2007 5:26 AM, Amit Nair <[EMAIL PROTECTED]> wrote: > Hi Team > > Sorry for replying late, > > I have downloaded & tried installation with 3 installers. I am getting the > below messsage while trying the various installers. > > 1. mysql-essential-5.0.45-winx64 [28641KB] ==> This install

Re: Stable MySQL Version

2007-12-19 Thread Amit Nair
Hi Team Sorry for replying late, I have downloaded & tried installation with 3 installers. I am getting the below messsage while trying the various installers. 1. mysql-essential-5.0.45-winx64 [28641KB] ==> This installation package is not supported by this processor type. Contact your produc

Re: Stable MySQL Version

2007-12-05 Thread Tiago Cruz
On Wed, 2007-12-05 at 07:13 -0800, Amit Nair wrote: > Could some one please let me know a stable version of MySQL for my computer? Version 5.0.45. http://dev.mysql.com/downloads/mysql/5.0.html#win32 -- Tiago Cruz http://everlinux.com Linux User #282636 -- MySQL General Mailing List For lis

Stable MySQL Version

2007-12-05 Thread Amit Nair
Hello Team Could some one please let me know a stable version of MySQL for my computer? Configuration is as below: OS- Windows XP Professional Service Pack 2 Processor – AMD Athlon 64 Processor 2800+ 1.8Ghz RAM – 1 GB Actually I have downloaded one which was meant for AMD processor, but it was

RE: MySql Version difference

2007-01-24 Thread Nilesh
56 AM To: Nilesh Cc: mysql@lists.mysql.com Subject: Re: MySql Version difference >How could i know the difference between these 2 version and there >compatiblity. Read the Change History section of the manual for versions 5.0.19 through 5.0.27. PB - Nilesh wrote: Hi,

Re: MySql Version difference

2007-01-24 Thread Peter Brawley
MySQL 5.0.18 version . Now I plan to use the lastest MySQL version (5.0.27). But before that i want to know the differences between these 2 versions and whether the current database will work fine with 5.0.27 version. How could i know the difference between these 2 version and there compatiblity

Re: MySQL version 4.0.23 uses 99% of processor on FreeBSD 4.11

2006-07-17 Thread Jeremiah Foster
On Fri, 2006-07-14 at 09:47 -0300, Miles Thompson wrote: > At 09:15 AM 7/14/2006, Jeremiah Foster wrote: > >Nearly once or twice a day the mysql daemon on our FreeBSD server has to > >be restarted since it is taking up most of the processor. > > > >That is about 3 hours and a billion rows examined.

Re: MySQL version 4.0.23 uses 99% of processor on FreeBSD 4.11

2006-07-14 Thread Miles Thompson
At 09:15 AM 7/14/2006, Jeremiah Foster wrote: Hello, Nearly once or twice a day the mysql daemon on our FreeBSD server has to be restarted since it is taking up most of the processor. One of the entries in our slow_queries log looks like this; # Query_time: 14074 Lock_time: 0 Rows_sent: 11

MySQL version 4.0.23 uses 99% of processor on FreeBSD 4.11

2006-07-14 Thread Jeremiah Foster
Hello, Nearly once or twice a day the mysql daemon on our FreeBSD server has to be restarted since it is taking up most of the processor. One of the entries in our slow_queries log looks like this; # Query_time: 14074 Lock_time: 0 Rows_sent: 11 Rows_examined: 1020472928 SELECT pp.art_num, pp

Re: restoring database previous mysql version

2006-04-03 Thread Kishore Jalleda
ave 8 mb total SQL database, i'm currently using mysql version: > 4.1.11-debian. > > Our database uses latin5 character set and collate: latin5_turkish_ci > > And now... how can i restore this database without problem; previous mysql > version? > > previous mysql version

restoring database previous mysql version

2006-04-03 Thread murat .
Dear Sir, I have 8 mb total SQL database, i'm currently using mysql version: 4.1.11-debian. Our database uses latin5 character set and collate: latin5_turkish_ci And now... how can i restore this database without problem; previous mysql version? previous mysql version is: 4.0.25-sta

Warning but show warning not available (mysql version 3.21)

2005-04-15 Thread Andy Pieters
Hi all I use a script to build a query and while testing this script by copy'ing it into the mysql console, it shows me a warning. However, the SHOW WARNINGS; is not available on versions < 4. mysql> describe shop_products; ++---+--+-+-+

Re: Extract MySQL Version

2004-10-29 Thread Martijn Tonies
> > > I use the following to extract the version number. But it throws an error > on > > newer version 5.xx. It works on version 4.0 and below. > > > > SELECT SUBSTRING(VERSION(),1,LOCATE("-",VERSION())-1) AS VERSION > > > > On version 5.0.1-alpha-nt-log I get an error... > > Illegal mix of colla

Re: Extract MySQL Version

2004-10-29 Thread Rhino
- Original Message - From: "Fredrick Bartlett" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 29, 2004 12:08 PM Subject: Extract MySQL Version > I use the following to extract the version number. But it throws an error on > newer versio

Extract MySQL Version

2004-10-29 Thread Fredrick Bartlett
I use the following to extract the version number. But it throws an error on newer version 5.xx. It works on version 4.0 and below. SELECT SUBSTRING(VERSION(),1,LOCATE("-",VERSION())-1) AS VERSION On version 5.0.1-alpha-nt-log I get an error... Illegal mix of collations (utf8_general_ci,IMPLICIT

Re: LOAD DATA LOCAL: The used command is not allowed with this MySQL version

2004-10-27 Thread Gleb Paharenko
Hi. See http://dev.mysql.com/doc/mysql/en/LOAD_DATA_LOCAL.html "Martin Rytz" <[EMAIL PROTECTED]> wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ _

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

2004-10-27 Thread Martin Rytz
Hi mysql-community! I have a problem with mysql 3.23.49a: If I try to use the statement 'LOAD DATA LOCAL INFILE '/storage/hosting/uxclients/www.xxx.ch/transfer/golfclub.csv' INTO TABLE test' mysql replys: 'The used command is not allowed with this MySQL version&#

MySQL version and sysklogd-sql problem

2004-10-24 Thread Frank Larsen
I'm banging my head against a somewhat strange problem I hope somewhat more proficient than me can help me with. I'm trying to setup a central logging-server and having it dump all input into a MySQL db for easier access from diferent analisys systems. I've found sysklogd-sql on Sourceforge, wh

How to replace a installed mysql version?

2004-04-13 Thread Walter Andreas
Hi there, I am a bit confused. It is not clear to me that the version I am currently running is the one I compiled last. How can I check the date of compiling? In order to get more performance I did try to install mysql 4.0.18 with different configure commands, now I am not sure if the make insta

Re: An doubt about mysql version 4.0.x agains 4.1.x

2004-03-05 Thread Victoria Reznichenko
"Luiz Rafael Culik Guimaraes" <[EMAIL PROTECTED]> wrote: > Dear Friend > > an friend of mine told that the follow line bellow dont work with mysql > version 4.0.x > > * Support for subqueries and derived tables > This mean query like : SELECT A.* FROM (SELEC

An doubt about mysql version 4.0.x agains 4.1.x

2004-03-05 Thread Luiz Rafael Culik Guimaraes
Dear Friend an friend of mine told that the follow line bellow dont work with mysql version 4.0.x * Support for subqueries and derived tables This mean query like : SELECT A.* FROM (SELECT * FROM TESTE WHERE X = Y) A WHERE COL1 = 3 is this true, or mysql version 4.0.x work properly with this

Re: Mysql version 4.0.x ,LOCKS and Transactions

2004-03-02 Thread Sasha Pachev
Luiz Rafael Culik Guimaraes wrote: Dear Friends Talking with an friend, he told he that mysql 4.0.x has many problems with lock and transactions, is this true. All table that i use are innodb If you program a certain way, you can run into deadlocks which will result in rolled back transactions th

Re: Mysql version 4.0.x ,LOCKS and Transactions

2004-03-02 Thread Daniel Kasak
Luiz Rafael Culik Guimaraes wrote: Dear Friends Talking with an friend, he told he that mysql 4.0.x has many problems with lock and transactions, is this true. All table that i use are innodb Regards Luiz I haven't had any problems. Did your friend elaborate? -- signature Daniel Ka

Mysql version 4.0.x ,LOCKS and Transactions

2004-03-02 Thread Luiz Rafael Culik Guimaraes
Dear Friends Talking with an friend, he told he that mysql 4.0.x has many problems with lock and transactions, is this true. All table that i use are innodb Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.co

Re: MySQL version 4.1.x

2004-02-19 Thread Heikki Tuuri
Hi! - Original Message - From: "Sasha Pachev" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Thursday, February 19, 2004 12:58 AM Subject: Re: MySQL version 4.1.x > lee wrote: > > Anyone know when 4.1.x is scheduled for going "Producti

Re: MySQL version 4.1.x

2004-02-18 Thread Sasha Pachev
lee wrote: Anyone know when 4.1.x is scheduled for going "Production?" The website says it's currently in Alpha. We'd like to upgrade past 4.0.18 if possible, to have the improved subqueries, etc. in 4.1.x. I would guess 4.1.1 is roughly as good on the old features as the latest 4.0. However, I wo

MySQL version 4.1.x

2004-02-18 Thread lee
Anyone know when 4.1.x is scheduled for going "Production?" The website says it's currently in Alpha. We'd like to upgrade past 4.0.18 if possible, to have the improved subqueries, etc. in 4.1.x. > From http://www.mysql.com/doc/en/News-4.0.x.html > > # C.2 Changes in release 4.1.x (Alpha) > *

mysql version 4.1.2

2004-01-19 Thread Kate Lapan Fox
I need MySQL version 4.1.2 build for Windows. Does anyone have a built version of it, or know when it will be released? Thanks for your help, Kate

mysql version problem

2004-01-02 Thread jamie murray
Hi Guys, I am running winxp with mysql. Seeing this is a home machine there is no workstation just one computer which I guess at this point is acting as my server and client for mysql. I am just getting acquainted with mysql so I have been playing around with both 4.1 and 5.0. Neither database is

Re: Somebody tried MySQL version 5 / Stored Procedures

2003-09-28 Thread Hans van Dalen
speed, we want to use > MyISAM db. I plan to write code as an "alternate" transaction mechanism. > But I have read that MySQL version 5 supports Stored Procedures (PL/SQL like). > > In PL/SQL it is possible to use in your stored procedures transactions (at > the end (eg) of

Re: Somebody tried MySQL version 5 / Stored Procedures

2003-09-28 Thread Jeremy Zawodny
On Mon, Sep 29, 2003 at 08:45:39AM +0200, Hans van Dalen wrote: > Hi all, > > We want to migrate to MySQL, and because of its speed, we want to use > MyISAM db. I plan to write code as an "alternate" transaction mechanism. > But I have read that MySQL version 5 suppo

Somebody tried MySQL version 5 / Stored Procedures

2003-09-28 Thread Hans van Dalen
Hi all, We want to migrate to MySQL, and because of its speed, we want to use MyISAM db. I plan to write code as an "alternate" transaction mechanism. But I have read that MySQL version 5 supports Stored Procedures (PL/SQL like). In PL/SQL it is possible to use in your stored

Somebody tried MySQL version 5 / Stored Procedures

2003-09-26 Thread Hans van Dalen
Hi all, We want to migrate to MySQL, and because of its speed, we want to use MyISAM db. I plan to write code as an "alternate" transaction mechanism. But I have read that MySQL version 5 supports Stored Procedures (PL/SQL like). In PL/SQL it is possible to use in your stored

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

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/[E

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/[

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

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

2003-02-12 Thread Mark Matthews
using this command into a Java servlet 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 co

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

2003-02-12 Thread Ahmed S K Anis
TA 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 a

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

2003-02-12 Thread [EMAIL PROTECTED]
error: The used command is not allowed 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.Connecti

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

2003-02-11 Thread Sergei Golubchik
t; this have worked for the last year or so.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(), ran

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

2003-02-08 Thread Aman Raheja
"Tue 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. > > Ex

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

2003-02-06 Thread Tue Tønning
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 randomly => "select fieldName from tableName order by RAND() limit 3" this have worked for the last year or so.but after upgrading our redhat 7

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 >=== > >--

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 Framewo

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 descript

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

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, &

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" INT

re: MySQL - version to install?

2002-11-11 Thread Victoria Reznichenko
Mike, Friday, November 08, 2002, 6:29:29 PM, you wrote: MAS> I've got to do a fresh install of mysql on a webserver (a new server, so it MAS> isn't overwriting anything). Does anyone have any info as whether I should MAS> use just MySQL or MySQL-MAX? What is the difference? If you use v3.23, My

MySQL - version to install?

2002-11-08 Thread Mike At Spy
I've got to do a fresh install of mysql on a webserver (a new server, so it isn't overwriting anything). Does anyone have any info as whether I should use just MySQL or MySQL-MAX? What is the difference? Thanks! :) -Mike -

the highly recomended MySQL version

2002-10-16 Thread usha
Hi Can anyone suggest me the highly recomended MySQL version(non vulnerable). Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

re: highly recomended MySQL version

2002-10-16 Thread Egor Egorov
usha, Wednesday, October 16, 2002, 7:48:26 PM, you wrote: u> Can anyone suggest me the highly recomended (non vulnerable)MySQL version. What about stable version? What OS do you use? 3.23.5X has some loading problems on Linux .. In Ensita we use v3.23.52 and v4.0.4 on production serv

highly recomended MySQL version

2002-10-16 Thread usha
Hi all, Can anyone suggest me the highly recomended (non vulnerable)MySQL version. Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Best MySQL version for replication

2002-10-14 Thread Ross Davis - DataAnywhere.net
I am about to setup the following server layout using all Windows 2000 Server and XP Pro machines. Master Server-| |--Branch Office Server -| ||- Machine 1 ||...

mysqlimport: Error: The used command is not allowed with this MySQL version, when using table

2002-07-31 Thread lana lana
Hello to everybody, I installed mysql ver 11.17 distrib 3.23.49a on redhat 7.2. I would like to import data into database table using command line instructions. I tried mysqlimport but I got the following error messagge mysqlimport: Error: The used command is not allowed with this MySQL version

Re: Error 1148: The used command is not allowed with this MySQL version

2002-07-29 Thread Victoria Reznichenko
Jeffrey, Sunday, July 28, 2002, 8:14:43 PM, you wrote: JAK> Could you help me understand how to correct this error: JAK> "Error 1148: The used command is not allowed with this MySQL version" JAK> I have looked in the online manual under this section for help: JAK> "

Error 1148: The used command is not allowed with this MySQL version

2002-07-28 Thread Jeffrey A. Kirby
Dear Support, Could you help me understand how to correct this error: "Error 1148: The used command is not allowed with this MySQL version" I have looked in the online manual under this section for help: "4.2.4 Security issues with LOAD DATA LOCAL" Unfortunately I am v

Create Table error with MySQL version 3.23.39-max-nt, Access 2000, and MyODBC 2.50.39-nt

2002-07-24 Thread Liz Craig
I am currently using MySQL version 3.23.39-max-nt, MS Access 2000 as my gui, and MyODBC 2.50.39-nt I am able to run reports, queries and use the SQL pass through in access to retrieve data from the MySQL database through MyODBC. The problem is that I can not create a table in MySQL from

Re: MySql version 4.1?

2002-06-14 Thread Przemyslaw Popielarski
"Remy Dufour" <[EMAIL PROTECTED]> wrote: > Anyone here got a hint about release date of My sql version 4.1 ? It was metioned on the mysql-bugs list today: "Alpha version of 4.1 should come out this year." -- Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> -- ./ premax ./ [EMAIL PROTECTED] ./ ko

Re: MySql version 4.1?

2002-06-14 Thread Victoria Reznichenko
Remy, Friday, June 14, 2002, 4:14:54 PM, you wrote: RD> Anyone here got a hint about release date of My sql version 4.1 ? RD> Gracias ! There is no exact date of 4.1 release. It will suddenly come before then end of the year. :) -- For technical support contracts, goto https://order.mysql

MySql version 4.1?

2002-06-14 Thread Remy Dufour
Hi All, Anyone here got a hint about release date of My sql version 4.1 ? Gracias ! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To r

Re: how to deinstall old mysql version?

2002-06-03 Thread Thomas Spahni
On Fri, 31 May 2002, andy wrote: > I am just trying to configure my root server. The provider has preinstalled > mysql on suse72. So I did try to get rid of this installation with yast, but > this did not work out. After compiling php,apache and mysql, PHP is still > trying to connect to the old

how to deinstall old mysql version?

2002-05-31 Thread andy
Hi there, I am just trying to configure my root server. The provider has preinstalled mysql on suse72. So I did try to get rid of this installation with yast, but this did not work out. After compiling php,apache and mysql, PHP is still trying to connect to the old server. The new server is runni

Re: Is there MySQL version 4.0.2 ?

2002-05-15 Thread Paul DuBois
At 9:59 -0600 5/15/02, Colin Faber wrote: >Hi, > >as far as I know the only way that can be correct is to have one of the >committers rename the files them selves that have duplicate names. Since >windows isn't smart enough to realize that "ABC" doesn't mean "abc". > >Good luck getting it working

Re: Is there MySQL version 4.0.2 ?

2002-05-15 Thread Colin Faber
Hi, as far as I know the only way that can be correct is to have one of the committers rename the files them selves that have duplicate names. Since windows isn't smart enough to realize that "ABC" doesn't mean "abc". Good luck getting it working under windows ;-) Viliam Batka wrote: > > Hi ,

Re: Re: Is there MySQL version 4.0.2 ?

2002-05-15 Thread Viliam Batka
Hi , CFc> I've decided to provide a snapshot release system of the data on the CFc> work.mysql.com server for 4.0.x you can access the nightly builds here: CFc> CFc> http://www.mysqldeveloper.com/snapshots/ thank you very much for the option to download the snapshot. Just my Intention is to by i

RE: RAND and MySQL version!

2002-05-14 Thread Gurhan Ozen
t: Tuesday, May 14, 2002 4:26 PM To: [EMAIL PROTECTED] Subject: RAND and MySQL version! Hello All, I am running 2 MySQL servers, one on Linux, and the other on FreeBSD. Linux, MySQL version: 3.23.49 FreeBSD, MySQL version: 3.22.32 Problem: The following code runs on the newer version of MySQL,

  1   2   >