phpmyadmin - max upload file size is not changed

phpmyadmin - max upload file size is not changed after making changes in php.ini

If you have changed upload_max_filesize & post_max_size both parameters in php.ini but still it does not show changed maximum upload file size in import section.

You have restarted apache and you have done every thing what was suggested to you but still you are unable to see increased max upload file size.

 Now you are at correct place, just follow this.

Make a file .htaccess and put following text in it.

php_value upload_max_filesize 2048M
php_value post_max_size 2048M

where 2048M is your max upload file size, you can set whatever value you want.

Put this file into phpmyadmin directory.

Now restart apache and mysql and see import page of phpmyadmin. It will show the limit you have put in .htaccess file.

The path of phpmyadmin directory is /usr/share/phpmyadmin. If you are using LAMPP, the path of phpmyadmin directory is /opt/lampp/phpmyadmin

Invalid command 'RewriteEngine', perhaps misspelled or defined by a module not included in the server configuration Action 'configtest' failed.

Invalid command 'RewriteEngine', perhaps misspelled or defined by a module not included in the server configuration
Action 'configtest' failed. The Apache error log may have more information....fail!

Ubuntu - Apache2 error

If you are getting this error, it means you have used rewrite engine in your script but rewrite module is disabled right now.

To solve this error, just enable the rewrite module.

If you are using ubuntu - apache2, run this command in terminal

# sudo a2enmod rewrite
# service apache2 restart

Now try again.

If you are getting this error in RHEL/CentOS or in LAMPP, click here.

Enable and Disable Apache modules

Enable and Disable Apache modules in Ubuntu or CentOS

If you want to enable or disable any module in Apache, this post may be helpful for you.

Enable or Disable Apache module in RHEL or CentOS

In CentOS, we can see all Apache modules in the directory /etc/httpd/modules.
These modules are enabled in the file httpd.conf using following code. 
Here is an example of rewrite module.

LoadModule rewrite_module modules/mod_rewrite.so

If you want to disable this module, just comment the line and restart Apache, now it does not load the module.

If you want to enable it again, just uncomment the line and restart apache. 
Using this method we can enable and disable any module of Apache on CentOS.

Enable or Disable Apache module in LAMPP

The process in LAMPP in same as CentOS.

All modules are mentioned in the file /opt/lampp/etc/httpd.conf

If you want to disable any module, just comment the line and restart LAMPP, now it does not load the module.

If you want to enable it again, just uncomment the line and restart LAMPP. 
Using this method we can enable and disable any module of Apache in LAMPP.

Enable or Disable Apache module in Ubuntu

If you want to disable apache module in ubuntu-apache2, run following command

$ sudo a2dismod module_name

If you want to enable apache module in ubuntu-apache2, run following command

$ sudo a2enmod module_name

Suppose you want to disable or enable rewrite module, you should run :

$ sudo a2dismod rewrite
$ sudo a2enmod rewrite