title: the right syntax to use near '' at line 1 my sql
body: <p>I know this question has been asked quite a few times, but unfortunately, I failed to find the solution for this problem. May be there is some trivial thing that I am missing .. </p>
  
  <p>I have exported the database schema from mysql workbench and trying to build the database from it on the linux machine. However when I run the script it throws the error like below:</p>
  
  <blockquote>
    <p>ERROR: 1064  You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1</p>
  </blockquote>
  
  <p>In addition, I have tried many combinations with quotes and all. below is my part of the exported sql file. </p>
  
  <pre><code>CREATE DATABASE IF NOT EXISTS `abcdata` /*!40100 DEFAULT CHARACTER SET utf8 */;
  USE `abcdata`;
  -- MySQL dump 10.13  Distrib 5.7.17, for Win64 (x86_64)
  --
  -- Host: localhost    Database: abcdata
  -- ------------------------------------------------------
  -- Server version   8.0.3-rc-log
  
  /*!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 */;
  
  --
  -- Table structure for table `databoard`
  --
  
  DROP TABLE IF EXISTS `databoard`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `databoard` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hwunit_id` int(11) NOT NULL,
  `brd_board_type` varchar(128) NOT NULL,
  `brd_manufacturer` varchar(128) DEFAULT '""',
  `brd_article_number` varchar(128) DEFAULT '""',
  `brd_production_date` date DEFAULT NULL,
  `brd_delivery_revision` varchar(128) DEFAULT '""',
  `brd_present_revision` varchar(128) DEFAULT '""',
  `brd_rev_date` varchar(32) DEFAULT '""',
  `brd_made_the_last_rev` varchar(128) DEFAULT '""',
  `brd_serial_number` varchar(128) DEFAULT '""',
  `brd_slot_number` varchar(128) DEFAULT '""',
  PRIMARY KEY (`id`)    ) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT 
   CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  </code></pre>
  
  <p>as specified error is in line 1. </p>