Increase the file size limit in phpmyadmin

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.

This [FAQ entry](https://phpmyadmin.readthedocs.org/en/QA_4_0/faq.html?highlight=import%20size#i-cannot-upload-big-dump-files-memory-http-or-timeout-problems) from phpMyAdmin documentation on importing big dump files might come handy. — Madhura Jayaratne, Aug 23 '13 at 12:42

Nisarg · Answer 1 · 2013-08-23T05:58:21.810

6

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

edited Aug 23 '13 at 05:58

answered Aug 23 '13 at 05:48

Nisarg

3,024
5
32
54

score 3 · Answer 2 · answered Aug 23 '13 at 05:42

3

restart the connection of your apache.

answered Aug 23 '13 at 05:42

pEte wEntz Mendoza

53
3

score 1 · Answer 3 · answered Aug 23 '13 at 05:47

1

Try to change max_file_uploads, did you see maxfilesize to upload in phpmyadmin,if you change all in php.ini then it must update,

also restart apache

answered Aug 23 '13 at 05:47

Sagar Thesia

11
1

score -1 · Answer 4 · answered Aug 23 '13 at 05:47

-1

I would suggest using the mysql command line tool for importing a database. This way you don't have the memory limit problem and the import is 100x faster.

answered Aug 23 '13 at 05:47

Wim Mostmans

3,485
1
20
20

1

How to use that and where please tel.... – Ishu Aug 23 '13 at 06:21
1

Agreed with Ishu. Learnt nothing from this answer, or the command line answer by Napster. – Jayden Lawson Jun 13 '15 at 00:31

Increase the file size limit in phpmyadmin

4 Answers4