![bittorrent sync database error bittorrent sync database error](https://bqekb.zendesk.com/hc/article_attachments/360009746351/existing_database.png)
![bittorrent sync database error bittorrent sync database error](https://www.codeproject.com/KB/database/sync_sql_mysql/error.jpg)
This would give some indication as to what stage and progress it is currently in rather? (My assumption is that it is all cached locally first for all rows and once all rows are cached in then inserts them into the Target as my TCP trace shows large packets from the Source to my host machine running SQLYog, with no connections out from my host machine to the Target yet (still retrieving rows to insert I assume).Ģ) What is the location of the cache file on the host machine? i.e. I use Wireshark to sniff the connection on port 3306 to see that it is currently still active and it appears as though it is caching the data locally as large packet size of data are being streamed.ġ) Assuming that the data is first cached and then sent to the Target or that it is cached in chunks and then each chunk is sent to the Target, could the 'Source: ' field be updated to reflect its progress rather than both fields simply saying 'Retrieving table data…'. I have been running the query now for about 15 minutes and will continue to let this run but in the past we have seen errors related to timeout/connection lost and I am concerned that's what will happen with this one. We realize that this is because it is assembling the data to sync. We see in the 'Completing the SQLyog Database Synchronization Wizard' dialog that the 'Source:' and 'Target:' fields show 'Retrieving table data…'. We have recently tried to do a database sync of a large table of date (> 17 million rows). First would just like to say Thank you to the Webyog team for the SQLYog tool as it has become the tool of choice used for MySQL database access.