forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Cannot Synchronize All Tables!
- This topic is empty.
-
AuthorPosts
-
-
October 13, 2005 at 4:38 am #19483
motin
MemberI 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!
-
October 13, 2005 at 5:17 am #19484
peterlaursen
ParticipantIt 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 secondsmax_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!
-
October 13, 2005 at 6:35 am #19485
Ritesh
MemberIt 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.
-
-
AuthorPosts
- You must be logged in to reply to this topic.