Hello everyone,
I ran into a problem while trying to migrate my drupal site from one hosting plan to another within the same hosting company. While importing the database in phpMyAdmin, I got this error:
ERROR: C1 C2 LEN: 20 21 750
STR:
MySQL: 5.5.49-cll-lve
USR OS, AGENT, VER: Linux MOZILLA 5.0
PMA: 4.0.10.14
PHP VER,OS: 5.4.31 Linux
LANG: en
SQL: barywhyt_drup542.sql000644 001750 001750 00266465750 12753436007 014771 0ustar00seunseun000000 000000 -- phpMyAdmin SQL Dump
-- version 4.0.10.14
-- http://www.phpmyadmin.net
--
-- Host: localhost:3306
-- Generation Time: Aug 12, 2016 at 02:32 PM
-- Server version: 5.5.50-cll
-- PHP Version: 5.4.31
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
----END RAW----
SQL query:
barywhyt_drup542.sql000644 001750 001750 00266465750 12753436007 014771 0ustar00seunseun000000 000000 -- phpMyAdmin SQL Dump -- version 4.0.10.14 -- http://www.phpmyadmin.net -- -- Host: localhost:3306 -- Generation Time: Aug 12, 2016 at 02:32 PM -- Server version: 5.5.50-cll -- PHP Version: 5.4.31 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 'barywhyt_drup542.sql' at line 1
The particular portion that this error appear to point to is :
-- phpMyAdmin SQL Dump
-- version 4.0.10.14
-- http://www.phpmyadmin.net
--
-- Host: localhost:3306
-- Generation Time: Aug 12, 2016 at 02:32 PM
-- Server version: 5.5.50-cll
-- PHP Version: 5.4.31
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 */;
Can anyone please help me out? I cannot figure out where this error is coming from. Of course this is not drupal issue but I will appreciate any help I can get here.
Thank you all readers