How to increase phpmyadmin upload file size












10















I am not able to change the file size that phpmyadmin accepts for importing databases on my test server.



I have changed all values I have some idea about in my.cnf:



max_packet_size
Key_buffer


or the upload file size and
max_post_size value in every php.ini file I have found on the system.



The accepted file size on the import screen still remains 8,192kib.










share|improve this question

























  • As per reference of increase MySQL import file size by usage of a terminal of ubuntu.

    – GuruQuest
    Feb 7 '17 at 18:41
















10















I am not able to change the file size that phpmyadmin accepts for importing databases on my test server.



I have changed all values I have some idea about in my.cnf:



max_packet_size
Key_buffer


or the upload file size and
max_post_size value in every php.ini file I have found on the system.



The accepted file size on the import screen still remains 8,192kib.










share|improve this question

























  • As per reference of increase MySQL import file size by usage of a terminal of ubuntu.

    – GuruQuest
    Feb 7 '17 at 18:41














10












10








10


7






I am not able to change the file size that phpmyadmin accepts for importing databases on my test server.



I have changed all values I have some idea about in my.cnf:



max_packet_size
Key_buffer


or the upload file size and
max_post_size value in every php.ini file I have found on the system.



The accepted file size on the import screen still remains 8,192kib.










share|improve this question
















I am not able to change the file size that phpmyadmin accepts for importing databases on my test server.



I have changed all values I have some idea about in my.cnf:



max_packet_size
Key_buffer


or the upload file size and
max_post_size value in every php.ini file I have found on the system.



The accepted file size on the import screen still remains 8,192kib.







phpmyadmin






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Aug 19 '17 at 18:35









Zanna

50.7k13136241




50.7k13136241










asked Jun 24 '14 at 14:35









JoshJosh

43061434




43061434













  • As per reference of increase MySQL import file size by usage of a terminal of ubuntu.

    – GuruQuest
    Feb 7 '17 at 18:41



















  • As per reference of increase MySQL import file size by usage of a terminal of ubuntu.

    – GuruQuest
    Feb 7 '17 at 18:41

















As per reference of increase MySQL import file size by usage of a terminal of ubuntu.

– GuruQuest
Feb 7 '17 at 18:41





As per reference of increase MySQL import file size by usage of a terminal of ubuntu.

– GuruQuest
Feb 7 '17 at 18:41










4 Answers
4






active

oldest

votes


















3














The first things to check (or ask your host provider to check) are the values of max_execution_time, upload_max_filesize, memory_limit and post_max_size in the php.ini configuration file. All of these three settings limit the maximum size of data that can be submitted and handled by PHP.



Please note that post_max_size needs to be larger than upload_max_filesize.






