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 H

Re: version 5 to 4

2010-02-15 Thread Glyn Astill
--- On Mon, 15/2/10, Prathima Rao wrote: > From: Prathima Rao > 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 of the systmem  has

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 he

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 he

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: yum version 5.*

2007-01-17 Thread Colin Charles
Karl Larsen wrote: I am using Red Hat Fedora Core 4 and I wanted to yum mysql version 5 of any other and find with Core 4 I can yum only mysql version 4. I imagine Core 5 might be able to yum mysql version 5 but not certain of that. Is there a way I can yum the later version? I studied

Re: Setting up version 5

2006-12-18 Thread Duncan Hill
On Monday 18 December 2006 13:10, Karl Larsen wrote: > Is there a paper I can d/l that covers intalling MYSQL on Red Hat > Linux? http://dev.mysql.com/doc/refman/5.1/en/linux-rpm.html perhaps? -- Scanned by iCritical. -- MySQL General Mailing List For list archives: http://lists.mysql.com/

Setting up version 5

2006-12-18 Thread Karl Larsen
Is there a paper I can d/l that covers intalling MYSQL on Red Hat Linux? Karl Larsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: What happened to left join under version 5?

2006-09-21 Thread Gerald L. Clark
Mailing List Receiver wrote: Worked under version 4. Does not work under version 5. $Qstr = "select distinct replace(reftraffic.refurl,'http://',''),\ count(*)\ from reftraffic,site\ left join links\ on left(replace(reftraffic.re

Re: What happened to left join under version 5?

2006-09-21 Thread Joerg Bruehe
Mailing List Receiver wrote: Worked under version 4. Does not work under version 5. $Qstr = "select distinct replace(reftraffic.refurl,'http://',''),\ count(*)\ from reftraffic,site\ left join links\ on left(replace(reftraffic.re

What happened to left join under version 5?

2006-09-21 Thread Mailing List Receiver
Worked under version 4. Does not work under version 5. $Qstr = "select distinct replace(reftraffic.refurl,'http://',''),\ count(*)\ from reftraffic,site\ left join links\ on left(replace(reftraffic.refurl,'http://',''

Re: yum version 5.*

2006-07-27 Thread Duncan Hill
On Wednesday 26 July 2006 22:16, Karl Larsen wrote: > I am using Red Hat Fedora Core 4 and I wanted to yum mysql version 5 > of any other and find with Core 4 I can yum only mysql version 4. > > I imagine Core 5 might be able to yum mysql version 5 but not > certain of that.

yum version 5.*

2006-07-26 Thread Karl Larsen
I am using Red Hat Fedora Core 4 and I wanted to yum mysql version 5 of any other and find with Core 4 I can yum only mysql version 4. I imagine Core 5 might be able to yum mysql version 5 but not certain of that. Is there a way I can yum the later version? I studied the man for yum but

Re: Where is the perl DBI for version 5 mysql

2005-12-12 Thread Gleb Paharenko
Hello. Follow instructions from: http://dev.mysql.com/doc/refman/5.0/en/perl-support.html Logg, Connie A. wrote: > I have done various searches, and cannot locate the perl dbi for mysql = > 5.0.16. > > I assume that the old one for mysql 4 will not work. > > Can someone please

Where is the perl DBI for version 5 mysql

2005-12-12 Thread Logg, Connie A.
I have done various searches, and cannot locate the perl dbi for mysql 5.0.16. I assume that the old one for mysql 4 will not work. Can someone please provide me the url for mysql 5's perl dbd/dbi bundle? Thanks, Connie Connie Logg, Network Analyst Stanford Linear Accelerator Center ph: 650-926-

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: 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 o

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