logo
  • Home
  • Blog
  • About
  • Contact
  • Services
Login
Call Us
+91

Cookies Consent

This website use cookies to help you have a superior and more relevant browsing experience on the website. Read more...

logo Login
  • +91
  • inquiries@advantageaieng.com
shape
shape
shape

Blog Details

Home Blog Details
image
  • By Bimlesh Kumar
  • 20 Nov, 2025
  • Ubuntu

Increase File Upload Size in Ubuntu + Apache (For SQL & .gz Files)

Increase File Upload Size in Ubuntu + Apache (For SQL & .gz Files)

Running into the 2MB upload limit when uploading .sql or .sql.gz files on Ubuntu + Apache?
This limit comes from PHP defaults. Here’s the exact fix.


1. Edit php.ini

Check your PHP version:

php -v

Open the Apache PHP config:

sudo nano /etc/php//apache2/php.ini

Update the limits:

upload_max_filesize = 64M post_max_size = 64M memory_limit = 512M max_execution_time = 300

2. Restart Apache

sudo systemctl restart apache2

3. Verify Changes

Create a phpinfo page:

<?php phpinfo(); ?>

Open in browser:

http://your-server-ip/phpinfo.php

Confirm updated values:

  • upload_max_filesize

  • post_max_size

Bonus: Import Large SQL Files Faster

phpMyAdmin is slow for big files. Use terminal import instead:

zcat backup.sql.gz | mysql -u root -p your_database
Tags: Linux DevOps Apache
Share:
Search
Category
  • Database Security (0)
  • IT Consultancy (4)
  • App Development (1)
  • Ubuntu (1)
Resent Post
  • image
    05 Dec, 2025
    Top jQuery Interview Questions and Answers for 2025 Part 3 (Beginner to Advanced)
  • image
    04 Dec, 2025
    Top jQuery Interview Questions and Answers for 2025 Part 2 (Beginner to Advanced)
  • image
    03 Dec, 2025
    Top jQuery Interview Questions and Answers for 2025 (Beginner to Advanced)
Tags
jQuery Interview Learning Development Questions Apache Server Web SSL HTTP Security Ubuntu Optimization MySQL PHP Composer Linux DevOps EngineeringExcellence SaaS Developers AAI
shape
shape
shape
shape
shodow
image

Advantage AI Engineering Private Limited

Our Services

  • IT Management
  • Cybersecurity & Data Protection
  • IT Consultancy
  • App Development
  • Cloud & DevOps Services

Quick Link

  • FAQ
  • Home
  • Blog
  • About
  • Contact

Contact Us

A-130, Sector-63, Noida, UP-201301

  • Opening Hours:

    Mon - Fri: 11.00 AM - 5.00 AM

  • Phone Call:

    +91

© All Copyright 2025 by Advantage Ai Engineering Private Limited

  • Terms & Conditions
  • Privacy Policy