phpmyadmin sql dump error

Whenever I'm using mysql dumps generated from phpmyadmin I get errors even if the generated code is perfectly OK. Here is the example:

CREATE DATABASE  IF NOT EXISTS `dpn` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `dpn`;
-- MySQL dump 10.13  Distrib 5.1.40, for Win32 (ia32)
--
-- Host: localhost    Database: dpn
-- ------------------------------------------------------
-- Server version     5.1.37

DROP TABLE IF EXISTS `models`;

There is error shown on E in IF EXISTS which says: expected on of the following : / ;
Is this a bug or am I doing something wrong?

3 comments

Have you selected appropriate (MySQL) SQL dialect as default at Settings | SQL dialects?
If you did - than this is a bug, file a report at http://youtrack.jetbrains.net/issues/WI

0

Double checked my settings, project was set up for MySQL, I additionaly set up all of the SQL files to use MySQL dialect but same error shows up.

0

Please file error report to http://youtrack.jetbrains.net/issues/WI
Please describe carefully what you mean under "using mysql dumps"
(responsible developer is on vacation so it will take some time to progress)

0

Please sign in to leave a comment.