• The error is:

    Error

    SQL query:

    phpMyAdmin SQL Dump
    — version 3.5.5
    — phpmyadmin.net

    — Host: localhost
    — Generation Time: Apr 30, 2014 at 12:53 PM
    — Server version: 5.5.33-31.1
    — PHP Version: 5.4.23

    SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”;

    MySQL said: Documentation
    #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 ‘phpMyAdmin SQL Dump
    — version 3.5.5
    — phpmyadmin.net

    — Host: lo’ at line 1

    I used this exported DB to move from one HostGator (call it A) account to another (call it B) about a year+ ago. I’m cleaning up a hacked website mess on HostGator account B so I’m restoring this website from my original files (from HostGator A) on my computer to another HostGator (call it C) account. It worked when I imported it last year.

    Here are the first few lines:

    -- phpMyAdmin SQL Dump
    -- version 3.5.5
    -- https://www.phpmyadmin.net
    --
    -- Host: localhost
    -- Generation Time: Apr 30, 2014 at 12:53 PM
    -- Server version: 5.5.33-31.1
    -- PHP Version: 5.4.23
    
    SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
    SET time_zone = "+00:00";
    
    /*!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: <code>hosting_NameChangedForThisPost</code>
    --
    
    --
  • The topic ‘DB import problem "You have an error in your SQL syntax; Host: lo' at line 1 "’ is closed to new replies.