MySQL server has gone away in wampserver

Question

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?

Answer 1

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 `