Re: MySQL DB Version

2010-10-04 Thread Shawn Green (MySQL)
On 10/4/2010 12:32 PM, Tompkins Neil wrote: Account Number : uk600724 Dear Sir/Madam, The MySQL database version which you have supplied to us is version 5.0.77. However, it would appear that we require version to be at least 5.1.43. How can we get our MySQL db upgraded to this version

Re: Error on compile MySQL with version 5.5.6 rc

2010-09-24 Thread Joerg Bruehe
Hi Sharl! Sharl.Jimh.Tsin wrote: hi,everyone i try to compile and install mysql from source tarball,but i failed again again. this is my config string: [r...@powerpc mysql-5.5.6-rc]# ./configure --prefix=/usr/local/mysql --exec-prefix=/usr/local --sysconfdir=/etc/sysconfig/mysql

Re: Error on compile MySQL with version 5.5.6 rc

2010-09-24 Thread Sharl.Jimh.Tsin
On 2010年09月24日 16:27, Joerg Bruehe wrote: Hi Sharl! Sharl.Jimh.Tsin wrote: hi,everyone i try to compile and install mysql from source tarball,but i failed again again. this is my config string: [r...@powerpc mysql-5.5.6-rc]# ./configure --prefix=/usr/local/mysql

Error on compile MySQL with version 5.5.6 rc

2010-09-23 Thread Sharl.Jimh.Tsin
hi,everyone i try to compile and install mysql from source tarball,but i failed again again. this is my config string: [r...@powerpc mysql-5.5.6-rc]# ./configure --prefix=/usr/local/mysql --exec-prefix=/usr/local --sysconfdir=/etc/sysconfig/mysql --localstatedir=/var --enable-profiling

which version is better for production servers?

2010-07-19 Thread Nilnandan Joshi
Hi all, I just wanna make new MySQL server for OLTP kind of environment. I want to use InnoDB storage engine. Which version is better for this kind of environment and which will give the great performance? MySQL 5.1.47/48 or MySQL 5.5? Should we use mysql development release for production

Re: which version is better for production servers?

2010-07-19 Thread Andrés Tello
just wanna make new MySQL server for OLTP kind of environment. I want to use InnoDB storage engine. Which version is better for this kind of environment and which will give the great performance? MySQL 5.1.47/48 or MySQL 5.5? Should we use mysql development release for production server

Re: which version is better for production servers?

2010-07-19 Thread Nilnandan Joshi
:05 AM, Nilnandan Joshi nilnand...@synechron.com mailto:nilnand...@synechron.com wrote: Hi all, I just wanna make new MySQL server for OLTP kind of environment. I want to use InnoDB storage engine. Which version is better for this kind of environment and which will give

RE: which version is better for production servers?

2010-07-19 Thread Gavin Towey
No, current GA is 5.1.48 -Original Message- From: Nilnandan Joshi [mailto:nilnand...@synechron.com] Sent: Monday, July 19, 2010 6:14 AM To: Andrés Tello Cc: mysql@lists.mysql.com Subject: Re: which version is better for production servers? But, can we get GA releases for MySQL 5.5

Re: Why is MySQL always linked to Php? The history channel version...

2010-07-15 Thread Andrés Tello
HIstorical convinience: A certification program for oracle or db2 requires a lot of money and time. The facilities oracle and db2 can offer to the dba includes things that the S.O should to. Exaple: raw spaces and table spaces, hot copy, replication, etc... Many of this facilities used to be

Benetl, a free ETL tool for files using mySQL, is out in version 3.5.

2010-06-19 Thread Benoît Carpentier
Dear all, Benetl, a free ETL tool for files using mySQL, is out in version 3.5. You can freely download it at: www.benetl.net This version brings bugs correction and if operator for conditions in part formula. You should update. You can learn more about ETL tools at: http://en.wikipedia.org

Version-differing replication trouble

