Export Issue

[peterlaursen]

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?

[peterlaursen]

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! 😎

[peterlaursen]

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).

[Ritesh]

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