0

I am trying to import a 70 MB .sql file in PHPMYADMIN but it give me the limit error:

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

I have changed the values of upload_max_filesize, memory_limit and post_max_size in the php.ini and have restarted xampp but its still not working ??? please help

8
  • Which limit error do you get? Please show the error message.
    – hakre
    Jul 27, 2011 at 14:02
  • 1
    You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit.
    – user418232
    Jul 27, 2011 at 14:04
  • 5
    mysql dbname < importfile.sql
    – thetaiko
    Jul 27, 2011 at 14:04
  • Try to use Execute Large Script tool in dbForge Studio for MySQL.
    – Devart
    Jul 27, 2011 at 14:09
  • 1
    @thetaiko pv importfile.sql | mysql dbname gives you a progress bar. pv is available in EPEL for RHEL/CentOS, and probably via Your Favorite Package Manager™ in other distributions.
    – BMDan
    Jul 27, 2011 at 19:11

1 Answer 1

1

Maybe the phpmyadmin import formulary is block your upload. Look next to upload form field the max value, if it is less then 70mb you can increase it on MAX_FILE_SIZE hidden field.

4
  • Yes this field still shows 16 M ...
    – user418232
    Jul 27, 2011 at 15:09
  • Can you please specify the hidden field you are talking about ???
    – user418232
    Jul 27, 2011 at 15:10
  • the field is on html formulary bellow the upload file field, it is responsable to limit the max size value to upload.
    – GodFather
    Jul 27, 2011 at 18:12
  • if it not work, maybe this tip can help you: phpmyadmin.net/documentation/Documentation.html#faq1_16
    – GodFather
    Jul 27, 2011 at 18:13

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .