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

Copying Tables Between Databases

forums › forums › SQLyog › Using SQLyog › Copying Tables Between Databases

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • January 22, 2007 at 9:09 pm #10144
      Kwaka
      Member

      Hi I'm using the latest version of SQL Yog Professional.

      I'm trying to move some tables between my production and test databases using the copy database option and selecting the tables I want.

      However it freezes on the second table after 1000 or 2000 rows. If I abort the copy it just hangs there until I end task.

      Its on a specific table each time. Really strange.

      Any ideas?

    • January 23, 2007 at 5:38 am #23284
      peterlaursen
      Participant

      “the latest version of SQL Yog”  version number please.  We have seen before that people refer to a 2 year old version as “the latest version” 😉

      Please answer:

      1) How do you connect to the databases? direct, HTTP, SSH?

      2) Does it always happen exactly the same place?

      3) How long do you wait?  If you let it 'hang' for several minutes no message will appear?

      I have no problems copying +100.000 rows here.

      I think chances are that the server becomes irresponsive.  

      With cheap hosting and HTTP-tunnelling we have seen a lot of badly configured and 'over-burdoned' webservers. (It is most often a Apache and not a MySQL problem)

      But please reply to the questions! 

    • January 23, 2007 at 9:28 pm #23285
      Kwaka
      Member
      peterlaursen wrote on Jan 23 2007, 05:38 AM:
      “the latest version of SQL Yog” version number please. We have seen before that people refer to a 2 year old version as “the latest version” 😉

      Please answer:

      1) How do you connect to the databases? direct, HTTP, SSH?

      2) Does it always happen exactly the same place?

      3) How long do you wait? If you let it 'hang' for several minutes no message will appear?

      I have no problems copying +100.000 rows here.

      I think chances are that the server becomes irresponsive.

      With cheap hosting and HTTP-tunnelling we have seen a lot of badly configured and 'over-burdoned' webservers. (It is most often a Apache and not a MySQL problem)

      But please reply to the questions!

      1. Via HTTP.

      2. It started to happen at 1000 rows and but now manages to get to 2000.

      3. I've left it for several hours with no difference.

      If I abort the transfer it just hang the whole application as well.

      I'm using the version that you have on your website as I've just downloaded the very latest version.

    • January 24, 2007 at 5:20 am #23286
      peterlaursen
      Participant

      I thought it was HTTP.

      This is a webserver issue, I believe. Webserver does neither respond or time out.

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