i cant import sql file into localhost phpmyadmin

Hi,

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:

#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 .

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sayuj Raghavan10y ago
yeahitgotsolved,thanks:)
0
Dipankar Biswas10y ago
Hi..
Check this link to help...
http://hepspace.com/web/answer_view.php?ID=33&qus=MySQL%20Error%201064:%20You%20have%20an%20error%20in%20your%20SQL%20syntax
+1