Re: 答复: PreparedStatement problem

- Original Message - From: ZhangFangXue zhangfang...@sogou-inc.com 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

Re: PreparedStatement problem

- Original Message - From: ZhangFangXue zhangfang...@sogou-inc.com 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

答复: 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 23,

答复: 答复: 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 抄送:

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.

Re: How to verify if backup is ok?

Thanks, I will use this tool :) 2013/2/19 Johan De Meersman vegiv...@tuxera.be: - Original Message - From: Rafał Radecki radecki.ra...@gmail.com pt-table-checksum performs an online replication consistency check by executing checksum queries on the master, which produces

Re: How to verify if backup is ok?

- Original Message - From: Rafał Radecki radecki.ra...@gmail.com 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

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

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 h.rei...@thelounge.net wrote: surely * use mysql_upgrade -u root -p after EACH update * upgrade regulary we went from MySQL

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 h.rei...@thelounge.net 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

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 do

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 h.rei...@thelounge.net wrote: Am 16.02.2013 09:42, schrieb Manuel Arostegui: 2013/2/15 Reindl Harald