Re: error in copy data from mysql 4.1 to mysql 5.0 server
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" <[EMAIL PROTECTED]> To: "prathima rao" <[EMAIL PROTECTED]> 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/[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]
Re: error in copy data from mysql 4.1 to mysql 5.0 server
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: 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]
Re: error in copy data from mysql 4.1 to mysql 5.0 server
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: 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]
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]
error in copy data from mysql 4.1 to mysql 5.0 server
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 regards rao -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
