How to Increase Import Size Limit in phpMyAdmin



I had the same problem with my working correctly by doing the following


changes into the php.ini file

post_max_size = 800M 
upload_max_filesize = 800M 
max_execution_time = 5000 
max_input_time = 5000 
memory_limit = 1000M 




If you are working on XAMPP then you can fix the MySQL Server has gone away issue with following changes..


open your my.ini file my.ini location is (D:\xampp\mysql\bin\my.ini)


change the following variable values

max_allowed_packet = 64M
innodb_lock_wait_timeout = 500


Comments

Post a Comment

Popular posts from this blog

Android App Version Update using the following cordova cli commands

Change the version in config.xml ionic cordova build --release android jarsigner -verbose -sigalg SHA1withRSA -digestalg SHA1 -keystore my-release-key.keystore app-release-unsigned.apk alias_name_1 C:\Users\<Username>\AppData\Local\Android\Sdk\build-tools\23.0.2\zipalign.exe -v 4 app-release-unsigned.apk NameOfTheApp.apk Note:   C:\Users\<Username>\AppData\Local\Android\Sdk\build-tools\23.0.2\zipalign.exe --  this path may vary depending on your OS/Folder configuration.  Once release build is generated upload your APK, for upload the new version in play store follow the below link . 1. First, log in to the Google Play Developer Console. 2. Next, locate your app in the app choices listed for your developer account. Click on the appropriate app. 3. Next, click on 'Release Management', then 'App Releases'. 4. To upload a new .APK file, click on 'Manage Production', then 'Create Release'. 5. Drag and drop the new .APK file into the 'APKs to a...
Read more

75 inspirational quotes that will change your life

1 of 75 Oprah Winfrey Quote : "You become what you believe." 2 of 75 Margaret Thatcher Quote : "You may have to fight a battle more than once to win it. 3 of 75 Steve Jobs Quote : "The only way to do great work is to love what you do." 4 of 75 Audrey Hepburn Quote : "Nothing is impossible, the word itself says, 'I'm possible!'" 5 of 75 Dalai Lama Quote : "Happiness is not something readymade. It comes from your own actions." 6 of 75 Amelia Earhart Quote : "The most difficult thing is the decision to act, the rest is merely tenacity." 7 of 75 Dolly Parton Quote : "If you see someone without a smile give them yours." 8 of 75 Jane Fonda Quote : "It's never to late- never to late to change your life,never to late to be happy." 9 of 75 Cate Blanchett Quote : "If you know you are going to fail, then fail gloriously." 10 of 75 Drew Barrymore Quote : "Life is very interesting... in t...
Read more

Retrieval Image From DataBase and Display on WebPage by Using Servlets.

Hi Frnds, This Session I will Explain you to " How Retrive Image from DataBase Using Servlets and Display it on WebPage " The below code is useful for  Retrive Image from DataBase Using Servlets and Display it on WebPage. import java.io.*; import java.sql.*; import javax.servlet.*; import javax.servlet.http.*; import javax.servlet.http.HttpServlet; import javax.servlet.annotation.WebServlet; @WebServlet("/ImageDis") public class ImageDis extends HttpServlet { public void service(HttpServletRequest request,HttpServletResponse response)  throws IOException,ServletException {  response.setContentType("image/jpeg"); Blob image = null; Connection con = null; byte[ ] imgData = null ; Statement stmt = null; ResultSet rs = null; try { Class.forName("com.mysql.jdbc.Driver"); con = DriverManager.getConnection("jdbc:mysql://localhost:3306/DbName","UserName","Password"); stmt = con.createStatement...
Read more