Import big file in PHPmyadmin

[Mohammadreza]

hello
i wanna import big file in PhpMyAdmin, but show me this error:
#2006 - MySQL server has gone away
,
im change in my.cnf>

max_allowed_packet
and not solved this problem
please help me, how i can resolved it's


thank you

 

[UFHH01]

Hi Mohammadreza,

I think this KB - article will help to solve your issue:

How to increase max upload file size for PHPMyadmin? ( KB - article 120 683 )​

 

[Mohammadreza]

other setting is ok
but phpmyadmin show this error:
#2006 - MySQL server has gone away

 

[IgorG]

MySQL server has gone away

Increase value for option wait_timeout in file:

"%plesk_dir%"\Databases\MySQL\Data\my.ini

wait_timeout = 2147483

and restart mysql service.

 

[Mohammadreza]

Increase value for option wait_timeout in file:

"%plesk_dir%"\Databases\MySQL\Data\my.ini

wait_timeout = 2147483

and restart mysql service.

thanks for your help
my config is:
[MySQLD]
port=3306
basedir=C:\Program Files (x86)\Parallels\Plesk\Databases\MySQL51\
datadir=C:\Program Files (x86)\Parallels\Plesk\Databases\MySQL\Data
character-set-server=latin1
default-storage-engine=INNODB
read_buffer_size=1M
read_rnd_buffer_size=256K
sort_buffer_size=256K
innodb_additional_mem_pool_size=2M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1M
innodb_buffer_pool_size=16M
innodb_log_file_size=10M
innodb_thread_concurrency=8
max_connections=400
old_passwords=0
max_user_connections=30
thread_cache_size=4
thread_stack=196608
binlog_cache_size=32768
net_read_timeout=30
net_retry_count=10
net_write_timeout=30
thread_concurrency=10
open_files_limit=0
wait_timeout = 2147483
[client]
port=3306
wait_timeout = 2147483


again show me this error>>>

MySQL server has gone away

 

[IgorG]

Have you tried to increase wait_timeout value?

 

[Mohammadreza]

Have you tried to increase wait_timeout value?

yes,now i'm change to wait_timeout = 21222473234483

 

[Mohammadreza]

please help me

 

[IgorG]

Try to use solution from https://kb.odin.com/en/126312

 

[Mohammadreza]

Try to use solution from https://kb.odin.com/en/126312

not solved this problem

 

[scsa20]

Have you changed the mysql.connect_timeout value in your php.ini file (and restarted iis)?

 

[Mohammadreza]

Have you changed the mysql.connect_timeout value in your php.ini file (and restarted iis)?

yes, i'm attached my php.ini config
could you check all my config?

thank you very much