Can't increase phpmyadmin max upload/import file size

[Charalampidis_Alexandros]

I'm running Plesk 12. I install it today, using the ISO which parallels provides, which includes centos 6.5 and preinstalled Plesk 12 in my vps. Then I logged in plesk, and I did everything it wants. Then I upgraded my php, to php 5.4.36 according to the manual that Paralells provides, and then I tried to increase the max upload file size for phpmyadmin. I have edited my /usr/local/psa/admin/conf/php.ini file and tried to restart using with 3 different ways using terminal:

1st: service sw-cp-server restart
2st: /etc/init.d/psa stop
/etc/init.d/psa start
3st: reboot (which rebooted all the vps)

My php.ini file is:

short_open_tag = On
y2k_compliance = Off
output_buffering = Off
max_execution_time = 600
max_input_time = 600
memory_limit = 256M
max_file_uploads = 99999
max_input_vars = 2000

; error_reporting = E_ALL & ~E_NOTICE & ~E_STRICT & ~E_DEPRECATED
error_reporting = E_ALL & ~E_STRICT & ~E_DEPRECATED
log_errors = On
display_errors = Off
warn_plus_overloading = Off
expose_php = Off

variables_order = "ECGPS"
register_argc_argv = On
post_max_size = 5000M
magic_quotes_gpc = Off
magic_quotes_runtime = Off

include_path = "/usr/local/psa/admin/plib:/usr/local/psa/admin/externals"
upload_tmp_dir = "/tmp"
upload_max_filesize = 5000M

opcache.enabled=1
opcache.memory_consumption=100
opcache.fast_shutdown=1

swkey.repository_dir = "/etc/sw/keys"

psasem.semfile = "/usr/local/psa/var/psasem.sem"

zend_extension = "/usr/lib64/php/modules/sw-engine/ioncube_loader_lin_5.5.so"
zend_extension = "/usr/lib64/php/modules/sw-engine/opcache.so"

However, when I'm trying to import a 31mb sql file, I always get that error, and only some of my tables are being imported:

#1153 - Got a packet bigger than 'max_allowed_packet' bytes

Any ideas?

 

[Charalampidis_Alexandros]

Solved after hours.

 

[JCV]

Hi Charalampidis

Can you tell how solved it?

Thanks.

 

[magnozo]

Solved after hours.

Nice to hear that, but you should PROBABLY write the answer?