If you're working with databases in a local development environment using XAMPP, you've probably run into the "max upload size exceeded" error when trying to import a large SQL file using phpMyAdmin. Fortunately, there are several ways to overcome this limitation.

In this guide, we'll show you how to import large SQL files in XAMPP on localhost, covering both manual and advanced methods. Whether you're a beginner or an experienced developer, this step-by-step tutorial will help you get the job done efficiently.

Why You Might Face Issues Importing Large SQL Files

By default, phpMyAdmin (which comes with XAMPP) limits the file upload size (often to 2MB or 8MB). If your .sql file is larger than this, the import will fail.

Common error messages include:

  • "You probably tried to upload too large file."
  • "Maximum execution time exceeded."
  • "Memory limit exhausted."

Solution 1: Increase Import Limits in php.ini (Recommended)

The most reliable way to import large SQL files is to increase the PHP configuration limits.

Step 1: Open the php.ini File

  1. Go to your XAMPP installation directory.
  2. Open this path:
    C:\xampp\php\php.ini

Step 2: Modify These Settings

Search for the following directives and increase their values:

upload_max_filesize = 128M
post_max_size = 128M
memory_limit = 256M
max_execution_time = 300
max_input_time = 300

You can set the values higher depending on your system and the size of your SQL file.

Step 3: Restart Apache Server

  • Open XAMPP Control Panel.
  • Click Stop next to Apache.
  • Then click Start to restart it.

Now go to phpMyAdmin and try importing the file again.

Solution 2: Use the Command Line (Fastest for Very Large Files)

If your SQL file is extremely large (100MB+), using the command line is much faster and more reliable.

Step 1: Open Command Prompt

  • Press Windows + R, type cmd, and press Enter.

Step 2: Navigate to the MySQL Bin Directory

cd C:\xampp\mysql\bin

Step 3: Run the Import Command

mysql -u root -p your_database_name < C:\path\to\your\file.sql
  • Replace your_database_name with the actual name of your database.
  • Replace the path with the full path to your .sql file.
  • If you haven't set a MySQL root password, just press Enter when prompted.

Tip: Make sure the database already exists before running this command. You can create it via phpMyAdmin or with this command:

 

CREATE DATABASE your_database_name;

Solution 3: Split the SQL File (If You're Still Facing Issues)

If you're dealing with a multi-gigabyte file, you can split it into smaller chunks using a tool like:

  • SQLDumpSplitter
  • BigDump: Staggered MySQL Dump Importer

These tools help avoid timeout or memory issues by importing the file in parts.

Pro Tips for Working with Large SQL Files

  • Use .sql files only – Avoid exporting zipped or compressed files if possible.
  • Optimize your SQL dump – Remove unnecessary INSERT statements or data if not needed.
  • Increase Apache and MySQL resources – Especially if you're using large datasets frequently.

Final Thoughts

Importing large SQL files in XAMPP’s localhost setup doesn’t have to be a hassle. By adjusting your php.ini settings, using the command line, or splitting the file, you can import even multi-gigabyte databases without a hitch.

Make sure to always back up your existing databases before importing large files.

Frequently Asked Questions (FAQ)

What is the maximum file size phpMyAdmin can import?

By default, phpMyAdmin in XAMPP limits uploads to 2MB–8MB, but you can increase this limit by editing the php.ini file.

 How do I know if the import was successful?

phpMyAdmin will show a success message after the import. If using the command line, you'll be returned to the prompt without error messages.

Can I use this method on live servers?

Yes, but for live production environments, it's recommended to use SSH and MySQL client tools for better security and performance.

Tags:

MySQL Php Sql XAMPP