Cannot Synchronize All Tables!

[motin]

I always do a search in forums before posting, but still I managed to doule-post. Searching for “large tables” gave me a post that addresses the same issue.

Highlights:

Quote:

My theory is that if I can get them copied the once then synch should be ok as there are minimal differences to deal with.

&&

Quote:

For a big table, it is recommended that you import the data in the target server for the first time and then sync it.

Now I know what to do: Import the data through standard methods instead of the Synchronization Wizard. Then use the wizard for what it is made for: synchronization!

[peterlaursen]

It might be an issue with php configuration.

From my own php configuration file I quote these settings:

Quote:

max_execution_time = 30    ; Maximum execution time of each script, in seconds

max_input_time = 60 ; Maximum amount of time each script may spend parsing request data

memory_limit = 8M      ; Maximum amount of memory a script may consume (8M:cool:

And my experience is that the “cheaper” ISP's are not generous with that!

[Ritesh]

It is a known issue with HTTP Tunneling when we try to import large tables (with lot of rows). Since, HTTP is stateless we have to populate the whole table data at the source computer and due to limit specified in PHP configuration, it fails. 🙁

We plan to fix this issue in v4.3. Another SQLyog user has reported the same problem and thus requires more attention.

As of now, you will need to create a dump of database at source in SQL statements. Import it locally using Tool -> Import SQL Statements. Once, a locally copy of the db has been made, you can use Sync feature without any problem.

[Author]

Posts