title: MySQL Syntax error when locally importing dump from Amazon MySQL RDS?
body: <p>When I create a database dump from Amazon RDS and then I try to import it locally, the result is <code>ERROR 1064 (42000) at line 54</code>.</p>
  
  <p>At line 54 there is the following statement:
  <code>CREATE TABLE account_emailconfirmation (</code></p>
  
  <p>The command used for dump is:
  <code>mysqldump -u user -h host.rds.amazonaws.com -p --default-character-set=utf8 --result-file=sync.sql database_name</code></p>
  
  <p>The command used for import is:
  <code>mysql --user=root -p mpl -vv &lt; sync.sql</code></p>
  
  <p>And here is the output (verbosity increased).</p>
  
  <pre><code>--------------
  CREATE TABLE `account_emailconfirmation` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `created` datetime(6) NOT NULL,
    `sent` datetime(6) DEFAULT NULL,
    `key` varchar(64) NOT NULL,
    `email_address_id` int(11) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `key` (`key`),
    KEY `acc_email_address_id_5bcf9f503c32d4d8_fk_account_emailaddress_id` (`email_address_id`),
    CONSTRAINT `acc_email_address_id_5bcf9f503c32d4d8_fk_account_emailaddress_id` FOREIGN KEY (`email_address_id`) REFERENCES `account_emailaddress` (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  --------------
  
  ERROR 1064 (42000) at line 54: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6) NOT NULL,
    `sent` datetime(6) DEFAULT NULL,
    `key` varchar(64) NOT NULL,
   ' at line 3
  Bye
  </code></pre>