Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6

Hi all Is there any better way for grade MySQL version without taking backup with mysqldump Or if there any tool for this R's DK On 16-Feb-2013, at 16:07, Reindl Harald wrote: > > > Am 16.02.2013 09:42, schrieb Manuel Arostegui: >> 2013/2/15 Reindl Harald >

Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6

Am 19.02.2013 23:53, schrieb Divesh Kamra: > Hi Reindi > > > Thanks for solution . > > Can u share complete steps ? which steps? * update * call "mysql_upgrade -u root -p" in doubt "mysqlcheck -h localhost --check-upgrade --all-databases --auto-repair --user=root -p" and if you d

Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6

Hi Reindi Thanks for solution . Can u share complete steps ? R's DK On 20-Feb-2013, at 2:50, Reindl Harald wrote: > surely > > * use "mysql_upgrade -u root -p" after EACH update > * upgrade regulary > > we went from MySQL 3.x to 5.5.30 until know without > any dump and here are ar

Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6

Use replication as your fail over and why not percona's xtrabackup or lvm type backup if you need a backup? Sabika On Feb 19, 2013, at 1:20 PM, Reindl Harald wrote: > surely > > * use "mysql_upgrade -u root -p" after EACH update > * upgrade regulary > > we went from MySQL 3.x to 5.5.30 unt

Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6

surely * use "mysql_upgrade -u root -p" after EACH update * upgrade regulary we went from MySQL 3.x to 5.5.30 until know without any dump and here are around 5000 tables Am 19.02.2013 22:12, schrieb Divesh Kamra: > Is there any better way for grade MySQL version without taking backup with > mys

Re: How to verify if backup is ok?

- Original Message - > From: "Rafał Radecki" > > pt-table-checksum performs an online replication consistency check by > executing checksum queries on the master, which produces >different results on replicas that are inconsistent with the > master. -> It should be used for verifi

Re: How to verify if backup is ok?

Thanks, I will use this tool :) 2013/2/19 Johan De Meersman : > - Original Message - >> From: "Rafał Radecki" >> >> pt-table-checksum performs an online replication consistency check by >> executing checksum queries on the master, which produces >>different results on replicas tha

Re: How to verify if backup is ok?

Thanks for the reply. pt-table-checksum performs an online replication consistency check by executing checksum queries on the master, which produces different results on replicas that are inconsistent with the master. -> It should be used for verifing mysql replication, not for my problem.

答复: 答复: PreparedStatement problem

yes, it is CityName, but it is not the point, setInt works abnormally.. By the way, I found there is not a thorough introduction to the mysql c++ connector, can you give me some hint? -邮件原件- 发件人: Johan De Meersman [mailto:vegiv...@tuxera.be] 发送时间: 2013年2月19日 16:36 收件人: ZhangFangXue 抄送: m

答复: PreparedStatement problem

well, the problem is that I used it like this: prep_stmt = con -> prepareStatement ("INSERT INTO City (CityNumber) VALUES (?)"); prep_stmt -> setInt (1, 23); //this statement didn’t act normally!!! then when I execute the statement, the result does not appear to be correct, as CityNumber is not

Re: PreparedStatement problem

- Original Message - > From: "ZhangFangXue" > > Hi, when I use PreparedStatement in c++ connector, I find some > unexcepted error, Well, first of all, you don't actually say what the error is that you're seeing. This tends to be on the rather helpful side when trying to diagnose it. >

Re: 答复: PreparedStatement problem

- Original Message - > From: "ZhangFangXue" > > well, the problem is that I used it like this: > prep_stmt = con -> prepareStatement ("INSERT INTO City (CityNumber) The statement in your original mail used CityName, which sounds like it should be a string. Fieldname confusion? -- Unh