How to change import file size in PhpmyAdmin

February 6, 2018

When you transfer your website one server to another server. When you import your sql files in phpmyadmin . You face this type of problem many time.

If you have a local server installation PHP and MySql then you might often required to import database files into your phpmyadmin

the error will looking like this.

No data was received to import. Either no file name was submitted, or the file size exceeded the maximum size permitted by your PHP configuration

Different Different Software have the different import sql file size. But good thing is the you can change it as per requirement.

Today we are Discuss about xampp server. You have to Follow this step….

  1. Open the Xampp Control Panel.
  2. Click on the Config in the Apache row.
  3. Click on the php.ini from dropdown menu.
  4. Search for keyword upload_max_filesize or visit the line number approx 800 and change the value of attribute upload_max_filesize to the value you require. By default import sql file limit will be 2MB.
  5. Save the File.
  6. Restart Your Apache and MySql.

if this is not work in your condition. then changes in below code

Now You can easily upload file and Import file size will be 500MB or below 500MB. You can also change the maximum execution time and input time to change in php.ini.

If you guys have any question please feel free to ask and put your doubts in the comments section below.

 

Karan Suthar

Surat, India

I'm Karan, the creator Behind the KTechBlog. I write Blogs in my Free Time. I ❤ to learn new Technologies and Share with Others. I'm Trying best effort to make KTechBlog useful for Everyone.