Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question

migrated from stackoverflow.com Jul 27 '11 at 19:01

This question came from our site for professional and enthusiast programmers.

    
Which limit error do you get? Please show the error message. –  hakre Jul 27 '11 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 '11 at 14:04
5  
mysql dbname < importfile.sql –  thetaiko Jul 27 '11 at 14:04
    
Try to use Execute Large Script tool in dbForge Studio for MySQL. –  Devart Jul 27 '11 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 '11 at 19:11

1 Answer 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.

share|improve this answer
    
Yes this field still shows 16 M ... –  user418232 Jul 27 '11 at 15:09
    
Can you please specify the hidden field you are talking about ??? –  user418232 Jul 27 '11 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 '11 at 18:12
    
if it not work, maybe this tip can help you: phpmyadmin.net/documentation/Documentation.html#faq1_16 –  GodFather Jul 27 '11 at 18:13

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.