how to import more than 2 mb to 1024 mb data base file in phpmyadmin

how to import more than 2 mb to 1024 mb data base file in phpmyadmin

I tried and i got the error message saying the size is greater. I tried with php.ini and increased the size of upload

===================

change upload_max_filesize 2M  to 1024M

==================

; Maximum allowed size for uploaded files.
; http://php.net/upload-max-filesize
  upload_max_filesize = 300M

Find:
===========================

post_max_size = 8M
upload_max_filesize = 2M
max_execution_time = 30
max_input_time = 60
memory_limit = 8M

==============================

Change to:

post_max_size = 1024M
upload_max_filesize = 1024M
max_execution_time = 5000
max_input_time = 5000
memory_limit = 1000M 

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 )

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