2010-06-16 Thread Johan De Meersman
Hey list, Got another strange problem. I'm in the process of migrating a 4.1 server to a 5.1. Replication is not compatible between them, so I have an intermediate 5.0 server. Setup is thus: 4.1 - 5.0 - 5.1 The server-id is different on all servers. It's been soft-set, followed by a flush

when will version 5.1.6 of the odbc connector become available ?

2010-06-07 Thread wim . delvaux
I need some bugs fixed W -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

ANN: New version of Database Workbench, the multi-DBMS IDE now available!

2010-04-22 Thread Martijn Tonies
Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: Database Workbench 4.0 Pro With this version we're reached a milestone: Database Workbench is now fully Unicode enabled and offers new tools to increase your productivity

Re: upgrade from version 5.0.45

2010-04-05 Thread Rob Wultsch
On Sun, Apr 4, 2010 at 9:29 PM, Walter Heck - OlinData.com li...@olindata.com wrote: Depending on the seriousness of your environment you can read the changelogs and upgrade if you don't see any showstoppers. I have hardly ever seen any problems with minor version upgrades of mysql. Of course

Re: upgrade from version 5.0.45

2010-04-04 Thread Rob Wultsch
On Tue, Mar 30, 2010 at 6:36 AM, Marco Baiguera marco.baigu...@gmail.com wrote: Hello everyone, i am quite new to mysql and i recently begin to work with a company who is using mysql 5.0.45 in production. i think this version is too old and would like to upgrade to the most recent 5.0.xx my

Re: upgrade from version 5.0.45

2010-04-04 Thread Walter Heck - OlinData.com
Depending on the seriousness of your environment you can read the changelogs and upgrade if you don't see any showstoppers. I have hardly ever seen any problems with minor version upgrades of mysql. Of course what Rob says is true, and it is a good idea to test things out in a test environment

Re: upgrade from version 5.0.45

