Help - Search - Members - Calendar
Full Version: Sql-import Fails With Http-tunnel
Webyog Forums > SQLyog > SQLyog BETA Discussions
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' "
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2008 Invision Power Services, Inc.