0

I try to import a csv file into phpmyadmin using wampserver.

I created the db and I go to import option.

I select the file which is 26MB.

I select to keep the line as the name of values.

Finally I receive this:

#2006 - MySQL server has gone away

How can I import the file?

angs
  • 341
  • 3
  • 5
  • 13
  • Next to the file upload there should be "max upload". What does that say for you? – Devin H. Jun 17 '15 at 12:40
  • possible duplicate of [MySQL Server has gone away when importing large sql file](http://stackoverflow.com/questions/12425287/mysql-server-has-gone-away-when-importing-large-sql-file) – Devin H. Jun 17 '15 at 14:38

1 Answers1

0

You can use command to import tables into database as below :

mysql -uUSERNAME -pPASSWORD -hHOSTNAME DATABASENAME < FILEPATH

FilePath must be like : /home/xxx/Desktop/abc.sql `

AnkiiG
  • 3,468
  • 1
  • 17
  • 28