Import File Size Limit

PROBLEM

The error message "ERROR: File upload failed" typically indicates that you are trying to import a file that is too large. Although the plugin checks the file size against your upload_max_size setting, other server configurations can also cause this issue.

EASY SOLUTIONS

The simplest solution is to compress your SQL file and upload it as a ZIP file. WP Data Access recognizes ZIP files and will extract and process their contents. However, this requires the ZipArchive extension to be installed on your server, and the file may still be too large after compression.

SOLUTIONS REQUIRING MORE EFFORT

You can resolve this problem by adjusting the following PHP configuration parameters:

• file_uploads
• upload_max_filesize
• post_max_size
• max_execution_time
• max_input_time

📌 Navigate to Manage Plugin > System Info to check your current settings.

There are three methods to change these parameters, all described below. Replace the example values with your preferred settings.

1) Add the following lines to the functions.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

📌 Remember to restart your web server for the changes to take effect.

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

📌 NOTES

Changing the parameters to the values mentioned above will allow users to upload 64MB files, which is probably not desirable for long-term use. Remember to decrease these values after finishing your import.