prathima rao wrote:
I don't know. Did you try exporting from 4.1 with mysqldump and running the dump script on the 5.1 server, as the manual recommends for major upgrades?hi,, the query is select sum(gtotal) from invoice this if i connect to 4.1 says 14000 but in 5.1 it says 0.00why so is it because i copy data from 4.1 to 5.1 PB rao ----- Original Message ----- From: "Peter Brawley" <[EMAIL PROTECTED]> To: "prathima rao" <[EMAIL PROTECTED]> Cc: <mysql@lists.mysql.com> Sent: Monday, June 19, 2006 6:57 PM Subject: Re: error in copy data from mysql 4.1 to mysql 5.0 serverprathima rao wrote:hello every one, i have two mysql servers one is the local server 4.1 and one is the centralised server 5.0 . i copy data from 4.1 to 5.0 through a optioncalledcopy database to another server/host - (drop table if exists) during this process i am not getting the same resule as i get in 4.1 ieimusing a text box which sums up a value in a table that in 4.1 is showing correct but in 5.1 is showing 0 when displayed in front end(visual basic5)even though it has the sum correct data can anyone help mePost the query. PBregards rao-- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.9.0/368 - Release Date: 6/16/2006 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]-- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.9.0/368 - Release Date: 6/16/2006 |
No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.9.1/369 - Release Date: 6/19/2006
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]