[Ritesh]

jexxer wrote on Nov 2 2005, 02:53 PM:

First, i want to apologise if this has already been postet. The forum search gives me an error when searching for 'set'.

SQLyog Free 4.2RC2 crashes if i edit a value of the type 'set'. I can open the dropdown list that shows all available set-entries and i can select one entry of the list. in the moment when i click somewhere in another cell of the resulttable and the dropdown list closes SQLyog crashes with error:

Die Anweisung in “0x0042f3e5” verweist auf Speicher in “0x0000000c”. Der Vorgang “read” konnte nicht auf dem Speicher durchgeführt werden.

if you want me to run a debug version I'd be happy to help.

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

Bug confirmed. This will be fixed in v4.2 FINAL.

This bug was introduced in v4.2 BETA 5. Thanks a lot. It will be our pleasure to give you a complimentary license of SQLyog Enterprise for all the trouble you have taken to report the bug.

Please send in registration name etc. to [email protected].

[Ritesh]

To take a dump of a table in HTTP Tunneling, we need to load all the table data in memory. Most of the ISPs put a limit on resources and thus the backup fails.

We plan to overcome this issue in v4.3 by doing incremental export where the dumps will be taken in batch of 1000 rows (or maybe user-specified value as we will need to reduce the row count if there are lot of blob columns).

Quote:

you could be right, its a php timeout, I just wondered why SQLyog reports the export has been completed, I would expect it do detect the error, and report it.

This is very strange as SQLyog will indeed throw up an HTTP error.

[Ritesh]

Just for the sake of completeness, do you see any plink.exe in the windows process list?

I am assuming that you are providing a local port value that is not being used by any other process/app.

[Ritesh]

Waiting for your comments.

[Ritesh]

The most important information that we require is whether you are using HTTP Tunneling or Direct Connection.

[Ritesh]

Thanks for the report. Will be fixed in 4.2 FINAL.

[Ritesh]

onse wrote on Oct 31 2005, 01:57 PM:

I got that fixed now.. just downloaded the new sja. 🙂

anyway another question i have is how can i not delete the data that is being backed up from another server..?

because im trying to combine data on two different servers but they seem to delete the data that is from the each others server.

thanks.. 🙂

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

Can you explain the problem with a simple example?

[Ritesh]

Can you copy-n-paste 2-3 rows of data in the CSV file?

After looking at the data, I can correctly tell you the delimiter settings.

[Ritesh]

BTW, are you using any kind of firewall, multiple monitor management software etc.?

We had an issue earlier with Multimon found at Relatime Soft

[Ritesh]

BTW, what happens when you try to use “Copy database…” with your 4.0 server?

I just tried with 5.0.13 and it works great. Looks like an issue with 5.0.15.

[Ritesh]

So you are connecting to your local server using “Direct Connection” method?

Are you trying to copy the database to a remote server?

[Ritesh]

As Peter described, we will need more details about your setup. Are you connecting to a remote server?

Can you mail me a screenshot of your connection window?

BTW, what does show tables from `yourdb` return?

[Ritesh]

This is a known issue. This issue occurs due to the MySQL server running in strict mode.

You will need to download the latest RC (Release Candidate) version of v4.2.

More info at: http://www.webyog.com/forums/index.php?sho…view=getnewpost

[Ritesh]

You can download SJA v4.2 RC1 from:

http://www.webyog.com/betas/sja42.tar.gz

Starting with this version, you can specify the path for session.xml file.

Now you can execute SJA like:

CODE

sja -llog.log -ssession.xml schema.xml

[Ritesh]

Currently, there is no other option but to create different schema files.

We plan to support backing up of multiple databases using one schema file in one of the future releases.

[Author]

Posts