[peterlaursen]

1) you should use a non-proportional font (like Courier) – it looks like Arial …

.. a series of SPACEs do not take much SPACE for instance …

That will do the trick if column names are not too long.

[peterlaursen]

yup ..

we have decided that we will spend the necessary time with this before releasing 5.2 FINAL. We estimate it to delay the FINAL thing 1-2 days.

A 'progress bar' (understood as numbers, percentages etc.) is not possible for technical reasons, but there will be SIGN OF ACTIVITY like 'fetching checksums' .. 'updating rows' etc.

[peterlaursen]

If we shall be able to help you we must have

1) the PHP version or better the complete php_info() response

2) or even better temporary access to the server. Create a ticket with details.

Maybe your ISP can help to explain this too.

[peterlaursen]

Looks like an issue with MySQL.

http://bugs.mysql.com/bug.php?id=22377

.. let us see what they say!

[peterlaursen]

we need to research into that!

Please answer: did you enter a query or use the GUI in the first place?

[peterlaursen]

Quote:

Upon investigation into the job xml file, it appears that the column from neither source nor target is listed at all.

Now do I understand you correctly like this:

1) You did an import some time ago, and saved the jobfile

2) You have since then added a column to the3) You cannot after that add the new column and its mapping options using your existing jobfile?

If that is it it would also be interesting to find out what happend if you had deleted a column from…. or changed indexes and similar things!

[peterlaursen]

Does a column exist in advance in MySQL with that name?

If so and 'import into existing table' is selected your (new) mapping has no effect of course!

It is absolutely not just because you are reading from a XML-file.

You can easily verify yourself!

Please answer precisely: What does it mean that you 'can't edit mappings'.

Does not the dropdown respond or does your choice just not take effect?

It is always more precise to describe what happens compared to what does not happen <_<

[peterlaursen]

confirmed fixed with non-public beta3

[peterlaursen]

no change between beta2 and non-public beta3.

[peterlaursen]

Confirmed fixed in (non-public) beta3.

However there is another issue.

With HTTP-tunnel this has no effect:

Code:

SET NAMES utf8;
SET SQL_MODE='';
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO';

/*Table structure for table `TableName1` */
DROP TABLE IF EXISTS `TableName1`;
CREATE TABLE `TableName1` ……

/*Data for the table `TableName1` */
insert into ….

SET SQL_MODE=@OLD_SQL_MODE;

to execute SET NAMES and SET SQL_MODE like this you need to use mysql_pconnect() and not mysql_connect() in the Tunneller as with mysql_connect() the connection gets reset with the 'hardcoded' values from the tunneler for each statement.

Actually SQLyog tells 'import unsuccessfull' with the error message

“Error Code: 1231 – Variable 'sql_mode' can't be set to the value of 'NULL' “

[peterlaursen]

No other idea than that this must be a webserver/PHP configuration issue.

Can you execute any other PHP script accessing MySQL ?

I think I can give you a short sameple if you cannot create or have one yourself.

[peterlaursen]

“#1) Tabbed SQL Windows with corresponding resultsets”

You DO have TABBED SQL-windows but not TABBED connection-windows.

(implemented in 5.0 – 4.2 was never released)

You can have more Query TABS in the same connection.

[peterlaursen]

the requst for a TABBED interface is not new.

Even I suggested this about ½ year ago.

We will absolutely look into this once we get passed the UNICODE release.

We give priorites to FEATURES for the rest of this year.

[peterlaursen]

If you loook int the beta category of this Forums you will see that the issue with the Backup wizard is allready reported.

It is fixed in development tree. Next beta likely in a few hours.

[peterlaursen]

Can you connect to the tunnelling file with a browser?

[Author]

Posts