Increase Import File Size in phpMyAdmin
In this article i”ll Guide you how to increase Import File size in phpMyAdmin, If you are working on some big website like eCommerce, multi-vendor or some large database website you have to increase phpMyAdmin upload size. By default when you import file from SQL then the max import file size is 2 MB. if you want to upload above 2 MB file then you have to increase file size. for that, you have to follow some steps.
Top 150+ High PR DoFollow Backlinks Site List
Step 1 Find php.ini file
$ locate php.ini
/etc/php5/apache2/php.ini
/etc/php5/cli/php.ini
/usr/share/doc/php5-common/examples/php.ini-development
/usr/share/php5/php.ini-production
/usr/share/php5/php.ini-production-dist
/usr/share/php5/php.ini-production.cli
/var/www/php.ini
Step 2 Edit php.ini file
$ vim /etc/php5/apache2/php.ini
Step 3 Find upload max file size and update it as you required
post_max_size = 8M
upload_max_filesize = 2M
max_execution_time = 30
max_input_time = 60
memory_limit = 8M
after completion of the above step restart your apache to take effect.
Now the question is where to find php.ini File?, There are two ways, local Wamp Server and Live server.
Local Wamp Server
if you are using wamp then you should click on your wamp
icon
after that PHP section then select php.ini
Live Server
if you are using live server then this depends on your hosting, like if you are using shared hosting then you can’t find php.ini, alternate you can use .httacces file to add some code like that.
Update .htaccess file
php_value upload_max_filesize 128M
php_value post_max_size 128M
php_value memory_limit 256M
php_value max_execution_time 300
php_value max_input_time 300
Or if you are using WordPress then you can also increase memory by wp-config.php, simply put this code on that file
@ini_set( ‘upload_max_filesize’ , ‘128M’ );
@ini_set( ‘post_max_size’, ‘128M’);
@ini_set( ‘memory_limit’, ‘256M’ );
@ini_set( ‘max_execution_time’, ‘300’ );
@ini_set( ‘max_input_time’, ‘300’ );
Also Read:
How to make a festival wishing website script free
How to use WhatsApp without a
phone number
I hope above mention steps help you to Increase your PHP upload memory and now you are able to upload your heavy Files. If you like this article to then share it with the social platform you can also join our social community.
NOTE: We are in the process of modifying the file structure and configuration for many Bitnami stacks. On account of these changes, the file paths stated in this guide may change depending on whether your Bitnami stack uses native Linux system packages (Approach A), or if it is a self-contained installation (Approach B). To identify your Bitnami installation type and what approach to follow, run the command below: The output of the command
indicates which approach (A or B) is used by the installation, and will allow you to identify the paths, configuration and commands to use in this guide. Refer to the FAQ for more information on these changes. To increase the allowed size for uploads, follow the steps below: Modify the following options in the php.ini file:Approach A: Bitnami installations
using system packages
Approach B: Self-contained Bitnami installations
Modify the following options in the /opt/bitnami/apps/phpmyadmin/conf/httpd-app.conf file:
<IfModule php7_module> php_value upload_max_filesize 80M php_value post_max_size 80M </IfModule>If you are using PHP-FPM, modify the settings in the /opt/bitnami/apps/phpmyadmin/conf/php-fpm/php-settings.conf file
php_value[upload_max_filesize]=80M php_value[post_max_size]=80MBefore running the commands shown on this page, you should load the Bitnami stack environment by executing the installdir/use_APPNAME script (Linux and MacOS) or by clicking the shortcut in the Start Menu under “Start -> Bitnami APPNAME Stack -> Application console” (Windows). On OS X VMs, the installation directory is /opt/bitnami and OS X VM users can click the “Open Terminal” button to run commands. Learn more about the
Bitnami stack environment and about OS X VMs. NOTE: The Approach A sections referred to below do not apply to Bitnami native installers. Users of Bitnami native installers should refer only to the Approach B sections. To increase the allowed size for uploads, follow the steps
below: Modify the following options in the php.ini file: Modify the following options in the installdir/apps/phpmyadmin/conf/httpd-app.conf file: If you are using PHP-FPM, modify the settings in the
installdir/apps/phpmyadmin/conf/php-fpm/php-settings.conf fileApproach A: Bitnami installations using system packages
Approach B: Self-contained Bitnami installations