From: Peter Brawley Date: June 19 2006 3:45pm Subject: Re: error in copy data from mysql 4.1 to mysql 5.0 server List-Archive: http://lists.mysql.com/mysql/199042 Message-Id: <4496C691.1040601@earthlink.net> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="=======AVGMAIL-4496C6913D9F=======" --=======AVGMAIL-4496C6913D9F======= Content-Type: multipart/alternative; boundary=------------000800000103070100080301 --------------000800000103070100080301 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit prathima rao wrote: > 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.00 > > why so > > is it because i copy data from 4.1 to 5.1 > 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? PB > rao > ----- Original Message ----- > From: "Peter Brawley" > To: "prathima rao" > Cc: > Sent: Monday, June 19, 2006 6:57 PM > Subject: Re: error in copy data from mysql 4.1 to mysql 5.0 server > > > >> prathima 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 option >>> > called > >>> copy 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 ie >>> > im > >>> using 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 basic >>> > 5) > >>> even though it has the sum correct data >>> >>> can anyone help me >>> >>> >> Post the query. >> >> PB >> >>> regards >>> >>> 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/mysql?unsub=prathimanrao@stripped > >> >> -- >> 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 >> >> >> > > > --------------000800000103070100080301 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit prathima rao wrote:

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

why so

is it because i copy data from 4.1 to 5.1

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?

PB

rao
----- Original Message ----- 
From: "Peter Brawley" <peter.brawley@stripped>
To: "prathima rao" <prathimanrao@stripped>
Cc: <mysql@stripped>
Sent: Monday, June 19, 2006 6:57 PM
Subject: Re: error in copy data from mysql 4.1 to mysql 5.0 server

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

called

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

im

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

5)

even though it has the sum correct data

can anyone help me

Post the query.

PB

regards

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/mysql?unsub=prathimanrao@stripped


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

--------------000800000103070100080301-- --=======AVGMAIL-4496C6913D9F======= Content-Type: text/plain; x-avg=cert; charset=us-ascii Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Content-Description: "AVG certification" 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 --=======AVGMAIL-4496C6913D9F=======--