We're evaluation SQLyog as our data sync tool for a BI project. But when trying to sync a huge table (>10M rows) for the first time, it generates an error 2008 (MySQL client ran out of memory). I searched this forum and found a similar problem with a previous version but we're using the latest 9.30 which is supposed to be fixed.
Here's the log for your reference:
Sync started at Thu Oct 20 14:52:17 2011
`gc_txlog` 11099577 0 Error No. 2008
MySQL client ran out of memory
Source Server: Windows 2003 server 32-bit
Source Database: MySQL 5.0.26-community-nt
Target Server: Linux
Target Database: MySQL 5.0.77
Any idea? Thanks!