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

Import from Access stalling

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Import from Access stalling

  • This topic is empty.
Viewing 6 reply threads
  • Author
    Posts
    • December 22, 2003 at 11:18 am #15364
      Shadow
      Member

      What error do you get?

    • December 22, 2003 at 11:41 am #15365
      Jase
      Member

      It looses the connection to the remote database. I think it times out (need to check exact error when I get home tonight)

    • December 22, 2003 at 12:36 pm #15366
      Shadow
      Member

      Either the communication to your remote db is not ok, or the rows (better to say specific rows) contain too much data. Try increasing the wait_timeout or max_allowed_packet setting of the remote db.

    • December 22, 2003 at 12:50 pm #15367
      Jase
      Member

      connect_timeout is 5 & max_allowed_packet is 1047552. What new values would you suggest? It's just that I'm new to MySQL.

    • December 22, 2003 at 1:42 pm #15368
      Shadow
      Member

      max_allowed_packet is all right unless you strore huge blobs in the Access db, but I was not talking about connect_timeout, but about wait_timeout. wait_timeout being 5 secs would be a way too short period!

    • December 22, 2003 at 2:03 pm #15369
      Jase
      Member

      Beg your pardon, wait_timeout is 20.

      There could be some large blobs moving across, I might double that max_allowed_packet. Again, I will have to check tonight when I get home.

    • December 23, 2003 at 8:04 am #15370
      Shadow
      Member

      I would increase the wait_timeout setting! My default value is 28800… About max_allowed_packet: find the largest row in your Access db (the row that contains the most data), determine its size in bytes and compare this value to the max_allowed_packet. If the size of the row exceeds max_allowed_packet, then increase the setting's value. Otherwise you can leave it as is.

  • Author
    Posts
Viewing 6 reply threads
  • You must be logged in to reply to this topic.