share|improve this answer































    17














    To increase MySQL phpmyadmin import file size in Ubuntu 16.04 or newer, follow these steps. In the newest Ubuntu version you can have either PHP 5 or PHP 7.



    Step - 1: open php.ini of the appropriate PHP version(s).





    • For PHP v5.0



      sudo -H gedit /etc/php5/apache2/php.ini



    • For PHP v7.0



      sudo -H gedit /etc/php/7.0/apache2/php.ini



    • For PHP v7.1



      sudo -H gedit /etc/php/7.1/apache2/php.ini



    • For PHP v7.2



      sudo -H gedit /etc/php/7.2/apache2/php.ini



    • For PHP v7.3



      sudo -H gedit /etc/php/7.3/apache2/php.ini



    Step - 2: Now need to increase below parameters in the php.ini file.



    memory_limit = 1500M

    post_max_size = 1500M

    upload_max_filesize = 1500M


    Please Note : post_max_size should be larger than upload_max_size



    Step - 3: Now you need to restart your apache server to effect changes.



    sudo service apache2 restart





    share|improve this answer


























    • Someone else tried to leave this as a comment in response to this answer: "Note it is actually mentioned above but when I inserted 1500Mb it didn't worked.My localhost got out of the order. It should 1500m not 1500mb ;)"

      – doppelgreener
      Nov 8 '18 at 15:34



















    6
















    1. create info.php page and check all details about file



      <?php 
      phpinfo();
      ?>


    2. run in your browser search upload_max_filesize and post_max_size change by default value 2M to 80M.



    3. Run



      sudo -H gedit /etc/php5/apache2/php.ini


    4. change both values upload_max_filesize and post_max_size

      change by default value 2M to 80M



    5. Restart apache



      sudo /etc/init.d/apache2 restart







    share|improve this answer

































      2














      Set the variables upload_max_filesize, post_max_size, memory_limit in php.ini to the right values and restart the server, then it should work.

      If it does not work, check with phpinfo() if you edited the right php.ini.






      share|improve this answer























        Your Answer








        StackExchange.ready(function() {
        var channelOptions = {
        tags: "".split(" "),
        id: "89"
        };
        initTagRenderer("".split(" "), "".split(" "), channelOptions);

        StackExchange.using("externalEditor", function() {
        // Have to fire editor after snippets, if snippets enabled
        if (StackExchange.settings.snippets.snippetsEnabled) {
        StackExchange.using("snippets", function() {
        createEditor();
        });
        }
        else {
        createEditor();
        }
        });

        function createEditor() {
        StackExchange.prepareEditor({
        heartbeatType: 'answer',
        autoActivateHeartbeat: false,
        convertImagesToLinks: true,
        noModals: true,
        showLowRepImageUploadWarning: true,
        reputationToPostImages: 10,
        bindNavPrevention: true,
        postfix: "",
        imageUploader: {
        brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
        contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
        allowUrls: true
        },
        onDemand: true,
        discardSelector: ".discard-answer"
        ,immediatelyShowMarkdownHelp:true
        });


        }
        });














        draft saved

        draft discarded


















        StackExchange.ready(
        function () {
        StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f487644%2fhow-to-increase-phpmyadmin-upload-file-size%23new-answer', 'question_page');
        }
        );

        Post as a guest















        Required, but never shown

























        4 Answers
        4






        active

        oldest

        votes








        4 Answers
        4






        active

        oldest

        votes









        active

        oldest

        votes






        active

        oldest

        votes









        3














        The first things to check (or ask your host provider to check) are the values of max_execution_time, upload_max_filesize, memory_limit and post_max_size in the php.ini configuration file. All of these three settings limit the maximum size of data that can be submitted and handled by PHP.



        Please note that post_max_size needs to be larger than upload_max_filesize.






        share|improve this answer




























          3














          The first things to check (or ask your host provider to check) are the values of max_execution_time, upload_max_filesize, memory_limit and post_max_size in the php.ini configuration file. All of these three settings limit the maximum size of data that can be submitted and handled by PHP.



          Please note that post_max_size needs to be larger than upload_max_filesize.






          share|improve this answer


























            3












            3








            3







            The first things to check (or ask your host provider to check) are the values of max_execution_time, upload_max_filesize, memory_limit and post_max_size in the php.ini configuration file. All of these three settings limit the maximum size of data that can be submitted and handled by PHP.



            Please note that post_max_size needs to be larger than upload_max_filesize.






            share|improve this answer













            The first things to check (or ask your host provider to check) are the values of max_execution_time, upload_max_filesize, memory_limit and post_max_size in the php.ini configuration file. All of these three settings limit the maximum size of data that can be submitted and handled by PHP.



            Please note that post_max_size needs to be larger than upload_max_filesize.







            share|improve this answer












            share|improve this answer



            share|improve this answer










            answered Feb 14 '18 at 18:14









            Mostafa SoufiMostafa Soufi

            1454




            1454

























                17














                To increase MySQL phpmyadmin import file size in Ubuntu 16.04 or newer, follow these steps. In the newest Ubuntu version you can have either PHP 5 or PHP 7.



                Step - 1: open php.ini of the appropriate PHP version(s).





                • For PHP v5.0



                  sudo -H gedit /etc/php5/apache2/php.ini



                • For PHP v7.0



                  sudo -H gedit /etc/php/7.0/apache2/php.ini



                • For PHP v7.1



                  sudo -H gedit /etc/php/7.1/apache2/php.ini



                • For PHP v7.2



                  sudo -H gedit /etc/php/7.2/apache2/php.ini



                • For PHP v7.3



                  sudo -H gedit /etc/php/7.3/apache2/php.ini



                Step - 2: Now need to increase below parameters in the php.ini file.



                memory_limit = 1500M

                post_max_size = 1500M

                upload_max_filesize = 1500M


                Please Note : post_max_size should be larger than upload_max_size



                Step - 3: Now you need to restart your apache server to effect changes.



                sudo service apache2 restart





                share|improve this answer


























                • Someone else tried to leave this as a comment in response to this answer: "Note it is actually mentioned above but when I inserted 1500Mb it didn't worked.My localhost got out of the order. It should 1500m not 1500mb ;)"

                  – doppelgreener
                  Nov 8 '18 at 15:34
















                17














                To increase MySQL phpmyadmin import file size in Ubuntu 16.04 or newer, follow these steps. In the newest Ubuntu version you can have either PHP 5 or PHP 7.



                Step - 1: open php.ini of the appropriate PHP version(s).





                • For PHP v5.0



                  sudo -H gedit /etc/php5/apache2/php.ini



                • For PHP v7.0



                  sudo -H gedit /etc/php/7.0/apache2/php.ini



                • For PHP v7.1



                  sudo -H gedit /etc/php/7.1/apache2/php.ini



                • For PHP v7.2



                  sudo -H gedit /etc/php/7.2/apache2/php.ini



                • For PHP v7.3



                  sudo -H gedit /etc/php/7.3/apache2/php.ini



                Step - 2: Now need to increase below parameters in the php.ini file.



                memory_limit = 1500M

                post_max_size = 1500M

                upload_max_filesize = 1500M


                Please Note : post_max_size should be larger than upload_max_size



                Step - 3: Now you need to restart your apache server to effect changes.



                sudo service apache2 restart





                share|improve this answer


























                • Someone else tried to leave this as a comment in response to this answer: "Note it is actually mentioned above but when I inserted 1500Mb it didn't worked.My localhost got out of the order. It should 1500m not 1500mb ;)"

                  – doppelgreener
                  Nov 8 '18 at 15:34














                17












                17








                17







                To increase MySQL phpmyadmin import file size in Ubuntu 16.04 or newer, follow these steps. In the newest Ubuntu version you can have either PHP 5 or PHP 7.



                Step - 1: open php.ini of the appropriate PHP version(s).





                • For PHP v5.0



                  sudo -H gedit /etc/php5/apache2/php.ini



                • For PHP v7.0



                  sudo -H gedit /etc/php/7.0/apache2/php.ini



                • For PHP v7.1



                  sudo -H gedit /etc/php/7.1/apache2/php.ini



                • For PHP v7.2



                  sudo -H gedit /etc/php/7.2/apache2/php.ini



                • For PHP v7.3



                  sudo -H gedit /etc/php/7.3/apache2/php.ini



                Step - 2: Now need to increase below parameters in the php.ini file.



                memory_limit = 1500M

                post_max_size = 1500M

                upload_max_filesize = 1500M


                Please Note : post_max_size should be larger than upload_max_size



                Step - 3: Now you need to restart your apache server to effect changes.



                sudo service apache2 restart





                share|improve this answer















                To increase MySQL phpmyadmin import file size in Ubuntu 16.04 or newer, follow these steps. In the newest Ubuntu version you can have either PHP 5 or PHP 7.



                Step - 1: open php.ini of the appropriate PHP version(s).





                • For PHP v5.0



                  sudo -H gedit /etc/php5/apache2/php.ini



                • For PHP v7.0



                  sudo -H gedit /etc/php/7.0/apache2/php.ini



                • For PHP v7.1



                  sudo -H gedit /etc/php/7.1/apache2/php.ini



                • For PHP v7.2



                  sudo -H gedit /etc/php/7.2/apache2/php.ini



                • For PHP v7.3



                  sudo -H gedit /etc/php/7.3/apache2/php.ini



                Step - 2: Now need to increase below parameters in the php.ini file.



                memory_limit = 1500M

                post_max_size = 1500M

                upload_max_filesize = 1500M


                Please Note : post_max_size should be larger than upload_max_size



                Step - 3: Now you need to restart your apache server to effect changes.



                sudo service apache2 restart






                share|improve this answer














                share|improve this answer



                share|improve this answer








                edited Jan 6 at 16:00









                Fendi Setiawan

                31




                31










                answered Aug 18 '17 at 19:53









                Bhaskar BhattBhaskar Bhatt

                30124




                30124













                • Someone else tried to leave this as a comment in response to this answer: "Note it is actually mentioned above but when I inserted 1500Mb it didn't worked.My localhost got out of the order. It should 1500m not 1500mb ;)"

                  – doppelgreener
                  Nov 8 '18 at 15:34



















                • Someone else tried to leave this as a comment in response to this answer: "Note it is actually mentioned above but when I inserted 1500Mb it didn't worked.My localhost got out of the order. It should 1500m not 1500mb ;)"

                  – doppelgreener
                  Nov 8 '18 at 15:34

















                Someone else tried to leave this as a comment in response to this answer: "Note it is actually mentioned above but when I inserted 1500Mb it didn't worked.My localhost got out of the order. It should 1500m not 1500mb ;)"

                – doppelgreener
                Nov 8 '18 at 15:34





                Someone else tried to leave this as a comment in response to this answer: "Note it is actually mentioned above but when I inserted 1500Mb it didn't worked.My localhost got out of the order. It should 1500m not 1500mb ;)"

                – doppelgreener
                Nov 8 '18 at 15:34











                6
















                1. create info.php page and check all details about file



                  <?php 
                  phpinfo();
                  ?>


                2. run in your browser search upload_max_filesize and post_max_size change by default value 2M to 80M.



                3. Run



                  sudo -H gedit /etc/php5/apache2/php.ini


                4. change both values upload_max_filesize and post_max_size

                  change by default value 2M to 80M



                5. Restart apache



                  sudo /etc/init.d/apache2 restart







                share|improve this answer






























                  6
















                  1. create info.php page and check all details about file



                    <?php 
                    phpinfo();
                    ?>


                  2. run in your browser search upload_max_filesize and post_max_size change by default value 2M to 80M.



                  3. Run



                    sudo -H gedit /etc/php5/apache2/php.ini


                  4. change both values upload_max_filesize and post_max_size

                    change by default value 2M to 80M



                  5. Restart apache



                    sudo /etc/init.d/apache2 restart







                  share|improve this answer




























                    6












                    6








                    6









                    1. create info.php page and check all details about file



                      <?php 
                      phpinfo();
                      ?>


                    2. run in your browser search upload_max_filesize and post_max_size change by default value 2M to 80M.



                    3. Run



                      sudo -H gedit /etc/php5/apache2/php.ini


                    4. change both values upload_max_filesize and post_max_size

                      change by default value 2M to 80M



                    5. Restart apache



                      sudo /etc/init.d/apache2 restart







                    share|improve this answer

















                    1. create info.php page and check all details about file



                      <?php 
                      phpinfo();
                      ?>


                    2. run in your browser search upload_max_filesize and post_max_size change by default value 2M to 80M.



                    3. Run



                      sudo -H gedit /etc/php5/apache2/php.ini


                    4. change both values upload_max_filesize and post_max_size

                      change by default value 2M to 80M



                    5. Restart apache



                      sudo /etc/init.d/apache2 restart








                    share|improve this answer














                    share|improve this answer



                    share|improve this answer








                    edited Aug 19 '17 at 18:36









                    Zanna

                    50.7k13136241




                    50.7k13136241










                    answered Oct 10 '16 at 14:07









                    Siddharth ShuklaSiddharth Shukla

                    16113




                    16113























                        2














                        Set the variables upload_max_filesize, post_max_size, memory_limit in php.ini to the right values and restart the server, then it should work.

                        If it does not work, check with phpinfo() if you edited the right php.ini.






                        share|improve this answer




























                          2














                          Set the variables upload_max_filesize, post_max_size, memory_limit in php.ini to the right values and restart the server, then it should work.

                          If it does not work, check with phpinfo() if you edited the right php.ini.






                          share|improve this answer


























                            2












                            2








                            2







                            Set the variables upload_max_filesize, post_max_size, memory_limit in php.ini to the right values and restart the server, then it should work.

                            If it does not work, check with phpinfo() if you edited the right php.ini.






                            share|improve this answer













                            Set the variables upload_max_filesize, post_max_size, memory_limit in php.ini to the right values and restart the server, then it should work.

                            If it does not work, check with phpinfo() if you edited the right php.ini.







                            share|improve this answer












                            share|improve this answer



                            share|improve this answer










                            answered Jun 24 '14 at 14:39









                            PabiPabi

                            5,67433042




                            5,67433042






























                                draft saved

                                draft discarded




















































                                Thanks for contributing an answer to Ask Ubuntu!


                                • Please be sure to answer the question. Provide details and share your research!

                                But avoid



                                • Asking for help, clarification, or responding to other answers.

                                • Making statements based on opinion; back them up with references or personal experience.


                                To learn more, see our tips on writing great answers.




                                draft saved


                                draft discarded














                                StackExchange.ready(
                                function () {
                                StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f487644%2fhow-to-increase-phpmyadmin-upload-file-size%23new-answer', 'question_page');
                                }
                                );

                                Post as a guest















                                Required, but never shown





















































                                Required, but never shown














                                Required, but never shown












                                Required, but never shown







                                Required, but never shown

































                                Required, but never shown














                                Required, but never shown












                                Required, but never shown







                                Required, but never shown







                                Popular posts from this blog

                                How to change which sound is reproduced for terminal bell?

                                Title Spacing in Bjornstrup Chapter, Removing Chapter Number From Contents

                                Can I use Tabulator js library in my java Spring + Thymeleaf project?