Sayuj Raghavan

Sayuj Raghavan

  • 1.8k
  • 50
  • 4.2k

i cant import sql file into localhost phpmyadmin

Aug 20 2016 1:56 AM
  I am migrating my wordpress site from live to local host server.I exported the sql database frm live server's phpmyadmin . After tht i am trying to import into my local host phpmyadmin
i am getting this error(below)

SQL query:

-- Database: `information_schema`
- - CREATE DATABASE `information_schema` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

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 '--CREATE DATABASE `information_schema` DEFAULT CHARACTER SET utf8 COLLATE utf8_g' at line 4

can any help me to resolve this issue, I googled it but i cudnt find anything to resolve it . 

Answers (2)