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

Export Issue

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Export Issue

  • This topic is empty.
Viewing 4 reply threads
  • Author
    Posts
    • February 21, 2006 at 7:08 pm #9491
      powellbound
      Member

      Hi all,

      I have a 700K row table I am trying to export via SQLYog 5.02 through the SQLYogTunnel.php connection and I keep getting the error below.

      SQLyog Enterprise – MySQL GUI

      Error No. 2008

      MySQL client run out of memory

      OK Help

      I have a gig of ram on this machine and find it hard to believe that is the problem. Especially since I am less than 10 seconds into the export when I get the error.

      Any ideas out there??

      Thanks,

      David Fordham

    • February 21, 2006 at 7:13 pm #20639
      peterlaursen
      Participant

      This

      Quote:
      MySQL client run out of memory

      now .. in this case is the MySQL client the SQLyog program or the PHP binary? I am not sure!

      Do you have access to php configuration?

    • February 21, 2006 at 7:16 pm #20640
      peterlaursen
      Participant

      Also ..

      do you use the 'ordinary' export option or the 'powertool' backup option of SQLyog Enterprise?

      If 1st is the case, you my try the latter (demo available if you don't have Enterprise)

      EDIT: Of course you have Enterprise since you are able to tunnel!. Silly remark from me! 😎

    • February 21, 2006 at 7:37 pm #20641
      peterlaursen
      Participant

      One more question:

      Do you generate BULK INSERT statements?

      If so the BULK SIZE will be as big as the max_allowed_packet setting of the MySQL server. That might be too much for PHP with the current cofiguration!

      Ritesh has promised me that BULK size wll be made user configurable in near future (no later than SQLyog 5.2).

    • February 22, 2006 at 8:26 am #20642
      Ritesh
      Member
      powellbound wrote on Feb 21 2006, 07:08 PM:
      Hi all,

      SQLyog Enterprise – MySQL GUI

      Error No. 2008

      MySQL client run out of memory

      OK  Help 

      [post=”8828″]<{POST_SNAPBACK}>[/post]

      Since you are using HTTP tunneling, the client at the PHP is breaking. Your problem is same as:

      http://www.vbulletin.com/forum/archive/ind…hp/t-16473.html

      BTW, starting with v5.1 BETA 1, SQLyog will get the data in blocks of 100 rows which will by-pass the resource limit put by your ISP.

      v5.1 BETA 1 can be downloaded at: http://www.webyog.com/forums/index.php?sho…view=getnewpost

      Just try v5.1 BETA 1 once and let me know how it goes.

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