How to increase phpmyadmin import size

---

Increase phpMyAdmin Import Limit in XAMPP (Mac)

🛠 1. Open the php.ini file used by XAMPP

You can find it here:

/Applications/XAMPP/xamppfiles/etc/php.ini

Use a text editor to open it, for example:

sudo nano /Applications/XAMPP/xamppfiles/etc/php.ini

---

🔧 2. Modify These Values

Search (CTRL + W in nano) and update the following settings:

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

• You can increase the values as needed. For example, set them to 512M for large files.

---

🔄 3. Restart Apache via XAMPP

After saving php.ini:

• Open the XAMPP Control Panel.
• Stop and then Start Apache.

Or restart from terminal:

sudo /Applications/XAMPP/xamppfiles/bin/apachectl restart

---

🧪 4. Confirm the Change

• Open phpMyAdmin in your browser.
• Click on the Import tab.
• You should see something like: “Max: 128MiB”
  (This should reflect the new upload_max_filesize value.)

---

⚡ Bonus: For Huge Files

If you’re importing a large .sql file (>100MB), it’s faster to use the command line:

/Applications/XAMPP/xamppfiles/bin/mysql -u root -p your_database_name < /path/to/your-file.sql

---

Let me know if you’d like a script to automate this or if you’re using MAMP instead of XAMPP.