[firebright]

Thanks for the detailed questions. I'll do my best to reply…

> Moving how ?? Do you use “copy DB to another host” or “syncronization” or just export/import sql ?? Does the connection involve some kind of tunnelling ?

Sync. Exporting and importing is too resource intensive, and the mysqld db dies trying to do it. There is no tunnel.

> What are the mysql server versions ?? Certain variable types (such as date/time , timestamp) are incompatible across older and more recent mysql versions. The error message could imply something like that.

3.23. Yes, I know it's old. No, there is nothing I can do about it.

> Are the server configuration(s) under your control or not ?

Some of them.

> Please explain about the data structure and possibly supply “create table” statements for the DB('s), and even some sample data. If you don't want to throw it here in public, you could wait for Ritesh to send him this information confidentially.

I cannot share this info unfortunately. It's for a company, and involved financial information. 😉

> And you have no problems with small DB's ??

None.

> Do you know about a tool that works ?

No, haven't found one. rsync. 😉

> Are you sure that its the query(s) that SJA executes corrupting the data?

Yes, fairly. It's a fresh copy to a new db, and it's showing errors. Myisamchk on the donor host shows no errors…

This is the job I have scheduled…

http://www.foo.com

root

3306

foo

localhost

root

3306

foo

I was as miffed about it as you guys seem to be… I couldn't figure how it could end up corrupted, but it does. It literally ends up with corrupted DBs (myisamchk reveals) even though rsyncing the EXACT same dbs over has no errors. So, I'm 100% sure it's the tool.

[Author]

Posts