Sql-import Fails With Http-tunnel

[peterlaursen]

see attached picture.

This is a beta issue only. Not 5.18!

[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' “

[Author]

Posts