title: phpmyadmin #1064 error importing remote mysql database into localhost using phpmyadmin
body: <p>I have downloaded the remote contents of a client's website, and I am trying to get them running on my local server. I created and exported the database using phpmyadmin on GoDaddy and tried to import it using phpmyadmin on my localhost (running a fresh LAMP setup on Ubuntu 14.0.4), but got the following message:</p>
  <h1>1064 - 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 'PK' at line 1</h1>
  <p>Here is the export:</p>
  <hr />
  <pre><code>    -- phpMyAdmin SQL Dump
      -- version 2.11.11.3
      -- http://www.phpmyadmin.net
      --
      -- Host: XX.XXX.XXX.XX
      -- Generation Time: Apr 16, 2015 at 02:38 PM
      -- Server version: 5.5.40
      -- PHP Version: 5.1.6
      
      SET SQL_MODE=&quot;NO_AUTO_VALUE_ON_ZERO&quot;;
      
      
      /*!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 */;
      
      --
      -- Database: `XXXXXXXXXX`
      --
      CREATE DATABASE `XXXXXXXXXX` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
  
  USE `XXXXXXXXXX`;
  </code></pre>
  <hr />
  <p>Looking at other people's #1064 error problems did not really enlighten me much, as my error message references the syntax near &quot;PK&quot; at line 1, and &quot;PK&quot; is nowhere in the file. Any insight would be helpful. This is the first time I've tried moving a website from remote server (would also like to be able to move them in the other direction as well)</p>