[peterlaursen]

No, I am afraid it does not really help much!

We need a reproducable test case.  This error message is without valuefor us  if you do not explain how to reproduce it!  And I am not sure that this error mesage at all is related to the (connection) issue that you are reporting!  This error log was created when you were connected.  

Whend id you execute the statement “40103 SET TIME_ZONE='+00:00” with SQLyog.  did you import some script?  We do not know the mango server in detail.  And what is the MySQL version?  I think you may need to import the time zone descriptions, if they are not distributed with Mango.  But may depend on the server version.  And still I do not think this is related to the conection problem.

the timestamps in the log also is confusing.  they are not in logical/cronological order-  Still you may be able to tell from the timestamps what happend at taht particular time+

You can clear the error log in Notepad (select all and delete).  Or just rename the existing file and a new one will be created. Then the file will only have 'fresh' error messages in it.

[peterlaursen]

It looks like the job has been specified to use HTTP-tunnelling but the URL to the tunneller is blank or nonexistent.

try one or more of those:

1) open the jobfile in an editor and check the connection details. You can copy it here (or create a ticket) if you like. be careful not to expose confidential details!

2) start the wizard again and load the existing jobfile. Be careful to check that an URL is displayed in the HTTP tab of the connections manager

I cannot reproduce the issue you reported. I generate a jobfile and thesection reads like:

http://localhost/SQLyogTunnel53.php

30

localhost

root

******* 3306

0

0

[default]

test2

note:

http://localhost/SQLyogTunnel53.php

.. it should look like that!

[peterlaursen]

1) You are sure that the server is running?

2) Which one is the firewall?

3) SQLyog, MySQL and Windows version please!! (though probably not very much relevant here!)

[peterlaursen]

In what browser do you view MONyog?

[peterlaursen]

We do not support export of images in the HTML view.  

That would be practiaclly impossible to format, too!  The only opton would be to create a folder with a .html and seperate image files, and links in the html.  But currently do do not support it.

You can edit the HTML of course and add the links and exports the individual BLOB values as seperate files.

[peterlaursen]

we have 'vacuumized' the program for all sorts of leaks. However I doubt we will be able to release beta5 today. We need to finish some in-depth testing with data sync. We are a little low on manpower due to some persons being sick

[peterlaursen]

First: is the file that you try to import a CSV file or SQL file?  You will

To import a CSV a table must be selected in the Object Browser.  The table structure must match the data in the CSV file.  A CSV file only contains data for a single table.

If only a databse is selected most options in the tablel menu will be greyed out.  To perform operations on table(s) you will ahve to tell the program (by selecting the appropriate table) on which table the operation shall be performed.

But I first understood that the file was a SQL dump?

Personally I think using the contect menus (right click menus) from the Object itself in the Object Browser is more intuitive.  From here only the options that are possible with the the Object chosen will be displayed.

[peterlaursen]

I checked your script!

1) There is no 'USE some_database' statement  The script simply starts CREATE TABLE …  To import with SQLyog you should start creating an empty database (right click in 'Obkject Browser (the left window) … create database) and select this one before running the SQL script!  If no databse is selcted you will get the error 'no database selected' (how logical can the world be? 🙂 )

2) Your script will import on every MySQL version.  tTere are no ENGINE or CHARSET specification in the file that are specific for some MySQL versions only.  Seems like you exported from MySQL 4.0 or lower.

[peterlaursen]

“Error Code: 2006 – MySQL server has gone away”

I think the most likely reason is that the (server) max_allowed_packet setting is too low compared to the size of BULK inserts in the file.

Old server versions dispaly only that in this situation.  5.0.41 say “got a package too big” or something like that!

[peterlaursen]

yes .. it does!

We plan a bigger 'overhaul' of the data sync once we get finished the new features that we started for the 6.0 tree.

So this we will consider too.  Actually a similar request has been raised before regarding Migration/ODBC import.

[peterlaursen]

can you access the tunnelling script from a browser and execute simple PHP scripts form the same folder.

try small scripts containing only one lineand the PHp tags of course) like

Code:

echo 'something';

and

Code:

phpinfo();

[peterlaursen]

Once you have a SQL-script (with correct syntax for mysql) you import to MySQL from the SQLyog 'tools' menu.  You must of ocurse connect to mysql first!

It is very smple actually.  However there are two issues you should know:

1)  If the dump file is created with mySQL 4.1 or higher it will not import on 4.0 or lower

2)  If ther is no CREATE DATABASE and USE statement in the file you will need to start creating it manually and selecting it.

[peterlaursen]

hmmm ..

and I have HTTP tunnel problems that I never had before …

Now I have Vista, and I think I have no option to reintsall IE.  The only options is to uninstall patches/updates.

thanks for the info.  We will keep a sharp eye on that!

[peterlaursen]

Please give direct links and tell what we need to install to make it functional.

I doubt that anybody here ever heard about this software.

[peterlaursen]

maybe you could give some additional information about this OMNIS thing?   From where do we get it (with an ODBC driver) ??

The general answer to what we support with the Migration Tool is this:

http://www.webyog.com/faq/17_77_en.html

[Author]

Posts