• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

Import big file in PHPmyadmin

Mohammadreza

Basic Pleskian
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
 
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
 
Have you changed the mysql.connect_timeout value in your php.ini file (and restarted iis)?
 
Back
Top