How to FIX Error File Upload Too Large on MySQL

So recently I have some problem with importing old database to MySQL database, but I get an error like this

1

So after searching some similar case on the internet, I can fix it by changing some text one php.ini file on Xampp.

First, go to Xampp path->php-php.ini

2

Then find these words, upload_max_file, and post_max_size, then change the value of those items, in my case I changed it from 10M to 1000M (1GB) because I need to import big size file (900MB).

3

4

After changing it you can restart your Apache n MySql server.5.PNG

Then walah, now it works, you can import or upload files up to 1000MB to your MySql!

6

#Bonus

If you getting an error like “Max execution Timeout” you can fix it by changing max_execution_timeout on php.ini. You can change it up to 3600 sec (1 hr).

8.PNG

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s