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

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

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

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

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://',''),locate('/',replace(reftraffic.refurl,'http

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.refurl,'http://',''),locate

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.refurl,'http://',''),locate

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. Is there a way I

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

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:

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

Somebody tried MySQL version 5 / Stored Procedures

2003-09-29 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 procedures

Re: Somebody tried MySQL version 5 / Stored Procedures

2003-09-29 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 supports Stored Procedures (PL/SQL like

Re: Somebody tried MySQL version 5 / Stored Procedures

2003-09-29 Thread Hans van Dalen
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 a stored procedure you can do a commit

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 procedures

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