DB import problem "You have an error in your SQL syntax; Host: lo' at line 1 "
-
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.23SET 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 1I 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.