P3PHP

Don't think out of box.Think like there is no box.

By

Import Large sql file from phpmyadmin

Hello Friends,
I was trying to import a 500MB file in phpmyadmin using import tab in phpmyadmin. When I select file and start import it shows me below error.

“You probably tried to upload too large file. Please refer to documentation for ways to work around this limit.”

I have set all ways to increase limit from mysql than it throws me time out error. I increased timeout but still it keeps loading and never finishes the import. I found a way to get this done using other way. Here it is.

Go to phpmyadmin directory under your xampp directory.
1. Open config.inc.php file and set/add this line. $cfg['UploadDir'] = ‘upload’;
2. Now create upload folder inside your phpmyadmin folder and put your .sql file in upload folder.
3. Now open phpmyadmin in browser, go to import. You can see the file in dropdown just below browse button.
4. Select it and Gooooooo…
This will surely work. You will never face error like

“You probably tried to upload too large file. Please refer to documentation for ways to work around this limit.”

with this method. You can import large sql files from phpmyadmin. Easy to import large sql file from phpmyadmin.

+6
-5
  

8 Responses to Import Large sql file from phpmyadmin

  1. Piero says:

    Are you kidding me? Not all of us are using that stupid XAMPP. Tell us the location of phpMyAdmin directory on other systems, otherwise your post is useless!

  2. Pratik Patel says:

    you are not wrong Piero.
    I think following link will help you for wamp server
    http://question-answer-pvk.blogspot.in/2012/08/how-to-import-large-sql-files-into.html

  3. Sobir Bakhtiyor says:

    Thanks a lot. Good luck!

  4. VJ says:

    This is great work Mate, Thanks a lot.

    Cheers
    VJ

  5. Corzu says:

    That worked for me. Thanks Patrik

  6. kevin read says:

    *****Perfect**** just what i needed . had such a headache trying different methods but this went straight through . thanks for sharing

  7. Pratik Patel says:

    You all’re welcome Sobir Bakhtiyor,VJ,Corzu,kevin read.
    Thanks for reading my post.

  8. Jonathan says:

    Thanks very much for taking the time to post this. Helped me out very much!

Leave a Reply

Your email address will not be published. Required fields are marked *

− 3 = one

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>