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 the 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 = 300Don'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 300NOTES #
- 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.
