How do I increase the upload size for MySQL databases?

[AllanEspinoza]

Hi,

I need know how i can do it?, i have Windows Server 2012 STD 64bit with Plesk 11.3.30

I have changed the php.ini from C:\Program Files (x86)\Parallels\Plesk\Additional\PleskPHP5

To 150M but at my PHPMyAdmin says only 2M

What i can do?

Thanks,
Allan Espinoza

 

[IgorG]

Have you tried to change “upload_max_filesize” and “post_max_size” in admin's php.ini - %plesk_dir%\admin\php.ini ?

 

[AllanEspinoza]

Hi,

Yes look: "%plesk_dir%\admin\php.ini":

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

[Session]
session.save_path="C:\Program Files (x86)\Parallels\Plesk\admin\sessions"
[ioncube]
zend_extension="C:\Program Files (x86)\Parallels\Plesk\admin\modules\ioncube_loader_win_5.4.dll"

extension_dir="C:\Program Files (x86)\Parallels\Plesk\admin\modules"
max_execution_time=7200
log_errors=On
display_errors=Off
error_reporting=E_ALL & ~E_NOTICE & ~E_STRICT & ~E_DEPRECATED
error_log="C:\Program Files (x86)\Parallels\Plesk\admin\logs\php_error.log"
register_globals=Off
post_max_size=150M
auto_prepend_file= "auth.php"
include_path= "C:\Program Files (x86)\Parallels\Plesk\admin\plib;C:\Program Files (x86)\Parallels\Plesk\admin\externals"
fastcgi.impersonate=1
upload_tmp_dir= "C:\Program Files (x86)\Parallels\Plesk\PrivateTemp"
upload_max_filesize=150M
max_file_uploads=99999
max_input_vars=2000
cgi.force_redirect= 0
memory_limit=128M
swkey.product_name="plesk-win"
swkey.repository_dir="C:\Program Files (x86)\Parallels\Plesk\admin\repository\"
expose_php=Off
magic_quotes_gpc=Off
magic_quotes_runtime=Off
[opcache]
zend_extension="C:\Program Files (x86)\Parallels\Plesk\admin\modules\php_zendoptimizerplus.dll"
opcache.enable=1
opcache.memory_consumption=24
[php_curl]
extension=php_curl.dll
[php_imap]
extension=php_imap.dll
[php_mbstring]
extension.off=php_mbstring.dll
[php_openssl]
extension=php_openssl.dll
[php_soap]
extension.off=php_soap.dll
[php_sockets]
extension.off=php_sockets.dll
[php_sqlite3]
extension.off=php_sqlite3.dll
[php_xsl]
extension=php_xsl.dll
[psasem]
extension=psasem.dll
[php_plesk_util]
extension=php_plesk_util.dll
[php_psakey]
extension=php_psakey.dll
[php_gd2]
extension=php_gd2.dll
[php_intl]
extension=php_intl.dll
[php_aps_php]
extension=php_aps_php.dll
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Thanks,
Allan

 

[AllanEspinoza]

Hi,

I have restarted the server and now is working.

What files I modify:
C:\Program Files (x86)\Parallels\Plesk\Additional\PleskPHP5\php.ini
C:\Program Files (x86)\Parallels\Plesk\Additional\PleskPHP53\php.ini
C:\Program Files (x86)\Parallels\Plesk\Additional\PleskPHP54\php.ini
C:\Program Files (x86)\Parallels\Plesk\admin\php.ini

Lines:
upload_max_filesize=150M
post_max_size=150M

And rebooted the server, and now is working perfect! Says i can upload 150MB.

Thanks,
Allan