PROBLEM

The message “ERROR: File upload failed” usually means that you are trying to import a file which is too large.

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.

WP Data Access also allows you to add multiple export (SQL) files to one ZIP.

BIT MORE WORK SOLUTIONS

This can be solved this problem by changing to following parameters:

  • upload_max_filesize
  • post_max_size
  • max_execution_time
  • max_input_time

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( '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:

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

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

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

BE AWARE!

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.

Peter Schulz

Written by 

Lecturer at HAN University of Applied Sciences

Leave a Reply

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