Prathima, you'll have to provide a lot more detail about how you have
copied the data from one database to the other before we can help you.
What software are you using? What exact command? Any errors when you
run it? Has it worked in the past? Have you updated anything lately?
All this will be helpful in tracking down the problem.
Dan
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
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 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/[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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
