Increase the file size limit in phpmyadmin [duplicate]

Question

I have a sql file 480,396kb. I could not import the file in my phpmyadmin in this memory limit

is (Max: 128MiB) only. When I import the sql file it shows the error

You probably tried to upload a file that is too large. Please refer to documentation for a workaround for this limit.

I changed the memory limit in php.ini file both

upload_max_filesize and post_max_size also.

Answer 1

Importing a large file from the command line is simple:

#mysql -p... -u... -h... database_name < file.sql 

OR

You can use this plugins

Get from Here