2010-04-04 Thread Jesper Wisborg Krogh
Be aware that if it is an unpatched version of 5.0.77, then there is a bug related to name_const (http://bugs.mysql.com/bug.php?id=42014) that can cause serious problems (infinite server crashes if it happens in a replication thread). Redhat/CentOS have applied the patch, but other sources

RE: upgrade from version 5.0.45

2010-04-01 Thread Parikh, Dilip Kumar
, 2010 7:07 PM To: mysql@lists.mysql.com Subject: upgrade from version 5.0.45 Hello everyone, i am quite new to mysql and i recently begin to work with a company who is using mysql 5.0.45 in production. i think this version is too old and would like to upgrade to the most recent 5.0.xx my os

upgrade from version 5.0.45

2010-03-31 Thread Marco Baiguera
Hello everyone, i am quite new to mysql and i recently begin to work with a company who is using mysql 5.0.45 in production. i think this version is too old and would like to upgrade to the most recent 5.0.xx my os is CentOS release 5.3. is it safe to simply use yum upgrade mysql

Re: 5.1.44 community version select ordno=' ' error (2)

2010-03-04 Thread wang shuming
Oh, If any char fields add to index key ,then the =' ' gets wrong . ordno, qty ,mem 1 3 5 aaa18 b 20 1. CREATE TABLE `t1` ( `mid` int(11) NOT NULL, `qty` decimal(12,2) NOT NULL DEFAULT '0.00', `ordno` char(8) NOT NULL

Re: 5.1.44 community version select ordno=' ' error (2)

2010-03-04 Thread Peter Brawley
by AVG - www.avg.com Version: 8.5.435 / Virus Database: 271.1.1/2721 - Release Date: 03/03/10 19:34:00

5.1.44 community version select ordno=' ' error (2)

2010-03-03 Thread wang shuming
' 20 mysql version 5.1.44 still with the bug Best regards! Shuming Wang

Re: 5.1.44 community version select ordno=' ' error (2)

2010-03-03 Thread Dan Nelson
* from t1 where ordno=' ' ordno qty 'aaa' 18 'b' 20 mysql version 5.1.44 still with the bug Best regards! Shuming Wang -- Dan Nelson dnel...@allantgroup.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

5.1.42 community version select ordno=' ' error

2010-03-01 Thread wang shuming
Hi, Any table with a ordno char(n) not null field for example ordno qty 35 0 1 'abc' 3 '000' 100 select * from table1 where ordno' ' or ordno=' ' 3 rows select * from table1 where ordno=' ' 0 rows best regard! Shuming

5.1.42 community version select ordno=' ' error (2)

2010-03-01 Thread wang shuming
Hi, Any table with a ordno char(n) not null field for example ordno qty 35 0 1 'abc' 3 '000' 100 select * from table1 where ordno' ' or ordno=' ' 5 rows select * from table1 where ordno=' ' 2 rows best regard! Shuming

Re: 5.1.42 community version select ordno=' ' error (2)

2010-03-01 Thread Dan Nelson
In the last episode (Mar 02), wang shuming said: Hi, Any table with a ordno char(n) not null field for example ordno qty 35 0 1 'abc' 3 '000' 100 select * from table1 where ordno' ' or ordno=' ' 5 rows

Re: version 5 to 4

2010-02-15 Thread Glyn Astill
--- On Mon, 15/2/10, Prathima Rao prathiman...@vsnl.net wrote: From: Prathima Rao prathiman...@vsnl.net Subject: Re: version 5 to 4 To: mysql@lists.mysql.com Date: Monday, 15 February, 2010, 7:09 hi mysql tem, i have a version 5 on which i have developed a database now one

Re: version 5 to 4

2010-02-15 Thread Peter Brawley
i need this data in version 4 Create the mysqldump script with the --compatible-mysql4 option. PB - Prathima Rao wrote: hi mysql tem, i have a version 5 on which i have developed a database now one of the systmem has 4 i tried to migrate from 5 to 4 it says THE TABLES HAVE BEEN

version 5 to 4

2010-02-14 Thread Prathima Rao
hi mysql tem, i have a version 5 on which i have developed a database now one of the systmem has 4 i tried to migrate from 5 to 4 it says THE TABLES HAVE BEEN CREATED IN LATER VERSION I AM not able to see any table any solutions for this? i need this data in version 4 pls help Thanks

Re: version 5 to 4

2010-02-14 Thread Prathima Rao
hi mysql tem, i have a version 5 on which i have developed a database now one of the systmem has 4 i tried to migrate from 5 to 4 it says THE TABLES HAVE BEEN CREATED IN LATER VERSION I AM not able to see any table any solutions for this? i need this data in version 4 pls help Thanks

version

2010-01-14 Thread tony . chamberlain
I have an install script that does some stuff with mysql (i.e. install, start, etc). It installs mysql Ver 14.12 Distrib 5.0.19, for pc-linux-gnu (i686) using readline 5.0 This was good when we just used CentOS 4.5. Now we are doing some later CentOS versions and the mysql version may

Re: version

2010-01-14 Thread Johan De Meersman
later CentOS versions and the mysql version may be higher. I want to do something like mysql --version and process the result and if the version is = 5.0.19 skip the mysql installation and just do the other stuff. I can't compare as it is right now because the . and stuff may screw up

Re: version

2010-01-14 Thread tony . chamberlain
I am using RPM. And for Centos 5 it was installing a lower version of mysql than what was installed with the system. That is why I want to check before doing the RPM. I guess the alternative is to use the latest version all the time, but not sure whether that will work on the 4.5 version

Re: version

2010-01-14 Thread Johan De Meersman
To: tony.chamberl...@lemko.com Cc: mysql@lists.mysql.com Subject: Re: version You *should* be using a package manager (perfectly fine RPMs available for all your needs), but if you must do this, it's a reasonably safe bet to right-align and zero-pad all your number to 4 digits, at which point you're

Re: Benetl, a free ETL tool for files using MySQL, is out in version 3.3

2010-01-01 Thread benoît carpentier
Dear all, Benetl, a free ETL tool for files using MySQL, is out in version 3.3. You can freely download it at: www.benetl.net This version brings two new improvements, you should update. You can learn more about ETL tools at: http://en.wikipedia.org/wiki/Extract,_transform,_load Thanks

ERROR 1235 (42000): This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

2009-12-08 Thread Jeetendra Ranjan
Hi, I just would like to know which version of MySQL support the creation of database triggers with the same action and event for one table. Because if i create the the triggers as below i am getting error. First trigger (Succesfull) ++ CREATE TRIGGER CONSUMER_PROFILE_before_delete

Re: ERROR 1235 (42000): This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

2009-12-08 Thread Jesper Wisborg Krogh
On Wed, 9 Dec 2009 16:39:33 Jeetendra Ranjan wrote: Hi, I just would like to know which version of MySQL support the creation of database triggers with the same action and event for one table. I'm not sure there is any plan to implement support for multiple triggers with the same action

Re: ERROR 1235 (42000): This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

2009-12-08 Thread Martijn Tonies
I just would like to know which version of MySQL support the creation of database triggers with the same action and event for one table. I'm not sure there is any plan to implement support for multiple triggers with the same action and timing. I certainly hope so... If not, it seems yet

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:

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

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

Removing MySQL to install new version

2009-11-12 Thread Miguel Cardenas
Hello I noticed that mysql 6 alpha is no longer available so I want to remove it from my laptop and install the latest 5.x version. I have just restored my Linux system image so my database is clean and empty and is a good moment to do it. My question is, how can I remove it completely from my

Re: Removing MySQL to install new version

2009-11-12 Thread Carlos Proal
Yes, you only have to delete the directories. Carlos On 11/12/2009 8:16 AM, Miguel Cardenas wrote: Hello I noticed that mysql 6 alpha is no longer available so I want to remove it from my laptop and install the latest 5.x version. I have just restored my Linux system image so my database

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 how

Mysql Upgrade from version 4 to 5

2009-10-21 Thread Tharanga Abeyseela
Hi Guys, Iam going to upgrade mysql version 4 to version 5.x on redhat ES4 . is there any particular way to do that ? if i take a mysqldump of the database and simply restore on to version 5 will work ? are there any differences between syntaxes/db structure etc on those 2 versions ? Thanks

RE: Mysql Upgrade from version 4 to 5

2009-10-21 Thread Gavin Towey
See: http://dev.mysql.com/doc/refman/5.0/en/upgrade.html -Original Message- From: Tharanga Abeyseela [mailto:tharanga.abeyse...@gmail.com] Sent: Wednesday, October 21, 2009 2:34 PM To: mysql@lists.mysql.com Subject: Mysql Upgrade from version 4 to 5 Hi Guys, Iam going to upgrade mysql

Benetl, a free ETL tool for files using postgreSQL, is out in version 3.2

2009-10-19 Thread benoît carpentier
Dear all, Benetl, a free ETL tool for files using MySQL, is out in version 3.2. This new version is now supporting Java SE 6 and using memory arguments for JVM. You can freely download it at : www.benetl.net You can learn more about ETL tools at: http://en.wikipedia.org/wiki/Extract

Benetl, a free ETL tool for files using postgreSQL, is out in version 3.2

2009-10-14 Thread benoît carpentier
Dear all, Benetl, a free ETL tool for files using postgreSQL and MySQL, is out in version 3.2. You can freely download it at : www.benetl.net This new version is now supporting Java SE 6 and using memory arguments for JVM. You can learn more about ETL tools at: http://en.wikipedia.org

Mysql Perl DBI DBD Version Compatability for MAC OS 10.6

2009-10-05 Thread Hagen
After installing Apple's MAC Snow Leopard OS 10.6 I haven't been able to get my DBD:mysql module to work. I am kind of beyond trying to fix that issue directly so I am requesting assistance defining a compatible version set which is known to work. Between various releases and 32/64 bit options

RE: Mysql Perl DBI DBD Version Compatability for MAC OS 10.6

2009-10-05 Thread Gavin Towey
DBI DBD Version Compatability for MAC OS 10.6 After installing Apple's MAC Snow Leopard OS 10.6 I haven't been able to get my DBD:mysql module to work. I am kind of beyond trying to fix that issue directly so I am requesting assistance defining a compatible version set which is known to work

Re: Mysql Perl DBI DBD Version Compatability for MAC OS 10.6

2009-10-05 Thread Hagen Finley
Version Compatability for MAC OS 10.6 After installing Apple's MAC Snow Leopard OS 10.6 I haven't been able to get my DBD:mysql module to work. I am kind of beyond trying to fix that issue directly so I am requesting assistance defining a compatible version set which is known to work. Between

RE: Mysql Perl DBI DBD Version Compatability for MAC OS 10.6

2009-10-05 Thread Gavin Towey
To: Gavin Towey Cc: mysql@lists.mysql.com Subject: Re: Mysql Perl DBI DBD Version Compatability for MAC OS 10.6 Here is the error I am receiving ( I posted this issue in the recent past): dyld: lazy symbol binding failed: Symbol not found: _mysql_init Referenced from: /Library/Perl/5.10.0/darwin-thread

Benetl, a free ETL tool for files using postgreSQL, is out in version 3.1 - update

2009-09-22 Thread benoît carpentier
Dear all, Benetl, a free ETL tool for files using postgreSQL (and now MySQL), is out in version 3.1. A small correction has been done to Benetl 3.1. This is now available online. You can freely download it at : www.benetl.net This new version brings the support of long as date. Benetl

free ETL tool for files using MySQL, Benetl version 3.1

2009-09-21 Thread benoît carpentier
Dear all, Benetl, a free ETL tool for files now using MySQL is out in version 3.1. You can freely download it at : www.benetl.net You can learn more about ETL tools at: http://en.wikipedia.org/wiki/Extract,_transform,_load Thanks for your interest. Regards, -- Benoît Carpentier

Re: Downloading old version of MySQL ?

2009-08-31 Thread Joerg Bruehe
Hi David, all, David Harrison wrote: Hi all, I'm trying to drag a database through the upgrade process from 5.0.32 but I keep running into small cross-version compatibility issues. [[...]] So it looks like I now need a 5.0.34 install to transition through, but I can't find anywhere

Downloading old version of MySQL ?

2009-08-30 Thread David Harrison
Hi all, I'm trying to drag a database through the upgrade process from 5.0.32 but I keep running into small cross-version compatibility issues. At present my live database is running 5.0.32 and is large enough that it would take too long (read days) to perform an upgrade on, and drives

Re: MySQL Windows version

2009-07-16 Thread russbucket
russbucket wrote: I have been using the Linux version of MySQL for five years, also used it on a Windows ME system even though documents said you couldn't. Recent a friend asked me to help him get it up and running on a Windows Vista system. I was looking for the system configuration

RE: MySQL Windows version

2009-07-13 Thread Jerry Schwartz
-Original Message- From: russbucket [mailto:russbuc...@nwi.net] Sent: Friday, July 10, 2009 12:09 PM To: mysql@lists.mysql.com Subject: MySQL Windows version I have been using the Linux version of MySQL for five years, also used it on a Windows ME system even though documents said you

Re: MySQL Windows version

2009-07-12 Thread russbucket
hoping to get him using. Other choice is use Excel. So I hope one of these recommendations works. Thank for your response. As phpMyadmin is a web application run through a web server, there is no Linux or Windows version. They all work on any web server. You just un zip/rar/tar etc

Re: MySQL Windows version

2009-07-11 Thread russbucket
Marcus Bointon wrote: On 10 Jul 2009, at 17:18, mos wrote: Is there a Windows application that works like phpMyAdmin? I tried MySQLAdmin on my Linux system, but I could not cut and paste SQL Commands into the editor. You could run php (and thus phpmyadmin) on windows - in contrast with

Re: MySQL Windows version

2009-07-11 Thread russbucket
russbucket wrote: I have been using the Linux version of MySQL for five years, also used it on a Windows ME system even though documents said you couldn't. Recent a friend asked me to help him get it up and running on a Windows Vista system. I was looking for the system configuration

Re: MySQL Windows version

2009-07-11 Thread B J Ambrose
using. Other choice is use Excel. So I hope one of these recommendations works. Thank for your response. As phpMyadmin is a web application run through a web server, there is no Linux or Windows version. They all work on any web server. You just un zip/rar/tar etc. the latest version

MySQL Windows version

2009-07-10 Thread russbucket
I have been using the Linux version of MySQL for five years, also used it on a Windows ME system even though documents said you couldn't. Recent a friend asked me to help him get it up and running on a Windows Vista system. I was looking for the system configuration requirements but could

Re: MySQL Windows version

2009-07-10 Thread mos
At 11:08 AM 7/10/2009, russbucket wrote: I have been using the Linux version of MySQL for five years, also used it on a Windows ME system even though documents said you couldn't. Recent a friend asked me to help him get it up and running on a Windows Vista system. I was looking for the system

Re: MySQL Windows version

2009-07-10 Thread Marcus Bointon
On 10 Jul 2009, at 17:18, mos wrote: Is there a Windows application that works like phpMyAdmin? I tried MySQLAdmin on my Linux system, but I could not cut and paste SQL Commands into the editor. You could run php (and thus phpmyadmin) on windows - in contrast with earlier versions, 5.3

RE: MySQL Windows version

2009-07-10 Thread Jason Trebilcock
-Original Message- From: russbucket [mailto:russbuc...@nwi.net] Sent: Friday, July 10, 2009 11:09 AM To: mysql@lists.mysql.com Subject: MySQL Windows version I have been using the Linux version of MySQL for five years, also used it on a Windows ME system even though documents

New version of open source MySQL appliance

2009-03-04 Thread Liraz Siri
Hello everyone, We just released a new version of our MySQL appliance: http://www.turnkeylinux.org/appliances/mysql In a nutshell, this is an extremely easy way to get a MySQL instance up and running on your server or VM (VMware, VirtualBox, Xen, KVM) of choice in just a couple of minutes

Maatkit version 2725 released

2008-12-28 Thread Baron Schwartz
This release is all about mk-log-parser http://www.maatkit.org/doc/mk-log-parser.html, which is vastly improved and has respectable documentation now too. I know a couple people on the MySQL list were watching this tool with interest, which is why I'm cross posting. Thanks very much to Pythian

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 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 about using is replication for our website

RE: Using Replication in mySQL version 5

2008-11-19 Thread Mary Bahrami
-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 version of mySQL to the latest

Re: Using Replication in mySQL version 5

2008-11-19 Thread Jim Lyons
telling you that something doesn't exist or you won't get any error, but the slave may well get out of sync. On Mon, Nov 17, 2008 at 4:16 AM, Tompkins Neil [EMAIL PROTECTED] wrote: Hi We are looking to upgrade our version of mySQL to the latest version of mySQL 5. One of the main features we

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

Re: [ANN] PBXT Beta Version Released!

2008-09-03 Thread Paul McCullagh
to announce that the Beta version of PBXT has just been released. PBXT is a fast, lightweight, transactional storage engine for MySQL. More information is available at http://www.primebase.org. You can download the source code at http://www.primebase.org/ download. I have also updated the documentation

[ANN] PBXT Beta Version Released!

2008-09-02 Thread Paul McCullagh
Hi All! I am pleased to announce that the Beta version of PBXT has just been released. PBXT is a fast, lightweight, transactional storage engine for MySQL. More information is available at http://www.primebase.org. You can download the source code at http://www.primebase.org/download. I

Re: [ANN] PBXT Beta Version Released!

2008-09-02 Thread mos
Paul McCullagh, What's the advantage of using PBXT over InnoDb or the new Falcon transactional engine? TIA Mike Hi All! I am pleased to announce that the Beta version of PBXT has just been released. PBXT is a fast, lightweight, transactional storage engine for MySQL. More information

ANN: MicroOLAP DAC for MySQL 2.6.3 released, Tiburon-version prepared

2008-08-30 Thread Mikhail Oleynik
Greetings! We are glad to announce DAC for MySQL versions 2.6.3 and 2.7.0-beta (August 28, 2008) release. This release introduces extended syntax for TmySQLDataset.Filter property. Several bugfixes and improvements are also added. First Delphi/C++Builder 2009 (Tiburon) beta-version

to move tables to new version

2008-08-04 Thread Yavuz Maslak
I use mysql4.1.22. I have some domains which use mysql databases. I am going to change my old machine with a stronger machine. Also I think to install mysql 5.0 Will there be any problem about my domains ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: to move tables to new version

2008-08-04 Thread Ananda Kumar
what is your plan to move the data to new mysql version. Ideally, there should not be any problem. regards anandkl On 8/4/08, Yavuz Maslak [EMAIL PROTECTED] wrote: I use mysql4.1.22. I have some domains which use mysql databases. I am going to change my old machine with a stronger machine

Re: Does version 4 mysqlcheck close MyISAM tables left open?

2008-04-20 Thread Eric Bergen
Nicole, The tables left open warning is from the tables that were left open when the server was rebooted. Internally mysql keeps a counter per table of the number of clients that have a table open. When a table is closed this counter is decremented. If mysql is improperly shutdown this counter

Does version 4 mysqlcheck close MyISAM tables left open?

2008-04-15 Thread Garris, Nicole
Unable to find this in the manual ... Yesterday morning we rebooted the server by accident, which crashed and restarted MySQL 4.1. Late last night a scheduled job ran mysqlcheck and found 4 open tables. When I next ran mysqlcheck it found nothing wrong. mysqlcheck command: CHECK TABLE $DBTABLES

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_protein_passwd WHERE

RE: We have just moved to a new web server where we are runningmysql version: 5.0.45

2008-04-09 Thread Edward Kay
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; Here you're updating 'table1'... and then gave the following command, SELECT user_name

RE: We have just moved to a new web server where we are runningmysql version: 5.0.45

2008-04-09 Thread 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; Here you're updating 'table1'... and then gave the following command, SELECT

Re: We have just moved to a new web server where we arerunningmysql version: 5.0.45

2008-04-09 Thread Martijn Tonies
Thanks for the answer but that's not it. It was my typo. I am really updating and selecting from the same table. Perhaps not it either, but strings should be in single quotes, not double quotes. Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions

Re: We have just moved to a new web server where we arerunningmysql version: 5.0.45

2008-04-09 Thread Malka Cymbalista
Thanks for the email but that didn't help. I gave the commands again using only single quotes and I still get no results. On the old machine we were running MySQL 4.0.15a. Is there any difference with the password function in these 2 versions? -- Malka Cymbalista Webmaster, Weizmann

Re: We have just moved to a new web server where wearerunningmysql version: 5.0.45

2008-04-09 Thread Martijn Tonies
Thanks for the email but that didn't help. I gave the commands again using only single quotes and I still get no results. On the old machine we were running MySQL 4.0.15a. Is there any difference with the password function in these 2 versions? Could be, I remember MySQL 4.1 having a new

Re: We have just moved to a new web server where wearerunningmysql version: 5.0.45

2008-04-09 Thread Malka Cymbalista
Thanks. So how does one use the password function in MySQL 5? -- Malka Cymbalista Webmaster, Weizmann Institute of Science [EMAIL PROTECTED] 08-934-3036 On 4/9/2008 at 2:57 PM, in message [EMAIL PROTECTED], Martijn Tonies [EMAIL PROTECTED] wrote: Thanks for the email but that didn't help.

Re: We have just moved to a new web server wherewearerunningmysql version: 5.0.45

2008-04-09 Thread Martijn Tonies
-hashing.html http://dev.mysql.com/doc/mysql/search.php?version=5.0q=passwordfrom=%2Fdoc%2Frefman%2F5.0%2Fen%2Flang=en Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development

Re: We have just moved to a new web server wherewearerunningmysql version: 5.0.45

2008-04-09 Thread Martijn Tonies
PS, the document I send you also mentions: To change the password but create a short hash, use the OLD_PASSWORD() function instead: Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle MS SQL Server Upscene Productions http://www.upscene.com My thoughts:

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 the following command, SELECT

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
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_protein_passwd WHERE (user_name = xx

R: version mimatch

2008-03-27 Thread Nanni Claudio
, dump the databases and reimport them in the MySQL 3.x server. Finally my hint is to upgrade the DB server to 5.x version, It's much much better and it is not hard to do the migration. Aloha! Claudio Nanni -Messaggio originale- Da: Naufal Sheikh [mailto:[EMAIL PROTECTED] Inviato: lunedì

version mimatch

2008-03-24 Thread Naufal Sheikh
Hi, I had binlogs from the mysql 4 which I was trying to get into mysql3 using the mysqlbinlog utility. Obviously I got the version mismatch error i.e ERROR 1064 at line 8: You have an error in your SQL syntax near 'DEFAULT ROW_FORMAT=DEFAULT' at line 1 My question, is there anywaay to make

Re: [ANN] PBXT storage engine version 1.0-Alpha released

2008-03-21 Thread Moon's Father
, 2008, at 8:30 AM, Sebastian Mendel wrote: Paul McCullagh schrieb: Hi All, I have just released the first fully durable version of PBXT. Because of the amount of new code I have reverted PBXT to Alpha status. This version, 1.0-alpha, can be downloaded from: http:// www.primebase.org

Re: [ANN] PBXT storage engine version 1.0-Alpha released

2008-03-18 Thread Sebastian Mendel
Paul McCullagh schrieb: Hi All, I have just released the first fully durable version of PBXT. Because of the amount of new code I have reverted PBXT to Alpha status. This version, 1.0-alpha, can be downloaded from: http://www.primebase.org/download. will there be any Windows builds

Re: [ANN] PBXT storage engine version 1.0-Alpha released

2008-03-18 Thread Paul McCullagh
have just released the first fully durable version of PBXT. Because of the amount of new code I have reverted PBXT to Alpha status. This version, 1.0-alpha, can be downloaded from: http:// www.primebase.org/download. will there be any Windows builds available sooner or later? -- Sebastian

Re: [ANN] PBXT storage engine version 1.0-Alpha released

2008-03-17 Thread Paul McCullagh
released the first fully durable version of PBXT. Because of the amount of new code I have reverted PBXT to Alpha status. This version, 1.0-alpha, can be downloaded from: http:// www.primebase.org/download. PBXT is a highly scalable, transactional storage engine for MySQL. The main features

[ANN] PBXT storage engine version 1.0-Alpha released

2008-03-14 Thread Paul McCullagh
Hi All, I have just released the first fully durable version of PBXT. Because of the amount of new code I have reverted PBXT to Alpha status. This version, 1.0-alpha, can be downloaded from: http://www.primebase.org/ download. PBXT is a highly scalable, transactional storage engine

Re: weird select - version 2

2008-02-28 Thread Joerg Bruehe
Hi dante, all, [EMAIL PROTECTED] wrote: [[...]] In a nutshell, i need a query intelligent enough to make a query to table_Out, see if theres a match for 'id_tA', if there is one, retrieve field ref, otherwise go look in table_In and retrieve ref from there. Is it too complicated

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