Ubuntu Linux

Increase / Change MySQL Import Size in PHPMyAdmin

By default the size limit for importing MySQL database is 2 MB. To increase this limit you will have to change the php.ini file which can be located in C:\WAMP\BIN\Apache\php.ini if you are using WAMP.

Search

upload_max_filesize

upload_max_filesize represents the size of one file which you can import. Change  it’s value to the desired size, the default will be 2M where M represents MB

Search

post_max_size

Give it a larger value than upload_max_filesize

Search

memory_limit

and give it a larger value than both upload_max_filesize & post_max_size

Restart the WAMP server or restart it’s services and you are all set-up

Advertisements

About Suendri

Owner dan Founder Go Software Media sebelumnya bernama PHPBeGO Foundation

Discussion

No comments yet.

Tinggalkan Komentar

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

Follow Go Software Media Blog on WordPress.com

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 65 other followers

Archives

%d bloggers like this: