Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Cannot Synchronize All Tables!

forums forums SQLyog Sync tools, Migration, Scheduled Backup and Notifications Cannot Synchronize All Tables!

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • #19483
      motin
      Member

      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!

    • #19484
      peterlaursen
      Participant

      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!

    • #19485
      Ritesh
      Member

      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.

Viewing 2 reply threads
  • You must be logged in to reply to this topic.