Import file too large

PROBLEM

The message “ERROR: File upload failed” usually means that you are trying to import a file which is too large. Although the plugin checks the file size against your “upload_max_size” settings there are other settings which might cause problems

EASY SOLUTIONS

The simplest solution is to compress your SQL file and upload it as a ZIP file. WP Data Access will recognize ZIP files, extract them and process the content. This will only work however if you have ZipArchive installed and files might of course still be to large.

BIT MORE WORK SOLUTIONS

You can solve this problem by changing to following parameters:

  • file_uploads
  • upload_max_filesize
  • post_max_size
  • max_execution_time
  • max_input_time

Navigate to “Manage Plugin” > “System Info” to check your settings!

There are three different ways to change these parameter, all described below. Replace the values for the parameters with the ones prefer.

1) Add the following lines of code to the function.php file of your theme:

@ini_set( 'file_uploads' , 'On' );
@ini_set( 'upload_max_size' , '64M' );
@ini_set( 'post_max_size', '64M');
@ini_set( 'max_execution_time', '300' );
@ini_set( 'max_input_time', '300' );

2) Add the following lines to your php.ini file:

file_uploads = On
upload_max_filesize = 64M
post_max_size = 64M
max_execution_time = 300
max_input_time = 300

Don’t forget to restart your web server!

3) Add the following lines to your .htaccess file:

php_value file_uploads On
php_value upload_max_filesize 64M
php_value post_max_size 64M
php_value max_execution_time 300
php_value max_input_time 300

NOTE

If you change the parameters to the ones mentioned above your users will be able to upload 64M files. That’s most probably not what you want. Don’t forget to decrease the parameter values after finishing your import.

Leave a Reply

Your email address will not be published. Required fields are marked *