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

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 63 other followers

Archives

%d bloggers like this: