[peterlaursen]

I recall that we have had a few issues with that WORDPRESS system – but do not recall details. But you should not expect us to know about or support other applications. We relate to the database and the content of the database alone! We have no clew about the contents of the milllions of applications around .. you will have to inform us!

If the structure (column types and order, charset, storage engine etc.) on both sides are not identical the sync will refuse to start! Once it has started it should finish.

Can you provide a test case with a zipped dump from both servers. You can crate a ticket if you want privacy. And please not much too big! In principle a single row that fails to sync is enough!

Alternative provide download links and a step-by-step instruction on how to reproduce this!

Also tell the EXACT server versions! Not 4.1 but 4.1.10 or 4.1.22 … and both source and target.

I also think you should try 6.12. Just to be sure .. but frankly I do not think this is an issue that has been resolved between 6.1 and 6.12!

[peterlaursen]

You cannot do this with a 'pure' database client like SQLyog. It is NOT a browser! It simply dispays the content of the database!

This you should be code in HTML (or some HTML preprocessor language like PHP, ASP etc.). Still however you as the admin can use SQLyog for managing the database.

Is the end user using SQLyog as well?

[peterlaursen]

1) Please tell the exact program (SQLyog) version used for the import!

2) Was the dump created with the same SQLyog version? or another version or another program?

3) Tell the MySQL server version(s) from where you export and import (both). Note that a dump created from MySQL 4.1 and higher is not compatible with 4.0 and lower! There are encoding issues (4.0 do not support Unicode) as well as the CREATE TABLE statement is slightly different. The 'weird' characters seem to indicate that this is the situation! What charset did you select for the export (this option is only supported with the 'scheduled backup' feature of ENTERPRISE version and only with recent versions?

4) How do you connect? direct, HTTP-tunnel or SHH-tunnel? the 'temporary table' issue seems to indicate HTTP?

4) Could you please provide an example of such dump that fails to restore? (you cannot attach .sql files here – rename to .txt or better zip before attaching!). You can create a ticket if you want privacy.

[peterlaursen]

You will have code completion in SQLyog Enterprise – and syntax highlightning is there also in COMMUNITY.

I think this question is related to this one:

http://www.webyog.com/forums//index.php?showtopic=3588

A full-featured IDE (like Microsoft Visual Studio, Delphi, misc. JAVA IDE tools etc.) I simply do not think is possible with MySQL. In the MySQL world there is a tradition to code in applications (PHP, C for instance) what you with SQL server, Oracle would most often use SP's, Triggers etc. for. Neither the server itself nor the client API supports IDE functionalities for stored programs.

[peterlaursen]

“Any idea when you plan to add the additional VIEW options to the Enterprise version?”

I will ask the developer assigned with this for this detailed work-plan for the next months on Monday!

[peterlaursen]

Please tell the program version you are using!

And please also try 6.12 – such issue when syncing between 4.0 and 4.1 was fixed in this release.!

[peterlaursen]

This is actually a MySQL question more than a SQLyog question!

In MySQL (like in most databases) such 'saved query' is called a VIEW!

The (most simple) SQL-syntax for creating a VIEW is

CREATE VIEW `viewname` {some SELECT statement}.

VIEWs are supported from MySQL 5.0.x. Once a VIEW is created you can query it like a table (with the restriction that not all VIEWs are updatable – refer to the MySQL documentation for details!)

In SQLog “CREATE VIEW” is in the database menu/context menu. We will soon add an option to generate a VIEW from the GUI Query Builder (Enterprise feature only). Also the option to query the VIEW will be added to the Query Builder.

[peterlaursen]

yes .. it is an old bug.

We have fixed the crash with this build:

http://www.webyog.com/downloads/betas/not_…QLyog612Ent.exe

You are welcome to confirm!

[peterlaursen]

we have now reproduced this — and most often that is more difficult than fixing!

[peterlaursen]

We have tried very hard to reproduce all issues with no success.

“you throw me away without asking for more details, test accounts”

… Whatever information you can give, give!! And create a support ticket if you want privacy!

[peterlaursen]

On windows servers to use tunnelling the requirements are

HTTP tunnel:

***********

PHP (>= 4.3.x) must be installed and mysql or mysqli extensions must be enabled. If you use IIS 6 with Windows there is a known issue with the php-distribution with automatic installer (a problem with url_encode in the HTTP header – please tell if this is the situation – we can provide a special build to solve this). The PHP package for manual configuration has no such issue. Also no such issue if you use Apache with Windows (any Windows version)

SSH-tunnel:

***********

Windows does not support SSH natively. You must install a SSH package. OpenSSH for windows works fine. Download link: http://sshwindows.sourceforge.net/download/ . ON Win2003 a few tricks are required to configure it – a good configuration guide is http://www.cs.bham.ac.uk/~smp/projects/ssh-windows/ . On 2K and XP just follow the 'quickstart' guide in the Openssh folder. OpenSSH installs a Cygwin instance (and not the latest one – the package available is now three years old) and you can only run one Cygwin. If you are capable of UNIX systems from command line you can of course also install Cygwin yourself and build OpenSSH on it! 🙂 Normally this is not required, but may be necessary if you have more unix/linux softwares on your Windows box that need to use Cygwin.

[peterlaursen]

“That INSERT INTO is very, very long.”

And that is why raising the max_allowed_packet in server configuration may solve the import issue.

Also we will probably need to lose connection to the server/get the 'gone away' server error if we shall reproduce the program crash!

[peterlaursen]

Could you share that SQL DUMP with us? There is no usable stack trace in the crash dump file saved by SQLyog, so without it it will be difficult to do progress. You can create a ticket and attach here if you want privacy. And please zip before attaching!

BTW: I think you execute as an external file. What happens if you copy the file into the editor and executes from here?

[peterlaursen]

You have reported two issues.

1) your SQL DUMP won't import (server has 'gone away').

This may very well be because the max_allowed_packet setting in server configuration is too small compared to the size of an INSERT in this SQL DUMP.

If this is the situation, you should raise this setting. If you are not in control of the server configuration for this server you will probably be able to import to another (local) server and copy data (using 'copy to other' or 'data sync')

Also please read this FAQ:

http://webyog.com/faq/content/24/101/en/ab…-and-bulks.html

2) SQLyog crashes. We are looking into that now!

[peterlaursen]

OK .. I'll summarize. You reported two issues

1) client charset gets lost after inactivity (this is a recent 64 bit Linux server)

We cannot reproduce. Can you on other servers? This may be a server bug!

2) 'server gone away' .. this may be a connection/firewall/OS issue and not a MySQL or SQLyog issue.

We cannot reproduce either of those issues. Not after 'playing around' with 'interactive timeout' either.

Please tell how you connect – direct, SSH, HTTP? I would not be surprised if the 2nd issue is SSH-related!

[Author]

Posts