problem import mysql backup in Plesk

[Mortezaa]

Hello
i Have Plesk Windows version,
when i want import my backup mysql, i see below error:

Error: dbbackup failed: Unable to restore database 'admin_IranDnn'
ERROR 2006 (HY000) at line 1: MySQL server has gone away

and format of backup is file.bak , is correct?

and my my.ini value is below:

[client]
port=8306
[PleskSQLServer]
port=8306
basedir=C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL
datadir=C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL\\Data
character-set-server=latin1
default-storage-engine=INNODB
query_cache_size=8M
table_cache=32
tmp_table_size=7M
thread_cache=32
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=2M
key_buffer_size=2M
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=99999999999999
key_buffer=8M
max_allowed_packet=10240M
sort_buffer=256K
net_buffer_length=4K
old_passwords=0
tmpdir=C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL\\Data
connect_timeout=9000000

how i can resolve?

Thanks.

خرید هاست ، دامنه و سرور مجازی

 

[Mortezaa]

Hello
i Have Plesk Windows version,
when i want import my backup mysql, i see below error:



and format of backup is file.bak , is correct?

and my my.ini value is below:



how i can resolve?

Thanks.

any update??

http://www.almashosting.com/

 

[IgorG]

Just increase wait_timeout value in "%plesk_dir%"\Databases\MySQL\Data\my.ini

 

[Mortezaa]

Just increase wait_timeout value in "%plesk_dir%"\Databases\MySQL\Data\my.ini

now my wait_timeout is 9999999, but still i have this problem,

below is my my.ini:

=====
[client]
port=8306
[PleskSQLServer]
port=8306
basedir=C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL
datadir=C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL\\Data
character-set-server=latin1
default-storage-engine=INNODB
query_cache_size=8M
table_cache=32
tmp_table_size=7M
thread_cache=32
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=2M
key_buffer_size=2M
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=99999999999999
key_buffer=8M
max_allowed_packet=10240M
sort_buffer=256K
net_buffer_length=4K
old_passwords=0
tmpdir=C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL\\Data
connect_timeout=9000000
wait_timeout=999999999999
===============================================

i can send you my backup link and password server in PrivateMessage, then you check for me?

really i have problem.....

Thanks.

 

[Mortezaa]

now i see my backup is MSsql,
how i can install MSsql instead mysql in My plesk 11 windows?

http://www.almashosting.com/

Thanks.

 

[IgorG]

now i see my backup is MSsql,
how i can install MSsql instead mysql in My plesk 11 windows?

Thanks.

What do you mean "instead" exactly?

 

[InderS]

Just go to updates and upgrades >> add remove components >> select mssql2008 or 2012 and select install and click on continue.

 

[Mortezaa]

Thank, resolved.


خرید هاست ، دامنه و سرور مجازی