Unsupported Screen Size: The viewport size is too small for the theme to render properly.

/*!40101 Comment */;

forums forums SQLyog SQLyog: Bugs / Feature Requests /*!40101 Comment */;

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • #9809
      peterlaursen
      Participant

      this is the beginneing of a typical 'mysqldump' dump

      /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

      /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

      /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

      /*!40101 SET NAMES utf8 */;

      /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

      /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

      /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

      /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

      etc ….

      If you copy it into the SQL-pane of SQLyog it works fine! However if you import the file '/*!40101' raises an error. This comment style means execute only if MySQL serverversion is >= 4.1.01 (I think). Looks like the import tool strips out these 'comments' (but does wrong) and the SQL-editor does not strip out! The server handles it perfectly!

Viewing 0 reply threads
  • You must be logged in to reply to this topic.