phpmyadmin sql dump error Follow
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?
Please sign in to leave a comment.
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
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.
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)